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 = '38548' 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 = 27682 AND c0_.name IN ('highways_count', 'highways_completion') ORDER BY c0_.date ASC, c0_.id ASC;

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

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 = '38548';

"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\":\"highways\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-13 03:22:37', 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 = 27682;

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 = 27682 AND z0_.theme = 'highways' 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'38548'') = ?
  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'38548'') = ?
      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 = '38548';

SELECT
  osm_type,
  osm_id :: text AS osm_id,
  ST_Y(
    ST_Centroid(m.geom)
  ) AS lat,
  ST_X(
    ST_Centroid(m.geom)
  ) AS lon,
  tags :: jsonb AS tags_json,
  version,
  osm_timestamp,
  changeset,
  osm_user,
  uid :: bigint AS uid,
  ST_AsGeoJSON(
    ST_Force2D(m.geom),
    6,
    0
  ) AS geom_geojson,
  COALESCE(
    ST_Length(
      ST_Intersection(
        ST_MakeValid(m.geom),
        z.poly
      ):: geography
    ),
    0
  ) AS length_m,
  (tags -> 'highway') AS highway_value,
  (tags -> 'railway') AS railway_value
FROM
  osm_object_meta m CROSS
  JOIN (
    SELECT
      ST_MakeValid(
        ST_SetSRID(
          ST_GeomFromText(?),
          4326
        )
      ) AS poly
  ) z
WHERE
  m.geom IS NOT NULL
  AND m.osm_type IN ('way', 'relation')
  AND ST_Intersects(m.geom, z.poly)
  AND (
    exist(tags, 'highway')
    OR (tags -> 'railway') = 'rail'
  )

SELECT osm_type, osm_id::text AS osm_id,
       ST_Y(ST_Centroid(m.geom)) AS lat, ST_X(ST_Centroid(m.geom)) AS lon,
       tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,
       ST_AsGeoJSON(ST_Force2D(m.geom), 6, 0) AS geom_geojson,
       COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) AS length_m,
       (tags->'highway') AS highway_value,
       (tags->'railway') AS railway_value
FROM osm_object_meta m
CROSS JOIN (SELECT ST_MakeValid(ST_SetSRID(ST_GeomFromText('MULTIPOLYGON(((5.494217 45.071744,5.494364 45.071739,5.494977 45.071818,5.495116 45.071785,5.495302 45.071812,5.495416 45.071779,5.495518 45.071873,5.495758 45.071834,5.496024 45.071863,5.496257 45.07171,5.496604 45.071705,5.496827 45.071736,5.497084 45.071718,5.497751 45.07158,5.498054 45.071475,5.498256 45.071376,5.498477 45.071346,5.499159 45.071068,5.499535 45.070977,5.499862 45.070848,5.500044 45.070819,5.500614 45.070778,5.501214 45.070697,5.501476 45.070605,5.501698 45.070585,5.501826 45.070637,5.501962 45.070616,5.502194 45.070437,5.50232 45.070449,5.502568 45.070652,5.502778 45.070684,5.503195 45.070588,5.503512 45.070559,5.503737 45.070596,5.503963 45.070584,5.504146 45.070518,5.504289 45.070405,5.504373 45.07025,5.504492 45.070222,5.504865 45.070307,5.505111 45.070324,5.505471 45.070297,5.505842 45.070158,5.505956 45.069987,5.506152 45.069822,5.50654 45.06963,5.506819 45.069553,5.507225 45.069509,5.507568 45.069408,5.507782 45.069386,5.508032 45.069319,5.508688 45.069178,5.50896 45.069048,5.509373 45.068989,5.51017 45.068932,5.510766 45.068858,5.511092 45.068764,5.511303 45.068658,5.511873 45.068603,5.512186 45.06852,5.512798 45.068094,5.512988 45.06808,5.513484 45.068097,5.513761 45.068077,5.51395 45.067971,5.514314 45.067926,5.515059 45.067965,5.515301 45.067924,5.515948 45.067676,5.516341 45.067544,5.516586 45.067546,5.51657 45.067733,5.516631 45.068395,5.516421 45.069167,5.516111 45.069311,5.515855 45.069272,5.515523 45.069012,5.515211 45.069111,5.514404 45.069449,5.513466 45.069701,5.512412 45.070398,5.511901 45.070322,5.5117 45.070148,5.51169 45.069968,5.511373 45.069977,5.510396 45.07068,5.509857 45.071236,5.508882 45.071984,5.508134 45.072231,5.507317 45.072389,5.50664 45.072768,5.505905 45.07324,5.504162 45.073865,5.503779 45.073832,5.503692 45.073429,5.503489 45.073209,5.502985 45.073269,5.502683 45.073548,5.502569 45.074001,5.502864 45.074713,5.503005 45.074979,5.502963 45.07534,5.502433 45.076075,5.502191 45.076308,5.502007 45.077528,5.501538 45.078217,5.501307 45.078628,5.500625 45.079143,5.500526 45.079641,5.500631 45.080359,5.501184 45.082278,5.50205 45.084324,5.502086 45.084953,5.501984 45.085406,5.50244 45.086107,5.502381 45.086137,5.502207 45.086424,5.501871 45.087089,5.501731 45.087506,5.501803 45.087801,5.501749 45.08825,5.501536 45.08857,5.501413 45.08883,5.50139 45.088983,5.501608 45.089236,5.501636 45.089395,5.501508 45.089823,5.501499 45.089962,5.501611 45.090169,5.501626 45.090313,5.501353 45.090777,5.500983 45.091157,5.500678 45.091581,5.500405 45.091747,5.500286 45.092026,5.499343 45.091693,5.499209 45.091562,5.499119 45.091114,5.499053 45.091071,5.497922 45.091284,5.49749 45.091521,5.496947 45.092032,5.495737 45.094451,5.494857 45.095737,5.494224 45.096917,5.49385 45.098367,5.493216 45.099511,5.495947 45.099487,5.49684 45.099552,5.500714 45.099486,5.502499 45.09958,5.503656 45.099817,5.506046 45.100643,5.506071 45.100755,5.506215 45.100821,5.506838 45.100958,5.507478 45.101038,5.508249 45.101077,5.508535 45.100953,5.508722 45.100993,5.509067 45.101186,5.509224 45.101451,5.509297 45.101513,5.509609 45.101644,5.509728 45.101738,5.509841 45.101906,5.511637 45.101578,5.51246 45.101489,5.512971 45.101527,5.513288 45.101519,5.513498 45.10155,5.514091 45.101551,5.514534 45.101591,5.514264 45.101695,5.514657 45.101805,5.515117 45.101958,5.515307 45.101999,5.515861 45.10201,5.516146 45.102042,5.51664 45.102059,5.517318 45.101866,5.518012 45.101559,5.518734 45.101348,5.519046 45.101232,5.519573 45.100968,5.521042 45.100572,5.521426 45.100526,5.523125 45.100436,5.524137 45.100331,5.524534 45.100239,5.524966 45.100183,5.525088 45.100122,5.525327 45.100301,5.525542 45.100366,5.525713 45.100337,5.526077 45.100383,5.526319 45.100453,5.526934 45.100687,5.527407 45.100953,5.527606 45.101153,5.527897 45.101087,5.528224 45.100963,5.528595 45.100963,5.528793 45.100992,5.529011 45.101084,5.529219 45.101302,5.529508 45.101449,5.52979 45.101482,5.530768 45.101494,5.531137 45.10151,5.531861 45.101661,5.532015 45.101616,5.531989 45.101489,5.53214 45.101372,5.532555 45.101237,5.532637 45.101126,5.532927 45.100995,5.533005 45.100836,5.533396 45.100453,5.533587 45.100371,5.533823 45.100359,5.534274 45.10046,5.534589 45.10045,5.535419 45.100177,5.535793 45.099909,5.535914 45.099776,5.535986 45.099609,5.536106 45.09911,5.536227 45.099016,5.537988 45.098696,5.539259 45.098612,5.53933 45.098586,5.540382 45.098574,5.542306 45.09818,5.543245 45.097928,5.543816 45.097842,5.544383 45.097712,5.545838 45.097417,5.547032 45.097158,5.54892 45.096834,5.548977 45.096777,5.549588 45.096676,5.550329 45.096472,5.551531 45.096282,5.553688 45.095825,5.556501 45.09535,5.557362 45.095114,5.558423 45.094942,5.561267 45.094297,5.563719 45.093776,5.564778 45.093562,5.567097 45.093129,5.569583 45.092563,5.574577 45.091757,5.575715 45.091428,5.577145 45.091077,5.578814 45.090747,5.582831 45.089929,5.585212 45.089373,5.585584 45.089353,5.58622 45.089208,5.588098 45.088872,5.590295 45.088413,5.592573 45.087994,5.594827 45.087492,5.597162 45.086988,5.599461 45.086582,5.602045 45.085957,5.604792 45.085384,5.607383 45.084872,5.609852 45.084321,5.613577 45.083568,5.613461 45.083291,5.61346 45.083101,5.613095 45.0825,5.612932 45.082307,5.612467 45.08207,5.612271 45.081925,5.612007 45.081306,5.61199 45.081219,5.611378 45.081113,5.61128 45.080531,5.610453 45.07943,5.610292 45.07885,5.609766 45.078549,5.609245 45.078115,5.60909 45.077625,5.608448 45.076428,5.608484 45.075977,5.608077 45.075539,5.607987 45.075091,5.608175 45.07396,5.608198 45.073059,5.607862 45.071673,5.606705 45.070348,5.606068 45.069242,5.604662 45.067798,5.603808 45.066248,5.603476 45.065987,5.602525 45.064934,5.601782 45.064182,5.601036 45.063169,5.600743 45.062502,5.6008 45.061286,5.600512 45.059628,5.600139 45.058469,5.599283 45.056873,5.59908 45.056655,5.598792 45.056078,5.598246 45.055418,5.597889 45.054754,5.59755 45.054404,5.596998 45.05342,5.597111 45.052816,5.597223 45.052693,5.597195 45.052608,5.597273 45.05235,5.596845 45.051894,5.596589 45.050777,5.596558 45.050238,5.596249 45.049301,5.595636 45.048374,5.595074 45.046365,5.594934 45.046144,5.59487 45.045066,5.594501 45.044176,5.594292 45.043642,5.594023 45.0423,5.594348 45.041345,5.594304 45.040581,5.594088 45.040137,5.593704 45.038798,5.593099 45.038222,5.593009 45.037774,5.592856 45.037328,5.592679 45.036478,5.592469 45.036125,5.592445 45.03572,5.592292 45.035274,5.591962 45.035059,5.591999 45.034608,5.592168 45.034243,5.592287 45.033879,5.592086 45.033705,5.591935 45.033304,5.592105 45.032939,5.592268 45.032485,5.591875 45.03227,5.591537 45.03192,5.591337 45.030666,5.590764 45.029557,5.590554 45.029204,5.590463 45.028531,5.589919 45.026837,5.5895 45.026174,5.589326 45.02536,5.588339 45.023453,5.58731 45.022133,5.586958 45.021558,5.586901 45.020569,5.586705 45.020485,5.586321 45.020406,5.585802 45.020241,5.585273 45.019851,5.58545 45.019621,5.586184 45.01915,5.586247 45.018922,5.58583 45.018305,5.585452 45.017281,5.584783 45.01667,5.584558 45.016092,5.584629 45.015135,5.58446 45.01442,5.583431 45.013955,5.582832 45.013478,5.582455 45.013533,5.581763 45.013869,5.581513 45.013921,5.581246 45.013478,5.580705 45.012909,5.579938 45.011717,5.580115 45.011486,5.580157 45.011125,5.579941 45.010681,5.579712 45.010012,5.579752 45.009606,5.579965 45.008925,5.579822 45.008434,5.57855 45.007292,5.578411 45.007071,5.578583 45.00675,5.579554 45.006002,5.579782 45.005545,5.579787 45.004555,5.579507 45.004113,5.579259 45.003985,5.578492 45.003872,5.577022 45.00369,5.577006 45.003421,5.577698 45.002231,5.577791 45.001642,5.577443 45.001112,5.57691 45.000678,5.57586 45.000079,5.575538 44.999998,5.575361 45.000228,5.575512 45.001277,5.575152 45.001582,5.574437 45.001548,5.573588 45.001396,5.573161 45.001679,5.571734 45.003132,5.570951 45.003309,5.569858 45.00327,5.569395 45.003496,5.568571 45.003704,5.567813 45.004518,5.567631 45.00454,5.56745 45.004657,5.567048 45.004773,5.566733 45.004688,5.566205 45.004924,5.56602 45.004798,5.565735 45.00483,5.565533 45.004915,5.564171 45.00493,5.563789 45.004911,5.563641 45.005144,5.562681 45.006072,5.561965 45.007083,5.560831 45.008331,5.560643 45.009195,5.560174 45.009348,5.559983 45.009314,5.559832 45.009711,5.558754 45.010822,5.55798 45.011917,5.556691 45.014758,5.55653 45.01505,5.555964 45.01592,5.555725 45.016194,5.555435 45.016434,5.555333 45.01648,5.555232 45.016628,5.554539 45.017742,5.554274 45.018223,5.554052 45.018515,5.553877 45.018665,5.553731 45.018964,5.553424 45.019231,5.553182 45.019389,5.552718 45.019768,5.552383 45.019909,5.55217 45.019954,5.551798 45.019984,5.551563 45.020087,5.55146 45.020177,5.551455 45.020317,5.551239 45.02089,5.551009 45.021301,5.549879 45.02264,5.549128 45.022876,5.549411 45.023145,5.549483 45.023277,5.5495 45.023653,5.549534 45.023861,5.5493 45.024189,5.54884 45.024638,5.548613 45.024963,5.548352 45.02519,5.548159 45.025309,5.547738 45.025494,5.547437 45.025707,5.547302 45.025865,5.547259 45.025989,5.547361 45.026386,5.547349 45.02661,5.547228 45.027087,5.547234 45.027232,5.547358 45.027647,5.547334 45.027787,5.547241 45.027949,5.546997 45.028235,5.546944 45.028401,5.546952 45.028686,5.546654 45.029317,5.546714 45.030356,5.546403 45.030464,5.545819 45.031029,5.545392 45.03152,5.544831 45.031775,5.544033 45.032038,5.543633 45.032316,5.543514 45.032671,5.543445 45.033194,5.542949 45.033684,5.543275 45.034255,5.542971 45.034652,5.543062 45.034769,5.543257 45.034893,5.543622 45.034996,5.543569 45.03517,5.543337 45.035346,5.543316 45.035489,5.543464 45.035744,5.543624 45.035876,5.543855 45.036015,5.543884 45.036114,5.543893 45.036608,5.543922 45.037155,5.543922 45.037835,5.543972 45.038076,5.543921 45.038466,5.543954 45.038693,5.543966 45.039044,5.54392 45.039278,5.543866 45.039829,5.543782 45.040068,5.54348 45.040526,5.54324 45.04078,5.542569 45.04137,5.542318 45.041611,5.542031 45.041837,5.541858 45.041862,5.541252 45.042371,5.54034 45.043072,5.54016 45.043258,5.538758 45.044468,5.538094 45.045064,5.53523 45.047172,5.532552 45.04941,5.532 45.049741,5.529991 45.051276,5.529815 45.051506,5.528284 45.05272,5.526386 45.054061,5.526198 45.05379,5.525846 45.053389,5.525628 45.053169,5.524957 45.052568,5.524411 45.052123,5.524183 45.051904,5.524073 45.051728,5.523602 45.05191,5.523513 45.052588,5.522763 45.05278,5.521642 45.053172,5.520846 45.05369,5.519421 45.054316,5.517854 45.054677,5.516424 45.055213,5.515791 45.055231,5.515009 45.054884,5.51282 45.054362,5.508403 45.053759,5.506798 45.053445,5.505565 45.052985,5.505291 45.052632,5.504234 45.051898,5.503645 45.051599,5.502849 45.050992,5.501509 45.050073,5.501437 45.04976,5.50136 45.049553,5.501339 45.049064,5.501195 45.048862,5.501141 45.048694,5.50114 45.048544,5.501028 45.04835,5.500376 45.047759,5.500194 45.04768,5.500039 45.047556,5.499998 45.047428,5.499977 45.047134,5.499842 45.046566,5.499761 45.04642,5.499539 45.046245,5.49948 45.046087,5.499621 45.045359,5.499775 45.043892,5.4994 45.042551,5.499729 45.040996,5.499783 45.039841,5.499909 45.038824,5.499547 45.038024,5.499374 45.037219,5.499453 45.036361,5.499094 45.035651,5.499769 45.034846,5.499656 45.034853,5.499205 45.034755,5.498524 45.034432,5.495994 45.034696,5.492646 45.035016,5.489287 45.035102,5.488848 45.035205,5.486505 45.035317,5.485307 45.035441,5.485329 45.03472,5.485037 45.034044,5.484855 45.032834,5.485005 45.032109,5.485357 45.031604,5.485971 45.031235,5.486265 45.030823,5.486173 45.029195,5.485917 45.027807,5.485401 45.026562,5.48478 45.02568,5.484879 45.025181,5.484783 45.024599,5.484436 45.024068,5.483743 45.022828,5.483614 45.022787,5.477105 45.024627,5.476047 45.025018,5.476562 45.027614,5.477062 45.027847,5.476965 45.028217,5.476964 45.028308,5.477073 45.028869,5.477156 45.029173,5.477254 45.02995,5.477445 45.030661,5.477526 45.030872,5.477733 45.031183,5.477808 45.03153,5.477845 45.0324,5.477886 45.032587,5.478102 45.032789,5.478466 45.033053,5.478032 45.033648,5.477381 45.034477,5.471214 45.039063,5.46809 45.041303,5.466203 45.042752,5.465468 45.043223,5.465232 45.043544,5.464981 45.044722,5.464846 45.045941,5.465094 45.046969,5.465457 45.047769,5.465505 45.048622,5.465216 45.049126,5.465193 45.049846,5.465525 45.050107,5.465729 45.050371,5.465757 45.051091,5.465971 45.05149,5.466041 45.052749,5.466221 45.053689,5.466941 45.055199,5.468014 45.056437,5.469046 45.057849,5.469261 45.058293,5.469953 45.059309,5.470676 45.059738,5.470704 45.060232,5.470468 45.060555,5.470618 45.060955,5.470971 45.062926,5.471371 45.063275,5.471632 45.063403,5.472684 45.064057,5.473702 45.065198,5.474331 45.066215,5.474653 45.067647,5.474868 45.070342,5.476515 45.071601,5.477364 45.072026,5.478573 45.072046,5.479783 45.072102,5.480884 45.072475,5.48167 45.072904,5.482319 45.073155,5.483656 45.073207,5.483707 45.072981,5.483898 45.072975,5.48486 45.073137,5.48727 45.073069,5.487972 45.073139,5.489683 45.073045,5.489941 45.073127,5.490449 45.073113,5.492054 45.072087,5.492414 45.071716,5.493201 45.071019,5.493386 45.070923,5.494052 45.071446,5.494217 45.071744)))'), 4326)) AS poly) z
WHERE m.geom IS NOT NULL
  AND m.osm_type IN ('way', 'relation')
  AND ST_Intersects(m.geom, z.poly)
  AND (exist(tags, 'highway') OR (tags->'railway') = 'rail');