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 = '02361';

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:02', NULL, NULL);

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

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

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

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 = '02361' 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.605802 49.915432,3.60685 49.91523,3.608158 49.914998,3.608988 49.914941,3.609328 49.914906,3.609073 49.914566,3.61014 49.914329,3.61039 49.91441,3.611246 49.914613,3.61184 49.914836,3.61204 49.914894,3.612269 49.914903,3.6129 49.91483,3.613063 49.914832,3.613221 49.91494,3.613319 49.915072,3.613735 49.914287,3.613959 49.914116,3.614471 49.9135,3.615102 49.912924,3.615542 49.912623,3.615995 49.91237,3.616581 49.912066,3.616896 49.912208,3.617047 49.912357,3.617232 49.912404,3.61751 49.912225,3.617491 49.912089,3.617861 49.911984,3.618221 49.911844,3.61925 49.911985,3.619682 49.911925,3.619971 49.911932,3.621015 49.911519,3.622281 49.911035,3.623028 49.910722,3.623359 49.910602,3.623537 49.91074,3.6242 49.911354,3.625115 49.912129,3.625465 49.91234,3.625826 49.912451,3.626132 49.912498,3.626586 49.912526,3.627464 49.912627,3.627772 49.912787,3.627732 49.913609,3.627852 49.913602,3.635912 49.912507,3.636687 49.912384,3.637094 49.912431,3.63762 49.912604,3.640929 49.913663,3.64131 49.913771,3.641652 49.913379,3.642452 49.912501,3.643558 49.913508,3.644334 49.914126,3.645251 49.915045,3.645785 49.915471,3.64734 49.91665,3.647492 49.916747,3.648787 49.917327,3.649103 49.917651,3.649862 49.918493,3.649767 49.918472,3.651232 49.919984,3.651506 49.920243,3.651875 49.919852,3.652023 49.919768,3.652323 49.919745,3.65232 49.91955,3.652031 49.919209,3.651939 49.918902,3.651954 49.918573,3.651775 49.918339,3.651712 49.918109,3.651768 49.917889,3.652109 49.917274,3.65207 49.917055,3.651898 49.91697,3.651812 49.916811,3.651982 49.916741,3.652346 49.916757,3.652805 49.916848,3.653133 49.91682,3.654041 49.916605,3.654423 49.916537,3.654696 49.916425,3.65521 49.916303,3.65546 49.916182,3.655782 49.915962,3.655706 49.915918,3.655966 49.915801,3.656278 49.915268,3.656157 49.914985,3.656052 49.914889,3.655984 49.914161,3.656032 49.914075,3.656658 49.913768,3.656445 49.913239,3.655947 49.913125,3.655594 49.912915,3.655709 49.912818,3.655102 49.912449,3.653949 49.911623,3.655377 49.909833,3.656884 49.911442,3.657056 49.911654,3.656203 49.912373,3.656209 49.912445,3.656641 49.912347,3.657118 49.912114,3.657695 49.911711,3.65782 49.911576,3.657447 49.911341,3.657554 49.911222,3.657836 49.910822,3.658457 49.910567,3.658719 49.910482,3.658886 49.910474,3.657654 49.909646,3.656688 49.909016,3.654962 49.907999,3.65339 49.907178,3.65332 49.907231,3.650322 49.905877,3.650833 49.905517,3.650178 49.905367,3.646897 49.904551,3.645676 49.904226,3.645693 49.903946,3.646393 49.904093,3.646472 49.903581,3.645889 49.903461,3.645849 49.903091,3.646243 49.902649,3.646244 49.902524,3.647423 49.901078,3.64693 49.901032,3.646689 49.901331,3.644599 49.901295,3.644715 49.900611,3.645276 49.900229,3.645322 49.900106,3.64571 49.900068,3.64433 49.899638,3.645083 49.899131,3.645341 49.899184,3.646854 49.897723,3.647219 49.897804,3.647888 49.897111,3.647377 49.89697,3.647925 49.89663,3.64819 49.896523,3.648682 49.896406,3.649447 49.896261,3.649173 49.896158,3.649286 49.896001,3.649389 49.89576,3.649578 49.895117,3.649722 49.894961,3.64997 49.894942,3.650101 49.894886,3.65073 49.894496,3.650704 49.894098,3.650841 49.893914,3.651191 49.893557,3.651824 49.893352,3.65226 49.893124,3.65245 49.89305,3.652624 49.892934,3.652975 49.892775,3.65327 49.892494,3.653331 49.892267,3.654827 49.89203,3.655015 49.891988,3.655121 49.891898,3.654942 49.89172,3.654768 49.891441,3.654984 49.891415,3.65505 49.890841,3.65497 49.890698,3.656496 49.887467,3.655924 49.887478,3.655483 49.887515,3.654772 49.887599,3.653923 49.887727,3.653591 49.886615,3.653573 49.886371,3.653765 49.886308,3.654386 49.885718,3.654721 49.885438,3.65556 49.88479,3.655839 49.884645,3.656188 49.884501,3.656623 49.884361,3.65717 49.884141,3.657366 49.88401,3.657266 49.883858,3.656371 49.882742,3.656179 49.882261,3.65626 49.881548,3.656154 49.881212,3.656021 49.881047,3.655719 49.880814,3.655324 49.880571,3.655155 49.880431,3.654287 49.880783,3.653062 49.87913,3.653518 49.879009,3.653298 49.878799,3.652903 49.87836,3.652331 49.877756,3.651564 49.876914,3.650442 49.87573,3.650206 49.875435,3.649857 49.875397,3.649002 49.875196,3.648697 49.875097,3.647648 49.874613,3.646842 49.87433,3.644773 49.875069,3.643967 49.874624,3.643296 49.875306,3.644143 49.876092,3.644366 49.875977,3.644421 49.876341,3.643549 49.876877,3.643811 49.878241,3.643178 49.878642,3.642213 49.881291,3.639874 49.879794,3.638891 49.880423,3.638447 49.880274,3.637446 49.880072,3.636927 49.880496,3.635757 49.880122,3.634375 49.879733,3.633802 49.879582,3.633576 49.87958,3.632858 49.878254,3.631645 49.876,3.631196 49.875173,3.628173 49.875445,3.627452 49.875558,3.625936 49.875989,3.623728 49.877199,3.621733 49.877734,3.621127 49.876846,3.620664 49.87688,3.620764 49.876369,3.620421 49.8763,3.620375 49.87645,3.618427 49.876756,3.616287 49.877223,3.613737 49.877799,3.614245 49.878792,3.611509 49.879684,3.611682 49.878565,3.609344 49.878646,3.609314 49.879821,3.605136 49.881044,3.602467 49.881828,3.601698 49.881233,3.599543 49.881918,3.596514 49.882898,3.596931 49.884188,3.596969 49.884636,3.603916 49.886639,3.60288 49.88749,3.601028 49.88904,3.599774 49.890109,3.598998 49.890085,3.598756 49.889934,3.598574 49.889503,3.60002 49.887934,3.600228 49.887671,3.601018 49.887096,3.601253 49.886897,3.601178 49.886793,3.600845 49.886483,3.597204 49.886015,3.597069 49.8861,3.596832 49.88635,3.59676 49.886565,3.596851 49.887563,3.596702 49.888362,3.596764 49.888917,3.596975 49.889374,3.595911 49.889327,3.595192 49.889207,3.595165 49.8893,3.592014 49.888968,3.591404 49.889304,3.591204 49.8896,3.59092 49.88957,3.590404 49.889572,3.590085 49.89,3.587524 49.889543,3.587374 49.890051,3.587408 49.890288,3.587814 49.890366,3.587853 49.890842,3.58806 49.891434,3.588752 49.891492,3.587467 49.892581,3.586841 49.893655,3.58705 49.894646,3.587165 49.895076,3.588251 49.896049,3.589353 49.897057,3.590166 49.897751,3.59065 49.897683,3.59066 49.89662,3.590673 49.896096,3.59124 49.896145,3.591281 49.897759,3.59136 49.899425,3.589765 49.899797,3.589963 49.900624,3.590719 49.900632,3.592492 49.900629,3.593463 49.900668,3.591636 49.902408,3.594504 49.903806,3.592515 49.906004,3.593551 49.905857,3.593881 49.905889,3.593713 49.906038,3.595297 49.906656,3.596916 49.907302,3.597046 49.907185,3.597721 49.907452,3.597984 49.907037,3.598109 49.906969,3.598503 49.906895,3.599313 49.906805,3.600181 49.906757,3.600726 49.906929,3.601053 49.907092,3.602363 49.90797,3.602611 49.908249,3.603026 49.90889,3.603358 49.909431,3.603742 49.909772,3.604134 49.910024,3.604494 49.910228,3.604796 49.910346,3.604871 49.910464,3.604952 49.910746,3.604999 49.911065,3.605087 49.911196,3.605327 49.91265,3.605455 49.913133,3.605679 49.913669,3.605661 49.914034,3.605553 49.914579,3.605657 49.915245,3.605802 49.915432)))', 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'02361'') = ?
  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
  1

SELECT 1;

SELECT
  ST_AsText(
    ST_Multi(geom)
  )
FROM
  zone_polygon
WHERE
  insee_code = ?

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

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'02361'') = ?
      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()
                );