ImageVerifierCode 换一换
格式:PDF , 页数:72 ,大小:824.06KB ,
资源ID:581527      下载积分:10000 积分
快捷下载
登录下载
邮箱/手机:
温馨提示:
如需开发票,请勿充值!快捷下载时,用户名和密码都是您填写的邮箱或者手机号,方便查询和重复下载(系统自动生成)。
如填写123,账号就是123,密码也是123。
特别说明:
请自助下载,系统不会自动发送文件的哦; 如果您已付费,想二次下载,请登录后访问:我的下载记录
支付方式: 支付宝扫码支付 微信扫码支付   
注意:如需开发票,请勿充值!
验证码:   换一换

加入VIP,免费下载
 

温馨提示:由于个人手机设置不同,如果发现不能下载,请复制以下地址【http://www.mydoc123.com/d-581527.html】到电脑端继续下载(重复下载不扣费)。

已注册用户请登录:
账号:
密码:
验证码:   换一换
  忘记密码?
三方登录: 微信登录  

下载须知

1: 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。
2: 试题试卷类文档,如果标题没有明确说明有答案则都视为没有答案,请知晓。
3: 文件的所有权益归上传用户所有。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 本站仅提供交流平台,并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

版权提示 | 免责声明

本文(BS EN ISO 19125-2-2005 Geographic information - Simple feature access - SQL option《地理信息 简单特征选取 结构化查询语言(SQL)选项》.pdf)为本站会员(registerpick115)主动上传,麦多课文库仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对上载内容本身不做任何修改或编辑。 若此文所含内容侵犯了您的版权或隐私,请立即通知麦多课文库(发送邮件至master@mydoc123.com或直接QQ联系客服),我们立即给予删除!

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

copyright@ 2008-2019 麦多课文库(www.mydoc123.com)网站版权所有
备案/许可证编号:苏ICP备17064731号-1