Symfony Profiler

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

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

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

"COMMIT"

"COMMIT";

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

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

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 = '24037' 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 = ?
  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 = 25736 AND z0_.theme = 'plein_air' ORDER BY z0_.id ASC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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,
  ST_AsGeoJSON(
    ST_Force2D(geom),
    6,
    0
  ) AS geom_geojson,
  ST_Length(geom :: geography) AS length_m,
  (tags -> 'route') AS route_value
FROM
  osm_object_meta m
WHERE
  geom IS NOT NULL
  AND osm_type = 'relation'
  AND ST_Intersects(
    m.geom,
    ST_GeomFromText(?, 4326)
  )
  AND (tags -> 'type') = 'route'
  AND (tags -> 'route') IN (
    'hiking', 'foot', 'running', 'walking',
    'fitness_trail', 'horse', 'inline_skates'
  )

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,
       ST_AsGeoJSON(ST_Force2D(geom), 6, 0) AS geom_geojson,
       ST_Length(geom::geography) AS length_m,
       (tags->'route') AS route_value
FROM osm_object_meta m
WHERE geom IS NOT NULL
  AND osm_type = 'relation'
  AND ST_Intersects(m.geom, ST_GeomFromText('MULTIPOLYGON(((0.515622 44.804175,0.515273 44.804192,0.515053 44.804144,0.513073 44.803766,0.512058 44.805935,0.510676 44.805613,0.510637 44.805762,0.510199 44.806896,0.509789 44.808104,0.509251 44.809821,0.508676 44.81044,0.506701 44.812798,0.506238 44.812949,0.505967 44.813453,0.505621 44.813407,0.505202 44.814242,0.50482 44.813969,0.504659 44.813816,0.504584 44.813694,0.503228 44.813868,0.503291 44.814211,0.501531 44.814345,0.500069 44.815138,0.499619 44.815181,0.498947 44.815215,0.499014 44.815545,0.499 44.815735,0.498411 44.816125,0.497862 44.816568,0.496892 44.816462,0.495566 44.816369,0.494396 44.816302,0.493402 44.816212,0.49331 44.817022,0.492929 44.819656,0.492533 44.819542,0.491652 44.819321,0.491402 44.819272,0.489976 44.8185,0.485627 44.816106,0.485579 44.816084,0.48578 44.815795,0.486266 44.815185,0.486509 44.814694,0.486382 44.814677,0.485377 44.814735,0.484514 44.81451,0.484211 44.814523,0.482593 44.81456,0.480981 44.81481,0.480798 44.814825,0.480732 44.814745,0.480733 44.814255,0.480647 44.814004,0.480363 44.813744,0.479656 44.813125,0.479512 44.813251,0.479189 44.813471,0.477968 44.814228,0.47772 44.814338,0.476438 44.814623,0.475521 44.814584,0.475387 44.814666,0.474752 44.814682,0.472747 44.814752,0.472076 44.814795,0.471187 44.814877,0.470898 44.814963,0.470467 44.815185,0.469923 44.81549,0.469699 44.815681,0.46915 44.816094,0.468942 44.816273,0.468697 44.816578,0.468511 44.816905,0.468316 44.817112,0.467959 44.817442,0.467942 44.817494,0.468238 44.81812,0.468306 44.818379,0.468325 44.818736,0.467421 44.81886,0.466104 44.819072,0.46593 44.819087,0.465939 44.820004,0.466225 44.821206,0.466228 44.821279,0.465822 44.822259,0.466288 44.822819,0.466138 44.822812,0.465625 44.822984,0.465441 44.823105,0.465243 44.823293,0.464852 44.823569,0.464658 44.823678,0.464403 44.823731,0.464541 44.823844,0.464339 44.824013,0.464457 44.82428,0.464349 44.824364,0.463552 44.825117,0.463729 44.825224,0.462617 44.825742,0.462337 44.825897,0.462137 44.826067,0.462268 44.826268,0.462037 44.826404,0.461864 44.828358,0.461488 44.82844,0.461362 44.828822,0.461641 44.829568,0.46171 44.829818,0.461727 44.830371,0.461654 44.830652,0.461484 44.831109,0.461159 44.831194,0.460653 44.831219,0.460388 44.831264,0.459978 44.831435,0.459738 44.831507,0.457883 44.831912,0.457358 44.831948,0.45648 44.832151,0.455781 44.832296,0.455708 44.832352,0.455528 44.832607,0.454521 44.833102,0.454219 44.833497,0.453878 44.834125,0.453745 44.834278,0.453479 44.834281,0.45331 44.834213,0.453072 44.834014,0.452879 44.834026,0.452582 44.833948,0.452396 44.833847,0.452035 44.833751,0.451673 44.833778,0.451525 44.833759,0.451083 44.833563,0.450752 44.833541,0.450619 44.833418,0.450085 44.833433,0.449749 44.833345,0.449055 44.833342,0.448528 44.833797,0.448098 44.833896,0.447814 44.833768,0.447581 44.833749,0.446548 44.83404,0.445519 44.834511,0.445055 44.835033,0.444432 44.835153,0.444223 44.835344,0.443804 44.836404,0.443555 44.836729,0.44314 44.8371,0.443852 44.837424,0.444253 44.837663,0.444549 44.837861,0.44498 44.838204,0.445393 44.838626,0.446083 44.839475,0.4463 44.839891,0.446547 44.840466,0.445594 44.840828,0.445528 44.840918,0.445214 44.840867,0.444612 44.840519,0.44422 44.840866,0.444509 44.841044,0.444661 44.841175,0.444745 44.841306,0.444778 44.841498,0.444798 44.842603,0.444756 44.842835,0.44483 44.843014,0.444848 44.84331,0.444818 44.843887,0.444617 44.844688,0.444554 44.844992,0.444511 44.845448,0.444544 44.8457,0.444762 44.846696,0.444842 44.847111,0.445034 44.848266,0.445147 44.849009,0.445297 44.849866,0.445148 44.849872,0.445116 44.851172,0.445073 44.852284,0.445071 44.852716,0.445042 44.853499,0.445012 44.854728,0.444961 44.854992,0.444992 44.855137,0.444965 44.855757,0.444957 44.856309,0.444885 44.857728,0.444887 44.858201,0.44487 44.858454,0.444829 44.860127,0.444807 44.860675,0.444777 44.861929,0.444739 44.862481,0.444716 44.863432,0.443877 44.863508,0.443489 44.863567,0.443 44.863688,0.442411 44.863853,0.442398 44.863943,0.442057 44.864393,0.441807 44.864602,0.441686 44.864801,0.441928 44.865178,0.441974 44.865716,0.441928 44.865939,0.441452 44.866122,0.441384 44.866402,0.441491 44.866578,0.441536 44.866805,0.441823 44.867073,0.441817 44.867329,0.442027 44.868127,0.442022 44.868303,0.441855 44.868437,0.441785 44.869278,0.441718 44.869441,0.441556 44.869514,0.441424 44.869518,0.441289 44.869404,0.44112 44.869471,0.441102 44.869644,0.440955 44.869913,0.440736 44.870051,0.440379 44.87011,0.440225 44.870213,0.440128 44.87035,0.439927 44.870816,0.439803 44.871022,0.439795 44.871247,0.439745 44.871423,0.440094 44.871744,0.439977 44.872341,0.439967 44.872508,0.439811 44.872604,0.439531 44.872659,0.439244 44.872686,0.438982 44.872773,0.438473 44.873005,0.43814 44.873231,0.438021 44.873257,0.437824 44.873373,0.437798 44.873472,0.437655 44.873618,0.437327 44.873746,0.437141 44.87398,0.43694 44.874295,0.436944 44.874423,0.436663 44.874611,0.436435 44.874864,0.43611 44.875598,0.435997 44.87602,0.435927 44.876692,0.435854 44.877121,0.435616 44.87742,0.435153 44.877928,0.435125 44.878096,0.435262 44.87823,0.435454 44.878335,0.435512 44.87847,0.435404 44.878591,0.435044 44.878649,0.434581 44.878687,0.434444 44.878743,0.434284 44.879259,0.433932 44.880288,0.433816 44.880664,0.433593 44.880956,0.433332 44.881177,0.432949 44.881305,0.432627 44.88148,0.432615 44.881795,0.432509 44.882009,0.432365 44.882099,0.432239 44.882318,0.432191 44.882587,0.431977 44.882938,0.431803 44.88315,0.43121 44.884029,0.431092 44.884611,0.431162 44.884886,0.431291 44.885062,0.431628 44.885357,0.431877 44.885489,0.432068 44.88565,0.432295 44.885775,0.432673 44.886025,0.432966 44.886245,0.433296 44.886536,0.433468 44.886629,0.433778 44.886566,0.433897 44.886608,0.434025 44.887032,0.434305 44.887448,0.434456 44.88763,0.434494 44.887878,0.43457 44.888001,0.434577 44.888491,0.434925 44.888749,0.435346 44.889127,0.435743 44.889307,0.436041 44.889634,0.436344 44.890251,0.436802 44.89049,0.437196 44.890581,0.437923 44.891016,0.438872 44.891712,0.439146 44.892054,0.439711 44.892416,0.439845 44.89264,0.4402 44.892777,0.440362 44.892899,0.440371 44.893192,0.440321 44.893394,0.440151 44.893737,0.440163 44.894306,0.440076 44.894549,0.440061 44.895111,0.440178 44.895321,0.440448 44.895491,0.440958 44.895722,0.44122 44.895894,0.441494 44.896027,0.441698 44.896159,0.441945 44.896429,0.442039 44.896619,0.442065 44.897004,0.442138 44.897079,0.442389 44.897099,0.442613 44.896952,0.442849 44.896968,0.443434 44.897095,0.443612 44.897167,0.444212 44.897536,0.444475 44.897714,0.445001 44.898105,0.445345 44.898426,0.445456 44.898636,0.445532 44.898889,0.445525 44.899564,0.445477 44.900034,0.446525 44.900073,0.449149 44.900029,0.452144 44.899488,0.452298 44.898974,0.452419 44.897648,0.452559 44.897072,0.452767 44.896414,0.453013 44.895881,0.453294 44.895613,0.453531 44.895482,0.453825 44.895123,0.454248 44.894795,0.454569 44.894632,0.45523 44.89435,0.456123 44.89408,0.45642 44.894102,0.456744 44.894093,0.457663 44.893955,0.458186 44.893934,0.458791 44.893947,0.459027 44.893915,0.459961 44.893898,0.460467 44.893905,0.460931 44.893798,0.461089 44.894119,0.461178 44.894606,0.461176 44.895023,0.461086 44.895432,0.461004 44.895958,0.460992 44.896155,0.461011 44.896541,0.461941 44.896456,0.462152 44.896426,0.462624 44.896213,0.46303 44.895944,0.463354 44.895782,0.463842 44.895651,0.464586 44.895639,0.465607 44.895266,0.46704 44.8948,0.467039 44.89468,0.467289 44.894296,0.467536 44.894092,0.468173 44.893699,0.468502 44.893512,0.470222 44.892127,0.470365 44.892242,0.471255 44.892368,0.471915 44.892503,0.472487 44.892653,0.473023 44.892737,0.473707 44.892807,0.474329 44.892967,0.474546 44.893047,0.474751 44.892947,0.475272 44.892777,0.475845 44.892677,0.476333 44.892648,0.477639 44.89268,0.478162 44.892655,0.479616 44.892533,0.479641 44.89282,0.480174 44.892892,0.480894 44.892966,0.481005 44.892954,0.482244 44.893036,0.482941 44.89295,0.483223 44.892941,0.483592 44.893018,0.484026 44.893181,0.484426 44.89336,0.48476 44.893479,0.48501 44.89354,0.485966 44.893739,0.486499 44.893827,0.487108 44.893876,0.48733 44.893968,0.487506 44.89444,0.487918 44.894618,0.488746 44.894844,0.489197 44.895011,0.489465 44.895068,0.489848 44.895104,0.48955 44.895314,0.488892 44.895656,0.488376 44.895831,0.488122 44.895942,0.487888 44.896596,0.486693 44.899861,0.487178 44.89973,0.487934 44.899743,0.489292 44.899533,0.490134 44.899415,0.490598 44.899375,0.491688 44.899328,0.492449 44.899278,0.492898 44.899451,0.493361 44.89956,0.493891 44.899543,0.494475 44.899502,0.495226 44.899591,0.496418 44.899783,0.496875 44.899872,0.497125 44.899597,0.497603 44.899107,0.498452 44.898281,0.498763 44.898501,0.498812 44.89841,0.49888 44.89809,0.498861 44.897924,0.498685 44.897658,0.498504 44.897514,0.498413 44.897305,0.498372 44.897098,0.498232 44.89674,0.498236 44.896463,0.498165 44.895847,0.498145 44.895366,0.498074 44.894915,0.498087 44.894674,0.498147 44.894499,0.498419 44.893852,0.498441 44.89355,0.498632 44.8934,0.498909 44.893266,0.499082 44.893123,0.500088 44.892988,0.500086 44.892794,0.500022 44.892663,0.499806 44.892407,0.499751 44.892256,0.499783 44.891927,0.499886 44.891731,0.500137 44.891392,0.500224 44.891186,0.500217 44.89062,0.500175 44.890398,0.50005 44.890026,0.499906 44.889689,0.499508 44.888825,0.499349 44.888344,0.499337 44.887869,0.499393 44.887355,0.4995 44.886787,0.499771 44.885519,0.499857 44.885047,0.500019 44.884305,0.500297 44.883156,0.500509 44.882471,0.500894 44.881659,0.500544 44.881565,0.499242 44.881237,0.498583 44.88092,0.500518 44.880088,0.501726 44.879439,0.502094 44.879283,0.502883 44.878816,0.503172 44.878656,0.503853 44.878243,0.504709 44.878001,0.505512 44.877674,0.50607 44.877423,0.506316 44.877239,0.506599 44.877123,0.506742 44.877034,0.50702 44.876534,0.507204 44.876261,0.50782 44.875884,0.508066 44.875754,0.508193 44.875344,0.508297 44.875141,0.508296 44.874959,0.508351 44.874812,0.508467 44.874725,0.508788 44.87483,0.50908 44.875,0.509231 44.875131,0.509841 44.875838,0.51021 44.876158,0.510696 44.8765,0.511401 44.876708,0.511967 44.877006,0.512302 44.877072,0.512884 44.877282,0.513124 44.877413,0.513465 44.877499,0.513595 44.877404,0.513967 44.877426,0.514473 44.87733,0.514641 44.877144,0.51458 44.876947,0.514654 44.876853,0.514835 44.87678,0.515183 44.876803,0.515338 44.876944,0.515548 44.877055,0.515702 44.877083,0.516471 44.877054,0.516894 44.877244,0.517329 44.877395,0.517521 44.877538,0.517901 44.877869,0.518424 44.878169,0.51881 44.878366,0.51913 44.878507,0.519323 44.878649,0.519438 44.878837,0.519555 44.878933,0.519567 44.879233,0.519601 44.879403,0.519544 44.879562,0.519636 44.879911,0.519788 44.880072,0.520108 44.880237,0.520415 44.880422,0.520486 44.880632,0.521001 44.880909,0.521352 44.881127,0.52153 44.8812,0.521911 44.881259,0.522294 44.881249,0.522515 44.881273,0.522848 44.881254,0.523318 44.881255,0.524024 44.88107,0.52431 44.880964,0.524623 44.880984,0.524806 44.881201,0.525001 44.881149,0.525727 44.880324,0.525988 44.880172,0.526457 44.880058,0.526734 44.879932,0.527435 44.879564,0.527522 44.879419,0.528078 44.879358,0.528437 44.879162,0.528485 44.878706,0.529191 44.877318,0.529543 44.876701,0.529911 44.875048,0.529873 44.87414,0.529745 44.872907,0.529803 44.872804,0.529996 44.872248,0.531558 44.869117,0.531868 44.868342,0.532142 44.867726,0.532304 44.867604,0.532409 44.867468,0.532454 44.867329,0.532334 44.866687,0.53234 44.866599,0.532569 44.865908,0.532689 44.865824,0.53167 44.864948,0.529967 44.863467,0.529898 44.863421,0.529824 44.863157,0.529706 44.862178,0.529584 44.861745,0.529196 44.861329,0.528943 44.861259,0.528356 44.860854,0.528099 44.860373,0.527671 44.859945,0.527266 44.859392,0.527085 44.859168,0.527103 44.85901,0.527045 44.858693,0.527133 44.858483,0.52751 44.858252,0.527553 44.858019,0.52762 44.857458,0.528003 44.856375,0.528937 44.85526,0.529089 44.855098,0.529049 44.854735,0.529263 44.853608,0.52815 44.848961,0.527927 44.846394,0.527899 44.843724,0.527036 44.843511,0.524616 44.842771,0.523148 44.842254,0.521853 44.841729,0.521233 44.841459,0.522992 44.839059,0.523164 44.839173,0.523556 44.839484,0.523871 44.839772,0.524464 44.838894,0.525107 44.837963,0.525224 44.837979,0.525734 44.836703,0.525948 44.836789,0.5263 44.836848,0.526823 44.83696,0.527202 44.83701,0.527459 44.837101,0.527573 44.837184,0.527754 44.83724,0.52825 44.837303,0.528822 44.837517,0.529361 44.837575,0.529516 44.837614,0.530179 44.837948,0.531446 44.838483,0.531842 44.838683,0.532148 44.838863,0.532439 44.83897,0.533005 44.838753,0.53393 44.83844,0.534268 44.838278,0.534486 44.838053,0.5349 44.837793,0.535037 44.837482,0.534941 44.837299,0.534404 44.837193,0.534417 44.836124,0.534459 44.836026,0.534692 44.835732,0.535261 44.835567,0.53589 44.835518,0.536338 44.835345,0.53673 44.834947,0.536928 44.834725,0.536962 44.833691,0.537098 44.833379,0.53714 44.833109,0.537116 44.832965,0.536971 44.832763,0.537264 44.832383,0.538171 44.831461,0.538556 44.831288,0.539423 44.831622,0.539824 44.831755,0.540659 44.831742,0.541409 44.831432,0.542172 44.831053,0.542431 44.830687,0.542438 44.830073,0.542863 44.828654,0.542813 44.827667,0.542665 44.827343,0.54266 44.826875,0.542869 44.826653,0.543103 44.826442,0.543656 44.826154,0.544175 44.826067,0.544697 44.826036,0.545476 44.826189,0.545368 44.825857,0.545069 44.825268,0.539333 44.82243,0.536906 44.822208,0.535877 44.822106,0.528335 44.821051,0.525684 44.820585,0.525174 44.820548,0.525029 44.820474,0.525091 44.820383,0.525125 44.819966,0.525082 44.818967,0.524957 44.818408,0.524856 44.81832,0.52485 44.817811,0.524689 44.81636,0.524577 44.816197,0.524473 44.815192,0.524632 44.814787,0.52478 44.814499,0.524517 44.814428,0.523635 44.814233,0.52342 44.814246,0.523608 44.813641,0.52402 44.811201,0.523824 44.809666,0.523468 44.808362,0.523106 44.806487,0.522814 44.806505,0.522567 44.805569,0.52243 44.804819,0.521476 44.804488,0.521212 44.804415,0.52103 44.804403,0.520903 44.804413,0.520238 44.804543,0.517097 44.805118,0.516744 44.805228,0.51592 44.805626,0.515743 44.805684,0.515316 44.805777,0.514958 44.805811,0.514474 44.805775,0.514266 44.805689,0.514479 44.805459,0.515622 44.804175)))', 4326))
  AND (tags->'type') = 'route'
  AND (tags->'route') IN ('hiking','foot','running','walking','fitness_trail','horse','inline_skates');

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

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

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