Difference between revisions of "Panorama SIG Libre 2014/Bases de datos"
Jump to navigation
Jump to search
Line 3: | Line 3: | ||
[https://github.com/OSGeo-ES/panorama-siglibre8/issues/8 discussion] (in Spanish) | [https://github.com/OSGeo-ES/panorama-siglibre8/issues/8 discussion] (in Spanish) | ||
− | == Introduction == | + | == 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 == | == State of the Art == | ||
Line 13: | Line 13: | ||
== Software == | == 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. | |
− | |||
− | |||
{| class="wikitable sortable" style="text-align: center;" | {| class="wikitable sortable" style="text-align: center;" | ||
Line 65: | Line 63: | ||
|} | |} | ||
+ | <references/> | ||
== Documentation == | == Documentation == | ||
− | + | ||
+ | {| class="wikitable sortable" style="text-align: center;" | ||
+ | ! Name | ||
+ | ! Documentation | ||
+ | ! Basic How To | ||
+ | |- | ||
+ | | [http://postgis.net/ PostGIS] | ||
+ | | [http://postgis.net/ PostGIS] | ||
+ | | [http://postgis.net/ PostGIS] | ||
+ | |- | ||
+ | | [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial] | ||
+ | | [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial] | ||
+ | | [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial] | ||
+ | |- | ||
+ | | [http://www.gaia-gis.it/gaia-sins/ Spatialite] | ||
+ | | [http://www.gaia-gis.it/gaia-sins/ Spatialite] | ||
+ | |- | ||
+ | | [http://www.h2gis.org/ H2GIS] | ||
+ | | [http://www.h2gis.org/ H2GIS] | ||
+ | | [http://www.h2gis.org/ H2GIS] | ||
+ | |- | ||
+ | |} | ||
+ | |||
== Examples == | == Examples == | ||
− | |||
== References == | == References == |
Revision as of 10:40, 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 | ☹[1] |
Documentation
Name | Documentation | Basic How To |
---|---|---|
PostGIS | PostGIS | PostGIS |
MySQL Spatial | MySQL Spatial | MySQL Spatial |
Spatialite | Spatialite | |
H2GIS | H2GIS | H2GIS |
Examples
References
- Wikipedia
- Project metrics at OSGeo Live
- Open Source GIS History