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

From OSGeo
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 ==  
  
Breve descripción de la sección con retrospectiva y evolución incluyendo la tabla de la sección.
+
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 ==  
  
Aquí explicaría en qué campos se suele mover cada elemento sofware. Por ejemplo, Geoserver permite CSW, pero generalmente su uso es más WMS/WFS...
+
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.
Curva de aprendizaje y conocimientos previos
 
Metería otra tabla con los conocimientos previos necesarios para trabajar con y en cada software.
 
  
 
{| class="wikitable sortable"  style="text-align: center;"
 
{| class="wikitable sortable"  style="text-align: center;"
Line 65: Line 63:
 
|}
 
|}
  
 +
<references/>
  
 
== Documentation ==
 
== Documentation ==
  
Aquí haría un breve *how to* sobre el uso de la documentación de cada herramienta y lo enlazaría.
+
 
 +
{| 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 ==
 
== 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]
  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