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 = '13021' 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 = 27664 AND c0_.name IN ('bus_stop_count', 'bus_stop_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 = '13021';

"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\":\"bus_stop\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-15 08:26:05', 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 = 27664;

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

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 = 27664 AND z0_.theme = 'bus_stop' 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'13021'') = ?
  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'13021'') = ?
      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 = '13021';

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 -> 'highway') = 'bus_stop'
    OR (tags -> 'public_transport') = 'platform'
  )

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.183724 43.329839,5.183774 43.330362,5.183955 43.330296,5.183835 43.330092,5.18392 43.330007,5.183924 43.329834,5.183805 43.329737,5.183724 43.329839)),((5.138727 43.364456,5.139267 43.364376,5.143517 43.363301,5.14509 43.362893,5.148278 43.362078,5.149525 43.36128,5.150239 43.360781,5.15195 43.359727,5.160462 43.354298,5.162744 43.352895,5.165011 43.35144,5.167472 43.350117,5.170154 43.348558,5.17029 43.348334,5.17222 43.345029,5.176061 43.338445,5.178755 43.33725,5.179115 43.337158,5.18048 43.337022,5.181289 43.336877,5.182071 43.336752,5.183543 43.336554,5.185827 43.33632,5.185592 43.336159,5.185443 43.336103,5.185187 43.335825,5.185155 43.33563,5.185224 43.335456,5.185459 43.335217,5.185508 43.335064,5.185468 43.334613,5.185509 43.334302,5.185439 43.334118,5.185479 43.333969,5.185692 43.333774,5.185697 43.333642,5.185529 43.333551,5.185434 43.333424,5.185407 43.333277,5.185454 43.333139,5.185422 43.333037,5.185184 43.332858,5.185101 43.332754,5.184847 43.332567,5.184442 43.332566,5.183864 43.332507,5.183493 43.332383,5.183394 43.332299,5.183456 43.332127,5.183399 43.332036,5.183187 43.33191,5.182973 43.331873,5.182892 43.331738,5.182766 43.331826,5.182594 43.331762,5.18241 43.331795,5.181923 43.331713,5.181751 43.33162,5.181571 43.331635,5.181544 43.331754,5.181229 43.331767,5.180963 43.331704,5.180784 43.3318,5.180561 43.331654,5.180374 43.331658,5.180158 43.331618,5.179866 43.331454,5.179884 43.331356,5.179615 43.331467,5.179319 43.331397,5.179159 43.331388,5.178928 43.331438,5.178792 43.331596,5.178596 43.331912,5.178625 43.331991,5.178399 43.332155,5.178222 43.332354,5.17814 43.33251,5.177999 43.332543,5.177979 43.332644,5.178074 43.332785,5.178073 43.333397,5.178054 43.333559,5.177902 43.333584,5.177616 43.333721,5.177289 43.333529,5.177254 43.333584,5.177568 43.333749,5.177401 43.333882,5.176966 43.33413,5.176686 43.334207,5.176342 43.334259,5.176303 43.334188,5.176118 43.334192,5.175693 43.334047,5.175323 43.334046,5.175326 43.334109,5.175597 43.334121,5.175934 43.334223,5.175976 43.334366,5.175588 43.334536,5.175403 43.334521,5.175339 43.334469,5.175099 43.334526,5.174857 43.334539,5.1745 43.334518,5.174153 43.334402,5.173912 43.334414,5.173647 43.334347,5.173177 43.334104,5.172937 43.33386,5.173198 43.333603,5.173097 43.333542,5.172824 43.333817,5.172577 43.333804,5.172399 43.333655,5.172388 43.333358,5.172456 43.333204,5.172896 43.333096,5.172996 43.33313,5.17315 43.333307,5.173352 43.33342,5.173486 43.333381,5.173331 43.333195,5.173027 43.332985,5.172511 43.333031,5.172146 43.332841,5.171744 43.332537,5.171611 43.332253,5.171508 43.332171,5.171513 43.331828,5.171452 43.331777,5.171256 43.331779,5.17106 43.331614,5.170871 43.331391,5.170875 43.331183,5.17106 43.331004,5.170805 43.330784,5.170759 43.330709,5.170778 43.330555,5.170729 43.33043,5.170663 43.329994,5.17059 43.329756,5.170411 43.32961,5.170287 43.329393,5.170147 43.329336,5.170024 43.329161,5.169904 43.329103,5.169939 43.329021,5.169635 43.328896,5.169381 43.328718,5.169296 43.328614,5.1691 43.328558,5.168872 43.328357,5.168747 43.328187,5.168273 43.328127,5.16819 43.328057,5.167848 43.328027,5.167813 43.328111,5.167668 43.32811,5.16728 43.328298,5.167034 43.328378,5.166755 43.328412,5.166467 43.328603,5.16627 43.328625,5.166137 43.32875,5.165787 43.328757,5.165478 43.328619,5.165448 43.328327,5.165304 43.327987,5.165083 43.327801,5.16478 43.327658,5.164161 43.32748,5.164049 43.327426,5.163836 43.327426,5.163634 43.327386,5.163494 43.327268,5.163281 43.327193,5.162994 43.327215,5.162742 43.327341,5.162488 43.327399,5.162402 43.327486,5.16165 43.32783,5.161466 43.327961,5.161441 43.328244,5.16131 43.328499,5.160735 43.329029,5.160397 43.329045,5.160154 43.329,5.159812 43.328718,5.159786 43.328341,5.159875 43.328112,5.159912 43.327776,5.159817 43.327639,5.159418 43.32747,5.159312 43.3274,5.159007 43.327378,5.158869 43.327491,5.158693 43.327513,5.158549 43.327418,5.158292 43.327385,5.15821 43.327423,5.158129 43.327589,5.157804 43.327748,5.157492 43.327761,5.156918 43.327566,5.156606 43.327575,5.15633 43.327644,5.155983 43.327862,5.155673 43.328013,5.155532 43.328272,5.155272 43.328438,5.15501 43.32854,5.15478 43.32832,5.154416 43.328165,5.154281 43.328168,5.154247 43.328258,5.154386 43.328346,5.154683 43.328385,5.1549 43.328578,5.154854 43.328651,5.154706 43.328663,5.154513 43.328784,5.154493 43.328892,5.15427 43.328879,5.154289 43.328716,5.154445 43.328605,5.154406 43.328552,5.154116 43.328711,5.154006 43.328722,5.153782 43.328664,5.153493 43.328534,5.153236 43.328242,5.152981 43.328014,5.152743 43.32791,5.152596 43.327949,5.1526 43.328057,5.152862 43.328142,5.153286 43.32861,5.15272 43.329279,5.152808 43.32934,5.152926 43.329194,5.153036 43.329164,5.153835 43.329427,5.153875 43.329508,5.153305 43.330419,5.152618 43.330505,5.152663 43.330063,5.152526 43.330029,5.152483 43.330534,5.152076 43.330515,5.151765 43.33045,5.151404 43.330034,5.151271 43.329433,5.151203 43.328931,5.151206 43.328697,5.151265 43.328624,5.152183 43.328767,5.152259 43.328829,5.15243 43.328771,5.152326 43.328639,5.151298 43.328497,5.151193 43.328341,5.151207 43.328245,5.151112 43.328093,5.151198 43.327951,5.151155 43.327885,5.151354 43.327704,5.151431 43.32745,5.15175 43.327075,5.151984 43.327011,5.151867 43.326899,5.151892 43.326753,5.152047 43.326581,5.152209 43.326459,5.152397 43.32626,5.152304 43.326106,5.151998 43.326316,5.151985 43.326414,5.151786 43.326455,5.151672 43.326562,5.151308 43.326661,5.151032 43.326695,5.150856 43.326869,5.150624 43.3269,5.150497 43.32677,5.150098 43.326716,5.150064 43.32667,5.14973 43.326628,5.149557 43.326462,5.149656 43.326352,5.14962 43.326193,5.149452 43.326153,5.149423 43.326028,5.148992 43.326064,5.148846 43.326117,5.148816 43.326219,5.148883 43.326368,5.148759 43.326482,5.148506 43.32657,5.148249 43.326577,5.148063 43.32654,5.147797 43.326592,5.147591 43.326663,5.147347 43.326688,5.147289 43.326753,5.146835 43.326819,5.146508 43.326926,5.146461 43.326999,5.1462 43.327095,5.146054 43.327053,5.145765 43.326897,5.145461 43.326821,5.144939 43.326725,5.144242 43.326781,5.144193 43.326901,5.144076 43.326965,5.143715 43.327469,5.143698 43.327676,5.14357 43.327674,5.1435 43.327807,5.143335 43.327947,5.14332 43.328108,5.143209 43.328149,5.143039 43.328454,5.143015 43.328545,5.142871 43.328646,5.14272 43.328519,5.142587 43.328527,5.142638 43.328662,5.142567 43.328778,5.142279 43.328964,5.142062 43.329427,5.141733 43.329542,5.141204 43.329561,5.140706 43.329436,5.140769 43.329129,5.140337 43.32911,5.140174 43.329042,5.140109 43.328953,5.140154 43.328826,5.140065 43.328774,5.139773 43.328213,5.139684 43.328142,5.139347 43.328014,5.139141 43.327855,5.138956 43.327824,5.13875 43.327841,5.138323 43.327986,5.138087 43.328002,5.138085 43.327817,5.137859 43.327862,5.137804 43.328028,5.137731 43.328092,5.137528 43.328158,5.137183 43.328232,5.137091 43.328347,5.136711 43.328591,5.136496 43.328646,5.136325 43.328625,5.136024 43.328495,5.135823 43.328553,5.135936 43.328712,5.135714 43.328708,5.135738 43.32879,5.135446 43.328874,5.13545 43.328997,5.135285 43.329055,5.135306 43.32921,5.135356 43.329307,5.134886 43.329588,5.13471 43.329863,5.134708 43.330006,5.134437 43.331813,5.134347 43.332521,5.134818 43.332589,5.135349 43.333698,5.135582 43.334097,5.135577 43.334208,5.135882 43.334172,5.136191 43.334173,5.137383 43.334263,5.137081 43.335183,5.137005 43.336033,5.136758 43.336547,5.136593 43.337185,5.136313 43.337591,5.135929 43.33793,5.136004 43.338459,5.136652 43.339219,5.13634 43.340081,5.134607 43.341157,5.134928 43.341977,5.136285 43.34384,5.137031 43.344551,5.138054 43.345176,5.140618 43.346214,5.141496 43.346307,5.142848 43.346874,5.143286 43.347707,5.143288 43.347845,5.143172 43.347936,5.142403 43.348171,5.142138 43.348379,5.14205 43.348675,5.14154 43.348873,5.140791 43.348763,5.140406 43.349491,5.140177 43.349551,5.139618 43.349504,5.139459 43.349532,5.139241 43.349646,5.138394 43.349651,5.138246 43.3498,5.138243 43.349955,5.139354 43.350833,5.139303 43.350966,5.138602 43.351372,5.13853 43.351571,5.13858 43.351697,5.138786 43.351853,5.139407 43.352177,5.139527 43.3523,5.139525 43.352435,5.139415 43.352601,5.139092 43.352796,5.138475 43.353029,5.138434 43.353232,5.138635 43.353679,5.137074 43.353826,5.136827 43.354105,5.136837 43.354431,5.137057 43.354688,5.137196 43.354718,5.137932 43.354707,5.137462 43.355543,5.137525 43.355868,5.138016 43.356349,5.137965 43.356756,5.137868 43.357142,5.138653 43.357489,5.138984 43.358059,5.138888 43.358272,5.138357 43.35849,5.13679 43.359621,5.136176 43.359797,5.135969 43.360225,5.135309 43.360603,5.134387 43.360795,5.135645 43.3614,5.136144 43.361728,5.136577 43.362172,5.136462 43.362646,5.136225 43.362912,5.134358 43.364367,5.132414 43.365563,5.131509 43.366224,5.132577 43.366192,5.134963 43.366362,5.135988 43.365182,5.138727 43.364456)))', 4326))
            AND ((tags->'highway') = 'bus_stop' OR (tags->'public_transport') = 'platform');