Data source: Verschiedene Organisationen und Projekte
This data as json, CSV (advanced)
Link | f_table_name | f_geometry_column | read_only | hidden |
---|---|---|---|---|
incidents,point_geom | incidents | point_geom | 0 | 0 |
JSON shape: default, array, newline-delimited, object
CREATE TABLE geometry_columns_auth ( f_table_name TEXT NOT NULL, f_geometry_column TEXT NOT NULL, read_only INTEGER NOT NULL, hidden INTEGER NOT NULL, CONSTRAINT pk_gc_auth PRIMARY KEY (f_table_name, f_geometry_column), CONSTRAINT fk_gc_auth FOREIGN KEY (f_table_name, f_geometry_column) REFERENCES geometry_columns (f_table_name, f_geometry_column) ON DELETE CASCADE, CONSTRAINT ck_gc_ronly CHECK (read_only IN (0,1)), CONSTRAINT ck_gc_hidden CHECK (hidden IN (0,1)));