Changes between Version 25 and Version 26 of FDORfc16


Ignore:
Timestamp:
Apr 20, 2008, 9:55:56 PM (16 years ago)
Author:
jbirch
Comment:

Less explicit about not filling in auth_name, auth_srid

Legend:

Unmodified
Added
Removed
Modified
  • FDORfc16

    v25 v26  
    7272== spatial_ref_sys ==
    7373
    74 SQLite databases require the following fields in their spatial_ref_sys table.  The SRID and SRTEXT columns must be populated with a unique identifier and a valid WKT spatial reference string respectively.  AUTH_NAME and AUTH_SRID may be populated where known, but are not critical to functionality and may be left null when unknown.
     74SQLite databases require the following fields in their spatial_ref_sys table.
    7575
    7676|| Column Name || Type || Notes ||
    7777|| srid || INTEGER || an integer value that uniquely identifies each Spatial Reference System within a database ||
    78 || auth_name || TEXT || the name of the standard or standards body that is being cited for this reference system. EPSG would be an example of a valid AUTH_NAME.  If unknown, leave as null. ||
    79 || auth_srid || INTEGER || the ID of the Spatial Reference System as defined by the Authority cited in AUTH_NAME. {http://spatialreference.org/ref/epsg/26910 26910] would be an example of a valid EPSG srid (UTM Zone 10 NAD830).  If unknown, leave as null. ||
    80 || srtext || TEXT || The Well-known Text Representation of the Spatial Reference System ||
     78|| auth_name || TEXT || the name of the standard or standards body that is being cited for this reference system. EPSG would be an example of a valid AUTH_NAME. ||
     79|| auth_srid || INTEGER || the ID of the Spatial Reference System as defined by the Authority cited in AUTH_NAME. {http://spatialreference.org/ref/epsg/26910 26910] would be an example of a valid EPSG srid (UTM Zone 10 NAD830). ||
     80|| srtext || TEXT || The Well-known Text Representation of the Spatial Reference System. ||
    8181
    8282The suggested definition is: