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 = '13062' 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 = 27648 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 = '13062';

"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-14 06:05:10', 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 = 27648;

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

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

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.533303 43.416532,5.53298 43.416499,5.532569 43.416562,5.532291 43.416561,5.532041 43.416495,5.531433 43.416541,5.531144 43.416614,5.530883 43.416592,5.530717 43.416421,5.530511 43.416348,5.530333 43.416349,5.530091 43.416268,5.529794 43.41627,5.529518 43.416342,5.529195 43.416538,5.528971 43.416748,5.52869 43.416839,5.528356 43.416882,5.528078 43.416845,5.527992 43.416667,5.527906 43.416398,5.52779 43.416159,5.527417 43.415718,5.527069 43.415525,5.526378 43.414998,5.52596 43.414703,5.52531 43.414153,5.524881 43.414077,5.524651 43.414012,5.52442 43.413581,5.524101 43.413288,5.523939 43.413206,5.522226 43.411539,5.521501 43.410868,5.521234 43.410592,5.519783 43.40922,5.519665 43.409019,5.519066 43.407668,5.518335 43.407112,5.51785 43.406854,5.517069 43.406807,5.516037 43.406816,5.515316 43.406776,5.512972 43.406163,5.512685 43.405389,5.51462 43.404209,5.514231 43.402003,5.511789 43.400025,5.511664 43.399912,5.511402 43.399804,5.511248 43.399627,5.511009 43.399459,5.510638 43.399103,5.508559 43.396983,5.507191 43.395636,5.506754 43.394428,5.50616 43.392824,5.504914 43.389436,5.504427 43.388057,5.50365 43.387837,5.501662 43.387297,5.501087 43.387128,5.500527 43.386996,5.500186 43.386938,5.499691 43.386811,5.499038 43.38662,5.498697 43.386505,5.498026 43.386354,5.497663 43.386243,5.496585 43.385942,5.496099 43.385798,5.495043 43.385507,5.49438 43.385333,5.494155 43.385311,5.493167 43.385283,5.491824 43.385186,5.491145 43.385146,5.490057 43.38486,5.48965 43.384743,5.488747 43.384628,5.487133 43.384463,5.486796 43.384447,5.485528 43.384414,5.484267 43.384454,5.484088 43.384424,5.483589 43.384403,5.483277 43.384414,5.482248 43.384539,5.481737 43.38471,5.481356 43.3848,5.481136 43.384914,5.480995 43.384934,5.479839 43.385359,5.47921 43.386381,5.479186 43.387306,5.478908 43.387637,5.478423 43.388357,5.477488 43.389125,5.477339 43.389234,5.47709 43.389556,5.47702 43.389882,5.476932 43.390112,5.476786 43.390243,5.475999 43.391008,5.475746 43.391152,5.475344 43.391448,5.47525 43.39173,5.475235 43.392259,5.475356 43.393005,5.475523 43.393249,5.476088 43.394436,5.475817 43.394726,5.475443 43.395241,5.475423 43.395486,5.475444 43.395725,5.475265 43.395983,5.475125 43.396267,5.474985 43.396777,5.474908 43.396917,5.474838 43.397524,5.474863 43.397679,5.475675 43.398328,5.476345 43.398803,5.476608 43.399014,5.476789 43.399195,5.476878 43.399353,5.47689 43.399733,5.476673 43.400837,5.476242 43.402933,5.475874 43.404139,5.475834 43.404315,5.475864 43.404455,5.476142 43.40502,5.476454 43.405558,5.476789 43.406069,5.477066 43.406335,5.477891 43.407309,5.4786 43.408383,5.479127 43.40843,5.478724 43.410418,5.478576 43.410912,5.478036 43.411259,5.477577 43.41178,5.477388 43.411854,5.476794 43.412019,5.477001 43.412299,5.477232 43.412513,5.47725 43.412621,5.477159 43.413023,5.477131 43.413633,5.477056 43.414095,5.476916 43.414229,5.476653 43.41431,5.475771 43.414346,5.475657 43.414494,5.475536 43.414761,5.475389 43.414955,5.475229 43.415252,5.475039 43.415431,5.474735 43.415602,5.474431 43.415715,5.474147 43.415848,5.473766 43.416112,5.473681 43.416347,5.473265 43.416853,5.473039 43.417088,5.472775 43.417288,5.472423 43.417444,5.471662 43.417868,5.471126 43.418249,5.470791 43.418433,5.470597 43.418501,5.47027 43.418667,5.469775 43.418958,5.46953 43.419142,5.468833 43.419534,5.467997 43.419854,5.467633 43.42003,5.467264 43.420158,5.467113 43.420236,5.46708 43.420358,5.467478 43.421639,5.46735 43.424069,5.466197 43.424753,5.466936 43.425383,5.466352 43.425823,5.466561 43.426058,5.466207 43.426172,5.463694 43.427075,5.463227 43.428336,5.464329 43.430076,5.464468 43.430005,5.464986 43.429646,5.465226 43.429501,5.465665 43.429114,5.466111 43.428808,5.466859 43.429394,5.467575 43.430123,5.467679 43.430197,5.467908 43.430541,5.468145 43.431026,5.468258 43.431189,5.468435 43.430847,5.46873 43.430895,5.469241 43.43116,5.469628 43.431315,5.47016 43.431093,5.471469 43.430631,5.471907 43.431232,5.472364 43.431996,5.472509 43.431956,5.473068 43.431743,5.473617 43.431699,5.473724 43.43185,5.4739 43.431836,5.475544 43.431567,5.475858 43.431522,5.476443 43.431184,5.476606 43.431008,5.476631 43.430808,5.476783 43.430628,5.477068 43.430509,5.478926 43.430542,5.481331 43.429649,5.4829 43.429379,5.483692 43.4299,5.483479 43.430287,5.485837 43.432021,5.486263 43.431863,5.486844 43.431677,5.487331 43.431687,5.489685 43.431697,5.489838 43.431686,5.490169 43.431751,5.490979 43.431997,5.4913 43.431553,5.492466 43.430713,5.494677 43.429986,5.49617 43.429489,5.496468 43.429461,5.497189 43.429281,5.497432 43.429207,5.497891 43.429106,5.498363 43.428873,5.499014 43.428597,5.500673 43.428242,5.501203 43.428149,5.501494 43.428077,5.501748 43.428041,5.502248 43.427939,5.502385 43.42797,5.503122 43.428046,5.504069 43.428163,5.504213 43.428159,5.505337 43.428209,5.506502 43.428396,5.506643 43.428393,5.506914 43.428664,5.507263 43.429159,5.507719 43.429666,5.507793 43.429804,5.508194 43.430333,5.509609 43.430052,5.510407 43.429931,5.510988 43.430012,5.51184 43.430112,5.512514 43.430158,5.513473 43.430248,5.513886 43.430234,5.514835 43.430139,5.516987 43.429669,5.517803 43.429371,5.518566 43.429015,5.518833 43.428859,5.519402 43.429397,5.519844 43.429889,5.520069 43.430208,5.520368 43.430548,5.520763 43.430909,5.521633 43.431602,5.521868 43.43191,5.522536 43.433251,5.523318 43.433884,5.523748 43.434165,5.525806 43.435414,5.525927 43.435469,5.526101 43.435643,5.527034 43.43641,5.527387 43.436667,5.527935 43.437269,5.52832 43.437738,5.52845 43.437926,5.528539 43.438274,5.528619 43.438432,5.528785 43.438866,5.529281 43.439881,5.529485 43.44014,5.529336 43.439709,5.529527 43.439304,5.529612 43.439039,5.529743 43.438534,5.529842 43.438374,5.530156 43.437989,5.530315 43.437625,5.530633 43.437157,5.530752 43.436707,5.530149 43.43665,5.530155 43.436361,5.529955 43.436227,5.529825 43.436029,5.529804 43.435861,5.529843 43.435675,5.530106 43.435143,5.53044 43.434344,5.530425 43.434228,5.530503 43.433653,5.530324 43.433395,5.530277 43.43315,5.530304 43.432716,5.530272 43.432165,5.530061 43.431694,5.530161 43.431326,5.530297 43.431168,5.530596 43.430753,5.53092 43.4304,5.530978 43.430166,5.531137 43.429962,5.531396 43.429794,5.531597 43.429477,5.531498 43.429249,5.531231 43.428875,5.531205 43.428696,5.531149 43.428664,5.530953 43.428338,5.532118 43.42785,5.532625 43.42758,5.533062 43.42733,5.533346 43.427226,5.533567 43.427198,5.533647 43.427103,5.534102 43.426952,5.534386 43.426822,5.534889 43.426487,5.535193 43.426213,5.535303 43.426081,5.535816 43.425739,5.536125 43.425413,5.536242 43.42526,5.536372 43.424971,5.536478 43.424808,5.536785 43.424236,5.536865 43.423948,5.536812 43.42366,5.536927 43.423246,5.536928 43.423149,5.536703 43.422976,5.53664 43.422811,5.536573 43.422488,5.536345 43.422404,5.536524 43.422177,5.536712 43.422009,5.536695 43.421783,5.536253 43.421774,5.535683 43.421691,5.535541 43.421692,5.53485 43.421603,5.534508 43.421465,5.534343 43.421355,5.534208 43.421076,5.53409 43.420904,5.533903 43.420878,5.533823 43.420816,5.534437 43.420404,5.53457 43.420237,5.534532 43.420075,5.534647 43.419954,5.534953 43.419958,5.535026 43.419923,5.535515 43.419513,5.535784 43.419423,5.535975 43.419247,5.536045 43.419073,5.535793 43.418885,5.535747 43.418792,5.535736 43.418555,5.535593 43.418251,5.535276 43.417958,5.534914 43.417687,5.534694 43.417402,5.534589 43.417305,5.533303 43.416532)))', 4326))
            AND ((tags->'railway') IN ('station','halt') OR ((tags->'public_transport') = 'station' AND (tags->'train') = 'yes'));