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 Once downloaded you have functions such as Overlaps(), Touches(), Union() and Buffer().

File Export

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.

Tagged with:

5 Responses to Better Know a GeoCommons Feature – SpatiaLite

  1. Nicely done – the sooner we get broad acceptance of SpatialLite the better – an truly open alternative to shapefiles.

  2. Abe Usher says:


    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.

  3. […] you rarely see it in the real world. Offhand I can only think of the “beta” format that GeoCommons has on their service (and they’ve had beta attached to it for almost a […]

  4. […] relational data store that provides great access and compression. About a year ago we even added Spatialite support to GeoCommons – so anyone can convert data to a SQLite […]

  5. Wow – great work guys, will definitely be having a look at this in conjuction with the work I am doing on Tile5 + mobile :) SpatiaLite would appear to be the *perfect* solution.