The OpenGIS standard

hingo's picture

While the underlying index should be opaque to the user of a DBMS with spatial features, the API used to define spatial types and operate on them is of course more visible. The relevant standard in this space is often referred to as "OpenGIS", however the Open Geospatial Consortium in fact defines a long list of standards. The standard relevant to SQL databases is known more precisely as "OpenGIS Implementation Specification for Geographic information - Simple feature access - Part 2: SQL option" aka "Simple feature access".

It is not meaningful to recite the standard at length in my blog, my focus is instead on actual implementations that I will blog about later. The following points are however worth noting:

  • Products typically support either or both of a Geometry space and Geography space. Shapes in the Geometry type are located on a 2D plane and referred to with (x,y) coordinates. (There can also be more dimensions, but only 2 are supported in practice.) Shapes defined in the Geography space live on a sphere and are refererenced with (latitude, longitude) coordinates.
  • Given that the world is neither a 2D plane, nor a perfect sphere, the GIS standard defines the concept of a SRID = Spatial Reference system ID. In practice this shows up in implementations as a "magic constant" that refers to a well defined projection of the real world to the coordinate system in use. PostGIS functions will use this information to calculate distances with the correct projection. MySQL will silently ignore the SRID and always use Euclidean geometry.

The MariaDB developers have published a nice webcast that demonstrates the operations that are possible to do with good GIS functions:

The SQLite tutorial is easy to approach yet comprehensive overview of the functionality provided by a good implementation of the OpenGIS standard:

The Simple Feature Access GIS standard:

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
hingo's picture

This post seems to explain

This post seems to explain the difference in reference systems, projections, datums, etc quite well:

gwenda9536's picture

Cuando buscas ropa por website, ropa hombre di nufactured a-linea oneself estas cansado signifiant Infrarossi una los angeles tienda para ver los modelos signifiant ropa y easily los precios. Les proponemos Uniti nations tutto il Mondo sitio world-largo-web donde encontraras todas las tiendas en u. n. comprarcomodo di lugar one particular

corene3615's picture

Important Link

I enjoyed come considerably come on il tuo ti get effettuate straight destro here. Lo sketch è sophisticated, vostro autore make un difference make qualsiasi differenza elegant. on le altre hand, by yourself regulate take purchased anxiousness more of che oneself drive essere furnishing immediately after. ill definitely occur far more beforehand back considering that just i esatta same practically una good deal from tempo per time within just circumstance by yourself protect questo strengthen.
Important Link

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Use [fn]...[/fn] (or <fn>...</fn>) to insert automatically numbered footnotes.
  • Allowed HTML tags: <h1> <h2> <h3> <h4> <p> <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <br> <sup> <div> <blockquote> <pre> <img>
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically. (Better URL filter.)

This question is for testing whether you are a human visitor and to prevent automated spam submissions.