Symfony Profiler

[
  "route" => "app_admin_stats"
  "route_parameters" => [
    "_route" => "app_admin_stats"
    "_controller" => "App\Controller\AdminController::stats"
    "insee_code" => "01229"
  ]
  "request_uri" => "https://osm-commerces.cipherbliss.com/admin/stats/01229"
  "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 => "01229"
  ]
  "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 => 26698
  ]
  "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":"01229","nom":"01229"}"
    3 => "2026-07-15 02:05:28"
    4 => "https://osm-commerces.cipherbliss.com/admin/labourer/01229?deleteMissing=1&disableFollowUpCleanup=1"
    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 => "01229"
  ]
  "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 => 26698
  ]
  "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 => "01229"
  ]
  "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 => "01229"
  ]
  "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 => "01229"
  ]
  "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(((5.139452 46.353022,5.139839 46.352828,5.14013 46.352772,5.141578 46.352648,5.14202 46.352115,5.142942 46.351277,5.143273 46.351194,5.143473 46.351213,5.143741 46.351182,5.144244 46.350701,5.14469 46.350411,5.144716 46.350333,5.144605 46.350054,5.144574 46.349898,5.144608 46.349766,5.14473 46.349595,5.144884 46.349472,5.145069 46.349398,5.145297 46.349364,5.145564 46.34937,5.145982 46.349421,5.14627 46.349266,5.146982 46.348566,5.147324 46.34844,5.147634 46.346791,5.148203 46.346654,5.148708 46.346454,5.149431 46.346124,5.149803 46.34599,5.150023 46.345963,5.150628 46.345964,5.150883 46.345531,5.15095 46.34535,5.150921 46.345008,5.15096 46.344667,5.151397 46.344349,5.151849 46.344168,5.152267 46.34387,5.152436 46.343725,5.152673 46.343831,5.154313 46.344872,5.155044 46.344237,5.155781 46.344527,5.157569 46.345005,5.158233 46.345096,5.158409 46.344732,5.160531 46.341798,5.161634 46.340435,5.161494 46.339892,5.161425 46.339804,5.161877 46.339689,5.162552 46.339305,5.162662 46.338999,5.162826 46.33841,5.162989 46.33656,5.163462 46.335648,5.163812 46.335104,5.164221 46.334553,5.164267 46.334337,5.164488 46.333982,5.16476 46.33361,5.164924 46.333252,5.164926 46.33317,5.165197 46.332769,5.167288 46.330474,5.167809 46.329832,5.167901 46.329761,5.168154 46.329444,5.168561 46.328898,5.168761 46.328726,5.167498 46.328373,5.167764 46.327941,5.166721 46.327517,5.165631 46.327182,5.163705 46.326952,5.163619 46.326841,5.163127 46.326699,5.162812 46.326581,5.162771 46.326306,5.161763 46.326568,5.161833 46.326766,5.161746 46.327058,5.161606 46.327153,5.161311 46.327143,5.160475 46.327229,5.160032 46.327348,5.159646 46.327413,5.159462 46.327422,5.158974 46.327402,5.158641 46.327349,5.15815 46.327337,5.157951 46.327304,5.157802 46.327062,5.15767 46.326936,5.157582 46.326581,5.157422 46.326248,5.15704 46.325794,5.15701 46.325636,5.157084 46.325286,5.157159 46.325126,5.156663 46.324974,5.1564 46.324943,5.156131 46.324969,5.155828 46.325032,5.155376 46.324875,5.155126 46.32475,5.155548 46.324161,5.154862 46.323947,5.154453 46.323745,5.154098 46.32351,5.153567 46.322989,5.153392 46.323015,5.153038 46.323229,5.15166 46.323838,5.150661 46.324213,5.15026 46.323793,5.150191 46.323604,5.150197 46.323096,5.150219 46.322855,5.150323 46.322388,5.150463 46.321996,5.150454 46.321818,5.150366 46.321709,5.149824 46.321253,5.149536 46.320976,5.149451 46.320751,5.149416 46.320482,5.149267 46.320249,5.149112 46.320078,5.148939 46.319765,5.148906 46.3196,5.149025 46.319291,5.149123 46.318955,5.149242 46.318802,5.149426 46.318667,5.149735 46.318389,5.149992 46.318105,5.150386 46.31806,5.150767 46.318047,5.151127 46.317909,5.151293 46.317782,5.151234 46.317601,5.150963 46.317308,5.15091 46.317178,5.149945 46.316492,5.149253 46.316377,5.148227 46.315977,5.148176 46.31553,5.148233 46.315164,5.14828 46.315096,5.147786 46.314883,5.147575 46.314844,5.145599 46.314895,5.145446 46.314685,5.144948 46.314276,5.144567 46.313889,5.143818 46.312955,5.14372 46.312802,5.143792 46.312686,5.143158 46.312298,5.142852 46.31215,5.142427 46.312035,5.1422 46.311994,5.141711 46.311827,5.141479 46.311712,5.140794 46.311286,5.140821 46.310964,5.140715 46.310647,5.140429 46.310192,5.140315 46.309889,5.140347 46.309626,5.141138 46.308519,5.141278 46.308242,5.140736 46.308125,5.140435 46.308079,5.139296 46.308042,5.138183 46.308028,5.137938 46.307583,5.137599 46.307013,5.137331 46.307084,5.136875 46.307094,5.135861 46.307243,5.134841 46.30743,5.134321 46.307488,5.133859 46.307449,5.134192 46.307085,5.134168 46.30696,5.134046 46.306869,5.133358 46.307005,5.132812 46.307053,5.132284 46.307153,5.13192 46.307294,5.13167 46.307537,5.131331 46.307577,5.131383 46.307415,5.130905 46.307388,5.130245 46.307329,5.129544 46.307389,5.129629 46.307002,5.129255 46.30684,5.128568 46.306826,5.12829 46.306839,5.128057 46.307071,5.127664 46.307324,5.127401 46.307448,5.127029 46.307801,5.126703 46.308275,5.126532 46.308485,5.126018 46.308802,5.12553 46.308991,5.124912 46.309175,5.124229 46.30938,5.124526 46.310085,5.124795 46.310484,5.124255 46.310704,5.123615 46.310901,5.123755 46.311109,5.123809 46.31127,5.123712 46.311479,5.123622 46.311557,5.12361 46.311683,5.12393 46.312234,5.124098 46.312349,5.123698 46.312827,5.123767 46.313314,5.123773 46.313603,5.123563 46.313609,5.123597 46.313913,5.123988 46.31531,5.124019 46.315675,5.123876 46.316174,5.123796 46.316574,5.123783 46.316874,5.123853 46.31707,5.123973 46.317528,5.12405 46.317984,5.124928 46.317895,5.12522 46.318952,5.125535 46.319639,5.126275 46.319814,5.126772 46.319722,5.127586 46.319642,5.127604 46.31981,5.127976 46.319682,5.128101 46.319612,5.128471 46.319597,5.128812 46.319689,5.12848 46.320158,5.128153 46.320866,5.127937 46.320815,5.127767 46.321382,5.127631 46.321529,5.127397 46.321716,5.127369 46.321885,5.127388 46.322857,5.127347 46.323241,5.127458 46.323851,5.127656 46.324184,5.126988 46.324525,5.12617 46.324895,5.126116 46.325042,5.126109 46.325426,5.126249 46.325442,5.127593 46.325737,5.128173 46.325878,5.129191 46.326147,5.128833 46.326963,5.128337 46.327425,5.127988 46.328084,5.127844 46.328775,5.127702 46.32915,5.127524 46.329743,5.127335 46.330081,5.127165 46.330293,5.127194 46.330505,5.127372 46.330619,5.128264 46.331122,5.128352 46.331423,5.128682 46.333084,5.128817 46.333506,5.129004 46.333639,5.12951 46.333839,5.130659 46.333798,5.130186 46.334531,5.129213 46.336116,5.130356 46.336517,5.131014 46.336795,5.131483 46.33681,5.132283 46.336781,5.132615 46.33682,5.13405 46.337136,5.134444 46.337236,5.134032 46.337966,5.134048 46.338306,5.134132 46.338562,5.134127 46.338836,5.133989 46.33905,5.133811 46.3392,5.133323 46.339431,5.133028 46.33974,5.132959 46.339916,5.132955 46.34013,5.133069 46.340732,5.133093 46.341166,5.133148 46.341548,5.133253 46.341996,5.133216 46.3421,5.132926 46.342457,5.132875 46.342616,5.13308 46.342639,5.133111 46.342904,5.133494 46.343391,5.133777 46.343467,5.133805 46.343659,5.133987 46.343806,5.135143 46.344813,5.136444 46.346086,5.137331 46.346865,5.137801 46.347245,5.138089 46.347369,5.13901 46.348157,5.139437 46.348385,5.139544 46.348526,5.139516 46.348703,5.139199 46.348801,5.138941 46.349131,5.138877 46.349248,5.139445 46.349429,5.139475 46.349569,5.139389 46.349672,5.139105 46.349791,5.139088 46.350156,5.139173 46.350411,5.139349 46.351386,5.139193 46.351609,5.139274 46.351656,5.138906 46.352663,5.139005 46.352691,5.13911 46.352874,5.139327 46.352917,5.139452 46.353022)))"
    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(((5.139452 46.353022,5.139839 46.352828,5.14013 46.352772,5.141578 46.352648,5.14202 46.352115,5.142942 46.351277,5.143273 46.351194,5.143473 46.351213,5.143741 46.351182,5.144244 46.350701,5.14469 46.350411,5.144716 46.350333,5.144605 46.350054,5.144574 46.349898,5.144608 46.349766,5.14473 46.349595,5.144884 46.349472,5.145069 46.349398,5.145297 46.349364,5.145564 46.34937,5.145982 46.349421,5.14627 46.349266,5.146982 46.348566,5.147324 46.34844,5.147634 46.346791,5.148203 46.346654,5.148708 46.346454,5.149431 46.346124,5.149803 46.34599,5.150023 46.345963,5.150628 46.345964,5.150883 46.345531,5.15095 46.34535,5.150921 46.345008,5.15096 46.344667,5.151397 46.344349,5.151849 46.344168,5.152267 46.34387,5.152436 46.343725,5.152673 46.343831,5.154313 46.344872,5.155044 46.344237,5.155781 46.344527,5.157569 46.345005,5.158233 46.345096,5.158409 46.344732,5.160531 46.341798,5.161634 46.340435,5.161494 46.339892,5.161425 46.339804,5.161877 46.339689,5.162552 46.339305,5.162662 46.338999,5.162826 46.33841,5.162989 46.33656,5.163462 46.335648,5.163812 46.335104,5.164221 46.334553,5.164267 46.334337,5.164488 46.333982,5.16476 46.33361,5.164924 46.333252,5.164926 46.33317,5.165197 46.332769,5.167288 46.330474,5.167809 46.329832,5.167901 46.329761,5.168154 46.329444,5.168561 46.328898,5.168761 46.328726,5.167498 46.328373,5.167764 46.327941,5.166721 46.327517,5.165631 46.327182,5.163705 46.326952,5.163619 46.326841,5.163127 46.326699,5.162812 46.326581,5.162771 46.326306,5.161763 46.326568,5.161833 46.326766,5.161746 46.327058,5.161606 46.327153,5.161311 46.327143,5.160475 46.327229,5.160032 46.327348,5.159646 46.327413,5.159462 46.327422,5.158974 46.327402,5.158641 46.327349,5.15815 46.327337,5.157951 46.327304,5.157802 46.327062,5.15767 46.326936,5.157582 46.326581,5.157422 46.326248,5.15704 46.325794,5.15701 46.325636,5.157084 46.325286,5.157159 46.325126,5.156663 46.324974,5.1564 46.324943,5.156131 46.324969,5.155828 46.325032,5.155376 46.324875,5.155126 46.32475,5.155548 46.324161,5.154862 46.323947,5.154453 46.323745,5.154098 46.32351,5.153567 46.322989,5.153392 46.323015,5.153038 46.323229,5.15166 46.323838,5.150661 46.324213,5.15026 46.323793,5.150191 46.323604,5.150197 46.323096,5.150219 46.322855,5.150323 46.322388,5.150463 46.321996,5.150454 46.321818,5.150366 46.321709,5.149824 46.321253,5.149536 46.320976,5.149451 46.320751,5.149416 46.320482,5.149267 46.320249,5.149112 46.320078,5.148939 46.319765,5.148906 46.3196,5.149025 46.319291,5.149123 46.318955,5.149242 46.318802,5.149426 46.318667,5.149735 46.318389,5.149992 46.318105,5.150386 46.31806,5.150767 46.318047,5.151127 46.317909,5.151293 46.317782,5.151234 46.317601,5.150963 46.317308,5.15091 46.317178,5.149945 46.316492,5.149253 46.316377,5.148227 46.315977,5.148176 46.31553,5.148233 46.315164,5.14828 46.315096,5.147786 46.314883,5.147575 46.314844,5.145599 46.314895,5.145446 46.314685,5.144948 46.314276,5.144567 46.313889,5.143818 46.312955,5.14372 46.312802,5.143792 46.312686,5.143158 46.312298,5.142852 46.31215,5.142427 46.312035,5.1422 46.311994,5.141711 46.311827,5.141479 46.311712,5.140794 46.311286,5.140821 46.310964,5.140715 46.310647,5.140429 46.310192,5.140315 46.309889,5.140347 46.309626,5.141138 46.308519,5.141278 46.308242,5.140736 46.308125,5.140435 46.308079,5.139296 46.308042,5.138183 46.308028,5.137938 46.307583,5.137599 46.307013,5.137331 46.307084,5.136875 46.307094,5.135861 46.307243,5.134841 46.30743,5.134321 46.307488,5.133859 46.307449,5.134192 46.307085,5.134168 46.30696,5.134046 46.306869,5.133358 46.307005,5.132812 46.307053,5.132284 46.307153,5.13192 46.307294,5.13167 46.307537,5.131331 46.307577,5.131383 46.307415,5.130905 46.307388,5.130245 46.307329,5.129544 46.307389,5.129629 46.307002,5.129255 46.30684,5.128568 46.306826,5.12829 46.306839,5.128057 46.307071,5.127664 46.307324,5.127401 46.307448,5.127029 46.307801,5.126703 46.308275,5.126532 46.308485,5.126018 46.308802,5.12553 46.308991,5.124912 46.309175,5.124229 46.30938,5.124526 46.310085,5.124795 46.310484,5.124255 46.310704,5.123615 46.310901,5.123755 46.311109,5.123809 46.31127,5.123712 46.311479,5.123622 46.311557,5.12361 46.311683,5.12393 46.312234,5.124098 46.312349,5.123698 46.312827,5.123767 46.313314,5.123773 46.313603,5.123563 46.313609,5.123597 46.313913,5.123988 46.31531,5.124019 46.315675,5.123876 46.316174,5.123796 46.316574,5.123783 46.316874,5.123853 46.31707,5.123973 46.317528,5.12405 46.317984,5.124928 46.317895,5.12522 46.318952,5.125535 46.319639,5.126275 46.319814,5.126772 46.319722,5.127586 46.319642,5.127604 46.31981,5.127976 46.319682,5.128101 46.319612,5.128471 46.319597,5.128812 46.319689,5.12848 46.320158,5.128153 46.320866,5.127937 46.320815,5.127767 46.321382,5.127631 46.321529,5.127397 46.321716,5.127369 46.321885,5.127388 46.322857,5.127347 46.323241,5.127458 46.323851,5.127656 46.324184,5.126988 46.324525,5.12617 46.324895,5.126116 46.325042,5.126109 46.325426,5.126249 46.325442,5.127593 46.325737,5.128173 46.325878,5.129191 46.326147,5.128833 46.326963,5.128337 46.327425,5.127988 46.328084,5.127844 46.328775,5.127702 46.32915,5.127524 46.329743,5.127335 46.330081,5.127165 46.330293,5.127194 46.330505,5.127372 46.330619,5.128264 46.331122,5.128352 46.331423,5.128682 46.333084,5.128817 46.333506,5.129004 46.333639,5.12951 46.333839,5.130659 46.333798,5.130186 46.334531,5.129213 46.336116,5.130356 46.336517,5.131014 46.336795,5.131483 46.33681,5.132283 46.336781,5.132615 46.33682,5.13405 46.337136,5.134444 46.337236,5.134032 46.337966,5.134048 46.338306,5.134132 46.338562,5.134127 46.338836,5.133989 46.33905,5.133811 46.3392,5.133323 46.339431,5.133028 46.33974,5.132959 46.339916,5.132955 46.34013,5.133069 46.340732,5.133093 46.341166,5.133148 46.341548,5.133253 46.341996,5.133216 46.3421,5.132926 46.342457,5.132875 46.342616,5.13308 46.342639,5.133111 46.342904,5.133494 46.343391,5.133777 46.343467,5.133805 46.343659,5.133987 46.343806,5.135143 46.344813,5.136444 46.346086,5.137331 46.346865,5.137801 46.347245,5.138089 46.347369,5.13901 46.348157,5.139437 46.348385,5.139544 46.348526,5.139516 46.348703,5.139199 46.348801,5.138941 46.349131,5.138877 46.349248,5.139445 46.349429,5.139475 46.349569,5.139389 46.349672,5.139105 46.349791,5.139088 46.350156,5.139173 46.350411,5.139349 46.351386,5.139193 46.351609,5.139274 46.351656,5.138906 46.352663,5.139005 46.352691,5.13911 46.352874,5.139327 46.352917,5.139452 46.353022)))"
  ]
  "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(((5.139452 46.353022,5.139839 46.352828,5.14013 46.352772,5.141578 46.352648,5.14202 46.352115,5.142942 46.351277,5.143273 46.351194,5.143473 46.351213,5.143741 46.351182,5.144244 46.350701,5.14469 46.350411,5.144716 46.350333,5.144605 46.350054,5.144574 46.349898,5.144608 46.349766,5.14473 46.349595,5.144884 46.349472,5.145069 46.349398,5.145297 46.349364,5.145564 46.34937,5.145982 46.349421,5.14627 46.349266,5.146982 46.348566,5.147324 46.34844,5.147634 46.346791,5.148203 46.346654,5.148708 46.346454,5.149431 46.346124,5.149803 46.34599,5.150023 46.345963,5.150628 46.345964,5.150883 46.345531,5.15095 46.34535,5.150921 46.345008,5.15096 46.344667,5.151397 46.344349,5.151849 46.344168,5.152267 46.34387,5.152436 46.343725,5.152673 46.343831,5.154313 46.344872,5.155044 46.344237,5.155781 46.344527,5.157569 46.345005,5.158233 46.345096,5.158409 46.344732,5.160531 46.341798,5.161634 46.340435,5.161494 46.339892,5.161425 46.339804,5.161877 46.339689,5.162552 46.339305,5.162662 46.338999,5.162826 46.33841,5.162989 46.33656,5.163462 46.335648,5.163812 46.335104,5.164221 46.334553,5.164267 46.334337,5.164488 46.333982,5.16476 46.33361,5.164924 46.333252,5.164926 46.33317,5.165197 46.332769,5.167288 46.330474,5.167809 46.329832,5.167901 46.329761,5.168154 46.329444,5.168561 46.328898,5.168761 46.328726,5.167498 46.328373,5.167764 46.327941,5.166721 46.327517,5.165631 46.327182,5.163705 46.326952,5.163619 46.326841,5.163127 46.326699,5.162812 46.326581,5.162771 46.326306,5.161763 46.326568,5.161833 46.326766,5.161746 46.327058,5.161606 46.327153,5.161311 46.327143,5.160475 46.327229,5.160032 46.327348,5.159646 46.327413,5.159462 46.327422,5.158974 46.327402,5.158641 46.327349,5.15815 46.327337,5.157951 46.327304,5.157802 46.327062,5.15767 46.326936,5.157582 46.326581,5.157422 46.326248,5.15704 46.325794,5.15701 46.325636,5.157084 46.325286,5.157159 46.325126,5.156663 46.324974,5.1564 46.324943,5.156131 46.324969,5.155828 46.325032,5.155376 46.324875,5.155126 46.32475,5.155548 46.324161,5.154862 46.323947,5.154453 46.323745,5.154098 46.32351,5.153567 46.322989,5.153392 46.323015,5.153038 46.323229,5.15166 46.323838,5.150661 46.324213,5.15026 46.323793,5.150191 46.323604,5.150197 46.323096,5.150219 46.322855,5.150323 46.322388,5.150463 46.321996,5.150454 46.321818,5.150366 46.321709,5.149824 46.321253,5.149536 46.320976,5.149451 46.320751,5.149416 46.320482,5.149267 46.320249,5.149112 46.320078,5.148939 46.319765,5.148906 46.3196,5.149025 46.319291,5.149123 46.318955,5.149242 46.318802,5.149426 46.318667,5.149735 46.318389,5.149992 46.318105,5.150386 46.31806,5.150767 46.318047,5.151127 46.317909,5.151293 46.317782,5.151234 46.317601,5.150963 46.317308,5.15091 46.317178,5.149945 46.316492,5.149253 46.316377,5.148227 46.315977,5.148176 46.31553,5.148233 46.315164,5.14828 46.315096,5.147786 46.314883,5.147575 46.314844,5.145599 46.314895,5.145446 46.314685,5.144948 46.314276,5.144567 46.313889,5.143818 46.312955,5.14372 46.312802,5.143792 46.312686,5.143158 46.312298,5.142852 46.31215,5.142427 46.312035,5.1422 46.311994,5.141711 46.311827,5.141479 46.311712,5.140794 46.311286,5.140821 46.310964,5.140715 46.310647,5.140429 46.310192,5.140315 46.309889,5.140347 46.309626,5.141138 46.308519,5.141278 46.308242,5.140736 46.308125,5.140435 46.308079,5.139296 46.308042,5.138183 46.308028,5.137938 46.307583,5.137599 46.307013,5.137331 46.307084,5.136875 46.307094,5.135861 46.307243,5.134841 46.30743,5.134321 46.307488,5.133859 46.307449,5.134192 46.307085,5.134168 46.30696,5.134046 46.306869,5.133358 46.307005,5.132812 46.307053,5.132284 46.307153,5.13192 46.307294,5.13167 46.307537,5.131331 46.307577,5.131383 46.307415,5.130905 46.307388,5.130245 46.307329,5.129544 46.307389,5.129629 46.307002,5.129255 46.30684,5.128568 46.306826,5.12829 46.306839,5.128057 46.307071,5.127664 46.307324,5.127401 46.307448,5.127029 46.307801,5.126703 46.308275,5.126532 46.308485,5.126018 46.308802,5.12553 46.308991,5.124912 46.309175,5.124229 46.30938,5.124526 46.310085,5.124795 46.310484,5.124255 46.310704,5.123615 46.310901,5.123755 46.311109,5.123809 46.31127,5.123712 46.311479,5.123622 46.311557,5.12361 46.311683,5.12393 46.312234,5.124098 46.312349,5.123698 46.312827,5.123767 46.313314,5.123773 46.313603,5.123563 46.313609,5.123597 46.313913,5.123988 46.31531,5.124019 46.315675,5.123876 46.316174,5.123796 46.316574,5.123783 46.316874,5.123853 46.31707,5.123973 46.317528,5.12405 46.317984,5.124928 46.317895,5.12522 46.318952,5.125535 46.319639,5.126275 46.319814,5.126772 46.319722,5.127586 46.319642,5.127604 46.31981,5.127976 46.319682,5.128101 46.319612,5.128471 46.319597,5.128812 46.319689,5.12848 46.320158,5.128153 46.320866,5.127937 46.320815,5.127767 46.321382,5.127631 46.321529,5.127397 46.321716,5.127369 46.321885,5.127388 46.322857,5.127347 46.323241,5.127458 46.323851,5.127656 46.324184,5.126988 46.324525,5.12617 46.324895,5.126116 46.325042,5.126109 46.325426,5.126249 46.325442,5.127593 46.325737,5.128173 46.325878,5.129191 46.326147,5.128833 46.326963,5.128337 46.327425,5.127988 46.328084,5.127844 46.328775,5.127702 46.32915,5.127524 46.329743,5.127335 46.330081,5.127165 46.330293,5.127194 46.330505,5.127372 46.330619,5.128264 46.331122,5.128352 46.331423,5.128682 46.333084,5.128817 46.333506,5.129004 46.333639,5.12951 46.333839,5.130659 46.333798,5.130186 46.334531,5.129213 46.336116,5.130356 46.336517,5.131014 46.336795,5.131483 46.33681,5.132283 46.336781,5.132615 46.33682,5.13405 46.337136,5.134444 46.337236,5.134032 46.337966,5.134048 46.338306,5.134132 46.338562,5.134127 46.338836,5.133989 46.33905,5.133811 46.3392,5.133323 46.339431,5.133028 46.33974,5.132959 46.339916,5.132955 46.34013,5.133069 46.340732,5.133093 46.341166,5.133148 46.341548,5.133253 46.341996,5.133216 46.3421,5.132926 46.342457,5.132875 46.342616,5.13308 46.342639,5.133111 46.342904,5.133494 46.343391,5.133777 46.343467,5.133805 46.343659,5.133987 46.343806,5.135143 46.344813,5.136444 46.346086,5.137331 46.346865,5.137801 46.347245,5.138089 46.347369,5.13901 46.348157,5.139437 46.348385,5.139544 46.348526,5.139516 46.348703,5.139199 46.348801,5.138941 46.349131,5.138877 46.349248,5.139445 46.349429,5.139475 46.349569,5.139389 46.349672,5.139105 46.349791,5.139088 46.350156,5.139173 46.350411,5.139349 46.351386,5.139193 46.351609,5.139274 46.351656,5.138906 46.352663,5.139005 46.352691,5.13911 46.352874,5.139327 46.352917,5.139452 46.353022)))"
  ]
  "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(((5.139452 46.353022,5.139839 46.352828,5.14013 46.352772,5.141578 46.352648,5.14202 46.352115,5.142942 46.351277,5.143273 46.351194,5.143473 46.351213,5.143741 46.351182,5.144244 46.350701,5.14469 46.350411,5.144716 46.350333,5.144605 46.350054,5.144574 46.349898,5.144608 46.349766,5.14473 46.349595,5.144884 46.349472,5.145069 46.349398,5.145297 46.349364,5.145564 46.34937,5.145982 46.349421,5.14627 46.349266,5.146982 46.348566,5.147324 46.34844,5.147634 46.346791,5.148203 46.346654,5.148708 46.346454,5.149431 46.346124,5.149803 46.34599,5.150023 46.345963,5.150628 46.345964,5.150883 46.345531,5.15095 46.34535,5.150921 46.345008,5.15096 46.344667,5.151397 46.344349,5.151849 46.344168,5.152267 46.34387,5.152436 46.343725,5.152673 46.343831,5.154313 46.344872,5.155044 46.344237,5.155781 46.344527,5.157569 46.345005,5.158233 46.345096,5.158409 46.344732,5.160531 46.341798,5.161634 46.340435,5.161494 46.339892,5.161425 46.339804,5.161877 46.339689,5.162552 46.339305,5.162662 46.338999,5.162826 46.33841,5.162989 46.33656,5.163462 46.335648,5.163812 46.335104,5.164221 46.334553,5.164267 46.334337,5.164488 46.333982,5.16476 46.33361,5.164924 46.333252,5.164926 46.33317,5.165197 46.332769,5.167288 46.330474,5.167809 46.329832,5.167901 46.329761,5.168154 46.329444,5.168561 46.328898,5.168761 46.328726,5.167498 46.328373,5.167764 46.327941,5.166721 46.327517,5.165631 46.327182,5.163705 46.326952,5.163619 46.326841,5.163127 46.326699,5.162812 46.326581,5.162771 46.326306,5.161763 46.326568,5.161833 46.326766,5.161746 46.327058,5.161606 46.327153,5.161311 46.327143,5.160475 46.327229,5.160032 46.327348,5.159646 46.327413,5.159462 46.327422,5.158974 46.327402,5.158641 46.327349,5.15815 46.327337,5.157951 46.327304,5.157802 46.327062,5.15767 46.326936,5.157582 46.326581,5.157422 46.326248,5.15704 46.325794,5.15701 46.325636,5.157084 46.325286,5.157159 46.325126,5.156663 46.324974,5.1564 46.324943,5.156131 46.324969,5.155828 46.325032,5.155376 46.324875,5.155126 46.32475,5.155548 46.324161,5.154862 46.323947,5.154453 46.323745,5.154098 46.32351,5.153567 46.322989,5.153392 46.323015,5.153038 46.323229,5.15166 46.323838,5.150661 46.324213,5.15026 46.323793,5.150191 46.323604,5.150197 46.323096,5.150219 46.322855,5.150323 46.322388,5.150463 46.321996,5.150454 46.321818,5.150366 46.321709,5.149824 46.321253,5.149536 46.320976,5.149451 46.320751,5.149416 46.320482,5.149267 46.320249,5.149112 46.320078,5.148939 46.319765,5.148906 46.3196,5.149025 46.319291,5.149123 46.318955,5.149242 46.318802,5.149426 46.318667,5.149735 46.318389,5.149992 46.318105,5.150386 46.31806,5.150767 46.318047,5.151127 46.317909,5.151293 46.317782,5.151234 46.317601,5.150963 46.317308,5.15091 46.317178,5.149945 46.316492,5.149253 46.316377,5.148227 46.315977,5.148176 46.31553,5.148233 46.315164,5.14828 46.315096,5.147786 46.314883,5.147575 46.314844,5.145599 46.314895,5.145446 46.314685,5.144948 46.314276,5.144567 46.313889,5.143818 46.312955,5.14372 46.312802,5.143792 46.312686,5.143158 46.312298,5.142852 46.31215,5.142427 46.312035,5.1422 46.311994,5.141711 46.311827,5.141479 46.311712,5.140794 46.311286,5.140821 46.310964,5.140715 46.310647,5.140429 46.310192,5.140315 46.309889,5.140347 46.309626,5.141138 46.308519,5.141278 46.308242,5.140736 46.308125,5.140435 46.308079,5.139296 46.308042,5.138183 46.308028,5.137938 46.307583,5.137599 46.307013,5.137331 46.307084,5.136875 46.307094,5.135861 46.307243,5.134841 46.30743,5.134321 46.307488,5.133859 46.307449,5.134192 46.307085,5.134168 46.30696,5.134046 46.306869,5.133358 46.307005,5.132812 46.307053,5.132284 46.307153,5.13192 46.307294,5.13167 46.307537,5.131331 46.307577,5.131383 46.307415,5.130905 46.307388,5.130245 46.307329,5.129544 46.307389,5.129629 46.307002,5.129255 46.30684,5.128568 46.306826,5.12829 46.306839,5.128057 46.307071,5.127664 46.307324,5.127401 46.307448,5.127029 46.307801,5.126703 46.308275,5.126532 46.308485,5.126018 46.308802,5.12553 46.308991,5.124912 46.309175,5.124229 46.30938,5.124526 46.310085,5.124795 46.310484,5.124255 46.310704,5.123615 46.310901,5.123755 46.311109,5.123809 46.31127,5.123712 46.311479,5.123622 46.311557,5.12361 46.311683,5.12393 46.312234,5.124098 46.312349,5.123698 46.312827,5.123767 46.313314,5.123773 46.313603,5.123563 46.313609,5.123597 46.313913,5.123988 46.31531,5.124019 46.315675,5.123876 46.316174,5.123796 46.316574,5.123783 46.316874,5.123853 46.31707,5.123973 46.317528,5.12405 46.317984,5.124928 46.317895,5.12522 46.318952,5.125535 46.319639,5.126275 46.319814,5.126772 46.319722,5.127586 46.319642,5.127604 46.31981,5.127976 46.319682,5.128101 46.319612,5.128471 46.319597,5.128812 46.319689,5.12848 46.320158,5.128153 46.320866,5.127937 46.320815,5.127767 46.321382,5.127631 46.321529,5.127397 46.321716,5.127369 46.321885,5.127388 46.322857,5.127347 46.323241,5.127458 46.323851,5.127656 46.324184,5.126988 46.324525,5.12617 46.324895,5.126116 46.325042,5.126109 46.325426,5.126249 46.325442,5.127593 46.325737,5.128173 46.325878,5.129191 46.326147,5.128833 46.326963,5.128337 46.327425,5.127988 46.328084,5.127844 46.328775,5.127702 46.32915,5.127524 46.329743,5.127335 46.330081,5.127165 46.330293,5.127194 46.330505,5.127372 46.330619,5.128264 46.331122,5.128352 46.331423,5.128682 46.333084,5.128817 46.333506,5.129004 46.333639,5.12951 46.333839,5.130659 46.333798,5.130186 46.334531,5.129213 46.336116,5.130356 46.336517,5.131014 46.336795,5.131483 46.33681,5.132283 46.336781,5.132615 46.33682,5.13405 46.337136,5.134444 46.337236,5.134032 46.337966,5.134048 46.338306,5.134132 46.338562,5.134127 46.338836,5.133989 46.33905,5.133811 46.3392,5.133323 46.339431,5.133028 46.33974,5.132959 46.339916,5.132955 46.34013,5.133069 46.340732,5.133093 46.341166,5.133148 46.341548,5.133253 46.341996,5.133216 46.3421,5.132926 46.342457,5.132875 46.342616,5.13308 46.342639,5.133111 46.342904,5.133494 46.343391,5.133777 46.343467,5.133805 46.343659,5.133987 46.343806,5.135143 46.344813,5.136444 46.346086,5.137331 46.346865,5.137801 46.347245,5.138089 46.347369,5.13901 46.348157,5.139437 46.348385,5.139544 46.348526,5.139516 46.348703,5.139199 46.348801,5.138941 46.349131,5.138877 46.349248,5.139445 46.349429,5.139475 46.349569,5.139389 46.349672,5.139105 46.349791,5.139088 46.350156,5.139173 46.350411,5.139349 46.351386,5.139193 46.351609,5.139274 46.351656,5.138906 46.352663,5.139005 46.352691,5.13911 46.352874,5.139327 46.352917,5.139452 46.353022)))"
  ]
  "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(((5.139452 46.353022,5.139839 46.352828,5.14013 46.352772,5.141578 46.352648,5.14202 46.352115,5.142942 46.351277,5.143273 46.351194,5.143473 46.351213,5.143741 46.351182,5.144244 46.350701,5.14469 46.350411,5.144716 46.350333,5.144605 46.350054,5.144574 46.349898,5.144608 46.349766,5.14473 46.349595,5.144884 46.349472,5.145069 46.349398,5.145297 46.349364,5.145564 46.34937,5.145982 46.349421,5.14627 46.349266,5.146982 46.348566,5.147324 46.34844,5.147634 46.346791,5.148203 46.346654,5.148708 46.346454,5.149431 46.346124,5.149803 46.34599,5.150023 46.345963,5.150628 46.345964,5.150883 46.345531,5.15095 46.34535,5.150921 46.345008,5.15096 46.344667,5.151397 46.344349,5.151849 46.344168,5.152267 46.34387,5.152436 46.343725,5.152673 46.343831,5.154313 46.344872,5.155044 46.344237,5.155781 46.344527,5.157569 46.345005,5.158233 46.345096,5.158409 46.344732,5.160531 46.341798,5.161634 46.340435,5.161494 46.339892,5.161425 46.339804,5.161877 46.339689,5.162552 46.339305,5.162662 46.338999,5.162826 46.33841,5.162989 46.33656,5.163462 46.335648,5.163812 46.335104,5.164221 46.334553,5.164267 46.334337,5.164488 46.333982,5.16476 46.33361,5.164924 46.333252,5.164926 46.33317,5.165197 46.332769,5.167288 46.330474,5.167809 46.329832,5.167901 46.329761,5.168154 46.329444,5.168561 46.328898,5.168761 46.328726,5.167498 46.328373,5.167764 46.327941,5.166721 46.327517,5.165631 46.327182,5.163705 46.326952,5.163619 46.326841,5.163127 46.326699,5.162812 46.326581,5.162771 46.326306,5.161763 46.326568,5.161833 46.326766,5.161746 46.327058,5.161606 46.327153,5.161311 46.327143,5.160475 46.327229,5.160032 46.327348,5.159646 46.327413,5.159462 46.327422,5.158974 46.327402,5.158641 46.327349,5.15815 46.327337,5.157951 46.327304,5.157802 46.327062,5.15767 46.326936,5.157582 46.326581,5.157422 46.326248,5.15704 46.325794,5.15701 46.325636,5.157084 46.325286,5.157159 46.325126,5.156663 46.324974,5.1564 46.324943,5.156131 46.324969,5.155828 46.325032,5.155376 46.324875,5.155126 46.32475,5.155548 46.324161,5.154862 46.323947,5.154453 46.323745,5.154098 46.32351,5.153567 46.322989,5.153392 46.323015,5.153038 46.323229,5.15166 46.323838,5.150661 46.324213,5.15026 46.323793,5.150191 46.323604,5.150197 46.323096,5.150219 46.322855,5.150323 46.322388,5.150463 46.321996,5.150454 46.321818,5.150366 46.321709,5.149824 46.321253,5.149536 46.320976,5.149451 46.320751,5.149416 46.320482,5.149267 46.320249,5.149112 46.320078,5.148939 46.319765,5.148906 46.3196,5.149025 46.319291,5.149123 46.318955,5.149242 46.318802,5.149426 46.318667,5.149735 46.318389,5.149992 46.318105,5.150386 46.31806,5.150767 46.318047,5.151127 46.317909,5.151293 46.317782,5.151234 46.317601,5.150963 46.317308,5.15091 46.317178,5.149945 46.316492,5.149253 46.316377,5.148227 46.315977,5.148176 46.31553,5.148233 46.315164,5.14828 46.315096,5.147786 46.314883,5.147575 46.314844,5.145599 46.314895,5.145446 46.314685,5.144948 46.314276,5.144567 46.313889,5.143818 46.312955,5.14372 46.312802,5.143792 46.312686,5.143158 46.312298,5.142852 46.31215,5.142427 46.312035,5.1422 46.311994,5.141711 46.311827,5.141479 46.311712,5.140794 46.311286,5.140821 46.310964,5.140715 46.310647,5.140429 46.310192,5.140315 46.309889,5.140347 46.309626,5.141138 46.308519,5.141278 46.308242,5.140736 46.308125,5.140435 46.308079,5.139296 46.308042,5.138183 46.308028,5.137938 46.307583,5.137599 46.307013,5.137331 46.307084,5.136875 46.307094,5.135861 46.307243,5.134841 46.30743,5.134321 46.307488,5.133859 46.307449,5.134192 46.307085,5.134168 46.30696,5.134046 46.306869,5.133358 46.307005,5.132812 46.307053,5.132284 46.307153,5.13192 46.307294,5.13167 46.307537,5.131331 46.307577,5.131383 46.307415,5.130905 46.307388,5.130245 46.307329,5.129544 46.307389,5.129629 46.307002,5.129255 46.30684,5.128568 46.306826,5.12829 46.306839,5.128057 46.307071,5.127664 46.307324,5.127401 46.307448,5.127029 46.307801,5.126703 46.308275,5.126532 46.308485,5.126018 46.308802,5.12553 46.308991,5.124912 46.309175,5.124229 46.30938,5.124526 46.310085,5.124795 46.310484,5.124255 46.310704,5.123615 46.310901,5.123755 46.311109,5.123809 46.31127,5.123712 46.311479,5.123622 46.311557,5.12361 46.311683,5.12393 46.312234,5.124098 46.312349,5.123698 46.312827,5.123767 46.313314,5.123773 46.313603,5.123563 46.313609,5.123597 46.313913,5.123988 46.31531,5.124019 46.315675,5.123876 46.316174,5.123796 46.316574,5.123783 46.316874,5.123853 46.31707,5.123973 46.317528,5.12405 46.317984,5.124928 46.317895,5.12522 46.318952,5.125535 46.319639,5.126275 46.319814,5.126772 46.319722,5.127586 46.319642,5.127604 46.31981,5.127976 46.319682,5.128101 46.319612,5.128471 46.319597,5.128812 46.319689,5.12848 46.320158,5.128153 46.320866,5.127937 46.320815,5.127767 46.321382,5.127631 46.321529,5.127397 46.321716,5.127369 46.321885,5.127388 46.322857,5.127347 46.323241,5.127458 46.323851,5.127656 46.324184,5.126988 46.324525,5.12617 46.324895,5.126116 46.325042,5.126109 46.325426,5.126249 46.325442,5.127593 46.325737,5.128173 46.325878,5.129191 46.326147,5.128833 46.326963,5.128337 46.327425,5.127988 46.328084,5.127844 46.328775,5.127702 46.32915,5.127524 46.329743,5.127335 46.330081,5.127165 46.330293,5.127194 46.330505,5.127372 46.330619,5.128264 46.331122,5.128352 46.331423,5.128682 46.333084,5.128817 46.333506,5.129004 46.333639,5.12951 46.333839,5.130659 46.333798,5.130186 46.334531,5.129213 46.336116,5.130356 46.336517,5.131014 46.336795,5.131483 46.33681,5.132283 46.336781,5.132615 46.33682,5.13405 46.337136,5.134444 46.337236,5.134032 46.337966,5.134048 46.338306,5.134132 46.338562,5.134127 46.338836,5.133989 46.33905,5.133811 46.3392,5.133323 46.339431,5.133028 46.33974,5.132959 46.339916,5.132955 46.34013,5.133069 46.340732,5.133093 46.341166,5.133148 46.341548,5.133253 46.341996,5.133216 46.3421,5.132926 46.342457,5.132875 46.342616,5.13308 46.342639,5.133111 46.342904,5.133494 46.343391,5.133777 46.343467,5.133805 46.343659,5.133987 46.343806,5.135143 46.344813,5.136444 46.346086,5.137331 46.346865,5.137801 46.347245,5.138089 46.347369,5.13901 46.348157,5.139437 46.348385,5.139544 46.348526,5.139516 46.348703,5.139199 46.348801,5.138941 46.349131,5.138877 46.349248,5.139445 46.349429,5.139475 46.349569,5.139389 46.349672,5.139105 46.349791,5.139088 46.350156,5.139173 46.350411,5.139349 46.351386,5.139193 46.351609,5.139274 46.351656,5.138906 46.352663,5.139005 46.352691,5.13911 46.352874,5.139327 46.352917,5.139452 46.353022)))"
  ]
  "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 => 26698
  ]
  "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 => 26698
  ]
  "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(((5.139452 46.353022,5.139839 46.352828,5.14013 46.352772,5.141578 46.352648,5.14202 46.352115,5.142942 46.351277,5.143273 46.351194,5.143473 46.351213,5.143741 46.351182,5.144244 46.350701,5.14469 46.350411,5.144716 46.350333,5.144605 46.350054,5.144574 46.349898,5.144608 46.349766,5.14473 46.349595,5.144884 46.349472,5.145069 46.349398,5.145297 46.349364,5.145564 46.34937,5.145982 46.349421,5.14627 46.349266,5.146982 46.348566,5.147324 46.34844,5.147634 46.346791,5.148203 46.346654,5.148708 46.346454,5.149431 46.346124,5.149803 46.34599,5.150023 46.345963,5.150628 46.345964,5.150883 46.345531,5.15095 46.34535,5.150921 46.345008,5.15096 46.344667,5.151397 46.344349,5.151849 46.344168,5.152267 46.34387,5.152436 46.343725,5.152673 46.343831,5.154313 46.344872,5.155044 46.344237,5.155781 46.344527,5.157569 46.345005,5.158233 46.345096,5.158409 46.344732,5.160531 46.341798,5.161634 46.340435,5.161494 46.339892,5.161425 46.339804,5.161877 46.339689,5.162552 46.339305,5.162662 46.338999,5.162826 46.33841,5.162989 46.33656,5.163462 46.335648,5.163812 46.335104,5.164221 46.334553,5.164267 46.334337,5.164488 46.333982,5.16476 46.33361,5.164924 46.333252,5.164926 46.33317,5.165197 46.332769,5.167288 46.330474,5.167809 46.329832,5.167901 46.329761,5.168154 46.329444,5.168561 46.328898,5.168761 46.328726,5.167498 46.328373,5.167764 46.327941,5.166721 46.327517,5.165631 46.327182,5.163705 46.326952,5.163619 46.326841,5.163127 46.326699,5.162812 46.326581,5.162771 46.326306,5.161763 46.326568,5.161833 46.326766,5.161746 46.327058,5.161606 46.327153,5.161311 46.327143,5.160475 46.327229,5.160032 46.327348,5.159646 46.327413,5.159462 46.327422,5.158974 46.327402,5.158641 46.327349,5.15815 46.327337,5.157951 46.327304,5.157802 46.327062,5.15767 46.326936,5.157582 46.326581,5.157422 46.326248,5.15704 46.325794,5.15701 46.325636,5.157084 46.325286,5.157159 46.325126,5.156663 46.324974,5.1564 46.324943,5.156131 46.324969,5.155828 46.325032,5.155376 46.324875,5.155126 46.32475,5.155548 46.324161,5.154862 46.323947,5.154453 46.323745,5.154098 46.32351,5.153567 46.322989,5.153392 46.323015,5.153038 46.323229,5.15166 46.323838,5.150661 46.324213,5.15026 46.323793,5.150191 46.323604,5.150197 46.323096,5.150219 46.322855,5.150323 46.322388,5.150463 46.321996,5.150454 46.321818,5.150366 46.321709,5.149824 46.321253,5.149536 46.320976,5.149451 46.320751,5.149416 46.320482,5.149267 46.320249,5.149112 46.320078,5.148939 46.319765,5.148906 46.3196,5.149025 46.319291,5.149123 46.318955,5.149242 46.318802,5.149426 46.318667,5.149735 46.318389,5.149992 46.318105,5.150386 46.31806,5.150767 46.318047,5.151127 46.317909,5.151293 46.317782,5.151234 46.317601,5.150963 46.317308,5.15091 46.317178,5.149945 46.316492,5.149253 46.316377,5.148227 46.315977,5.148176 46.31553,5.148233 46.315164,5.14828 46.315096,5.147786 46.314883,5.147575 46.314844,5.145599 46.314895,5.145446 46.314685,5.144948 46.314276,5.144567 46.313889,5.143818 46.312955,5.14372 46.312802,5.143792 46.312686,5.143158 46.312298,5.142852 46.31215,5.142427 46.312035,5.1422 46.311994,5.141711 46.311827,5.141479 46.311712,5.140794 46.311286,5.140821 46.310964,5.140715 46.310647,5.140429 46.310192,5.140315 46.309889,5.140347 46.309626,5.141138 46.308519,5.141278 46.308242,5.140736 46.308125,5.140435 46.308079,5.139296 46.308042,5.138183 46.308028,5.137938 46.307583,5.137599 46.307013,5.137331 46.307084,5.136875 46.307094,5.135861 46.307243,5.134841 46.30743,5.134321 46.307488,5.133859 46.307449,5.134192 46.307085,5.134168 46.30696,5.134046 46.306869,5.133358 46.307005,5.132812 46.307053,5.132284 46.307153,5.13192 46.307294,5.13167 46.307537,5.131331 46.307577,5.131383 46.307415,5.130905 46.307388,5.130245 46.307329,5.129544 46.307389,5.129629 46.307002,5.129255 46.30684,5.128568 46.306826,5.12829 46.306839,5.128057 46.307071,5.127664 46.307324,5.127401 46.307448,5.127029 46.307801,5.126703 46.308275,5.126532 46.308485,5.126018 46.308802,5.12553 46.308991,5.124912 46.309175,5.124229 46.30938,5.124526 46.310085,5.124795 46.310484,5.124255 46.310704,5.123615 46.310901,5.123755 46.311109,5.123809 46.31127,5.123712 46.311479,5.123622 46.311557,5.12361 46.311683,5.12393 46.312234,5.124098 46.312349,5.123698 46.312827,5.123767 46.313314,5.123773 46.313603,5.123563 46.313609,5.123597 46.313913,5.123988 46.31531,5.124019 46.315675,5.123876 46.316174,5.123796 46.316574,5.123783 46.316874,5.123853 46.31707,5.123973 46.317528,5.12405 46.317984,5.124928 46.317895,5.12522 46.318952,5.125535 46.319639,5.126275 46.319814,5.126772 46.319722,5.127586 46.319642,5.127604 46.31981,5.127976 46.319682,5.128101 46.319612,5.128471 46.319597,5.128812 46.319689,5.12848 46.320158,5.128153 46.320866,5.127937 46.320815,5.127767 46.321382,5.127631 46.321529,5.127397 46.321716,5.127369 46.321885,5.127388 46.322857,5.127347 46.323241,5.127458 46.323851,5.127656 46.324184,5.126988 46.324525,5.12617 46.324895,5.126116 46.325042,5.126109 46.325426,5.126249 46.325442,5.127593 46.325737,5.128173 46.325878,5.129191 46.326147,5.128833 46.326963,5.128337 46.327425,5.127988 46.328084,5.127844 46.328775,5.127702 46.32915,5.127524 46.329743,5.127335 46.330081,5.127165 46.330293,5.127194 46.330505,5.127372 46.330619,5.128264 46.331122,5.128352 46.331423,5.128682 46.333084,5.128817 46.333506,5.129004 46.333639,5.12951 46.333839,5.130659 46.333798,5.130186 46.334531,5.129213 46.336116,5.130356 46.336517,5.131014 46.336795,5.131483 46.33681,5.132283 46.336781,5.132615 46.33682,5.13405 46.337136,5.134444 46.337236,5.134032 46.337966,5.134048 46.338306,5.134132 46.338562,5.134127 46.338836,5.133989 46.33905,5.133811 46.3392,5.133323 46.339431,5.133028 46.33974,5.132959 46.339916,5.132955 46.34013,5.133069 46.340732,5.133093 46.341166,5.133148 46.341548,5.133253 46.341996,5.133216 46.3421,5.132926 46.342457,5.132875 46.342616,5.13308 46.342639,5.133111 46.342904,5.133494 46.343391,5.133777 46.343467,5.133805 46.343659,5.133987 46.343806,5.135143 46.344813,5.136444 46.346086,5.137331 46.346865,5.137801 46.347245,5.138089 46.347369,5.13901 46.348157,5.139437 46.348385,5.139544 46.348526,5.139516 46.348703,5.139199 46.348801,5.138941 46.349131,5.138877 46.349248,5.139445 46.349429,5.139475 46.349569,5.139389 46.349672,5.139105 46.349791,5.139088 46.350156,5.139173 46.350411,5.139349 46.351386,5.139193 46.351609,5.139274 46.351656,5.138906 46.352663,5.139005 46.352691,5.13911 46.352874,5.139327 46.352917,5.139452 46.353022)))"
    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(((5.139452 46.353022,5.139839 46.352828,5.14013 46.352772,5.141578 46.352648,5.14202 46.352115,5.142942 46.351277,5.143273 46.351194,5.143473 46.351213,5.143741 46.351182,5.144244 46.350701,5.14469 46.350411,5.144716 46.350333,5.144605 46.350054,5.144574 46.349898,5.144608 46.349766,5.14473 46.349595,5.144884 46.349472,5.145069 46.349398,5.145297 46.349364,5.145564 46.34937,5.145982 46.349421,5.14627 46.349266,5.146982 46.348566,5.147324 46.34844,5.147634 46.346791,5.148203 46.346654,5.148708 46.346454,5.149431 46.346124,5.149803 46.34599,5.150023 46.345963,5.150628 46.345964,5.150883 46.345531,5.15095 46.34535,5.150921 46.345008,5.15096 46.344667,5.151397 46.344349,5.151849 46.344168,5.152267 46.34387,5.152436 46.343725,5.152673 46.343831,5.154313 46.344872,5.155044 46.344237,5.155781 46.344527,5.157569 46.345005,5.158233 46.345096,5.158409 46.344732,5.160531 46.341798,5.161634 46.340435,5.161494 46.339892,5.161425 46.339804,5.161877 46.339689,5.162552 46.339305,5.162662 46.338999,5.162826 46.33841,5.162989 46.33656,5.163462 46.335648,5.163812 46.335104,5.164221 46.334553,5.164267 46.334337,5.164488 46.333982,5.16476 46.33361,5.164924 46.333252,5.164926 46.33317,5.165197 46.332769,5.167288 46.330474,5.167809 46.329832,5.167901 46.329761,5.168154 46.329444,5.168561 46.328898,5.168761 46.328726,5.167498 46.328373,5.167764 46.327941,5.166721 46.327517,5.165631 46.327182,5.163705 46.326952,5.163619 46.326841,5.163127 46.326699,5.162812 46.326581,5.162771 46.326306,5.161763 46.326568,5.161833 46.326766,5.161746 46.327058,5.161606 46.327153,5.161311 46.327143,5.160475 46.327229,5.160032 46.327348,5.159646 46.327413,5.159462 46.327422,5.158974 46.327402,5.158641 46.327349,5.15815 46.327337,5.157951 46.327304,5.157802 46.327062,5.15767 46.326936,5.157582 46.326581,5.157422 46.326248,5.15704 46.325794,5.15701 46.325636,5.157084 46.325286,5.157159 46.325126,5.156663 46.324974,5.1564 46.324943,5.156131 46.324969,5.155828 46.325032,5.155376 46.324875,5.155126 46.32475,5.155548 46.324161,5.154862 46.323947,5.154453 46.323745,5.154098 46.32351,5.153567 46.322989,5.153392 46.323015,5.153038 46.323229,5.15166 46.323838,5.150661 46.324213,5.15026 46.323793,5.150191 46.323604,5.150197 46.323096,5.150219 46.322855,5.150323 46.322388,5.150463 46.321996,5.150454 46.321818,5.150366 46.321709,5.149824 46.321253,5.149536 46.320976,5.149451 46.320751,5.149416 46.320482,5.149267 46.320249,5.149112 46.320078,5.148939 46.319765,5.148906 46.3196,5.149025 46.319291,5.149123 46.318955,5.149242 46.318802,5.149426 46.318667,5.149735 46.318389,5.149992 46.318105,5.150386 46.31806,5.150767 46.318047,5.151127 46.317909,5.151293 46.317782,5.151234 46.317601,5.150963 46.317308,5.15091 46.317178,5.149945 46.316492,5.149253 46.316377,5.148227 46.315977,5.148176 46.31553,5.148233 46.315164,5.14828 46.315096,5.147786 46.314883,5.147575 46.314844,5.145599 46.314895,5.145446 46.314685,5.144948 46.314276,5.144567 46.313889,5.143818 46.312955,5.14372 46.312802,5.143792 46.312686,5.143158 46.312298,5.142852 46.31215,5.142427 46.312035,5.1422 46.311994,5.141711 46.311827,5.141479 46.311712,5.140794 46.311286,5.140821 46.310964,5.140715 46.310647,5.140429 46.310192,5.140315 46.309889,5.140347 46.309626,5.141138 46.308519,5.141278 46.308242,5.140736 46.308125,5.140435 46.308079,5.139296 46.308042,5.138183 46.308028,5.137938 46.307583,5.137599 46.307013,5.137331 46.307084,5.136875 46.307094,5.135861 46.307243,5.134841 46.30743,5.134321 46.307488,5.133859 46.307449,5.134192 46.307085,5.134168 46.30696,5.134046 46.306869,5.133358 46.307005,5.132812 46.307053,5.132284 46.307153,5.13192 46.307294,5.13167 46.307537,5.131331 46.307577,5.131383 46.307415,5.130905 46.307388,5.130245 46.307329,5.129544 46.307389,5.129629 46.307002,5.129255 46.30684,5.128568 46.306826,5.12829 46.306839,5.128057 46.307071,5.127664 46.307324,5.127401 46.307448,5.127029 46.307801,5.126703 46.308275,5.126532 46.308485,5.126018 46.308802,5.12553 46.308991,5.124912 46.309175,5.124229 46.30938,5.124526 46.310085,5.124795 46.310484,5.124255 46.310704,5.123615 46.310901,5.123755 46.311109,5.123809 46.31127,5.123712 46.311479,5.123622 46.311557,5.12361 46.311683,5.12393 46.312234,5.124098 46.312349,5.123698 46.312827,5.123767 46.313314,5.123773 46.313603,5.123563 46.313609,5.123597 46.313913,5.123988 46.31531,5.124019 46.315675,5.123876 46.316174,5.123796 46.316574,5.123783 46.316874,5.123853 46.31707,5.123973 46.317528,5.12405 46.317984,5.124928 46.317895,5.12522 46.318952,5.125535 46.319639,5.126275 46.319814,5.126772 46.319722,5.127586 46.319642,5.127604 46.31981,5.127976 46.319682,5.128101 46.319612,5.128471 46.319597,5.128812 46.319689,5.12848 46.320158,5.128153 46.320866,5.127937 46.320815,5.127767 46.321382,5.127631 46.321529,5.127397 46.321716,5.127369 46.321885,5.127388 46.322857,5.127347 46.323241,5.127458 46.323851,5.127656 46.324184,5.126988 46.324525,5.12617 46.324895,5.126116 46.325042,5.126109 46.325426,5.126249 46.325442,5.127593 46.325737,5.128173 46.325878,5.129191 46.326147,5.128833 46.326963,5.128337 46.327425,5.127988 46.328084,5.127844 46.328775,5.127702 46.32915,5.127524 46.329743,5.127335 46.330081,5.127165 46.330293,5.127194 46.330505,5.127372 46.330619,5.128264 46.331122,5.128352 46.331423,5.128682 46.333084,5.128817 46.333506,5.129004 46.333639,5.12951 46.333839,5.130659 46.333798,5.130186 46.334531,5.129213 46.336116,5.130356 46.336517,5.131014 46.336795,5.131483 46.33681,5.132283 46.336781,5.132615 46.33682,5.13405 46.337136,5.134444 46.337236,5.134032 46.337966,5.134048 46.338306,5.134132 46.338562,5.134127 46.338836,5.133989 46.33905,5.133811 46.3392,5.133323 46.339431,5.133028 46.33974,5.132959 46.339916,5.132955 46.34013,5.133069 46.340732,5.133093 46.341166,5.133148 46.341548,5.133253 46.341996,5.133216 46.3421,5.132926 46.342457,5.132875 46.342616,5.13308 46.342639,5.133111 46.342904,5.133494 46.343391,5.133777 46.343467,5.133805 46.343659,5.133987 46.343806,5.135143 46.344813,5.136444 46.346086,5.137331 46.346865,5.137801 46.347245,5.138089 46.347369,5.13901 46.348157,5.139437 46.348385,5.139544 46.348526,5.139516 46.348703,5.139199 46.348801,5.138941 46.349131,5.138877 46.349248,5.139445 46.349429,5.139475 46.349569,5.139389 46.349672,5.139105 46.349791,5.139088 46.350156,5.139173 46.350411,5.139349 46.351386,5.139193 46.351609,5.139274 46.351656,5.138906 46.352663,5.139005 46.352691,5.13911 46.352874,5.139327 46.352917,5.139452 46.353022)))"
  ]
  "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(((5.139452 46.353022,5.139839 46.352828,5.14013 46.352772,5.141578 46.352648,5.14202 46.352115,5.142942 46.351277,5.143273 46.351194,5.143473 46.351213,5.143741 46.351182,5.144244 46.350701,5.14469 46.350411,5.144716 46.350333,5.144605 46.350054,5.144574 46.349898,5.144608 46.349766,5.14473 46.349595,5.144884 46.349472,5.145069 46.349398,5.145297 46.349364,5.145564 46.34937,5.145982 46.349421,5.14627 46.349266,5.146982 46.348566,5.147324 46.34844,5.147634 46.346791,5.148203 46.346654,5.148708 46.346454,5.149431 46.346124,5.149803 46.34599,5.150023 46.345963,5.150628 46.345964,5.150883 46.345531,5.15095 46.34535,5.150921 46.345008,5.15096 46.344667,5.151397 46.344349,5.151849 46.344168,5.152267 46.34387,5.152436 46.343725,5.152673 46.343831,5.154313 46.344872,5.155044 46.344237,5.155781 46.344527,5.157569 46.345005,5.158233 46.345096,5.158409 46.344732,5.160531 46.341798,5.161634 46.340435,5.161494 46.339892,5.161425 46.339804,5.161877 46.339689,5.162552 46.339305,5.162662 46.338999,5.162826 46.33841,5.162989 46.33656,5.163462 46.335648,5.163812 46.335104,5.164221 46.334553,5.164267 46.334337,5.164488 46.333982,5.16476 46.33361,5.164924 46.333252,5.164926 46.33317,5.165197 46.332769,5.167288 46.330474,5.167809 46.329832,5.167901 46.329761,5.168154 46.329444,5.168561 46.328898,5.168761 46.328726,5.167498 46.328373,5.167764 46.327941,5.166721 46.327517,5.165631 46.327182,5.163705 46.326952,5.163619 46.326841,5.163127 46.326699,5.162812 46.326581,5.162771 46.326306,5.161763 46.326568,5.161833 46.326766,5.161746 46.327058,5.161606 46.327153,5.161311 46.327143,5.160475 46.327229,5.160032 46.327348,5.159646 46.327413,5.159462 46.327422,5.158974 46.327402,5.158641 46.327349,5.15815 46.327337,5.157951 46.327304,5.157802 46.327062,5.15767 46.326936,5.157582 46.326581,5.157422 46.326248,5.15704 46.325794,5.15701 46.325636,5.157084 46.325286,5.157159 46.325126,5.156663 46.324974,5.1564 46.324943,5.156131 46.324969,5.155828 46.325032,5.155376 46.324875,5.155126 46.32475,5.155548 46.324161,5.154862 46.323947,5.154453 46.323745,5.154098 46.32351,5.153567 46.322989,5.153392 46.323015,5.153038 46.323229,5.15166 46.323838,5.150661 46.324213,5.15026 46.323793,5.150191 46.323604,5.150197 46.323096,5.150219 46.322855,5.150323 46.322388,5.150463 46.321996,5.150454 46.321818,5.150366 46.321709,5.149824 46.321253,5.149536 46.320976,5.149451 46.320751,5.149416 46.320482,5.149267 46.320249,5.149112 46.320078,5.148939 46.319765,5.148906 46.3196,5.149025 46.319291,5.149123 46.318955,5.149242 46.318802,5.149426 46.318667,5.149735 46.318389,5.149992 46.318105,5.150386 46.31806,5.150767 46.318047,5.151127 46.317909,5.151293 46.317782,5.151234 46.317601,5.150963 46.317308,5.15091 46.317178,5.149945 46.316492,5.149253 46.316377,5.148227 46.315977,5.148176 46.31553,5.148233 46.315164,5.14828 46.315096,5.147786 46.314883,5.147575 46.314844,5.145599 46.314895,5.145446 46.314685,5.144948 46.314276,5.144567 46.313889,5.143818 46.312955,5.14372 46.312802,5.143792 46.312686,5.143158 46.312298,5.142852 46.31215,5.142427 46.312035,5.1422 46.311994,5.141711 46.311827,5.141479 46.311712,5.140794 46.311286,5.140821 46.310964,5.140715 46.310647,5.140429 46.310192,5.140315 46.309889,5.140347 46.309626,5.141138 46.308519,5.141278 46.308242,5.140736 46.308125,5.140435 46.308079,5.139296 46.308042,5.138183 46.308028,5.137938 46.307583,5.137599 46.307013,5.137331 46.307084,5.136875 46.307094,5.135861 46.307243,5.134841 46.30743,5.134321 46.307488,5.133859 46.307449,5.134192 46.307085,5.134168 46.30696,5.134046 46.306869,5.133358 46.307005,5.132812 46.307053,5.132284 46.307153,5.13192 46.307294,5.13167 46.307537,5.131331 46.307577,5.131383 46.307415,5.130905 46.307388,5.130245 46.307329,5.129544 46.307389,5.129629 46.307002,5.129255 46.30684,5.128568 46.306826,5.12829 46.306839,5.128057 46.307071,5.127664 46.307324,5.127401 46.307448,5.127029 46.307801,5.126703 46.308275,5.126532 46.308485,5.126018 46.308802,5.12553 46.308991,5.124912 46.309175,5.124229 46.30938,5.124526 46.310085,5.124795 46.310484,5.124255 46.310704,5.123615 46.310901,5.123755 46.311109,5.123809 46.31127,5.123712 46.311479,5.123622 46.311557,5.12361 46.311683,5.12393 46.312234,5.124098 46.312349,5.123698 46.312827,5.123767 46.313314,5.123773 46.313603,5.123563 46.313609,5.123597 46.313913,5.123988 46.31531,5.124019 46.315675,5.123876 46.316174,5.123796 46.316574,5.123783 46.316874,5.123853 46.31707,5.123973 46.317528,5.12405 46.317984,5.124928 46.317895,5.12522 46.318952,5.125535 46.319639,5.126275 46.319814,5.126772 46.319722,5.127586 46.319642,5.127604 46.31981,5.127976 46.319682,5.128101 46.319612,5.128471 46.319597,5.128812 46.319689,5.12848 46.320158,5.128153 46.320866,5.127937 46.320815,5.127767 46.321382,5.127631 46.321529,5.127397 46.321716,5.127369 46.321885,5.127388 46.322857,5.127347 46.323241,5.127458 46.323851,5.127656 46.324184,5.126988 46.324525,5.12617 46.324895,5.126116 46.325042,5.126109 46.325426,5.126249 46.325442,5.127593 46.325737,5.128173 46.325878,5.129191 46.326147,5.128833 46.326963,5.128337 46.327425,5.127988 46.328084,5.127844 46.328775,5.127702 46.32915,5.127524 46.329743,5.127335 46.330081,5.127165 46.330293,5.127194 46.330505,5.127372 46.330619,5.128264 46.331122,5.128352 46.331423,5.128682 46.333084,5.128817 46.333506,5.129004 46.333639,5.12951 46.333839,5.130659 46.333798,5.130186 46.334531,5.129213 46.336116,5.130356 46.336517,5.131014 46.336795,5.131483 46.33681,5.132283 46.336781,5.132615 46.33682,5.13405 46.337136,5.134444 46.337236,5.134032 46.337966,5.134048 46.338306,5.134132 46.338562,5.134127 46.338836,5.133989 46.33905,5.133811 46.3392,5.133323 46.339431,5.133028 46.33974,5.132959 46.339916,5.132955 46.34013,5.133069 46.340732,5.133093 46.341166,5.133148 46.341548,5.133253 46.341996,5.133216 46.3421,5.132926 46.342457,5.132875 46.342616,5.13308 46.342639,5.133111 46.342904,5.133494 46.343391,5.133777 46.343467,5.133805 46.343659,5.133987 46.343806,5.135143 46.344813,5.136444 46.346086,5.137331 46.346865,5.137801 46.347245,5.138089 46.347369,5.13901 46.348157,5.139437 46.348385,5.139544 46.348526,5.139516 46.348703,5.139199 46.348801,5.138941 46.349131,5.138877 46.349248,5.139445 46.349429,5.139475 46.349569,5.139389 46.349672,5.139105 46.349791,5.139088 46.350156,5.139173 46.350411,5.139349 46.351386,5.139193 46.351609,5.139274 46.351656,5.138906 46.352663,5.139005 46.352691,5.13911 46.352874,5.139327 46.352917,5.139452 46.353022)))"
  ]
  "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(((5.139452 46.353022,5.139839 46.352828,5.14013 46.352772,5.141578 46.352648,5.14202 46.352115,5.142942 46.351277,5.143273 46.351194,5.143473 46.351213,5.143741 46.351182,5.144244 46.350701,5.14469 46.350411,5.144716 46.350333,5.144605 46.350054,5.144574 46.349898,5.144608 46.349766,5.14473 46.349595,5.144884 46.349472,5.145069 46.349398,5.145297 46.349364,5.145564 46.34937,5.145982 46.349421,5.14627 46.349266,5.146982 46.348566,5.147324 46.34844,5.147634 46.346791,5.148203 46.346654,5.148708 46.346454,5.149431 46.346124,5.149803 46.34599,5.150023 46.345963,5.150628 46.345964,5.150883 46.345531,5.15095 46.34535,5.150921 46.345008,5.15096 46.344667,5.151397 46.344349,5.151849 46.344168,5.152267 46.34387,5.152436 46.343725,5.152673 46.343831,5.154313 46.344872,5.155044 46.344237,5.155781 46.344527,5.157569 46.345005,5.158233 46.345096,5.158409 46.344732,5.160531 46.341798,5.161634 46.340435,5.161494 46.339892,5.161425 46.339804,5.161877 46.339689,5.162552 46.339305,5.162662 46.338999,5.162826 46.33841,5.162989 46.33656,5.163462 46.335648,5.163812 46.335104,5.164221 46.334553,5.164267 46.334337,5.164488 46.333982,5.16476 46.33361,5.164924 46.333252,5.164926 46.33317,5.165197 46.332769,5.167288 46.330474,5.167809 46.329832,5.167901 46.329761,5.168154 46.329444,5.168561 46.328898,5.168761 46.328726,5.167498 46.328373,5.167764 46.327941,5.166721 46.327517,5.165631 46.327182,5.163705 46.326952,5.163619 46.326841,5.163127 46.326699,5.162812 46.326581,5.162771 46.326306,5.161763 46.326568,5.161833 46.326766,5.161746 46.327058,5.161606 46.327153,5.161311 46.327143,5.160475 46.327229,5.160032 46.327348,5.159646 46.327413,5.159462 46.327422,5.158974 46.327402,5.158641 46.327349,5.15815 46.327337,5.157951 46.327304,5.157802 46.327062,5.15767 46.326936,5.157582 46.326581,5.157422 46.326248,5.15704 46.325794,5.15701 46.325636,5.157084 46.325286,5.157159 46.325126,5.156663 46.324974,5.1564 46.324943,5.156131 46.324969,5.155828 46.325032,5.155376 46.324875,5.155126 46.32475,5.155548 46.324161,5.154862 46.323947,5.154453 46.323745,5.154098 46.32351,5.153567 46.322989,5.153392 46.323015,5.153038 46.323229,5.15166 46.323838,5.150661 46.324213,5.15026 46.323793,5.150191 46.323604,5.150197 46.323096,5.150219 46.322855,5.150323 46.322388,5.150463 46.321996,5.150454 46.321818,5.150366 46.321709,5.149824 46.321253,5.149536 46.320976,5.149451 46.320751,5.149416 46.320482,5.149267 46.320249,5.149112 46.320078,5.148939 46.319765,5.148906 46.3196,5.149025 46.319291,5.149123 46.318955,5.149242 46.318802,5.149426 46.318667,5.149735 46.318389,5.149992 46.318105,5.150386 46.31806,5.150767 46.318047,5.151127 46.317909,5.151293 46.317782,5.151234 46.317601,5.150963 46.317308,5.15091 46.317178,5.149945 46.316492,5.149253 46.316377,5.148227 46.315977,5.148176 46.31553,5.148233 46.315164,5.14828 46.315096,5.147786 46.314883,5.147575 46.314844,5.145599 46.314895,5.145446 46.314685,5.144948 46.314276,5.144567 46.313889,5.143818 46.312955,5.14372 46.312802,5.143792 46.312686,5.143158 46.312298,5.142852 46.31215,5.142427 46.312035,5.1422 46.311994,5.141711 46.311827,5.141479 46.311712,5.140794 46.311286,5.140821 46.310964,5.140715 46.310647,5.140429 46.310192,5.140315 46.309889,5.140347 46.309626,5.141138 46.308519,5.141278 46.308242,5.140736 46.308125,5.140435 46.308079,5.139296 46.308042,5.138183 46.308028,5.137938 46.307583,5.137599 46.307013,5.137331 46.307084,5.136875 46.307094,5.135861 46.307243,5.134841 46.30743,5.134321 46.307488,5.133859 46.307449,5.134192 46.307085,5.134168 46.30696,5.134046 46.306869,5.133358 46.307005,5.132812 46.307053,5.132284 46.307153,5.13192 46.307294,5.13167 46.307537,5.131331 46.307577,5.131383 46.307415,5.130905 46.307388,5.130245 46.307329,5.129544 46.307389,5.129629 46.307002,5.129255 46.30684,5.128568 46.306826,5.12829 46.306839,5.128057 46.307071,5.127664 46.307324,5.127401 46.307448,5.127029 46.307801,5.126703 46.308275,5.126532 46.308485,5.126018 46.308802,5.12553 46.308991,5.124912 46.309175,5.124229 46.30938,5.124526 46.310085,5.124795 46.310484,5.124255 46.310704,5.123615 46.310901,5.123755 46.311109,5.123809 46.31127,5.123712 46.311479,5.123622 46.311557,5.12361 46.311683,5.12393 46.312234,5.124098 46.312349,5.123698 46.312827,5.123767 46.313314,5.123773 46.313603,5.123563 46.313609,5.123597 46.313913,5.123988 46.31531,5.124019 46.315675,5.123876 46.316174,5.123796 46.316574,5.123783 46.316874,5.123853 46.31707,5.123973 46.317528,5.12405 46.317984,5.124928 46.317895,5.12522 46.318952,5.125535 46.319639,5.126275 46.319814,5.126772 46.319722,5.127586 46.319642,5.127604 46.31981,5.127976 46.319682,5.128101 46.319612,5.128471 46.319597,5.128812 46.319689,5.12848 46.320158,5.128153 46.320866,5.127937 46.320815,5.127767 46.321382,5.127631 46.321529,5.127397 46.321716,5.127369 46.321885,5.127388 46.322857,5.127347 46.323241,5.127458 46.323851,5.127656 46.324184,5.126988 46.324525,5.12617 46.324895,5.126116 46.325042,5.126109 46.325426,5.126249 46.325442,5.127593 46.325737,5.128173 46.325878,5.129191 46.326147,5.128833 46.326963,5.128337 46.327425,5.127988 46.328084,5.127844 46.328775,5.127702 46.32915,5.127524 46.329743,5.127335 46.330081,5.127165 46.330293,5.127194 46.330505,5.127372 46.330619,5.128264 46.331122,5.128352 46.331423,5.128682 46.333084,5.128817 46.333506,5.129004 46.333639,5.12951 46.333839,5.130659 46.333798,5.130186 46.334531,5.129213 46.336116,5.130356 46.336517,5.131014 46.336795,5.131483 46.33681,5.132283 46.336781,5.132615 46.33682,5.13405 46.337136,5.134444 46.337236,5.134032 46.337966,5.134048 46.338306,5.134132 46.338562,5.134127 46.338836,5.133989 46.33905,5.133811 46.3392,5.133323 46.339431,5.133028 46.33974,5.132959 46.339916,5.132955 46.34013,5.133069 46.340732,5.133093 46.341166,5.133148 46.341548,5.133253 46.341996,5.133216 46.3421,5.132926 46.342457,5.132875 46.342616,5.13308 46.342639,5.133111 46.342904,5.133494 46.343391,5.133777 46.343467,5.133805 46.343659,5.133987 46.343806,5.135143 46.344813,5.136444 46.346086,5.137331 46.346865,5.137801 46.347245,5.138089 46.347369,5.13901 46.348157,5.139437 46.348385,5.139544 46.348526,5.139516 46.348703,5.139199 46.348801,5.138941 46.349131,5.138877 46.349248,5.139445 46.349429,5.139475 46.349569,5.139389 46.349672,5.139105 46.349791,5.139088 46.350156,5.139173 46.350411,5.139349 46.351386,5.139193 46.351609,5.139274 46.351656,5.138906 46.352663,5.139005 46.352691,5.13911 46.352874,5.139327 46.352917,5.139452 46.353022)))"
    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"
]