Symfony Profiler

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

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

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

"START TRANSACTION"

"START TRANSACTION";

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-14 05:31:19', NULL, NULL);

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

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

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

SELECT
  1

SELECT 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
  1

SELECT 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
  information_schema.tables
WHERE
  table_schema = ?
  AND table_name = ?

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_history';

SELECT
  COUNT(*)
FROM
  osm_object_meta
WHERE
  osm_type = 'relation'
  AND geom IS NOT NULL
  AND (tags -> 'admin_level') = '8'
  AND (tags -> 'boundary') = 'administrative'
  AND (tags -> 'ref:INSEE') IS NOT NULL

SELECT COUNT(*) FROM osm_object_meta WHERE osm_type = 'relation'
                  AND geom IS NOT NULL
                  AND (tags->'admin_level') = '8'
                  AND (tags->'boundary') = 'administrative'
                  AND (tags->'ref:INSEE') IS NOT NULL;

INSERT INTO osm_object_meta (
  osm_type, osm_id, geom, tags, version,
  osm_timestamp, changeset, osm_user,
  uid
)
SELECT
  'relation',
  latest.osm_id,
  latest.geom,
  latest.tags,
  latest.version,
  to_char(
    latest.valid_from AT TIME ZONE 'UTC',
    'YYYY-MM-DD"T"HH24:MI:SS"Z"'
  ),
  latest.changeset,
  latest.osm_user,
  latest.uid
FROM
  (
    SELECT
      DISTINCT ON (h.osm_id) h.osm_id,
      h.geom,
      h.tags,
      h.version,
      h.valid_from,
      h.changeset,
      h.osm_user,
      h.uid
    FROM
      osm_object_history h
    WHERE
      h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags -> 'boundary') = 'administrative'
      AND (h.tags -> 'admin_level') = '8'
      AND (h.tags -> 'ref:INSEE') IS NOT NULL
    ORDER BY
      h.osm_id,
      h.version DESC,
      h.valid_from DESC
  ) AS latest
WHERE
  NOT EXISTS (
    SELECT
      1
    FROM
      osm_object_meta m
    WHERE
      m.osm_type = 'relation'
      AND m.osm_id = latest.osm_id
  )

INSERT INTO osm_object_meta (
    osm_type, osm_id, geom, tags, version, osm_timestamp, changeset, osm_user, uid
)
SELECT
    'relation',
    latest.osm_id,
    latest.geom,
    latest.tags,
    latest.version,
    to_char(latest.valid_from AT TIME ZONE 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"'),
    latest.changeset,
    latest.osm_user,
    latest.uid
FROM (
    SELECT DISTINCT ON (h.osm_id)
        h.osm_id,
        h.geom,
        h.tags,
        h.version,
        h.valid_from,
        h.changeset,
        h.osm_user,
        h.uid
    FROM osm_object_history h
    WHERE h.osm_type = 'relation'
      AND h.visible = true
      AND h.geom IS NOT NULL
      AND (h.tags->'boundary') = 'administrative'
      AND (h.tags->'admin_level') = '8'
      AND (h.tags->'ref:INSEE') IS NOT NULL
    ORDER BY h.osm_id, h.version DESC, h.valid_from DESC
) AS latest
WHERE NOT EXISTS (
    SELECT 1 FROM osm_object_meta m
    WHERE m.osm_type = 'relation' AND m.osm_id = latest.osm_id
);

SELECT
  ST_AsText(
    ST_Multi(geom)
  ) 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'68066'') = ?
  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 = ?
  AND table_name = ?

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_history';

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

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

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

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

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(((7.32934 48.114169,7.33001 48.115834,7.329912 48.115947,7.327731 48.116355,7.32743 48.116675,7.327938 48.116983,7.328157 48.117075,7.328712 48.117216,7.329848 48.117424,7.330357 48.117558,7.330556 48.117693,7.330722 48.118795,7.330953 48.119102,7.331322 48.119446,7.331696 48.119836,7.331889 48.120458,7.33178 48.120733,7.331806 48.121002,7.332787 48.121028,7.335874 48.120565,7.33611 48.121257,7.336183 48.121597,7.33664 48.122414,7.336732 48.122644,7.336973 48.122777,7.337415 48.122907,7.337736 48.122976,7.339077 48.123153,7.339417 48.123173,7.340697 48.123292,7.340732 48.123286,7.34201 48.1234,7.342025 48.124441,7.3421 48.124527,7.344005 48.124762,7.344113 48.12517,7.344152 48.125238,7.344626 48.125206,7.344947 48.125208,7.345692 48.125315,7.347211 48.125557,7.347504 48.125647,7.347733 48.125817,7.347907 48.126145,7.34799 48.12617,7.34846 48.126125,7.348768 48.126221,7.348672 48.125925,7.348662 48.125785,7.348724 48.125671,7.348557 48.124896,7.348543 48.121375,7.349218 48.120143,7.349337 48.120024,7.349479 48.119691,7.349777 48.119303,7.34985 48.119274,7.350411 48.119287,7.350342 48.119021,7.350198 48.118217,7.350168 48.117949,7.350018 48.117237,7.350451 48.117252,7.350844 48.117207,7.351947 48.117165,7.352248 48.117144,7.352952 48.117131,7.353584 48.117026,7.354073 48.117033,7.354206 48.117072,7.354198 48.117661,7.355195 48.117605,7.355229 48.117212,7.356081 48.117076,7.356914 48.116976,7.357749 48.116887,7.359119 48.116756,7.359219 48.116799,7.359318 48.117171,7.364161 48.116691,7.364697 48.116662,7.364653 48.116395,7.365837 48.116295,7.365998 48.116861,7.366113 48.116895,7.368965 48.116981,7.369096 48.11693,7.369842 48.114991,7.372265 48.115206,7.372537 48.115026,7.374626 48.114934,7.374957 48.115417,7.375012 48.115691,7.376443 48.115668,7.376992 48.11578,7.377341 48.116513,7.377473 48.116665,7.377511 48.116889,7.377636 48.117249,7.377726 48.117396,7.37783 48.117691,7.377997 48.117903,7.378271 48.118161,7.378345 48.118435,7.378417 48.11857,7.378581 48.118682,7.37909 48.118747,7.379338 48.118813,7.380549 48.119336,7.381069 48.11949,7.381468 48.119525,7.381785 48.119462,7.381892 48.119412,7.382214 48.120503,7.382221 48.1207,7.382386 48.120985,7.382458 48.121353,7.382546 48.121441,7.382856 48.121443,7.38398 48.121551,7.384058 48.121763,7.384542 48.122372,7.384962 48.123042,7.385127 48.123279,7.385255 48.123388,7.385647 48.123363,7.385711 48.123393,7.385697 48.123578,7.385803 48.123835,7.385933 48.123967,7.386106 48.123915,7.386384 48.123942,7.386674 48.124047,7.386917 48.124228,7.38724 48.124316,7.387866 48.124521,7.388029 48.124554,7.388354 48.124771,7.388676 48.124872,7.389023 48.125066,7.389156 48.125175,7.389167 48.125276,7.388763 48.125433,7.388696 48.125587,7.389106 48.126172,7.38951 48.126724,7.389562 48.127058,7.389616 48.127245,7.389945 48.127543,7.390179 48.127948,7.39018 48.128163,7.389897 48.128424,7.389361 48.128684,7.389123 48.12875,7.388842 48.128739,7.388768 48.128833,7.388844 48.129288,7.388952 48.129441,7.388985 48.129659,7.389125 48.130022,7.389391 48.1308,7.389422 48.130972,7.389402 48.131407,7.389456 48.131591,7.389425 48.131878,7.389435 48.132179,7.389536 48.132324,7.38978 48.132369,7.39022 48.132549,7.390384 48.132727,7.390667 48.132877,7.390827 48.133037,7.390839 48.133164,7.390712 48.133444,7.390971 48.13383,7.389947 48.134369,7.390027 48.134502,7.390901 48.135185,7.391765 48.135778,7.392414 48.135525,7.392552 48.135564,7.392918 48.135864,7.392937 48.136763,7.392763 48.137762,7.39274 48.138213,7.392029 48.138515,7.390445 48.138853,7.390383 48.138901,7.391065 48.139749,7.390566 48.140197,7.390416 48.140313,7.388555 48.139894,7.385031 48.139943,7.385585 48.142083,7.385764 48.142321,7.386179 48.142811,7.38627 48.143048,7.386349 48.143449,7.386517 48.144583,7.386601 48.144898,7.38703 48.14593,7.387117 48.146259,7.387497 48.147301,7.387647 48.147605,7.387967 48.14808,7.38823 48.148508,7.388741 48.149371,7.388848 48.149602,7.389254 48.150145,7.389421 48.150403,7.389785 48.151031,7.390124 48.151667,7.390308 48.151975,7.390663 48.152999,7.390797 48.153347,7.390938 48.153549,7.391138 48.153448,7.393007 48.152396,7.396162 48.154745,7.399333 48.154138,7.399343 48.154021,7.399437 48.153946,7.399846 48.15381,7.400213 48.154419,7.40021 48.154813,7.400403 48.155198,7.40054 48.155398,7.400891 48.155754,7.401017 48.155935,7.401967 48.156523,7.40205 48.156807,7.40183 48.157042,7.401648 48.157301,7.401711 48.157948,7.401791 48.158195,7.402033 48.158385,7.402058 48.158647,7.402151 48.159018,7.402413 48.159394,7.402456 48.159668,7.402442 48.160106,7.402709 48.160545,7.40272 48.160845,7.40244 48.161143,7.400995 48.160893,7.398726 48.160447,7.397373 48.160369,7.396579 48.160415,7.395535 48.160549,7.395413 48.160535,7.39373 48.160494,7.393114 48.160508,7.39186 48.160552,7.390653 48.160604,7.389455 48.160746,7.389651 48.161158,7.390023 48.162112,7.389811 48.162353,7.388824 48.163296,7.387507 48.164299,7.385682 48.164918,7.384516 48.165512,7.384681 48.167878,7.385937 48.168581,7.386504 48.168538,7.388069 48.169541,7.388449 48.1699,7.389241 48.170251,7.389506 48.170866,7.390119 48.172191,7.390377 48.173119,7.390292 48.173411,7.39011 48.173698,7.389926 48.174064,7.389948 48.174301,7.390044 48.174509,7.390236 48.174764,7.390568 48.174994,7.391157 48.175294,7.391862 48.175614,7.392401 48.175953,7.393109 48.176687,7.393283 48.176754,7.394326 48.177098,7.395261 48.177144,7.395466 48.177134,7.395906 48.177041,7.396465 48.17683,7.396866 48.176724,7.397381 48.176639,7.397771 48.176598,7.399121 48.176427,7.401872 48.176057,7.402798 48.175943,7.402835 48.175695,7.403264 48.175165,7.404409 48.175241,7.404866 48.175211,7.405198 48.17525,7.406771 48.175554,7.407539 48.17546,7.413175 48.17486,7.414223 48.174545,7.41591 48.173886,7.41642 48.173593,7.416784 48.173172,7.416914 48.173121,7.417249 48.173107,7.417511 48.173726,7.417645 48.173721,7.42035 48.173277,7.420548 48.173215,7.421023 48.173124,7.422065 48.172763,7.42546 48.171978,7.426109 48.171871,7.427046 48.171651,7.427728 48.171403,7.427883 48.171559,7.428447 48.171989,7.429052 48.172505,7.429232 48.172676,7.429445 48.17266,7.429655 48.172576,7.429943 48.172601,7.430562 48.17248,7.430798 48.172515,7.43098 48.17273,7.430866 48.172896,7.43049 48.173204,7.430422 48.173289,7.430346 48.17351,7.430248 48.173556,7.42998 48.173591,7.429233 48.173621,7.429083 48.173745,7.428749 48.173889,7.428497 48.17408,7.428378 48.174293,7.428362 48.174617,7.428612 48.174801,7.429282 48.175136,7.429476 48.175302,7.429533 48.175518,7.429446 48.175673,7.429231 48.175776,7.428948 48.175827,7.428559 48.175749,7.428133 48.17555,7.427782 48.175429,7.427573 48.175604,7.427335 48.17585,7.4273 48.176031,7.427359 48.176226,7.427486 48.176406,7.428141 48.176771,7.428432 48.176969,7.428078 48.177173,7.427862 48.177257,7.427356 48.17753,7.427224 48.17771,7.427416 48.177858,7.427752 48.178018,7.428112 48.178061,7.428462 48.17793,7.428883 48.177522,7.429022 48.177441,7.429449 48.177557,7.429677 48.177541,7.429883 48.177657,7.429886 48.177798,7.429789 48.17802,7.429546 48.178303,7.429317 48.178533,7.429183 48.178733,7.429242 48.17904,7.428926 48.179104,7.428618 48.179138,7.4282 48.179219,7.428082 48.179301,7.428059 48.179436,7.428137 48.179561,7.428372 48.179652,7.428806 48.17965,7.429024 48.179615,7.429501 48.179429,7.430192 48.179889,7.430266 48.180058,7.43025 48.180219,7.429787 48.180583,7.429653 48.18076,7.429639 48.180959,7.429742 48.18109,7.430046 48.181374,7.430229 48.181663,7.430268 48.181915,7.431037 48.181925,7.434602 48.180987,7.435074 48.180945,7.435647 48.181272,7.436102 48.181858,7.436454 48.181907,7.43665 48.182254,7.43684 48.182301,7.437291 48.18221,7.437951 48.182035,7.438102 48.182077,7.438466 48.182079,7.440018 48.181907,7.441359 48.181387,7.442693 48.181138,7.442813 48.18101,7.443223 48.180705,7.443297 48.18047,7.443393 48.180345,7.443563 48.180226,7.443958 48.179688,7.44401 48.178441,7.444278 48.178354,7.444694 48.178026,7.444874 48.177942,7.445264 48.177863,7.445469 48.177756,7.44551 48.177671,7.446284 48.177761,7.446427 48.177523,7.446376 48.177328,7.446444 48.177117,7.446757 48.176946,7.446933 48.176908,7.446966 48.176785,7.446844 48.176683,7.446509 48.17651,7.446344 48.176227,7.446119 48.176076,7.446039 48.175963,7.445931 48.175423,7.445934 48.17525,7.446119 48.174886,7.446282 48.174475,7.446481 48.174257,7.446625 48.173904,7.446873 48.173535,7.446927 48.173315,7.447049 48.173245,7.447417 48.173261,7.447689 48.173245,7.447941 48.173133,7.447939 48.173034,7.447786 48.172785,7.447633 48.172616,7.447401 48.172576,7.447142 48.17269,7.446947 48.172718,7.446752 48.172694,7.446569 48.172526,7.446529 48.172334,7.446327 48.172092,7.446345 48.171941,7.446512 48.171845,7.447161 48.171644,7.447531 48.171414,7.447653 48.17131,7.447401 48.171044,7.447463 48.170917,7.447726 48.17073,7.448161 48.170574,7.448823 48.170069,7.449103 48.169307,7.449291 48.168999,7.449385 48.168767,7.449402 48.168627,7.449383 48.168181,7.44928 48.167795,7.449185 48.167651,7.449174 48.167539,7.449349 48.167418,7.449912 48.167231,7.450287 48.167064,7.450566 48.16684,7.451092 48.166365,7.451242 48.166187,7.451268 48.166078,7.450964 48.165625,7.450873 48.165454,7.450839 48.165158,7.451064 48.164678,7.450885 48.164184,7.450669 48.164082,7.450489 48.163825,7.450203 48.163653,7.449905 48.163338,7.449781 48.163043,7.45047 48.162879,7.45398 48.162276,7.4546 48.162143,7.453922 48.160397,7.455696 48.160014,7.459034 48.159289,7.460731 48.158927,7.46296 48.158447,7.463593 48.158362,7.463707 48.156989,7.468385 48.156725,7.468078 48.156273,7.467636 48.155488,7.467198 48.154942,7.466975 48.154602,7.466695 48.154001,7.466587 48.153648,7.466584 48.153323,7.466496 48.152995,7.466645 48.152904,7.467167 48.152794,7.468127 48.152555,7.468184 48.152482,7.468137 48.152229,7.467865 48.151769,7.467812 48.151326,7.467609 48.151062,7.467628 48.150745,7.467538 48.150433,7.467236 48.150099,7.467083 48.149842,7.467037 48.149584,7.467165 48.149372,7.467158 48.149094,7.467316 48.148716,7.467346 48.148433,7.467472 48.148034,7.467442 48.14772,7.46712 48.147193,7.467174 48.147056,7.469252 48.146653,7.468649 48.145264,7.468215 48.145142,7.467636 48.144942,7.46741 48.144739,7.467316 48.144355,7.467207 48.144197,7.467023 48.14403,7.466963 48.143794,7.467031 48.14353,7.467321 48.143066,7.467175 48.142722,7.466182 48.142526,7.465581 48.142339,7.465176 48.142137,7.465004 48.142098,7.464804 48.142103,7.464668 48.14215,7.464188 48.142225,7.463841 48.142219,7.463661 48.142156,7.463476 48.141993,7.463172 48.141789,7.462857 48.141681,7.462754 48.141573,7.462608 48.141285,7.462482 48.14072,7.46233 48.140395,7.462342 48.139725,7.462171 48.139323,7.462013 48.139054,7.46169 48.138787,7.461556 48.138602,7.461376 48.138186,7.461333 48.1379,7.461632 48.137649,7.462151 48.137414,7.462084 48.137316,7.461839 48.137089,7.46155 48.136614,7.461405 48.136282,7.461176 48.136041,7.460773 48.135358,7.460151 48.134923,7.459554 48.13436,7.458925 48.133861,7.45832 48.133588,7.457836 48.133434,7.456765 48.133368,7.453523 48.13409,7.453138 48.134217,7.448515 48.135466,7.449509 48.137454,7.447295 48.138098,7.447071 48.13813,7.446917 48.138104,7.445609 48.138416,7.44152 48.139369,7.441311 48.139428,7.439694 48.140519,7.438293 48.13944,7.436565 48.140071,7.437541 48.142326,7.436888 48.14252,7.436804 48.142443,7.436574 48.142478,7.434996 48.143059,7.43461 48.142277,7.434002 48.140908,7.433418 48.13973,7.432284 48.139985,7.432129 48.139927,7.431681 48.139982,7.431128 48.140111,7.430939 48.140139,7.430909 48.139957,7.430812 48.139741,7.430868 48.139285,7.430805 48.139165,7.430633 48.139023,7.430223 48.138762,7.429988 48.138588,7.429798 48.1384,7.429698 48.138172,7.429721 48.137718,7.429639 48.137389,7.42945 48.137135,7.429421 48.136455,7.429348 48.13628,7.429074 48.136058,7.428785 48.135951,7.428183 48.135773,7.427832 48.135635,7.427321 48.135481,7.426662 48.135263,7.426236 48.135082,7.426018 48.134951,7.425807 48.1347,7.425794 48.134465,7.425864 48.134212,7.426286 48.13374,7.426422 48.133008,7.426274 48.132639,7.426386 48.13226,7.426418 48.131875,7.42539 48.131883,7.423495 48.131664,7.423123 48.131723,7.422447 48.131787,7.420822 48.131908,7.419167 48.132017,7.416256 48.132326,7.414164 48.132498,7.413816 48.132032,7.41134 48.127994,7.409704 48.125698,7.408536 48.123692,7.405952 48.124198,7.404663 48.122012,7.403706 48.120365,7.402953 48.119092,7.401139 48.115968,7.400714 48.115263,7.40337 48.114778,7.402985 48.114102,7.402714 48.113663,7.402069 48.112571,7.401597 48.11266,7.400569 48.112875,7.399422 48.1131,7.39881 48.112276,7.398617 48.111994,7.398206 48.111459,7.396962 48.109721,7.397718 48.109363,7.397925 48.109048,7.398331 48.108475,7.398563 48.108123,7.398272 48.107402,7.397872 48.106467,7.397777 48.106219,7.39702 48.104513,7.396687 48.103729,7.396515 48.103274,7.395936 48.101983,7.395881 48.101935,7.395911 48.101239,7.395925 48.100519,7.39561 48.100525,7.395639 48.100159,7.395618 48.09922,7.395654 48.097896,7.395738 48.097092,7.39577 48.096557,7.395916 48.096242,7.395607 48.096188,7.394933 48.096041,7.394804 48.095324,7.394715 48.094515,7.397496 48.094536,7.39774 48.094527,7.397095 48.093611,7.396318 48.092548,7.396114 48.09223,7.395727 48.091691,7.395155 48.090863,7.392649 48.091176,7.392235 48.090346,7.391784 48.089424,7.391347 48.088504,7.390771 48.087322,7.390605 48.087032,7.389326 48.088362,7.388517 48.089383,7.388226 48.089548,7.387929 48.089492,7.388083 48.089227,7.388096 48.089141,7.388006 48.089026,7.387439 48.088721,7.387171 48.08838,7.387302 48.08806,7.387326 48.08785,7.387406 48.087747,7.387812 48.087664,7.388458 48.087289,7.388338 48.086813,7.389103 48.086653,7.389199 48.086663,7.389279 48.086166,7.388197 48.086434,7.387854 48.086546,7.387532 48.086567,7.387003 48.086401,7.38682 48.086092,7.386559 48.085137,7.38626 48.08479,7.385769 48.084845,7.385892 48.084363,7.385646 48.084249,7.384849 48.084133,7.384918 48.083817,7.385066 48.083266,7.385195 48.082922,7.385405 48.082598,7.385548 48.082299,7.385636 48.082056,7.385642 48.081641,7.385786 48.080984,7.385812 48.080677,7.385899 48.08017,7.385936 48.079129,7.385963 48.078837,7.386042 48.078541,7.386128 48.078079,7.386272 48.077644,7.386402 48.076979,7.386406 48.076458,7.386109 48.07627,7.385998 48.075996,7.385983 48.075822,7.386099 48.074504,7.386165 48.074368,7.386451 48.074019,7.386654 48.073655,7.386767 48.0733,7.38723 48.07031,7.38736 48.069442,7.387402 48.069074,7.387576 48.068322,7.387607 48.06813,7.387809 48.06808,7.39034 48.067262,7.392042 48.066743,7.392746 48.066518,7.39304 48.06639,7.393568 48.066201,7.39388 48.066014,7.393936 48.065865,7.394213 48.065731,7.394413 48.065579,7.394509 48.065423,7.394807 48.064835,7.39543 48.063403,7.395631 48.062922,7.396072 48.061941,7.396402 48.061123,7.396738 48.060351,7.397565 48.058404,7.398268 48.058345,7.399211 48.058319,7.399913 48.058333,7.400331 48.057736,7.401002 48.05703,7.401302 48.056658,7.40251 48.055604,7.402479 48.054926,7.40249 48.052406,7.402117 48.051886,7.401102 48.051054,7.400257 48.051386,7.398654 48.050779,7.397686 48.050506,7.395791 48.050067,7.394207 48.049755,7.393855 48.049574,7.392734 48.048622,7.39148 48.048161,7.390956 48.047598,7.390461 48.046628,7.38986 48.045978,7.389067 48.045437,7.387092 48.044983,7.386902 48.044542,7.38451 48.044561,7.383389 48.043158,7.381612 48.043612,7.380403 48.043992,7.380711 48.04457,7.3799 48.044872,7.378402 48.044895,7.377372 48.044987,7.377251 48.044022,7.376911 48.0435,7.376615 48.04328,7.376456 48.042919,7.376333 48.042819,7.375819 48.043061,7.375468 48.043409,7.374673 48.042713,7.374377 48.04286,7.37378 48.042396,7.373579 48.042421,7.372039 48.042017,7.371259 48.041591,7.370594 48.04133,7.370091 48.041148,7.369457 48.040682,7.368749 48.04086,7.368858 48.041188,7.364455 48.04171,7.362644 48.041324,7.362376 48.040949,7.361181 48.041175,7.359204 48.041575,7.357838 48.042039,7.355615 48.042675,7.355728 48.043166,7.355603 48.043261,7.354938 48.043335,7.354272 48.042688,7.354071 48.042696,7.353305 48.042937,7.352776 48.043059,7.354487 48.044798,7.35454 48.045033,7.354627 48.045256,7.354536 48.046028,7.354052 48.046032,7.353601 48.04623,7.35356 48.046503,7.353172 48.046654,7.353344 48.047053,7.353357 48.047187,7.352918 48.047522,7.352522 48.047583,7.352312 48.047503,7.351877 48.04716,7.351612 48.047217,7.351647 48.047576,7.351196 48.047776,7.351074 48.047915,7.351288 48.048042,7.351428 48.048802,7.351755 48.049419,7.352249 48.049667,7.352288 48.050071,7.352535 48.050556,7.352223 48.050795,7.352244 48.051019,7.352743 48.051314,7.352764 48.051538,7.352834 48.05158,7.352852 48.051759,7.352596 48.051906,7.352538 48.051998,7.35282 48.052121,7.352899 48.052253,7.352774 48.052348,7.35205 48.052514,7.351968 48.053058,7.351852 48.053244,7.351525 48.053348,7.351455 48.053543,7.351099 48.053739,7.35129 48.054059,7.351194 48.054155,7.350937 48.054205,7.35101 48.053951,7.350357 48.053807,7.350183 48.053801,7.348531 48.054055,7.348424 48.053771,7.34751 48.053938,7.347882 48.054721,7.346067 48.054142,7.346359 48.053834,7.345436 48.053741,7.344509 48.053694,7.344176 48.053462,7.342752 48.05393,7.342503 48.054036,7.34168 48.054184,7.340955 48.054285,7.33959 48.054498,7.338435 48.054603,7.338328 48.054651,7.337877 48.054741,7.337011 48.054861,7.336345 48.054941,7.335552 48.055073,7.335022 48.055117,7.334796 48.055115,7.334613 48.055158,7.333808 48.055448,7.332668 48.055897,7.33176 48.056275,7.331351 48.056427,7.329073 48.057395,7.3285 48.057621,7.327991 48.05785,7.32742 48.058087,7.326882 48.058334,7.325785 48.05879,7.325025 48.059118,7.323516 48.059734,7.322825 48.059975,7.323142 48.060348,7.323832 48.06113,7.324141 48.061552,7.324696 48.06244,7.3262 48.064293,7.325784 48.064445,7.325198 48.064619,7.324172 48.064892,7.322238 48.065382,7.321086 48.065601,7.320003 48.065817,7.320528 48.066008,7.320638 48.066634,7.32014 48.066701,7.320409 48.067576,7.32034 48.067585,7.320412 48.068032,7.320382 48.068116,7.320452 48.068337,7.320471 48.068732,7.320515 48.069011,7.320651 48.0696,7.320781 48.069977,7.315517 48.070477,7.315669 48.071068,7.316021 48.071819,7.316334 48.072521,7.316813 48.073885,7.317149 48.074733,7.317315 48.075123,7.317605 48.075656,7.317755 48.076045,7.318095 48.077375,7.318286 48.077339,7.320541 48.077108,7.321033 48.077037,7.321529 48.076999,7.322145 48.076906,7.322344 48.07689,7.323364 48.079715,7.323718 48.080761,7.324418 48.082379,7.324502 48.083068,7.32459 48.083549,7.324677 48.084123,7.324671 48.08444,7.3247 48.08463,7.32484 48.084955,7.325192 48.086306,7.325461 48.086291,7.325924 48.086301,7.325977 48.086872,7.324846 48.086969,7.324837 48.087042,7.325002 48.087939,7.326223 48.087629,7.326625 48.087539,7.326706 48.087608,7.327075 48.088181,7.327302 48.088566,7.327289 48.08873,7.327272 48.089584,7.326966 48.089756,7.326918 48.090577,7.326805 48.091707,7.326847 48.092155,7.327037 48.092673,7.327193 48.093582,7.327392 48.094326,7.327552 48.094588,7.32774 48.095153,7.327917 48.095135,7.328133 48.095575,7.328275 48.095565,7.328378 48.096234,7.328533 48.096627,7.328764 48.096984,7.32904 48.097866,7.329114 48.098343,7.329288 48.099164,7.329326 48.09929,7.328464 48.099418,7.328694 48.100276,7.329316 48.102463,7.327994 48.102748,7.328523 48.103952,7.328429 48.104019,7.328825 48.105193,7.328984 48.105583,7.328899 48.105682,7.329193 48.105971,7.32934 48.106429,7.329527 48.106707,7.329594 48.106869,7.329663 48.107308,7.329571 48.107704,7.329399 48.108664,7.329219 48.109619,7.329106 48.110151,7.329135 48.11021,7.32925 48.111547,7.329295 48.11178,7.32945 48.111908,7.329651 48.112248,7.329861 48.11271,7.329611 48.112833,7.329799 48.113507,7.329213 48.113544,7.32924 48.113813,7.32934 48.114169)))', 4326))
  AND (tags->'type') = 'route'
  AND (tags->'route') IN ('hiking','foot','running','walking','fitness_trail','horse','inline_skates');