Scripts for indexing data into ODC instances.
Please note - we are aware that using these scripts with GDAL 3.0+ can cause Latitudes and Longitudes to become transposed. When using these scripts, please use a python environment with an earlier version of GDAL.
SQL scripts to delete ODC products and related records in ODC, Explorer and OWS DB. Each script takes product_name as an input parameter.
Usage:
psql -v product_name=<product-to-delete> -f <scriptname.sql> -h <database-hostname> <dbname>
delete_odc_product.sql
agdc.dataset_source
, agdc.dataset_location
, agdc.dataset
and agdc.dataset_type
.delete_odc_product_explorer.sql
delete_odc_product.sql
as script makes reference to ODC DB.cubedash.dataset_spatial
, cubedash.time_overview
, cubedash.product
.cubedash.mv_dataset_spatial_quality
.delete_odc_product_ows.sql
wms.product_ranges
and wms.sub_product_ranges
. delete_odc_product.sql
as OWS DB maintains a foreign key to ODC DB.agdc.dataset_type
has foreign key constraint wms.product_ranges_id_fkey
on table wms.product_ranges