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 = '67519' 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 = 27491 AND c0_.name IN ('drinking_water_count', 'drinking_water_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 = '67519';

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

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

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 = 27491 AND z0_.theme = 'drinking_water' 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'67519'') = ?
  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'67519'') = ?
      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 = '67519';

INSERT INTO zone_polygon (
  insee_code, geom, source, updated_at
)
VALUES
  (
    ?,
    ST_Multi(
      ST_MakeValid(
        ST_SetSRID(
          ST_GeomFromText(?),
          4326
        )
      )
    ),
    ?,
    NOW()
  ) ON CONFLICT (insee_code) DO
UPDATE
SET
  geom = EXCLUDED.geom,
  source = EXCLUDED.source,
  updated_at = NOW()
WHERE
  zone_polygon.source IS DISTINCT
FROM
  EXCLUDED.source
  OR NOT ST_Equals(
    zone_polygon.geom, EXCLUDED.geom
  )

INSERT INTO zone_polygon (insee_code, geom, source, updated_at)
                 VALUES ('67519', ST_Multi(ST_MakeValid(ST_SetSRID(ST_GeomFromText('POLYGON((7.8360646 48.6335044, 7.8362401 48.6339808, 7.8362401 48.6339808, 7.836677 48.6351665, 7.8376238 48.6377956, 7.8379075 48.6384692, 7.8386235 48.6398274, 7.8393911 48.6409714, 7.8404639 48.6422894, 7.8417394 48.6435419, 7.8429273 48.6444538, 7.844278 48.645338, 7.8453164 48.6458777, 7.8466531 48.6464733, 7.8478259 48.6468614, 7.8490203 48.647208, 7.8499162 48.6473973, 7.8529395 48.6480212, 7.8556341 48.6486912, 7.8566975 48.6489969, 7.8581947 48.6494562, 7.8600078 48.6500504, 7.8626231 48.6510018, 7.8640294 48.6515693, 7.8663687 48.6524992, 7.8696862 48.6538009, 7.8729789 48.6551547, 7.8756259 48.6561991, 7.8766557 48.6565983, 7.8766557 48.6565983, 7.8834097 48.6593521, 7.8839267 48.6595857, 7.8856983 48.6603501, 7.8882894 48.661657, 7.8888491 48.6619877, 7.8903447 48.6628567, 7.8922965 48.6641796, 7.8929864 48.6647127, 7.8938598 48.6653616, 7.8950376 48.6663372, 7.8957138 48.6668586, 7.8727749 48.6751342, 7.8729617 48.6751143, 7.8731994 48.6749712, 7.8734543 48.674699, 7.8735476 48.6745787, 7.8736769 48.6744824, 7.8739485 48.6742029, 7.874091 48.6739851, 7.8742244 48.6737846, 7.8743501 48.6736201, 7.8744733 48.6734783, 7.8746794 48.6733677, 7.8750068 48.6732738, 7.8751826 48.6732118, 7.87556 48.673117, 7.8758633 48.6730584, 7.8767362 48.6730351, 7.8771214 48.673055, 7.877273 48.6730472, 7.8778064 48.6731308, 7.878189 48.6732773, 7.8785052 48.6734194, 7.8787706 48.6735521, 7.8791213 48.6737374, 7.8792623 48.6738398, 7.8794642 48.6739993, 7.8797882 48.6741872, 7.8801131 48.6744147, 7.8803414 48.6745293, 7.8804043 48.6745637, 7.8806111 48.6747369, 7.8808817 48.6749119, 7.8810273 48.6749946, 7.881154 48.675054, 7.8816641 48.6751755, 7.8826688 48.6753367, 7.8833681 48.6753828, 7.8836821 48.6754196, 7.8840389 48.6754588, 7.8842529 48.6754857, 7.8844607 48.6755209, 7.8846944 48.6755385, 7.8849022 48.6755385, 7.8852517 48.6756046, 7.8858204 48.6756884, 7.8860903 48.6756998, 7.8862702 48.6756977, 7.8864429 48.6756822, 7.8868793 48.6755643, 7.8870809 48.6754992, 7.8873673 48.6753989, 7.8875162 48.6753141, 7.8881035 48.6740867, 7.8877882 48.6740009, 7.8874443 48.6735948, 7.8871977 48.6732823, 7.8868069 48.6724292, 7.8862485 48.6718688, 7.8859011 48.6715824, 7.8856285 48.6711646, 7.8856574 48.6710408, 7.8865498 48.670933, 7.8875641 48.6707696, 7.8882243 48.6707744, 7.8889135 48.6707774, 7.8901206 48.6708058, 7.890972 48.6708205, 7.8914544 48.6705657, 7.8915595 48.6704436, 7.8923043 48.6693838, 7.8937072 48.6680494, 7.8943236 48.667762, 7.8949662 48.6673977, 7.8957138 48.6668586, 7.8185651 48.6872577, 7.8194887 48.6866964, 7.8199336 48.6864254, 7.8207734 48.6859078, 7.821596 48.6854, 7.8220081 48.6851461, 7.8224298 48.6848997, 7.8232622 48.6844145, 7.8241583 48.6838721, 7.8250455 48.6833342, 7.8255834 48.683009, 7.8262136 48.6826123, 7.8263346 48.6825477, 7.8267094 48.6822938, 7.8269836 48.682109, 7.8272987 48.6819329, 7.8274862 48.6818281, 7.8280616 48.6815058, 7.8286036 48.6811763, 7.8292124 48.6808068, 7.8299724 48.6803456, 7.8300771 48.680262, 7.830693 48.6799065, 7.8310648 48.6796951, 7.8316721 48.6799219, 7.832262 48.6801448, 7.8333371 48.6805531, 7.8342546 48.6809192, 7.8354782 48.679906, 7.8357667 48.6800686, 7.8362673 48.6797203, 7.8366185 48.6794846, 7.8371783 48.6791147, 7.8375287 48.6789055, 7.8378153 48.6787651, 7.838115 48.6786296, 7.8386333 48.6782958, 7.8392377 48.6779204, 7.839762 48.6775797, 7.8403473 48.6772045, 7.8407197 48.6769896, 7.8412916 48.6765776, 7.8418578 48.6761289, 7.8427845 48.6753533, 7.8420517 48.6750366, 7.8414955 48.6747963, 7.8409558 48.674535, 7.8404706 48.6743002, 7.8399936 48.6740708, 7.8400319 48.6740571, 7.8401638 48.6739415, 7.8407173 48.6735292, 7.8414985 48.6729362, 7.8416202 48.6728438, 7.8418824 48.6725361, 7.8421719 48.6721966, 7.8425733 48.671239, 7.8429301 48.6703806, 7.8435682 48.6705144, 7.8442846 48.6706228, 7.8445003 48.6706555, 7.8445658 48.6704862, 7.8453321 48.6695852, 7.8461336 48.6698547, 7.8465384 48.6693189, 7.8466054 48.6693819, 7.8478011 48.6692273, 7.8489516 48.6689397, 7.850036 48.6686678, 7.8501788 48.6689614, 7.8504024 48.668921, 7.8501828 48.6682611, 7.851347 48.6681084, 7.8516583 48.6687959, 7.8521419 48.6680227, 7.8523802 48.6674947, 7.8525496 48.6670515, 7.8527053 48.6671411, 7.8528639 48.6667452, 7.8536735 48.667149, 7.8542083 48.6665738, 7.8547461 48.6660764, 7.8548722 48.6661414, 7.8552209 48.6658607, 7.855543 48.6659799, 7.855935 48.6661069, 7.8564344 48.6662202, 7.8570175 48.6663029, 7.8576961 48.6664989, 7.8579355 48.6665846, 7.8581965 48.6667087, 7.8582723 48.6667541, 7.858557 48.6667974, 7.8592307 48.6669954, 7.8593065 48.6670269, 7.8593617 48.6670742, 7.8593912 48.6671471, 7.8594169 48.667284, 7.8594267 48.6674485, 7.8594464 48.6675627, 7.859541 48.6678375, 7.8595577 48.6679715, 7.8595567 48.6680394, 7.8595193 48.6681438, 7.8595272 48.6682079, 7.8594257 48.6684196, 7.858817 48.6688254, 7.8587806 48.6690185, 7.8589362 48.6691416, 7.859409 48.6693091, 7.8602038 48.6692263, 7.8606687 48.6696282, 7.8604353 48.6703295, 7.8597714 48.6704024, 7.8597419 48.6704871, 7.8597833 48.6710278, 7.8598975 48.6713194, 7.8598896 48.6714238, 7.8597419 48.6717439, 7.8597468 48.671869, 7.8598167 48.6720049, 7.8602176 48.6725752, 7.8604245 48.672522, 7.8610214 48.6726875, 7.8614784 48.6729594, 7.8615503 48.6733809, 7.8614173 48.6734449, 7.8614163 48.6735257, 7.8620014 48.6739256, 7.8623983 48.6741167, 7.8627037 48.6743117, 7.8629539 48.6744407, 7.8636089 48.6747027, 7.8641861 48.674949, 7.8644396 48.6750993, 7.8645976 48.675091, 7.8648798 48.6751333, 7.8653944 48.6751701, 7.8659832 48.6751944, 7.8664725 48.6751136, 7.8666894 48.6750918, 7.8670687 48.6751267, 7.8674537 48.6751398, 7.8676448 48.6751144, 7.8679757 48.6751436, 7.8680979 48.6751253, 7.8683157 48.6751818, 7.8685764 48.6752095, 7.8688177 48.6752063, 7.8699 48.675142, 7.870164 48.6751546, 7.8706866 48.6751667, 7.8711171 48.6751972, 7.8714203 48.6751714, 7.8725361 48.675157, 7.8727749 48.6751342, 7.8179896 48.6876074, 7.8185651 48.6872577, 7.8118358 48.6822673, 7.8123985 48.6827384, 7.8140003 48.6841325, 7.8158243 48.6857156, 7.8173845 48.6870005, 7.8179896 48.6876074, 7.7965301 48.6693074, 7.7967867 48.669609, 7.7969702 48.6697524, 7.7972111 48.6698901, 7.7979166 48.6705497, 7.7988057 48.6713069, 7.8017884 48.6737848, 7.802689 48.6745075, 7.8035379 48.6752417, 7.8042319 48.6759415, 7.806033 48.6773985, 7.8064288 48.6777082, 7.8075359 48.6786719, 7.8080808 48.6791193, 7.8086658 48.6796068, 7.8105644 48.6812301, 7.8111725 48.6817119, 7.8118358 48.6822673, 7.7965301 48.6693074, 7.7964801 48.6692408, 7.7963746 48.669052, 7.7961803 48.6683247, 7.7960526 48.6680415, 7.7956417 48.6662204, 7.7943758 48.6645325, 7.7936152 48.6628113, 7.791844 48.6598631, 7.7904338 48.6582807, 7.7894066 48.6572535, 7.7887959 48.6565928, 7.7866805 48.6539722, 7.7851814 48.6521344, 7.7842875 48.6511461, 7.7842981 48.6509976, 7.7842981 48.6509976, 7.7843665 48.6493803, 7.7848738 48.6438375, 7.7852026 48.6397131, 7.7852026 48.6397131, 7.7871027 48.6401809, 7.7873672 48.6401464, 7.7882181 48.6396405, 7.7889656 48.6394105, 7.7886419 48.6388016, 7.7889096 48.6384535, 7.7893782 48.6383464, 7.7896861 48.6377707, 7.7895656 48.6370879, 7.7890301 48.6369541, 7.7887088 48.6369139, 7.7883741 48.6364052, 7.7884812 48.6358295, 7.7888695 48.6354948, 7.7892979 48.6354814, 7.7896995 48.6357626, 7.7900877 48.6358161, 7.7911454 48.6351601, 7.790891 48.6347719, 7.7898104 48.6343719, 7.7898207 48.6337961, 7.7898601 48.6336607, 7.7899146 48.6336277, 7.7899964 48.6335781, 7.791788 48.6327905, 7.7925243 48.6330181, 7.794104 48.6344104, 7.793517 48.6354257, 7.7938675 48.6359433, 7.8360646 48.6335044, 7.8343832 48.6337216, 7.8315279 48.6331402, 7.8309336 48.6330192, 7.8306597 48.6329635, 7.8266743 48.632152, 7.8251471 48.6325399, 7.8243431 48.6333213, 7.8224958 48.6350081, 7.8222571 48.6348494, 7.8209787 48.6354216, 7.8199947 48.6358325, 7.8199508 48.6360925, 7.8199235 48.6362778, 7.8194297 48.6363199, 7.8184677 48.6364019, 7.8175635 48.6364789, 7.8168088 48.6365433, 7.8152453 48.6366778, 7.8137064 48.6368185, 7.8127828 48.6368916, 7.8126645 48.6368783, 7.8126453 48.6368761, 7.8117378 48.6367741, 7.8116177 48.6367606, 7.8113697 48.6366905, 7.8111054 48.6366157, 7.8108436 48.6365139, 7.8105456 48.636398, 7.8099118 48.6361515, 7.8097256 48.6362266, 7.8092358 48.6366002, 7.808779 48.6371092, 7.8086934 48.6378773, 7.8086875 48.6379299, 7.8088119 48.63839, 7.8087731 48.6387608, 7.8088943 48.6400999, 7.8089402 48.6402459, 7.809139 48.6407431, 7.8096891 48.6406105, 7.8111846 48.6411805, 7.8113373 48.6419109, 7.8119917 48.642502, 7.8126822 48.6429244, 7.8137003 48.6432452, 7.8141287 48.6433782, 7.8156431 48.64365, 7.8159913 48.6438178, 7.8156551 48.6439795, 7.8152333 48.6442332, 7.814643 48.6448798, 7.8139617 48.6455272, 7.8132555 48.6459587, 7.8126381 48.6460908, 7.811949 48.6461642, 7.8110037 48.6461896, 7.8089061 48.6460864, 7.8075785 48.6458, 7.8068975 48.6455737, 7.8060819 48.6450802, 7.8053112 48.6440413, 7.8048948 48.643616, 7.8040472 48.6428757, 7.8033146 48.6424764, 7.8021151 48.6417375, 7.8010346 48.6408415, 7.8006513 48.6406136, 7.799995 48.6403512, 7.7995987 48.6402533, 7.7986417 48.6402393, 7.7981429 48.6403184, 7.7977882 48.6404384, 7.7974731 48.6406235, 7.7971783 48.6410284, 7.7967892 48.6417578, 7.7966958 48.6420827, 7.7966454 48.6421805, 7.7965425 48.6423179, 7.7959481 48.6425535, 7.7955553 48.6426247, 7.7950697 48.6426218, 7.7945583 48.6425162, 7.7938752 48.6423688, 7.7933702 48.6418439, 7.793055 48.6415299, 7.7928877 48.641208, 7.7926887 48.6405274, 7.792591 48.6399704, 7.7925293 48.638504, 7.7925793 48.638204, 7.7928031 48.6374671, 7.7931313 48.6368169, 7.7938675 48.6359433, 7.8360646 48.6335044))'), 4326))), 'poly_file', NOW())
                 ON CONFLICT (insee_code) DO UPDATE SET
                    geom = EXCLUDED.geom,
                    source = EXCLUDED.source,
                    updated_at = NOW()
                 WHERE zone_polygon.source IS DISTINCT FROM EXCLUDED.source
                    OR NOT ST_Equals(zone_polygon.geom, EXCLUDED.geom);

SELECT
  osm_type,
  osm_id :: text AS osm_id,
  ST_Y(
    ST_Centroid(geom)
  ) AS lat,
  ST_X(
    ST_Centroid(geom)
  ) AS lon,
  tags :: jsonb AS tags_json,
  version,
  osm_timestamp,
  changeset,
  osm_user,
  uid :: bigint AS uid
FROM
  osm_object_meta m
WHERE
  geom IS NOT NULL
  AND ST_Intersects(
    m.geom,
    ST_GeomFromText(?, 4326)
  )
  AND (
    (tags -> 'amenity') = 'drinking_water'
  )

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('POLYGON((7.8360646 48.6335044, 7.8362401 48.6339808, 7.8362401 48.6339808, 7.836677 48.6351665, 7.8376238 48.6377956, 7.8379075 48.6384692, 7.8386235 48.6398274, 7.8393911 48.6409714, 7.8404639 48.6422894, 7.8417394 48.6435419, 7.8429273 48.6444538, 7.844278 48.645338, 7.8453164 48.6458777, 7.8466531 48.6464733, 7.8478259 48.6468614, 7.8490203 48.647208, 7.8499162 48.6473973, 7.8529395 48.6480212, 7.8556341 48.6486912, 7.8566975 48.6489969, 7.8581947 48.6494562, 7.8600078 48.6500504, 7.8626231 48.6510018, 7.8640294 48.6515693, 7.8663687 48.6524992, 7.8696862 48.6538009, 7.8729789 48.6551547, 7.8756259 48.6561991, 7.8766557 48.6565983, 7.8766557 48.6565983, 7.8834097 48.6593521, 7.8839267 48.6595857, 7.8856983 48.6603501, 7.8882894 48.661657, 7.8888491 48.6619877, 7.8903447 48.6628567, 7.8922965 48.6641796, 7.8929864 48.6647127, 7.8938598 48.6653616, 7.8950376 48.6663372, 7.8957138 48.6668586, 7.8727749 48.6751342, 7.8729617 48.6751143, 7.8731994 48.6749712, 7.8734543 48.674699, 7.8735476 48.6745787, 7.8736769 48.6744824, 7.8739485 48.6742029, 7.874091 48.6739851, 7.8742244 48.6737846, 7.8743501 48.6736201, 7.8744733 48.6734783, 7.8746794 48.6733677, 7.8750068 48.6732738, 7.8751826 48.6732118, 7.87556 48.673117, 7.8758633 48.6730584, 7.8767362 48.6730351, 7.8771214 48.673055, 7.877273 48.6730472, 7.8778064 48.6731308, 7.878189 48.6732773, 7.8785052 48.6734194, 7.8787706 48.6735521, 7.8791213 48.6737374, 7.8792623 48.6738398, 7.8794642 48.6739993, 7.8797882 48.6741872, 7.8801131 48.6744147, 7.8803414 48.6745293, 7.8804043 48.6745637, 7.8806111 48.6747369, 7.8808817 48.6749119, 7.8810273 48.6749946, 7.881154 48.675054, 7.8816641 48.6751755, 7.8826688 48.6753367, 7.8833681 48.6753828, 7.8836821 48.6754196, 7.8840389 48.6754588, 7.8842529 48.6754857, 7.8844607 48.6755209, 7.8846944 48.6755385, 7.8849022 48.6755385, 7.8852517 48.6756046, 7.8858204 48.6756884, 7.8860903 48.6756998, 7.8862702 48.6756977, 7.8864429 48.6756822, 7.8868793 48.6755643, 7.8870809 48.6754992, 7.8873673 48.6753989, 7.8875162 48.6753141, 7.8881035 48.6740867, 7.8877882 48.6740009, 7.8874443 48.6735948, 7.8871977 48.6732823, 7.8868069 48.6724292, 7.8862485 48.6718688, 7.8859011 48.6715824, 7.8856285 48.6711646, 7.8856574 48.6710408, 7.8865498 48.670933, 7.8875641 48.6707696, 7.8882243 48.6707744, 7.8889135 48.6707774, 7.8901206 48.6708058, 7.890972 48.6708205, 7.8914544 48.6705657, 7.8915595 48.6704436, 7.8923043 48.6693838, 7.8937072 48.6680494, 7.8943236 48.667762, 7.8949662 48.6673977, 7.8957138 48.6668586, 7.8185651 48.6872577, 7.8194887 48.6866964, 7.8199336 48.6864254, 7.8207734 48.6859078, 7.821596 48.6854, 7.8220081 48.6851461, 7.8224298 48.6848997, 7.8232622 48.6844145, 7.8241583 48.6838721, 7.8250455 48.6833342, 7.8255834 48.683009, 7.8262136 48.6826123, 7.8263346 48.6825477, 7.8267094 48.6822938, 7.8269836 48.682109, 7.8272987 48.6819329, 7.8274862 48.6818281, 7.8280616 48.6815058, 7.8286036 48.6811763, 7.8292124 48.6808068, 7.8299724 48.6803456, 7.8300771 48.680262, 7.830693 48.6799065, 7.8310648 48.6796951, 7.8316721 48.6799219, 7.832262 48.6801448, 7.8333371 48.6805531, 7.8342546 48.6809192, 7.8354782 48.679906, 7.8357667 48.6800686, 7.8362673 48.6797203, 7.8366185 48.6794846, 7.8371783 48.6791147, 7.8375287 48.6789055, 7.8378153 48.6787651, 7.838115 48.6786296, 7.8386333 48.6782958, 7.8392377 48.6779204, 7.839762 48.6775797, 7.8403473 48.6772045, 7.8407197 48.6769896, 7.8412916 48.6765776, 7.8418578 48.6761289, 7.8427845 48.6753533, 7.8420517 48.6750366, 7.8414955 48.6747963, 7.8409558 48.674535, 7.8404706 48.6743002, 7.8399936 48.6740708, 7.8400319 48.6740571, 7.8401638 48.6739415, 7.8407173 48.6735292, 7.8414985 48.6729362, 7.8416202 48.6728438, 7.8418824 48.6725361, 7.8421719 48.6721966, 7.8425733 48.671239, 7.8429301 48.6703806, 7.8435682 48.6705144, 7.8442846 48.6706228, 7.8445003 48.6706555, 7.8445658 48.6704862, 7.8453321 48.6695852, 7.8461336 48.6698547, 7.8465384 48.6693189, 7.8466054 48.6693819, 7.8478011 48.6692273, 7.8489516 48.6689397, 7.850036 48.6686678, 7.8501788 48.6689614, 7.8504024 48.668921, 7.8501828 48.6682611, 7.851347 48.6681084, 7.8516583 48.6687959, 7.8521419 48.6680227, 7.8523802 48.6674947, 7.8525496 48.6670515, 7.8527053 48.6671411, 7.8528639 48.6667452, 7.8536735 48.667149, 7.8542083 48.6665738, 7.8547461 48.6660764, 7.8548722 48.6661414, 7.8552209 48.6658607, 7.855543 48.6659799, 7.855935 48.6661069, 7.8564344 48.6662202, 7.8570175 48.6663029, 7.8576961 48.6664989, 7.8579355 48.6665846, 7.8581965 48.6667087, 7.8582723 48.6667541, 7.858557 48.6667974, 7.8592307 48.6669954, 7.8593065 48.6670269, 7.8593617 48.6670742, 7.8593912 48.6671471, 7.8594169 48.667284, 7.8594267 48.6674485, 7.8594464 48.6675627, 7.859541 48.6678375, 7.8595577 48.6679715, 7.8595567 48.6680394, 7.8595193 48.6681438, 7.8595272 48.6682079, 7.8594257 48.6684196, 7.858817 48.6688254, 7.8587806 48.6690185, 7.8589362 48.6691416, 7.859409 48.6693091, 7.8602038 48.6692263, 7.8606687 48.6696282, 7.8604353 48.6703295, 7.8597714 48.6704024, 7.8597419 48.6704871, 7.8597833 48.6710278, 7.8598975 48.6713194, 7.8598896 48.6714238, 7.8597419 48.6717439, 7.8597468 48.671869, 7.8598167 48.6720049, 7.8602176 48.6725752, 7.8604245 48.672522, 7.8610214 48.6726875, 7.8614784 48.6729594, 7.8615503 48.6733809, 7.8614173 48.6734449, 7.8614163 48.6735257, 7.8620014 48.6739256, 7.8623983 48.6741167, 7.8627037 48.6743117, 7.8629539 48.6744407, 7.8636089 48.6747027, 7.8641861 48.674949, 7.8644396 48.6750993, 7.8645976 48.675091, 7.8648798 48.6751333, 7.8653944 48.6751701, 7.8659832 48.6751944, 7.8664725 48.6751136, 7.8666894 48.6750918, 7.8670687 48.6751267, 7.8674537 48.6751398, 7.8676448 48.6751144, 7.8679757 48.6751436, 7.8680979 48.6751253, 7.8683157 48.6751818, 7.8685764 48.6752095, 7.8688177 48.6752063, 7.8699 48.675142, 7.870164 48.6751546, 7.8706866 48.6751667, 7.8711171 48.6751972, 7.8714203 48.6751714, 7.8725361 48.675157, 7.8727749 48.6751342, 7.8179896 48.6876074, 7.8185651 48.6872577, 7.8118358 48.6822673, 7.8123985 48.6827384, 7.8140003 48.6841325, 7.8158243 48.6857156, 7.8173845 48.6870005, 7.8179896 48.6876074, 7.7965301 48.6693074, 7.7967867 48.669609, 7.7969702 48.6697524, 7.7972111 48.6698901, 7.7979166 48.6705497, 7.7988057 48.6713069, 7.8017884 48.6737848, 7.802689 48.6745075, 7.8035379 48.6752417, 7.8042319 48.6759415, 7.806033 48.6773985, 7.8064288 48.6777082, 7.8075359 48.6786719, 7.8080808 48.6791193, 7.8086658 48.6796068, 7.8105644 48.6812301, 7.8111725 48.6817119, 7.8118358 48.6822673, 7.7965301 48.6693074, 7.7964801 48.6692408, 7.7963746 48.669052, 7.7961803 48.6683247, 7.7960526 48.6680415, 7.7956417 48.6662204, 7.7943758 48.6645325, 7.7936152 48.6628113, 7.791844 48.6598631, 7.7904338 48.6582807, 7.7894066 48.6572535, 7.7887959 48.6565928, 7.7866805 48.6539722, 7.7851814 48.6521344, 7.7842875 48.6511461, 7.7842981 48.6509976, 7.7842981 48.6509976, 7.7843665 48.6493803, 7.7848738 48.6438375, 7.7852026 48.6397131, 7.7852026 48.6397131, 7.7871027 48.6401809, 7.7873672 48.6401464, 7.7882181 48.6396405, 7.7889656 48.6394105, 7.7886419 48.6388016, 7.7889096 48.6384535, 7.7893782 48.6383464, 7.7896861 48.6377707, 7.7895656 48.6370879, 7.7890301 48.6369541, 7.7887088 48.6369139, 7.7883741 48.6364052, 7.7884812 48.6358295, 7.7888695 48.6354948, 7.7892979 48.6354814, 7.7896995 48.6357626, 7.7900877 48.6358161, 7.7911454 48.6351601, 7.790891 48.6347719, 7.7898104 48.6343719, 7.7898207 48.6337961, 7.7898601 48.6336607, 7.7899146 48.6336277, 7.7899964 48.6335781, 7.791788 48.6327905, 7.7925243 48.6330181, 7.794104 48.6344104, 7.793517 48.6354257, 7.7938675 48.6359433, 7.8360646 48.6335044, 7.8343832 48.6337216, 7.8315279 48.6331402, 7.8309336 48.6330192, 7.8306597 48.6329635, 7.8266743 48.632152, 7.8251471 48.6325399, 7.8243431 48.6333213, 7.8224958 48.6350081, 7.8222571 48.6348494, 7.8209787 48.6354216, 7.8199947 48.6358325, 7.8199508 48.6360925, 7.8199235 48.6362778, 7.8194297 48.6363199, 7.8184677 48.6364019, 7.8175635 48.6364789, 7.8168088 48.6365433, 7.8152453 48.6366778, 7.8137064 48.6368185, 7.8127828 48.6368916, 7.8126645 48.6368783, 7.8126453 48.6368761, 7.8117378 48.6367741, 7.8116177 48.6367606, 7.8113697 48.6366905, 7.8111054 48.6366157, 7.8108436 48.6365139, 7.8105456 48.636398, 7.8099118 48.6361515, 7.8097256 48.6362266, 7.8092358 48.6366002, 7.808779 48.6371092, 7.8086934 48.6378773, 7.8086875 48.6379299, 7.8088119 48.63839, 7.8087731 48.6387608, 7.8088943 48.6400999, 7.8089402 48.6402459, 7.809139 48.6407431, 7.8096891 48.6406105, 7.8111846 48.6411805, 7.8113373 48.6419109, 7.8119917 48.642502, 7.8126822 48.6429244, 7.8137003 48.6432452, 7.8141287 48.6433782, 7.8156431 48.64365, 7.8159913 48.6438178, 7.8156551 48.6439795, 7.8152333 48.6442332, 7.814643 48.6448798, 7.8139617 48.6455272, 7.8132555 48.6459587, 7.8126381 48.6460908, 7.811949 48.6461642, 7.8110037 48.6461896, 7.8089061 48.6460864, 7.8075785 48.6458, 7.8068975 48.6455737, 7.8060819 48.6450802, 7.8053112 48.6440413, 7.8048948 48.643616, 7.8040472 48.6428757, 7.8033146 48.6424764, 7.8021151 48.6417375, 7.8010346 48.6408415, 7.8006513 48.6406136, 7.799995 48.6403512, 7.7995987 48.6402533, 7.7986417 48.6402393, 7.7981429 48.6403184, 7.7977882 48.6404384, 7.7974731 48.6406235, 7.7971783 48.6410284, 7.7967892 48.6417578, 7.7966958 48.6420827, 7.7966454 48.6421805, 7.7965425 48.6423179, 7.7959481 48.6425535, 7.7955553 48.6426247, 7.7950697 48.6426218, 7.7945583 48.6425162, 7.7938752 48.6423688, 7.7933702 48.6418439, 7.793055 48.6415299, 7.7928877 48.641208, 7.7926887 48.6405274, 7.792591 48.6399704, 7.7925293 48.638504, 7.7925793 48.638204, 7.7928031 48.6374671, 7.7931313 48.6368169, 7.7938675 48.6359433, 7.8360646 48.6335044))', 4326))
            AND ((tags->'amenity') = 'drinking_water');