pgstac
pgstac copied to clipboard
stac-utils
Schema, functions and a python library for storing and accessing STAC collections and items in PostgreSQL
Imagine that we have 2 users `user1` and `user2` which can ingest data into the database: ```sql GRANT pgstac_ingest TO user1; GRANT pgstac_ingest TO user2; ``` During the data ingestion...
I ran into a case where the check on this line: https://github.com/stac-utils/pgstac/blob/main/pypgstac/pypgstac/db.py#L234 failed due to the row value being bytes, not str. Forcing a `.decode()` on the value if it's...
`pg-stac` version - `0.4.3` `pypgstac` version - `0.4.5` When using `load_ndjson` with the `method` `loadopt.upsert` https://github.com/NASA-IMPACT/cmr-pgstac-loader/blob/main/lambdas/pgstac_loader/handler.py#L40 records with duplicate `ids` throw `UniqueViolationError`. An example full stack trace ``` [ERROR] UniqueViolationError:...
# Background Given that uniqueness constraints on the `items` table combine `id` and `datetime`, loading data with the `upsert` method will fail if the `datetime` for an existing row has...
In the most recent release of the STAC API specification (i.e. v1.0.0-beta.5), two features have been added which imply a hierarchical representation of of STAC documents within STAC APIs: [children](https://github.com/radiantearth/stac-api-spec/tree/master/children)...
The data upload functionality assumes the data is temporally dense and [creates datetime partitions that are 1 week long](https://github.com/stac-utils/pgstac/blob/4b582773f764f317788a8879f5cac3ee4f4f7951/sql/003_items.sql#L133). Some datasets (eg: CMIP6) are sparsely populated over a very large...
Right now the `official` image published is built with https://github.com/stac-utils/pgstac/blob/main/Dockerfile packaging pypgstac python module and postgres (+pgstac SQL). I don't think the image will be used for both function running...
Let me know if you have another recommendation for backing up and restoring the database, but I attempted to use `pg_dump` and `pg_restore` and I get this error: ``` CONTEXT:...
I am seeing behavior where if a search is performed with only "items" specified, but no "collections", that invalid results can occur. I saw this through stac-fastapi, where the get_item()...
I was testing out pgstac migrations (with `pypgstac migrate`) and it looks like multiple version numbers can be inserted at the same time. ``` db=> SELECT * FROM pgstac.migrations; version...
Metadata
Owner
Metadata
Schema, functions and a python library for storing and accessing STAC collections and items in PostgreSQL