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 = '57463' 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 = 24977 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 = '57463';

"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 11:12:30', 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 = 24977;

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

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 = 24977 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'57463'') = ?
  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'57463'') = ?
      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 = '57463';

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(((6.148508 49.118861,6.148368 49.119351,6.149182 49.119667,6.148675 49.11995,6.148829 49.120128,6.149133 49.120245,6.149307 49.120407,6.149647 49.120911,6.149851 49.121282,6.150517 49.121474,6.154004 49.122581,6.155024 49.12289,6.15605 49.123227,6.156741 49.123433,6.157246 49.123604,6.157579 49.123753,6.157898 49.123933,6.158433 49.124321,6.158829 49.124711,6.159076 49.125008,6.158946 49.125348,6.15868 49.125579,6.158069 49.12574,6.155183 49.126486,6.154695 49.12662,6.153861 49.12683,6.153482 49.12695,6.153077 49.12712,6.151259 49.128086,6.151002 49.128177,6.150641 49.128253,6.150271 49.128283,6.147261 49.128411,6.14695 49.128415,6.145076 49.128481,6.144673 49.128511,6.143385 49.128663,6.142904 49.128757,6.142457 49.12877,6.142205 49.128758,6.141141 49.128788,6.140508 49.128842,6.139408 49.128989,6.138493 49.129069,6.136555 49.129352,6.136545 49.1301,6.136556 49.13069,6.136516 49.130785,6.136687 49.131936,6.136732 49.132005,6.137503 49.132297,6.138552 49.132576,6.138701 49.132823,6.138768 49.133083,6.138802 49.133379,6.138782 49.13372,6.138506 49.135188,6.138309 49.135468,6.1381 49.135826,6.137912 49.136021,6.137524 49.136234,6.137272 49.136344,6.13691 49.136694,6.136804 49.136755,6.136795 49.136866,6.136273 49.137488,6.136002 49.137869,6.136714 49.138118,6.137132 49.138246,6.137733 49.138387,6.138031 49.138485,6.138822 49.138708,6.139564 49.13882,6.139271 49.138891,6.138914 49.139043,6.138671 49.139176,6.13893 49.139304,6.139371 49.139421,6.140042 49.139565,6.140203 49.139631,6.140042 49.139979,6.13974 49.140688,6.139937 49.140722,6.139793 49.141016,6.13951 49.140977,6.139272 49.141521,6.139068 49.141898,6.139532 49.142064,6.139082 49.14295,6.139707 49.14308,6.140423 49.143194,6.140688 49.143221,6.141464 49.143239,6.142021 49.143193,6.142447 49.143214,6.143563 49.143164,6.144593 49.143233,6.14543 49.143226,6.146424 49.143302,6.147605 49.143432,6.147778 49.143406,6.14774 49.143245,6.147751 49.143018,6.147908 49.14242,6.148054 49.141679,6.148343 49.141044,6.148352 49.140858,6.150654 49.141114,6.151496 49.141175,6.151533 49.140811,6.151348 49.14079,6.151735 49.140018,6.152649 49.140002,6.153096 49.140004,6.153339 49.14012,6.154314 49.14108,6.155306 49.142122,6.155697 49.142488,6.156063 49.142398,6.156204 49.142516,6.156573 49.142663,6.157178 49.142489,6.159293 49.141657,6.160255 49.141867,6.160858 49.142056,6.161313 49.142081,6.161382 49.141495,6.162841 49.141522,6.16291 49.142036,6.164831 49.14232,6.1646 49.142698,6.164178 49.143288,6.163609 49.144105,6.165218 49.144595,6.165291 49.144466,6.165656 49.144575,6.16577 49.144401,6.165928 49.144437,6.166058 49.144388,6.166399 49.144482,6.166257 49.144704,6.166875 49.144891,6.167462 49.145044,6.167721 49.145138,6.16821 49.145255,6.168141 49.145387,6.169247 49.145712,6.169179 49.146906,6.170111 49.14722,6.169715 49.148199,6.170171 49.148496,6.171736 49.148828,6.171802 49.148722,6.172186 49.148482,6.173093 49.147947,6.173351 49.147832,6.173693 49.14775,6.174897 49.14737,6.175399 49.147188,6.175821 49.147067,6.177379 49.14677,6.177977 49.146642,6.178459 49.146577,6.179798 49.146335,6.180495 49.146215,6.182062 49.145968,6.182639 49.145895,6.183362 49.145818,6.183711 49.145699,6.186151 49.144553,6.185969 49.142195,6.186971 49.142135,6.187391 49.14206,6.187626 49.141958,6.189503 49.141008,6.190811 49.140975,6.191158 49.141309,6.191739 49.142197,6.19301 49.142211,6.193618 49.143204,6.195114 49.14333,6.196461 49.143552,6.197468 49.143827,6.197878 49.143969,6.198756 49.14376,6.198117 49.142631,6.197594 49.141618,6.197486 49.141535,6.197556 49.140712,6.197721 49.140188,6.197765 49.139923,6.197739 49.139547,6.197828 49.138864,6.197982 49.138375,6.198267 49.137688,6.198272 49.137473,6.198221 49.137209,6.198093 49.136892,6.197668 49.13623,6.197225 49.135495,6.19677 49.134778,6.196358 49.13409,6.195609 49.133061,6.195363 49.132697,6.194824 49.131961,6.19421 49.131237,6.193886 49.130971,6.19231 49.129909,6.192014 49.129734,6.191421 49.129454,6.191015 49.129201,6.190693 49.12908,6.190285 49.128882,6.189852 49.128601,6.189156 49.128303,6.18874 49.128056,6.188463 49.127822,6.188159 49.127653,6.188566 49.12726,6.188616 49.12718,6.189555 49.126328,6.189669 49.126244,6.189966 49.126332,6.191159 49.126608,6.192115 49.126781,6.193018 49.126955,6.193328 49.127024,6.19332 49.126875,6.193791 49.126617,6.195364 49.125866,6.195129 49.125449,6.195852 49.125194,6.195869 49.124833,6.197788 49.124201,6.197185 49.123468,6.197479 49.123352,6.197871 49.123116,6.198192 49.122772,6.198311 49.122439,6.198517 49.12263,6.199929 49.122254,6.199994 49.122173,6.200241 49.122165,6.199839 49.121305,6.200753 49.121187,6.201635 49.121037,6.202277 49.120913,6.202631 49.120863,6.203349 49.120853,6.203374 49.121588,6.203319 49.121833,6.203044 49.122128,6.202479 49.122478,6.202177 49.122763,6.201966 49.123079,6.201758 49.123475,6.201542 49.123776,6.201516 49.123905,6.201633 49.124078,6.201904 49.12462,6.203013 49.124596,6.202879 49.124653,6.203099 49.125025,6.203895 49.124848,6.204116 49.12487,6.204219 49.124794,6.204249 49.124622,6.204649 49.124646,6.205737 49.124506,6.206766 49.124297,6.206757 49.124573,6.206674 49.125567,6.206753 49.125917,6.206873 49.126066,6.207059 49.126187,6.20754 49.12638,6.207839 49.126367,6.207871 49.126772,6.208421 49.126799,6.208459 49.127305,6.207856 49.127297,6.206452 49.127321,6.206429 49.127997,6.20605 49.127922,6.205449 49.127911,6.204467 49.128027,6.204299 49.128581,6.205941 49.129023,6.205852 49.129259,6.205664 49.129552,6.206055 49.129623,6.205824 49.130142,6.207101 49.130548,6.209389 49.1318,6.209087 49.132036,6.210899 49.133032,6.211216 49.13322,6.210837 49.133498,6.210384 49.133912,6.209912 49.134505,6.210356 49.134647,6.21029 49.13479,6.209928 49.135244,6.209568 49.135662,6.209078 49.136314,6.209794 49.136952,6.210116 49.137173,6.210546 49.137382,6.210846 49.137505,6.211182 49.137595,6.211569 49.137653,6.211972 49.137776,6.212079 49.137772,6.212895 49.136318,6.212933 49.136203,6.21317 49.135957,6.214197 49.136484,6.216066 49.137301,6.216897 49.136504,6.217214 49.136688,6.21769 49.137087,6.21814 49.137346,6.218997 49.137871,6.219257 49.137647,6.219805 49.137261,6.220783 49.136672,6.220944 49.13655,6.221039 49.136398,6.221501 49.136162,6.221787 49.135993,6.221996 49.13571,6.222095 49.135481,6.222309 49.135143,6.222862 49.134573,6.22319 49.134353,6.223249 49.134276,6.223635 49.134014,6.22373 49.133853,6.224254 49.133415,6.224596 49.133091,6.223823 49.132792,6.223434 49.132682,6.223432 49.13265,6.223755 49.132311,6.223888 49.13209,6.224168 49.131788,6.224924 49.130755,6.225216 49.129783,6.225284 49.129136,6.225346 49.128898,6.22596 49.127982,6.225987 49.127594,6.22613 49.127552,6.226812 49.127274,6.227365 49.127178,6.227669 49.127305,6.227951 49.126853,6.228008 49.126299,6.229372 49.126602,6.229845 49.126716,6.230824 49.124931,6.231447 49.123339,6.232591 49.123693,6.233268 49.122055,6.233544 49.12106,6.233668 49.120539,6.233937 49.119555,6.233956 49.119387,6.238376 49.119726,6.238347 49.119856,6.238841 49.119894,6.23894 49.119829,6.239443 49.119849,6.241617 49.119912,6.242008 49.119955,6.242137 49.119936,6.242206 49.119723,6.242233 49.119636,6.242632 49.119627,6.24307 49.119569,6.243605 49.119422,6.244191 49.119191,6.245622 49.118575,6.246473 49.118325,6.247179 49.118174,6.248102 49.118163,6.250156 49.118262,6.251201 49.118333,6.251828 49.116387,6.2518 49.116183,6.251966 49.115123,6.252116 49.114235,6.252102 49.11405,6.251034 49.113987,6.249569 49.113878,6.249616 49.112823,6.249613 49.11224,6.249451 49.110686,6.250088 49.110667,6.25006 49.110178,6.250127 49.11012,6.251781 49.109817,6.252852 49.109644,6.253625 49.109489,6.254898 49.109174,6.25622 49.108661,6.256189 49.10853,6.256465 49.108358,6.253129 49.10749,6.252927 49.107397,6.251856 49.106995,6.251439 49.106791,6.251335 49.106717,6.250549 49.1063,6.250246 49.106159,6.249855 49.105899,6.249751 49.105915,6.249556 49.106088,6.249034 49.105956,6.248503 49.105848,6.247502 49.105721,6.246583 49.105675,6.245857 49.105719,6.246421 49.103605,6.247187 49.103066,6.247066 49.102549,6.247046 49.101821,6.246957 49.101687,6.245919 49.100615,6.245706 49.100256,6.245292 49.099788,6.245531 49.099159,6.245379 49.098884,6.245162 49.098104,6.245892 49.097844,6.246209 49.097711,6.247401 49.097253,6.248066 49.096954,6.248772 49.09676,6.249347 49.096661,6.249658 49.096551,6.249882 49.09651,6.250282 49.096172,6.251064 49.095768,6.251907 49.095251,6.251671 49.095061,6.251478 49.094805,6.251747 49.094316,6.252976 49.093525,6.252858 49.093359,6.254056 49.093021,6.253981 49.092805,6.250431 49.092966,6.250636 49.092552,6.249869 49.092413,6.248437 49.090826,6.246597 49.089572,6.244909 49.088853,6.243721 49.088294,6.242905 49.087788,6.2423 49.087541,6.24175 49.087371,6.24099 49.087236,6.240111 49.08706,6.239099 49.086785,6.238512 49.086641,6.238073 49.086564,6.237493 49.086438,6.236908 49.086189,6.236169 49.08596,6.236273 49.085767,6.234961 49.085514,6.234584 49.085415,6.234025 49.085167,6.233768 49.085078,6.232995 49.08547,6.232678 49.085606,6.232133 49.085881,6.231891 49.085949,6.231683 49.085954,6.231319 49.08585,6.230943 49.086135,6.230521 49.086506,6.230264 49.086822,6.229953 49.086737,6.227799 49.086115,6.226406 49.085669,6.224703 49.085065,6.224575 49.085134,6.223526 49.085937,6.222519 49.086928,6.222025 49.087356,6.220138 49.088726,6.219878 49.088902,6.219416 49.089157,6.218248 49.089731,6.21797 49.089911,6.21751 49.090326,6.216834 49.089954,6.215857 49.089526,6.214535 49.088932,6.213883 49.088653,6.213667 49.088503,6.213672 49.08836,6.213777 49.08825,6.214248 49.087934,6.214401 49.087785,6.21481 49.087506,6.212422 49.086182,6.210437 49.0852,6.21044 49.084445,6.210565 49.083944,6.212412 49.084057,6.212476 49.083878,6.212529 49.083541,6.212574 49.08347,6.212677 49.082593,6.212701 49.0822,6.213192 49.082188,6.213166 49.081613,6.210986 49.080739,6.210529 49.079822,6.211962 49.076459,6.205723 49.075408,6.204516 49.07502,6.203981 49.074928,6.202341 49.074578,6.202007 49.074492,6.201674 49.074446,6.201398 49.074357,6.201114 49.0743,6.200417 49.074132,6.200135 49.074042,6.199621 49.073918,6.199106 49.073853,6.198674 49.073869,6.198274 49.07383,6.198162 49.073881,6.197186 49.073751,6.196833 49.073713,6.195943 49.073562,6.195972 49.073341,6.196036 49.073274,6.196316 49.072841,6.196452 49.072669,6.196826 49.072061,6.19698 49.071914,6.197231 49.071596,6.197301 49.071421,6.197406 49.071361,6.197697 49.070979,6.197412 49.070973,6.199719 49.070082,6.200065 49.069931,6.200743 49.069705,6.201292 49.069445,6.20175 49.069208,6.202276 49.068891,6.202557 49.06861,6.202787 49.068149,6.202932 49.067924,6.203617 49.067196,6.203786 49.067098,6.204092 49.066499,6.204219 49.066127,6.204197 49.065593,6.204115 49.064717,6.204062 49.064514,6.203817 49.064162,6.203689 49.063884,6.203701 49.063701,6.203416 49.063668,6.203044 49.063588,6.201016 49.063233,6.200821 49.063166,6.19986 49.062931,6.199495 49.06282,6.198924 49.06267,6.198147 49.062435,6.197308 49.062116,6.196548 49.061863,6.195509 49.061491,6.194268 49.061069,6.193943 49.061003,6.193424 49.060822,6.193293 49.061335,6.193314 49.061505,6.193158 49.061765,6.192881 49.062001,6.192775 49.062046,6.192648 49.062296,6.192357 49.062461,6.191978 49.062912,6.191798 49.063059,6.19147 49.063179,6.190602 49.063581,6.19014 49.063844,6.190023 49.063948,6.189938 49.064167,6.189595 49.064488,6.186664 49.066664,6.185524 49.067156,6.185327 49.067038,6.184393 49.066602,6.184255 49.066524,6.184108 49.066908,6.18328 49.066625,6.182706 49.066511,6.182607 49.066816,6.181715 49.066783,6.181767 49.066584,6.180961 49.066423,6.177639 49.065466,6.176758 49.065082,6.17659 49.064854,6.176482 49.064796,6.174107 49.063761,6.174279 49.063503,6.173075 49.063167,6.172699 49.063269,6.172443 49.063665,6.172168 49.064137,6.172223 49.064171,6.172044 49.064414,6.171965 49.064469,6.171767 49.064773,6.17155 49.065212,6.17139 49.065188,6.171077 49.065759,6.171546 49.065863,6.170865 49.066498,6.170127 49.067071,6.169903 49.067233,6.170615 49.068349,6.1696 49.069046,6.169562 49.06911,6.169235 49.069332,6.169675 49.069491,6.170321 49.069856,6.17095 49.070374,6.171612 49.070766,6.17148 49.07087,6.170704 49.071749,6.169252 49.071439,6.168467 49.073582,6.168078 49.073694,6.167931 49.074254,6.166898 49.074162,6.166739 49.074026,6.165258 49.073272,6.164943 49.073076,6.164723 49.072716,6.164387 49.072321,6.164084 49.072573,6.16371 49.073028,6.163853 49.073063,6.16428 49.073257,6.163797 49.074291,6.1632 49.075894,6.165379 49.07627,6.166996 49.076619,6.166551 49.079281,6.165731 49.079141,6.164669 49.081378,6.164769 49.081539,6.164891 49.081577,6.166068 49.081695,6.166559 49.081727,6.167037 49.081709,6.167971 49.08165,6.168347 49.081666,6.169003 49.081749,6.169737 49.081795,6.171274 49.081843,6.171773 49.081845,6.172463 49.081791,6.172944 49.081653,6.173122 49.081553,6.173462 49.081283,6.173685 49.080988,6.174047 49.080202,6.174871 49.079552,6.175604 49.079968,6.175992 49.079847,6.176667 49.079775,6.178316 49.079784,6.180035 49.079708,6.181001 49.079832,6.181616 49.08,6.181837 49.080088,6.182037 49.080286,6.182047 49.0804,6.181997 49.080716,6.181843 49.081235,6.181698 49.081467,6.181357 49.081847,6.181242 49.082048,6.180917 49.082326,6.180276 49.082351,6.179769 49.082423,6.17939 49.082558,6.179176 49.082675,6.178777 49.082993,6.17857 49.083201,6.177967 49.083883,6.177643 49.08437,6.177458 49.08475,6.177397 49.084929,6.177326 49.085291,6.177279 49.085802,6.177323 49.086635,6.177255 49.087015,6.177463 49.087035,6.177558 49.087381,6.177484 49.087631,6.177244 49.088139,6.177192 49.08819,6.17692 49.088669,6.176629 49.089432,6.176309 49.089921,6.175846 49.090329,6.175522 49.090461,6.175474 49.090574,6.175069 49.091012,6.174431 49.091491,6.173865 49.091988,6.173192 49.092627,6.17261 49.09321,6.172105 49.093671,6.171621 49.094074,6.171349 49.09423,6.171084 49.095797,6.163125 49.097703,6.163012 49.09771,6.161293 49.098198,6.160904 49.098329,6.160416 49.098466,6.158909 49.098868,6.157538 49.099218,6.158657 49.100766,6.158852 49.100951,6.159146 49.101168,6.160027 49.10171,6.161189 49.102613,6.16172 49.10308,6.161927 49.103396,6.16194 49.103561,6.163234 49.105002,6.163658 49.105567,6.164167 49.106166,6.164004 49.106218,6.163289 49.1068,6.163139 49.106908,6.162576 49.107386,6.161465 49.108104,6.16112 49.107932,6.160176 49.108483,6.160503 49.108894,6.160925 49.109345,6.161768 49.110221,6.162284 49.110787,6.162404 49.110939,6.163075 49.11142,6.163649 49.111763,6.164314 49.112114,6.164615 49.112309,6.164962 49.112586,6.165216 49.112922,6.165369 49.113172,6.165466 49.113401,6.165671 49.114221,6.165709 49.114877,6.165826 49.115911,6.165986 49.116438,6.166217 49.116818,6.16647 49.117089,6.166847 49.117411,6.166263 49.117483,6.165818 49.117594,6.164923 49.117963,6.164324 49.118233,6.163896 49.118389,6.163383 49.11852,6.162705 49.118631,6.16227 49.11867,6.161572 49.118709,6.160841 49.11862,6.159601 49.11833,6.158343 49.117986,6.158035 49.117919,6.157456 49.117876,6.15684 49.117906,6.156298 49.117996,6.155735 49.118133,6.154743 49.118436,6.154223 49.118624,6.153561 49.118763,6.15276 49.118871,6.148508 49.118861)))', 4326))
            AND ((tags->'amenity') = 'bench');