Open Source GIS: Enterprise GIS w/ Postgres/PostGIS
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!!!
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.
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.
Who this course is for:
- 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.
Course content
- Preview07:31
- Preview18:29
- 05:55Install Postgres
- 02:31Install QGIS
- 13:16Import our data
- 09:37Ways to load data into Postgres/PostGIS
Instructor
![Arthur Lembo](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.2 Instructor Rating
- 3,369 Reviews
- 12,468 Students
- 19 Courses
Dr. Arthur J. Lembo, Jr. is an educator with a passion for GIS and almost 30 years of GIS industry experience. He has won numerous teaching awards, including the prestigious New York State Chancellors award for Excellence in Teaching (2006), and the Maryland Board of Regents Teaching Award (2018) - both of these awards are the highest awards in academia for both States.
Currently, Dr. Lembo is a Professor in the Department of Geography and Geosciences at Salisbury University, where he is also the Technical Director of the Eastern Shore Regional GIS Cooperative. Dr. Lembo has published numerous academic papers on GIS, authored a leading textbook on Statistical Problem Solving in Geography, and conducted sponsored research for organizations like the National Science Foundation, NASA, the United States Department of Agriculture, and the Kellogg Foundation.