1
--#############################################################################
2
-- This SQL script generates the raster metadata table to store
3
-- and metadata for SQL queries and temporal GIS support.
5
-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
6
--#############################################################################
8
--PRAGMA foreign_keys = ON;
10
-- The metadata table reflects most of the raster metadata available in grass
12
CREATE TABLE raster_metadata (
13
id VARCHAR NOT NULL, -- The id (PFK) is the unique identifier for all tables, it is based on name and mapset (name@mapset) and is used as primary key
14
datatype VARCHAR NOT NULL,
15
cols INTEGER NOT NULL,
16
rows INTEGER NOT NULL,
17
number_of_cells INTEGER NOT NULL,
18
nsres DOUBLE PRECISION NOT NULL,
19
ewres DOUBLE PRECISION NOT NULL,