標準號：ISO 19125-2-2004
中文標準名稱：地理信息.簡單特征選取.第2部分:SQL方案
英文標準名稱：Geographic information - Simple feature access - Part 2: SQL option
標準類型：A76
發布日期：1999/12/31 12:00:00
實施日期：1999/12/31 12:00:00
中國標準分類號：A76
國際標準分類號：35.240.70
適用范圍：This part of ISO 19125 specifies an SQL schema that supports storage, retrieval, query and update of simplegeospatial feature collections via the SQL Call Level Interface (SQL/CLI) (ISO/IEC 9075-3:2003).This part of ISO 19125 establishes an architecture for the implementation of feature tables.This part of ISO 19125 defines terms to use within the architecture.This part of ISO 19125 defines a simple feature profile of ISO 19107.This part of ISO 19125 describes a set of SQL Geometry Types together with SQL functions on those types.The Geometry Types and Functions described in this part of ISO 19125 represent a profile of ISO 13249-3.This part of ISO 19125 does not attempt to standardize and does not depend upon any part of the mechanismby which Types are added and maintained in the SQL environment including the following:a) the syntax and functionality provided for defining types;b) the syntax and functionality provided for defining SQL functions;c) the physical storage of type instances in the database;d) specific terminology used to refer to User Defined Types, for example, UDT.This part of ISO 19125 does standardize:? names and geometric definitions of the SQL Types for Geometry;? names, signatures and geometric definitions of the SQL Functions for Geometry.This part of ISO 19125 describes a feature access implementation in SQL based on a profile of ISO 19107.ISO 19107 does not place any requirements on how to define the Geometry Types in the internal schema.ISO 19107 does not place any requirements on when or how or who defines the Geometry Types. Inparticular, a compliant system may be shipped to the database user with the set of Geometry Types andFunctions already built into the SQL-implementation, or with the set of Geometry Types and Functionssupplied to the database user as a dynamically loaded extension to the SQL-implementation or in any othermanner not mentioned in this part of ISO 19125.