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 = '13103' 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 = 27387 AND c0_.name IN ('waste_basket_count', 'waste_basket_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 = '13103';

"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\":\"waste_basket\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-14 06:09:41', 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 = 27387;

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

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 = 27387 AND z0_.theme = 'waste_basket' 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'13103'') = ?
  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'13103'') = ?
      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 = '13103';

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') = 'waste_basket'
  )

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.129979 43.622108,5.130032 43.621907,5.130038 43.621533,5.130082 43.621059,5.130087 43.620776,5.130165 43.619891,5.130204 43.618014,5.130091 43.617758,5.129372 43.616577,5.130298 43.616257,5.13149 43.615835,5.130555 43.614977,5.130487 43.614736,5.130118 43.614342,5.130217 43.613993,5.131826 43.609941,5.127427 43.61022,5.126674 43.610241,5.126528 43.610207,5.122947 43.609978,5.122972 43.609508,5.122972 43.609051,5.123026 43.608225,5.123024 43.608033,5.123191 43.60629,5.123033 43.605702,5.118582 43.603823,5.117053 43.603205,5.115244 43.602906,5.114958 43.603584,5.114672 43.604108,5.114267 43.604795,5.113572 43.60592,5.110891 43.604074,5.107986 43.601985,5.105082 43.600202,5.103995 43.599431,5.103427 43.599015,5.103154 43.598865,5.102617 43.598465,5.102222 43.598234,5.101702 43.597994,5.101342 43.59831,5.101291 43.598385,5.100547 43.59978,5.100185 43.600485,5.100079 43.60062,5.099798 43.601235,5.096021 43.598847,5.095866 43.599154,5.095499 43.59971,5.095428 43.599746,5.095052 43.600301,5.094988 43.600541,5.095087 43.600985,5.095274 43.601586,5.095655 43.601803,5.097042 43.602565,5.097176 43.602664,5.097393 43.602905,5.096875 43.603545,5.094907 43.605725,5.094191 43.606598,5.093872 43.606955,5.093597 43.606818,5.093068 43.606607,5.092951 43.606636,5.092809 43.607665,5.092959 43.607799,5.093089 43.608164,5.093287 43.608536,5.092948 43.609057,5.09286 43.609296,5.092119 43.611019,5.092082 43.611162,5.09191 43.6116,5.091797 43.61164,5.091677 43.611871,5.091363 43.612122,5.091042 43.612626,5.089812 43.614095,5.089379 43.614486,5.08924 43.614652,5.089176 43.6148,5.088918 43.615208,5.088756 43.615405,5.088824 43.615573,5.088705 43.615625,5.088602 43.61598,5.08835 43.615901,5.088004 43.615869,5.087786 43.615812,5.087604 43.615719,5.087377 43.61566,5.086987 43.61654,5.086917 43.616601,5.08661 43.617413,5.086616 43.617654,5.087005 43.618207,5.087148 43.618538,5.087236 43.619004,5.087173 43.61936,5.086961 43.619982,5.086806 43.62048,5.086711 43.6206,5.086214 43.621412,5.086206 43.621512,5.086575 43.621734,5.086693 43.621883,5.08683 43.622237,5.0869 43.622843,5.086977 43.622918,5.086974 43.623198,5.087102 43.623811,5.087105 43.623968,5.087194 43.624646,5.086576 43.624735,5.08507 43.624922,5.084924 43.624962,5.082406 43.625358,5.08221 43.625356,5.080951 43.625574,5.079713 43.625776,5.079499 43.625804,5.077609 43.626119,5.077401 43.626231,5.076559 43.626318,5.075845 43.626424,5.075089 43.626554,5.073665 43.626778,5.072979 43.626908,5.072053 43.627065,5.071266 43.627209,5.070507 43.627333,5.068712 43.627652,5.067554 43.627863,5.066601 43.628024,5.064803 43.628356,5.062961 43.628681,5.062482 43.628761,5.062296 43.628817,5.061619 43.628954,5.059179 43.629388,5.058858 43.629454,5.058444 43.629508,5.057943 43.629608,5.056944 43.629763,5.056543 43.629887,5.056234 43.629946,5.05511 43.63012,5.05346 43.630435,5.052717 43.630587,5.051459 43.630858,5.050997 43.630969,5.050671 43.631016,5.04855 43.631526,5.045639 43.63224,5.043695 43.632759,5.041839 43.633279,5.041152 43.633452,5.039289 43.633969,5.038292 43.634268,5.036722 43.634776,5.033347 43.635859,5.030763 43.636819,5.028383 43.637616,5.028041 43.637766,5.027771 43.637804,5.026742 43.638141,5.025747 43.638513,5.024756 43.638943,5.024521 43.638994,5.024419 43.638968,5.023227 43.639337,5.021934 43.639782,5.012471 43.642945,5.012348 43.63933,5.01213 43.633337,5.011959 43.629162,5.003459 43.622817,5.003278 43.622794,5.003051 43.622707,4.995218 43.620121,4.991336 43.618786,4.989085 43.6182,4.988804 43.61809,4.988617 43.618209,4.988404 43.618281,4.984921 43.620435,4.984291 43.620821,4.980749 43.622819,4.980591 43.622899,4.9801 43.623201,4.978412 43.624103,4.973963 43.626595,4.969344 43.629159,4.968772 43.629498,4.964244 43.632517,4.959756 43.63547,4.958015 43.636589,4.957108 43.637145,4.956246 43.637663,4.955633 43.638059,4.955453 43.638221,4.955067 43.638429,4.954097 43.639059,4.954708 43.639992,4.954518 43.639989,4.954984 43.64059,4.957714 43.644209,4.959368 43.646405,4.960684 43.64811,4.960866 43.648465,4.963293 43.651542,4.963654 43.651996,4.963743 43.652152,4.963796 43.652414,4.963997 43.652673,4.964101 43.652735,4.964372 43.653055,4.965424 43.654182,4.966417 43.655388,4.967671 43.656948,4.967953 43.657399,4.968827 43.658298,4.969954 43.657912,4.974638 43.656266,4.982971 43.653352,4.988236 43.651516,4.994353 43.649379,4.998371 43.647979,5.002294 43.649441,5.008829 43.65188,5.015559 43.654389,5.022298 43.656902,5.026629 43.658646,5.028506 43.659518,5.033159 43.661995,5.036676 43.663845,5.037616 43.664468,5.043672 43.6678,5.044698 43.668289,5.045542 43.668705,5.047005 43.669292,5.047411 43.669442,5.048403 43.66984,5.048766 43.670001,5.048943 43.670048,5.049639 43.67034,5.051797 43.671294,5.053043 43.671828,5.053863 43.672168,5.054447 43.672424,5.055235 43.67274,5.055588 43.672911,5.05688 43.673474,5.057951 43.673917,5.058727 43.674264,5.059806 43.67481,5.060047 43.674921,5.060477 43.675151,5.060808 43.675384,5.062638 43.676577,5.063884 43.677475,5.064841 43.678149,5.06737 43.679714,5.068159 43.680223,5.069622 43.681247,5.070715 43.682137,5.072114 43.683305,5.072805 43.683854,5.072926 43.683983,5.073064 43.683989,5.073304 43.68414,5.073519 43.684242,5.074119 43.684455,5.074475 43.684552,5.074902 43.684608,5.076285 43.684768,5.079054 43.685194,5.07948 43.685311,5.080265 43.685384,5.080836 43.685421,5.081101 43.685423,5.085179 43.685326,5.085622 43.685274,5.086697 43.685227,5.088797 43.685153,5.089046 43.685161,5.090262 43.685093,5.093837 43.684822,5.094248 43.684809,5.097245 43.68459,5.101008 43.684334,5.105249 43.683731,5.106205 43.683656,5.108868 43.683717,5.111197 43.685859,5.112472 43.687552,5.113055 43.687981,5.115004 43.686084,5.115272 43.685684,5.115717 43.685104,5.115878 43.685044,5.116331 43.684789,5.116852 43.684281,5.117227 43.684095,5.118327 43.682439,5.118946 43.681708,5.118971 43.681577,5.119123 43.681324,5.119536 43.681045,5.119726 43.68081,5.119789 43.680558,5.119831 43.680114,5.120223 43.679642,5.12064 43.67918,5.120918 43.678686,5.121238 43.678224,5.12186 43.677242,5.122144 43.677143,5.122425 43.676954,5.122433 43.676767,5.122716 43.676735,5.123152 43.676736,5.123572 43.676639,5.124029 43.676838,5.124691 43.676251,5.124776 43.676002,5.124993 43.675846,5.125305 43.675561,5.126156 43.674875,5.126446 43.67446,5.126628 43.67432,5.127026 43.674177,5.127219 43.674067,5.127399 43.674026,5.127592 43.673924,5.127509 43.673539,5.12762 43.6732,5.128661 43.672189,5.12924 43.671711,5.129575 43.671392,5.129683 43.671356,5.130147 43.670856,5.130473 43.670359,5.131267 43.669783,5.131945 43.669122,5.132725 43.668453,5.133432 43.668003,5.134636 43.667588,5.135753 43.666968,5.136857 43.666633,5.137509 43.666465,5.138229 43.666312,5.140279 43.665944,5.141146 43.665782,5.141263 43.665785,5.141621 43.665621,5.14188 43.665233,5.142364 43.664391,5.142694 43.66391,5.142898 43.663713,5.143979 43.661698,5.143936 43.661588,5.143953 43.661435,5.1439 43.661229,5.143879 43.660967,5.143897 43.660796,5.143887 43.660427,5.143818 43.660003,5.143834 43.659745,5.143899 43.65956,5.143813 43.659375,5.143518 43.659155,5.143381 43.658961,5.143292 43.658773,5.143013 43.658308,5.14288 43.658167,5.142565 43.657729,5.142091 43.657352,5.141967 43.657229,5.141817 43.656831,5.141486 43.656056,5.141416 43.655768,5.141311 43.655559,5.139894 43.654593,5.139286 43.653951,5.139154 43.653922,5.138908 43.653708,5.138869 43.653596,5.138512 43.653311,5.138418 43.653058,5.138265 43.652774,5.138199 43.65256,5.138057 43.652397,5.138003 43.652256,5.137612 43.651967,5.137421 43.651514,5.137134 43.651286,5.136384 43.65085,5.136029 43.650458,5.135654 43.650465,5.135076 43.649263,5.134928 43.648835,5.134606 43.648133,5.134513 43.647978,5.13452 43.647799,5.134149 43.647505,5.133535 43.647119,5.133219 43.646889,5.133073 43.646866,5.132921 43.646742,5.13269 43.646498,5.132475 43.646453,5.132313 43.646225,5.132209 43.646136,5.131826 43.645956,5.131233 43.645775,5.130864 43.6456,5.130753 43.645498,5.130499 43.645339,5.129742 43.644916,5.129684 43.644791,5.129575 43.644733,5.129512 43.644559,5.129368 43.644474,5.128888 43.644444,5.128565 43.64447,5.127846 43.644358,5.128531 43.644028,5.128749 43.643547,5.128728 43.642755,5.129059 43.642482,5.129358 43.641825,5.129145 43.641717,5.128676 43.641584,5.128476 43.641566,5.128108 43.641444,5.127953 43.641302,5.12756 43.641327,5.127717 43.640665,5.127926 43.64037,5.127633 43.640137,5.127643 43.639859,5.127772 43.639466,5.127976 43.639342,5.128168 43.638622,5.128166 43.63835,5.12829 43.638157,5.12886 43.637753,5.129123 43.637311,5.129097 43.636823,5.129262 43.636693,5.129433 43.636734,5.129509 43.636187,5.129648 43.635941,5.12959 43.63567,5.129369 43.635559,5.129215 43.635538,5.129008 43.6353,5.12878 43.635212,5.128682 43.635113,5.128997 43.634952,5.129625 43.634531,5.130094 43.634287,5.130373 43.634182,5.13103 43.633986,5.130662 43.633182,5.130541 43.632963,5.130471 43.632718,5.130601 43.632503,5.130609 43.632261,5.130537 43.631838,5.130663 43.631558,5.130709 43.631129,5.131354 43.631209,5.131524 43.630865,5.131648 43.630454,5.13178 43.630086,5.131865 43.629492,5.131925 43.629252,5.132379 43.628012,5.132412 43.627896,5.132732 43.628011,5.133368 43.628323,5.133395 43.62788,5.133867 43.626282,5.133748 43.626266,5.133496 43.626362,5.133243 43.62636,5.132837 43.626229,5.132469 43.626186,5.132072 43.626079,5.13175 43.625944,5.131492 43.625938,5.131044 43.626087,5.13055 43.626198,5.129906 43.626236,5.129579 43.626109,5.128994 43.625645,5.128554 43.625348,5.128084 43.625124,5.127466 43.624667,5.127495 43.624508,5.127797 43.623978,5.127994 43.62344,5.12812 43.62326,5.128497 43.623297,5.128821 43.623361,5.129646 43.623578,5.129918 43.622605,5.129979 43.622108)))', 4326))
            AND ((tags->'amenity') = 'waste_basket');