Symfony Profiler

[
  "route" => "app_admin_stats"
  "route_parameters" => [
    "_route" => "app_admin_stats"
    "_controller" => "App\Controller\AdminController::stats"
    "insee_code" => "12101"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/admin/stats/12101"
  "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 => "12101"
  ]
  "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 => 27693
  ]
  "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":"12101","nom":"12101"}"
    3 => "2026-07-15 10:16:49"
    4 => "https://osm-labo.cipherbliss.com/admin/labourer/12101?deleteMissing=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 => "12101"
  ]
  "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 => 27693
  ]
  "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 => "12101"
  ]
  "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 => "12101"
  ]
  "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 => "12101"
  ]
  "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(((2.264969 44.619869,2.266191 44.61959,2.266989 44.619328,2.267388 44.619167,2.267881 44.61888,2.26811 44.618691,2.268372 44.618438,2.269484 44.6173,2.269825 44.617003,2.270334 44.61674,2.270866 44.616577,2.271047 44.616479,2.271599 44.616075,2.271653 44.615924,2.271009 44.616152,2.270715 44.616215,2.270161 44.616431,2.269801 44.616529,2.269123 44.616613,2.269261 44.61652,2.269721 44.616099,2.270024 44.615913,2.270164 44.615791,2.270386 44.615533,2.271234 44.614757,2.271494 44.614551,2.272036 44.614038,2.272605 44.613685,2.273606 44.613119,2.273971 44.61303,2.274823 44.612773,2.275146 44.612722,2.276381 44.612565,2.276851 44.612558,2.27693 44.612284,2.277224 44.611502,2.277345 44.611315,2.277557 44.611177,2.277725 44.610823,2.277599 44.610733,2.277158 44.610508,2.27697 44.610148,2.277096 44.609834,2.277664 44.609429,2.278104 44.609205,2.278827 44.609029,2.278895 44.608569,2.278994 44.608314,2.278981 44.60816,2.278863 44.608065,2.278466 44.607989,2.278122 44.607989,2.277441 44.607958,2.27716 44.607852,2.276929 44.607234,2.276838 44.60708,2.276623 44.606973,2.27547 44.606551,2.275401 44.60641,2.275864 44.606259,2.276297 44.606188,2.277249 44.606119,2.278004 44.606056,2.278965 44.605986,2.279055 44.605901,2.280171 44.60523,2.279734 44.605092,2.279528 44.604965,2.279435 44.604831,2.279353 44.604431,2.279287 44.60429,2.279009 44.604047,2.278769 44.603929,2.278275 44.603772,2.277739 44.603637,2.276967 44.603471,2.276752 44.603364,2.276348 44.603035,2.277763 44.602643,2.277959 44.602577,2.27827 44.602527,2.278626 44.602498,2.28 44.602046,2.28 44.602451,2.279874 44.602856,2.279999 44.603036,2.280314 44.603179,2.280425 44.602925,2.280606 44.602725,2.281087 44.60238,2.281331 44.602131,2.281409 44.601936,2.281435 44.601688,2.281421 44.601495,2.28136 44.601345,2.281231 44.601181,2.280837 44.600873,2.280675 44.600596,2.280676 44.600427,2.280788 44.59986,2.280713 44.599518,2.280591 44.599371,2.279868 44.598685,2.279637 44.598565,2.279285 44.598527,2.278764 44.598417,2.278172 44.598243,2.277915 44.598189,2.277465 44.598159,2.277198 44.598193,2.27689 44.598274,2.275812 44.598643,2.275352 44.598693,2.274964 44.598656,2.274609 44.598554,2.27416 44.598377,2.273787 44.598177,2.273484 44.597979,2.273151 44.597592,2.27294 44.597239,2.272722 44.596781,2.272492 44.596411,2.272118 44.596098,2.271394 44.59583,2.27044 44.595565,2.270167 44.595465,2.269919 44.59534,2.269639 44.595154,2.269029 44.59468,2.26877 44.594463,2.26854 44.594201,2.268293 44.593962,2.267996 44.593769,2.267722 44.59363,2.267385 44.593514,2.267055 44.593443,2.266885 44.593357,2.267075 44.593129,2.267101 44.592912,2.266999 44.592644,2.266897 44.592533,2.266726 44.592427,2.266689 44.592292,2.266813 44.59219,2.267184 44.592059,2.267657 44.591946,2.268503 44.591784,2.268699 44.591762,2.269203 44.591756,2.269667 44.591723,2.26997 44.591602,2.270029 44.591424,2.269981 44.591314,2.269702 44.591137,2.269259 44.590998,2.269155 44.590902,2.269123 44.590785,2.269224 44.590566,2.269355 44.590491,2.269786 44.590378,2.269894 44.59022,2.269876 44.590074,2.269925 44.589983,2.270214 44.589861,2.270565 44.58982,2.270998 44.589939,2.271318 44.589988,2.271597 44.589936,2.271775 44.58982,2.271853 44.589654,2.271895 44.589262,2.272054 44.589141,2.272402 44.589071,2.272556 44.589081,2.272798 44.58919,2.272966 44.589336,2.273287 44.589704,2.273546 44.589841,2.2739 44.589866,2.274066 44.589769,2.274438 44.5892,2.274437 44.589087,2.274115 44.588958,2.274101 44.588864,2.274425 44.588626,2.274652 44.58858,2.274923 44.588565,2.275068 44.588604,2.275149 44.588757,2.275272 44.58888,2.275417 44.588903,2.275558 44.588866,2.275748 44.588726,2.275844 44.588574,2.276023 44.588212,2.276103 44.587847,2.276237 44.587611,2.276488 44.587616,2.276682 44.587725,2.276982 44.587989,2.27728 44.588337,2.277443 44.588388,2.277674 44.588311,2.277998 44.588342,2.278071 44.588317,2.278146 44.588109,2.277947 44.587652,2.278049 44.587517,2.278164 44.587277,2.27823 44.587046,2.278325 44.586957,2.278507 44.586927,2.27891 44.586921,2.279086 44.586995,2.279203 44.587093,2.279508 44.587458,2.279642 44.587728,2.279761 44.587862,2.279974 44.587973,2.280175 44.588031,2.280577 44.58809,2.280912 44.588106,2.281163 44.588215,2.281424 44.588381,2.281771 44.588553,2.282087 44.588781,2.282294 44.589037,2.282282 44.589354,2.282459 44.589443,2.282815 44.589497,2.283115 44.589437,2.283264 44.589352,2.283699 44.588971,2.283965 44.588667,2.284148 44.588558,2.28535 44.587993,2.285887 44.587711,2.285964 44.587708,2.286243 44.587849,2.286476 44.587868,2.286646 44.587827,2.286815 44.587669,2.287107 44.587311,2.287207 44.587145,2.287386 44.587067,2.287584 44.586853,2.287588 44.586713,2.287535 44.586567,2.287577 44.586473,2.287709 44.586445,2.287981 44.586469,2.288209 44.586414,2.288627 44.586258,2.288782 44.586248,2.288873 44.586094,2.289045 44.585958,2.289058 44.585447,2.288893 44.584551,2.288879 44.584339,2.288916 44.584124,2.289051 44.583897,2.289414 44.58342,2.28993 44.582642,2.29007 44.582475,2.289953 44.58179,2.290826 44.581528,2.29087 44.581411,2.291268 44.58112,2.291886 44.580813,2.292161 44.580733,2.292553 44.580762,2.292692 44.580724,2.29276 44.580587,2.292654 44.580392,2.292652 44.580208,2.293034 44.579685,2.293322 44.579397,2.29409 44.57887,2.294272 44.578525,2.294345 44.578177,2.293942 44.578519,2.292779 44.579071,2.292292 44.579285,2.291838 44.579532,2.291246 44.579915,2.291027 44.580026,2.290815 44.58009,2.290405 44.580088,2.289857 44.579937,2.289901 44.5791,2.289335 44.578965,2.289273 44.578156,2.289274 44.577302,2.289022 44.577301,2.288519 44.577435,2.288331 44.577391,2.287646 44.576841,2.287573 44.576367,2.287797 44.576161,2.288291 44.57565,2.28851 44.575332,2.288685 44.575025,2.289071 44.574816,2.290064 44.57414,2.29033 44.574014,2.29028 44.57382,2.290183 44.573746,2.289279 44.57213,2.289278 44.57195,2.289028 44.571455,2.288902 44.57105,2.288337 44.570196,2.287645 44.569342,2.28739 44.568856,2.287273 44.568776,2.286996 44.568506,2.286578 44.567893,2.286263 44.567308,2.285509 44.566139,2.285384 44.565959,2.285475 44.565146,2.285245 44.565141,2.285011 44.565193,2.284428 44.565435,2.284213 44.565479,2.284004 44.565481,2.283416 44.565333,2.283005 44.565196,2.282393 44.565012,2.281914 44.565016,2.281711 44.565035,2.281352 44.565163,2.281139 44.565201,2.280385 44.565185,2.279573 44.565056,2.279135 44.565035,2.278722 44.565076,2.278446 44.565128,2.277753 44.565347,2.277238 44.565542,2.276775 44.565665,2.276641 44.565803,2.276559 44.565985,2.276325 44.566228,2.275787 44.566562,2.274971 44.566831,2.274703 44.566997,2.274389 44.567434,2.273993 44.567747,2.273174 44.568198,2.272287 44.568624,2.272088 44.568686,2.271627 44.568787,2.271089 44.56885,2.270882 44.568899,2.270736 44.568975,2.270615 44.569095,2.270278 44.569497,2.269953 44.569727,2.269661 44.569789,2.269323 44.569732,2.268835 44.569607,2.268503 44.569616,2.2683 44.569667,2.268099 44.569793,2.267643 44.56994,2.267551 44.569934,2.267515 44.57019,2.2675 44.570904,2.267751 44.571894,2.267877 44.572254,2.268506 44.572434,2.26882 44.572389,2.26945 44.572165,2.269448 44.572884,2.269268 44.573802,2.269223 44.57423,2.269076 44.574423,2.268589 44.574865,2.268182 44.575256,2.268162 44.575341,2.268437 44.57562,2.268094 44.57577,2.267932 44.575926,2.267433 44.57629,2.267134 44.576556,2.26685 44.576757,2.266633 44.576969,2.266413 44.577258,2.26626 44.577561,2.266101 44.577817,2.265352 44.578323,2.264786 44.578862,2.263968 44.579401,2.261575 44.580308,2.259875 44.581296,2.258239 44.582014,2.257608 44.582374,2.257169 44.582238,2.256099 44.581563,2.255869 44.581437,2.25719 44.580218,2.257478 44.579987,2.257798 44.579765,2.258071 44.579608,2.258479 44.579403,2.258761 44.579228,2.258923 44.579012,2.25928 44.5786,2.259573 44.578436,2.259818 44.578059,2.259964 44.577527,2.259916 44.576865,2.261613 44.574688,2.260541 44.574356,2.260047 44.574268,2.259378 44.574178,2.258333 44.574088,2.25789 44.574092,2.257602 44.574172,2.257193 44.574415,2.256894 44.574571,2.255747 44.575061,2.255458 44.575103,2.254871 44.575144,2.25459 44.575121,2.254221 44.575062,2.253209 44.574935,2.253025 44.575874,2.253028 44.576261,2.252978 44.57653,2.252549 44.576966,2.252381 44.577269,2.252334 44.577555,2.252343 44.577811,2.252395 44.578167,2.252499 44.578231,2.25309 44.578726,2.253488 44.579107,2.253571 44.579949,2.254126 44.582049,2.254095 44.5823,2.253942 44.582675,2.253934 44.583154,2.25397 44.583362,2.254129 44.583677,2.254479 44.584056,2.254523 44.584129,2.254501 44.58451,2.254593 44.5848,2.254733 44.584947,2.255355 44.585371,2.255144 44.585566,2.25504 44.585877,2.254952 44.586212,2.255022 44.58641,2.254839 44.587125,2.254848 44.587415,2.254772 44.58769,2.254662 44.587929,2.254473 44.588224,2.25444 44.588425,2.254675 44.589047,2.254735 44.589281,2.254839 44.589447,2.255023 44.589632,2.255124 44.589818,2.255096 44.590011,2.254696 44.59043,2.25461 44.590664,2.254632 44.590851,2.254706 44.591014,2.254807 44.591117,2.254707 44.591221,2.254325 44.591362,2.254008 44.591581,2.254029 44.591707,2.254275 44.591977,2.254597 44.592177,2.254614 44.592357,2.254224 44.592655,2.254147 44.592976,2.253982 44.593078,2.253659 44.593116,2.253494 44.593176,2.253155 44.59347,2.253012 44.593565,2.252825 44.593627,2.25254 44.593659,2.252358 44.593627,2.251839 44.59364,2.251586 44.593716,2.25121 44.594052,2.25099 44.594205,2.250733 44.594203,2.250547 44.594239,2.250377 44.59422,2.250269 44.594105,2.249696 44.593824,2.24951 44.594546,2.249127 44.595382,2.248665 44.596195,2.248258 44.596747,2.247929 44.597053,2.246951 44.597621,2.246546 44.597831,2.245933 44.598088,2.243999 44.598661,2.242796 44.598981,2.242243 44.599082,2.241654 44.599117,2.24015 44.599089,2.23944 44.599114,2.238609 44.599161,2.237161 44.599281,2.236385 44.599411,2.235733 44.599594,2.235191 44.599795,2.234602 44.600085,2.234096 44.600435,2.233576 44.600934,2.233095 44.601616,2.232543 44.602751,2.232043 44.603873,2.231908 44.604261,2.231841 44.604807,2.231916 44.605685,2.232039 44.606471,2.232109 44.606818,2.23226 44.607232,2.232971 44.608423,2.233297 44.608929,2.23364 44.609463,2.233991 44.609903,2.234391 44.610264,2.234894 44.610601,2.235282 44.610796,2.235774 44.610937,2.238341 44.611096,2.240235 44.611121,2.241892 44.611118,2.243657 44.611197,2.245508 44.611336,2.24738 44.611503,2.249303 44.611658,2.250485 44.611808,2.250661 44.611838,2.252238 44.612117,2.254025 44.612397,2.255088 44.612528,2.256324 44.612582,2.257235 44.612668,2.257979 44.612882,2.258596 44.613197,2.259369 44.613958,2.260412 44.615409,2.261427 44.617062,2.262045 44.617804,2.262728 44.618458,2.263768 44.619202,2.264814 44.619797,2.264969 44.619869)))"
    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(((2.264969 44.619869,2.266191 44.61959,2.266989 44.619328,2.267388 44.619167,2.267881 44.61888,2.26811 44.618691,2.268372 44.618438,2.269484 44.6173,2.269825 44.617003,2.270334 44.61674,2.270866 44.616577,2.271047 44.616479,2.271599 44.616075,2.271653 44.615924,2.271009 44.616152,2.270715 44.616215,2.270161 44.616431,2.269801 44.616529,2.269123 44.616613,2.269261 44.61652,2.269721 44.616099,2.270024 44.615913,2.270164 44.615791,2.270386 44.615533,2.271234 44.614757,2.271494 44.614551,2.272036 44.614038,2.272605 44.613685,2.273606 44.613119,2.273971 44.61303,2.274823 44.612773,2.275146 44.612722,2.276381 44.612565,2.276851 44.612558,2.27693 44.612284,2.277224 44.611502,2.277345 44.611315,2.277557 44.611177,2.277725 44.610823,2.277599 44.610733,2.277158 44.610508,2.27697 44.610148,2.277096 44.609834,2.277664 44.609429,2.278104 44.609205,2.278827 44.609029,2.278895 44.608569,2.278994 44.608314,2.278981 44.60816,2.278863 44.608065,2.278466 44.607989,2.278122 44.607989,2.277441 44.607958,2.27716 44.607852,2.276929 44.607234,2.276838 44.60708,2.276623 44.606973,2.27547 44.606551,2.275401 44.60641,2.275864 44.606259,2.276297 44.606188,2.277249 44.606119,2.278004 44.606056,2.278965 44.605986,2.279055 44.605901,2.280171 44.60523,2.279734 44.605092,2.279528 44.604965,2.279435 44.604831,2.279353 44.604431,2.279287 44.60429,2.279009 44.604047,2.278769 44.603929,2.278275 44.603772,2.277739 44.603637,2.276967 44.603471,2.276752 44.603364,2.276348 44.603035,2.277763 44.602643,2.277959 44.602577,2.27827 44.602527,2.278626 44.602498,2.28 44.602046,2.28 44.602451,2.279874 44.602856,2.279999 44.603036,2.280314 44.603179,2.280425 44.602925,2.280606 44.602725,2.281087 44.60238,2.281331 44.602131,2.281409 44.601936,2.281435 44.601688,2.281421 44.601495,2.28136 44.601345,2.281231 44.601181,2.280837 44.600873,2.280675 44.600596,2.280676 44.600427,2.280788 44.59986,2.280713 44.599518,2.280591 44.599371,2.279868 44.598685,2.279637 44.598565,2.279285 44.598527,2.278764 44.598417,2.278172 44.598243,2.277915 44.598189,2.277465 44.598159,2.277198 44.598193,2.27689 44.598274,2.275812 44.598643,2.275352 44.598693,2.274964 44.598656,2.274609 44.598554,2.27416 44.598377,2.273787 44.598177,2.273484 44.597979,2.273151 44.597592,2.27294 44.597239,2.272722 44.596781,2.272492 44.596411,2.272118 44.596098,2.271394 44.59583,2.27044 44.595565,2.270167 44.595465,2.269919 44.59534,2.269639 44.595154,2.269029 44.59468,2.26877 44.594463,2.26854 44.594201,2.268293 44.593962,2.267996 44.593769,2.267722 44.59363,2.267385 44.593514,2.267055 44.593443,2.266885 44.593357,2.267075 44.593129,2.267101 44.592912,2.266999 44.592644,2.266897 44.592533,2.266726 44.592427,2.266689 44.592292,2.266813 44.59219,2.267184 44.592059,2.267657 44.591946,2.268503 44.591784,2.268699 44.591762,2.269203 44.591756,2.269667 44.591723,2.26997 44.591602,2.270029 44.591424,2.269981 44.591314,2.269702 44.591137,2.269259 44.590998,2.269155 44.590902,2.269123 44.590785,2.269224 44.590566,2.269355 44.590491,2.269786 44.590378,2.269894 44.59022,2.269876 44.590074,2.269925 44.589983,2.270214 44.589861,2.270565 44.58982,2.270998 44.589939,2.271318 44.589988,2.271597 44.589936,2.271775 44.58982,2.271853 44.589654,2.271895 44.589262,2.272054 44.589141,2.272402 44.589071,2.272556 44.589081,2.272798 44.58919,2.272966 44.589336,2.273287 44.589704,2.273546 44.589841,2.2739 44.589866,2.274066 44.589769,2.274438 44.5892,2.274437 44.589087,2.274115 44.588958,2.274101 44.588864,2.274425 44.588626,2.274652 44.58858,2.274923 44.588565,2.275068 44.588604,2.275149 44.588757,2.275272 44.58888,2.275417 44.588903,2.275558 44.588866,2.275748 44.588726,2.275844 44.588574,2.276023 44.588212,2.276103 44.587847,2.276237 44.587611,2.276488 44.587616,2.276682 44.587725,2.276982 44.587989,2.27728 44.588337,2.277443 44.588388,2.277674 44.588311,2.277998 44.588342,2.278071 44.588317,2.278146 44.588109,2.277947 44.587652,2.278049 44.587517,2.278164 44.587277,2.27823 44.587046,2.278325 44.586957,2.278507 44.586927,2.27891 44.586921,2.279086 44.586995,2.279203 44.587093,2.279508 44.587458,2.279642 44.587728,2.279761 44.587862,2.279974 44.587973,2.280175 44.588031,2.280577 44.58809,2.280912 44.588106,2.281163 44.588215,2.281424 44.588381,2.281771 44.588553,2.282087 44.588781,2.282294 44.589037,2.282282 44.589354,2.282459 44.589443,2.282815 44.589497,2.283115 44.589437,2.283264 44.589352,2.283699 44.588971,2.283965 44.588667,2.284148 44.588558,2.28535 44.587993,2.285887 44.587711,2.285964 44.587708,2.286243 44.587849,2.286476 44.587868,2.286646 44.587827,2.286815 44.587669,2.287107 44.587311,2.287207 44.587145,2.287386 44.587067,2.287584 44.586853,2.287588 44.586713,2.287535 44.586567,2.287577 44.586473,2.287709 44.586445,2.287981 44.586469,2.288209 44.586414,2.288627 44.586258,2.288782 44.586248,2.288873 44.586094,2.289045 44.585958,2.289058 44.585447,2.288893 44.584551,2.288879 44.584339,2.288916 44.584124,2.289051 44.583897,2.289414 44.58342,2.28993 44.582642,2.29007 44.582475,2.289953 44.58179,2.290826 44.581528,2.29087 44.581411,2.291268 44.58112,2.291886 44.580813,2.292161 44.580733,2.292553 44.580762,2.292692 44.580724,2.29276 44.580587,2.292654 44.580392,2.292652 44.580208,2.293034 44.579685,2.293322 44.579397,2.29409 44.57887,2.294272 44.578525,2.294345 44.578177,2.293942 44.578519,2.292779 44.579071,2.292292 44.579285,2.291838 44.579532,2.291246 44.579915,2.291027 44.580026,2.290815 44.58009,2.290405 44.580088,2.289857 44.579937,2.289901 44.5791,2.289335 44.578965,2.289273 44.578156,2.289274 44.577302,2.289022 44.577301,2.288519 44.577435,2.288331 44.577391,2.287646 44.576841,2.287573 44.576367,2.287797 44.576161,2.288291 44.57565,2.28851 44.575332,2.288685 44.575025,2.289071 44.574816,2.290064 44.57414,2.29033 44.574014,2.29028 44.57382,2.290183 44.573746,2.289279 44.57213,2.289278 44.57195,2.289028 44.571455,2.288902 44.57105,2.288337 44.570196,2.287645 44.569342,2.28739 44.568856,2.287273 44.568776,2.286996 44.568506,2.286578 44.567893,2.286263 44.567308,2.285509 44.566139,2.285384 44.565959,2.285475 44.565146,2.285245 44.565141,2.285011 44.565193,2.284428 44.565435,2.284213 44.565479,2.284004 44.565481,2.283416 44.565333,2.283005 44.565196,2.282393 44.565012,2.281914 44.565016,2.281711 44.565035,2.281352 44.565163,2.281139 44.565201,2.280385 44.565185,2.279573 44.565056,2.279135 44.565035,2.278722 44.565076,2.278446 44.565128,2.277753 44.565347,2.277238 44.565542,2.276775 44.565665,2.276641 44.565803,2.276559 44.565985,2.276325 44.566228,2.275787 44.566562,2.274971 44.566831,2.274703 44.566997,2.274389 44.567434,2.273993 44.567747,2.273174 44.568198,2.272287 44.568624,2.272088 44.568686,2.271627 44.568787,2.271089 44.56885,2.270882 44.568899,2.270736 44.568975,2.270615 44.569095,2.270278 44.569497,2.269953 44.569727,2.269661 44.569789,2.269323 44.569732,2.268835 44.569607,2.268503 44.569616,2.2683 44.569667,2.268099 44.569793,2.267643 44.56994,2.267551 44.569934,2.267515 44.57019,2.2675 44.570904,2.267751 44.571894,2.267877 44.572254,2.268506 44.572434,2.26882 44.572389,2.26945 44.572165,2.269448 44.572884,2.269268 44.573802,2.269223 44.57423,2.269076 44.574423,2.268589 44.574865,2.268182 44.575256,2.268162 44.575341,2.268437 44.57562,2.268094 44.57577,2.267932 44.575926,2.267433 44.57629,2.267134 44.576556,2.26685 44.576757,2.266633 44.576969,2.266413 44.577258,2.26626 44.577561,2.266101 44.577817,2.265352 44.578323,2.264786 44.578862,2.263968 44.579401,2.261575 44.580308,2.259875 44.581296,2.258239 44.582014,2.257608 44.582374,2.257169 44.582238,2.256099 44.581563,2.255869 44.581437,2.25719 44.580218,2.257478 44.579987,2.257798 44.579765,2.258071 44.579608,2.258479 44.579403,2.258761 44.579228,2.258923 44.579012,2.25928 44.5786,2.259573 44.578436,2.259818 44.578059,2.259964 44.577527,2.259916 44.576865,2.261613 44.574688,2.260541 44.574356,2.260047 44.574268,2.259378 44.574178,2.258333 44.574088,2.25789 44.574092,2.257602 44.574172,2.257193 44.574415,2.256894 44.574571,2.255747 44.575061,2.255458 44.575103,2.254871 44.575144,2.25459 44.575121,2.254221 44.575062,2.253209 44.574935,2.253025 44.575874,2.253028 44.576261,2.252978 44.57653,2.252549 44.576966,2.252381 44.577269,2.252334 44.577555,2.252343 44.577811,2.252395 44.578167,2.252499 44.578231,2.25309 44.578726,2.253488 44.579107,2.253571 44.579949,2.254126 44.582049,2.254095 44.5823,2.253942 44.582675,2.253934 44.583154,2.25397 44.583362,2.254129 44.583677,2.254479 44.584056,2.254523 44.584129,2.254501 44.58451,2.254593 44.5848,2.254733 44.584947,2.255355 44.585371,2.255144 44.585566,2.25504 44.585877,2.254952 44.586212,2.255022 44.58641,2.254839 44.587125,2.254848 44.587415,2.254772 44.58769,2.254662 44.587929,2.254473 44.588224,2.25444 44.588425,2.254675 44.589047,2.254735 44.589281,2.254839 44.589447,2.255023 44.589632,2.255124 44.589818,2.255096 44.590011,2.254696 44.59043,2.25461 44.590664,2.254632 44.590851,2.254706 44.591014,2.254807 44.591117,2.254707 44.591221,2.254325 44.591362,2.254008 44.591581,2.254029 44.591707,2.254275 44.591977,2.254597 44.592177,2.254614 44.592357,2.254224 44.592655,2.254147 44.592976,2.253982 44.593078,2.253659 44.593116,2.253494 44.593176,2.253155 44.59347,2.253012 44.593565,2.252825 44.593627,2.25254 44.593659,2.252358 44.593627,2.251839 44.59364,2.251586 44.593716,2.25121 44.594052,2.25099 44.594205,2.250733 44.594203,2.250547 44.594239,2.250377 44.59422,2.250269 44.594105,2.249696 44.593824,2.24951 44.594546,2.249127 44.595382,2.248665 44.596195,2.248258 44.596747,2.247929 44.597053,2.246951 44.597621,2.246546 44.597831,2.245933 44.598088,2.243999 44.598661,2.242796 44.598981,2.242243 44.599082,2.241654 44.599117,2.24015 44.599089,2.23944 44.599114,2.238609 44.599161,2.237161 44.599281,2.236385 44.599411,2.235733 44.599594,2.235191 44.599795,2.234602 44.600085,2.234096 44.600435,2.233576 44.600934,2.233095 44.601616,2.232543 44.602751,2.232043 44.603873,2.231908 44.604261,2.231841 44.604807,2.231916 44.605685,2.232039 44.606471,2.232109 44.606818,2.23226 44.607232,2.232971 44.608423,2.233297 44.608929,2.23364 44.609463,2.233991 44.609903,2.234391 44.610264,2.234894 44.610601,2.235282 44.610796,2.235774 44.610937,2.238341 44.611096,2.240235 44.611121,2.241892 44.611118,2.243657 44.611197,2.245508 44.611336,2.24738 44.611503,2.249303 44.611658,2.250485 44.611808,2.250661 44.611838,2.252238 44.612117,2.254025 44.612397,2.255088 44.612528,2.256324 44.612582,2.257235 44.612668,2.257979 44.612882,2.258596 44.613197,2.259369 44.613958,2.260412 44.615409,2.261427 44.617062,2.262045 44.617804,2.262728 44.618458,2.263768 44.619202,2.264814 44.619797,2.264969 44.619869)))"
  ]
  "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(((2.264969 44.619869,2.266191 44.61959,2.266989 44.619328,2.267388 44.619167,2.267881 44.61888,2.26811 44.618691,2.268372 44.618438,2.269484 44.6173,2.269825 44.617003,2.270334 44.61674,2.270866 44.616577,2.271047 44.616479,2.271599 44.616075,2.271653 44.615924,2.271009 44.616152,2.270715 44.616215,2.270161 44.616431,2.269801 44.616529,2.269123 44.616613,2.269261 44.61652,2.269721 44.616099,2.270024 44.615913,2.270164 44.615791,2.270386 44.615533,2.271234 44.614757,2.271494 44.614551,2.272036 44.614038,2.272605 44.613685,2.273606 44.613119,2.273971 44.61303,2.274823 44.612773,2.275146 44.612722,2.276381 44.612565,2.276851 44.612558,2.27693 44.612284,2.277224 44.611502,2.277345 44.611315,2.277557 44.611177,2.277725 44.610823,2.277599 44.610733,2.277158 44.610508,2.27697 44.610148,2.277096 44.609834,2.277664 44.609429,2.278104 44.609205,2.278827 44.609029,2.278895 44.608569,2.278994 44.608314,2.278981 44.60816,2.278863 44.608065,2.278466 44.607989,2.278122 44.607989,2.277441 44.607958,2.27716 44.607852,2.276929 44.607234,2.276838 44.60708,2.276623 44.606973,2.27547 44.606551,2.275401 44.60641,2.275864 44.606259,2.276297 44.606188,2.277249 44.606119,2.278004 44.606056,2.278965 44.605986,2.279055 44.605901,2.280171 44.60523,2.279734 44.605092,2.279528 44.604965,2.279435 44.604831,2.279353 44.604431,2.279287 44.60429,2.279009 44.604047,2.278769 44.603929,2.278275 44.603772,2.277739 44.603637,2.276967 44.603471,2.276752 44.603364,2.276348 44.603035,2.277763 44.602643,2.277959 44.602577,2.27827 44.602527,2.278626 44.602498,2.28 44.602046,2.28 44.602451,2.279874 44.602856,2.279999 44.603036,2.280314 44.603179,2.280425 44.602925,2.280606 44.602725,2.281087 44.60238,2.281331 44.602131,2.281409 44.601936,2.281435 44.601688,2.281421 44.601495,2.28136 44.601345,2.281231 44.601181,2.280837 44.600873,2.280675 44.600596,2.280676 44.600427,2.280788 44.59986,2.280713 44.599518,2.280591 44.599371,2.279868 44.598685,2.279637 44.598565,2.279285 44.598527,2.278764 44.598417,2.278172 44.598243,2.277915 44.598189,2.277465 44.598159,2.277198 44.598193,2.27689 44.598274,2.275812 44.598643,2.275352 44.598693,2.274964 44.598656,2.274609 44.598554,2.27416 44.598377,2.273787 44.598177,2.273484 44.597979,2.273151 44.597592,2.27294 44.597239,2.272722 44.596781,2.272492 44.596411,2.272118 44.596098,2.271394 44.59583,2.27044 44.595565,2.270167 44.595465,2.269919 44.59534,2.269639 44.595154,2.269029 44.59468,2.26877 44.594463,2.26854 44.594201,2.268293 44.593962,2.267996 44.593769,2.267722 44.59363,2.267385 44.593514,2.267055 44.593443,2.266885 44.593357,2.267075 44.593129,2.267101 44.592912,2.266999 44.592644,2.266897 44.592533,2.266726 44.592427,2.266689 44.592292,2.266813 44.59219,2.267184 44.592059,2.267657 44.591946,2.268503 44.591784,2.268699 44.591762,2.269203 44.591756,2.269667 44.591723,2.26997 44.591602,2.270029 44.591424,2.269981 44.591314,2.269702 44.591137,2.269259 44.590998,2.269155 44.590902,2.269123 44.590785,2.269224 44.590566,2.269355 44.590491,2.269786 44.590378,2.269894 44.59022,2.269876 44.590074,2.269925 44.589983,2.270214 44.589861,2.270565 44.58982,2.270998 44.589939,2.271318 44.589988,2.271597 44.589936,2.271775 44.58982,2.271853 44.589654,2.271895 44.589262,2.272054 44.589141,2.272402 44.589071,2.272556 44.589081,2.272798 44.58919,2.272966 44.589336,2.273287 44.589704,2.273546 44.589841,2.2739 44.589866,2.274066 44.589769,2.274438 44.5892,2.274437 44.589087,2.274115 44.588958,2.274101 44.588864,2.274425 44.588626,2.274652 44.58858,2.274923 44.588565,2.275068 44.588604,2.275149 44.588757,2.275272 44.58888,2.275417 44.588903,2.275558 44.588866,2.275748 44.588726,2.275844 44.588574,2.276023 44.588212,2.276103 44.587847,2.276237 44.587611,2.276488 44.587616,2.276682 44.587725,2.276982 44.587989,2.27728 44.588337,2.277443 44.588388,2.277674 44.588311,2.277998 44.588342,2.278071 44.588317,2.278146 44.588109,2.277947 44.587652,2.278049 44.587517,2.278164 44.587277,2.27823 44.587046,2.278325 44.586957,2.278507 44.586927,2.27891 44.586921,2.279086 44.586995,2.279203 44.587093,2.279508 44.587458,2.279642 44.587728,2.279761 44.587862,2.279974 44.587973,2.280175 44.588031,2.280577 44.58809,2.280912 44.588106,2.281163 44.588215,2.281424 44.588381,2.281771 44.588553,2.282087 44.588781,2.282294 44.589037,2.282282 44.589354,2.282459 44.589443,2.282815 44.589497,2.283115 44.589437,2.283264 44.589352,2.283699 44.588971,2.283965 44.588667,2.284148 44.588558,2.28535 44.587993,2.285887 44.587711,2.285964 44.587708,2.286243 44.587849,2.286476 44.587868,2.286646 44.587827,2.286815 44.587669,2.287107 44.587311,2.287207 44.587145,2.287386 44.587067,2.287584 44.586853,2.287588 44.586713,2.287535 44.586567,2.287577 44.586473,2.287709 44.586445,2.287981 44.586469,2.288209 44.586414,2.288627 44.586258,2.288782 44.586248,2.288873 44.586094,2.289045 44.585958,2.289058 44.585447,2.288893 44.584551,2.288879 44.584339,2.288916 44.584124,2.289051 44.583897,2.289414 44.58342,2.28993 44.582642,2.29007 44.582475,2.289953 44.58179,2.290826 44.581528,2.29087 44.581411,2.291268 44.58112,2.291886 44.580813,2.292161 44.580733,2.292553 44.580762,2.292692 44.580724,2.29276 44.580587,2.292654 44.580392,2.292652 44.580208,2.293034 44.579685,2.293322 44.579397,2.29409 44.57887,2.294272 44.578525,2.294345 44.578177,2.293942 44.578519,2.292779 44.579071,2.292292 44.579285,2.291838 44.579532,2.291246 44.579915,2.291027 44.580026,2.290815 44.58009,2.290405 44.580088,2.289857 44.579937,2.289901 44.5791,2.289335 44.578965,2.289273 44.578156,2.289274 44.577302,2.289022 44.577301,2.288519 44.577435,2.288331 44.577391,2.287646 44.576841,2.287573 44.576367,2.287797 44.576161,2.288291 44.57565,2.28851 44.575332,2.288685 44.575025,2.289071 44.574816,2.290064 44.57414,2.29033 44.574014,2.29028 44.57382,2.290183 44.573746,2.289279 44.57213,2.289278 44.57195,2.289028 44.571455,2.288902 44.57105,2.288337 44.570196,2.287645 44.569342,2.28739 44.568856,2.287273 44.568776,2.286996 44.568506,2.286578 44.567893,2.286263 44.567308,2.285509 44.566139,2.285384 44.565959,2.285475 44.565146,2.285245 44.565141,2.285011 44.565193,2.284428 44.565435,2.284213 44.565479,2.284004 44.565481,2.283416 44.565333,2.283005 44.565196,2.282393 44.565012,2.281914 44.565016,2.281711 44.565035,2.281352 44.565163,2.281139 44.565201,2.280385 44.565185,2.279573 44.565056,2.279135 44.565035,2.278722 44.565076,2.278446 44.565128,2.277753 44.565347,2.277238 44.565542,2.276775 44.565665,2.276641 44.565803,2.276559 44.565985,2.276325 44.566228,2.275787 44.566562,2.274971 44.566831,2.274703 44.566997,2.274389 44.567434,2.273993 44.567747,2.273174 44.568198,2.272287 44.568624,2.272088 44.568686,2.271627 44.568787,2.271089 44.56885,2.270882 44.568899,2.270736 44.568975,2.270615 44.569095,2.270278 44.569497,2.269953 44.569727,2.269661 44.569789,2.269323 44.569732,2.268835 44.569607,2.268503 44.569616,2.2683 44.569667,2.268099 44.569793,2.267643 44.56994,2.267551 44.569934,2.267515 44.57019,2.2675 44.570904,2.267751 44.571894,2.267877 44.572254,2.268506 44.572434,2.26882 44.572389,2.26945 44.572165,2.269448 44.572884,2.269268 44.573802,2.269223 44.57423,2.269076 44.574423,2.268589 44.574865,2.268182 44.575256,2.268162 44.575341,2.268437 44.57562,2.268094 44.57577,2.267932 44.575926,2.267433 44.57629,2.267134 44.576556,2.26685 44.576757,2.266633 44.576969,2.266413 44.577258,2.26626 44.577561,2.266101 44.577817,2.265352 44.578323,2.264786 44.578862,2.263968 44.579401,2.261575 44.580308,2.259875 44.581296,2.258239 44.582014,2.257608 44.582374,2.257169 44.582238,2.256099 44.581563,2.255869 44.581437,2.25719 44.580218,2.257478 44.579987,2.257798 44.579765,2.258071 44.579608,2.258479 44.579403,2.258761 44.579228,2.258923 44.579012,2.25928 44.5786,2.259573 44.578436,2.259818 44.578059,2.259964 44.577527,2.259916 44.576865,2.261613 44.574688,2.260541 44.574356,2.260047 44.574268,2.259378 44.574178,2.258333 44.574088,2.25789 44.574092,2.257602 44.574172,2.257193 44.574415,2.256894 44.574571,2.255747 44.575061,2.255458 44.575103,2.254871 44.575144,2.25459 44.575121,2.254221 44.575062,2.253209 44.574935,2.253025 44.575874,2.253028 44.576261,2.252978 44.57653,2.252549 44.576966,2.252381 44.577269,2.252334 44.577555,2.252343 44.577811,2.252395 44.578167,2.252499 44.578231,2.25309 44.578726,2.253488 44.579107,2.253571 44.579949,2.254126 44.582049,2.254095 44.5823,2.253942 44.582675,2.253934 44.583154,2.25397 44.583362,2.254129 44.583677,2.254479 44.584056,2.254523 44.584129,2.254501 44.58451,2.254593 44.5848,2.254733 44.584947,2.255355 44.585371,2.255144 44.585566,2.25504 44.585877,2.254952 44.586212,2.255022 44.58641,2.254839 44.587125,2.254848 44.587415,2.254772 44.58769,2.254662 44.587929,2.254473 44.588224,2.25444 44.588425,2.254675 44.589047,2.254735 44.589281,2.254839 44.589447,2.255023 44.589632,2.255124 44.589818,2.255096 44.590011,2.254696 44.59043,2.25461 44.590664,2.254632 44.590851,2.254706 44.591014,2.254807 44.591117,2.254707 44.591221,2.254325 44.591362,2.254008 44.591581,2.254029 44.591707,2.254275 44.591977,2.254597 44.592177,2.254614 44.592357,2.254224 44.592655,2.254147 44.592976,2.253982 44.593078,2.253659 44.593116,2.253494 44.593176,2.253155 44.59347,2.253012 44.593565,2.252825 44.593627,2.25254 44.593659,2.252358 44.593627,2.251839 44.59364,2.251586 44.593716,2.25121 44.594052,2.25099 44.594205,2.250733 44.594203,2.250547 44.594239,2.250377 44.59422,2.250269 44.594105,2.249696 44.593824,2.24951 44.594546,2.249127 44.595382,2.248665 44.596195,2.248258 44.596747,2.247929 44.597053,2.246951 44.597621,2.246546 44.597831,2.245933 44.598088,2.243999 44.598661,2.242796 44.598981,2.242243 44.599082,2.241654 44.599117,2.24015 44.599089,2.23944 44.599114,2.238609 44.599161,2.237161 44.599281,2.236385 44.599411,2.235733 44.599594,2.235191 44.599795,2.234602 44.600085,2.234096 44.600435,2.233576 44.600934,2.233095 44.601616,2.232543 44.602751,2.232043 44.603873,2.231908 44.604261,2.231841 44.604807,2.231916 44.605685,2.232039 44.606471,2.232109 44.606818,2.23226 44.607232,2.232971 44.608423,2.233297 44.608929,2.23364 44.609463,2.233991 44.609903,2.234391 44.610264,2.234894 44.610601,2.235282 44.610796,2.235774 44.610937,2.238341 44.611096,2.240235 44.611121,2.241892 44.611118,2.243657 44.611197,2.245508 44.611336,2.24738 44.611503,2.249303 44.611658,2.250485 44.611808,2.250661 44.611838,2.252238 44.612117,2.254025 44.612397,2.255088 44.612528,2.256324 44.612582,2.257235 44.612668,2.257979 44.612882,2.258596 44.613197,2.259369 44.613958,2.260412 44.615409,2.261427 44.617062,2.262045 44.617804,2.262728 44.618458,2.263768 44.619202,2.264814 44.619797,2.264969 44.619869)))"
  ]
  "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(((2.264969 44.619869,2.266191 44.61959,2.266989 44.619328,2.267388 44.619167,2.267881 44.61888,2.26811 44.618691,2.268372 44.618438,2.269484 44.6173,2.269825 44.617003,2.270334 44.61674,2.270866 44.616577,2.271047 44.616479,2.271599 44.616075,2.271653 44.615924,2.271009 44.616152,2.270715 44.616215,2.270161 44.616431,2.269801 44.616529,2.269123 44.616613,2.269261 44.61652,2.269721 44.616099,2.270024 44.615913,2.270164 44.615791,2.270386 44.615533,2.271234 44.614757,2.271494 44.614551,2.272036 44.614038,2.272605 44.613685,2.273606 44.613119,2.273971 44.61303,2.274823 44.612773,2.275146 44.612722,2.276381 44.612565,2.276851 44.612558,2.27693 44.612284,2.277224 44.611502,2.277345 44.611315,2.277557 44.611177,2.277725 44.610823,2.277599 44.610733,2.277158 44.610508,2.27697 44.610148,2.277096 44.609834,2.277664 44.609429,2.278104 44.609205,2.278827 44.609029,2.278895 44.608569,2.278994 44.608314,2.278981 44.60816,2.278863 44.608065,2.278466 44.607989,2.278122 44.607989,2.277441 44.607958,2.27716 44.607852,2.276929 44.607234,2.276838 44.60708,2.276623 44.606973,2.27547 44.606551,2.275401 44.60641,2.275864 44.606259,2.276297 44.606188,2.277249 44.606119,2.278004 44.606056,2.278965 44.605986,2.279055 44.605901,2.280171 44.60523,2.279734 44.605092,2.279528 44.604965,2.279435 44.604831,2.279353 44.604431,2.279287 44.60429,2.279009 44.604047,2.278769 44.603929,2.278275 44.603772,2.277739 44.603637,2.276967 44.603471,2.276752 44.603364,2.276348 44.603035,2.277763 44.602643,2.277959 44.602577,2.27827 44.602527,2.278626 44.602498,2.28 44.602046,2.28 44.602451,2.279874 44.602856,2.279999 44.603036,2.280314 44.603179,2.280425 44.602925,2.280606 44.602725,2.281087 44.60238,2.281331 44.602131,2.281409 44.601936,2.281435 44.601688,2.281421 44.601495,2.28136 44.601345,2.281231 44.601181,2.280837 44.600873,2.280675 44.600596,2.280676 44.600427,2.280788 44.59986,2.280713 44.599518,2.280591 44.599371,2.279868 44.598685,2.279637 44.598565,2.279285 44.598527,2.278764 44.598417,2.278172 44.598243,2.277915 44.598189,2.277465 44.598159,2.277198 44.598193,2.27689 44.598274,2.275812 44.598643,2.275352 44.598693,2.274964 44.598656,2.274609 44.598554,2.27416 44.598377,2.273787 44.598177,2.273484 44.597979,2.273151 44.597592,2.27294 44.597239,2.272722 44.596781,2.272492 44.596411,2.272118 44.596098,2.271394 44.59583,2.27044 44.595565,2.270167 44.595465,2.269919 44.59534,2.269639 44.595154,2.269029 44.59468,2.26877 44.594463,2.26854 44.594201,2.268293 44.593962,2.267996 44.593769,2.267722 44.59363,2.267385 44.593514,2.267055 44.593443,2.266885 44.593357,2.267075 44.593129,2.267101 44.592912,2.266999 44.592644,2.266897 44.592533,2.266726 44.592427,2.266689 44.592292,2.266813 44.59219,2.267184 44.592059,2.267657 44.591946,2.268503 44.591784,2.268699 44.591762,2.269203 44.591756,2.269667 44.591723,2.26997 44.591602,2.270029 44.591424,2.269981 44.591314,2.269702 44.591137,2.269259 44.590998,2.269155 44.590902,2.269123 44.590785,2.269224 44.590566,2.269355 44.590491,2.269786 44.590378,2.269894 44.59022,2.269876 44.590074,2.269925 44.589983,2.270214 44.589861,2.270565 44.58982,2.270998 44.589939,2.271318 44.589988,2.271597 44.589936,2.271775 44.58982,2.271853 44.589654,2.271895 44.589262,2.272054 44.589141,2.272402 44.589071,2.272556 44.589081,2.272798 44.58919,2.272966 44.589336,2.273287 44.589704,2.273546 44.589841,2.2739 44.589866,2.274066 44.589769,2.274438 44.5892,2.274437 44.589087,2.274115 44.588958,2.274101 44.588864,2.274425 44.588626,2.274652 44.58858,2.274923 44.588565,2.275068 44.588604,2.275149 44.588757,2.275272 44.58888,2.275417 44.588903,2.275558 44.588866,2.275748 44.588726,2.275844 44.588574,2.276023 44.588212,2.276103 44.587847,2.276237 44.587611,2.276488 44.587616,2.276682 44.587725,2.276982 44.587989,2.27728 44.588337,2.277443 44.588388,2.277674 44.588311,2.277998 44.588342,2.278071 44.588317,2.278146 44.588109,2.277947 44.587652,2.278049 44.587517,2.278164 44.587277,2.27823 44.587046,2.278325 44.586957,2.278507 44.586927,2.27891 44.586921,2.279086 44.586995,2.279203 44.587093,2.279508 44.587458,2.279642 44.587728,2.279761 44.587862,2.279974 44.587973,2.280175 44.588031,2.280577 44.58809,2.280912 44.588106,2.281163 44.588215,2.281424 44.588381,2.281771 44.588553,2.282087 44.588781,2.282294 44.589037,2.282282 44.589354,2.282459 44.589443,2.282815 44.589497,2.283115 44.589437,2.283264 44.589352,2.283699 44.588971,2.283965 44.588667,2.284148 44.588558,2.28535 44.587993,2.285887 44.587711,2.285964 44.587708,2.286243 44.587849,2.286476 44.587868,2.286646 44.587827,2.286815 44.587669,2.287107 44.587311,2.287207 44.587145,2.287386 44.587067,2.287584 44.586853,2.287588 44.586713,2.287535 44.586567,2.287577 44.586473,2.287709 44.586445,2.287981 44.586469,2.288209 44.586414,2.288627 44.586258,2.288782 44.586248,2.288873 44.586094,2.289045 44.585958,2.289058 44.585447,2.288893 44.584551,2.288879 44.584339,2.288916 44.584124,2.289051 44.583897,2.289414 44.58342,2.28993 44.582642,2.29007 44.582475,2.289953 44.58179,2.290826 44.581528,2.29087 44.581411,2.291268 44.58112,2.291886 44.580813,2.292161 44.580733,2.292553 44.580762,2.292692 44.580724,2.29276 44.580587,2.292654 44.580392,2.292652 44.580208,2.293034 44.579685,2.293322 44.579397,2.29409 44.57887,2.294272 44.578525,2.294345 44.578177,2.293942 44.578519,2.292779 44.579071,2.292292 44.579285,2.291838 44.579532,2.291246 44.579915,2.291027 44.580026,2.290815 44.58009,2.290405 44.580088,2.289857 44.579937,2.289901 44.5791,2.289335 44.578965,2.289273 44.578156,2.289274 44.577302,2.289022 44.577301,2.288519 44.577435,2.288331 44.577391,2.287646 44.576841,2.287573 44.576367,2.287797 44.576161,2.288291 44.57565,2.28851 44.575332,2.288685 44.575025,2.289071 44.574816,2.290064 44.57414,2.29033 44.574014,2.29028 44.57382,2.290183 44.573746,2.289279 44.57213,2.289278 44.57195,2.289028 44.571455,2.288902 44.57105,2.288337 44.570196,2.287645 44.569342,2.28739 44.568856,2.287273 44.568776,2.286996 44.568506,2.286578 44.567893,2.286263 44.567308,2.285509 44.566139,2.285384 44.565959,2.285475 44.565146,2.285245 44.565141,2.285011 44.565193,2.284428 44.565435,2.284213 44.565479,2.284004 44.565481,2.283416 44.565333,2.283005 44.565196,2.282393 44.565012,2.281914 44.565016,2.281711 44.565035,2.281352 44.565163,2.281139 44.565201,2.280385 44.565185,2.279573 44.565056,2.279135 44.565035,2.278722 44.565076,2.278446 44.565128,2.277753 44.565347,2.277238 44.565542,2.276775 44.565665,2.276641 44.565803,2.276559 44.565985,2.276325 44.566228,2.275787 44.566562,2.274971 44.566831,2.274703 44.566997,2.274389 44.567434,2.273993 44.567747,2.273174 44.568198,2.272287 44.568624,2.272088 44.568686,2.271627 44.568787,2.271089 44.56885,2.270882 44.568899,2.270736 44.568975,2.270615 44.569095,2.270278 44.569497,2.269953 44.569727,2.269661 44.569789,2.269323 44.569732,2.268835 44.569607,2.268503 44.569616,2.2683 44.569667,2.268099 44.569793,2.267643 44.56994,2.267551 44.569934,2.267515 44.57019,2.2675 44.570904,2.267751 44.571894,2.267877 44.572254,2.268506 44.572434,2.26882 44.572389,2.26945 44.572165,2.269448 44.572884,2.269268 44.573802,2.269223 44.57423,2.269076 44.574423,2.268589 44.574865,2.268182 44.575256,2.268162 44.575341,2.268437 44.57562,2.268094 44.57577,2.267932 44.575926,2.267433 44.57629,2.267134 44.576556,2.26685 44.576757,2.266633 44.576969,2.266413 44.577258,2.26626 44.577561,2.266101 44.577817,2.265352 44.578323,2.264786 44.578862,2.263968 44.579401,2.261575 44.580308,2.259875 44.581296,2.258239 44.582014,2.257608 44.582374,2.257169 44.582238,2.256099 44.581563,2.255869 44.581437,2.25719 44.580218,2.257478 44.579987,2.257798 44.579765,2.258071 44.579608,2.258479 44.579403,2.258761 44.579228,2.258923 44.579012,2.25928 44.5786,2.259573 44.578436,2.259818 44.578059,2.259964 44.577527,2.259916 44.576865,2.261613 44.574688,2.260541 44.574356,2.260047 44.574268,2.259378 44.574178,2.258333 44.574088,2.25789 44.574092,2.257602 44.574172,2.257193 44.574415,2.256894 44.574571,2.255747 44.575061,2.255458 44.575103,2.254871 44.575144,2.25459 44.575121,2.254221 44.575062,2.253209 44.574935,2.253025 44.575874,2.253028 44.576261,2.252978 44.57653,2.252549 44.576966,2.252381 44.577269,2.252334 44.577555,2.252343 44.577811,2.252395 44.578167,2.252499 44.578231,2.25309 44.578726,2.253488 44.579107,2.253571 44.579949,2.254126 44.582049,2.254095 44.5823,2.253942 44.582675,2.253934 44.583154,2.25397 44.583362,2.254129 44.583677,2.254479 44.584056,2.254523 44.584129,2.254501 44.58451,2.254593 44.5848,2.254733 44.584947,2.255355 44.585371,2.255144 44.585566,2.25504 44.585877,2.254952 44.586212,2.255022 44.58641,2.254839 44.587125,2.254848 44.587415,2.254772 44.58769,2.254662 44.587929,2.254473 44.588224,2.25444 44.588425,2.254675 44.589047,2.254735 44.589281,2.254839 44.589447,2.255023 44.589632,2.255124 44.589818,2.255096 44.590011,2.254696 44.59043,2.25461 44.590664,2.254632 44.590851,2.254706 44.591014,2.254807 44.591117,2.254707 44.591221,2.254325 44.591362,2.254008 44.591581,2.254029 44.591707,2.254275 44.591977,2.254597 44.592177,2.254614 44.592357,2.254224 44.592655,2.254147 44.592976,2.253982 44.593078,2.253659 44.593116,2.253494 44.593176,2.253155 44.59347,2.253012 44.593565,2.252825 44.593627,2.25254 44.593659,2.252358 44.593627,2.251839 44.59364,2.251586 44.593716,2.25121 44.594052,2.25099 44.594205,2.250733 44.594203,2.250547 44.594239,2.250377 44.59422,2.250269 44.594105,2.249696 44.593824,2.24951 44.594546,2.249127 44.595382,2.248665 44.596195,2.248258 44.596747,2.247929 44.597053,2.246951 44.597621,2.246546 44.597831,2.245933 44.598088,2.243999 44.598661,2.242796 44.598981,2.242243 44.599082,2.241654 44.599117,2.24015 44.599089,2.23944 44.599114,2.238609 44.599161,2.237161 44.599281,2.236385 44.599411,2.235733 44.599594,2.235191 44.599795,2.234602 44.600085,2.234096 44.600435,2.233576 44.600934,2.233095 44.601616,2.232543 44.602751,2.232043 44.603873,2.231908 44.604261,2.231841 44.604807,2.231916 44.605685,2.232039 44.606471,2.232109 44.606818,2.23226 44.607232,2.232971 44.608423,2.233297 44.608929,2.23364 44.609463,2.233991 44.609903,2.234391 44.610264,2.234894 44.610601,2.235282 44.610796,2.235774 44.610937,2.238341 44.611096,2.240235 44.611121,2.241892 44.611118,2.243657 44.611197,2.245508 44.611336,2.24738 44.611503,2.249303 44.611658,2.250485 44.611808,2.250661 44.611838,2.252238 44.612117,2.254025 44.612397,2.255088 44.612528,2.256324 44.612582,2.257235 44.612668,2.257979 44.612882,2.258596 44.613197,2.259369 44.613958,2.260412 44.615409,2.261427 44.617062,2.262045 44.617804,2.262728 44.618458,2.263768 44.619202,2.264814 44.619797,2.264969 44.619869)))"
  ]
  "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 => 27693
  ]
  "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 => 27693
  ]
  "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(((2.264969 44.619869,2.266191 44.61959,2.266989 44.619328,2.267388 44.619167,2.267881 44.61888,2.26811 44.618691,2.268372 44.618438,2.269484 44.6173,2.269825 44.617003,2.270334 44.61674,2.270866 44.616577,2.271047 44.616479,2.271599 44.616075,2.271653 44.615924,2.271009 44.616152,2.270715 44.616215,2.270161 44.616431,2.269801 44.616529,2.269123 44.616613,2.269261 44.61652,2.269721 44.616099,2.270024 44.615913,2.270164 44.615791,2.270386 44.615533,2.271234 44.614757,2.271494 44.614551,2.272036 44.614038,2.272605 44.613685,2.273606 44.613119,2.273971 44.61303,2.274823 44.612773,2.275146 44.612722,2.276381 44.612565,2.276851 44.612558,2.27693 44.612284,2.277224 44.611502,2.277345 44.611315,2.277557 44.611177,2.277725 44.610823,2.277599 44.610733,2.277158 44.610508,2.27697 44.610148,2.277096 44.609834,2.277664 44.609429,2.278104 44.609205,2.278827 44.609029,2.278895 44.608569,2.278994 44.608314,2.278981 44.60816,2.278863 44.608065,2.278466 44.607989,2.278122 44.607989,2.277441 44.607958,2.27716 44.607852,2.276929 44.607234,2.276838 44.60708,2.276623 44.606973,2.27547 44.606551,2.275401 44.60641,2.275864 44.606259,2.276297 44.606188,2.277249 44.606119,2.278004 44.606056,2.278965 44.605986,2.279055 44.605901,2.280171 44.60523,2.279734 44.605092,2.279528 44.604965,2.279435 44.604831,2.279353 44.604431,2.279287 44.60429,2.279009 44.604047,2.278769 44.603929,2.278275 44.603772,2.277739 44.603637,2.276967 44.603471,2.276752 44.603364,2.276348 44.603035,2.277763 44.602643,2.277959 44.602577,2.27827 44.602527,2.278626 44.602498,2.28 44.602046,2.28 44.602451,2.279874 44.602856,2.279999 44.603036,2.280314 44.603179,2.280425 44.602925,2.280606 44.602725,2.281087 44.60238,2.281331 44.602131,2.281409 44.601936,2.281435 44.601688,2.281421 44.601495,2.28136 44.601345,2.281231 44.601181,2.280837 44.600873,2.280675 44.600596,2.280676 44.600427,2.280788 44.59986,2.280713 44.599518,2.280591 44.599371,2.279868 44.598685,2.279637 44.598565,2.279285 44.598527,2.278764 44.598417,2.278172 44.598243,2.277915 44.598189,2.277465 44.598159,2.277198 44.598193,2.27689 44.598274,2.275812 44.598643,2.275352 44.598693,2.274964 44.598656,2.274609 44.598554,2.27416 44.598377,2.273787 44.598177,2.273484 44.597979,2.273151 44.597592,2.27294 44.597239,2.272722 44.596781,2.272492 44.596411,2.272118 44.596098,2.271394 44.59583,2.27044 44.595565,2.270167 44.595465,2.269919 44.59534,2.269639 44.595154,2.269029 44.59468,2.26877 44.594463,2.26854 44.594201,2.268293 44.593962,2.267996 44.593769,2.267722 44.59363,2.267385 44.593514,2.267055 44.593443,2.266885 44.593357,2.267075 44.593129,2.267101 44.592912,2.266999 44.592644,2.266897 44.592533,2.266726 44.592427,2.266689 44.592292,2.266813 44.59219,2.267184 44.592059,2.267657 44.591946,2.268503 44.591784,2.268699 44.591762,2.269203 44.591756,2.269667 44.591723,2.26997 44.591602,2.270029 44.591424,2.269981 44.591314,2.269702 44.591137,2.269259 44.590998,2.269155 44.590902,2.269123 44.590785,2.269224 44.590566,2.269355 44.590491,2.269786 44.590378,2.269894 44.59022,2.269876 44.590074,2.269925 44.589983,2.270214 44.589861,2.270565 44.58982,2.270998 44.589939,2.271318 44.589988,2.271597 44.589936,2.271775 44.58982,2.271853 44.589654,2.271895 44.589262,2.272054 44.589141,2.272402 44.589071,2.272556 44.589081,2.272798 44.58919,2.272966 44.589336,2.273287 44.589704,2.273546 44.589841,2.2739 44.589866,2.274066 44.589769,2.274438 44.5892,2.274437 44.589087,2.274115 44.588958,2.274101 44.588864,2.274425 44.588626,2.274652 44.58858,2.274923 44.588565,2.275068 44.588604,2.275149 44.588757,2.275272 44.58888,2.275417 44.588903,2.275558 44.588866,2.275748 44.588726,2.275844 44.588574,2.276023 44.588212,2.276103 44.587847,2.276237 44.587611,2.276488 44.587616,2.276682 44.587725,2.276982 44.587989,2.27728 44.588337,2.277443 44.588388,2.277674 44.588311,2.277998 44.588342,2.278071 44.588317,2.278146 44.588109,2.277947 44.587652,2.278049 44.587517,2.278164 44.587277,2.27823 44.587046,2.278325 44.586957,2.278507 44.586927,2.27891 44.586921,2.279086 44.586995,2.279203 44.587093,2.279508 44.587458,2.279642 44.587728,2.279761 44.587862,2.279974 44.587973,2.280175 44.588031,2.280577 44.58809,2.280912 44.588106,2.281163 44.588215,2.281424 44.588381,2.281771 44.588553,2.282087 44.588781,2.282294 44.589037,2.282282 44.589354,2.282459 44.589443,2.282815 44.589497,2.283115 44.589437,2.283264 44.589352,2.283699 44.588971,2.283965 44.588667,2.284148 44.588558,2.28535 44.587993,2.285887 44.587711,2.285964 44.587708,2.286243 44.587849,2.286476 44.587868,2.286646 44.587827,2.286815 44.587669,2.287107 44.587311,2.287207 44.587145,2.287386 44.587067,2.287584 44.586853,2.287588 44.586713,2.287535 44.586567,2.287577 44.586473,2.287709 44.586445,2.287981 44.586469,2.288209 44.586414,2.288627 44.586258,2.288782 44.586248,2.288873 44.586094,2.289045 44.585958,2.289058 44.585447,2.288893 44.584551,2.288879 44.584339,2.288916 44.584124,2.289051 44.583897,2.289414 44.58342,2.28993 44.582642,2.29007 44.582475,2.289953 44.58179,2.290826 44.581528,2.29087 44.581411,2.291268 44.58112,2.291886 44.580813,2.292161 44.580733,2.292553 44.580762,2.292692 44.580724,2.29276 44.580587,2.292654 44.580392,2.292652 44.580208,2.293034 44.579685,2.293322 44.579397,2.29409 44.57887,2.294272 44.578525,2.294345 44.578177,2.293942 44.578519,2.292779 44.579071,2.292292 44.579285,2.291838 44.579532,2.291246 44.579915,2.291027 44.580026,2.290815 44.58009,2.290405 44.580088,2.289857 44.579937,2.289901 44.5791,2.289335 44.578965,2.289273 44.578156,2.289274 44.577302,2.289022 44.577301,2.288519 44.577435,2.288331 44.577391,2.287646 44.576841,2.287573 44.576367,2.287797 44.576161,2.288291 44.57565,2.28851 44.575332,2.288685 44.575025,2.289071 44.574816,2.290064 44.57414,2.29033 44.574014,2.29028 44.57382,2.290183 44.573746,2.289279 44.57213,2.289278 44.57195,2.289028 44.571455,2.288902 44.57105,2.288337 44.570196,2.287645 44.569342,2.28739 44.568856,2.287273 44.568776,2.286996 44.568506,2.286578 44.567893,2.286263 44.567308,2.285509 44.566139,2.285384 44.565959,2.285475 44.565146,2.285245 44.565141,2.285011 44.565193,2.284428 44.565435,2.284213 44.565479,2.284004 44.565481,2.283416 44.565333,2.283005 44.565196,2.282393 44.565012,2.281914 44.565016,2.281711 44.565035,2.281352 44.565163,2.281139 44.565201,2.280385 44.565185,2.279573 44.565056,2.279135 44.565035,2.278722 44.565076,2.278446 44.565128,2.277753 44.565347,2.277238 44.565542,2.276775 44.565665,2.276641 44.565803,2.276559 44.565985,2.276325 44.566228,2.275787 44.566562,2.274971 44.566831,2.274703 44.566997,2.274389 44.567434,2.273993 44.567747,2.273174 44.568198,2.272287 44.568624,2.272088 44.568686,2.271627 44.568787,2.271089 44.56885,2.270882 44.568899,2.270736 44.568975,2.270615 44.569095,2.270278 44.569497,2.269953 44.569727,2.269661 44.569789,2.269323 44.569732,2.268835 44.569607,2.268503 44.569616,2.2683 44.569667,2.268099 44.569793,2.267643 44.56994,2.267551 44.569934,2.267515 44.57019,2.2675 44.570904,2.267751 44.571894,2.267877 44.572254,2.268506 44.572434,2.26882 44.572389,2.26945 44.572165,2.269448 44.572884,2.269268 44.573802,2.269223 44.57423,2.269076 44.574423,2.268589 44.574865,2.268182 44.575256,2.268162 44.575341,2.268437 44.57562,2.268094 44.57577,2.267932 44.575926,2.267433 44.57629,2.267134 44.576556,2.26685 44.576757,2.266633 44.576969,2.266413 44.577258,2.26626 44.577561,2.266101 44.577817,2.265352 44.578323,2.264786 44.578862,2.263968 44.579401,2.261575 44.580308,2.259875 44.581296,2.258239 44.582014,2.257608 44.582374,2.257169 44.582238,2.256099 44.581563,2.255869 44.581437,2.25719 44.580218,2.257478 44.579987,2.257798 44.579765,2.258071 44.579608,2.258479 44.579403,2.258761 44.579228,2.258923 44.579012,2.25928 44.5786,2.259573 44.578436,2.259818 44.578059,2.259964 44.577527,2.259916 44.576865,2.261613 44.574688,2.260541 44.574356,2.260047 44.574268,2.259378 44.574178,2.258333 44.574088,2.25789 44.574092,2.257602 44.574172,2.257193 44.574415,2.256894 44.574571,2.255747 44.575061,2.255458 44.575103,2.254871 44.575144,2.25459 44.575121,2.254221 44.575062,2.253209 44.574935,2.253025 44.575874,2.253028 44.576261,2.252978 44.57653,2.252549 44.576966,2.252381 44.577269,2.252334 44.577555,2.252343 44.577811,2.252395 44.578167,2.252499 44.578231,2.25309 44.578726,2.253488 44.579107,2.253571 44.579949,2.254126 44.582049,2.254095 44.5823,2.253942 44.582675,2.253934 44.583154,2.25397 44.583362,2.254129 44.583677,2.254479 44.584056,2.254523 44.584129,2.254501 44.58451,2.254593 44.5848,2.254733 44.584947,2.255355 44.585371,2.255144 44.585566,2.25504 44.585877,2.254952 44.586212,2.255022 44.58641,2.254839 44.587125,2.254848 44.587415,2.254772 44.58769,2.254662 44.587929,2.254473 44.588224,2.25444 44.588425,2.254675 44.589047,2.254735 44.589281,2.254839 44.589447,2.255023 44.589632,2.255124 44.589818,2.255096 44.590011,2.254696 44.59043,2.25461 44.590664,2.254632 44.590851,2.254706 44.591014,2.254807 44.591117,2.254707 44.591221,2.254325 44.591362,2.254008 44.591581,2.254029 44.591707,2.254275 44.591977,2.254597 44.592177,2.254614 44.592357,2.254224 44.592655,2.254147 44.592976,2.253982 44.593078,2.253659 44.593116,2.253494 44.593176,2.253155 44.59347,2.253012 44.593565,2.252825 44.593627,2.25254 44.593659,2.252358 44.593627,2.251839 44.59364,2.251586 44.593716,2.25121 44.594052,2.25099 44.594205,2.250733 44.594203,2.250547 44.594239,2.250377 44.59422,2.250269 44.594105,2.249696 44.593824,2.24951 44.594546,2.249127 44.595382,2.248665 44.596195,2.248258 44.596747,2.247929 44.597053,2.246951 44.597621,2.246546 44.597831,2.245933 44.598088,2.243999 44.598661,2.242796 44.598981,2.242243 44.599082,2.241654 44.599117,2.24015 44.599089,2.23944 44.599114,2.238609 44.599161,2.237161 44.599281,2.236385 44.599411,2.235733 44.599594,2.235191 44.599795,2.234602 44.600085,2.234096 44.600435,2.233576 44.600934,2.233095 44.601616,2.232543 44.602751,2.232043 44.603873,2.231908 44.604261,2.231841 44.604807,2.231916 44.605685,2.232039 44.606471,2.232109 44.606818,2.23226 44.607232,2.232971 44.608423,2.233297 44.608929,2.23364 44.609463,2.233991 44.609903,2.234391 44.610264,2.234894 44.610601,2.235282 44.610796,2.235774 44.610937,2.238341 44.611096,2.240235 44.611121,2.241892 44.611118,2.243657 44.611197,2.245508 44.611336,2.24738 44.611503,2.249303 44.611658,2.250485 44.611808,2.250661 44.611838,2.252238 44.612117,2.254025 44.612397,2.255088 44.612528,2.256324 44.612582,2.257235 44.612668,2.257979 44.612882,2.258596 44.613197,2.259369 44.613958,2.260412 44.615409,2.261427 44.617062,2.262045 44.617804,2.262728 44.618458,2.263768 44.619202,2.264814 44.619797,2.264969 44.619869)))"
    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(((2.264969 44.619869,2.266191 44.61959,2.266989 44.619328,2.267388 44.619167,2.267881 44.61888,2.26811 44.618691,2.268372 44.618438,2.269484 44.6173,2.269825 44.617003,2.270334 44.61674,2.270866 44.616577,2.271047 44.616479,2.271599 44.616075,2.271653 44.615924,2.271009 44.616152,2.270715 44.616215,2.270161 44.616431,2.269801 44.616529,2.269123 44.616613,2.269261 44.61652,2.269721 44.616099,2.270024 44.615913,2.270164 44.615791,2.270386 44.615533,2.271234 44.614757,2.271494 44.614551,2.272036 44.614038,2.272605 44.613685,2.273606 44.613119,2.273971 44.61303,2.274823 44.612773,2.275146 44.612722,2.276381 44.612565,2.276851 44.612558,2.27693 44.612284,2.277224 44.611502,2.277345 44.611315,2.277557 44.611177,2.277725 44.610823,2.277599 44.610733,2.277158 44.610508,2.27697 44.610148,2.277096 44.609834,2.277664 44.609429,2.278104 44.609205,2.278827 44.609029,2.278895 44.608569,2.278994 44.608314,2.278981 44.60816,2.278863 44.608065,2.278466 44.607989,2.278122 44.607989,2.277441 44.607958,2.27716 44.607852,2.276929 44.607234,2.276838 44.60708,2.276623 44.606973,2.27547 44.606551,2.275401 44.60641,2.275864 44.606259,2.276297 44.606188,2.277249 44.606119,2.278004 44.606056,2.278965 44.605986,2.279055 44.605901,2.280171 44.60523,2.279734 44.605092,2.279528 44.604965,2.279435 44.604831,2.279353 44.604431,2.279287 44.60429,2.279009 44.604047,2.278769 44.603929,2.278275 44.603772,2.277739 44.603637,2.276967 44.603471,2.276752 44.603364,2.276348 44.603035,2.277763 44.602643,2.277959 44.602577,2.27827 44.602527,2.278626 44.602498,2.28 44.602046,2.28 44.602451,2.279874 44.602856,2.279999 44.603036,2.280314 44.603179,2.280425 44.602925,2.280606 44.602725,2.281087 44.60238,2.281331 44.602131,2.281409 44.601936,2.281435 44.601688,2.281421 44.601495,2.28136 44.601345,2.281231 44.601181,2.280837 44.600873,2.280675 44.600596,2.280676 44.600427,2.280788 44.59986,2.280713 44.599518,2.280591 44.599371,2.279868 44.598685,2.279637 44.598565,2.279285 44.598527,2.278764 44.598417,2.278172 44.598243,2.277915 44.598189,2.277465 44.598159,2.277198 44.598193,2.27689 44.598274,2.275812 44.598643,2.275352 44.598693,2.274964 44.598656,2.274609 44.598554,2.27416 44.598377,2.273787 44.598177,2.273484 44.597979,2.273151 44.597592,2.27294 44.597239,2.272722 44.596781,2.272492 44.596411,2.272118 44.596098,2.271394 44.59583,2.27044 44.595565,2.270167 44.595465,2.269919 44.59534,2.269639 44.595154,2.269029 44.59468,2.26877 44.594463,2.26854 44.594201,2.268293 44.593962,2.267996 44.593769,2.267722 44.59363,2.267385 44.593514,2.267055 44.593443,2.266885 44.593357,2.267075 44.593129,2.267101 44.592912,2.266999 44.592644,2.266897 44.592533,2.266726 44.592427,2.266689 44.592292,2.266813 44.59219,2.267184 44.592059,2.267657 44.591946,2.268503 44.591784,2.268699 44.591762,2.269203 44.591756,2.269667 44.591723,2.26997 44.591602,2.270029 44.591424,2.269981 44.591314,2.269702 44.591137,2.269259 44.590998,2.269155 44.590902,2.269123 44.590785,2.269224 44.590566,2.269355 44.590491,2.269786 44.590378,2.269894 44.59022,2.269876 44.590074,2.269925 44.589983,2.270214 44.589861,2.270565 44.58982,2.270998 44.589939,2.271318 44.589988,2.271597 44.589936,2.271775 44.58982,2.271853 44.589654,2.271895 44.589262,2.272054 44.589141,2.272402 44.589071,2.272556 44.589081,2.272798 44.58919,2.272966 44.589336,2.273287 44.589704,2.273546 44.589841,2.2739 44.589866,2.274066 44.589769,2.274438 44.5892,2.274437 44.589087,2.274115 44.588958,2.274101 44.588864,2.274425 44.588626,2.274652 44.58858,2.274923 44.588565,2.275068 44.588604,2.275149 44.588757,2.275272 44.58888,2.275417 44.588903,2.275558 44.588866,2.275748 44.588726,2.275844 44.588574,2.276023 44.588212,2.276103 44.587847,2.276237 44.587611,2.276488 44.587616,2.276682 44.587725,2.276982 44.587989,2.27728 44.588337,2.277443 44.588388,2.277674 44.588311,2.277998 44.588342,2.278071 44.588317,2.278146 44.588109,2.277947 44.587652,2.278049 44.587517,2.278164 44.587277,2.27823 44.587046,2.278325 44.586957,2.278507 44.586927,2.27891 44.586921,2.279086 44.586995,2.279203 44.587093,2.279508 44.587458,2.279642 44.587728,2.279761 44.587862,2.279974 44.587973,2.280175 44.588031,2.280577 44.58809,2.280912 44.588106,2.281163 44.588215,2.281424 44.588381,2.281771 44.588553,2.282087 44.588781,2.282294 44.589037,2.282282 44.589354,2.282459 44.589443,2.282815 44.589497,2.283115 44.589437,2.283264 44.589352,2.283699 44.588971,2.283965 44.588667,2.284148 44.588558,2.28535 44.587993,2.285887 44.587711,2.285964 44.587708,2.286243 44.587849,2.286476 44.587868,2.286646 44.587827,2.286815 44.587669,2.287107 44.587311,2.287207 44.587145,2.287386 44.587067,2.287584 44.586853,2.287588 44.586713,2.287535 44.586567,2.287577 44.586473,2.287709 44.586445,2.287981 44.586469,2.288209 44.586414,2.288627 44.586258,2.288782 44.586248,2.288873 44.586094,2.289045 44.585958,2.289058 44.585447,2.288893 44.584551,2.288879 44.584339,2.288916 44.584124,2.289051 44.583897,2.289414 44.58342,2.28993 44.582642,2.29007 44.582475,2.289953 44.58179,2.290826 44.581528,2.29087 44.581411,2.291268 44.58112,2.291886 44.580813,2.292161 44.580733,2.292553 44.580762,2.292692 44.580724,2.29276 44.580587,2.292654 44.580392,2.292652 44.580208,2.293034 44.579685,2.293322 44.579397,2.29409 44.57887,2.294272 44.578525,2.294345 44.578177,2.293942 44.578519,2.292779 44.579071,2.292292 44.579285,2.291838 44.579532,2.291246 44.579915,2.291027 44.580026,2.290815 44.58009,2.290405 44.580088,2.289857 44.579937,2.289901 44.5791,2.289335 44.578965,2.289273 44.578156,2.289274 44.577302,2.289022 44.577301,2.288519 44.577435,2.288331 44.577391,2.287646 44.576841,2.287573 44.576367,2.287797 44.576161,2.288291 44.57565,2.28851 44.575332,2.288685 44.575025,2.289071 44.574816,2.290064 44.57414,2.29033 44.574014,2.29028 44.57382,2.290183 44.573746,2.289279 44.57213,2.289278 44.57195,2.289028 44.571455,2.288902 44.57105,2.288337 44.570196,2.287645 44.569342,2.28739 44.568856,2.287273 44.568776,2.286996 44.568506,2.286578 44.567893,2.286263 44.567308,2.285509 44.566139,2.285384 44.565959,2.285475 44.565146,2.285245 44.565141,2.285011 44.565193,2.284428 44.565435,2.284213 44.565479,2.284004 44.565481,2.283416 44.565333,2.283005 44.565196,2.282393 44.565012,2.281914 44.565016,2.281711 44.565035,2.281352 44.565163,2.281139 44.565201,2.280385 44.565185,2.279573 44.565056,2.279135 44.565035,2.278722 44.565076,2.278446 44.565128,2.277753 44.565347,2.277238 44.565542,2.276775 44.565665,2.276641 44.565803,2.276559 44.565985,2.276325 44.566228,2.275787 44.566562,2.274971 44.566831,2.274703 44.566997,2.274389 44.567434,2.273993 44.567747,2.273174 44.568198,2.272287 44.568624,2.272088 44.568686,2.271627 44.568787,2.271089 44.56885,2.270882 44.568899,2.270736 44.568975,2.270615 44.569095,2.270278 44.569497,2.269953 44.569727,2.269661 44.569789,2.269323 44.569732,2.268835 44.569607,2.268503 44.569616,2.2683 44.569667,2.268099 44.569793,2.267643 44.56994,2.267551 44.569934,2.267515 44.57019,2.2675 44.570904,2.267751 44.571894,2.267877 44.572254,2.268506 44.572434,2.26882 44.572389,2.26945 44.572165,2.269448 44.572884,2.269268 44.573802,2.269223 44.57423,2.269076 44.574423,2.268589 44.574865,2.268182 44.575256,2.268162 44.575341,2.268437 44.57562,2.268094 44.57577,2.267932 44.575926,2.267433 44.57629,2.267134 44.576556,2.26685 44.576757,2.266633 44.576969,2.266413 44.577258,2.26626 44.577561,2.266101 44.577817,2.265352 44.578323,2.264786 44.578862,2.263968 44.579401,2.261575 44.580308,2.259875 44.581296,2.258239 44.582014,2.257608 44.582374,2.257169 44.582238,2.256099 44.581563,2.255869 44.581437,2.25719 44.580218,2.257478 44.579987,2.257798 44.579765,2.258071 44.579608,2.258479 44.579403,2.258761 44.579228,2.258923 44.579012,2.25928 44.5786,2.259573 44.578436,2.259818 44.578059,2.259964 44.577527,2.259916 44.576865,2.261613 44.574688,2.260541 44.574356,2.260047 44.574268,2.259378 44.574178,2.258333 44.574088,2.25789 44.574092,2.257602 44.574172,2.257193 44.574415,2.256894 44.574571,2.255747 44.575061,2.255458 44.575103,2.254871 44.575144,2.25459 44.575121,2.254221 44.575062,2.253209 44.574935,2.253025 44.575874,2.253028 44.576261,2.252978 44.57653,2.252549 44.576966,2.252381 44.577269,2.252334 44.577555,2.252343 44.577811,2.252395 44.578167,2.252499 44.578231,2.25309 44.578726,2.253488 44.579107,2.253571 44.579949,2.254126 44.582049,2.254095 44.5823,2.253942 44.582675,2.253934 44.583154,2.25397 44.583362,2.254129 44.583677,2.254479 44.584056,2.254523 44.584129,2.254501 44.58451,2.254593 44.5848,2.254733 44.584947,2.255355 44.585371,2.255144 44.585566,2.25504 44.585877,2.254952 44.586212,2.255022 44.58641,2.254839 44.587125,2.254848 44.587415,2.254772 44.58769,2.254662 44.587929,2.254473 44.588224,2.25444 44.588425,2.254675 44.589047,2.254735 44.589281,2.254839 44.589447,2.255023 44.589632,2.255124 44.589818,2.255096 44.590011,2.254696 44.59043,2.25461 44.590664,2.254632 44.590851,2.254706 44.591014,2.254807 44.591117,2.254707 44.591221,2.254325 44.591362,2.254008 44.591581,2.254029 44.591707,2.254275 44.591977,2.254597 44.592177,2.254614 44.592357,2.254224 44.592655,2.254147 44.592976,2.253982 44.593078,2.253659 44.593116,2.253494 44.593176,2.253155 44.59347,2.253012 44.593565,2.252825 44.593627,2.25254 44.593659,2.252358 44.593627,2.251839 44.59364,2.251586 44.593716,2.25121 44.594052,2.25099 44.594205,2.250733 44.594203,2.250547 44.594239,2.250377 44.59422,2.250269 44.594105,2.249696 44.593824,2.24951 44.594546,2.249127 44.595382,2.248665 44.596195,2.248258 44.596747,2.247929 44.597053,2.246951 44.597621,2.246546 44.597831,2.245933 44.598088,2.243999 44.598661,2.242796 44.598981,2.242243 44.599082,2.241654 44.599117,2.24015 44.599089,2.23944 44.599114,2.238609 44.599161,2.237161 44.599281,2.236385 44.599411,2.235733 44.599594,2.235191 44.599795,2.234602 44.600085,2.234096 44.600435,2.233576 44.600934,2.233095 44.601616,2.232543 44.602751,2.232043 44.603873,2.231908 44.604261,2.231841 44.604807,2.231916 44.605685,2.232039 44.606471,2.232109 44.606818,2.23226 44.607232,2.232971 44.608423,2.233297 44.608929,2.23364 44.609463,2.233991 44.609903,2.234391 44.610264,2.234894 44.610601,2.235282 44.610796,2.235774 44.610937,2.238341 44.611096,2.240235 44.611121,2.241892 44.611118,2.243657 44.611197,2.245508 44.611336,2.24738 44.611503,2.249303 44.611658,2.250485 44.611808,2.250661 44.611838,2.252238 44.612117,2.254025 44.612397,2.255088 44.612528,2.256324 44.612582,2.257235 44.612668,2.257979 44.612882,2.258596 44.613197,2.259369 44.613958,2.260412 44.615409,2.261427 44.617062,2.262045 44.617804,2.262728 44.618458,2.263768 44.619202,2.264814 44.619797,2.264969 44.619869)))"
  ]
  "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(((2.264969 44.619869,2.266191 44.61959,2.266989 44.619328,2.267388 44.619167,2.267881 44.61888,2.26811 44.618691,2.268372 44.618438,2.269484 44.6173,2.269825 44.617003,2.270334 44.61674,2.270866 44.616577,2.271047 44.616479,2.271599 44.616075,2.271653 44.615924,2.271009 44.616152,2.270715 44.616215,2.270161 44.616431,2.269801 44.616529,2.269123 44.616613,2.269261 44.61652,2.269721 44.616099,2.270024 44.615913,2.270164 44.615791,2.270386 44.615533,2.271234 44.614757,2.271494 44.614551,2.272036 44.614038,2.272605 44.613685,2.273606 44.613119,2.273971 44.61303,2.274823 44.612773,2.275146 44.612722,2.276381 44.612565,2.276851 44.612558,2.27693 44.612284,2.277224 44.611502,2.277345 44.611315,2.277557 44.611177,2.277725 44.610823,2.277599 44.610733,2.277158 44.610508,2.27697 44.610148,2.277096 44.609834,2.277664 44.609429,2.278104 44.609205,2.278827 44.609029,2.278895 44.608569,2.278994 44.608314,2.278981 44.60816,2.278863 44.608065,2.278466 44.607989,2.278122 44.607989,2.277441 44.607958,2.27716 44.607852,2.276929 44.607234,2.276838 44.60708,2.276623 44.606973,2.27547 44.606551,2.275401 44.60641,2.275864 44.606259,2.276297 44.606188,2.277249 44.606119,2.278004 44.606056,2.278965 44.605986,2.279055 44.605901,2.280171 44.60523,2.279734 44.605092,2.279528 44.604965,2.279435 44.604831,2.279353 44.604431,2.279287 44.60429,2.279009 44.604047,2.278769 44.603929,2.278275 44.603772,2.277739 44.603637,2.276967 44.603471,2.276752 44.603364,2.276348 44.603035,2.277763 44.602643,2.277959 44.602577,2.27827 44.602527,2.278626 44.602498,2.28 44.602046,2.28 44.602451,2.279874 44.602856,2.279999 44.603036,2.280314 44.603179,2.280425 44.602925,2.280606 44.602725,2.281087 44.60238,2.281331 44.602131,2.281409 44.601936,2.281435 44.601688,2.281421 44.601495,2.28136 44.601345,2.281231 44.601181,2.280837 44.600873,2.280675 44.600596,2.280676 44.600427,2.280788 44.59986,2.280713 44.599518,2.280591 44.599371,2.279868 44.598685,2.279637 44.598565,2.279285 44.598527,2.278764 44.598417,2.278172 44.598243,2.277915 44.598189,2.277465 44.598159,2.277198 44.598193,2.27689 44.598274,2.275812 44.598643,2.275352 44.598693,2.274964 44.598656,2.274609 44.598554,2.27416 44.598377,2.273787 44.598177,2.273484 44.597979,2.273151 44.597592,2.27294 44.597239,2.272722 44.596781,2.272492 44.596411,2.272118 44.596098,2.271394 44.59583,2.27044 44.595565,2.270167 44.595465,2.269919 44.59534,2.269639 44.595154,2.269029 44.59468,2.26877 44.594463,2.26854 44.594201,2.268293 44.593962,2.267996 44.593769,2.267722 44.59363,2.267385 44.593514,2.267055 44.593443,2.266885 44.593357,2.267075 44.593129,2.267101 44.592912,2.266999 44.592644,2.266897 44.592533,2.266726 44.592427,2.266689 44.592292,2.266813 44.59219,2.267184 44.592059,2.267657 44.591946,2.268503 44.591784,2.268699 44.591762,2.269203 44.591756,2.269667 44.591723,2.26997 44.591602,2.270029 44.591424,2.269981 44.591314,2.269702 44.591137,2.269259 44.590998,2.269155 44.590902,2.269123 44.590785,2.269224 44.590566,2.269355 44.590491,2.269786 44.590378,2.269894 44.59022,2.269876 44.590074,2.269925 44.589983,2.270214 44.589861,2.270565 44.58982,2.270998 44.589939,2.271318 44.589988,2.271597 44.589936,2.271775 44.58982,2.271853 44.589654,2.271895 44.589262,2.272054 44.589141,2.272402 44.589071,2.272556 44.589081,2.272798 44.58919,2.272966 44.589336,2.273287 44.589704,2.273546 44.589841,2.2739 44.589866,2.274066 44.589769,2.274438 44.5892,2.274437 44.589087,2.274115 44.588958,2.274101 44.588864,2.274425 44.588626,2.274652 44.58858,2.274923 44.588565,2.275068 44.588604,2.275149 44.588757,2.275272 44.58888,2.275417 44.588903,2.275558 44.588866,2.275748 44.588726,2.275844 44.588574,2.276023 44.588212,2.276103 44.587847,2.276237 44.587611,2.276488 44.587616,2.276682 44.587725,2.276982 44.587989,2.27728 44.588337,2.277443 44.588388,2.277674 44.588311,2.277998 44.588342,2.278071 44.588317,2.278146 44.588109,2.277947 44.587652,2.278049 44.587517,2.278164 44.587277,2.27823 44.587046,2.278325 44.586957,2.278507 44.586927,2.27891 44.586921,2.279086 44.586995,2.279203 44.587093,2.279508 44.587458,2.279642 44.587728,2.279761 44.587862,2.279974 44.587973,2.280175 44.588031,2.280577 44.58809,2.280912 44.588106,2.281163 44.588215,2.281424 44.588381,2.281771 44.588553,2.282087 44.588781,2.282294 44.589037,2.282282 44.589354,2.282459 44.589443,2.282815 44.589497,2.283115 44.589437,2.283264 44.589352,2.283699 44.588971,2.283965 44.588667,2.284148 44.588558,2.28535 44.587993,2.285887 44.587711,2.285964 44.587708,2.286243 44.587849,2.286476 44.587868,2.286646 44.587827,2.286815 44.587669,2.287107 44.587311,2.287207 44.587145,2.287386 44.587067,2.287584 44.586853,2.287588 44.586713,2.287535 44.586567,2.287577 44.586473,2.287709 44.586445,2.287981 44.586469,2.288209 44.586414,2.288627 44.586258,2.288782 44.586248,2.288873 44.586094,2.289045 44.585958,2.289058 44.585447,2.288893 44.584551,2.288879 44.584339,2.288916 44.584124,2.289051 44.583897,2.289414 44.58342,2.28993 44.582642,2.29007 44.582475,2.289953 44.58179,2.290826 44.581528,2.29087 44.581411,2.291268 44.58112,2.291886 44.580813,2.292161 44.580733,2.292553 44.580762,2.292692 44.580724,2.29276 44.580587,2.292654 44.580392,2.292652 44.580208,2.293034 44.579685,2.293322 44.579397,2.29409 44.57887,2.294272 44.578525,2.294345 44.578177,2.293942 44.578519,2.292779 44.579071,2.292292 44.579285,2.291838 44.579532,2.291246 44.579915,2.291027 44.580026,2.290815 44.58009,2.290405 44.580088,2.289857 44.579937,2.289901 44.5791,2.289335 44.578965,2.289273 44.578156,2.289274 44.577302,2.289022 44.577301,2.288519 44.577435,2.288331 44.577391,2.287646 44.576841,2.287573 44.576367,2.287797 44.576161,2.288291 44.57565,2.28851 44.575332,2.288685 44.575025,2.289071 44.574816,2.290064 44.57414,2.29033 44.574014,2.29028 44.57382,2.290183 44.573746,2.289279 44.57213,2.289278 44.57195,2.289028 44.571455,2.288902 44.57105,2.288337 44.570196,2.287645 44.569342,2.28739 44.568856,2.287273 44.568776,2.286996 44.568506,2.286578 44.567893,2.286263 44.567308,2.285509 44.566139,2.285384 44.565959,2.285475 44.565146,2.285245 44.565141,2.285011 44.565193,2.284428 44.565435,2.284213 44.565479,2.284004 44.565481,2.283416 44.565333,2.283005 44.565196,2.282393 44.565012,2.281914 44.565016,2.281711 44.565035,2.281352 44.565163,2.281139 44.565201,2.280385 44.565185,2.279573 44.565056,2.279135 44.565035,2.278722 44.565076,2.278446 44.565128,2.277753 44.565347,2.277238 44.565542,2.276775 44.565665,2.276641 44.565803,2.276559 44.565985,2.276325 44.566228,2.275787 44.566562,2.274971 44.566831,2.274703 44.566997,2.274389 44.567434,2.273993 44.567747,2.273174 44.568198,2.272287 44.568624,2.272088 44.568686,2.271627 44.568787,2.271089 44.56885,2.270882 44.568899,2.270736 44.568975,2.270615 44.569095,2.270278 44.569497,2.269953 44.569727,2.269661 44.569789,2.269323 44.569732,2.268835 44.569607,2.268503 44.569616,2.2683 44.569667,2.268099 44.569793,2.267643 44.56994,2.267551 44.569934,2.267515 44.57019,2.2675 44.570904,2.267751 44.571894,2.267877 44.572254,2.268506 44.572434,2.26882 44.572389,2.26945 44.572165,2.269448 44.572884,2.269268 44.573802,2.269223 44.57423,2.269076 44.574423,2.268589 44.574865,2.268182 44.575256,2.268162 44.575341,2.268437 44.57562,2.268094 44.57577,2.267932 44.575926,2.267433 44.57629,2.267134 44.576556,2.26685 44.576757,2.266633 44.576969,2.266413 44.577258,2.26626 44.577561,2.266101 44.577817,2.265352 44.578323,2.264786 44.578862,2.263968 44.579401,2.261575 44.580308,2.259875 44.581296,2.258239 44.582014,2.257608 44.582374,2.257169 44.582238,2.256099 44.581563,2.255869 44.581437,2.25719 44.580218,2.257478 44.579987,2.257798 44.579765,2.258071 44.579608,2.258479 44.579403,2.258761 44.579228,2.258923 44.579012,2.25928 44.5786,2.259573 44.578436,2.259818 44.578059,2.259964 44.577527,2.259916 44.576865,2.261613 44.574688,2.260541 44.574356,2.260047 44.574268,2.259378 44.574178,2.258333 44.574088,2.25789 44.574092,2.257602 44.574172,2.257193 44.574415,2.256894 44.574571,2.255747 44.575061,2.255458 44.575103,2.254871 44.575144,2.25459 44.575121,2.254221 44.575062,2.253209 44.574935,2.253025 44.575874,2.253028 44.576261,2.252978 44.57653,2.252549 44.576966,2.252381 44.577269,2.252334 44.577555,2.252343 44.577811,2.252395 44.578167,2.252499 44.578231,2.25309 44.578726,2.253488 44.579107,2.253571 44.579949,2.254126 44.582049,2.254095 44.5823,2.253942 44.582675,2.253934 44.583154,2.25397 44.583362,2.254129 44.583677,2.254479 44.584056,2.254523 44.584129,2.254501 44.58451,2.254593 44.5848,2.254733 44.584947,2.255355 44.585371,2.255144 44.585566,2.25504 44.585877,2.254952 44.586212,2.255022 44.58641,2.254839 44.587125,2.254848 44.587415,2.254772 44.58769,2.254662 44.587929,2.254473 44.588224,2.25444 44.588425,2.254675 44.589047,2.254735 44.589281,2.254839 44.589447,2.255023 44.589632,2.255124 44.589818,2.255096 44.590011,2.254696 44.59043,2.25461 44.590664,2.254632 44.590851,2.254706 44.591014,2.254807 44.591117,2.254707 44.591221,2.254325 44.591362,2.254008 44.591581,2.254029 44.591707,2.254275 44.591977,2.254597 44.592177,2.254614 44.592357,2.254224 44.592655,2.254147 44.592976,2.253982 44.593078,2.253659 44.593116,2.253494 44.593176,2.253155 44.59347,2.253012 44.593565,2.252825 44.593627,2.25254 44.593659,2.252358 44.593627,2.251839 44.59364,2.251586 44.593716,2.25121 44.594052,2.25099 44.594205,2.250733 44.594203,2.250547 44.594239,2.250377 44.59422,2.250269 44.594105,2.249696 44.593824,2.24951 44.594546,2.249127 44.595382,2.248665 44.596195,2.248258 44.596747,2.247929 44.597053,2.246951 44.597621,2.246546 44.597831,2.245933 44.598088,2.243999 44.598661,2.242796 44.598981,2.242243 44.599082,2.241654 44.599117,2.24015 44.599089,2.23944 44.599114,2.238609 44.599161,2.237161 44.599281,2.236385 44.599411,2.235733 44.599594,2.235191 44.599795,2.234602 44.600085,2.234096 44.600435,2.233576 44.600934,2.233095 44.601616,2.232543 44.602751,2.232043 44.603873,2.231908 44.604261,2.231841 44.604807,2.231916 44.605685,2.232039 44.606471,2.232109 44.606818,2.23226 44.607232,2.232971 44.608423,2.233297 44.608929,2.23364 44.609463,2.233991 44.609903,2.234391 44.610264,2.234894 44.610601,2.235282 44.610796,2.235774 44.610937,2.238341 44.611096,2.240235 44.611121,2.241892 44.611118,2.243657 44.611197,2.245508 44.611336,2.24738 44.611503,2.249303 44.611658,2.250485 44.611808,2.250661 44.611838,2.252238 44.612117,2.254025 44.612397,2.255088 44.612528,2.256324 44.612582,2.257235 44.612668,2.257979 44.612882,2.258596 44.613197,2.259369 44.613958,2.260412 44.615409,2.261427 44.617062,2.262045 44.617804,2.262728 44.618458,2.263768 44.619202,2.264814 44.619797,2.264969 44.619869)))"
  ]
  "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(((2.264969 44.619869,2.266191 44.61959,2.266989 44.619328,2.267388 44.619167,2.267881 44.61888,2.26811 44.618691,2.268372 44.618438,2.269484 44.6173,2.269825 44.617003,2.270334 44.61674,2.270866 44.616577,2.271047 44.616479,2.271599 44.616075,2.271653 44.615924,2.271009 44.616152,2.270715 44.616215,2.270161 44.616431,2.269801 44.616529,2.269123 44.616613,2.269261 44.61652,2.269721 44.616099,2.270024 44.615913,2.270164 44.615791,2.270386 44.615533,2.271234 44.614757,2.271494 44.614551,2.272036 44.614038,2.272605 44.613685,2.273606 44.613119,2.273971 44.61303,2.274823 44.612773,2.275146 44.612722,2.276381 44.612565,2.276851 44.612558,2.27693 44.612284,2.277224 44.611502,2.277345 44.611315,2.277557 44.611177,2.277725 44.610823,2.277599 44.610733,2.277158 44.610508,2.27697 44.610148,2.277096 44.609834,2.277664 44.609429,2.278104 44.609205,2.278827 44.609029,2.278895 44.608569,2.278994 44.608314,2.278981 44.60816,2.278863 44.608065,2.278466 44.607989,2.278122 44.607989,2.277441 44.607958,2.27716 44.607852,2.276929 44.607234,2.276838 44.60708,2.276623 44.606973,2.27547 44.606551,2.275401 44.60641,2.275864 44.606259,2.276297 44.606188,2.277249 44.606119,2.278004 44.606056,2.278965 44.605986,2.279055 44.605901,2.280171 44.60523,2.279734 44.605092,2.279528 44.604965,2.279435 44.604831,2.279353 44.604431,2.279287 44.60429,2.279009 44.604047,2.278769 44.603929,2.278275 44.603772,2.277739 44.603637,2.276967 44.603471,2.276752 44.603364,2.276348 44.603035,2.277763 44.602643,2.277959 44.602577,2.27827 44.602527,2.278626 44.602498,2.28 44.602046,2.28 44.602451,2.279874 44.602856,2.279999 44.603036,2.280314 44.603179,2.280425 44.602925,2.280606 44.602725,2.281087 44.60238,2.281331 44.602131,2.281409 44.601936,2.281435 44.601688,2.281421 44.601495,2.28136 44.601345,2.281231 44.601181,2.280837 44.600873,2.280675 44.600596,2.280676 44.600427,2.280788 44.59986,2.280713 44.599518,2.280591 44.599371,2.279868 44.598685,2.279637 44.598565,2.279285 44.598527,2.278764 44.598417,2.278172 44.598243,2.277915 44.598189,2.277465 44.598159,2.277198 44.598193,2.27689 44.598274,2.275812 44.598643,2.275352 44.598693,2.274964 44.598656,2.274609 44.598554,2.27416 44.598377,2.273787 44.598177,2.273484 44.597979,2.273151 44.597592,2.27294 44.597239,2.272722 44.596781,2.272492 44.596411,2.272118 44.596098,2.271394 44.59583,2.27044 44.595565,2.270167 44.595465,2.269919 44.59534,2.269639 44.595154,2.269029 44.59468,2.26877 44.594463,2.26854 44.594201,2.268293 44.593962,2.267996 44.593769,2.267722 44.59363,2.267385 44.593514,2.267055 44.593443,2.266885 44.593357,2.267075 44.593129,2.267101 44.592912,2.266999 44.592644,2.266897 44.592533,2.266726 44.592427,2.266689 44.592292,2.266813 44.59219,2.267184 44.592059,2.267657 44.591946,2.268503 44.591784,2.268699 44.591762,2.269203 44.591756,2.269667 44.591723,2.26997 44.591602,2.270029 44.591424,2.269981 44.591314,2.269702 44.591137,2.269259 44.590998,2.269155 44.590902,2.269123 44.590785,2.269224 44.590566,2.269355 44.590491,2.269786 44.590378,2.269894 44.59022,2.269876 44.590074,2.269925 44.589983,2.270214 44.589861,2.270565 44.58982,2.270998 44.589939,2.271318 44.589988,2.271597 44.589936,2.271775 44.58982,2.271853 44.589654,2.271895 44.589262,2.272054 44.589141,2.272402 44.589071,2.272556 44.589081,2.272798 44.58919,2.272966 44.589336,2.273287 44.589704,2.273546 44.589841,2.2739 44.589866,2.274066 44.589769,2.274438 44.5892,2.274437 44.589087,2.274115 44.588958,2.274101 44.588864,2.274425 44.588626,2.274652 44.58858,2.274923 44.588565,2.275068 44.588604,2.275149 44.588757,2.275272 44.58888,2.275417 44.588903,2.275558 44.588866,2.275748 44.588726,2.275844 44.588574,2.276023 44.588212,2.276103 44.587847,2.276237 44.587611,2.276488 44.587616,2.276682 44.587725,2.276982 44.587989,2.27728 44.588337,2.277443 44.588388,2.277674 44.588311,2.277998 44.588342,2.278071 44.588317,2.278146 44.588109,2.277947 44.587652,2.278049 44.587517,2.278164 44.587277,2.27823 44.587046,2.278325 44.586957,2.278507 44.586927,2.27891 44.586921,2.279086 44.586995,2.279203 44.587093,2.279508 44.587458,2.279642 44.587728,2.279761 44.587862,2.279974 44.587973,2.280175 44.588031,2.280577 44.58809,2.280912 44.588106,2.281163 44.588215,2.281424 44.588381,2.281771 44.588553,2.282087 44.588781,2.282294 44.589037,2.282282 44.589354,2.282459 44.589443,2.282815 44.589497,2.283115 44.589437,2.283264 44.589352,2.283699 44.588971,2.283965 44.588667,2.284148 44.588558,2.28535 44.587993,2.285887 44.587711,2.285964 44.587708,2.286243 44.587849,2.286476 44.587868,2.286646 44.587827,2.286815 44.587669,2.287107 44.587311,2.287207 44.587145,2.287386 44.587067,2.287584 44.586853,2.287588 44.586713,2.287535 44.586567,2.287577 44.586473,2.287709 44.586445,2.287981 44.586469,2.288209 44.586414,2.288627 44.586258,2.288782 44.586248,2.288873 44.586094,2.289045 44.585958,2.289058 44.585447,2.288893 44.584551,2.288879 44.584339,2.288916 44.584124,2.289051 44.583897,2.289414 44.58342,2.28993 44.582642,2.29007 44.582475,2.289953 44.58179,2.290826 44.581528,2.29087 44.581411,2.291268 44.58112,2.291886 44.580813,2.292161 44.580733,2.292553 44.580762,2.292692 44.580724,2.29276 44.580587,2.292654 44.580392,2.292652 44.580208,2.293034 44.579685,2.293322 44.579397,2.29409 44.57887,2.294272 44.578525,2.294345 44.578177,2.293942 44.578519,2.292779 44.579071,2.292292 44.579285,2.291838 44.579532,2.291246 44.579915,2.291027 44.580026,2.290815 44.58009,2.290405 44.580088,2.289857 44.579937,2.289901 44.5791,2.289335 44.578965,2.289273 44.578156,2.289274 44.577302,2.289022 44.577301,2.288519 44.577435,2.288331 44.577391,2.287646 44.576841,2.287573 44.576367,2.287797 44.576161,2.288291 44.57565,2.28851 44.575332,2.288685 44.575025,2.289071 44.574816,2.290064 44.57414,2.29033 44.574014,2.29028 44.57382,2.290183 44.573746,2.289279 44.57213,2.289278 44.57195,2.289028 44.571455,2.288902 44.57105,2.288337 44.570196,2.287645 44.569342,2.28739 44.568856,2.287273 44.568776,2.286996 44.568506,2.286578 44.567893,2.286263 44.567308,2.285509 44.566139,2.285384 44.565959,2.285475 44.565146,2.285245 44.565141,2.285011 44.565193,2.284428 44.565435,2.284213 44.565479,2.284004 44.565481,2.283416 44.565333,2.283005 44.565196,2.282393 44.565012,2.281914 44.565016,2.281711 44.565035,2.281352 44.565163,2.281139 44.565201,2.280385 44.565185,2.279573 44.565056,2.279135 44.565035,2.278722 44.565076,2.278446 44.565128,2.277753 44.565347,2.277238 44.565542,2.276775 44.565665,2.276641 44.565803,2.276559 44.565985,2.276325 44.566228,2.275787 44.566562,2.274971 44.566831,2.274703 44.566997,2.274389 44.567434,2.273993 44.567747,2.273174 44.568198,2.272287 44.568624,2.272088 44.568686,2.271627 44.568787,2.271089 44.56885,2.270882 44.568899,2.270736 44.568975,2.270615 44.569095,2.270278 44.569497,2.269953 44.569727,2.269661 44.569789,2.269323 44.569732,2.268835 44.569607,2.268503 44.569616,2.2683 44.569667,2.268099 44.569793,2.267643 44.56994,2.267551 44.569934,2.267515 44.57019,2.2675 44.570904,2.267751 44.571894,2.267877 44.572254,2.268506 44.572434,2.26882 44.572389,2.26945 44.572165,2.269448 44.572884,2.269268 44.573802,2.269223 44.57423,2.269076 44.574423,2.268589 44.574865,2.268182 44.575256,2.268162 44.575341,2.268437 44.57562,2.268094 44.57577,2.267932 44.575926,2.267433 44.57629,2.267134 44.576556,2.26685 44.576757,2.266633 44.576969,2.266413 44.577258,2.26626 44.577561,2.266101 44.577817,2.265352 44.578323,2.264786 44.578862,2.263968 44.579401,2.261575 44.580308,2.259875 44.581296,2.258239 44.582014,2.257608 44.582374,2.257169 44.582238,2.256099 44.581563,2.255869 44.581437,2.25719 44.580218,2.257478 44.579987,2.257798 44.579765,2.258071 44.579608,2.258479 44.579403,2.258761 44.579228,2.258923 44.579012,2.25928 44.5786,2.259573 44.578436,2.259818 44.578059,2.259964 44.577527,2.259916 44.576865,2.261613 44.574688,2.260541 44.574356,2.260047 44.574268,2.259378 44.574178,2.258333 44.574088,2.25789 44.574092,2.257602 44.574172,2.257193 44.574415,2.256894 44.574571,2.255747 44.575061,2.255458 44.575103,2.254871 44.575144,2.25459 44.575121,2.254221 44.575062,2.253209 44.574935,2.253025 44.575874,2.253028 44.576261,2.252978 44.57653,2.252549 44.576966,2.252381 44.577269,2.252334 44.577555,2.252343 44.577811,2.252395 44.578167,2.252499 44.578231,2.25309 44.578726,2.253488 44.579107,2.253571 44.579949,2.254126 44.582049,2.254095 44.5823,2.253942 44.582675,2.253934 44.583154,2.25397 44.583362,2.254129 44.583677,2.254479 44.584056,2.254523 44.584129,2.254501 44.58451,2.254593 44.5848,2.254733 44.584947,2.255355 44.585371,2.255144 44.585566,2.25504 44.585877,2.254952 44.586212,2.255022 44.58641,2.254839 44.587125,2.254848 44.587415,2.254772 44.58769,2.254662 44.587929,2.254473 44.588224,2.25444 44.588425,2.254675 44.589047,2.254735 44.589281,2.254839 44.589447,2.255023 44.589632,2.255124 44.589818,2.255096 44.590011,2.254696 44.59043,2.25461 44.590664,2.254632 44.590851,2.254706 44.591014,2.254807 44.591117,2.254707 44.591221,2.254325 44.591362,2.254008 44.591581,2.254029 44.591707,2.254275 44.591977,2.254597 44.592177,2.254614 44.592357,2.254224 44.592655,2.254147 44.592976,2.253982 44.593078,2.253659 44.593116,2.253494 44.593176,2.253155 44.59347,2.253012 44.593565,2.252825 44.593627,2.25254 44.593659,2.252358 44.593627,2.251839 44.59364,2.251586 44.593716,2.25121 44.594052,2.25099 44.594205,2.250733 44.594203,2.250547 44.594239,2.250377 44.59422,2.250269 44.594105,2.249696 44.593824,2.24951 44.594546,2.249127 44.595382,2.248665 44.596195,2.248258 44.596747,2.247929 44.597053,2.246951 44.597621,2.246546 44.597831,2.245933 44.598088,2.243999 44.598661,2.242796 44.598981,2.242243 44.599082,2.241654 44.599117,2.24015 44.599089,2.23944 44.599114,2.238609 44.599161,2.237161 44.599281,2.236385 44.599411,2.235733 44.599594,2.235191 44.599795,2.234602 44.600085,2.234096 44.600435,2.233576 44.600934,2.233095 44.601616,2.232543 44.602751,2.232043 44.603873,2.231908 44.604261,2.231841 44.604807,2.231916 44.605685,2.232039 44.606471,2.232109 44.606818,2.23226 44.607232,2.232971 44.608423,2.233297 44.608929,2.23364 44.609463,2.233991 44.609903,2.234391 44.610264,2.234894 44.610601,2.235282 44.610796,2.235774 44.610937,2.238341 44.611096,2.240235 44.611121,2.241892 44.611118,2.243657 44.611197,2.245508 44.611336,2.24738 44.611503,2.249303 44.611658,2.250485 44.611808,2.250661 44.611838,2.252238 44.612117,2.254025 44.612397,2.255088 44.612528,2.256324 44.612582,2.257235 44.612668,2.257979 44.612882,2.258596 44.613197,2.259369 44.613958,2.260412 44.615409,2.261427 44.617062,2.262045 44.617804,2.262728 44.618458,2.263768 44.619202,2.264814 44.619797,2.264969 44.619869)))"
    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"
]