Symfony Profiler

[
  "route" => "app_admin_stats"
  "route_parameters" => [
    "_route" => "app_admin_stats"
    "_controller" => "App\Controller\AdminController::stats"
    "insee_code" => "54396"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/admin/stats/54396"
  "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 => "54396"
  ]
  "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 => 27687
  ]
  "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":"54396","nom":"54396"}"
    3 => "2026-07-14 04:01:50"
    4 => null
    5 => null
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
    3 => Doctrine\DBAL\ParameterType {#588}
    4 => Doctrine\DBAL\ParameterType {#588}
    5 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM osm_object t0 WHERE t0.zone = ?"
  "params" => [
    1 => "54396"
  ]
  "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 => 27687
  ]
  "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 => "54396"
  ]
  "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 => "54396"
  ]
  "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 => "54396"
  ]
  "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(((6.918362 48.435465,6.918393 48.435329,6.918343 48.435239,6.918123 48.435091,6.917994 48.435043,6.917725 48.434785,6.917468 48.434714,6.917169 48.434458,6.91671 48.434235,6.916564 48.43392,6.916231 48.433608,6.915869 48.433338,6.915726 48.433262,6.915501 48.433206,6.914976 48.432574,6.914786 48.432327,6.914543 48.432294,6.914259 48.432117,6.91384 48.431821,6.913487 48.431527,6.913441 48.431309,6.913358 48.431206,6.913109 48.431059,6.912688 48.43089,6.912174 48.430804,6.911703 48.430766,6.911464 48.430773,6.910836 48.430728,6.910388 48.430866,6.909581 48.430646,6.909303 48.43051,6.908685 48.43034,6.908241 48.430066,6.907968 48.429975,6.907505 48.429655,6.907247 48.429419,6.907173 48.42915,6.906952 48.428852,6.906702 48.428684,6.90632 48.428535,6.905952 48.428436,6.905583 48.428296,6.905417 48.428159,6.90515 48.428107,6.905025 48.428041,6.904959 48.427603,6.90474 48.427345,6.904453 48.427232,6.904287 48.427105,6.904118 48.427075,6.903859 48.427115,6.90355 48.427275,6.903254 48.427358,6.902947 48.427367,6.902654 48.427313,6.902479 48.427233,6.902311 48.427104,6.902201 48.426862,6.902034 48.426408,6.902018 48.4262,6.902025 48.425751,6.901956 48.425075,6.901854 48.424666,6.901632 48.424488,6.901283 48.423979,6.90111 48.4238,6.900949 48.42373,6.900366 48.423792,6.899833 48.423831,6.899305 48.423831,6.898928 48.423791,6.898747 48.423734,6.898373 48.42354,6.897686 48.423132,6.897044 48.422878,6.896764 48.422695,6.896631 48.422482,6.896544 48.421975,6.896417 48.421741,6.896114 48.421565,6.895932 48.421249,6.895739 48.421,6.895215 48.42037,6.895084 48.42014,6.894741 48.419689,6.894308 48.419253,6.894193 48.419109,6.893822 48.41876,6.893339 48.418445,6.892796 48.418158,6.892176 48.417869,6.89169 48.417595,6.891465 48.417591,6.891327 48.417702,6.891051 48.418268,6.890891 48.418425,6.890575 48.418479,6.890415 48.418378,6.890569 48.41827,6.890587 48.418194,6.890469 48.418099,6.890243 48.41809,6.889742 48.418165,6.889457 48.418159,6.888909 48.418029,6.888661 48.418014,6.887996 48.418257,6.887693 48.418276,6.887364 48.418239,6.886975 48.418154,6.886664 48.418035,6.886292 48.417929,6.885568 48.41761,6.885398 48.41747,6.88526 48.417289,6.884985 48.417145,6.884554 48.417037,6.882965 48.417267,6.881611 48.416676,6.881099 48.416632,6.879704 48.416717,6.878618 48.416762,6.878038 48.416802,6.877726 48.41672,6.877937 48.418206,6.87815 48.418525,6.878443 48.419359,6.878615 48.419985,6.877705 48.420382,6.876615 48.420303,6.87608 48.420201,6.875711 48.420169,6.874026 48.420149,6.873458 48.420189,6.872678 48.420164,6.872139 48.419995,6.870725 48.420271,6.870282 48.420466,6.870273 48.420804,6.870241 48.421047,6.870169 48.42128,6.869979 48.42166,6.869816 48.421884,6.869622 48.42205,6.869297 48.42248,6.869121 48.422815,6.868968 48.423046,6.86878 48.42439,6.868676 48.424689,6.868431 48.425118,6.867886 48.425792,6.867621 48.426019,6.867456 48.426238,6.867287 48.426794,6.86692 48.427523,6.866424 48.428383,6.866342 48.428672,6.866367 48.429613,6.866324 48.430101,6.866101 48.430721,6.866058 48.431022,6.866077 48.431153,6.866345 48.431627,6.866582 48.432094,6.866741 48.432546,6.866703 48.432816,6.86659 48.433234,6.866584 48.433491,6.866655 48.433778,6.866653 48.433917,6.866265 48.434369,6.866021 48.434618,6.865503 48.43521,6.865134 48.435666,6.864944 48.435962,6.864883 48.436115,6.864696 48.436757,6.864419 48.436777,6.864327 48.436748,6.864061 48.436545,6.862943 48.435948,6.862674 48.435819,6.862459 48.435633,6.862297 48.435569,6.861756 48.435416,6.861292 48.435265,6.860972 48.435038,6.860148 48.434289,6.859908 48.43424,6.859618 48.434126,6.859033 48.433851,6.857732 48.433282,6.857618 48.433213,6.856971 48.432958,6.856538 48.432837,6.855943 48.432797,6.85537 48.43283,6.854969 48.432887,6.85482 48.432924,6.854335 48.433174,6.854149 48.433361,6.853761 48.434758,6.853708 48.434919,6.853584 48.43506,6.853314 48.435261,6.852754 48.435621,6.852345 48.435804,6.852072 48.435953,6.851831 48.436311,6.851422 48.436544,6.851152 48.436756,6.850883 48.437023,6.850182 48.437767,6.849862 48.437999,6.849662 48.438075,6.849397 48.438118,6.848651 48.438173,6.848362 48.438232,6.847685 48.438426,6.847444 48.438555,6.847276 48.43902,6.84717 48.439184,6.846163 48.439844,6.846587 48.440608,6.846634 48.440807,6.846542 48.441238,6.846382 48.441427,6.845587 48.441748,6.84532 48.442327,6.845955 48.443382,6.845988 48.443683,6.845516 48.444879,6.845329 48.44491,6.845144 48.444993,6.84389 48.445784,6.84326 48.44611,6.843121 48.446149,6.842984 48.446297,6.841815 48.447031,6.840681 48.447831,6.839305 48.448729,6.83811 48.449587,6.837792 48.449973,6.837235 48.450579,6.836777 48.45114,6.836633 48.45127,6.836346 48.451455,6.835975 48.451639,6.835712 48.451824,6.83552 48.452092,6.835421 48.452364,6.835321 48.452726,6.83505 48.453479,6.834947 48.453624,6.834813 48.453705,6.833598 48.454235,6.833189 48.454586,6.831712 48.455809,6.831185 48.456197,6.830017 48.456891,6.829414 48.457268,6.828695 48.457661,6.828249 48.457956,6.827404 48.458489,6.826627 48.458926,6.825939 48.459257,6.82559 48.459461,6.824911 48.459771,6.824559 48.460258,6.824184 48.46061,6.824035 48.460859,6.824078 48.461152,6.824374 48.461436,6.826968 48.463079,6.827017 48.46346,6.827662 48.463665,6.828176 48.463784,6.828618 48.463888,6.829364 48.464302,6.830588 48.46475,6.830943 48.464906,6.831353 48.46512,6.831729 48.465356,6.831959 48.465548,6.83208 48.465705,6.832127 48.465844,6.832139 48.466131,6.832115 48.466258,6.831994 48.466513,6.832043 48.466659,6.832376 48.466817,6.832481 48.466938,6.832436 48.467065,6.832501 48.467249,6.832308 48.467525,6.832506 48.4679,6.832412 48.468079,6.831876 48.468501,6.831875 48.468628,6.832058 48.468728,6.832249 48.468748,6.832556 48.468957,6.832549 48.469106,6.83239 48.469246,6.832053 48.469361,6.831923 48.469453,6.831901 48.469632,6.832007 48.469792,6.83156 48.469957,6.83133 48.470012,6.830804 48.470178,6.830239 48.470468,6.82997 48.470493,6.829872 48.470635,6.829943 48.471313,6.829645 48.471425,6.829297 48.471514,6.829076 48.471538,6.829235 48.471824,6.829037 48.471952,6.828782 48.472052,6.828677 48.472134,6.828494 48.472447,6.828132 48.472605,6.829008 48.473409,6.829529 48.473194,6.829774 48.473117,6.830301 48.473008,6.830937 48.472963,6.831537 48.472964,6.832285 48.472998,6.833579 48.472986,6.835122 48.472924,6.835601 48.472874,6.836281 48.472702,6.836932 48.472443,6.83737 48.472296,6.838131 48.472112,6.838923 48.47322,6.839568 48.473238,6.839466 48.473821,6.840045 48.473873,6.839233 48.475635,6.838675 48.475656,6.83723 48.478128,6.83887 48.478085,6.838463 48.479151,6.837776 48.479621,6.837564 48.47992,6.837982 48.479998,6.839522 48.480572,6.839928 48.480568,6.840824 48.481,6.84122 48.481041,6.841973 48.481198,6.842255 48.481279,6.842549 48.481428,6.843009 48.481435,6.843275 48.481476,6.843426 48.481551,6.843559 48.481755,6.843779 48.481867,6.843983 48.481901,6.844388 48.481922,6.844599 48.481878,6.84555 48.482239,6.845871 48.482284,6.847252 48.481807,6.851212 48.480021,6.851461 48.480549,6.851534 48.480799,6.85194 48.480794,6.852482 48.479635,6.853206 48.478683,6.853399 48.478491,6.853862 48.478547,6.854456 48.478366,6.854942 48.478126,6.855774 48.477165,6.856222 48.476537,6.857177 48.475466,6.857301 48.475424,6.858603 48.47405,6.859855 48.472303,6.860243 48.472081,6.860207 48.471729,6.860244 48.4714,6.860381 48.470984,6.860422 48.470783,6.860423 48.470555,6.860322 48.469589,6.860547 48.469446,6.861476 48.468724,6.862403 48.46803,6.863309 48.46728,6.863955 48.466783,6.866665 48.464809,6.866993 48.464501,6.869118 48.46263,6.869718 48.462142,6.871247 48.460682,6.873208 48.458816,6.87464 48.457612,6.878321 48.454285,6.880439 48.451937,6.880618 48.451952,6.881076 48.452081,6.881333 48.452112,6.881602 48.452106,6.881957 48.452039,6.882723 48.45186,6.883087 48.451829,6.883582 48.451819,6.883975 48.451835,6.884327 48.451875,6.885081 48.452027,6.885296 48.452048,6.885891 48.452065,6.886281 48.452056,6.886597 48.452219,6.886812 48.452263,6.88721 48.452252,6.887486 48.452184,6.888097 48.451921,6.888315 48.45188,6.888899 48.451836,6.889461 48.451743,6.890762 48.451754,6.891228 48.451665,6.891906 48.45147,6.892301 48.451398,6.892797 48.451353,6.893489 48.451318,6.893971 48.451263,6.894274 48.451151,6.894559 48.450921,6.89495 48.450777,6.895171 48.450742,6.895838 48.450737,6.89606 48.450701,6.896541 48.450541,6.89674 48.45044,6.897071 48.450179,6.89732 48.449872,6.897637 48.449563,6.897907 48.449371,6.898743 48.448859,6.899084 48.448547,6.899251 48.44836,6.899657 48.448029,6.899946 48.447893,6.900713 48.447736,6.90107 48.447642,6.901456 48.447472,6.902333 48.446955,6.90277 48.446668,6.903452 48.446274,6.903747 48.446156,6.904035 48.446071,6.904629 48.445937,6.905189 48.445825,6.905529 48.445721,6.905776 48.445581,6.906254 48.445168,6.906549 48.444866,6.906847 48.444529,6.906991 48.444399,6.907242 48.444268,6.907594 48.444174,6.908525 48.443809,6.908873 48.443595,6.909217 48.4433,6.909673 48.443065,6.910017 48.442928,6.91038 48.442826,6.910768 48.442753,6.911137 48.442743,6.911419 48.442678,6.911732 48.442473,6.91211 48.442005,6.912211 48.441913,6.912615 48.441688,6.912997 48.441571,6.913343 48.441439,6.913877 48.441572,6.914423 48.44158,6.915036 48.441564,6.917 48.440993,6.918215 48.440806,6.919927 48.440472,6.920087 48.439868,6.920618 48.439718,6.921011 48.439528,6.921413 48.439197,6.92126 48.439106,6.92067 48.438611,6.920389 48.438294,6.920238 48.438056,6.920071 48.437664,6.920012 48.436691,6.919958 48.436568,6.9198 48.436445,6.919593 48.436391,6.919381 48.436281,6.9192 48.43623,6.918973 48.436085,6.918679 48.43603,6.918321 48.435836,6.918267 48.435744,6.918362 48.435465)))"
    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(((6.918362 48.435465,6.918393 48.435329,6.918343 48.435239,6.918123 48.435091,6.917994 48.435043,6.917725 48.434785,6.917468 48.434714,6.917169 48.434458,6.91671 48.434235,6.916564 48.43392,6.916231 48.433608,6.915869 48.433338,6.915726 48.433262,6.915501 48.433206,6.914976 48.432574,6.914786 48.432327,6.914543 48.432294,6.914259 48.432117,6.91384 48.431821,6.913487 48.431527,6.913441 48.431309,6.913358 48.431206,6.913109 48.431059,6.912688 48.43089,6.912174 48.430804,6.911703 48.430766,6.911464 48.430773,6.910836 48.430728,6.910388 48.430866,6.909581 48.430646,6.909303 48.43051,6.908685 48.43034,6.908241 48.430066,6.907968 48.429975,6.907505 48.429655,6.907247 48.429419,6.907173 48.42915,6.906952 48.428852,6.906702 48.428684,6.90632 48.428535,6.905952 48.428436,6.905583 48.428296,6.905417 48.428159,6.90515 48.428107,6.905025 48.428041,6.904959 48.427603,6.90474 48.427345,6.904453 48.427232,6.904287 48.427105,6.904118 48.427075,6.903859 48.427115,6.90355 48.427275,6.903254 48.427358,6.902947 48.427367,6.902654 48.427313,6.902479 48.427233,6.902311 48.427104,6.902201 48.426862,6.902034 48.426408,6.902018 48.4262,6.902025 48.425751,6.901956 48.425075,6.901854 48.424666,6.901632 48.424488,6.901283 48.423979,6.90111 48.4238,6.900949 48.42373,6.900366 48.423792,6.899833 48.423831,6.899305 48.423831,6.898928 48.423791,6.898747 48.423734,6.898373 48.42354,6.897686 48.423132,6.897044 48.422878,6.896764 48.422695,6.896631 48.422482,6.896544 48.421975,6.896417 48.421741,6.896114 48.421565,6.895932 48.421249,6.895739 48.421,6.895215 48.42037,6.895084 48.42014,6.894741 48.419689,6.894308 48.419253,6.894193 48.419109,6.893822 48.41876,6.893339 48.418445,6.892796 48.418158,6.892176 48.417869,6.89169 48.417595,6.891465 48.417591,6.891327 48.417702,6.891051 48.418268,6.890891 48.418425,6.890575 48.418479,6.890415 48.418378,6.890569 48.41827,6.890587 48.418194,6.890469 48.418099,6.890243 48.41809,6.889742 48.418165,6.889457 48.418159,6.888909 48.418029,6.888661 48.418014,6.887996 48.418257,6.887693 48.418276,6.887364 48.418239,6.886975 48.418154,6.886664 48.418035,6.886292 48.417929,6.885568 48.41761,6.885398 48.41747,6.88526 48.417289,6.884985 48.417145,6.884554 48.417037,6.882965 48.417267,6.881611 48.416676,6.881099 48.416632,6.879704 48.416717,6.878618 48.416762,6.878038 48.416802,6.877726 48.41672,6.877937 48.418206,6.87815 48.418525,6.878443 48.419359,6.878615 48.419985,6.877705 48.420382,6.876615 48.420303,6.87608 48.420201,6.875711 48.420169,6.874026 48.420149,6.873458 48.420189,6.872678 48.420164,6.872139 48.419995,6.870725 48.420271,6.870282 48.420466,6.870273 48.420804,6.870241 48.421047,6.870169 48.42128,6.869979 48.42166,6.869816 48.421884,6.869622 48.42205,6.869297 48.42248,6.869121 48.422815,6.868968 48.423046,6.86878 48.42439,6.868676 48.424689,6.868431 48.425118,6.867886 48.425792,6.867621 48.426019,6.867456 48.426238,6.867287 48.426794,6.86692 48.427523,6.866424 48.428383,6.866342 48.428672,6.866367 48.429613,6.866324 48.430101,6.866101 48.430721,6.866058 48.431022,6.866077 48.431153,6.866345 48.431627,6.866582 48.432094,6.866741 48.432546,6.866703 48.432816,6.86659 48.433234,6.866584 48.433491,6.866655 48.433778,6.866653 48.433917,6.866265 48.434369,6.866021 48.434618,6.865503 48.43521,6.865134 48.435666,6.864944 48.435962,6.864883 48.436115,6.864696 48.436757,6.864419 48.436777,6.864327 48.436748,6.864061 48.436545,6.862943 48.435948,6.862674 48.435819,6.862459 48.435633,6.862297 48.435569,6.861756 48.435416,6.861292 48.435265,6.860972 48.435038,6.860148 48.434289,6.859908 48.43424,6.859618 48.434126,6.859033 48.433851,6.857732 48.433282,6.857618 48.433213,6.856971 48.432958,6.856538 48.432837,6.855943 48.432797,6.85537 48.43283,6.854969 48.432887,6.85482 48.432924,6.854335 48.433174,6.854149 48.433361,6.853761 48.434758,6.853708 48.434919,6.853584 48.43506,6.853314 48.435261,6.852754 48.435621,6.852345 48.435804,6.852072 48.435953,6.851831 48.436311,6.851422 48.436544,6.851152 48.436756,6.850883 48.437023,6.850182 48.437767,6.849862 48.437999,6.849662 48.438075,6.849397 48.438118,6.848651 48.438173,6.848362 48.438232,6.847685 48.438426,6.847444 48.438555,6.847276 48.43902,6.84717 48.439184,6.846163 48.439844,6.846587 48.440608,6.846634 48.440807,6.846542 48.441238,6.846382 48.441427,6.845587 48.441748,6.84532 48.442327,6.845955 48.443382,6.845988 48.443683,6.845516 48.444879,6.845329 48.44491,6.845144 48.444993,6.84389 48.445784,6.84326 48.44611,6.843121 48.446149,6.842984 48.446297,6.841815 48.447031,6.840681 48.447831,6.839305 48.448729,6.83811 48.449587,6.837792 48.449973,6.837235 48.450579,6.836777 48.45114,6.836633 48.45127,6.836346 48.451455,6.835975 48.451639,6.835712 48.451824,6.83552 48.452092,6.835421 48.452364,6.835321 48.452726,6.83505 48.453479,6.834947 48.453624,6.834813 48.453705,6.833598 48.454235,6.833189 48.454586,6.831712 48.455809,6.831185 48.456197,6.830017 48.456891,6.829414 48.457268,6.828695 48.457661,6.828249 48.457956,6.827404 48.458489,6.826627 48.458926,6.825939 48.459257,6.82559 48.459461,6.824911 48.459771,6.824559 48.460258,6.824184 48.46061,6.824035 48.460859,6.824078 48.461152,6.824374 48.461436,6.826968 48.463079,6.827017 48.46346,6.827662 48.463665,6.828176 48.463784,6.828618 48.463888,6.829364 48.464302,6.830588 48.46475,6.830943 48.464906,6.831353 48.46512,6.831729 48.465356,6.831959 48.465548,6.83208 48.465705,6.832127 48.465844,6.832139 48.466131,6.832115 48.466258,6.831994 48.466513,6.832043 48.466659,6.832376 48.466817,6.832481 48.466938,6.832436 48.467065,6.832501 48.467249,6.832308 48.467525,6.832506 48.4679,6.832412 48.468079,6.831876 48.468501,6.831875 48.468628,6.832058 48.468728,6.832249 48.468748,6.832556 48.468957,6.832549 48.469106,6.83239 48.469246,6.832053 48.469361,6.831923 48.469453,6.831901 48.469632,6.832007 48.469792,6.83156 48.469957,6.83133 48.470012,6.830804 48.470178,6.830239 48.470468,6.82997 48.470493,6.829872 48.470635,6.829943 48.471313,6.829645 48.471425,6.829297 48.471514,6.829076 48.471538,6.829235 48.471824,6.829037 48.471952,6.828782 48.472052,6.828677 48.472134,6.828494 48.472447,6.828132 48.472605,6.829008 48.473409,6.829529 48.473194,6.829774 48.473117,6.830301 48.473008,6.830937 48.472963,6.831537 48.472964,6.832285 48.472998,6.833579 48.472986,6.835122 48.472924,6.835601 48.472874,6.836281 48.472702,6.836932 48.472443,6.83737 48.472296,6.838131 48.472112,6.838923 48.47322,6.839568 48.473238,6.839466 48.473821,6.840045 48.473873,6.839233 48.475635,6.838675 48.475656,6.83723 48.478128,6.83887 48.478085,6.838463 48.479151,6.837776 48.479621,6.837564 48.47992,6.837982 48.479998,6.839522 48.480572,6.839928 48.480568,6.840824 48.481,6.84122 48.481041,6.841973 48.481198,6.842255 48.481279,6.842549 48.481428,6.843009 48.481435,6.843275 48.481476,6.843426 48.481551,6.843559 48.481755,6.843779 48.481867,6.843983 48.481901,6.844388 48.481922,6.844599 48.481878,6.84555 48.482239,6.845871 48.482284,6.847252 48.481807,6.851212 48.480021,6.851461 48.480549,6.851534 48.480799,6.85194 48.480794,6.852482 48.479635,6.853206 48.478683,6.853399 48.478491,6.853862 48.478547,6.854456 48.478366,6.854942 48.478126,6.855774 48.477165,6.856222 48.476537,6.857177 48.475466,6.857301 48.475424,6.858603 48.47405,6.859855 48.472303,6.860243 48.472081,6.860207 48.471729,6.860244 48.4714,6.860381 48.470984,6.860422 48.470783,6.860423 48.470555,6.860322 48.469589,6.860547 48.469446,6.861476 48.468724,6.862403 48.46803,6.863309 48.46728,6.863955 48.466783,6.866665 48.464809,6.866993 48.464501,6.869118 48.46263,6.869718 48.462142,6.871247 48.460682,6.873208 48.458816,6.87464 48.457612,6.878321 48.454285,6.880439 48.451937,6.880618 48.451952,6.881076 48.452081,6.881333 48.452112,6.881602 48.452106,6.881957 48.452039,6.882723 48.45186,6.883087 48.451829,6.883582 48.451819,6.883975 48.451835,6.884327 48.451875,6.885081 48.452027,6.885296 48.452048,6.885891 48.452065,6.886281 48.452056,6.886597 48.452219,6.886812 48.452263,6.88721 48.452252,6.887486 48.452184,6.888097 48.451921,6.888315 48.45188,6.888899 48.451836,6.889461 48.451743,6.890762 48.451754,6.891228 48.451665,6.891906 48.45147,6.892301 48.451398,6.892797 48.451353,6.893489 48.451318,6.893971 48.451263,6.894274 48.451151,6.894559 48.450921,6.89495 48.450777,6.895171 48.450742,6.895838 48.450737,6.89606 48.450701,6.896541 48.450541,6.89674 48.45044,6.897071 48.450179,6.89732 48.449872,6.897637 48.449563,6.897907 48.449371,6.898743 48.448859,6.899084 48.448547,6.899251 48.44836,6.899657 48.448029,6.899946 48.447893,6.900713 48.447736,6.90107 48.447642,6.901456 48.447472,6.902333 48.446955,6.90277 48.446668,6.903452 48.446274,6.903747 48.446156,6.904035 48.446071,6.904629 48.445937,6.905189 48.445825,6.905529 48.445721,6.905776 48.445581,6.906254 48.445168,6.906549 48.444866,6.906847 48.444529,6.906991 48.444399,6.907242 48.444268,6.907594 48.444174,6.908525 48.443809,6.908873 48.443595,6.909217 48.4433,6.909673 48.443065,6.910017 48.442928,6.91038 48.442826,6.910768 48.442753,6.911137 48.442743,6.911419 48.442678,6.911732 48.442473,6.91211 48.442005,6.912211 48.441913,6.912615 48.441688,6.912997 48.441571,6.913343 48.441439,6.913877 48.441572,6.914423 48.44158,6.915036 48.441564,6.917 48.440993,6.918215 48.440806,6.919927 48.440472,6.920087 48.439868,6.920618 48.439718,6.921011 48.439528,6.921413 48.439197,6.92126 48.439106,6.92067 48.438611,6.920389 48.438294,6.920238 48.438056,6.920071 48.437664,6.920012 48.436691,6.919958 48.436568,6.9198 48.436445,6.919593 48.436391,6.919381 48.436281,6.9192 48.43623,6.918973 48.436085,6.918679 48.43603,6.918321 48.435836,6.918267 48.435744,6.918362 48.435465)))"
  ]
  "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(((6.918362 48.435465,6.918393 48.435329,6.918343 48.435239,6.918123 48.435091,6.917994 48.435043,6.917725 48.434785,6.917468 48.434714,6.917169 48.434458,6.91671 48.434235,6.916564 48.43392,6.916231 48.433608,6.915869 48.433338,6.915726 48.433262,6.915501 48.433206,6.914976 48.432574,6.914786 48.432327,6.914543 48.432294,6.914259 48.432117,6.91384 48.431821,6.913487 48.431527,6.913441 48.431309,6.913358 48.431206,6.913109 48.431059,6.912688 48.43089,6.912174 48.430804,6.911703 48.430766,6.911464 48.430773,6.910836 48.430728,6.910388 48.430866,6.909581 48.430646,6.909303 48.43051,6.908685 48.43034,6.908241 48.430066,6.907968 48.429975,6.907505 48.429655,6.907247 48.429419,6.907173 48.42915,6.906952 48.428852,6.906702 48.428684,6.90632 48.428535,6.905952 48.428436,6.905583 48.428296,6.905417 48.428159,6.90515 48.428107,6.905025 48.428041,6.904959 48.427603,6.90474 48.427345,6.904453 48.427232,6.904287 48.427105,6.904118 48.427075,6.903859 48.427115,6.90355 48.427275,6.903254 48.427358,6.902947 48.427367,6.902654 48.427313,6.902479 48.427233,6.902311 48.427104,6.902201 48.426862,6.902034 48.426408,6.902018 48.4262,6.902025 48.425751,6.901956 48.425075,6.901854 48.424666,6.901632 48.424488,6.901283 48.423979,6.90111 48.4238,6.900949 48.42373,6.900366 48.423792,6.899833 48.423831,6.899305 48.423831,6.898928 48.423791,6.898747 48.423734,6.898373 48.42354,6.897686 48.423132,6.897044 48.422878,6.896764 48.422695,6.896631 48.422482,6.896544 48.421975,6.896417 48.421741,6.896114 48.421565,6.895932 48.421249,6.895739 48.421,6.895215 48.42037,6.895084 48.42014,6.894741 48.419689,6.894308 48.419253,6.894193 48.419109,6.893822 48.41876,6.893339 48.418445,6.892796 48.418158,6.892176 48.417869,6.89169 48.417595,6.891465 48.417591,6.891327 48.417702,6.891051 48.418268,6.890891 48.418425,6.890575 48.418479,6.890415 48.418378,6.890569 48.41827,6.890587 48.418194,6.890469 48.418099,6.890243 48.41809,6.889742 48.418165,6.889457 48.418159,6.888909 48.418029,6.888661 48.418014,6.887996 48.418257,6.887693 48.418276,6.887364 48.418239,6.886975 48.418154,6.886664 48.418035,6.886292 48.417929,6.885568 48.41761,6.885398 48.41747,6.88526 48.417289,6.884985 48.417145,6.884554 48.417037,6.882965 48.417267,6.881611 48.416676,6.881099 48.416632,6.879704 48.416717,6.878618 48.416762,6.878038 48.416802,6.877726 48.41672,6.877937 48.418206,6.87815 48.418525,6.878443 48.419359,6.878615 48.419985,6.877705 48.420382,6.876615 48.420303,6.87608 48.420201,6.875711 48.420169,6.874026 48.420149,6.873458 48.420189,6.872678 48.420164,6.872139 48.419995,6.870725 48.420271,6.870282 48.420466,6.870273 48.420804,6.870241 48.421047,6.870169 48.42128,6.869979 48.42166,6.869816 48.421884,6.869622 48.42205,6.869297 48.42248,6.869121 48.422815,6.868968 48.423046,6.86878 48.42439,6.868676 48.424689,6.868431 48.425118,6.867886 48.425792,6.867621 48.426019,6.867456 48.426238,6.867287 48.426794,6.86692 48.427523,6.866424 48.428383,6.866342 48.428672,6.866367 48.429613,6.866324 48.430101,6.866101 48.430721,6.866058 48.431022,6.866077 48.431153,6.866345 48.431627,6.866582 48.432094,6.866741 48.432546,6.866703 48.432816,6.86659 48.433234,6.866584 48.433491,6.866655 48.433778,6.866653 48.433917,6.866265 48.434369,6.866021 48.434618,6.865503 48.43521,6.865134 48.435666,6.864944 48.435962,6.864883 48.436115,6.864696 48.436757,6.864419 48.436777,6.864327 48.436748,6.864061 48.436545,6.862943 48.435948,6.862674 48.435819,6.862459 48.435633,6.862297 48.435569,6.861756 48.435416,6.861292 48.435265,6.860972 48.435038,6.860148 48.434289,6.859908 48.43424,6.859618 48.434126,6.859033 48.433851,6.857732 48.433282,6.857618 48.433213,6.856971 48.432958,6.856538 48.432837,6.855943 48.432797,6.85537 48.43283,6.854969 48.432887,6.85482 48.432924,6.854335 48.433174,6.854149 48.433361,6.853761 48.434758,6.853708 48.434919,6.853584 48.43506,6.853314 48.435261,6.852754 48.435621,6.852345 48.435804,6.852072 48.435953,6.851831 48.436311,6.851422 48.436544,6.851152 48.436756,6.850883 48.437023,6.850182 48.437767,6.849862 48.437999,6.849662 48.438075,6.849397 48.438118,6.848651 48.438173,6.848362 48.438232,6.847685 48.438426,6.847444 48.438555,6.847276 48.43902,6.84717 48.439184,6.846163 48.439844,6.846587 48.440608,6.846634 48.440807,6.846542 48.441238,6.846382 48.441427,6.845587 48.441748,6.84532 48.442327,6.845955 48.443382,6.845988 48.443683,6.845516 48.444879,6.845329 48.44491,6.845144 48.444993,6.84389 48.445784,6.84326 48.44611,6.843121 48.446149,6.842984 48.446297,6.841815 48.447031,6.840681 48.447831,6.839305 48.448729,6.83811 48.449587,6.837792 48.449973,6.837235 48.450579,6.836777 48.45114,6.836633 48.45127,6.836346 48.451455,6.835975 48.451639,6.835712 48.451824,6.83552 48.452092,6.835421 48.452364,6.835321 48.452726,6.83505 48.453479,6.834947 48.453624,6.834813 48.453705,6.833598 48.454235,6.833189 48.454586,6.831712 48.455809,6.831185 48.456197,6.830017 48.456891,6.829414 48.457268,6.828695 48.457661,6.828249 48.457956,6.827404 48.458489,6.826627 48.458926,6.825939 48.459257,6.82559 48.459461,6.824911 48.459771,6.824559 48.460258,6.824184 48.46061,6.824035 48.460859,6.824078 48.461152,6.824374 48.461436,6.826968 48.463079,6.827017 48.46346,6.827662 48.463665,6.828176 48.463784,6.828618 48.463888,6.829364 48.464302,6.830588 48.46475,6.830943 48.464906,6.831353 48.46512,6.831729 48.465356,6.831959 48.465548,6.83208 48.465705,6.832127 48.465844,6.832139 48.466131,6.832115 48.466258,6.831994 48.466513,6.832043 48.466659,6.832376 48.466817,6.832481 48.466938,6.832436 48.467065,6.832501 48.467249,6.832308 48.467525,6.832506 48.4679,6.832412 48.468079,6.831876 48.468501,6.831875 48.468628,6.832058 48.468728,6.832249 48.468748,6.832556 48.468957,6.832549 48.469106,6.83239 48.469246,6.832053 48.469361,6.831923 48.469453,6.831901 48.469632,6.832007 48.469792,6.83156 48.469957,6.83133 48.470012,6.830804 48.470178,6.830239 48.470468,6.82997 48.470493,6.829872 48.470635,6.829943 48.471313,6.829645 48.471425,6.829297 48.471514,6.829076 48.471538,6.829235 48.471824,6.829037 48.471952,6.828782 48.472052,6.828677 48.472134,6.828494 48.472447,6.828132 48.472605,6.829008 48.473409,6.829529 48.473194,6.829774 48.473117,6.830301 48.473008,6.830937 48.472963,6.831537 48.472964,6.832285 48.472998,6.833579 48.472986,6.835122 48.472924,6.835601 48.472874,6.836281 48.472702,6.836932 48.472443,6.83737 48.472296,6.838131 48.472112,6.838923 48.47322,6.839568 48.473238,6.839466 48.473821,6.840045 48.473873,6.839233 48.475635,6.838675 48.475656,6.83723 48.478128,6.83887 48.478085,6.838463 48.479151,6.837776 48.479621,6.837564 48.47992,6.837982 48.479998,6.839522 48.480572,6.839928 48.480568,6.840824 48.481,6.84122 48.481041,6.841973 48.481198,6.842255 48.481279,6.842549 48.481428,6.843009 48.481435,6.843275 48.481476,6.843426 48.481551,6.843559 48.481755,6.843779 48.481867,6.843983 48.481901,6.844388 48.481922,6.844599 48.481878,6.84555 48.482239,6.845871 48.482284,6.847252 48.481807,6.851212 48.480021,6.851461 48.480549,6.851534 48.480799,6.85194 48.480794,6.852482 48.479635,6.853206 48.478683,6.853399 48.478491,6.853862 48.478547,6.854456 48.478366,6.854942 48.478126,6.855774 48.477165,6.856222 48.476537,6.857177 48.475466,6.857301 48.475424,6.858603 48.47405,6.859855 48.472303,6.860243 48.472081,6.860207 48.471729,6.860244 48.4714,6.860381 48.470984,6.860422 48.470783,6.860423 48.470555,6.860322 48.469589,6.860547 48.469446,6.861476 48.468724,6.862403 48.46803,6.863309 48.46728,6.863955 48.466783,6.866665 48.464809,6.866993 48.464501,6.869118 48.46263,6.869718 48.462142,6.871247 48.460682,6.873208 48.458816,6.87464 48.457612,6.878321 48.454285,6.880439 48.451937,6.880618 48.451952,6.881076 48.452081,6.881333 48.452112,6.881602 48.452106,6.881957 48.452039,6.882723 48.45186,6.883087 48.451829,6.883582 48.451819,6.883975 48.451835,6.884327 48.451875,6.885081 48.452027,6.885296 48.452048,6.885891 48.452065,6.886281 48.452056,6.886597 48.452219,6.886812 48.452263,6.88721 48.452252,6.887486 48.452184,6.888097 48.451921,6.888315 48.45188,6.888899 48.451836,6.889461 48.451743,6.890762 48.451754,6.891228 48.451665,6.891906 48.45147,6.892301 48.451398,6.892797 48.451353,6.893489 48.451318,6.893971 48.451263,6.894274 48.451151,6.894559 48.450921,6.89495 48.450777,6.895171 48.450742,6.895838 48.450737,6.89606 48.450701,6.896541 48.450541,6.89674 48.45044,6.897071 48.450179,6.89732 48.449872,6.897637 48.449563,6.897907 48.449371,6.898743 48.448859,6.899084 48.448547,6.899251 48.44836,6.899657 48.448029,6.899946 48.447893,6.900713 48.447736,6.90107 48.447642,6.901456 48.447472,6.902333 48.446955,6.90277 48.446668,6.903452 48.446274,6.903747 48.446156,6.904035 48.446071,6.904629 48.445937,6.905189 48.445825,6.905529 48.445721,6.905776 48.445581,6.906254 48.445168,6.906549 48.444866,6.906847 48.444529,6.906991 48.444399,6.907242 48.444268,6.907594 48.444174,6.908525 48.443809,6.908873 48.443595,6.909217 48.4433,6.909673 48.443065,6.910017 48.442928,6.91038 48.442826,6.910768 48.442753,6.911137 48.442743,6.911419 48.442678,6.911732 48.442473,6.91211 48.442005,6.912211 48.441913,6.912615 48.441688,6.912997 48.441571,6.913343 48.441439,6.913877 48.441572,6.914423 48.44158,6.915036 48.441564,6.917 48.440993,6.918215 48.440806,6.919927 48.440472,6.920087 48.439868,6.920618 48.439718,6.921011 48.439528,6.921413 48.439197,6.92126 48.439106,6.92067 48.438611,6.920389 48.438294,6.920238 48.438056,6.920071 48.437664,6.920012 48.436691,6.919958 48.436568,6.9198 48.436445,6.919593 48.436391,6.919381 48.436281,6.9192 48.43623,6.918973 48.436085,6.918679 48.43603,6.918321 48.435836,6.918267 48.435744,6.918362 48.435465)))"
  ]
  "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(((6.918362 48.435465,6.918393 48.435329,6.918343 48.435239,6.918123 48.435091,6.917994 48.435043,6.917725 48.434785,6.917468 48.434714,6.917169 48.434458,6.91671 48.434235,6.916564 48.43392,6.916231 48.433608,6.915869 48.433338,6.915726 48.433262,6.915501 48.433206,6.914976 48.432574,6.914786 48.432327,6.914543 48.432294,6.914259 48.432117,6.91384 48.431821,6.913487 48.431527,6.913441 48.431309,6.913358 48.431206,6.913109 48.431059,6.912688 48.43089,6.912174 48.430804,6.911703 48.430766,6.911464 48.430773,6.910836 48.430728,6.910388 48.430866,6.909581 48.430646,6.909303 48.43051,6.908685 48.43034,6.908241 48.430066,6.907968 48.429975,6.907505 48.429655,6.907247 48.429419,6.907173 48.42915,6.906952 48.428852,6.906702 48.428684,6.90632 48.428535,6.905952 48.428436,6.905583 48.428296,6.905417 48.428159,6.90515 48.428107,6.905025 48.428041,6.904959 48.427603,6.90474 48.427345,6.904453 48.427232,6.904287 48.427105,6.904118 48.427075,6.903859 48.427115,6.90355 48.427275,6.903254 48.427358,6.902947 48.427367,6.902654 48.427313,6.902479 48.427233,6.902311 48.427104,6.902201 48.426862,6.902034 48.426408,6.902018 48.4262,6.902025 48.425751,6.901956 48.425075,6.901854 48.424666,6.901632 48.424488,6.901283 48.423979,6.90111 48.4238,6.900949 48.42373,6.900366 48.423792,6.899833 48.423831,6.899305 48.423831,6.898928 48.423791,6.898747 48.423734,6.898373 48.42354,6.897686 48.423132,6.897044 48.422878,6.896764 48.422695,6.896631 48.422482,6.896544 48.421975,6.896417 48.421741,6.896114 48.421565,6.895932 48.421249,6.895739 48.421,6.895215 48.42037,6.895084 48.42014,6.894741 48.419689,6.894308 48.419253,6.894193 48.419109,6.893822 48.41876,6.893339 48.418445,6.892796 48.418158,6.892176 48.417869,6.89169 48.417595,6.891465 48.417591,6.891327 48.417702,6.891051 48.418268,6.890891 48.418425,6.890575 48.418479,6.890415 48.418378,6.890569 48.41827,6.890587 48.418194,6.890469 48.418099,6.890243 48.41809,6.889742 48.418165,6.889457 48.418159,6.888909 48.418029,6.888661 48.418014,6.887996 48.418257,6.887693 48.418276,6.887364 48.418239,6.886975 48.418154,6.886664 48.418035,6.886292 48.417929,6.885568 48.41761,6.885398 48.41747,6.88526 48.417289,6.884985 48.417145,6.884554 48.417037,6.882965 48.417267,6.881611 48.416676,6.881099 48.416632,6.879704 48.416717,6.878618 48.416762,6.878038 48.416802,6.877726 48.41672,6.877937 48.418206,6.87815 48.418525,6.878443 48.419359,6.878615 48.419985,6.877705 48.420382,6.876615 48.420303,6.87608 48.420201,6.875711 48.420169,6.874026 48.420149,6.873458 48.420189,6.872678 48.420164,6.872139 48.419995,6.870725 48.420271,6.870282 48.420466,6.870273 48.420804,6.870241 48.421047,6.870169 48.42128,6.869979 48.42166,6.869816 48.421884,6.869622 48.42205,6.869297 48.42248,6.869121 48.422815,6.868968 48.423046,6.86878 48.42439,6.868676 48.424689,6.868431 48.425118,6.867886 48.425792,6.867621 48.426019,6.867456 48.426238,6.867287 48.426794,6.86692 48.427523,6.866424 48.428383,6.866342 48.428672,6.866367 48.429613,6.866324 48.430101,6.866101 48.430721,6.866058 48.431022,6.866077 48.431153,6.866345 48.431627,6.866582 48.432094,6.866741 48.432546,6.866703 48.432816,6.86659 48.433234,6.866584 48.433491,6.866655 48.433778,6.866653 48.433917,6.866265 48.434369,6.866021 48.434618,6.865503 48.43521,6.865134 48.435666,6.864944 48.435962,6.864883 48.436115,6.864696 48.436757,6.864419 48.436777,6.864327 48.436748,6.864061 48.436545,6.862943 48.435948,6.862674 48.435819,6.862459 48.435633,6.862297 48.435569,6.861756 48.435416,6.861292 48.435265,6.860972 48.435038,6.860148 48.434289,6.859908 48.43424,6.859618 48.434126,6.859033 48.433851,6.857732 48.433282,6.857618 48.433213,6.856971 48.432958,6.856538 48.432837,6.855943 48.432797,6.85537 48.43283,6.854969 48.432887,6.85482 48.432924,6.854335 48.433174,6.854149 48.433361,6.853761 48.434758,6.853708 48.434919,6.853584 48.43506,6.853314 48.435261,6.852754 48.435621,6.852345 48.435804,6.852072 48.435953,6.851831 48.436311,6.851422 48.436544,6.851152 48.436756,6.850883 48.437023,6.850182 48.437767,6.849862 48.437999,6.849662 48.438075,6.849397 48.438118,6.848651 48.438173,6.848362 48.438232,6.847685 48.438426,6.847444 48.438555,6.847276 48.43902,6.84717 48.439184,6.846163 48.439844,6.846587 48.440608,6.846634 48.440807,6.846542 48.441238,6.846382 48.441427,6.845587 48.441748,6.84532 48.442327,6.845955 48.443382,6.845988 48.443683,6.845516 48.444879,6.845329 48.44491,6.845144 48.444993,6.84389 48.445784,6.84326 48.44611,6.843121 48.446149,6.842984 48.446297,6.841815 48.447031,6.840681 48.447831,6.839305 48.448729,6.83811 48.449587,6.837792 48.449973,6.837235 48.450579,6.836777 48.45114,6.836633 48.45127,6.836346 48.451455,6.835975 48.451639,6.835712 48.451824,6.83552 48.452092,6.835421 48.452364,6.835321 48.452726,6.83505 48.453479,6.834947 48.453624,6.834813 48.453705,6.833598 48.454235,6.833189 48.454586,6.831712 48.455809,6.831185 48.456197,6.830017 48.456891,6.829414 48.457268,6.828695 48.457661,6.828249 48.457956,6.827404 48.458489,6.826627 48.458926,6.825939 48.459257,6.82559 48.459461,6.824911 48.459771,6.824559 48.460258,6.824184 48.46061,6.824035 48.460859,6.824078 48.461152,6.824374 48.461436,6.826968 48.463079,6.827017 48.46346,6.827662 48.463665,6.828176 48.463784,6.828618 48.463888,6.829364 48.464302,6.830588 48.46475,6.830943 48.464906,6.831353 48.46512,6.831729 48.465356,6.831959 48.465548,6.83208 48.465705,6.832127 48.465844,6.832139 48.466131,6.832115 48.466258,6.831994 48.466513,6.832043 48.466659,6.832376 48.466817,6.832481 48.466938,6.832436 48.467065,6.832501 48.467249,6.832308 48.467525,6.832506 48.4679,6.832412 48.468079,6.831876 48.468501,6.831875 48.468628,6.832058 48.468728,6.832249 48.468748,6.832556 48.468957,6.832549 48.469106,6.83239 48.469246,6.832053 48.469361,6.831923 48.469453,6.831901 48.469632,6.832007 48.469792,6.83156 48.469957,6.83133 48.470012,6.830804 48.470178,6.830239 48.470468,6.82997 48.470493,6.829872 48.470635,6.829943 48.471313,6.829645 48.471425,6.829297 48.471514,6.829076 48.471538,6.829235 48.471824,6.829037 48.471952,6.828782 48.472052,6.828677 48.472134,6.828494 48.472447,6.828132 48.472605,6.829008 48.473409,6.829529 48.473194,6.829774 48.473117,6.830301 48.473008,6.830937 48.472963,6.831537 48.472964,6.832285 48.472998,6.833579 48.472986,6.835122 48.472924,6.835601 48.472874,6.836281 48.472702,6.836932 48.472443,6.83737 48.472296,6.838131 48.472112,6.838923 48.47322,6.839568 48.473238,6.839466 48.473821,6.840045 48.473873,6.839233 48.475635,6.838675 48.475656,6.83723 48.478128,6.83887 48.478085,6.838463 48.479151,6.837776 48.479621,6.837564 48.47992,6.837982 48.479998,6.839522 48.480572,6.839928 48.480568,6.840824 48.481,6.84122 48.481041,6.841973 48.481198,6.842255 48.481279,6.842549 48.481428,6.843009 48.481435,6.843275 48.481476,6.843426 48.481551,6.843559 48.481755,6.843779 48.481867,6.843983 48.481901,6.844388 48.481922,6.844599 48.481878,6.84555 48.482239,6.845871 48.482284,6.847252 48.481807,6.851212 48.480021,6.851461 48.480549,6.851534 48.480799,6.85194 48.480794,6.852482 48.479635,6.853206 48.478683,6.853399 48.478491,6.853862 48.478547,6.854456 48.478366,6.854942 48.478126,6.855774 48.477165,6.856222 48.476537,6.857177 48.475466,6.857301 48.475424,6.858603 48.47405,6.859855 48.472303,6.860243 48.472081,6.860207 48.471729,6.860244 48.4714,6.860381 48.470984,6.860422 48.470783,6.860423 48.470555,6.860322 48.469589,6.860547 48.469446,6.861476 48.468724,6.862403 48.46803,6.863309 48.46728,6.863955 48.466783,6.866665 48.464809,6.866993 48.464501,6.869118 48.46263,6.869718 48.462142,6.871247 48.460682,6.873208 48.458816,6.87464 48.457612,6.878321 48.454285,6.880439 48.451937,6.880618 48.451952,6.881076 48.452081,6.881333 48.452112,6.881602 48.452106,6.881957 48.452039,6.882723 48.45186,6.883087 48.451829,6.883582 48.451819,6.883975 48.451835,6.884327 48.451875,6.885081 48.452027,6.885296 48.452048,6.885891 48.452065,6.886281 48.452056,6.886597 48.452219,6.886812 48.452263,6.88721 48.452252,6.887486 48.452184,6.888097 48.451921,6.888315 48.45188,6.888899 48.451836,6.889461 48.451743,6.890762 48.451754,6.891228 48.451665,6.891906 48.45147,6.892301 48.451398,6.892797 48.451353,6.893489 48.451318,6.893971 48.451263,6.894274 48.451151,6.894559 48.450921,6.89495 48.450777,6.895171 48.450742,6.895838 48.450737,6.89606 48.450701,6.896541 48.450541,6.89674 48.45044,6.897071 48.450179,6.89732 48.449872,6.897637 48.449563,6.897907 48.449371,6.898743 48.448859,6.899084 48.448547,6.899251 48.44836,6.899657 48.448029,6.899946 48.447893,6.900713 48.447736,6.90107 48.447642,6.901456 48.447472,6.902333 48.446955,6.90277 48.446668,6.903452 48.446274,6.903747 48.446156,6.904035 48.446071,6.904629 48.445937,6.905189 48.445825,6.905529 48.445721,6.905776 48.445581,6.906254 48.445168,6.906549 48.444866,6.906847 48.444529,6.906991 48.444399,6.907242 48.444268,6.907594 48.444174,6.908525 48.443809,6.908873 48.443595,6.909217 48.4433,6.909673 48.443065,6.910017 48.442928,6.91038 48.442826,6.910768 48.442753,6.911137 48.442743,6.911419 48.442678,6.911732 48.442473,6.91211 48.442005,6.912211 48.441913,6.912615 48.441688,6.912997 48.441571,6.913343 48.441439,6.913877 48.441572,6.914423 48.44158,6.915036 48.441564,6.917 48.440993,6.918215 48.440806,6.919927 48.440472,6.920087 48.439868,6.920618 48.439718,6.921011 48.439528,6.921413 48.439197,6.92126 48.439106,6.92067 48.438611,6.920389 48.438294,6.920238 48.438056,6.920071 48.437664,6.920012 48.436691,6.919958 48.436568,6.9198 48.436445,6.919593 48.436391,6.919381 48.436281,6.9192 48.43623,6.918973 48.436085,6.918679 48.43603,6.918321 48.435836,6.918267 48.435744,6.918362 48.435465)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

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

[
  "sql" => """
    SELECT osm_type, osm_id::text AS osm_id, ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,\n
                tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid\n
                FROM osm_object_meta m\n
                WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
                AND (\n
                  (tags->'shop') = 'vacant'\n
                  OR EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k LIKE 'was:%')\n
                )
    """
  "params" => [
    1 => "MULTIPOLYGON(((6.918362 48.435465,6.918393 48.435329,6.918343 48.435239,6.918123 48.435091,6.917994 48.435043,6.917725 48.434785,6.917468 48.434714,6.917169 48.434458,6.91671 48.434235,6.916564 48.43392,6.916231 48.433608,6.915869 48.433338,6.915726 48.433262,6.915501 48.433206,6.914976 48.432574,6.914786 48.432327,6.914543 48.432294,6.914259 48.432117,6.91384 48.431821,6.913487 48.431527,6.913441 48.431309,6.913358 48.431206,6.913109 48.431059,6.912688 48.43089,6.912174 48.430804,6.911703 48.430766,6.911464 48.430773,6.910836 48.430728,6.910388 48.430866,6.909581 48.430646,6.909303 48.43051,6.908685 48.43034,6.908241 48.430066,6.907968 48.429975,6.907505 48.429655,6.907247 48.429419,6.907173 48.42915,6.906952 48.428852,6.906702 48.428684,6.90632 48.428535,6.905952 48.428436,6.905583 48.428296,6.905417 48.428159,6.90515 48.428107,6.905025 48.428041,6.904959 48.427603,6.90474 48.427345,6.904453 48.427232,6.904287 48.427105,6.904118 48.427075,6.903859 48.427115,6.90355 48.427275,6.903254 48.427358,6.902947 48.427367,6.902654 48.427313,6.902479 48.427233,6.902311 48.427104,6.902201 48.426862,6.902034 48.426408,6.902018 48.4262,6.902025 48.425751,6.901956 48.425075,6.901854 48.424666,6.901632 48.424488,6.901283 48.423979,6.90111 48.4238,6.900949 48.42373,6.900366 48.423792,6.899833 48.423831,6.899305 48.423831,6.898928 48.423791,6.898747 48.423734,6.898373 48.42354,6.897686 48.423132,6.897044 48.422878,6.896764 48.422695,6.896631 48.422482,6.896544 48.421975,6.896417 48.421741,6.896114 48.421565,6.895932 48.421249,6.895739 48.421,6.895215 48.42037,6.895084 48.42014,6.894741 48.419689,6.894308 48.419253,6.894193 48.419109,6.893822 48.41876,6.893339 48.418445,6.892796 48.418158,6.892176 48.417869,6.89169 48.417595,6.891465 48.417591,6.891327 48.417702,6.891051 48.418268,6.890891 48.418425,6.890575 48.418479,6.890415 48.418378,6.890569 48.41827,6.890587 48.418194,6.890469 48.418099,6.890243 48.41809,6.889742 48.418165,6.889457 48.418159,6.888909 48.418029,6.888661 48.418014,6.887996 48.418257,6.887693 48.418276,6.887364 48.418239,6.886975 48.418154,6.886664 48.418035,6.886292 48.417929,6.885568 48.41761,6.885398 48.41747,6.88526 48.417289,6.884985 48.417145,6.884554 48.417037,6.882965 48.417267,6.881611 48.416676,6.881099 48.416632,6.879704 48.416717,6.878618 48.416762,6.878038 48.416802,6.877726 48.41672,6.877937 48.418206,6.87815 48.418525,6.878443 48.419359,6.878615 48.419985,6.877705 48.420382,6.876615 48.420303,6.87608 48.420201,6.875711 48.420169,6.874026 48.420149,6.873458 48.420189,6.872678 48.420164,6.872139 48.419995,6.870725 48.420271,6.870282 48.420466,6.870273 48.420804,6.870241 48.421047,6.870169 48.42128,6.869979 48.42166,6.869816 48.421884,6.869622 48.42205,6.869297 48.42248,6.869121 48.422815,6.868968 48.423046,6.86878 48.42439,6.868676 48.424689,6.868431 48.425118,6.867886 48.425792,6.867621 48.426019,6.867456 48.426238,6.867287 48.426794,6.86692 48.427523,6.866424 48.428383,6.866342 48.428672,6.866367 48.429613,6.866324 48.430101,6.866101 48.430721,6.866058 48.431022,6.866077 48.431153,6.866345 48.431627,6.866582 48.432094,6.866741 48.432546,6.866703 48.432816,6.86659 48.433234,6.866584 48.433491,6.866655 48.433778,6.866653 48.433917,6.866265 48.434369,6.866021 48.434618,6.865503 48.43521,6.865134 48.435666,6.864944 48.435962,6.864883 48.436115,6.864696 48.436757,6.864419 48.436777,6.864327 48.436748,6.864061 48.436545,6.862943 48.435948,6.862674 48.435819,6.862459 48.435633,6.862297 48.435569,6.861756 48.435416,6.861292 48.435265,6.860972 48.435038,6.860148 48.434289,6.859908 48.43424,6.859618 48.434126,6.859033 48.433851,6.857732 48.433282,6.857618 48.433213,6.856971 48.432958,6.856538 48.432837,6.855943 48.432797,6.85537 48.43283,6.854969 48.432887,6.85482 48.432924,6.854335 48.433174,6.854149 48.433361,6.853761 48.434758,6.853708 48.434919,6.853584 48.43506,6.853314 48.435261,6.852754 48.435621,6.852345 48.435804,6.852072 48.435953,6.851831 48.436311,6.851422 48.436544,6.851152 48.436756,6.850883 48.437023,6.850182 48.437767,6.849862 48.437999,6.849662 48.438075,6.849397 48.438118,6.848651 48.438173,6.848362 48.438232,6.847685 48.438426,6.847444 48.438555,6.847276 48.43902,6.84717 48.439184,6.846163 48.439844,6.846587 48.440608,6.846634 48.440807,6.846542 48.441238,6.846382 48.441427,6.845587 48.441748,6.84532 48.442327,6.845955 48.443382,6.845988 48.443683,6.845516 48.444879,6.845329 48.44491,6.845144 48.444993,6.84389 48.445784,6.84326 48.44611,6.843121 48.446149,6.842984 48.446297,6.841815 48.447031,6.840681 48.447831,6.839305 48.448729,6.83811 48.449587,6.837792 48.449973,6.837235 48.450579,6.836777 48.45114,6.836633 48.45127,6.836346 48.451455,6.835975 48.451639,6.835712 48.451824,6.83552 48.452092,6.835421 48.452364,6.835321 48.452726,6.83505 48.453479,6.834947 48.453624,6.834813 48.453705,6.833598 48.454235,6.833189 48.454586,6.831712 48.455809,6.831185 48.456197,6.830017 48.456891,6.829414 48.457268,6.828695 48.457661,6.828249 48.457956,6.827404 48.458489,6.826627 48.458926,6.825939 48.459257,6.82559 48.459461,6.824911 48.459771,6.824559 48.460258,6.824184 48.46061,6.824035 48.460859,6.824078 48.461152,6.824374 48.461436,6.826968 48.463079,6.827017 48.46346,6.827662 48.463665,6.828176 48.463784,6.828618 48.463888,6.829364 48.464302,6.830588 48.46475,6.830943 48.464906,6.831353 48.46512,6.831729 48.465356,6.831959 48.465548,6.83208 48.465705,6.832127 48.465844,6.832139 48.466131,6.832115 48.466258,6.831994 48.466513,6.832043 48.466659,6.832376 48.466817,6.832481 48.466938,6.832436 48.467065,6.832501 48.467249,6.832308 48.467525,6.832506 48.4679,6.832412 48.468079,6.831876 48.468501,6.831875 48.468628,6.832058 48.468728,6.832249 48.468748,6.832556 48.468957,6.832549 48.469106,6.83239 48.469246,6.832053 48.469361,6.831923 48.469453,6.831901 48.469632,6.832007 48.469792,6.83156 48.469957,6.83133 48.470012,6.830804 48.470178,6.830239 48.470468,6.82997 48.470493,6.829872 48.470635,6.829943 48.471313,6.829645 48.471425,6.829297 48.471514,6.829076 48.471538,6.829235 48.471824,6.829037 48.471952,6.828782 48.472052,6.828677 48.472134,6.828494 48.472447,6.828132 48.472605,6.829008 48.473409,6.829529 48.473194,6.829774 48.473117,6.830301 48.473008,6.830937 48.472963,6.831537 48.472964,6.832285 48.472998,6.833579 48.472986,6.835122 48.472924,6.835601 48.472874,6.836281 48.472702,6.836932 48.472443,6.83737 48.472296,6.838131 48.472112,6.838923 48.47322,6.839568 48.473238,6.839466 48.473821,6.840045 48.473873,6.839233 48.475635,6.838675 48.475656,6.83723 48.478128,6.83887 48.478085,6.838463 48.479151,6.837776 48.479621,6.837564 48.47992,6.837982 48.479998,6.839522 48.480572,6.839928 48.480568,6.840824 48.481,6.84122 48.481041,6.841973 48.481198,6.842255 48.481279,6.842549 48.481428,6.843009 48.481435,6.843275 48.481476,6.843426 48.481551,6.843559 48.481755,6.843779 48.481867,6.843983 48.481901,6.844388 48.481922,6.844599 48.481878,6.84555 48.482239,6.845871 48.482284,6.847252 48.481807,6.851212 48.480021,6.851461 48.480549,6.851534 48.480799,6.85194 48.480794,6.852482 48.479635,6.853206 48.478683,6.853399 48.478491,6.853862 48.478547,6.854456 48.478366,6.854942 48.478126,6.855774 48.477165,6.856222 48.476537,6.857177 48.475466,6.857301 48.475424,6.858603 48.47405,6.859855 48.472303,6.860243 48.472081,6.860207 48.471729,6.860244 48.4714,6.860381 48.470984,6.860422 48.470783,6.860423 48.470555,6.860322 48.469589,6.860547 48.469446,6.861476 48.468724,6.862403 48.46803,6.863309 48.46728,6.863955 48.466783,6.866665 48.464809,6.866993 48.464501,6.869118 48.46263,6.869718 48.462142,6.871247 48.460682,6.873208 48.458816,6.87464 48.457612,6.878321 48.454285,6.880439 48.451937,6.880618 48.451952,6.881076 48.452081,6.881333 48.452112,6.881602 48.452106,6.881957 48.452039,6.882723 48.45186,6.883087 48.451829,6.883582 48.451819,6.883975 48.451835,6.884327 48.451875,6.885081 48.452027,6.885296 48.452048,6.885891 48.452065,6.886281 48.452056,6.886597 48.452219,6.886812 48.452263,6.88721 48.452252,6.887486 48.452184,6.888097 48.451921,6.888315 48.45188,6.888899 48.451836,6.889461 48.451743,6.890762 48.451754,6.891228 48.451665,6.891906 48.45147,6.892301 48.451398,6.892797 48.451353,6.893489 48.451318,6.893971 48.451263,6.894274 48.451151,6.894559 48.450921,6.89495 48.450777,6.895171 48.450742,6.895838 48.450737,6.89606 48.450701,6.896541 48.450541,6.89674 48.45044,6.897071 48.450179,6.89732 48.449872,6.897637 48.449563,6.897907 48.449371,6.898743 48.448859,6.899084 48.448547,6.899251 48.44836,6.899657 48.448029,6.899946 48.447893,6.900713 48.447736,6.90107 48.447642,6.901456 48.447472,6.902333 48.446955,6.90277 48.446668,6.903452 48.446274,6.903747 48.446156,6.904035 48.446071,6.904629 48.445937,6.905189 48.445825,6.905529 48.445721,6.905776 48.445581,6.906254 48.445168,6.906549 48.444866,6.906847 48.444529,6.906991 48.444399,6.907242 48.444268,6.907594 48.444174,6.908525 48.443809,6.908873 48.443595,6.909217 48.4433,6.909673 48.443065,6.910017 48.442928,6.91038 48.442826,6.910768 48.442753,6.911137 48.442743,6.911419 48.442678,6.911732 48.442473,6.91211 48.442005,6.912211 48.441913,6.912615 48.441688,6.912997 48.441571,6.913343 48.441439,6.913877 48.441572,6.914423 48.44158,6.915036 48.441564,6.917 48.440993,6.918215 48.440806,6.919927 48.440472,6.920087 48.439868,6.920618 48.439718,6.921011 48.439528,6.921413 48.439197,6.92126 48.439106,6.92067 48.438611,6.920389 48.438294,6.920238 48.438056,6.920071 48.437664,6.920012 48.436691,6.919958 48.436568,6.9198 48.436445,6.919593 48.436391,6.919381 48.436281,6.9192 48.43623,6.918973 48.436085,6.918679 48.43603,6.918321 48.435836,6.918267 48.435744,6.918362 48.435465)))"
  ]
  "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 => 27687
  ]
  "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 => 27687
  ]
  "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(((6.918362 48.435465,6.918393 48.435329,6.918343 48.435239,6.918123 48.435091,6.917994 48.435043,6.917725 48.434785,6.917468 48.434714,6.917169 48.434458,6.91671 48.434235,6.916564 48.43392,6.916231 48.433608,6.915869 48.433338,6.915726 48.433262,6.915501 48.433206,6.914976 48.432574,6.914786 48.432327,6.914543 48.432294,6.914259 48.432117,6.91384 48.431821,6.913487 48.431527,6.913441 48.431309,6.913358 48.431206,6.913109 48.431059,6.912688 48.43089,6.912174 48.430804,6.911703 48.430766,6.911464 48.430773,6.910836 48.430728,6.910388 48.430866,6.909581 48.430646,6.909303 48.43051,6.908685 48.43034,6.908241 48.430066,6.907968 48.429975,6.907505 48.429655,6.907247 48.429419,6.907173 48.42915,6.906952 48.428852,6.906702 48.428684,6.90632 48.428535,6.905952 48.428436,6.905583 48.428296,6.905417 48.428159,6.90515 48.428107,6.905025 48.428041,6.904959 48.427603,6.90474 48.427345,6.904453 48.427232,6.904287 48.427105,6.904118 48.427075,6.903859 48.427115,6.90355 48.427275,6.903254 48.427358,6.902947 48.427367,6.902654 48.427313,6.902479 48.427233,6.902311 48.427104,6.902201 48.426862,6.902034 48.426408,6.902018 48.4262,6.902025 48.425751,6.901956 48.425075,6.901854 48.424666,6.901632 48.424488,6.901283 48.423979,6.90111 48.4238,6.900949 48.42373,6.900366 48.423792,6.899833 48.423831,6.899305 48.423831,6.898928 48.423791,6.898747 48.423734,6.898373 48.42354,6.897686 48.423132,6.897044 48.422878,6.896764 48.422695,6.896631 48.422482,6.896544 48.421975,6.896417 48.421741,6.896114 48.421565,6.895932 48.421249,6.895739 48.421,6.895215 48.42037,6.895084 48.42014,6.894741 48.419689,6.894308 48.419253,6.894193 48.419109,6.893822 48.41876,6.893339 48.418445,6.892796 48.418158,6.892176 48.417869,6.89169 48.417595,6.891465 48.417591,6.891327 48.417702,6.891051 48.418268,6.890891 48.418425,6.890575 48.418479,6.890415 48.418378,6.890569 48.41827,6.890587 48.418194,6.890469 48.418099,6.890243 48.41809,6.889742 48.418165,6.889457 48.418159,6.888909 48.418029,6.888661 48.418014,6.887996 48.418257,6.887693 48.418276,6.887364 48.418239,6.886975 48.418154,6.886664 48.418035,6.886292 48.417929,6.885568 48.41761,6.885398 48.41747,6.88526 48.417289,6.884985 48.417145,6.884554 48.417037,6.882965 48.417267,6.881611 48.416676,6.881099 48.416632,6.879704 48.416717,6.878618 48.416762,6.878038 48.416802,6.877726 48.41672,6.877937 48.418206,6.87815 48.418525,6.878443 48.419359,6.878615 48.419985,6.877705 48.420382,6.876615 48.420303,6.87608 48.420201,6.875711 48.420169,6.874026 48.420149,6.873458 48.420189,6.872678 48.420164,6.872139 48.419995,6.870725 48.420271,6.870282 48.420466,6.870273 48.420804,6.870241 48.421047,6.870169 48.42128,6.869979 48.42166,6.869816 48.421884,6.869622 48.42205,6.869297 48.42248,6.869121 48.422815,6.868968 48.423046,6.86878 48.42439,6.868676 48.424689,6.868431 48.425118,6.867886 48.425792,6.867621 48.426019,6.867456 48.426238,6.867287 48.426794,6.86692 48.427523,6.866424 48.428383,6.866342 48.428672,6.866367 48.429613,6.866324 48.430101,6.866101 48.430721,6.866058 48.431022,6.866077 48.431153,6.866345 48.431627,6.866582 48.432094,6.866741 48.432546,6.866703 48.432816,6.86659 48.433234,6.866584 48.433491,6.866655 48.433778,6.866653 48.433917,6.866265 48.434369,6.866021 48.434618,6.865503 48.43521,6.865134 48.435666,6.864944 48.435962,6.864883 48.436115,6.864696 48.436757,6.864419 48.436777,6.864327 48.436748,6.864061 48.436545,6.862943 48.435948,6.862674 48.435819,6.862459 48.435633,6.862297 48.435569,6.861756 48.435416,6.861292 48.435265,6.860972 48.435038,6.860148 48.434289,6.859908 48.43424,6.859618 48.434126,6.859033 48.433851,6.857732 48.433282,6.857618 48.433213,6.856971 48.432958,6.856538 48.432837,6.855943 48.432797,6.85537 48.43283,6.854969 48.432887,6.85482 48.432924,6.854335 48.433174,6.854149 48.433361,6.853761 48.434758,6.853708 48.434919,6.853584 48.43506,6.853314 48.435261,6.852754 48.435621,6.852345 48.435804,6.852072 48.435953,6.851831 48.436311,6.851422 48.436544,6.851152 48.436756,6.850883 48.437023,6.850182 48.437767,6.849862 48.437999,6.849662 48.438075,6.849397 48.438118,6.848651 48.438173,6.848362 48.438232,6.847685 48.438426,6.847444 48.438555,6.847276 48.43902,6.84717 48.439184,6.846163 48.439844,6.846587 48.440608,6.846634 48.440807,6.846542 48.441238,6.846382 48.441427,6.845587 48.441748,6.84532 48.442327,6.845955 48.443382,6.845988 48.443683,6.845516 48.444879,6.845329 48.44491,6.845144 48.444993,6.84389 48.445784,6.84326 48.44611,6.843121 48.446149,6.842984 48.446297,6.841815 48.447031,6.840681 48.447831,6.839305 48.448729,6.83811 48.449587,6.837792 48.449973,6.837235 48.450579,6.836777 48.45114,6.836633 48.45127,6.836346 48.451455,6.835975 48.451639,6.835712 48.451824,6.83552 48.452092,6.835421 48.452364,6.835321 48.452726,6.83505 48.453479,6.834947 48.453624,6.834813 48.453705,6.833598 48.454235,6.833189 48.454586,6.831712 48.455809,6.831185 48.456197,6.830017 48.456891,6.829414 48.457268,6.828695 48.457661,6.828249 48.457956,6.827404 48.458489,6.826627 48.458926,6.825939 48.459257,6.82559 48.459461,6.824911 48.459771,6.824559 48.460258,6.824184 48.46061,6.824035 48.460859,6.824078 48.461152,6.824374 48.461436,6.826968 48.463079,6.827017 48.46346,6.827662 48.463665,6.828176 48.463784,6.828618 48.463888,6.829364 48.464302,6.830588 48.46475,6.830943 48.464906,6.831353 48.46512,6.831729 48.465356,6.831959 48.465548,6.83208 48.465705,6.832127 48.465844,6.832139 48.466131,6.832115 48.466258,6.831994 48.466513,6.832043 48.466659,6.832376 48.466817,6.832481 48.466938,6.832436 48.467065,6.832501 48.467249,6.832308 48.467525,6.832506 48.4679,6.832412 48.468079,6.831876 48.468501,6.831875 48.468628,6.832058 48.468728,6.832249 48.468748,6.832556 48.468957,6.832549 48.469106,6.83239 48.469246,6.832053 48.469361,6.831923 48.469453,6.831901 48.469632,6.832007 48.469792,6.83156 48.469957,6.83133 48.470012,6.830804 48.470178,6.830239 48.470468,6.82997 48.470493,6.829872 48.470635,6.829943 48.471313,6.829645 48.471425,6.829297 48.471514,6.829076 48.471538,6.829235 48.471824,6.829037 48.471952,6.828782 48.472052,6.828677 48.472134,6.828494 48.472447,6.828132 48.472605,6.829008 48.473409,6.829529 48.473194,6.829774 48.473117,6.830301 48.473008,6.830937 48.472963,6.831537 48.472964,6.832285 48.472998,6.833579 48.472986,6.835122 48.472924,6.835601 48.472874,6.836281 48.472702,6.836932 48.472443,6.83737 48.472296,6.838131 48.472112,6.838923 48.47322,6.839568 48.473238,6.839466 48.473821,6.840045 48.473873,6.839233 48.475635,6.838675 48.475656,6.83723 48.478128,6.83887 48.478085,6.838463 48.479151,6.837776 48.479621,6.837564 48.47992,6.837982 48.479998,6.839522 48.480572,6.839928 48.480568,6.840824 48.481,6.84122 48.481041,6.841973 48.481198,6.842255 48.481279,6.842549 48.481428,6.843009 48.481435,6.843275 48.481476,6.843426 48.481551,6.843559 48.481755,6.843779 48.481867,6.843983 48.481901,6.844388 48.481922,6.844599 48.481878,6.84555 48.482239,6.845871 48.482284,6.847252 48.481807,6.851212 48.480021,6.851461 48.480549,6.851534 48.480799,6.85194 48.480794,6.852482 48.479635,6.853206 48.478683,6.853399 48.478491,6.853862 48.478547,6.854456 48.478366,6.854942 48.478126,6.855774 48.477165,6.856222 48.476537,6.857177 48.475466,6.857301 48.475424,6.858603 48.47405,6.859855 48.472303,6.860243 48.472081,6.860207 48.471729,6.860244 48.4714,6.860381 48.470984,6.860422 48.470783,6.860423 48.470555,6.860322 48.469589,6.860547 48.469446,6.861476 48.468724,6.862403 48.46803,6.863309 48.46728,6.863955 48.466783,6.866665 48.464809,6.866993 48.464501,6.869118 48.46263,6.869718 48.462142,6.871247 48.460682,6.873208 48.458816,6.87464 48.457612,6.878321 48.454285,6.880439 48.451937,6.880618 48.451952,6.881076 48.452081,6.881333 48.452112,6.881602 48.452106,6.881957 48.452039,6.882723 48.45186,6.883087 48.451829,6.883582 48.451819,6.883975 48.451835,6.884327 48.451875,6.885081 48.452027,6.885296 48.452048,6.885891 48.452065,6.886281 48.452056,6.886597 48.452219,6.886812 48.452263,6.88721 48.452252,6.887486 48.452184,6.888097 48.451921,6.888315 48.45188,6.888899 48.451836,6.889461 48.451743,6.890762 48.451754,6.891228 48.451665,6.891906 48.45147,6.892301 48.451398,6.892797 48.451353,6.893489 48.451318,6.893971 48.451263,6.894274 48.451151,6.894559 48.450921,6.89495 48.450777,6.895171 48.450742,6.895838 48.450737,6.89606 48.450701,6.896541 48.450541,6.89674 48.45044,6.897071 48.450179,6.89732 48.449872,6.897637 48.449563,6.897907 48.449371,6.898743 48.448859,6.899084 48.448547,6.899251 48.44836,6.899657 48.448029,6.899946 48.447893,6.900713 48.447736,6.90107 48.447642,6.901456 48.447472,6.902333 48.446955,6.90277 48.446668,6.903452 48.446274,6.903747 48.446156,6.904035 48.446071,6.904629 48.445937,6.905189 48.445825,6.905529 48.445721,6.905776 48.445581,6.906254 48.445168,6.906549 48.444866,6.906847 48.444529,6.906991 48.444399,6.907242 48.444268,6.907594 48.444174,6.908525 48.443809,6.908873 48.443595,6.909217 48.4433,6.909673 48.443065,6.910017 48.442928,6.91038 48.442826,6.910768 48.442753,6.911137 48.442743,6.911419 48.442678,6.911732 48.442473,6.91211 48.442005,6.912211 48.441913,6.912615 48.441688,6.912997 48.441571,6.913343 48.441439,6.913877 48.441572,6.914423 48.44158,6.915036 48.441564,6.917 48.440993,6.918215 48.440806,6.919927 48.440472,6.920087 48.439868,6.920618 48.439718,6.921011 48.439528,6.921413 48.439197,6.92126 48.439106,6.92067 48.438611,6.920389 48.438294,6.920238 48.438056,6.920071 48.437664,6.920012 48.436691,6.919958 48.436568,6.9198 48.436445,6.919593 48.436391,6.919381 48.436281,6.9192 48.43623,6.918973 48.436085,6.918679 48.43603,6.918321 48.435836,6.918267 48.435744,6.918362 48.435465)))"
    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(((6.918362 48.435465,6.918393 48.435329,6.918343 48.435239,6.918123 48.435091,6.917994 48.435043,6.917725 48.434785,6.917468 48.434714,6.917169 48.434458,6.91671 48.434235,6.916564 48.43392,6.916231 48.433608,6.915869 48.433338,6.915726 48.433262,6.915501 48.433206,6.914976 48.432574,6.914786 48.432327,6.914543 48.432294,6.914259 48.432117,6.91384 48.431821,6.913487 48.431527,6.913441 48.431309,6.913358 48.431206,6.913109 48.431059,6.912688 48.43089,6.912174 48.430804,6.911703 48.430766,6.911464 48.430773,6.910836 48.430728,6.910388 48.430866,6.909581 48.430646,6.909303 48.43051,6.908685 48.43034,6.908241 48.430066,6.907968 48.429975,6.907505 48.429655,6.907247 48.429419,6.907173 48.42915,6.906952 48.428852,6.906702 48.428684,6.90632 48.428535,6.905952 48.428436,6.905583 48.428296,6.905417 48.428159,6.90515 48.428107,6.905025 48.428041,6.904959 48.427603,6.90474 48.427345,6.904453 48.427232,6.904287 48.427105,6.904118 48.427075,6.903859 48.427115,6.90355 48.427275,6.903254 48.427358,6.902947 48.427367,6.902654 48.427313,6.902479 48.427233,6.902311 48.427104,6.902201 48.426862,6.902034 48.426408,6.902018 48.4262,6.902025 48.425751,6.901956 48.425075,6.901854 48.424666,6.901632 48.424488,6.901283 48.423979,6.90111 48.4238,6.900949 48.42373,6.900366 48.423792,6.899833 48.423831,6.899305 48.423831,6.898928 48.423791,6.898747 48.423734,6.898373 48.42354,6.897686 48.423132,6.897044 48.422878,6.896764 48.422695,6.896631 48.422482,6.896544 48.421975,6.896417 48.421741,6.896114 48.421565,6.895932 48.421249,6.895739 48.421,6.895215 48.42037,6.895084 48.42014,6.894741 48.419689,6.894308 48.419253,6.894193 48.419109,6.893822 48.41876,6.893339 48.418445,6.892796 48.418158,6.892176 48.417869,6.89169 48.417595,6.891465 48.417591,6.891327 48.417702,6.891051 48.418268,6.890891 48.418425,6.890575 48.418479,6.890415 48.418378,6.890569 48.41827,6.890587 48.418194,6.890469 48.418099,6.890243 48.41809,6.889742 48.418165,6.889457 48.418159,6.888909 48.418029,6.888661 48.418014,6.887996 48.418257,6.887693 48.418276,6.887364 48.418239,6.886975 48.418154,6.886664 48.418035,6.886292 48.417929,6.885568 48.41761,6.885398 48.41747,6.88526 48.417289,6.884985 48.417145,6.884554 48.417037,6.882965 48.417267,6.881611 48.416676,6.881099 48.416632,6.879704 48.416717,6.878618 48.416762,6.878038 48.416802,6.877726 48.41672,6.877937 48.418206,6.87815 48.418525,6.878443 48.419359,6.878615 48.419985,6.877705 48.420382,6.876615 48.420303,6.87608 48.420201,6.875711 48.420169,6.874026 48.420149,6.873458 48.420189,6.872678 48.420164,6.872139 48.419995,6.870725 48.420271,6.870282 48.420466,6.870273 48.420804,6.870241 48.421047,6.870169 48.42128,6.869979 48.42166,6.869816 48.421884,6.869622 48.42205,6.869297 48.42248,6.869121 48.422815,6.868968 48.423046,6.86878 48.42439,6.868676 48.424689,6.868431 48.425118,6.867886 48.425792,6.867621 48.426019,6.867456 48.426238,6.867287 48.426794,6.86692 48.427523,6.866424 48.428383,6.866342 48.428672,6.866367 48.429613,6.866324 48.430101,6.866101 48.430721,6.866058 48.431022,6.866077 48.431153,6.866345 48.431627,6.866582 48.432094,6.866741 48.432546,6.866703 48.432816,6.86659 48.433234,6.866584 48.433491,6.866655 48.433778,6.866653 48.433917,6.866265 48.434369,6.866021 48.434618,6.865503 48.43521,6.865134 48.435666,6.864944 48.435962,6.864883 48.436115,6.864696 48.436757,6.864419 48.436777,6.864327 48.436748,6.864061 48.436545,6.862943 48.435948,6.862674 48.435819,6.862459 48.435633,6.862297 48.435569,6.861756 48.435416,6.861292 48.435265,6.860972 48.435038,6.860148 48.434289,6.859908 48.43424,6.859618 48.434126,6.859033 48.433851,6.857732 48.433282,6.857618 48.433213,6.856971 48.432958,6.856538 48.432837,6.855943 48.432797,6.85537 48.43283,6.854969 48.432887,6.85482 48.432924,6.854335 48.433174,6.854149 48.433361,6.853761 48.434758,6.853708 48.434919,6.853584 48.43506,6.853314 48.435261,6.852754 48.435621,6.852345 48.435804,6.852072 48.435953,6.851831 48.436311,6.851422 48.436544,6.851152 48.436756,6.850883 48.437023,6.850182 48.437767,6.849862 48.437999,6.849662 48.438075,6.849397 48.438118,6.848651 48.438173,6.848362 48.438232,6.847685 48.438426,6.847444 48.438555,6.847276 48.43902,6.84717 48.439184,6.846163 48.439844,6.846587 48.440608,6.846634 48.440807,6.846542 48.441238,6.846382 48.441427,6.845587 48.441748,6.84532 48.442327,6.845955 48.443382,6.845988 48.443683,6.845516 48.444879,6.845329 48.44491,6.845144 48.444993,6.84389 48.445784,6.84326 48.44611,6.843121 48.446149,6.842984 48.446297,6.841815 48.447031,6.840681 48.447831,6.839305 48.448729,6.83811 48.449587,6.837792 48.449973,6.837235 48.450579,6.836777 48.45114,6.836633 48.45127,6.836346 48.451455,6.835975 48.451639,6.835712 48.451824,6.83552 48.452092,6.835421 48.452364,6.835321 48.452726,6.83505 48.453479,6.834947 48.453624,6.834813 48.453705,6.833598 48.454235,6.833189 48.454586,6.831712 48.455809,6.831185 48.456197,6.830017 48.456891,6.829414 48.457268,6.828695 48.457661,6.828249 48.457956,6.827404 48.458489,6.826627 48.458926,6.825939 48.459257,6.82559 48.459461,6.824911 48.459771,6.824559 48.460258,6.824184 48.46061,6.824035 48.460859,6.824078 48.461152,6.824374 48.461436,6.826968 48.463079,6.827017 48.46346,6.827662 48.463665,6.828176 48.463784,6.828618 48.463888,6.829364 48.464302,6.830588 48.46475,6.830943 48.464906,6.831353 48.46512,6.831729 48.465356,6.831959 48.465548,6.83208 48.465705,6.832127 48.465844,6.832139 48.466131,6.832115 48.466258,6.831994 48.466513,6.832043 48.466659,6.832376 48.466817,6.832481 48.466938,6.832436 48.467065,6.832501 48.467249,6.832308 48.467525,6.832506 48.4679,6.832412 48.468079,6.831876 48.468501,6.831875 48.468628,6.832058 48.468728,6.832249 48.468748,6.832556 48.468957,6.832549 48.469106,6.83239 48.469246,6.832053 48.469361,6.831923 48.469453,6.831901 48.469632,6.832007 48.469792,6.83156 48.469957,6.83133 48.470012,6.830804 48.470178,6.830239 48.470468,6.82997 48.470493,6.829872 48.470635,6.829943 48.471313,6.829645 48.471425,6.829297 48.471514,6.829076 48.471538,6.829235 48.471824,6.829037 48.471952,6.828782 48.472052,6.828677 48.472134,6.828494 48.472447,6.828132 48.472605,6.829008 48.473409,6.829529 48.473194,6.829774 48.473117,6.830301 48.473008,6.830937 48.472963,6.831537 48.472964,6.832285 48.472998,6.833579 48.472986,6.835122 48.472924,6.835601 48.472874,6.836281 48.472702,6.836932 48.472443,6.83737 48.472296,6.838131 48.472112,6.838923 48.47322,6.839568 48.473238,6.839466 48.473821,6.840045 48.473873,6.839233 48.475635,6.838675 48.475656,6.83723 48.478128,6.83887 48.478085,6.838463 48.479151,6.837776 48.479621,6.837564 48.47992,6.837982 48.479998,6.839522 48.480572,6.839928 48.480568,6.840824 48.481,6.84122 48.481041,6.841973 48.481198,6.842255 48.481279,6.842549 48.481428,6.843009 48.481435,6.843275 48.481476,6.843426 48.481551,6.843559 48.481755,6.843779 48.481867,6.843983 48.481901,6.844388 48.481922,6.844599 48.481878,6.84555 48.482239,6.845871 48.482284,6.847252 48.481807,6.851212 48.480021,6.851461 48.480549,6.851534 48.480799,6.85194 48.480794,6.852482 48.479635,6.853206 48.478683,6.853399 48.478491,6.853862 48.478547,6.854456 48.478366,6.854942 48.478126,6.855774 48.477165,6.856222 48.476537,6.857177 48.475466,6.857301 48.475424,6.858603 48.47405,6.859855 48.472303,6.860243 48.472081,6.860207 48.471729,6.860244 48.4714,6.860381 48.470984,6.860422 48.470783,6.860423 48.470555,6.860322 48.469589,6.860547 48.469446,6.861476 48.468724,6.862403 48.46803,6.863309 48.46728,6.863955 48.466783,6.866665 48.464809,6.866993 48.464501,6.869118 48.46263,6.869718 48.462142,6.871247 48.460682,6.873208 48.458816,6.87464 48.457612,6.878321 48.454285,6.880439 48.451937,6.880618 48.451952,6.881076 48.452081,6.881333 48.452112,6.881602 48.452106,6.881957 48.452039,6.882723 48.45186,6.883087 48.451829,6.883582 48.451819,6.883975 48.451835,6.884327 48.451875,6.885081 48.452027,6.885296 48.452048,6.885891 48.452065,6.886281 48.452056,6.886597 48.452219,6.886812 48.452263,6.88721 48.452252,6.887486 48.452184,6.888097 48.451921,6.888315 48.45188,6.888899 48.451836,6.889461 48.451743,6.890762 48.451754,6.891228 48.451665,6.891906 48.45147,6.892301 48.451398,6.892797 48.451353,6.893489 48.451318,6.893971 48.451263,6.894274 48.451151,6.894559 48.450921,6.89495 48.450777,6.895171 48.450742,6.895838 48.450737,6.89606 48.450701,6.896541 48.450541,6.89674 48.45044,6.897071 48.450179,6.89732 48.449872,6.897637 48.449563,6.897907 48.449371,6.898743 48.448859,6.899084 48.448547,6.899251 48.44836,6.899657 48.448029,6.899946 48.447893,6.900713 48.447736,6.90107 48.447642,6.901456 48.447472,6.902333 48.446955,6.90277 48.446668,6.903452 48.446274,6.903747 48.446156,6.904035 48.446071,6.904629 48.445937,6.905189 48.445825,6.905529 48.445721,6.905776 48.445581,6.906254 48.445168,6.906549 48.444866,6.906847 48.444529,6.906991 48.444399,6.907242 48.444268,6.907594 48.444174,6.908525 48.443809,6.908873 48.443595,6.909217 48.4433,6.909673 48.443065,6.910017 48.442928,6.91038 48.442826,6.910768 48.442753,6.911137 48.442743,6.911419 48.442678,6.911732 48.442473,6.91211 48.442005,6.912211 48.441913,6.912615 48.441688,6.912997 48.441571,6.913343 48.441439,6.913877 48.441572,6.914423 48.44158,6.915036 48.441564,6.917 48.440993,6.918215 48.440806,6.919927 48.440472,6.920087 48.439868,6.920618 48.439718,6.921011 48.439528,6.921413 48.439197,6.92126 48.439106,6.92067 48.438611,6.920389 48.438294,6.920238 48.438056,6.920071 48.437664,6.920012 48.436691,6.919958 48.436568,6.9198 48.436445,6.919593 48.436391,6.919381 48.436281,6.9192 48.43623,6.918973 48.436085,6.918679 48.43603,6.918321 48.435836,6.918267 48.435744,6.918362 48.435465)))"
  ]
  "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(((6.918362 48.435465,6.918393 48.435329,6.918343 48.435239,6.918123 48.435091,6.917994 48.435043,6.917725 48.434785,6.917468 48.434714,6.917169 48.434458,6.91671 48.434235,6.916564 48.43392,6.916231 48.433608,6.915869 48.433338,6.915726 48.433262,6.915501 48.433206,6.914976 48.432574,6.914786 48.432327,6.914543 48.432294,6.914259 48.432117,6.91384 48.431821,6.913487 48.431527,6.913441 48.431309,6.913358 48.431206,6.913109 48.431059,6.912688 48.43089,6.912174 48.430804,6.911703 48.430766,6.911464 48.430773,6.910836 48.430728,6.910388 48.430866,6.909581 48.430646,6.909303 48.43051,6.908685 48.43034,6.908241 48.430066,6.907968 48.429975,6.907505 48.429655,6.907247 48.429419,6.907173 48.42915,6.906952 48.428852,6.906702 48.428684,6.90632 48.428535,6.905952 48.428436,6.905583 48.428296,6.905417 48.428159,6.90515 48.428107,6.905025 48.428041,6.904959 48.427603,6.90474 48.427345,6.904453 48.427232,6.904287 48.427105,6.904118 48.427075,6.903859 48.427115,6.90355 48.427275,6.903254 48.427358,6.902947 48.427367,6.902654 48.427313,6.902479 48.427233,6.902311 48.427104,6.902201 48.426862,6.902034 48.426408,6.902018 48.4262,6.902025 48.425751,6.901956 48.425075,6.901854 48.424666,6.901632 48.424488,6.901283 48.423979,6.90111 48.4238,6.900949 48.42373,6.900366 48.423792,6.899833 48.423831,6.899305 48.423831,6.898928 48.423791,6.898747 48.423734,6.898373 48.42354,6.897686 48.423132,6.897044 48.422878,6.896764 48.422695,6.896631 48.422482,6.896544 48.421975,6.896417 48.421741,6.896114 48.421565,6.895932 48.421249,6.895739 48.421,6.895215 48.42037,6.895084 48.42014,6.894741 48.419689,6.894308 48.419253,6.894193 48.419109,6.893822 48.41876,6.893339 48.418445,6.892796 48.418158,6.892176 48.417869,6.89169 48.417595,6.891465 48.417591,6.891327 48.417702,6.891051 48.418268,6.890891 48.418425,6.890575 48.418479,6.890415 48.418378,6.890569 48.41827,6.890587 48.418194,6.890469 48.418099,6.890243 48.41809,6.889742 48.418165,6.889457 48.418159,6.888909 48.418029,6.888661 48.418014,6.887996 48.418257,6.887693 48.418276,6.887364 48.418239,6.886975 48.418154,6.886664 48.418035,6.886292 48.417929,6.885568 48.41761,6.885398 48.41747,6.88526 48.417289,6.884985 48.417145,6.884554 48.417037,6.882965 48.417267,6.881611 48.416676,6.881099 48.416632,6.879704 48.416717,6.878618 48.416762,6.878038 48.416802,6.877726 48.41672,6.877937 48.418206,6.87815 48.418525,6.878443 48.419359,6.878615 48.419985,6.877705 48.420382,6.876615 48.420303,6.87608 48.420201,6.875711 48.420169,6.874026 48.420149,6.873458 48.420189,6.872678 48.420164,6.872139 48.419995,6.870725 48.420271,6.870282 48.420466,6.870273 48.420804,6.870241 48.421047,6.870169 48.42128,6.869979 48.42166,6.869816 48.421884,6.869622 48.42205,6.869297 48.42248,6.869121 48.422815,6.868968 48.423046,6.86878 48.42439,6.868676 48.424689,6.868431 48.425118,6.867886 48.425792,6.867621 48.426019,6.867456 48.426238,6.867287 48.426794,6.86692 48.427523,6.866424 48.428383,6.866342 48.428672,6.866367 48.429613,6.866324 48.430101,6.866101 48.430721,6.866058 48.431022,6.866077 48.431153,6.866345 48.431627,6.866582 48.432094,6.866741 48.432546,6.866703 48.432816,6.86659 48.433234,6.866584 48.433491,6.866655 48.433778,6.866653 48.433917,6.866265 48.434369,6.866021 48.434618,6.865503 48.43521,6.865134 48.435666,6.864944 48.435962,6.864883 48.436115,6.864696 48.436757,6.864419 48.436777,6.864327 48.436748,6.864061 48.436545,6.862943 48.435948,6.862674 48.435819,6.862459 48.435633,6.862297 48.435569,6.861756 48.435416,6.861292 48.435265,6.860972 48.435038,6.860148 48.434289,6.859908 48.43424,6.859618 48.434126,6.859033 48.433851,6.857732 48.433282,6.857618 48.433213,6.856971 48.432958,6.856538 48.432837,6.855943 48.432797,6.85537 48.43283,6.854969 48.432887,6.85482 48.432924,6.854335 48.433174,6.854149 48.433361,6.853761 48.434758,6.853708 48.434919,6.853584 48.43506,6.853314 48.435261,6.852754 48.435621,6.852345 48.435804,6.852072 48.435953,6.851831 48.436311,6.851422 48.436544,6.851152 48.436756,6.850883 48.437023,6.850182 48.437767,6.849862 48.437999,6.849662 48.438075,6.849397 48.438118,6.848651 48.438173,6.848362 48.438232,6.847685 48.438426,6.847444 48.438555,6.847276 48.43902,6.84717 48.439184,6.846163 48.439844,6.846587 48.440608,6.846634 48.440807,6.846542 48.441238,6.846382 48.441427,6.845587 48.441748,6.84532 48.442327,6.845955 48.443382,6.845988 48.443683,6.845516 48.444879,6.845329 48.44491,6.845144 48.444993,6.84389 48.445784,6.84326 48.44611,6.843121 48.446149,6.842984 48.446297,6.841815 48.447031,6.840681 48.447831,6.839305 48.448729,6.83811 48.449587,6.837792 48.449973,6.837235 48.450579,6.836777 48.45114,6.836633 48.45127,6.836346 48.451455,6.835975 48.451639,6.835712 48.451824,6.83552 48.452092,6.835421 48.452364,6.835321 48.452726,6.83505 48.453479,6.834947 48.453624,6.834813 48.453705,6.833598 48.454235,6.833189 48.454586,6.831712 48.455809,6.831185 48.456197,6.830017 48.456891,6.829414 48.457268,6.828695 48.457661,6.828249 48.457956,6.827404 48.458489,6.826627 48.458926,6.825939 48.459257,6.82559 48.459461,6.824911 48.459771,6.824559 48.460258,6.824184 48.46061,6.824035 48.460859,6.824078 48.461152,6.824374 48.461436,6.826968 48.463079,6.827017 48.46346,6.827662 48.463665,6.828176 48.463784,6.828618 48.463888,6.829364 48.464302,6.830588 48.46475,6.830943 48.464906,6.831353 48.46512,6.831729 48.465356,6.831959 48.465548,6.83208 48.465705,6.832127 48.465844,6.832139 48.466131,6.832115 48.466258,6.831994 48.466513,6.832043 48.466659,6.832376 48.466817,6.832481 48.466938,6.832436 48.467065,6.832501 48.467249,6.832308 48.467525,6.832506 48.4679,6.832412 48.468079,6.831876 48.468501,6.831875 48.468628,6.832058 48.468728,6.832249 48.468748,6.832556 48.468957,6.832549 48.469106,6.83239 48.469246,6.832053 48.469361,6.831923 48.469453,6.831901 48.469632,6.832007 48.469792,6.83156 48.469957,6.83133 48.470012,6.830804 48.470178,6.830239 48.470468,6.82997 48.470493,6.829872 48.470635,6.829943 48.471313,6.829645 48.471425,6.829297 48.471514,6.829076 48.471538,6.829235 48.471824,6.829037 48.471952,6.828782 48.472052,6.828677 48.472134,6.828494 48.472447,6.828132 48.472605,6.829008 48.473409,6.829529 48.473194,6.829774 48.473117,6.830301 48.473008,6.830937 48.472963,6.831537 48.472964,6.832285 48.472998,6.833579 48.472986,6.835122 48.472924,6.835601 48.472874,6.836281 48.472702,6.836932 48.472443,6.83737 48.472296,6.838131 48.472112,6.838923 48.47322,6.839568 48.473238,6.839466 48.473821,6.840045 48.473873,6.839233 48.475635,6.838675 48.475656,6.83723 48.478128,6.83887 48.478085,6.838463 48.479151,6.837776 48.479621,6.837564 48.47992,6.837982 48.479998,6.839522 48.480572,6.839928 48.480568,6.840824 48.481,6.84122 48.481041,6.841973 48.481198,6.842255 48.481279,6.842549 48.481428,6.843009 48.481435,6.843275 48.481476,6.843426 48.481551,6.843559 48.481755,6.843779 48.481867,6.843983 48.481901,6.844388 48.481922,6.844599 48.481878,6.84555 48.482239,6.845871 48.482284,6.847252 48.481807,6.851212 48.480021,6.851461 48.480549,6.851534 48.480799,6.85194 48.480794,6.852482 48.479635,6.853206 48.478683,6.853399 48.478491,6.853862 48.478547,6.854456 48.478366,6.854942 48.478126,6.855774 48.477165,6.856222 48.476537,6.857177 48.475466,6.857301 48.475424,6.858603 48.47405,6.859855 48.472303,6.860243 48.472081,6.860207 48.471729,6.860244 48.4714,6.860381 48.470984,6.860422 48.470783,6.860423 48.470555,6.860322 48.469589,6.860547 48.469446,6.861476 48.468724,6.862403 48.46803,6.863309 48.46728,6.863955 48.466783,6.866665 48.464809,6.866993 48.464501,6.869118 48.46263,6.869718 48.462142,6.871247 48.460682,6.873208 48.458816,6.87464 48.457612,6.878321 48.454285,6.880439 48.451937,6.880618 48.451952,6.881076 48.452081,6.881333 48.452112,6.881602 48.452106,6.881957 48.452039,6.882723 48.45186,6.883087 48.451829,6.883582 48.451819,6.883975 48.451835,6.884327 48.451875,6.885081 48.452027,6.885296 48.452048,6.885891 48.452065,6.886281 48.452056,6.886597 48.452219,6.886812 48.452263,6.88721 48.452252,6.887486 48.452184,6.888097 48.451921,6.888315 48.45188,6.888899 48.451836,6.889461 48.451743,6.890762 48.451754,6.891228 48.451665,6.891906 48.45147,6.892301 48.451398,6.892797 48.451353,6.893489 48.451318,6.893971 48.451263,6.894274 48.451151,6.894559 48.450921,6.89495 48.450777,6.895171 48.450742,6.895838 48.450737,6.89606 48.450701,6.896541 48.450541,6.89674 48.45044,6.897071 48.450179,6.89732 48.449872,6.897637 48.449563,6.897907 48.449371,6.898743 48.448859,6.899084 48.448547,6.899251 48.44836,6.899657 48.448029,6.899946 48.447893,6.900713 48.447736,6.90107 48.447642,6.901456 48.447472,6.902333 48.446955,6.90277 48.446668,6.903452 48.446274,6.903747 48.446156,6.904035 48.446071,6.904629 48.445937,6.905189 48.445825,6.905529 48.445721,6.905776 48.445581,6.906254 48.445168,6.906549 48.444866,6.906847 48.444529,6.906991 48.444399,6.907242 48.444268,6.907594 48.444174,6.908525 48.443809,6.908873 48.443595,6.909217 48.4433,6.909673 48.443065,6.910017 48.442928,6.91038 48.442826,6.910768 48.442753,6.911137 48.442743,6.911419 48.442678,6.911732 48.442473,6.91211 48.442005,6.912211 48.441913,6.912615 48.441688,6.912997 48.441571,6.913343 48.441439,6.913877 48.441572,6.914423 48.44158,6.915036 48.441564,6.917 48.440993,6.918215 48.440806,6.919927 48.440472,6.920087 48.439868,6.920618 48.439718,6.921011 48.439528,6.921413 48.439197,6.92126 48.439106,6.92067 48.438611,6.920389 48.438294,6.920238 48.438056,6.920071 48.437664,6.920012 48.436691,6.919958 48.436568,6.9198 48.436445,6.919593 48.436391,6.919381 48.436281,6.9192 48.43623,6.918973 48.436085,6.918679 48.43603,6.918321 48.435836,6.918267 48.435744,6.918362 48.435465)))"
  ]
  "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(((6.918362 48.435465,6.918393 48.435329,6.918343 48.435239,6.918123 48.435091,6.917994 48.435043,6.917725 48.434785,6.917468 48.434714,6.917169 48.434458,6.91671 48.434235,6.916564 48.43392,6.916231 48.433608,6.915869 48.433338,6.915726 48.433262,6.915501 48.433206,6.914976 48.432574,6.914786 48.432327,6.914543 48.432294,6.914259 48.432117,6.91384 48.431821,6.913487 48.431527,6.913441 48.431309,6.913358 48.431206,6.913109 48.431059,6.912688 48.43089,6.912174 48.430804,6.911703 48.430766,6.911464 48.430773,6.910836 48.430728,6.910388 48.430866,6.909581 48.430646,6.909303 48.43051,6.908685 48.43034,6.908241 48.430066,6.907968 48.429975,6.907505 48.429655,6.907247 48.429419,6.907173 48.42915,6.906952 48.428852,6.906702 48.428684,6.90632 48.428535,6.905952 48.428436,6.905583 48.428296,6.905417 48.428159,6.90515 48.428107,6.905025 48.428041,6.904959 48.427603,6.90474 48.427345,6.904453 48.427232,6.904287 48.427105,6.904118 48.427075,6.903859 48.427115,6.90355 48.427275,6.903254 48.427358,6.902947 48.427367,6.902654 48.427313,6.902479 48.427233,6.902311 48.427104,6.902201 48.426862,6.902034 48.426408,6.902018 48.4262,6.902025 48.425751,6.901956 48.425075,6.901854 48.424666,6.901632 48.424488,6.901283 48.423979,6.90111 48.4238,6.900949 48.42373,6.900366 48.423792,6.899833 48.423831,6.899305 48.423831,6.898928 48.423791,6.898747 48.423734,6.898373 48.42354,6.897686 48.423132,6.897044 48.422878,6.896764 48.422695,6.896631 48.422482,6.896544 48.421975,6.896417 48.421741,6.896114 48.421565,6.895932 48.421249,6.895739 48.421,6.895215 48.42037,6.895084 48.42014,6.894741 48.419689,6.894308 48.419253,6.894193 48.419109,6.893822 48.41876,6.893339 48.418445,6.892796 48.418158,6.892176 48.417869,6.89169 48.417595,6.891465 48.417591,6.891327 48.417702,6.891051 48.418268,6.890891 48.418425,6.890575 48.418479,6.890415 48.418378,6.890569 48.41827,6.890587 48.418194,6.890469 48.418099,6.890243 48.41809,6.889742 48.418165,6.889457 48.418159,6.888909 48.418029,6.888661 48.418014,6.887996 48.418257,6.887693 48.418276,6.887364 48.418239,6.886975 48.418154,6.886664 48.418035,6.886292 48.417929,6.885568 48.41761,6.885398 48.41747,6.88526 48.417289,6.884985 48.417145,6.884554 48.417037,6.882965 48.417267,6.881611 48.416676,6.881099 48.416632,6.879704 48.416717,6.878618 48.416762,6.878038 48.416802,6.877726 48.41672,6.877937 48.418206,6.87815 48.418525,6.878443 48.419359,6.878615 48.419985,6.877705 48.420382,6.876615 48.420303,6.87608 48.420201,6.875711 48.420169,6.874026 48.420149,6.873458 48.420189,6.872678 48.420164,6.872139 48.419995,6.870725 48.420271,6.870282 48.420466,6.870273 48.420804,6.870241 48.421047,6.870169 48.42128,6.869979 48.42166,6.869816 48.421884,6.869622 48.42205,6.869297 48.42248,6.869121 48.422815,6.868968 48.423046,6.86878 48.42439,6.868676 48.424689,6.868431 48.425118,6.867886 48.425792,6.867621 48.426019,6.867456 48.426238,6.867287 48.426794,6.86692 48.427523,6.866424 48.428383,6.866342 48.428672,6.866367 48.429613,6.866324 48.430101,6.866101 48.430721,6.866058 48.431022,6.866077 48.431153,6.866345 48.431627,6.866582 48.432094,6.866741 48.432546,6.866703 48.432816,6.86659 48.433234,6.866584 48.433491,6.866655 48.433778,6.866653 48.433917,6.866265 48.434369,6.866021 48.434618,6.865503 48.43521,6.865134 48.435666,6.864944 48.435962,6.864883 48.436115,6.864696 48.436757,6.864419 48.436777,6.864327 48.436748,6.864061 48.436545,6.862943 48.435948,6.862674 48.435819,6.862459 48.435633,6.862297 48.435569,6.861756 48.435416,6.861292 48.435265,6.860972 48.435038,6.860148 48.434289,6.859908 48.43424,6.859618 48.434126,6.859033 48.433851,6.857732 48.433282,6.857618 48.433213,6.856971 48.432958,6.856538 48.432837,6.855943 48.432797,6.85537 48.43283,6.854969 48.432887,6.85482 48.432924,6.854335 48.433174,6.854149 48.433361,6.853761 48.434758,6.853708 48.434919,6.853584 48.43506,6.853314 48.435261,6.852754 48.435621,6.852345 48.435804,6.852072 48.435953,6.851831 48.436311,6.851422 48.436544,6.851152 48.436756,6.850883 48.437023,6.850182 48.437767,6.849862 48.437999,6.849662 48.438075,6.849397 48.438118,6.848651 48.438173,6.848362 48.438232,6.847685 48.438426,6.847444 48.438555,6.847276 48.43902,6.84717 48.439184,6.846163 48.439844,6.846587 48.440608,6.846634 48.440807,6.846542 48.441238,6.846382 48.441427,6.845587 48.441748,6.84532 48.442327,6.845955 48.443382,6.845988 48.443683,6.845516 48.444879,6.845329 48.44491,6.845144 48.444993,6.84389 48.445784,6.84326 48.44611,6.843121 48.446149,6.842984 48.446297,6.841815 48.447031,6.840681 48.447831,6.839305 48.448729,6.83811 48.449587,6.837792 48.449973,6.837235 48.450579,6.836777 48.45114,6.836633 48.45127,6.836346 48.451455,6.835975 48.451639,6.835712 48.451824,6.83552 48.452092,6.835421 48.452364,6.835321 48.452726,6.83505 48.453479,6.834947 48.453624,6.834813 48.453705,6.833598 48.454235,6.833189 48.454586,6.831712 48.455809,6.831185 48.456197,6.830017 48.456891,6.829414 48.457268,6.828695 48.457661,6.828249 48.457956,6.827404 48.458489,6.826627 48.458926,6.825939 48.459257,6.82559 48.459461,6.824911 48.459771,6.824559 48.460258,6.824184 48.46061,6.824035 48.460859,6.824078 48.461152,6.824374 48.461436,6.826968 48.463079,6.827017 48.46346,6.827662 48.463665,6.828176 48.463784,6.828618 48.463888,6.829364 48.464302,6.830588 48.46475,6.830943 48.464906,6.831353 48.46512,6.831729 48.465356,6.831959 48.465548,6.83208 48.465705,6.832127 48.465844,6.832139 48.466131,6.832115 48.466258,6.831994 48.466513,6.832043 48.466659,6.832376 48.466817,6.832481 48.466938,6.832436 48.467065,6.832501 48.467249,6.832308 48.467525,6.832506 48.4679,6.832412 48.468079,6.831876 48.468501,6.831875 48.468628,6.832058 48.468728,6.832249 48.468748,6.832556 48.468957,6.832549 48.469106,6.83239 48.469246,6.832053 48.469361,6.831923 48.469453,6.831901 48.469632,6.832007 48.469792,6.83156 48.469957,6.83133 48.470012,6.830804 48.470178,6.830239 48.470468,6.82997 48.470493,6.829872 48.470635,6.829943 48.471313,6.829645 48.471425,6.829297 48.471514,6.829076 48.471538,6.829235 48.471824,6.829037 48.471952,6.828782 48.472052,6.828677 48.472134,6.828494 48.472447,6.828132 48.472605,6.829008 48.473409,6.829529 48.473194,6.829774 48.473117,6.830301 48.473008,6.830937 48.472963,6.831537 48.472964,6.832285 48.472998,6.833579 48.472986,6.835122 48.472924,6.835601 48.472874,6.836281 48.472702,6.836932 48.472443,6.83737 48.472296,6.838131 48.472112,6.838923 48.47322,6.839568 48.473238,6.839466 48.473821,6.840045 48.473873,6.839233 48.475635,6.838675 48.475656,6.83723 48.478128,6.83887 48.478085,6.838463 48.479151,6.837776 48.479621,6.837564 48.47992,6.837982 48.479998,6.839522 48.480572,6.839928 48.480568,6.840824 48.481,6.84122 48.481041,6.841973 48.481198,6.842255 48.481279,6.842549 48.481428,6.843009 48.481435,6.843275 48.481476,6.843426 48.481551,6.843559 48.481755,6.843779 48.481867,6.843983 48.481901,6.844388 48.481922,6.844599 48.481878,6.84555 48.482239,6.845871 48.482284,6.847252 48.481807,6.851212 48.480021,6.851461 48.480549,6.851534 48.480799,6.85194 48.480794,6.852482 48.479635,6.853206 48.478683,6.853399 48.478491,6.853862 48.478547,6.854456 48.478366,6.854942 48.478126,6.855774 48.477165,6.856222 48.476537,6.857177 48.475466,6.857301 48.475424,6.858603 48.47405,6.859855 48.472303,6.860243 48.472081,6.860207 48.471729,6.860244 48.4714,6.860381 48.470984,6.860422 48.470783,6.860423 48.470555,6.860322 48.469589,6.860547 48.469446,6.861476 48.468724,6.862403 48.46803,6.863309 48.46728,6.863955 48.466783,6.866665 48.464809,6.866993 48.464501,6.869118 48.46263,6.869718 48.462142,6.871247 48.460682,6.873208 48.458816,6.87464 48.457612,6.878321 48.454285,6.880439 48.451937,6.880618 48.451952,6.881076 48.452081,6.881333 48.452112,6.881602 48.452106,6.881957 48.452039,6.882723 48.45186,6.883087 48.451829,6.883582 48.451819,6.883975 48.451835,6.884327 48.451875,6.885081 48.452027,6.885296 48.452048,6.885891 48.452065,6.886281 48.452056,6.886597 48.452219,6.886812 48.452263,6.88721 48.452252,6.887486 48.452184,6.888097 48.451921,6.888315 48.45188,6.888899 48.451836,6.889461 48.451743,6.890762 48.451754,6.891228 48.451665,6.891906 48.45147,6.892301 48.451398,6.892797 48.451353,6.893489 48.451318,6.893971 48.451263,6.894274 48.451151,6.894559 48.450921,6.89495 48.450777,6.895171 48.450742,6.895838 48.450737,6.89606 48.450701,6.896541 48.450541,6.89674 48.45044,6.897071 48.450179,6.89732 48.449872,6.897637 48.449563,6.897907 48.449371,6.898743 48.448859,6.899084 48.448547,6.899251 48.44836,6.899657 48.448029,6.899946 48.447893,6.900713 48.447736,6.90107 48.447642,6.901456 48.447472,6.902333 48.446955,6.90277 48.446668,6.903452 48.446274,6.903747 48.446156,6.904035 48.446071,6.904629 48.445937,6.905189 48.445825,6.905529 48.445721,6.905776 48.445581,6.906254 48.445168,6.906549 48.444866,6.906847 48.444529,6.906991 48.444399,6.907242 48.444268,6.907594 48.444174,6.908525 48.443809,6.908873 48.443595,6.909217 48.4433,6.909673 48.443065,6.910017 48.442928,6.91038 48.442826,6.910768 48.442753,6.911137 48.442743,6.911419 48.442678,6.911732 48.442473,6.91211 48.442005,6.912211 48.441913,6.912615 48.441688,6.912997 48.441571,6.913343 48.441439,6.913877 48.441572,6.914423 48.44158,6.915036 48.441564,6.917 48.440993,6.918215 48.440806,6.919927 48.440472,6.920087 48.439868,6.920618 48.439718,6.921011 48.439528,6.921413 48.439197,6.92126 48.439106,6.92067 48.438611,6.920389 48.438294,6.920238 48.438056,6.920071 48.437664,6.920012 48.436691,6.919958 48.436568,6.9198 48.436445,6.919593 48.436391,6.919381 48.436281,6.9192 48.43623,6.918973 48.436085,6.918679 48.43603,6.918321 48.435836,6.918267 48.435744,6.918362 48.435465)))"
    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"
]