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 = '26324' 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 = 27452 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 = 27452;

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

"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 02:00:26', 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 = 27452;

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

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(((4.778042 44.372627,4.778342 44.372673,4.778781 44.372652,4.779794 44.372623,4.780463 44.372556,4.780846 44.372542,4.782211 44.372246,4.783039 44.372098,4.785027 44.371716,4.785573 44.371627,4.785633 44.371754,4.785889 44.371699,4.787305 44.371347,4.787953 44.371193,4.788863 44.370961,4.787228 44.367828,4.787041 44.367759,4.786476 44.367471,4.786108 44.367246,4.785983 44.36714,4.785898 44.36698,4.785153 44.364924,4.785212 44.364678,4.785582 44.363338,4.78481 44.362861,4.784673 44.362875,4.785927 44.362084,4.786319 44.361902,4.786582 44.361757,4.787561 44.361188,4.789526 44.358667,4.792212 44.358194,4.792256 44.357559,4.792006 44.357083,4.791738 44.35676,4.791406 44.356396,4.792105 44.356626,4.792606 44.356839,4.793227 44.356998,4.793473 44.357077,4.795777 44.355958,4.79662 44.356547,4.797442 44.357071,4.797629 44.35705,4.80143 44.356305,4.803313 44.354895,4.801707 44.354405,4.801378 44.354229,4.800901 44.354082,4.80046 44.353889,4.800307 44.353802,4.798672 44.349861,4.797717 44.347623,4.797416 44.347498,4.797364 44.347435,4.796585 44.346802,4.796099 44.346431,4.795627 44.346129,4.795257 44.345969,4.793648 44.345225,4.793432 44.345147,4.792989 44.344916,4.791243 44.343612,4.79088 44.343203,4.790802 44.343093,4.790731 44.342835,4.7907 44.342454,4.790568 44.342139,4.790352 44.341985,4.790406 44.341698,4.790361 44.341568,4.789824 44.341586,4.788959 44.341661,4.787741 44.3417,4.786845 44.341708,4.786028 44.341772,4.785573 44.34185,4.785212 44.341212,4.785091 44.341108,4.785161 44.341041,4.784907 44.340648,4.784352 44.339668,4.783621 44.338898,4.782962 44.337803,4.782703 44.337298,4.782579 44.336971,4.782357 44.336659,4.782247 44.336554,4.778617 44.335858,4.777205 44.33768,4.771042 44.338769,4.770478 44.337823,4.770213 44.337222,4.770031 44.336869,4.769874 44.336235,4.769768 44.336023,4.769432 44.335702,4.769264 44.335619,4.769021 44.335605,4.768804 44.335533,4.768538 44.335235,4.768353 44.335074,4.767536 44.334642,4.767243 44.334058,4.76714 44.333826,4.767008 44.333682,4.766471 44.33299,4.766051 44.33248,4.765785 44.33213,4.765495 44.332005,4.765013 44.331892,4.764657 44.33174,4.764591 44.331592,4.764702 44.331138,4.764839 44.330024,4.764824 44.32962,4.764665 44.329242,4.764472 44.328913,4.764406 44.328733,4.764049 44.328147,4.763829 44.327488,4.763795 44.32726,4.763638 44.326832,4.763578 44.326598,4.763486 44.326404,4.763214 44.32612,4.763144 44.325927,4.763045 44.325787,4.762932 44.325524,4.762135 44.325476,4.761359 44.325401,4.760867 44.32539,4.760621 44.325346,4.760127 44.325327,4.759934 44.325292,4.759621 44.325284,4.759145 44.325238,4.758606 44.325246,4.757604 44.32522,4.756884 44.325211,4.756376 44.325221,4.756085 44.325199,4.75582 44.325205,4.755253 44.325185,4.754599 44.325175,4.75354 44.325181,4.753317 44.32517,4.752541 44.325174,4.751844 44.325154,4.750854 44.325144,4.749813 44.32521,4.748793 44.32526,4.74809 44.32528,4.747325 44.325326,4.746038 44.325357,4.743887 44.32561,4.743039 44.32569,4.742704 44.325647,4.742246 44.325453,4.742011 44.325417,4.741606 44.325431,4.740936 44.325481,4.740699 44.325543,4.739864 44.325639,4.733742 44.326193,4.732519 44.326242,4.732185 44.326233,4.730048 44.326287,4.725539 44.32635,4.723721 44.326369,4.722671 44.326388,4.721964 44.326427,4.721535 44.326524,4.721342 44.326732,4.721148 44.326898,4.720756 44.327286,4.720547 44.327547,4.720224 44.32815,4.720086 44.329159,4.72009 44.330022,4.720105 44.330254,4.720354 44.330759,4.720388 44.330999,4.720373 44.331781,4.720383 44.332681,4.720486 44.333773,4.720512 44.334282,4.720933 44.335144,4.721031 44.335452,4.721164 44.335639,4.721835 44.336294,4.722251 44.336609,4.723033 44.336937,4.724499 44.337643,4.725407 44.338121,4.725977 44.338603,4.726234 44.338856,4.726522 44.339303,4.726577 44.339487,4.726761 44.340908,4.726798 44.343285,4.72858 44.343722,4.728379 44.345589,4.72895 44.346789,4.726884 44.349249,4.726894 44.352007,4.727449 44.35199,4.728689 44.351904,4.729996 44.352802,4.729492 44.356034,4.729393 44.356639,4.729281 44.356958,4.729272 44.357558,4.729312 44.35784,4.729431 44.358101,4.729646 44.3585,4.730506 44.358528,4.730412 44.359115,4.730392 44.359819,4.730324 44.36029,4.730318 44.360737,4.729881 44.361345,4.729457 44.361983,4.729401 44.362504,4.729422 44.362731,4.7292 44.363116,4.728873 44.363517,4.728657 44.363935,4.728501 44.364305,4.728488 44.364535,4.728696 44.365092,4.728855 44.365705,4.72902 44.366283,4.729105 44.366529,4.729175 44.366937,4.729152 44.367089,4.729007 44.367215,4.728983 44.367628,4.729029 44.367896,4.729025 44.368321,4.728987 44.368503,4.728863 44.368708,4.728861 44.368813,4.728737 44.369372,4.733274 44.367995,4.733874 44.367854,4.735163 44.367478,4.735652 44.367299,4.73596 44.367213,4.736317 44.367173,4.736909 44.367178,4.737267 44.367221,4.737816 44.367322,4.73801 44.367336,4.739267 44.367304,4.740115 44.36726,4.740188 44.367209,4.740754 44.367141,4.74113 44.367081,4.74153 44.367066,4.742245 44.367118,4.742566 44.367199,4.742768 44.367149,4.743009 44.367134,4.743282 44.36702,4.743374 44.36682,4.743478 44.366306,4.743615 44.366064,4.743986 44.365751,4.744126 44.365593,4.744459 44.365157,4.744489 44.36508,4.744751 44.364833,4.745151 44.364415,4.745265 44.364174,4.74547 44.36392,4.745649 44.363738,4.746024 44.363537,4.746186 44.363492,4.746689 44.363465,4.746989 44.363507,4.747186 44.363436,4.747496 44.363231,4.747846 44.363063,4.748539 44.362896,4.749141 44.36271,4.749715 44.362556,4.75005 44.362385,4.750254 44.36217,4.750332 44.36213,4.750518 44.362194,4.75086 44.362432,4.751095 44.362626,4.75127 44.362838,4.75166 44.363199,4.752021 44.36346,4.75236 44.363656,4.752835 44.363803,4.753053 44.363948,4.753184 44.364134,4.753567 44.364738,4.753633 44.364912,4.753624 44.365094,4.753505 44.365869,4.753553 44.366147,4.753687 44.366311,4.753994 44.366421,4.754508 44.36656,4.754835 44.366843,4.755133 44.367055,4.755393 44.3673,4.755482 44.36778,4.755786 44.368732,4.755829 44.368793,4.756112 44.368944,4.756598 44.36923,4.756974 44.369428,4.757422 44.369686,4.758069 44.370087,4.758178 44.370111,4.758567 44.370061,4.759116 44.369953,4.759339 44.369951,4.759825 44.369996,4.761384 44.370109,4.761579 44.370102,4.762109 44.369876,4.762362 44.369798,4.763176 44.369702,4.763443 44.36965,4.763737 44.36953,4.764575 44.369093,4.764992 44.368916,4.765215 44.368883,4.765803 44.36889,4.766161 44.368924,4.766881 44.368953,4.767811 44.368968,4.768732 44.368996,4.769319 44.368906,4.769855 44.368761,4.770099 44.368796,4.770564 44.368943,4.771032 44.369129,4.772178 44.369603,4.772618 44.369799,4.774307 44.370799,4.775054 44.371205,4.775681 44.371508,4.776994 44.372115,4.777948 44.372594,4.778042 44.372627)))'), 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');