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