stac-utils/pgstac

Stars
140
Rank 261,473 (Top 6 %)
Language PLpgSQL
License
MIT License
Created over 3 years ago
Updated 3 months ago

stac-utils/pgstac

stac-utils

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Schema, functions and a python library for storing and accessing STAC collections and items in PostgreSQL

PostgreSQL schema and functions for Spatio-Temporal Asset Catalog (STAC)

Documentation: https://stac-utils.github.io/pgstac/

Source Code: https://github.com/stac-utils/pgstac

PgSTAC is a set of SQL functions and schema to build highly performant databases for Spatio-Temporal Asset Catalogs (STAC). The project also provides pypgstac (a Python module) to help with database migrations and document ingestion (collections and items).

PgSTAC provides functionality for STAC Filters, CQL2 search, and utilities to help manage the indexing and partitioning of STAC Collections and Items.

PgSTAC is used in production to scale to hundreds of millions of STAC items. PgSTAC implements core data models and functions to provide a STAC API from a PostgreSQL database. PgSTAC is entirely within the database and does not provide an HTTP-facing API. The Stac FastAPI PgSTAC backend and Franklin can be used to expose a PgSTAC catalog. Integrating PgSTAC with any other language with PostgreSQL drivers is also possible.

PgSTAC Documentation: https://stac-utils.github.io/pgstac/pgstac

pyPgSTAC Documentation: https://stac-utils.github.io/pgstac/pypgstac

Project structure

/
 ├── src/pypgstac           - pyPgSTAC python module
 ├── src/pypgstac/tests/    - pyPgSTAC tests
 ├── scripts/               - scripts to set up the environment, create migrations, and run tests
 ├── src/pgstac/sql/        - PgSTAC SQL code
 ├── src/pgstac/migrations/ - Migrations for incremental upgrades
 └── src/pgstac/tests/      - test suite

Contribution & Development

See CONTRIBUTING.md

License

Authors

See contributors for a listing of individual contributors.

Changes

See CHANGELOG.md.

pystac

Python library for working with any SpatioTemporal Asset Catalog (STAC)

stac-fastapi

STAC API implementation with FastAPI.

pystac-client

Python client for searching STAC APIs

stactools

Command line utility and Python library for STAC

titiler-pgstac

TiTiler + PgSTAC

stac-server

A Node-based STAC API, AWS Serverless, OpenSearch

stac-geoparquet

Convert STAC items between JSON, GeoParquet, pgstac, and Delta Lake.

qgis-stac-plugin

QGIS plugin for reading STAC APIs

stac-pydantic

Pydantic data models for the STAC spec

xstac

STAC from xarray

stac-fastapi-pgstac

PostgreSQL backend for stac-fastapi using pgstac (https://github.com/stac-utils/pgstac)

stac-layer

Visualize a STAC Item or Collection on a Leaflet Map

stac-validator

Validator for the stac-spec

xpystac

For extending xarray.open_dataset to accept pystac objects

stac-fastapi-elasticsearch-opensearch

Elasticsearch backend for stac-fastapi with Opensearch support.

stac-asset

Read and download STAC Assets, using a variety of authentication schemes

stac-vrt

stac-check

Linting and validation tool for STAC assets

stac-api-validator

A STAC API validation client

stac-terminal

Output info on STAC Items in the terminal

stac4s

a scala library with primitives to build applications using the SpatioTemporal Asset Catalogs specification

stac-task

Provides a class interface for running custom algorithms on STAC ItemCollections

stac-node-validator

Simple validator for STAC Items, Catalogs, and Collections. STAC 1.0.0 compliant!

stac-fastapi-sqlalchemy

PostgreSQL backend for stac-fastapi using SQLAlchemy

stac-api-benchmark

STAC API Benchmark

stac-index

A service that lists all available and registered STAC catalogs and APIs.

stac-migrate

A tool to migrate Items, Catalogs and Collections from old versions to the most recent one.

stac-crosswalks

Common metadata crosswalks to help people map from their existing data into STAC

stac-fields

A minimal STAC library that contains a list of STAC fields with some metadata and helper functions for styling as HTML.

stac-table

stac-ecosystem

Collaboration space for the broader STAC software and data ecosystem

stac-sentinel

STAC Collections and Items for Sentinel data

developer-guide

Developer guide for stac-utils

stac-examples

A small repository of real world STAC collections and items, to let users get a sense of how STAC is used, without having to dive deep into huge catalogs.