Panorama SIG Libre 2014/Bases de datos

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	☹^[1]

↑ ^1.0 ^1.1 ^1.2 Partially supported

Documentation

Name	Documentation	Basic How To
PostGIS	PostGIS	PostGIS
MySQL Spatial	MySQL Spatial	MySQL Spatial
Spatialite	Spatialite
H2GIS	H2GIS	H2GIS

Examples

References

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

[1]