Stories
Slash Boxes
Comments

In+ersec+ion for Spatial People

SpatiaLite and VirtualShape for SQLite

posted by Satri on Tuesday April 15, @02:39PM   Printer-friendly   Email story  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.
Display Options Threshold:
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.