Server-side web GIS applications with Leaflet and PostGIS
Accessing common data stores
- Description
- Curriculum
- FAQ
- Reviews
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.
Working with PostGIS data
Moving other functions to server-side operations
-
7
Converting PostGIS data to GeoJSON -
8
PHP script to create GeoJSON from PostGIS
-
9
Calling load_baea.php from Leaflet via AJAX
-
10
Generalizing our load_data php script
-
11
Creating a load data function
-
12
Adding the other spatial data
-
13
Adding the other spatial data part 2
-
14
Cleaning up loose ends
-
15
Refreshing data layers from the server
-
16
Handling database errors
Working with non-spatial data
Analyzing PostGIS data with spatial SQL
Preparing for editing
-
28
Single table spatial queries and the geography data type
-
29
Multi-table queries joined on a spatial relationship
-
30
Finding Projects impacted by constraints
-
31
Debugging and adding to other constraints
-
32
Finding constraints impacted by projects
-
33
Using the Leaflet PM plug-in
-
34
Analyzing features created by the draw tool
-
35
Moving to a tabbed sidebar
-
36
Adding Content to a tabbed sidebar
-
37
Cleaning up the client web app
Editing non-spatial data
-
38
Creating a new group in the CMS for editors
-
39
Preparing the database for editing
-
40
Modifying the survey table field names
-
41
Accessing the current user information from JavaScript
-
42
Accessing the current date and time from JavaScript
-
43
Working with sequences in PostgreSQL
-
44
Refactoring the survey results as a function
Editing spatial data
-
45
Adding edit and delete buttons to the survey results
-
46
Wiring the delete button to a generic php delete record script
-
47
Creating a survey form and populating with survey data
-
48
Creating a survey form and populating with form data part 2
-
49
Converting the result input to a select element
-
50
Updating the database from the form
-
51
Adding a new survey
-
52
The insert_data.php script
-
53
Creating custom select options from the database
Finishing Touches
-
54
Refactoring our PHP Scripts
-
55
Refactoring CSS and JavaScript
-
56
Changing text boxes to select elements and populating them
-
57
Adding delete and edit buttons
-
58
Deleting features
-
59
Editing feature attributes
-
60
Editing spatial data
-
61
Editing spatial data - Part 2
-
62
Handling GeoJSON in the update records PHP script
-
63
Modifying the form for adding data
-
64
Creating new geometries
-
65
Handling geometries on the server side
-
66
Working with multi-part geometries in leaflet - editing parts
Bonus Lectures
-
67
Cleaning things up
-
68
Cleaning things up Part 2
-
69
Working with multi-part geometries in leaflet - adding and deleting parts
-
70
Deleting parts from multi-part features
-
71
Issues with adding editing capability to other datasets
-
72
Taking it live
-
73
Creating a new map with reduced functionality
-
74
Where to go next?
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
Stars 5
92
Stars 4
37
Stars 3
8
Stars 2
1
Stars 1
2
Course details
Video
17 hours
Certificate of Completion
Popular courses
Social Network