Symfony Profiler

"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.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 = '59122';

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

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 = 26439 AND c0_.name IN ('signalisation_count', 'signalisation_completion') ORDER BY c0_.date ASC, c0_.id ASC;

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\":\"signalisation\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-14 14:27:04', NULL, NULL);

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 = 26439 AND z0_.theme = 'signalisation' ORDER BY z0_.id ASC LIMIT 1;

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

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 = '59122' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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 (
    exist(tags, 'traffic_sign')
    OR (tags -> 'highway') IN (
      'traffic_signals', 'give_way', 'stop'
    )
    OR (tags -> 'crossing') = 'traffic_signals'
    OR exist(tags, 'traffic_calming')
    OR (tags -> 'railway') IN ('level_crossing', 'crossing')
    OR exist(tags, 'maxheight')
    OR exist(tags, 'maxwidth')
    OR (
      osm_type IN ('way', 'relation')
      AND (
        exist(tags, 'maxspeed')
        OR (tags -> 'oneway') = 'yes'
      )
    )
  )

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.204566 50.169716,3.205778 50.170041,3.207915 50.170964,3.207375 50.171439,3.208455 50.171947,3.204295 50.174328,3.203855 50.174583,3.202891 50.173914,3.202057 50.174432,3.201429 50.175593,3.20285 50.175903,3.204155 50.17616,3.204681 50.17623,3.206113 50.176562,3.206725 50.176713,3.20815 50.176992,3.209693 50.17732,3.20956 50.177441,3.209045 50.177764,3.20857 50.177907,3.20678 50.178255,3.209069 50.178886,3.209597 50.179438,3.212419 50.178686,3.212509 50.178826,3.213379 50.179803,3.213664 50.180164,3.214003 50.180508,3.215242 50.180006,3.217138 50.179575,3.217198 50.179634,3.219184 50.179376,3.219369 50.179359,3.219498 50.179498,3.219601 50.179681,3.219715 50.180101,3.220051 50.180539,3.220214 50.180646,3.22129 50.181114,3.221945 50.181416,3.222119 50.181538,3.222389 50.181829,3.222784 50.182317,3.223299 50.182928,3.223389 50.183085,3.2237 50.183804,3.223818 50.184016,3.224166 50.184533,3.224881 50.185484,3.225985 50.186549,3.227003 50.186203,3.226513 50.185606,3.22676 50.18548,3.226372 50.184944,3.227307 50.184525,3.228082 50.184263,3.227871 50.184006,3.22828 50.184138,3.228657 50.184051,3.229257 50.184318,3.229362 50.184497,3.229544 50.18466,3.230278 50.185194,3.230615 50.185472,3.230887 50.185649,3.23134 50.185991,3.232463 50.186315,3.234334 50.187739,3.234694 50.187967,3.235687 50.188322,3.235819 50.188993,3.23559 50.189163,3.234176 50.190028,3.233429 50.19037,3.234666 50.191151,3.233664 50.191798,3.233477 50.191716,3.233209 50.191745,3.232971 50.191702,3.232643 50.191941,3.229102 50.194166,3.230315 50.195105,3.229272 50.195853,3.229248 50.195997,3.22939 50.196131,3.229867 50.196449,3.228592 50.197456,3.227707 50.197788,3.226989 50.19822,3.228513 50.199381,3.228321 50.1995,3.228757 50.199825,3.229617 50.200557,3.229323 50.200817,3.229769 50.201189,3.228995 50.201439,3.229204 50.201984,3.227527 50.202901,3.228314 50.203484,3.229509 50.202791,3.230528 50.203558,3.230984 50.203219,3.2349 50.200897,3.234894 50.201459,3.234939 50.202336,3.234943 50.202892,3.235633 50.202645,3.237402 50.201601,3.238919 50.200369,3.239199 50.20018,3.242772 50.201859,3.243157 50.201628,3.243896 50.201212,3.244466 50.200823,3.244681 50.200696,3.245329 50.20037,3.241823 50.198553,3.243435 50.197635,3.244152 50.19809,3.246535 50.196705,3.246096 50.196416,3.24703 50.195768,3.248589 50.194728,3.247946 50.194564,3.247507 50.194425,3.246907 50.194137,3.247546 50.192965,3.248114 50.192983,3.24888 50.192838,3.248473 50.19242,3.248396 50.192219,3.248115 50.191941,3.24785 50.191777,3.247522 50.191607,3.246502 50.191135,3.246129 50.190922,3.245725 50.19064,3.245569 50.190505,3.247132 50.189121,3.24844 50.187981,3.249612 50.186985,3.250402 50.186244,3.25264 50.184063,3.253966 50.184797,3.255455 50.183465,3.256273 50.183652,3.256398 50.183645,3.256753 50.183708,3.257883 50.183859,3.258243 50.184121,3.258568 50.184281,3.258802 50.184362,3.260446 50.184832,3.261472 50.185137,3.262852 50.184043,3.262568 50.183803,3.262626 50.183623,3.263326 50.183265,3.263939 50.182828,3.264973 50.183493,3.267904 50.182343,3.269873 50.183904,3.27077 50.183231,3.271006 50.183319,3.271571 50.182657,3.272321 50.181828,3.272351 50.181744,3.272676 50.181768,3.273249 50.181778,3.273657 50.181756,3.274091 50.18171,3.277233 50.18128,3.277862 50.181201,3.278349 50.181173,3.281195 50.181034,3.281146 50.180776,3.279627 50.179917,3.279543 50.179655,3.278073 50.178622,3.278366 50.178138,3.278406 50.177902,3.277466 50.176059,3.276658 50.174675,3.275808 50.174044,3.275837 50.173154,3.275078 50.173187,3.274582 50.172088,3.274333 50.171678,3.274521 50.171618,3.275607 50.171196,3.275988 50.171139,3.275802 50.170004,3.276214 50.170025,3.276613 50.16991,3.277617 50.169398,3.27772 50.169267,3.277431 50.167609,3.276979 50.167685,3.275043 50.165446,3.272282 50.166078,3.271168 50.163803,3.270972 50.162626,3.270407 50.162821,3.269219 50.161787,3.269408 50.161679,3.268319 50.1608,3.26799 50.160949,3.267045 50.160406,3.267892 50.159872,3.265651 50.158286,3.266875 50.157618,3.267856 50.157045,3.266816 50.156077,3.267253 50.155171,3.26719 50.155059,3.265148 50.154753,3.26551 50.154227,3.266439 50.153414,3.264911 50.152578,3.264155 50.152307,3.264411 50.152023,3.263144 50.152007,3.2591 50.152179,3.25512 50.151957,3.252956 50.151795,3.25002 50.151428,3.245923 50.150487,3.24257 50.14919,3.233072 50.145783,3.229513 50.144381,3.224499 50.142563,3.221926 50.141585,3.217707 50.140776,3.218297 50.142774,3.214105 50.145256,3.215238 50.146476,3.215962 50.147133,3.216814 50.147851,3.218146 50.148934,3.218408 50.14916,3.218672 50.149427,3.219158 50.149961,3.219424 50.150325,3.219659 50.15069,3.219973 50.151222,3.220126 50.151517,3.220384 50.151946,3.221014 50.152883,3.221322 50.153244,3.22168 50.153336,3.22203 50.154477,3.222469 50.155293,3.222733 50.155743,3.223312 50.156781,3.223963 50.157918,3.224034 50.158028,3.223032 50.158508,3.223941 50.159343,3.223343 50.15986,3.222639 50.160348,3.222419 50.160524,3.223929 50.161532,3.22241 50.162428,3.221872 50.162059,3.220047 50.162936,3.219695 50.162729,3.217732 50.164526,3.218159 50.164733,3.216716 50.166153,3.216611 50.166101,3.216262 50.166045,3.215716 50.165771,3.215265 50.166157,3.215357 50.166496,3.21354 50.165588,3.213198 50.165795,3.212533 50.165573,3.212249 50.165597,3.211899 50.165486,3.211517 50.165278,3.211003 50.164854,3.210894 50.164818,3.210696 50.164968,3.209759 50.165404,3.208807 50.164827,3.2083 50.164483,3.208014 50.164632,3.207826 50.164877,3.207449 50.165437,3.207088 50.165938,3.20702 50.166009,3.207696 50.166218,3.20918 50.166738,3.210193 50.167033,3.210493 50.167085,3.210794 50.167252,3.211128 50.167526,3.211617 50.16779,3.212286 50.167969,3.213649 50.166968,3.215189 50.167179,3.215928 50.167309,3.216558 50.167496,3.216949 50.167646,3.217875 50.168154,3.215925 50.169572,3.218454 50.171055,3.216865 50.172701,3.215662 50.17208,3.213187 50.170501,3.213285 50.170261,3.211334 50.169789,3.211204 50.169983,3.208467 50.170949,3.207698 50.170516,3.206558 50.16998,3.205799 50.169755,3.204664 50.169581,3.204566 50.169716)))', 4326))
  AND (
       exist(tags, 'traffic_sign')
    OR (tags->'highway') IN ('traffic_signals','give_way','stop')
    OR (tags->'crossing') = 'traffic_signals'
    OR exist(tags, 'traffic_calming')
    OR (tags->'railway') IN ('level_crossing','crossing')
    OR exist(tags, 'maxheight')
    OR exist(tags, 'maxwidth')
    OR (osm_type IN ('way','relation') AND (
        exist(tags, 'maxspeed')
     OR (tags->'oneway') = 'yes'
    ))
  );

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'59122'') = ?
  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 = '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
  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)
  )
FROM
  zone_polygon
WHERE
  insee_code = ?

SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = '59122';

SELECT
  1

SELECT 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: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'59122'') = ?
      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 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);

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()
                );