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

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.

Course curriculum

  1. 01
  2. 02

    • 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
  3. 03

    • 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

Pricing - Life time Access

What will you learn?

  • 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

GEO Premium

Access our ENTIRE content with a yearly subscription only 8EUR/month

Learn More

Student Profile?

  • Under/post graduate students

  • Professionals and Companies

  • Master students and PhD candidates

  • Researchers and Academics

Some more information

  • Certificates of Completion

    After you successfully finish the course, you can claim your Certificate of Completion with NO extra cost! You can add it to your CV, LinkedIn profile etc

  • Available at any time! Study at your best time

    We know hard it is to acquire new skills. All our courses are self paced.

  • Online and always accessible

    Even when you finish the course and you get your certificate, you will still have access to course contents! Every time an Instructor makes an update you will be notified and be able to watch it for FREE

Requirements

  • 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

About your Instructor

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.

Arthur Lembo

Professor

Suggested Courses to follow

  • Learn the FOSS4g Stack: Spatial SQL with PostgreSQL/PostGIS

    €25,00

    Enroll Now

  • Learn the FOSS4g Stack: QGIS 3 Desktop

    Free

    Enroll Now