Geospatial User Guide > Geospatial User Guide > A. Geospatial System Catalogs > geometry_columns Catalog
Was this helpful?
geometry_columns Catalog
GEOMETRY_COLUMNS provides a manifest of tables with geospatial columns. It is a "system view" on iiattribute and iirelation created during createdb by default.
Column Name
Data Type
Description
f_table_schema
varchar(256)
Schema name that holds the table being cataloged
f_table_name
varchar(256)
Feature table name being cataloged
f_geometry_column
varchar(256)
Column name that holds the geometry objects
geometry_type
varchar(32)
Type of geometry features held in the cataloged column
coord_dimension
smallint
Number of dimensions used for defining feature type
srid
integer
Spatial Reference System Identifier (SRID)
Last modified date: 01/30/2023