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

From OSGeo
Jump to navigation Jump to search
Line 63: Line 63:
 
|}
 
|}
  
−
[http://www.opengeospatial.org/standards/sfs Simple Feature Access OGC Standard]
+
Compliance with [http://www.opengeospatial.org/standards/sfs Simple Feature Access OGC Standard].
  
 +
 +
{| class="wikitable sortable"  style="text-align: center;"
 +
! Name
 +
! Binary Geometry
 +
! Normalized Geometry
 +
! Types and Functions
 +
|-
 +
| [http://postgis.net/ PostGIS]
 +
| {{yes|✓}}?| 2008
 +
| {{no|☹}}
 +
| {{no|☹}}
 +
| [https://github.com/irstv/H2GIS GPL3]
 +
| {{no|☹}}
 +
| Java
 +
| {{yes|✓}}
 +
 +
| {{yes|✓}}?
 +
| {{yes|✓}}?
 +
|-
 +
| [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
 +
|-
 +
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
 +
|-
 +
| [http://www.h2gis.org/ H2GIS]
 +
|-
 +
|}
 
<references/>
 
<references/>
  

Revision as of 10:57, 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 ✓

Compliance with Simple Feature Access OGC Standard.


Name Binary Geometry Normalized Geometry Types and Functions
PostGIS ✓?| 2008 ☹ ☹ GPL3 ☹ Java ✓ ✓? ✓?
MySQL Spatial
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=76912"