Using Open Source Tools to Create an Enterprise GIS

Learn to build a multi-user Enterprise GIS from scratch using Free and Open Source Software like Postgres, PostGIS, and QGIS in this hands-on course.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course teaches you to build an Enterprise GIS using free software like Postgres and QGIS. You’ll learn to manage users and data for a mid-sized municipality, and even how to perform simultaneous edits—all while keeping it simple and fun. Seriously, it’s like building your own GIS playground!

Key Points

  • Create a multi-user Enterprise GIS from scratch.
  • Use Free and Open Source Software: Postgres, PostGIS, and QGIS.
  • Manage users with different permissions.
  • Perform simultaneous multi-user editing on GIS layers.
  • Access GIS tools using Python for custom applications.

Learning Outcomes

  • Understand how to install and configure PostGRES and PostGIS.
  • Design a database to support multiple users and roles.
  • Load and manage GIS data effectively in the database.
  • Implement real-time multi-user collaboration in GIS.
  • Create custom GIS applications using Python.

About This Course

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 Quantum GIS (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 that includes vector and raster data 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.


  • Install PostGRES and PostGIS

  • Design a PostGRES database with multiple users and roles

  • Load GIS and attribute data into PostGRES and PostGIS

Instructor

Profile photo of Arthur Lembo
Arthur Lembo

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

Review
4.9 course rating
4K ratings
ui-avatar of Alka Ramnath
Alka R.
4.0
1 year ago

It was an excellent course and it has definitely achieved its objective as it has given me the confidence to set up an enterprise GIS without having to use super-expensive consultants who make it sound like it is top-secret magic. My only recommendation is that the course is updated as I have completed it in 2024 and as the course pointed out, opensource software changes rapidly. I therefore had to rely on Google in following the course steps but using the most recent, stable version of the different software. I will definitely be telling all those I know about this course and encouraging them to complete it as they work in public sector organisations and therefore cannot afford the expensive software and consultants. Thank you so much!

  • Helpful
  • Not helpful
ui-avatar of Thomas Okine
Thomas O.
4.0
1 year ago

Looks good but outdated
New links should be uploaded for the web builder for QGIS

  • Helpful
  • Not helpful
ui-avatar of Saskia Bestmann
Saskia B.
4.0
2 years ago

As other users already said, the course is a litte bit outdated, but with knowledge in SQL und QGIS still good to follow. Would recommend it!

  • Helpful
  • Not helpful
ui-avatar of Heather Stanton
Heather S.
3.0
2 years ago

This course is pretty out of date, but still has useful information. Also, I don't view this as enterprise GIS, so much as enterprise GIS databases.

  • Helpful
  • Not helpful
ui-avatar of Wilfried NZI
Wilfried N.
3.5
3 years ago

Great course, Im starting to understand a lot of things in databases especially in Postgres. really cool !

  • Helpful
  • Not helpful
ui-avatar of Enrica De Luchi
Enrica D. L.
5.0
3 years ago

I really enjoyed this course. Excellent teacher with great teaching capabilities. It seems a little "old fashioned", now but still really useful. I hope the teacher will update it, soon.

  • Helpful
  • Not helpful
ui-avatar of Michael Davies
Michael D.
5.0
3 years ago

Thank you for the course Arthur. Working in geospatial for about 10 years, I had no experience of databases, let alone creating an enterprise level setup, so this has been super helpful, thank you!

  • Helpful
  • Not helpful
ui-avatar of Bankim Chandra Yadav
Bankim C. Y.
5.0
4 years ago

Everytime I watched Dr. Arthur's courses, he is there with some new technology to train us on. This course has showed me how to actually deploy enterprise GIS and develop an understanding about it from scratch. Otherwise, these were just fancy words for me. Thanks Dr. Arthur.

  • Helpful
  • Not helpful
ui-avatar of Etienne Drouin
Etienne D.
4.0
4 years ago

La formation a besoin d'une mise à jour, mais avec un peu de recherche sur les changements dans les logiciels, on y arrive. La formation est simplet et complète sur les éléments de base.

  • Helpful
  • Not helpful
ui-avatar of Ankur Mishra
Ankur M.
2.5
4 years ago

The video is years old and uses years old versions of softwares and no latest information available.

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses