Geospatial User Guide > Geospatial User Guide > A. Geospatial System Catalogs
Was this helpful?
Geospatial System Catalogs
spatial_ref_sys Catalog
SPATIAL_REF_SYS tracks valid SRIDs. It is automatically populated during createdb using data from front/st/geo/srs.dat.
Column Name
Data Type
Description
srid
integer
Spatial Reference System Identifier (SRID)
auth_name
varchar(256)
Authority name providing the SRS definition (for example, EPSG)
auth_srid
integer
SRID used by the authority managing the SRS definition (for example, EPSG ID)
srtext
varchar(2048)
OGC Well Known Text format description of the spatial reference system details
proj4text
varchar(1024)
PROJ.4 format description of the spatial reference system details
Last modified date: 04/03/2024