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 = '13060' 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 = 27626 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 = '13060';

"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-12 20:19:01', 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 = 27626;

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

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 = 27626 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'13060'') = ?
  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'13060'') = ?
      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 = '13060';

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(((5.532718 43.482958,5.532169 43.482953,5.531829 43.482986,5.530636 43.483235,5.530223 43.483246,5.530029 43.483292,5.527471 43.480092,5.52631 43.478724,5.525943 43.478501,5.525531 43.478189,5.525179 43.47789,5.523879 43.476831,5.522844 43.475958,5.52253 43.475822,5.522469 43.475742,5.522261 43.475181,5.522104 43.475076,5.52144 43.474994,5.520941 43.474886,5.520097 43.474631,5.517065 43.473681,5.514742 43.472973,5.513496 43.472584,5.512901 43.472439,5.50864 43.471649,5.508848 43.470364,5.509604 43.469756,5.508221 43.469545,5.507602 43.46947,5.507283 43.469416,5.506883 43.469319,5.505792 43.469011,5.505489 43.468956,5.504903 43.468773,5.503861 43.468509,5.503578 43.468428,5.503354 43.468253,5.503111 43.467996,5.502532 43.467546,5.500758 43.466193,5.496552 43.4634,5.496132 43.463273,5.496127 43.463546,5.496158 43.463661,5.495856 43.463751,5.495708 43.463824,5.495013 43.463258,5.494068 43.463909,5.493427 43.464319,5.493214 43.464431,5.492829 43.464588,5.492434 43.464726,5.49237 43.46481,5.492063 43.464853,5.491342 43.465073,5.49095 43.465278,5.490809 43.465381,5.49044 43.465534,5.489864 43.465846,5.489759 43.465926,5.489239 43.466542,5.488644 43.467146,5.487242 43.467931,5.486771 43.468168,5.486637 43.468297,5.486313 43.468519,5.485375 43.468813,5.484892 43.468917,5.484167 43.469401,5.484032 43.469526,5.483715 43.469715,5.483042 43.470056,5.482089 43.470558,5.481992 43.471003,5.481788 43.471738,5.481544 43.472333,5.481816 43.472877,5.482004 43.473401,5.482084 43.474316,5.482162 43.475333,5.482162 43.47556,5.482228 43.476049,5.482352 43.476757,5.482528 43.477978,5.482565 43.478296,5.482599 43.479313,5.482637 43.4799,5.482646 43.480332,5.48268 43.48078,5.482618 43.480883,5.482337 43.481053,5.481796 43.481761,5.481609 43.481912,5.481245 43.48262,5.481123 43.482911,5.480843 43.483123,5.480512 43.483313,5.480288 43.483534,5.479977 43.483877,5.479669 43.484158,5.479425 43.484436,5.479267 43.484671,5.478956 43.485009,5.478689 43.485176,5.478358 43.485537,5.47776 43.486032,5.477411 43.486508,5.477184 43.486858,5.476904 43.487179,5.476494 43.487487,5.476367 43.487505,5.476344 43.487596,5.476161 43.487758,5.475896 43.487876,5.475414 43.488189,5.475265 43.488237,5.474928 43.488268,5.474611 43.488207,5.4733 43.488226,5.473053 43.488248,5.472345 43.488237,5.471603 43.488113,5.470687 43.487934,5.47022 43.487883,5.470001 43.487841,5.469899 43.487902,5.469692 43.488386,5.469389 43.488703,5.469294 43.48884,5.469289 43.488935,5.469087 43.489006,5.469021 43.48941,5.469044 43.489575,5.469012 43.490101,5.471233 43.491792,5.470934 43.49193,5.470843 43.492,5.470658 43.492245,5.470284 43.492574,5.469913 43.492748,5.469551 43.493041,5.469394 43.493122,5.468706 43.493427,5.468713 43.493509,5.468615 43.49362,5.468427 43.493743,5.468277 43.49395,5.46828 43.494166,5.468141 43.494412,5.46786 43.49469,5.467713 43.494782,5.467457 43.495085,5.46722 43.495326,5.466746 43.495672,5.466445 43.495934,5.466244 43.496073,5.465926 43.496352,5.465752 43.496473,5.465464 43.496735,5.465386 43.496856,5.465384 43.497066,5.465428 43.497314,5.465523 43.49757,5.465523 43.497932,5.465444 43.498012,5.465003 43.498138,5.464973 43.498294,5.464818 43.498511,5.464684 43.498585,5.464522 43.498599,5.464391 43.498667,5.464381 43.498941,5.464299 43.499091,5.46407 43.499201,5.463719 43.499412,5.463701 43.499572,5.463825 43.499949,5.463947 43.500231,5.463954 43.500471,5.46391 43.500713,5.463672 43.501057,5.463554 43.501282,5.463555 43.501431,5.463616 43.501585,5.4635 43.501772,5.463527 43.501943,5.463959 43.502386,5.464078 43.502617,5.464363 43.502819,5.464434 43.502932,5.464379 43.50318,5.464396 43.50331,5.464518 43.503501,5.464554 43.503656,5.464681 43.503889,5.464834 43.504024,5.465041 43.504105,5.46557 43.50419,5.466009 43.50422,5.466193 43.504293,5.466151 43.5046,5.466193 43.504775,5.466146 43.504994,5.466051 43.505167,5.465889 43.505342,5.465644 43.505667,5.465471 43.505968,5.465473 43.506062,5.465582 43.506522,5.465528 43.506674,5.466304 43.506699,5.466685 43.506781,5.467401 43.50697,5.467858 43.506933,5.468125 43.507052,5.468307 43.507189,5.468485 43.50745,5.468682 43.507644,5.469285 43.50808,5.469425 43.5082,5.469504 43.508354,5.469541 43.508632,5.469494 43.508819,5.469373 43.509045,5.469227 43.509255,5.468986 43.509806,5.468726 43.510274,5.468703 43.510565,5.468759 43.510665,5.469005 43.510836,5.469216 43.511074,5.469341 43.511322,5.469468 43.511755,5.469559 43.511866,5.469773 43.512023,5.469985 43.512104,5.470427 43.512125,5.471253 43.511936,5.471966 43.511788,5.472287 43.511705,5.47261 43.511521,5.473051 43.511305,5.473843 43.511175,5.474259 43.510885,5.474469 43.51083,5.474974 43.510777,5.475545 43.510797,5.475774 43.510825,5.47647 43.511019,5.477177 43.511245,5.477525 43.51138,5.477896 43.511575,5.478167 43.511753,5.478723 43.512243,5.479472 43.512527,5.479699 43.512563,5.480766 43.512657,5.481281 43.512371,5.481629 43.512238,5.48174 43.512157,5.482114 43.511665,5.482284 43.511552,5.482859 43.511233,5.48332 43.511022,5.483507 43.510904,5.483995 43.510751,5.484336 43.510694,5.485313 43.510662,5.485532 43.510635,5.485949 43.510519,5.486461 43.510232,5.486891 43.509857,5.487296 43.509531,5.487675 43.509258,5.488108 43.508909,5.488457 43.508573,5.488636 43.508288,5.489004 43.508102,5.489566 43.508141,5.48981 43.50807,5.490555 43.507449,5.490935 43.506986,5.491094 43.506744,5.491223 43.506626,5.49138 43.506544,5.491804 43.506408,5.49224 43.506378,5.492555 43.5064,5.492783 43.506471,5.493208 43.506759,5.493713 43.506981,5.494125 43.507128,5.494531 43.507248,5.495187 43.507679,5.495479 43.507793,5.495969 43.507888,5.49621 43.507891,5.496657 43.507841,5.497149 43.507725,5.497921 43.507504,5.499003 43.50724,5.499493 43.507169,5.499822 43.507161,5.50011 43.507222,5.500411 43.507334,5.500971 43.50757,5.501234 43.50765,5.501579 43.507786,5.502025 43.508005,5.502287 43.5082,5.502517 43.508471,5.503047 43.509148,5.503392 43.509606,5.503466 43.509982,5.503904 43.51002,5.504497 43.509981,5.504843 43.50994,5.50527 43.509845,5.506036 43.50965,5.506412 43.50954,5.506693 43.509402,5.506783 43.509318,5.507219 43.508815,5.507352 43.50858,5.507694 43.508386,5.50948 43.508218,5.509643 43.508161,5.5097 43.508047,5.509682 43.507139,5.509733 43.506994,5.510138 43.506594,5.510398 43.506593,5.510867 43.506813,5.511256 43.506956,5.511641 43.507063,5.511928 43.507098,5.5123 43.507065,5.512587 43.50715,5.512971 43.507189,5.513842 43.50712,5.514276 43.507124,5.514725 43.507054,5.515418 43.507074,5.516091 43.506969,5.517295 43.506698,5.517571 43.506716,5.517592 43.506564,5.517747 43.50614,5.518276 43.50612,5.519487 43.506197,5.520526 43.506084,5.521134 43.505963,5.522248 43.505677,5.522924 43.505541,5.523288 43.505479,5.523511 43.505478,5.523763 43.505378,5.524547 43.505216,5.524913 43.505129,5.525348 43.505056,5.526136 43.504854,5.526552 43.504783,5.526995 43.504791,5.528005 43.505004,5.529133 43.505221,5.529832 43.505335,5.530611 43.505442,5.531154 43.505416,5.531586 43.505591,5.53169 43.505478,5.531949 43.505233,5.532404 43.505097,5.532935 43.505064,5.53355 43.504927,5.534641 43.50471,5.534975 43.504657,5.535045 43.504585,5.535328 43.504586,5.535961 43.504526,5.536924 43.504397,5.536865 43.504272,5.536772 43.503877,5.535851 43.499837,5.535249 43.497231,5.534817 43.494908,5.534518 43.493394,5.534132 43.491667,5.53401 43.490949,5.533744 43.489691,5.533747 43.489486,5.533601 43.488916,5.533465 43.488659,5.53342 43.488287,5.533161 43.487142,5.533091 43.484351,5.532718 43.482958)))', 4326))
            AND ((tags->'emergency') = 'defibrillator');