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

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

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

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 = 27644 AND c0_.name IN ('restaurant_count', 'restaurant_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\":\"restaurant\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-13 02:17:55', 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 = 27644 AND z0_.theme = 'restaurant' ORDER BY z0_.id ASC 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 = ?
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 = '26235' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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

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') = 'restaurant'
  )

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(((4.721535 44.326524,4.718434 44.326879,4.717916 44.326948,4.718825 44.325712,4.717694 44.325719,4.715265 44.325742,4.713727 44.325559,4.713209 44.324707,4.712423 44.323813,4.712459 44.32341,4.712532 44.322941,4.712722 44.322088,4.712952 44.321284,4.713131 44.320575,4.713129 44.320531,4.707773 44.320653,4.705637 44.320633,4.705463 44.320646,4.704678 44.320641,4.704411 44.320653,4.703161 44.320671,4.700843 44.320723,4.700361 44.320743,4.699846 44.320789,4.69912 44.320813,4.698446 44.320808,4.697905 44.320843,4.697497 44.320888,4.696888 44.320911,4.696263 44.320902,4.694615 44.320849,4.694169 44.320827,4.693082 44.320722,4.692947 44.320728,4.690708 44.320648,4.689783 44.320599,4.688731 44.320562,4.688352 44.320564,4.686359 44.320531,4.686098 44.320515,4.682329 44.320537,4.682151 44.320577,4.680845 44.320618,4.678617 44.320711,4.678379 44.320967,4.677933 44.321408,4.67714 44.32208,4.676654 44.322531,4.675509 44.323625,4.675274 44.323989,4.673276 44.324167,4.67204 44.324589,4.671486 44.324826,4.671422 44.324782,4.671312 44.32366,4.670604 44.323225,4.669711 44.32284,4.669524 44.322843,4.662849 44.325369,4.659026 44.326881,4.656235 44.327885,4.650612 44.329805,4.650212 44.331071,4.649728 44.333015,4.649591 44.334235,4.649387 44.335275,4.649125 44.337522,4.648993 44.339335,4.648595 44.342206,4.647957 44.344138,4.647293 44.34676,4.646889 44.348736,4.646892 44.349136,4.646865 44.351257,4.647029 44.352198,4.647422 44.354899,4.647621 44.356324,4.648367 44.363786,4.64864 44.367218,4.648882 44.370093,4.649176 44.371856,4.649475 44.373708,4.649787 44.374644,4.649757 44.375287,4.650053 44.376406,4.650516 44.377296,4.651051 44.378094,4.651839 44.378977,4.652576 44.380095,4.653521 44.38174,4.653869 44.382587,4.654419 44.383702,4.655737 44.385292,4.657509 44.387512,4.658354 44.387952,4.658445 44.388019,4.659487 44.388877,4.660379 44.389868,4.661138 44.390888,4.661297 44.39113,4.661442 44.3915,4.66211 44.392597,4.662316 44.393725,4.6626 44.394408,4.663436 44.395946,4.663779 44.397043,4.663832 44.397586,4.664367 44.398945,4.665539 44.399115,4.665546 44.399345,4.666199 44.400439,4.666361 44.400545,4.666541 44.400612,4.667204 44.400605,4.668008 44.400555,4.668228 44.40058,4.668524 44.400664,4.66878 44.4008,4.669074 44.400988,4.669385 44.401304,4.669944 44.401777,4.670273 44.402086,4.670376 44.402287,4.670377 44.402527,4.67034 44.4027,4.670068 44.402932,4.670554 44.403092,4.670835 44.403205,4.671124 44.403395,4.671354 44.403597,4.6715 44.40377,4.671942 44.40398,4.672625 44.404266,4.67289 44.404389,4.673881 44.405181,4.674042 44.405179,4.674273 44.405052,4.674505 44.405063,4.675194 44.405393,4.675577 44.405749,4.67586 44.405918,4.676153 44.406015,4.676487 44.406092,4.676651 44.406174,4.676981 44.406244,4.677251 44.406198,4.677578 44.406047,4.678385 44.405737,4.67871 44.405551,4.678831 44.405506,4.679586 44.405135,4.680409 44.404984,4.680729 44.405062,4.681626 44.40498,4.682575 44.404971,4.683143 44.405015,4.683918 44.405099,4.684571 44.405206,4.685023 44.405347,4.685488 44.405447,4.686188 44.405579,4.686511 44.405709,4.686606 44.405689,4.686782 44.405502,4.687324 44.405052,4.687619 44.404926,4.688133 44.404856,4.688611 44.404695,4.688809 44.404592,4.689092 44.40456,4.689754 44.404517,4.690291 44.404454,4.690773 44.404359,4.691208 44.40423,4.691415 44.404127,4.692096 44.403744,4.692561 44.40355,4.692859 44.403491,4.693448 44.403444,4.69461 44.403415,4.695225 44.403365,4.695911 44.40335,4.696434 44.403296,4.696695 44.403286,4.697849 44.403361,4.698138 44.403318,4.698499 44.403129,4.698838 44.403034,4.699161 44.403018,4.699313 44.403065,4.699598 44.403233,4.699968 44.403487,4.700189 44.40354,4.700991 44.403566,4.701422 44.403528,4.702109 44.403387,4.702341 44.403376,4.702832 44.40343,4.703301 44.403535,4.703788 44.403783,4.704113 44.404043,4.704372 44.404223,4.705308 44.404728,4.705582 44.40492,4.705874 44.405188,4.706186 44.405575,4.706435 44.405795,4.706632 44.405866,4.706951 44.405869,4.707657 44.406193,4.709552 44.406187,4.709709 44.406233,4.710215 44.406254,4.711878 44.406277,4.712468 44.406251,4.713652 44.406169,4.714356 44.40611,4.715017 44.406068,4.714954 44.403872,4.712087 44.400585,4.715466 44.400368,4.715238 44.398353,4.714591 44.393085,4.714197 44.39136,4.713748 44.39038,4.714013 44.390373,4.713528 44.386867,4.711545 44.386279,4.711877 44.385815,4.711749 44.38446,4.712598 44.383123,4.71352 44.38165,4.713934 44.381051,4.714235 44.380291,4.714552 44.380367,4.714879 44.380496,4.715536 44.380806,4.715936 44.378255,4.712928 44.37831,4.71274 44.376489,4.71271 44.376095,4.712647 44.37567,4.712537 44.375326,4.711873 44.373136,4.712512 44.372964,4.713452 44.372788,4.713828 44.372729,4.714784 44.372626,4.715188 44.372597,4.715731 44.372537,4.716906 44.37229,4.717621 44.372148,4.718058 44.372048,4.719308 44.371724,4.719565 44.371666,4.721191 44.371406,4.722119 44.37117,4.722757 44.37099,4.723406 44.370764,4.72389 44.370537,4.724638 44.370032,4.7248 44.369948,4.72551 44.369842,4.725893 44.369822,4.72633 44.369825,4.72691 44.369866,4.727235 44.369903,4.728737 44.369372,4.728861 44.368813,4.728863 44.368708,4.728987 44.368503,4.729025 44.368321,4.729029 44.367896,4.728983 44.367628,4.729007 44.367215,4.729152 44.367089,4.729175 44.366937,4.729105 44.366529,4.72902 44.366283,4.728855 44.365705,4.728696 44.365092,4.728488 44.364535,4.728501 44.364305,4.728657 44.363935,4.728873 44.363517,4.7292 44.363116,4.729422 44.362731,4.729401 44.362504,4.729457 44.361983,4.729881 44.361345,4.730318 44.360737,4.730324 44.36029,4.730392 44.359819,4.730412 44.359115,4.730506 44.358528,4.729646 44.3585,4.729431 44.358101,4.729312 44.35784,4.729272 44.357558,4.729281 44.356958,4.729393 44.356639,4.729492 44.356034,4.729996 44.352802,4.728689 44.351904,4.727449 44.35199,4.726894 44.352007,4.726884 44.349249,4.72895 44.346789,4.728379 44.345589,4.72858 44.343722,4.726798 44.343285,4.726761 44.340908,4.726577 44.339487,4.726522 44.339303,4.726234 44.338856,4.725977 44.338603,4.725407 44.338121,4.724499 44.337643,4.723033 44.336937,4.722251 44.336609,4.721835 44.336294,4.721164 44.335639,4.721031 44.335452,4.720933 44.335144,4.720512 44.334282,4.720486 44.333773,4.720383 44.332681,4.720373 44.331781,4.720388 44.330999,4.720354 44.330759,4.720105 44.330254,4.72009 44.330022,4.720086 44.329159,4.720224 44.32815,4.720547 44.327547,4.720756 44.327286,4.721148 44.326898,4.721342 44.326732,4.721535 44.326524)))', 4326))
            AND ((tags->'amenity') = 'restaurant');

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

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