Panorama SIG Libre 2014/Bases de datos
< Panorama SIG Libre 2014
Jump to navigation
Jump to search
Revision as of 12:06, 23 February 2014 by Delawen (talk | contribs) (→Compliance with Simple Feature Access OGC Standard)
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 | |||
| Spatialite | |||
| H2GIS |
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
- Wikipedia
- Project metrics at OSGeo Live
- Open Source GIS History