Slashgeo Log In
SpatiaLite and VirtualShape for SQLite
posted by Satri
on Tuesday April 15, @02:39PM
Permalink
Trackback URI
Slashdotthis
Diggthis
Del.icio.us
from the spatial-in-every-box dept.
Permalink
Trackback URI
Slashdotthis
Diggthis
Del.icio.us
from the spatial-in-every-box dept.
Kurt's Weblog links to the open source tools for SQLite named SpatiaLite and VirtualShape. From the page: "the SpatiaLite extension enables SQLite to support spatial data too [aka GEOMETRY], in a way conformant to OpenGis specifications [...] the VirtualShape extension enables SQLite to access shapefiles as VIRTUAL TABLEs"
Related Stories
MySQL Spatial support for OGR and GDAL 1 comment
[+]
The Hobu blog has an interesting entry about MySQL spatial support for GDAL/OGR. From the blog: "Under the direction of Frank Warmerdam, I have been bringing the OGR driver up to par with the rest of the vector data drivers in OGR. [...] MySQL is known for being fast, widely deployed, and frequently used. Unlike PostGIS, however, it does not support spatial predicates and operators (for testing whether one geometry exists in another, for example) [...]"
Improved MySQL GIS Functions 1 comment
[+]
Christian Spanring offers news on improved MySQL GIS functions. From the blog: "According to the GIS Functions wiki entry following MySQL GIS functions have been added to the MySQL 5.1.23 beta GIS release: BUFFER,
DIFFERENCE,
DISTANCE,
INTERSECTION,
SYM_DIFFERENCE,
UNION. I haven’t had the chance to test it yet, but I remember being very excited when I first read about the MySQL spatial extension a couple of years ago, followed by disappointment because of the MBR limits. Finally I decided to go with PostgreSQL/PostGIS back then. " See previous stories below, including a survey of geospatial features of Oracle, MySQL and PostGIS.
SpatiaLite 2.2 GUI
[+]
We mentioned SQLite's SpatiaLite about a year ago, but now the MapFish blog shares a SpatiaLite hands on demo in 5 minutes using a GUI: "Nothing really new (Personal Geodatabase, SDF, others exist for a while) except the extrem simplicity, the file portability (cross plattforms), the possibility to access the shapefile as "virtual tables" (you can start SQL statements directly on shapefiles) and the OS license. Of course PostGIS or Oracle Spatial will provide more functions or will extract data faster but I can imagine dozen of applications where the simplicity of spatialite is an huge advantage (SQLite is the most widely deployed SQL database engine in the world)." Back in December GeoMusings shared his thought on SpatiaLite and last September, version 2.2 was released.
This discussion has been archived.
No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
