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

Revision as of 11:09, 23 February 2014

Work in progress

discussion (in Spanish)

Introduction

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.

Name	Year	OSGeo	Live	License	Ohloh	Tech	OGC Compliant
PostGIS	2005	G	✓	GPL v2	ohloh	C/C++	✓
MySQL Spatial	???	☹	☹	Oracle	ohloh	C/C++	☹^[1]
Spatialite	2008	☹	☹	MPL tri-license	ohloh	C/C++	☹^[1]
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.0 ^1.1 ^1.2 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

[partially-1] 1.0 ^1.1 ^1.2 Partially supported

[1]

@@ Line 73: / Line 73: @@
 |-
 | [http://postgis.net/ PostGIS]
-|
+| {{yes|☹}}
-|
+| {{yes|☹}}
 | {{yes|✓}}
 |-
 | [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]
@@ Line 87: / Line 87: @@
 |-
 | [http://www.h2gis.org/ H2GIS]
-|
+| {{yes|☹}}
-|
+| {{yes|☹}}
-|
+| {{yes|☹}}
 |-
 |}