Open Source GIS: Enterprise GIS w/ Postgres/PostGIS

Create an enterprise GIS with Postgres SQL, QGIS, and PostGIS to manage users, and support multiple GIS software clients

4.80 (75 reviews)
Udemy
platform
English
language
Other
category
instructor
445
students
4 hours
content
Apr 2020
last update
$49.99
regular price

What you will learn

Install Postgres and PostGIS

Design a Postgres database with multiple users and roles

Load spatial and attribute data into Postgres and PostGIS

Manage data by including constraints, views, and indexes

Connect GIS software and clients to the Enterprise Postgres database

Perform simultaneous multi-user editing of GIS data

Issue spatial and non-spatial SQL to perform geographic analysis

Develop and external application (kiosk) in Python

Publish Enterprise data on the Internet (this will be a demonstration only)

Implement your Enterprise solution using a cloud-based hosting service

... and you'll learn how to do it with Postgres 11 and PostGIS 3!!!

Description

For years I've been hearing everyone talking about Enterprise GIS, but I haven't seen anyone do it.  After this course, I can now say that "I've created a multi-user enterprise GIS on my own!" - John from California.

Do you want to learn how to build an Enterprise GIS from scratch using Free and Open Source Software for GIS (FOSS4g)?

In response to the high cost and complexities of implementing an Enterprise GIS, I created this easy-to-follow, hands-on training course allowing students to actually build a multi-user enterprise GIS from scratch using Postgres, PostGIS (free) and QGIS (free).   As an added bonus, this training will show how you can add other GIS products (i.e. commercial GIS software) into the enterprise stack as GIS clients.

In this course you will create an Enterprise GIS for a mid-sized municipality.  You will learn how to add users, each with different permissions for accessing and editing data, and also how to use PostGRES to control all aspects of database access, presentation, and editing.  You'll even perform simultaneous multi-user editing on the same GIS layer, and learn how a true Enterprise GIS can manage many users at once. 

As a bonus, you will see how you can access all the GIS tools from outside of the software by using python to create a table-top GIS application that you might find at a kiosk.  And finally, I will show you an example of how the same data in the enterprise can be simultaneously displayed on the Internet using FOSS4g software.


Content

Getting Started

Understanding the entire Open Source GIS Curriculum
Enterprise GIS overview
Install Postgres
Install QGIS
Import our data
Ways to load data into Postgres/PostGIS

System Design and Implementation

Logical Design: Groups, Users, and Layers
Physical Design - Roles, Users, and Layers - Part 1
Physical Design - Roles, Users, and Layers - Part 2
Physical Design - Views
Physical Design - Constraints
Physical Design - Triggers
Clean up code - make sure to run this

Enterprise GIS Use in Practice

Accessing Enterprise GIS data from desktop clients
Simultaneous Multi-user Editing of Enterprise GIS data
Server-Side Analysis of Enterprise GIS Data
Accessing Enterprise GIS Data with Python
A Demonstration of Internet Mapping with Postgres/PostGIS
Bonus Lecture: Hosting your enterprise GIS in the cloud
Bonus Lecture: How to keep learning

Screenshots

Open Source GIS: Enterprise GIS w/ Postgres/PostGIS - Screenshot_01Open Source GIS: Enterprise GIS w/ Postgres/PostGIS - Screenshot_02Open Source GIS: Enterprise GIS w/ Postgres/PostGIS - Screenshot_03Open Source GIS: Enterprise GIS w/ Postgres/PostGIS - Screenshot_04

Reviews

Surabhi
April 16, 2022
The course is great! Explains the basics of PostgreSQL with its applications in GIS and its functionalities. However, the versions of paid software like ArcMap are very old (they are using 10.1 which is not even supported by ESRI support). Demonstrating it in newer versions can be better in terms of functionalities. It would also be great if you could add a chapter on how to create an enterprise geodatabase with Postgres in ArcMap.
Enrica
March 18, 2022
Great course and great teacher. It was very useful to me and I'm sure that I would revise some lessons in order to use all the things I've leraned properly.
Miguel
March 28, 2021
Art Lembo isn't just an expert in GIS and geospatial but also in teaching. He knows how to make students understand certain points. What really sold me on giving him a 5 star are the many times he answers questions that one might have in mind on a certain task. So it affirms immediately your hunch on why X works (or does not work). It helps because those are usually the questions people that take these courses have. I'm hoping he updates the Python for geospatial course for 2021.
Edilberto
June 26, 2020
Excelente curso. Arthur explica detallada y claramente cada paso para montar un SIG empresarial a nivel de servidor local; adicionalmente brinda una buena opción para montar dicho servidor en la nube.
Ahmed
May 20, 2020
Amazing , All i need, simple and straight foreword , thanks a lot, i recommended, can you add apart for raster import, and how to manage cashe ??
Stylianos
April 5, 2020
Small pictures, outdated stuff, code is missing from the sql files, pretty less the same as the old version
Ethan
February 15, 2020
This course was a great way to dive into Enterprise GIS data management and learn how to use Postgres.
Allison
February 10, 2020
This has been a great class so far. Love that Arthur places emphasis on learning some SQL for database management. I've had to take a proactive approach to learning some things on my own when things don't go as expected or shown in the videos, but I feel like this is to be expected. It's the same as with any approach you take to learning anything. So, I'm happy to give it FIVE stars!! :)

Charts

Price

Open Source GIS: Enterprise GIS w/ Postgres/PostGIS - Price chart

Rating

Open Source GIS: Enterprise GIS w/ Postgres/PostGIS - Ratings chart

Enrollment distribution

Open Source GIS: Enterprise GIS w/ Postgres/PostGIS - Distribution chart

Related Topics

2674394
udemy ID
11/26/2019
course created date
6/15/2020
course indexed date
Bot
course submited by