Using Open Source Tools to Create an Enterprise GIS (Udemy.com)

Create an enterprise GIS with Postgres SQL, QGIS, and PostGIS to manage users, and support multiple GIS software clients

( 245 Reviews )

Created by: Arthur Lembo

Produced in 2015

What you will learn

Install PostGRES and PostGIS
Design a PostGRES database with multiple users and roles
Load GIS and attribute data into PostGRES and PostGIS
Manage data by including constraints, views, and indexes.
Connect GIS software as 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 an external application (kiosk) in Python
Publish enterprise data on the Internet

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 90 / 100

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.

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.

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

Time: 3.5h

Instructor Details

Arthur Lembo

4.5 Rating
245 Reviews

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

Spatial SQL with Postgres : A language for geographers

Spatial SQL with Postgres : A language for geographers (2016)
4.5 (208 Reviews)

- Provider: Udemy
- Time: 4h

$11.99

All courses by Arthur Lembo

More engineering courses

Digital Electronics: Robotics, learn by building module II

Digital Electronics: Robotics, learn by building module II (2021)
4.8 (90 Reviews)

- Provider: Udemy
- Time: 13h

$11.99

Do it Yourself-Automotive Electrical Diagnosis-Intermediate

Do it Yourself-Automotive Electrical Diagnosis-Intermediate (2021)
4.8 (83 Reviews)

- Provider: Udemy
- Time: 3h

$11.99

Crash Course Electronics and PCB Design (2021)
4.7 (312 Reviews)

- Provider: Udemy
- Time: 103.5h

$11.99

Learn Social Engineering From Scratch (2021)
4.7 (301 Reviews)

- Provider: Udemy
- Time: 12.5h

$11.99

Electricity & electronics - Robotics, learn by building

Electricity & electronics - Robotics, learn by building (2021)
4.7 (299 Reviews)

- Provider: Udemy
- Time: 10.5h

$11.99

Fundamentals of Electrical Controls (2021)
4.7 (244 Reviews)

- Provider: Udemy
- Time: 4h

$11.99

All engineering courses

Reviews

4.5

245 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Madhura Bhalerao on 11/15/2020

I am excited for further learning

By Aidan Short on 11/8/2020

Course does seem to be a bit outdated, we are currently at ArcGIS10.6, but the fundementals are good.

By Alexandre Dargains A. de Oliveira on 10/21/2020

I am still doing this course. However, up to now, I can say that the course is very basic and is not updated. Maybe my rate can change at the end of the course.

By Ahsan Riaz on 8/2/2020

Communication is precise and clear. Instructor knows what to deliver and how much to deliver for students ranging from beginner to expert level.

By Vikas Kamal on 7/8/2020

Excellent stuff...packed with amazing lessons...

By Sasha Shcheglov on 6/21/2020

Thank you a lot for this course!

By Yashar Alimohammadlou on 6/16/2020

The course is outdated and very superficial

By Hernan Galvis on 5/27/2020

Buena eleccin, hay algunos pocos fallos en los subititulos pero lo demas esta bien.
Los plugins de qgis que se utilizan ya no estan disponibles en las versiones actuales

By Susmita Das on 5/26/2020

This is really good one to learn in small steps and hope its going to help me a lot to add in my resume!

By Orlando Chacon on 5/26/2020

It was a very well explained, hands-on, tutorial for learning the basics of PostGIS (maybe enough for creating intermediate or advanced applications). This helped me to start using PostGIS with confidence.

By Asif Hanif on 5/12/2020