Are all SQL Geospatial databases available?

Question

My team is exploring the geospatial features offered by various database platforms.

Are all implementation databases specific or is there an ANSI SQL standard or similar type of standard that is proposed or will be offered in the future?

I ask because I would like the implemented code to be an agnostic database as soon as possible (our project is written as ANSI SQL standard).

Is there any known plan to standardize this functionality in the future?

Answer 1

There are currently several specifications followed by popular proprietary and open source spatial database implementations:

• OpenGIS - Simple Functions for SQL
• ISO Multimedia Data Specification for Features - ISO / IEC 13249-3: 2006 - Information Technology - Database Languages ​​- SQL Multimedia and Multimedia Tools Application Packages - Part 3: Spatial

PostGIS, Oracle, Microsoft SQL Server and, to some extent, MySQL, all databases implement standard interfaces for managing spatial data. However, despite these fairly standardized functions, all databases usually differ at a simple SQL level, which can make it difficult to implement your solution in a database. You probably need to explore the features you are interested in and compare what different providers provide.

Answer 2

For example, the GIS extensions for MySQL and for PostgreSQL both follow the OpenGIS standard "Standard Specifications for SQL" .

Answer 3

I have not tried it, but Google tells me FDO - it is an "open source API for managing, defining and analyzing geospatial information, no matter where it is stored." He listed on osgeo.org - a point in his favor, in my opinion.

There are MySQL and Oracle providers. Disappointing, although SQL Server and Postgis are not listed on the providers page.

Answer 4

The only standard I know about is http://www.opengeospatial.org/standards/sfs , and I don’t know how well all spatial database extensions implement it.

Answer 5

there are a number of geodata available using spatial sleep mode

• Oracle10g
• Postgresql
• MySQL

using an abstraction layer like hibernate is a good idea if you plan on writing an agnostic database application. hibernatespatial fills this gap for geo functions.