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 = '13067' 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 = 27698 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 = '13067';

"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:03:26', 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 = 27698;

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

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 = 27698 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'13067'') = ?
  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'13067'') = ?
      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 = '13067';

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.042913 43.806494,5.04314 43.80226,5.043178 43.801688,5.043448 43.797333,5.043499 43.796319,5.043591 43.795313,5.043801 43.794434,5.043929 43.793852,5.044196 43.793193,5.044523 43.792602,5.044874 43.792131,5.045529 43.791524,5.045957 43.791216,5.046293 43.790956,5.047066 43.790569,5.047418 43.790419,5.048 43.790002,5.049811 43.788727,5.056567 43.785988,5.065891 43.782217,5.07148 43.779809,5.07451 43.778742,5.077651 43.777611,5.090753 43.772067,5.085978 43.770361,5.085837 43.770295,5.084133 43.769713,5.083916 43.769662,5.083202 43.769454,5.082525 43.769214,5.082068 43.769084,5.080992 43.768741,5.080574 43.768623,5.077992 43.76763,5.075757 43.766758,5.075467 43.766689,5.074848 43.766628,5.073582 43.76629,5.072744 43.765918,5.071165 43.765188,5.071014 43.765073,5.070715 43.76494,5.068888 43.764294,5.067241 43.763674,5.066974 43.763652,5.066706 43.763748,5.066079 43.764102,5.065474 43.764245,5.065203 43.764246,5.064679 43.764167,5.062901 43.763919,5.06268 43.763873,5.062188 43.764002,5.061659 43.763988,5.06127 43.764026,5.060627 43.764163,5.060053 43.76439,5.059933 43.76442,5.058774 43.766347,5.057889 43.767839,5.057528 43.767727,5.057202 43.76757,5.0563 43.767181,5.055891 43.767036,5.055026 43.76671,5.054671 43.766632,5.053658 43.766672,5.053411 43.766634,5.053314 43.76655,5.053023 43.76652,5.052676 43.766604,5.052406 43.766533,5.049667 43.765652,5.049017 43.765438,5.049545 43.764399,5.049561 43.764183,5.049493 43.763852,5.049504 43.763701,5.049569 43.763565,5.049846 43.763253,5.049876 43.76313,5.049737 43.762897,5.049591 43.762798,5.048494 43.762235,5.048075 43.762053,5.047672 43.76183,5.047057 43.761451,5.041254 43.758521,5.040499 43.758052,5.040301 43.757904,5.039278 43.757254,5.039044 43.757089,5.038555 43.756794,5.037936 43.756396,5.037718 43.756273,5.036093 43.755264,5.035638 43.754991,5.035054 43.754621,5.034691 43.754471,5.034266 43.754229,5.033215 43.753766,5.029824 43.752473,5.028469 43.752934,5.02796 43.752988,5.027042 43.753187,5.026656 43.753413,5.026183 43.753467,5.02601 43.753377,5.025487 43.753161,5.02524 43.753098,5.024892 43.753252,5.02437 43.753379,5.023923 43.753388,5.023438 43.75337,5.02319 43.753307,5.022967 43.753218,5.022754 43.753065,5.022569 43.752786,5.022495 43.752371,5.022333 43.752156,5.022097 43.752038,5.021712 43.752039,5.021252 43.752013,5.02083 43.751922,5.020395 43.751725,5.020208 43.751616,5.019923 43.751266,5.019836 43.751041,5.019762 43.750581,5.019699 43.7505,5.01929 43.750474,5.019079 43.750555,5.018729 43.750599,5.018383 43.750529,5.01827 43.75043,5.018121 43.750141,5.01806 43.749918,5.015486 43.749998,5.015171 43.750023,5.014812 43.750006,5.01402 43.750006,5.013242 43.749994,5.010749 43.74994,5.010241 43.74996,5.009281 43.749942,5.009083 43.749955,5.008317 43.749953,5.007176 43.749928,5.006908 43.749931,5.005741 43.749875,5.004721 43.749889,5.003947 43.749882,5.003373 43.749799,5.002931 43.749719,5.002206 43.749655,5.001584 43.749546,5.001358 43.749532,5.001098 43.749472,5.000912 43.749394,5.000509 43.749412,4.99986 43.749305,4.999619 43.749253,4.998491 43.749087,4.997753 43.7489,4.997711 43.749514,4.99764 43.751001,4.997655 43.751523,4.997778 43.751908,4.997802 43.752048,4.996948 43.75292,4.996913 43.752946,4.996214 43.754818,4.996091 43.755203,4.995613 43.755553,4.995472 43.755708,4.995408 43.755945,4.995184 43.75635,4.995032 43.756491,4.994851 43.756568,4.994421 43.756869,4.994165 43.757028,4.993916 43.757456,4.993686 43.757891,4.992729 43.759628,4.992703 43.759649,4.991721 43.761375,4.991301 43.762039,4.990763 43.762949,4.990318 43.763653,4.99021 43.76386,4.989995 43.764199,4.989808 43.764388,4.989648 43.764649,4.989193 43.765151,4.988965 43.76554,4.988805 43.765977,4.988636 43.766307,4.988449 43.766609,4.987928 43.767626,4.987797 43.767974,4.98775 43.768174,4.987464 43.769151,4.987459 43.769461,4.987344 43.76979,4.987104 43.770547,4.98625 43.771967,4.98558 43.773154,4.985468 43.773323,4.985291 43.773419,4.985208 43.773546,4.984927 43.774166,4.984758 43.774483,4.984619 43.774671,4.984455 43.775026,4.984314 43.775265,4.98414 43.775669,4.984086 43.775864,4.983885 43.776147,4.983869 43.776261,4.983711 43.776467,4.983342 43.777452,4.982833 43.777844,4.982499 43.778378,4.98221 43.77872,4.981995 43.778823,4.981737 43.779274,4.981683 43.779681,4.981506 43.78009,4.981277 43.780457,4.981041 43.780657,4.980539 43.780923,4.979846 43.781398,4.979661 43.781575,4.979362 43.781804,4.979014 43.782128,4.978665 43.782405,4.978413 43.78266,4.978325 43.782855,4.978186 43.783057,4.977687 43.783587,4.9773 43.783878,4.976821 43.784133,4.97591 43.784715,4.975585 43.784987,4.975293 43.785259,4.975205 43.785255,4.974817 43.785652,4.974267 43.786069,4.973835 43.786478,4.973153 43.786998,4.972762 43.787238,4.971576 43.788137,4.97086 43.788748,4.969668 43.789709,4.968059 43.791016,4.969564 43.791371,4.970459 43.791573,4.971061 43.791727,4.971462 43.79181,4.974441 43.792518,4.975931 43.792876,4.976577 43.793041,4.978612 43.793519,4.979706 43.793781,4.981012 43.794067,4.982604 43.794472,4.983933 43.794768,4.985862 43.795234,4.988152 43.795771,4.990097 43.796233,4.991126 43.796595,4.991646 43.796754,4.992654 43.7971,4.993792 43.797482,4.996252 43.798329,4.997577 43.79876,4.999696 43.799475,5.000176 43.799629,5.002674 43.800469,5.002955 43.800572,5.003657 43.80069,5.003955 43.800705,5.005019 43.800642,5.005519 43.800621,5.005315 43.80078,5.005545 43.800905,5.005645 43.801148,5.005615 43.801551,5.005736 43.801779,5.006988 43.803242,5.007008 43.80334,5.007599 43.803598,5.007618 43.803663,5.008065 43.804065,5.008441 43.80422,5.009124 43.803924,5.009391 43.803848,5.009554 43.803723,5.009744 43.803716,5.010073 43.803661,5.010412 43.803632,5.010684 43.8035,5.010903 43.80343,5.011157 43.803399,5.011628 43.803254,5.011837 43.803045,5.011914 43.8028,5.012057 43.802615,5.01218 43.802603,5.01244 43.802487,5.012541 43.80231,5.012714 43.802283,5.013073 43.802348,5.013241 43.802415,5.013337 43.802598,5.013511 43.802806,5.013685 43.802969,5.013895 43.803227,5.014073 43.803379,5.014481 43.803937,5.015036 43.804145,5.015239 43.804307,5.015509 43.80387,5.016143 43.803595,5.016342 43.803902,5.016392 43.804112,5.016309 43.804425,5.016347 43.804712,5.016736 43.805139,5.017025 43.805405,5.017482 43.805879,5.017775 43.806148,5.018311 43.806548,5.018355 43.806637,5.018844 43.806924,5.018933 43.806994,5.01918 43.807054,5.019653 43.807036,5.019819 43.806985,5.020025 43.806992,5.020516 43.807194,5.020837 43.807409,5.021032 43.807436,5.021148 43.807648,5.021335 43.807732,5.021499 43.807909,5.022148 43.808329,5.022454 43.808795,5.022734 43.809063,5.023121 43.809634,5.023528 43.810065,5.02361 43.810377,5.023785 43.810595,5.0241 43.810482,5.024302 43.810515,5.024299 43.810361,5.02457 43.810313,5.02497 43.810118,5.025268 43.810072,5.025405 43.810094,5.025574 43.810211,5.025768 43.810529,5.026055 43.810845,5.026157 43.811131,5.026417 43.81137,5.026477 43.811654,5.026594 43.811846,5.026777 43.811929,5.026816 43.812031,5.027077 43.812388,5.02775 43.813194,5.027971 43.813406,5.028019 43.813539,5.027984 43.813707,5.027779 43.814092,5.027848 43.814262,5.028997 43.815422,5.028989 43.815542,5.029608 43.816,5.03089 43.81685,5.03157 43.817338,5.035471 43.819988,5.036675 43.818354,5.041248 43.811198,5.042913 43.806494)))', 4326))
            AND ((tags->'amenity') = 'bench');