Damien Ayers omad

SpatioTemporal Access Catalogues and ODC

The SpatioTemporal Asset Catalog specification is a simple specification being designed to make open geospatial assets searchable and crawlable. It aims to

Too many definitions of spatial extents
- Including
Insufficient spatial metadata
- Not enough information to define the pixel grid
- Requires CRS + Affine transform + Shape (width, height)
Shape and Transform can be different per band

	description: Landsat 5 Fractional Cover 25 metre, 100km tile, Australian Albers Equal
	Area projection (EPSG:3577)
	managed: true
	measurements:
	- aliases: [bare]
	dtype: int8
	name: BS
	nodata: -1
	units: percent
	- aliases: [green_veg]

	------------------------------------------
	-- Some SQL to Delete a Data Cube Product
	------------------------------------------

	--
	-- COUNT NUMBER OF DATASETS OF EACH TYPE (including archived)
	--
	select
	count(*),
	t.name

	--------------------------------------
	-- SQL to Delete a Data Cube Product
	--------------------------------------
	--
	-- Use with psql from the command line:
	--
	-- psql -v product_name=<product-to-delete> -f delete_odc_product.sql -h <database-hostname> <dbname>
	--

	--


	-- Experiments with PostgreSQL, connecting to a remote server.

	CREATE EXTENSION postgres_fdw;

	DROP SERVER IF EXISTS collection2;
	CREATE SERVER collection2 FOREIGN DATA WRAPPER postgres_fdw OPTIONS (dbname 'datacube', host 'localhost');

	DROP USER MAPPING IF EXISTS FOR CURRENT_USER SERVER collection2;
	CREATE USER MAPPING FOR dra547 SERVER collection2 OPTIONS (user 'dra547', password 'xxxxx');