Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Are all SQL Geospatial implementations database specific?

Tags:

sql

tsql

geospatial

ansi-sql

My team is looking into geospatial features offered by different database platforms.

Are all of the implementations database specific, or is there a ANSI SQL standard, or similar type of standard, which is being offered, or will be offered in the future?

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

Is there any known plan for standardization of this functionality in the future?

like image 647
pearcewg Avatar asked Mar 16 '09 19:03

pearcewg

People also ask

What is SQL spatial database?

Spatial data represents information about the physical location and shape of geometric objects. These objects can be point locations or more complex objects such as countries/regions, roads, or lakes. SQL Server supports two spatial data types: the geometry data type and the geography data type.

How do spatial databases differ from regular databases?

It is important to make the distinction between typical databases and spatial databases. Spatial databases are standard databases that have been extended to accept spatial data types and queries. Spatial data types store feature geometry that describes shape and location.

Does Azure SQL support spatial data?

Azure PostgreSQL with PostGIS Extension A key extension within PG is called PostGIS, which would be recognised as a best-of-breed feature to support many spatial types and functions. It can store both Vector and Raster.

What is geometry data type in SQL?

The planar spatial data type, geometry, is implemented as a common language runtime (CLR) data type in SQL Server. This type represents data in a Euclidean (flat) coordinate system. SQL Server supports a set of methods for the geometry spatial data type.

2 Answers

Currently, there are more than one specifications followed by popular proprietary and open source implementations of spatial databases:

  • The OpenGIS - Simple Features for SQL
  • ISO SQL Multimedia Specification for Spatial - ISO/IEC 13249-3:2006 - Information technology -- Database languages -- SQL multimedia and application packages -- Part 3: Spatial

PostGIS, Oracle, Microsoft SQL Server and to some limited degree MySQL, all the databases implement the standard interfaces to manipulate spatial data. However, in spite of this fairly standardized features, all databases usually differ on simple SQL level what may make the database-agnostic implementation of your solution tricky. You likely need to survey the features you are interested and compare what various vendors provide.

like image 136
mloskot Avatar answered Sep 21 '22 09:09

mloskot

For example GIS extensions for MySQL and for PostgreSQL both follow OpenGIS "Simple Features Specification for SQL" standard.

like image 43
vartec Avatar answered Sep 25 '22 09:09

vartec
Sign in to Comment

Related questions

Postgresql: Violates check constraint. Failing row contains
Why do you need to include a field in GROUP BY when using OVER (PARTITION BY x)?
Conditional JOIN based on column value
Why is the Max function used when we pivot text columns in SQL Server?
Wordpress SQL: get post category and tags
Updating a column from a varchar to jsonb
sp_OAGetProperty returning NULL with OUT variable declared as MAX
Where can I find usage statistics in Redshift?
SQL equivalent for Pandas's [df.groupby(...)['col_name'].shift(1)]
MySQL select from INT column
Fill in gaps in data, using a value proportional to the gap distance to data from the surrounding rows?
Abbreviation of Strings that Remains Unique
Select rows until running sum reaches specific value
add a column from a select query with index
How to join comma separated column values with another table as rows
Get date range gaps from a date set
Oracle equivalent of information_schema.tables
Condensing arrays in Presto
Microsoft SQL Server - best way to 'Update if exists, or Insert'
String list in SqlCommand through Parameters in C#

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!