Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.zone AS zone_2,
  t0.completion_percent AS completion_percent_3,
  t0.places_count AS places_count_4,
  t0.avec_horaires AS avec_horaires_5,
  t0.avec_adresse AS avec_adresse_6,
  t0.avec_site AS avec_site_7,
  t0.avec_accessibilite AS avec_accessibilite_8,
  t0.avec_note AS avec_note_9,
  t0.name AS name_10,
  t0.population AS population_11,
  t0.siren AS siren_12,
  t0.code_epci AS code_epci_13,
  t0.codes_postaux AS codes_postaux_14,
  t0.date_created AS date_created_15,
  t0.date_modified AS date_modified_16,
  t0.avec_siret AS avec_siret_17,
  t0.avec_name AS avec_name_18,
  t0.avec_email AS avec_email_19,
  t0.osm_data_date_min AS osm_data_date_min_20,
  t0.osm_data_date_avg AS osm_data_date_avg_21,
  t0.osm_data_date_max AS osm_data_date_max_22,
  t0.budget_annuel AS budget_annuel_23,
  t0.lat AS lat_24,
  t0.lon AS lon_25,
  t0.date_labourage_requested AS date_labourage_requested_26,
  t0.date_labourage_done AS date_labourage_done_27,
  t0.kind AS kind_28
FROM
  stats t0
WHERE
  t0.zone = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.avec_email AS avec_email_19, t0.osm_data_date_min AS osm_data_date_min_20, t0.osm_data_date_avg AS osm_data_date_avg_21, t0.osm_data_date_max AS osm_data_date_max_22, t0.budget_annuel AS budget_annuel_23, t0.lat AS lat_24, t0.lon AS lon_25, t0.date_labourage_requested AS date_labourage_requested_26, t0.date_labourage_done AS date_labourage_done_27, t0.kind AS kind_28 FROM stats t0 WHERE t0.zone = '17300' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.measure AS measure_3,
  t0.date AS date_4,
  t0.stats_id AS stats_id_5
FROM
  city_follow_up t0
WHERE
  t0.stats_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = 27565;

SELECT
  t0.id AS id_1,
  t0.uuid_for_url AS uuid_for_url_2,
  t0.osm_kind AS osm_kind_3,
  t0.email AS email_4,
  t0.opted_out AS opted_out_5,
  t0.dead AS dead_6,
  t0.note AS note_7,
  t0.modified_date AS modified_date_8,
  t0.zip_code AS zip_code_9,
  t0.asked_humains_support AS asked_humains_support_10,
  t0.last_contact_attempt_date AS last_contact_attempt_date_11,
  t0.osm_id AS osm_id_12,
  t0.name AS name_13,
  t0.has_opening_hours AS has_opening_hours_14,
  t0.has_address AS has_address_15,
  t0.has_website AS has_website_16,
  t0.has_wheelchair AS has_wheelchair_17,
  t0.has_note AS has_note_18,
  t0.main_tag AS main_tag_19,
  t0.note_content AS note_content_20,
  t0.displayed_date AS displayed_date_21,
  t0.lat AS lat_22,
  t0.lon AS lon_23,
  t0.street AS street_24,
  t0.housenumber AS housenumber_25,
  t0.siret AS siret_26,
  t0.habitants AS habitants_27,
  t0.osm_data_date AS osm_data_date_28,
  t0.osm_version AS osm_version_29,
  t0.osm_user AS osm_user_30,
  t0.osm_uid AS osm_uid_31,
  t0.osm_changeset AS osm_changeset_32,
  t0.email_content AS email_content_33,
  t0.place_count AS place_count_34,
  t0.stats_id AS stats_id_35
FROM
  place t0
WHERE
  t0.stats_id = ?

SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.stats_id = 27565;

SELECT
  1

SELECT 1;

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = 'public'
  AND table_name = 'osm_object_meta'

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta';

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = ?
  AND table_name = ?

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta';

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = ?
  AND table_name = ?

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_history';

SELECT
  COUNT(*)
FROM
  osm_object_meta
WHERE
  osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags -> 'admin_level') = '8'
  AND (tags -> 'boundary') = 'administrative'
  AND (tags -> 'ref:INSEE') IS NOT NULL

SELECT COUNT(*) FROM osm_object_meta WHERE osm_type = 'relation'
                  AND geom IS NOT NULL
                  AND (tags->'admin_level') = '8'
                  AND (tags->'boundary') = 'administrative'
                  AND (tags->'ref:INSEE') IS NOT NULL;

INSERT INTO osm_object_meta (
  osm_type, osm_id, geom, tags, version,
  osm_timestamp, changeset, osm_user,
  uid
)
SELECT
  'relation',
  latest.osm_id,
  latest.geom,
  latest.tags,
  latest.version,
  to_char(
    latest.valid_from AT TIME ZONE 'UTC',
    'YYYY-MM-DD"T"HH24:MI:SS"Z"'
  ),
  latest.changeset,
  latest.osm_user,
  latest.uid
FROM
  (
    SELECT
      DISTINCT ON (h.osm_id) h.osm_id,
      h.geom,
      h.tags,
      h.version,
      h.valid_from,
      h.changeset,
      h.osm_user,
      h.uid
    FROM
      osm_object_history h
    WHERE
      h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags -> 'boundary') = 'administrative'
      AND (h.tags -> 'admin_level') = '8'
      AND (h.tags -> 'ref:INSEE') IS NOT NULL
    ORDER BY
      h.osm_id,
      h.version DESC,
      h.valid_from DESC
  ) AS latest
WHERE
  NOT EXISTS (
    SELECT
      1
    FROM
      osm_object_meta m
    WHERE
      m.osm_type = 'relation'
      AND m.osm_id = latest.osm_id
  )

INSERT INTO osm_object_meta (
    osm_type, osm_id, geom, tags, version, osm_timestamp, changeset, osm_user, uid
)
SELECT
    'relation',
    latest.osm_id,
    latest.geom,
    latest.tags,
    latest.version,
    to_char(latest.valid_from AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"'),
    latest.changeset,
    latest.osm_user,
    latest.uid
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.osm_id,
        h.geom,
        h.tags,
        h.version,
        h.valid_from,
        h.changeset,
        h.osm_user,
        h.uid
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'boundary') = 'administrative'
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'ref:INSEE') IS NOT NULL
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) AS latest
WHERE NOT EXISTS (
    SELECT 1 FROM osm_object_meta m
    WHERE m.osm_type = 'relation' AND m.osm_id = latest.osm_id
);

SELECT
  ST_AsText(
    ST_Multi(geom)
  ) AS wkt
FROM
  osm_object_meta m
WHERE
  osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags -> 'ref:INSEE') = ?
  AND (tags -> 'admin_level') = '8'
  AND (tags -> 'boundary') = 'administrative'
ORDER BY
  ST_Area(geom :: geography) DESC NULLS LAST
LIMIT
  1

SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM osm_object_meta m
WHERE osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags->'ref'17300'') = ?
  AND (tags->'admin_level') = '8'
  AND (tags->'boundary') = 'administrative'
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1;

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = ?
  AND table_name = ?

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_history';

SELECT
  ST_AsText(
    ST_Multi(geom)
  ) AS wkt
FROM
  (
    SELECT
      DISTINCT ON (h.osm_id) h.geom
    FROM
      osm_object_history h
    WHERE
      h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags -> 'ref:INSEE') = ?
      AND (h.tags -> 'admin_level') = '8'
      AND (h.tags -> 'boundary') = 'administrative'
    ORDER BY
      h.osm_id,
      h.version DESC,
      h.valid_from DESC
  ) latest
ORDER BY
  ST_Area(geom :: geography) DESC NULLS LAST
LIMIT
  1

SELECT ST_AsText(ST_Multi(geom)) AS wkt
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.geom
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'ref'17300'') = ?
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'boundary') = 'administrative'
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) latest
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1;

CREATE TABLE IF NOT EXISTS zone_polygon (
  insee_code TEXT PRIMARY KEY,
  geom geometry(MultiPolygon, 4326) NOT NULL,
  source TEXT NOT NULL,
  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
)

CREATE TABLE IF NOT EXISTS zone_polygon (
                    insee_code TEXT PRIMARY KEY,
                    geom geometry(MultiPolygon, 4326) NOT NULL,
                    source TEXT NOT NULL,
                    updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
                );

CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)

CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom);

SELECT
  ST_AsText(
    ST_Multi(geom)
  )
FROM
  zone_polygon
WHERE
  insee_code = ?

SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = '17300';

SELECT
  osm_type,
  osm_id :: text AS osm_id,
  ST_Y(
    ST_Centroid(geom)
  ) AS lat,
  ST_X(
    ST_Centroid(geom)
  ) AS lon,
  tags :: jsonb AS tags_json,
  version,
  osm_timestamp,
  changeset,
  osm_user,
  uid :: bigint AS uid
FROM
  osm_object_meta m
WHERE
  geom IS NOT NULL
  AND ST_Intersects(
    m.geom,
    ST_GeomFromText(?, 4326)
  )
  AND akeys(tags) && ARRAY[ 'amenity',
  'shop',
  'office',
  'craft',
  'leisure',
  'healthcare',
  'emergency',
  'man_made',
  'power',
  'highway',
  'railway',
  'public_transport',
  'landuse',
  'historic',
  'barrier',
  'tourism',
  'sport',
  'place',
  'waterway',
  'natural',
  'geological',
  'route',
  'military',
  'traffic_sign',
  'traffic_calming',
  'seamark',
  'route_master',
  'water',
  'airway',
  'aerialway',
  'building' ] :: text[]

SELECT osm_type, osm_id::text AS osm_id, ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,
            tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid
            FROM osm_object_meta m
            WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText('MULTIPOLYGON(((-1.138306 46.179658,-1.138163 46.179624,-1.137789 46.179394,-1.137397 46.179121,-1.137089 46.1788,-1.136838 46.178468,-1.136598 46.178231,-1.13626 46.177979,-1.13567 46.177301,-1.135445 46.177155,-1.13496 46.17694,-1.134692 46.176758,-1.134512 46.176751,-1.134395 46.176617,-1.134563 46.176501,-1.134431 46.176297,-1.133945 46.175925,-1.13366 46.175744,-1.133337 46.17561,-1.131604 46.175165,-1.131113 46.175026,-1.130006 46.174691,-1.128598 46.174164,-1.12724 46.173752,-1.126927 46.173636,-1.12653 46.173456,-1.126242 46.173301,-1.125414 46.172825,-1.123941 46.172069,-1.123774 46.171945,-1.123229 46.171413,-1.122952 46.171189,-1.122476 46.170916,-1.121647 46.170395,-1.12111 46.170142,-1.120899 46.17014,-1.120691 46.169954,-1.120225 46.16983,-1.119414 46.169595,-1.118569 46.169403,-1.117659 46.169235,-1.116499 46.168938,-1.115816 46.168768,-1.115606 46.168702,-1.115283 46.168443,-1.115458 46.168056,-1.115641 46.167856,-1.115803 46.167635,-1.116243 46.167085,-1.116701 46.166687,-1.117455 46.166114,-1.117882 46.165847,-1.118269 46.165653,-1.118729 46.16551,-1.120144 46.165167,-1.1209 46.165017,-1.121651 46.1649,-1.121832 46.164885,-1.121994 46.164226,-1.121389 46.164271,-1.120941 46.163697,-1.121073 46.163667,-1.120935 46.163231,-1.121008 46.16297,-1.121305 46.162762,-1.121687 46.162565,-1.122069 46.162415,-1.122031 46.16208,-1.12192 46.161792,-1.121843 46.161688,-1.121612 46.161097,-1.121352 46.16059,-1.121029 46.160093,-1.120657 46.159618,-1.120177 46.159097,-1.119709 46.158669,-1.119441 46.158455,-1.116136 46.155874,-1.115626 46.15543,-1.115173 46.154977,-1.114754 46.154506,-1.114443 46.154116,-1.11393 46.153342,-1.111069 46.148923,-1.111311 46.14888,-1.111837 46.148747,-1.112365 46.148586,-1.113487 46.148296,-1.115796 46.147862,-1.11724 46.147617,-1.118754 46.147338,-1.119564 46.147244,-1.120444 46.147212,-1.121119 46.147261,-1.122138 46.147456,-1.12261 46.147488,-1.123077 46.14773,-1.123806 46.147945,-1.12411 46.148067,-1.124335 46.148007,-1.12464 46.148064,-1.125588 46.148296,-1.12607 46.148548,-1.126423 46.148763,-1.127289 46.149142,-1.12779 46.149309,-1.128265 46.149443,-1.128758 46.149629,-1.129109 46.14972,-1.129398 46.149695,-1.129585 46.149594,-1.129887 46.149742,-1.130083 46.149744,-1.130191 46.149642,-1.1303 46.149384,-1.130387 46.149286,-1.130845 46.148977,-1.13118 46.148958,-1.131203 46.148704,-1.131152 46.148559,-1.130912 46.14828,-1.130911 46.148159,-1.130993 46.148046,-1.131427 46.147897,-1.131609 46.14773,-1.131812 46.147282,-1.131817 46.147002,-1.132067 46.146783,-1.132123 46.146658,-1.132108 46.146279,-1.132144 46.145807,-1.132716 46.145778,-1.133333 46.14565,-1.134064 46.145538,-1.134899 46.145368,-1.135197 46.145288,-1.135568 46.145125,-1.135787 46.144966,-1.136036 46.144572,-1.136075 46.144407,-1.13605 46.14418,-1.135977 46.143909,-1.135797 46.143845,-1.135391 46.143535,-1.134257 46.142761,-1.134011 46.142624,-1.133777 46.142554,-1.133628 46.142464,-1.133549 46.142329,-1.133453 46.142023,-1.133244 46.141487,-1.133621 46.141516,-1.134297 46.141711,-1.135066 46.142033,-1.135422 46.142129,-1.135678 46.142149,-1.136042 46.142119,-1.136326 46.142018,-1.136602 46.141866,-1.136941 46.141537,-1.137264 46.141363,-1.137556 46.141433,-1.13776 46.141391,-1.137935 46.141188,-1.137849 46.141156,-1.138187 46.139996,-1.138454 46.138663,-1.138501 46.138545,-1.138682 46.138483,-1.138862 46.138498,-1.139413 46.138661,-1.141154 46.139008,-1.143053 46.13934,-1.143591 46.139454,-1.14423 46.139611,-1.145067 46.139846,-1.145476 46.139938,-1.145793 46.139976,-1.146705 46.139999,-1.147051 46.140042,-1.147216 46.139717,-1.147502 46.139096,-1.147889 46.1381,-1.147536 46.137857,-1.147466 46.137717,-1.14748 46.137576,-1.147658 46.136846,-1.147951 46.135811,-1.14771 46.135634,-1.147973 46.135168,-1.148811 46.13378,-1.149016 46.133422,-1.149085 46.133217,-1.149172 46.133138,-1.149446 46.133313,-1.149731 46.133388,-1.149865 46.133501,-1.150252 46.133757,-1.150989 46.134158,-1.151283 46.134459,-1.15145 46.134777,-1.151666 46.135094,-1.152591 46.136124,-1.153032 46.136662,-1.153517 46.137065,-1.153908 46.137266,-1.154213 46.137348,-1.154341 46.137413,-1.154732 46.137526,-1.154876 46.13754,-1.155402 46.137661,-1.156126 46.13773,-1.156808 46.137741,-1.157626 46.137715,-1.158517 46.137779,-1.158797 46.13777,-1.15928 46.13772,-1.160009 46.137619,-1.16057 46.137518,-1.160944 46.137338,-1.161083 46.137301,-1.161509 46.137091,-1.161918 46.137183,-1.162515 46.137359,-1.163275 46.137629,-1.163932 46.137912,-1.164216 46.138007,-1.164688 46.138133,-1.165306 46.138243,-1.165527 46.138251,-1.16613 46.138396,-1.166567 46.138452,-1.16693 46.138441,-1.166992 46.138411,-1.167434 46.138413,-1.167743 46.13839,-1.168838 46.138458,-1.16921 46.138405,-1.170055 46.138422,-1.170513 46.13848,-1.170645 46.138514,-1.170941 46.13848,-1.171433 46.138475,-1.171852 46.138346,-1.172212 46.138312,-1.172579 46.138354,-1.172882 46.138418,-1.173538 46.138514,-1.1739 46.138501,-1.174195 46.138459,-1.174288 46.138565,-1.174102 46.138762,-1.173914 46.13885,-1.173484 46.139001,-1.173244 46.139154,-1.172983 46.139237,-1.172811 46.139361,-1.172342 46.139593,-1.171913 46.139726,-1.171808 46.139851,-1.171646 46.140214,-1.171561 46.140521,-1.171386 46.140558,-1.171478 46.140684,-1.171483 46.140893,-1.171532 46.140947,-1.171633 46.141558,-1.171694 46.141725,-1.171909 46.14183,-1.171672 46.14195,-1.171703 46.142123,-1.171639 46.142233,-1.171888 46.142779,-1.171965 46.142884,-1.172128 46.143234,-1.172283 46.143633,-1.172541 46.144202,-1.17271 46.14463,-1.172822 46.144802,-1.172959 46.145211,-1.173013 46.145504,-1.17294 46.145978,-1.172869 46.14617,-1.17264 46.146522,-1.172275 46.146854,-1.172017 46.147031,-1.171474 46.147357,-1.171145 46.147486,-1.1705 46.147662,-1.17 46.14791,-1.169824 46.148028,-1.169588 46.148053,-1.169562 46.147949,-1.169743 46.147873,-1.169851 46.147898,-1.170369 46.14766,-1.170849 46.147475,-1.171598 46.14714,-1.171782 46.147044,-1.172125 46.146798,-1.172328 46.146587,-1.172393 46.146416,-1.172153 46.145969,-1.170358 46.141923,-1.170331 46.141936,-1.167264 46.142595,-1.167136 46.142935,-1.16727 46.143266,-1.167141 46.143779,-1.167739 46.144127,-1.167687 46.144278,-1.167831 46.144303,-1.167731 46.144651,-1.167574 46.144627,-1.167491 46.144818,-1.16729 46.144825,-1.166784 46.144499,-1.166249 46.144902,-1.166169 46.144985,-1.165187 46.144355,-1.165182 46.144333,-1.165622 46.14296,-1.165532 46.142908,-1.165609 46.14268,-1.166294 46.142534,-1.1666 46.142283,-1.166722 46.141918,-1.166558 46.141575,-1.166149 46.141314,-1.165993 46.141301,-1.164881 46.14153,-1.164065 46.141711,-1.16391 46.14177,-1.163694 46.141942,-1.163619 46.142063,-1.163503 46.142472,-1.163118 46.143593,-1.162677 46.143797,-1.162626 46.143795,-1.161761 46.146379,-1.162151 46.146461,-1.162129 46.146541,-1.16187 46.146501,-1.161803 46.146645,-1.161671 46.14663,-1.161358 46.14758,-1.161186 46.148073,-1.161623 46.148336,-1.162146 46.148224,-1.162096 46.148145,-1.162357 46.148062,-1.162469 46.148134,-1.162619 46.148107,-1.166907 46.147187,-1.167068 46.147084,-1.167235 46.147071,-1.167446 46.147208,-1.167431 46.147343,-1.167259 46.147462,-1.166826 46.147544,-1.163176 46.148334,-1.160953 46.148787,-1.160431 46.150355,-1.159843 46.152215,-1.159897 46.152236,-1.155746 46.153985,-1.155818 46.154123,-1.155651 46.154136,-1.15548 46.153921,-1.155459 46.153801,-1.15319 46.154149,-1.152748 46.154403,-1.152311 46.154419,-1.152225 46.153763,-1.152205 46.150832,-1.152026 46.150835,-1.152034 46.15,-1.151846 46.150024,-1.151839 46.150833,-1.151725 46.150833,-1.151712 46.150472,-1.151259 46.150475,-1.151275 46.152945,-1.151199 46.152956,-1.151204 46.154102,-1.151151 46.154124,-1.149841 46.154126,-1.149844 46.15485,-1.152355 46.15477,-1.152331 46.154576,-1.152783 46.154544,-1.153299 46.154751,-1.153586 46.154753,-1.153659 46.154859,-1.153368 46.155078,-1.153252 46.155244,-1.153169 46.155481,-1.153153 46.155734,-1.153341 46.15568,-1.153525 46.155713,-1.153474 46.155836,-1.153311 46.155936,-1.152984 46.155878,-1.152755 46.15592,-1.152593 46.156016,-1.15235 46.156251,-1.151888 46.156314,-1.151624 46.15632,-1.151624 46.155958,-1.150527 46.15595,-1.149862 46.155963,-1.149847 46.156054,-1.149857 46.156702,-1.150098 46.157015,-1.151329 46.156988,-1.151629 46.156701,-1.151608 46.156454,-1.151891 46.156434,-1.152083 46.156485,-1.151993 46.156632,-1.150804 46.157852,-1.150811 46.157921,-1.151019 46.158038,-1.151386 46.158078,-1.152682 46.158059,-1.152822 46.158012,-1.153104 46.157636,-1.153043 46.157613,-1.153201 46.15741,-1.153271 46.157425,-1.153532 46.157087,-1.153462 46.157057,-1.153663 46.156807,-1.153766 46.156788,-1.154013 46.156446,-1.153957 46.156413,-1.154142 46.156176,-1.154138 46.156086,-1.154029 46.155955,-1.153791 46.155891,-1.154513 46.155306,-1.155095 46.15533,-1.155801 46.155053,-1.15618 46.155258,-1.157378 46.154768,-1.157306 46.154437,-1.157539 46.154362,-1.157682 46.154368,-1.157896 46.154524,-1.158575 46.155333,-1.158817 46.155223,-1.158967 46.155206,-1.159029 46.155084,-1.158914 46.154958,-1.159024 46.154834,-1.159121 46.154825,-1.160246 46.154126,-1.16028 46.154148,-1.159878 46.154415,-1.160151 46.154565,-1.160417 46.15486,-1.160727 46.155094,-1.160882 46.155296,-1.160886 46.15543,-1.16123 46.155465,-1.161681 46.155669,-1.163247 46.155711,-1.164037 46.155597,-1.164294 46.155471,-1.164748 46.155487,-1.165096 46.155453,-1.165432 46.155356,-1.16674 46.155096,-1.167513 46.154986,-1.168521 46.15477,-1.169404 46.154602,-1.169837 46.154502,-1.170651 46.154285,-1.172003 46.15379,-1.172031 46.153661,-1.17278 46.153448,-1.172714 46.153132,-1.172834 46.153135,-1.173381 46.152983,-1.173463 46.153037,-1.174241 46.152915,-1.174446 46.15283,-1.174807 46.1528,-1.175029 46.152821,-1.175196 46.152796,-1.175371 46.152884,-1.176329 46.153192,-1.176915 46.153393,-1.17752 46.15349,-1.178167 46.153469,-1.178308 46.153451,-1.179577 46.153422,-1.179771 46.153402,-1.180149 46.15343,-1.180597 46.153526,-1.181031 46.153594,-1.181778 46.153689,-1.18226 46.153729,-1.182665 46.153741,-1.183385 46.153688,-1.183795 46.15362,-1.184428 46.153578,-1.184549 46.153532,-1.185128 46.15357,-1.185509 46.153632,-1.186279 46.153687,-1.186655 46.153681,-1.186986 46.153603,-1.187437 46.153398,-1.187885 46.15316,-1.18801 46.153047,-1.188056 46.152883,-1.18798 46.152615,-1.1879 46.152493,-1.187667 46.152374,-1.187722 46.152264,-1.187428 46.152132,-1.187623 46.151916,-1.187119 46.151691,-1.18648 46.151423,-1.186448 46.151314,-1.186979 46.151477,-1.18743 46.151428,-1.187821 46.151287,-1.188379 46.151113,-1.189636 46.150753,-1.190307 46.150537,-1.190556 46.150399,-1.19106 46.150371,-1.191252 46.150342,-1.191844 46.150191,-1.192345 46.149955,-1.192587 46.149895,-1.192887 46.149753,-1.193046 46.149637,-1.193717 46.149371,-1.194012 46.149307,-1.194402 46.149162,-1.195088 46.149062,-1.195455 46.148976,-1.196114 46.148737,-1.196688 46.148556,-1.197107 46.148397,-1.197324 46.148355,-1.197722 46.148183,-1.197929 46.148061,-1.198194 46.147824,-1.198373 46.147699,-1.198873 46.147521,-1.199394 46.147374,-1.199625 46.147341,-1.200432 46.147343,-1.201004 46.147391,-1.201765 46.147309,-1.202122 46.147207,-1.20255 46.147046,-1.202946 46.146806,-1.203336 46.146678,-1.20426 46.146443,-1.204921 46.146249,-1.205296 46.146186,-1.205847 46.146145,-1.206239 46.146148,-1.206304 46.146093,-1.206777 46.146048,-1.20727 46.146091,-1.207717 46.146168,-1.208253 46.146353,-1.208591 46.146562,-1.208973 46.146903,-1.209154 46.146999,-1.209224 46.147092,-1.209406 46.147158,-1.209553 46.147351,-1.209845 46.147565,-1.210332 46.147971,-1.210661 46.148181,-1.210844 46.148234,-1.212163 46.147698,-1.213342 46.147189,-1.213515 46.14714,-1.213842 46.147145,-1.214115 46.147205,-1.214776 46.147408,-1.216029 46.147811,-1.216126 46.147819,-1.216982 46.147654,-1.217588 46.147572,-1.218214 46.147511,-1.21963 46.147446,-1.220711 46.147415,-1.221362 46.147426,-1.22495 46.147569,-1.226523 46.147643,-1.226852 46.147763,-1.22731 46.148116,-1.227388 46.148221,-1.22727 46.1483,-1.226673 46.147821,-1.226398 46.147757,-1.221072 46.147536,-1.22095 46.147625,-1.220962 46.1479,-1.221107 46.147899,-1.221112 46.148028,-1.221652 46.148018,-1.221655 46.148087,-1.221115 46.148098,-1.221124 46.148277,-1.221465 46.148269,-1.22147 46.148324,-1.221124 46.148334,-1.221132 46.148492,-1.221476 46.148486,-1.221476 46.148542,-1.221131 46.148549,-1.221139 46.14871,-1.221486 46.148706,-1.221488 46.148759,-1.221143 46.148766,-1.221 46.148824,-1.221023 46.149057,-1.221069 46.149123,-1.221534 46.149275,-1.221704 46.149063,-1.222523 46.148815,-1.222578 46.148897,-1.221768 46.149145,-1.221657 46.149309,-1.222278 46.149507,-1.222401 46.149329,-1.222545 46.149328,-1.223625 46.148997,-1.223678 46.149079,-1.222607 46.14941,-1.222494 46.149576,-1.223075 46.149758,-1.223194 46.149577,-1.22334 46.149575,-1.22442 46.149249,-1.224473 46.149329,-1.223394 46.149661,-1.223283 46.149823,-1.223547 46.150225,-1.223539 46.150321,-1.223805 46.150745,-1.223963 46.150717,-1.224107 46.150984,-1.224278 46.150924,-1.226725 46.150167,-1.226729 46.150154,-1.226033 46.149054,-1.225887 46.14901,-1.225883 46.148905,-1.226052 46.148859,-1.226142 46.14892,-1.226954 46.150173,-1.227193 46.150246,-1.228132 46.149973,-1.228491 46.149905,-1.228781 46.149936,-1.229009 46.150039,-1.229929 46.150548,-1.230343 46.150812,-1.230747 46.151094,-1.231436 46.151638,-1.231796 46.151969,-1.232147 46.152327,-1.232693 46.152971,-1.233008 46.1534,-1.233221 46.153784,-1.233482 46.154308,-1.233616 46.154632,-1.233596 46.154726,-1.233472 46.154788,-1.233309 46.154762,-1.23324 46.154645,-1.233315 46.154539,-1.233192 46.154183,-1.232931 46.153699,-1.232505 46.153058,-1.232059 46.152521,-1.231427 46.151866,-1.230778 46.151338,-1.23062 46.151341,-1.230175 46.151457,-1.229941 46.151608,-1.230015 46.151846,-1.230259 46.152075,-1.224245 46.154942,-1.224055 46.154749,-1.22342 46.155095,-1.223575 46.155303,-1.223844 46.155251,-1.223902 46.155128,-1.224129 46.155024,-1.224367 46.155262,-1.224136 46.15537,-1.223949 46.155365,-1.223717 46.155522,-1.22384 46.155559,-1.225236 46.156976,-1.22542 46.157257,-1.225495 46.157471,-1.225489 46.157696,-1.225828 46.157758,-1.225792 46.157805,-1.224809 46.157627,-1.224542 46.157623,-1.223811 46.157519,-1.22365 46.15745,-1.223186 46.157414,-1.223157 46.157313,-1.223033 46.157317,-1.222997 46.157472,-1.222408 46.157432,-1.222254 46.157332,-1.221881 46.156884,-1.221706 46.156957,-1.222003 46.157311,-1.221287 46.157601,-1.220943 46.157634,-1.220952 46.157695,-1.221573 46.157654,-1.22161 46.157695,-1.220641 46.157751,-1.220673 46.157959,-1.220809 46.158031,-1.220856 46.158266,-1.218125 46.158443,-1.217833 46.158458,-1.217823 46.158372,-1.218403 46.158336,-1.218493 46.158264,-1.21825 46.15821,-1.218234 46.158062,-1.218503 46.158011,-1.21849 46.157899,-1.218216 46.157878,-1.218138 46.157219,-1.217893 46.157102,-1.218573 46.156304,-1.218431 46.156185,-1.218314 46.156211,-1.217666 46.15702,-1.217574 46.157188,-1.217319 46.15713,-1.21844 46.155811,-1.218392 46.155712,-1.218254 46.155657,-1.218097 46.155691,-1.217016 46.157018,-1.21687 46.157235,-1.210465 46.15764,-1.210456 46.157787,-1.210514 46.158226,-1.213048 46.158068,-1.213062 46.1582,-1.210498 46.158366,-1.210478 46.158386,-1.210621 46.159438,-1.217906 46.158968,-1.217869 46.158658,-1.220494 46.158487,-1.22089 46.158471,-1.221624 46.15868,-1.221708 46.158799,-1.221654 46.158879,-1.22126 46.159053,-1.2213 46.159179,-1.221495 46.159404,-1.222216 46.160126,-1.222956 46.159708,-1.223016 46.159588,-1.223184 46.159731,-1.223008 46.159752,-1.222263 46.16017,-1.223341 46.161035,-1.223307 46.161106,-1.223404 46.16121,-1.223722 46.161129,-1.223937 46.161037,-1.225676 46.160155,-1.226283 46.159817,-1.230703 46.157542,-1.231001 46.157823,-1.23136 46.157634,-1.231538 46.157622,-1.23169 46.157709,-1.231844 46.157737,-1.232189 46.157864,-1.232287 46.157927,-1.232459 46.158202,-1.232478 46.15855,-1.232441 46.158863,-1.232915 46.158896,-1.232363 46.162157,-1.231867 46.162113,-1.231702 46.162592,-1.231556 46.162737,-1.230344 46.163253,-1.230281 46.163315,-1.2301 46.164401,-1.23018 46.164572,-1.230345 46.164795,-1.230606 46.165221,-1.230774 46.165652,-1.235844 46.165725,-1.236369 46.165694,-1.236852 46.165598,-1.237312 46.165435,-1.237711 46.165204,-1.238016 46.164921,-1.238238 46.164607,-1.238336 46.1643,-1.238302 46.164269,-1.238533 46.163099,-1.238676 46.162297,-1.238784 46.161778,-1.238759 46.161713,-1.23918 46.159467,-1.239267 46.159437,-1.24114 46.15961,-1.241251 46.15909,-1.241491 46.157815,-1.241297 46.157782,-1.241332 46.157582,-1.241895 46.15764,-1.241858 46.157832,-1.241585 46.157805,-1.241345 46.159116,-1.241238 46.159617,-1.241517 46.159687,-1.240866 46.163048,-1.238501 46.164292,-1.238387 46.164638,-1.238159 46.164976,-1.237836 46.165281,-1.237429 46.165527,-1.236969 46.165703,-1.236421 46.165808,-1.235847 46.165847,-1.230781 46.165777,-1.230631 46.166078,-1.2305 46.166245,-1.230239 46.166462,-1.229954 46.166629,-1.229324 46.166902,-1.228616 46.167166,-1.228019 46.167455,-1.227497 46.167681,-1.227226 46.167843,-1.226522 46.168236,-1.226272 46.16843,-1.225889 46.168677,-1.225119 46.169385,-1.224828 46.169688,-1.224524 46.169962,-1.224085 46.170463,-1.22351 46.17129,-1.223309 46.171632,-1.223154 46.171967,-1.223017 46.172209,-1.222921 46.172471,-1.222738 46.172781,-1.222551 46.172983,-1.222239 46.173108,-1.221756 46.173237,-1.219917 46.173757,-1.219832 46.173879,-1.219806 46.174433,-1.21982 46.174806,-1.219963 46.175121,-1.220347 46.175245,-1.220598 46.175291,-1.221475 46.175404,-1.222034 46.175399,-1.222359 46.175371,-1.222476 46.175324,-1.222654 46.175364,-1.222706 46.175457,-1.222748 46.175698,-1.222618 46.175898,-1.22193 46.175909,-1.221674 46.175954,-1.219799 46.176209,-1.219627 46.176342,-1.219356 46.176878,-1.21909 46.177341,-1.218904 46.177804,-1.218874 46.177991,-1.218774 46.178172,-1.218727 46.178617,-1.218642 46.178717,-1.218641 46.178948,-1.218584 46.179078,-1.218441 46.179143,-1.218302 46.179409,-1.218249 46.179834,-1.217823 46.180231,-1.217702 46.18039,-1.217488 46.180496,-1.217332 46.180675,-1.216991 46.180882,-1.216938 46.181021,-1.216708 46.181184,-1.216667 46.181307,-1.2163 46.181809,-1.216216 46.181968,-1.215746 46.182484,-1.215407 46.182541,-1.215093 46.182753,-1.214918 46.182844,-1.214718 46.182895,-1.214326 46.183119,-1.214271 46.183214,-1.213782 46.183386,-1.212872 46.183543,-1.212557 46.18358,-1.21223 46.183659,-1.211501 46.183658,-1.21118 46.183682,-1.210792 46.183761,-1.210494 46.1838,-1.209892 46.183952,-1.209677 46.184027,-1.209369 46.184076,-1.208747 46.184087,-1.208638 46.184026,-1.208094 46.183944,-1.207992 46.183902,-1.207232 46.184114,-1.20695 46.184227,-1.206771 46.184345,-1.206436 46.184511,-1.205956 46.184871,-1.205441 46.185354,-1.205218 46.185491,-1.204755 46.185923,-1.204251 46.186512,-1.204273 46.186656,-1.204004 46.186891,-1.203814 46.187106,-1.203658 46.187238,-1.203235 46.187758,-1.202695 46.1885,-1.202552 46.188721,-1.202407 46.188853,-1.201883 46.189558,-1.201511 46.19013,-1.201391 46.190361,-1.201055 46.190933,-1.200759 46.190801,-1.199913 46.190475,-1.198353 46.189669,-1.197963 46.189512,-1.19726 46.189268,-1.196973 46.189182,-1.196535 46.189083,-1.196252 46.189,-1.195278 46.1886,-1.194648 46.188439,-1.194348 46.188329,-1.193942 46.188039,-1.193851 46.187891,-1.193047 46.187534,-1.19282 46.187306,-1.193044 46.187206,-1.193518 46.18686,-1.19362 46.186728,-1.193633 46.186613,-1.193566 46.186441,-1.193461 46.186343,-1.19306 46.186107,-1.192578 46.185593,-1.192288 46.185416,-1.192005 46.185293,-1.191563 46.185131,-1.191388 46.185095,-1.191323 46.184653,-1.191392 46.184336,-1.191194 46.184261,-1.191107 46.184107,-1.190949 46.183961,-1.190773 46.183857,-1.190185 46.183673,-1.189226 46.183457,-1.188589 46.183297,-1.187658 46.1829,-1.186519 46.18254,-1.185255 46.182158,-1.184556 46.181962,-1.183182 46.181468,-1.182504 46.181268,-1.181934 46.181052,-1.18158 46.180952,-1.181263 46.18099,-1.18087 46.181158,-1.180319 46.181701,-1.180157 46.181797,-1.179568 46.181973,-1.178989 46.182068,-1.178673 46.182137,-1.177866 46.182271,-1.177042 46.182342,-1.176738 46.182331,-1.176185 46.182253,-1.175803 46.182216,-1.175069 46.182236,-1.174882 46.182227,-1.174131 46.182114,-1.173497 46.182006,-1.173361 46.182004,-1.173119 46.181862,-1.172885 46.18186,-1.172503 46.181928,-1.172548 46.181718,-1.173177 46.180364,-1.173717 46.179235,-1.173714 46.179154,-1.173418 46.178858,-1.173306 46.178679,-1.17312 46.178263,-1.172929 46.177921,-1.172659 46.177223,-1.172528 46.17668,-1.172298 46.176027,-1.172293 46.175741,-1.172356 46.175472,-1.172447 46.175344,-1.173459 46.175485,-1.17396 46.175536,-1.174312 46.175546,-1.17498 46.175502,-1.175048 46.175049,-1.174482 46.173908,-1.174466 46.173666,-1.174092 46.172171,-1.173822 46.171119,-1.173746 46.170942,-1.173305 46.17092,-1.172406 46.171171,-1.172073 46.171157,-1.171857 46.171074,-1.171446 46.17083,-1.171105 46.170699,-1.170617 46.170586,-1.170457 46.170465,-1.170146 46.170006,-1.169906 46.169621,-1.169681 46.1697,-1.168443 46.170205,-1.168099 46.170327,-1.166864 46.170697,-1.166479 46.170827,-1.165729 46.171168,-1.165025 46.171514,-1.164544 46.171717,-1.163675 46.172023,-1.162925 46.172341,-1.162635 46.172479,-1.161981 46.172759,-1.161304 46.173031,-1.160648 46.173189,-1.159617 46.173493,-1.157938 46.174147,-1.15758 46.174227,-1.157476 46.174155,-1.157004 46.174315,-1.156667 46.174458,-1.15639 46.174623,-1.155626 46.175145,-1.15554 46.175221,-1.154624 46.175769,-1.153974 46.176116,-1.153187 46.176549,-1.152402 46.177007,-1.152189 46.177075,-1.151574 46.177353,-1.151277 46.177531,-1.150618 46.177824,-1.150404 46.177899,-1.148697 46.178436,-1.14776 46.178686,-1.147257 46.178774,-1.146358 46.178882,-1.145574 46.178925,-1.144861 46.178881,-1.144125 46.1788,-1.143992 46.179008,-1.14376 46.179306,-1.143482 46.179507,-1.142776 46.179604,-1.141978 46.179669,-1.141505 46.179734,-1.140852 46.179797,-1.140536 46.179843,-1.139867 46.179834,-1.139264 46.179773,-1.138306 46.179658)))', 4326))
            AND akeys(tags) && ARRAY['amenity','shop','office','craft','leisure','healthcare','emergency','man_made','power','highway','railway','public_transport','landuse','historic','barrier','tourism','sport','place','waterway','natural','geological','route','military','traffic_sign','traffic_calming','seamark','route_master','water','airway','aerialway','building']::text[];