Learn the FOSS4g Stack: Enterprise GIS w/ PostgreSQL/PostGIS
Create an enterprise GIS with PostgreSQL/PostGIS, QGIS and Python. 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.
So. Are you willing to learn how to build an Enterprise GIS from scratch using Free and Open Source Software for GIS (FOSS4g)?
Responding to the high cost and complexities of implementing an Enterprise GIS, I created this easy-to-follow and learn, hands-on training course allowing learners (students, professionals, etc) to build a multi-user enterprise GIS from scratch using Postgres/PostGIS (free) and QGIS (free).
Additionally in this training I 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.
Also, 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.
Lesson 1: Introduction to the course
FREE PREVIEWCourse Material
Lesson 2: Download and Install QGIS
Lesson 3: Download and Install PostGreSQL/PostGIS
Lesson 4: Exploring our data
FREE PREVIEWLesson 5: How to load the data into PostgreSQL/PostGIS
Lesson 6: Adding data into PostgreSQL
Lesson 7: Logical Design: Groups, Users and Layers
Lesson 8: Roles, Users and Layers - Part 1
Lesson 9: Roles, Users and Layers - Part 2
Lesson 10: Views
Lesson 11: Constraints
Lesson 12: Triggers
Lesson 13: Cleanup
Lesson 14: Access Enterprise GIS data from desktop client
Lesson 15: Simultaneous Multi-user editing of Enterprise GIS data
Lesson 16: Server-side data analysis of Enterprise GIS
Lesson 17: Use Python to access Enterprise GIS data
Lesson 18: Demonstrating internet mapping with PostgreSQL/PostGIS and Geoserver
Lesson 19: AcuGIS
€35,00
Regular price
Install Postgres, PostGIS and QGIS
Design a PostgreSQL database with multiple users and roles
Load spatial and attribute data into PostgreSQL and PostGIS
Manage data by including constraints, views, and indexes
Connect GIS software and clients to the Enterprise PostgreSQL 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
Under/post graduate students
Professionals and Companies
Master students and PhD candidates
Researchers and Academics
Learners should have a knowledge of what GIS is, and have some experience using GIS
Learners should be excited to learn about how to implement an Enterprise GIS
Although this course provides a lot of hands on 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
Arthur Lembo
Professor
€25,00
Enroll NowFree
Enroll Now