Server-side web GIS applications with Leaflet and PostGIS

"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."