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

Created by: Arthur Lembo
Professor

What Will I 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!!!

Requirements

• Students should know what GIS is, and have some experience using GIS
• Students should be excited to learn about how to implement an Enterprise GIs
• Although this class provides a lot of hand-holding through advanced technical concepts, students should have a natural curiosity about GIS and technology, and not be afraid to tinker around - remember, in this training the stakes are low - if you break it, you can always start again.

Target audience

• This course is meant for those looking for hands-on experience building a multi-user enterprise GIS from scratch, using open source tools.
• Students should have a familiarity with open source tools like QGIS, however, having that experience is not required, as the course is designed to teach student with little or no experience
• This course is perfect training for someone who is interviewing for a GIS position - not many applicants can articulate how they put together an enterprise GIS.