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)”

Working with SpatiaLite databases in QGIS 3.0

This video provides a brief introduction into what a SpatiaLite database is, why you might want to use one, and how to load data and create virtual layers in QGIS 3.0. (If you are using QGIS 2.xx you’ll be able to figure it out as well)

This is one lecture of an entire course on QGIS 3.0 for GIS professionals that will be available on Udemy.com when QGIS 3.0 is released (currently expected Dec 8) so keep an eye out for it if that will interest you.

If you want to learn more, check out What can a spatial database do for you? and Quick start to spatial databases with QGIS and SpatiaLite

Courses

All of my courses are available on the Udemy platform. This means that

  • They are self-paced. Start when you want and take as long as you want to finish
  • They are available 24-7 on-line
  • They can be downloaded to a mobile device and watched off-line
  • They have life-time access
  • The price is $20 each for readers of this blog.

All of my courses use open source software and simple, standard methods that have stood the test of time. They can be implemented without spending anything on licensing, subscriptions, or per-user fees.  Many of the concepts you will learn can be applied to commercial software as well but I think you will be impressed with the power and ease of the open source ecosystem, especially for multi-user geospatial applications.

Web Programming courses for Geospatial

  1. Introduction to web programming for GIS applications – This course is the foundation on which all my other web programming courses are based on. Its purpose is to provide the background necessary to understand the big picture of how various technologies, from basic HTML to PostGIS databases, work together to form a web GIS application. This course is intended to be watched with the intention of understanding the big picture. It is not intended to be followed along step by step, although several people have been able to do so.  (13 hours) AVAILABLE NOW.  *** BESTSELLER ***
  2. Display and analyze your GIS data on the web with Leaflet – This course builds on the first half of the previous course and provides much more detail on the Leaflet.js API and the Turf.js API for spatial analysis. Students are expected to follow along on their own computers and build a web map from start to finish. This course only covers client-side technologies, i.e. displaying and analyzing static data. It does not cover creating and/or editing data via the web although that subject is introduced in the introductory course. (13 hours) AVAILABLE NOW.     *** BESTSELLER ***
  3. Mobile GIS and mapping applications with Leaflet – This course builds on the previous two to cover issues specific to mobile devices, This includes dealing with small screens, touch screens, accessing the devices sensors, and working off-line. (4 hours) AVAILABLE NOW
  4. PHP registration, login, and content management system – One of the most frequent questions that I get is “How do I control access to my web pages and content?”. This course attempts to answer that question by providing step-by-step instructions for developing a user registration, login, and content management system that you can use for your own projects as-is or modify to suit your purpose. (9 hours) AVAILABLE NOW
  5. Server based web gis applications with Leaflet and PostGIS – This course will build on the introductory course to provide much more detail on integrating Leaflet web maps with a spatial database. It covers server-side programming with PHP, AJAX, and SQL. This is necessary for applications where the user is allowed to create and/or edit data via the web. Although I use Leaflet and postGIS as examples in this book the concepts are easily transferable to any client side web mapping API that can display GeoJSON and any server-side database. (16.5 hours) AVAILABLE NOW.
  6. Mobile data collection applications with Leaflet and PostGIS – This course will build on the previous course and show how to develop applications for collecting data in the field using the devices GPS sensor. AVAILABLE NOW 

QGIS and PostGIS courses

  1. QGIS 3.0 for GIS Professionals – This course is projected to be available concurrently with the release of QGIS 3.0 It will provide an overview of QGIS specifically for GIS users who are already trained in the use of commercial GIS software. Over 10 hours of content. AVAILABLE NOW!!! *** BESTSELLER ***
  2. Spatial databases with QGIS and PostGIS – This course is intended to provide an introduction in using spatial databases (based on PostGIS) for storing and analyzing geospatial data through SQL commands Over 10 hours of content. Available NOW!!!    *** HIGHEST RATED ***

Python programming courses for geospatial

  1. Survey of python for GIS applications – This course will provide a review of the python language and the python ecosystem for data analysis and geospatial applications. This course teaches PYTHON, not a particular library such as ArcPy or PyQGIS, but I think you will be impressed with what you can do with pure python not tied to a particular desktop GIS software and if you do decide you really want to work with ArcPy or PyQGIS you will have a strong basis for learning those libraries.  Available Now

Subscribe to my YouTube channel and/or join the Open Source Web GIS group on linked in to stay updated with the latest info.

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”

What can a spatial database do for you?

Is spatial really special?

Many GIS professionals come into the field from a specific discipline and become interested in GIS as a tool with which to accomplish their goals in their original field and by attrition or intent begin to shift their focus towards GIS. I followed this path myself.  After going to school to study wildlife biology, I learned about GIS and enrolled in a minor program in GIS and spatial analysis. I think that this is a good thing in many ways. People with an interest in solving problems in other disciplines will push the field forward in directions that someone who’s sole focus was on GIS would be unlikely to go. We need those people in the industry.

But GIS is a technical discipline. At its core GIS is database technology, albeit with a spatial focus. In my humble opinion many university GIS departments, especially at the certificate level, focus too much on the “spatial” aspects of GIS and not enough on the underlying database technology. As a result these programs produce GIS professionals who are very good at cartography and spatial analysis but who find themselves unprepared for the modern GIS job market where there is an increasing need for people with skills in enterprise level database administration, SQL, and web-based GIS. Even if they are not performing those tasks themselves, GIS professionals should at least have an understanding of the technology in order to be able to communicate effectively with those who will be performing those tasks. Continue reading “What can a spatial database do for you?”

Why your organization needs a web GIS strategy.

What is web GIS?

When most people think about web GIS, they think about publishing a map or a data set for the world to see.  That’s certainly part of it, but only a small part.  For many years when I would try to sell my employers on the concept of web GIS they would reply “We don’t want everyone to see our proprietary information.”  After digging in and learning more on my own I began to realize that there was much more to web GIS than publishing content. Continue reading “Why your organization needs a web GIS strategy.”