MCPcopy Index your code
hub / github.com/CartoDB/raquet

github.com/CartoDB/raquet @v0.9.0

Chat with this repo
repository ↗ · DeepWiki ↗ · release v0.9.0 ↗ · + Follow
271 symbols 694 edges 18 files 224 documented · 83%
What it actually does AI analysis from the code graph — generated when you open this
loading…
README

RaQuet

Unit Tests

RaQuet is a specification for storing and querying raster data using Apache Parquet, a column-oriented data file format. Users of data warehouse platforms rely on the simple interoperability of Parquet files to move data and perform queries.

Documentation | Online Viewer | Specification

Overview

Each row in a RaQuet file represents a single rectangular block of data. Location and zoom are given by a Web Mercator tile z/x/y tile identifier stored in the block column as a single 64-bit cell Quadbin identifier. Empty tiles can be omitted to reduce file size.

Raster data pixels are stored in row-major order binary packed blobs. By default, each band is stored in a separate column (band_1, band_2, etc.) with optional gzip compression. For RGB imagery, an interleaved layout stores all bands in a single pixels column, enabling lossy compression (JPEG/WebP) for 10-15x smaller files.

Pixel bands can be decoded via simple binary unpacking in any programming environment and converted to wire image formats like PNG or displayed directly in web visualization libraries like MapLibre.

Similar to GeoParquet, RaQuet metadata is stored as a JSON object with details on coverage area, raster resolution, pixel data format, and other needed information. For compatibility with data warehouses the metadata is stored within a Parquet row at a special “0” row (block=0x00).

Installation

# Basic installation (GeoTIFF conversion)
pip install raquet-io

# With rich output for CLI
pip install "raquet-io[rich]"

# With ImageServer support
pip install "raquet-io[imageserver]"

# All features
pip install "raquet-io[all]"

Note: GDAL must be installed separately. On macOS: brew install gdal. On Ubuntu: apt install gdal-bin libgdal-dev.

CLI Usage

The raquet CLI provides commands for inspecting, converting, and exporting Raquet files.

Inspect a Raquet file

# Display metadata and statistics
raquet-io inspect landcover.parquet

# With verbose output
raquet-io inspect landcover.parquet -v

Convert to Raquet

From GeoTIFF

# Basic conversion
raquet-io convert geotiff input.tif output.parquet

# With custom options
raquet-io convert geotiff input.tif output.parquet \
  --resampling bilinear \
  --block-size 512 \
  -v

Options: | Option | Description | |--------|-------------| | --zoom-strategy | Zoom level strategy: auto, lower, upper (default: auto) | | --resampling | Resampling algorithm: near, bilinear, cubic, etc. (default: near) | | --block-size | Block size: 256 (default), 512, or 1024. Use 512 for fewer HTTP requests. | | --target-size | Target size for auto zoom calculation | | --overviews | Overview generation: auto (full pyramid) or none (native resolution only) | | --min-zoom | Minimum zoom level for overviews (overrides auto calculation) | | --streaming | Memory-safe two-pass conversion for large files | | --band-layout | Band storage: sequential (default) or interleaved | | --compression | Compression: gzip (default), jpeg, webp, or none | | --compression-quality | Quality for lossy compression (1-100, default: 85) | | -v, --verbose | Enable verbose output |

Lossy compression for satellite imagery:

# WebP compression (best quality/size ratio for RGB imagery)
raquet-io convert geotiff satellite.tif output.parquet \
  --band-layout interleaved \
  --compression webp \
  --compression-quality 85

# JPEG compression (wider compatibility)
raquet-io convert geotiff satellite.tif output.parquet \
  --band-layout interleaved \
  --compression jpeg

# 512px blocks for fewer HTTP requests (recommended for mobile/high-latency)
raquet-io convert geotiff satellite.tif output.parquet \
  --block-size 512 \
  --band-layout interleaved \
  --compression webp

Large file conversion:

# Skip overviews for faster conversion (native resolution only)
raquet-io convert geotiff large.tif output.parquet --overviews none

# Memory-safe streaming mode for very large files
raquet-io convert geotiff huge.tif output.parquet --streaming -v

# Limit overview pyramid to zoom 5 and above
raquet-io convert geotiff input.tif output.parquet --min-zoom 5

From ArcGIS ImageServer

# Basic conversion
raquet-io convert imageserver https://server/arcgis/rest/services/dem/ImageServer dem.parquet

# With bounding box filter
raquet-io convert imageserver https://server/.../ImageServer output.parquet \
  --bbox "-122.5,37.5,-122.0,38.0"

# With specific resolution
raquet-io convert imageserver https://server/.../ImageServer output.parquet \
  --resolution 12 \
  -v

Options: | Option | Description | |--------|-------------| | --token | ArcGIS authentication token | | --bbox | Bounding box filter in WGS84: xmin,ymin,xmax,ymax | | --block-size | Block size: 256 (default), 512, or 1024. Use 512 for fewer HTTP requests. | | --resolution | Target QUADBIN pixel resolution (auto if not specified) | | --no-compression | Disable gzip compression for block data | | -v, --verbose | Enable verbose output |

Export from Raquet

To GeoTIFF

# Export to GeoTIFF
raquet-io export geotiff input.parquet output.tif

# Include RaQuet overviews in GeoTIFF (uses pre-computed overview tiles)
raquet-io export geotiff input.parquet output.tif --overviews

# With verbose output
raquet-io export geotiff input.parquet output.tif -v

Legacy Commands

For backwards compatibility, standalone commands are also available:

geotiff2raquet input.tif output.parquet
raquet2geotiff input.parquet output.tif

Python API

from raquet import geotiff2raquet, raquet2geotiff

# Convert GeoTIFF to Raquet
geotiff2raquet.main(
    "input.tif",
    "output.parquet",
    geotiff2raquet.ZoomStrategy.AUTO,
    geotiff2raquet.ResamplingAlgorithm.NEAR,
    block_zoom=8,  # 256px blocks
    target_size=None,
)

# Convert Raquet to GeoTIFF
raquet2geotiff.main("input.parquet", "output.tif")

ImageServer Conversion

from raquet.imageserver import imageserver_to_raquet

# Convert ImageServer to Raquet
result = imageserver_to_raquet(
    "https://server/arcgis/rest/services/dem/ImageServer",
    "output.parquet",
    bbox=(-122.5, 37.5, -122.0, 38.0),  # Optional WGS84 bounds
    block_size=256,
    target_resolution=12,  # Optional, auto-calculated if not specified
)

print(f"Created {result['num_blocks']} blocks with {result['num_bands']} bands")

Testing

# Run unit tests (skips integration tests)
python -m pytest -m "not integration"

Querying with DuckDB

Raquet files can be queried directly with DuckDB using the DuckDB Raquet Extension:

INSTALL raquet FROM community;
LOAD raquet;

-- Load Raquet file (automatically excludes metadata row)
SELECT * FROM read_raquet('raster.parquet') LIMIT 10;

-- Get metadata
SELECT metadata FROM read_raquet_metadata('raster.parquet');

-- Query specific tiles using QUADBIN
SELECT block, band_1
FROM read_raquet('raster.parquet')
WHERE block = quadbin_from_tile(x, y, z);

RaQuet files also work as standard Parquet without the extension:

-- Without extension (manual metadata filtering)
SELECT * FROM read_parquet('raster.parquet') WHERE block != 0 LIMIT 10;
SELECT metadata FROM read_parquet('raster.parquet') WHERE block = 0;

Online Viewer

Try the RaQuet Viewer - a client-side viewer powered by DuckDB-WASM that runs entirely in your browser. Load any publicly accessible RaQuet file and explore it interactively.

Performance Tips

For optimal remote query performance:

  1. Block sorting: Blocks are automatically sorted by QUADBIN ID during conversion, enabling Parquet row group pruning
  2. Row group size: Use smaller row groups (default: 200) for cloud storage access
  3. Zoom splitting: For large datasets, use raquet-io split-zoom to create per-zoom-level files
# Convert with optimized settings for remote access
raquet-io convert geotiff input.tif output.parquet --row-group-size 200

See the full documentation for more details.

Specification

See format-specs/raquet.md for the full specification.

Examples

See examples/example_metadata.json for an example of the metadata.

See examples/example_data.parquet for an example of the data.

License

See LICENSE for the license.

Core symbols most depended-on inside this repo

setup_logging
called by 7
raquet/cli.py
flush_rows_to_file
called by 6
raquet/raster2raquet.py
_get_crs_from_spatial_reference
called by 6
raquet/imageserver.py
nan_to_none
called by 5
raquet/raster2raquet.py
_calculate_target_resolution
called by 5
raquet/imageserver.py
get_metadata_compat
called by 5
raquet/raquet2geotiff.py
_get_tiling_value
called by 4
raquet/cli.py
_get_ee
called by 4
raquet/earthengine.py

Shape

Function 128
Method 89
Class 42
Route 12

Languages

Python100%

Modules by API surface

raquet/raster2raquet.py52 symbols
tests/test_cli.py45 symbols
raquet/cli.py31 symbols
tests/test_earthengine.py24 symbols
raquet/earthengine.py18 symbols
tests/test_geotiff2raquet.py17 symbols
tests/test_imageserver.py15 symbols
raquet/imageserver.py13 symbols
examples/server_viewer.py9 symbols
raquet/validate.py8 symbols
raquet/raquet2geotiff.py7 symbols
scripts/prepare_dem.py6 symbols

For agents

$ claude mcp add raquet \
  -- python -m otcore.mcp_server <graph>

⬇ download graph artifact