1--############################################################################# 2-- This SQL script generates the space time vector dataset metadata table. 3-- 4-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com 5--############################################################################# 6 7CREATE TABLE stvds_metadata ( 8 id VARCHAR NOT NULL, -- Name of the space-time vector dataset, this is the primary key 9 vector_register VARCHAR,-- The id of the table in which the vector maps are registered for this dataset 10 number_of_maps INTEGER, -- The number of registered vector maps 11 title VARCHAR, -- Title of the space-time vector dataset 12 description VARCHAR, -- Detailed description of the space-time vector dataset 13 command VARCHAR, -- The command that was used to create the space time vector dataset 14 points INTEGER, -- The number of points accumulated from all registered maps 15 lines INTEGER, -- The number of lines accumulated from all registered maps 16 boundaries INTEGER, -- The number of boundaries accumulated from all registered maps 17 centroids INTEGER, -- The number of centroids accumulated from all registered maps 18 faces INTEGER, -- The number of faces accumulated from all registered maps 19 kernels INTEGER, -- The number of kernels accumulated from all registered maps 20 primitives INTEGER, -- All primitives accumulated (points, lines,boundaries,centroids,faces,kernels) 21 nodes INTEGER, -- Number of nodes accumulated from all registered maps (topological information) 22 areas INTEGER, -- The number of areas accumulated from all registered maps (topological information) 23 islands INTEGER, -- The number of islands accumulated from all registered maps (topological information) 24 holes INTEGER, -- The number of holes accumulated from all registered maps (topological information) 25 volumes INTEGER, -- The number of volumes accumulated from all registered maps (topological information) -- The command that was used to create the space time raster dataset 26 PRIMARY KEY (id) 27); 28 29