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 = '02232' 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 = 26459 AND c0_.name IN ('fire_hydrant_count', 'fire_hydrant_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 = '02232';

"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\":\"fire_hydrant\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-15 12:49:56', 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 = 26459;

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

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 = 26459 AND z0_.theme = 'fire_hydrant' 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
  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'02232'') = ?
  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'02232'') = ?
      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 = '02232';

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') = 'fire_hydrant'
    OR (tags -> 'amenity') = 'fire_hydrant'
  )

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.034892 49.183627,3.035033 49.182591,3.035164 49.182164,3.035526 49.181218,3.035838 49.180314,3.036005 49.178908,3.036054 49.178314,3.036237 49.177114,3.03631 49.176895,3.036988 49.176013,3.037193 49.17573,3.038124 49.174971,3.037958 49.174749,3.037741 49.174378,3.037182 49.173521,3.037011 49.17317,3.0367 49.172663,3.036442 49.17188,3.036815 49.171439,3.037305 49.170945,3.037441 49.170923,3.037675 49.170676,3.037787 49.170452,3.037879 49.170425,3.037758 49.169797,3.038132 49.169232,3.038006 49.169132,3.037707 49.169068,3.035938 49.16921,3.035423 49.169341,3.03477 49.169697,3.034683 49.169841,3.034207 49.169996,3.033594 49.170074,3.033438 49.169737,3.032534 49.169972,3.030981 49.170903,3.030314 49.170055,3.029507 49.170156,3.027807 49.17026,3.027334 49.170356,3.026802 49.170385,3.026174 49.170387,3.025473 49.170209,3.025613 49.169857,3.024457 49.169866,3.022862 49.170199,3.022668 49.17091,3.022443 49.171279,3.021254 49.172803,3.020302 49.173771,3.019162 49.174987,3.01858 49.175755,3.018544 49.175894,3.018037 49.177114,3.01783 49.177429,3.017409 49.177988,3.017219 49.179229,3.017023 49.180036,3.016982 49.180404,3.017089 49.181068,3.016614 49.181985,3.016164 49.182712,3.015314 49.18269,3.01308 49.182597,3.011544 49.182539,3.009869 49.182732,3.008581 49.182873,3.007477 49.18295,3.005796 49.18296,3.005497 49.183238,3.005212 49.183341,3.004409 49.183908,3.003399 49.184854,3.002644 49.185228,3.001315 49.185666,3.000298 49.185952,2.999984 49.186195,2.999066 49.186312,2.998372 49.186544,2.997268 49.186676,2.996629 49.18688,2.996801 49.187049,2.99717 49.186975,2.997401 49.187351,2.997801 49.18822,2.997019 49.188437,2.997196 49.189229,2.996549 49.189295,2.996345 49.189483,2.995021 49.189311,2.994323 49.189539,2.994413 49.190574,2.99453 49.191144,2.994136 49.191553,2.994381 49.192013,2.994693 49.192213,2.994901 49.192248,2.994811 49.192642,2.993765 49.192618,2.992342 49.192876,2.992197 49.193639,2.991746 49.193751,2.991838 49.194147,2.992295 49.194167,2.992628 49.194526,2.993535 49.195448,2.992876 49.195724,2.991694 49.194654,2.991491 49.194437,2.990775 49.194119,2.990156 49.193182,2.989696 49.19247,2.99024 49.19233,2.989735 49.191764,2.989301 49.191136,2.98874 49.190282,2.989541 49.189359,2.989641 49.18902,2.989481 49.188666,2.989219 49.188689,2.988998 49.188522,2.98876 49.188346,2.988738 49.187882,2.988594 49.187895,2.985314 49.188457,2.984404 49.186866,2.984145 49.185597,2.983845 49.184366,2.982361 49.184627,2.981585 49.184581,2.981162 49.184643,2.980578 49.184743,2.978424 49.185455,2.977716 49.185734,2.976406 49.186214,2.975826 49.186352,2.974982 49.186622,2.974111 49.186954,2.97266 49.187813,2.972302 49.187699,2.971745 49.18795,2.971308 49.188645,2.970695 49.189105,2.970322 49.189543,2.970272 49.189788,2.970121 49.189935,2.969965 49.189843,2.969773 49.19004,2.969976 49.190112,2.969907 49.190259,2.969762 49.190216,2.969486 49.190388,2.969409 49.190531,2.969848 49.190803,2.970064 49.190785,2.970499 49.191243,2.968698 49.191616,2.968629 49.191495,2.967661 49.191755,2.967695 49.191949,2.967787 49.191946,2.967935 49.192318,2.968061 49.192474,2.968204 49.193002,2.96847 49.193309,2.968596 49.193322,2.968791 49.19399,2.969357 49.195238,2.970171 49.195412,2.970333 49.196144,2.970651 49.196145,2.970685 49.196274,2.971673 49.196252,2.972324 49.196839,2.97215 49.197074,2.972017 49.197326,2.973966 49.197399,2.973919 49.197734,2.973594 49.197907,2.972783 49.198081,2.972798 49.198288,2.972592 49.198497,2.9725 49.199159,2.972167 49.199003,2.971695 49.198921,2.970503 49.199218,2.970682 49.199602,2.970299 49.199783,2.969878 49.199755,2.969935 49.200823,2.969711 49.20087,2.969932 49.201478,2.970031 49.201595,2.968691 49.202769,2.967014 49.203099,2.967548 49.204795,2.965763 49.205209,2.965868 49.205379,2.967549 49.205985,2.969277 49.206803,2.969891 49.206506,2.970511 49.206798,2.97029 49.207183,2.970499 49.207728,2.971568 49.207819,2.972097 49.20831,2.972137 49.208779,2.971455 49.209259,2.971015 49.209605,2.969829 49.210407,2.971041 49.211959,2.971151 49.212804,2.970847 49.214439,2.968412 49.214641,2.968097 49.215891,2.967854 49.216344,2.967616 49.216698,2.966478 49.216696,2.964472 49.217256,2.963235 49.217662,2.963274 49.218077,2.962229 49.218146,2.961963 49.21837,2.964925 49.220305,2.964417 49.220635,2.963816 49.220978,2.963629 49.221057,2.961957 49.221911,2.961782 49.22199,2.960477 49.222499,2.960219 49.22278,2.959753 49.223493,2.95979 49.223687,2.95945 49.224215,2.959421 49.224602,2.959328 49.225399,2.959288 49.226038,2.958363 49.226156,2.958036 49.226922,2.958987 49.228604,2.961845 49.229544,2.96271 49.230272,2.963024 49.230579,2.963647 49.230691,2.963876 49.230752,2.964192 49.230887,2.964336 49.231604,2.964375 49.231893,2.964396 49.232044,2.964591 49.232664,2.967244 49.232697,2.967266 49.232334,2.967045 49.232343,2.967044 49.232017,2.968937 49.231932,2.968918 49.231827,2.969168 49.231811,2.969147 49.23171,2.970216 49.231665,2.970297 49.23188,2.972637 49.231786,2.97533 49.232017,2.975779 49.232143,2.979774 49.233145,2.979875 49.23318,2.980809 49.233658,2.981242 49.2339,2.981762 49.234165,2.983203 49.234336,2.983971 49.234525,2.984302 49.234595,2.985084 49.234683,2.986184 49.234858,2.986173 49.234935,2.987304 49.235083,2.987353 49.235032,2.988192 49.235083,2.989742 49.235127,2.990776 49.235215,2.990972 49.235241,2.992006 49.234685,2.992526 49.235181,2.992813 49.235435,2.993306 49.235399,2.993722 49.235344,2.995103 49.235218,2.995202 49.235183,2.995513 49.235175,2.99772 49.23508,2.999193 49.235023,2.999272 49.235183,3.000854 49.235194,3.000958 49.235631,3.001741 49.235574,3.001783 49.235594,3.002738 49.235716,3.00324 49.235532,3.003063 49.235058,3.004379 49.234849,3.00531 49.234588,3.006882 49.233938,3.006956 49.233672,3.007318 49.233492,3.007846 49.233307,3.009129 49.233061,3.009162 49.232742,3.011077 49.232528,3.012889 49.232072,3.012562 49.231531,3.013479 49.231243,3.013395 49.23099,3.014671 49.230757,3.014771 49.23084,3.015055 49.230729,3.015 49.230555,3.016374 49.230217,3.016252 49.23001,3.016044 49.229852,3.016021 49.22979,3.015654 49.229639,3.015174 49.229924,3.014692 49.229879,3.013469 49.229632,3.013583 49.228996,3.013083 49.228594,3.013126 49.228569,3.012802 49.228332,3.012623 49.228349,3.011377 49.228049,3.011006 49.227792,3.010311 49.227536,3.009901 49.226998,3.009326 49.226578,3.008063 49.225943,3.007726 49.226086,3.007659 49.225252,3.00704 49.224895,3.006605 49.224876,3.006289 49.224192,3.003383 49.224238,3.003418 49.223864,3.003739 49.22248,3.003821 49.221619,3.004557 49.22134,3.005613 49.220979,3.005556 49.221389,3.005656 49.22201,3.007325 49.221864,3.007461 49.22223,3.007967 49.222194,3.009168 49.22193,3.009459 49.222524,3.010702 49.222678,3.012062 49.22266,3.013042 49.22283,3.013734 49.223136,3.014467 49.223276,3.014946 49.223165,3.01488 49.222622,3.01431 49.222624,3.014432 49.221865,3.014113 49.221489,3.014989 49.221343,3.014968 49.221095,3.014572 49.220938,3.013931 49.220882,3.014172 49.219993,3.015019 49.220157,3.015426 49.219615,3.015774 49.219665,3.016352 49.218584,3.016155 49.218471,3.01654 49.218211,3.017391 49.218946,3.018514 49.219541,3.019539 49.218809,3.019689 49.218346,3.019442 49.218297,3.019458 49.218053,3.019524 49.217766,3.019695 49.217278,3.020079 49.216786,3.020964 49.216156,3.02124 49.216212,3.022116 49.216163,3.022371 49.216381,3.023554 49.216588,3.023838 49.21695,3.024201 49.218118,3.024307 49.218142,3.024595 49.218733,3.024444 49.218949,3.024161 49.219444,3.023192 49.220036,3.022997 49.220218,3.023086 49.220286,3.025137 49.220069,3.025166 49.220391,3.025303 49.22057,3.02579 49.220848,3.02608 49.22148,3.026422 49.221662,3.027963 49.221419,3.028128 49.221116,3.02871 49.2209,3.029003 49.221174,3.029882 49.221039,3.030771 49.220679,3.03115 49.22036,3.031588 49.220647,3.031864 49.22096,3.033086 49.220446,3.033377 49.220582,3.032339 49.221465,3.032483 49.221617,3.03112 49.222081,3.031088 49.222449,3.031332 49.223101,3.031613 49.223364,3.031044 49.223467,3.031227 49.224054,3.029948 49.224343,3.030258 49.225348,3.030579 49.225313,3.032291 49.224832,3.032364 49.225032,3.03192 49.225181,3.031817 49.225522,3.03154 49.226191,3.031771 49.226358,3.032184 49.226399,3.033197 49.226326,3.033707 49.226087,3.033692 49.225971,3.033545 49.225723,3.033719 49.225253,3.033574 49.224909,3.033344 49.224436,3.033448 49.224315,3.033099 49.223907,3.033529 49.22365,3.033446 49.223527,3.033678 49.22341,3.033839 49.22349,3.03399 49.223455,3.034183 49.222526,3.03504 49.222365,3.035814 49.221969,3.036966 49.222237,3.037148 49.223071,3.037247 49.223575,3.03765 49.224343,3.03861 49.22482,3.038534 49.224904,3.039559 49.225736,3.039701 49.225716,3.040156 49.226567,3.040039 49.227151,3.03985 49.227517,3.039207 49.227549,3.03864 49.22761,3.038707 49.228197,3.038784 49.228692,3.039272 49.229666,3.039765 49.229819,3.039806 49.229806,3.040494 49.22997,3.040633 49.229902,3.041514 49.23037,3.041715 49.23044,3.041871 49.230427,3.041821 49.230656,3.041512 49.230547,3.040989 49.230876,3.040632 49.230587,3.040393 49.230694,3.04016 49.230868,3.039869 49.231215,3.040355 49.231753,3.040813 49.232184,3.040685 49.232289,3.040046 49.232666,3.039869 49.232754,3.038816 49.233137,3.037223 49.233641,3.036748 49.233946,3.036597 49.234066,3.036067 49.234552,3.035668 49.234779,3.035756 49.234985,3.035899 49.235152,3.036207 49.235411,3.036628 49.235548,3.036852 49.235579,3.036871 49.235844,3.037039 49.236108,3.036964 49.23632,3.036674 49.236421,3.036621 49.236568,3.036361 49.236688,3.03626 49.23677,3.036182 49.236951,3.035991 49.237095,3.03564 49.23728,3.035473 49.237294,3.035408 49.237477,3.035158 49.23747,3.034863 49.237785,3.03445 49.237891,3.034323 49.237972,3.034245 49.238188,3.034083 49.238434,3.033982 49.238514,3.033608 49.238462,3.033529 49.23837,3.033369 49.238369,3.033179 49.238298,3.032816 49.238724,3.032799 49.238882,3.032994 49.239009,3.032887 49.239123,3.033084 49.239243,3.033189 49.23952,3.03298 49.239787,3.0329 49.239998,3.03294 49.240151,3.033243 49.240849,3.033533 49.241155,3.033899 49.241582,3.033797 49.241894,3.033634 49.242178,3.033294 49.242865,3.033319 49.242944,3.033555 49.24295,3.034512 49.242885,3.0348 49.243864,3.034805 49.24425,3.035462 49.244342,3.03566 49.244754,3.035935 49.245139,3.036502 49.244867,3.036512 49.24423,3.036206 49.243722,3.035558 49.242558,3.035353 49.241833,3.034994 49.241398,3.034873 49.240911,3.034978 49.240226,3.035515 49.239388,3.036658 49.239431,3.036691 49.239056,3.037243 49.239097,3.037287 49.238716,3.038458 49.238734,3.040898 49.239077,3.040901 49.239301,3.041443 49.239348,3.041417 49.239479,3.042524 49.239604,3.043174 49.240938,3.04384 49.241023,3.04717 49.240891,3.048755 49.241088,3.0507 49.241171,3.052553 49.242232,3.052951 49.24245,3.053154 49.24265,3.053243 49.242936,3.053457 49.243932,3.053751 49.244925,3.054122 49.245509,3.054546 49.245943,3.055263 49.246607,3.055607 49.245615,3.055209 49.245212,3.054998 49.24497,3.054889 49.244771,3.054834 49.244531,3.054766 49.243789,3.054587 49.243253,3.054534 49.24296,3.054499 49.242361,3.054574 49.241508,3.054675 49.241171,3.05542 49.24084,3.056992 49.240786,3.059298 49.240835,3.059994 49.240842,3.060663 49.2409,3.062842 49.24094,3.06313 49.241013,3.064771 49.241252,3.065643 49.24022,3.067288 49.238116,3.06962 49.234989,3.069303 49.234837,3.068284 49.234581,3.067618 49.234389,3.066559 49.234067,3.075226 49.231093,3.076146 49.230812,3.075997 49.230421,3.075985 49.229659,3.073912 49.229168,3.072885 49.228015,3.071969 49.227151,3.071315 49.2265,3.069743 49.22489,3.069314 49.224417,3.068029 49.223094,3.067853 49.222966,3.067562 49.222839,3.066767 49.222717,3.066196 49.222535,3.065917 49.222411,3.064653 49.221626,3.064521 49.221487,3.064348 49.221118,3.063964 49.22044,3.063477 49.219723,3.063128 49.219251,3.062468 49.218419,3.062226 49.218136,3.061865 49.217673,3.061785 49.217486,3.061704 49.217025,3.061698 49.216638,3.061597 49.216352,3.06092 49.215494,3.060149 49.214724,3.059851 49.214355,3.059572 49.21405,3.058176 49.212673,3.057549 49.212046,3.056803 49.211313,3.056483 49.210981,3.055824 49.210346,3.055648 49.210146,3.054342 49.208842,3.053582 49.208072,3.053283 49.207757,3.052294 49.206756,3.052104 49.206576,3.051792 49.207028,3.051976 49.207113,3.05158 49.207438,3.05112 49.20799,3.051084 49.208589,3.049609 49.20877,3.04942 49.209291,3.048147 49.209072,3.047603 49.208895,3.047478 49.209135,3.047369 49.209837,3.046855 49.209774,3.046292 49.209773,3.046253 49.21006,3.046192 49.210064,3.045675 49.209895,3.044408 49.209745,3.04442 49.209679,3.044146 49.209612,3.043351 49.20957,3.043007 49.209581,3.042668 49.209563,3.042583 49.209685,3.041945 49.209637,3.041921 49.209471,3.041799 49.20911,3.041712 49.208522,3.041732 49.208203,3.041713 49.208068,3.041595 49.207769,3.041183 49.207131,3.041143 49.206941,3.041071 49.206272,3.040975 49.20586,3.0407 49.205782,3.039995 49.205489,3.039527 49.205583,3.039244 49.2057,3.038903 49.205752,3.038864 49.205991,3.038565 49.206177,3.038084 49.206296,3.037827 49.206264,3.036607 49.205919,3.036362 49.205798,3.036316 49.205728,3.0363 49.205414,3.036371 49.205148,3.036125 49.205024,3.035413 49.205137,3.035107 49.205763,3.035076 49.205795,3.034797 49.207324,3.03375 49.20883,3.033367 49.209477,3.032537 49.210967,3.032454 49.21109,3.03175 49.211986,3.030879 49.212759,3.03064 49.212942,3.029696 49.21358,3.029342 49.213834,3.028729 49.214026,3.025978 49.214907,3.024937 49.215374,3.023204 49.215862,3.022946 49.215889,3.022135 49.215936,3.020981 49.216044,3.017785 49.21698,3.017679 49.217029,3.016172 49.216882,3.014948 49.21677,3.014489 49.216647,3.012963 49.216215,3.011119 49.216013,3.009256 49.215758,3.007909 49.215742,3.007411 49.215682,3.005988 49.215492,3.005577 49.215349,3.004076 49.214739,3.00233 49.214466,3.002163 49.214433,3.000361 49.213689,2.999315 49.212906,2.998934 49.212442,2.998319 49.211747,2.997925 49.211445,2.996803 49.21065,2.996664 49.210573,2.995199 49.209877,2.994402 49.209493,2.994724 49.209303,2.995328 49.209144,2.995588 49.209105,2.996417 49.208809,2.999089 49.207693,3.001128 49.206947,3.002582 49.206298,3.002075 49.20555,3.002044 49.205228,3.002184 49.204928,3.002405 49.204754,3.001968 49.204331,3.001357 49.204192,3.001314 49.203941,3.001497 49.203539,3.001688 49.203174,3.002105 49.203305,3.002647 49.20316,3.003042 49.203159,3.00316 49.202987,3.003135 49.202568,3.002592 49.20244,3.002411 49.202422,3.002188 49.202214,3.001273 49.201979,3.000487 49.201166,3.000491 49.200651,2.999752 49.200714,2.998882 49.200825,2.998479 49.200821,2.997679 49.20085,2.997282 49.20089,2.996875 49.200752,2.996598 49.20019,2.996532 49.199897,2.996788 49.199779,2.997101 49.199579,2.997393 49.199201,2.998373 49.199208,2.998694 49.199147,2.99916 49.199203,2.999373 49.199252,3.00004 49.199493,3.000067 49.199414,3.000048 49.198741,3.000493 49.198286,3.000598 49.197818,3.000479 49.197431,2.999915 49.196552,3.000209 49.196265,3.000414 49.196268,3.000856 49.1955,3.000649 49.195429,3.00011 49.195146,3.000347 49.194744,3.00077 49.194582,3.001207 49.194723,3.001454 49.194427,3.001797 49.194064,3.002052 49.194144,3.002224 49.194048,3.002568 49.194125,3.003508 49.193504,3.003204 49.193397,3.003254 49.193255,3.00342 49.193288,3.003337 49.192188,3.003975 49.191843,3.00347 49.191782,3.002687 49.191817,3.002787 49.191629,3.002649 49.190861,3.003244 49.19072,3.003191 49.190422,3.003383 49.190363,3.002758 49.189583,3.002354 49.189139,3.002186 49.188723,3.00233 49.188145,3.002819 49.187868,3.003123 49.187841,3.00351 49.187683,3.003924 49.187544,3.004155 49.187777,3.004366 49.187715,3.004576 49.187314,3.004519 49.18694,3.004064 49.186811,3.003681 49.186513,3.004032 49.186225,3.005223 49.186373,3.005629 49.186175,3.005595 49.185783,3.005346 49.185167,3.005419 49.185122,3.005888 49.185106,3.006227 49.185229,3.006361 49.185463,3.0066 49.185544,3.006679 49.185387,3.007397 49.185481,3.008364 49.185386,3.008583 49.185377,3.008837 49.185198,3.008844 49.184914,3.008908 49.184212,3.009546 49.184214,3.010178 49.184132,3.01021 49.18471,3.010499 49.184862,3.010916 49.184768,3.011943 49.184564,3.012729 49.18457,3.013455 49.184939,3.013508 49.185275,3.013481 49.185491,3.013291 49.186433,3.013039 49.186333,3.012978 49.18654,3.012996 49.187066,3.013498 49.187112,3.014362 49.186609,3.014595 49.187336,3.01503 49.187634,3.015933 49.188655,3.016229 49.188935,3.016296 49.189036,3.016471 49.189101,3.017576 49.189353,3.017446 49.189881,3.018176 49.190005,3.018803 49.190339,3.020166 49.190417,3.021419 49.190924,3.021434 49.191241,3.021777 49.191517,3.022385 49.191748,3.022935 49.191837,3.023702 49.19219,3.024516 49.192488,3.024742 49.192758,3.025222 49.192955,3.026066 49.192974,3.02638 49.192431,3.027031 49.191643,3.027382 49.191685,3.027644 49.191488,3.027936 49.191547,3.028279 49.190927,3.028597 49.190546,3.027509 49.190408,3.026118 49.190318,3.026234 49.18985,3.026105 49.189392,3.025721 49.189169,3.02664 49.188542,3.026814 49.188141,3.026856 49.18782,3.026808 49.187746,3.025745 49.187446,3.025708 49.187128,3.025694 49.186547,3.026392 49.186061,3.027445 49.186204,3.027675 49.186252,3.028268 49.185931,3.029127 49.185067,3.029292 49.184779,3.029521 49.184651,3.02989 49.183709,3.030041 49.183031,3.032249 49.18329,3.03397 49.183505,3.034892 49.183627)))', 4326))
  AND (
       (tags->'emergency') = 'fire_hydrant'
    OR (tags->'amenity') = 'fire_hydrant'
  );