I’m out at the ESRI DevSummit this year, and tonight I presented the following talk on using SQL to perform spatial analysis tasks. The presentation slides are included here.
I tried to squeeze in several examples, including mapping 2,199 farms for the State of New Jersey, studying habitat change, and monitoring use of a crowdsourcing application.
I also use SQL extensively in NJParcels.com on processing the available public data, as well as to produce the data products available on the site. You might also find my LearnSpatialSQL.com site helpful if you want to learn more about using only SQL for performing GIS tasks.