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 = '01102' 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 = 27460 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 = '01102';

"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-15 04:09:39', 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 = 27460;

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

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 = 27460 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'01102'') = ?
  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'01102'') = ?
      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 = '01102';

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(((4.943336 46.403007,4.943181 46.403721,4.943014 46.404555,4.942756 46.405766,4.944528 46.405681,4.944495 46.405998,4.944442 46.406248,4.944441 46.406437,4.944589 46.406746,4.944893 46.40677,4.945102 46.40684,4.945409 46.406854,4.945787 46.40703,4.946142 46.407279,4.94662 46.407003,4.947271 46.406473,4.948917 46.406417,4.952993 46.405695,4.956104 46.405156,4.956809 46.405026,4.957102 46.40499,4.958005 46.404834,4.958701 46.404724,4.959425 46.405182,4.959848 46.405469,4.960148 46.405496,4.960556 46.405784,4.961302 46.405502,4.961425 46.405651,4.961497 46.405506,4.96191 46.405235,4.962193 46.405174,4.962528 46.405136,4.962639 46.405195,4.963312 46.405435,4.963097 46.405597,4.963087 46.405723,4.962933 46.405785,4.962722 46.405751,4.962676 46.40585,4.962787 46.405974,4.962656 46.406136,4.962355 46.406168,4.962238 46.406265,4.961928 46.406316,4.96172 46.406395,4.961587 46.406502,4.961718 46.406595,4.961831 46.40677,4.961775 46.406854,4.961522 46.406824,4.961364 46.407001,4.961584 46.407166,4.96128 46.407331,4.961104 46.407754,4.96094 46.40802,4.960714 46.408463,4.960619 46.408548,4.960573 46.408869,4.96041 46.409099,4.960423 46.409434,4.960331 46.409615,4.960199 46.409708,4.960251 46.409801,4.960478 46.409833,4.96077 46.410028,4.96088 46.410162,4.96091 46.410291,4.96087 46.410462,4.961055 46.410636,4.960992 46.410726,4.960757 46.410711,4.960604 46.410881,4.960705 46.410942,4.960888 46.410956,4.961002 46.411016,4.961325 46.411075,4.96136 46.411179,4.961241 46.41125,4.961045 46.411262,4.961293 46.411533,4.961523 46.411459,4.962626 46.411209,4.962765 46.411151,4.96331 46.411019,4.963315 46.410625,4.963826 46.410167,4.963993 46.410214,4.964439 46.41001,4.964711 46.409781,4.965043 46.409355,4.965143 46.408959,4.965397 46.408594,4.965564 46.408282,4.965839 46.408194,4.966229 46.408184,4.96588 46.408741,4.966106 46.408825,4.967663 46.409033,4.969056 46.408464,4.969434 46.408316,4.969257 46.407447,4.96994 46.407414,4.971196 46.407382,4.971372 46.407103,4.971826 46.406258,4.971986 46.405996,4.973004 46.406154,4.974377 46.406389,4.975036 46.404855,4.975191 46.404824,4.975245 46.404647,4.975299 46.404287,4.975574 46.403213,4.975557 46.403156,4.975691 46.402862,4.975971 46.402526,4.976342 46.402305,4.97669 46.402149,4.976935 46.401921,4.97754 46.401018,4.977598 46.400961,4.97863 46.400369,4.978436 46.400067,4.978762 46.399848,4.979217 46.399685,4.979566 46.399535,4.979865 46.399455,4.980145 46.399225,4.980464 46.399056,4.980472 46.398969,4.98096 46.398667,4.981567 46.397843,4.983488 46.397551,4.984668 46.397476,4.985184 46.397381,4.985295 46.397471,4.985399 46.397647,4.986137 46.397539,4.986283 46.397326,4.986112 46.397339,4.986297 46.397089,4.988906 46.39689,4.988905 46.396755,4.988879 46.396077,4.988972 46.395142,4.989162 46.394589,4.98921 46.394299,4.989206 46.393834,4.989104 46.393306,4.98888 46.392635,4.988857 46.392508,4.988638 46.391941,4.988659 46.391875,4.988644 46.391389,4.988453 46.390635,4.988276 46.390209,4.987964 46.389717,4.987675 46.389093,4.987313 46.388412,4.987155 46.388151,4.986912 46.387812,4.986753 46.387356,4.986568 46.386943,4.986416 46.38652,4.985981 46.385766,4.985827 46.385288,4.985578 46.385233,4.985428 46.385145,4.985429 46.384612,4.98566 46.384148,4.985741 46.383947,4.985891 46.38372,4.986287 46.383348,4.986459 46.383148,4.986598 46.382919,4.986686 46.382677,4.986763 46.382284,4.986812 46.381906,4.986851 46.380746,4.986851 46.380406,4.986997 46.380411,4.987046 46.380117,4.987119 46.379349,4.987125 46.37846,4.987144 46.377825,4.986166 46.377955,4.986086 46.377659,4.986043 46.377617,4.985876 46.376924,4.985911 46.37684,4.985818 46.37655,4.986029 46.37633,4.985151 46.375629,4.985312 46.375542,4.985338 46.375292,4.985311 46.375063,4.985424 46.374868,4.985639 46.374662,4.986064 46.37441,4.986059 46.374283,4.985712 46.373891,4.985237 46.373388,4.985089 46.373326,4.984907 46.373077,4.984453 46.372579,4.983923 46.371734,4.983515 46.371428,4.983182 46.371211,4.98291 46.371145,4.982487 46.371154,4.981933 46.371142,4.981526 46.371053,4.981104 46.370879,4.980694 46.37065,4.980334 46.370205,4.980088 46.369952,4.980005 46.369949,4.979617 46.369644,4.979327 46.369482,4.978817 46.369295,4.978739 46.36924,4.978429 46.368888,4.978238 46.368769,4.978145 46.368488,4.977826 46.368482,4.977468 46.368392,4.976465 46.368073,4.976294 46.368038,4.975809 46.368092,4.975611 46.368015,4.975605 46.367956,4.975316 46.367639,4.975166 46.367444,4.974952 46.367319,4.974514 46.367107,4.974461 46.367025,4.973957 46.36656,4.97402 46.366444,4.974027 46.366189,4.974165 46.366166,4.974296 46.366233,4.974444 46.36623,4.974586 46.366056,4.974419 46.365993,4.974365 46.365857,4.9745 46.365744,4.974755 46.365718,4.975116 46.365812,4.9752 46.365746,4.975244 46.365541,4.975316 46.365445,4.975471 46.365365,4.97559 46.365234,4.97576 46.365121,4.975965 46.365056,4.976054 46.364906,4.976209 46.364825,4.976297 46.3646,4.976484 46.364634,4.976753 46.364499,4.977136 46.364405,4.977161 46.364127,4.977503 46.36413,4.977605 46.364106,4.977715 46.363953,4.977975 46.363884,4.977987 46.363814,4.978144 46.36377,4.978199 46.363692,4.978488 46.363653,4.978662 46.363519,4.978851 46.363476,4.978927 46.36336,4.979162 46.363303,4.979148 46.36297,4.979458 46.362892,4.979715 46.362492,4.979853 46.362489,4.980142 46.36228,4.980332 46.362093,4.980558 46.361999,4.980439 46.361735,4.980509 46.36164,4.980644 46.361619,4.980847 46.361658,4.980964 46.36151,4.980972 46.361305,4.981064 46.361265,4.981338 46.361281,4.981344 46.361151,4.981446 46.361068,4.981496 46.360798,4.981588 46.360745,4.981928 46.360794,4.982034 46.360724,4.981826 46.360593,4.981805 46.36045,4.981884 46.360402,4.982104 46.360545,4.982237 46.360462,4.982216 46.3603,4.982449 46.360242,4.982499 46.360047,4.982783 46.359981,4.982879 46.35974,4.98313 46.3595,4.982953 46.359145,4.982604 46.359284,4.981038 46.359115,4.980797 46.358901,4.980591 46.358757,4.980467 46.358597,4.980237 46.358433,4.979981 46.358336,4.979847 46.35798,4.979717 46.357448,4.97992 46.357298,4.979933 46.357234,4.979779 46.356805,4.979829 46.356505,4.980105 46.356234,4.980278 46.355981,4.98029 46.35587,4.980463 46.355109,4.980187 46.355006,4.979673 46.354888,4.979516 46.354836,4.978761 46.354703,4.978708 46.354624,4.97849 46.354525,4.978147 46.354432,4.977747 46.354358,4.977367 46.354216,4.976985 46.354124,4.976941 46.354254,4.976372 46.354346,4.976073 46.354441,4.976051 46.353651,4.976022 46.353062,4.975942 46.352883,4.974464 46.353042,4.97412 46.353063,4.973921 46.353025,4.973433 46.353053,4.97327 46.353097,4.972999 46.353111,4.972445 46.35323,4.972216 46.35326,4.971838 46.353215,4.971628 46.353236,4.971181 46.353344,4.970903 46.353493,4.970819 46.353398,4.970627 46.353315,4.970204 46.353346,4.969274 46.3536,4.968846 46.353823,4.968735 46.354135,4.968609 46.354363,4.968588 46.354539,4.968791 46.354827,4.967876 46.355318,4.967826 46.355434,4.967274 46.355636,4.967016 46.355748,4.966642 46.355655,4.966439 46.355558,4.966338 46.355339,4.966104 46.355335,4.96576 46.355426,4.965344 46.35551,4.964974 46.355563,4.964918 46.355686,4.964563 46.356158,4.964532 46.356285,4.964563 46.356594,4.964404 46.356613,4.96403 46.35672,4.963777 46.356766,4.963306 46.356773,4.962378 46.356757,4.960965 46.356743,4.96026 46.35672,4.9602 46.35683,4.958817 46.358679,4.958669 46.358848,4.958426 46.358981,4.958374 46.359059,4.958437 46.359368,4.958533 46.359531,4.95858 46.359715,4.958474 46.35983,4.957158 46.360779,4.955605 46.361922,4.954298 46.362869,4.949944 46.366033,4.949644 46.366239,4.949542 46.366355,4.949373 46.366645,4.949145 46.366889,4.948572 46.367317,4.948499 46.367432,4.948379 46.367867,4.94835 46.368189,4.948446 46.368724,4.948675 46.369529,4.948745 46.369689,4.948386 46.369741,4.947011 46.369905,4.946663 46.369868,4.946213 46.369744,4.946075 46.369727,4.944607 46.36977,4.942952 46.369835,4.942474 46.369823,4.9417 46.369666,4.941164 46.369576,4.940385 46.369482,4.93995 46.369409,4.938824 46.369197,4.938248 46.36907,4.937695 46.368924,4.937501 46.368853,4.936845 46.368501,4.936501 46.368351,4.936111 46.368215,4.935498 46.368062,4.935211 46.367947,4.934747 46.367816,4.934323 46.367803,4.933603 46.367827,4.933076 46.367793,4.93299 46.367949,4.932814 46.368143,4.932542 46.368347,4.932321 46.368551,4.931992 46.368938,4.931724 46.3692,4.93155 46.369616,4.931494 46.369891,4.931497 46.370627,4.931456 46.370828,4.931327 46.371033,4.931045 46.371546,4.930742 46.372033,4.930658 46.372209,4.930422 46.37239,4.930635 46.372583,4.930919 46.372825,4.930897 46.372903,4.931586 46.373758,4.931949 46.374173,4.932137 46.374357,4.932383 46.37473,4.932595 46.375137,4.932594 46.3752,4.932833 46.375468,4.93298 46.375572,4.93316 46.375574,4.933342 46.375642,4.934159 46.375853,4.934476 46.375845,4.93487 46.376107,4.935385 46.376369,4.936436 46.37681,4.936634 46.376882,4.936614 46.376939,4.937068 46.377426,4.937339 46.37769,4.937956 46.37779,4.938299 46.377805,4.938786 46.377862,4.939058 46.377829,4.941146 46.378649,4.941879 46.378964,4.942821 46.379345,4.943515 46.379591,4.94395 46.379674,4.944201 46.379683,4.944211 46.379743,4.943935 46.380021,4.943615 46.380411,4.943239 46.380832,4.942913 46.381132,4.942459 46.381414,4.941886 46.381848,4.941245 46.382422,4.940833 46.38277,4.940045 46.383377,4.939922 46.383455,4.939319 46.383973,4.939051 46.384227,4.93804 46.385347,4.937763 46.385637,4.937079 46.386391,4.936682 46.386758,4.936992 46.387082,4.937421 46.387894,4.937567 46.388122,4.937799 46.388419,4.937594 46.388549,4.937846 46.38872,4.938165 46.389005,4.938587 46.38913,4.93886 46.389299,4.939177 46.390035,4.939694 46.39072,4.940064 46.390547,4.940237 46.390489,4.940704 46.390411,4.941993 46.390027,4.942687 46.389847,4.942825 46.389918,4.943421 46.390635,4.943426 46.390973,4.944642 46.391122,4.945008 46.391158,4.944628 46.391993,4.94438 46.392654,4.944128 46.393269,4.943975 46.393558,4.943602 46.39411,4.943764 46.394068,4.944244 46.394211,4.944502 46.394235,4.945199 46.394261,4.945017 46.395083,4.944912 46.395509,4.944709 46.396624,4.944387 46.398043,4.944294 46.398536,4.943922 46.400298,4.943707 46.401274,4.94358 46.401784,4.943435 46.402607,4.943336 46.403007)))', 4326))
            AND ((tags->'amenity') = 'bench');