Symfony Profiler

[
  "route" => "admin_followup"
  "route_parameters" => [
    "_route" => "admin_followup"
    "_controller" => "App\Controller\FollowUpController::followup"
    "insee_code" => "01183"
  ]
  "request_uri" => "https://osm-commerces.cipherbliss.com/admin/followup/01183"
  "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 => "01183"
  ]
  "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 => "01183"
  ]
  "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 => "01183"
  ]
  "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 => "01183"
  ]
  "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.767408 46.107028,4.768468 46.108025,4.768648 46.10822,4.769377 46.109127,4.76985 46.109703,4.770112 46.110123,4.771074 46.1118,4.771398 46.112408,4.77159 46.113016,4.771685 46.114484,4.771519 46.11545,4.771498 46.116072,4.771722 46.117344,4.771968 46.117871,4.776137 46.116778,4.780863 46.115533,4.783576 46.114825,4.785651 46.114273,4.790605 46.11296,4.791842 46.112681,4.79867 46.111199,4.799048 46.111275,4.799615 46.1113,4.800572 46.111301,4.801675 46.111408,4.802115 46.11146,4.803929 46.111861,4.804864 46.112032,4.805492 46.112232,4.805781 46.112296,4.807444 46.11116,4.807479 46.111148,4.807121 46.10975,4.80608 46.107271,4.80567 46.106337,4.804273 46.105006,4.802641 46.105668,4.802511 46.105627,4.802242 46.105409,4.801994 46.105072,4.801618 46.104645,4.801443 46.104287,4.801248 46.103648,4.801244 46.103401,4.800955 46.103517,4.800657 46.103512,4.800505 46.103404,4.800271 46.103126,4.799733 46.102593,4.799035 46.102833,4.798884 46.102753,4.798661 46.102413,4.797923 46.101437,4.797792 46.101451,4.797166 46.101611,4.796969 46.101699,4.796844 46.101405,4.796715 46.101206,4.796429 46.100887,4.796006 46.101,4.795429 46.101096,4.794692 46.101329,4.794149 46.101603,4.792847 46.10222,4.791946 46.102619,4.791552 46.102765,4.79127 46.102779,4.790998 46.102997,4.790532 46.1031,4.790102 46.103101,4.789887 46.103073,4.78949 46.102945,4.789103 46.102668,4.788772 46.102932,4.788676 46.102946,4.788357 46.102813,4.788258 46.102641,4.788051 46.102177,4.786913 46.102022,4.785941 46.101996,4.786006 46.101839,4.785517 46.100979,4.7855 46.100841,4.785344 46.100799,4.784905 46.100794,4.78449 46.100708,4.784087 46.100571,4.78372 46.100591,4.783261 46.100723,4.781754 46.101128,4.7816 46.101161,4.781123 46.101208,4.778574 46.099884,4.773542 46.098285,4.773178 46.097627,4.772826 46.096959,4.772282 46.096025,4.771603 46.094953,4.77104 46.094114,4.770679 46.094172,4.770071 46.094344,4.769194 46.094963,4.76823 46.095739,4.76739 46.096492,4.766607 46.097176,4.764635 46.09887,4.764379 46.099076,4.764053 46.099398,4.763952 46.09945,4.76182 46.100265,4.760242 46.101058,4.761997 46.102492,4.764261 46.104078,4.767408 46.107028)))"
  ]
  "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.767408 46.107028,4.768468 46.108025,4.768648 46.10822,4.769377 46.109127,4.76985 46.109703,4.770112 46.110123,4.771074 46.1118,4.771398 46.112408,4.77159 46.113016,4.771685 46.114484,4.771519 46.11545,4.771498 46.116072,4.771722 46.117344,4.771968 46.117871,4.776137 46.116778,4.780863 46.115533,4.783576 46.114825,4.785651 46.114273,4.790605 46.11296,4.791842 46.112681,4.79867 46.111199,4.799048 46.111275,4.799615 46.1113,4.800572 46.111301,4.801675 46.111408,4.802115 46.11146,4.803929 46.111861,4.804864 46.112032,4.805492 46.112232,4.805781 46.112296,4.807444 46.11116,4.807479 46.111148,4.807121 46.10975,4.80608 46.107271,4.80567 46.106337,4.804273 46.105006,4.802641 46.105668,4.802511 46.105627,4.802242 46.105409,4.801994 46.105072,4.801618 46.104645,4.801443 46.104287,4.801248 46.103648,4.801244 46.103401,4.800955 46.103517,4.800657 46.103512,4.800505 46.103404,4.800271 46.103126,4.799733 46.102593,4.799035 46.102833,4.798884 46.102753,4.798661 46.102413,4.797923 46.101437,4.797792 46.101451,4.797166 46.101611,4.796969 46.101699,4.796844 46.101405,4.796715 46.101206,4.796429 46.100887,4.796006 46.101,4.795429 46.101096,4.794692 46.101329,4.794149 46.101603,4.792847 46.10222,4.791946 46.102619,4.791552 46.102765,4.79127 46.102779,4.790998 46.102997,4.790532 46.1031,4.790102 46.103101,4.789887 46.103073,4.78949 46.102945,4.789103 46.102668,4.788772 46.102932,4.788676 46.102946,4.788357 46.102813,4.788258 46.102641,4.788051 46.102177,4.786913 46.102022,4.785941 46.101996,4.786006 46.101839,4.785517 46.100979,4.7855 46.100841,4.785344 46.100799,4.784905 46.100794,4.78449 46.100708,4.784087 46.100571,4.78372 46.100591,4.783261 46.100723,4.781754 46.101128,4.7816 46.101161,4.781123 46.101208,4.778574 46.099884,4.773542 46.098285,4.773178 46.097627,4.772826 46.096959,4.772282 46.096025,4.771603 46.094953,4.77104 46.094114,4.770679 46.094172,4.770071 46.094344,4.769194 46.094963,4.76823 46.095739,4.76739 46.096492,4.766607 46.097176,4.764635 46.09887,4.764379 46.099076,4.764053 46.099398,4.763952 46.09945,4.76182 46.100265,4.760242 46.101058,4.761997 46.102492,4.764261 46.104078,4.767408 46.107028)))"
  ]
  "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.767408 46.107028,4.768468 46.108025,4.768648 46.10822,4.769377 46.109127,4.76985 46.109703,4.770112 46.110123,4.771074 46.1118,4.771398 46.112408,4.77159 46.113016,4.771685 46.114484,4.771519 46.11545,4.771498 46.116072,4.771722 46.117344,4.771968 46.117871,4.776137 46.116778,4.780863 46.115533,4.783576 46.114825,4.785651 46.114273,4.790605 46.11296,4.791842 46.112681,4.79867 46.111199,4.799048 46.111275,4.799615 46.1113,4.800572 46.111301,4.801675 46.111408,4.802115 46.11146,4.803929 46.111861,4.804864 46.112032,4.805492 46.112232,4.805781 46.112296,4.807444 46.11116,4.807479 46.111148,4.807121 46.10975,4.80608 46.107271,4.80567 46.106337,4.804273 46.105006,4.802641 46.105668,4.802511 46.105627,4.802242 46.105409,4.801994 46.105072,4.801618 46.104645,4.801443 46.104287,4.801248 46.103648,4.801244 46.103401,4.800955 46.103517,4.800657 46.103512,4.800505 46.103404,4.800271 46.103126,4.799733 46.102593,4.799035 46.102833,4.798884 46.102753,4.798661 46.102413,4.797923 46.101437,4.797792 46.101451,4.797166 46.101611,4.796969 46.101699,4.796844 46.101405,4.796715 46.101206,4.796429 46.100887,4.796006 46.101,4.795429 46.101096,4.794692 46.101329,4.794149 46.101603,4.792847 46.10222,4.791946 46.102619,4.791552 46.102765,4.79127 46.102779,4.790998 46.102997,4.790532 46.1031,4.790102 46.103101,4.789887 46.103073,4.78949 46.102945,4.789103 46.102668,4.788772 46.102932,4.788676 46.102946,4.788357 46.102813,4.788258 46.102641,4.788051 46.102177,4.786913 46.102022,4.785941 46.101996,4.786006 46.101839,4.785517 46.100979,4.7855 46.100841,4.785344 46.100799,4.784905 46.100794,4.78449 46.100708,4.784087 46.100571,4.78372 46.100591,4.783261 46.100723,4.781754 46.101128,4.7816 46.101161,4.781123 46.101208,4.778574 46.099884,4.773542 46.098285,4.773178 46.097627,4.772826 46.096959,4.772282 46.096025,4.771603 46.094953,4.77104 46.094114,4.770679 46.094172,4.770071 46.094344,4.769194 46.094963,4.76823 46.095739,4.76739 46.096492,4.766607 46.097176,4.764635 46.09887,4.764379 46.099076,4.764053 46.099398,4.763952 46.09945,4.76182 46.100265,4.760242 46.101058,4.761997 46.102492,4.764261 46.104078,4.767408 46.107028)))"
  ]
  "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.767408 46.107028,4.768468 46.108025,4.768648 46.10822,4.769377 46.109127,4.76985 46.109703,4.770112 46.110123,4.771074 46.1118,4.771398 46.112408,4.77159 46.113016,4.771685 46.114484,4.771519 46.11545,4.771498 46.116072,4.771722 46.117344,4.771968 46.117871,4.776137 46.116778,4.780863 46.115533,4.783576 46.114825,4.785651 46.114273,4.790605 46.11296,4.791842 46.112681,4.79867 46.111199,4.799048 46.111275,4.799615 46.1113,4.800572 46.111301,4.801675 46.111408,4.802115 46.11146,4.803929 46.111861,4.804864 46.112032,4.805492 46.112232,4.805781 46.112296,4.807444 46.11116,4.807479 46.111148,4.807121 46.10975,4.80608 46.107271,4.80567 46.106337,4.804273 46.105006,4.802641 46.105668,4.802511 46.105627,4.802242 46.105409,4.801994 46.105072,4.801618 46.104645,4.801443 46.104287,4.801248 46.103648,4.801244 46.103401,4.800955 46.103517,4.800657 46.103512,4.800505 46.103404,4.800271 46.103126,4.799733 46.102593,4.799035 46.102833,4.798884 46.102753,4.798661 46.102413,4.797923 46.101437,4.797792 46.101451,4.797166 46.101611,4.796969 46.101699,4.796844 46.101405,4.796715 46.101206,4.796429 46.100887,4.796006 46.101,4.795429 46.101096,4.794692 46.101329,4.794149 46.101603,4.792847 46.10222,4.791946 46.102619,4.791552 46.102765,4.79127 46.102779,4.790998 46.102997,4.790532 46.1031,4.790102 46.103101,4.789887 46.103073,4.78949 46.102945,4.789103 46.102668,4.788772 46.102932,4.788676 46.102946,4.788357 46.102813,4.788258 46.102641,4.788051 46.102177,4.786913 46.102022,4.785941 46.101996,4.786006 46.101839,4.785517 46.100979,4.7855 46.100841,4.785344 46.100799,4.784905 46.100794,4.78449 46.100708,4.784087 46.100571,4.78372 46.100591,4.783261 46.100723,4.781754 46.101128,4.7816 46.101161,4.781123 46.101208,4.778574 46.099884,4.773542 46.098285,4.773178 46.097627,4.772826 46.096959,4.772282 46.096025,4.771603 46.094953,4.77104 46.094114,4.770679 46.094172,4.770071 46.094344,4.769194 46.094963,4.76823 46.095739,4.76739 46.096492,4.766607 46.097176,4.764635 46.09887,4.764379 46.099076,4.764053 46.099398,4.763952 46.09945,4.76182 46.100265,4.760242 46.101058,4.761997 46.102492,4.764261 46.104078,4.767408 46.107028)))"
  ]
  "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.767408 46.107028,4.768468 46.108025,4.768648 46.10822,4.769377 46.109127,4.76985 46.109703,4.770112 46.110123,4.771074 46.1118,4.771398 46.112408,4.77159 46.113016,4.771685 46.114484,4.771519 46.11545,4.771498 46.116072,4.771722 46.117344,4.771968 46.117871,4.776137 46.116778,4.780863 46.115533,4.783576 46.114825,4.785651 46.114273,4.790605 46.11296,4.791842 46.112681,4.79867 46.111199,4.799048 46.111275,4.799615 46.1113,4.800572 46.111301,4.801675 46.111408,4.802115 46.11146,4.803929 46.111861,4.804864 46.112032,4.805492 46.112232,4.805781 46.112296,4.807444 46.11116,4.807479 46.111148,4.807121 46.10975,4.80608 46.107271,4.80567 46.106337,4.804273 46.105006,4.802641 46.105668,4.802511 46.105627,4.802242 46.105409,4.801994 46.105072,4.801618 46.104645,4.801443 46.104287,4.801248 46.103648,4.801244 46.103401,4.800955 46.103517,4.800657 46.103512,4.800505 46.103404,4.800271 46.103126,4.799733 46.102593,4.799035 46.102833,4.798884 46.102753,4.798661 46.102413,4.797923 46.101437,4.797792 46.101451,4.797166 46.101611,4.796969 46.101699,4.796844 46.101405,4.796715 46.101206,4.796429 46.100887,4.796006 46.101,4.795429 46.101096,4.794692 46.101329,4.794149 46.101603,4.792847 46.10222,4.791946 46.102619,4.791552 46.102765,4.79127 46.102779,4.790998 46.102997,4.790532 46.1031,4.790102 46.103101,4.789887 46.103073,4.78949 46.102945,4.789103 46.102668,4.788772 46.102932,4.788676 46.102946,4.788357 46.102813,4.788258 46.102641,4.788051 46.102177,4.786913 46.102022,4.785941 46.101996,4.786006 46.101839,4.785517 46.100979,4.7855 46.100841,4.785344 46.100799,4.784905 46.100794,4.78449 46.100708,4.784087 46.100571,4.78372 46.100591,4.783261 46.100723,4.781754 46.101128,4.7816 46.101161,4.781123 46.101208,4.778574 46.099884,4.773542 46.098285,4.773178 46.097627,4.772826 46.096959,4.772282 46.096025,4.771603 46.094953,4.77104 46.094114,4.770679 46.094172,4.770071 46.094344,4.769194 46.094963,4.76823 46.095739,4.76739 46.096492,4.766607 46.097176,4.764635 46.09887,4.764379 46.099076,4.764053 46.099398,4.763952 46.09945,4.76182 46.100265,4.760242 46.101058,4.761997 46.102492,4.764261 46.104078,4.767408 46.107028)))"
  ]
  "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.767408 46.107028,4.768468 46.108025,4.768648 46.10822,4.769377 46.109127,4.76985 46.109703,4.770112 46.110123,4.771074 46.1118,4.771398 46.112408,4.77159 46.113016,4.771685 46.114484,4.771519 46.11545,4.771498 46.116072,4.771722 46.117344,4.771968 46.117871,4.776137 46.116778,4.780863 46.115533,4.783576 46.114825,4.785651 46.114273,4.790605 46.11296,4.791842 46.112681,4.79867 46.111199,4.799048 46.111275,4.799615 46.1113,4.800572 46.111301,4.801675 46.111408,4.802115 46.11146,4.803929 46.111861,4.804864 46.112032,4.805492 46.112232,4.805781 46.112296,4.807444 46.11116,4.807479 46.111148,4.807121 46.10975,4.80608 46.107271,4.80567 46.106337,4.804273 46.105006,4.802641 46.105668,4.802511 46.105627,4.802242 46.105409,4.801994 46.105072,4.801618 46.104645,4.801443 46.104287,4.801248 46.103648,4.801244 46.103401,4.800955 46.103517,4.800657 46.103512,4.800505 46.103404,4.800271 46.103126,4.799733 46.102593,4.799035 46.102833,4.798884 46.102753,4.798661 46.102413,4.797923 46.101437,4.797792 46.101451,4.797166 46.101611,4.796969 46.101699,4.796844 46.101405,4.796715 46.101206,4.796429 46.100887,4.796006 46.101,4.795429 46.101096,4.794692 46.101329,4.794149 46.101603,4.792847 46.10222,4.791946 46.102619,4.791552 46.102765,4.79127 46.102779,4.790998 46.102997,4.790532 46.1031,4.790102 46.103101,4.789887 46.103073,4.78949 46.102945,4.789103 46.102668,4.788772 46.102932,4.788676 46.102946,4.788357 46.102813,4.788258 46.102641,4.788051 46.102177,4.786913 46.102022,4.785941 46.101996,4.786006 46.101839,4.785517 46.100979,4.7855 46.100841,4.785344 46.100799,4.784905 46.100794,4.78449 46.100708,4.784087 46.100571,4.78372 46.100591,4.783261 46.100723,4.781754 46.101128,4.7816 46.101161,4.781123 46.101208,4.778574 46.099884,4.773542 46.098285,4.773178 46.097627,4.772826 46.096959,4.772282 46.096025,4.771603 46.094953,4.77104 46.094114,4.770679 46.094172,4.770071 46.094344,4.769194 46.094963,4.76823 46.095739,4.76739 46.096492,4.766607 46.097176,4.764635 46.09887,4.764379 46.099076,4.764053 46.099398,4.763952 46.09945,4.76182 46.100265,4.760242 46.101058,4.761997 46.102492,4.764261 46.104078,4.767408 46.107028)))"
  ]
  "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.767408 46.107028,4.768468 46.108025,4.768648 46.10822,4.769377 46.109127,4.76985 46.109703,4.770112 46.110123,4.771074 46.1118,4.771398 46.112408,4.77159 46.113016,4.771685 46.114484,4.771519 46.11545,4.771498 46.116072,4.771722 46.117344,4.771968 46.117871,4.776137 46.116778,4.780863 46.115533,4.783576 46.114825,4.785651 46.114273,4.790605 46.11296,4.791842 46.112681,4.79867 46.111199,4.799048 46.111275,4.799615 46.1113,4.800572 46.111301,4.801675 46.111408,4.802115 46.11146,4.803929 46.111861,4.804864 46.112032,4.805492 46.112232,4.805781 46.112296,4.807444 46.11116,4.807479 46.111148,4.807121 46.10975,4.80608 46.107271,4.80567 46.106337,4.804273 46.105006,4.802641 46.105668,4.802511 46.105627,4.802242 46.105409,4.801994 46.105072,4.801618 46.104645,4.801443 46.104287,4.801248 46.103648,4.801244 46.103401,4.800955 46.103517,4.800657 46.103512,4.800505 46.103404,4.800271 46.103126,4.799733 46.102593,4.799035 46.102833,4.798884 46.102753,4.798661 46.102413,4.797923 46.101437,4.797792 46.101451,4.797166 46.101611,4.796969 46.101699,4.796844 46.101405,4.796715 46.101206,4.796429 46.100887,4.796006 46.101,4.795429 46.101096,4.794692 46.101329,4.794149 46.101603,4.792847 46.10222,4.791946 46.102619,4.791552 46.102765,4.79127 46.102779,4.790998 46.102997,4.790532 46.1031,4.790102 46.103101,4.789887 46.103073,4.78949 46.102945,4.789103 46.102668,4.788772 46.102932,4.788676 46.102946,4.788357 46.102813,4.788258 46.102641,4.788051 46.102177,4.786913 46.102022,4.785941 46.101996,4.786006 46.101839,4.785517 46.100979,4.7855 46.100841,4.785344 46.100799,4.784905 46.100794,4.78449 46.100708,4.784087 46.100571,4.78372 46.100591,4.783261 46.100723,4.781754 46.101128,4.7816 46.101161,4.781123 46.101208,4.778574 46.099884,4.773542 46.098285,4.773178 46.097627,4.772826 46.096959,4.772282 46.096025,4.771603 46.094953,4.77104 46.094114,4.770679 46.094172,4.770071 46.094344,4.769194 46.094963,4.76823 46.095739,4.76739 46.096492,4.766607 46.097176,4.764635 46.09887,4.764379 46.099076,4.764053 46.099398,4.763952 46.09945,4.76182 46.100265,4.760242 46.101058,4.761997 46.102492,4.764261 46.104078,4.767408 46.107028)))"
  ]
  "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.767408 46.107028,4.768468 46.108025,4.768648 46.10822,4.769377 46.109127,4.76985 46.109703,4.770112 46.110123,4.771074 46.1118,4.771398 46.112408,4.77159 46.113016,4.771685 46.114484,4.771519 46.11545,4.771498 46.116072,4.771722 46.117344,4.771968 46.117871,4.776137 46.116778,4.780863 46.115533,4.783576 46.114825,4.785651 46.114273,4.790605 46.11296,4.791842 46.112681,4.79867 46.111199,4.799048 46.111275,4.799615 46.1113,4.800572 46.111301,4.801675 46.111408,4.802115 46.11146,4.803929 46.111861,4.804864 46.112032,4.805492 46.112232,4.805781 46.112296,4.807444 46.11116,4.807479 46.111148,4.807121 46.10975,4.80608 46.107271,4.80567 46.106337,4.804273 46.105006,4.802641 46.105668,4.802511 46.105627,4.802242 46.105409,4.801994 46.105072,4.801618 46.104645,4.801443 46.104287,4.801248 46.103648,4.801244 46.103401,4.800955 46.103517,4.800657 46.103512,4.800505 46.103404,4.800271 46.103126,4.799733 46.102593,4.799035 46.102833,4.798884 46.102753,4.798661 46.102413,4.797923 46.101437,4.797792 46.101451,4.797166 46.101611,4.796969 46.101699,4.796844 46.101405,4.796715 46.101206,4.796429 46.100887,4.796006 46.101,4.795429 46.101096,4.794692 46.101329,4.794149 46.101603,4.792847 46.10222,4.791946 46.102619,4.791552 46.102765,4.79127 46.102779,4.790998 46.102997,4.790532 46.1031,4.790102 46.103101,4.789887 46.103073,4.78949 46.102945,4.789103 46.102668,4.788772 46.102932,4.788676 46.102946,4.788357 46.102813,4.788258 46.102641,4.788051 46.102177,4.786913 46.102022,4.785941 46.101996,4.786006 46.101839,4.785517 46.100979,4.7855 46.100841,4.785344 46.100799,4.784905 46.100794,4.78449 46.100708,4.784087 46.100571,4.78372 46.100591,4.783261 46.100723,4.781754 46.101128,4.7816 46.101161,4.781123 46.101208,4.778574 46.099884,4.773542 46.098285,4.773178 46.097627,4.772826 46.096959,4.772282 46.096025,4.771603 46.094953,4.77104 46.094114,4.770679 46.094172,4.770071 46.094344,4.769194 46.094963,4.76823 46.095739,4.76739 46.096492,4.766607 46.097176,4.764635 46.09887,4.764379 46.099076,4.764053 46.099398,4.763952 46.09945,4.76182 46.100265,4.760242 46.101058,4.761997 46.102492,4.764261 46.104078,4.767408 46.107028)))"
  ]
  "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.767408 46.107028,4.768468 46.108025,4.768648 46.10822,4.769377 46.109127,4.76985 46.109703,4.770112 46.110123,4.771074 46.1118,4.771398 46.112408,4.77159 46.113016,4.771685 46.114484,4.771519 46.11545,4.771498 46.116072,4.771722 46.117344,4.771968 46.117871,4.776137 46.116778,4.780863 46.115533,4.783576 46.114825,4.785651 46.114273,4.790605 46.11296,4.791842 46.112681,4.79867 46.111199,4.799048 46.111275,4.799615 46.1113,4.800572 46.111301,4.801675 46.111408,4.802115 46.11146,4.803929 46.111861,4.804864 46.112032,4.805492 46.112232,4.805781 46.112296,4.807444 46.11116,4.807479 46.111148,4.807121 46.10975,4.80608 46.107271,4.80567 46.106337,4.804273 46.105006,4.802641 46.105668,4.802511 46.105627,4.802242 46.105409,4.801994 46.105072,4.801618 46.104645,4.801443 46.104287,4.801248 46.103648,4.801244 46.103401,4.800955 46.103517,4.800657 46.103512,4.800505 46.103404,4.800271 46.103126,4.799733 46.102593,4.799035 46.102833,4.798884 46.102753,4.798661 46.102413,4.797923 46.101437,4.797792 46.101451,4.797166 46.101611,4.796969 46.101699,4.796844 46.101405,4.796715 46.101206,4.796429 46.100887,4.796006 46.101,4.795429 46.101096,4.794692 46.101329,4.794149 46.101603,4.792847 46.10222,4.791946 46.102619,4.791552 46.102765,4.79127 46.102779,4.790998 46.102997,4.790532 46.1031,4.790102 46.103101,4.789887 46.103073,4.78949 46.102945,4.789103 46.102668,4.788772 46.102932,4.788676 46.102946,4.788357 46.102813,4.788258 46.102641,4.788051 46.102177,4.786913 46.102022,4.785941 46.101996,4.786006 46.101839,4.785517 46.100979,4.7855 46.100841,4.785344 46.100799,4.784905 46.100794,4.78449 46.100708,4.784087 46.100571,4.78372 46.100591,4.783261 46.100723,4.781754 46.101128,4.7816 46.101161,4.781123 46.101208,4.778574 46.099884,4.773542 46.098285,4.773178 46.097627,4.772826 46.096959,4.772282 46.096025,4.771603 46.094953,4.77104 46.094114,4.770679 46.094172,4.770071 46.094344,4.769194 46.094963,4.76823 46.095739,4.76739 46.096492,4.766607 46.097176,4.764635 46.09887,4.764379 46.099076,4.764053 46.099398,4.763952 46.09945,4.76182 46.100265,4.760242 46.101058,4.761997 46.102492,4.764261 46.104078,4.767408 46.107028)))"
  ]
  "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.767408 46.107028,4.768468 46.108025,4.768648 46.10822,4.769377 46.109127,4.76985 46.109703,4.770112 46.110123,4.771074 46.1118,4.771398 46.112408,4.77159 46.113016,4.771685 46.114484,4.771519 46.11545,4.771498 46.116072,4.771722 46.117344,4.771968 46.117871,4.776137 46.116778,4.780863 46.115533,4.783576 46.114825,4.785651 46.114273,4.790605 46.11296,4.791842 46.112681,4.79867 46.111199,4.799048 46.111275,4.799615 46.1113,4.800572 46.111301,4.801675 46.111408,4.802115 46.11146,4.803929 46.111861,4.804864 46.112032,4.805492 46.112232,4.805781 46.112296,4.807444 46.11116,4.807479 46.111148,4.807121 46.10975,4.80608 46.107271,4.80567 46.106337,4.804273 46.105006,4.802641 46.105668,4.802511 46.105627,4.802242 46.105409,4.801994 46.105072,4.801618 46.104645,4.801443 46.104287,4.801248 46.103648,4.801244 46.103401,4.800955 46.103517,4.800657 46.103512,4.800505 46.103404,4.800271 46.103126,4.799733 46.102593,4.799035 46.102833,4.798884 46.102753,4.798661 46.102413,4.797923 46.101437,4.797792 46.101451,4.797166 46.101611,4.796969 46.101699,4.796844 46.101405,4.796715 46.101206,4.796429 46.100887,4.796006 46.101,4.795429 46.101096,4.794692 46.101329,4.794149 46.101603,4.792847 46.10222,4.791946 46.102619,4.791552 46.102765,4.79127 46.102779,4.790998 46.102997,4.790532 46.1031,4.790102 46.103101,4.789887 46.103073,4.78949 46.102945,4.789103 46.102668,4.788772 46.102932,4.788676 46.102946,4.788357 46.102813,4.788258 46.102641,4.788051 46.102177,4.786913 46.102022,4.785941 46.101996,4.786006 46.101839,4.785517 46.100979,4.7855 46.100841,4.785344 46.100799,4.784905 46.100794,4.78449 46.100708,4.784087 46.100571,4.78372 46.100591,4.783261 46.100723,4.781754 46.101128,4.7816 46.101161,4.781123 46.101208,4.778574 46.099884,4.773542 46.098285,4.773178 46.097627,4.772826 46.096959,4.772282 46.096025,4.771603 46.094953,4.77104 46.094114,4.770679 46.094172,4.770071 46.094344,4.769194 46.094963,4.76823 46.095739,4.76739 46.096492,4.766607 46.097176,4.764635 46.09887,4.764379 46.099076,4.764053 46.099398,4.763952 46.09945,4.76182 46.100265,4.760242 46.101058,4.761997 46.102492,4.764261 46.104078,4.767408 46.107028)))"
  ]
  "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 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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:20:28"
    4 => 27401
  ]
  "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"
    }
  ]
]