Simple Features (officially Simple Feature Access) is both an Open Geospatial Consortium (OGC) and International Organization for Standardization (ISO) standard ISO 19125 that specifies a common storage and access model of mostly two-dimensional geometries (point, line, polygon, multi-point, multi-line, etc.) used by geographic information systems.
The ISO 19125 standard comes in two parts. Part one, ISO 19125-1 (SFA-CA for "common architecture"), defines a model for two-dimensional simple features, with linear interpolation between vertices. The data model defined in SFA-CA is a hierarchy of classes. This part also defines representation using Well-Known Text (and Binary). Part 2 of the standard, ISO 19125-2 (SFA-SQL), defines an implementation using SQL. The OpenGIS standard(s) cover implementations in CORBA and OLE/COM as well, although these have lagged behind the SQL one and are not standardized by ISO.
The ISO/IEC 13249-3 SQL/MM Spatial extends the Simple Features data model mainly with circular interpolations (e.g. circular arcs) and adds other features like coordinate transformations and methods for validating geometries as well as Geography Markup Language support.
- 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
Part 1 details
The geometries are also associated with spatial reference systems. The standard also specifies attributes, methods and assertions with the geometries. In general, a 2D geometry is simple if it contains no self-intersection. The specification defines DE-9IM spatial predicates and several spatial operators that can be used to generate new geometries from existing geometries.
Part 2 of Simple Feature Access is implemented to varying degrees in:
- The sf package implements for Simple Features for R and contains functions that bind to GDAL for reading and writing data, to GEOS for geometrical operations, and to Proj.4 for projection conversions and datum transformations.
- MySQL Spatial Extensions. Up to MySQL 5.5, all of the functions that calculate relations between geometries are implemented using bounding boxes not the actual geometries. Starting from version 5.6, MySQL offers support for precise object shapes.
- MonetDB/GIS extension for MonetDB.
- PostGIS extension for PostgreSQL, also supporting some of the SQL/MM Spatial features.
- SpatiaLite extension for SQLite
- Oracle Spatial, which also implements some of the advanced features from SQL/MM Spatial.
- IBM DB2 Spatial Extender and IBM Informix Spatial DataBlade.
- Microsoft SQL Server since version 2008, with significant additions in the 2012 version.
- SAP Sybase IQ.
- SAP HANA as of 1.0 SPS6.
GeoSPARQL is an OGC standard that is intended to allow geospatially-linked data representation and querying based on RDF and SPARQL by defining an ontology for geospatial reasoning supporting a small Simple Features (as well as DE-9IM and RCC8) RDFS/OWL vocabulary for GML and WKT literals.
As of 2012, various NoSQL databases had very limited support for "anything more complex than a bounding box or proximity search".
- Wolfgang Kresse; David M. Danko (2011). Springer Handbook of Geographic Information. Springer. pp. 81–83. ISBN 978-3-540-72678-4.
- 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". Retrieved 2 April 2018 – via R-Packages.
- "MySQL 5.1 documentation on Spatial extensions". mysql.com. Retrieved 2 April 2018.
- Frank 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. Retrieved 2 April 2018.
- "GeoSpatial - MonetDB". 4 March 2014.
- Wolfgang 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. Retrieved 2 April 2018.
- 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.html SAP Sybase IQ support for spatial data
- http://help.sap.com/saphelp_hanaplatform/helpdata/en/7a/2f4266787c1014a9b6ab6cf937f8ac/content.htm?frameset=/en/7a/2d11d7787c1014ac3a8663250814c2/frameset.htm¤t_toc=/en/99/d10e4fdaaf41588480a43478e840d5/plain.htm&node_id=12 SAP HANA Spatial Reference: Supported Import and Export Formats for Spatial Data
- "Redirection". www.gdal.org. Retrieved 2 April 2018.
- Shashi Shekhar; Hui Xiong (2007). Encyclopedia of GIS. Springer. pp. 235–236. ISBN 978-0-387-30858-6.
- Battle, Robert; Kolas, Dave (2012). "Enabling the Geospatial Semantic Web with Parliament and GeoSPARQL" (PDF). Semantic Web. IOS Press. 3 (4): 355–370. doi:10.3233/SW-2012-0065. Retrieved 21 November 2012.