spatial_ref_sys

8500 rows


Description

Is spatial features system table. spatial_ref_sys stores projection definitions and is created automatically

Columns

Column Type Size Nulls Auto Default Children Parents Comments
srid int4 10 null
geography_columns.srid Implied Constraint R
geometry_columns.srid Implied Constraint R
auth_name varchar 256 √ null
auth_srid int4 10 √ null
srtext varchar 2048 √ null
proj4text varchar 2048 √ null

Indexes

Constraint Name Type Sort Column(s)
spatial_ref_sys_pkey Primary key Asc srid

Check Constraints

Constraint Name Constraint
spatial_ref_sys_srid_check (((srid > 0) AND (srid <= 998999)))

Relationships

Close relationships within degrees of separation