Skip to content
DuckDB community extension

raquet

Raster analytics on Raquet files with QUADBIN spatial indexing, raster ingestion, and PostGIS-style functions

01 / SETUP

Install and load

Run these commands in a Haybarn SQL session. The extension is available from the community repository.

Haybarn 2.0.0 · SQL
INSTALL raquet FROM community;
LOAD raquet FROM community;

Using upstream DuckDB? Follow the maintainer’s installation instructions.

02 / QUERY

Usage example

Read a raquet file and get pixel value at a location

SQL
-- Load extension and query a raster file

-- Read a raquet file and get pixel value at a location
SELECT ST_RasterValue(block, band_1, ST_Point(-73.98, 40.75), metadata) AS elevation
FROM read_raquet_at('dem.parquet', -73.98, 40.75);

-- Tile statistics
SELECT block,
       (ST_RasterSummaryStats(band_1, metadata)).mean AS avg_value
FROM read_raquet('dem.parquet')
LIMIT 5;

Provided by CartoDB. Not yet verified on Haybarn 2.0.0.

Sample data & setup

About this extension

Raquet is a specification by CARTO for storing raster data in Apache Parquet format with QUADBIN spatial indexing. This extension enables DuckDB to query Raquet files directly using SQL.

Note: The read_raster() function requires GDAL and is only available when built with GDAL support. All other functions work without GDAL.

Project overview from the community descriptor.

Documentation and resources

Project and build details
Repository
CartoDB/duckdb-raquet
License
Apache-2.0
Maintainers
jatorre, cayetanobv
Written in
C++
Build source
1d900cbb7e4c
Build definition
Community descriptor