Difference between revisions of "Panorama SIG Libre 2014/Bases de datos"

From OSGeo
Jump to navigation Jump to search
Line 3: Line 3:
 
  [https://github.com/OSGeo-ES/panorama-siglibre8/issues/8 discussion] (in Spanish)
 
  [https://github.com/OSGeo-ES/panorama-siglibre8/issues/8 discussion] (in Spanish)
  
−
== Introduction ==  
+
== Main Information ==  
−
 
 
−
Some databases have spatial extensions that can be used to store geometrical data and operate them. Short history about this TODO.
 
−
 
 
−
== State of the Art ==
 
−
 
 
−
Dentro de la sección, hacia donde se está moviendo la comunidad.
 
−
 
 
−
== Software ==
 
−
 
 
−
This database extensions are usually based on a basic geometric data type you can operate with. The only background you really need to use this geometric database extensions is the same as working with any database.
 
  
 
{| class="wikitable sortable"  style="text-align: center;"
 
{| class="wikitable sortable"  style="text-align: center;"

Revision as of 00:46, 17 March 2014

Work in progress
discussion (in Spanish)

Main Information

Name Year OSGeo Live License Ohloh Tech
PostGIS 2005 G ✓ GPL v2 ohloh C/C++
MySQL Spatial ??? ☹ ☹ Oracle ohloh C/C++
Spatialite 2008 ☹ ☹ MPL tri-license ohloh C/C++
H2GIS 2008 ☹ ☹ GPL3 ☹ Java

Compliance with Simple Feature Access OGC Standard

Name Binary Geometry Normalized Geometry Types and Functions
PostGIS ✓ ✓ ✓
MySQL Spatial ☹ ☹ ☹[1]
Spatialite ✓ ✓ ✓
H2GIS ✓ ✓ ✓
  1. ↑ Partially supported

Documentation

Name Full Documentation Where to start
PostGIS Official 2.0 doc Introduction
MySQL Spatial Official 5.0 doc No Official one
Spatialite Official 2.3.1 doc 5 minutes
H2GIS Official doc Quick-start guide

More info here.

Examples

References