Simple Features

Simple Features(officiallySimple Feature Access) is a set of standards that specify a common storage and access model ofgeographic featuresmade of mostly two-dimensional geometries (point, line, polygon, multi-point, multi-line, etc.) used bygeographic databasesandgeographic information systems. It is formalized by both theOpen Geospatial Consortium(OGC) and theInternational Organization for Standardization(ISO).

The ISO 19125 standard comes in two parts. Part 1, ISO 19125-1 (SFA-CA for "common architecture" ), defines a model for two-dimensional simple features, with linear interpolation between vertices, defined in a hierarchy ofclasses;this part also definesrepresentation of geometryin text and binary forms. Part 2 of the standard, ISO 19125-2 (SFA-SQL), defines a "SQL/MM"language bindingAPI forSQLunder the prefix "ST_".^[1]Theopen accessOGC standards cover additionally APIs forCORBAandOLE/COM,although these have lagged behind the SQL one and are not standardized by ISO. There are also adaptations to other languages covered below.

The ISO/IEC 13249-3SQL/MM Spatialextends the Simple Features data model, originally based onstraight-line segments,addingcircular interpolations(e.g.circular arcs) and other features like coordinate transformations and methods for validating geometries, as well asGeography Markup Languagesupport.^[1]

Details

Part 1

The geometries are associated withspatial reference systems.The standard also specifiesattributes,methodsandassertionswith the geometries, in theobject-orientedstyle. In general, a 2D geometry is simple if it contains no self-intersection. The specification definesDE-9IMspatial predicates and several spatial operators that can be used to generate new geometries from existing geometries.

Part 2

Part 2 is a SQL binding to Part 1, providing a translation of the interface to non-object-oriented environments. For example, instead of asomeGeometryObject.isEmpty()as in Part 1, SQL/MM uses aST_IsEmpty(...)function in SQL.

Spatial

The spatial extension adds the datatypes "Circularstring", "CompoundCurve", "CurvePolygon", "PolyhedralSurface", the last of which is also included into the OGC standard. It also defines the SQL/MM versions of these types and operations on them.

Implementations

Direct implementations of Part 2 (SQL/MM) include:

MySQLSpatial Extensions.^[2]Up to MySQL 5.5, all of the functions that calculate relations between geometries are implemented usingbounding boxesnot the actual geometries.^[3]Starting from version 5.6, MySQL offers support for precise object shapes.^[4]
MonetDB/GISextension forMonetDB.^[5]
PostGISextension forPostgreSQL,also supporting some of the SQL/MM Spatial features.^[6]
SpatiaLiteextension forSQLite^[7]
Oracle Spatial,which also implements some of the advanced features from SQL/MM Spatial.^[8]
IBM Db2Spatial Extender andIBM InformixSpatial DataBlade.^[6]
Microsoft SQL Serversince version 2008,^[6]with significant additions in the 2012 version.^[9]
SAPSybase IQ.^[10]
SAP HANAas of 1.0 SPS6.^[11]

Adaptations include:

Implementations of the CORBA and OLE/COM interfaces detailed above are mainly produced by commercial vendors maintaining legacy technology.
R:The sf package^[12]implements Simple Features and contains functions that bind toGDALfor reading and writing data, to GEOS for geometrical operations, and toPROJfor projection conversions and datum transformations.
TheGDALlibrary implements the Simple Features data model in its OGR component.^[13]
TheJava-baseddeegreeframework implements SFA (part 1) and various other OGC standards.^[14]
TheRustlibrarygeo_typesimplements geometry primitives that adhere to the simple feature access standards.^[15]

GeoSPARQLis anOGCstandard that is intended to allow geospatially-linked datarepresentation and querying based onRDFandSPARQLby defining anontologyfor geospatial reasoning supporting a small Simple Features (as well asDE-9IMandRCC8)RDFS/OWLvocabulary forGMLandWKTliterals.^[16]

As of 2012, variousNoSQLdatabases had very limited support for "anything more complex than a bounding box or proximity search".^[3]

References

^^a ^bWolfgang Kresse; David M. Danko (2011).Springer Handbook of Geographic Information.Springer. pp.81–83.ISBN 978-3-540-72678-4.
^"MySQL 5.1 documentation on Spatial extensions".mysql.com.Retrieved2 April2018.
^^a ^bFrank Hardisty (Fall 2012)."Penn State Geography 583: Geospatial System Analysis and Design. Databases".
^"MySQL:: MySQL 5.6 Reference Manual:: 12.15.9 Functions That Test Spatial Relations Between Geometry Objects".dev.mysql.com.Retrieved2 April2018.
^"GeoSpatial - MonetDB".4 March 2014.
^^a ^b ^cWolfgang Kresse; David M. Danko (2011).Springer Handbook of Geographic Information.Springer. pp.105–106.ISBN 978-3-540-72678-4.
^"SpatiaLite: SpatiaLite".www.gaia-gis.it.Retrieved2 April2018.
^Ravikanth V. Kothuri; Euro Beinat; Albert Godfrind (2004).Pro Oracle Spatial.Apress. p. 65.ISBN 978-1-59059-383-7.
^Alastair Aitchison (2012).Pro Spatial with SQL Server 2012.Apress. pp. 21–23.ISBN 978-1-4302-3491-3.
^http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01964.1602/doc/html/saiq-standards-compatibility-spatial.htmlSAP Sybase IQ support for spatial data
^http://help.sap.com/saphelp_hanaplatform/helpdata/en/7a/2f4266787c1014a9b6ab6cf937f8ac/content.htm?frameset=/en/7a/2d11d7787c1014ac3a8663250814c2/frameset.htm&current_toc=/en/99/d10e4fdaaf41588480a43478e840d5/plain.htm&node_id=12SAP HANA Spatial Reference: Supported Import and Export Formats for Spatial Data
^Pebesma, Edzer; Bivand, Roger; Cook, Ian; Keitt, Tim; Sumner, Michael; Lovelace, Robin; Wickham, Hadley; Ooms, Jeroen; Racine, Etienne (22 March 2018)."sf: Simple Features for R".Retrieved2 April2018– via R-Packages.
^"FAQ: What is this OGR stuff?".www.gdal.org.Retrieved2 April2018.
^Shashi Shekhar; Hui Xiong (2007).Encyclopedia of GIS.Springer. pp. 235–236.ISBN 978-0-387-30858-6.
^"geo_types - Rust".docs.rs.Retrieved2023-03-19.
^Battle, Robert; Kolas, Dave (2012)."Enabling the Geospatial Semantic Web with Parliament and GeoSPARQL"(PDF).Semantic Web.3(4).IOS Press:355–370.doi:10.3233/SW-2012-0065.Retrieved21 November2012.

External links

Simple Features SWG

Standard documents

ISO/IEC:
- ISO 19125-1:2004 Geographic information -- Simple feature access -- Part 1: Common architecture
- ISO 19125-2:2004 Geographic information -- Simple feature access -- Part 2: SQL option
OpenGIS
- OpenGIS Implementation Specification for Geographic information - Simple feature access - Part 1: Common architecture (05-126, 06-103r3, 06-103r4),current version 1.2.1
- OpenGIS Simple Feature Access - Part 2: SQL Option (99-054, 05-134, 06-104r3, 06-104r4),current version 1.2.1, formerly OpenGIS Simple Features [Implementation Specification] for SQL
- OpenGIS Simple Features Implementation Specification for CORBA (99-054),current version 1.0
- OpenGIS Simple Features Implementation Specification for OLE/COM (99-050),current version 1.1

[KresseDanko2011-1] Wolfgang Kresse; David M. Danko (2011).Springer Handbook of Geographic Information.Springer. pp.81–83.ISBN 978-3-540-72678-4.

[2] "MySQL 5.1 documentation on Spatial extensions".mysql.com.Retrieved2 April2018.

[geog583-3] Frank Hardisty (Fall 2012)."Penn State Geography 583: Geospatial System Analysis and Design. Databases".

[4] "MySQL:: MySQL 5.6 Reference Manual:: 12.15.9 Functions That Test Spatial Relations Between Geometry Objects".dev.mysql.com.Retrieved2 April2018.

[gis-5] "GeoSpatial - MonetDB".4 March 2014.

[dbs-6] Wolfgang Kresse; David M. Danko (2011).Springer Handbook of Geographic Information.Springer. pp.105–106.ISBN 978-3-540-72678-4.

[7] "SpatiaLite: SpatiaLite".www.gaia-gis.it.Retrieved2 April2018.

[KothuriBeinat2004-8] Ravikanth V. Kothuri; Euro Beinat; Albert Godfrind (2004).Pro Oracle Spatial.Apress. p. 65.ISBN 978-1-59059-383-7.

[Aitchison2012-9] Alastair Aitchison (2012).Pro Spatial with SQL Server 2012.Apress. pp. 21–23.ISBN 978-1-4302-3491-3.

[10] ttp://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01964.1602/doc/html/saiq-standards-compatibility-spatial.htmlSAP Sybase IQ support for spatial data

[11] ttp://help.sap.com/saphelp_hanaplatform/helpdata/en/7a/2f4266787c1014a9b6ab6cf937f8ac/content.htm?frameset=/en/7a/2d11d7787c1014ac3a8663250814c2/frameset.htm&current_toc=/en/99/d10e4fdaaf41588480a43478e840d5/plain.htm&node_id=12SAP HANA Spatial Reference: Supported Import and Export Formats for Spatial Data

[12] Pebesma, Edzer; Bivand, Roger; Cook, Ian; Keitt, Tim; Sumner, Michael; Lovelace, Robin; Wickham, Hadley; Ooms, Jeroen; Racine, Etienne (22 March 2018)."sf: Simple Features for R".Retrieved2 April2018– via R-Packages.

[13] "FAQ: What is this OGR stuff?".www.gdal.org.Retrieved2 April2018.

[ShekharXiong2007-14] Shashi Shekhar; Hui Xiong (2007).Encyclopedia of GIS.Springer. pp. 235–236.ISBN 978-0-387-30858-6.

[15] "geo_types - Rust".docs.rs.Retrieved2023-03-19.

[16] Battle, Robert; Kolas, Dave (2012)."Enabling the Geospatial Semantic Web with Parliament and GeoSPARQL"(PDF).Semantic Web.3(4).IOS Press:355–370.doi:10.3233/SW-2012-0065.Retrieved21 November2012.

[1]

[2]

[3]

[4]

[5]

[6]

[7]

[8]

[9]

[10]

[11]

[12]

[13]

[14]

[15]

[16]

v t e ISOstandardsby standard number
List ofISO standards–ISO romanizations–IEC standards
1–9999	1 2 3 4 6 7 9 16 17 31 -0 -1 -3 -4 -5 -6 -7 -8 -9 -10 -11 -12 -13 68-1 128 216 217 226 228 233 259 261 262 302 306 361 500 518 519 639 -1 -2 -3 -5 -6 646 657 668 690 704 732 764 838 843 860 898 965 999 1000 1004 1007 1073-1 1073-2 1155 1413 1538 1629 1745 1989 2014 2015 2022 2033 2047 2108 2145 2146 2240 2281 2533 2709 2711 2720 2788 2848 2852 2921 3029 3103 3166 -1 -2 -3 3297 3307 3601 3602 3864 3901 3950 3977 4031 4157 4165 4217 4909 5218 5426 5427 5428 5725 5775 5776 5800 5807 5964 6166 6344 6346 6373 6385 6425 6429 6438 6523 6709 6943 7001 7002 7010 7027 7064 7098 7185 7200 7498 -1 7637 7736 7810 7811 7812 7813 7816 7942 8000 8093 8178 8217 8373 8501-1 8571 8583 8601 8613 8632 8651 8652 8691 8805/8806 8807 8820-5 8859 -1 -2 -3 -4 -5 -6 -7 -8 -8-I -9 -10 -11 -12 -13 -14 -15 -16 8879 9000/9001 9036 9075 9126 9141 9227 9241 9293 9314 9362 9407 9496 9506 9529 9564 9592/9593 9594 9660 9797-1 9897 9899 9945 9984 9985 9995
10000–19999	10006 10007 10116 10118-3 10160 10161 10165 10179 10206 10218 10279 10303 -11 -21 -22 -28 -238 10383 10585 10589 10628 10646 10664 10746 10861 10957 10962 10967 11073 11170 11172 11179 11404 11544 11783 11784 11785 11801 11889 11898 11940(-2) 11941 11941 (TR) 11992 12006 12052 12182 12207 12234-2 12620 13211 -1 -2 13216 13250 13399 13406-2 13450 13485 13490 13567 13568 13584 13616 13816 13818 14000 14031 14224 14289 14396 14443 14496 -2 -3 -6 -10 -11 -12 -14 -17 -20 14617 14644 14649 14651 14698 14764 14882 14971 15022 15189 15288 15291 15398 15408 15444 -3 -9 15445 15438 15504 15511 15686 15693 15706 -2 15707 15897 15919 15924 15926 15926 WIP 15930 15938 16023 16262 16355-1 16485 16612-2 16750 16949 (TS) 17024 17025 17100 17203 17369 17442 17506 17799 18004 18014 18181 18245 18629 18916 19005 19011 19092 -1 -2 19114 19115 19125 19136 19407 19439 19500 19501 19502 19503 19505 19506 19507 19508 19509 19510 19600 19752 19757 19770 19775-1 19794-5 19831
20000–29999	20000 20022 20121 20400 20802 20830 21000 21001 21047 21122 21500 21827 22000 22275 22300 22301 22395 22537 23000 23003 23008 23009 23090-3 23092 23094-1 23094-2 23270 23271 23360 23941 24517 24613 24617 24707 24728 25178 25964 26000 26262 26300 26324 27000 series 27000 27001 27002 27005 27006 27729 28000 29110 29148 29199-2 29500
30000+	30170 31000 32000 37001 38500 39075 40500 42010 45001 50001 55000 56000 80000
Category