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 = '13059' 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 = 27395 AND c0_.name IN ('train_station_count', 'train_station_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 = '13059';

"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\":\"train_station\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-15 07:04:45', 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 = 27395;

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

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 = 27395 AND z0_.theme = 'train_station' 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
  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'13059'') = ?
  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'13059'') = ?
      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 = '13059';

SELECT
  osm_type,
  osm_id :: text AS osm_id,
  ST_Y(
    ST_Centroid(geom)
  ) AS lat,
  ST_X(
    ST_Centroid(geom)
  ) AS lon,
  tags :: jsonb AS tags_json,
  version,
  osm_timestamp,
  changeset,
  osm_user,
  uid :: bigint AS uid
FROM
  osm_object_meta m
WHERE
  geom IS NOT NULL
  AND ST_Intersects(
    m.geom,
    ST_GeomFromText(?, 4326)
  )
  AND (
    (tags -> 'railway') IN ('station', 'halt')
    OR (
      (tags -> 'public_transport') = 'station'
      AND (tags -> 'train') = 'yes'
    )
  )

SELECT osm_type, osm_id::text AS osm_id, ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,
            tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid
            FROM osm_object_meta m
            WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText('MULTIPOLYGON(((5.549876 43.659804,5.548881 43.65696,5.546842 43.651145,5.5466 43.650552,5.545739 43.648039,5.545626 43.647733,5.545555 43.647449,5.545389 43.646911,5.545264 43.646583,5.544742 43.645124,5.544576 43.644773,5.54442 43.644375,5.544165 43.643777,5.543847 43.643118,5.543796 43.64311,5.543674 43.642665,5.543469 43.642059,5.543275 43.640797,5.543102 43.640176,5.544416 43.638211,5.544693 43.637242,5.541119 43.634815,5.541398 43.634607,5.541486 43.634487,5.541511 43.634177,5.541395 43.633663,5.540615 43.632938,5.540895 43.632242,5.539806 43.63168,5.539587 43.631018,5.539452 43.630748,5.539282 43.630518,5.538996 43.630322,5.538894 43.630177,5.538825 43.6299,5.538641 43.629659,5.538593 43.629507,5.538772 43.629404,5.53892 43.629024,5.538959 43.628851,5.539038 43.628808,5.539292 43.628524,5.539547 43.628434,5.539802 43.628285,5.53991 43.628119,5.540241 43.628065,5.540662 43.628102,5.540903 43.628067,5.541034 43.628002,5.541202 43.627717,5.541196 43.627607,5.541361 43.627367,5.541382 43.627201,5.541604 43.62712,5.542697 43.626851,5.542869 43.626604,5.543076 43.626448,5.543368 43.62629,5.543483 43.62616,5.543633 43.625918,5.543739 43.625651,5.544095 43.625347,5.544703 43.625122,5.545038 43.624931,5.545219 43.624731,5.545449 43.624613,5.545704 43.624432,5.545928 43.624347,5.545902 43.624097,5.545993 43.623646,5.545957 43.62339,5.545971 43.623232,5.546165 43.62273,5.546086 43.622541,5.545752 43.622416,5.545358 43.622091,5.545064 43.621962,5.544999 43.621872,5.544932 43.62145,5.544978 43.621238,5.545096 43.621148,5.545454 43.621005,5.545568 43.620937,5.545823 43.620433,5.545963 43.620274,5.546165 43.620165,5.54632 43.620032,5.546426 43.619736,5.546663 43.619471,5.546757 43.618863,5.546568 43.618481,5.54645 43.618088,5.546306 43.61749,5.546285 43.617254,5.546354 43.616859,5.546401 43.616706,5.546575 43.616422,5.546936 43.616042,5.546986 43.615954,5.547396 43.614722,5.547526 43.614097,5.547543 43.613865,5.547469 43.613041,5.547516 43.612815,5.547615 43.612639,5.547731 43.611927,5.54746 43.611052,5.548733 43.610146,5.548863 43.609997,5.549033 43.609921,5.549877 43.609656,5.550153 43.609608,5.55032 43.609472,5.550546 43.608927,5.55064 43.608747,5.551386 43.607458,5.551929 43.606934,5.552 43.606809,5.55207 43.60623,5.552108 43.6058,5.552255 43.605079,5.55247 43.604805,5.552639 43.604657,5.552903 43.604496,5.552742 43.604013,5.552955 43.603474,5.55406 43.603416,5.554388 43.603335,5.554721 43.60322,5.555622 43.602456,5.555859 43.602347,5.55609 43.602165,5.558671 43.603328,5.559115 43.602886,5.559276 43.60277,5.559564 43.602473,5.559786 43.60212,5.559898 43.601994,5.559969 43.601775,5.56028 43.601408,5.560438 43.601195,5.560758 43.600842,5.560851 43.600694,5.561066 43.60044,5.561399 43.600209,5.561749 43.600009,5.562373 43.599724,5.562483 43.59954,5.562838 43.599557,5.563787 43.599559,5.564331 43.599518,5.564698 43.599521,5.565002 43.599401,5.565359 43.599302,5.565727 43.599109,5.566108 43.599069,5.567211 43.59901,5.56728 43.599014,5.568518 43.598905,5.570668 43.598458,5.570852 43.598253,5.570665 43.59778,5.570576 43.597673,5.570325 43.597483,5.570189 43.597257,5.570139 43.597095,5.570193 43.596985,5.57075 43.59636,5.571366 43.595961,5.571871 43.595701,5.572079 43.595616,5.572532 43.595486,5.572952 43.595387,5.573225 43.595185,5.573361 43.595118,5.57395 43.594894,5.574618 43.594551,5.574863 43.594497,5.575516 43.594433,5.576042 43.594323,5.576901 43.594161,5.57711 43.5941,5.577915 43.593805,5.578474 43.593706,5.578741 43.593612,5.579318 43.593496,5.57988 43.593249,5.580127 43.593178,5.580457 43.593026,5.580727 43.592643,5.581087 43.592293,5.581251 43.592165,5.581635 43.591952,5.581812 43.591809,5.581974 43.59163,5.582129 43.591524,5.582272 43.591516,5.582721 43.591578,5.582865 43.591555,5.583511 43.591343,5.583977 43.591219,5.584259 43.591119,5.58534 43.590858,5.585657 43.590745,5.586035 43.590641,5.587052 43.59051,5.587648 43.590378,5.587644 43.589977,5.587585 43.589868,5.58619 43.589245,5.585755 43.589028,5.585263 43.588707,5.585105 43.588581,5.584866 43.588456,5.584599 43.588408,5.584416 43.588336,5.583325 43.588063,5.582582 43.587835,5.581785 43.587516,5.581435 43.587403,5.581082 43.587358,5.580004 43.587127,5.579294 43.586861,5.579026 43.586746,5.57884 43.586698,5.578526 43.586679,5.578086 43.586546,5.577839 43.586443,5.577466 43.586372,5.576974 43.586237,5.576641 43.58601,5.576395 43.585935,5.575676 43.585673,5.57515 43.585506,5.574669 43.585231,5.574355 43.585108,5.573829 43.58486,5.573389 43.58454,5.572962 43.584318,5.572034 43.583758,5.571763 43.583545,5.569945 43.58287,5.568917 43.582598,5.568167 43.58242,5.567678 43.582275,5.566824 43.582073,5.565642 43.581824,5.565055 43.581711,5.564673 43.581612,5.563835 43.581471,5.563499 43.581339,5.563293 43.58112,5.562978 43.580911,5.562694 43.580612,5.5623 43.5804,5.56223 43.580245,5.562243 43.579904,5.562053 43.579742,5.561931 43.579526,5.561626 43.579324,5.561346 43.579084,5.56107 43.578884,5.560967 43.578609,5.560784 43.578465,5.56061 43.578421,5.560113 43.578357,5.559784 43.578357,5.559594 43.578473,5.559134 43.578937,5.558915 43.579103,5.558279 43.579412,5.557823 43.579577,5.557628 43.579614,5.557458 43.579689,5.556936 43.579857,5.556269 43.579942,5.555774 43.579956,5.55538 43.579947,5.554577 43.579736,5.554257 43.579612,5.554188 43.579541,5.553582 43.579369,5.552294 43.578903,5.552108 43.578794,5.551555 43.578552,5.551171 43.578269,5.550967 43.578178,5.550786 43.578181,5.550395 43.578271,5.549646 43.578266,5.549263 43.578313,5.548629 43.578297,5.548432 43.578325,5.548063 43.578518,5.547789 43.578724,5.547635 43.578955,5.547609 43.579154,5.547754 43.579408,5.548088 43.579723,5.548155 43.579864,5.548115 43.580067,5.547774 43.58052,5.547422 43.581044,5.547191 43.581252,5.546834 43.581408,5.546491 43.581493,5.546066 43.581632,5.545533 43.581704,5.544479 43.58171,5.54396 43.581675,5.5438 43.581578,5.543433 43.581284,5.543379 43.580932,5.543269 43.580855,5.54282 43.580732,5.542568 43.580723,5.542156 43.580778,5.541867 43.580888,5.541532 43.581074,5.541043 43.581213,5.540779 43.581445,5.540496 43.581574,5.539932 43.581682,5.539323 43.581742,5.538234 43.581724,5.537859 43.581666,5.537491 43.58167,5.537052 43.581712,5.536712 43.581677,5.536521 43.581629,5.536102 43.581615,5.535265 43.581487,5.534968 43.5814,5.532375 43.584094,5.530806 43.584084,5.52791 43.586822,5.527867 43.586823,5.522561 43.59222,5.520181 43.595356,5.513953 43.603565,5.513796 43.603759,5.513479 43.604254,5.513223 43.604568,5.512512 43.605476,5.512299 43.605726,5.512184 43.60598,5.512046 43.606151,5.511685 43.606529,5.511369 43.606977,5.511198 43.607128,5.510286 43.607593,5.510054 43.607689,5.509379 43.608018,5.508975 43.608249,5.508251 43.608611,5.508223 43.608695,5.50801 43.60878,5.504367 43.609304,5.503765 43.60943,5.50324 43.609556,5.50263 43.609661,5.501821 43.609787,5.501542 43.609845,5.500342 43.610122,5.498721 43.610527,5.494246 43.612036,5.494101 43.612049,5.493603 43.612209,5.493236 43.612348,5.493218 43.612398,5.492573 43.612489,5.487958 43.612872,5.488206 43.613275,5.488229 43.613714,5.488259 43.613885,5.488447 43.614162,5.488455 43.614468,5.488578 43.615054,5.488698 43.615389,5.488804 43.615763,5.4888 43.616156,5.488686 43.616188,5.488285 43.616195,5.487759 43.616183,5.487459 43.616032,5.486847 43.615882,5.484481 43.617566,5.482008 43.620051,5.481473 43.620098,5.481027 43.620185,5.480134 43.620551,5.479432 43.620874,5.479263 43.620983,5.479011 43.621193,5.478687 43.621524,5.478225 43.621929,5.478112 43.622052,5.477636 43.622501,5.47671 43.62344,5.476542 43.623517,5.476736 43.62369,5.476861 43.623843,5.477118 43.624077,5.477493 43.624385,5.47807 43.625065,5.478869 43.626116,5.479241 43.626406,5.479415 43.62652,5.4798 43.626874,5.480031 43.627161,5.480193 43.627289,5.480518 43.62741,5.480441 43.627535,5.480292 43.629145,5.481428 43.630798,5.484236 43.63112,5.484561 43.631521,5.484808 43.633562,5.484856 43.634082,5.484977 43.635023,5.483503 43.635621,5.481239 43.636013,5.481225 43.636564,5.481219 43.637578,5.481149 43.637731,5.48123 43.63803,5.481516 43.638548,5.481622 43.63861,5.481696 43.638771,5.481899 43.639423,5.482134 43.639876,5.482332 43.640039,5.482485 43.640214,5.482766 43.640726,5.483011 43.641264,5.483025 43.641331,5.482177 43.645366,5.48237 43.646668,5.482432 43.648018,5.481648 43.648061,5.480686 43.648167,5.480227 43.648387,5.479868 43.648587,5.479447 43.64879,5.479615 43.648932,5.479799 43.649133,5.480247 43.649537,5.481948 43.650989,5.482784 43.651675,5.48317 43.652008,5.483758 43.652482,5.484592 43.653196,5.485013 43.653534,5.485385 43.653931,5.485587 43.654234,5.485753 43.65464,5.48585 43.655007,5.486116 43.656426,5.486318 43.657203,5.486494 43.657991,5.486527 43.658294,5.486891 43.660358,5.48737 43.663105,5.487423 43.663265,5.487584 43.664142,5.487671 43.664944,5.487757 43.665131,5.4878 43.665383,5.487824 43.66592,5.487819 43.666192,5.487781 43.66639,5.487723 43.66757,5.488108 43.667436,5.496102 43.666727,5.503771 43.665725,5.51187 43.663625,5.512198 43.663534,5.519382 43.661311,5.526994 43.66005,5.532316 43.659173,5.543906 43.660896,5.549876 43.659804)))', 4326))
            AND ((tags->'railway') IN ('station','halt') OR ((tags->'public_transport') = 'station' AND (tags->'train') = 'yes'));