Table sola.system.crs
Identifies the coordinate reference system(s) (CRS) available to the Map Viewer. If there is more than one CRS defined, the user has the option to select the CRS to use for displaying features in the Map Viewer. The CRS with the lowest item_order will be the default CRS and used for the initial display of the map. The extent values defined in the system.setting table must be in the context of the default CRS. The from_long, to_long values define valid longitude values for each CRS in WGS84. These values can be used for various purposes such as assigning or transforming geometries into the appropraite storage CRS before being saved to the database.
Tags: FLOSS SOLA Extension, Reference Table, Map Configuration

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
srid int4 10 The Spatial Reference Identifier (SRID) for the CRS.
from_long float8 17,17  √  null The longitude in WGS84 identifying the where the CRS is valid from.
to_long float8 17,17  √  null The longitude in WGS84 identifying the where the CRS is valid to.
item_order int4 10 Identifies the order the CRS is displayed in the drop down menu on the Map Viewer. The CRS with the lowest item order will be used as the default CRS for the initial display of the map.

Analyzed at Tue May 31 09:59 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
srid Primary key Asc crs_pkey