duckdb

DuckDB with spatial extension

Things I've noted:

DuckDB spatial doesn't seem able to load GeoParquet's 'real' geometry directly (yet??). Need to convert it from WKB first: ddb.sql("CREATE TABLE grid AS SELECT * EXCLUDE geometry, ST_GEOMFROMWKB(geometry) GEO FROM grid")

Name		Name	Last commit message	Last commit date
Latest commit History 17 Commits
__pycache__		__pycache__
.gitignore		.gitignore
MarCadSample.ipynb		MarCadSample.ipynb
MarCadSampleNew.ipynb		MarCadSampleNew.ipynb
README.md		README.md
ais (4).gpkg		ais (4).gpkg
ais.gpkg		ais.gpkg
cargo_sample.csv		cargo_sample.csv
ddb_spatial_tools.py		ddb_spatial_tools.py
demodata_ais.gpkg		demodata_ais.gpkg
duckdb_media.ipynb		duckdb_media.ipynb
duckdb_nyc.ipynb		duckdb_nyc.ipynb
fakeAISdata.ipynb		fakeAISdata.ipynb
gpd_req.txt		gpd_req.txt
grid.csv		grid.csv
grid.parquet		grid.parquet
grid2.geojson		grid2.geojson
grid2.parquet		grid2.parquet
grid3.parquet		grid3.parquet
media.parquet		media.parquet
media2.duckdb		media2.duckdb
movingPandas.ipynb		movingPandas.ipynb
nyc.parquet		nyc.parquet
okok.py		okok.py
read_geop_github.ipynb		read_geop_github.ipynb
requirements.txt		requirements.txt
validate_geoparquet.py		validate_geoparquet.py

Provide feedback