Difference between revisions of "Panorama SIG Libre 2014/Bases de datos"
Jump to navigation
Jump to search
(8 intermediate revisions by the same user 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 == |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
{| class="wikitable sortable" style="text-align: center;" | {| class="wikitable sortable" style="text-align: center;" | ||
Line 23: | Line 13: | ||
! Ohloh | ! Ohloh | ||
! Tech | ! Tech | ||
− | + | |- | |
+ | | [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 32: | Line 29: | ||
| [http://www.ohloh.net/p/postgis ohloh] | | [http://www.ohloh.net/p/postgis ohloh] | ||
| C/C++ | | C/C++ | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
| [http://www.gaia-gis.it/gaia-sins/ Spatialite] | | [http://www.gaia-gis.it/gaia-sins/ Spatialite] | ||
Line 50: | Line 37: | ||
| [http://www.ohloh.net/p/spatialite ohloh] | | [http://www.ohloh.net/p/spatialite ohloh] | ||
| C/C++ | | C/C++ | ||
− | |||
|- | |- | ||
| [http://www.h2gis.org/ H2GIS] | | [http://www.h2gis.org/ H2GIS] | ||
Line 59: | Line 45: | ||
| {{no|☹}} | | {{no|☹}} | ||
| Java | | Java | ||
− | |||
|- | |- | ||
|} | |} | ||
Line 73: | Line 58: | ||
|- | |- | ||
| [http://postgis.net/ PostGIS] | | [http://postgis.net/ PostGIS] | ||
− | | {{yes|✓}} | + | | {{yes|✓}} |
− | | {{yes|✓}} | + | | {{yes|✓}} |
+ | | {{yes|✓}} | ||
|- | |- | ||
| [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] | ||
+ | | {{no|☹}} | ||
+ | | {{no|☹}} | ||
+ | | {{yes|☹}}<ref name="partially">Partially supported</ref> | ||
|- | |- | ||
| [http://www.gaia-gis.it/gaia-sins/ Spatialite] | | [http://www.gaia-gis.it/gaia-sins/ Spatialite] | ||
+ | | {{yes|✓}} | ||
+ | | {{yes|✓}} | ||
+ | | {{yes|✓}} | ||
|- | |- | ||
| [http://www.h2gis.org/ H2GIS] | | [http://www.h2gis.org/ H2GIS] | ||
+ | | {{yes|✓}} | ||
+ | | {{yes|✓}} | ||
+ | | {{yes|✓}} | ||
|- | |- | ||
|} | |} |
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 | ✓ | ✓ | ✓ |
- ↑ 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
- Wikipedia
- Project metrics at OSGeo Live
- Open Source GIS History