---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: raquet
excerpt: |
  DuckDB Community Extensions
  Raster analytics on Raquet files with QUADBIN spatial indexing, raster ingestion, and PostGIS-style functions

extension:
  name: raquet
  description: "Raster analytics on Raquet files with QUADBIN spatial indexing, raster ingestion, and PostGIS-style functions"
  version: 0.3.0
  language: C++
  build: cmake
  license: Apache-2.0
  excluded_platforms: "windows_amd64;windows_amd64_mingw;wasm_mvp;wasm_eh;wasm_threads"
  maintainers:
    - jatorre
    - cayetanobv

repo:
  github: CartoDB/duckdb-raquet
  ref: 1d900cbb7e4c021e441c44ed49384a6955191633
  variegata: 37bc15566f2ad89e039e1462aabc060d31bfbc60

docs:
  hello_world: |
    -- Load extension and query a raster file
    LOAD raquet;

    -- 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;

  extended_description: |
    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.

    **Features:**
    - PostGIS-style raster functions (ST_RasterValue, ST_RasterSummaryStats, ST_RegionStats)
    - QUADBIN spatial indexing functions (polyfill, kring, parent/children)
    - Raster ingestion from GeoTIFF/NetCDF via read_raster() (requires GDAL, optional)
    - Band math operations (ST_NormalizedDifference, ST_BandMath)
    - Raster clipping (ST_Clip, ST_ClipMask)
    - Metadata validation (raquet_validate_metadata)
    - Time-series support with CF conventions (NetCDF compatible)
    - Cloud-native queries with predicate pushdown (S3/GCS)
    - Native DuckDB GEOMETRY type support

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

    **Links:**
    - [Raquet Specification](https://raquet.io)
    - [Documentation](https://github.com/CartoDB/duckdb-raquet#readme)
    - [Performance Benchmarks](https://github.com/CartoDB/duckdb-raquet/blob/main/docs/PERFORMANCE_COMPARISON.md)

extension_star_count: 16
extension_star_count_pretty: 16
extension_download_count: 2081
extension_download_count_pretty: 2.1k
image: '/images/community_extensions/social_preview/preview_community_extension_raquet.png'
layout: community_extension_doc
---
### Compatibility Matrix

This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

<div class="extension_compatibility_table"></div>

| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
| :--- | :---: | :---: | :---: | :---: | :---: |
| Linux AMD64 | ❌ | ❌ | ✅ | ✅ | ✅ |
| Linux ARM64 | ❌ | ❌ | ✅ | ✅ | ✅ |
| macOS AMD64 | ❌ | ❌ | ✅ | ✅ | ✅ |
| macOS ARM64 | ❌ | ❌ | ✅ | ✅ | ✅ |
| Windows AMD64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| Windows ARM64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| WebAssembly | ❌ | ❌ | ❌ | ❌ | ❌ |

### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}
### Added Functions

<div class="extension_functions_table"></div>

|        function_name         | function_type | description | comment | examples |
|------------------------------|---------------|-------------|---------|----------|
| QUADBIN_POLYFILL             | scalar        | NULL        | NULL    |          |
| ST_Band                      | scalar        | NULL        | NULL    |          |
| ST_BandMath                  | scalar        | NULL        | NULL    |          |
| ST_Clip                      | scalar        | NULL        | NULL    |          |
| ST_ClipMask                  | scalar        | NULL        | NULL    |          |
| ST_Contains                  | scalar        | NULL        | NULL    |          |
| ST_GeomFromQuadbin           | scalar        | NULL        | NULL    |          |
| ST_Intersects                | scalar        | NULL        | NULL    |          |
| ST_NormalizedDifference      | scalar        | NULL        | NULL    |          |
| ST_NormalizedDifferenceStats | scalar        | NULL        | NULL    |          |
| ST_Point                     | scalar        | NULL        | NULL    |          |
| ST_Raster                    | table_macro   | NULL        | NULL    |          |
| ST_RasterAt                  | table_macro   | NULL        | NULL    |          |
| ST_RasterSummaryStats        | scalar        | NULL        | NULL    |          |
| ST_RasterValue               | scalar        | NULL        | NULL    |          |
| ST_RegionStats               | aggregate     | NULL        | NULL    |          |
| ST_X                         | scalar        | NULL        | NULL    |          |
| ST_Y                         | scalar        | NULL        | NULL    |          |
| quadbin_from_lonlat          | scalar        | NULL        | NULL    |          |
| quadbin_from_tile            | scalar        | NULL        | NULL    |          |
| quadbin_kring                | scalar        | NULL        | NULL    |          |
| quadbin_pixel_xy             | scalar        | NULL        | NULL    |          |
| quadbin_resolution           | scalar        | NULL        | NULL    |          |
| quadbin_sibling              | scalar        | NULL        | NULL    |          |
| quadbin_to_bbox              | scalar        | NULL        | NULL    |          |
| quadbin_to_children          | scalar        | NULL        | NULL    |          |
| quadbin_to_geojson           | scalar        | NULL        | NULL    |          |
| quadbin_to_lonlat            | scalar        | NULL        | NULL    |          |
| quadbin_to_parent            | scalar        | NULL        | NULL    |          |
| quadbin_to_tile              | scalar        | NULL        | NULL    |          |
| quadbin_to_wkt               | scalar        | NULL        | NULL    |          |
| raquet_decode_band           | scalar        | NULL        | NULL    |          |
| raquet_merge_bands           | table         | NULL        | NULL    |          |
| raquet_parse_metadata        | scalar        | NULL        | NULL    |          |
| raquet_pixel                 | scalar        | NULL        | NULL    |          |
| raquet_pixel_interleaved     | scalar        | NULL        | NULL    |          |
| raquet_validate_metadata     | scalar        | NULL        | NULL    |          |
| read_raquet                  | table_macro   | NULL        | NULL    |          |
| read_raquet_at               | table_macro   | NULL        | NULL    |          |
| read_raquet_metadata         | table_macro   | NULL        | NULL    |          |
| read_raster                  | table         | NULL        | NULL    |          |

### Overloaded Functions

<div class="extension_functions_table"></div>

This extension does not add any function overloads.

### Added Types

<div class="extension_types_table"></div>

This extension does not add any types.

### Added Settings

<div class="extension_settings_table"></div>

|      name      |                       description                       | input_type | scope  | aliases | typed_value |
|----------------|---------------------------------------------------------|------------|--------|---------|-------------|
| temp_directory | Set the directory to which temporary files are written. | VARCHAR    | GLOBAL | []      | post.db.tmp |