Symfony Profiler

[
  "route" => "app_admin_stats"
  "route_parameters" => [
    "_route" => "app_admin_stats"
    "_controller" => "App\Controller\AdminController::stats"
    "insee_code" => "93066"
  ]
  "request_uri" => "https://osm-labo.cipherbliss.com/admin/stats/93066"
  "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 => "93066"
  ]
  "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 => 26727
  ]
  "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":"93066","nom":"93066"}"
    3 => "2026-07-14 02:51: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 => "93066"
  ]
  "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 => 26727
  ]
  "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 => "93066"
  ]
  "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 => "93066"
  ]
  "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 => "93066"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    WITH zone AS (SELECT ST_GeomFromText(?, 4326) AS g),\n
    in_zone AS (\n
      SELECT h.osm_type, h.osm_id, h.version, h.valid_from, h.visible\n
      FROM osm_object_history h, zone z\n
      WHERE h.geom IS NOT NULL AND ST_Intersects(h.geom, z.g)\n
    ),\n
    creations AS (\n
      SELECT (valid_from AT TIME ZONE 'UTC')::date AS d\n
      FROM in_zone\n
      WHERE version = 1 AND visible = true AND valid_from >= NOW() - (? || ' days')::interval\n
    ),\n
    deletions AS (\n
      SELECT (del.valid_from AT TIME ZONE 'UTC')::date AS d\n
      FROM osm_object_history del\n
      JOIN in_zone prev\n
        ON prev.osm_type = del.osm_type\n
       AND prev.osm_id   = del.osm_id\n
       AND prev.version  = del.version - 1\n
      WHERE del.visible = false\n
        AND del.valid_from >= NOW() - (? || ' days')::interval\n
    )\n
    SELECT d::text AS date,\n
           SUM(n_creations)::int AS creations,\n
           SUM(n_deletions)::int AS deletions\n
    FROM (\n
      SELECT d, COUNT(*) AS n_creations, 0 AS n_deletions FROM creations GROUP BY d\n
      UNION ALL\n
      SELECT d, 0, COUNT(*) FROM deletions GROUP BY d\n
    ) u\n
    GROUP BY d\n
    ORDER BY d
    """
  "params" => [
    1 => "MULTIPOLYGON(((2.37475 48.923775,2.373992 48.92362,2.373501 48.923483,2.373049 48.923301,2.372551 48.923037,2.371994 48.922454,2.37124 48.922745,2.37048 48.923093,2.370107 48.923235,2.36943 48.923601,2.368645 48.924175,2.368299 48.924466,2.367232 48.923853,2.366987 48.923737,2.366675 48.923548,2.367136 48.922808,2.367614 48.922075,2.36685 48.921756,2.366138 48.921474,2.366524 48.920946,2.366906 48.920964,2.366839 48.92043,2.366815 48.919686,2.366848 48.919486,2.366864 48.918699,2.36694 48.917842,2.366338 48.917865,2.366315 48.916446,2.366394 48.915387,2.366707 48.915374,2.366675 48.915166,2.36631 48.913233,2.365984 48.911168,2.365702 48.909447,2.36568 48.909216,2.365962 48.906788,2.365968 48.904868,2.365876 48.903888,2.36562 48.901758,2.355239 48.901548,2.351984 48.901485,2.351839 48.902356,2.351825 48.902523,2.351691 48.903079,2.3516 48.903602,2.351543 48.903686,2.35143 48.90453,2.351354 48.905335,2.35122 48.907183,2.35119 48.907462,2.351234 48.907588,2.351602 48.908129,2.351644 48.908347,2.351461 48.909275,2.351477 48.909378,2.351353 48.910066,2.351269 48.910322,2.351054 48.910718,2.350838 48.910948,2.349757 48.911026,2.348885 48.911017,2.348398 48.910991,2.348254 48.911395,2.347058 48.914382,2.34572 48.914074,2.345229 48.914019,2.344674 48.914028,2.343225 48.914179,2.340527 48.914487,2.340078 48.914545,2.339601 48.914627,2.339081 48.914746,2.33851 48.914917,2.337802 48.915217,2.338118 48.915947,2.33911 48.918067,2.339244 48.918262,2.339621 48.918976,2.340011 48.919618,2.33912 48.919995,2.339153 48.920022,2.337136 48.920926,2.337257 48.920991,2.336993 48.92113,2.336823 48.921103,2.33412 48.922666,2.333246 48.923206,2.33485 48.925018,2.335844 48.926046,2.336386 48.926514,2.336846 48.926959,2.337159 48.927226,2.337497 48.927596,2.337927 48.928036,2.338355 48.928416,2.338986 48.929034,2.339201 48.929276,2.339714 48.92992,2.340018 48.930377,2.340227 48.930629,2.340352 48.930873,2.340657 48.931323,2.340875 48.931731,2.340978 48.932006,2.341242 48.932827,2.341426 48.933334,2.341574 48.933847,2.341657 48.93454,2.341721 48.935377,2.34174 48.936016,2.341544 48.936823,2.340952 48.938158,2.340376 48.939505,2.340023 48.940246,2.339372 48.941188,2.338337 48.942576,2.339435 48.943421,2.339733 48.943615,2.340627 48.944032,2.340491 48.944136,2.340764 48.944314,2.339225 48.945349,2.338561 48.94476,2.337946 48.944968,2.337896 48.94497,2.337511 48.944728,2.336987 48.944953,2.337061 48.945013,2.33687 48.94513,2.337763 48.945974,2.337576 48.946136,2.337873 48.946627,2.339379 48.947632,2.342794 48.946936,2.344586 48.946568,2.344209 48.946325,2.344196 48.946229,2.34472 48.945865,2.346019 48.946384,2.348085 48.947207,2.350577 48.94866,2.352216 48.951457,2.353709 48.954016,2.353661 48.956005,2.353501 48.956809,2.352975 48.956908,2.353577 48.957822,2.354571 48.959248,2.354879 48.959651,2.354004 48.959933,2.353554 48.960093,2.352803 48.960324,2.353061 48.96069,2.352446 48.96114,2.352464 48.961662,2.352905 48.961971,2.353535 48.962379,2.353031 48.962742,2.353549 48.963072,2.353013 48.963441,2.353538 48.963808,2.354017 48.964165,2.354558 48.964631,2.353918 48.964958,2.353496 48.965234,2.353466 48.965624,2.35365 48.965828,2.353925 48.965756,2.354804 48.966903,2.355357 48.967437,2.356533 48.968434,2.356761 48.968659,2.356929 48.968782,2.356559 48.968975,2.356424 48.969096,2.357506 48.970827,2.357928 48.971398,2.358203 48.971815,2.358985 48.972869,2.359531 48.972693,2.36 48.972496,2.360092 48.972481,2.360495 48.972691,2.360807 48.972989,2.361122 48.973348,2.36129 48.973499,2.361562 48.973886,2.361723 48.973965,2.362267 48.973797,2.362672 48.973722,2.362654 48.973658,2.365292 48.973086,2.365523 48.973538,2.365562 48.973691,2.365742 48.974028,2.365966 48.974007,2.368882 48.973034,2.369426 48.972919,2.371702 48.972529,2.372537 48.972369,2.375726 48.972074,2.375558 48.971688,2.375266 48.97096,2.374466 48.969112,2.374274 48.968697,2.374039 48.968112,2.373767 48.967482,2.373678 48.966707,2.373668 48.966499,2.373575 48.965626,2.37351 48.965244,2.373418 48.964149,2.373419 48.963292,2.373468 48.962736,2.373509 48.962572,2.37345 48.962354,2.373317 48.962082,2.373257 48.9617,2.373171 48.960819,2.373115 48.960749,2.373172 48.960623,2.373315 48.960104,2.369034 48.960088,2.36878 48.958962,2.365596 48.958807,2.365487 48.958793,2.365848 48.958054,2.3675 48.954756,2.367677 48.954415,2.368014 48.953875,2.368843 48.952735,2.369135 48.952386,2.369741 48.951064,2.370099 48.950169,2.370361 48.949593,2.370869 48.948593,2.371681 48.946968,2.37276 48.947163,2.373844 48.947369,2.375226 48.947647,2.375538 48.946701,2.375768 48.946195,2.375908 48.945992,2.376435 48.945311,2.377068 48.944551,2.377216 48.944656,2.377482 48.944769,2.377712 48.944813,2.378101 48.944825,2.378586 48.944789,2.379165 48.944796,2.379353 48.944817,2.380184 48.944962,2.38132 48.945196,2.382133 48.945411,2.382344 48.945171,2.382658 48.944652,2.382949 48.944302,2.383116 48.944359,2.383672 48.943516,2.384014 48.943596,2.384439 48.943851,2.384718 48.943729,2.384801 48.943855,2.385476 48.943929,2.385695 48.943898,2.385737 48.944037,2.385887 48.944022,2.386076 48.943941,2.386194 48.944076,2.386495 48.944205,2.387445 48.944472,2.387604 48.944566,2.387762 48.944795,2.387899 48.94484,2.388186 48.944862,2.388753 48.945003,2.389753 48.945345,2.390107 48.945427,2.390154 48.945472,2.390123 48.945769,2.38984 48.946183,2.389739 48.946418,2.389741 48.946692,2.389818 48.946777,2.390279 48.946958,2.391063 48.947051,2.391917 48.947397,2.392557 48.947614,2.392804 48.94772,2.393236 48.947852,2.393642 48.947931,2.393839 48.948024,2.394099 48.948233,2.394228 48.948378,2.394516 48.948398,2.394719 48.948466,2.394927 48.948755,2.395192 48.948834,2.395321 48.948923,2.395567 48.949388,2.395775 48.949321,2.396191 48.949279,2.397007 48.949453,2.397284 48.949657,2.397703 48.949452,2.397786 48.949323,2.398159 48.948978,2.397419 48.94866,2.397699 48.948616,2.398154 48.948218,2.398146 48.948111,2.398041 48.947819,2.397964 48.947689,2.397691 48.947509,2.397656 48.947401,2.397485 48.947402,2.397325 48.947043,2.397203 48.946918,2.397021 48.946544,2.396807 48.946205,2.39654 48.94589,2.396108 48.945483,2.395681 48.945186,2.39533 48.94499,2.394991 48.944755,2.394419 48.94444,2.393958 48.94424,2.393234 48.943979,2.392207 48.943563,2.390395 48.942942,2.389567 48.942665,2.38887 48.942447,2.388341 48.942346,2.387422 48.942222,2.387581 48.941394,2.385785 48.9409,2.385592 48.940841,2.384652 48.940304,2.384167 48.937218,2.383477 48.933507,2.383348 48.932837,2.383932 48.932505,2.382948 48.931335,2.382506 48.930783,2.381751 48.931104,2.381123 48.931336,2.38077 48.931402,2.379649 48.931587,2.378972 48.931687,2.377614 48.931836,2.376657 48.930211,2.375104 48.927685,2.37537 48.927526,2.376784 48.926278,2.377072 48.926001,2.377835 48.925347,2.374635 48.923839,2.37475 48.923775)))"
    2 => "30"
    3 => "30"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
    3 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "sql" => """
    SELECT to_char(qstart, 'YYYY') || '-Q' || EXTRACT(QUARTER FROM qstart)::int AS k,\n
           n\n
    FROM (\n
      SELECT date_trunc('quarter', valid_from) AS qstart, COUNT(*) AS n\n
      FROM osm_object_history h\n
      WHERE h.geom IS NOT NULL AND ST_Intersects(h.geom, ST_GeomFromText(?, 4326))\n
      GROUP BY 1\n
    ) t\n
    ORDER BY qstart
    """
  "params" => [
    1 => "MULTIPOLYGON(((2.37475 48.923775,2.373992 48.92362,2.373501 48.923483,2.373049 48.923301,2.372551 48.923037,2.371994 48.922454,2.37124 48.922745,2.37048 48.923093,2.370107 48.923235,2.36943 48.923601,2.368645 48.924175,2.368299 48.924466,2.367232 48.923853,2.366987 48.923737,2.366675 48.923548,2.367136 48.922808,2.367614 48.922075,2.36685 48.921756,2.366138 48.921474,2.366524 48.920946,2.366906 48.920964,2.366839 48.92043,2.366815 48.919686,2.366848 48.919486,2.366864 48.918699,2.36694 48.917842,2.366338 48.917865,2.366315 48.916446,2.366394 48.915387,2.366707 48.915374,2.366675 48.915166,2.36631 48.913233,2.365984 48.911168,2.365702 48.909447,2.36568 48.909216,2.365962 48.906788,2.365968 48.904868,2.365876 48.903888,2.36562 48.901758,2.355239 48.901548,2.351984 48.901485,2.351839 48.902356,2.351825 48.902523,2.351691 48.903079,2.3516 48.903602,2.351543 48.903686,2.35143 48.90453,2.351354 48.905335,2.35122 48.907183,2.35119 48.907462,2.351234 48.907588,2.351602 48.908129,2.351644 48.908347,2.351461 48.909275,2.351477 48.909378,2.351353 48.910066,2.351269 48.910322,2.351054 48.910718,2.350838 48.910948,2.349757 48.911026,2.348885 48.911017,2.348398 48.910991,2.348254 48.911395,2.347058 48.914382,2.34572 48.914074,2.345229 48.914019,2.344674 48.914028,2.343225 48.914179,2.340527 48.914487,2.340078 48.914545,2.339601 48.914627,2.339081 48.914746,2.33851 48.914917,2.337802 48.915217,2.338118 48.915947,2.33911 48.918067,2.339244 48.918262,2.339621 48.918976,2.340011 48.919618,2.33912 48.919995,2.339153 48.920022,2.337136 48.920926,2.337257 48.920991,2.336993 48.92113,2.336823 48.921103,2.33412 48.922666,2.333246 48.923206,2.33485 48.925018,2.335844 48.926046,2.336386 48.926514,2.336846 48.926959,2.337159 48.927226,2.337497 48.927596,2.337927 48.928036,2.338355 48.928416,2.338986 48.929034,2.339201 48.929276,2.339714 48.92992,2.340018 48.930377,2.340227 48.930629,2.340352 48.930873,2.340657 48.931323,2.340875 48.931731,2.340978 48.932006,2.341242 48.932827,2.341426 48.933334,2.341574 48.933847,2.341657 48.93454,2.341721 48.935377,2.34174 48.936016,2.341544 48.936823,2.340952 48.938158,2.340376 48.939505,2.340023 48.940246,2.339372 48.941188,2.338337 48.942576,2.339435 48.943421,2.339733 48.943615,2.340627 48.944032,2.340491 48.944136,2.340764 48.944314,2.339225 48.945349,2.338561 48.94476,2.337946 48.944968,2.337896 48.94497,2.337511 48.944728,2.336987 48.944953,2.337061 48.945013,2.33687 48.94513,2.337763 48.945974,2.337576 48.946136,2.337873 48.946627,2.339379 48.947632,2.342794 48.946936,2.344586 48.946568,2.344209 48.946325,2.344196 48.946229,2.34472 48.945865,2.346019 48.946384,2.348085 48.947207,2.350577 48.94866,2.352216 48.951457,2.353709 48.954016,2.353661 48.956005,2.353501 48.956809,2.352975 48.956908,2.353577 48.957822,2.354571 48.959248,2.354879 48.959651,2.354004 48.959933,2.353554 48.960093,2.352803 48.960324,2.353061 48.96069,2.352446 48.96114,2.352464 48.961662,2.352905 48.961971,2.353535 48.962379,2.353031 48.962742,2.353549 48.963072,2.353013 48.963441,2.353538 48.963808,2.354017 48.964165,2.354558 48.964631,2.353918 48.964958,2.353496 48.965234,2.353466 48.965624,2.35365 48.965828,2.353925 48.965756,2.354804 48.966903,2.355357 48.967437,2.356533 48.968434,2.356761 48.968659,2.356929 48.968782,2.356559 48.968975,2.356424 48.969096,2.357506 48.970827,2.357928 48.971398,2.358203 48.971815,2.358985 48.972869,2.359531 48.972693,2.36 48.972496,2.360092 48.972481,2.360495 48.972691,2.360807 48.972989,2.361122 48.973348,2.36129 48.973499,2.361562 48.973886,2.361723 48.973965,2.362267 48.973797,2.362672 48.973722,2.362654 48.973658,2.365292 48.973086,2.365523 48.973538,2.365562 48.973691,2.365742 48.974028,2.365966 48.974007,2.368882 48.973034,2.369426 48.972919,2.371702 48.972529,2.372537 48.972369,2.375726 48.972074,2.375558 48.971688,2.375266 48.97096,2.374466 48.969112,2.374274 48.968697,2.374039 48.968112,2.373767 48.967482,2.373678 48.966707,2.373668 48.966499,2.373575 48.965626,2.37351 48.965244,2.373418 48.964149,2.373419 48.963292,2.373468 48.962736,2.373509 48.962572,2.37345 48.962354,2.373317 48.962082,2.373257 48.9617,2.373171 48.960819,2.373115 48.960749,2.373172 48.960623,2.373315 48.960104,2.369034 48.960088,2.36878 48.958962,2.365596 48.958807,2.365487 48.958793,2.365848 48.958054,2.3675 48.954756,2.367677 48.954415,2.368014 48.953875,2.368843 48.952735,2.369135 48.952386,2.369741 48.951064,2.370099 48.950169,2.370361 48.949593,2.370869 48.948593,2.371681 48.946968,2.37276 48.947163,2.373844 48.947369,2.375226 48.947647,2.375538 48.946701,2.375768 48.946195,2.375908 48.945992,2.376435 48.945311,2.377068 48.944551,2.377216 48.944656,2.377482 48.944769,2.377712 48.944813,2.378101 48.944825,2.378586 48.944789,2.379165 48.944796,2.379353 48.944817,2.380184 48.944962,2.38132 48.945196,2.382133 48.945411,2.382344 48.945171,2.382658 48.944652,2.382949 48.944302,2.383116 48.944359,2.383672 48.943516,2.384014 48.943596,2.384439 48.943851,2.384718 48.943729,2.384801 48.943855,2.385476 48.943929,2.385695 48.943898,2.385737 48.944037,2.385887 48.944022,2.386076 48.943941,2.386194 48.944076,2.386495 48.944205,2.387445 48.944472,2.387604 48.944566,2.387762 48.944795,2.387899 48.94484,2.388186 48.944862,2.388753 48.945003,2.389753 48.945345,2.390107 48.945427,2.390154 48.945472,2.390123 48.945769,2.38984 48.946183,2.389739 48.946418,2.389741 48.946692,2.389818 48.946777,2.390279 48.946958,2.391063 48.947051,2.391917 48.947397,2.392557 48.947614,2.392804 48.94772,2.393236 48.947852,2.393642 48.947931,2.393839 48.948024,2.394099 48.948233,2.394228 48.948378,2.394516 48.948398,2.394719 48.948466,2.394927 48.948755,2.395192 48.948834,2.395321 48.948923,2.395567 48.949388,2.395775 48.949321,2.396191 48.949279,2.397007 48.949453,2.397284 48.949657,2.397703 48.949452,2.397786 48.949323,2.398159 48.948978,2.397419 48.94866,2.397699 48.948616,2.398154 48.948218,2.398146 48.948111,2.398041 48.947819,2.397964 48.947689,2.397691 48.947509,2.397656 48.947401,2.397485 48.947402,2.397325 48.947043,2.397203 48.946918,2.397021 48.946544,2.396807 48.946205,2.39654 48.94589,2.396108 48.945483,2.395681 48.945186,2.39533 48.94499,2.394991 48.944755,2.394419 48.94444,2.393958 48.94424,2.393234 48.943979,2.392207 48.943563,2.390395 48.942942,2.389567 48.942665,2.38887 48.942447,2.388341 48.942346,2.387422 48.942222,2.387581 48.941394,2.385785 48.9409,2.385592 48.940841,2.384652 48.940304,2.384167 48.937218,2.383477 48.933507,2.383348 48.932837,2.383932 48.932505,2.382948 48.931335,2.382506 48.930783,2.381751 48.931104,2.381123 48.931336,2.38077 48.931402,2.379649 48.931587,2.378972 48.931687,2.377614 48.931836,2.376657 48.930211,2.375104 48.927685,2.37537 48.927526,2.376784 48.926278,2.377072 48.926001,2.377835 48.925347,2.374635 48.923839,2.37475 48.923775)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    WITH last_versions AS (\n
      SELECT DISTINCT ON (osm_type, osm_id) osm_type, osm_id, valid_from, visible, geom\n
      FROM osm_object_history h\n
      WHERE h.geom IS NOT NULL\n
        AND ST_Intersects(h.geom, ST_GeomFromText(?, 4326))\n
      ORDER BY osm_type, osm_id, valid_from DESC\n
    )\n
    SELECT TO_TIMESTAMP(AVG(EXTRACT(EPOCH FROM valid_from))) AS avg_ts,\n
           COUNT(*) AS n\n
    FROM last_versions\n
    WHERE visible = true
    """
  "params" => [
    1 => "MULTIPOLYGON(((2.37475 48.923775,2.373992 48.92362,2.373501 48.923483,2.373049 48.923301,2.372551 48.923037,2.371994 48.922454,2.37124 48.922745,2.37048 48.923093,2.370107 48.923235,2.36943 48.923601,2.368645 48.924175,2.368299 48.924466,2.367232 48.923853,2.366987 48.923737,2.366675 48.923548,2.367136 48.922808,2.367614 48.922075,2.36685 48.921756,2.366138 48.921474,2.366524 48.920946,2.366906 48.920964,2.366839 48.92043,2.366815 48.919686,2.366848 48.919486,2.366864 48.918699,2.36694 48.917842,2.366338 48.917865,2.366315 48.916446,2.366394 48.915387,2.366707 48.915374,2.366675 48.915166,2.36631 48.913233,2.365984 48.911168,2.365702 48.909447,2.36568 48.909216,2.365962 48.906788,2.365968 48.904868,2.365876 48.903888,2.36562 48.901758,2.355239 48.901548,2.351984 48.901485,2.351839 48.902356,2.351825 48.902523,2.351691 48.903079,2.3516 48.903602,2.351543 48.903686,2.35143 48.90453,2.351354 48.905335,2.35122 48.907183,2.35119 48.907462,2.351234 48.907588,2.351602 48.908129,2.351644 48.908347,2.351461 48.909275,2.351477 48.909378,2.351353 48.910066,2.351269 48.910322,2.351054 48.910718,2.350838 48.910948,2.349757 48.911026,2.348885 48.911017,2.348398 48.910991,2.348254 48.911395,2.347058 48.914382,2.34572 48.914074,2.345229 48.914019,2.344674 48.914028,2.343225 48.914179,2.340527 48.914487,2.340078 48.914545,2.339601 48.914627,2.339081 48.914746,2.33851 48.914917,2.337802 48.915217,2.338118 48.915947,2.33911 48.918067,2.339244 48.918262,2.339621 48.918976,2.340011 48.919618,2.33912 48.919995,2.339153 48.920022,2.337136 48.920926,2.337257 48.920991,2.336993 48.92113,2.336823 48.921103,2.33412 48.922666,2.333246 48.923206,2.33485 48.925018,2.335844 48.926046,2.336386 48.926514,2.336846 48.926959,2.337159 48.927226,2.337497 48.927596,2.337927 48.928036,2.338355 48.928416,2.338986 48.929034,2.339201 48.929276,2.339714 48.92992,2.340018 48.930377,2.340227 48.930629,2.340352 48.930873,2.340657 48.931323,2.340875 48.931731,2.340978 48.932006,2.341242 48.932827,2.341426 48.933334,2.341574 48.933847,2.341657 48.93454,2.341721 48.935377,2.34174 48.936016,2.341544 48.936823,2.340952 48.938158,2.340376 48.939505,2.340023 48.940246,2.339372 48.941188,2.338337 48.942576,2.339435 48.943421,2.339733 48.943615,2.340627 48.944032,2.340491 48.944136,2.340764 48.944314,2.339225 48.945349,2.338561 48.94476,2.337946 48.944968,2.337896 48.94497,2.337511 48.944728,2.336987 48.944953,2.337061 48.945013,2.33687 48.94513,2.337763 48.945974,2.337576 48.946136,2.337873 48.946627,2.339379 48.947632,2.342794 48.946936,2.344586 48.946568,2.344209 48.946325,2.344196 48.946229,2.34472 48.945865,2.346019 48.946384,2.348085 48.947207,2.350577 48.94866,2.352216 48.951457,2.353709 48.954016,2.353661 48.956005,2.353501 48.956809,2.352975 48.956908,2.353577 48.957822,2.354571 48.959248,2.354879 48.959651,2.354004 48.959933,2.353554 48.960093,2.352803 48.960324,2.353061 48.96069,2.352446 48.96114,2.352464 48.961662,2.352905 48.961971,2.353535 48.962379,2.353031 48.962742,2.353549 48.963072,2.353013 48.963441,2.353538 48.963808,2.354017 48.964165,2.354558 48.964631,2.353918 48.964958,2.353496 48.965234,2.353466 48.965624,2.35365 48.965828,2.353925 48.965756,2.354804 48.966903,2.355357 48.967437,2.356533 48.968434,2.356761 48.968659,2.356929 48.968782,2.356559 48.968975,2.356424 48.969096,2.357506 48.970827,2.357928 48.971398,2.358203 48.971815,2.358985 48.972869,2.359531 48.972693,2.36 48.972496,2.360092 48.972481,2.360495 48.972691,2.360807 48.972989,2.361122 48.973348,2.36129 48.973499,2.361562 48.973886,2.361723 48.973965,2.362267 48.973797,2.362672 48.973722,2.362654 48.973658,2.365292 48.973086,2.365523 48.973538,2.365562 48.973691,2.365742 48.974028,2.365966 48.974007,2.368882 48.973034,2.369426 48.972919,2.371702 48.972529,2.372537 48.972369,2.375726 48.972074,2.375558 48.971688,2.375266 48.97096,2.374466 48.969112,2.374274 48.968697,2.374039 48.968112,2.373767 48.967482,2.373678 48.966707,2.373668 48.966499,2.373575 48.965626,2.37351 48.965244,2.373418 48.964149,2.373419 48.963292,2.373468 48.962736,2.373509 48.962572,2.37345 48.962354,2.373317 48.962082,2.373257 48.9617,2.373171 48.960819,2.373115 48.960749,2.373172 48.960623,2.373315 48.960104,2.369034 48.960088,2.36878 48.958962,2.365596 48.958807,2.365487 48.958793,2.365848 48.958054,2.3675 48.954756,2.367677 48.954415,2.368014 48.953875,2.368843 48.952735,2.369135 48.952386,2.369741 48.951064,2.370099 48.950169,2.370361 48.949593,2.370869 48.948593,2.371681 48.946968,2.37276 48.947163,2.373844 48.947369,2.375226 48.947647,2.375538 48.946701,2.375768 48.946195,2.375908 48.945992,2.376435 48.945311,2.377068 48.944551,2.377216 48.944656,2.377482 48.944769,2.377712 48.944813,2.378101 48.944825,2.378586 48.944789,2.379165 48.944796,2.379353 48.944817,2.380184 48.944962,2.38132 48.945196,2.382133 48.945411,2.382344 48.945171,2.382658 48.944652,2.382949 48.944302,2.383116 48.944359,2.383672 48.943516,2.384014 48.943596,2.384439 48.943851,2.384718 48.943729,2.384801 48.943855,2.385476 48.943929,2.385695 48.943898,2.385737 48.944037,2.385887 48.944022,2.386076 48.943941,2.386194 48.944076,2.386495 48.944205,2.387445 48.944472,2.387604 48.944566,2.387762 48.944795,2.387899 48.94484,2.388186 48.944862,2.388753 48.945003,2.389753 48.945345,2.390107 48.945427,2.390154 48.945472,2.390123 48.945769,2.38984 48.946183,2.389739 48.946418,2.389741 48.946692,2.389818 48.946777,2.390279 48.946958,2.391063 48.947051,2.391917 48.947397,2.392557 48.947614,2.392804 48.94772,2.393236 48.947852,2.393642 48.947931,2.393839 48.948024,2.394099 48.948233,2.394228 48.948378,2.394516 48.948398,2.394719 48.948466,2.394927 48.948755,2.395192 48.948834,2.395321 48.948923,2.395567 48.949388,2.395775 48.949321,2.396191 48.949279,2.397007 48.949453,2.397284 48.949657,2.397703 48.949452,2.397786 48.949323,2.398159 48.948978,2.397419 48.94866,2.397699 48.948616,2.398154 48.948218,2.398146 48.948111,2.398041 48.947819,2.397964 48.947689,2.397691 48.947509,2.397656 48.947401,2.397485 48.947402,2.397325 48.947043,2.397203 48.946918,2.397021 48.946544,2.396807 48.946205,2.39654 48.94589,2.396108 48.945483,2.395681 48.945186,2.39533 48.94499,2.394991 48.944755,2.394419 48.94444,2.393958 48.94424,2.393234 48.943979,2.392207 48.943563,2.390395 48.942942,2.389567 48.942665,2.38887 48.942447,2.388341 48.942346,2.387422 48.942222,2.387581 48.941394,2.385785 48.9409,2.385592 48.940841,2.384652 48.940304,2.384167 48.937218,2.383477 48.933507,2.383348 48.932837,2.383932 48.932505,2.382948 48.931335,2.382506 48.930783,2.381751 48.931104,2.381123 48.931336,2.38077 48.931402,2.379649 48.931587,2.378972 48.931687,2.377614 48.931836,2.376657 48.930211,2.375104 48.927685,2.37537 48.927526,2.376784 48.926278,2.377072 48.926001,2.377835 48.925347,2.374635 48.923839,2.37475 48.923775)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    WITH zone AS (SELECT ST_GeomFromText(?, 4326) AS g),\n
    in_zone AS (\n
      SELECT h.osm_type, h.osm_id, h.version, h.visible\n
      FROM osm_object_history h, zone z\n
      WHERE h.geom IS NOT NULL AND ST_Intersects(h.geom, z.g)\n
    ),\n
    deletions AS (\n
      SELECT 1 AS one\n
      FROM osm_object_history del\n
      JOIN in_zone prev\n
        ON prev.osm_type = del.osm_type\n
       AND prev.osm_id   = del.osm_id\n
       AND prev.version  = del.version - 1\n
      WHERE del.visible = false\n
    )\n
    SELECT\n
      (SELECT COUNT(*) FROM in_zone WHERE version = 1 AND visible = true) AS creations_total,\n
      (SELECT COUNT(*) FROM deletions)                                    AS deletions_total,\n
      (SELECT COUNT(*) FROM in_zone)                                      AS versions_total
    """
  "params" => [
    1 => "MULTIPOLYGON(((2.37475 48.923775,2.373992 48.92362,2.373501 48.923483,2.373049 48.923301,2.372551 48.923037,2.371994 48.922454,2.37124 48.922745,2.37048 48.923093,2.370107 48.923235,2.36943 48.923601,2.368645 48.924175,2.368299 48.924466,2.367232 48.923853,2.366987 48.923737,2.366675 48.923548,2.367136 48.922808,2.367614 48.922075,2.36685 48.921756,2.366138 48.921474,2.366524 48.920946,2.366906 48.920964,2.366839 48.92043,2.366815 48.919686,2.366848 48.919486,2.366864 48.918699,2.36694 48.917842,2.366338 48.917865,2.366315 48.916446,2.366394 48.915387,2.366707 48.915374,2.366675 48.915166,2.36631 48.913233,2.365984 48.911168,2.365702 48.909447,2.36568 48.909216,2.365962 48.906788,2.365968 48.904868,2.365876 48.903888,2.36562 48.901758,2.355239 48.901548,2.351984 48.901485,2.351839 48.902356,2.351825 48.902523,2.351691 48.903079,2.3516 48.903602,2.351543 48.903686,2.35143 48.90453,2.351354 48.905335,2.35122 48.907183,2.35119 48.907462,2.351234 48.907588,2.351602 48.908129,2.351644 48.908347,2.351461 48.909275,2.351477 48.909378,2.351353 48.910066,2.351269 48.910322,2.351054 48.910718,2.350838 48.910948,2.349757 48.911026,2.348885 48.911017,2.348398 48.910991,2.348254 48.911395,2.347058 48.914382,2.34572 48.914074,2.345229 48.914019,2.344674 48.914028,2.343225 48.914179,2.340527 48.914487,2.340078 48.914545,2.339601 48.914627,2.339081 48.914746,2.33851 48.914917,2.337802 48.915217,2.338118 48.915947,2.33911 48.918067,2.339244 48.918262,2.339621 48.918976,2.340011 48.919618,2.33912 48.919995,2.339153 48.920022,2.337136 48.920926,2.337257 48.920991,2.336993 48.92113,2.336823 48.921103,2.33412 48.922666,2.333246 48.923206,2.33485 48.925018,2.335844 48.926046,2.336386 48.926514,2.336846 48.926959,2.337159 48.927226,2.337497 48.927596,2.337927 48.928036,2.338355 48.928416,2.338986 48.929034,2.339201 48.929276,2.339714 48.92992,2.340018 48.930377,2.340227 48.930629,2.340352 48.930873,2.340657 48.931323,2.340875 48.931731,2.340978 48.932006,2.341242 48.932827,2.341426 48.933334,2.341574 48.933847,2.341657 48.93454,2.341721 48.935377,2.34174 48.936016,2.341544 48.936823,2.340952 48.938158,2.340376 48.939505,2.340023 48.940246,2.339372 48.941188,2.338337 48.942576,2.339435 48.943421,2.339733 48.943615,2.340627 48.944032,2.340491 48.944136,2.340764 48.944314,2.339225 48.945349,2.338561 48.94476,2.337946 48.944968,2.337896 48.94497,2.337511 48.944728,2.336987 48.944953,2.337061 48.945013,2.33687 48.94513,2.337763 48.945974,2.337576 48.946136,2.337873 48.946627,2.339379 48.947632,2.342794 48.946936,2.344586 48.946568,2.344209 48.946325,2.344196 48.946229,2.34472 48.945865,2.346019 48.946384,2.348085 48.947207,2.350577 48.94866,2.352216 48.951457,2.353709 48.954016,2.353661 48.956005,2.353501 48.956809,2.352975 48.956908,2.353577 48.957822,2.354571 48.959248,2.354879 48.959651,2.354004 48.959933,2.353554 48.960093,2.352803 48.960324,2.353061 48.96069,2.352446 48.96114,2.352464 48.961662,2.352905 48.961971,2.353535 48.962379,2.353031 48.962742,2.353549 48.963072,2.353013 48.963441,2.353538 48.963808,2.354017 48.964165,2.354558 48.964631,2.353918 48.964958,2.353496 48.965234,2.353466 48.965624,2.35365 48.965828,2.353925 48.965756,2.354804 48.966903,2.355357 48.967437,2.356533 48.968434,2.356761 48.968659,2.356929 48.968782,2.356559 48.968975,2.356424 48.969096,2.357506 48.970827,2.357928 48.971398,2.358203 48.971815,2.358985 48.972869,2.359531 48.972693,2.36 48.972496,2.360092 48.972481,2.360495 48.972691,2.360807 48.972989,2.361122 48.973348,2.36129 48.973499,2.361562 48.973886,2.361723 48.973965,2.362267 48.973797,2.362672 48.973722,2.362654 48.973658,2.365292 48.973086,2.365523 48.973538,2.365562 48.973691,2.365742 48.974028,2.365966 48.974007,2.368882 48.973034,2.369426 48.972919,2.371702 48.972529,2.372537 48.972369,2.375726 48.972074,2.375558 48.971688,2.375266 48.97096,2.374466 48.969112,2.374274 48.968697,2.374039 48.968112,2.373767 48.967482,2.373678 48.966707,2.373668 48.966499,2.373575 48.965626,2.37351 48.965244,2.373418 48.964149,2.373419 48.963292,2.373468 48.962736,2.373509 48.962572,2.37345 48.962354,2.373317 48.962082,2.373257 48.9617,2.373171 48.960819,2.373115 48.960749,2.373172 48.960623,2.373315 48.960104,2.369034 48.960088,2.36878 48.958962,2.365596 48.958807,2.365487 48.958793,2.365848 48.958054,2.3675 48.954756,2.367677 48.954415,2.368014 48.953875,2.368843 48.952735,2.369135 48.952386,2.369741 48.951064,2.370099 48.950169,2.370361 48.949593,2.370869 48.948593,2.371681 48.946968,2.37276 48.947163,2.373844 48.947369,2.375226 48.947647,2.375538 48.946701,2.375768 48.946195,2.375908 48.945992,2.376435 48.945311,2.377068 48.944551,2.377216 48.944656,2.377482 48.944769,2.377712 48.944813,2.378101 48.944825,2.378586 48.944789,2.379165 48.944796,2.379353 48.944817,2.380184 48.944962,2.38132 48.945196,2.382133 48.945411,2.382344 48.945171,2.382658 48.944652,2.382949 48.944302,2.383116 48.944359,2.383672 48.943516,2.384014 48.943596,2.384439 48.943851,2.384718 48.943729,2.384801 48.943855,2.385476 48.943929,2.385695 48.943898,2.385737 48.944037,2.385887 48.944022,2.386076 48.943941,2.386194 48.944076,2.386495 48.944205,2.387445 48.944472,2.387604 48.944566,2.387762 48.944795,2.387899 48.94484,2.388186 48.944862,2.388753 48.945003,2.389753 48.945345,2.390107 48.945427,2.390154 48.945472,2.390123 48.945769,2.38984 48.946183,2.389739 48.946418,2.389741 48.946692,2.389818 48.946777,2.390279 48.946958,2.391063 48.947051,2.391917 48.947397,2.392557 48.947614,2.392804 48.94772,2.393236 48.947852,2.393642 48.947931,2.393839 48.948024,2.394099 48.948233,2.394228 48.948378,2.394516 48.948398,2.394719 48.948466,2.394927 48.948755,2.395192 48.948834,2.395321 48.948923,2.395567 48.949388,2.395775 48.949321,2.396191 48.949279,2.397007 48.949453,2.397284 48.949657,2.397703 48.949452,2.397786 48.949323,2.398159 48.948978,2.397419 48.94866,2.397699 48.948616,2.398154 48.948218,2.398146 48.948111,2.398041 48.947819,2.397964 48.947689,2.397691 48.947509,2.397656 48.947401,2.397485 48.947402,2.397325 48.947043,2.397203 48.946918,2.397021 48.946544,2.396807 48.946205,2.39654 48.94589,2.396108 48.945483,2.395681 48.945186,2.39533 48.94499,2.394991 48.944755,2.394419 48.94444,2.393958 48.94424,2.393234 48.943979,2.392207 48.943563,2.390395 48.942942,2.389567 48.942665,2.38887 48.942447,2.388341 48.942346,2.387422 48.942222,2.387581 48.941394,2.385785 48.9409,2.385592 48.940841,2.384652 48.940304,2.384167 48.937218,2.383477 48.933507,2.383348 48.932837,2.383932 48.932505,2.382948 48.931335,2.382506 48.930783,2.381751 48.931104,2.381123 48.931336,2.38077 48.931402,2.379649 48.931587,2.378972 48.931687,2.377614 48.931836,2.376657 48.930211,2.375104 48.927685,2.37537 48.927526,2.376784 48.926278,2.377072 48.926001,2.377835 48.925347,2.374635 48.923839,2.37475 48.923775)))"
  ]
  "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(((2.37475 48.923775,2.373992 48.92362,2.373501 48.923483,2.373049 48.923301,2.372551 48.923037,2.371994 48.922454,2.37124 48.922745,2.37048 48.923093,2.370107 48.923235,2.36943 48.923601,2.368645 48.924175,2.368299 48.924466,2.367232 48.923853,2.366987 48.923737,2.366675 48.923548,2.367136 48.922808,2.367614 48.922075,2.36685 48.921756,2.366138 48.921474,2.366524 48.920946,2.366906 48.920964,2.366839 48.92043,2.366815 48.919686,2.366848 48.919486,2.366864 48.918699,2.36694 48.917842,2.366338 48.917865,2.366315 48.916446,2.366394 48.915387,2.366707 48.915374,2.366675 48.915166,2.36631 48.913233,2.365984 48.911168,2.365702 48.909447,2.36568 48.909216,2.365962 48.906788,2.365968 48.904868,2.365876 48.903888,2.36562 48.901758,2.355239 48.901548,2.351984 48.901485,2.351839 48.902356,2.351825 48.902523,2.351691 48.903079,2.3516 48.903602,2.351543 48.903686,2.35143 48.90453,2.351354 48.905335,2.35122 48.907183,2.35119 48.907462,2.351234 48.907588,2.351602 48.908129,2.351644 48.908347,2.351461 48.909275,2.351477 48.909378,2.351353 48.910066,2.351269 48.910322,2.351054 48.910718,2.350838 48.910948,2.349757 48.911026,2.348885 48.911017,2.348398 48.910991,2.348254 48.911395,2.347058 48.914382,2.34572 48.914074,2.345229 48.914019,2.344674 48.914028,2.343225 48.914179,2.340527 48.914487,2.340078 48.914545,2.339601 48.914627,2.339081 48.914746,2.33851 48.914917,2.337802 48.915217,2.338118 48.915947,2.33911 48.918067,2.339244 48.918262,2.339621 48.918976,2.340011 48.919618,2.33912 48.919995,2.339153 48.920022,2.337136 48.920926,2.337257 48.920991,2.336993 48.92113,2.336823 48.921103,2.33412 48.922666,2.333246 48.923206,2.33485 48.925018,2.335844 48.926046,2.336386 48.926514,2.336846 48.926959,2.337159 48.927226,2.337497 48.927596,2.337927 48.928036,2.338355 48.928416,2.338986 48.929034,2.339201 48.929276,2.339714 48.92992,2.340018 48.930377,2.340227 48.930629,2.340352 48.930873,2.340657 48.931323,2.340875 48.931731,2.340978 48.932006,2.341242 48.932827,2.341426 48.933334,2.341574 48.933847,2.341657 48.93454,2.341721 48.935377,2.34174 48.936016,2.341544 48.936823,2.340952 48.938158,2.340376 48.939505,2.340023 48.940246,2.339372 48.941188,2.338337 48.942576,2.339435 48.943421,2.339733 48.943615,2.340627 48.944032,2.340491 48.944136,2.340764 48.944314,2.339225 48.945349,2.338561 48.94476,2.337946 48.944968,2.337896 48.94497,2.337511 48.944728,2.336987 48.944953,2.337061 48.945013,2.33687 48.94513,2.337763 48.945974,2.337576 48.946136,2.337873 48.946627,2.339379 48.947632,2.342794 48.946936,2.344586 48.946568,2.344209 48.946325,2.344196 48.946229,2.34472 48.945865,2.346019 48.946384,2.348085 48.947207,2.350577 48.94866,2.352216 48.951457,2.353709 48.954016,2.353661 48.956005,2.353501 48.956809,2.352975 48.956908,2.353577 48.957822,2.354571 48.959248,2.354879 48.959651,2.354004 48.959933,2.353554 48.960093,2.352803 48.960324,2.353061 48.96069,2.352446 48.96114,2.352464 48.961662,2.352905 48.961971,2.353535 48.962379,2.353031 48.962742,2.353549 48.963072,2.353013 48.963441,2.353538 48.963808,2.354017 48.964165,2.354558 48.964631,2.353918 48.964958,2.353496 48.965234,2.353466 48.965624,2.35365 48.965828,2.353925 48.965756,2.354804 48.966903,2.355357 48.967437,2.356533 48.968434,2.356761 48.968659,2.356929 48.968782,2.356559 48.968975,2.356424 48.969096,2.357506 48.970827,2.357928 48.971398,2.358203 48.971815,2.358985 48.972869,2.359531 48.972693,2.36 48.972496,2.360092 48.972481,2.360495 48.972691,2.360807 48.972989,2.361122 48.973348,2.36129 48.973499,2.361562 48.973886,2.361723 48.973965,2.362267 48.973797,2.362672 48.973722,2.362654 48.973658,2.365292 48.973086,2.365523 48.973538,2.365562 48.973691,2.365742 48.974028,2.365966 48.974007,2.368882 48.973034,2.369426 48.972919,2.371702 48.972529,2.372537 48.972369,2.375726 48.972074,2.375558 48.971688,2.375266 48.97096,2.374466 48.969112,2.374274 48.968697,2.374039 48.968112,2.373767 48.967482,2.373678 48.966707,2.373668 48.966499,2.373575 48.965626,2.37351 48.965244,2.373418 48.964149,2.373419 48.963292,2.373468 48.962736,2.373509 48.962572,2.37345 48.962354,2.373317 48.962082,2.373257 48.9617,2.373171 48.960819,2.373115 48.960749,2.373172 48.960623,2.373315 48.960104,2.369034 48.960088,2.36878 48.958962,2.365596 48.958807,2.365487 48.958793,2.365848 48.958054,2.3675 48.954756,2.367677 48.954415,2.368014 48.953875,2.368843 48.952735,2.369135 48.952386,2.369741 48.951064,2.370099 48.950169,2.370361 48.949593,2.370869 48.948593,2.371681 48.946968,2.37276 48.947163,2.373844 48.947369,2.375226 48.947647,2.375538 48.946701,2.375768 48.946195,2.375908 48.945992,2.376435 48.945311,2.377068 48.944551,2.377216 48.944656,2.377482 48.944769,2.377712 48.944813,2.378101 48.944825,2.378586 48.944789,2.379165 48.944796,2.379353 48.944817,2.380184 48.944962,2.38132 48.945196,2.382133 48.945411,2.382344 48.945171,2.382658 48.944652,2.382949 48.944302,2.383116 48.944359,2.383672 48.943516,2.384014 48.943596,2.384439 48.943851,2.384718 48.943729,2.384801 48.943855,2.385476 48.943929,2.385695 48.943898,2.385737 48.944037,2.385887 48.944022,2.386076 48.943941,2.386194 48.944076,2.386495 48.944205,2.387445 48.944472,2.387604 48.944566,2.387762 48.944795,2.387899 48.94484,2.388186 48.944862,2.388753 48.945003,2.389753 48.945345,2.390107 48.945427,2.390154 48.945472,2.390123 48.945769,2.38984 48.946183,2.389739 48.946418,2.389741 48.946692,2.389818 48.946777,2.390279 48.946958,2.391063 48.947051,2.391917 48.947397,2.392557 48.947614,2.392804 48.94772,2.393236 48.947852,2.393642 48.947931,2.393839 48.948024,2.394099 48.948233,2.394228 48.948378,2.394516 48.948398,2.394719 48.948466,2.394927 48.948755,2.395192 48.948834,2.395321 48.948923,2.395567 48.949388,2.395775 48.949321,2.396191 48.949279,2.397007 48.949453,2.397284 48.949657,2.397703 48.949452,2.397786 48.949323,2.398159 48.948978,2.397419 48.94866,2.397699 48.948616,2.398154 48.948218,2.398146 48.948111,2.398041 48.947819,2.397964 48.947689,2.397691 48.947509,2.397656 48.947401,2.397485 48.947402,2.397325 48.947043,2.397203 48.946918,2.397021 48.946544,2.396807 48.946205,2.39654 48.94589,2.396108 48.945483,2.395681 48.945186,2.39533 48.94499,2.394991 48.944755,2.394419 48.94444,2.393958 48.94424,2.393234 48.943979,2.392207 48.943563,2.390395 48.942942,2.389567 48.942665,2.38887 48.942447,2.388341 48.942346,2.387422 48.942222,2.387581 48.941394,2.385785 48.9409,2.385592 48.940841,2.384652 48.940304,2.384167 48.937218,2.383477 48.933507,2.383348 48.932837,2.383932 48.932505,2.382948 48.931335,2.382506 48.930783,2.381751 48.931104,2.381123 48.931336,2.38077 48.931402,2.379649 48.931587,2.378972 48.931687,2.377614 48.931836,2.376657 48.930211,2.375104 48.927685,2.37537 48.927526,2.376784 48.926278,2.377072 48.926001,2.377835 48.925347,2.374635 48.923839,2.37475 48.923775)))"
  ]
  "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 => 26727
  ]
  "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 => 26727
  ]
  "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 => 26727
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#709
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

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

[
  "sql" => """
    \n
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(m.geom)) AS lat, ST_X(ST_Centroid(m.geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,\n
           ST_AsGeoJSON(ST_Force2D(m.geom), 6, 0) AS geom_geojson,\n
           COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), bufc.buf)::geography), 0) AS length_m,\n
           CASE\n
             WHEN (tags->'highway') = 'proposed' AND exist(tags, 'proposed') AND (tags->'proposed') = 'cycleway' THEN 'proposed_cycleway'\n
             WHEN (tags->'highway') = 'cycleway' THEN 'separated'\n
             WHEN (tags->'highway') = 'busway' THEN 'separated'\n
             WHEN (tags->'cycleway:both') IN ('track', 'opposite_track', 'separate')\n
                  AND exist(tags, 'highway')\n
                  AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway') THEN 'separated'\n
             WHEN EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%') AND exist(tags, 'highway')\n
                  AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway') THEN 'lane'\n
             WHEN (exist(tags, 'bicycle') AND (tags->'bicycle') IS NOT NULL AND (tags->'bicycle') <> 'no') AND exist(tags, 'highway')\n
                  AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway')\n
                  AND NOT (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%')) THEN 'designated'\n
             ELSE NULL\n
           END AS cycleway_category\n
    FROM osm_object_meta m\n
    CROSS JOIN (SELECT ST_MakeValid(ST_SetSRID(ST_GeomFromText(?), 4326)) AS poly) z\n
    CROSS JOIN LATERAL (SELECT ST_Buffer(z.poly::geography, ?)::geometry AS buf) bufc\n
    WHERE m.geom IS NOT NULL\n
      AND m.osm_type IN ('way', 'relation')\n
      AND ST_Intersects(m.geom, bufc.buf)\n
      AND (\n
        (tags->'highway') = 'proposed' AND exist(tags, 'proposed') AND (tags->'proposed') = 'cycleway'\n
        OR (tags->'highway') IN ('cycleway', 'busway')\n
        OR (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%') AND exist(tags, 'highway')\n
            AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway'))\n
        OR ((exist(tags, 'bicycle') AND (tags->'bicycle') IS NOT NULL AND (tags->'bicycle') <> 'no') AND exist(tags, 'highway')\n
            AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway'))\n
      )\n
    """
  "params" => [
    1 => "MULTIPOLYGON(((2.37475 48.923775,2.373992 48.92362,2.373501 48.923483,2.373049 48.923301,2.372551 48.923037,2.371994 48.922454,2.37124 48.922745,2.37048 48.923093,2.370107 48.923235,2.36943 48.923601,2.368645 48.924175,2.368299 48.924466,2.367232 48.923853,2.366987 48.923737,2.366675 48.923548,2.367136 48.922808,2.367614 48.922075,2.36685 48.921756,2.366138 48.921474,2.366524 48.920946,2.366906 48.920964,2.366839 48.92043,2.366815 48.919686,2.366848 48.919486,2.366864 48.918699,2.36694 48.917842,2.366338 48.917865,2.366315 48.916446,2.366394 48.915387,2.366707 48.915374,2.366675 48.915166,2.36631 48.913233,2.365984 48.911168,2.365702 48.909447,2.36568 48.909216,2.365962 48.906788,2.365968 48.904868,2.365876 48.903888,2.36562 48.901758,2.355239 48.901548,2.351984 48.901485,2.351839 48.902356,2.351825 48.902523,2.351691 48.903079,2.3516 48.903602,2.351543 48.903686,2.35143 48.90453,2.351354 48.905335,2.35122 48.907183,2.35119 48.907462,2.351234 48.907588,2.351602 48.908129,2.351644 48.908347,2.351461 48.909275,2.351477 48.909378,2.351353 48.910066,2.351269 48.910322,2.351054 48.910718,2.350838 48.910948,2.349757 48.911026,2.348885 48.911017,2.348398 48.910991,2.348254 48.911395,2.347058 48.914382,2.34572 48.914074,2.345229 48.914019,2.344674 48.914028,2.343225 48.914179,2.340527 48.914487,2.340078 48.914545,2.339601 48.914627,2.339081 48.914746,2.33851 48.914917,2.337802 48.915217,2.338118 48.915947,2.33911 48.918067,2.339244 48.918262,2.339621 48.918976,2.340011 48.919618,2.33912 48.919995,2.339153 48.920022,2.337136 48.920926,2.337257 48.920991,2.336993 48.92113,2.336823 48.921103,2.33412 48.922666,2.333246 48.923206,2.33485 48.925018,2.335844 48.926046,2.336386 48.926514,2.336846 48.926959,2.337159 48.927226,2.337497 48.927596,2.337927 48.928036,2.338355 48.928416,2.338986 48.929034,2.339201 48.929276,2.339714 48.92992,2.340018 48.930377,2.340227 48.930629,2.340352 48.930873,2.340657 48.931323,2.340875 48.931731,2.340978 48.932006,2.341242 48.932827,2.341426 48.933334,2.341574 48.933847,2.341657 48.93454,2.341721 48.935377,2.34174 48.936016,2.341544 48.936823,2.340952 48.938158,2.340376 48.939505,2.340023 48.940246,2.339372 48.941188,2.338337 48.942576,2.339435 48.943421,2.339733 48.943615,2.340627 48.944032,2.340491 48.944136,2.340764 48.944314,2.339225 48.945349,2.338561 48.94476,2.337946 48.944968,2.337896 48.94497,2.337511 48.944728,2.336987 48.944953,2.337061 48.945013,2.33687 48.94513,2.337763 48.945974,2.337576 48.946136,2.337873 48.946627,2.339379 48.947632,2.342794 48.946936,2.344586 48.946568,2.344209 48.946325,2.344196 48.946229,2.34472 48.945865,2.346019 48.946384,2.348085 48.947207,2.350577 48.94866,2.352216 48.951457,2.353709 48.954016,2.353661 48.956005,2.353501 48.956809,2.352975 48.956908,2.353577 48.957822,2.354571 48.959248,2.354879 48.959651,2.354004 48.959933,2.353554 48.960093,2.352803 48.960324,2.353061 48.96069,2.352446 48.96114,2.352464 48.961662,2.352905 48.961971,2.353535 48.962379,2.353031 48.962742,2.353549 48.963072,2.353013 48.963441,2.353538 48.963808,2.354017 48.964165,2.354558 48.964631,2.353918 48.964958,2.353496 48.965234,2.353466 48.965624,2.35365 48.965828,2.353925 48.965756,2.354804 48.966903,2.355357 48.967437,2.356533 48.968434,2.356761 48.968659,2.356929 48.968782,2.356559 48.968975,2.356424 48.969096,2.357506 48.970827,2.357928 48.971398,2.358203 48.971815,2.358985 48.972869,2.359531 48.972693,2.36 48.972496,2.360092 48.972481,2.360495 48.972691,2.360807 48.972989,2.361122 48.973348,2.36129 48.973499,2.361562 48.973886,2.361723 48.973965,2.362267 48.973797,2.362672 48.973722,2.362654 48.973658,2.365292 48.973086,2.365523 48.973538,2.365562 48.973691,2.365742 48.974028,2.365966 48.974007,2.368882 48.973034,2.369426 48.972919,2.371702 48.972529,2.372537 48.972369,2.375726 48.972074,2.375558 48.971688,2.375266 48.97096,2.374466 48.969112,2.374274 48.968697,2.374039 48.968112,2.373767 48.967482,2.373678 48.966707,2.373668 48.966499,2.373575 48.965626,2.37351 48.965244,2.373418 48.964149,2.373419 48.963292,2.373468 48.962736,2.373509 48.962572,2.37345 48.962354,2.373317 48.962082,2.373257 48.9617,2.373171 48.960819,2.373115 48.960749,2.373172 48.960623,2.373315 48.960104,2.369034 48.960088,2.36878 48.958962,2.365596 48.958807,2.365487 48.958793,2.365848 48.958054,2.3675 48.954756,2.367677 48.954415,2.368014 48.953875,2.368843 48.952735,2.369135 48.952386,2.369741 48.951064,2.370099 48.950169,2.370361 48.949593,2.370869 48.948593,2.371681 48.946968,2.37276 48.947163,2.373844 48.947369,2.375226 48.947647,2.375538 48.946701,2.375768 48.946195,2.375908 48.945992,2.376435 48.945311,2.377068 48.944551,2.377216 48.944656,2.377482 48.944769,2.377712 48.944813,2.378101 48.944825,2.378586 48.944789,2.379165 48.944796,2.379353 48.944817,2.380184 48.944962,2.38132 48.945196,2.382133 48.945411,2.382344 48.945171,2.382658 48.944652,2.382949 48.944302,2.383116 48.944359,2.383672 48.943516,2.384014 48.943596,2.384439 48.943851,2.384718 48.943729,2.384801 48.943855,2.385476 48.943929,2.385695 48.943898,2.385737 48.944037,2.385887 48.944022,2.386076 48.943941,2.386194 48.944076,2.386495 48.944205,2.387445 48.944472,2.387604 48.944566,2.387762 48.944795,2.387899 48.94484,2.388186 48.944862,2.388753 48.945003,2.389753 48.945345,2.390107 48.945427,2.390154 48.945472,2.390123 48.945769,2.38984 48.946183,2.389739 48.946418,2.389741 48.946692,2.389818 48.946777,2.390279 48.946958,2.391063 48.947051,2.391917 48.947397,2.392557 48.947614,2.392804 48.94772,2.393236 48.947852,2.393642 48.947931,2.393839 48.948024,2.394099 48.948233,2.394228 48.948378,2.394516 48.948398,2.394719 48.948466,2.394927 48.948755,2.395192 48.948834,2.395321 48.948923,2.395567 48.949388,2.395775 48.949321,2.396191 48.949279,2.397007 48.949453,2.397284 48.949657,2.397703 48.949452,2.397786 48.949323,2.398159 48.948978,2.397419 48.94866,2.397699 48.948616,2.398154 48.948218,2.398146 48.948111,2.398041 48.947819,2.397964 48.947689,2.397691 48.947509,2.397656 48.947401,2.397485 48.947402,2.397325 48.947043,2.397203 48.946918,2.397021 48.946544,2.396807 48.946205,2.39654 48.94589,2.396108 48.945483,2.395681 48.945186,2.39533 48.94499,2.394991 48.944755,2.394419 48.94444,2.393958 48.94424,2.393234 48.943979,2.392207 48.943563,2.390395 48.942942,2.389567 48.942665,2.38887 48.942447,2.388341 48.942346,2.387422 48.942222,2.387581 48.941394,2.385785 48.9409,2.385592 48.940841,2.384652 48.940304,2.384167 48.937218,2.383477 48.933507,2.383348 48.932837,2.383932 48.932505,2.382948 48.931335,2.382506 48.930783,2.381751 48.931104,2.381123 48.931336,2.38077 48.931402,2.379649 48.931587,2.378972 48.931687,2.377614 48.931836,2.376657 48.930211,2.375104 48.927685,2.37537 48.927526,2.376784 48.926278,2.377072 48.926001,2.377835 48.925347,2.374635 48.923839,2.37475 48.923775)))"
    2 => 2000.0
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#588}
  ]
]

[
  "sql" => "SELECT 1"
]

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

[
  "sql" => """
    \n
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(m.geom)) AS lat, ST_X(ST_Centroid(m.geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,\n
           ST_AsGeoJSON(ST_Force2D(m.geom), 6, 0) AS geom_geojson,\n
           COALESCE(ST_Length(ST_Intersection(ST_MakeValid(m.geom), z.poly)::geography), 0) AS length_m\n
    FROM osm_object_meta m\n
    CROSS JOIN (SELECT ST_MakeValid(ST_SetSRID(ST_GeomFromText(?), 4326)) AS poly) z\n
    WHERE m.geom IS NOT NULL\n
      AND m.osm_type IN ('way', 'relation')\n
      AND ST_Intersects(m.geom, z.poly)\n
      AND exist(tags, 'highway')\n
      AND (tags->'highway') NOT IN (\n
        'motorway', 'motorway_link', 'trunk', 'trunk_link',\n
        'footway', 'steps', 'pedestrian', 'bridleway', 'raceway',\n
        'cycleway', 'busway', 'construction', 'proposed'\n
      )\n
      AND (tags->'oneway') IN ('yes', '-1', '1')\n
      AND NOT ( (tags->'highway') IN ('cycleway', 'busway')\n
        OR (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%') AND exist(tags, 'highway') AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway'))\n
        OR ((exist(tags, 'bicycle') AND (tags->'bicycle') IS NOT NULL AND (tags->'bicycle') <> 'no') AND exist(tags, 'highway') AND (tags->'highway') IS NOT NULL AND (tags->'highway') NOT IN ('cycleway', 'busway') AND NOT (EXISTS (SELECT 1 FROM unnest(akeys(tags)) k WHERE k = 'cycleway' OR k LIKE 'cycleway:%'))))\n
      AND NOT ((tags->'oneway:bicycle') = 'no')\n
    """
  "params" => [
    1 => "MULTIPOLYGON(((2.37475 48.923775,2.373992 48.92362,2.373501 48.923483,2.373049 48.923301,2.372551 48.923037,2.371994 48.922454,2.37124 48.922745,2.37048 48.923093,2.370107 48.923235,2.36943 48.923601,2.368645 48.924175,2.368299 48.924466,2.367232 48.923853,2.366987 48.923737,2.366675 48.923548,2.367136 48.922808,2.367614 48.922075,2.36685 48.921756,2.366138 48.921474,2.366524 48.920946,2.366906 48.920964,2.366839 48.92043,2.366815 48.919686,2.366848 48.919486,2.366864 48.918699,2.36694 48.917842,2.366338 48.917865,2.366315 48.916446,2.366394 48.915387,2.366707 48.915374,2.366675 48.915166,2.36631 48.913233,2.365984 48.911168,2.365702 48.909447,2.36568 48.909216,2.365962 48.906788,2.365968 48.904868,2.365876 48.903888,2.36562 48.901758,2.355239 48.901548,2.351984 48.901485,2.351839 48.902356,2.351825 48.902523,2.351691 48.903079,2.3516 48.903602,2.351543 48.903686,2.35143 48.90453,2.351354 48.905335,2.35122 48.907183,2.35119 48.907462,2.351234 48.907588,2.351602 48.908129,2.351644 48.908347,2.351461 48.909275,2.351477 48.909378,2.351353 48.910066,2.351269 48.910322,2.351054 48.910718,2.350838 48.910948,2.349757 48.911026,2.348885 48.911017,2.348398 48.910991,2.348254 48.911395,2.347058 48.914382,2.34572 48.914074,2.345229 48.914019,2.344674 48.914028,2.343225 48.914179,2.340527 48.914487,2.340078 48.914545,2.339601 48.914627,2.339081 48.914746,2.33851 48.914917,2.337802 48.915217,2.338118 48.915947,2.33911 48.918067,2.339244 48.918262,2.339621 48.918976,2.340011 48.919618,2.33912 48.919995,2.339153 48.920022,2.337136 48.920926,2.337257 48.920991,2.336993 48.92113,2.336823 48.921103,2.33412 48.922666,2.333246 48.923206,2.33485 48.925018,2.335844 48.926046,2.336386 48.926514,2.336846 48.926959,2.337159 48.927226,2.337497 48.927596,2.337927 48.928036,2.338355 48.928416,2.338986 48.929034,2.339201 48.929276,2.339714 48.92992,2.340018 48.930377,2.340227 48.930629,2.340352 48.930873,2.340657 48.931323,2.340875 48.931731,2.340978 48.932006,2.341242 48.932827,2.341426 48.933334,2.341574 48.933847,2.341657 48.93454,2.341721 48.935377,2.34174 48.936016,2.341544 48.936823,2.340952 48.938158,2.340376 48.939505,2.340023 48.940246,2.339372 48.941188,2.338337 48.942576,2.339435 48.943421,2.339733 48.943615,2.340627 48.944032,2.340491 48.944136,2.340764 48.944314,2.339225 48.945349,2.338561 48.94476,2.337946 48.944968,2.337896 48.94497,2.337511 48.944728,2.336987 48.944953,2.337061 48.945013,2.33687 48.94513,2.337763 48.945974,2.337576 48.946136,2.337873 48.946627,2.339379 48.947632,2.342794 48.946936,2.344586 48.946568,2.344209 48.946325,2.344196 48.946229,2.34472 48.945865,2.346019 48.946384,2.348085 48.947207,2.350577 48.94866,2.352216 48.951457,2.353709 48.954016,2.353661 48.956005,2.353501 48.956809,2.352975 48.956908,2.353577 48.957822,2.354571 48.959248,2.354879 48.959651,2.354004 48.959933,2.353554 48.960093,2.352803 48.960324,2.353061 48.96069,2.352446 48.96114,2.352464 48.961662,2.352905 48.961971,2.353535 48.962379,2.353031 48.962742,2.353549 48.963072,2.353013 48.963441,2.353538 48.963808,2.354017 48.964165,2.354558 48.964631,2.353918 48.964958,2.353496 48.965234,2.353466 48.965624,2.35365 48.965828,2.353925 48.965756,2.354804 48.966903,2.355357 48.967437,2.356533 48.968434,2.356761 48.968659,2.356929 48.968782,2.356559 48.968975,2.356424 48.969096,2.357506 48.970827,2.357928 48.971398,2.358203 48.971815,2.358985 48.972869,2.359531 48.972693,2.36 48.972496,2.360092 48.972481,2.360495 48.972691,2.360807 48.972989,2.361122 48.973348,2.36129 48.973499,2.361562 48.973886,2.361723 48.973965,2.362267 48.973797,2.362672 48.973722,2.362654 48.973658,2.365292 48.973086,2.365523 48.973538,2.365562 48.973691,2.365742 48.974028,2.365966 48.974007,2.368882 48.973034,2.369426 48.972919,2.371702 48.972529,2.372537 48.972369,2.375726 48.972074,2.375558 48.971688,2.375266 48.97096,2.374466 48.969112,2.374274 48.968697,2.374039 48.968112,2.373767 48.967482,2.373678 48.966707,2.373668 48.966499,2.373575 48.965626,2.37351 48.965244,2.373418 48.964149,2.373419 48.963292,2.373468 48.962736,2.373509 48.962572,2.37345 48.962354,2.373317 48.962082,2.373257 48.9617,2.373171 48.960819,2.373115 48.960749,2.373172 48.960623,2.373315 48.960104,2.369034 48.960088,2.36878 48.958962,2.365596 48.958807,2.365487 48.958793,2.365848 48.958054,2.3675 48.954756,2.367677 48.954415,2.368014 48.953875,2.368843 48.952735,2.369135 48.952386,2.369741 48.951064,2.370099 48.950169,2.370361 48.949593,2.370869 48.948593,2.371681 48.946968,2.37276 48.947163,2.373844 48.947369,2.375226 48.947647,2.375538 48.946701,2.375768 48.946195,2.375908 48.945992,2.376435 48.945311,2.377068 48.944551,2.377216 48.944656,2.377482 48.944769,2.377712 48.944813,2.378101 48.944825,2.378586 48.944789,2.379165 48.944796,2.379353 48.944817,2.380184 48.944962,2.38132 48.945196,2.382133 48.945411,2.382344 48.945171,2.382658 48.944652,2.382949 48.944302,2.383116 48.944359,2.383672 48.943516,2.384014 48.943596,2.384439 48.943851,2.384718 48.943729,2.384801 48.943855,2.385476 48.943929,2.385695 48.943898,2.385737 48.944037,2.385887 48.944022,2.386076 48.943941,2.386194 48.944076,2.386495 48.944205,2.387445 48.944472,2.387604 48.944566,2.387762 48.944795,2.387899 48.94484,2.388186 48.944862,2.388753 48.945003,2.389753 48.945345,2.390107 48.945427,2.390154 48.945472,2.390123 48.945769,2.38984 48.946183,2.389739 48.946418,2.389741 48.946692,2.389818 48.946777,2.390279 48.946958,2.391063 48.947051,2.391917 48.947397,2.392557 48.947614,2.392804 48.94772,2.393236 48.947852,2.393642 48.947931,2.393839 48.948024,2.394099 48.948233,2.394228 48.948378,2.394516 48.948398,2.394719 48.948466,2.394927 48.948755,2.395192 48.948834,2.395321 48.948923,2.395567 48.949388,2.395775 48.949321,2.396191 48.949279,2.397007 48.949453,2.397284 48.949657,2.397703 48.949452,2.397786 48.949323,2.398159 48.948978,2.397419 48.94866,2.397699 48.948616,2.398154 48.948218,2.398146 48.948111,2.398041 48.947819,2.397964 48.947689,2.397691 48.947509,2.397656 48.947401,2.397485 48.947402,2.397325 48.947043,2.397203 48.946918,2.397021 48.946544,2.396807 48.946205,2.39654 48.94589,2.396108 48.945483,2.395681 48.945186,2.39533 48.94499,2.394991 48.944755,2.394419 48.94444,2.393958 48.94424,2.393234 48.943979,2.392207 48.943563,2.390395 48.942942,2.389567 48.942665,2.38887 48.942447,2.388341 48.942346,2.387422 48.942222,2.387581 48.941394,2.385785 48.9409,2.385592 48.940841,2.384652 48.940304,2.384167 48.937218,2.383477 48.933507,2.383348 48.932837,2.383932 48.932505,2.382948 48.931335,2.382506 48.930783,2.381751 48.931104,2.381123 48.931336,2.38077 48.931402,2.379649 48.931587,2.378972 48.931687,2.377614 48.931836,2.376657 48.930211,2.375104 48.927685,2.37537 48.927526,2.376784 48.926278,2.377072 48.926001,2.377835 48.925347,2.374635 48.923839,2.37475 48.923775)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT 1"
]

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

[
  "sql" => """
    SELECT osm_type, osm_id::text AS osm_id,\n
           ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,\n
           tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid\n
    FROM osm_object_meta m\n
    WHERE geom IS NOT NULL\n
      AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
      AND (tags->'man_made') = 'monitoring_station'\n
      AND (tags->'monitoring:bicycle') = 'yes'
    """
  "params" => [
    1 => "MULTIPOLYGON(((2.37475 48.923775,2.373992 48.92362,2.373501 48.923483,2.373049 48.923301,2.372551 48.923037,2.371994 48.922454,2.37124 48.922745,2.37048 48.923093,2.370107 48.923235,2.36943 48.923601,2.368645 48.924175,2.368299 48.924466,2.367232 48.923853,2.366987 48.923737,2.366675 48.923548,2.367136 48.922808,2.367614 48.922075,2.36685 48.921756,2.366138 48.921474,2.366524 48.920946,2.366906 48.920964,2.366839 48.92043,2.366815 48.919686,2.366848 48.919486,2.366864 48.918699,2.36694 48.917842,2.366338 48.917865,2.366315 48.916446,2.366394 48.915387,2.366707 48.915374,2.366675 48.915166,2.36631 48.913233,2.365984 48.911168,2.365702 48.909447,2.36568 48.909216,2.365962 48.906788,2.365968 48.904868,2.365876 48.903888,2.36562 48.901758,2.355239 48.901548,2.351984 48.901485,2.351839 48.902356,2.351825 48.902523,2.351691 48.903079,2.3516 48.903602,2.351543 48.903686,2.35143 48.90453,2.351354 48.905335,2.35122 48.907183,2.35119 48.907462,2.351234 48.907588,2.351602 48.908129,2.351644 48.908347,2.351461 48.909275,2.351477 48.909378,2.351353 48.910066,2.351269 48.910322,2.351054 48.910718,2.350838 48.910948,2.349757 48.911026,2.348885 48.911017,2.348398 48.910991,2.348254 48.911395,2.347058 48.914382,2.34572 48.914074,2.345229 48.914019,2.344674 48.914028,2.343225 48.914179,2.340527 48.914487,2.340078 48.914545,2.339601 48.914627,2.339081 48.914746,2.33851 48.914917,2.337802 48.915217,2.338118 48.915947,2.33911 48.918067,2.339244 48.918262,2.339621 48.918976,2.340011 48.919618,2.33912 48.919995,2.339153 48.920022,2.337136 48.920926,2.337257 48.920991,2.336993 48.92113,2.336823 48.921103,2.33412 48.922666,2.333246 48.923206,2.33485 48.925018,2.335844 48.926046,2.336386 48.926514,2.336846 48.926959,2.337159 48.927226,2.337497 48.927596,2.337927 48.928036,2.338355 48.928416,2.338986 48.929034,2.339201 48.929276,2.339714 48.92992,2.340018 48.930377,2.340227 48.930629,2.340352 48.930873,2.340657 48.931323,2.340875 48.931731,2.340978 48.932006,2.341242 48.932827,2.341426 48.933334,2.341574 48.933847,2.341657 48.93454,2.341721 48.935377,2.34174 48.936016,2.341544 48.936823,2.340952 48.938158,2.340376 48.939505,2.340023 48.940246,2.339372 48.941188,2.338337 48.942576,2.339435 48.943421,2.339733 48.943615,2.340627 48.944032,2.340491 48.944136,2.340764 48.944314,2.339225 48.945349,2.338561 48.94476,2.337946 48.944968,2.337896 48.94497,2.337511 48.944728,2.336987 48.944953,2.337061 48.945013,2.33687 48.94513,2.337763 48.945974,2.337576 48.946136,2.337873 48.946627,2.339379 48.947632,2.342794 48.946936,2.344586 48.946568,2.344209 48.946325,2.344196 48.946229,2.34472 48.945865,2.346019 48.946384,2.348085 48.947207,2.350577 48.94866,2.352216 48.951457,2.353709 48.954016,2.353661 48.956005,2.353501 48.956809,2.352975 48.956908,2.353577 48.957822,2.354571 48.959248,2.354879 48.959651,2.354004 48.959933,2.353554 48.960093,2.352803 48.960324,2.353061 48.96069,2.352446 48.96114,2.352464 48.961662,2.352905 48.961971,2.353535 48.962379,2.353031 48.962742,2.353549 48.963072,2.353013 48.963441,2.353538 48.963808,2.354017 48.964165,2.354558 48.964631,2.353918 48.964958,2.353496 48.965234,2.353466 48.965624,2.35365 48.965828,2.353925 48.965756,2.354804 48.966903,2.355357 48.967437,2.356533 48.968434,2.356761 48.968659,2.356929 48.968782,2.356559 48.968975,2.356424 48.969096,2.357506 48.970827,2.357928 48.971398,2.358203 48.971815,2.358985 48.972869,2.359531 48.972693,2.36 48.972496,2.360092 48.972481,2.360495 48.972691,2.360807 48.972989,2.361122 48.973348,2.36129 48.973499,2.361562 48.973886,2.361723 48.973965,2.362267 48.973797,2.362672 48.973722,2.362654 48.973658,2.365292 48.973086,2.365523 48.973538,2.365562 48.973691,2.365742 48.974028,2.365966 48.974007,2.368882 48.973034,2.369426 48.972919,2.371702 48.972529,2.372537 48.972369,2.375726 48.972074,2.375558 48.971688,2.375266 48.97096,2.374466 48.969112,2.374274 48.968697,2.374039 48.968112,2.373767 48.967482,2.373678 48.966707,2.373668 48.966499,2.373575 48.965626,2.37351 48.965244,2.373418 48.964149,2.373419 48.963292,2.373468 48.962736,2.373509 48.962572,2.37345 48.962354,2.373317 48.962082,2.373257 48.9617,2.373171 48.960819,2.373115 48.960749,2.373172 48.960623,2.373315 48.960104,2.369034 48.960088,2.36878 48.958962,2.365596 48.958807,2.365487 48.958793,2.365848 48.958054,2.3675 48.954756,2.367677 48.954415,2.368014 48.953875,2.368843 48.952735,2.369135 48.952386,2.369741 48.951064,2.370099 48.950169,2.370361 48.949593,2.370869 48.948593,2.371681 48.946968,2.37276 48.947163,2.373844 48.947369,2.375226 48.947647,2.375538 48.946701,2.375768 48.946195,2.375908 48.945992,2.376435 48.945311,2.377068 48.944551,2.377216 48.944656,2.377482 48.944769,2.377712 48.944813,2.378101 48.944825,2.378586 48.944789,2.379165 48.944796,2.379353 48.944817,2.380184 48.944962,2.38132 48.945196,2.382133 48.945411,2.382344 48.945171,2.382658 48.944652,2.382949 48.944302,2.383116 48.944359,2.383672 48.943516,2.384014 48.943596,2.384439 48.943851,2.384718 48.943729,2.384801 48.943855,2.385476 48.943929,2.385695 48.943898,2.385737 48.944037,2.385887 48.944022,2.386076 48.943941,2.386194 48.944076,2.386495 48.944205,2.387445 48.944472,2.387604 48.944566,2.387762 48.944795,2.387899 48.94484,2.388186 48.944862,2.388753 48.945003,2.389753 48.945345,2.390107 48.945427,2.390154 48.945472,2.390123 48.945769,2.38984 48.946183,2.389739 48.946418,2.389741 48.946692,2.389818 48.946777,2.390279 48.946958,2.391063 48.947051,2.391917 48.947397,2.392557 48.947614,2.392804 48.94772,2.393236 48.947852,2.393642 48.947931,2.393839 48.948024,2.394099 48.948233,2.394228 48.948378,2.394516 48.948398,2.394719 48.948466,2.394927 48.948755,2.395192 48.948834,2.395321 48.948923,2.395567 48.949388,2.395775 48.949321,2.396191 48.949279,2.397007 48.949453,2.397284 48.949657,2.397703 48.949452,2.397786 48.949323,2.398159 48.948978,2.397419 48.94866,2.397699 48.948616,2.398154 48.948218,2.398146 48.948111,2.398041 48.947819,2.397964 48.947689,2.397691 48.947509,2.397656 48.947401,2.397485 48.947402,2.397325 48.947043,2.397203 48.946918,2.397021 48.946544,2.396807 48.946205,2.39654 48.94589,2.396108 48.945483,2.395681 48.945186,2.39533 48.94499,2.394991 48.944755,2.394419 48.94444,2.393958 48.94424,2.393234 48.943979,2.392207 48.943563,2.390395 48.942942,2.389567 48.942665,2.38887 48.942447,2.388341 48.942346,2.387422 48.942222,2.387581 48.941394,2.385785 48.9409,2.385592 48.940841,2.384652 48.940304,2.384167 48.937218,2.383477 48.933507,2.383348 48.932837,2.383932 48.932505,2.382948 48.931335,2.382506 48.930783,2.381751 48.931104,2.381123 48.931336,2.38077 48.931402,2.379649 48.931587,2.378972 48.931687,2.377614 48.931836,2.376657 48.930211,2.375104 48.927685,2.37537 48.927526,2.376784 48.926278,2.377072 48.926001,2.377835 48.925347,2.374635 48.923839,2.37475 48.923775)))"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#588
      +name: "STRING"
    }
  ]
]

[
  "sql" => """
    SELECT osm_type, osm_id::text AS osm_id,\n
                    ST_Y(ST_Centroid(geom)) AS lat, ST_X(ST_Centroid(geom)) AS lon,\n
                    tags::jsonb AS tags_json, version, osm_timestamp, changeset, osm_user, uid::bigint AS uid,\n
                    ST_AsGeoJSON(ST_Force2D(geom), 6, 0) AS geom_geojson\n
                FROM osm_object_meta m\n
                WHERE geom IS NOT NULL AND ST_Intersects(m.geom, ST_GeomFromText(?, 4326))\n
                  AND osm_type IN ('way', 'relation')\n
                  AND (tags->'highway') IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
    """
  "params" => [
    1 => "MULTIPOLYGON(((2.37475 48.923775,2.373992 48.92362,2.373501 48.923483,2.373049 48.923301,2.372551 48.923037,2.371994 48.922454,2.37124 48.922745,2.37048 48.923093,2.370107 48.923235,2.36943 48.923601,2.368645 48.924175,2.368299 48.924466,2.367232 48.923853,2.366987 48.923737,2.366675 48.923548,2.367136 48.922808,2.367614 48.922075,2.36685 48.921756,2.366138 48.921474,2.366524 48.920946,2.366906 48.920964,2.366839 48.92043,2.366815 48.919686,2.366848 48.919486,2.366864 48.918699,2.36694 48.917842,2.366338 48.917865,2.366315 48.916446,2.366394 48.915387,2.366707 48.915374,2.366675 48.915166,2.36631 48.913233,2.365984 48.911168,2.365702 48.909447,2.36568 48.909216,2.365962 48.906788,2.365968 48.904868,2.365876 48.903888,2.36562 48.901758,2.355239 48.901548,2.351984 48.901485,2.351839 48.902356,2.351825 48.902523,2.351691 48.903079,2.3516 48.903602,2.351543 48.903686,2.35143 48.90453,2.351354 48.905335,2.35122 48.907183,2.35119 48.907462,2.351234 48.907588,2.351602 48.908129,2.351644 48.908347,2.351461 48.909275,2.351477 48.909378,2.351353 48.910066,2.351269 48.910322,2.351054 48.910718,2.350838 48.910948,2.349757 48.911026,2.348885 48.911017,2.348398 48.910991,2.348254 48.911395,2.347058 48.914382,2.34572 48.914074,2.345229 48.914019,2.344674 48.914028,2.343225 48.914179,2.340527 48.914487,2.340078 48.914545,2.339601 48.914627,2.339081 48.914746,2.33851 48.914917,2.337802 48.915217,2.338118 48.915947,2.33911 48.918067,2.339244 48.918262,2.339621 48.918976,2.340011 48.919618,2.33912 48.919995,2.339153 48.920022,2.337136 48.920926,2.337257 48.920991,2.336993 48.92113,2.336823 48.921103,2.33412 48.922666,2.333246 48.923206,2.33485 48.925018,2.335844 48.926046,2.336386 48.926514,2.336846 48.926959,2.337159 48.927226,2.337497 48.927596,2.337927 48.928036,2.338355 48.928416,2.338986 48.929034,2.339201 48.929276,2.339714 48.92992,2.340018 48.930377,2.340227 48.930629,2.340352 48.930873,2.340657 48.931323,2.340875 48.931731,2.340978 48.932006,2.341242 48.932827,2.341426 48.933334,2.341574 48.933847,2.341657 48.93454,2.341721 48.935377,2.34174 48.936016,2.341544 48.936823,2.340952 48.938158,2.340376 48.939505,2.340023 48.940246,2.339372 48.941188,2.338337 48.942576,2.339435 48.943421,2.339733 48.943615,2.340627 48.944032,2.340491 48.944136,2.340764 48.944314,2.339225 48.945349,2.338561 48.94476,2.337946 48.944968,2.337896 48.94497,2.337511 48.944728,2.336987 48.944953,2.337061 48.945013,2.33687 48.94513,2.337763 48.945974,2.337576 48.946136,2.337873 48.946627,2.339379 48.947632,2.342794 48.946936,2.344586 48.946568,2.344209 48.946325,2.344196 48.946229,2.34472 48.945865,2.346019 48.946384,2.348085 48.947207,2.350577 48.94866,2.352216 48.951457,2.353709 48.954016,2.353661 48.956005,2.353501 48.956809,2.352975 48.956908,2.353577 48.957822,2.354571 48.959248,2.354879 48.959651,2.354004 48.959933,2.353554 48.960093,2.352803 48.960324,2.353061 48.96069,2.352446 48.96114,2.352464 48.961662,2.352905 48.961971,2.353535 48.962379,2.353031 48.962742,2.353549 48.963072,2.353013 48.963441,2.353538 48.963808,2.354017 48.964165,2.354558 48.964631,2.353918 48.964958,2.353496 48.965234,2.353466 48.965624,2.35365 48.965828,2.353925 48.965756,2.354804 48.966903,2.355357 48.967437,2.356533 48.968434,2.356761 48.968659,2.356929 48.968782,2.356559 48.968975,2.356424 48.969096,2.357506 48.970827,2.357928 48.971398,2.358203 48.971815,2.358985 48.972869,2.359531 48.972693,2.36 48.972496,2.360092 48.972481,2.360495 48.972691,2.360807 48.972989,2.361122 48.973348,2.36129 48.973499,2.361562 48.973886,2.361723 48.973965,2.362267 48.973797,2.362672 48.973722,2.362654 48.973658,2.365292 48.973086,2.365523 48.973538,2.365562 48.973691,2.365742 48.974028,2.365966 48.974007,2.368882 48.973034,2.369426 48.972919,2.371702 48.972529,2.372537 48.972369,2.375726 48.972074,2.375558 48.971688,2.375266 48.97096,2.374466 48.969112,2.374274 48.968697,2.374039 48.968112,2.373767 48.967482,2.373678 48.966707,2.373668 48.966499,2.373575 48.965626,2.37351 48.965244,2.373418 48.964149,2.373419 48.963292,2.373468 48.962736,2.373509 48.962572,2.37345 48.962354,2.373317 48.962082,2.373257 48.9617,2.373171 48.960819,2.373115 48.960749,2.373172 48.960623,2.373315 48.960104,2.369034 48.960088,2.36878 48.958962,2.365596 48.958807,2.365487 48.958793,2.365848 48.958054,2.3675 48.954756,2.367677 48.954415,2.368014 48.953875,2.368843 48.952735,2.369135 48.952386,2.369741 48.951064,2.370099 48.950169,2.370361 48.949593,2.370869 48.948593,2.371681 48.946968,2.37276 48.947163,2.373844 48.947369,2.375226 48.947647,2.375538 48.946701,2.375768 48.946195,2.375908 48.945992,2.376435 48.945311,2.377068 48.944551,2.377216 48.944656,2.377482 48.944769,2.377712 48.944813,2.378101 48.944825,2.378586 48.944789,2.379165 48.944796,2.379353 48.944817,2.380184 48.944962,2.38132 48.945196,2.382133 48.945411,2.382344 48.945171,2.382658 48.944652,2.382949 48.944302,2.383116 48.944359,2.383672 48.943516,2.384014 48.943596,2.384439 48.943851,2.384718 48.943729,2.384801 48.943855,2.385476 48.943929,2.385695 48.943898,2.385737 48.944037,2.385887 48.944022,2.386076 48.943941,2.386194 48.944076,2.386495 48.944205,2.387445 48.944472,2.387604 48.944566,2.387762 48.944795,2.387899 48.94484,2.388186 48.944862,2.388753 48.945003,2.389753 48.945345,2.390107 48.945427,2.390154 48.945472,2.390123 48.945769,2.38984 48.946183,2.389739 48.946418,2.389741 48.946692,2.389818 48.946777,2.390279 48.946958,2.391063 48.947051,2.391917 48.947397,2.392557 48.947614,2.392804 48.94772,2.393236 48.947852,2.393642 48.947931,2.393839 48.948024,2.394099 48.948233,2.394228 48.948378,2.394516 48.948398,2.394719 48.948466,2.394927 48.948755,2.395192 48.948834,2.395321 48.948923,2.395567 48.949388,2.395775 48.949321,2.396191 48.949279,2.397007 48.949453,2.397284 48.949657,2.397703 48.949452,2.397786 48.949323,2.398159 48.948978,2.397419 48.94866,2.397699 48.948616,2.398154 48.948218,2.398146 48.948111,2.398041 48.947819,2.397964 48.947689,2.397691 48.947509,2.397656 48.947401,2.397485 48.947402,2.397325 48.947043,2.397203 48.946918,2.397021 48.946544,2.396807 48.946205,2.39654 48.94589,2.396108 48.945483,2.395681 48.945186,2.39533 48.94499,2.394991 48.944755,2.394419 48.94444,2.393958 48.94424,2.393234 48.943979,2.392207 48.943563,2.390395 48.942942,2.389567 48.942665,2.38887 48.942447,2.388341 48.942346,2.387422 48.942222,2.387581 48.941394,2.385785 48.9409,2.385592 48.940841,2.384652 48.940304,2.384167 48.937218,2.383477 48.933507,2.383348 48.932837,2.383932 48.932505,2.382948 48.931335,2.382506 48.930783,2.381751 48.931104,2.381123 48.931336,2.38077 48.931402,2.379649 48.931587,2.378972 48.931687,2.377614 48.931836,2.376657 48.930211,2.375104 48.927685,2.37537 48.927526,2.376784 48.926278,2.377072 48.926001,2.377835 48.925347,2.374635 48.923839,2.37475 48.923775)))"
    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"
]