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

From OSGeo
Jump to navigation Jump to search
 
(17 intermediate revisions by 2 users not shown)
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)
  
−
== Main information ==
+
== Main Information ==  
  
 
{| class="wikitable sortable"  style="text-align: center;"
 
{| class="wikitable sortable"  style="text-align: center;"
Line 13: Line 13:
 
! Ohloh
 
! Ohloh
 
! Tech
 
! Tech
−
! OGC Compliant
+
|-
 +
| [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
 +
| 2000
 +
| {{no|☹}}
 +
| {{no|☹}}
 +
| [http://www.mysql.com/about/legal/licensing/oem/ Oracle]
 +
| [http://www.ohloh.net/p/mysql ohloh]
 +
| C/C++
 
|-
 
|-
 
| [http://postgis.net/ PostGIS]
 
| [http://postgis.net/ PostGIS]
Line 22: Line 29:
 
| [http://www.ohloh.net/p/postgis ohloh]
 
| [http://www.ohloh.net/p/postgis ohloh]
 
| C/C++
 
| C/C++
−
| {{yes|✓}}
 
−
|-
 
−
| [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
 
−
| 2005
 
−
| {{no|☹}}
 
−
| {{no|☹}}
 
−
| [http://www.mysql.com/about/legal/licensing/oem/ Oracle]
 
−
| [http://www.ohloh.net/p/mysql ohloh]
 
−
| C/C++
 
−
| {{no|☹}}
 
 
|-
 
|-
 
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
 
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
−
| ¿¿¿
+
| 2008
 
| {{no|☹}}
 
| {{no|☹}}
 
| {{no|☹}}
 
| {{no|☹}}
Line 40: Line 37:
 
| [http://www.ohloh.net/p/spatialite ohloh]
 
| [http://www.ohloh.net/p/spatialite ohloh]
 
| C/C++
 
| C/C++
−
| {{yes|✓}}
 
 
|-
 
|-
 
| [http://www.h2gis.org/ H2GIS]
 
| [http://www.h2gis.org/ H2GIS]
−
| ???
+
| 2008
 
| {{no|☹}}
 
| {{no|☹}}
 
| {{no|☹}}
 
| {{no|☹}}
Line 49: Line 45:
 
| {{no|☹}}
 
| {{no|☹}}
 
| Java
 
| Java
 +
|-
 +
|}
 +
 +
=== 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|✓}}
 +
| {{yes|✓}}
 
| {{yes|✓}}
 
| {{yes|✓}}
 +
|-
 +
| [https://dev.mysql.com/doc/refman/5.0/es/spatial-extensions.html MySQL Spatial]
 +
| {{no|☹}}
 +
| {{no|☹}}
 +
| {{yes|☹}}<ref name="partially">Partially supported</ref>
 +
|-
 +
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
 +
| {{yes|✓}}
 +
| {{yes|✓}}
 +
| {{yes|✓}}
 +
|-
 +
| [http://www.h2gis.org/ H2GIS]
 +
| {{yes|✓}}
 +
| {{yes|✓}}
 +
| {{yes|✓}}
 +
|-
 +
|}
 +
<references/>
 +
 +
== Documentation ==
 +
 +
 +
{| class="wikitable sortable"  style="text-align: center;"
 +
! Name
 +
! Full Documentation
 +
! Where to start
 +
|-
 +
| [http://postgis.net/ PostGIS]
 +
| [http://postgis.net/docs/manual-2.1/ Official 2.0 doc]
 +
| [http://workshops.boundlessgeo.com/postgis-intro/ Introduction]
 +
|-
 +
| [https://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html MySQL Spatial]
 +
| [https://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html Official 5.0 doc]
 +
| No Official one
 +
|-
 +
| [http://www.gaia-gis.it/gaia-sins/ Spatialite]
 +
| [https://www.gaia-gis.it/spatialite-2.3.1/spatialite-manual-2.3.1.html Official 2.3.1 doc]
 +
| [http://www.camptocamp.com/actualite/kiss-spatialite-in-5-minutes/ 5 minutes]
 +
|-
 +
| [http://www.h2gis.org/ H2GIS]
 +
| [http://www.h2gis.org/docs/dev/home/ Official doc]
 +
| [http://www.h2gis.org/docs/dev/quickstart/ Quick-start guide]
 
|-
 
|-
 
|}
 
|}
 +
 +
More info [http://osgeo-es.github.io/panorama-siglibre8/ here].
 +
 +
== Examples ==
 +
 +
  
 
== References ==
 
== References ==

Latest revision as of 23:57, 16 March 2014

Work in progress

discussion (in Spanish)

Main Information

Name Year OSGeo Live License Ohloh Tech
MySQL Spatial 2000 ☹ ☹ Oracle ohloh C/C++
PostGIS 2005 G ✓ GPL v2 ohloh C/C++
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. ↑ 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=77313"