geometry_columns_auth

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

2 rows

This data as json, copyable, CSV (advanced)

Link f_table_name f_geometry_column read_only hidden
cpad_2020a_superunits,geometry cpad_2020a_superunits geometry 0 0
cpad_2020a_units,geometry cpad_2020a_units geometry 0 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)));
CREATE INDEX [idx_geometry_columns_auth_f_table_name]
    ON [geometry_columns_auth] ([f_table_name]);
CREATE INDEX [idx_geometry_columns_auth_f_geometry_column]
    ON [geometry_columns_auth] ([f_geometry_column]);