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) |
|
(No difference)
|
Revision as of 20:42, 25 February 2017
Overview)
Full name | ISO 19125-2:2004, Geographic information – Simple feature access – Part 2: SQL option |
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 |
Related standard(s) | ISO 19125-1:2004, Geographic information – Simple feature access – Part 1: Common access ISO 19107:2003, Geographic information – Spatial schema |
Application | Part two of ISO 19125 specifies an SQL schema that supports storage, retrieval, query and update of simple geo-spatial 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 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. |
Products | Two popular implementations of ISO 19125-2 are PostGIS (an extension of PostgreSQL) and Oracle Spatial. |