Mark Litwintschik
Mark Litwintschik
I built an ETL script that turns the current download into a parquet file. It has names for every field, is columnar-formatted so it is much quicker to query and...
A lot of roads on the Latvian side of the border with Estonia are marked as Estonian.  Most of Monaco's roads are marked as French. A very small part...
``Oceania-Full.zip`` is 282 MB at the moment. If its GeoJSON file was partitioned by country and sorted the ZIP file would be 244 MB instead. This would allow people to...
The records are marked with `JAP` instead of `JPN`.
This error comes up during installation. ``` Couldn't load plugin 'flight_planner' due to an error when calling its classFactory() method TypeError: 'QVariant' object is not subscriptable Traceback (most recent call...
Any plans to support H3s in uint64 form? This is with v0.10.1 4a89d97db8. ```bash $ aws s3 --no-sign-request cp s3://overturemaps-us-west-2/release/2024-05-16-beta.0/theme=base/type=land_use/part-00065* ./ ``` ```sql COPY ( SELECT geometry, subtype, SUBSTR(update_time, 1,...
This extension was compiled with GDAL 3.6.3 which has support for GeoParquet (it was added in 3.5.1). Any idea why it states for the format is unsupported? ```bash $ /Volumes/Seagate/duckdb_spatial/build/debug/duckdb...
This is running on Arch Linux on my Steam Deck. It has 16 GB of RAM and there is ~200 GB of free space atm. htop reports ~4.2% RES MEM...
The following OSM file is 618 MB. ```bash $ wget https://download.geofabrik.de/australia-oceania/australia-latest.osm.pbf ``` Below are the record counts for each layer. Layer | Record Count ------|------------- Points | 2,659,810 Lines |...
I've compiled the H3 extension for DuckDB and loaded it into the DuckDB binary with your extension. ```bash $ git clone https://github.com/isaacbrodsky/h3-duckdb ./duckdb_h3 $ cd ./duckdb_h3 $ git submodule update...