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