BS EN ISO 19125-2-2005 Geographic information - Simple feature access - SQL option《地理信息 简单特征选取 结构化查询语言(SQL)选项》.pdf

1、BRITISH STANDARDBS EN ISO 19125-2:2006IncorporatingAmendment No. 1 (renumbers BS ISO 19125-2:2004 as BS EN ISO 19125-2:2006)Geographicinformation Simple feature accessPart 2: SQL optionThe European Standard EN ISO 19125-2:2006 has the status of a British StandardICS 35.240.70BS EN ISO 19125-2:2006Th

2、is British Standard was published under the authority of the Standards Policy and Strategy Committee on 8 February2005National forewordThis British Standard is the official English language version of EN ISO 19125-2:2006. It is identical with ISO 19125-2:2004.The UK participation in its preparation

3、was entrusted to Technical Committee IST/36, Geographic information, which has the responsibility to:A list of organizations represented on this committee can be obtained on request to its secretary.Cross-referencesThe British Standards which implement international publications referred to in this

4、document may be found in the BSI Catalogue under the section entitled “International Standards Correspondence Index”, or by using the “Search” facility of the BSI Electronic Catalogue or of British Standards Online.This publication does not purport to include all the necessary provisions of a contra

5、ct. Users are responsible for its correct application. Compliance with a British Standard does not of itself confer immunity from legal obligations. aid enquirers to understand the text; present to the responsible international/European committee any enquiries on the interpretation, or proposals for

6、 change, and keep the UK interests informed; monitor related international and European developments and promulgate them in the UK.Summary of pagesThis document comprises a front cover, an inside front cover, the EN title page, the ISO title page, pages iv to viii, a blank page, pages 1 to 61 and a

7、back cover.The BSI copyright notice displayed in this document indicates when the document was last issued.Amendments issued since publicationAmd. No. Date Comments16387 June 2006 Renumbers BS ISO 19125-2:2004 as BS EN ISO 19125-2:2006ISBN 0 580 45412 6 BSI June 2006EUROPEAN STANDARDNORME EUROPENNEE

8、UROPISCHE NORMEN ISO 19125-2March 2006ICS 35.240.70English VersionGeographic information - Simple feature access - Part 2: SQLoption (ISO 19125-2:2004)Information gographique - Accs aux entits simples -Partie 2: Option SQL (ISO 19125-2:2004)Geoinformation - Simple feature access - Teil 2: Structured

9、Query Language (SQL) (ISO 19125-2:2004)This European Standard was approved by CEN on 16 February 2006.CEN members are bound to comply with the CEN/CENELEC Internal Regulations which stipulate the conditions for giving this EuropeanStandard the status of a national standard without any alteration. Up

10、-to-date lists and bibliographical references concerning such nationalstandards may be obtained on application to the Central Secretariat or to any CEN member.This European Standard exists in three official versions (English, French, German). A version in any other language made by translationunder

11、the responsibility of a CEN member into its own language and notified to the Central Secretariat has the same status as the officialversions.CEN members are the national standards bodies of Austria, Belgium, Cyprus, Czech Republic, Denmark, Estonia, Finland, France,Germany, Greece, Hungary, Iceland,

12、 Ireland, Italy, Latvia, Lithuania, Luxembourg, Malta, Netherlands, Norway, Poland, Portugal, Romania,Slovakia, Slovenia, Spain, Sweden, Switzerland and United Kingdom.EUROPEAN COMMITTEE FOR STANDARDIZATIONCOMIT EUROPEN DE NORMALISATIONEUROPISCHES KOMITEE FR NORMUNGManagement Centre: rue de Stassart

13、, 36 B-1050 Brussels 2006 CEN All rights of exploitation in any form and by any means reservedworldwide for CEN national Members.Ref. No. EN ISO 19125-2:2006: EEN ISO 19125-2:2006 (E) Foreword The text of ISO 19125-2:2004 has been prepared by Technical Committee ISO/TC 211 “Geographic information/Ge

14、omatics” of the International Organization for Standardization (ISO) and has been taken over as EN ISO 19125-2:2006 by Technical Committee CEN/TC 287 “Geographic Information“, the secretariat of which is held by NEN. This European Standard shall be given the status of a national standard, either by

15、publication of an identical text or by endorsement, at the latest by September 2006, and conflicting national standards shall be withdrawn at the latest by September 2006. According to the CEN/CENELEC Internal Regulations, the national standards organizations of the following countries are bound to

16、implement this European Standard: Austria, Belgium, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Iceland, Ireland, Italy, Latvia, Lithuania, Luxembourg, Malta, Netherlands, Norway, Poland, Portugal, Romania, Slovakia, Slovenia, Spain, Sweden, Switzerland and U

17、nited Kingdom. Endorsement noticeThe text of ISO 19125-2:2004 has been approved by CEN as EN ISO 19125-2:2006 without any modifications. Reference numberISO 19125-2:2004(E)OSI 4002INTERNATIONAL STANDARDISO19125-2First edition2004-08-01Geographic information Simple feature access Part 2: SQL option I

18、nformation gographique Accs aux entits simples Partie 2: Option SQL BS EN ISO 191252:2006,62 ( 3OFVLG)UHPLDLK7V3)ILOHPDFWQRLDQHPGHEWGHGIHSFDHV,QFFDRFQDGUZHLW K$ HERGVOLFHQVLORSJQLFWKLVILOHPDLUSHEQWHGLYURZHEG HWXVODKOWRQLGHHEWOQXGHHVVWKHWSHIDFHVZKLFHHUDKPOHUDGHGGHELFVQHGHWRLGQDQVWODOHGWQRHKFRPSXWIUHS

19、UHRUPLJQWLGHHKWLQJ,QZRGOQLGDRWJQKLVILOHWUDSLVHDWSHFFWLHUHKWQVHUHKQRSVLLEOLWIRQRWLQIULLJQJQ$ HERGVOLFHQVLORSJQLFHK7,62WQH 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 Defin

20、ed 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 profil

21、e 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. In particular, a compliant system may be shipped to the database user with the set of Geom

22、etry Types and Functions already built into the SQL-implementation, or with the set of Geometry Types and Functions supplied to the database user as a dynamically loaded extension to the SQL-implementation or in any other manner not mentioned in this part of ISO 19125. BS EN ISO 191252:2006IS-52191

23、O2:(4002E) 2 I SO 4002 All irthgs ersedevr2 Conformance In order to conform to this part of ISO 19125, an implementation shall satisfy the requirements of one of the following three conformance classes, as well as the appropriate components of ISO 19125-1: a) SQL implementation of feature tables bas

24、ed on predefined data types: 1) using numeric SQL types for geometry storage and SQL/CLI access, 2) using binary SQL types for geometry storage and SQL/CLI access; b) SQL with Geometry Types implementation of feature tables supporting both textual and binary SQL/CLI access to geometry. Annex B provi

25、des conformance tests for each implementation of this part of ISO 19125. 3 Normative references The following referenced documents are indispensable for the application of this document. For dated references, only the edition cited applies. For undated references, the latest edition of the reference

26、d document (including any amendments) applies. ISO/IEC 9075-1:2003, Information technology Database languages SQL Part 1: Framework (SQL/Framework)ISO/IEC 9075-2:2003, Information technology Database languages SQL Part 2: Foundation (SQL/Foundation)ISO/IEC 9075-3:2003, Information technology Databas

27、e languages SQL Part 3: Call-Level Interface (SQL/CLI)ISO/IEC 9075-4:2003, Information technology Database languages SQL Part 4: Persistent Stored Modules (SQL/PSM)ISO/IEC 9075-5:1999, Information technology Database languages SQL Part 5: Host Language Bindings (SQL/Bindings)ISO/IEC 13249-3:2003, In

28、formation technology Database languages SQL multimedia and application packages Part 3: SpatialISO 19107:2003, Geographic information Spatial schemaISO 19109:1), Geographic information Rules for application schemaISO 19119:2004, Geographic information ServicesISO 19125-1:2004, Geographic information

29、 Simple feature access Part 1: Common architecture4 Terms and definitions For the purposes of this part of ISO 19125, the following terms and definitions apply. 4.1feature table table where the columns represent feature attributes, and the rows represent features 1) To be published. BS EN ISO 191252

30、:2006IS-52191 O2:(4002E) I SO 4002 All irthgs ersedevr 34.2geographic feature representation of real world phenomenon associated with a location relative to the Earth 5 Symbols and abbreviated terms FID Feature ID column in the implementation of feature tables based on predefined data types GID Geom

31、etry ID column in the implementation of feature tables based on predefined data types MM Multimedia SQL Structured Query Language SRID Spatial Reference System Identifier SRTEXT Spatial Reference System Well Known Text WKB Well-Known Binary (representation for example, geometry) WKTR Well-Known Text

32、 Representation 2D 2-Dimensional 11-Dimensional space 22-Dimensional space empty set intersection union difference is a member of is not a member of is a proper subset of is a subset of if and only if implies for all X | set of X such that and or not equal z not equal less than ! greater than BS EN

33、ISO 191252:2006IS-52191 O2:(4002E) 4 I SO 4002 All irthgs ersedevr6 Architecture 6.1 Architecture SQL implementation of feature tables based on predefined data types 6.1.1 Overview This part of ISO 19125 defines a schema for the management of feature table, Geometry, and Spatial Reference System inf

34、ormation in an SQL-implementation based on predefined data types. This part of ISO 19125 does not define SQL functions for access, maintenance, or indexing of Geometry in an SQL-implementation based on predefined data types. Figure 1 illustrates the schema to support feature tables, Geometry, and Sp

35、atial Reference Information in an SQL-implementation based on predefined data types. a) The GEOMETRY_COLUMNS table describes the available feature tables and their Geometry properties. b) The SPATIAL_REF_SYS table describes the coordinate system and transformations for Geometry. c) The feature table

36、 stores a collection of features. A feature tables columns represent feature attributes, while rows represent individual features. The Geometry of a feature is one of its feature attributes; while logically a geometric data type, a Geometry Column is implemented as a foreign key to a geometry table.

37、 d) The geometry table stores geometric objects, and may be implemented using either standard SQL numeric types or SQL binary types. Figure 1 Schema for feature tables using predefined data types Depending upon the storage type specified by the GEOMETRY_COLUMNS table, a geometric object is stored ei

38、ther as an array of coordinate values or as a single binary value. In the former case, predefined SQL numeric types are used for the coordinates and these numeric values are obtained from the geometry table until the geometric object has been fully reconstructed. In the latter case, the complete geo

39、metric object is obtained in the Well-known Binary Representation as a single value. BS EN ISO 191252:2006IS-52191 O2:(4002E) I SO 4002 All irthgs ersedevr 56.1.2 Identification of feature tables and geometry columns Feature tables and Geometry columns are identified through the GEOMETRY_COLUMNS tab

40、le. Each Geometry Column in the database has an entry in the GEOMETRY_COLUMNS table. The data stored for each geometry column consists of the following: a) the identity of the feature table of which this Geometry Column is a member; b) the name of the Geometry Column; c) the spatial reference system

41、 ID (SRID) for the Geometry Column; d) the type of Geometry for the Geometry column; e) the coordinate dimension for the Geometry Column; f) the identity of the geometry table that stores geometric objects for this Geometry Column; g) the information necessary to navigate the geometry table in the c

42、ase of normalized geometry storage. 6.1.3 Identification of Spatial Reference Systems Every Geometry Column is associated with a Spatial Reference System. The Spatial Reference System identifies the coordinate system for all geometric objects stored in the column, and gives meaning to the numeric co

43、ordinate values for any geometric object stored in the column. Examples of commonly used Spatial Reference Systems include “Latitude Longitude” and “UTM Zone 10”. The SPATIAL_REF_SYS table stores information on each Spatial Reference System in the database. The columns of this table are the Spatial

44、Reference System Identifier (SRID), the Spatial Reference System Authority Name (AUTH_NAME), the Authority Specific Spatial Reference System Identifier (AUTH_SRID) and the Well-known Text description of the Spatial Reference System (SRTEXT). The Spatial Reference System Identifier (SRID) constitutes

45、 a unique integer key for a Spatial Reference System within a database. Interoperability between clients is achieved via the SRTEXT column which stores the Well-known Text representation for a Spatial Reference System. 6.1.4 Feature tables A feature is an abstraction of a real-world object. Feature

46、attributes are columns in a feature table. Features are rows in a feature table. The Geometry of a feature is one of its feature attributes; while logically a geometric data type, a geometry column is implemented as a foreign key to a geometry table. Relationships between features may be defined as

47、foreign key references between feature tables. 6.1.5 Geometry tables 6.1.5.1 Normalized geometry schema The normalized geometry schema stores the coordinates of geometric objects as predefined SQL numeric types. One or more coordinates (X and Y ordinate values) will be represented by pairs of numeric types in the geometry table, as shown in Figure 2. Each geometric object is identified by a key (GID) and consists of one or more primitive elements ordered by an element sequence (ESEQ). Each primitive element in t