Server-side web GIS applications with Leaflet and PostGIS

Accessing common data stores

4.75 (269 reviews)
Udemy
platform
English
language
Other
category
instructor
Server-side web GIS applications with Leaflet and PostGIS
2,634
students
16.5 hours
content
Nov 2019
last update
$69.99
regular price

What you will learn

Develop complex web GIS applications using data stored in a PostGIS database with open source software that doesn't require any licensing fees or subscriptions.

Description

Server-side web GIS applications allow you to access GIS data stored in a multi-user database. This means that your data will always be current and any changes that other users make to the data will be immediately available in your application. You will be able to build complex GIS applications where some users will only be able to view certain data that you allow them and other users will be able to add, edit, and delete data from a web-interface. This means that your users will be able to interact with your GIS database from any device that has a compatible browser and an internet connection. They may be working in the field from a mobile device or from home on a mac OS computer, or on the other side of the world on a Linux computer.

This course uses PHP for the server-side language because of its popularity and its wide availability on web servers. We will use PostGIS as a spatial database, again because of its popularity and common usage in GIS applications. I teach standard web development methods that have stood the test of time and will still be available in many years after the latest, greatest, technology has been replaced with something even better. My goal as an instructor is to provide an introduction to the basic concepts. I don't think you will find any limitations with the software that I teach but if you ultimately decide to use a different server-side language, database, or a newer framework the methods you learn here will provide a solid foundation.

Best of all, this course uses all open source software so there are no costs involved. I have had projects involving more than 50 people, including clients, accessing the same database through web interfaces and desktop GIS for several years with no problem and with no cost other than web-hosting which cost us about $10/month total. 

Content

Introduction

Introduction
Static vs Dynamic data
Software for this course
Getting started
Loading spatial data into PostGIS
Password protecting the page

Working with PostGIS data

Converting PostGIS data to GeoJSON
PHP script to create GeoJSON from PostGIS
Calling load_baea.php from Leaflet via AJAX
Generalizing our load_data php script
Creating a load data function
Adding the other spatial data
Adding the other spatial data part 2
Cleaning up loose ends
Refreshing data layers from the server
Handling database errors

Moving other functions to server-side operations

Creating buffers with PostGIS
Using our buffer function in the application
Filtering with the database
Filtering with SQL Part 2
Searching with SQL
Filtering Part 2 - Callback functions

Working with non-spatial data

Loading non-spatial data into PostGIS
Creating a modal dialog
Returning non-spatial data as a table
Cleaning up the table
Adding non-spatial survey data to search function

Analyzing PostGIS data with spatial SQL

Single table spatial queries and the geography data type
Multi-table queries joined on a spatial relationship
Finding Projects impacted by constraints
Debugging and adding to other constraints
Finding constraints impacted by projects
Using the Leaflet PM plug-in
Analyzing features created by the draw tool
Moving to a tabbed sidebar
Adding Content to a tabbed sidebar
Cleaning up the client web app

Preparing for editing

Creating a new group in the CMS for editors
Preparing the database for editing
Modifying the survey table field names
Accessing the current user information from JavaScript
Accessing the current date and time from JavaScript
Working with sequences in PostgreSQL
Refactoring the survey results as a function

Editing non-spatial data

Adding edit and delete buttons to the survey results
Wiring the delete button to a generic php delete record script
Creating a survey form and populating with survey data
Creating a survey form and populating with form data part 2
Converting the result input to a select element
Updating the database from the form
Adding a new survey
The insert_data.php script
Creating custom select options from the database

Editing spatial data

Refactoring our PHP Scripts
Refactoring CSS and JavaScript
Changing text boxes to select elements and populating them
Adding delete and edit buttons
Deleting features
Editing feature attributes
Editing spatial data
Editing spatial data - Part 2
Handling GeoJSON in the update records PHP script
Modifying the form for adding data
Creating new geometries
Handling geometries on the server side
Working with multi-part geometries in leaflet - editing parts

Finishing Touches

Cleaning things up
Cleaning things up Part 2
Working with multi-part geometries in leaflet - adding and deleting parts
Deleting parts from multi-part features
Issues with adding editing capability to other datasets
Taking it live
Creating a new map with reduced functionality
Where to go next?

Bonus Lectures

Installing Chrome, Brackets, Apache, and PHP
Installing PostgreSQL and PostGIS
Installing QGIS
Anatomy of a URL
All about GeoJSON
Geometry vs. Geography data types
Bonus Lecture: How to get the most from my series of Udemy courses.

Reviews

Pablo
September 22, 2022
Mike always delivers good courses. I highly recommend them for anyone from the GIS field who has 0 experience in programming.
Obula
September 6, 2022
He teaches CURD operation only for Polygon not done rest of Things Like Line and Marker pls do Same using Django And django Rest Api do Curd Operation
Joe
August 10, 2022
Michael's instructions are good and practical. I know because I am able to do the same tasks on a different platform where I have to make adjustments to his settings to match my own setup. Very well done.
Norman
January 21, 2022
This if the first complete course I see that covers both parts of the process of creating GIS web applications as is, since it connect all the dots, user authentication, CRUD, UI for different geometrical objects etc. Most of the workflow is live so the instructor develops and show what the outcome is instead of prepared scripts, this obviously sometimes does not work in the first shot but I think is part of the process to show how to tackle errors. The difference with other courses or blog post with Postgis is that it shows examples of the official documentation, this course is an actual website that covers different way to present, interact and use GIS that but all connected not isolates. I have enjoyed this course, let me be more confident about how to assess a GIS web app, I would suggest ad a session to focus on DB admin, backup, restore, security just to complete the whole real-life scenario.
Damien
August 17, 2021
This course like all of the others from this creator is well planned and paced. Covers the topic well and meets the 80/20 just as he says.
Godswill
June 2, 2021
This Course is exactly what I need and been searching for over the years. It has helped me with the skills to implement my dreams and develop a solution to meet the exact needs of my people and community. Big thanks to mike miller. A real mentor!
Joe
December 28, 2020
Covers all aspects of creating a GIS solution for the web which is server based. Would recommend this course to anyone who needs to create web applications.
Steve
October 16, 2020
Course not supported and not all resources provided. Course is ok in that it provides a way to set up a server side GIS application, so there is some good learning, but a lot of the coding is pretty basic and janky. It works but you aren't learning best practice and although some elements are explained, only in the context of the code rather than generically to make it more transferable. You will also pick up some bad coding habits. In some ways, that is good to help you learn for yourself, but suspect isn't why most people buy it. Think twice before purchasing unless you just want to a taught a basic method that works. Personally I'm pleased I bought it as I have learnt, but a good proportion by thinking through the issues myself prompted by the course opposed to the lessons themselves.
Elena
September 8, 2020
Very useful course, especially regarding the leaflet plugins usage etc. However, it should be better to upload the final version of the application, just to be able to have the final working solution.
Ranjith
April 22, 2020
A fantastic course for getting a sound footing for creating web GIS applications using free and open source software. Though the software used by the author may not be using the latest software stack, it does give a great start.. Strongly recommended.
Mike
February 3, 2020
I have taken several courses by this instructor. He always does a great job presenting the material.
Martin
November 20, 2018
Absolutely misleading name of the course, should be called how to work with postgis through my 'meaning teacher's' php application.
Matheus
November 4, 2018
This was a really great course. I learned a lot. I'm already taking a lot of courses with him. It's really hard to find professors that teach in a captivating way like he does! I'm your fan!!! Thank you so much for this course!!
Karl
October 6, 2018
This course was excellent. Very much enjoyed the opportunity to build on Michael's prior php / login course. This provided a great balance of following allow with the opportunity to work through the concepts yourself near the end of the course. Definitely recommend it if you are interested in building a web application using leaflet and postgis.
Roy
September 9, 2018
The course is good and contains what it promises, but the videos are edited and cut in a way that can make it difficult to get to see everything. But as stated, the course contains what it promises and is educational.

Charts

Price

Server-side web GIS applications with Leaflet and PostGIS - Price chart

Rating

Server-side web GIS applications with Leaflet and PostGIS - Ratings chart

Enrollment distribution

Server-side web GIS applications with Leaflet and PostGIS - Distribution chart

Related Topics

1721160
udemy ID
5/29/2018
course created date
11/23/2019
course indexed date
Bot
course submited by