Panorama SIG Libre 2014/Bases de datos

From OSGeo
Jump to navigation Jump to search 
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++ ✓
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. ↑ 1.0 1.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

Retrieved from "http://wiki.osgeo.org/w/index.php?title=Panorama_SIG_Libre_2014/Bases_de_datos&oldid=76919"