Enhance your PretzelAI with powerful spatial capabilities using DuckDB's spatial extension, HTTPFS for remote data access, and OGC API Features endpoints.
-- Load spatial extension LOAD spatial; LOAD httpfs; LOAD pivot_table; -- Query remote GeoJSON via HTTPFS CREATE TABLE cities AS SELECT * FROM st_read('https://example.com/data/cities.geojson'); -- Spatial analysis SELECT name, st_area(geometry) AS area, st_length(geometry) AS perimeter FROM cities WHERE st_within(geometry, st_geomfromtext('POLYGON((...))')); -- Create OGC API Features endpoint CALL ogc_api_serve('cities', 8080);
Full integration with DuckDB's spatial extension for advanced geospatial operations including distance calculations, spatial joins, and geometric transformations.
Access remote spatial data directly from HTTP endpoints or ZIP archives with the HTTPFS and ZIPFSX extensions, supporting GeoJSON, Shapefiles, and more.
Summarize and analyze spatial data with powerful pivot tables, grouping by geographic attributes and aggregating spatial metrics.
Serve your spatial data through standards-compliant OGC API Features endpoints, enabling interoperability with GIS software like QGIS and ArcGIS.
Interactive wizard for common spatial operations like buffer creation, intersection analysis, and spatial aggregation with intuitive visual feedback.
Integrated mapping and charting tools to visualize spatial patterns, heatmaps, and temporal trends directly within the interface.
| park_name | buffer_geom |
|---|---|
| Central Park | POLYGON((...)) |
| Riverside Park | POLYGON((...)) |
| Prospect Park | POLYGON((...)) |
Serve your spatial data through standards-compliant OGC API Features endpoints, making your data accessible to any GIS software that supports the standard.
Standards Compliance
Fully compliant with OGC API Features 1.0 specification
High Performance
Leverage DuckDB's speed for fast spatial queries
Secure Access
Optional authentication and rate limiting
The easiest way to get started with all spatial extensions pre-installed.
The Docker image includes all required extensions: spatial, httpfs, zipfsx, pivot_table, and the OGC API server.