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 = '13065' 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 = 27684 AND c0_.name IN ('defibrillator_count', 'defibrillator_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 = '13065';

"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\":\"defibrillator\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-15 12:01:47', 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 = 27684;

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

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 = 27684 AND z0_.theme = 'defibrillator' 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'13065'') = ?
  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'13065'') = ?
      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 = '13065';

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 -> 'emergency') = 'defibrillator'
  )

SELECT osm_type, osm_id::text AS osm_id, ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,
            tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid
            FROM osm_object_meta m
            WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText('MULTIPOLYGON(((4.926499 43.686716,4.928164 43.682095,4.928511 43.68107,4.92864 43.680651,4.928752 43.680386,4.928942 43.680067,4.929458 43.679066,4.930199 43.67769,4.93213 43.672333,4.932596 43.671057,4.932827 43.670539,4.930487 43.671216,4.930236 43.671109,4.928536 43.671446,4.926995 43.671665,4.926561 43.671694,4.926435 43.671898,4.92535 43.671749,4.920986 43.671053,4.917245 43.670462,4.915218 43.670155,4.913516 43.670103,4.91277 43.670129,4.911784 43.670103,4.909393 43.670098,4.908949 43.670107,4.908215 43.670144,4.907289 43.670221,4.906212 43.67034,4.905985 43.670352,4.899432 43.671028,4.895742 43.672256,4.895545 43.672311,4.895048 43.672516,4.8942 43.672926,4.894039 43.672944,4.89372 43.673066,4.893559 43.673177,4.893162 43.673323,4.892336 43.673668,4.891238 43.673846,4.89015 43.674801,4.890049 43.674608,4.889597 43.6747,4.889424 43.6747,4.889184 43.674798,4.88876 43.675028,4.888543 43.675232,4.888312 43.6754,4.888067 43.67545,4.88692 43.675781,4.885471 43.676189,4.884949 43.676372,4.884362 43.676555,4.88365 43.676751,4.883015 43.676814,4.882275 43.676933,4.881978 43.676995,4.881093 43.67723,4.880035 43.677565,4.879817 43.677676,4.87915 43.678103,4.878535 43.678385,4.878198 43.678498,4.877726 43.678621,4.877098 43.678734,4.876457 43.678796,4.874599 43.678794,4.874103 43.678809,4.873737 43.678836,4.87334 43.678839,4.873185 43.678897,4.872956 43.678871,4.872636 43.6788,4.871604 43.678649,4.871425 43.67861,4.870494 43.678319,4.870083 43.678218,4.869428 43.678098,4.868829 43.67801,4.868106 43.677927,4.867782 43.67792,4.867422 43.677964,4.866765 43.678007,4.865982 43.678032,4.865334 43.67807,4.86405 43.678236,4.862967 43.67833,4.861657 43.678428,4.860788 43.678448,4.860065 43.678499,4.859507 43.678552,4.859153 43.678549,4.858843 43.678571,4.858282 43.678651,4.857589 43.678693,4.857362 43.678761,4.857396 43.679039,4.857386 43.679279,4.857192 43.679105,4.856953 43.679004,4.85666 43.678944,4.856267 43.678961,4.85601 43.679015,4.855541 43.679079,4.854851 43.67914,4.852979 43.679128,4.852687 43.679108,4.852115 43.679137,4.85175 43.679221,4.851066 43.679285,4.850637 43.679308,4.850122 43.679191,4.849998 43.679202,4.849758 43.679301,4.849541 43.679354,4.848843 43.679427,4.848376 43.679554,4.848202 43.679694,4.847865 43.679742,4.847485 43.679845,4.847102 43.679991,4.846314 43.680269,4.846069 43.68032,4.845046 43.680441,4.844264 43.680461,4.843284 43.680543,4.843058 43.680577,4.842467 43.680724,4.841981 43.680825,4.841686 43.680962,4.841439 43.68111,4.841276 43.681254,4.841139 43.681468,4.8411 43.681626,4.840554 43.681404,4.840369 43.681367,4.838743 43.6812,4.837942 43.681133,4.836926 43.681021,4.834441 43.680669,4.832388 43.680163,4.831165 43.679731,4.830261 43.679752,4.828177 43.67979,4.825187 43.679794,4.824595 43.679897,4.82344 43.679941,4.823468 43.680011,4.825911 43.684593,4.827137 43.6864,4.829609 43.690049,4.832102 43.690801,4.833819 43.691358,4.83489 43.691671,4.835213 43.691755,4.835571 43.691782,4.838576 43.692088,4.840062 43.692186,4.8408 43.692259,4.843095 43.692459,4.844708 43.692585,4.845178 43.692563,4.8459 43.692511,4.84659 43.692543,4.847031 43.692602,4.848141 43.692594,4.848891 43.692576,4.849177 43.692602,4.84928 43.692693,4.849363 43.693041,4.849373 43.693199,4.849479 43.693535,4.849656 43.693899,4.849627 43.694228,4.849665 43.694564,4.849659 43.694803,4.849699 43.695025,4.849828 43.695424,4.849826 43.695602,4.850058 43.696053,4.849941 43.696265,4.849971 43.69641,4.850129 43.696602,4.850586 43.696921,4.850842 43.697193,4.850983 43.697583,4.851062 43.698017,4.851077 43.698539,4.85106 43.698704,4.850976 43.698847,4.850687 43.699017,4.850219 43.699198,4.849803 43.699288,4.84957 43.699384,4.849376 43.699598,4.849369 43.69973,4.849593 43.699876,4.849705 43.700033,4.849871 43.700171,4.849925 43.700284,4.850201 43.700447,4.850382 43.700867,4.85063 43.701136,4.850775 43.701152,4.850988 43.701105,4.851177 43.701116,4.851341 43.701173,4.851559 43.701312,4.851786 43.701399,4.852036 43.701414,4.852686 43.70135,4.852918 43.701302,4.853027 43.701337,4.853093 43.701525,4.853197 43.701598,4.853694 43.701797,4.854098 43.702034,4.854468 43.702135,4.855162 43.702248,4.855772 43.702288,4.85589 43.702344,4.856004 43.702482,4.856188 43.702541,4.856468 43.702544,4.856544 43.702641,4.856531 43.702936,4.856426 43.703233,4.856402 43.703483,4.856461 43.703723,4.856447 43.70399,4.856228 43.704507,4.856174 43.704706,4.85579 43.705374,4.855793 43.705592,4.856009 43.705911,4.856008 43.706451,4.8561 43.706866,4.85619 43.707055,4.856526 43.707497,4.856661 43.707631,4.856983 43.707849,4.857191 43.707891,4.85754 43.707879,4.857789 43.707772,4.858372 43.70778,4.858444 43.707812,4.858712 43.708049,4.858928 43.708105,4.858951 43.708554,4.859014 43.708721,4.859265 43.708765,4.859333 43.708913,4.859565 43.709126,4.859596 43.709374,4.859679 43.709596,4.859683 43.709961,4.859968 43.710298,4.860073 43.710453,4.860183 43.710517,4.860546 43.710885,4.860696 43.711083,4.861002 43.711414,4.861069 43.711566,4.861048 43.711747,4.861114 43.711841,4.861293 43.71189,4.861353 43.712153,4.861467 43.712279,4.861913 43.712649,4.862159 43.712789,4.862273 43.712807,4.862332 43.712574,4.862483 43.712598,4.862652 43.712808,4.86284 43.71284,4.863061 43.71283,4.863168 43.713024,4.863384 43.713309,4.863516 43.713399,4.863722 43.713455,4.86382 43.713734,4.863932 43.713798,4.864167 43.713797,4.864338 43.713834,4.86484 43.714122,4.865248 43.714222,4.865378 43.714226,4.865788 43.714303,4.866057 43.714376,4.866255 43.714485,4.866359 43.714771,4.866568 43.714942,4.866945 43.715185,4.867189 43.715289,4.867439 43.715477,4.867853 43.715612,4.868372 43.715653,4.868652 43.71576,4.868806 43.715857,4.869256 43.715999,4.869406 43.716068,4.869482 43.716196,4.869592 43.716575,4.869701 43.716671,4.870187 43.71678,4.870333 43.716737,4.870525 43.716828,4.870581 43.716959,4.870578 43.71728,4.870422 43.717485,4.870452 43.717678,4.870653 43.717959,4.870669 43.718049,4.870876 43.718276,4.870913 43.718364,4.870822 43.718617,4.87081 43.718822,4.870984 43.718869,4.871597 43.718893,4.871861 43.718939,4.872232 43.719059,4.872592 43.71906,4.872939 43.719003,4.873133 43.719063,4.87337 43.719236,4.873685 43.719306,4.874099 43.719257,4.874361 43.719287,4.874818 43.719226,4.87509 43.719079,4.875281 43.719102,4.875551 43.719241,4.875832 43.719353,4.87616 43.719324,4.876354 43.71936,4.876697 43.719537,4.87702 43.719575,4.877169 43.719744,4.877328 43.719862,4.877698 43.719963,4.877905 43.72008,4.878136 43.720456,4.878464 43.720786,4.878492 43.720885,4.878701 43.72112,4.87916 43.721462,4.879239 43.721583,4.879239 43.721813,4.879397 43.721864,4.879661 43.721885,4.879934 43.721955,4.880211 43.722076,4.880495 43.722229,4.880884 43.722542,4.881057 43.722753,4.8811 43.722925,4.881113 43.723387,4.881202 43.723656,4.881292 43.723739,4.881722 43.723882,4.881936 43.724051,4.882099 43.72442,4.882417 43.725072,4.882777 43.725247,4.882856 43.725332,4.882899 43.725669,4.882868 43.725965,4.882811 43.726159,4.8828 43.726567,4.882867 43.726915,4.882907 43.727495,4.883005 43.727781,4.883122 43.728031,4.883358 43.728178,4.883521 43.728386,4.88377 43.728592,4.883866 43.728738,4.88389 43.728884,4.883811 43.729199,4.883764 43.729599,4.883765 43.729834,4.883722 43.730079,4.883624 43.730239,4.883608 43.730534,4.883631 43.731544,4.883598 43.732121,4.883429 43.733013,4.883448 43.733325,4.883372 43.73347,4.88373 43.733604,4.88474 43.734013,4.884982 43.734123,4.885175 43.734317,4.885355 43.734398,4.885471 43.734614,4.885547 43.73485,4.885586 43.735805,4.885791 43.736372,4.88604 43.73736,4.886142 43.737566,4.886729 43.738397,4.887567 43.739324,4.887883 43.73954,4.889582 43.739934,4.89126 43.740261,4.893093 43.740562,4.895229 43.740169,4.901674 43.739237,4.907953 43.738495,4.909606 43.739298,4.909976 43.739352,4.911097 43.739382,4.912074 43.739117,4.913108 43.73881,4.917277 43.737603,4.918091 43.736662,4.91915 43.735399,4.919794 43.734645,4.920361 43.733725,4.921304 43.732551,4.922545 43.731062,4.923639 43.728563,4.924135 43.727476,4.925134 43.725418,4.925413 43.724712,4.92621 43.722756,4.926711 43.721639,4.926741 43.721384,4.926891 43.720748,4.926918 43.719531,4.927051 43.719079,4.927194 43.718365,4.927327 43.717304,4.927792 43.715282,4.928551 43.713661,4.929672 43.711973,4.92958 43.710917,4.929076 43.710101,4.929028 43.709949,4.928858 43.709654,4.928549 43.709461,4.928348 43.709247,4.928064 43.708999,4.928018 43.708849,4.927838 43.708651,4.927759 43.708482,4.927631 43.708345,4.927477 43.708106,4.927105 43.7076,4.92666 43.706782,4.926307 43.70626,4.926022 43.705942,4.925871 43.705803,4.925733 43.705615,4.925523 43.705248,4.925376 43.704903,4.925075 43.704535,4.924928 43.704201,4.924966 43.704014,4.924731 43.703649,4.924618 43.703371,4.924616 43.703252,4.924518 43.70305,4.924414 43.702937,4.924047 43.702627,4.923928 43.702482,4.92387 43.702307,4.923731 43.702133,4.923673 43.701684,4.923527 43.701523,4.923253 43.701387,4.92317 43.701306,4.922926 43.700927,4.922852 43.700768,4.922848 43.700616,4.922592 43.700283,4.922531 43.700012,4.922429 43.699334,4.92243 43.699063,4.922381 43.698533,4.922258 43.69801,4.922225 43.697625,4.922276 43.697223,4.922358 43.697086,4.922647 43.697046,4.922775 43.696763,4.922934 43.696159,4.923075 43.695721,4.923255 43.695255,4.923405 43.694759,4.923575 43.694389,4.923764 43.693829,4.923844 43.693758,4.924085 43.6932,4.924081 43.693053,4.924309 43.692325,4.924707 43.691419,4.924814 43.691111,4.925325 43.689728,4.925414 43.689688,4.925482 43.68946,4.925442 43.689393,4.926349 43.686679,4.926499 43.686716)))', 4326))
            AND ((tags->'emergency') = 'defibrillator');