Symfony Profiler

[
  "route" => "admin_followup"
  "route_parameters" => [
    "_route" => "admin_followup"
    "_controller" => "App\Controller\FollowUpController::followup"
    "insee_code" => "01026"
  ]
  "request_uri" => "https://osm-commerces.cipherbliss.com/admin/followup/01026"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 0
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\WikiRedirectSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "sf"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET NAMES utf8mb4"
      1000 => true
      "PDO::ATTR_TIMEOUT" => 300
      "PDO::ATTR_PERSISTENT" => false
      "PDO::MYSQL_ATTR_USE_BUFFERED_QUERY" => true
      "PDO::MYSQL_ATTR_INIT_COMMAND" => "SET SESSION wait_timeout=300, interactive_timeout=300"
    ]
    "defaultTableOptions" => []
    "dbname" => "osm_my_commerce"
    "serverVersion" => "15"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.zone AS zone_2, t0.completion_percent AS completion_percent_3, t0.places_count AS places_count_4, t0.avec_horaires AS avec_horaires_5, t0.avec_adresse AS avec_adresse_6, t0.avec_site AS avec_site_7, t0.avec_accessibilite AS avec_accessibilite_8, t0.avec_note AS avec_note_9, t0.name AS name_10, t0.population AS population_11, t0.siren AS siren_12, t0.code_epci AS code_epci_13, t0.codes_postaux AS codes_postaux_14, t0.date_created AS date_created_15, t0.date_modified AS date_modified_16, t0.avec_siret AS avec_siret_17, t0.avec_name AS avec_name_18, t0.avec_email AS avec_email_19, t0.osm_data_date_min AS osm_data_date_min_20, t0.osm_data_date_avg AS osm_data_date_avg_21, t0.osm_data_date_max AS osm_data_date_max_22, t0.budget_annuel AS budget_annuel_23, t0.lat AS lat_24, t0.lon AS lon_25, t0.date_labourage_requested AS date_labourage_requested_26, t0.date_labourage_done AS date_labourage_done_27, t0.kind AS kind_28 FROM stats t0 WHERE t0.zone = ? LIMIT 1"
  "params" => [
    1 => "01026"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "osmpgsql"
    "password" => "<redacted>"
    "driverOptions" => [
      1002 => "SET NAMES utf8mb4"
      "PDO::ATTR_TIMEOUT" => 600
      "PDO::ATTR_PERSISTENT" => false
    ]
    "defaultTableOptions" => []
    "dbname" => "osmpgsql"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?"
  "params" => [
    1 => "public"
    2 => "osm_object_meta"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?"
  "params" => [
    1 => "public"
    2 => "osm_object_history"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
  ]
]

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

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

[
  "sql" => """
    SELECT ST_AsText(ST_Multi(geom)) AS wkt\n
    FROM osm_object_meta m\n
    WHERE osm_type = 'relation'\n
      AND geom IS NOT NULL\n
      AND (tags->'ref:INSEE') = ?\n
      AND (tags->'admin_level') = '8'\n
      AND (tags->'boundary') = 'administrative'\n
    ORDER BY ST_Area(geom::geography) DESC NULLS LAST\n
    LIMIT 1
    """
  "params" => [
    1 => "01026"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = ? AND table_name = ?"
  "params" => [
    1 => "public"
    2 => "osm_object_history"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
  ]
]

[
  "sql" => """
    SELECT ST_AsText(ST_Multi(geom)) AS wkt\n
    FROM (\n
        SELECT DISTINCT ON (h.osm_id)\n
            h.geom\n
        FROM osm_object_history h\n
        WHERE h.osm_type = 'relation'\n
          AND h.visible = true\n
          AND h.geom IS NOT NULL\n
          AND (h.tags->'ref:INSEE') = ?\n
          AND (h.tags->'admin_level') = '8'\n
          AND (h.tags->'boundary') = 'administrative'\n
        ORDER BY h.osm_id, h.version DESC, h.valid_from DESC\n
    ) latest\n
    ORDER BY ST_Area(geom::geography) DESC NULLS LAST\n
    LIMIT 1
    """
  "params" => [
    1 => "01026"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    CREATE TABLE IF NOT EXISTS zone_polygon (\n
                        insee_code TEXT PRIMARY KEY,\n
                        geom geometry(MultiPolygon, 4326) NOT NULL,\n
                        source TEXT NOT NULL,\n
                        updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()\n
                    )
    """
]

[
  "sql" => "CREATE INDEX IF NOT EXISTS zone_polygon_geom_idx ON zone_polygon USING GIST (geom)"
]

[
  "sql" => "SELECT ST_AsText(ST_Multi(geom)) FROM zone_polygon WHERE insee_code = ?"
  "params" => [
    1 => "01026"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT osm_type, osm_id::text AS osm_id, ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,\n
                tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,\n
                CASE WHEN osm_type IN ('way','relation') THEN ST_Area(geom::geography) ELSE NULL END AS area_m2\n
                FROM osm_object_meta m WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
    AND (\n
      (tags->'emergency') = 'fire_hydrant' OR (tags->'amenity') = 'fire_hydrant'\n
      OR (tags->'amenity') = 'charging_station'\n
      OR (tags->'amenity') = 'toilets'\n
      OR (tags->'highway') = 'bus_stop' OR (tags->'public_transport') = 'platform'\n
      OR (tags->'emergency') = 'defibrillator'\n
      OR (tags->'man_made') = 'surveillance'\n
      OR (tags->'amenity') = 'recycling'\n
      OR (tags->'power') = 'substation'\n
      OR exist(tags, 'healthcare')\n
      OR (tags->'amenity') IN ('doctors','pharmacy','hospital','clinic','social_facility')\n
      OR (tags->'healthcare') = 'laboratory'\n
      OR (tags->'amenity') = 'school'\n
      OR (tags->'amenity') = 'police'\n
      OR (tags->'amenity') = 'bicycle_parking'\n
      OR ((tags->'advertising') = 'board' AND (tags->'message') = 'political')\n
      OR exist(tags, 'building')\n
      OR exist(tags, 'ref:FR:RNB')\n
      OR exist(tags, 'email') OR exist(tags, 'contact:email')\n
      OR (tags->'amenity') = 'bench'\n
      OR (tags->'amenity') = 'waste_basket'\n
      OR (tags->'highway') = 'street_lamp'\n
      OR (tags->'amenity') = 'drinking_water'\n
      OR (tags->'natural') = 'tree'\n
      OR (tags->'power') = 'pole'\n
      OR (tags->'man_made') = 'manhole'\n
      OR (tags->'amenity') = 'public_bookcase'\n
      OR (tags->'leisure') = 'playground'\n
      OR (tags->'amenity') = 'restaurant'\n
      OR exist(tags, 'air_conditioning')\n
      OR (tags->'highway') = 'cycleway'\n
      OR (tags->'highway') = 'busway'\n
      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'))\n
      OR (exist(tags, 'highway') AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway') AND exist(tags, 'bicycle') AND (tags->'bicycle') IS NOT NULL AND (tags->'bicycle') <> 'no')\n
      OR (tags->'landuse') = 'construction'\n
      OR (tags->'railway') IN ('station','halt')\n
      OR ((tags->'public_transport') = 'station' AND (tags->'train') = 'yes')\n
      OR (tags->'office') IN ('association','ngo')\n
      OR exist(tags, 'club')\n
      OR (tags->'social_facility') IN ('ngo','outreach')\n
      OR EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k LIKE 'proposed:%')\n
      OR EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k LIKE 'was:%')\n
      OR EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k LIKE 'addr:%')\n
    )
    """
  "params" => [
    1 => "MULTIPOLYGON(((4.926422 46.304434,4.926131 46.30459,4.925908 46.304884,4.925835 46.304918,4.925315 46.304869,4.924961 46.304938,4.92477 46.304896,4.924677 46.30458,4.924574 46.304478,4.924461 46.304463,4.924322 46.30459,4.924136 46.304679,4.923868 46.304895,4.92368 46.304991,4.92313 46.305134,4.922546 46.305698,4.922302 46.305913,4.922363 46.306159,4.922327 46.306386,4.922165 46.306511,4.921882 46.306577,4.921667 46.30674,4.92145 46.30697,4.92109 46.3074,4.920867 46.307753,4.921491 46.307897,4.921884 46.308501,4.921968 46.308538,4.923285 46.308144,4.923887 46.308586,4.92433 46.308983,4.925081 46.309629,4.924197 46.310288,4.924447 46.310418,4.926364 46.310934,4.926455 46.310971,4.926579 46.311428,4.926834 46.312289,4.926848 46.312539,4.926816 46.312669,4.927685 46.312802,4.928366 46.312859,4.92921 46.312881,4.929656 46.312904,4.930455 46.312923,4.931469 46.312911,4.932399 46.312908,4.933115 46.312886,4.933593 46.312946,4.934171 46.313102,4.934505 46.313209,4.934882 46.313264,4.935992 46.313178,4.936726 46.313212,4.937197 46.313167,4.937495 46.313114,4.937909 46.312943,4.938772 46.312473,4.939318 46.312283,4.939803 46.312151,4.940173 46.312071,4.939703 46.311975,4.938547 46.311629,4.93779 46.311015,4.93571 46.310716,4.934896 46.310466,4.934064 46.310264,4.933445 46.310087,4.932429 46.309763,4.932964 46.308554,4.932717 46.30846,4.932911 46.308091,4.932886 46.30778,4.933068 46.307749,4.934096 46.307719,4.934375 46.306981,4.934152 46.306366,4.93403 46.305955,4.934016 46.305779,4.934468 46.305969,4.934602 46.305876,4.934656 46.30577,4.93491 46.304715,4.934893 46.304475,4.934915 46.304266,4.934897 46.303868,4.935098 46.303809,4.935161 46.303535,4.93512 46.30344,4.934904 46.303306,4.934715 46.303047,4.934489 46.302954,4.934118 46.30294,4.933623 46.303092,4.933391 46.303189,4.93258 46.303421,4.931978 46.303378,4.931437 46.303378,4.931127 46.303315,4.930991 46.303224,4.930694 46.303163,4.930306 46.303189,4.929873 46.303147,4.92965 46.303163,4.928815 46.303404,4.928536 46.303512,4.927923 46.303709,4.927388 46.304015,4.927202 46.304099,4.927018 46.304137,4.926644 46.304347,4.926422 46.304434)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid\n
    FROM osm_object_meta m\n
    WHERE geom IS NOT NULL\n
      AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
      AND (\n
           (tags->'emergency') = 'fire_hydrant'\n
        OR (tags->'amenity') = 'fire_hydrant'\n
      )
    """
  "params" => [
    1 => "MULTIPOLYGON(((4.926422 46.304434,4.926131 46.30459,4.925908 46.304884,4.925835 46.304918,4.925315 46.304869,4.924961 46.304938,4.92477 46.304896,4.924677 46.30458,4.924574 46.304478,4.924461 46.304463,4.924322 46.30459,4.924136 46.304679,4.923868 46.304895,4.92368 46.304991,4.92313 46.305134,4.922546 46.305698,4.922302 46.305913,4.922363 46.306159,4.922327 46.306386,4.922165 46.306511,4.921882 46.306577,4.921667 46.30674,4.92145 46.30697,4.92109 46.3074,4.920867 46.307753,4.921491 46.307897,4.921884 46.308501,4.921968 46.308538,4.923285 46.308144,4.923887 46.308586,4.92433 46.308983,4.925081 46.309629,4.924197 46.310288,4.924447 46.310418,4.926364 46.310934,4.926455 46.310971,4.926579 46.311428,4.926834 46.312289,4.926848 46.312539,4.926816 46.312669,4.927685 46.312802,4.928366 46.312859,4.92921 46.312881,4.929656 46.312904,4.930455 46.312923,4.931469 46.312911,4.932399 46.312908,4.933115 46.312886,4.933593 46.312946,4.934171 46.313102,4.934505 46.313209,4.934882 46.313264,4.935992 46.313178,4.936726 46.313212,4.937197 46.313167,4.937495 46.313114,4.937909 46.312943,4.938772 46.312473,4.939318 46.312283,4.939803 46.312151,4.940173 46.312071,4.939703 46.311975,4.938547 46.311629,4.93779 46.311015,4.93571 46.310716,4.934896 46.310466,4.934064 46.310264,4.933445 46.310087,4.932429 46.309763,4.932964 46.308554,4.932717 46.30846,4.932911 46.308091,4.932886 46.30778,4.933068 46.307749,4.934096 46.307719,4.934375 46.306981,4.934152 46.306366,4.93403 46.305955,4.934016 46.305779,4.934468 46.305969,4.934602 46.305876,4.934656 46.30577,4.93491 46.304715,4.934893 46.304475,4.934915 46.304266,4.934897 46.303868,4.935098 46.303809,4.935161 46.303535,4.93512 46.30344,4.934904 46.303306,4.934715 46.303047,4.934489 46.302954,4.934118 46.30294,4.933623 46.303092,4.933391 46.303189,4.93258 46.303421,4.931978 46.303378,4.931437 46.303378,4.931127 46.303315,4.930991 46.303224,4.930694 46.303163,4.930306 46.303189,4.929873 46.303147,4.92965 46.303163,4.928815 46.303404,4.928536 46.303512,4.927923 46.303709,4.927388 46.304015,4.927202 46.304099,4.927018 46.304137,4.926644 46.304347,4.926422 46.304434)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,\n
           CASE WHEN osm_type IN ('way','relation') THEN ST_Area(geom::geography) ELSE NULL END AS area_m2\n
    FROM osm_object_meta m\n
    WHERE geom IS NOT NULL\n
      AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
      AND (tags->'amenity') = 'parking'
    """
  "params" => [
    1 => "MULTIPOLYGON(((4.926422 46.304434,4.926131 46.30459,4.925908 46.304884,4.925835 46.304918,4.925315 46.304869,4.924961 46.304938,4.92477 46.304896,4.924677 46.30458,4.924574 46.304478,4.924461 46.304463,4.924322 46.30459,4.924136 46.304679,4.923868 46.304895,4.92368 46.304991,4.92313 46.305134,4.922546 46.305698,4.922302 46.305913,4.922363 46.306159,4.922327 46.306386,4.922165 46.306511,4.921882 46.306577,4.921667 46.30674,4.92145 46.30697,4.92109 46.3074,4.920867 46.307753,4.921491 46.307897,4.921884 46.308501,4.921968 46.308538,4.923285 46.308144,4.923887 46.308586,4.92433 46.308983,4.925081 46.309629,4.924197 46.310288,4.924447 46.310418,4.926364 46.310934,4.926455 46.310971,4.926579 46.311428,4.926834 46.312289,4.926848 46.312539,4.926816 46.312669,4.927685 46.312802,4.928366 46.312859,4.92921 46.312881,4.929656 46.312904,4.930455 46.312923,4.931469 46.312911,4.932399 46.312908,4.933115 46.312886,4.933593 46.312946,4.934171 46.313102,4.934505 46.313209,4.934882 46.313264,4.935992 46.313178,4.936726 46.313212,4.937197 46.313167,4.937495 46.313114,4.937909 46.312943,4.938772 46.312473,4.939318 46.312283,4.939803 46.312151,4.940173 46.312071,4.939703 46.311975,4.938547 46.311629,4.93779 46.311015,4.93571 46.310716,4.934896 46.310466,4.934064 46.310264,4.933445 46.310087,4.932429 46.309763,4.932964 46.308554,4.932717 46.30846,4.932911 46.308091,4.932886 46.30778,4.933068 46.307749,4.934096 46.307719,4.934375 46.306981,4.934152 46.306366,4.93403 46.305955,4.934016 46.305779,4.934468 46.305969,4.934602 46.305876,4.934656 46.30577,4.93491 46.304715,4.934893 46.304475,4.934915 46.304266,4.934897 46.303868,4.935098 46.303809,4.935161 46.303535,4.93512 46.30344,4.934904 46.303306,4.934715 46.303047,4.934489 46.302954,4.934118 46.30294,4.933623 46.303092,4.933391 46.303189,4.93258 46.303421,4.931978 46.303378,4.931437 46.303378,4.931127 46.303315,4.930991 46.303224,4.930694 46.303163,4.930306 46.303189,4.929873 46.303147,4.92965 46.303163,4.928815 46.303404,4.928536 46.303512,4.927923 46.303709,4.927388 46.304015,4.927202 46.304099,4.927018 46.304137,4.926644 46.304347,4.926422 46.304434)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    \n
    SELECT\n
      COALESCE(SUM(CASE\n
        WHEN (tags->'highway') IN ('cycleway', 'busway') THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0)\n
        WHEN (tags->'cycleway:both') IN ('track', 'opposite_track', 'separate')\n
         AND NOT ((tags->'highway') = 'proposed' AND exist(tags, 'proposed') AND (tags->'proposed') = 'cycleway')\n
         AND exist(tags, 'highway')\n
         AND (tags->'highway') IS NOT NULL\n
         AND (tags->'highway') NOT IN ('cycleway', 'busway')\n
        THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0)\n
        ELSE 0 END), 0) / 1000.0 AS separated_km,\n
      COALESCE(SUM(CASE\n
        WHEN EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%')\n
         AND NOT ((tags->'highway') = 'proposed' AND exist(tags, 'proposed') AND (tags->'proposed') = 'cycleway')\n
         AND exist(tags, 'highway')\n
         AND (tags->'highway') IS NOT NULL\n
         AND (tags->'highway') NOT IN ('cycleway', 'busway')\n
         AND NOT ((tags->'cycleway:both') IN ('track', 'opposite_track', 'separate'))\n
        THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS lane_km,\n
      COALESCE(SUM(CASE\n
        WHEN (exist(tags, 'bicycle') AND (tags->'bicycle') IS NOT NULL AND (tags->'bicycle') <> 'no')\n
         AND NOT ((tags->'highway') = 'proposed' AND exist(tags, 'proposed') AND (tags->'proposed') = 'cycleway')\n
         AND exist(tags, 'highway')\n
         AND (tags->'highway') IS NOT NULL\n
         AND (tags->'highway') NOT IN ('cycleway', 'busway')\n
         AND NOT (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%'))\n
        THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS designated_km,\n
      COALESCE(SUM(CASE\n
        WHEN (tags->'highway') = 'proposed' AND exist(tags, 'proposed') AND (tags->'proposed') = 'cycleway'\n
        THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS proposed_cycleway_km\n
    FROM osm_object_meta m\n
    CROSS JOIN (SELECT ST_MakeValid(ST_SetSRID(ST_GeomFromText(?), 4326)) AS poly) z\n
    WHERE m.geom IS NOT NULL\n
      AND m.osm_type IN ('way', 'relation')\n
      AND ST_Intersects(m.geom, z.poly)\n
      AND (\n
        (tags->'highway') = 'proposed' AND exist(tags, 'proposed') AND (tags->'proposed') = 'cycleway'\n
        OR (tags->'highway') IN ('cycleway', 'busway')\n
        OR (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%') AND exist(tags, 'highway'))\n
        OR ((exist(tags, 'bicycle') AND (tags->'bicycle') IS NOT NULL AND (tags->'bicycle') <> 'no') AND exist(tags, 'highway'))\n
      )\n
    """
  "params" => [
    1 => "MULTIPOLYGON(((4.926422 46.304434,4.926131 46.30459,4.925908 46.304884,4.925835 46.304918,4.925315 46.304869,4.924961 46.304938,4.92477 46.304896,4.924677 46.30458,4.924574 46.304478,4.924461 46.304463,4.924322 46.30459,4.924136 46.304679,4.923868 46.304895,4.92368 46.304991,4.92313 46.305134,4.922546 46.305698,4.922302 46.305913,4.922363 46.306159,4.922327 46.306386,4.922165 46.306511,4.921882 46.306577,4.921667 46.30674,4.92145 46.30697,4.92109 46.3074,4.920867 46.307753,4.921491 46.307897,4.921884 46.308501,4.921968 46.308538,4.923285 46.308144,4.923887 46.308586,4.92433 46.308983,4.925081 46.309629,4.924197 46.310288,4.924447 46.310418,4.926364 46.310934,4.926455 46.310971,4.926579 46.311428,4.926834 46.312289,4.926848 46.312539,4.926816 46.312669,4.927685 46.312802,4.928366 46.312859,4.92921 46.312881,4.929656 46.312904,4.930455 46.312923,4.931469 46.312911,4.932399 46.312908,4.933115 46.312886,4.933593 46.312946,4.934171 46.313102,4.934505 46.313209,4.934882 46.313264,4.935992 46.313178,4.936726 46.313212,4.937197 46.313167,4.937495 46.313114,4.937909 46.312943,4.938772 46.312473,4.939318 46.312283,4.939803 46.312151,4.940173 46.312071,4.939703 46.311975,4.938547 46.311629,4.93779 46.311015,4.93571 46.310716,4.934896 46.310466,4.934064 46.310264,4.933445 46.310087,4.932429 46.309763,4.932964 46.308554,4.932717 46.30846,4.932911 46.308091,4.932886 46.30778,4.933068 46.307749,4.934096 46.307719,4.934375 46.306981,4.934152 46.306366,4.93403 46.305955,4.934016 46.305779,4.934468 46.305969,4.934602 46.305876,4.934656 46.30577,4.93491 46.304715,4.934893 46.304475,4.934915 46.304266,4.934897 46.303868,4.935098 46.303809,4.935161 46.303535,4.93512 46.30344,4.934904 46.303306,4.934715 46.303047,4.934489 46.302954,4.934118 46.30294,4.933623 46.303092,4.933391 46.303189,4.93258 46.303421,4.931978 46.303378,4.931437 46.303378,4.931127 46.303315,4.930991 46.303224,4.930694 46.303163,4.930306 46.303189,4.929873 46.303147,4.92965 46.303163,4.928815 46.303404,4.928536 46.303512,4.927923 46.303709,4.927388 46.304015,4.927202 46.304099,4.927018 46.304137,4.926644 46.304347,4.926422 46.304434)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    \n
    SELECT COALESCE(SUM(COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0)), 0) / 1000.0 AS km\n
    FROM osm_object_meta m\n
    CROSS JOIN (SELECT ST_MakeValid(ST_SetSRID(ST_GeomFromText(?), 4326)) AS poly) z\n
    WHERE m.geom IS NOT NULL\n
      AND m.osm_type IN ('way', 'relation')\n
      AND ST_Intersects(m.geom, z.poly)\n
      AND exist(tags, 'highway')\n
      AND (tags->'highway') NOT IN (\n
        'motorway', 'motorway_link', 'trunk', 'trunk_link',\n
        'footway', 'steps', 'pedestrian', 'bridleway', 'raceway',\n
        'cycleway', 'busway', 'construction', 'proposed'\n
      )\n
      AND (tags->'oneway') IN ('yes', '-1', '1')\n
      AND NOT ( (tags->'highway') IN ('cycleway', 'busway')\n
        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'))\n
        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:%'))))\n
      AND NOT ((tags->'oneway:bicycle') = 'no')\n
    """
  "params" => [
    1 => "MULTIPOLYGON(((4.926422 46.304434,4.926131 46.30459,4.925908 46.304884,4.925835 46.304918,4.925315 46.304869,4.924961 46.304938,4.92477 46.304896,4.924677 46.30458,4.924574 46.304478,4.924461 46.304463,4.924322 46.30459,4.924136 46.304679,4.923868 46.304895,4.92368 46.304991,4.92313 46.305134,4.922546 46.305698,4.922302 46.305913,4.922363 46.306159,4.922327 46.306386,4.922165 46.306511,4.921882 46.306577,4.921667 46.30674,4.92145 46.30697,4.92109 46.3074,4.920867 46.307753,4.921491 46.307897,4.921884 46.308501,4.921968 46.308538,4.923285 46.308144,4.923887 46.308586,4.92433 46.308983,4.925081 46.309629,4.924197 46.310288,4.924447 46.310418,4.926364 46.310934,4.926455 46.310971,4.926579 46.311428,4.926834 46.312289,4.926848 46.312539,4.926816 46.312669,4.927685 46.312802,4.928366 46.312859,4.92921 46.312881,4.929656 46.312904,4.930455 46.312923,4.931469 46.312911,4.932399 46.312908,4.933115 46.312886,4.933593 46.312946,4.934171 46.313102,4.934505 46.313209,4.934882 46.313264,4.935992 46.313178,4.936726 46.313212,4.937197 46.313167,4.937495 46.313114,4.937909 46.312943,4.938772 46.312473,4.939318 46.312283,4.939803 46.312151,4.940173 46.312071,4.939703 46.311975,4.938547 46.311629,4.93779 46.311015,4.93571 46.310716,4.934896 46.310466,4.934064 46.310264,4.933445 46.310087,4.932429 46.309763,4.932964 46.308554,4.932717 46.30846,4.932911 46.308091,4.932886 46.30778,4.933068 46.307749,4.934096 46.307719,4.934375 46.306981,4.934152 46.306366,4.93403 46.305955,4.934016 46.305779,4.934468 46.305969,4.934602 46.305876,4.934656 46.30577,4.93491 46.304715,4.934893 46.304475,4.934915 46.304266,4.934897 46.303868,4.935098 46.303809,4.935161 46.303535,4.93512 46.30344,4.934904 46.303306,4.934715 46.303047,4.934489 46.302954,4.934118 46.30294,4.933623 46.303092,4.933391 46.303189,4.93258 46.303421,4.931978 46.303378,4.931437 46.303378,4.931127 46.303315,4.930991 46.303224,4.930694 46.303163,4.930306 46.303189,4.929873 46.303147,4.92965 46.303163,4.928815 46.303404,4.928536 46.303512,4.927923 46.303709,4.927388 46.304015,4.927202 46.304099,4.927018 46.304137,4.926644 46.304347,4.926422 46.304434)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid\n
    FROM osm_object_meta m\n
    WHERE geom IS NOT NULL\n
      AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
      AND (tags->'man_made') = 'monitoring_station'\n
      AND (tags->'monitoring:bicycle') = 'yes'
    """
  "params" => [
    1 => "MULTIPOLYGON(((4.926422 46.304434,4.926131 46.30459,4.925908 46.304884,4.925835 46.304918,4.925315 46.304869,4.924961 46.304938,4.92477 46.304896,4.924677 46.30458,4.924574 46.304478,4.924461 46.304463,4.924322 46.30459,4.924136 46.304679,4.923868 46.304895,4.92368 46.304991,4.92313 46.305134,4.922546 46.305698,4.922302 46.305913,4.922363 46.306159,4.922327 46.306386,4.922165 46.306511,4.921882 46.306577,4.921667 46.30674,4.92145 46.30697,4.92109 46.3074,4.920867 46.307753,4.921491 46.307897,4.921884 46.308501,4.921968 46.308538,4.923285 46.308144,4.923887 46.308586,4.92433 46.308983,4.925081 46.309629,4.924197 46.310288,4.924447 46.310418,4.926364 46.310934,4.926455 46.310971,4.926579 46.311428,4.926834 46.312289,4.926848 46.312539,4.926816 46.312669,4.927685 46.312802,4.928366 46.312859,4.92921 46.312881,4.929656 46.312904,4.930455 46.312923,4.931469 46.312911,4.932399 46.312908,4.933115 46.312886,4.933593 46.312946,4.934171 46.313102,4.934505 46.313209,4.934882 46.313264,4.935992 46.313178,4.936726 46.313212,4.937197 46.313167,4.937495 46.313114,4.937909 46.312943,4.938772 46.312473,4.939318 46.312283,4.939803 46.312151,4.940173 46.312071,4.939703 46.311975,4.938547 46.311629,4.93779 46.311015,4.93571 46.310716,4.934896 46.310466,4.934064 46.310264,4.933445 46.310087,4.932429 46.309763,4.932964 46.308554,4.932717 46.30846,4.932911 46.308091,4.932886 46.30778,4.933068 46.307749,4.934096 46.307719,4.934375 46.306981,4.934152 46.306366,4.93403 46.305955,4.934016 46.305779,4.934468 46.305969,4.934602 46.305876,4.934656 46.30577,4.93491 46.304715,4.934893 46.304475,4.934915 46.304266,4.934897 46.303868,4.935098 46.303809,4.935161 46.303535,4.93512 46.30344,4.934904 46.303306,4.934715 46.303047,4.934489 46.302954,4.934118 46.30294,4.933623 46.303092,4.933391 46.303189,4.93258 46.303421,4.931978 46.303378,4.931437 46.303378,4.931127 46.303315,4.930991 46.303224,4.930694 46.303163,4.930306 46.303189,4.929873 46.303147,4.92965 46.303163,4.928815 46.303404,4.928536 46.303512,4.927923 46.303709,4.927388 46.304015,4.927202 46.304099,4.927018 46.304137,4.926644 46.304347,4.926422 46.304434)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    SELECT\n
      COALESCE(SUM(CASE WHEN exist(tags, 'highway') THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS total_km,\n
      COALESCE(SUM(CASE WHEN (tags->'highway') = 'primary' THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS primary_km,\n
      COALESCE(SUM(CASE WHEN (tags->'highway') = 'secondary' THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS secondary_km,\n
      COALESCE(SUM(CASE WHEN (tags->'highway') = 'tertiary' THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS tertiary_km,\n
      COALESCE(SUM(CASE WHEN (tags->'highway') = 'residential' THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS residential_km,\n
      COALESCE(SUM(CASE WHEN (tags->'highway') = 'unclassified' THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS unclassified_km,\n
      COALESCE(SUM(CASE WHEN (tags->'highway') = 'service' THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS service_km,\n
      COALESCE(SUM(CASE WHEN (tags->'highway') = 'cycleway' THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS cycleway_km,\n
      COALESCE(SUM(CASE WHEN (tags->'highway') = 'footway' THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS footway_km,\n
      COALESCE(SUM(CASE WHEN (tags->'railway') = 'rail' THEN COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) ELSE 0 END), 0) / 1000.0 AS rail_km,\n
      COUNT(*) FILTER (WHERE exist(tags, 'highway')) AS highway_count\n
    FROM osm_object_meta m\n
    CROSS JOIN (SELECT ST_MakeValid(ST_SetSRID(ST_GeomFromText(?), 4326)) AS poly) z\n
    WHERE m.geom IS NOT NULL\n
      AND m.osm_type IN ('way', 'relation')\n
      AND ST_Intersects(m.geom, z.poly)\n
      AND (exist(tags, 'highway') OR (tags->'railway') = 'rail')
    """
  "params" => [
    1 => "MULTIPOLYGON(((4.926422 46.304434,4.926131 46.30459,4.925908 46.304884,4.925835 46.304918,4.925315 46.304869,4.924961 46.304938,4.92477 46.304896,4.924677 46.30458,4.924574 46.304478,4.924461 46.304463,4.924322 46.30459,4.924136 46.304679,4.923868 46.304895,4.92368 46.304991,4.92313 46.305134,4.922546 46.305698,4.922302 46.305913,4.922363 46.306159,4.922327 46.306386,4.922165 46.306511,4.921882 46.306577,4.921667 46.30674,4.92145 46.30697,4.92109 46.3074,4.920867 46.307753,4.921491 46.307897,4.921884 46.308501,4.921968 46.308538,4.923285 46.308144,4.923887 46.308586,4.92433 46.308983,4.925081 46.309629,4.924197 46.310288,4.924447 46.310418,4.926364 46.310934,4.926455 46.310971,4.926579 46.311428,4.926834 46.312289,4.926848 46.312539,4.926816 46.312669,4.927685 46.312802,4.928366 46.312859,4.92921 46.312881,4.929656 46.312904,4.930455 46.312923,4.931469 46.312911,4.932399 46.312908,4.933115 46.312886,4.933593 46.312946,4.934171 46.313102,4.934505 46.313209,4.934882 46.313264,4.935992 46.313178,4.936726 46.313212,4.937197 46.313167,4.937495 46.313114,4.937909 46.312943,4.938772 46.312473,4.939318 46.312283,4.939803 46.312151,4.940173 46.312071,4.939703 46.311975,4.938547 46.311629,4.93779 46.311015,4.93571 46.310716,4.934896 46.310466,4.934064 46.310264,4.933445 46.310087,4.932429 46.309763,4.932964 46.308554,4.932717 46.30846,4.932911 46.308091,4.932886 46.30778,4.933068 46.307749,4.934096 46.307719,4.934375 46.306981,4.934152 46.306366,4.93403 46.305955,4.934016 46.305779,4.934468 46.305969,4.934602 46.305876,4.934656 46.30577,4.93491 46.304715,4.934893 46.304475,4.934915 46.304266,4.934897 46.303868,4.935098 46.303809,4.935161 46.303535,4.93512 46.30344,4.934904 46.303306,4.934715 46.303047,4.934489 46.302954,4.934118 46.30294,4.933623 46.303092,4.933391 46.303189,4.93258 46.303421,4.931978 46.303378,4.931437 46.303378,4.931127 46.303315,4.930991 46.303224,4.930694 46.303163,4.930306 46.303189,4.929873 46.303147,4.92965 46.303163,4.928815 46.303404,4.928536 46.303512,4.927923 46.303709,4.927388 46.304015,4.927202 46.304099,4.927018 46.304137,4.926644 46.304347,4.926422 46.304434)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,\n
           ST_AsGeoJSON(ST_Force2D(geom), 6, 0) AS geom_geojson,\n
           ST_Length(geom::geography) AS length_m,\n
           (tags->'route') AS route_value\n
    FROM osm_object_meta m\n
    WHERE geom IS NOT NULL\n
      AND osm_type = 'relation'\n
      AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
      AND (tags->'type') = 'route'\n
      AND (tags->'route') IN ('hiking','foot','running','walking','fitness_trail','horse','inline_skates')
    """
  "params" => [
    1 => "MULTIPOLYGON(((4.926422 46.304434,4.926131 46.30459,4.925908 46.304884,4.925835 46.304918,4.925315 46.304869,4.924961 46.304938,4.92477 46.304896,4.924677 46.30458,4.924574 46.304478,4.924461 46.304463,4.924322 46.30459,4.924136 46.304679,4.923868 46.304895,4.92368 46.304991,4.92313 46.305134,4.922546 46.305698,4.922302 46.305913,4.922363 46.306159,4.922327 46.306386,4.922165 46.306511,4.921882 46.306577,4.921667 46.30674,4.92145 46.30697,4.92109 46.3074,4.920867 46.307753,4.921491 46.307897,4.921884 46.308501,4.921968 46.308538,4.923285 46.308144,4.923887 46.308586,4.92433 46.308983,4.925081 46.309629,4.924197 46.310288,4.924447 46.310418,4.926364 46.310934,4.926455 46.310971,4.926579 46.311428,4.926834 46.312289,4.926848 46.312539,4.926816 46.312669,4.927685 46.312802,4.928366 46.312859,4.92921 46.312881,4.929656 46.312904,4.930455 46.312923,4.931469 46.312911,4.932399 46.312908,4.933115 46.312886,4.933593 46.312946,4.934171 46.313102,4.934505 46.313209,4.934882 46.313264,4.935992 46.313178,4.936726 46.313212,4.937197 46.313167,4.937495 46.313114,4.937909 46.312943,4.938772 46.312473,4.939318 46.312283,4.939803 46.312151,4.940173 46.312071,4.939703 46.311975,4.938547 46.311629,4.93779 46.311015,4.93571 46.310716,4.934896 46.310466,4.934064 46.310264,4.933445 46.310087,4.932429 46.309763,4.932964 46.308554,4.932717 46.30846,4.932911 46.308091,4.932886 46.30778,4.933068 46.307749,4.934096 46.307719,4.934375 46.306981,4.934152 46.306366,4.93403 46.305955,4.934016 46.305779,4.934468 46.305969,4.934602 46.305876,4.934656 46.30577,4.93491 46.304715,4.934893 46.304475,4.934915 46.304266,4.934897 46.303868,4.935098 46.303809,4.935161 46.303535,4.93512 46.30344,4.934904 46.303306,4.934715 46.303047,4.934489 46.302954,4.934118 46.30294,4.933623 46.303092,4.933391 46.303189,4.93258 46.303421,4.931978 46.303378,4.931437 46.303378,4.931127 46.303315,4.930991 46.303224,4.930694 46.303163,4.930306 46.303189,4.929873 46.303147,4.92965 46.303163,4.928815 46.303404,4.928536 46.303512,4.927923 46.303709,4.927388 46.304015,4.927202 46.304099,4.927018 46.304137,4.926644 46.304347,4.926422 46.304434)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid\n
    FROM osm_object_meta m\n
    WHERE geom IS NOT NULL\n
      AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
      AND (\n
           exist(tags, 'traffic_sign')\n
        OR (tags->'highway') IN ('traffic_signals','give_way','stop')\n
        OR (tags->'crossing') = 'traffic_signals'\n
        OR exist(tags, 'traffic_calming')\n
        OR (tags->'railway') IN ('level_crossing','crossing')\n
        OR exist(tags, 'maxheight')\n
        OR exist(tags, 'maxwidth')\n
        OR (osm_type IN ('way','relation') AND (\n
            exist(tags, 'maxspeed')\n
         OR (tags->'oneway') = 'yes'\n
        ))\n
      )
    """
  "params" => [
    1 => "MULTIPOLYGON(((4.926422 46.304434,4.926131 46.30459,4.925908 46.304884,4.925835 46.304918,4.925315 46.304869,4.924961 46.304938,4.92477 46.304896,4.924677 46.30458,4.924574 46.304478,4.924461 46.304463,4.924322 46.30459,4.924136 46.304679,4.923868 46.304895,4.92368 46.304991,4.92313 46.305134,4.922546 46.305698,4.922302 46.305913,4.922363 46.306159,4.922327 46.306386,4.922165 46.306511,4.921882 46.306577,4.921667 46.30674,4.92145 46.30697,4.92109 46.3074,4.920867 46.307753,4.921491 46.307897,4.921884 46.308501,4.921968 46.308538,4.923285 46.308144,4.923887 46.308586,4.92433 46.308983,4.925081 46.309629,4.924197 46.310288,4.924447 46.310418,4.926364 46.310934,4.926455 46.310971,4.926579 46.311428,4.926834 46.312289,4.926848 46.312539,4.926816 46.312669,4.927685 46.312802,4.928366 46.312859,4.92921 46.312881,4.929656 46.312904,4.930455 46.312923,4.931469 46.312911,4.932399 46.312908,4.933115 46.312886,4.933593 46.312946,4.934171 46.313102,4.934505 46.313209,4.934882 46.313264,4.935992 46.313178,4.936726 46.313212,4.937197 46.313167,4.937495 46.313114,4.937909 46.312943,4.938772 46.312473,4.939318 46.312283,4.939803 46.312151,4.940173 46.312071,4.939703 46.311975,4.938547 46.311629,4.93779 46.311015,4.93571 46.310716,4.934896 46.310466,4.934064 46.310264,4.933445 46.310087,4.932429 46.309763,4.932964 46.308554,4.932717 46.30846,4.932911 46.308091,4.932886 46.30778,4.933068 46.307749,4.934096 46.307719,4.934375 46.306981,4.934152 46.306366,4.93403 46.305955,4.934016 46.305779,4.934468 46.305969,4.934602 46.305876,4.934656 46.30577,4.93491 46.304715,4.934893 46.304475,4.934915 46.304266,4.934897 46.303868,4.935098 46.303809,4.935161 46.303535,4.93512 46.30344,4.934904 46.303306,4.934715 46.303047,4.934489 46.302954,4.934118 46.30294,4.933623 46.303092,4.933391 46.303189,4.93258 46.303421,4.931978 46.303378,4.931437 46.303378,4.931127 46.303315,4.930991 46.303224,4.930694 46.303163,4.930306 46.303189,4.929873 46.303147,4.92965 46.303163,4.928815 46.303404,4.928536 46.303512,4.927923 46.303709,4.927388 46.304015,4.927202 46.304099,4.927018 46.304137,4.926644 46.304347,4.926422 46.304434)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

[
  "sql" => "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_meta'"
]

[
  "sql" => """
    SELECT osm_type, osm_id::text AS osm_id, ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,\n
                tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid\n
                FROM osm_object_meta m\n
                WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
                AND akeys(tags) && ARRAY['amenity','shop','office','craft','leisure','healthcare','emergency','man_made','power','highway','railway','public_transport','landuse','historic','barrier','tourism','sport','place','waterway','natural','geological','route','military','traffic_sign','traffic_calming','seamark','route_master','water','airway','aerialway','building']::text[]
    """
  "params" => [
    1 => "MULTIPOLYGON(((4.926422 46.304434,4.926131 46.30459,4.925908 46.304884,4.925835 46.304918,4.925315 46.304869,4.924961 46.304938,4.92477 46.304896,4.924677 46.30458,4.924574 46.304478,4.924461 46.304463,4.924322 46.30459,4.924136 46.304679,4.923868 46.304895,4.92368 46.304991,4.92313 46.305134,4.922546 46.305698,4.922302 46.305913,4.922363 46.306159,4.922327 46.306386,4.922165 46.306511,4.921882 46.306577,4.921667 46.30674,4.92145 46.30697,4.92109 46.3074,4.920867 46.307753,4.921491 46.307897,4.921884 46.308501,4.921968 46.308538,4.923285 46.308144,4.923887 46.308586,4.92433 46.308983,4.925081 46.309629,4.924197 46.310288,4.924447 46.310418,4.926364 46.310934,4.926455 46.310971,4.926579 46.311428,4.926834 46.312289,4.926848 46.312539,4.926816 46.312669,4.927685 46.312802,4.928366 46.312859,4.92921 46.312881,4.929656 46.312904,4.930455 46.312923,4.931469 46.312911,4.932399 46.312908,4.933115 46.312886,4.933593 46.312946,4.934171 46.313102,4.934505 46.313209,4.934882 46.313264,4.935992 46.313178,4.936726 46.313212,4.937197 46.313167,4.937495 46.313114,4.937909 46.312943,4.938772 46.312473,4.939318 46.312283,4.939803 46.312151,4.940173 46.312071,4.939703 46.311975,4.938547 46.311629,4.93779 46.311015,4.93571 46.310716,4.934896 46.310466,4.934064 46.310264,4.933445 46.310087,4.932429 46.309763,4.932964 46.308554,4.932717 46.30846,4.932911 46.308091,4.932886 46.30778,4.933068 46.307749,4.934096 46.307719,4.934375 46.306981,4.934152 46.306366,4.93403 46.305955,4.934016 46.305779,4.934468 46.305969,4.934602 46.305876,4.934656 46.30577,4.93491 46.304715,4.934893 46.304475,4.934915 46.304266,4.934897 46.303868,4.935098 46.303809,4.935161 46.303535,4.93512 46.30344,4.934904 46.303306,4.934715 46.303047,4.934489 46.302954,4.934118 46.30294,4.933623 46.303092,4.933391 46.303189,4.93258 46.303421,4.931978 46.303378,4.931437 46.303378,4.931127 46.303315,4.930991 46.303224,4.930694 46.303163,4.930306 46.303189,4.929873 46.303147,4.92965 46.303163,4.928815 46.303404,4.928536 46.303512,4.927923 46.303709,4.927388 46.304015,4.927202 46.304099,4.927018 46.304137,4.926644 46.304347,4.926422 46.304434)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "fire_hydrant_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "fire_hydrant_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "charging_station_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "charging_station_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "toilets_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "toilets_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "bus_stop_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "bus_stop_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "defibrillator_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "defibrillator_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "camera_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "camera_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "recycling_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "recycling_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "substation_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "substation_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "laboratory_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "laboratory_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "school_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "school_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "police_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "police_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "healthcare_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "healthcare_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "bicycle_parking_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "bicycle_parking_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "bicycle_parking_capacity"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "bicycle_parking_capacity_declared"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "bicycle_parking_capacity_estimated_surface"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "car_parking_capacity"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "car_parking_capacity_declared"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "car_parking_capacity_estimated_surface"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "car_parking_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "mobility_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "mobility_completion"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "mobility_separated_km"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "mobility_lane_km"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "mobility_designated_km"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "mobility_proposed_cycleway_km"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "mobility_oneway_dsc_potential_km"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "mobility_bicycle_counter_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO city_follow_up (name, measure, date, stats_id) VALUES (?, ?, ?, ?)"
  "params" => [
    1 => "advertising_board_count"
    2 => 0.0
    3 => "2026-07-12 21:19:10"
    4 => 27087
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#391
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#391}
    3 => Doctrine\DBAL\ParameterType {#391}
    4 => Doctrine\DBAL\ParameterType {#655
      +name: "INTEGER"
    }
  ]
]