This part of ISO 19125:2004 specifies an SQL schema that supports storage, retrieval, query and update of simple geospatial feature collections via the SQL Call Level Interface (SQL/CLI) and establishes an architecture for the implementation of feature tables. This part of ISO 19125:2004 defines terms to use within the architecture. of geographic information and defines a simple feature profile of ISO 19107. In addition, this part of ISO 19125:2004 describes a set of SQL Geometry Types together with SQL functions on those types. The Geometry Types and Functions described represent a profile of ISO 13249-3. This part of ISO 19125:2004 standardizes the names and geometric definitions of the SQL Types for Geometry and the names, signatures and geometric definitions of the SQL Functions for Geometry. This part of ISO 19125:2004 does not attempt to standardize and does not depend upon any part of the mechanism by which Types are added and maintained in the SQL environment, including the following: the syntax and functionality provided for defining types; the syntax and functionality provided for defining SQL functions; the physical storage of type instances in the database; specific terminology used to refer to User Defined Types, for example, UDT.
Tämän julkaisun valmistelusta Suomessa vastaa SFS Suomen Standardit, puh. 09 149 9331.
Sisällysluettelo
Foreword
Introduction
1 Scope
2 Conformance
3 Normative references
4 Terms and definitions
5 Symbols and abbreviated terms
6 Architecture
6.1 Architecture — SQL implementation of feature tables based on predefined data types
6.2 Architecture — SQL with Geometry Types implementation of feature tables
7 Clause component specifications
7.1 Components — Implementation of feature tables based on predefined data types
7.2 Components — SQL with Geometry Types implementation of feature tables
Annex A Comparison of Simple feature access/SQL and SQL/MM — Spatial (informative)
ISO 19107:2003 Geographic information -- Spatial schema
ISO 19109:2005 Geographic information -- Rules for application schema
ISO 19119:2005 Geographic information -- Services
ISO 19107:2003 Geographic information -- Spatial schema
ISO 19109:2005 Geographic information -- Rules for application schema
ISO 19119:2005 Geographic information -- Services
ISO 19125-1:2004 Geographic information -- Simple feature access -- Part 1: Common architecture
ISO/IEC 13249-3:2003
ISO/IEC 9075-1:2003
ISO/IEC 9075-2:2003
ISO/IEC 9075-3:2003
ISO/IEC 9075-4:2003
ISO/IEC 9075-5:1999