Symfony Profiler

[
  "route" => "app_admin_stats"
  "route_parameters" => [
    "_route" => "app_admin_stats"
    "_controller" => "App\Controller\AdminController::stats"
    "insee_code" => "02006"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/admin/stats/02006"
  "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 s0_.id AS id_0, s0_.zone AS zone_1, s0_.completion_percent AS completion_percent_2, s0_.places_count AS places_count_3, s0_.avec_horaires AS avec_horaires_4, s0_.avec_adresse AS avec_adresse_5, s0_.avec_site AS avec_site_6, s0_.avec_accessibilite AS avec_accessibilite_7, s0_.avec_note AS avec_note_8, s0_.name AS name_9, s0_.population AS population_10, s0_.siren AS siren_11, s0_.code_epci AS code_epci_12, s0_.codes_postaux AS codes_postaux_13, s0_.date_created AS date_created_14, s0_.date_modified AS date_modified_15, s0_.avec_siret AS avec_siret_16, s0_.avec_name AS avec_name_17, s0_.avec_email AS avec_email_18, s0_.osm_data_date_min AS osm_data_date_min_19, s0_.osm_data_date_avg AS osm_data_date_avg_20, s0_.osm_data_date_max AS osm_data_date_max_21, s0_.budget_annuel AS budget_annuel_22, s0_.lat AS lat_23, s0_.lon AS lon_24, s0_.date_labourage_requested AS date_labourage_requested_25, s0_.date_labourage_done AS date_labourage_done_26, s0_.kind AS kind_27 FROM stats s0_ WHERE s0_.zone = ? ORDER BY s0_.id ASC LIMIT 1"
  "params" => [
    1 => "02006"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.measure AS measure_3, t0.date AS date_4, t0.stats_id AS stats_id_5 FROM city_follow_up t0 WHERE t0.stats_id = ?"
  "params" => [
    1 => 27297
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#709
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "INSERT INTO action_log (type, data, created_at, from_url, who) VALUES (?, ?, ?, ?, ?)"
  "params" => [
    1 => "stats_de_ville"
    2 => "{"insee_code":"02006","nom":"02006"}"
    3 => "2026-07-15 02:56:42"
    4 => null
    5 => null
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
    3 => Doctrine\DBAL\ParameterType {#588}
    4 => Doctrine\DBAL\ParameterType {#588}
    5 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM osm_object t0 WHERE t0.zone = ?"
  "params" => [
    1 => "02006"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.places_count AS places_count_1, s0_.emails_count AS emails_count_2, s0_.completion_percent AS completion_percent_3, s0_.emails_sent AS emails_sent_4, s0_.date AS date_5, s0_.names_count AS names_count_6, s0_.opening_hours_count AS opening_hours_count_7, s0_.website_count AS website_count_8, s0_.address_count AS address_count_9, s0_.siret_count AS siret_count_10, s0_.stats_id AS stats_id_11 FROM stats_history s0_ WHERE s0_.stats_id = ? ORDER BY s0_.id DESC LIMIT 100"
  "params" => [
    1 => 27297
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#709
      +name: "INTEGER"
    }
  ]
]

[
  "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 COUNT(*) FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'osm_object_history'"
]

[
  "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 {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "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 {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "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 => "02006"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +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 {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "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 => "02006"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +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 => "02006"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    WITH zone AS (SELECT ST_GeomFromText(?, 4326) AS g),\n
    in_zone AS (\n
      SELECT h.osm_type, h.osm_id, h.version, h.valid_from, h.visible\n
      FROM osm_object_history h, zone z\n
      WHERE h.geom IS NOT NULL AND ST_Intersects(h.geom, z.g)\n
    ),\n
    creations AS (\n
      SELECT (valid_from AT TIME ZONE 'UTC')::date AS d\n
      FROM in_zone\n
      WHERE version = 1 AND visible = true AND valid_from >= NOW() - (? || ' days')::interval\n
    ),\n
    deletions AS (\n
      SELECT (del.valid_from AT TIME ZONE 'UTC')::date AS d\n
      FROM osm_object_history del\n
      JOIN in_zone prev\n
        ON prev.osm_type = del.osm_type\n
       AND prev.osm_id   = del.osm_id\n
       AND prev.version  = del.version - 1\n
      WHERE del.visible = false\n
        AND del.valid_from >= NOW() - (? || ' days')::interval\n
    )\n
    SELECT d::text AS date,\n
           SUM(n_creations)::int AS creations,\n
           SUM(n_deletions)::int AS deletions\n
    FROM (\n
      SELECT d, COUNT(*) AS n_creations, 0 AS n_deletions FROM creations GROUP BY d\n
      UNION ALL\n
      SELECT d, 0, COUNT(*) FROM deletions GROUP BY d\n
    ) u\n
    GROUP BY d\n
    ORDER BY d
    """
  "params" => [
    1 => "MULTIPOLYGON(((3.48265 49.934107,3.481931 49.934226,3.481701 49.934823,3.480967 49.936372,3.481056 49.936628,3.481164 49.937984,3.481185 49.939242,3.480816 49.940171,3.482125 49.940838,3.482761 49.941231,3.482349 49.941522,3.482318 49.941604,3.483114 49.94218,3.484208 49.942912,3.484842 49.943243,3.484963 49.94309,3.485337 49.94275,3.485643 49.942614,3.486056 49.942302,3.486519 49.94235,3.486912 49.942435,3.487123 49.94256,3.486571 49.942733,3.486185 49.942952,3.486163 49.943174,3.486203 49.943358,3.486364 49.943739,3.486814 49.943862,3.487146 49.943921,3.487607 49.943944,3.488099 49.944025,3.489392 49.94358,3.490738 49.943731,3.491707 49.942102,3.494228 49.942603,3.495042 49.942828,3.494301 49.943458,3.493175 49.944358,3.492743 49.944763,3.494188 49.945223,3.494558 49.945328,3.493573 49.94697,3.494049 49.94704,3.495293 49.947203,3.495491 49.948213,3.49557 49.948455,3.495535 49.949058,3.495355 49.951401,3.496778 49.951593,3.496541 49.952774,3.499579 49.953144,3.499529 49.951835,3.499497 49.949006,3.499849 49.948815,3.500146 49.948622,3.50011 49.94834,3.500164 49.945453,3.501993 49.945861,3.502409 49.945009,3.502603 49.94466,3.503445 49.944256,3.503854 49.944008,3.504863 49.943345,3.505346 49.942637,3.505901 49.941802,3.50712 49.942113,3.507358 49.941534,3.507707 49.941117,3.508389 49.940431,3.508904 49.93988,3.50741 49.938665,3.508199 49.938153,3.509009 49.937653,3.510038 49.937142,3.511117 49.936798,3.511931 49.937518,3.512609 49.938091,3.51343 49.937753,3.516192 49.939427,3.516789 49.939837,3.516849 49.939743,3.521314 49.937832,3.521471 49.937842,3.522204 49.936944,3.522458 49.937409,3.523011 49.938052,3.523081 49.938194,3.523363 49.939241,3.523448 49.939456,3.523614 49.939685,3.525791 49.939133,3.527558 49.936933,3.527648 49.937001,3.528432 49.936424,3.530011 49.935245,3.530083 49.935245,3.531311 49.935796,3.532561 49.934909,3.533976 49.934322,3.535928 49.934955,3.536055 49.934643,3.536318 49.934135,3.537186 49.933622,3.537772 49.933239,3.538542 49.932484,3.538866 49.931065,3.538835 49.930915,3.535344 49.928979,3.536252 49.928506,3.536304 49.928506,3.538109 49.929394,3.539299 49.929989,3.542589 49.930374,3.542957 49.929211,3.543481 49.928273,3.543377 49.927778,3.54336 49.927487,3.543258 49.927214,3.54305 49.926874,3.542802 49.926681,3.542382 49.926181,3.542343 49.926055,3.542158 49.925904,3.541944 49.925952,3.541403 49.926007,3.540875 49.926101,3.540133 49.926319,3.539959 49.926305,3.539825 49.926105,3.539289 49.925191,3.537822 49.923022,3.537389 49.922395,3.537264 49.922244,3.536921 49.921663,3.536719 49.921592,3.536402 49.921607,3.534527 49.92167,3.534398 49.921599,3.533989 49.920783,3.533761 49.920259,3.533119 49.918866,3.532937 49.918562,3.532552 49.918461,3.531287 49.918247,3.530072 49.91797,3.529243 49.91781,3.528859 49.917856,3.527598 49.918115,3.525245 49.918564,3.523549 49.918892,3.521712 49.919462,3.520488 49.919901,3.518793 49.920664,3.517123 49.921343,3.515916 49.920623,3.51501 49.920138,3.514865 49.919886,3.514679 49.919367,3.514516 49.91868,3.513947 49.917665,3.513574 49.916947,3.513526 49.916722,3.513922 49.916529,3.51604 49.915629,3.516155 49.915376,3.515728 49.914959,3.515343 49.914805,3.514581 49.914586,3.513781 49.913327,3.516219 49.912018,3.515128 49.910597,3.51424 49.909788,3.513763 49.909455,3.513213 49.909747,3.513058 49.909801,3.511636 49.909944,3.509252 49.910163,3.508999 49.910175,3.508329 49.910146,3.50552 49.909912,3.50486 49.909874,3.504318 49.909895,3.503608 49.909994,3.503662 49.910225,3.503673 49.911695,3.503222 49.91243,3.503624 49.913276,3.504078 49.913116,3.505646 49.914109,3.505547 49.914526,3.505493 49.914631,3.50547 49.915021,3.505939 49.915885,3.503195 49.916338,3.503186 49.916402,3.504996 49.917707,3.50496 49.917974,3.50576 49.921414,3.505781 49.92164,3.505671 49.92182,3.505528 49.921932,3.504685 49.921993,3.503697 49.922102,3.503136 49.922254,3.501687 49.922575,3.501481 49.922345,3.5012 49.922721,3.50018 49.924277,3.500971 49.924621,3.499811 49.925842,3.498335 49.925721,3.496226 49.925502,3.49536 49.926907,3.49462 49.927208,3.494004 49.927971,3.493612 49.928263,3.49239 49.929296,3.493246 49.929404,3.49348 49.92946,3.493552 49.929543,3.493514 49.929769,3.493087 49.930063,3.492805 49.930308,3.49191 49.931006,3.491323 49.932038,3.492651 49.933229,3.491347 49.934206,3.48827 49.934271,3.48265 49.934107)))"
    2 => "30"
    3 => "30"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
    3 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "sql" => """
    SELECT to_char(qstart, 'YYYY') || '-Q' || EXTRACT(QUARTER FROM qstart)::int AS k,\n
           n\n
    FROM (\n
      SELECT date_trunc('quarter', valid_from) AS qstart, COUNT(*) AS n\n
      FROM osm_object_history h\n
      WHERE h.geom IS NOT NULL AND ST_Intersects(h.geom, ST_GeomFromText(?, 4326))\n
      GROUP BY 1\n
    ) t\n
    ORDER BY qstart
    """
  "params" => [
    1 => "MULTIPOLYGON(((3.48265 49.934107,3.481931 49.934226,3.481701 49.934823,3.480967 49.936372,3.481056 49.936628,3.481164 49.937984,3.481185 49.939242,3.480816 49.940171,3.482125 49.940838,3.482761 49.941231,3.482349 49.941522,3.482318 49.941604,3.483114 49.94218,3.484208 49.942912,3.484842 49.943243,3.484963 49.94309,3.485337 49.94275,3.485643 49.942614,3.486056 49.942302,3.486519 49.94235,3.486912 49.942435,3.487123 49.94256,3.486571 49.942733,3.486185 49.942952,3.486163 49.943174,3.486203 49.943358,3.486364 49.943739,3.486814 49.943862,3.487146 49.943921,3.487607 49.943944,3.488099 49.944025,3.489392 49.94358,3.490738 49.943731,3.491707 49.942102,3.494228 49.942603,3.495042 49.942828,3.494301 49.943458,3.493175 49.944358,3.492743 49.944763,3.494188 49.945223,3.494558 49.945328,3.493573 49.94697,3.494049 49.94704,3.495293 49.947203,3.495491 49.948213,3.49557 49.948455,3.495535 49.949058,3.495355 49.951401,3.496778 49.951593,3.496541 49.952774,3.499579 49.953144,3.499529 49.951835,3.499497 49.949006,3.499849 49.948815,3.500146 49.948622,3.50011 49.94834,3.500164 49.945453,3.501993 49.945861,3.502409 49.945009,3.502603 49.94466,3.503445 49.944256,3.503854 49.944008,3.504863 49.943345,3.505346 49.942637,3.505901 49.941802,3.50712 49.942113,3.507358 49.941534,3.507707 49.941117,3.508389 49.940431,3.508904 49.93988,3.50741 49.938665,3.508199 49.938153,3.509009 49.937653,3.510038 49.937142,3.511117 49.936798,3.511931 49.937518,3.512609 49.938091,3.51343 49.937753,3.516192 49.939427,3.516789 49.939837,3.516849 49.939743,3.521314 49.937832,3.521471 49.937842,3.522204 49.936944,3.522458 49.937409,3.523011 49.938052,3.523081 49.938194,3.523363 49.939241,3.523448 49.939456,3.523614 49.939685,3.525791 49.939133,3.527558 49.936933,3.527648 49.937001,3.528432 49.936424,3.530011 49.935245,3.530083 49.935245,3.531311 49.935796,3.532561 49.934909,3.533976 49.934322,3.535928 49.934955,3.536055 49.934643,3.536318 49.934135,3.537186 49.933622,3.537772 49.933239,3.538542 49.932484,3.538866 49.931065,3.538835 49.930915,3.535344 49.928979,3.536252 49.928506,3.536304 49.928506,3.538109 49.929394,3.539299 49.929989,3.542589 49.930374,3.542957 49.929211,3.543481 49.928273,3.543377 49.927778,3.54336 49.927487,3.543258 49.927214,3.54305 49.926874,3.542802 49.926681,3.542382 49.926181,3.542343 49.926055,3.542158 49.925904,3.541944 49.925952,3.541403 49.926007,3.540875 49.926101,3.540133 49.926319,3.539959 49.926305,3.539825 49.926105,3.539289 49.925191,3.537822 49.923022,3.537389 49.922395,3.537264 49.922244,3.536921 49.921663,3.536719 49.921592,3.536402 49.921607,3.534527 49.92167,3.534398 49.921599,3.533989 49.920783,3.533761 49.920259,3.533119 49.918866,3.532937 49.918562,3.532552 49.918461,3.531287 49.918247,3.530072 49.91797,3.529243 49.91781,3.528859 49.917856,3.527598 49.918115,3.525245 49.918564,3.523549 49.918892,3.521712 49.919462,3.520488 49.919901,3.518793 49.920664,3.517123 49.921343,3.515916 49.920623,3.51501 49.920138,3.514865 49.919886,3.514679 49.919367,3.514516 49.91868,3.513947 49.917665,3.513574 49.916947,3.513526 49.916722,3.513922 49.916529,3.51604 49.915629,3.516155 49.915376,3.515728 49.914959,3.515343 49.914805,3.514581 49.914586,3.513781 49.913327,3.516219 49.912018,3.515128 49.910597,3.51424 49.909788,3.513763 49.909455,3.513213 49.909747,3.513058 49.909801,3.511636 49.909944,3.509252 49.910163,3.508999 49.910175,3.508329 49.910146,3.50552 49.909912,3.50486 49.909874,3.504318 49.909895,3.503608 49.909994,3.503662 49.910225,3.503673 49.911695,3.503222 49.91243,3.503624 49.913276,3.504078 49.913116,3.505646 49.914109,3.505547 49.914526,3.505493 49.914631,3.50547 49.915021,3.505939 49.915885,3.503195 49.916338,3.503186 49.916402,3.504996 49.917707,3.50496 49.917974,3.50576 49.921414,3.505781 49.92164,3.505671 49.92182,3.505528 49.921932,3.504685 49.921993,3.503697 49.922102,3.503136 49.922254,3.501687 49.922575,3.501481 49.922345,3.5012 49.922721,3.50018 49.924277,3.500971 49.924621,3.499811 49.925842,3.498335 49.925721,3.496226 49.925502,3.49536 49.926907,3.49462 49.927208,3.494004 49.927971,3.493612 49.928263,3.49239 49.929296,3.493246 49.929404,3.49348 49.92946,3.493552 49.929543,3.493514 49.929769,3.493087 49.930063,3.492805 49.930308,3.49191 49.931006,3.491323 49.932038,3.492651 49.933229,3.491347 49.934206,3.48827 49.934271,3.48265 49.934107)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    WITH last_versions AS (\n
      SELECT DISTINCT ON (osm_type, osm_id) osm_type, osm_id, valid_from, visible, geom\n
      FROM osm_object_history h\n
      WHERE h.geom IS NOT NULL\n
        AND ST_Intersects(h.geom, ST_GeomFromText(?, 4326))\n
      ORDER BY osm_type, osm_id, valid_from DESC\n
    )\n
    SELECT TO_TIMESTAMP(AVG(EXTRACT(EPOCH FROM valid_from))) AS avg_ts,\n
           COUNT(*) AS n\n
    FROM last_versions\n
    WHERE visible = true
    """
  "params" => [
    1 => "MULTIPOLYGON(((3.48265 49.934107,3.481931 49.934226,3.481701 49.934823,3.480967 49.936372,3.481056 49.936628,3.481164 49.937984,3.481185 49.939242,3.480816 49.940171,3.482125 49.940838,3.482761 49.941231,3.482349 49.941522,3.482318 49.941604,3.483114 49.94218,3.484208 49.942912,3.484842 49.943243,3.484963 49.94309,3.485337 49.94275,3.485643 49.942614,3.486056 49.942302,3.486519 49.94235,3.486912 49.942435,3.487123 49.94256,3.486571 49.942733,3.486185 49.942952,3.486163 49.943174,3.486203 49.943358,3.486364 49.943739,3.486814 49.943862,3.487146 49.943921,3.487607 49.943944,3.488099 49.944025,3.489392 49.94358,3.490738 49.943731,3.491707 49.942102,3.494228 49.942603,3.495042 49.942828,3.494301 49.943458,3.493175 49.944358,3.492743 49.944763,3.494188 49.945223,3.494558 49.945328,3.493573 49.94697,3.494049 49.94704,3.495293 49.947203,3.495491 49.948213,3.49557 49.948455,3.495535 49.949058,3.495355 49.951401,3.496778 49.951593,3.496541 49.952774,3.499579 49.953144,3.499529 49.951835,3.499497 49.949006,3.499849 49.948815,3.500146 49.948622,3.50011 49.94834,3.500164 49.945453,3.501993 49.945861,3.502409 49.945009,3.502603 49.94466,3.503445 49.944256,3.503854 49.944008,3.504863 49.943345,3.505346 49.942637,3.505901 49.941802,3.50712 49.942113,3.507358 49.941534,3.507707 49.941117,3.508389 49.940431,3.508904 49.93988,3.50741 49.938665,3.508199 49.938153,3.509009 49.937653,3.510038 49.937142,3.511117 49.936798,3.511931 49.937518,3.512609 49.938091,3.51343 49.937753,3.516192 49.939427,3.516789 49.939837,3.516849 49.939743,3.521314 49.937832,3.521471 49.937842,3.522204 49.936944,3.522458 49.937409,3.523011 49.938052,3.523081 49.938194,3.523363 49.939241,3.523448 49.939456,3.523614 49.939685,3.525791 49.939133,3.527558 49.936933,3.527648 49.937001,3.528432 49.936424,3.530011 49.935245,3.530083 49.935245,3.531311 49.935796,3.532561 49.934909,3.533976 49.934322,3.535928 49.934955,3.536055 49.934643,3.536318 49.934135,3.537186 49.933622,3.537772 49.933239,3.538542 49.932484,3.538866 49.931065,3.538835 49.930915,3.535344 49.928979,3.536252 49.928506,3.536304 49.928506,3.538109 49.929394,3.539299 49.929989,3.542589 49.930374,3.542957 49.929211,3.543481 49.928273,3.543377 49.927778,3.54336 49.927487,3.543258 49.927214,3.54305 49.926874,3.542802 49.926681,3.542382 49.926181,3.542343 49.926055,3.542158 49.925904,3.541944 49.925952,3.541403 49.926007,3.540875 49.926101,3.540133 49.926319,3.539959 49.926305,3.539825 49.926105,3.539289 49.925191,3.537822 49.923022,3.537389 49.922395,3.537264 49.922244,3.536921 49.921663,3.536719 49.921592,3.536402 49.921607,3.534527 49.92167,3.534398 49.921599,3.533989 49.920783,3.533761 49.920259,3.533119 49.918866,3.532937 49.918562,3.532552 49.918461,3.531287 49.918247,3.530072 49.91797,3.529243 49.91781,3.528859 49.917856,3.527598 49.918115,3.525245 49.918564,3.523549 49.918892,3.521712 49.919462,3.520488 49.919901,3.518793 49.920664,3.517123 49.921343,3.515916 49.920623,3.51501 49.920138,3.514865 49.919886,3.514679 49.919367,3.514516 49.91868,3.513947 49.917665,3.513574 49.916947,3.513526 49.916722,3.513922 49.916529,3.51604 49.915629,3.516155 49.915376,3.515728 49.914959,3.515343 49.914805,3.514581 49.914586,3.513781 49.913327,3.516219 49.912018,3.515128 49.910597,3.51424 49.909788,3.513763 49.909455,3.513213 49.909747,3.513058 49.909801,3.511636 49.909944,3.509252 49.910163,3.508999 49.910175,3.508329 49.910146,3.50552 49.909912,3.50486 49.909874,3.504318 49.909895,3.503608 49.909994,3.503662 49.910225,3.503673 49.911695,3.503222 49.91243,3.503624 49.913276,3.504078 49.913116,3.505646 49.914109,3.505547 49.914526,3.505493 49.914631,3.50547 49.915021,3.505939 49.915885,3.503195 49.916338,3.503186 49.916402,3.504996 49.917707,3.50496 49.917974,3.50576 49.921414,3.505781 49.92164,3.505671 49.92182,3.505528 49.921932,3.504685 49.921993,3.503697 49.922102,3.503136 49.922254,3.501687 49.922575,3.501481 49.922345,3.5012 49.922721,3.50018 49.924277,3.500971 49.924621,3.499811 49.925842,3.498335 49.925721,3.496226 49.925502,3.49536 49.926907,3.49462 49.927208,3.494004 49.927971,3.493612 49.928263,3.49239 49.929296,3.493246 49.929404,3.49348 49.92946,3.493552 49.929543,3.493514 49.929769,3.493087 49.930063,3.492805 49.930308,3.49191 49.931006,3.491323 49.932038,3.492651 49.933229,3.491347 49.934206,3.48827 49.934271,3.48265 49.934107)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    WITH zone AS (SELECT ST_GeomFromText(?, 4326) AS g),\n
    in_zone AS (\n
      SELECT h.osm_type, h.osm_id, h.version, h.visible\n
      FROM osm_object_history h, zone z\n
      WHERE h.geom IS NOT NULL AND ST_Intersects(h.geom, z.g)\n
    ),\n
    deletions AS (\n
      SELECT 1 AS one\n
      FROM osm_object_history del\n
      JOIN in_zone prev\n
        ON prev.osm_type = del.osm_type\n
       AND prev.osm_id   = del.osm_id\n
       AND prev.version  = del.version - 1\n
      WHERE del.visible = false\n
    )\n
    SELECT\n
      (SELECT COUNT(*) FROM in_zone WHERE version = 1 AND visible = true) AS creations_total,\n
      (SELECT COUNT(*) FROM deletions)                                    AS deletions_total,\n
      (SELECT COUNT(*) FROM in_zone)                                      AS versions_total
    """
  "params" => [
    1 => "MULTIPOLYGON(((3.48265 49.934107,3.481931 49.934226,3.481701 49.934823,3.480967 49.936372,3.481056 49.936628,3.481164 49.937984,3.481185 49.939242,3.480816 49.940171,3.482125 49.940838,3.482761 49.941231,3.482349 49.941522,3.482318 49.941604,3.483114 49.94218,3.484208 49.942912,3.484842 49.943243,3.484963 49.94309,3.485337 49.94275,3.485643 49.942614,3.486056 49.942302,3.486519 49.94235,3.486912 49.942435,3.487123 49.94256,3.486571 49.942733,3.486185 49.942952,3.486163 49.943174,3.486203 49.943358,3.486364 49.943739,3.486814 49.943862,3.487146 49.943921,3.487607 49.943944,3.488099 49.944025,3.489392 49.94358,3.490738 49.943731,3.491707 49.942102,3.494228 49.942603,3.495042 49.942828,3.494301 49.943458,3.493175 49.944358,3.492743 49.944763,3.494188 49.945223,3.494558 49.945328,3.493573 49.94697,3.494049 49.94704,3.495293 49.947203,3.495491 49.948213,3.49557 49.948455,3.495535 49.949058,3.495355 49.951401,3.496778 49.951593,3.496541 49.952774,3.499579 49.953144,3.499529 49.951835,3.499497 49.949006,3.499849 49.948815,3.500146 49.948622,3.50011 49.94834,3.500164 49.945453,3.501993 49.945861,3.502409 49.945009,3.502603 49.94466,3.503445 49.944256,3.503854 49.944008,3.504863 49.943345,3.505346 49.942637,3.505901 49.941802,3.50712 49.942113,3.507358 49.941534,3.507707 49.941117,3.508389 49.940431,3.508904 49.93988,3.50741 49.938665,3.508199 49.938153,3.509009 49.937653,3.510038 49.937142,3.511117 49.936798,3.511931 49.937518,3.512609 49.938091,3.51343 49.937753,3.516192 49.939427,3.516789 49.939837,3.516849 49.939743,3.521314 49.937832,3.521471 49.937842,3.522204 49.936944,3.522458 49.937409,3.523011 49.938052,3.523081 49.938194,3.523363 49.939241,3.523448 49.939456,3.523614 49.939685,3.525791 49.939133,3.527558 49.936933,3.527648 49.937001,3.528432 49.936424,3.530011 49.935245,3.530083 49.935245,3.531311 49.935796,3.532561 49.934909,3.533976 49.934322,3.535928 49.934955,3.536055 49.934643,3.536318 49.934135,3.537186 49.933622,3.537772 49.933239,3.538542 49.932484,3.538866 49.931065,3.538835 49.930915,3.535344 49.928979,3.536252 49.928506,3.536304 49.928506,3.538109 49.929394,3.539299 49.929989,3.542589 49.930374,3.542957 49.929211,3.543481 49.928273,3.543377 49.927778,3.54336 49.927487,3.543258 49.927214,3.54305 49.926874,3.542802 49.926681,3.542382 49.926181,3.542343 49.926055,3.542158 49.925904,3.541944 49.925952,3.541403 49.926007,3.540875 49.926101,3.540133 49.926319,3.539959 49.926305,3.539825 49.926105,3.539289 49.925191,3.537822 49.923022,3.537389 49.922395,3.537264 49.922244,3.536921 49.921663,3.536719 49.921592,3.536402 49.921607,3.534527 49.92167,3.534398 49.921599,3.533989 49.920783,3.533761 49.920259,3.533119 49.918866,3.532937 49.918562,3.532552 49.918461,3.531287 49.918247,3.530072 49.91797,3.529243 49.91781,3.528859 49.917856,3.527598 49.918115,3.525245 49.918564,3.523549 49.918892,3.521712 49.919462,3.520488 49.919901,3.518793 49.920664,3.517123 49.921343,3.515916 49.920623,3.51501 49.920138,3.514865 49.919886,3.514679 49.919367,3.514516 49.91868,3.513947 49.917665,3.513574 49.916947,3.513526 49.916722,3.513922 49.916529,3.51604 49.915629,3.516155 49.915376,3.515728 49.914959,3.515343 49.914805,3.514581 49.914586,3.513781 49.913327,3.516219 49.912018,3.515128 49.910597,3.51424 49.909788,3.513763 49.909455,3.513213 49.909747,3.513058 49.909801,3.511636 49.909944,3.509252 49.910163,3.508999 49.910175,3.508329 49.910146,3.50552 49.909912,3.50486 49.909874,3.504318 49.909895,3.503608 49.909994,3.503662 49.910225,3.503673 49.911695,3.503222 49.91243,3.503624 49.913276,3.504078 49.913116,3.505646 49.914109,3.505547 49.914526,3.505493 49.914631,3.50547 49.915021,3.505939 49.915885,3.503195 49.916338,3.503186 49.916402,3.504996 49.917707,3.50496 49.917974,3.50576 49.921414,3.505781 49.92164,3.505671 49.92182,3.505528 49.921932,3.504685 49.921993,3.503697 49.922102,3.503136 49.922254,3.501687 49.922575,3.501481 49.922345,3.5012 49.922721,3.50018 49.924277,3.500971 49.924621,3.499811 49.925842,3.498335 49.925721,3.496226 49.925502,3.49536 49.926907,3.49462 49.927208,3.494004 49.927971,3.493612 49.928263,3.49239 49.929296,3.493246 49.929404,3.49348 49.92946,3.493552 49.929543,3.493514 49.929769,3.493087 49.930063,3.492805 49.930308,3.49191 49.931006,3.491323 49.932038,3.492651 49.933229,3.491347 49.934206,3.48827 49.934271,3.48265 49.934107)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +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 (\n
                  (tags->'shop') = 'vacant'\n
                  OR EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k LIKE 'was:%')\n
                )
    """
  "params" => [
    1 => "MULTIPOLYGON(((3.48265 49.934107,3.481931 49.934226,3.481701 49.934823,3.480967 49.936372,3.481056 49.936628,3.481164 49.937984,3.481185 49.939242,3.480816 49.940171,3.482125 49.940838,3.482761 49.941231,3.482349 49.941522,3.482318 49.941604,3.483114 49.94218,3.484208 49.942912,3.484842 49.943243,3.484963 49.94309,3.485337 49.94275,3.485643 49.942614,3.486056 49.942302,3.486519 49.94235,3.486912 49.942435,3.487123 49.94256,3.486571 49.942733,3.486185 49.942952,3.486163 49.943174,3.486203 49.943358,3.486364 49.943739,3.486814 49.943862,3.487146 49.943921,3.487607 49.943944,3.488099 49.944025,3.489392 49.94358,3.490738 49.943731,3.491707 49.942102,3.494228 49.942603,3.495042 49.942828,3.494301 49.943458,3.493175 49.944358,3.492743 49.944763,3.494188 49.945223,3.494558 49.945328,3.493573 49.94697,3.494049 49.94704,3.495293 49.947203,3.495491 49.948213,3.49557 49.948455,3.495535 49.949058,3.495355 49.951401,3.496778 49.951593,3.496541 49.952774,3.499579 49.953144,3.499529 49.951835,3.499497 49.949006,3.499849 49.948815,3.500146 49.948622,3.50011 49.94834,3.500164 49.945453,3.501993 49.945861,3.502409 49.945009,3.502603 49.94466,3.503445 49.944256,3.503854 49.944008,3.504863 49.943345,3.505346 49.942637,3.505901 49.941802,3.50712 49.942113,3.507358 49.941534,3.507707 49.941117,3.508389 49.940431,3.508904 49.93988,3.50741 49.938665,3.508199 49.938153,3.509009 49.937653,3.510038 49.937142,3.511117 49.936798,3.511931 49.937518,3.512609 49.938091,3.51343 49.937753,3.516192 49.939427,3.516789 49.939837,3.516849 49.939743,3.521314 49.937832,3.521471 49.937842,3.522204 49.936944,3.522458 49.937409,3.523011 49.938052,3.523081 49.938194,3.523363 49.939241,3.523448 49.939456,3.523614 49.939685,3.525791 49.939133,3.527558 49.936933,3.527648 49.937001,3.528432 49.936424,3.530011 49.935245,3.530083 49.935245,3.531311 49.935796,3.532561 49.934909,3.533976 49.934322,3.535928 49.934955,3.536055 49.934643,3.536318 49.934135,3.537186 49.933622,3.537772 49.933239,3.538542 49.932484,3.538866 49.931065,3.538835 49.930915,3.535344 49.928979,3.536252 49.928506,3.536304 49.928506,3.538109 49.929394,3.539299 49.929989,3.542589 49.930374,3.542957 49.929211,3.543481 49.928273,3.543377 49.927778,3.54336 49.927487,3.543258 49.927214,3.54305 49.926874,3.542802 49.926681,3.542382 49.926181,3.542343 49.926055,3.542158 49.925904,3.541944 49.925952,3.541403 49.926007,3.540875 49.926101,3.540133 49.926319,3.539959 49.926305,3.539825 49.926105,3.539289 49.925191,3.537822 49.923022,3.537389 49.922395,3.537264 49.922244,3.536921 49.921663,3.536719 49.921592,3.536402 49.921607,3.534527 49.92167,3.534398 49.921599,3.533989 49.920783,3.533761 49.920259,3.533119 49.918866,3.532937 49.918562,3.532552 49.918461,3.531287 49.918247,3.530072 49.91797,3.529243 49.91781,3.528859 49.917856,3.527598 49.918115,3.525245 49.918564,3.523549 49.918892,3.521712 49.919462,3.520488 49.919901,3.518793 49.920664,3.517123 49.921343,3.515916 49.920623,3.51501 49.920138,3.514865 49.919886,3.514679 49.919367,3.514516 49.91868,3.513947 49.917665,3.513574 49.916947,3.513526 49.916722,3.513922 49.916529,3.51604 49.915629,3.516155 49.915376,3.515728 49.914959,3.515343 49.914805,3.514581 49.914586,3.513781 49.913327,3.516219 49.912018,3.515128 49.910597,3.51424 49.909788,3.513763 49.909455,3.513213 49.909747,3.513058 49.909801,3.511636 49.909944,3.509252 49.910163,3.508999 49.910175,3.508329 49.910146,3.50552 49.909912,3.50486 49.909874,3.504318 49.909895,3.503608 49.909994,3.503662 49.910225,3.503673 49.911695,3.503222 49.91243,3.503624 49.913276,3.504078 49.913116,3.505646 49.914109,3.505547 49.914526,3.505493 49.914631,3.50547 49.915021,3.505939 49.915885,3.503195 49.916338,3.503186 49.916402,3.504996 49.917707,3.50496 49.917974,3.50576 49.921414,3.505781 49.92164,3.505671 49.92182,3.505528 49.921932,3.504685 49.921993,3.503697 49.922102,3.503136 49.922254,3.501687 49.922575,3.501481 49.922345,3.5012 49.922721,3.50018 49.924277,3.500971 49.924621,3.499811 49.925842,3.498335 49.925721,3.496226 49.925502,3.49536 49.926907,3.49462 49.927208,3.494004 49.927971,3.493612 49.928263,3.49239 49.929296,3.493246 49.929404,3.49348 49.92946,3.493552 49.929543,3.493514 49.929769,3.493087 49.930063,3.492805 49.930308,3.49191 49.931006,3.491323 49.932038,3.492651 49.933229,3.491347 49.934206,3.48827 49.934271,3.48265 49.934107)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT p0_.osm_user AS osm_user_0, COUNT(p0_.id) AS sclr_1, AVG((CASE WHEN p0_.has_opening_hours = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_address = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_website = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_wheelchair = 1 THEN 1 ELSE 0 END) + (CASE WHEN p0_.has_note = 1 THEN 1 ELSE 0 END)) / 5 * 100 AS sclr_2 FROM place p0_ WHERE p0_.osm_user IS NOT NULL AND p0_.osm_user <> '' AND p0_.stats_id = ? GROUP BY p0_.osm_user ORDER BY sclr_1 DESC LIMIT 100"
  "params" => [
    1 => 27297
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#709
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.disappeared_list AS disappeared_list_2, t0.current_list AS current_list_3, t0.theme AS theme_4, t0.stats_id AS stats_id_5 FROM zone_places t0 WHERE t0.stats_id = ?"
  "params" => [
    1 => 27297
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#709
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

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

[
  "sql" => """
    \n
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(m.geom)) AS lat, ST_X(ST_Centroid(m.geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,\n
           ST_AsGeoJSON(ST_Force2D(m.geom), 6, 0) AS geom_geojson,\n
           COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), bufc.buf)::geography), 0) AS length_m,\n
           CASE\n
             WHEN (tags->'highway') = 'proposed' AND exist(tags, 'proposed') AND (tags->'proposed') = 'cycleway' THEN 'proposed_cycleway'\n
             WHEN (tags->'highway') = 'cycleway' THEN 'separated'\n
             WHEN (tags->'highway') = 'busway' THEN 'separated'\n
             WHEN (tags->'cycleway:both') IN ('track', 'opposite_track', 'separate')\n
                  AND exist(tags, 'highway')\n
                  AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway') THEN 'separated'\n
             WHEN EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%') AND exist(tags, 'highway')\n
                  AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway') THEN 'lane'\n
             WHEN (exist(tags, 'bicycle') AND (tags->'bicycle') IS NOT NULL AND (tags->'bicycle') <> 'no') AND exist(tags, 'highway')\n
                  AND (tags->'highway') IS NOT NULL 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:%')) THEN 'designated'\n
             ELSE NULL\n
           END AS cycleway_category\n
    FROM osm_object_meta m\n
    CROSS JOIN (SELECT ST_MakeValid(ST_SetSRID(ST_GeomFromText(?), 4326)) AS poly) z\n
    CROSS JOIN LATERAL (SELECT ST_Buffer(z.poly::geography, ?)::geometry AS buf) bufc\n
    WHERE m.geom IS NOT NULL\n
      AND m.osm_type IN ('way', 'relation')\n
      AND ST_Intersects(m.geom, bufc.buf)\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
            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')\n
            AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway'))\n
      )\n
    """
  "params" => [
    1 => "MULTIPOLYGON(((3.48265 49.934107,3.481931 49.934226,3.481701 49.934823,3.480967 49.936372,3.481056 49.936628,3.481164 49.937984,3.481185 49.939242,3.480816 49.940171,3.482125 49.940838,3.482761 49.941231,3.482349 49.941522,3.482318 49.941604,3.483114 49.94218,3.484208 49.942912,3.484842 49.943243,3.484963 49.94309,3.485337 49.94275,3.485643 49.942614,3.486056 49.942302,3.486519 49.94235,3.486912 49.942435,3.487123 49.94256,3.486571 49.942733,3.486185 49.942952,3.486163 49.943174,3.486203 49.943358,3.486364 49.943739,3.486814 49.943862,3.487146 49.943921,3.487607 49.943944,3.488099 49.944025,3.489392 49.94358,3.490738 49.943731,3.491707 49.942102,3.494228 49.942603,3.495042 49.942828,3.494301 49.943458,3.493175 49.944358,3.492743 49.944763,3.494188 49.945223,3.494558 49.945328,3.493573 49.94697,3.494049 49.94704,3.495293 49.947203,3.495491 49.948213,3.49557 49.948455,3.495535 49.949058,3.495355 49.951401,3.496778 49.951593,3.496541 49.952774,3.499579 49.953144,3.499529 49.951835,3.499497 49.949006,3.499849 49.948815,3.500146 49.948622,3.50011 49.94834,3.500164 49.945453,3.501993 49.945861,3.502409 49.945009,3.502603 49.94466,3.503445 49.944256,3.503854 49.944008,3.504863 49.943345,3.505346 49.942637,3.505901 49.941802,3.50712 49.942113,3.507358 49.941534,3.507707 49.941117,3.508389 49.940431,3.508904 49.93988,3.50741 49.938665,3.508199 49.938153,3.509009 49.937653,3.510038 49.937142,3.511117 49.936798,3.511931 49.937518,3.512609 49.938091,3.51343 49.937753,3.516192 49.939427,3.516789 49.939837,3.516849 49.939743,3.521314 49.937832,3.521471 49.937842,3.522204 49.936944,3.522458 49.937409,3.523011 49.938052,3.523081 49.938194,3.523363 49.939241,3.523448 49.939456,3.523614 49.939685,3.525791 49.939133,3.527558 49.936933,3.527648 49.937001,3.528432 49.936424,3.530011 49.935245,3.530083 49.935245,3.531311 49.935796,3.532561 49.934909,3.533976 49.934322,3.535928 49.934955,3.536055 49.934643,3.536318 49.934135,3.537186 49.933622,3.537772 49.933239,3.538542 49.932484,3.538866 49.931065,3.538835 49.930915,3.535344 49.928979,3.536252 49.928506,3.536304 49.928506,3.538109 49.929394,3.539299 49.929989,3.542589 49.930374,3.542957 49.929211,3.543481 49.928273,3.543377 49.927778,3.54336 49.927487,3.543258 49.927214,3.54305 49.926874,3.542802 49.926681,3.542382 49.926181,3.542343 49.926055,3.542158 49.925904,3.541944 49.925952,3.541403 49.926007,3.540875 49.926101,3.540133 49.926319,3.539959 49.926305,3.539825 49.926105,3.539289 49.925191,3.537822 49.923022,3.537389 49.922395,3.537264 49.922244,3.536921 49.921663,3.536719 49.921592,3.536402 49.921607,3.534527 49.92167,3.534398 49.921599,3.533989 49.920783,3.533761 49.920259,3.533119 49.918866,3.532937 49.918562,3.532552 49.918461,3.531287 49.918247,3.530072 49.91797,3.529243 49.91781,3.528859 49.917856,3.527598 49.918115,3.525245 49.918564,3.523549 49.918892,3.521712 49.919462,3.520488 49.919901,3.518793 49.920664,3.517123 49.921343,3.515916 49.920623,3.51501 49.920138,3.514865 49.919886,3.514679 49.919367,3.514516 49.91868,3.513947 49.917665,3.513574 49.916947,3.513526 49.916722,3.513922 49.916529,3.51604 49.915629,3.516155 49.915376,3.515728 49.914959,3.515343 49.914805,3.514581 49.914586,3.513781 49.913327,3.516219 49.912018,3.515128 49.910597,3.51424 49.909788,3.513763 49.909455,3.513213 49.909747,3.513058 49.909801,3.511636 49.909944,3.509252 49.910163,3.508999 49.910175,3.508329 49.910146,3.50552 49.909912,3.50486 49.909874,3.504318 49.909895,3.503608 49.909994,3.503662 49.910225,3.503673 49.911695,3.503222 49.91243,3.503624 49.913276,3.504078 49.913116,3.505646 49.914109,3.505547 49.914526,3.505493 49.914631,3.50547 49.915021,3.505939 49.915885,3.503195 49.916338,3.503186 49.916402,3.504996 49.917707,3.50496 49.917974,3.50576 49.921414,3.505781 49.92164,3.505671 49.92182,3.505528 49.921932,3.504685 49.921993,3.503697 49.922102,3.503136 49.922254,3.501687 49.922575,3.501481 49.922345,3.5012 49.922721,3.50018 49.924277,3.500971 49.924621,3.499811 49.925842,3.498335 49.925721,3.496226 49.925502,3.49536 49.926907,3.49462 49.927208,3.494004 49.927971,3.493612 49.928263,3.49239 49.929296,3.493246 49.929404,3.49348 49.92946,3.493552 49.929543,3.493514 49.929769,3.493087 49.930063,3.492805 49.930308,3.49191 49.931006,3.491323 49.932038,3.492651 49.933229,3.491347 49.934206,3.48827 49.934271,3.48265 49.934107)))"
    2 => 2000.0
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "sql" => "SELECT 1"
]

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

[
  "sql" => """
    \n
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(m.geom)) AS lat, ST_X(ST_Centroid(m.geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,\n
           ST_AsGeoJSON(ST_Force2D(m.geom), 6, 0) AS geom_geojson,\n
           COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) AS length_m\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(((3.48265 49.934107,3.481931 49.934226,3.481701 49.934823,3.480967 49.936372,3.481056 49.936628,3.481164 49.937984,3.481185 49.939242,3.480816 49.940171,3.482125 49.940838,3.482761 49.941231,3.482349 49.941522,3.482318 49.941604,3.483114 49.94218,3.484208 49.942912,3.484842 49.943243,3.484963 49.94309,3.485337 49.94275,3.485643 49.942614,3.486056 49.942302,3.486519 49.94235,3.486912 49.942435,3.487123 49.94256,3.486571 49.942733,3.486185 49.942952,3.486163 49.943174,3.486203 49.943358,3.486364 49.943739,3.486814 49.943862,3.487146 49.943921,3.487607 49.943944,3.488099 49.944025,3.489392 49.94358,3.490738 49.943731,3.491707 49.942102,3.494228 49.942603,3.495042 49.942828,3.494301 49.943458,3.493175 49.944358,3.492743 49.944763,3.494188 49.945223,3.494558 49.945328,3.493573 49.94697,3.494049 49.94704,3.495293 49.947203,3.495491 49.948213,3.49557 49.948455,3.495535 49.949058,3.495355 49.951401,3.496778 49.951593,3.496541 49.952774,3.499579 49.953144,3.499529 49.951835,3.499497 49.949006,3.499849 49.948815,3.500146 49.948622,3.50011 49.94834,3.500164 49.945453,3.501993 49.945861,3.502409 49.945009,3.502603 49.94466,3.503445 49.944256,3.503854 49.944008,3.504863 49.943345,3.505346 49.942637,3.505901 49.941802,3.50712 49.942113,3.507358 49.941534,3.507707 49.941117,3.508389 49.940431,3.508904 49.93988,3.50741 49.938665,3.508199 49.938153,3.509009 49.937653,3.510038 49.937142,3.511117 49.936798,3.511931 49.937518,3.512609 49.938091,3.51343 49.937753,3.516192 49.939427,3.516789 49.939837,3.516849 49.939743,3.521314 49.937832,3.521471 49.937842,3.522204 49.936944,3.522458 49.937409,3.523011 49.938052,3.523081 49.938194,3.523363 49.939241,3.523448 49.939456,3.523614 49.939685,3.525791 49.939133,3.527558 49.936933,3.527648 49.937001,3.528432 49.936424,3.530011 49.935245,3.530083 49.935245,3.531311 49.935796,3.532561 49.934909,3.533976 49.934322,3.535928 49.934955,3.536055 49.934643,3.536318 49.934135,3.537186 49.933622,3.537772 49.933239,3.538542 49.932484,3.538866 49.931065,3.538835 49.930915,3.535344 49.928979,3.536252 49.928506,3.536304 49.928506,3.538109 49.929394,3.539299 49.929989,3.542589 49.930374,3.542957 49.929211,3.543481 49.928273,3.543377 49.927778,3.54336 49.927487,3.543258 49.927214,3.54305 49.926874,3.542802 49.926681,3.542382 49.926181,3.542343 49.926055,3.542158 49.925904,3.541944 49.925952,3.541403 49.926007,3.540875 49.926101,3.540133 49.926319,3.539959 49.926305,3.539825 49.926105,3.539289 49.925191,3.537822 49.923022,3.537389 49.922395,3.537264 49.922244,3.536921 49.921663,3.536719 49.921592,3.536402 49.921607,3.534527 49.92167,3.534398 49.921599,3.533989 49.920783,3.533761 49.920259,3.533119 49.918866,3.532937 49.918562,3.532552 49.918461,3.531287 49.918247,3.530072 49.91797,3.529243 49.91781,3.528859 49.917856,3.527598 49.918115,3.525245 49.918564,3.523549 49.918892,3.521712 49.919462,3.520488 49.919901,3.518793 49.920664,3.517123 49.921343,3.515916 49.920623,3.51501 49.920138,3.514865 49.919886,3.514679 49.919367,3.514516 49.91868,3.513947 49.917665,3.513574 49.916947,3.513526 49.916722,3.513922 49.916529,3.51604 49.915629,3.516155 49.915376,3.515728 49.914959,3.515343 49.914805,3.514581 49.914586,3.513781 49.913327,3.516219 49.912018,3.515128 49.910597,3.51424 49.909788,3.513763 49.909455,3.513213 49.909747,3.513058 49.909801,3.511636 49.909944,3.509252 49.910163,3.508999 49.910175,3.508329 49.910146,3.50552 49.909912,3.50486 49.909874,3.504318 49.909895,3.503608 49.909994,3.503662 49.910225,3.503673 49.911695,3.503222 49.91243,3.503624 49.913276,3.504078 49.913116,3.505646 49.914109,3.505547 49.914526,3.505493 49.914631,3.50547 49.915021,3.505939 49.915885,3.503195 49.916338,3.503186 49.916402,3.504996 49.917707,3.50496 49.917974,3.50576 49.921414,3.505781 49.92164,3.505671 49.92182,3.505528 49.921932,3.504685 49.921993,3.503697 49.922102,3.503136 49.922254,3.501687 49.922575,3.501481 49.922345,3.5012 49.922721,3.50018 49.924277,3.500971 49.924621,3.499811 49.925842,3.498335 49.925721,3.496226 49.925502,3.49536 49.926907,3.49462 49.927208,3.494004 49.927971,3.493612 49.928263,3.49239 49.929296,3.493246 49.929404,3.49348 49.92946,3.493552 49.929543,3.493514 49.929769,3.493087 49.930063,3.492805 49.930308,3.49191 49.931006,3.491323 49.932038,3.492651 49.933229,3.491347 49.934206,3.48827 49.934271,3.48265 49.934107)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +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(((3.48265 49.934107,3.481931 49.934226,3.481701 49.934823,3.480967 49.936372,3.481056 49.936628,3.481164 49.937984,3.481185 49.939242,3.480816 49.940171,3.482125 49.940838,3.482761 49.941231,3.482349 49.941522,3.482318 49.941604,3.483114 49.94218,3.484208 49.942912,3.484842 49.943243,3.484963 49.94309,3.485337 49.94275,3.485643 49.942614,3.486056 49.942302,3.486519 49.94235,3.486912 49.942435,3.487123 49.94256,3.486571 49.942733,3.486185 49.942952,3.486163 49.943174,3.486203 49.943358,3.486364 49.943739,3.486814 49.943862,3.487146 49.943921,3.487607 49.943944,3.488099 49.944025,3.489392 49.94358,3.490738 49.943731,3.491707 49.942102,3.494228 49.942603,3.495042 49.942828,3.494301 49.943458,3.493175 49.944358,3.492743 49.944763,3.494188 49.945223,3.494558 49.945328,3.493573 49.94697,3.494049 49.94704,3.495293 49.947203,3.495491 49.948213,3.49557 49.948455,3.495535 49.949058,3.495355 49.951401,3.496778 49.951593,3.496541 49.952774,3.499579 49.953144,3.499529 49.951835,3.499497 49.949006,3.499849 49.948815,3.500146 49.948622,3.50011 49.94834,3.500164 49.945453,3.501993 49.945861,3.502409 49.945009,3.502603 49.94466,3.503445 49.944256,3.503854 49.944008,3.504863 49.943345,3.505346 49.942637,3.505901 49.941802,3.50712 49.942113,3.507358 49.941534,3.507707 49.941117,3.508389 49.940431,3.508904 49.93988,3.50741 49.938665,3.508199 49.938153,3.509009 49.937653,3.510038 49.937142,3.511117 49.936798,3.511931 49.937518,3.512609 49.938091,3.51343 49.937753,3.516192 49.939427,3.516789 49.939837,3.516849 49.939743,3.521314 49.937832,3.521471 49.937842,3.522204 49.936944,3.522458 49.937409,3.523011 49.938052,3.523081 49.938194,3.523363 49.939241,3.523448 49.939456,3.523614 49.939685,3.525791 49.939133,3.527558 49.936933,3.527648 49.937001,3.528432 49.936424,3.530011 49.935245,3.530083 49.935245,3.531311 49.935796,3.532561 49.934909,3.533976 49.934322,3.535928 49.934955,3.536055 49.934643,3.536318 49.934135,3.537186 49.933622,3.537772 49.933239,3.538542 49.932484,3.538866 49.931065,3.538835 49.930915,3.535344 49.928979,3.536252 49.928506,3.536304 49.928506,3.538109 49.929394,3.539299 49.929989,3.542589 49.930374,3.542957 49.929211,3.543481 49.928273,3.543377 49.927778,3.54336 49.927487,3.543258 49.927214,3.54305 49.926874,3.542802 49.926681,3.542382 49.926181,3.542343 49.926055,3.542158 49.925904,3.541944 49.925952,3.541403 49.926007,3.540875 49.926101,3.540133 49.926319,3.539959 49.926305,3.539825 49.926105,3.539289 49.925191,3.537822 49.923022,3.537389 49.922395,3.537264 49.922244,3.536921 49.921663,3.536719 49.921592,3.536402 49.921607,3.534527 49.92167,3.534398 49.921599,3.533989 49.920783,3.533761 49.920259,3.533119 49.918866,3.532937 49.918562,3.532552 49.918461,3.531287 49.918247,3.530072 49.91797,3.529243 49.91781,3.528859 49.917856,3.527598 49.918115,3.525245 49.918564,3.523549 49.918892,3.521712 49.919462,3.520488 49.919901,3.518793 49.920664,3.517123 49.921343,3.515916 49.920623,3.51501 49.920138,3.514865 49.919886,3.514679 49.919367,3.514516 49.91868,3.513947 49.917665,3.513574 49.916947,3.513526 49.916722,3.513922 49.916529,3.51604 49.915629,3.516155 49.915376,3.515728 49.914959,3.515343 49.914805,3.514581 49.914586,3.513781 49.913327,3.516219 49.912018,3.515128 49.910597,3.51424 49.909788,3.513763 49.909455,3.513213 49.909747,3.513058 49.909801,3.511636 49.909944,3.509252 49.910163,3.508999 49.910175,3.508329 49.910146,3.50552 49.909912,3.50486 49.909874,3.504318 49.909895,3.503608 49.909994,3.503662 49.910225,3.503673 49.911695,3.503222 49.91243,3.503624 49.913276,3.504078 49.913116,3.505646 49.914109,3.505547 49.914526,3.505493 49.914631,3.50547 49.915021,3.505939 49.915885,3.503195 49.916338,3.503186 49.916402,3.504996 49.917707,3.50496 49.917974,3.50576 49.921414,3.505781 49.92164,3.505671 49.92182,3.505528 49.921932,3.504685 49.921993,3.503697 49.922102,3.503136 49.922254,3.501687 49.922575,3.501481 49.922345,3.5012 49.922721,3.50018 49.924277,3.500971 49.924621,3.499811 49.925842,3.498335 49.925721,3.496226 49.925502,3.49536 49.926907,3.49462 49.927208,3.494004 49.927971,3.493612 49.928263,3.49239 49.929296,3.493246 49.929404,3.49348 49.92946,3.493552 49.929543,3.493514 49.929769,3.493087 49.930063,3.492805 49.930308,3.49191 49.931006,3.491323 49.932038,3.492651 49.933229,3.491347 49.934206,3.48827 49.934271,3.48265 49.934107)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "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
                FROM osm_object_meta m\n
                WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
                  AND osm_type IN ('way', 'relation')\n
                  AND (tags->'highway') IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
    """
  "params" => [
    1 => "MULTIPOLYGON(((3.48265 49.934107,3.481931 49.934226,3.481701 49.934823,3.480967 49.936372,3.481056 49.936628,3.481164 49.937984,3.481185 49.939242,3.480816 49.940171,3.482125 49.940838,3.482761 49.941231,3.482349 49.941522,3.482318 49.941604,3.483114 49.94218,3.484208 49.942912,3.484842 49.943243,3.484963 49.94309,3.485337 49.94275,3.485643 49.942614,3.486056 49.942302,3.486519 49.94235,3.486912 49.942435,3.487123 49.94256,3.486571 49.942733,3.486185 49.942952,3.486163 49.943174,3.486203 49.943358,3.486364 49.943739,3.486814 49.943862,3.487146 49.943921,3.487607 49.943944,3.488099 49.944025,3.489392 49.94358,3.490738 49.943731,3.491707 49.942102,3.494228 49.942603,3.495042 49.942828,3.494301 49.943458,3.493175 49.944358,3.492743 49.944763,3.494188 49.945223,3.494558 49.945328,3.493573 49.94697,3.494049 49.94704,3.495293 49.947203,3.495491 49.948213,3.49557 49.948455,3.495535 49.949058,3.495355 49.951401,3.496778 49.951593,3.496541 49.952774,3.499579 49.953144,3.499529 49.951835,3.499497 49.949006,3.499849 49.948815,3.500146 49.948622,3.50011 49.94834,3.500164 49.945453,3.501993 49.945861,3.502409 49.945009,3.502603 49.94466,3.503445 49.944256,3.503854 49.944008,3.504863 49.943345,3.505346 49.942637,3.505901 49.941802,3.50712 49.942113,3.507358 49.941534,3.507707 49.941117,3.508389 49.940431,3.508904 49.93988,3.50741 49.938665,3.508199 49.938153,3.509009 49.937653,3.510038 49.937142,3.511117 49.936798,3.511931 49.937518,3.512609 49.938091,3.51343 49.937753,3.516192 49.939427,3.516789 49.939837,3.516849 49.939743,3.521314 49.937832,3.521471 49.937842,3.522204 49.936944,3.522458 49.937409,3.523011 49.938052,3.523081 49.938194,3.523363 49.939241,3.523448 49.939456,3.523614 49.939685,3.525791 49.939133,3.527558 49.936933,3.527648 49.937001,3.528432 49.936424,3.530011 49.935245,3.530083 49.935245,3.531311 49.935796,3.532561 49.934909,3.533976 49.934322,3.535928 49.934955,3.536055 49.934643,3.536318 49.934135,3.537186 49.933622,3.537772 49.933239,3.538542 49.932484,3.538866 49.931065,3.538835 49.930915,3.535344 49.928979,3.536252 49.928506,3.536304 49.928506,3.538109 49.929394,3.539299 49.929989,3.542589 49.930374,3.542957 49.929211,3.543481 49.928273,3.543377 49.927778,3.54336 49.927487,3.543258 49.927214,3.54305 49.926874,3.542802 49.926681,3.542382 49.926181,3.542343 49.926055,3.542158 49.925904,3.541944 49.925952,3.541403 49.926007,3.540875 49.926101,3.540133 49.926319,3.539959 49.926305,3.539825 49.926105,3.539289 49.925191,3.537822 49.923022,3.537389 49.922395,3.537264 49.922244,3.536921 49.921663,3.536719 49.921592,3.536402 49.921607,3.534527 49.92167,3.534398 49.921599,3.533989 49.920783,3.533761 49.920259,3.533119 49.918866,3.532937 49.918562,3.532552 49.918461,3.531287 49.918247,3.530072 49.91797,3.529243 49.91781,3.528859 49.917856,3.527598 49.918115,3.525245 49.918564,3.523549 49.918892,3.521712 49.919462,3.520488 49.919901,3.518793 49.920664,3.517123 49.921343,3.515916 49.920623,3.51501 49.920138,3.514865 49.919886,3.514679 49.919367,3.514516 49.91868,3.513947 49.917665,3.513574 49.916947,3.513526 49.916722,3.513922 49.916529,3.51604 49.915629,3.516155 49.915376,3.515728 49.914959,3.515343 49.914805,3.514581 49.914586,3.513781 49.913327,3.516219 49.912018,3.515128 49.910597,3.51424 49.909788,3.513763 49.909455,3.513213 49.909747,3.513058 49.909801,3.511636 49.909944,3.509252 49.910163,3.508999 49.910175,3.508329 49.910146,3.50552 49.909912,3.50486 49.909874,3.504318 49.909895,3.503608 49.909994,3.503662 49.910225,3.503673 49.911695,3.503222 49.91243,3.503624 49.913276,3.504078 49.913116,3.505646 49.914109,3.505547 49.914526,3.505493 49.914631,3.50547 49.915021,3.505939 49.915885,3.503195 49.916338,3.503186 49.916402,3.504996 49.917707,3.50496 49.917974,3.50576 49.921414,3.505781 49.92164,3.505671 49.92182,3.505528 49.921932,3.504685 49.921993,3.503697 49.922102,3.503136 49.922254,3.501687 49.922575,3.501481 49.922345,3.5012 49.922721,3.50018 49.924277,3.500971 49.924621,3.499811 49.925842,3.498335 49.925721,3.496226 49.925502,3.49536 49.926907,3.49462 49.927208,3.494004 49.927971,3.493612 49.928263,3.49239 49.929296,3.493246 49.929404,3.49348 49.92946,3.493552 49.929543,3.493514 49.929769,3.493087 49.930063,3.492805 49.930308,3.49191 49.931006,3.491323 49.932038,3.492651 49.933229,3.491347 49.934206,3.48827 49.934271,3.48265 49.934107)))"
    2 => "motorway"
    3 => "trunk"
    4 => "primary"
    5 => "secondary"
    6 => "tertiary"
    7 => "unclassified"
    8 => "residential"
    9 => "living_street"
    10 => "motorway_link"
    11 => "trunk_link"
    12 => "primary_link"
    13 => "secondary_link"
    14 => "tertiary_link"
    15 => "service"
    16 => "road"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
    3 => Doctrine\DBAL\ParameterType {#588}
    4 => Doctrine\DBAL\ParameterType {#588}
    5 => Doctrine\DBAL\ParameterType {#588}
    6 => Doctrine\DBAL\ParameterType {#588}
    7 => Doctrine\DBAL\ParameterType {#588}
    8 => Doctrine\DBAL\ParameterType {#588}
    9 => Doctrine\DBAL\ParameterType {#588}
    10 => Doctrine\DBAL\ParameterType {#588}
    11 => Doctrine\DBAL\ParameterType {#588}
    12 => Doctrine\DBAL\ParameterType {#588}
    13 => Doctrine\DBAL\ParameterType {#588}
    14 => Doctrine\DBAL\ParameterType {#588}
    15 => Doctrine\DBAL\ParameterType {#588}
    16 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

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

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

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

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

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

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

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

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

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\WebpackEncoreBundle\EventListener\ResetAssetsEventListener::resetAssets"
]

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