1
--#############################################################################
2
-- This SQL script generates the vector table to store
3
-- metadata for SQL queries and temporal GIS support.
5
-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
6
--#############################################################################
8
--PRAGMA foreign_keys = ON;
12
CREATE TABLE vector_metadata (
13
id VARCHAR NOT NULL, -- The id (PK) is the unique identifier for all tables, it is based on name and mapset (name@mapset) and is used as primary key
14
is_3d BOOLEAN, -- This is 1 if the vector map is 3d and 0 otherwise
15
points INTEGER, -- The number of points
16
lines INTEGER, -- The number of lines
17
boundaries INTEGER, -- The number of boundaries
18
centroids INTEGER, -- The number of centroids
19
faces INTEGER, -- The number of faces
20
kernels INTEGER, -- The number of kernels
21
primitives INTEGER, -- All primitives accumulated (points, lines,boundaries,centroids,faces,kernels)
22
nodes INTEGER, -- Number of nodes (topological information)
23
areas INTEGER, -- The number of areas (topological information)
24
islands INTEGER, -- The number of islands (topological information)
25
holes INTEGER, -- The number of holes (topological information)
26
volumes INTEGER, -- The number of volumes (topological information)