Better Know a GeoCommons Feature - SpatiaLite
December 15th, 2009by Kate Chapman
For Colbert fans the "Better Know a District" series is a familiar part of the Colbert Report. Today I'm kicking off my own series "Better Know a GeoCommons Feature." I'd like you to meet one of our lesser known export formats Spatialite.
For those not familiar with SpatiaLite it is SQLite with spatial function goodness added. GeoCommons exports the geometries from your overlay into Well-known text. To download your Finder overlay as SpatiaLite you can go to a you overlay details page and click the Spatialite Download link or you the URI to access it from the API is http://finder.geocommons.com/overlays/#your_overlay_id#.sqlite. Once downloaded you have functions such as Overlaps(), Touches(), Union() and Buffer().
Is SpatiaLite a GeoCommons' feature you'd like to get to know better? Download SpatiaLite from here.
For those not familiar with the "Better Know a District" series here is my favorite episode with Eleanor Holmes Norton.
Is SpatiaLite a GeoCommons' feature you'd like to get to know better? Download SpatiaLite from here.
For those not familiar with the "Better Know a District" series here is my favorite episode with Eleanor Holmes Norton.
Popularity: 8% [?]
December 15th, 2009 at 11:52 pm
Nicely done - the sooner we get broad acceptance of SpatialLite the better - an truly open alternative to shapefiles.
December 19th, 2009 at 3:26 pm
Brilliant!
I’ve been using Spatialite for about nine months and I love it (for all of the reasons I love using SQLite 3 as an embedded database). The ability to do geospatial queries without PostGIS or Oracle Spatial is very handy.