Mark Litwintschik

I built a new test to make sure the filenames lined up but I'm still seeing the same issue. ```bash $ unzip -l test.zip ``` ``` Archive: test.zip Length Date...

Give me a day or so to put together an easy-to-repeat example with a PostGIS script for a performance comparison.

Download gNATSGO_CA.zip from https://nrcs.app.box.com/v/soils/folder/191785692827 (ignore the login / signup box, the download will start anyway). The ZIP is 694 MB. `a00000020.gdbtable` within that ZIP is 2.2 GB. ```bash $ unzip...

The describe statement is near-instant. It would be nice to produce default settings that avoid full-file scans by default so that `ST_READ` on its own is more or less all...

Okay, let's do that. I'll then have another go with this file and report back. I'm surprised 65K "features", whatever that is measuring, took 30+ seconds to go through.

I rebuilt the master branch and I'm seeing a 3x speed up but it's still ~10 seconds. ``` $ GEN=ninja make release mkdir -p build/release && \ cmake -G "Ninja"...

The spatial index is really what makes GPKG special. I know we can do spatial sorting with community extensions in PQ now but QGIS doesn't yet allow dropping PQ files...

I had a look and its a `MULTIPOLYGON`. ```bash $ git clone https://github.com/scdoshi/us-geojson/ $ ogr2ogr -f GPKG US.gpkg us-geojson/geojson/nation/US.geojson ``` ```bash $ ~/duckdb_spatial/build/release/duckdb -unsigned ``` The `geom` column is a...

Does the above mean there is a way to convert WKT strings into a GEOMETRY or WKB_BLOB type already? ``` D DESCRIBE FROM read_ndjson_auto('shapes_all_low.jsonl') LIMIT 1; ┌─────────────┬─────────────┬─────────┬─────────┬─────────┬─────────┐ │ column_name │...

Okay, thanks.