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 = '54396' 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 = 27687 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 = '54396';

"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-14 05:29:19', 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 = 27687;

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

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 = 27687 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'54396'') = ?
  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'54396'') = ?
      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 = '54396';

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(((6.918362 48.435465,6.918393 48.435329,6.918343 48.435239,6.918123 48.435091,6.917994 48.435043,6.917725 48.434785,6.917468 48.434714,6.917169 48.434458,6.91671 48.434235,6.916564 48.43392,6.916231 48.433608,6.915869 48.433338,6.915726 48.433262,6.915501 48.433206,6.914976 48.432574,6.914786 48.432327,6.914543 48.432294,6.914259 48.432117,6.91384 48.431821,6.913487 48.431527,6.913441 48.431309,6.913358 48.431206,6.913109 48.431059,6.912688 48.43089,6.912174 48.430804,6.911703 48.430766,6.911464 48.430773,6.910836 48.430728,6.910388 48.430866,6.909581 48.430646,6.909303 48.43051,6.908685 48.43034,6.908241 48.430066,6.907968 48.429975,6.907505 48.429655,6.907247 48.429419,6.907173 48.42915,6.906952 48.428852,6.906702 48.428684,6.90632 48.428535,6.905952 48.428436,6.905583 48.428296,6.905417 48.428159,6.90515 48.428107,6.905025 48.428041,6.904959 48.427603,6.90474 48.427345,6.904453 48.427232,6.904287 48.427105,6.904118 48.427075,6.903859 48.427115,6.90355 48.427275,6.903254 48.427358,6.902947 48.427367,6.902654 48.427313,6.902479 48.427233,6.902311 48.427104,6.902201 48.426862,6.902034 48.426408,6.902018 48.4262,6.902025 48.425751,6.901956 48.425075,6.901854 48.424666,6.901632 48.424488,6.901283 48.423979,6.90111 48.4238,6.900949 48.42373,6.900366 48.423792,6.899833 48.423831,6.899305 48.423831,6.898928 48.423791,6.898747 48.423734,6.898373 48.42354,6.897686 48.423132,6.897044 48.422878,6.896764 48.422695,6.896631 48.422482,6.896544 48.421975,6.896417 48.421741,6.896114 48.421565,6.895932 48.421249,6.895739 48.421,6.895215 48.42037,6.895084 48.42014,6.894741 48.419689,6.894308 48.419253,6.894193 48.419109,6.893822 48.41876,6.893339 48.418445,6.892796 48.418158,6.892176 48.417869,6.89169 48.417595,6.891465 48.417591,6.891327 48.417702,6.891051 48.418268,6.890891 48.418425,6.890575 48.418479,6.890415 48.418378,6.890569 48.41827,6.890587 48.418194,6.890469 48.418099,6.890243 48.41809,6.889742 48.418165,6.889457 48.418159,6.888909 48.418029,6.888661 48.418014,6.887996 48.418257,6.887693 48.418276,6.887364 48.418239,6.886975 48.418154,6.886664 48.418035,6.886292 48.417929,6.885568 48.41761,6.885398 48.41747,6.88526 48.417289,6.884985 48.417145,6.884554 48.417037,6.882965 48.417267,6.881611 48.416676,6.881099 48.416632,6.879704 48.416717,6.878618 48.416762,6.878038 48.416802,6.877726 48.41672,6.877937 48.418206,6.87815 48.418525,6.878443 48.419359,6.878615 48.419985,6.877705 48.420382,6.876615 48.420303,6.87608 48.420201,6.875711 48.420169,6.874026 48.420149,6.873458 48.420189,6.872678 48.420164,6.872139 48.419995,6.870725 48.420271,6.870282 48.420466,6.870273 48.420804,6.870241 48.421047,6.870169 48.42128,6.869979 48.42166,6.869816 48.421884,6.869622 48.42205,6.869297 48.42248,6.869121 48.422815,6.868968 48.423046,6.86878 48.42439,6.868676 48.424689,6.868431 48.425118,6.867886 48.425792,6.867621 48.426019,6.867456 48.426238,6.867287 48.426794,6.86692 48.427523,6.866424 48.428383,6.866342 48.428672,6.866367 48.429613,6.866324 48.430101,6.866101 48.430721,6.866058 48.431022,6.866077 48.431153,6.866345 48.431627,6.866582 48.432094,6.866741 48.432546,6.866703 48.432816,6.86659 48.433234,6.866584 48.433491,6.866655 48.433778,6.866653 48.433917,6.866265 48.434369,6.866021 48.434618,6.865503 48.43521,6.865134 48.435666,6.864944 48.435962,6.864883 48.436115,6.864696 48.436757,6.864419 48.436777,6.864327 48.436748,6.864061 48.436545,6.862943 48.435948,6.862674 48.435819,6.862459 48.435633,6.862297 48.435569,6.861756 48.435416,6.861292 48.435265,6.860972 48.435038,6.860148 48.434289,6.859908 48.43424,6.859618 48.434126,6.859033 48.433851,6.857732 48.433282,6.857618 48.433213,6.856971 48.432958,6.856538 48.432837,6.855943 48.432797,6.85537 48.43283,6.854969 48.432887,6.85482 48.432924,6.854335 48.433174,6.854149 48.433361,6.853761 48.434758,6.853708 48.434919,6.853584 48.43506,6.853314 48.435261,6.852754 48.435621,6.852345 48.435804,6.852072 48.435953,6.851831 48.436311,6.851422 48.436544,6.851152 48.436756,6.850883 48.437023,6.850182 48.437767,6.849862 48.437999,6.849662 48.438075,6.849397 48.438118,6.848651 48.438173,6.848362 48.438232,6.847685 48.438426,6.847444 48.438555,6.847276 48.43902,6.84717 48.439184,6.846163 48.439844,6.846587 48.440608,6.846634 48.440807,6.846542 48.441238,6.846382 48.441427,6.845587 48.441748,6.84532 48.442327,6.845955 48.443382,6.845988 48.443683,6.845516 48.444879,6.845329 48.44491,6.845144 48.444993,6.84389 48.445784,6.84326 48.44611,6.843121 48.446149,6.842984 48.446297,6.841815 48.447031,6.840681 48.447831,6.839305 48.448729,6.83811 48.449587,6.837792 48.449973,6.837235 48.450579,6.836777 48.45114,6.836633 48.45127,6.836346 48.451455,6.835975 48.451639,6.835712 48.451824,6.83552 48.452092,6.835421 48.452364,6.835321 48.452726,6.83505 48.453479,6.834947 48.453624,6.834813 48.453705,6.833598 48.454235,6.833189 48.454586,6.831712 48.455809,6.831185 48.456197,6.830017 48.456891,6.829414 48.457268,6.828695 48.457661,6.828249 48.457956,6.827404 48.458489,6.826627 48.458926,6.825939 48.459257,6.82559 48.459461,6.824911 48.459771,6.824559 48.460258,6.824184 48.46061,6.824035 48.460859,6.824078 48.461152,6.824374 48.461436,6.826968 48.463079,6.827017 48.46346,6.827662 48.463665,6.828176 48.463784,6.828618 48.463888,6.829364 48.464302,6.830588 48.46475,6.830943 48.464906,6.831353 48.46512,6.831729 48.465356,6.831959 48.465548,6.83208 48.465705,6.832127 48.465844,6.832139 48.466131,6.832115 48.466258,6.831994 48.466513,6.832043 48.466659,6.832376 48.466817,6.832481 48.466938,6.832436 48.467065,6.832501 48.467249,6.832308 48.467525,6.832506 48.4679,6.832412 48.468079,6.831876 48.468501,6.831875 48.468628,6.832058 48.468728,6.832249 48.468748,6.832556 48.468957,6.832549 48.469106,6.83239 48.469246,6.832053 48.469361,6.831923 48.469453,6.831901 48.469632,6.832007 48.469792,6.83156 48.469957,6.83133 48.470012,6.830804 48.470178,6.830239 48.470468,6.82997 48.470493,6.829872 48.470635,6.829943 48.471313,6.829645 48.471425,6.829297 48.471514,6.829076 48.471538,6.829235 48.471824,6.829037 48.471952,6.828782 48.472052,6.828677 48.472134,6.828494 48.472447,6.828132 48.472605,6.829008 48.473409,6.829529 48.473194,6.829774 48.473117,6.830301 48.473008,6.830937 48.472963,6.831537 48.472964,6.832285 48.472998,6.833579 48.472986,6.835122 48.472924,6.835601 48.472874,6.836281 48.472702,6.836932 48.472443,6.83737 48.472296,6.838131 48.472112,6.838923 48.47322,6.839568 48.473238,6.839466 48.473821,6.840045 48.473873,6.839233 48.475635,6.838675 48.475656,6.83723 48.478128,6.83887 48.478085,6.838463 48.479151,6.837776 48.479621,6.837564 48.47992,6.837982 48.479998,6.839522 48.480572,6.839928 48.480568,6.840824 48.481,6.84122 48.481041,6.841973 48.481198,6.842255 48.481279,6.842549 48.481428,6.843009 48.481435,6.843275 48.481476,6.843426 48.481551,6.843559 48.481755,6.843779 48.481867,6.843983 48.481901,6.844388 48.481922,6.844599 48.481878,6.84555 48.482239,6.845871 48.482284,6.847252 48.481807,6.851212 48.480021,6.851461 48.480549,6.851534 48.480799,6.85194 48.480794,6.852482 48.479635,6.853206 48.478683,6.853399 48.478491,6.853862 48.478547,6.854456 48.478366,6.854942 48.478126,6.855774 48.477165,6.856222 48.476537,6.857177 48.475466,6.857301 48.475424,6.858603 48.47405,6.859855 48.472303,6.860243 48.472081,6.860207 48.471729,6.860244 48.4714,6.860381 48.470984,6.860422 48.470783,6.860423 48.470555,6.860322 48.469589,6.860547 48.469446,6.861476 48.468724,6.862403 48.46803,6.863309 48.46728,6.863955 48.466783,6.866665 48.464809,6.866993 48.464501,6.869118 48.46263,6.869718 48.462142,6.871247 48.460682,6.873208 48.458816,6.87464 48.457612,6.878321 48.454285,6.880439 48.451937,6.880618 48.451952,6.881076 48.452081,6.881333 48.452112,6.881602 48.452106,6.881957 48.452039,6.882723 48.45186,6.883087 48.451829,6.883582 48.451819,6.883975 48.451835,6.884327 48.451875,6.885081 48.452027,6.885296 48.452048,6.885891 48.452065,6.886281 48.452056,6.886597 48.452219,6.886812 48.452263,6.88721 48.452252,6.887486 48.452184,6.888097 48.451921,6.888315 48.45188,6.888899 48.451836,6.889461 48.451743,6.890762 48.451754,6.891228 48.451665,6.891906 48.45147,6.892301 48.451398,6.892797 48.451353,6.893489 48.451318,6.893971 48.451263,6.894274 48.451151,6.894559 48.450921,6.89495 48.450777,6.895171 48.450742,6.895838 48.450737,6.89606 48.450701,6.896541 48.450541,6.89674 48.45044,6.897071 48.450179,6.89732 48.449872,6.897637 48.449563,6.897907 48.449371,6.898743 48.448859,6.899084 48.448547,6.899251 48.44836,6.899657 48.448029,6.899946 48.447893,6.900713 48.447736,6.90107 48.447642,6.901456 48.447472,6.902333 48.446955,6.90277 48.446668,6.903452 48.446274,6.903747 48.446156,6.904035 48.446071,6.904629 48.445937,6.905189 48.445825,6.905529 48.445721,6.905776 48.445581,6.906254 48.445168,6.906549 48.444866,6.906847 48.444529,6.906991 48.444399,6.907242 48.444268,6.907594 48.444174,6.908525 48.443809,6.908873 48.443595,6.909217 48.4433,6.909673 48.443065,6.910017 48.442928,6.91038 48.442826,6.910768 48.442753,6.911137 48.442743,6.911419 48.442678,6.911732 48.442473,6.91211 48.442005,6.912211 48.441913,6.912615 48.441688,6.912997 48.441571,6.913343 48.441439,6.913877 48.441572,6.914423 48.44158,6.915036 48.441564,6.917 48.440993,6.918215 48.440806,6.919927 48.440472,6.920087 48.439868,6.920618 48.439718,6.921011 48.439528,6.921413 48.439197,6.92126 48.439106,6.92067 48.438611,6.920389 48.438294,6.920238 48.438056,6.920071 48.437664,6.920012 48.436691,6.919958 48.436568,6.9198 48.436445,6.919593 48.436391,6.919381 48.436281,6.9192 48.43623,6.918973 48.436085,6.918679 48.43603,6.918321 48.435836,6.918267 48.435744,6.918362 48.435465)))', 4326))
  AND (
       (tags->'emergency') = 'fire_hydrant'
    OR (tags->'amenity') = 'fire_hydrant'
  );