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

Revision as of 11:21, 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
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	✓	✓	✓

↑ 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] Partially supported

[1]

@@ Line 23: / Line 23: @@
 ! Ohloh
 ! Tech
-! OGC Compliant
 |-
 | [http://postgis.net/ PostGIS]
@@ Line 32: / Line 31: @@
 | [http://www.ohloh.net/p/postgis ohloh]
 | C/C++
-| {{yes|✓}}
 |-
 | [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
@@ Line 41: / Line 39: @@
 | [http://www.ohloh.net/p/mysql ohloh]
 | C/C++
-| {{yes|☹}}<ref name="partially">Partially supported</ref>
 |-
 | [http://www.gaia-gis.it/gaia-sins/ Spatialite]
@@ Line 50: / Line 47: @@
 | [http://www.ohloh.net/p/spatialite ohloh]
 | C/C++
-| {{yes|✓}}
 |-
 | [http://www.h2gis.org/ H2GIS]
@@ Line 59: / Line 55: @@
 | {{no|☹}}
 | Java
-| {{yes|✓}}
 |-
 |}