Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.disappeared_list AS disappeared_list_2,
  t0.current_list AS current_list_3,
  t0.theme AS theme_4,
  t0.stats_id AS stats_id_5
FROM
  zone_places t0
WHERE
  t0.stats_id = ?

SELECT t0.id AS id_1, t0.disappeared_list AS disappeared_list_2, t0.current_list AS current_list_3, t0.theme AS theme_4, t0.stats_id AS stats_id_5 FROM zone_places t0 WHERE t0.stats_id = 25964;

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

INSERT INTO action_log (
  type, data, created_at, from_url, who
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO action_log (type, data, created_at, from_url, who) VALUES ('stats_de_ville', '{\"insee_code\":\"34189\",\"nom\":\"34189\"}', '2026-07-15 01:51:14', NULL, NULL);

SELECT
  p0_.osm_user AS osm_user_0,
  COUNT(p0_.id) AS sclr_1,
  AVG(
    (
      CASE WHEN p0_.has_opening_hours = 1 THEN
        1
      ELSE
        0
      END
    ) + (
      CASE WHEN p0_.has_address = 1 THEN
        1
      ELSE
        0
      END
    ) + (
      CASE WHEN p0_.has_website = 1 THEN
        1
      ELSE
        0
      END
    ) + (
      CASE WHEN p0_.has_wheelchair = 1 THEN
        1
      ELSE
        0
      END
    ) + (
      CASE WHEN p0_.has_note = 1 THEN
        1
      ELSE
        0
      END
    )
  ) / 5 * 100 AS sclr_2
FROM
  place p0_
WHERE
  p0_.osm_user IS NOT NULL
  AND p0_.osm_user <> ''
  AND p0_.stats_id = ?
GROUP BY
  p0_.osm_user
ORDER BY
  sclr_1 DESC
LIMIT
  100

SELECT p0_.osm_user AS osm_user_0, COUNT(p0_.id) AS sclr_1, AVG((CASE WHEN p0_.has_opening_hours = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_address = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_website = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_wheelchair = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_note = 1 THEN 1 ELSE 0 END)) / 5 * 100 AS sclr_2 FROM place p0_ WHERE p0_.osm_user IS NOT NULL AND p0_.osm_user <> '' AND p0_.stats_id = 25964 GROUP BY p0_.osm_user ORDER BY sclr_1 DESC LIMIT 100;

SELECT
  s0_.id AS id_0,
  s0_.places_count AS places_count_1,
  s0_.emails_count AS emails_count_2,
  s0_.completion_percent AS completion_percent_3,
  s0_.emails_sent AS emails_sent_4,
  s0_.date AS date_5,
  s0_.names_count AS names_count_6,
  s0_.opening_hours_count AS opening_hours_count_7,
  s0_.website_count AS website_count_8,
  s0_.address_count AS address_count_9,
  s0_.siret_count AS siret_count_10,
  s0_.stats_id AS stats_id_11
FROM
  stats_history s0_
WHERE
  s0_.stats_id = ?
ORDER BY
  s0_.id DESC
LIMIT
  100

SELECT s0_.id AS id_0, s0_.places_count AS places_count_1, s0_.emails_count AS emails_count_2, s0_.completion_percent AS completion_percent_3, s0_.emails_sent AS emails_sent_4, s0_.date AS date_5, s0_.names_count AS names_count_6, s0_.opening_hours_count AS opening_hours_count_7, s0_.website_count AS website_count_8, s0_.address_count AS address_count_9, s0_.siret_count AS siret_count_10, s0_.stats_id AS stats_id_11 FROM stats_history s0_ WHERE s0_.stats_id = 25964 ORDER BY s0_.id DESC LIMIT 100;

SELECT
  COUNT(*)
FROM
  osm_object t0
WHERE
  t0.zone = ?

SELECT COUNT(*) FROM osm_object t0 WHERE t0.zone = '34189';

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

SELECT
  s0_.id AS id_0,
  s0_.zone AS zone_1,
  s0_.completion_percent AS completion_percent_2,
  s0_.places_count AS places_count_3,
  s0_.avec_horaires AS avec_horaires_4,
  s0_.avec_adresse AS avec_adresse_5,
  s0_.avec_site AS avec_site_6,
  s0_.avec_accessibilite AS avec_accessibilite_7,
  s0_.avec_note AS avec_note_8,
  s0_.name AS name_9,
  s0_.population AS population_10,
  s0_.siren AS siren_11,
  s0_.code_epci AS code_epci_12,
  s0_.codes_postaux AS codes_postaux_13,
  s0_.date_created AS date_created_14,
  s0_.date_modified AS date_modified_15,
  s0_.avec_siret AS avec_siret_16,
  s0_.avec_name AS avec_name_17,
  s0_.avec_email AS avec_email_18,
  s0_.osm_data_date_min AS osm_data_date_min_19,
  s0_.osm_data_date_avg AS osm_data_date_avg_20,
  s0_.osm_data_date_max AS osm_data_date_max_21,
  s0_.budget_annuel AS budget_annuel_22,
  s0_.lat AS lat_23,
  s0_.lon AS lon_24,
  s0_.date_labourage_requested AS date_labourage_requested_25,
  s0_.date_labourage_done AS date_labourage_done_26,
  s0_.kind AS kind_27
FROM
  stats s0_
WHERE
  s0_.zone = ?
ORDER BY
  s0_.id ASC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.zone AS zone_1, s0_.completion_percent AS completion_percent_2, s0_.places_count AS places_count_3, s0_.avec_horaires AS avec_horaires_4, s0_.avec_adresse AS avec_adresse_5, s0_.avec_site AS avec_site_6, s0_.avec_accessibilite AS avec_accessibilite_7, s0_.avec_note AS avec_note_8, s0_.name AS name_9, s0_.population AS population_10, s0_.siren AS siren_11, s0_.code_epci AS code_epci_12, s0_.codes_postaux AS codes_postaux_13, s0_.date_created AS date_created_14, s0_.date_modified AS date_modified_15, s0_.avec_siret AS avec_siret_16, s0_.avec_name AS avec_name_17, s0_.avec_email AS avec_email_18, s0_.osm_data_date_min AS osm_data_date_min_19, s0_.osm_data_date_avg AS osm_data_date_avg_20, s0_.osm_data_date_max AS osm_data_date_max_21, s0_.budget_annuel AS budget_annuel_22, s0_.lat AS lat_23, s0_.lon AS lon_24, s0_.date_labourage_requested AS date_labourage_requested_25, s0_.date_labourage_done AS date_labourage_done_26, s0_.kind AS kind_27 FROM stats s0_ WHERE s0_.zone = '34189' ORDER BY s0_.id ASC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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(((2.786973 43.274431,2.786926 43.273495,2.787279 43.273413,2.787322 43.273307,2.787436 43.272839,2.787511 43.272363,2.787244 43.27207,2.786459 43.271371,2.785611 43.270542,2.78513 43.270101,2.784741 43.269593,2.784097 43.26858,2.783763 43.26798,2.783221 43.267378,2.782312 43.266734,2.780609 43.265607,2.779771 43.265026,2.775266 43.2644,2.775111 43.263362,2.773507 43.261735,2.773749 43.261641,2.773522 43.26101,2.772877 43.260957,2.772075 43.26084,2.772202 43.260692,2.772225 43.259725,2.771963 43.259684,2.771428 43.259453,2.771289 43.259475,2.771367 43.259047,2.771567 43.258887,2.771812 43.25884,2.772104 43.258684,2.772169 43.258601,2.772256 43.258307,2.772172 43.25829,2.772224 43.257786,2.772285 43.257735,2.771991 43.257659,2.771786 43.257635,2.771468 43.257547,2.770667 43.257404,2.770133 43.257348,2.770068 43.257373,2.769788 43.257255,2.769213 43.257113,2.768796 43.257095,2.767989 43.256962,2.767088 43.256755,2.76692 43.256607,2.766874 43.256483,2.766221 43.256305,2.765962 43.256189,2.765479 43.256029,2.765088 43.255951,2.764838 43.255875,2.764443 43.255712,2.764106 43.255594,2.763821 43.255525,2.76321 43.255339,2.763012 43.255245,2.762789 43.255242,2.762247 43.255184,2.761968 43.255131,2.761576 43.255157,2.761318 43.255111,2.760818 43.255143,2.760397 43.255142,2.756767 43.254794,2.755945 43.254685,2.752443 43.254811,2.752145 43.255287,2.751661 43.255916,2.751225 43.25646,2.75074 43.256852,2.749981 43.257652,2.748686 43.258402,2.747821 43.258975,2.74737 43.259285,2.747182 43.259381,2.747038 43.259515,2.746863 43.259615,2.746361 43.25981,2.745965 43.2599,2.745831 43.259953,2.745571 43.260153,2.745184 43.260291,2.744883 43.260493,2.744748 43.260625,2.744625 43.260818,2.74442 43.261262,2.74425 43.261684,2.743821 43.262627,2.743648 43.263094,2.743484 43.263402,2.743081 43.26378,2.742398 43.264246,2.742014 43.264425,2.741696 43.264512,2.740988 43.264657,2.740973 43.264682,2.74083 43.264796,2.740657 43.26499,2.740122 43.26539,2.739703 43.265739,2.739612 43.265773,2.739321 43.266039,2.739129 43.266391,2.739014 43.266733,2.738328 43.267065,2.738004 43.267161,2.737878 43.267312,2.737637 43.26742,2.737484 43.267523,2.73618 43.268186,2.735719 43.26837,2.734657 43.268842,2.734351 43.268996,2.732438 43.269719,2.731511 43.270088,2.731494 43.270216,2.729876 43.270821,2.729727 43.270906,2.729133 43.271165,2.727267 43.271951,2.726419 43.272337,2.725853 43.272563,2.725066 43.272927,2.724776 43.273094,2.724564 43.27319,2.724261 43.273258,2.723473 43.273547,2.722524 43.27393,2.721928 43.274194,2.721388 43.27441,2.720565 43.274709,2.719961 43.274966,2.719598 43.275136,2.718853 43.275446,2.718399 43.275563,2.717947 43.27572,2.717498 43.275922,2.717203 43.276027,2.716318 43.276299,2.715591 43.276604,2.714782 43.277013,2.714164 43.276045,2.713562 43.274943,2.713332 43.274627,2.713146 43.274268,2.712149 43.274601,2.711614 43.274754,2.710825 43.274933,2.710508 43.274981,2.710064 43.27499,2.709684 43.27432,2.70933 43.273715,2.707359 43.273458,2.704935 43.274738,2.705047 43.275046,2.702952 43.276763,2.702412 43.278109,2.702258 43.278217,2.701884 43.278363,2.701665 43.278521,2.701238 43.278733,2.70096 43.27895,2.700766 43.279014,2.700504 43.279049,2.70024 43.279151,2.699646 43.279529,2.699092 43.279961,2.698951 43.280119,2.698902 43.280292,2.69894 43.280461,2.699096 43.280653,2.699364 43.280884,2.699448 43.28099,2.699428 43.28114,2.699313 43.281241,2.699215 43.281443,2.699161 43.281798,2.699191 43.281843,2.699536 43.281961,2.699894 43.28212,2.700471 43.282277,2.700842 43.282518,2.701226 43.282793,2.701021 43.282975,2.701092 43.283052,2.70116 43.283248,2.701931 43.285027,2.702056 43.285294,2.701943 43.285431,2.701807 43.285771,2.70182 43.286036,2.701988 43.286718,2.70195 43.286967,2.703754 43.288701,2.703948 43.288976,2.704125 43.289272,2.705121 43.290812,2.705765 43.292029,2.707135 43.294271,2.706532 43.294417,2.705909 43.29453,2.705319 43.294668,2.704631 43.294814,2.703564 43.295064,2.702648 43.295315,2.702381 43.295409,2.702466 43.295565,2.703017 43.296237,2.703627 43.29692,2.703829 43.297182,2.704368 43.297615,2.705106 43.298318,2.705629 43.29859,2.705909 43.29875,2.705416 43.298819,2.70498 43.298972,2.704406 43.299301,2.703695 43.299755,2.703174 43.300138,2.702497 43.300783,2.702272 43.30096,2.701784 43.301224,2.701423 43.301474,2.701112 43.301649,2.700793 43.301783,2.700172 43.302084,2.699729 43.302253,2.699242 43.302398,2.698608 43.302524,2.698927 43.303065,2.698887 43.303149,2.699183 43.303734,2.699458 43.304194,2.699578 43.304344,2.70002 43.305017,2.699785 43.305176,2.699531 43.305543,2.699674 43.30571,2.699884 43.30619,2.699457 43.306428,2.699396 43.308254,2.699549 43.308228,2.699872 43.30823,2.700302 43.308197,2.700581 43.308142,2.701027 43.307995,2.701646 43.30784,2.702334 43.307598,2.703502 43.307261,2.704027 43.307184,2.704276 43.307859,2.704614 43.308596,2.704828 43.308362,2.704887 43.308231,2.704929 43.307937,2.705568 43.307428,2.706053 43.30708,2.706201 43.306937,2.706485 43.306834,2.707185 43.306345,2.707703 43.305917,2.707918 43.305765,2.708066 43.305802,2.70861 43.305609,2.709201 43.305632,2.709536 43.305663,2.709645 43.305192,2.710608 43.305338,2.710898 43.305439,2.711739 43.305589,2.712807 43.305321,2.71319 43.305061,2.713877 43.30448,2.714477 43.303664,2.714896 43.303068,2.714932 43.302977,2.714933 43.302751,2.714814 43.302566,2.714467 43.302172,2.714251 43.302014,2.714079 43.301925,2.714233 43.301633,2.714648 43.301116,2.714695 43.300964,2.715052 43.301054,2.716037 43.301367,2.716649 43.30158,2.71698 43.301615,2.717609 43.301651,2.717803 43.301649,2.7178 43.301784,2.717966 43.30191,2.718411 43.301966,2.718673 43.302077,2.718906 43.302237,2.719306 43.302297,2.719448 43.302102,2.720021 43.302353,2.720227 43.302539,2.720266 43.302711,2.720471 43.302879,2.720801 43.303023,2.720924 43.303047,2.721206 43.303194,2.721685 43.303508,2.72193 43.303539,2.722219 43.303619,2.722434 43.30364,2.722705 43.303855,2.722927 43.303921,2.72315 43.30411,2.723419 43.304173,2.723442 43.304376,2.723543 43.304515,2.723873 43.304623,2.723971 43.304701,2.724939 43.305091,2.725137 43.30487,2.725663 43.30507,2.726124 43.305322,2.726298 43.305378,2.726443 43.305552,2.726709 43.305717,2.727094 43.305855,2.727463 43.305504,2.727736 43.305607,2.727889 43.305586,2.728262 43.305386,2.728157 43.305228,2.72872 43.305187,2.729021 43.305226,2.729135 43.305205,2.729415 43.305077,2.729764 43.305028,2.729972 43.305055,2.730095 43.305366,2.731226 43.305025,2.732113 43.305005,2.733027 43.305059,2.733379 43.305015,2.733666 43.305064,2.734044 43.305182,2.734703 43.305305,2.735094 43.305306,2.737421 43.30529,2.738131 43.305299,2.738807 43.30534,2.739069 43.305324,2.740087 43.305145,2.740222 43.305007,2.742135 43.303738,2.743155 43.302999,2.743897 43.302527,2.74391 43.302323,2.743853 43.302127,2.743278 43.302091,2.743358 43.301967,2.743521 43.301605,2.743283 43.301324,2.743423 43.300884,2.743259 43.300674,2.743215 43.300539,2.74321 43.300327,2.743449 43.300344,2.743211 43.299697,2.742363 43.299712,2.741872 43.299761,2.741589 43.29981,2.741589 43.299726,2.741837 43.299496,2.742419 43.298779,2.74299 43.298167,2.743316 43.297784,2.743668 43.297305,2.743878 43.297078,2.744147 43.296864,2.744311 43.296632,2.745054 43.296038,2.745745 43.295404,2.746153 43.29508,2.746414 43.294895,2.746733 43.294764,2.746915 43.294594,2.747115 43.294079,2.747171 43.293762,2.747327 43.293283,2.747639 43.292661,2.747666 43.292468,2.747811 43.29219,2.748063 43.291829,2.748217 43.291555,2.748643 43.291041,2.748923 43.290613,2.748967 43.290432,2.749289 43.290272,2.749613 43.290139,2.750653 43.289858,2.751055 43.28974,2.751053 43.28948,2.751087 43.289065,2.751221 43.288726,2.75153 43.288381,2.751661 43.288132,2.751449 43.288038,2.751725 43.287852,2.751822 43.287489,2.751868 43.287,2.751887 43.285998,2.751847 43.284908,2.750609 43.284875,2.750731 43.284275,2.750434 43.284213,2.750089 43.284181,2.749941 43.284197,2.749535 43.284318,2.749245 43.284268,2.749269 43.284025,2.749387 43.283713,2.749454 43.283312,2.749552 43.283176,2.749987 43.282137,2.749913 43.281888,2.749905 43.281749,2.750238 43.281622,2.751409 43.281202,2.751712 43.281135,2.752089 43.281085,2.752909 43.281039,2.754108 43.2808,2.75547 43.280544,2.75715 43.280185,2.757982 43.280017,2.758514 43.279884,2.759171 43.27964,2.758993 43.279223,2.758653 43.278328,2.758496 43.277806,2.7585 43.27744,2.758254 43.276876,2.758097 43.276356,2.757661 43.27509,2.757484 43.274785,2.757387 43.274443,2.757123 43.273981,2.757721 43.273717,2.758516 43.27352,2.758737 43.273406,2.759072 43.273093,2.75945 43.272935,2.7606 43.272704,2.760857 43.272721,2.761048 43.272771,2.761459 43.272815,2.761652 43.272812,2.762404 43.272487,2.762636 43.272355,2.762989 43.272239,2.763421 43.272228,2.763998 43.27227,2.764236 43.272311,2.764958 43.272476,2.765603 43.272477,2.765928 43.2725,2.766111 43.272407,2.766396 43.272352,2.766829 43.272355,2.767248 43.27227,2.767576 43.272248,2.767804 43.272191,2.768445 43.272326,2.768926 43.272395,2.76929 43.272399,2.769949 43.272362,2.770654 43.272422,2.771097 43.272512,2.771276 43.272578,2.771545 43.272626,2.772115 43.272617,2.772427 43.272639,2.772784 43.272717,2.773743 43.272985,2.77399 43.273027,2.774402 43.273133,2.775543 43.273195,2.776235 43.273313,2.776501 43.27329,2.77668 43.273361,2.77732 43.273506,2.778448 43.273637,2.779238 43.273913,2.779577 43.273994,2.780668 43.274191,2.780733 43.274224,2.780754 43.274406,2.780975 43.274419,2.781091 43.274359,2.78159 43.27431,2.783291 43.274295,2.783656 43.274334,2.784262 43.274524,2.78438 43.274598,2.784843 43.274623,2.785074 43.274252,2.786973 43.274431)))'') 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'))
  )
;

SELECT
  osm_type,
  osm_id :: text AS osm_id,
  ST_Y(
    ST_Centroid(geom)
  ) AS lat,
  ST_X(
    ST_Centroid(geom)
  ) AS lon,
  tags :: jsonb AS tags_json,
  version,
  osm_timestamp,
  changeset,
  osm_user,
  uid :: bigint AS uid
FROM
  osm_object_meta m
WHERE
  geom IS NOT NULL
  AND ST_Intersects(
    m.geom,
    ST_GeomFromText(?, 4326)
  )
  AND (
    (tags -> 'shop') = 'vacant'
    OR EXISTS (
      SELECT
        1
      FROM
        unnest(
          akeys(tags)
        ) k
      WHERE
        k LIKE 'was:%'
    )
  )

SELECT osm_type, osm_id::text AS osm_id, ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,
            tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid
            FROM osm_object_meta m
            WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText('MULTIPOLYGON(((2.786973 43.274431,2.786926 43.273495,2.787279 43.273413,2.787322 43.273307,2.787436 43.272839,2.787511 43.272363,2.787244 43.27207,2.786459 43.271371,2.785611 43.270542,2.78513 43.270101,2.784741 43.269593,2.784097 43.26858,2.783763 43.26798,2.783221 43.267378,2.782312 43.266734,2.780609 43.265607,2.779771 43.265026,2.775266 43.2644,2.775111 43.263362,2.773507 43.261735,2.773749 43.261641,2.773522 43.26101,2.772877 43.260957,2.772075 43.26084,2.772202 43.260692,2.772225 43.259725,2.771963 43.259684,2.771428 43.259453,2.771289 43.259475,2.771367 43.259047,2.771567 43.258887,2.771812 43.25884,2.772104 43.258684,2.772169 43.258601,2.772256 43.258307,2.772172 43.25829,2.772224 43.257786,2.772285 43.257735,2.771991 43.257659,2.771786 43.257635,2.771468 43.257547,2.770667 43.257404,2.770133 43.257348,2.770068 43.257373,2.769788 43.257255,2.769213 43.257113,2.768796 43.257095,2.767989 43.256962,2.767088 43.256755,2.76692 43.256607,2.766874 43.256483,2.766221 43.256305,2.765962 43.256189,2.765479 43.256029,2.765088 43.255951,2.764838 43.255875,2.764443 43.255712,2.764106 43.255594,2.763821 43.255525,2.76321 43.255339,2.763012 43.255245,2.762789 43.255242,2.762247 43.255184,2.761968 43.255131,2.761576 43.255157,2.761318 43.255111,2.760818 43.255143,2.760397 43.255142,2.756767 43.254794,2.755945 43.254685,2.752443 43.254811,2.752145 43.255287,2.751661 43.255916,2.751225 43.25646,2.75074 43.256852,2.749981 43.257652,2.748686 43.258402,2.747821 43.258975,2.74737 43.259285,2.747182 43.259381,2.747038 43.259515,2.746863 43.259615,2.746361 43.25981,2.745965 43.2599,2.745831 43.259953,2.745571 43.260153,2.745184 43.260291,2.744883 43.260493,2.744748 43.260625,2.744625 43.260818,2.74442 43.261262,2.74425 43.261684,2.743821 43.262627,2.743648 43.263094,2.743484 43.263402,2.743081 43.26378,2.742398 43.264246,2.742014 43.264425,2.741696 43.264512,2.740988 43.264657,2.740973 43.264682,2.74083 43.264796,2.740657 43.26499,2.740122 43.26539,2.739703 43.265739,2.739612 43.265773,2.739321 43.266039,2.739129 43.266391,2.739014 43.266733,2.738328 43.267065,2.738004 43.267161,2.737878 43.267312,2.737637 43.26742,2.737484 43.267523,2.73618 43.268186,2.735719 43.26837,2.734657 43.268842,2.734351 43.268996,2.732438 43.269719,2.731511 43.270088,2.731494 43.270216,2.729876 43.270821,2.729727 43.270906,2.729133 43.271165,2.727267 43.271951,2.726419 43.272337,2.725853 43.272563,2.725066 43.272927,2.724776 43.273094,2.724564 43.27319,2.724261 43.273258,2.723473 43.273547,2.722524 43.27393,2.721928 43.274194,2.721388 43.27441,2.720565 43.274709,2.719961 43.274966,2.719598 43.275136,2.718853 43.275446,2.718399 43.275563,2.717947 43.27572,2.717498 43.275922,2.717203 43.276027,2.716318 43.276299,2.715591 43.276604,2.714782 43.277013,2.714164 43.276045,2.713562 43.274943,2.713332 43.274627,2.713146 43.274268,2.712149 43.274601,2.711614 43.274754,2.710825 43.274933,2.710508 43.274981,2.710064 43.27499,2.709684 43.27432,2.70933 43.273715,2.707359 43.273458,2.704935 43.274738,2.705047 43.275046,2.702952 43.276763,2.702412 43.278109,2.702258 43.278217,2.701884 43.278363,2.701665 43.278521,2.701238 43.278733,2.70096 43.27895,2.700766 43.279014,2.700504 43.279049,2.70024 43.279151,2.699646 43.279529,2.699092 43.279961,2.698951 43.280119,2.698902 43.280292,2.69894 43.280461,2.699096 43.280653,2.699364 43.280884,2.699448 43.28099,2.699428 43.28114,2.699313 43.281241,2.699215 43.281443,2.699161 43.281798,2.699191 43.281843,2.699536 43.281961,2.699894 43.28212,2.700471 43.282277,2.700842 43.282518,2.701226 43.282793,2.701021 43.282975,2.701092 43.283052,2.70116 43.283248,2.701931 43.285027,2.702056 43.285294,2.701943 43.285431,2.701807 43.285771,2.70182 43.286036,2.701988 43.286718,2.70195 43.286967,2.703754 43.288701,2.703948 43.288976,2.704125 43.289272,2.705121 43.290812,2.705765 43.292029,2.707135 43.294271,2.706532 43.294417,2.705909 43.29453,2.705319 43.294668,2.704631 43.294814,2.703564 43.295064,2.702648 43.295315,2.702381 43.295409,2.702466 43.295565,2.703017 43.296237,2.703627 43.29692,2.703829 43.297182,2.704368 43.297615,2.705106 43.298318,2.705629 43.29859,2.705909 43.29875,2.705416 43.298819,2.70498 43.298972,2.704406 43.299301,2.703695 43.299755,2.703174 43.300138,2.702497 43.300783,2.702272 43.30096,2.701784 43.301224,2.701423 43.301474,2.701112 43.301649,2.700793 43.301783,2.700172 43.302084,2.699729 43.302253,2.699242 43.302398,2.698608 43.302524,2.698927 43.303065,2.698887 43.303149,2.699183 43.303734,2.699458 43.304194,2.699578 43.304344,2.70002 43.305017,2.699785 43.305176,2.699531 43.305543,2.699674 43.30571,2.699884 43.30619,2.699457 43.306428,2.699396 43.308254,2.699549 43.308228,2.699872 43.30823,2.700302 43.308197,2.700581 43.308142,2.701027 43.307995,2.701646 43.30784,2.702334 43.307598,2.703502 43.307261,2.704027 43.307184,2.704276 43.307859,2.704614 43.308596,2.704828 43.308362,2.704887 43.308231,2.704929 43.307937,2.705568 43.307428,2.706053 43.30708,2.706201 43.306937,2.706485 43.306834,2.707185 43.306345,2.707703 43.305917,2.707918 43.305765,2.708066 43.305802,2.70861 43.305609,2.709201 43.305632,2.709536 43.305663,2.709645 43.305192,2.710608 43.305338,2.710898 43.305439,2.711739 43.305589,2.712807 43.305321,2.71319 43.305061,2.713877 43.30448,2.714477 43.303664,2.714896 43.303068,2.714932 43.302977,2.714933 43.302751,2.714814 43.302566,2.714467 43.302172,2.714251 43.302014,2.714079 43.301925,2.714233 43.301633,2.714648 43.301116,2.714695 43.300964,2.715052 43.301054,2.716037 43.301367,2.716649 43.30158,2.71698 43.301615,2.717609 43.301651,2.717803 43.301649,2.7178 43.301784,2.717966 43.30191,2.718411 43.301966,2.718673 43.302077,2.718906 43.302237,2.719306 43.302297,2.719448 43.302102,2.720021 43.302353,2.720227 43.302539,2.720266 43.302711,2.720471 43.302879,2.720801 43.303023,2.720924 43.303047,2.721206 43.303194,2.721685 43.303508,2.72193 43.303539,2.722219 43.303619,2.722434 43.30364,2.722705 43.303855,2.722927 43.303921,2.72315 43.30411,2.723419 43.304173,2.723442 43.304376,2.723543 43.304515,2.723873 43.304623,2.723971 43.304701,2.724939 43.305091,2.725137 43.30487,2.725663 43.30507,2.726124 43.305322,2.726298 43.305378,2.726443 43.305552,2.726709 43.305717,2.727094 43.305855,2.727463 43.305504,2.727736 43.305607,2.727889 43.305586,2.728262 43.305386,2.728157 43.305228,2.72872 43.305187,2.729021 43.305226,2.729135 43.305205,2.729415 43.305077,2.729764 43.305028,2.729972 43.305055,2.730095 43.305366,2.731226 43.305025,2.732113 43.305005,2.733027 43.305059,2.733379 43.305015,2.733666 43.305064,2.734044 43.305182,2.734703 43.305305,2.735094 43.305306,2.737421 43.30529,2.738131 43.305299,2.738807 43.30534,2.739069 43.305324,2.740087 43.305145,2.740222 43.305007,2.742135 43.303738,2.743155 43.302999,2.743897 43.302527,2.74391 43.302323,2.743853 43.302127,2.743278 43.302091,2.743358 43.301967,2.743521 43.301605,2.743283 43.301324,2.743423 43.300884,2.743259 43.300674,2.743215 43.300539,2.74321 43.300327,2.743449 43.300344,2.743211 43.299697,2.742363 43.299712,2.741872 43.299761,2.741589 43.29981,2.741589 43.299726,2.741837 43.299496,2.742419 43.298779,2.74299 43.298167,2.743316 43.297784,2.743668 43.297305,2.743878 43.297078,2.744147 43.296864,2.744311 43.296632,2.745054 43.296038,2.745745 43.295404,2.746153 43.29508,2.746414 43.294895,2.746733 43.294764,2.746915 43.294594,2.747115 43.294079,2.747171 43.293762,2.747327 43.293283,2.747639 43.292661,2.747666 43.292468,2.747811 43.29219,2.748063 43.291829,2.748217 43.291555,2.748643 43.291041,2.748923 43.290613,2.748967 43.290432,2.749289 43.290272,2.749613 43.290139,2.750653 43.289858,2.751055 43.28974,2.751053 43.28948,2.751087 43.289065,2.751221 43.288726,2.75153 43.288381,2.751661 43.288132,2.751449 43.288038,2.751725 43.287852,2.751822 43.287489,2.751868 43.287,2.751887 43.285998,2.751847 43.284908,2.750609 43.284875,2.750731 43.284275,2.750434 43.284213,2.750089 43.284181,2.749941 43.284197,2.749535 43.284318,2.749245 43.284268,2.749269 43.284025,2.749387 43.283713,2.749454 43.283312,2.749552 43.283176,2.749987 43.282137,2.749913 43.281888,2.749905 43.281749,2.750238 43.281622,2.751409 43.281202,2.751712 43.281135,2.752089 43.281085,2.752909 43.281039,2.754108 43.2808,2.75547 43.280544,2.75715 43.280185,2.757982 43.280017,2.758514 43.279884,2.759171 43.27964,2.758993 43.279223,2.758653 43.278328,2.758496 43.277806,2.7585 43.27744,2.758254 43.276876,2.758097 43.276356,2.757661 43.27509,2.757484 43.274785,2.757387 43.274443,2.757123 43.273981,2.757721 43.273717,2.758516 43.27352,2.758737 43.273406,2.759072 43.273093,2.75945 43.272935,2.7606 43.272704,2.760857 43.272721,2.761048 43.272771,2.761459 43.272815,2.761652 43.272812,2.762404 43.272487,2.762636 43.272355,2.762989 43.272239,2.763421 43.272228,2.763998 43.27227,2.764236 43.272311,2.764958 43.272476,2.765603 43.272477,2.765928 43.2725,2.766111 43.272407,2.766396 43.272352,2.766829 43.272355,2.767248 43.27227,2.767576 43.272248,2.767804 43.272191,2.768445 43.272326,2.768926 43.272395,2.76929 43.272399,2.769949 43.272362,2.770654 43.272422,2.771097 43.272512,2.771276 43.272578,2.771545 43.272626,2.772115 43.272617,2.772427 43.272639,2.772784 43.272717,2.773743 43.272985,2.77399 43.273027,2.774402 43.273133,2.775543 43.273195,2.776235 43.273313,2.776501 43.27329,2.77668 43.273361,2.77732 43.273506,2.778448 43.273637,2.779238 43.273913,2.779577 43.273994,2.780668 43.274191,2.780733 43.274224,2.780754 43.274406,2.780975 43.274419,2.781091 43.274359,2.78159 43.27431,2.783291 43.274295,2.783656 43.274334,2.784262 43.274524,2.78438 43.274598,2.784843 43.274623,2.785074 43.274252,2.786973 43.274431)))', 4326))
            AND (
              (tags->'shop') = 'vacant'
              OR EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k LIKE 'was:%')
            );

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),
        z.poly
      ):: geography
    ),
    0
  ) AS length_m
FROM
  osm_object_meta m CROSS
  JOIN (
    SELECT
      ST_MakeValid(
        ST_SetSRID(
          ST_GeomFromText(?),
          4326
        )
      ) AS poly
  ) z
WHERE
  m.geom IS NOT NULL
  AND m.osm_type IN ('way', 'relation')
  AND ST_Intersects(m.geom, z.poly)
  AND exist(tags, 'highway')
  AND (tags -> 'highway') NOT IN (
    'motorway', 'motorway_link', 'trunk',
    'trunk_link', 'footway', 'steps',
    'pedestrian', 'bridleway', 'raceway',
    'cycleway', 'busway', 'construction',
    'proposed'
  )
  AND (tags -> 'oneway') IN ('yes', '-1', '1')
  AND NOT (
    (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')
      AND NOT (
        EXISTS (
          SELECT
            1
          FROM
            unnest(
              akeys(tags)
            ) k
          WHERE
            k = 'cycleway'
            OR k LIKE 'cycleway:%'
        )
      )
    )
  )
  AND NOT (
    (tags -> 'oneway:bicycle') = 'no'
  )

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), z.poly)::geography), 0) AS length_m
FROM osm_object_meta m
CROSS JOIN (SELECT ST_MakeValid(ST_SetSRID(ST_GeomFromText('MULTIPOLYGON(((2.786973 43.274431,2.786926 43.273495,2.787279 43.273413,2.787322 43.273307,2.787436 43.272839,2.787511 43.272363,2.787244 43.27207,2.786459 43.271371,2.785611 43.270542,2.78513 43.270101,2.784741 43.269593,2.784097 43.26858,2.783763 43.26798,2.783221 43.267378,2.782312 43.266734,2.780609 43.265607,2.779771 43.265026,2.775266 43.2644,2.775111 43.263362,2.773507 43.261735,2.773749 43.261641,2.773522 43.26101,2.772877 43.260957,2.772075 43.26084,2.772202 43.260692,2.772225 43.259725,2.771963 43.259684,2.771428 43.259453,2.771289 43.259475,2.771367 43.259047,2.771567 43.258887,2.771812 43.25884,2.772104 43.258684,2.772169 43.258601,2.772256 43.258307,2.772172 43.25829,2.772224 43.257786,2.772285 43.257735,2.771991 43.257659,2.771786 43.257635,2.771468 43.257547,2.770667 43.257404,2.770133 43.257348,2.770068 43.257373,2.769788 43.257255,2.769213 43.257113,2.768796 43.257095,2.767989 43.256962,2.767088 43.256755,2.76692 43.256607,2.766874 43.256483,2.766221 43.256305,2.765962 43.256189,2.765479 43.256029,2.765088 43.255951,2.764838 43.255875,2.764443 43.255712,2.764106 43.255594,2.763821 43.255525,2.76321 43.255339,2.763012 43.255245,2.762789 43.255242,2.762247 43.255184,2.761968 43.255131,2.761576 43.255157,2.761318 43.255111,2.760818 43.255143,2.760397 43.255142,2.756767 43.254794,2.755945 43.254685,2.752443 43.254811,2.752145 43.255287,2.751661 43.255916,2.751225 43.25646,2.75074 43.256852,2.749981 43.257652,2.748686 43.258402,2.747821 43.258975,2.74737 43.259285,2.747182 43.259381,2.747038 43.259515,2.746863 43.259615,2.746361 43.25981,2.745965 43.2599,2.745831 43.259953,2.745571 43.260153,2.745184 43.260291,2.744883 43.260493,2.744748 43.260625,2.744625 43.260818,2.74442 43.261262,2.74425 43.261684,2.743821 43.262627,2.743648 43.263094,2.743484 43.263402,2.743081 43.26378,2.742398 43.264246,2.742014 43.264425,2.741696 43.264512,2.740988 43.264657,2.740973 43.264682,2.74083 43.264796,2.740657 43.26499,2.740122 43.26539,2.739703 43.265739,2.739612 43.265773,2.739321 43.266039,2.739129 43.266391,2.739014 43.266733,2.738328 43.267065,2.738004 43.267161,2.737878 43.267312,2.737637 43.26742,2.737484 43.267523,2.73618 43.268186,2.735719 43.26837,2.734657 43.268842,2.734351 43.268996,2.732438 43.269719,2.731511 43.270088,2.731494 43.270216,2.729876 43.270821,2.729727 43.270906,2.729133 43.271165,2.727267 43.271951,2.726419 43.272337,2.725853 43.272563,2.725066 43.272927,2.724776 43.273094,2.724564 43.27319,2.724261 43.273258,2.723473 43.273547,2.722524 43.27393,2.721928 43.274194,2.721388 43.27441,2.720565 43.274709,2.719961 43.274966,2.719598 43.275136,2.718853 43.275446,2.718399 43.275563,2.717947 43.27572,2.717498 43.275922,2.717203 43.276027,2.716318 43.276299,2.715591 43.276604,2.714782 43.277013,2.714164 43.276045,2.713562 43.274943,2.713332 43.274627,2.713146 43.274268,2.712149 43.274601,2.711614 43.274754,2.710825 43.274933,2.710508 43.274981,2.710064 43.27499,2.709684 43.27432,2.70933 43.273715,2.707359 43.273458,2.704935 43.274738,2.705047 43.275046,2.702952 43.276763,2.702412 43.278109,2.702258 43.278217,2.701884 43.278363,2.701665 43.278521,2.701238 43.278733,2.70096 43.27895,2.700766 43.279014,2.700504 43.279049,2.70024 43.279151,2.699646 43.279529,2.699092 43.279961,2.698951 43.280119,2.698902 43.280292,2.69894 43.280461,2.699096 43.280653,2.699364 43.280884,2.699448 43.28099,2.699428 43.28114,2.699313 43.281241,2.699215 43.281443,2.699161 43.281798,2.699191 43.281843,2.699536 43.281961,2.699894 43.28212,2.700471 43.282277,2.700842 43.282518,2.701226 43.282793,2.701021 43.282975,2.701092 43.283052,2.70116 43.283248,2.701931 43.285027,2.702056 43.285294,2.701943 43.285431,2.701807 43.285771,2.70182 43.286036,2.701988 43.286718,2.70195 43.286967,2.703754 43.288701,2.703948 43.288976,2.704125 43.289272,2.705121 43.290812,2.705765 43.292029,2.707135 43.294271,2.706532 43.294417,2.705909 43.29453,2.705319 43.294668,2.704631 43.294814,2.703564 43.295064,2.702648 43.295315,2.702381 43.295409,2.702466 43.295565,2.703017 43.296237,2.703627 43.29692,2.703829 43.297182,2.704368 43.297615,2.705106 43.298318,2.705629 43.29859,2.705909 43.29875,2.705416 43.298819,2.70498 43.298972,2.704406 43.299301,2.703695 43.299755,2.703174 43.300138,2.702497 43.300783,2.702272 43.30096,2.701784 43.301224,2.701423 43.301474,2.701112 43.301649,2.700793 43.301783,2.700172 43.302084,2.699729 43.302253,2.699242 43.302398,2.698608 43.302524,2.698927 43.303065,2.698887 43.303149,2.699183 43.303734,2.699458 43.304194,2.699578 43.304344,2.70002 43.305017,2.699785 43.305176,2.699531 43.305543,2.699674 43.30571,2.699884 43.30619,2.699457 43.306428,2.699396 43.308254,2.699549 43.308228,2.699872 43.30823,2.700302 43.308197,2.700581 43.308142,2.701027 43.307995,2.701646 43.30784,2.702334 43.307598,2.703502 43.307261,2.704027 43.307184,2.704276 43.307859,2.704614 43.308596,2.704828 43.308362,2.704887 43.308231,2.704929 43.307937,2.705568 43.307428,2.706053 43.30708,2.706201 43.306937,2.706485 43.306834,2.707185 43.306345,2.707703 43.305917,2.707918 43.305765,2.708066 43.305802,2.70861 43.305609,2.709201 43.305632,2.709536 43.305663,2.709645 43.305192,2.710608 43.305338,2.710898 43.305439,2.711739 43.305589,2.712807 43.305321,2.71319 43.305061,2.713877 43.30448,2.714477 43.303664,2.714896 43.303068,2.714932 43.302977,2.714933 43.302751,2.714814 43.302566,2.714467 43.302172,2.714251 43.302014,2.714079 43.301925,2.714233 43.301633,2.714648 43.301116,2.714695 43.300964,2.715052 43.301054,2.716037 43.301367,2.716649 43.30158,2.71698 43.301615,2.717609 43.301651,2.717803 43.301649,2.7178 43.301784,2.717966 43.30191,2.718411 43.301966,2.718673 43.302077,2.718906 43.302237,2.719306 43.302297,2.719448 43.302102,2.720021 43.302353,2.720227 43.302539,2.720266 43.302711,2.720471 43.302879,2.720801 43.303023,2.720924 43.303047,2.721206 43.303194,2.721685 43.303508,2.72193 43.303539,2.722219 43.303619,2.722434 43.30364,2.722705 43.303855,2.722927 43.303921,2.72315 43.30411,2.723419 43.304173,2.723442 43.304376,2.723543 43.304515,2.723873 43.304623,2.723971 43.304701,2.724939 43.305091,2.725137 43.30487,2.725663 43.30507,2.726124 43.305322,2.726298 43.305378,2.726443 43.305552,2.726709 43.305717,2.727094 43.305855,2.727463 43.305504,2.727736 43.305607,2.727889 43.305586,2.728262 43.305386,2.728157 43.305228,2.72872 43.305187,2.729021 43.305226,2.729135 43.305205,2.729415 43.305077,2.729764 43.305028,2.729972 43.305055,2.730095 43.305366,2.731226 43.305025,2.732113 43.305005,2.733027 43.305059,2.733379 43.305015,2.733666 43.305064,2.734044 43.305182,2.734703 43.305305,2.735094 43.305306,2.737421 43.30529,2.738131 43.305299,2.738807 43.30534,2.739069 43.305324,2.740087 43.305145,2.740222 43.305007,2.742135 43.303738,2.743155 43.302999,2.743897 43.302527,2.74391 43.302323,2.743853 43.302127,2.743278 43.302091,2.743358 43.301967,2.743521 43.301605,2.743283 43.301324,2.743423 43.300884,2.743259 43.300674,2.743215 43.300539,2.74321 43.300327,2.743449 43.300344,2.743211 43.299697,2.742363 43.299712,2.741872 43.299761,2.741589 43.29981,2.741589 43.299726,2.741837 43.299496,2.742419 43.298779,2.74299 43.298167,2.743316 43.297784,2.743668 43.297305,2.743878 43.297078,2.744147 43.296864,2.744311 43.296632,2.745054 43.296038,2.745745 43.295404,2.746153 43.29508,2.746414 43.294895,2.746733 43.294764,2.746915 43.294594,2.747115 43.294079,2.747171 43.293762,2.747327 43.293283,2.747639 43.292661,2.747666 43.292468,2.747811 43.29219,2.748063 43.291829,2.748217 43.291555,2.748643 43.291041,2.748923 43.290613,2.748967 43.290432,2.749289 43.290272,2.749613 43.290139,2.750653 43.289858,2.751055 43.28974,2.751053 43.28948,2.751087 43.289065,2.751221 43.288726,2.75153 43.288381,2.751661 43.288132,2.751449 43.288038,2.751725 43.287852,2.751822 43.287489,2.751868 43.287,2.751887 43.285998,2.751847 43.284908,2.750609 43.284875,2.750731 43.284275,2.750434 43.284213,2.750089 43.284181,2.749941 43.284197,2.749535 43.284318,2.749245 43.284268,2.749269 43.284025,2.749387 43.283713,2.749454 43.283312,2.749552 43.283176,2.749987 43.282137,2.749913 43.281888,2.749905 43.281749,2.750238 43.281622,2.751409 43.281202,2.751712 43.281135,2.752089 43.281085,2.752909 43.281039,2.754108 43.2808,2.75547 43.280544,2.75715 43.280185,2.757982 43.280017,2.758514 43.279884,2.759171 43.27964,2.758993 43.279223,2.758653 43.278328,2.758496 43.277806,2.7585 43.27744,2.758254 43.276876,2.758097 43.276356,2.757661 43.27509,2.757484 43.274785,2.757387 43.274443,2.757123 43.273981,2.757721 43.273717,2.758516 43.27352,2.758737 43.273406,2.759072 43.273093,2.75945 43.272935,2.7606 43.272704,2.760857 43.272721,2.761048 43.272771,2.761459 43.272815,2.761652 43.272812,2.762404 43.272487,2.762636 43.272355,2.762989 43.272239,2.763421 43.272228,2.763998 43.27227,2.764236 43.272311,2.764958 43.272476,2.765603 43.272477,2.765928 43.2725,2.766111 43.272407,2.766396 43.272352,2.766829 43.272355,2.767248 43.27227,2.767576 43.272248,2.767804 43.272191,2.768445 43.272326,2.768926 43.272395,2.76929 43.272399,2.769949 43.272362,2.770654 43.272422,2.771097 43.272512,2.771276 43.272578,2.771545 43.272626,2.772115 43.272617,2.772427 43.272639,2.772784 43.272717,2.773743 43.272985,2.77399 43.273027,2.774402 43.273133,2.775543 43.273195,2.776235 43.273313,2.776501 43.27329,2.77668 43.273361,2.77732 43.273506,2.778448 43.273637,2.779238 43.273913,2.779577 43.273994,2.780668 43.274191,2.780733 43.274224,2.780754 43.274406,2.780975 43.274419,2.781091 43.274359,2.78159 43.27431,2.783291 43.274295,2.783656 43.274334,2.784262 43.274524,2.78438 43.274598,2.784843 43.274623,2.785074 43.274252,2.786973 43.274431)))'), 4326)) AS poly) z
WHERE m.geom IS NOT NULL
  AND m.osm_type IN ('way', 'relation')
  AND ST_Intersects(m.geom, z.poly)
  AND exist(tags, 'highway')
  AND (tags->'highway') NOT IN (
    'motorway', 'motorway_link', 'trunk', 'trunk_link',
    'footway', 'steps', 'pedestrian', 'bridleway', 'raceway',
    'cycleway', 'busway', 'construction', 'proposed'
  )
  AND (tags->'oneway') IN ('yes', '-1', '1')
  AND NOT ( (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') AND NOT (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%'))))
  AND NOT ((tags->'oneway:bicycle') = 'no')
;

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