Symfony Profiler

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

"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 = 25863;

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 = 25863 GROUP BY p0_.osm_user ORDER BY sclr_1 DESC LIMIT 100;

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\":\"34029\",\"nom\":\"34029\"}', '2026-07-15 02:56:43', NULL, NULL);

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

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

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 = 25863 ORDER BY s0_.id DESC LIMIT 100;

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 = '34029' ORDER BY s0_.id ASC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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(((3.520352 43.54584,3.51964 43.545765,3.519295 43.545779,3.518855 43.545872,3.518539 43.546039,3.518316 43.546046,3.517638 43.546032,3.517466 43.546016,3.516885 43.54602,3.516462 43.545928,3.516045 43.545906,3.515433 43.545895,3.515184 43.545918,3.514731 43.546014,3.51449 43.546044,3.514207 43.546045,3.513837 43.545997,3.513066 43.545857,3.512629 43.545809,3.512264 43.54582,3.511934 43.54601,3.511722 43.546175,3.511594 43.546379,3.511478 43.546625,3.511085 43.547054,3.510918 43.547178,3.510544 43.547383,3.510288 43.547449,3.51011 43.547428,3.50979 43.547157,3.509561 43.547127,3.50919 43.547171,3.508708 43.547275,3.508407 43.547269,3.507657 43.547092,3.507253 43.54708,3.506729 43.547129,3.506428 43.547215,3.506043 43.547158,3.505763 43.547161,3.505576 43.54712,3.505333 43.546993,3.504904 43.546922,3.504485 43.546955,3.503865 43.547076,3.503232 43.547068,3.502892 43.547094,3.502417 43.547101,3.501533 43.547197,3.501141 43.547353,3.500858 43.547328,3.500576 43.547334,3.500281 43.547478,3.499846 43.547582,3.499282 43.547638,3.498848 43.547754,3.498216 43.548131,3.497907 43.548353,3.497672 43.548553,3.497457 43.548599,3.497274 43.548561,3.496858 43.548554,3.496556 43.548487,3.496374 43.548265,3.496175 43.548154,3.495999 43.548117,3.49576 43.548182,3.495415 43.548338,3.495145 43.548336,3.494302 43.548171,3.494152 43.548176,3.494015 43.5481,3.493619 43.548035,3.493348 43.548084,3.493182 43.548155,3.492953 43.548312,3.492839 43.548323,3.492641 43.548237,3.492006 43.54809,3.491479 43.548012,3.491061 43.547972,3.490711 43.547997,3.49022 43.548131,3.48984 43.548161,3.489287 43.548062,3.489031 43.548075,3.488473 43.548142,3.488007 43.548293,3.487664 43.548295,3.487301 43.548228,3.486941 43.548262,3.486724 43.548402,3.486584 43.548613,3.48653 43.548828,3.48636 43.548896,3.485883 43.548978,3.485397 43.549148,3.485268 43.549523,3.485274 43.549667,3.4852 43.549768,3.48474 43.55004,3.484561 43.550122,3.484392 43.550128,3.48426 43.549993,3.484062 43.549715,3.48383 43.549503,3.483623 43.549466,3.483434 43.549592,3.483364 43.549818,3.483151 43.550219,3.483031 43.550377,3.482934 43.550437,3.482182 43.550773,3.482613 43.551414,3.483133 43.551793,3.484128 43.552646,3.48497 43.553347,3.484453 43.553769,3.484332 43.554144,3.483184 43.554715,3.482981 43.554825,3.481764 43.554843,3.481556 43.554835,3.480541 43.554843,3.4803 43.554815,3.480215 43.555008,3.480127 43.554989,3.48004 43.555295,3.479983 43.555681,3.479715 43.556755,3.47905 43.557482,3.478561 43.557973,3.478255 43.558374,3.47778 43.558858,3.478042 43.558975,3.477736 43.559345,3.479058 43.56,3.479471 43.560179,3.480033 43.560397,3.480697 43.559058,3.480871 43.559186,3.480923 43.559332,3.481169 43.559504,3.48155 43.559729,3.48169 43.559845,3.482274 43.560202,3.482817 43.56061,3.483041 43.560846,3.483519 43.561194,3.483676 43.56128,3.484034 43.561533,3.483829 43.561685,3.483836 43.561923,3.484288 43.562054,3.48499 43.56221,3.485349 43.562273,3.485894 43.562431,3.486481 43.56264,3.487039 43.562943,3.487339 43.563001,3.488023 43.563189,3.488104 43.563134,3.488492 43.563033,3.488927 43.562976,3.48966 43.562804,3.489964 43.562785,3.490441 43.562838,3.49106 43.562869,3.491692 43.562939,3.491885 43.562979,3.492396 43.563127,3.492835 43.563277,3.493326 43.563353,3.493954 43.563417,3.494168 43.563461,3.495079 43.563686,3.495895 43.56238,3.496535 43.562456,3.49783 43.560976,3.498621 43.560016,3.498311 43.560002,3.49875 43.559533,3.499192 43.558958,3.499858 43.559187,3.501146 43.558516,3.501296 43.558399,3.501691 43.558584,3.502145 43.558028,3.502351 43.557794,3.502794 43.557369,3.503114 43.557017,3.503201 43.556834,3.503314 43.55675,3.5036 43.556367,3.503844 43.555994,3.504134 43.555779,3.504946 43.555636,3.50507 43.555633,3.505282 43.555763,3.505418 43.555986,3.505387 43.556383,3.505468 43.556884,3.505562 43.55707,3.505733 43.557311,3.505874 43.557599,3.505958 43.55799,3.506113 43.558341,3.506595 43.558515,3.506731 43.5586,3.506944 43.558842,3.507147 43.558993,3.50736 43.559213,3.507424 43.559419,3.507416 43.559805,3.507359 43.560042,3.507449 43.560323,3.507591 43.560514,3.50802 43.56068,3.508541 43.561024,3.508652 43.561146,3.508675 43.561555,3.508883 43.562146,3.509132 43.562583,3.509166 43.562516,3.509088 43.562283,3.509058 43.561893,3.509133 43.561645,3.509318 43.561226,3.509698 43.560112,3.509769 43.559862,3.509969 43.559273,3.510122 43.558936,3.510566 43.558345,3.510793 43.558122,3.511156 43.557801,3.511052 43.557647,3.510955 43.557324,3.51092 43.557042,3.510852 43.556862,3.51092 43.556745,3.511132 43.556715,3.511891 43.556555,3.512577 43.556377,3.512894 43.556335,3.513787 43.556121,3.515052 43.555808,3.515524 43.555638,3.515816 43.55551,3.516311 43.555217,3.516721 43.554923,3.516959 43.554705,3.517023 43.554279,3.51712 43.554062,3.517466 43.553721,3.517565 43.553588,3.517903 43.553349,3.518038 43.55322,3.518269 43.552909,3.518509 43.552627,3.518849 43.552155,3.519068 43.551997,3.519799 43.551717,3.520292 43.551561,3.520651 43.551326,3.521046 43.551091,3.522365 43.550531,3.52129 43.54944,3.521157 43.549236,3.521111 43.549067,3.520971 43.548165,3.520863 43.547835,3.520794 43.547455,3.520643 43.547114,3.520545 43.546572,3.520499 43.546225,3.520417 43.54595,3.520352 43.54584)))', 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),
        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(((3.520352 43.54584,3.51964 43.545765,3.519295 43.545779,3.518855 43.545872,3.518539 43.546039,3.518316 43.546046,3.517638 43.546032,3.517466 43.546016,3.516885 43.54602,3.516462 43.545928,3.516045 43.545906,3.515433 43.545895,3.515184 43.545918,3.514731 43.546014,3.51449 43.546044,3.514207 43.546045,3.513837 43.545997,3.513066 43.545857,3.512629 43.545809,3.512264 43.54582,3.511934 43.54601,3.511722 43.546175,3.511594 43.546379,3.511478 43.546625,3.511085 43.547054,3.510918 43.547178,3.510544 43.547383,3.510288 43.547449,3.51011 43.547428,3.50979 43.547157,3.509561 43.547127,3.50919 43.547171,3.508708 43.547275,3.508407 43.547269,3.507657 43.547092,3.507253 43.54708,3.506729 43.547129,3.506428 43.547215,3.506043 43.547158,3.505763 43.547161,3.505576 43.54712,3.505333 43.546993,3.504904 43.546922,3.504485 43.546955,3.503865 43.547076,3.503232 43.547068,3.502892 43.547094,3.502417 43.547101,3.501533 43.547197,3.501141 43.547353,3.500858 43.547328,3.500576 43.547334,3.500281 43.547478,3.499846 43.547582,3.499282 43.547638,3.498848 43.547754,3.498216 43.548131,3.497907 43.548353,3.497672 43.548553,3.497457 43.548599,3.497274 43.548561,3.496858 43.548554,3.496556 43.548487,3.496374 43.548265,3.496175 43.548154,3.495999 43.548117,3.49576 43.548182,3.495415 43.548338,3.495145 43.548336,3.494302 43.548171,3.494152 43.548176,3.494015 43.5481,3.493619 43.548035,3.493348 43.548084,3.493182 43.548155,3.492953 43.548312,3.492839 43.548323,3.492641 43.548237,3.492006 43.54809,3.491479 43.548012,3.491061 43.547972,3.490711 43.547997,3.49022 43.548131,3.48984 43.548161,3.489287 43.548062,3.489031 43.548075,3.488473 43.548142,3.488007 43.548293,3.487664 43.548295,3.487301 43.548228,3.486941 43.548262,3.486724 43.548402,3.486584 43.548613,3.48653 43.548828,3.48636 43.548896,3.485883 43.548978,3.485397 43.549148,3.485268 43.549523,3.485274 43.549667,3.4852 43.549768,3.48474 43.55004,3.484561 43.550122,3.484392 43.550128,3.48426 43.549993,3.484062 43.549715,3.48383 43.549503,3.483623 43.549466,3.483434 43.549592,3.483364 43.549818,3.483151 43.550219,3.483031 43.550377,3.482934 43.550437,3.482182 43.550773,3.482613 43.551414,3.483133 43.551793,3.484128 43.552646,3.48497 43.553347,3.484453 43.553769,3.484332 43.554144,3.483184 43.554715,3.482981 43.554825,3.481764 43.554843,3.481556 43.554835,3.480541 43.554843,3.4803 43.554815,3.480215 43.555008,3.480127 43.554989,3.48004 43.555295,3.479983 43.555681,3.479715 43.556755,3.47905 43.557482,3.478561 43.557973,3.478255 43.558374,3.47778 43.558858,3.478042 43.558975,3.477736 43.559345,3.479058 43.56,3.479471 43.560179,3.480033 43.560397,3.480697 43.559058,3.480871 43.559186,3.480923 43.559332,3.481169 43.559504,3.48155 43.559729,3.48169 43.559845,3.482274 43.560202,3.482817 43.56061,3.483041 43.560846,3.483519 43.561194,3.483676 43.56128,3.484034 43.561533,3.483829 43.561685,3.483836 43.561923,3.484288 43.562054,3.48499 43.56221,3.485349 43.562273,3.485894 43.562431,3.486481 43.56264,3.487039 43.562943,3.487339 43.563001,3.488023 43.563189,3.488104 43.563134,3.488492 43.563033,3.488927 43.562976,3.48966 43.562804,3.489964 43.562785,3.490441 43.562838,3.49106 43.562869,3.491692 43.562939,3.491885 43.562979,3.492396 43.563127,3.492835 43.563277,3.493326 43.563353,3.493954 43.563417,3.494168 43.563461,3.495079 43.563686,3.495895 43.56238,3.496535 43.562456,3.49783 43.560976,3.498621 43.560016,3.498311 43.560002,3.49875 43.559533,3.499192 43.558958,3.499858 43.559187,3.501146 43.558516,3.501296 43.558399,3.501691 43.558584,3.502145 43.558028,3.502351 43.557794,3.502794 43.557369,3.503114 43.557017,3.503201 43.556834,3.503314 43.55675,3.5036 43.556367,3.503844 43.555994,3.504134 43.555779,3.504946 43.555636,3.50507 43.555633,3.505282 43.555763,3.505418 43.555986,3.505387 43.556383,3.505468 43.556884,3.505562 43.55707,3.505733 43.557311,3.505874 43.557599,3.505958 43.55799,3.506113 43.558341,3.506595 43.558515,3.506731 43.5586,3.506944 43.558842,3.507147 43.558993,3.50736 43.559213,3.507424 43.559419,3.507416 43.559805,3.507359 43.560042,3.507449 43.560323,3.507591 43.560514,3.50802 43.56068,3.508541 43.561024,3.508652 43.561146,3.508675 43.561555,3.508883 43.562146,3.509132 43.562583,3.509166 43.562516,3.509088 43.562283,3.509058 43.561893,3.509133 43.561645,3.509318 43.561226,3.509698 43.560112,3.509769 43.559862,3.509969 43.559273,3.510122 43.558936,3.510566 43.558345,3.510793 43.558122,3.511156 43.557801,3.511052 43.557647,3.510955 43.557324,3.51092 43.557042,3.510852 43.556862,3.51092 43.556745,3.511132 43.556715,3.511891 43.556555,3.512577 43.556377,3.512894 43.556335,3.513787 43.556121,3.515052 43.555808,3.515524 43.555638,3.515816 43.55551,3.516311 43.555217,3.516721 43.554923,3.516959 43.554705,3.517023 43.554279,3.51712 43.554062,3.517466 43.553721,3.517565 43.553588,3.517903 43.553349,3.518038 43.55322,3.518269 43.552909,3.518509 43.552627,3.518849 43.552155,3.519068 43.551997,3.519799 43.551717,3.520292 43.551561,3.520651 43.551326,3.521046 43.551091,3.522365 43.550531,3.52129 43.54944,3.521157 43.549236,3.521111 43.549067,3.520971 43.548165,3.520863 43.547835,3.520794 43.547455,3.520643 43.547114,3.520545 43.546572,3.520499 43.546225,3.520417 43.54595,3.520352 43.54584)))'') 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(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(((3.520352 43.54584,3.51964 43.545765,3.519295 43.545779,3.518855 43.545872,3.518539 43.546039,3.518316 43.546046,3.517638 43.546032,3.517466 43.546016,3.516885 43.54602,3.516462 43.545928,3.516045 43.545906,3.515433 43.545895,3.515184 43.545918,3.514731 43.546014,3.51449 43.546044,3.514207 43.546045,3.513837 43.545997,3.513066 43.545857,3.512629 43.545809,3.512264 43.54582,3.511934 43.54601,3.511722 43.546175,3.511594 43.546379,3.511478 43.546625,3.511085 43.547054,3.510918 43.547178,3.510544 43.547383,3.510288 43.547449,3.51011 43.547428,3.50979 43.547157,3.509561 43.547127,3.50919 43.547171,3.508708 43.547275,3.508407 43.547269,3.507657 43.547092,3.507253 43.54708,3.506729 43.547129,3.506428 43.547215,3.506043 43.547158,3.505763 43.547161,3.505576 43.54712,3.505333 43.546993,3.504904 43.546922,3.504485 43.546955,3.503865 43.547076,3.503232 43.547068,3.502892 43.547094,3.502417 43.547101,3.501533 43.547197,3.501141 43.547353,3.500858 43.547328,3.500576 43.547334,3.500281 43.547478,3.499846 43.547582,3.499282 43.547638,3.498848 43.547754,3.498216 43.548131,3.497907 43.548353,3.497672 43.548553,3.497457 43.548599,3.497274 43.548561,3.496858 43.548554,3.496556 43.548487,3.496374 43.548265,3.496175 43.548154,3.495999 43.548117,3.49576 43.548182,3.495415 43.548338,3.495145 43.548336,3.494302 43.548171,3.494152 43.548176,3.494015 43.5481,3.493619 43.548035,3.493348 43.548084,3.493182 43.548155,3.492953 43.548312,3.492839 43.548323,3.492641 43.548237,3.492006 43.54809,3.491479 43.548012,3.491061 43.547972,3.490711 43.547997,3.49022 43.548131,3.48984 43.548161,3.489287 43.548062,3.489031 43.548075,3.488473 43.548142,3.488007 43.548293,3.487664 43.548295,3.487301 43.548228,3.486941 43.548262,3.486724 43.548402,3.486584 43.548613,3.48653 43.548828,3.48636 43.548896,3.485883 43.548978,3.485397 43.549148,3.485268 43.549523,3.485274 43.549667,3.4852 43.549768,3.48474 43.55004,3.484561 43.550122,3.484392 43.550128,3.48426 43.549993,3.484062 43.549715,3.48383 43.549503,3.483623 43.549466,3.483434 43.549592,3.483364 43.549818,3.483151 43.550219,3.483031 43.550377,3.482934 43.550437,3.482182 43.550773,3.482613 43.551414,3.483133 43.551793,3.484128 43.552646,3.48497 43.553347,3.484453 43.553769,3.484332 43.554144,3.483184 43.554715,3.482981 43.554825,3.481764 43.554843,3.481556 43.554835,3.480541 43.554843,3.4803 43.554815,3.480215 43.555008,3.480127 43.554989,3.48004 43.555295,3.479983 43.555681,3.479715 43.556755,3.47905 43.557482,3.478561 43.557973,3.478255 43.558374,3.47778 43.558858,3.478042 43.558975,3.477736 43.559345,3.479058 43.56,3.479471 43.560179,3.480033 43.560397,3.480697 43.559058,3.480871 43.559186,3.480923 43.559332,3.481169 43.559504,3.48155 43.559729,3.48169 43.559845,3.482274 43.560202,3.482817 43.56061,3.483041 43.560846,3.483519 43.561194,3.483676 43.56128,3.484034 43.561533,3.483829 43.561685,3.483836 43.561923,3.484288 43.562054,3.48499 43.56221,3.485349 43.562273,3.485894 43.562431,3.486481 43.56264,3.487039 43.562943,3.487339 43.563001,3.488023 43.563189,3.488104 43.563134,3.488492 43.563033,3.488927 43.562976,3.48966 43.562804,3.489964 43.562785,3.490441 43.562838,3.49106 43.562869,3.491692 43.562939,3.491885 43.562979,3.492396 43.563127,3.492835 43.563277,3.493326 43.563353,3.493954 43.563417,3.494168 43.563461,3.495079 43.563686,3.495895 43.56238,3.496535 43.562456,3.49783 43.560976,3.498621 43.560016,3.498311 43.560002,3.49875 43.559533,3.499192 43.558958,3.499858 43.559187,3.501146 43.558516,3.501296 43.558399,3.501691 43.558584,3.502145 43.558028,3.502351 43.557794,3.502794 43.557369,3.503114 43.557017,3.503201 43.556834,3.503314 43.55675,3.5036 43.556367,3.503844 43.555994,3.504134 43.555779,3.504946 43.555636,3.50507 43.555633,3.505282 43.555763,3.505418 43.555986,3.505387 43.556383,3.505468 43.556884,3.505562 43.55707,3.505733 43.557311,3.505874 43.557599,3.505958 43.55799,3.506113 43.558341,3.506595 43.558515,3.506731 43.5586,3.506944 43.558842,3.507147 43.558993,3.50736 43.559213,3.507424 43.559419,3.507416 43.559805,3.507359 43.560042,3.507449 43.560323,3.507591 43.560514,3.50802 43.56068,3.508541 43.561024,3.508652 43.561146,3.508675 43.561555,3.508883 43.562146,3.509132 43.562583,3.509166 43.562516,3.509088 43.562283,3.509058 43.561893,3.509133 43.561645,3.509318 43.561226,3.509698 43.560112,3.509769 43.559862,3.509969 43.559273,3.510122 43.558936,3.510566 43.558345,3.510793 43.558122,3.511156 43.557801,3.511052 43.557647,3.510955 43.557324,3.51092 43.557042,3.510852 43.556862,3.51092 43.556745,3.511132 43.556715,3.511891 43.556555,3.512577 43.556377,3.512894 43.556335,3.513787 43.556121,3.515052 43.555808,3.515524 43.555638,3.515816 43.55551,3.516311 43.555217,3.516721 43.554923,3.516959 43.554705,3.517023 43.554279,3.51712 43.554062,3.517466 43.553721,3.517565 43.553588,3.517903 43.553349,3.518038 43.55322,3.518269 43.552909,3.518509 43.552627,3.518849 43.552155,3.519068 43.551997,3.519799 43.551717,3.520292 43.551561,3.520651 43.551326,3.521046 43.551091,3.522365 43.550531,3.52129 43.54944,3.521157 43.549236,3.521111 43.549067,3.520971 43.548165,3.520863 43.547835,3.520794 43.547455,3.520643 43.547114,3.520545 43.546572,3.520499 43.546225,3.520417 43.54595,3.520352 43.54584)))'), 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'34029'') = ?
  AND (tags->'admin_level') = '8'
  AND (tags->'boundary') = 'administrative'
ORDER BY ST_Area(geom::geography) DESC NULLS LAST
LIMIT 1;

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
FROM
  osm_object_meta m
WHERE
  geom IS NOT NULL
  AND ST_Intersects(
    m.geom,
    ST_GeomFromText(?, 4326)
  )
  AND osm_type IN ('way', 'relation')
  AND (tags -> 'highway') IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

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
            FROM osm_object_meta m
            WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText('MULTIPOLYGON(((3.520352 43.54584,3.51964 43.545765,3.519295 43.545779,3.518855 43.545872,3.518539 43.546039,3.518316 43.546046,3.517638 43.546032,3.517466 43.546016,3.516885 43.54602,3.516462 43.545928,3.516045 43.545906,3.515433 43.545895,3.515184 43.545918,3.514731 43.546014,3.51449 43.546044,3.514207 43.546045,3.513837 43.545997,3.513066 43.545857,3.512629 43.545809,3.512264 43.54582,3.511934 43.54601,3.511722 43.546175,3.511594 43.546379,3.511478 43.546625,3.511085 43.547054,3.510918 43.547178,3.510544 43.547383,3.510288 43.547449,3.51011 43.547428,3.50979 43.547157,3.509561 43.547127,3.50919 43.547171,3.508708 43.547275,3.508407 43.547269,3.507657 43.547092,3.507253 43.54708,3.506729 43.547129,3.506428 43.547215,3.506043 43.547158,3.505763 43.547161,3.505576 43.54712,3.505333 43.546993,3.504904 43.546922,3.504485 43.546955,3.503865 43.547076,3.503232 43.547068,3.502892 43.547094,3.502417 43.547101,3.501533 43.547197,3.501141 43.547353,3.500858 43.547328,3.500576 43.547334,3.500281 43.547478,3.499846 43.547582,3.499282 43.547638,3.498848 43.547754,3.498216 43.548131,3.497907 43.548353,3.497672 43.548553,3.497457 43.548599,3.497274 43.548561,3.496858 43.548554,3.496556 43.548487,3.496374 43.548265,3.496175 43.548154,3.495999 43.548117,3.49576 43.548182,3.495415 43.548338,3.495145 43.548336,3.494302 43.548171,3.494152 43.548176,3.494015 43.5481,3.493619 43.548035,3.493348 43.548084,3.493182 43.548155,3.492953 43.548312,3.492839 43.548323,3.492641 43.548237,3.492006 43.54809,3.491479 43.548012,3.491061 43.547972,3.490711 43.547997,3.49022 43.548131,3.48984 43.548161,3.489287 43.548062,3.489031 43.548075,3.488473 43.548142,3.488007 43.548293,3.487664 43.548295,3.487301 43.548228,3.486941 43.548262,3.486724 43.548402,3.486584 43.548613,3.48653 43.548828,3.48636 43.548896,3.485883 43.548978,3.485397 43.549148,3.485268 43.549523,3.485274 43.549667,3.4852 43.549768,3.48474 43.55004,3.484561 43.550122,3.484392 43.550128,3.48426 43.549993,3.484062 43.549715,3.48383 43.549503,3.483623 43.549466,3.483434 43.549592,3.483364 43.549818,3.483151 43.550219,3.483031 43.550377,3.482934 43.550437,3.482182 43.550773,3.482613 43.551414,3.483133 43.551793,3.484128 43.552646,3.48497 43.553347,3.484453 43.553769,3.484332 43.554144,3.483184 43.554715,3.482981 43.554825,3.481764 43.554843,3.481556 43.554835,3.480541 43.554843,3.4803 43.554815,3.480215 43.555008,3.480127 43.554989,3.48004 43.555295,3.479983 43.555681,3.479715 43.556755,3.47905 43.557482,3.478561 43.557973,3.478255 43.558374,3.47778 43.558858,3.478042 43.558975,3.477736 43.559345,3.479058 43.56,3.479471 43.560179,3.480033 43.560397,3.480697 43.559058,3.480871 43.559186,3.480923 43.559332,3.481169 43.559504,3.48155 43.559729,3.48169 43.559845,3.482274 43.560202,3.482817 43.56061,3.483041 43.560846,3.483519 43.561194,3.483676 43.56128,3.484034 43.561533,3.483829 43.561685,3.483836 43.561923,3.484288 43.562054,3.48499 43.56221,3.485349 43.562273,3.485894 43.562431,3.486481 43.56264,3.487039 43.562943,3.487339 43.563001,3.488023 43.563189,3.488104 43.563134,3.488492 43.563033,3.488927 43.562976,3.48966 43.562804,3.489964 43.562785,3.490441 43.562838,3.49106 43.562869,3.491692 43.562939,3.491885 43.562979,3.492396 43.563127,3.492835 43.563277,3.493326 43.563353,3.493954 43.563417,3.494168 43.563461,3.495079 43.563686,3.495895 43.56238,3.496535 43.562456,3.49783 43.560976,3.498621 43.560016,3.498311 43.560002,3.49875 43.559533,3.499192 43.558958,3.499858 43.559187,3.501146 43.558516,3.501296 43.558399,3.501691 43.558584,3.502145 43.558028,3.502351 43.557794,3.502794 43.557369,3.503114 43.557017,3.503201 43.556834,3.503314 43.55675,3.5036 43.556367,3.503844 43.555994,3.504134 43.555779,3.504946 43.555636,3.50507 43.555633,3.505282 43.555763,3.505418 43.555986,3.505387 43.556383,3.505468 43.556884,3.505562 43.55707,3.505733 43.557311,3.505874 43.557599,3.505958 43.55799,3.506113 43.558341,3.506595 43.558515,3.506731 43.5586,3.506944 43.558842,3.507147 43.558993,3.50736 43.559213,3.507424 43.559419,3.507416 43.559805,3.507359 43.560042,3.507449 43.560323,3.507591 43.560514,3.50802 43.56068,3.508541 43.561024,3.508652 43.561146,3.508675 43.561555,3.508883 43.562146,3.509132 43.562583,3.509166 43.562516,3.509088 43.562283,3.509058 43.561893,3.509133 43.561645,3.509318 43.561226,3.509698 43.560112,3.509769 43.559862,3.509969 43.559273,3.510122 43.558936,3.510566 43.558345,3.510793 43.558122,3.511156 43.557801,3.511052 43.557647,3.510955 43.557324,3.51092 43.557042,3.510852 43.556862,3.51092 43.556745,3.511132 43.556715,3.511891 43.556555,3.512577 43.556377,3.512894 43.556335,3.513787 43.556121,3.515052 43.555808,3.515524 43.555638,3.515816 43.55551,3.516311 43.555217,3.516721 43.554923,3.516959 43.554705,3.517023 43.554279,3.51712 43.554062,3.517466 43.553721,3.517565 43.553588,3.517903 43.553349,3.518038 43.55322,3.518269 43.552909,3.518509 43.552627,3.518849 43.552155,3.519068 43.551997,3.519799 43.551717,3.520292 43.551561,3.520651 43.551326,3.521046 43.551091,3.522365 43.550531,3.52129 43.54944,3.521157 43.549236,3.521111 43.549067,3.520971 43.548165,3.520863 43.547835,3.520794 43.547455,3.520643 43.547114,3.520545 43.546572,3.520499 43.546225,3.520417 43.54595,3.520352 43.54584)))', 4326))
              AND osm_type IN ('way', 'relation')
              AND (tags->'highway') IN ('motorway','trunk','primary','secondary','tertiary','unclassified','residential','living_street','motorway_link','trunk_link','primary_link','secondary_link','tertiary_link','service','road');

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 -> 'man_made') = 'monitoring_station'
  AND (tags -> 'monitoring:bicycle') = 'yes'

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(((3.520352 43.54584,3.51964 43.545765,3.519295 43.545779,3.518855 43.545872,3.518539 43.546039,3.518316 43.546046,3.517638 43.546032,3.517466 43.546016,3.516885 43.54602,3.516462 43.545928,3.516045 43.545906,3.515433 43.545895,3.515184 43.545918,3.514731 43.546014,3.51449 43.546044,3.514207 43.546045,3.513837 43.545997,3.513066 43.545857,3.512629 43.545809,3.512264 43.54582,3.511934 43.54601,3.511722 43.546175,3.511594 43.546379,3.511478 43.546625,3.511085 43.547054,3.510918 43.547178,3.510544 43.547383,3.510288 43.547449,3.51011 43.547428,3.50979 43.547157,3.509561 43.547127,3.50919 43.547171,3.508708 43.547275,3.508407 43.547269,3.507657 43.547092,3.507253 43.54708,3.506729 43.547129,3.506428 43.547215,3.506043 43.547158,3.505763 43.547161,3.505576 43.54712,3.505333 43.546993,3.504904 43.546922,3.504485 43.546955,3.503865 43.547076,3.503232 43.547068,3.502892 43.547094,3.502417 43.547101,3.501533 43.547197,3.501141 43.547353,3.500858 43.547328,3.500576 43.547334,3.500281 43.547478,3.499846 43.547582,3.499282 43.547638,3.498848 43.547754,3.498216 43.548131,3.497907 43.548353,3.497672 43.548553,3.497457 43.548599,3.497274 43.548561,3.496858 43.548554,3.496556 43.548487,3.496374 43.548265,3.496175 43.548154,3.495999 43.548117,3.49576 43.548182,3.495415 43.548338,3.495145 43.548336,3.494302 43.548171,3.494152 43.548176,3.494015 43.5481,3.493619 43.548035,3.493348 43.548084,3.493182 43.548155,3.492953 43.548312,3.492839 43.548323,3.492641 43.548237,3.492006 43.54809,3.491479 43.548012,3.491061 43.547972,3.490711 43.547997,3.49022 43.548131,3.48984 43.548161,3.489287 43.548062,3.489031 43.548075,3.488473 43.548142,3.488007 43.548293,3.487664 43.548295,3.487301 43.548228,3.486941 43.548262,3.486724 43.548402,3.486584 43.548613,3.48653 43.548828,3.48636 43.548896,3.485883 43.548978,3.485397 43.549148,3.485268 43.549523,3.485274 43.549667,3.4852 43.549768,3.48474 43.55004,3.484561 43.550122,3.484392 43.550128,3.48426 43.549993,3.484062 43.549715,3.48383 43.549503,3.483623 43.549466,3.483434 43.549592,3.483364 43.549818,3.483151 43.550219,3.483031 43.550377,3.482934 43.550437,3.482182 43.550773,3.482613 43.551414,3.483133 43.551793,3.484128 43.552646,3.48497 43.553347,3.484453 43.553769,3.484332 43.554144,3.483184 43.554715,3.482981 43.554825,3.481764 43.554843,3.481556 43.554835,3.480541 43.554843,3.4803 43.554815,3.480215 43.555008,3.480127 43.554989,3.48004 43.555295,3.479983 43.555681,3.479715 43.556755,3.47905 43.557482,3.478561 43.557973,3.478255 43.558374,3.47778 43.558858,3.478042 43.558975,3.477736 43.559345,3.479058 43.56,3.479471 43.560179,3.480033 43.560397,3.480697 43.559058,3.480871 43.559186,3.480923 43.559332,3.481169 43.559504,3.48155 43.559729,3.48169 43.559845,3.482274 43.560202,3.482817 43.56061,3.483041 43.560846,3.483519 43.561194,3.483676 43.56128,3.484034 43.561533,3.483829 43.561685,3.483836 43.561923,3.484288 43.562054,3.48499 43.56221,3.485349 43.562273,3.485894 43.562431,3.486481 43.56264,3.487039 43.562943,3.487339 43.563001,3.488023 43.563189,3.488104 43.563134,3.488492 43.563033,3.488927 43.562976,3.48966 43.562804,3.489964 43.562785,3.490441 43.562838,3.49106 43.562869,3.491692 43.562939,3.491885 43.562979,3.492396 43.563127,3.492835 43.563277,3.493326 43.563353,3.493954 43.563417,3.494168 43.563461,3.495079 43.563686,3.495895 43.56238,3.496535 43.562456,3.49783 43.560976,3.498621 43.560016,3.498311 43.560002,3.49875 43.559533,3.499192 43.558958,3.499858 43.559187,3.501146 43.558516,3.501296 43.558399,3.501691 43.558584,3.502145 43.558028,3.502351 43.557794,3.502794 43.557369,3.503114 43.557017,3.503201 43.556834,3.503314 43.55675,3.5036 43.556367,3.503844 43.555994,3.504134 43.555779,3.504946 43.555636,3.50507 43.555633,3.505282 43.555763,3.505418 43.555986,3.505387 43.556383,3.505468 43.556884,3.505562 43.55707,3.505733 43.557311,3.505874 43.557599,3.505958 43.55799,3.506113 43.558341,3.506595 43.558515,3.506731 43.5586,3.506944 43.558842,3.507147 43.558993,3.50736 43.559213,3.507424 43.559419,3.507416 43.559805,3.507359 43.560042,3.507449 43.560323,3.507591 43.560514,3.50802 43.56068,3.508541 43.561024,3.508652 43.561146,3.508675 43.561555,3.508883 43.562146,3.509132 43.562583,3.509166 43.562516,3.509088 43.562283,3.509058 43.561893,3.509133 43.561645,3.509318 43.561226,3.509698 43.560112,3.509769 43.559862,3.509969 43.559273,3.510122 43.558936,3.510566 43.558345,3.510793 43.558122,3.511156 43.557801,3.511052 43.557647,3.510955 43.557324,3.51092 43.557042,3.510852 43.556862,3.51092 43.556745,3.511132 43.556715,3.511891 43.556555,3.512577 43.556377,3.512894 43.556335,3.513787 43.556121,3.515052 43.555808,3.515524 43.555638,3.515816 43.55551,3.516311 43.555217,3.516721 43.554923,3.516959 43.554705,3.517023 43.554279,3.51712 43.554062,3.517466 43.553721,3.517565 43.553588,3.517903 43.553349,3.518038 43.55322,3.518269 43.552909,3.518509 43.552627,3.518849 43.552155,3.519068 43.551997,3.519799 43.551717,3.520292 43.551561,3.520651 43.551326,3.521046 43.551091,3.522365 43.550531,3.52129 43.54944,3.521157 43.549236,3.521111 43.549067,3.520971 43.548165,3.520863 43.547835,3.520794 43.547455,3.520643 43.547114,3.520545 43.546572,3.520499 43.546225,3.520417 43.54595,3.520352 43.54584)))', 4326))
  AND (tags->'man_made') = 'monitoring_station'
  AND (tags->'monitoring:bicycle') = 'yes';

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 = 'public'
  AND table_name = 'osm_object_history'

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;