geometry_columns
Data license: ODbL · Data source: timezone-boundary-builder · About: simonw/timezones-api
2 rows
This data as json, CSV (advanced)
Link | f_table_name | f_geometry_column | geometry_type | coord_dimension | srid | spatial_index_enabled |
---|---|---|---|---|---|---|
countries,geometry | countries | geometry | 0 | 2 | 4326 4326 | 1 |
timezones,geometry | timezones | geometry | 0 | 2 | 4326 4326 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE geometry_columns ( f_table_name TEXT NOT NULL, f_geometry_column TEXT NOT NULL, geometry_type INTEGER NOT NULL, coord_dimension INTEGER NOT NULL, srid INTEGER NOT NULL, spatial_index_enabled INTEGER NOT NULL, CONSTRAINT pk_geom_cols PRIMARY KEY (f_table_name, f_geometry_column), CONSTRAINT fk_gc_srs FOREIGN KEY (srid) REFERENCES spatial_ref_sys (srid), CONSTRAINT ck_gc_rtree CHECK (spatial_index_enabled IN (0,1,2))); CREATE INDEX idx_srid_geocols ON geometry_columns (srid) ;