Difference between revisions of "ISO 19125-2:2004 Geographic information - Simple feature access - Part 2: SQL option"

From ICA Wiki
Jump to navigation Jump to search
Line 1: Line 1:
==Overview) ==  
+
==Overview ==  
 
{| class="wikitable"
 
{| class="wikitable"
 
| Full name
 
| Full name
Line 24: Line 24:
 
| Type of standard
 
| Type of standard
 
| ISO International Standard <br/>Meta level
 
| ISO International Standard <br/>Meta level
|-
 
| Related standard(s)
 
|[http://wiki.icaci.org/index.php?title=Simple_feature_access_%E2%80%93_Part_1:_Common_access ISO 19125-1:2004, Geographic information – Simple feature access – Part 1: Common access] <br/>[http://wiki.icaci.org/index.php?title=Spatial_schema ISO 19107:2003, Geographic information – Spatial schema]
 
 
|-
 
|-
 
| Application
 
| Application
Line 40: Line 37:
 
| Two popular implementations of [http://www.iso.org/iso/home/store/catalogue_tc/catalogue_detail.htm?csnumber=40115 ISO 19125-2] are PostGIS (an extension of PostgreSQL) and Oracle Spatial.
 
| Two popular implementations of [http://www.iso.org/iso/home/store/catalogue_tc/catalogue_detail.htm?csnumber=40115 ISO 19125-2] are PostGIS (an extension of PostgreSQL) and Oracle Spatial.
 
|}
 
|}
 +
 +
==See also==
 +
* [[ISO 19125-1:2004 Geographic information - Simple feature access - Part 1: Common access]]
 +
* [[ISO 19107:2003 Geographic information - Spatial schema]]

Revision as of 19:44, 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
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.

See also