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 = '13066' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.measure AS measure_2,
  c0_.date AS date_3,
  c0_.stats_id AS stats_id_4
FROM
  city_follow_up c0_
  INNER JOIN stats s1_ ON c0_.stats_id = s1_.id
WHERE
  s1_.id = ?
  AND c0_.name IN (?, ?)
ORDER BY
  c0_.date ASC,
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.measure AS measure_2, c0_.date AS date_3, c0_.stats_id AS stats_id_4 FROM city_follow_up c0_ INNER JOIN stats s1_ ON c0_.stats_id = s1_.id WHERE s1_.id = 27689 AND c0_.name IN ('travaux_count', 'travaux_completion') ORDER BY c0_.date ASC, c0_.id ASC;

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.zip_code = ?

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.zip_code = '13066';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO action_log (
  type, data, created_at, from_url, who
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO action_log (type, data, created_at, from_url, who) VALUES ('[DEBUG][followupThemeGraph]', '{\"theme\":\"travaux\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-14 06:05:59', NULL, NULL);

"COMMIT"

"COMMIT";

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

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

SELECT
  z0_.id AS id_0,
  z0_.disappeared_list AS disappeared_list_1,
  z0_.current_list AS current_list_2,
  z0_.theme AS theme_3,
  z0_.stats_id AS stats_id_4
FROM
  zone_places z0_
WHERE
  z0_.stats_id = ?
  AND z0_.theme = ?
ORDER BY
  z0_.id ASC
LIMIT
  1

SELECT z0_.id AS id_0, z0_.disappeared_list AS disappeared_list_1, z0_.current_list AS current_list_2, z0_.theme AS theme_3, z0_.stats_id AS stats_id_4 FROM zone_places z0_ WHERE z0_.stats_id = 27689 AND z0_.theme = 'travaux' ORDER BY z0_.id ASC LIMIT 1;

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

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,
  ST_AsGeoJSON(
    ST_Force2D(geom),
    6,
    0
  ) AS geom_geojson,
  CASE WHEN GeometryType(geom) IN ('POLYGON', 'MULTIPOLYGON') THEN
    ST_Area(geom :: geography)
  ELSE
    NULL
  END AS area_m2
FROM
  osm_object_meta m
WHERE
  geom IS NOT NULL
  AND ST_Intersects(
    m.geom,
    ST_GeomFromText(?, 4326)
  )
  AND osm_type IN ('way', 'relation')
  AND (tags -> 'landuse') = 'construction'

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,
       ST_AsGeoJSON(ST_Force2D(geom), 6, 0) AS geom_geojson,
       CASE WHEN GeometryType(geom) IN ('POLYGON', 'MULTIPOLYGON')
            THEN ST_Area(geom::geography)
            ELSE NULL END AS area_m2
FROM osm_object_meta m
WHERE geom IS NOT NULL
  AND ST_Intersects(m.geom, ST_GeomFromText('MULTIPOLYGON(((4.922213 43.886588,4.925185 43.886581,4.930459 43.88443,4.935085 43.879739,4.934242 43.877461,4.934257 43.877193,4.934432 43.876515,4.934435 43.876194,4.934479 43.876038,4.934407 43.875794,4.934376 43.875579,4.934305 43.875407,4.934177 43.874937,4.933906 43.873776,4.933707 43.872839,4.933588 43.872404,4.933288 43.872416,4.932539 43.872496,4.932314 43.87254,4.932093 43.872465,4.930967 43.871944,4.929902 43.871498,4.929626 43.871465,4.92923 43.871248,4.928872 43.870977,4.92882 43.870962,4.926616 43.86946,4.92626 43.869635,4.925937 43.869821,4.924734 43.869409,4.924492 43.869342,4.924269 43.869247,4.92265 43.868594,4.922691 43.868567,4.921036 43.867859,4.920998 43.8678,4.921048 43.867401,4.921185 43.866828,4.921451 43.866583,4.921828 43.866361,4.922662 43.865978,4.922728 43.865883,4.92283 43.865589,4.923014 43.865366,4.923553 43.865026,4.923952 43.864811,4.924222 43.864692,4.924498 43.864526,4.924821 43.864199,4.924973 43.864008,4.925075 43.863815,4.925325 43.863131,4.925403 43.862445,4.925449 43.861899,4.925079 43.861864,4.924687 43.861802,4.924563 43.861532,4.924409 43.861112,4.924352 43.860877,4.924395 43.860616,4.924433 43.860144,4.924491 43.859783,4.924574 43.859622,4.924946 43.85911,4.924963 43.858966,4.925199 43.858606,4.925418 43.858353,4.925697 43.858131,4.926323 43.85759,4.926659 43.857374,4.926998 43.857239,4.927367 43.857117,4.927798 43.857001,4.928499 43.85687,4.928909 43.856707,4.929396 43.856492,4.930556 43.855961,4.930616 43.855898,4.930694 43.855512,4.93076 43.855323,4.931059 43.854915,4.931405 43.854396,4.931485 43.854235,4.931814 43.853683,4.931944 43.853492,4.931925 43.853356,4.929689 43.852897,4.928461 43.852653,4.928559 43.852551,4.926824 43.852004,4.925591 43.85154,4.925437 43.851577,4.925057 43.851408,4.924953 43.851404,4.924418 43.851119,4.9242 43.851324,4.92333 43.851014,4.922987 43.850917,4.92241 43.850694,4.922016 43.850574,4.921209 43.850273,4.920368 43.849985,4.919987 43.84989,4.919801 43.850136,4.919642 43.850125,4.919025 43.849999,4.918624 43.849935,4.918505 43.850124,4.916937 43.849734,4.917006 43.849553,4.91612 43.849349,4.913327 43.848795,4.913336 43.848658,4.912106 43.848232,4.911218 43.847686,4.911135 43.847658,4.909471 43.846789,4.909298 43.846719,4.908948 43.846988,4.908663 43.847182,4.907867 43.847654,4.907215 43.84747,4.905805 43.84705,4.905484 43.846969,4.904943 43.846807,4.9051 43.846575,4.905628 43.846068,4.905901 43.845769,4.906982 43.844978,4.906906 43.844932,4.90526 43.844115,4.905166 43.844054,4.905747 43.843653,4.906823 43.842887,4.906928 43.842744,4.906914 43.84266,4.906365 43.842676,4.906757 43.842131,4.907269 43.841454,4.908016 43.840499,4.908295 43.840163,4.908151 43.83989,4.908206 43.839728,4.908411 43.839378,4.908544 43.839266,4.908762 43.839016,4.908778 43.838892,4.908144 43.837835,4.907925 43.837443,4.90777 43.837281,4.908378 43.836091,4.908444 43.835847,4.908215 43.835441,4.90805 43.835282,4.9076 43.834902,4.906694 43.834406,4.906476 43.83437,4.906379 43.834112,4.906452 43.833861,4.906841 43.833582,4.906929 43.833477,4.907057 43.833206,4.907384 43.832453,4.907804 43.831564,4.907894 43.831409,4.908009 43.83111,4.908132 43.830872,4.908339 43.830857,4.909038 43.830857,4.909234 43.830837,4.909379 43.83073,4.909681 43.830408,4.909805 43.830233,4.910582 43.829445,4.910606 43.829408,4.909752 43.829268,4.909869 43.829039,4.910773 43.827524,4.911633 43.826103,4.911875 43.82566,4.912482 43.824629,4.913008 43.823761,4.911487 43.823353,4.90983 43.822826,4.909244 43.822618,4.908917 43.822484,4.907671 43.821949,4.907238 43.821755,4.907293 43.821615,4.907437 43.820963,4.907406 43.820741,4.907531 43.819697,4.9077 43.818616,4.907738 43.818279,4.907446 43.81828,4.906665 43.818356,4.905665 43.818419,4.905195 43.81846,4.9031 43.818698,4.901132 43.818824,4.899439 43.818948,4.898961 43.819005,4.898615 43.819018,4.895524 43.819269,4.892872 43.81946,4.891636 43.819557,4.890761 43.819647,4.890106 43.819747,4.889312 43.819905,4.888993 43.819981,4.888048 43.820241,4.887616 43.820374,4.887264 43.820448,4.886903 43.82048,4.886306 43.820496,4.885349 43.820545,4.884403 43.820621,4.883639 43.820701,4.883074 43.82077,4.881178 43.82098,4.880846 43.821025,4.880571 43.821092,4.88051 43.821038,4.87997 43.821315,4.879788 43.821462,4.879574 43.821581,4.879127 43.821898,4.878483 43.822156,4.877893 43.822441,4.877378 43.822714,4.876863 43.822916,4.876649 43.823058,4.876601 43.823316,4.876519 43.823425,4.876204 43.823713,4.875811 43.824012,4.87554 43.824255,4.875039 43.824579,4.87454 43.824956,4.874175 43.825186,4.873529 43.825641,4.872912 43.826199,4.872288 43.826706,4.872178 43.82683,4.87204 43.826897,4.871711 43.82712,4.871418 43.827362,4.870724 43.827991,4.870024 43.828647,4.869468 43.829127,4.868909 43.82966,4.868589 43.829855,4.8688 43.830149,4.86896 43.830279,4.8695 43.830622,4.869875 43.830967,4.870016 43.831245,4.870176 43.831622,4.870359 43.831929,4.870499 43.832207,4.871008 43.832926,4.871265 43.833322,4.871655 43.83382,4.871907 43.834194,4.872113 43.834449,4.872711 43.835299,4.873044 43.835688,4.873504 43.836289,4.873677 43.836485,4.874898 43.837676,4.876258 43.839083,4.876373 43.839182,4.876894 43.839782,4.877394 43.840377,4.878069 43.841368,4.878205 43.841456,4.878536 43.841861,4.879754 43.843416,4.880053 43.843851,4.880299 43.844241,4.880623 43.844709,4.881217 43.845477,4.881716 43.846291,4.881811 43.846511,4.881894 43.846813,4.881972 43.847204,4.88213 43.847696,4.882165 43.848068,4.882283 43.848608,4.882334 43.849074,4.882571 43.84965,4.882631 43.850114,4.882581 43.850426,4.88262 43.850726,4.882906 43.85196,4.882941 43.852951,4.882969 43.853195,4.883065 43.853617,4.88314 43.854047,4.883169 43.854358,4.88317 43.854667,4.883126 43.855218,4.883031 43.855657,4.882727 43.856535,4.882665 43.85684,4.882588 43.857499,4.882578 43.857773,4.882622 43.858042,4.882758 43.858402,4.883121 43.859162,4.883114 43.859272,4.883353 43.859821,4.883296 43.859979,4.882963 43.86049,4.88277 43.860362,4.882341 43.860272,4.882262 43.860174,4.88197 43.859996,4.881813 43.86017,4.88179 43.860399,4.881709 43.860631,4.881576 43.860639,4.881559 43.860741,4.881059 43.861747,4.880684 43.862469,4.880656 43.862558,4.879984 43.863914,4.879917 43.863998,4.879716 43.864396,4.879569 43.864771,4.879386 43.864994,4.879298 43.865188,4.879143 43.865859,4.878904 43.866548,4.878762 43.867413,4.878597 43.869492,4.878846 43.870504,4.878942 43.871125,4.879066 43.8716,4.879243 43.871641,4.879324 43.87223,4.879177 43.872246,4.879235 43.87304,4.879405 43.873205,4.879482 43.873393,4.879525 43.873872,4.879512 43.874159,4.879458 43.874621,4.879368 43.875018,4.879315 43.875151,4.87936 43.875328,4.879143 43.876673,4.87886 43.877511,4.878906 43.877602,4.878894 43.877835,4.87879 43.877991,4.878808 43.878128,4.878716 43.878468,4.878641 43.879529,4.878901 43.879515,4.879272 43.879141,4.879861 43.87916,4.879947 43.879298,4.879825 43.879701,4.879833 43.879899,4.879771 43.88013,4.879701 43.880196,4.879645 43.880504,4.879632 43.880955,4.879645 43.881755,4.879595 43.882126,4.879469 43.88232,4.879451 43.882951,4.879157 43.883581,4.878487 43.884028,4.878576 43.884059,4.87908 43.884073,4.879667 43.884126,4.880008 43.884081,4.879928 43.884558,4.879809 43.884688,4.879859 43.884827,4.879713 43.884974,4.879456 43.885164,4.879406 43.885339,4.879458 43.885675,4.879568 43.886921,4.879632 43.887217,4.879784 43.887273,4.879767 43.887416,4.879897 43.888387,4.880074 43.888791,4.880127 43.889094,4.880262 43.890609,4.880273 43.89206,4.880252 43.892895,4.880256 43.893946,4.880328 43.894854,4.880377 43.895142,4.880558 43.896359,4.880631 43.897022,4.880636 43.897257,4.880703 43.897641,4.880731 43.897679,4.88081 43.898251,4.880884 43.898905,4.881117 43.900707,4.881172 43.901686,4.882313 43.901187,4.883882 43.900656,4.884855 43.90034,4.885342 43.900035,4.890506 43.896423,4.89567 43.892812,4.898388 43.890945,4.902276 43.88823,4.902711 43.8881,4.902978 43.888002,4.90769 43.886472,4.914288 43.886517,4.921812 43.886569,4.922213 43.886588)))', 4326))
  AND osm_type IN ('way', 'relation')
  AND (tags->'landuse') = 'construction';