Difference between revisions of "ISO 19125-2:2004 Geographic information - Simple feature access - Part 2: SQL option"
Jump to navigation
Jump to search
Vrautenbach (talk | contribs) |
PeterParslow (talk | contribs) (withdrawn in favour of ISO/IEC 13249-3:2016) |
||
(5 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
− | ==Overview | + | ==Overview == |
{| class="wikitable" | {| class="wikitable" | ||
| Full name | | Full name | ||
− | | [http://www.iso.org/iso/home/store/catalogue_tc/catalogue_detail.htm?csnumber=40115 ISO 19125-2:2004, Geographic information | + | | [http://www.iso.org/iso/home/store/catalogue_tc/catalogue_detail.htm?csnumber=40115 ISO 19125-2:2004, Geographic information - Simple feature access - Part 2: SQL option] (withdrawn 2018) |
|- | |- | ||
| Version | | Version | ||
Line 24: | Line 24: | ||
| Type of standard | | Type of standard | ||
| ISO International Standard <br/>Meta level | | ISO International Standard <br/>Meta level | ||
− | |||
− | |||
− | |||
|- | |- | ||
| Application | | Application | ||
− | | Part two of ISO 19125 specifies an SQL schema that supports storage, retrieval, query and update of simple | + | | Part two of ISO 19125 specifies an SQL schema that supports storage, retrieval, query and update of simple geographic feature collections. |
|- | |- | ||
| Conformance classes | | Conformance classes | ||
Line 35: | Line 32: | ||
|- | |- | ||
| Implementation benefits | | Implementation benefits | ||
− | | | + | | ISO 19125-2 standardizes the names and geometric definitions of the SQL Types for the Geometry class, and names, signatures and geometric definitions of the SQL Functions for Geometry. The implementation of ISO 19125-2 is an extension of SQL and is very simple to use. This extension of SQL is a very effective method of querying a database or performing complex analysis.<br/>Withdrawn in 2018 on publication of ISO/IEC 13249-3:2016 which moved "SQL spatial" into the mainstream |
|- | |- | ||
| Products | | Products | ||
− | | Two popular implementations of [http:// | + | | Two popular implementations of ISO 19125-2 are [http://postgis.net PostGIS] (an extension of PostgreSQL) and [https://www.oracle.com/database/spatial/index.html Oracle Spatial]. |
|} | |} | ||
+ | |||
+ | ==See also== | ||
+ | * [[ISO 19125-1:2004 Geographic information - Simple feature access - Part 1: Common access]] | ||
+ | * [[ISO 19107:2003 Geographic information - Spatial schema]] |
Latest revision as of 18:25, 13 April 2022
Overview
Full name | ISO 19125-2:2004, Geographic information - Simple feature access - Part 2: SQL option (withdrawn 2018) |
Version | Edition 1 |
Amendments | None |
Corrigenda | None |
Published by | ISO/TC 211 |
Languages | English |
Online overview | https://www.iso.org/obp/ui/#iso:std:iso:19125:-2:ed-1:v1:en |
Type of standard | ISO International Standard Meta level |
Application | Part two of ISO 19125 specifies an SQL schema that supports storage, retrieval, query and update of simple geographic feature collections. |
Conformance classes | SQL SQL with Geometry Types |
Implementation benefits | ISO 19125-2 standardizes the names and geometric definitions of the SQL Types for the Geometry class, and names, signatures and geometric definitions of the SQL Functions for Geometry. The implementation of ISO 19125-2 is an extension of SQL and is very simple to use. This extension of SQL is a very effective method of querying a database or performing complex analysis. Withdrawn in 2018 on publication of ISO/IEC 13249-3:2016 which moved "SQL spatial" into the mainstream |
Products | Two popular implementations of ISO 19125-2 are PostGIS (an extension of PostgreSQL) and Oracle Spatial. |