Course Information
Course Overview
Create an enterprise GIS with Postgres SQL, QGIS, and PostGIS to manage users, and support multiple GIS software clients
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.
Course Content
- 3 section(s)
- 20 lecture(s)
- Section 1 Getting Started
- Section 2 System Design and Implementation
- Section 3 Enterprise GIS Use in Practice
What You’ll 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!!!
Skills covered in this course
Reviews
-
KKata Tisza
Great course, very informative!
-
BBrenda Joseph
I am glad I took the course. It help me to become more confident with my knowledge and use it in my work. Thanks.
-
NNitin
It was an amazing course. Learn all basics from this course
-
LLaura Schuch
The first video went black, and stayed that way.