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 = '13071' 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 = 27190 AND c0_.name IN ('bench_count', 'bench_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 = '13071';

"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\":\"bench\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-14 06:08:16', 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 = 27190;

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

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 = 27190 AND z0_.theme = 'bench' 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'13071'') = ?
  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'13071'') = ?
      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 = '13071';

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 -> 'amenity') = 'bench'
  )

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.278783 43.380454,5.278391 43.381709,5.27562 43.388894,5.275317 43.389043,5.274635 43.3893,5.273171 43.389826,5.273007 43.389981,5.27292 43.390241,5.272931 43.390364,5.272417 43.391091,5.272276 43.391354,5.271365 43.391177,5.27138 43.391354,5.271291 43.391502,5.271216 43.391941,5.271196 43.392267,5.271205 43.39303,5.27117 43.39329,5.271084 43.393569,5.270904 43.39405,5.270766 43.394266,5.270423 43.394714,5.27003 43.395286,5.269524 43.396048,5.269126 43.396541,5.268586 43.397319,5.268185 43.397853,5.267518 43.398663,5.267105 43.399244,5.266424 43.400043,5.266018 43.400576,5.265623 43.400481,5.265489 43.400702,5.265104 43.401059,5.265996 43.401806,5.266571 43.401946,5.26778 43.402275,5.267389 43.402695,5.268131 43.403042,5.268174 43.403077,5.269106 43.403514,5.270376 43.404126,5.271157 43.404495,5.27156 43.404657,5.272649 43.405157,5.272447 43.405523,5.271958 43.406358,5.272319 43.406493,5.273071 43.406509,5.272972 43.407473,5.272832 43.408082,5.272848 43.408683,5.273659 43.412555,5.273753 43.41275,5.273772 43.412961,5.273878 43.413371,5.27401 43.414005,5.274131 43.414437,5.273936 43.41459,5.274867 43.415115,5.274674 43.415574,5.274323 43.415611,5.274361 43.415838,5.274869 43.41835,5.274951 43.418878,5.275618 43.419044,5.276067 43.419182,5.276476 43.419444,5.276692 43.41949,5.276969 43.419507,5.27729 43.419566,5.277675 43.419598,5.278734 43.419712,5.278972 43.419715,5.279161 43.419766,5.279365 43.419746,5.280318 43.41981,5.280748 43.41987,5.28094 43.419861,5.281219 43.419987,5.281223 43.420113,5.281566 43.420362,5.281794 43.420463,5.281997 43.420511,5.282123 43.420486,5.282555 43.420273,5.28302 43.420093,5.283543 43.420068,5.283922 43.419919,5.284137 43.419799,5.284262 43.419774,5.284592 43.419858,5.284739 43.419851,5.284957 43.419897,5.285321 43.419886,5.285551 43.41995,5.285923 43.420009,5.286051 43.420074,5.286157 43.420347,5.286309 43.420445,5.286718 43.420504,5.287046 43.420417,5.287327 43.420428,5.287825 43.420575,5.288621 43.42041,5.289026 43.420281,5.289188 43.420203,5.289759 43.419858,5.290203 43.419572,5.290422 43.41962,5.290686 43.419619,5.290853 43.41969,5.291145 43.41973,5.29136 43.419857,5.291575 43.420073,5.292044 43.42035,5.292683 43.420677,5.292874 43.420727,5.293058 43.420863,5.293275 43.421094,5.29347 43.42136,5.293663 43.421758,5.293848 43.422192,5.293885 43.422389,5.293969 43.422589,5.294094 43.422779,5.294363 43.423054,5.294427 43.423149,5.294385 43.423576,5.294416 43.423793,5.294692 43.424615,5.294521 43.424626,5.294474 43.42471,5.294545 43.42487,5.294822 43.425282,5.294938 43.425582,5.295022 43.426031,5.295022 43.426193,5.294876 43.426475,5.294855 43.426665,5.294782 43.426939,5.29463 43.427212,5.294893 43.427577,5.294807 43.427704,5.294924 43.427863,5.294869 43.42799,5.294951 43.428275,5.295061 43.428494,5.295048 43.428678,5.29523 43.428924,5.295184 43.429057,5.294934 43.429288,5.294906 43.429448,5.295015 43.429642,5.295231 43.429775,5.295479 43.43005,5.295504 43.430312,5.295557 43.430359,5.295898 43.430293,5.295761 43.430628,5.295995 43.430858,5.296112 43.430819,5.296199 43.431095,5.29627 43.431211,5.296336 43.431469,5.296417 43.431644,5.296719 43.431739,5.296794 43.431868,5.296946 43.431941,5.2972 43.431967,5.297365 43.431908,5.298009 43.431853,5.298333 43.43198,5.298526 43.432082,5.298855 43.432541,5.298987 43.43266,5.299232 43.432783,5.299388 43.432755,5.299947 43.432576,5.300421 43.432566,5.300886 43.432822,5.301188 43.432816,5.301379 43.432767,5.301974 43.432512,5.302424 43.432391,5.302789 43.432353,5.303458 43.432259,5.304069 43.432239,5.304296 43.43221,5.304657 43.432243,5.304877 43.432215,5.305396 43.432196,5.305605 43.43221,5.308994 43.43174,5.310788 43.431564,5.310821 43.431525,5.311225 43.431579,5.311357 43.431571,5.31225 43.431248,5.31242 43.431118,5.312887 43.430936,5.313211 43.430848,5.313641 43.430668,5.31395 43.430575,5.314189 43.430537,5.314335 43.430471,5.314603 43.430415,5.314994 43.430277,5.315504 43.429892,5.315744 43.429794,5.315801 43.429725,5.316094 43.429674,5.316491 43.429642,5.31678 43.429653,5.317537 43.429403,5.322238 43.429413,5.322445 43.429382,5.322757 43.429282,5.323503 43.429114,5.324026 43.428953,5.324373 43.428809,5.324561 43.428692,5.325154 43.428484,5.325397 43.428442,5.32616 43.428229,5.32654 43.428066,5.326879 43.42786,5.327346 43.427522,5.327732 43.42722,5.327954 43.427143,5.328565 43.426747,5.329178 43.426426,5.329369 43.426278,5.329726 43.426042,5.330352 43.425794,5.330961 43.425406,5.331626 43.424863,5.332022 43.42459,5.332586 43.42424,5.332904 43.42411,5.333349 43.423989,5.334008 43.423636,5.334469 43.423332,5.334773 43.423152,5.335423 43.422799,5.336226 43.422432,5.336494 43.422281,5.336972 43.422057,5.337179 43.421978,5.338079 43.421736,5.338302 43.421639,5.338723 43.421513,5.339075 43.421445,5.339274 43.421381,5.339497 43.421208,5.339679 43.420966,5.339828 43.420825,5.340276 43.420708,5.341059 43.420624,5.341363 43.420607,5.341656 43.420564,5.34194 43.420474,5.34255 43.420172,5.342992 43.419901,5.343789 43.419516,5.344187 43.419296,5.346085 43.419752,5.346785 43.419877,5.347235 43.419995,5.347404 43.420063,5.349171 43.420458,5.350747 43.420818,5.352266 43.421147,5.352804 43.421285,5.353636 43.421458,5.353978 43.421517,5.355538 43.421995,5.355626 43.421809,5.355697 43.421505,5.355829 43.421298,5.356083 43.421093,5.35641 43.420937,5.356662 43.42084,5.356845 43.420479,5.357014 43.420241,5.357252 43.419726,5.357703 43.418875,5.357789 43.418899,5.35842 43.417718,5.359423 43.418018,5.359753 43.418138,5.360471 43.41745,5.360843 43.417009,5.363479 43.41777,5.363916 43.417914,5.363831 43.418106,5.364457 43.41847,5.364765 43.418614,5.365744 43.41919,5.36534 43.419442,5.364896 43.419681,5.365766 43.419938,5.366579 43.420133,5.366813 43.420222,5.367471 43.41933,5.367589 43.419356,5.367906 43.419356,5.368403 43.419382,5.368915 43.419486,5.369361 43.419488,5.369608 43.419438,5.36984 43.419435,5.370865 43.419486,5.371407 43.419491,5.371997 43.419533,5.372527 43.419615,5.373166 43.419752,5.373348 43.41977,5.373942 43.419877,5.374552 43.419965,5.374938 43.419995,5.375327 43.419367,5.375764 43.41871,5.376104 43.418176,5.376243 43.418081,5.376814 43.417246,5.377344 43.416603,5.377936 43.415987,5.37815 43.415783,5.378419 43.415917,5.378459 43.415743,5.378638 43.415537,5.379013 43.415038,5.379164 43.414733,5.379276 43.414619,5.377364 43.413715,5.376117 43.413322,5.374185 43.41255,5.373396 43.41239,5.373126 43.412204,5.372734 43.412211,5.371762 43.412266,5.370472 43.412105,5.369918 43.411985,5.369173 43.411846,5.368596 43.411717,5.367774 43.411472,5.367335 43.411232,5.366892 43.410936,5.366645 43.410747,5.366498 43.410706,5.365834 43.410353,5.365014 43.410045,5.364581 43.409805,5.364357 43.409533,5.364207 43.409483,5.364017 43.409488,5.363382 43.409621,5.363293 43.409351,5.362981 43.408789,5.362829 43.408668,5.362611 43.408618,5.361803 43.408557,5.3615 43.408597,5.361194 43.408768,5.361065 43.408908,5.361045 43.40903,5.360966 43.409077,5.360759 43.409016,5.360647 43.409023,5.36035 43.409126,5.35987 43.409397,5.359621 43.409354,5.357787 43.408974,5.357614 43.408907,5.357299 43.408841,5.356464 43.408858,5.355091 43.408851,5.354304 43.408755,5.352976 43.408616,5.35301 43.408526,5.35279 43.408495,5.352561 43.408574,5.352321 43.40859,5.351246 43.408584,5.350662 43.408539,5.349629 43.408546,5.349112 43.408602,5.347994 43.4088,5.347679 43.408744,5.347442 43.408575,5.34665 43.408213,5.346577 43.408148,5.346259 43.408042,5.346 43.407888,5.346285 43.407525,5.346272 43.407131,5.345981 43.406504,5.345269 43.405947,5.344969 43.405823,5.345449 43.404192,5.345715 43.403374,5.345708 43.403197,5.344932 43.402904,5.344795 43.402772,5.344708 43.402615,5.344423 43.402457,5.344133 43.402566,5.343725 43.40264,5.343298 43.402803,5.343032 43.402818,5.342509 43.402944,5.341871 43.403002,5.34163 43.403036,5.340473 43.403049,5.340903 43.402579,5.341077 43.402185,5.341354 43.401812,5.341519 43.401754,5.341844 43.40176,5.342073 43.401737,5.342262 43.401645,5.3425 43.401294,5.3428 43.400977,5.343573 43.400242,5.343846 43.400005,5.344144 43.399559,5.344614 43.399134,5.344326 43.398903,5.343977 43.398552,5.343723 43.39805,5.343706 43.397458,5.343866 43.396649,5.344153 43.395577,5.344316 43.395428,5.344528 43.394855,5.344668 43.394583,5.344667 43.394478,5.344811 43.3941,5.345098 43.393445,5.345162 43.393048,5.345059 43.392628,5.34503 43.392401,5.34504 43.391838,5.34518 43.39162,5.345736 43.391013,5.345936 43.390812,5.346099 43.390409,5.346267 43.390157,5.346507 43.389922,5.346571 43.389824,5.347206 43.389206,5.347335 43.388958,5.34798 43.387922,5.348555 43.387115,5.348487 43.386888,5.348259 43.386593,5.348423 43.385733,5.348468 43.385391,5.348588 43.385023,5.349161 43.384524,5.348921 43.383908,5.348992 43.383789,5.349433 43.383668,5.349118 43.383168,5.349577 43.382722,5.349791 43.382551,5.350391 43.382498,5.35045 43.382204,5.350768 43.381498,5.350993 43.380637,5.351039 43.380529,5.351639 43.380119,5.351762 43.379884,5.351922 43.379375,5.351877 43.379346,5.352077 43.378986,5.352226 43.378775,5.352301 43.378608,5.352641 43.378001,5.352843 43.377837,5.352956 43.377561,5.353301 43.377284,5.353382 43.377113,5.353866 43.376723,5.354094 43.376599,5.354454 43.376331,5.354509 43.376193,5.354517 43.375936,5.354593 43.375684,5.354627 43.375414,5.354774 43.375068,5.354905 43.374992,5.355679 43.374623,5.355297 43.374532,5.355138 43.37443,5.354764 43.374452,5.354441 43.374439,5.354567 43.374315,5.35373 43.374244,5.353552 43.374216,5.353157 43.374314,5.3528 43.374373,5.352146 43.374324,5.351321 43.374777,5.350709 43.375098,5.350442 43.375204,5.350205 43.37525,5.349494 43.375319,5.349139 43.3754,5.348944 43.375482,5.348624 43.375469,5.347512 43.375352,5.347156 43.375326,5.345956 43.375281,5.345069 43.375211,5.344428 43.375174,5.343833 43.375315,5.343435 43.375443,5.342897 43.375735,5.341322 43.376342,5.340981 43.376518,5.340525 43.376832,5.340376 43.376906,5.339985 43.377004,5.339512 43.37708,5.338714 43.377239,5.338553 43.377241,5.338098 43.377161,5.337417 43.376968,5.337098 43.376904,5.336392 43.376793,5.336436 43.37641,5.336442 43.376011,5.336809 43.375535,5.337088 43.375261,5.336636 43.374823,5.335357 43.374304,5.334974 43.374086,5.333853 43.373176,5.333095 43.372418,5.332334 43.371461,5.332251 43.371478,5.3317 43.371645,5.330836 43.371943,5.330307 43.372105,5.32978 43.371286,5.329162 43.371603,5.32863 43.371839,5.328194 43.371991,5.328075 43.372057,5.327519 43.372288,5.327145 43.372337,5.32547 43.37174,5.324607 43.371368,5.324284 43.371081,5.324181 43.370804,5.32403 43.370317,5.324072 43.369953,5.323996 43.369689,5.323853 43.369663,5.323651 43.369487,5.32273 43.368737,5.322001 43.368201,5.321439 43.3682,5.320952 43.368364,5.320469 43.368483,5.320285 43.369056,5.320196 43.369202,5.319824 43.36956,5.319434 43.369831,5.318738 43.370154,5.318545 43.370321,5.318369 43.370838,5.318286 43.371177,5.318358 43.371159,5.318543 43.370986,5.318898 43.37147,5.319263 43.372316,5.319211 43.372616,5.319295 43.372774,5.319293 43.373152,5.319268 43.373261,5.319092 43.373515,5.318791 43.373677,5.318315 43.374044,5.318152 43.374222,5.317977 43.374504,5.317957 43.374631,5.31804 43.374883,5.318045 43.375076,5.317782 43.375486,5.317577 43.375738,5.317435 43.37608,5.317335 43.376405,5.317029 43.377008,5.316645 43.377083,5.31635 43.377072,5.316184 43.377029,5.315527 43.376983,5.31532 43.377248,5.315105 43.377302,5.31465 43.377469,5.314435 43.377588,5.314085 43.377678,5.313774 43.3778,5.31338 43.377988,5.313215 43.37796,5.313092 43.378004,5.312781 43.378186,5.312427 43.378566,5.312282 43.378665,5.311533 43.379092,5.311226 43.37938,5.311102 43.37968,5.310708 43.38007,5.310687 43.380395,5.310749 43.380808,5.310558 43.381144,5.310439 43.381482,5.310314 43.381597,5.310082 43.381733,5.309565 43.381946,5.309417 43.382049,5.308993 43.381884,5.308363 43.381679,5.308118 43.381494,5.306883 43.381329,5.306275 43.381202,5.306101 43.381541,5.30547 43.38126,5.304715 43.381084,5.303949 43.380888,5.303991 43.381268,5.304041 43.38143,5.304099 43.381963,5.304226 43.382249,5.30408 43.382421,5.304063 43.382582,5.303835 43.382674,5.303767 43.382774,5.303746 43.383082,5.303826 43.383374,5.30396 43.383558,5.304033 43.38395,5.304001 43.38445,5.304076 43.384756,5.303955 43.384891,5.30344 43.385325,5.303291 43.385568,5.303124 43.385907,5.302995 43.386023,5.302884 43.386207,5.302462 43.386722,5.302222 43.386984,5.301293 43.386788,5.300664 43.386984,5.300336 43.387007,5.30014 43.386962,5.299051 43.38701,5.298927 43.387046,5.298872 43.38766,5.298327 43.38826,5.298125 43.388507,5.297977 43.388777,5.297828 43.388843,5.297241 43.388956,5.296957 43.388945,5.296556 43.388732,5.296313 43.388476,5.29597 43.388227,5.295471 43.387968,5.295205 43.387859,5.294853 43.38782,5.294105 43.387281,5.293943 43.387107,5.29387 43.386809,5.293625 43.38656,5.293327 43.386316,5.293152 43.386099,5.293141 43.385968,5.293236 43.385878,5.293373 43.385522,5.293174 43.385313,5.292904 43.385127,5.291656 43.385194,5.290902 43.385259,5.290168 43.385038,5.289983 43.38494,5.289489 43.384972,5.289125 43.384935,5.288792 43.38495,5.288549 43.384926,5.288405 43.384841,5.287833 43.384897,5.287267 43.384615,5.286982 43.384547,5.286413 43.384456,5.28613 43.384447,5.285755 43.384389,5.285516 43.384195,5.285691 43.383787,5.285898 43.383422,5.285389 43.383264,5.284989 43.383103,5.284587 43.382898,5.284154 43.382643,5.283537 43.382354,5.283011 43.382299,5.281547 43.381939,5.281793 43.3812,5.281555 43.380933,5.281405 43.380657,5.281234 43.380409,5.281195 43.380295,5.281013 43.380238,5.280681 43.38023,5.280119 43.380308,5.278783 43.380454)))', 4326))
            AND ((tags->'amenity') = 'bench');