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.
Welcome to the Esri DC Development Center blog. We write about features of our work on big data analytics, open platforms, and open data, what is new and exciting in the Esri and community, and general industry thought leadership and discussions of geospatial data visualization and analysis.
Please explore what we're working on and let us know if you have any questions or ideas!