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 = '08122' 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 = 27309 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 = 27309;

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

"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:25', 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 = 27309;

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

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.795128 50.128507,4.795281 50.128504,4.796426 50.126505,4.79656 50.126368,4.797049 50.126248,4.796882 50.126007,4.796531 50.125363,4.796266 50.124711,4.796069 50.123956,4.795965 50.123505,4.795832 50.122535,4.796003 50.121322,4.796135 50.120614,4.796432 50.119844,4.797192 50.118368,4.798006 50.116934,4.79847 50.116073,4.79926 50.116147,4.800573 50.115842,4.802045 50.11516,4.802282 50.115043,4.80251 50.114983,4.802757 50.114846,4.803106 50.114761,4.803648 50.114478,4.806971 50.113594,4.808069 50.112899,4.80885 50.112621,4.809131 50.112559,4.808683 50.112213,4.807972 50.111166,4.807733 50.110929,4.808901 50.110737,4.80915 50.110657,4.809059 50.110371,4.808325 50.108753,4.80839 50.108662,4.808663 50.108521,4.809273 50.108149,4.809574 50.107156,4.809968 50.106654,4.81041 50.10626,4.811189 50.10591,4.81117 50.105543,4.811788 50.105306,4.812117 50.104895,4.812264 50.104526,4.812574 50.104133,4.813173 50.104058,4.813674 50.103921,4.813996 50.103855,4.814363 50.103727,4.814575 50.103419,4.814943 50.102999,4.815379 50.102393,4.815588 50.101673,4.815307 50.101633,4.815301 50.101498,4.81555 50.100865,4.81618 50.100923,4.816391 50.100915,4.818106 50.100955,4.818961 50.099566,4.819141 50.099139,4.819314 50.097906,4.81909 50.097331,4.819124 50.096831,4.818903 50.095264,4.818939 50.093414,4.818103 50.093454,4.817335 50.093233,4.815542 50.092646,4.81523 50.09259,4.815814 50.092319,4.815815 50.090918,4.81606 50.090153,4.816441 50.089737,4.816789 50.08973,4.817207 50.089431,4.818384 50.088082,4.819307 50.088144,4.822182 50.088399,4.822031 50.088178,4.821233 50.087566,4.819073 50.086487,4.818787 50.086358,4.817917 50.085703,4.817257 50.084848,4.816889 50.083646,4.816153 50.082488,4.815355 50.081245,4.815069 50.080542,4.814533 50.080275,4.813794 50.080173,4.813783 50.07994,4.814111 50.079529,4.815126 50.07928,4.815203 50.078854,4.815111 50.078607,4.816688 50.078737,4.817174 50.078739,4.817352 50.078286,4.816601 50.07803,4.816081 50.077809,4.815635 50.077596,4.815233 50.077363,4.814876 50.07709,4.814591 50.076826,4.81444 50.07651,4.814402 50.076017,4.814723 50.075674,4.815192 50.075114,4.815523 50.074818,4.816019 50.074247,4.816492 50.073764,4.816704 50.073527,4.816713 50.07334,4.816624 50.073071,4.816509 50.0729,4.816327 50.072237,4.816205 50.071863,4.815626 50.071097,4.81546 50.070781,4.815447 50.070502,4.815538 50.07023,4.815657 50.06957,4.815402 50.068957,4.815372 50.068678,4.815561 50.068249,4.815941 50.06771,4.816187 50.067521,4.816565 50.067281,4.817127 50.067115,4.817433 50.066945,4.817749 50.066639,4.818232 50.066368,4.818685 50.066209,4.819664 50.066063,4.819262 50.066085,4.819152 50.066036,4.819884 50.065614,4.820344 50.065592,4.820931 50.065229,4.821855 50.064618,4.822125 50.064213,4.821903 50.063995,4.821646 50.063833,4.821221 50.063661,4.821171 50.063429,4.821264 50.063302,4.821256 50.063192,4.8211 50.06294,4.820912 50.06277,4.820629 50.062578,4.820234 50.062363,4.82013 50.062356,4.819729 50.062153,4.819635 50.061896,4.819466 50.061829,4.819143 50.06161,4.819084 50.061514,4.81905 50.061234,4.81928 50.060921,4.81954 50.060682,4.819675 50.060625,4.819255 50.060403,4.818991 50.06039,4.818748 50.060463,4.818214 50.060707,4.817669 50.060749,4.816946 50.060746,4.816598 50.060728,4.816 50.060666,4.815305 50.060649,4.815029 50.060659,4.814128 50.060645,4.812635 50.060684,4.811901 50.060599,4.811513 50.060525,4.810918 50.060346,4.810424 50.059971,4.810068 50.059637,4.80929 50.058958,4.808441 50.058566,4.807624 50.058236,4.806707 50.058015,4.806034 50.057889,4.805308 50.057794,4.804902 50.057775,4.80412 50.057564,4.803689 50.057428,4.803063 50.057148,4.802176 50.05663,4.801534 50.056368,4.801069 50.056197,4.800327 50.056835,4.79933 50.057067,4.799143 50.057214,4.798695 50.057323,4.798364 50.057546,4.798061 50.058012,4.797036 50.058437,4.795757 50.058535,4.79445 50.058748,4.793932 50.058736,4.793863 50.058946,4.793984 50.059461,4.794038 50.059614,4.794197 50.059893,4.794458 50.060171,4.795037 50.060898,4.795137 50.061093,4.795758 50.061799,4.795804 50.062555,4.795403 50.063486,4.795301 50.063751,4.795013 50.06423,4.79452 50.064839,4.793035 50.066529,4.792389 50.067619,4.792259 50.067801,4.791458 50.069712,4.791138 50.070303,4.790963 50.07098,4.790102 50.073377,4.789895 50.074872,4.789593 50.075698,4.789444 50.0764,4.789188 50.077116,4.78917 50.077353,4.788988 50.077745,4.787434 50.080832,4.786433 50.082393,4.786141 50.083198,4.786366 50.084627,4.786715 50.085146,4.786436 50.085259,4.785323 50.085828,4.783791 50.086849,4.78294 50.087704,4.781951 50.089119,4.781631 50.09002,4.781423 50.090917,4.781294 50.092012,4.781327 50.092909,4.781515 50.093712,4.782269 50.094436,4.783345 50.095085,4.784853 50.095695,4.78608 50.09647,4.786821 50.09734,4.78757 50.098422,4.788287 50.099251,4.789344 50.100251,4.7903 50.100858,4.790963 50.101334,4.79112 50.101577,4.791295 50.102308,4.791382 50.103632,4.791223 50.104939,4.792142 50.105317,4.793102 50.106419,4.793192 50.106822,4.793068 50.107139,4.792242 50.107494,4.792309 50.107637,4.7923 50.107954,4.792085 50.108319,4.791797 50.10866,4.791234 50.109177,4.790411 50.109686,4.789205 50.111167,4.786813 50.113407,4.785342 50.11441,4.785901 50.114854,4.785347 50.115178,4.78538 50.11537,4.785175 50.115775,4.784927 50.116344,4.784994 50.116677,4.783058 50.117468,4.782114 50.118366,4.780504 50.11965,4.7795 50.120574,4.779122 50.120455,4.77873 50.1203,4.778229 50.120191,4.777644 50.120121,4.77737 50.12006,4.777232 50.120088,4.777105 50.120265,4.777943 50.1207,4.778843 50.121062,4.780257 50.12162,4.782584 50.122473,4.783966 50.123148,4.785462 50.123942,4.786352 50.124341,4.78687 50.124639,4.787542 50.124906,4.78792 50.125098,4.790681 50.126552,4.791535 50.126833,4.793195 50.127558,4.795128 50.128507)))'), 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');