Install and load
Run these commands in a Haybarn SQL session. The extension is available from the community repository.
INSTALL raquet FROM community;
LOAD raquet FROM community;
Using upstream DuckDB? Follow the maintainer’s installation instructions.
Usage example
Read a raquet file and get pixel value at a location
-- 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 & setupAbout 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