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 = '13041' 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 = 27501 AND c0_.name IN ('mobility_count', 'mobility_completion') ORDER BY c0_.date ASC, c0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.measure AS measure_3,
  t0.date AS date_4,
  t0.stats_id AS stats_id_5
FROM
  city_follow_up t0
WHERE
  t0.stats_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = 27501;

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

"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\":\"mobility\",\"tagKey\":null,\"tagValue\":null,\"main_tags\":[],\"places_count\":0,\"filtered_count\":0,\"filtered_main_tags\":[]}', '2026-07-14 05:05:52', 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 = 27501;

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 = 27501 AND z0_.theme = 'mobility' 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'13041'') = ?
  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'13041'') = ?
      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 = '13041';

SELECT
  osm_type,
  osm_id :: text AS osm_id,
  ST_Y(
    ST_Centroid(m.geom)
  ) AS lat,
  ST_X(
    ST_Centroid(m.geom)
  ) AS lon,
  tags :: jsonb AS tags_json,
  version,
  osm_timestamp,
  changeset,
  osm_user,
  uid :: bigint AS uid,
  ST_AsGeoJSON(
    ST_Force2D(m.geom),
    6,
    0
  ) AS geom_geojson,
  COALESCE(
    ST_Length(
      ST_Intersection(
        ST_MakeValid(m.geom),
        bufc.buf
      ):: geography
    ),
    0
  ) AS length_m,
  CASE WHEN (tags -> 'highway') = 'proposed'
  AND exist(tags, 'proposed')
  AND (tags -> 'proposed') = 'cycleway' THEN
    'proposed_cycleway'
  WHEN (tags -> 'highway') = 'cycleway' THEN
    'separated'
  WHEN (tags -> 'highway') = 'busway' THEN
    'separated'
  WHEN (tags -> 'cycleway:both') IN (
    'track', 'opposite_track', 'separate'
  )
  AND exist(tags, 'highway')
  AND (tags -> 'highway') IS NOT NULL
  AND (tags -> 'highway') NOT IN ('cycleway', 'busway') THEN
    'separated'
  WHEN EXISTS (
    SELECT
      1
    FROM
      unnest(
        akeys(tags)
      ) k
    WHERE
      k = 'cycleway'
      OR k LIKE 'cycleway:%'
  )
  AND exist(tags, 'highway')
  AND (tags -> 'highway') IS NOT NULL
  AND (tags -> 'highway') NOT IN ('cycleway', 'busway') THEN
    'lane'
  WHEN (
    exist(tags, 'bicycle')
    AND (tags -> 'bicycle') IS NOT NULL
    AND (tags -> 'bicycle') <> 'no'
  )
  AND exist(tags, 'highway')
  AND (tags -> 'highway') IS NOT NULL
  AND (tags -> 'highway') NOT IN ('cycleway', 'busway')
  AND NOT (
    EXISTS (
      SELECT
        1
      FROM
        unnest(
          akeys(tags)
        ) k
      WHERE
        k = 'cycleway'
        OR k LIKE 'cycleway:%'
    )
  ) THEN
    'designated'
  ELSE
    NULL
  END AS cycleway_category
FROM
  osm_object_meta m CROSS
  JOIN (
    SELECT
      ST_MakeValid(
        ST_SetSRID(
          ST_GeomFromText(?),
          4326
        )
      ) AS poly
  ) z CROSS
  JOIN LATERAL (
    SELECT
      ST_Buffer(z.poly :: geography, ?):: geometry AS buf
  ) bufc
WHERE
  m.geom IS NOT NULL
  AND m.osm_type IN ('way', 'relation')
  AND ST_Intersects(m.geom, bufc.buf)
  AND (
    (tags -> 'highway') = 'proposed'
    AND exist(tags, 'proposed')
    AND (tags -> 'proposed') = 'cycleway'
    OR (tags -> 'highway') IN ('cycleway', 'busway')
    OR (
      EXISTS (
        SELECT
          1
        FROM
          unnest(
            akeys(tags)
          ) k
        WHERE
          k = 'cycleway'
          OR k LIKE 'cycleway:%'
      )
      AND exist(tags, 'highway')
      AND (tags -> 'highway') IS NOT NULL
      AND (tags -> 'highway') NOT IN ('cycleway', 'busway')
    )
    OR (
      (
        exist(tags, 'bicycle')
        AND (tags -> 'bicycle') IS NOT NULL
        AND (tags -> 'bicycle') <> 'no'
      )
      AND exist(tags, 'highway')
      AND (tags -> 'highway') IS NOT NULL
      AND (tags -> 'highway') NOT IN ('cycleway', 'busway')
    )
  )

SELECT osm_type, osm_id::text AS osm_id,
       ST_Y(ST_Centroid(m.geom)) AS lat, ST_X(ST_Centroid(m.geom)) AS lon,
       tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,
       ST_AsGeoJSON(ST_Force2D(m.geom), 6, 0) AS geom_geojson,
       COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), bufc.buf)::geography), 0) AS length_m,
       CASE
         WHEN (tags->'highway') = 'proposed' AND exist(tags, 'proposed') AND (tags->'proposed') = 'cycleway' THEN 'proposed_cycleway'
         WHEN (tags->'highway') = 'cycleway' THEN 'separated'
         WHEN (tags->'highway') = 'busway' THEN 'separated'
         WHEN (tags->'cycleway'MULTIPOLYGON(((5.496132 43.463273,5.496132 43.463089,5.496256 43.462912,5.496816 43.462757,5.497088 43.462794,5.497529 43.462784,5.498006 43.462868,5.498594 43.462891,5.499753 43.462864,5.500512 43.462692,5.500934 43.462557,5.501861 43.462206,5.502376 43.46172,5.502796 43.461374,5.504105 43.460071,5.504618 43.459481,5.505146 43.458838,5.505688 43.458154,5.506659 43.456975,5.507188 43.456387,5.508121 43.455847,5.509154 43.455396,5.509836 43.454964,5.51044 43.4545,5.511062 43.453946,5.511764 43.453204,5.512164 43.452822,5.512819 43.452254,5.513417 43.451614,5.513634 43.451424,5.517067 43.449197,5.519033 43.448623,5.520121 43.448277,5.520785 43.44789,5.521707 43.447262,5.522392 43.446841,5.522632 43.446719,5.522717 43.446636,5.523428 43.446128,5.523528 43.446039,5.525081 43.444985,5.525918 43.444386,5.529485 43.44014,5.529281 43.439881,5.528785 43.438866,5.528619 43.438432,5.528539 43.438274,5.52845 43.437926,5.52832 43.437738,5.527935 43.437269,5.527387 43.436667,5.527034 43.43641,5.526101 43.435643,5.525927 43.435469,5.525806 43.435414,5.523748 43.434165,5.523318 43.433884,5.522536 43.433251,5.521868 43.43191,5.521633 43.431602,5.520763 43.430909,5.520368 43.430548,5.520069 43.430208,5.519844 43.429889,5.519402 43.429397,5.518833 43.428859,5.518566 43.429015,5.517803 43.429371,5.516987 43.429669,5.514835 43.430139,5.513886 43.430234,5.513473 43.430248,5.512514 43.430158,5.51184 43.430112,5.510988 43.430012,5.510407 43.429931,5.509609 43.430052,5.508194 43.430333,5.507793 43.429804,5.507719 43.429666,5.507263 43.429159,5.506914 43.428664,5.506643 43.428393,5.506502 43.428396,5.505337 43.428209,5.504213 43.428159,5.504069 43.428163,5.503122 43.428046,5.502385 43.42797,5.502248 43.427939,5.501748 43.428041,5.501494 43.428077,5.501203 43.428149,5.500673 43.428242,5.499014 43.428597,5.498363 43.428873,5.497891 43.429106,5.497432 43.429207,5.497189 43.429281,5.496468 43.429461,5.49617 43.429489,5.494677 43.429986,5.492466 43.430713,5.4913 43.431553,5.490979 43.431997,5.490169 43.431751,5.489838 43.431686,5.489685 43.431697,5.487331 43.431687,5.486844 43.431677,5.486263 43.431863,5.485837 43.432021,5.483479 43.430287,5.483692 43.4299,5.4829 43.429379,5.481331 43.429649,5.478926 43.430542,5.477068 43.430509,5.476783 43.430628,5.476631 43.430808,5.476606 43.431008,5.476443 43.431184,5.475858 43.431522,5.475544 43.431567,5.4739 43.431836,5.473724 43.43185,5.473617 43.431699,5.473068 43.431743,5.472509 43.431956,5.472364 43.431996,5.471907 43.431232,5.471469 43.430631,5.47016 43.431093,5.469628 43.431315,5.469241 43.43116,5.46873 43.430895,5.468435 43.430847,5.468258 43.431189,5.468145 43.431026,5.467908 43.430541,5.467679 43.430197,5.467575 43.430123,5.466859 43.429394,5.466111 43.428808,5.465665 43.429114,5.465226 43.429501,5.464986 43.429646,5.464468 43.430005,5.464329 43.430076,5.4641 43.430191,5.463706 43.430461,5.463015 43.430806,5.462656 43.431008,5.462268 43.431386,5.461814 43.431605,5.461703 43.431718,5.461434 43.432063,5.460936 43.432526,5.460864 43.432573,5.459447 43.433625,5.458126 43.434002,5.457198 43.434486,5.456676 43.434529,5.456064 43.434702,5.455743 43.434846,5.455161 43.435168,5.454628 43.435378,5.453696 43.435762,5.453086 43.436034,5.452317 43.436345,5.451948 43.436454,5.451665 43.436576,5.451328 43.436762,5.451024 43.436986,5.450865 43.437202,5.450593 43.437385,5.450465 43.437572,5.450057 43.438001,5.449677 43.438306,5.449637 43.438316,5.44948 43.438603,5.449339 43.439014,5.449301 43.439252,5.449431 43.439827,5.449407 43.440283,5.449501 43.441307,5.449633 43.441454,5.450224 43.441867,5.450572 43.442077,5.450598 43.44218,5.450508 43.442437,5.4505 43.442595,5.450438 43.442688,5.449784 43.443082,5.449632 43.443194,5.449273 43.443338,5.449217 43.443325,5.448895 43.44347,5.448416 43.443845,5.447999 43.444038,5.447245 43.444055,5.446773 43.444244,5.44657 43.444369,5.446529 43.444451,5.446351 43.445008,5.446298 43.44512,5.445836 43.445778,5.445466 43.446624,5.445102 43.447481,5.445207 43.447528,5.444902 43.448139,5.444738 43.448539,5.444656 43.448679,5.444552 43.449051,5.444293 43.44901,5.443892 43.448907,5.443806 43.449027,5.443737 43.449259,5.443473 43.449774,5.44516 43.450776,5.445633 43.451633,5.444435 43.4518,5.444316 43.451986,5.444947 43.452377,5.445066 43.452683,5.444748 43.453041,5.444722 43.453128,5.444778 43.453259,5.445167 43.453491,5.445376 43.45395,5.445306 43.454081,5.445342 43.454261,5.445543 43.454375,5.445591 43.454488,5.445598 43.4548,5.445711 43.454949,5.44603 43.455202,5.446433 43.454843,5.447511 43.456511,5.448671 43.460263,5.448267 43.460656,5.448354 43.462425,5.44826 43.463046,5.448191 43.46329,5.448195 43.463434,5.448273 43.463625,5.44838 43.463725,5.448552 43.464104,5.448524 43.46455,5.448579 43.464764,5.448695 43.465035,5.448615 43.465298,5.448346 43.465556,5.448257 43.465741,5.448113 43.465922,5.448132 43.466168,5.448256 43.466421,5.448196 43.466565,5.448007 43.466745,5.447967 43.466838,5.447901 43.467279,5.44784 43.467426,5.44756 43.467395,5.446953 43.467657,5.446363 43.468501,5.446139 43.468728,5.445349 43.469055,5.445128 43.469255,5.444787 43.469454,5.444561 43.4694,5.444015 43.469883,5.443925 43.469988,5.443874 43.470169,5.443692 43.470401,5.443524 43.470563,5.443285 43.470681,5.44313 43.470807,5.442517 43.471064,5.442381 43.471101,5.441853 43.471499,5.441965 43.472853,5.44242 43.472799,5.442547 43.472816,5.442779 43.472718,5.442981 43.472745,5.443287 43.472843,5.443435 43.472679,5.443656 43.472677,5.443974 43.472625,5.444301 43.472713,5.444486 43.472839,5.444482 43.472961,5.444878 43.473204,5.444998 43.473257,5.445152 43.473162,5.445283 43.473182,5.445812 43.473578,5.446084 43.473652,5.446576 43.473974,5.446622 43.474624,5.446648 43.474715,5.446988 43.474448,5.447277 43.474416,5.447466 43.474273,5.447736 43.474235,5.447795 43.474393,5.448235 43.474766,5.448423 43.474884,5.448824 43.475064,5.449039 43.475209,5.44925 43.475476,5.449421 43.475487,5.449925 43.475707,5.45008 43.47575,5.450388 43.475689,5.450422 43.475523,5.450517 43.475466,5.450909 43.475473,5.451233 43.475503,5.451508 43.475603,5.451791 43.475671,5.452152 43.47579,5.452331 43.475893,5.452596 43.476312,5.452596 43.47649,5.452652 43.476681,5.452562 43.476783,5.452468 43.477,5.452759 43.477208,5.452718 43.477443,5.452917 43.477589,5.45312 43.477633,5.453401 43.477548,5.453984 43.477612,5.454017 43.477408,5.454145 43.477302,5.454627 43.477284,5.454776 43.477351,5.455146 43.477433,5.455515 43.477411,5.455688 43.477506,5.455933 43.477793,5.456174 43.477946,5.456302 43.478088,5.456599 43.478158,5.457438 43.478814,5.457638 43.479093,5.457715 43.4795,5.457802 43.479663,5.45799 43.479918,5.458104 43.48039,5.458138 43.480681,5.458186 43.480815,5.458283 43.480911,5.458518 43.481065,5.458604 43.481328,5.458684 43.481459,5.458951 43.481709,5.459079 43.481923,5.459511 43.482109,5.459881 43.482062,5.460823 43.482752,5.461067 43.483046,5.46159 43.483858,5.462601 43.484658,5.462914 43.484925,5.463305 43.485207,5.463783 43.485857,5.464211 43.486811,5.464678 43.487136,5.46474 43.487206,5.465168 43.487388,5.465687 43.4877,5.466153 43.487934,5.466479 43.488139,5.466876 43.488424,5.467006 43.488551,5.468138 43.489075,5.468552 43.489066,5.468986 43.489032,5.469087 43.489006,5.469289 43.488935,5.469294 43.48884,5.469389 43.488703,5.469692 43.488386,5.469899 43.487902,5.470001 43.487841,5.47022 43.487883,5.470687 43.487934,5.471603 43.488113,5.472345 43.488237,5.473053 43.488248,5.4733 43.488226,5.474611 43.488207,5.474928 43.488268,5.475265 43.488237,5.475414 43.488189,5.475896 43.487876,5.476161 43.487758,5.476344 43.487596,5.476367 43.487505,5.476494 43.487487,5.476904 43.487179,5.477184 43.486858,5.477411 43.486508,5.47776 43.486032,5.478358 43.485537,5.478689 43.485176,5.478956 43.485009,5.479267 43.484671,5.479425 43.484436,5.479669 43.484158,5.479977 43.483877,5.480288 43.483534,5.480512 43.483313,5.480843 43.483123,5.481123 43.482911,5.481245 43.48262,5.481609 43.481912,5.481796 43.481761,5.482337 43.481053,5.482618 43.480883,5.48268 43.48078,5.482646 43.480332,5.482637 43.4799,5.482599 43.479313,5.482565 43.478296,5.482528 43.477978,5.482352 43.476757,5.482228 43.476049,5.482162 43.47556,5.482162 43.475333,5.482084 43.474316,5.482004 43.473401,5.481816 43.472877,5.481544 43.472333,5.481788 43.471738,5.481992 43.471003,5.482089 43.470558,5.483042 43.470056,5.483715 43.469715,5.484032 43.469526,5.484167 43.469401,5.484892 43.468917,5.485375 43.468813,5.486313 43.468519,5.486637 43.468297,5.486771 43.468168,5.487242 43.467931,5.488644 43.467146,5.489239 43.466542,5.489759 43.465926,5.489864 43.465846,5.49044 43.465534,5.490809 43.465381,5.49095 43.465278,5.491342 43.465073,5.492063 43.464853,5.49237 43.46481,5.492434 43.464726,5.492829 43.464588,5.493214 43.464431,5.493427 43.464319,5.494068 43.463909,5.495013 43.463258,5.495708 43.463824,5.495856 43.463751,5.496158 43.463661,5.496127 43.463546,5.496132 43.463273)))'') IN ('track', 'opposite_track', 'separate')
              AND exist(tags, 'highway')
              AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway') THEN 'separated'
         WHEN EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%') AND exist(tags, 'highway')
              AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway') THEN 'lane'
         WHEN (exist(tags, 'bicycle') AND (tags->'bicycle') IS NOT NULL AND (tags->'bicycle') <> 'no') AND exist(tags, 'highway')
              AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway')
              AND NOT (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%')) THEN 'designated'
         ELSE NULL
       END AS cycleway_category
FROM osm_object_meta m
CROSS JOIN (SELECT ST_MakeValid(ST_SetSRID(ST_GeomFromText(2000), 4326)) AS poly) z
CROSS JOIN LATERAL (SELECT ST_Buffer(z.poly::geography, ?)::geometry AS buf) bufc
WHERE m.geom IS NOT NULL
  AND m.osm_type IN ('way', 'relation')
  AND ST_Intersects(m.geom, bufc.buf)
  AND (
    (tags->'highway') = 'proposed' AND exist(tags, 'proposed') AND (tags->'proposed') = 'cycleway'
    OR (tags->'highway') IN ('cycleway', 'busway')
    OR (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%') AND exist(tags, 'highway')
        AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway'))
    OR ((exist(tags, 'bicycle') AND (tags->'bicycle') IS NOT NULL AND (tags->'bicycle') <> 'no') AND exist(tags, 'highway')
        AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway'))
  )
;