Working with PostGIS data from within Leaflet.js (or any other client side mapping API)

This 3-part mini-course is my attempt to explain the basic concepts of working with PostGIS data from within the Leaflet.js mapping API.  Technically this is not Leaflet programming. In this scenario Leaflet.js simply becomes the canvas on which your geospatial data is displayed on a web map.  All of the interaction with the geospatial data occur through very common and standard methods of working with enterprise level databases, but with a geospatial twist. Continue reading “Working with PostGIS data from within Leaflet.js (or any other client side mapping API)”

Quick start to spatial databases with QGIS and SpatiaLite

In a recent post, I attempted to answer the question What can a spatial database do for you? That post was a broad overview of the advantages of storing your geospatial data in a spatial database. This post follows up with more specific information on how to get started and step by step instructions on using one type, SpatiaLite, with the popular open source GIS software QGIS. Continue reading “Quick start to spatial databases with QGIS and SpatiaLite”