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 = '34121' 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 = 26866;

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 = 26866;

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'34121'') = ?
  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'34121'') = ?
      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 = '34121';

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(((3.123793 43.785108,3.123809 43.785713,3.123774 43.787287,3.123873 43.787542,3.124014 43.787719,3.124167 43.787842,3.124222 43.788057,3.124129 43.788398,3.124176 43.78868,3.124273 43.788969,3.12471 43.789598,3.124885 43.789699,3.125002 43.789834,3.125267 43.790051,3.125332 43.790235,3.125642 43.790519,3.125769 43.790728,3.12582 43.791042,3.125804 43.791271,3.125845 43.791385,3.125837 43.791602,3.12568 43.791876,3.125752 43.79195,3.126009 43.792087,3.126214 43.79228,3.1264 43.792402,3.126664 43.79244,3.126942 43.792626,3.127375 43.792793,3.127745 43.79286,3.128167 43.792979,3.128736 43.793207,3.129178 43.793491,3.12935 43.793644,3.129867 43.793894,3.13013 43.794117,3.130414 43.794474,3.129972 43.794758,3.129344 43.794903,3.129006 43.795013,3.128852 43.795119,3.128455 43.795611,3.128124 43.79591,3.12787 43.795914,3.127706 43.796016,3.127574 43.796049,3.127453 43.796152,3.127283 43.796197,3.126795 43.796161,3.126614 43.796209,3.126222 43.796446,3.125735 43.796679,3.125431 43.796744,3.125267 43.796818,3.125167 43.796998,3.125021 43.79705,3.124736 43.797092,3.124463 43.797257,3.124174 43.797558,3.124035 43.797747,3.123995 43.797873,3.123882 43.797963,3.123193 43.798099,3.12294 43.79813,3.122814 43.798183,3.122651 43.798383,3.12259 43.79858,3.122755 43.798989,3.12273 43.79915,3.122522 43.799514,3.122346 43.799726,3.122199 43.80001,3.12213 43.800078,3.121904 43.80017,3.121656 43.800537,3.121436 43.800747,3.121287 43.800799,3.121053 43.800806,3.121003 43.800889,3.120812 43.801525,3.120562 43.801917,3.120337 43.802084,3.120422 43.802224,3.120573 43.802361,3.121262 43.802808,3.121626 43.803022,3.122247 43.80332,3.123241 43.803818,3.124256 43.80417,3.124691 43.80431,3.12482 43.804395,3.125031 43.804684,3.125269 43.804744,3.125816 43.804793,3.126237 43.804723,3.127141 43.804279,3.127403 43.804117,3.127855 43.803995,3.128069 43.803918,3.12833 43.803641,3.128723 43.803445,3.129061 43.803387,3.129911 43.803048,3.130049 43.802978,3.130249 43.802958,3.130874 43.802954,3.131426 43.80293,3.131795 43.802931,3.132186 43.80306,3.132837 43.803468,3.133101 43.803603,3.133606 43.803819,3.134009 43.803966,3.134374 43.804041,3.134668 43.804126,3.135295 43.804495,3.135745 43.804725,3.136324 43.805088,3.136695 43.805289,3.137255 43.805459,3.137559 43.805473,3.137957 43.805442,3.13872 43.805478,3.139323 43.805565,3.140477 43.805877,3.140764 43.805921,3.141046 43.80639,3.141119 43.806556,3.141404 43.806889,3.14175 43.807248,3.142127 43.807605,3.142551 43.80792,3.142698 43.808152,3.143119 43.808574,3.143393 43.808753,3.144026 43.808985,3.14451 43.809105,3.144957 43.809149,3.145942 43.809057,3.146318 43.80904,3.147281 43.809119,3.147758 43.809245,3.148302 43.809418,3.148531 43.809627,3.148801 43.810037,3.149176 43.810382,3.149962 43.810796,3.150231 43.810915,3.150783 43.811037,3.151163 43.811137,3.151325 43.811218,3.151527 43.811589,3.151789 43.811937,3.152037 43.812137,3.152145 43.812182,3.153021 43.812408,3.153441 43.812419,3.153852 43.81239,3.154083 43.812266,3.154394 43.812054,3.154616 43.811952,3.155022 43.81182,3.155325 43.811677,3.155515 43.811559,3.156129 43.811071,3.156527 43.810737,3.157105 43.810337,3.157467 43.810143,3.157733 43.810044,3.158007 43.81,3.158633 43.809803,3.158844 43.809761,3.159885 43.809688,3.160427 43.809739,3.160732 43.809726,3.161103 43.809671,3.162088 43.809594,3.162492 43.809597,3.163467 43.809405,3.164001 43.809342,3.164864 43.80933,3.165161 43.809365,3.165475 43.8092,3.165726 43.808939,3.166007 43.808564,3.166468 43.808143,3.166853 43.807969,3.16746 43.807747,3.167746 43.807531,3.167846 43.807283,3.167864 43.806678,3.167903 43.806303,3.168099 43.805803,3.168237 43.805557,3.168309 43.805356,3.168692 43.804752,3.168997 43.804406,3.169246 43.804222,3.169525 43.80406,3.169823 43.803917,3.170575 43.803725,3.170864 43.803728,3.171131 43.803698,3.171788 43.803667,3.172138 43.803629,3.17292 43.803468,3.173299 43.803325,3.173468 43.803007,3.173539 43.802938,3.174245 43.802553,3.174547 43.802418,3.174937 43.802281,3.175403 43.802139,3.175791 43.80205,3.176822 43.801934,3.177123 43.801885,3.177574 43.801843,3.178221 43.80175,3.178521 43.801722,3.178825 43.801667,3.179005 43.801595,3.17915 43.801482,3.179315 43.801291,3.179966 43.800235,3.180071 43.800002,3.180261 43.799431,3.180266 43.798771,3.180368 43.798386,3.180514 43.798112,3.180759 43.79759,3.180844 43.797465,3.18112 43.796886,3.181275 43.796648,3.181368 43.796226,3.181383 43.79587,3.181286 43.79567,3.181059 43.795309,3.180766 43.795016,3.180686 43.794884,3.180604 43.794642,3.180601 43.794281,3.180637 43.793738,3.180701 43.793497,3.180761 43.793416,3.181183 43.793119,3.181425 43.792877,3.181432 43.79279,3.181347 43.792623,3.181205 43.792455,3.180808 43.792132,3.18061 43.791854,3.180571 43.791485,3.180609 43.79131,3.180725 43.791122,3.181056 43.790819,3.181207 43.790646,3.181324 43.790452,3.181416 43.790207,3.181551 43.789964,3.181798 43.789632,3.181903 43.789539,3.182297 43.789325,3.183394 43.788984,3.183651 43.788887,3.184029 43.788869,3.184186 43.788835,3.184537 43.788675,3.184702 43.78852,3.184777 43.78835,3.184732 43.788085,3.184591 43.787906,3.184335 43.787691,3.184057 43.787562,3.183734 43.787306,3.182846 43.786786,3.182205 43.786448,3.181872 43.786225,3.181646 43.785974,3.181583 43.785789,3.181627 43.785514,3.181807 43.785262,3.181975 43.785106,3.182215 43.78495,3.183051 43.784606,3.183388 43.78435,3.183532 43.784161,3.183701 43.783663,3.183759 43.783438,3.183861 43.783201,3.183898 43.783037,3.184067 43.782654,3.18417 43.782535,3.18452 43.782269,3.184603 43.782104,3.184742 43.782018,3.184933 43.781984,3.185156 43.781897,3.185317 43.781697,3.185288 43.781483,3.185 43.781074,3.184875 43.780847,3.184694 43.780589,3.184654 43.780442,3.18467 43.78003,3.184713 43.779882,3.184652 43.779604,3.18468 43.779421,3.184766 43.779159,3.184958 43.778806,3.1851 43.778633,3.185432 43.778328,3.185748 43.778116,3.185844 43.777971,3.18657 43.777652,3.187186 43.777395,3.187524 43.777191,3.18762 43.777077,3.1877 43.77688,3.187858 43.776721,3.188004 43.776656,3.188938 43.776518,3.189052 43.776464,3.189177 43.776323,3.189365 43.776213,3.189816 43.776145,3.190548 43.776187,3.190935 43.776227,3.191113 43.776365,3.19129 43.776457,3.191522 43.776488,3.191756 43.776554,3.19191 43.776556,3.19228 43.776486,3.192512 43.776531,3.192837 43.776661,3.1932 43.776701,3.193346 43.776693,3.193707 43.776614,3.193881 43.776604,3.193985 43.776535,3.194363 43.776678,3.194672 43.776865,3.19505 43.777125,3.195318 43.777255,3.19604 43.777495,3.196241 43.777525,3.196883 43.777521,3.19723 43.777546,3.197755 43.777543,3.198169 43.777492,3.199069 43.777808,3.199377 43.777903,3.199811 43.777944,3.200057 43.777917,3.200373 43.777998,3.200947 43.778277,3.201199 43.778603,3.201417 43.778753,3.201581 43.77881,3.202427 43.778822,3.202806 43.778884,3.202948 43.778835,3.203172 43.778696,3.203721 43.778473,3.203937 43.778436,3.204457 43.778273,3.204659 43.778248,3.204965 43.778154,3.205559 43.777891,3.206202 43.777586,3.206563 43.77736,3.206674 43.777262,3.20681 43.777034,3.207049 43.776858,3.207674 43.776728,3.207771 43.776671,3.207846 43.77651,3.208011 43.776365,3.208448 43.776361,3.208807 43.776313,3.209138 43.776181,3.2095 43.776142,3.209652 43.77609,3.210042 43.775846,3.210223 43.775691,3.210407 43.775401,3.210575 43.775265,3.211013 43.775098,3.211347 43.774862,3.211544 43.774796,3.211746 43.774651,3.212303 43.77439,3.212563 43.774234,3.212833 43.774012,3.213096 43.773868,3.213457 43.773803,3.213949 43.773961,3.214074 43.773951,3.21428 43.773768,3.214505 43.773746,3.214806 43.773797,3.215109 43.773674,3.215437 43.773627,3.215793 43.773854,3.216059 43.773896,3.216156 43.773949,3.216499 43.774258,3.21658 43.774414,3.216818 43.774312,3.216891 43.774144,3.216992 43.774024,3.217296 43.773466,3.217428 43.773337,3.217452 43.773214,3.217576 43.773042,3.217596 43.772881,3.21773 43.772747,3.218156 43.772661,3.218314 43.772539,3.218732 43.772615,3.219035 43.772478,3.223138 43.772404,3.223227 43.772242,3.223575 43.772021,3.223745 43.771977,3.223897 43.772087,3.224103 43.771972,3.224298 43.772028,3.22451 43.772014,3.224862 43.77214,3.224954 43.772145,3.225101 43.772005,3.225412 43.772094,3.225523 43.772013,3.225909 43.772067,3.226285 43.772154,3.226687 43.772051,3.227024 43.772073,3.227256 43.771977,3.227392 43.771957,3.227858 43.772137,3.228032 43.772242,3.228353 43.772285,3.228727 43.772371,3.229161 43.772408,3.22927 43.772453,3.2301 43.772568,3.230413 43.772581,3.230665 43.772491,3.230825 43.7724,3.231273 43.772077,3.231446 43.771854,3.231637 43.771791,3.231867 43.771791,3.231912 43.771855,3.232077 43.771841,3.232186 43.771746,3.232542 43.771664,3.232693 43.771477,3.232774 43.771289,3.232936 43.771132,3.233416 43.770959,3.233584 43.77083,3.233676 43.770824,3.234406 43.770491,3.235939 43.770409,3.236609 43.770393,3.237669 43.770346,3.237676 43.769939,3.237833 43.769772,3.238228 43.769505,3.238336 43.769242,3.238363 43.769079,3.237978 43.769035,3.237676 43.768965,3.237413 43.768804,3.237318 43.768657,3.237284 43.768491,3.237331 43.767688,3.237289 43.767451,3.23706 43.767024,3.236981 43.766713,3.236951 43.766488,3.23695 43.766174,3.236979 43.765731,3.236989 43.765067,3.237033 43.764721,3.237115 43.764444,3.237239 43.764215,3.237535 43.763911,3.237682 43.763716,3.237947 43.763253,3.238054 43.763026,3.238324 43.762366,3.238516 43.762075,3.238748 43.761784,3.238896 43.761668,3.239335 43.761379,3.239476 43.761214,3.239891 43.761011,3.240262 43.76075,3.240811 43.760159,3.241444 43.759495,3.241559 43.759317,3.241626 43.759141,3.241657 43.758934,3.241819 43.758716,3.242111 43.758253,3.2424 43.758076,3.242693 43.7578,3.243016 43.757651,3.243392 43.757453,3.24355 43.757304,3.243915 43.756539,3.244073 43.756373,3.244174 43.756161,3.244215 43.755942,3.244624 43.755253,3.244871 43.754815,3.245018 43.754381,3.245961 43.753432,3.246235 43.753193,3.246521 43.751757,3.246352 43.749338,3.246329 43.749349,3.242015 43.746151,3.240761 43.744499,3.239928 43.743493,3.239702 43.743136,3.23851 43.742664,3.237378 43.740005,3.237141 43.739995,3.237126 43.73978,3.236983 43.739587,3.236879 43.739521,3.23661 43.739712,3.236202 43.73986,3.234735 43.739994,3.230226 43.740395,3.227927 43.740013,3.224606 43.738362,3.22263 43.737686,3.222566 43.737921,3.222596 43.738092,3.22254 43.738378,3.222364 43.738421,3.222328 43.738489,3.222298 43.738983,3.222248 43.739186,3.222104 43.739314,3.221912 43.739354,3.221808 43.739461,3.221349 43.739814,3.22089 43.73971,3.220375 43.739542,3.219997 43.739312,3.219501 43.739098,3.219206 43.739008,3.218449 43.738879,3.218151 43.738796,3.217406 43.738804,3.217064 43.738727,3.216597 43.738541,3.216127 43.738379,3.214959 43.737856,3.214734 43.737742,3.214274 43.737644,3.214099 43.737576,3.213396 43.737442,3.213258 43.737144,3.21317 43.736708,3.213007 43.736313,3.212796 43.736035,3.212684 43.735783,3.212674 43.735586,3.21261 43.735411,3.212364 43.735144,3.212187 43.734819,3.212135 43.734461,3.212041 43.734215,3.211756 43.733655,3.211579 43.733398,3.211434 43.733248,3.211021 43.732938,3.210753 43.73282,3.21064 43.732849,3.210504 43.732772,3.210092 43.732317,3.209247 43.731717,3.209001 43.731504,3.208786 43.731276,3.208665 43.731052,3.208402 43.730036,3.208282 43.729862,3.207047 43.728703,3.206991 43.728636,3.2067 43.727831,3.202383 43.726713,3.200986 43.726395,3.200838 43.72635,3.199484 43.726154,3.19943 43.726333,3.199284 43.727142,3.199292 43.727368,3.199013 43.727482,3.198125 43.727795,3.197856 43.727857,3.197491 43.727988,3.196976 43.728057,3.191336 43.72705,3.186273 43.726147,3.184068 43.725752,3.180615 43.726204,3.174073 43.726872,3.173967 43.726845,3.173401 43.726847,3.172942 43.726694,3.172583 43.72666,3.172566 43.726782,3.172414 43.72706,3.172327 43.727344,3.172273 43.727682,3.172342 43.727887,3.171445 43.72794,3.169625 43.727992,3.166075 43.728818,3.164977 43.72907,3.164724 43.729581,3.164246 43.730231,3.164054 43.730438,3.163611 43.73083,3.163319 43.730967,3.163317 43.731181,3.163182 43.731639,3.162825 43.732392,3.162709 43.732716,3.162576 43.732934,3.162327 43.733445,3.162079 43.734077,3.161924 43.734316,3.161878 43.734482,3.161921 43.734763,3.161945 43.735423,3.161911 43.735644,3.16179 43.735835,3.161479 43.736119,3.161285 43.736359,3.161142 43.736476,3.160759 43.736978,3.161021 43.737833,3.161481 43.738988,3.16178 43.739282,3.162055 43.739511,3.162369 43.739677,3.162568 43.739821,3.162659 43.740111,3.162823 43.740402,3.163118 43.740737,3.163214 43.740965,3.163458 43.741345,3.16362 43.741813,3.16363 43.742075,3.163738 43.743205,3.163781 43.743467,3.16442 43.744829,3.164694 43.745211,3.166287 43.746378,3.166806 43.749314,3.167313 43.749539,3.167623 43.749703,3.168261 43.75024,3.168111 43.750408,3.167486 43.750828,3.167741 43.751127,3.168395 43.751073,3.168573 43.751289,3.168737 43.751202,3.169568 43.751741,3.168964 43.752233,3.168604 43.75254,3.168031 43.75308,3.167975 43.753106,3.167885 43.753327,3.167659 43.753574,3.167558 43.753804,3.167303 43.754113,3.167082 43.754343,3.166579 43.754678,3.166514 43.754753,3.166306 43.754853,3.165681 43.755319,3.165521 43.755383,3.165283 43.755567,3.164931 43.755684,3.164657 43.755804,3.164305 43.756072,3.163927 43.756279,3.16366 43.756671,3.163547 43.756731,3.16312 43.756883,3.162864 43.756919,3.162373 43.757027,3.162256 43.75713,3.162158 43.75711,3.161928 43.757366,3.161785 43.757636,3.16164 43.757818,3.161271 43.758114,3.16115 43.758301,3.160968 43.758477,3.160838 43.758686,3.160477 43.75898,3.160066 43.759238,3.159908 43.759288,3.159592 43.759286,3.15946 43.759247,3.159052 43.758999,3.158831 43.758659,3.158531 43.758325,3.158277 43.758127,3.158061 43.75803,3.157932 43.757883,3.157581 43.757654,3.157202 43.757614,3.157024 43.757503,3.156911 43.757297,3.15671 43.757122,3.15634 43.756897,3.156161 43.756864,3.155897 43.756869,3.155626 43.756767,3.155507 43.756686,3.155411 43.756538,3.155285 43.756188,3.155178 43.756167,3.154723 43.756415,3.154622 43.756515,3.154498 43.756745,3.154196 43.756878,3.154117 43.756964,3.154189 43.757155,3.154126 43.757289,3.153976 43.757462,3.153601 43.757661,3.153512 43.757765,3.153271 43.757888,3.153286 43.758059,3.153392 43.758143,3.153547 43.758353,3.153366 43.758679,3.153142 43.758854,3.153125 43.758924,3.152905 43.759054,3.152774 43.759263,3.152637 43.759285,3.152444 43.759399,3.1521 43.759466,3.151621 43.759663,3.151234 43.759731,3.151077 43.759797,3.150891 43.760047,3.150878 43.760186,3.150704 43.760265,3.150383 43.760658,3.150284 43.760716,3.150174 43.761106,3.150164 43.761375,3.150116 43.76159,3.149935 43.761832,3.149911 43.76214,3.149951 43.762551,3.149888 43.762725,3.149765 43.763412,3.149693 43.763626,3.150031 43.763998,3.150526 43.76463,3.151072 43.765196,3.150538 43.765398,3.150337 43.765346,3.149877 43.765479,3.149409 43.765671,3.149212 43.765734,3.148844 43.765906,3.148619 43.766074,3.147972 43.76637,3.147624 43.766743,3.147416 43.76686,3.14727 43.76689,3.14698 43.766868,3.146745 43.766888,3.146317 43.767035,3.146025 43.767065,3.145544 43.767172,3.14487 43.767243,3.144532 43.767342,3.143053 43.768154,3.142476 43.768356,3.141445 43.768768,3.141681 43.769893,3.141925 43.770057,3.142034 43.770179,3.142069 43.77043,3.142185 43.770529,3.14218 43.770707,3.142251 43.770804,3.142425 43.770898,3.142628 43.77111,3.142773 43.771347,3.14292 43.771462,3.142951 43.771722,3.143067 43.771862,3.142997 43.772043,3.143144 43.772357,3.143271 43.772566,3.143632 43.772802,3.143836 43.773087,3.14398 43.773247,3.144055 43.773414,3.144169 43.773496,3.144307 43.77369,3.144494 43.773848,3.144424 43.773956,3.144465 43.774035,3.144703 43.774075,3.144738 43.774228,3.14495 43.774356,3.145025 43.774559,3.145274 43.774782,3.145246 43.775079,3.145259 43.775726,3.145306 43.775787,3.145256 43.775935,3.145272 43.776103,3.145019 43.776488,3.14495 43.776676,3.144963 43.777112,3.144931 43.777357,3.144863 43.777606,3.144897 43.777905,3.144843 43.778344,3.144917 43.778604,3.145013 43.778803,3.145054 43.779033,3.145019 43.779544,3.145056 43.779877,3.145197 43.780164,3.145217 43.780571,3.145459 43.78056,3.145663 43.780611,3.145809 43.780734,3.146024 43.781038,3.146175 43.78121,3.146336 43.781342,3.146558 43.781463,3.146827 43.781759,3.14698 43.781862,3.14746 43.782072,3.147804 43.782302,3.148055 43.782527,3.148396 43.782986,3.147926 43.783561,3.147678 43.783794,3.147589 43.783952,3.14762 43.784071,3.147325 43.784557,3.147066 43.784809,3.146898 43.784855,3.14666 43.784854,3.146282 43.784913,3.145727 43.785076,3.145471 43.785308,3.144942 43.785563,3.144858 43.78574,3.144002 43.785383,3.143658 43.785222,3.143412 43.785009,3.143167 43.784885,3.141986 43.784501,3.141359 43.784347,3.141034 43.784234,3.140358 43.784142,3.140211 43.784095,3.139807 43.784724,3.139707 43.785017,3.139616 43.785087,3.139379 43.785111,3.139108 43.785197,3.138768 43.78525,3.137927 43.785291,3.137239 43.785275,3.136419 43.785286,3.1358 43.78523,3.135034 43.785246,3.134483 43.78522,3.133737 43.785156,3.133242 43.784769,3.133086 43.784786,3.131744 43.784725,3.130196 43.784662,3.129931 43.784676,3.129782 43.784828,3.129524 43.784882,3.128965 43.785053,3.128535 43.785086,3.127933 43.785198,3.126459 43.785239,3.125328 43.785176,3.124377 43.785139,3.123793 43.785108)))', 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[];