Install and load
Run these commands in a Haybarn SQL session. The extension is available from the community repository.
INSTALL stac FROM community;
LOAD stac FROM community;
Try it in a temporary SQL session with stac already loaded. Queries run in this tab; examples using files or services need their own setup.
Using upstream DuckDB? Follow the maintainerβs installation instructions.
Usage example
Read the content of a static STAC catalog and return the first 2 items:
-- Read the content of a static STAC catalog and return the first 2 items:
SELECT
collection, id
FROM
STAC_Read('https://raw.githubusercontent.com/radiantearth/stac-spec/refs/heads/master/examples/catalog.json')
LIMIT 2
;
βββββββββββββββββ¬βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ¬ββββββββββββββββββββββββββββββββββ
β collection β id β bbox β
β varchar β varchar β stac_bbox β
βββββββββββββββββΌβββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββ€
β sentinel2_l2a β S2A_OPER_MSI_L2A_TL_EPAE_20190527T094026_A020508_T46VCQ_N02.12 β { β
β β β 'minx': 90.63571493952938, β
β β β 'miny': 91.27015715015226, β
β β β 'maxx': 62.12379856857608, β
β β β 'maxy': 62.96338922674105 β
β β β } β
βββββββββββββββββΌβββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββ€
β sentinel2_l2a β S2A_OPER_MSI_L2A_TL_MTI__20190518T203951_A020386_T24XWM_N02.12 β { β
β β β 'minx': -39.0008444956852, β
β β β 'miny': -34.13214411127818, β
β β β 'maxx': 77.42853163431232, β
β β β 'maxy': 78.37301671070006 β
β β β } β
βββββββββββββββββ΄βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββ
-- Search for items in a STAC catalog using the STAC API - Item Search endpoint:
SELECT
collection, id, bbox
FROM
STAC_Search(
'https://earth-search.aws.element84.com/v0/search',
collections := ['sentinel-s2-l2a-cogs'],
datetime := '2021-09-30/2021-10-30',
bbox := [-1.695007724869786, 42.788757186108654, -1.604482013650674, 42.84244150196227]
)
;
ββββββββββββββββββββββββ¬βββββββββββββββββββββββββββ¬ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
β collection β id β bbox β
β varchar β varchar β stac_bbox β
ββββββββββββββββββββββββΌβββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
β sentinel-s2-l2a-cogs β S2B_30TWN_20211030_0_L2A β {'minx': -3.0002344509650487, 'miny': 42.356331534440834, 'maxx': -1.6455652046460576, 'maxy': 43.35284638738093} β
β sentinel-s2-l2a-cogs β S2B_30TXN_20211030_0_L2A β {'minx': -1.7857005522228677, 'miny': 42.335791505536065, 'maxx': -0.4124765189393069, 'maxy': 43.3461908738427} β
β sentinel-s2-l2a-cogs β S2A_30TWN_20211025_0_L2A β {'minx': -3.0002344509650487, 'miny': 42.356331534440834, 'maxx': -1.6455652046460576, 'maxy': 43.35284638738093} β
β sentinel-s2-l2a-cogs β S2A_30TXN_20211025_0_L2A β {'minx': -1.7857005522228677, 'miny': 42.335791505536065, 'maxx': -0.4124765189393069, 'maxy': 43.3461908738427} β
β sentinel-s2-l2a-cogs β S2B_30TWN_20211020_0_L2A β {'minx': -3.0002344509650487, 'miny': 42.356331534440834, 'maxx': -1.6455652046460576, 'maxy': 43.35284638738093} β
β sentinel-s2-l2a-cogs β S2A_30TXN_20211015_0_L2A β {'minx': -1.7857005522228677, 'miny': 42.335791505536065, 'maxx': -0.4124765189393069, 'maxy': 43.3461908738427} β
β sentinel-s2-l2a-cogs β S2B_30TXN_20210930_0_L2A β {'minx': -1.7857005522228677, 'miny': 42.335791505536065, 'maxx': -0.4124765189393069, 'maxy': 43.3461908738427} β
ββββββββββββββββββββββββ΄βββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
Provided by ahuarte47. Not yet verified on Haybarn 2.0.0.
Sample data & setupAbout this extension
A DuckDB extension for reading data from SpatioTemporal Asset Catalogs (STAC) using SQL.
The extension exposes STAC catalogs as relational tables, following the GeoParquet STAC specification.
Project overview from the community descriptor.
Documentation and resources
Project and build details
- Repository
- ahuarte47/duckdb-stac
- License
- MIT
- Maintainers
- ahuarte47
- Written in
- C++
- Build source
ac3b2545ea19- Build definition
- Community descriptor