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

From OSGeo
Jump to navigation Jump to search
 
(8 intermediate revisions by the same user not shown)
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;"
Line 23: Line 13:
 
! Ohloh
 
! Ohloh
 
! Tech
 
! Tech
! OGC Compliant
+
|-
 +
| [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
 +
| 2000
 +
| {{no|☹}}
 +
| {{no|☹}}
 +
| [http://www.mysql.com/about/legal/licensing/oem/ Oracle]
 +
| [http://www.ohloh.net/p/mysql ohloh]
 +
| C/C++
 
|-
 
|-
 
| [http://postgis.net/ PostGIS]
 
| [http://postgis.net/ PostGIS]
Line 32: Line 29:
 
| [http://www.ohloh.net/p/postgis ohloh]
 
| [http://www.ohloh.net/p/postgis ohloh]
 
| C/C++
 
| C/C++
| {{yes|✓}}
 
|-
 
| [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
 
| ???
 
| {{no|☹}}
 
| {{no|☹}}
 
| [http://www.mysql.com/about/legal/licensing/oem/ Oracle]
 
| [http://www.ohloh.net/p/mysql ohloh]
 
| C/C++
 
| {{yes|☹}}<ref name="partially">Partially supported</ref>
 
 
|-
 
|-
 
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
 
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
Line 50: Line 37:
 
| [http://www.ohloh.net/p/spatialite ohloh]
 
| [http://www.ohloh.net/p/spatialite ohloh]
 
| C/C++
 
| C/C++
| {{yes|☹}}<ref name="partially"/>
 
 
|-
 
|-
 
| [http://www.h2gis.org/ H2GIS]
 
| [http://www.h2gis.org/ H2GIS]
Line 59: Line 45:
 
| {{no|☹}}
 
| {{no|☹}}
 
| Java
 
| Java
| {{yes|✓}}
 
 
|-
 
|-
 
|}
 
|}
Line 73: Line 58:
 
|-
 
|-
 
| [http://postgis.net/ PostGIS]
 
| [http://postgis.net/ PostGIS]
| {{yes|✓}}?
+
| {{yes|✓}}
| {{yes|✓}}?
+
| {{yes|✓}}
 +
| {{yes|✓}}
 
|-
 
|-
 
| [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
 
| [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
 +
| {{no|☹}}
 +
| {{no|☹}}
 +
| {{yes|☹}}<ref name="partially">Partially supported</ref>
 
|-
 
|-
 
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
 
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
 +
| {{yes|✓}}
 +
| {{yes|✓}}
 +
| {{yes|✓}}
 
|-
 
|-
 
| [http://www.h2gis.org/ H2GIS]
 
| [http://www.h2gis.org/ H2GIS]
 +
| {{yes|✓}}
 +
| {{yes|✓}}
 +
| {{yes|✓}}
 
|-
 
|-
 
|}
 
|}

Latest revision as of 23:57, 16 March 2014

Work in progress
discussion (in Spanish)

Main Information

Name Year OSGeo Live License Ohloh Tech
MySQL Spatial 2000 Oracle ohloh C/C++
PostGIS 2005 G GPL v2 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