Symfony Profiler

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

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

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\":\"microbibliotheque\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-15 09:20:00', NULL, NULL);

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

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 = 25070 AND z0_.theme = 'microbibliotheque' 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 = 25070;

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 = '02167' 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 (
    (tags -> 'amenity') = 'public_bookcase'
  )

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.479198 49.399451,3.479642 49.399576,3.480242 49.39978,3.480825 49.400085,3.481325 49.400378,3.481571 49.400556,3.481695 49.400695,3.482451 49.401099,3.483233 49.401484,3.483779 49.40182,3.484362 49.402198,3.484707 49.402403,3.485101 49.402608,3.485525 49.40285,3.486042 49.403197,3.486434 49.402966,3.49267 49.398966,3.494821 49.397587,3.501236 49.393468,3.504603 49.395401,3.509479 49.396308,3.507706 49.390234,3.50798 49.385927,3.50996 49.382817,3.510008 49.382724,3.510188 49.382624,3.510301 49.382406,3.520051 49.381834,3.520745 49.38182,3.521975 49.381758,3.522479 49.38172,3.523642 49.381683,3.524404 49.381642,3.525351 49.381563,3.527187 49.381501,3.528474 49.381408,3.528644 49.381524,3.534428 49.38156,3.533845 49.377629,3.533683 49.376881,3.533292 49.374897,3.532721 49.372818,3.53172 49.370132,3.529634 49.368532,3.529311 49.368751,3.528544 49.369127,3.528047 49.369349,3.527398 49.369607,3.526919 49.369735,3.526093 49.369399,3.5238 49.368511,3.523769 49.368451,3.523474 49.368307,3.522684 49.367996,3.52221 49.367839,3.520208 49.367051,3.518516 49.366343,3.517664 49.366024,3.516994 49.365696,3.516643 49.365539,3.515976 49.365297,3.51551 49.365147,3.51504 49.364938,3.514633 49.364686,3.514481 49.364565,3.514067 49.364358,3.512608 49.363659,3.51247 49.363503,3.512408 49.363029,3.512344 49.362885,3.512046 49.36246,3.510894 49.360399,3.510771 49.360208,3.510664 49.359952,3.510399 49.359518,3.510194 49.359052,3.51017 49.358829,3.510342 49.357907,3.510382 49.35757,3.510118 49.357383,3.509869 49.357262,3.509328 49.357039,3.508862 49.356746,3.507948 49.356093,3.50765 49.355861,3.507404 49.355639,3.507035 49.355409,3.506913 49.355306,3.50623 49.354811,3.505885 49.354736,3.503875 49.354144,3.503808 49.353788,3.503753 49.353654,3.503497 49.353287,3.503536 49.353108,3.501944 49.352325,3.50192 49.352372,3.501368 49.35303,3.501259 49.353275,3.500995 49.353642,3.500932 49.353813,3.500924 49.353991,3.500974 49.354154,3.50097 49.354494,3.500862 49.354674,3.5008 49.354963,3.500894 49.355134,3.500857 49.355387,3.500734 49.355491,3.50025 49.355688,3.500105 49.355794,3.500009 49.356092,3.500023 49.356427,3.499934 49.356856,3.49981 49.357271,3.499728 49.357632,3.4997 49.357889,3.499774 49.358119,3.499868 49.358273,3.500028 49.358354,3.500566 49.358467,3.500736 49.358548,3.500946 49.358767,3.501062 49.35884,3.501562 49.358973,3.501694 49.359183,3.501541 49.359354,3.501226 49.359521,3.500955 49.359613,3.50021 49.359753,3.500076 49.359845,3.499989 49.360038,3.500066 49.360416,3.499999 49.360483,3.499606 49.360687,3.499112 49.360915,3.498889 49.361058,3.49879 49.361207,3.498675 49.361617,3.498543 49.361766,3.498168 49.361845,3.497785 49.361878,3.497675 49.362072,3.497485 49.3622,3.496979 49.362368,3.496832 49.362451,3.496773 49.36283,3.496673 49.362897,3.496198 49.36305,3.495884 49.363187,3.495143 49.363551,3.494501 49.363777,3.494045 49.363915,3.493684 49.36394,3.492917 49.364033,3.492628 49.364031,3.491779 49.363903,3.490756 49.363861,3.4903 49.363814,3.49015 49.363764,3.490066 49.363535,3.490131 49.363348,3.490024 49.363157,3.489816 49.363034,3.489048 49.362766,3.488766 49.362761,3.488573 49.362823,3.488282 49.362967,3.48798 49.363163,3.487812 49.363328,3.487572 49.363715,3.487148 49.363979,3.486767 49.364243,3.486482 49.364257,3.486243 49.364152,3.485969 49.364146,3.485815 49.364334,3.485848 49.364808,3.486041 49.365267,3.486046 49.365489,3.485994 49.365623,3.485847 49.36572,3.485351 49.365889,3.48514 49.366062,3.485095 49.366544,3.484951 49.366738,3.48427 49.366745,3.483963 49.366778,3.483784 49.366861,3.483743 49.367032,3.48378 49.367209,3.483944 49.367371,3.484137 49.367406,3.484524 49.367396,3.485352 49.367328,3.485951 49.367263,3.486077 49.367305,3.486092 49.367432,3.485993 49.367625,3.485727 49.367887,3.485503 49.368023,3.485312 49.368077,3.485107 49.368079,3.484398 49.367871,3.483778 49.367603,3.483517 49.367576,3.483313 49.3676,3.483156 49.36772,3.482847 49.368095,3.48251 49.368239,3.481781 49.36861,3.481708 49.368892,3.481774 49.369008,3.481734 49.369145,3.481598 49.369354,3.481154 49.369901,3.480619 49.370603,3.480499 49.370941,3.480653 49.37152,3.480672 49.37188,3.480441 49.371981,3.48003 49.371948,3.479523 49.371799,3.479196 49.371825,3.479035 49.371996,3.479064 49.372171,3.479211 49.372468,3.479191 49.372637,3.478845 49.372854,3.478872 49.373037,3.478991 49.373113,3.4797 49.373403,3.479785 49.373511,3.479875 49.373839,3.479833 49.374046,3.479587 49.374507,3.479603 49.374751,3.479854 49.374979,3.480528 49.375217,3.480801 49.375359,3.481435 49.375881,3.481659 49.376039,3.481873 49.376152,3.482464 49.376337,3.482537 49.376451,3.482541 49.376627,3.482456 49.377041,3.482575 49.377116,3.482786 49.37706,3.482911 49.376952,3.483097 49.376889,3.483367 49.376879,3.483989 49.376973,3.484226 49.377054,3.484512 49.37728,3.484789 49.377568,3.485003 49.377712,3.485205 49.377794,3.485425 49.377737,3.485737 49.377506,3.485888 49.377444,3.486145 49.377494,3.48623 49.37757,3.486281 49.377745,3.486286 49.377982,3.486218 49.378447,3.486325 49.378699,3.486577 49.37887,3.486613 49.379046,3.486475 49.37918,3.485765 49.379379,3.485398 49.379551,3.485262 49.379739,3.485454 49.37997,3.485666 49.380075,3.486213 49.380262,3.486691 49.38045,3.486836 49.38065,3.486738 49.380804,3.486406 49.380904,3.485951 49.380948,3.485836 49.381056,3.485979 49.381207,3.486605 49.381428,3.487128 49.381504,3.48722 49.381797,3.487346 49.381847,3.487476 49.381775,3.487469 49.381532,3.487345 49.381214,3.487372 49.38096,3.487492 49.380827,3.487813 49.38057,3.488212 49.380414,3.48863 49.380344,3.488849 49.380373,3.488944 49.380554,3.488918 49.380701,3.488731 49.381047,3.488405 49.381314,3.488339 49.381523,3.488462 49.381769,3.488332 49.382172,3.488158 49.382416,3.487981 49.382534,3.487902 49.382723,3.488028 49.382849,3.487792 49.383302,3.487324 49.38395,3.487154 49.384286,3.487244 49.384488,3.487926 49.385079,3.488082 49.385134,3.48865 49.385228,3.488754 49.38531,3.488868 49.385551,3.488898 49.385874,3.488862 49.385983,3.488617 49.386111,3.488269 49.38617,3.488124 49.386268,3.488136 49.386496,3.488281 49.386646,3.488421 49.386676,3.488753 49.386611,3.489072 49.38632,3.48951 49.385793,3.489709 49.385664,3.489841 49.385628,3.490152 49.385625,3.490379 49.385749,3.490434 49.386149,3.49054 49.386295,3.49064 49.386324,3.491176 49.386329,3.491334 49.386438,3.491324 49.386677,3.491171 49.38681,3.490855 49.38692,3.490701 49.386931,3.490452 49.386883,3.49031 49.386813,3.490053 49.386776,3.489884 49.386858,3.48985 49.387021,3.48991 49.387234,3.490078 49.387516,3.489956 49.387588,3.48967 49.387621,3.489277 49.387736,3.488957 49.387689,3.488585 49.387399,3.48828 49.387255,3.488013 49.387216,3.487685 49.387398,3.48735 49.387391,3.487068 49.387262,3.486839 49.387082,3.486666 49.387023,3.486371 49.386999,3.485753 49.387128,3.485488 49.387085,3.485409 49.387015,3.485437 49.386888,3.485782 49.386717,3.485965 49.386588,3.485844 49.386367,3.485709 49.386287,3.485414 49.386214,3.485111 49.386232,3.484919 49.386326,3.484717 49.386632,3.484715 49.3869,3.484827 49.387056,3.485151 49.387286,3.485296 49.387477,3.485174 49.38764,3.485005 49.387708,3.484672 49.387732,3.483957 49.387673,3.483629 49.38759,3.483034 49.387363,3.482559 49.387302,3.482331 49.387197,3.482242 49.387036,3.482338 49.386822,3.48257 49.38646,3.48248 49.386274,3.482386 49.386193,3.48185 49.385895,3.481421 49.385783,3.481096 49.385817,3.480796 49.385986,3.480609 49.386216,3.48062 49.386389,3.480823 49.386792,3.480836 49.386954,3.480706 49.387097,3.480226 49.387462,3.479975 49.387707,3.479918 49.38791,3.480048 49.388097,3.480141 49.388157,3.480697 49.388349,3.480768 49.388403,3.480767 49.388543,3.483567 49.38985,3.480374 49.392845,3.479736 49.393267,3.479599 49.393479,3.478159 49.395163,3.475263 49.398023,3.474731 49.398535,3.475169 49.398696,3.476261 49.399005,3.476885 49.399146,3.477351 49.399208,3.478255 49.399264,3.478599 49.399305,3.479198 49.399451)))', 4326))
            AND ((tags->'amenity') = 'public_bookcase');

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'02167'') = ?
  AND (tags->'admin_level') = '8'
  AND (tags->'boundary') = 'administrative'
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1;

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;

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

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

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