Symfony Profiler

[
  "route" => "app_admin_stats"
  "route_parameters" => [
    "_route" => "app_admin_stats"
    "_controller" => "App\Controller\AdminController::stats"
    "insee_code" => "27275"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/admin/stats/27275"
  "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 => "27275"
  ]
  "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 => 26852
  ]
  "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":"27275","nom":"27275"}"
    3 => "2026-07-14 02:55:35"
    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 => "27275"
  ]
  "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 => 26852
  ]
  "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 => "27275"
  ]
  "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 => "27275"
  ]
  "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 => "27275"
  ]
  "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(((1.368845 49.175414,1.36963 49.175264,1.370139 49.17515,1.371044 49.174909,1.372113 49.174598,1.373181 49.174163,1.374133 49.173637,1.374877 49.173259,1.375519 49.172946,1.376217 49.172578,1.376775 49.172311,1.377359 49.171993,1.377875 49.171768,1.378651 49.171337,1.381054 49.170387,1.384048 49.169718,1.387141 49.169534,1.388021 49.169273,1.389293 49.168988,1.390389 49.168721,1.391001 49.16853,1.39029 49.167987,1.389818 49.167533,1.388212 49.166059,1.387772 49.165632,1.387278 49.165212,1.387152 49.165085,1.387103 49.16494,1.386809 49.164516,1.386189 49.163805,1.385258 49.162922,1.384892 49.162411,1.384652 49.162019,1.38434 49.161635,1.384106 49.161277,1.38286 49.159509,1.382218 49.158544,1.381755 49.157917,1.381576 49.157644,1.380493 49.156122,1.380316 49.155839,1.380202 49.155738,1.379422 49.154903,1.379099 49.154505,1.378817 49.15396,1.37852 49.153538,1.378126 49.152914,1.377587 49.152159,1.377449 49.152067,1.377359 49.151876,1.376856 49.151211,1.376735 49.151071,1.375442 49.151366,1.372297 49.152071,1.371261 49.152309,1.369564 49.152687,1.366286 49.153426,1.364409 49.153846,1.363567 49.154029,1.360058 49.154824,1.357567 49.155379,1.357323 49.154881,1.356589 49.153577,1.356549 49.153402,1.356144 49.152725,1.356085 49.152603,1.356182 49.15244,1.355966 49.151904,1.356038 49.151702,1.356016 49.151548,1.355767 49.151448,1.355428 49.151347,1.355074 49.15127,1.354895 49.151268,1.354464 49.151337,1.35292 49.151644,1.35253 49.151666,1.352236 49.151639,1.351481 49.151502,1.351476 49.151428,1.351199 49.150668,1.35078 49.149314,1.349836 49.149415,1.34887 49.149535,1.348949 49.149782,1.347374 49.149773,1.346027 49.149759,1.345204 49.149717,1.344439 49.150147,1.34144 49.151661,1.341492 49.151853,1.340441 49.152128,1.340148 49.151784,1.339106 49.152378,1.339239 49.15262,1.338555 49.152614,1.337437 49.152394,1.336307 49.151073,1.335763 49.151328,1.335574 49.150927,1.334479 49.151317,1.335271 49.152557,1.335235 49.152852,1.335188 49.154153,1.334247 49.154096,1.333879 49.154098,1.333542 49.154064,1.332914 49.153839,1.332672 49.153779,1.331796 49.153694,1.33066 49.15364,1.330572 49.153588,1.330164 49.153537,1.329566 49.153429,1.329078 49.153326,1.328711 49.153222,1.32833 49.153016,1.328006 49.15274,1.327622 49.152345,1.327457 49.152087,1.327264 49.151636,1.327053 49.151302,1.326873 49.150915,1.326762 49.150798,1.326193 49.150469,1.325931 49.150334,1.32548 49.150196,1.325304 49.150112,1.324611 49.149908,1.324084 49.149827,1.323347 49.149667,1.32295 49.149548,1.322635 49.149427,1.322064 49.149072,1.321632 49.148689,1.32089 49.148233,1.319988 49.147242,1.319381 49.14662,1.31914 49.146511,1.31764 49.146139,1.316414 49.145814,1.315117 49.145578,1.313337 49.145608,1.312243 49.145464,1.311426 49.145232,1.311019 49.145049,1.310745 49.145001,1.310677 49.145046,1.304638 49.148457,1.304113 49.148724,1.303097 49.148018,1.301788 49.14712,1.301218 49.14728,1.300893 49.147363,1.300177 49.147503,1.29941 49.147625,1.298282 49.147748,1.297824 49.14787,1.297323 49.148153,1.297137 49.148308,1.296461 49.14881,1.29607 49.149026,1.293735 49.15012,1.293584 49.150389,1.292343 49.150484,1.291885 49.150726,1.29073 49.15129,1.289955 49.151721,1.290789 49.151892,1.291399 49.151958,1.291742 49.152097,1.292648 49.152493,1.293813 49.152988,1.29406 49.153104,1.294192 49.153262,1.294473 49.153411,1.295199 49.153743,1.295561 49.153872,1.29605 49.154011,1.296564 49.154232,1.296809 49.154431,1.29735 49.1547,1.297913 49.155097,1.298734 49.155556,1.299566 49.15596,1.301155 49.154669,1.303293 49.15552,1.303575 49.155606,1.304224 49.154902,1.304409 49.155029,1.306086 49.155635,1.306216 49.155698,1.308109 49.155918,1.310105 49.156306,1.311446 49.156598,1.311201 49.156926,1.312366 49.15747,1.312268 49.157584,1.313367 49.15815,1.314029 49.157439,1.31424 49.157501,1.314753 49.157605,1.315119 49.15771,1.315349 49.157744,1.315988 49.157746,1.316234 49.157768,1.316912 49.157892,1.316353 49.158582,1.317369 49.159098,1.317708 49.159638,1.318339 49.160167,1.3178 49.16064,1.318547 49.160908,1.318645 49.160961,1.319027 49.161037,1.319679 49.161075,1.320901 49.16107,1.321454 49.162542,1.32276 49.163422,1.322504 49.163565,1.321525 49.163963,1.321195 49.164068,1.32134 49.16429,1.322007 49.164134,1.322223 49.164489,1.323668 49.163998,1.323973 49.164252,1.324935 49.163891,1.325222 49.164164,1.325308 49.164086,1.325899 49.164529,1.328099 49.164622,1.329421 49.164683,1.330229 49.164737,1.330262 49.164573,1.330428 49.163464,1.338363 49.164169,1.338273 49.164834,1.338429 49.164919,1.339155 49.165422,1.33939 49.165481,1.341899 49.16565,1.342393 49.165705,1.342854 49.165785,1.34434 49.166136,1.345505 49.16639,1.347387 49.166769,1.347673 49.166974,1.347877 49.167229,1.348456 49.168009,1.349167 49.168986,1.349692 49.169804,1.350333 49.169466,1.35057 49.16938,1.351159 49.169224,1.351442 49.169169,1.356339 49.168128,1.358005 49.167682,1.359761 49.167218,1.360408 49.167041,1.361355 49.168288,1.361684 49.168735,1.362287 49.168708,1.363044 49.169556,1.365965 49.172393,1.366846 49.172118,1.367592 49.172891,1.368845 49.175414)))"
    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(((1.368845 49.175414,1.36963 49.175264,1.370139 49.17515,1.371044 49.174909,1.372113 49.174598,1.373181 49.174163,1.374133 49.173637,1.374877 49.173259,1.375519 49.172946,1.376217 49.172578,1.376775 49.172311,1.377359 49.171993,1.377875 49.171768,1.378651 49.171337,1.381054 49.170387,1.384048 49.169718,1.387141 49.169534,1.388021 49.169273,1.389293 49.168988,1.390389 49.168721,1.391001 49.16853,1.39029 49.167987,1.389818 49.167533,1.388212 49.166059,1.387772 49.165632,1.387278 49.165212,1.387152 49.165085,1.387103 49.16494,1.386809 49.164516,1.386189 49.163805,1.385258 49.162922,1.384892 49.162411,1.384652 49.162019,1.38434 49.161635,1.384106 49.161277,1.38286 49.159509,1.382218 49.158544,1.381755 49.157917,1.381576 49.157644,1.380493 49.156122,1.380316 49.155839,1.380202 49.155738,1.379422 49.154903,1.379099 49.154505,1.378817 49.15396,1.37852 49.153538,1.378126 49.152914,1.377587 49.152159,1.377449 49.152067,1.377359 49.151876,1.376856 49.151211,1.376735 49.151071,1.375442 49.151366,1.372297 49.152071,1.371261 49.152309,1.369564 49.152687,1.366286 49.153426,1.364409 49.153846,1.363567 49.154029,1.360058 49.154824,1.357567 49.155379,1.357323 49.154881,1.356589 49.153577,1.356549 49.153402,1.356144 49.152725,1.356085 49.152603,1.356182 49.15244,1.355966 49.151904,1.356038 49.151702,1.356016 49.151548,1.355767 49.151448,1.355428 49.151347,1.355074 49.15127,1.354895 49.151268,1.354464 49.151337,1.35292 49.151644,1.35253 49.151666,1.352236 49.151639,1.351481 49.151502,1.351476 49.151428,1.351199 49.150668,1.35078 49.149314,1.349836 49.149415,1.34887 49.149535,1.348949 49.149782,1.347374 49.149773,1.346027 49.149759,1.345204 49.149717,1.344439 49.150147,1.34144 49.151661,1.341492 49.151853,1.340441 49.152128,1.340148 49.151784,1.339106 49.152378,1.339239 49.15262,1.338555 49.152614,1.337437 49.152394,1.336307 49.151073,1.335763 49.151328,1.335574 49.150927,1.334479 49.151317,1.335271 49.152557,1.335235 49.152852,1.335188 49.154153,1.334247 49.154096,1.333879 49.154098,1.333542 49.154064,1.332914 49.153839,1.332672 49.153779,1.331796 49.153694,1.33066 49.15364,1.330572 49.153588,1.330164 49.153537,1.329566 49.153429,1.329078 49.153326,1.328711 49.153222,1.32833 49.153016,1.328006 49.15274,1.327622 49.152345,1.327457 49.152087,1.327264 49.151636,1.327053 49.151302,1.326873 49.150915,1.326762 49.150798,1.326193 49.150469,1.325931 49.150334,1.32548 49.150196,1.325304 49.150112,1.324611 49.149908,1.324084 49.149827,1.323347 49.149667,1.32295 49.149548,1.322635 49.149427,1.322064 49.149072,1.321632 49.148689,1.32089 49.148233,1.319988 49.147242,1.319381 49.14662,1.31914 49.146511,1.31764 49.146139,1.316414 49.145814,1.315117 49.145578,1.313337 49.145608,1.312243 49.145464,1.311426 49.145232,1.311019 49.145049,1.310745 49.145001,1.310677 49.145046,1.304638 49.148457,1.304113 49.148724,1.303097 49.148018,1.301788 49.14712,1.301218 49.14728,1.300893 49.147363,1.300177 49.147503,1.29941 49.147625,1.298282 49.147748,1.297824 49.14787,1.297323 49.148153,1.297137 49.148308,1.296461 49.14881,1.29607 49.149026,1.293735 49.15012,1.293584 49.150389,1.292343 49.150484,1.291885 49.150726,1.29073 49.15129,1.289955 49.151721,1.290789 49.151892,1.291399 49.151958,1.291742 49.152097,1.292648 49.152493,1.293813 49.152988,1.29406 49.153104,1.294192 49.153262,1.294473 49.153411,1.295199 49.153743,1.295561 49.153872,1.29605 49.154011,1.296564 49.154232,1.296809 49.154431,1.29735 49.1547,1.297913 49.155097,1.298734 49.155556,1.299566 49.15596,1.301155 49.154669,1.303293 49.15552,1.303575 49.155606,1.304224 49.154902,1.304409 49.155029,1.306086 49.155635,1.306216 49.155698,1.308109 49.155918,1.310105 49.156306,1.311446 49.156598,1.311201 49.156926,1.312366 49.15747,1.312268 49.157584,1.313367 49.15815,1.314029 49.157439,1.31424 49.157501,1.314753 49.157605,1.315119 49.15771,1.315349 49.157744,1.315988 49.157746,1.316234 49.157768,1.316912 49.157892,1.316353 49.158582,1.317369 49.159098,1.317708 49.159638,1.318339 49.160167,1.3178 49.16064,1.318547 49.160908,1.318645 49.160961,1.319027 49.161037,1.319679 49.161075,1.320901 49.16107,1.321454 49.162542,1.32276 49.163422,1.322504 49.163565,1.321525 49.163963,1.321195 49.164068,1.32134 49.16429,1.322007 49.164134,1.322223 49.164489,1.323668 49.163998,1.323973 49.164252,1.324935 49.163891,1.325222 49.164164,1.325308 49.164086,1.325899 49.164529,1.328099 49.164622,1.329421 49.164683,1.330229 49.164737,1.330262 49.164573,1.330428 49.163464,1.338363 49.164169,1.338273 49.164834,1.338429 49.164919,1.339155 49.165422,1.33939 49.165481,1.341899 49.16565,1.342393 49.165705,1.342854 49.165785,1.34434 49.166136,1.345505 49.16639,1.347387 49.166769,1.347673 49.166974,1.347877 49.167229,1.348456 49.168009,1.349167 49.168986,1.349692 49.169804,1.350333 49.169466,1.35057 49.16938,1.351159 49.169224,1.351442 49.169169,1.356339 49.168128,1.358005 49.167682,1.359761 49.167218,1.360408 49.167041,1.361355 49.168288,1.361684 49.168735,1.362287 49.168708,1.363044 49.169556,1.365965 49.172393,1.366846 49.172118,1.367592 49.172891,1.368845 49.175414)))"
  ]
  "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(((1.368845 49.175414,1.36963 49.175264,1.370139 49.17515,1.371044 49.174909,1.372113 49.174598,1.373181 49.174163,1.374133 49.173637,1.374877 49.173259,1.375519 49.172946,1.376217 49.172578,1.376775 49.172311,1.377359 49.171993,1.377875 49.171768,1.378651 49.171337,1.381054 49.170387,1.384048 49.169718,1.387141 49.169534,1.388021 49.169273,1.389293 49.168988,1.390389 49.168721,1.391001 49.16853,1.39029 49.167987,1.389818 49.167533,1.388212 49.166059,1.387772 49.165632,1.387278 49.165212,1.387152 49.165085,1.387103 49.16494,1.386809 49.164516,1.386189 49.163805,1.385258 49.162922,1.384892 49.162411,1.384652 49.162019,1.38434 49.161635,1.384106 49.161277,1.38286 49.159509,1.382218 49.158544,1.381755 49.157917,1.381576 49.157644,1.380493 49.156122,1.380316 49.155839,1.380202 49.155738,1.379422 49.154903,1.379099 49.154505,1.378817 49.15396,1.37852 49.153538,1.378126 49.152914,1.377587 49.152159,1.377449 49.152067,1.377359 49.151876,1.376856 49.151211,1.376735 49.151071,1.375442 49.151366,1.372297 49.152071,1.371261 49.152309,1.369564 49.152687,1.366286 49.153426,1.364409 49.153846,1.363567 49.154029,1.360058 49.154824,1.357567 49.155379,1.357323 49.154881,1.356589 49.153577,1.356549 49.153402,1.356144 49.152725,1.356085 49.152603,1.356182 49.15244,1.355966 49.151904,1.356038 49.151702,1.356016 49.151548,1.355767 49.151448,1.355428 49.151347,1.355074 49.15127,1.354895 49.151268,1.354464 49.151337,1.35292 49.151644,1.35253 49.151666,1.352236 49.151639,1.351481 49.151502,1.351476 49.151428,1.351199 49.150668,1.35078 49.149314,1.349836 49.149415,1.34887 49.149535,1.348949 49.149782,1.347374 49.149773,1.346027 49.149759,1.345204 49.149717,1.344439 49.150147,1.34144 49.151661,1.341492 49.151853,1.340441 49.152128,1.340148 49.151784,1.339106 49.152378,1.339239 49.15262,1.338555 49.152614,1.337437 49.152394,1.336307 49.151073,1.335763 49.151328,1.335574 49.150927,1.334479 49.151317,1.335271 49.152557,1.335235 49.152852,1.335188 49.154153,1.334247 49.154096,1.333879 49.154098,1.333542 49.154064,1.332914 49.153839,1.332672 49.153779,1.331796 49.153694,1.33066 49.15364,1.330572 49.153588,1.330164 49.153537,1.329566 49.153429,1.329078 49.153326,1.328711 49.153222,1.32833 49.153016,1.328006 49.15274,1.327622 49.152345,1.327457 49.152087,1.327264 49.151636,1.327053 49.151302,1.326873 49.150915,1.326762 49.150798,1.326193 49.150469,1.325931 49.150334,1.32548 49.150196,1.325304 49.150112,1.324611 49.149908,1.324084 49.149827,1.323347 49.149667,1.32295 49.149548,1.322635 49.149427,1.322064 49.149072,1.321632 49.148689,1.32089 49.148233,1.319988 49.147242,1.319381 49.14662,1.31914 49.146511,1.31764 49.146139,1.316414 49.145814,1.315117 49.145578,1.313337 49.145608,1.312243 49.145464,1.311426 49.145232,1.311019 49.145049,1.310745 49.145001,1.310677 49.145046,1.304638 49.148457,1.304113 49.148724,1.303097 49.148018,1.301788 49.14712,1.301218 49.14728,1.300893 49.147363,1.300177 49.147503,1.29941 49.147625,1.298282 49.147748,1.297824 49.14787,1.297323 49.148153,1.297137 49.148308,1.296461 49.14881,1.29607 49.149026,1.293735 49.15012,1.293584 49.150389,1.292343 49.150484,1.291885 49.150726,1.29073 49.15129,1.289955 49.151721,1.290789 49.151892,1.291399 49.151958,1.291742 49.152097,1.292648 49.152493,1.293813 49.152988,1.29406 49.153104,1.294192 49.153262,1.294473 49.153411,1.295199 49.153743,1.295561 49.153872,1.29605 49.154011,1.296564 49.154232,1.296809 49.154431,1.29735 49.1547,1.297913 49.155097,1.298734 49.155556,1.299566 49.15596,1.301155 49.154669,1.303293 49.15552,1.303575 49.155606,1.304224 49.154902,1.304409 49.155029,1.306086 49.155635,1.306216 49.155698,1.308109 49.155918,1.310105 49.156306,1.311446 49.156598,1.311201 49.156926,1.312366 49.15747,1.312268 49.157584,1.313367 49.15815,1.314029 49.157439,1.31424 49.157501,1.314753 49.157605,1.315119 49.15771,1.315349 49.157744,1.315988 49.157746,1.316234 49.157768,1.316912 49.157892,1.316353 49.158582,1.317369 49.159098,1.317708 49.159638,1.318339 49.160167,1.3178 49.16064,1.318547 49.160908,1.318645 49.160961,1.319027 49.161037,1.319679 49.161075,1.320901 49.16107,1.321454 49.162542,1.32276 49.163422,1.322504 49.163565,1.321525 49.163963,1.321195 49.164068,1.32134 49.16429,1.322007 49.164134,1.322223 49.164489,1.323668 49.163998,1.323973 49.164252,1.324935 49.163891,1.325222 49.164164,1.325308 49.164086,1.325899 49.164529,1.328099 49.164622,1.329421 49.164683,1.330229 49.164737,1.330262 49.164573,1.330428 49.163464,1.338363 49.164169,1.338273 49.164834,1.338429 49.164919,1.339155 49.165422,1.33939 49.165481,1.341899 49.16565,1.342393 49.165705,1.342854 49.165785,1.34434 49.166136,1.345505 49.16639,1.347387 49.166769,1.347673 49.166974,1.347877 49.167229,1.348456 49.168009,1.349167 49.168986,1.349692 49.169804,1.350333 49.169466,1.35057 49.16938,1.351159 49.169224,1.351442 49.169169,1.356339 49.168128,1.358005 49.167682,1.359761 49.167218,1.360408 49.167041,1.361355 49.168288,1.361684 49.168735,1.362287 49.168708,1.363044 49.169556,1.365965 49.172393,1.366846 49.172118,1.367592 49.172891,1.368845 49.175414)))"
  ]
  "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(((1.368845 49.175414,1.36963 49.175264,1.370139 49.17515,1.371044 49.174909,1.372113 49.174598,1.373181 49.174163,1.374133 49.173637,1.374877 49.173259,1.375519 49.172946,1.376217 49.172578,1.376775 49.172311,1.377359 49.171993,1.377875 49.171768,1.378651 49.171337,1.381054 49.170387,1.384048 49.169718,1.387141 49.169534,1.388021 49.169273,1.389293 49.168988,1.390389 49.168721,1.391001 49.16853,1.39029 49.167987,1.389818 49.167533,1.388212 49.166059,1.387772 49.165632,1.387278 49.165212,1.387152 49.165085,1.387103 49.16494,1.386809 49.164516,1.386189 49.163805,1.385258 49.162922,1.384892 49.162411,1.384652 49.162019,1.38434 49.161635,1.384106 49.161277,1.38286 49.159509,1.382218 49.158544,1.381755 49.157917,1.381576 49.157644,1.380493 49.156122,1.380316 49.155839,1.380202 49.155738,1.379422 49.154903,1.379099 49.154505,1.378817 49.15396,1.37852 49.153538,1.378126 49.152914,1.377587 49.152159,1.377449 49.152067,1.377359 49.151876,1.376856 49.151211,1.376735 49.151071,1.375442 49.151366,1.372297 49.152071,1.371261 49.152309,1.369564 49.152687,1.366286 49.153426,1.364409 49.153846,1.363567 49.154029,1.360058 49.154824,1.357567 49.155379,1.357323 49.154881,1.356589 49.153577,1.356549 49.153402,1.356144 49.152725,1.356085 49.152603,1.356182 49.15244,1.355966 49.151904,1.356038 49.151702,1.356016 49.151548,1.355767 49.151448,1.355428 49.151347,1.355074 49.15127,1.354895 49.151268,1.354464 49.151337,1.35292 49.151644,1.35253 49.151666,1.352236 49.151639,1.351481 49.151502,1.351476 49.151428,1.351199 49.150668,1.35078 49.149314,1.349836 49.149415,1.34887 49.149535,1.348949 49.149782,1.347374 49.149773,1.346027 49.149759,1.345204 49.149717,1.344439 49.150147,1.34144 49.151661,1.341492 49.151853,1.340441 49.152128,1.340148 49.151784,1.339106 49.152378,1.339239 49.15262,1.338555 49.152614,1.337437 49.152394,1.336307 49.151073,1.335763 49.151328,1.335574 49.150927,1.334479 49.151317,1.335271 49.152557,1.335235 49.152852,1.335188 49.154153,1.334247 49.154096,1.333879 49.154098,1.333542 49.154064,1.332914 49.153839,1.332672 49.153779,1.331796 49.153694,1.33066 49.15364,1.330572 49.153588,1.330164 49.153537,1.329566 49.153429,1.329078 49.153326,1.328711 49.153222,1.32833 49.153016,1.328006 49.15274,1.327622 49.152345,1.327457 49.152087,1.327264 49.151636,1.327053 49.151302,1.326873 49.150915,1.326762 49.150798,1.326193 49.150469,1.325931 49.150334,1.32548 49.150196,1.325304 49.150112,1.324611 49.149908,1.324084 49.149827,1.323347 49.149667,1.32295 49.149548,1.322635 49.149427,1.322064 49.149072,1.321632 49.148689,1.32089 49.148233,1.319988 49.147242,1.319381 49.14662,1.31914 49.146511,1.31764 49.146139,1.316414 49.145814,1.315117 49.145578,1.313337 49.145608,1.312243 49.145464,1.311426 49.145232,1.311019 49.145049,1.310745 49.145001,1.310677 49.145046,1.304638 49.148457,1.304113 49.148724,1.303097 49.148018,1.301788 49.14712,1.301218 49.14728,1.300893 49.147363,1.300177 49.147503,1.29941 49.147625,1.298282 49.147748,1.297824 49.14787,1.297323 49.148153,1.297137 49.148308,1.296461 49.14881,1.29607 49.149026,1.293735 49.15012,1.293584 49.150389,1.292343 49.150484,1.291885 49.150726,1.29073 49.15129,1.289955 49.151721,1.290789 49.151892,1.291399 49.151958,1.291742 49.152097,1.292648 49.152493,1.293813 49.152988,1.29406 49.153104,1.294192 49.153262,1.294473 49.153411,1.295199 49.153743,1.295561 49.153872,1.29605 49.154011,1.296564 49.154232,1.296809 49.154431,1.29735 49.1547,1.297913 49.155097,1.298734 49.155556,1.299566 49.15596,1.301155 49.154669,1.303293 49.15552,1.303575 49.155606,1.304224 49.154902,1.304409 49.155029,1.306086 49.155635,1.306216 49.155698,1.308109 49.155918,1.310105 49.156306,1.311446 49.156598,1.311201 49.156926,1.312366 49.15747,1.312268 49.157584,1.313367 49.15815,1.314029 49.157439,1.31424 49.157501,1.314753 49.157605,1.315119 49.15771,1.315349 49.157744,1.315988 49.157746,1.316234 49.157768,1.316912 49.157892,1.316353 49.158582,1.317369 49.159098,1.317708 49.159638,1.318339 49.160167,1.3178 49.16064,1.318547 49.160908,1.318645 49.160961,1.319027 49.161037,1.319679 49.161075,1.320901 49.16107,1.321454 49.162542,1.32276 49.163422,1.322504 49.163565,1.321525 49.163963,1.321195 49.164068,1.32134 49.16429,1.322007 49.164134,1.322223 49.164489,1.323668 49.163998,1.323973 49.164252,1.324935 49.163891,1.325222 49.164164,1.325308 49.164086,1.325899 49.164529,1.328099 49.164622,1.329421 49.164683,1.330229 49.164737,1.330262 49.164573,1.330428 49.163464,1.338363 49.164169,1.338273 49.164834,1.338429 49.164919,1.339155 49.165422,1.33939 49.165481,1.341899 49.16565,1.342393 49.165705,1.342854 49.165785,1.34434 49.166136,1.345505 49.16639,1.347387 49.166769,1.347673 49.166974,1.347877 49.167229,1.348456 49.168009,1.349167 49.168986,1.349692 49.169804,1.350333 49.169466,1.35057 49.16938,1.351159 49.169224,1.351442 49.169169,1.356339 49.168128,1.358005 49.167682,1.359761 49.167218,1.360408 49.167041,1.361355 49.168288,1.361684 49.168735,1.362287 49.168708,1.363044 49.169556,1.365965 49.172393,1.366846 49.172118,1.367592 49.172891,1.368845 49.175414)))"
  ]
  "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(((1.368845 49.175414,1.36963 49.175264,1.370139 49.17515,1.371044 49.174909,1.372113 49.174598,1.373181 49.174163,1.374133 49.173637,1.374877 49.173259,1.375519 49.172946,1.376217 49.172578,1.376775 49.172311,1.377359 49.171993,1.377875 49.171768,1.378651 49.171337,1.381054 49.170387,1.384048 49.169718,1.387141 49.169534,1.388021 49.169273,1.389293 49.168988,1.390389 49.168721,1.391001 49.16853,1.39029 49.167987,1.389818 49.167533,1.388212 49.166059,1.387772 49.165632,1.387278 49.165212,1.387152 49.165085,1.387103 49.16494,1.386809 49.164516,1.386189 49.163805,1.385258 49.162922,1.384892 49.162411,1.384652 49.162019,1.38434 49.161635,1.384106 49.161277,1.38286 49.159509,1.382218 49.158544,1.381755 49.157917,1.381576 49.157644,1.380493 49.156122,1.380316 49.155839,1.380202 49.155738,1.379422 49.154903,1.379099 49.154505,1.378817 49.15396,1.37852 49.153538,1.378126 49.152914,1.377587 49.152159,1.377449 49.152067,1.377359 49.151876,1.376856 49.151211,1.376735 49.151071,1.375442 49.151366,1.372297 49.152071,1.371261 49.152309,1.369564 49.152687,1.366286 49.153426,1.364409 49.153846,1.363567 49.154029,1.360058 49.154824,1.357567 49.155379,1.357323 49.154881,1.356589 49.153577,1.356549 49.153402,1.356144 49.152725,1.356085 49.152603,1.356182 49.15244,1.355966 49.151904,1.356038 49.151702,1.356016 49.151548,1.355767 49.151448,1.355428 49.151347,1.355074 49.15127,1.354895 49.151268,1.354464 49.151337,1.35292 49.151644,1.35253 49.151666,1.352236 49.151639,1.351481 49.151502,1.351476 49.151428,1.351199 49.150668,1.35078 49.149314,1.349836 49.149415,1.34887 49.149535,1.348949 49.149782,1.347374 49.149773,1.346027 49.149759,1.345204 49.149717,1.344439 49.150147,1.34144 49.151661,1.341492 49.151853,1.340441 49.152128,1.340148 49.151784,1.339106 49.152378,1.339239 49.15262,1.338555 49.152614,1.337437 49.152394,1.336307 49.151073,1.335763 49.151328,1.335574 49.150927,1.334479 49.151317,1.335271 49.152557,1.335235 49.152852,1.335188 49.154153,1.334247 49.154096,1.333879 49.154098,1.333542 49.154064,1.332914 49.153839,1.332672 49.153779,1.331796 49.153694,1.33066 49.15364,1.330572 49.153588,1.330164 49.153537,1.329566 49.153429,1.329078 49.153326,1.328711 49.153222,1.32833 49.153016,1.328006 49.15274,1.327622 49.152345,1.327457 49.152087,1.327264 49.151636,1.327053 49.151302,1.326873 49.150915,1.326762 49.150798,1.326193 49.150469,1.325931 49.150334,1.32548 49.150196,1.325304 49.150112,1.324611 49.149908,1.324084 49.149827,1.323347 49.149667,1.32295 49.149548,1.322635 49.149427,1.322064 49.149072,1.321632 49.148689,1.32089 49.148233,1.319988 49.147242,1.319381 49.14662,1.31914 49.146511,1.31764 49.146139,1.316414 49.145814,1.315117 49.145578,1.313337 49.145608,1.312243 49.145464,1.311426 49.145232,1.311019 49.145049,1.310745 49.145001,1.310677 49.145046,1.304638 49.148457,1.304113 49.148724,1.303097 49.148018,1.301788 49.14712,1.301218 49.14728,1.300893 49.147363,1.300177 49.147503,1.29941 49.147625,1.298282 49.147748,1.297824 49.14787,1.297323 49.148153,1.297137 49.148308,1.296461 49.14881,1.29607 49.149026,1.293735 49.15012,1.293584 49.150389,1.292343 49.150484,1.291885 49.150726,1.29073 49.15129,1.289955 49.151721,1.290789 49.151892,1.291399 49.151958,1.291742 49.152097,1.292648 49.152493,1.293813 49.152988,1.29406 49.153104,1.294192 49.153262,1.294473 49.153411,1.295199 49.153743,1.295561 49.153872,1.29605 49.154011,1.296564 49.154232,1.296809 49.154431,1.29735 49.1547,1.297913 49.155097,1.298734 49.155556,1.299566 49.15596,1.301155 49.154669,1.303293 49.15552,1.303575 49.155606,1.304224 49.154902,1.304409 49.155029,1.306086 49.155635,1.306216 49.155698,1.308109 49.155918,1.310105 49.156306,1.311446 49.156598,1.311201 49.156926,1.312366 49.15747,1.312268 49.157584,1.313367 49.15815,1.314029 49.157439,1.31424 49.157501,1.314753 49.157605,1.315119 49.15771,1.315349 49.157744,1.315988 49.157746,1.316234 49.157768,1.316912 49.157892,1.316353 49.158582,1.317369 49.159098,1.317708 49.159638,1.318339 49.160167,1.3178 49.16064,1.318547 49.160908,1.318645 49.160961,1.319027 49.161037,1.319679 49.161075,1.320901 49.16107,1.321454 49.162542,1.32276 49.163422,1.322504 49.163565,1.321525 49.163963,1.321195 49.164068,1.32134 49.16429,1.322007 49.164134,1.322223 49.164489,1.323668 49.163998,1.323973 49.164252,1.324935 49.163891,1.325222 49.164164,1.325308 49.164086,1.325899 49.164529,1.328099 49.164622,1.329421 49.164683,1.330229 49.164737,1.330262 49.164573,1.330428 49.163464,1.338363 49.164169,1.338273 49.164834,1.338429 49.164919,1.339155 49.165422,1.33939 49.165481,1.341899 49.16565,1.342393 49.165705,1.342854 49.165785,1.34434 49.166136,1.345505 49.16639,1.347387 49.166769,1.347673 49.166974,1.347877 49.167229,1.348456 49.168009,1.349167 49.168986,1.349692 49.169804,1.350333 49.169466,1.35057 49.16938,1.351159 49.169224,1.351442 49.169169,1.356339 49.168128,1.358005 49.167682,1.359761 49.167218,1.360408 49.167041,1.361355 49.168288,1.361684 49.168735,1.362287 49.168708,1.363044 49.169556,1.365965 49.172393,1.366846 49.172118,1.367592 49.172891,1.368845 49.175414)))"
  ]
  "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 => 26852
  ]
  "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 => 26852
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#709
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.uuid_for_url AS uuid_for_url_2, t0.osm_kind AS osm_kind_3, t0.email AS email_4, t0.opted_out AS opted_out_5, t0.dead AS dead_6, t0.note AS note_7, t0.modified_date AS modified_date_8, t0.zip_code AS zip_code_9, t0.asked_humains_support AS asked_humains_support_10, t0.last_contact_attempt_date AS last_contact_attempt_date_11, t0.osm_id AS osm_id_12, t0.name AS name_13, t0.has_opening_hours AS has_opening_hours_14, t0.has_address AS has_address_15, t0.has_website AS has_website_16, t0.has_wheelchair AS has_wheelchair_17, t0.has_note AS has_note_18, t0.main_tag AS main_tag_19, t0.note_content AS note_content_20, t0.displayed_date AS displayed_date_21, t0.lat AS lat_22, t0.lon AS lon_23, t0.street AS street_24, t0.housenumber AS housenumber_25, t0.siret AS siret_26, t0.habitants AS habitants_27, t0.osm_data_date AS osm_data_date_28, t0.osm_version AS osm_version_29, t0.osm_user AS osm_user_30, t0.osm_uid AS osm_uid_31, t0.osm_changeset AS osm_changeset_32, t0.email_content AS email_content_33, t0.place_count AS place_count_34, t0.stats_id AS stats_id_35 FROM place t0 WHERE t0.stats_id = ?"
  "params" => [
    1 => 26852
  ]
  "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(((1.368845 49.175414,1.36963 49.175264,1.370139 49.17515,1.371044 49.174909,1.372113 49.174598,1.373181 49.174163,1.374133 49.173637,1.374877 49.173259,1.375519 49.172946,1.376217 49.172578,1.376775 49.172311,1.377359 49.171993,1.377875 49.171768,1.378651 49.171337,1.381054 49.170387,1.384048 49.169718,1.387141 49.169534,1.388021 49.169273,1.389293 49.168988,1.390389 49.168721,1.391001 49.16853,1.39029 49.167987,1.389818 49.167533,1.388212 49.166059,1.387772 49.165632,1.387278 49.165212,1.387152 49.165085,1.387103 49.16494,1.386809 49.164516,1.386189 49.163805,1.385258 49.162922,1.384892 49.162411,1.384652 49.162019,1.38434 49.161635,1.384106 49.161277,1.38286 49.159509,1.382218 49.158544,1.381755 49.157917,1.381576 49.157644,1.380493 49.156122,1.380316 49.155839,1.380202 49.155738,1.379422 49.154903,1.379099 49.154505,1.378817 49.15396,1.37852 49.153538,1.378126 49.152914,1.377587 49.152159,1.377449 49.152067,1.377359 49.151876,1.376856 49.151211,1.376735 49.151071,1.375442 49.151366,1.372297 49.152071,1.371261 49.152309,1.369564 49.152687,1.366286 49.153426,1.364409 49.153846,1.363567 49.154029,1.360058 49.154824,1.357567 49.155379,1.357323 49.154881,1.356589 49.153577,1.356549 49.153402,1.356144 49.152725,1.356085 49.152603,1.356182 49.15244,1.355966 49.151904,1.356038 49.151702,1.356016 49.151548,1.355767 49.151448,1.355428 49.151347,1.355074 49.15127,1.354895 49.151268,1.354464 49.151337,1.35292 49.151644,1.35253 49.151666,1.352236 49.151639,1.351481 49.151502,1.351476 49.151428,1.351199 49.150668,1.35078 49.149314,1.349836 49.149415,1.34887 49.149535,1.348949 49.149782,1.347374 49.149773,1.346027 49.149759,1.345204 49.149717,1.344439 49.150147,1.34144 49.151661,1.341492 49.151853,1.340441 49.152128,1.340148 49.151784,1.339106 49.152378,1.339239 49.15262,1.338555 49.152614,1.337437 49.152394,1.336307 49.151073,1.335763 49.151328,1.335574 49.150927,1.334479 49.151317,1.335271 49.152557,1.335235 49.152852,1.335188 49.154153,1.334247 49.154096,1.333879 49.154098,1.333542 49.154064,1.332914 49.153839,1.332672 49.153779,1.331796 49.153694,1.33066 49.15364,1.330572 49.153588,1.330164 49.153537,1.329566 49.153429,1.329078 49.153326,1.328711 49.153222,1.32833 49.153016,1.328006 49.15274,1.327622 49.152345,1.327457 49.152087,1.327264 49.151636,1.327053 49.151302,1.326873 49.150915,1.326762 49.150798,1.326193 49.150469,1.325931 49.150334,1.32548 49.150196,1.325304 49.150112,1.324611 49.149908,1.324084 49.149827,1.323347 49.149667,1.32295 49.149548,1.322635 49.149427,1.322064 49.149072,1.321632 49.148689,1.32089 49.148233,1.319988 49.147242,1.319381 49.14662,1.31914 49.146511,1.31764 49.146139,1.316414 49.145814,1.315117 49.145578,1.313337 49.145608,1.312243 49.145464,1.311426 49.145232,1.311019 49.145049,1.310745 49.145001,1.310677 49.145046,1.304638 49.148457,1.304113 49.148724,1.303097 49.148018,1.301788 49.14712,1.301218 49.14728,1.300893 49.147363,1.300177 49.147503,1.29941 49.147625,1.298282 49.147748,1.297824 49.14787,1.297323 49.148153,1.297137 49.148308,1.296461 49.14881,1.29607 49.149026,1.293735 49.15012,1.293584 49.150389,1.292343 49.150484,1.291885 49.150726,1.29073 49.15129,1.289955 49.151721,1.290789 49.151892,1.291399 49.151958,1.291742 49.152097,1.292648 49.152493,1.293813 49.152988,1.29406 49.153104,1.294192 49.153262,1.294473 49.153411,1.295199 49.153743,1.295561 49.153872,1.29605 49.154011,1.296564 49.154232,1.296809 49.154431,1.29735 49.1547,1.297913 49.155097,1.298734 49.155556,1.299566 49.15596,1.301155 49.154669,1.303293 49.15552,1.303575 49.155606,1.304224 49.154902,1.304409 49.155029,1.306086 49.155635,1.306216 49.155698,1.308109 49.155918,1.310105 49.156306,1.311446 49.156598,1.311201 49.156926,1.312366 49.15747,1.312268 49.157584,1.313367 49.15815,1.314029 49.157439,1.31424 49.157501,1.314753 49.157605,1.315119 49.15771,1.315349 49.157744,1.315988 49.157746,1.316234 49.157768,1.316912 49.157892,1.316353 49.158582,1.317369 49.159098,1.317708 49.159638,1.318339 49.160167,1.3178 49.16064,1.318547 49.160908,1.318645 49.160961,1.319027 49.161037,1.319679 49.161075,1.320901 49.16107,1.321454 49.162542,1.32276 49.163422,1.322504 49.163565,1.321525 49.163963,1.321195 49.164068,1.32134 49.16429,1.322007 49.164134,1.322223 49.164489,1.323668 49.163998,1.323973 49.164252,1.324935 49.163891,1.325222 49.164164,1.325308 49.164086,1.325899 49.164529,1.328099 49.164622,1.329421 49.164683,1.330229 49.164737,1.330262 49.164573,1.330428 49.163464,1.338363 49.164169,1.338273 49.164834,1.338429 49.164919,1.339155 49.165422,1.33939 49.165481,1.341899 49.16565,1.342393 49.165705,1.342854 49.165785,1.34434 49.166136,1.345505 49.16639,1.347387 49.166769,1.347673 49.166974,1.347877 49.167229,1.348456 49.168009,1.349167 49.168986,1.349692 49.169804,1.350333 49.169466,1.35057 49.16938,1.351159 49.169224,1.351442 49.169169,1.356339 49.168128,1.358005 49.167682,1.359761 49.167218,1.360408 49.167041,1.361355 49.168288,1.361684 49.168735,1.362287 49.168708,1.363044 49.169556,1.365965 49.172393,1.366846 49.172118,1.367592 49.172891,1.368845 49.175414)))"
    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(((1.368845 49.175414,1.36963 49.175264,1.370139 49.17515,1.371044 49.174909,1.372113 49.174598,1.373181 49.174163,1.374133 49.173637,1.374877 49.173259,1.375519 49.172946,1.376217 49.172578,1.376775 49.172311,1.377359 49.171993,1.377875 49.171768,1.378651 49.171337,1.381054 49.170387,1.384048 49.169718,1.387141 49.169534,1.388021 49.169273,1.389293 49.168988,1.390389 49.168721,1.391001 49.16853,1.39029 49.167987,1.389818 49.167533,1.388212 49.166059,1.387772 49.165632,1.387278 49.165212,1.387152 49.165085,1.387103 49.16494,1.386809 49.164516,1.386189 49.163805,1.385258 49.162922,1.384892 49.162411,1.384652 49.162019,1.38434 49.161635,1.384106 49.161277,1.38286 49.159509,1.382218 49.158544,1.381755 49.157917,1.381576 49.157644,1.380493 49.156122,1.380316 49.155839,1.380202 49.155738,1.379422 49.154903,1.379099 49.154505,1.378817 49.15396,1.37852 49.153538,1.378126 49.152914,1.377587 49.152159,1.377449 49.152067,1.377359 49.151876,1.376856 49.151211,1.376735 49.151071,1.375442 49.151366,1.372297 49.152071,1.371261 49.152309,1.369564 49.152687,1.366286 49.153426,1.364409 49.153846,1.363567 49.154029,1.360058 49.154824,1.357567 49.155379,1.357323 49.154881,1.356589 49.153577,1.356549 49.153402,1.356144 49.152725,1.356085 49.152603,1.356182 49.15244,1.355966 49.151904,1.356038 49.151702,1.356016 49.151548,1.355767 49.151448,1.355428 49.151347,1.355074 49.15127,1.354895 49.151268,1.354464 49.151337,1.35292 49.151644,1.35253 49.151666,1.352236 49.151639,1.351481 49.151502,1.351476 49.151428,1.351199 49.150668,1.35078 49.149314,1.349836 49.149415,1.34887 49.149535,1.348949 49.149782,1.347374 49.149773,1.346027 49.149759,1.345204 49.149717,1.344439 49.150147,1.34144 49.151661,1.341492 49.151853,1.340441 49.152128,1.340148 49.151784,1.339106 49.152378,1.339239 49.15262,1.338555 49.152614,1.337437 49.152394,1.336307 49.151073,1.335763 49.151328,1.335574 49.150927,1.334479 49.151317,1.335271 49.152557,1.335235 49.152852,1.335188 49.154153,1.334247 49.154096,1.333879 49.154098,1.333542 49.154064,1.332914 49.153839,1.332672 49.153779,1.331796 49.153694,1.33066 49.15364,1.330572 49.153588,1.330164 49.153537,1.329566 49.153429,1.329078 49.153326,1.328711 49.153222,1.32833 49.153016,1.328006 49.15274,1.327622 49.152345,1.327457 49.152087,1.327264 49.151636,1.327053 49.151302,1.326873 49.150915,1.326762 49.150798,1.326193 49.150469,1.325931 49.150334,1.32548 49.150196,1.325304 49.150112,1.324611 49.149908,1.324084 49.149827,1.323347 49.149667,1.32295 49.149548,1.322635 49.149427,1.322064 49.149072,1.321632 49.148689,1.32089 49.148233,1.319988 49.147242,1.319381 49.14662,1.31914 49.146511,1.31764 49.146139,1.316414 49.145814,1.315117 49.145578,1.313337 49.145608,1.312243 49.145464,1.311426 49.145232,1.311019 49.145049,1.310745 49.145001,1.310677 49.145046,1.304638 49.148457,1.304113 49.148724,1.303097 49.148018,1.301788 49.14712,1.301218 49.14728,1.300893 49.147363,1.300177 49.147503,1.29941 49.147625,1.298282 49.147748,1.297824 49.14787,1.297323 49.148153,1.297137 49.148308,1.296461 49.14881,1.29607 49.149026,1.293735 49.15012,1.293584 49.150389,1.292343 49.150484,1.291885 49.150726,1.29073 49.15129,1.289955 49.151721,1.290789 49.151892,1.291399 49.151958,1.291742 49.152097,1.292648 49.152493,1.293813 49.152988,1.29406 49.153104,1.294192 49.153262,1.294473 49.153411,1.295199 49.153743,1.295561 49.153872,1.29605 49.154011,1.296564 49.154232,1.296809 49.154431,1.29735 49.1547,1.297913 49.155097,1.298734 49.155556,1.299566 49.15596,1.301155 49.154669,1.303293 49.15552,1.303575 49.155606,1.304224 49.154902,1.304409 49.155029,1.306086 49.155635,1.306216 49.155698,1.308109 49.155918,1.310105 49.156306,1.311446 49.156598,1.311201 49.156926,1.312366 49.15747,1.312268 49.157584,1.313367 49.15815,1.314029 49.157439,1.31424 49.157501,1.314753 49.157605,1.315119 49.15771,1.315349 49.157744,1.315988 49.157746,1.316234 49.157768,1.316912 49.157892,1.316353 49.158582,1.317369 49.159098,1.317708 49.159638,1.318339 49.160167,1.3178 49.16064,1.318547 49.160908,1.318645 49.160961,1.319027 49.161037,1.319679 49.161075,1.320901 49.16107,1.321454 49.162542,1.32276 49.163422,1.322504 49.163565,1.321525 49.163963,1.321195 49.164068,1.32134 49.16429,1.322007 49.164134,1.322223 49.164489,1.323668 49.163998,1.323973 49.164252,1.324935 49.163891,1.325222 49.164164,1.325308 49.164086,1.325899 49.164529,1.328099 49.164622,1.329421 49.164683,1.330229 49.164737,1.330262 49.164573,1.330428 49.163464,1.338363 49.164169,1.338273 49.164834,1.338429 49.164919,1.339155 49.165422,1.33939 49.165481,1.341899 49.16565,1.342393 49.165705,1.342854 49.165785,1.34434 49.166136,1.345505 49.16639,1.347387 49.166769,1.347673 49.166974,1.347877 49.167229,1.348456 49.168009,1.349167 49.168986,1.349692 49.169804,1.350333 49.169466,1.35057 49.16938,1.351159 49.169224,1.351442 49.169169,1.356339 49.168128,1.358005 49.167682,1.359761 49.167218,1.360408 49.167041,1.361355 49.168288,1.361684 49.168735,1.362287 49.168708,1.363044 49.169556,1.365965 49.172393,1.366846 49.172118,1.367592 49.172891,1.368845 49.175414)))"
  ]
  "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(((1.368845 49.175414,1.36963 49.175264,1.370139 49.17515,1.371044 49.174909,1.372113 49.174598,1.373181 49.174163,1.374133 49.173637,1.374877 49.173259,1.375519 49.172946,1.376217 49.172578,1.376775 49.172311,1.377359 49.171993,1.377875 49.171768,1.378651 49.171337,1.381054 49.170387,1.384048 49.169718,1.387141 49.169534,1.388021 49.169273,1.389293 49.168988,1.390389 49.168721,1.391001 49.16853,1.39029 49.167987,1.389818 49.167533,1.388212 49.166059,1.387772 49.165632,1.387278 49.165212,1.387152 49.165085,1.387103 49.16494,1.386809 49.164516,1.386189 49.163805,1.385258 49.162922,1.384892 49.162411,1.384652 49.162019,1.38434 49.161635,1.384106 49.161277,1.38286 49.159509,1.382218 49.158544,1.381755 49.157917,1.381576 49.157644,1.380493 49.156122,1.380316 49.155839,1.380202 49.155738,1.379422 49.154903,1.379099 49.154505,1.378817 49.15396,1.37852 49.153538,1.378126 49.152914,1.377587 49.152159,1.377449 49.152067,1.377359 49.151876,1.376856 49.151211,1.376735 49.151071,1.375442 49.151366,1.372297 49.152071,1.371261 49.152309,1.369564 49.152687,1.366286 49.153426,1.364409 49.153846,1.363567 49.154029,1.360058 49.154824,1.357567 49.155379,1.357323 49.154881,1.356589 49.153577,1.356549 49.153402,1.356144 49.152725,1.356085 49.152603,1.356182 49.15244,1.355966 49.151904,1.356038 49.151702,1.356016 49.151548,1.355767 49.151448,1.355428 49.151347,1.355074 49.15127,1.354895 49.151268,1.354464 49.151337,1.35292 49.151644,1.35253 49.151666,1.352236 49.151639,1.351481 49.151502,1.351476 49.151428,1.351199 49.150668,1.35078 49.149314,1.349836 49.149415,1.34887 49.149535,1.348949 49.149782,1.347374 49.149773,1.346027 49.149759,1.345204 49.149717,1.344439 49.150147,1.34144 49.151661,1.341492 49.151853,1.340441 49.152128,1.340148 49.151784,1.339106 49.152378,1.339239 49.15262,1.338555 49.152614,1.337437 49.152394,1.336307 49.151073,1.335763 49.151328,1.335574 49.150927,1.334479 49.151317,1.335271 49.152557,1.335235 49.152852,1.335188 49.154153,1.334247 49.154096,1.333879 49.154098,1.333542 49.154064,1.332914 49.153839,1.332672 49.153779,1.331796 49.153694,1.33066 49.15364,1.330572 49.153588,1.330164 49.153537,1.329566 49.153429,1.329078 49.153326,1.328711 49.153222,1.32833 49.153016,1.328006 49.15274,1.327622 49.152345,1.327457 49.152087,1.327264 49.151636,1.327053 49.151302,1.326873 49.150915,1.326762 49.150798,1.326193 49.150469,1.325931 49.150334,1.32548 49.150196,1.325304 49.150112,1.324611 49.149908,1.324084 49.149827,1.323347 49.149667,1.32295 49.149548,1.322635 49.149427,1.322064 49.149072,1.321632 49.148689,1.32089 49.148233,1.319988 49.147242,1.319381 49.14662,1.31914 49.146511,1.31764 49.146139,1.316414 49.145814,1.315117 49.145578,1.313337 49.145608,1.312243 49.145464,1.311426 49.145232,1.311019 49.145049,1.310745 49.145001,1.310677 49.145046,1.304638 49.148457,1.304113 49.148724,1.303097 49.148018,1.301788 49.14712,1.301218 49.14728,1.300893 49.147363,1.300177 49.147503,1.29941 49.147625,1.298282 49.147748,1.297824 49.14787,1.297323 49.148153,1.297137 49.148308,1.296461 49.14881,1.29607 49.149026,1.293735 49.15012,1.293584 49.150389,1.292343 49.150484,1.291885 49.150726,1.29073 49.15129,1.289955 49.151721,1.290789 49.151892,1.291399 49.151958,1.291742 49.152097,1.292648 49.152493,1.293813 49.152988,1.29406 49.153104,1.294192 49.153262,1.294473 49.153411,1.295199 49.153743,1.295561 49.153872,1.29605 49.154011,1.296564 49.154232,1.296809 49.154431,1.29735 49.1547,1.297913 49.155097,1.298734 49.155556,1.299566 49.15596,1.301155 49.154669,1.303293 49.15552,1.303575 49.155606,1.304224 49.154902,1.304409 49.155029,1.306086 49.155635,1.306216 49.155698,1.308109 49.155918,1.310105 49.156306,1.311446 49.156598,1.311201 49.156926,1.312366 49.15747,1.312268 49.157584,1.313367 49.15815,1.314029 49.157439,1.31424 49.157501,1.314753 49.157605,1.315119 49.15771,1.315349 49.157744,1.315988 49.157746,1.316234 49.157768,1.316912 49.157892,1.316353 49.158582,1.317369 49.159098,1.317708 49.159638,1.318339 49.160167,1.3178 49.16064,1.318547 49.160908,1.318645 49.160961,1.319027 49.161037,1.319679 49.161075,1.320901 49.16107,1.321454 49.162542,1.32276 49.163422,1.322504 49.163565,1.321525 49.163963,1.321195 49.164068,1.32134 49.16429,1.322007 49.164134,1.322223 49.164489,1.323668 49.163998,1.323973 49.164252,1.324935 49.163891,1.325222 49.164164,1.325308 49.164086,1.325899 49.164529,1.328099 49.164622,1.329421 49.164683,1.330229 49.164737,1.330262 49.164573,1.330428 49.163464,1.338363 49.164169,1.338273 49.164834,1.338429 49.164919,1.339155 49.165422,1.33939 49.165481,1.341899 49.16565,1.342393 49.165705,1.342854 49.165785,1.34434 49.166136,1.345505 49.16639,1.347387 49.166769,1.347673 49.166974,1.347877 49.167229,1.348456 49.168009,1.349167 49.168986,1.349692 49.169804,1.350333 49.169466,1.35057 49.16938,1.351159 49.169224,1.351442 49.169169,1.356339 49.168128,1.358005 49.167682,1.359761 49.167218,1.360408 49.167041,1.361355 49.168288,1.361684 49.168735,1.362287 49.168708,1.363044 49.169556,1.365965 49.172393,1.366846 49.172118,1.367592 49.172891,1.368845 49.175414)))"
  ]
  "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(((1.368845 49.175414,1.36963 49.175264,1.370139 49.17515,1.371044 49.174909,1.372113 49.174598,1.373181 49.174163,1.374133 49.173637,1.374877 49.173259,1.375519 49.172946,1.376217 49.172578,1.376775 49.172311,1.377359 49.171993,1.377875 49.171768,1.378651 49.171337,1.381054 49.170387,1.384048 49.169718,1.387141 49.169534,1.388021 49.169273,1.389293 49.168988,1.390389 49.168721,1.391001 49.16853,1.39029 49.167987,1.389818 49.167533,1.388212 49.166059,1.387772 49.165632,1.387278 49.165212,1.387152 49.165085,1.387103 49.16494,1.386809 49.164516,1.386189 49.163805,1.385258 49.162922,1.384892 49.162411,1.384652 49.162019,1.38434 49.161635,1.384106 49.161277,1.38286 49.159509,1.382218 49.158544,1.381755 49.157917,1.381576 49.157644,1.380493 49.156122,1.380316 49.155839,1.380202 49.155738,1.379422 49.154903,1.379099 49.154505,1.378817 49.15396,1.37852 49.153538,1.378126 49.152914,1.377587 49.152159,1.377449 49.152067,1.377359 49.151876,1.376856 49.151211,1.376735 49.151071,1.375442 49.151366,1.372297 49.152071,1.371261 49.152309,1.369564 49.152687,1.366286 49.153426,1.364409 49.153846,1.363567 49.154029,1.360058 49.154824,1.357567 49.155379,1.357323 49.154881,1.356589 49.153577,1.356549 49.153402,1.356144 49.152725,1.356085 49.152603,1.356182 49.15244,1.355966 49.151904,1.356038 49.151702,1.356016 49.151548,1.355767 49.151448,1.355428 49.151347,1.355074 49.15127,1.354895 49.151268,1.354464 49.151337,1.35292 49.151644,1.35253 49.151666,1.352236 49.151639,1.351481 49.151502,1.351476 49.151428,1.351199 49.150668,1.35078 49.149314,1.349836 49.149415,1.34887 49.149535,1.348949 49.149782,1.347374 49.149773,1.346027 49.149759,1.345204 49.149717,1.344439 49.150147,1.34144 49.151661,1.341492 49.151853,1.340441 49.152128,1.340148 49.151784,1.339106 49.152378,1.339239 49.15262,1.338555 49.152614,1.337437 49.152394,1.336307 49.151073,1.335763 49.151328,1.335574 49.150927,1.334479 49.151317,1.335271 49.152557,1.335235 49.152852,1.335188 49.154153,1.334247 49.154096,1.333879 49.154098,1.333542 49.154064,1.332914 49.153839,1.332672 49.153779,1.331796 49.153694,1.33066 49.15364,1.330572 49.153588,1.330164 49.153537,1.329566 49.153429,1.329078 49.153326,1.328711 49.153222,1.32833 49.153016,1.328006 49.15274,1.327622 49.152345,1.327457 49.152087,1.327264 49.151636,1.327053 49.151302,1.326873 49.150915,1.326762 49.150798,1.326193 49.150469,1.325931 49.150334,1.32548 49.150196,1.325304 49.150112,1.324611 49.149908,1.324084 49.149827,1.323347 49.149667,1.32295 49.149548,1.322635 49.149427,1.322064 49.149072,1.321632 49.148689,1.32089 49.148233,1.319988 49.147242,1.319381 49.14662,1.31914 49.146511,1.31764 49.146139,1.316414 49.145814,1.315117 49.145578,1.313337 49.145608,1.312243 49.145464,1.311426 49.145232,1.311019 49.145049,1.310745 49.145001,1.310677 49.145046,1.304638 49.148457,1.304113 49.148724,1.303097 49.148018,1.301788 49.14712,1.301218 49.14728,1.300893 49.147363,1.300177 49.147503,1.29941 49.147625,1.298282 49.147748,1.297824 49.14787,1.297323 49.148153,1.297137 49.148308,1.296461 49.14881,1.29607 49.149026,1.293735 49.15012,1.293584 49.150389,1.292343 49.150484,1.291885 49.150726,1.29073 49.15129,1.289955 49.151721,1.290789 49.151892,1.291399 49.151958,1.291742 49.152097,1.292648 49.152493,1.293813 49.152988,1.29406 49.153104,1.294192 49.153262,1.294473 49.153411,1.295199 49.153743,1.295561 49.153872,1.29605 49.154011,1.296564 49.154232,1.296809 49.154431,1.29735 49.1547,1.297913 49.155097,1.298734 49.155556,1.299566 49.15596,1.301155 49.154669,1.303293 49.15552,1.303575 49.155606,1.304224 49.154902,1.304409 49.155029,1.306086 49.155635,1.306216 49.155698,1.308109 49.155918,1.310105 49.156306,1.311446 49.156598,1.311201 49.156926,1.312366 49.15747,1.312268 49.157584,1.313367 49.15815,1.314029 49.157439,1.31424 49.157501,1.314753 49.157605,1.315119 49.15771,1.315349 49.157744,1.315988 49.157746,1.316234 49.157768,1.316912 49.157892,1.316353 49.158582,1.317369 49.159098,1.317708 49.159638,1.318339 49.160167,1.3178 49.16064,1.318547 49.160908,1.318645 49.160961,1.319027 49.161037,1.319679 49.161075,1.320901 49.16107,1.321454 49.162542,1.32276 49.163422,1.322504 49.163565,1.321525 49.163963,1.321195 49.164068,1.32134 49.16429,1.322007 49.164134,1.322223 49.164489,1.323668 49.163998,1.323973 49.164252,1.324935 49.163891,1.325222 49.164164,1.325308 49.164086,1.325899 49.164529,1.328099 49.164622,1.329421 49.164683,1.330229 49.164737,1.330262 49.164573,1.330428 49.163464,1.338363 49.164169,1.338273 49.164834,1.338429 49.164919,1.339155 49.165422,1.33939 49.165481,1.341899 49.16565,1.342393 49.165705,1.342854 49.165785,1.34434 49.166136,1.345505 49.16639,1.347387 49.166769,1.347673 49.166974,1.347877 49.167229,1.348456 49.168009,1.349167 49.168986,1.349692 49.169804,1.350333 49.169466,1.35057 49.16938,1.351159 49.169224,1.351442 49.169169,1.356339 49.168128,1.358005 49.167682,1.359761 49.167218,1.360408 49.167041,1.361355 49.168288,1.361684 49.168735,1.362287 49.168708,1.363044 49.169556,1.365965 49.172393,1.366846 49.172118,1.367592 49.172891,1.368845 49.175414)))"
    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"
]