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 = '12063' 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 = 26072 AND c0_.name IN ('charging_station_count', 'charging_station_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 = '12063';

"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\":\"charging_station\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-15 08:22:46', 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 = 26072;

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

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 = 26072 AND z0_.theme = 'charging_station' 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'12063'') = ?
  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'12063'') = ?
      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 = '12063';

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

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(((3.125822 44.028219,3.126455 44.028079,3.129123 44.027251,3.130299 44.026747,3.131287 44.026111,3.132401 44.025563,3.133951 44.024967,3.136071 44.024278,3.138118 44.023589,3.139857 44.023171,3.141365 44.0228,3.14192 44.02274,3.142538 44.022594,3.142714 44.022581,3.143103 44.022633,3.143499 44.022813,3.144231 44.023036,3.14486 44.023204,3.14517 44.023318,3.145169 44.022881,3.145315 44.022348,3.145371 44.022058,3.145435 44.021906,3.145416 44.021325,3.145429 44.02109,3.145572 44.020808,3.145606 44.020458,3.145708 44.020241,3.145638 44.020171,3.14581 44.019959,3.146372 44.019538,3.146648 44.019348,3.146829 44.019266,3.146891 44.019332,3.147156 44.019321,3.147462 44.019218,3.14772 44.018978,3.148031 44.01884,3.148724 44.019374,3.148978 44.019642,3.150111 44.020488,3.15117 44.02048,3.151794 44.020565,3.152483 44.020785,3.153047 44.021059,3.153737 44.021368,3.154672 44.021497,3.15512 44.021358,3.156046 44.020766,3.156968 44.019951,3.157582 44.019308,3.158192 44.018404,3.1585 44.018132,3.159525 44.01781,3.159701 44.017771,3.160229 44.017376,3.160608 44.017129,3.16186 44.016504,3.163562 44.017375,3.163173 44.018196,3.162881 44.019546,3.162713 44.020896,3.162725 44.02166,3.162493 44.022876,3.162516 44.024405,3.163397 44.025072,3.164048 44.025858,3.164574 44.025973,3.164808 44.026089,3.165989 44.026758,3.166448 44.027541,3.16658 44.028277,3.167867 44.028689,3.169436 44.029232,3.170458 44.030692,3.172292 44.032575,3.173378 44.033511,3.173885 44.034046,3.174833 44.035028,3.175342 44.035653,3.176102 44.036501,3.176103 44.036546,3.178378 44.038696,3.17977 44.040123,3.184378 44.043963,3.184547 44.04702,3.184511 44.050954,3.184559 44.050965,3.184328 44.051757,3.18548 44.051571,3.18704 44.0511,3.188093 44.050731,3.190955 44.049718,3.193693 44.048761,3.193868 44.04874,3.19435 44.048552,3.194898 44.048307,3.195197 44.048144,3.195695 44.047766,3.195927 44.047571,3.196085 44.0474,3.196907 44.04696,3.197486 44.046711,3.197969 44.04643,3.198279 44.046307,3.198721 44.04618,3.199428 44.045803,3.199688 44.0456,3.200022 44.04538,3.200686 44.044993,3.203495 44.043699,3.208168 44.040896,3.208587 44.040659,3.208841 44.040633,3.209811 44.040453,3.210499 44.040197,3.212974 44.039111,3.213154 44.039056,3.214747 44.038442,3.21503 44.038368,3.216667 44.037863,3.219086 44.037079,3.220586 44.036618,3.222183 44.036497,3.226695 44.036941,3.228261 44.037194,3.228326 44.036115,3.228147 44.035782,3.22784 44.03513,3.227656 44.034611,3.227449 44.034137,3.227197 44.033697,3.226933 44.033629,3.226704 44.033392,3.22658 44.033193,3.226112 44.032362,3.225971 44.032029,3.225918 44.031839,3.22594 44.031657,3.226028 44.030469,3.226599 44.028326,3.226572 44.028151,3.226633 44.027677,3.226627 44.027517,3.226449 44.026348,3.226156 44.02605,3.225878 44.025674,3.225792 44.025453,3.22576 44.02496,3.225683 44.024519,3.225657 44.024128,3.225666 44.023959,3.22536 44.022168,3.225206 44.021773,3.225296 44.021697,3.225342 44.021519,3.225308 44.021279,3.2253 44.020902,3.22527 44.020683,3.225306 44.020498,3.225443 44.020148,3.225461 44.019889,3.2254 44.019703,3.225244 44.019413,3.22508 44.019161,3.224819 44.018857,3.224688 44.018589,3.224503 44.018384,3.224516 44.018141,3.224597 44.017909,3.224745 44.017697,3.224925 44.017493,3.225352 44.017131,3.226045 44.01664,3.226419 44.016296,3.226627 44.015974,3.2266 44.015744,3.226552 44.014837,3.226961 44.012352,3.227067 44.011138,3.227177 44.010193,3.22728 44.008844,3.227449 44.007718,3.227614 44.006278,3.227822 44.003705,3.227625 44.003032,3.227485 44.00209,3.227305 44.001168,3.227194 44.000729,3.226999 43.999887,3.226998 43.999739,3.227076 43.999371,3.227082 43.999219,3.227024 43.998876,3.226955 43.997778,3.226905 43.997175,3.226863 43.996457,3.226763 43.995791,3.226579 43.995031,3.226511 43.99482,3.226528 43.991883,3.22676 43.990086,3.226977 43.988948,3.22716 43.988209,3.227447 43.986967,3.226613 43.986857,3.224848 43.98718,3.224035 43.987483,3.222976 43.987722,3.221983 43.987911,3.220801 43.98801,3.219539 43.987705,3.219225 43.987528,3.216768 43.98575,3.216389 43.985384,3.21588 43.984624,3.214528 43.982509,3.214373 43.982424,3.214227 43.982222,3.214142 43.98202,3.213968 43.981743,3.213489 43.981109,3.213395 43.980916,3.213013 43.98051,3.212641 43.98019,3.212529 43.980133,3.212209 43.980101,3.21175 43.980086,3.210474 43.979997,3.209889 43.979976,3.209336 43.979982,3.208839 43.980007,3.208401 43.98,3.207667 43.979969,3.207035 43.979997,3.206731 43.979978,3.206089 43.980001,3.205652 43.980461,3.205103 43.980971,3.203809 43.981835,3.203229 43.981087,3.201716 43.980816,3.20141 43.980999,3.201116 43.981089,3.200665 43.981056,3.199575 43.98114,3.199264 43.9812,3.198841 43.981309,3.198653 43.981291,3.19704 43.982809,3.194972 43.983627,3.193887 43.983973,3.191561 43.985705,3.191034 43.986176,3.190847 43.986323,3.190495 43.98686,3.190311 43.9872,3.190249 43.987359,3.190229 43.987553,3.189452 43.989266,3.188803 43.990756,3.188086 43.992524,3.187855 43.992991,3.187696 43.993428,3.187649 43.993678,3.187586 43.994448,3.187503 43.994983,3.187339 43.995537,3.187146 43.995923,3.186981 43.996188,3.186988 43.996243,3.180447 43.99313,3.180026 43.99273,3.179273 43.992331,3.178459 43.992067,3.175586 43.99146,3.175708 43.991235,3.17623 43.988704,3.176405 43.987894,3.176877 43.985327,3.177053 43.984607,3.17714 43.98374,3.17734 43.983472,3.177556 43.983102,3.17784 43.982688,3.178071 43.982293,3.178428 43.981602,3.178571 43.981279,3.178576 43.981193,3.17878 43.980706,3.178943 43.980577,3.179313 43.98003,3.179602 43.979421,3.179746 43.979061,3.179884 43.978987,3.179331 43.97884,3.179405 43.978629,3.178822 43.978577,3.178328 43.978116,3.177515 43.977896,3.176829 43.977812,3.175335 43.977868,3.173725 43.978464,3.172915 43.978336,3.171969 43.978343,3.171285 43.978484,3.17029 43.979162,3.169746 43.979292,3.169178 43.979084,3.168806 43.979222,3.168129 43.979722,3.167458 43.980625,3.167274 43.980851,3.167275 43.980941,3.167464 43.981075,3.167342 43.981255,3.166724 43.98162,3.166052 43.981827,3.165783 43.981959,3.165667 43.982072,3.165293 43.982543,3.164993 43.982864,3.164927 43.982965,3.164446 43.983216,3.164021 43.983485,3.163435 43.983896,3.163127 43.98421,3.162884 43.984421,3.16218 43.984909,3.161663 43.985315,3.161033 43.985748,3.160033 43.986363,3.159502 43.986723,3.158847 43.987148,3.158531 43.987319,3.15827 43.987435,3.157972 43.987613,3.157803 43.987761,3.157581 43.988004,3.15721 43.988683,3.156953 43.989035,3.156771 43.989222,3.156361 43.989552,3.156054 43.989894,3.155659 43.990272,3.155603 43.990615,3.155442 43.990727,3.15425 43.99128,3.15354 43.991508,3.152632 43.991847,3.152154 43.99206,3.152025 43.992071,3.151749 43.992386,3.151302 43.992678,3.15023 43.993267,3.149942 43.993382,3.148875 43.993761,3.148579 43.993849,3.147134 43.994141,3.146609 43.994273,3.146196 43.994408,3.145716 43.994589,3.144866 43.994738,3.144034 43.99494,3.143579 43.995083,3.142949 43.995339,3.14226 43.995527,3.141905 43.995593,3.141587 43.995625,3.141138 43.995719,3.140003 43.996115,3.138844 43.996596,3.13843 43.996726,3.137343 43.997039,3.138012 43.997578,3.139133 43.99757,3.139756 43.99761,3.139688 43.998208,3.139162 43.998184,3.138964 43.99883,3.139046 43.999702,3.137919 43.999781,3.135118 43.999892,3.134436 44.000122,3.133657 44.001076,3.132766 44.001842,3.132582 44.002023,3.132395 44.001935,3.131528 44.001363,3.130359 44.002596,3.130009 44.002833,3.12967 44.002993,3.129217 44.003277,3.129068 44.003432,3.128376 44.004466,3.128206 44.004653,3.127467 44.005351,3.127271 44.005594,3.126585 44.005169,3.126397 44.005081,3.125787 44.005993,3.124603 44.006901,3.124174 44.007398,3.123933 44.007984,3.123878 44.008479,3.124964 44.008928,3.124392 44.009554,3.121872 44.01209,3.121812 44.012226,3.121628 44.012407,3.121448 44.012947,3.120921 44.014101,3.12166 44.016034,3.123675 44.020808,3.123874 44.02175,3.123954 44.022972,3.124026 44.023601,3.124222 44.024274,3.124676 44.02565,3.124878 44.026113,3.125564 44.027591,3.125822 44.028219)))', 4326))
            AND ((tags->'amenity') = 'charging_station');