Changes between Version 12 and Version 13 of FDORfc16


Ignore:
Timestamp:
03/22/08 08:42:36 (17 years ago)
Author:
warmerdam
Comment:

add preliminary geometry_columns layout.

Legend:

Unmodified
Added
Removed
Modified

  • FDORfc16

    v12 v13  
    6060
    6161
     62== geometry_columns ==
     63
     64|| Column Name || Type || Notes ||
     65|| f_table_catalog || VARCHAR || blank ||
     66|| f_table_schema || VARCHAR || blank ||
     67|| f_table_name || VARCHAR || name of a feature table with a geometry column ||
     68|| f_geometry_column || VARCHAR || name of a geometry column in the feature table ||
     69|| COORD_DIMENSION || ? || 2, 3 or 4 ||
     70|| SRID || ? || shared key with spatial_ref_sys table ||
     71|| f_geometry_format || VARCHAR || One of "WKT", "WKB", "FGF", ... (should we differentiate between 1.0 and 1.2 geometries?) ||
     72
    6273== Implications ==
    6374
    … …  
    7788 * [http://www.gaia-gis.it/spatialite/ SpatialLite] - a spatial extension for SQLite
    7889 * [http://fdo.osgeo.org/files/fdo/docs/FDG_FDODevGuide/files/WSfacf1429558a55de8821c21057fbebc2b-789.htm FGF Binary Specification]
    79  * WKB Specification (?)
    80  * WKT Specification (?)
     90 * [http://www.opengeospatial.org/standards/sfs OGC Simple Features for SQL] (see 06-104r3)
     91