pgstac

pgstac copied to clipboard

This PR adds tests to demonstrate a `bug` with the `geometrysearch` function when passing a geometry without `area` (e.g point). If `exitwhenfull` / `skipcovered` are set to `true` the geometrysearch...

vincentsarago

Add documentation for using `\copy` for faster data ingest

1

Any thoughts on adding a section in the documentation (maybe for "advanced users") for how to ingest data to pgstac using `\copy`? I tried using `pypgstac load`, but for some...

kylebarron

Issue running migration against DB with sslmode=require

3

Running migrations against a --dsn that has ?sslmode=require (or with PGSSLMODE=require), I get: ``` ERROR:asyncio:Fatal error on SSL transport protocol: transport: Traceback (most recent call last): File "/opt/conda/lib/python3.8/asyncio/selector_events.py", line 910,...

lossyrob

I am working on incorporating `pgstac` into a project and I had to downgrade to smart-open==4.2.0 so I thought I would try bumping the pinned version to the latest (6.2.*)....

hrodmn

pypgstac function for deleting collections/items

7

Have you considered adding pypgstac functions for deleting collections and items? I see some SQL functions that seem to do this: [delete_collection](https://github.com/stac-utils/pgstac/blob/3c61e0398ece42c431fcef5f2cf7b3938c16b4b2/sql/002_collections.sql#L478-L484) [delete_item](https://github.com/stac-utils/pgstac/blob/3c61e0398ece42c431fcef5f2cf7b3938c16b4b2/sql/003_items.sql#L255-L261) What do you think about adding `delete_collections`...

hrodmn

CQL2 filters resulting in full scans despite indexed properties

2

Even when the property is indexed in certain filter requests, it is bypassed. Consider the following example: ```sql postgis=> SELECT * from queryables WHERE name = 'platform'; id | name...

drnextgis

Feature request: Update collection extend from item(s)

2

It would be nice if there was an easy way to update the collection extend. I can imagine the following ways: * A new command in `pypgstac` that does the...

charalamm

Unable to ingest private metadata

8

Although the items table contains `private` column, the pypgstac loader is unable to ingest private metadata.

drnextgis

We encountered an issue where the database logs experienced rapid growth, particularly under heavy load. After making adjustments of some PostgreSQL settings, we discovered that the growth could only be...

drnextgis

How to have a Collection of Collections?

4

Is it possible to have a collection of collections? We have a static STAC catalog with a structure similar to below. We would like to migrate this type of structure...

randyberos