Open Source GIS: Enterprise GIS w/ Postgres/PostGIS

Open Source GIS: Enterprise GIS w/ Postgres/PostGIS, available at $49.99, has an average rating of 4.65, with 20 lectures, based on 77 reviews, and has 476 subscribers.

You will learn about 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!!! This course is ideal for individuals who are This course is meant for those looking for hands-on experience building a multi-user enterprise GIS from scratch, using open source tools. or 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 or 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. It is particularly useful for This course is meant for those looking for hands-on experience building a multi-user enterprise GIS from scratch, using open source tools. or 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 or 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.

Enroll now: Open Source GIS: Enterprise GIS w/ Postgres/PostGIS

Summary

Title: Open Source GIS: Enterprise GIS w/ Postgres/PostGIS

Price: $49.99

Average Rating: 4.65

Number of Lectures: 20

Number of Published Lectures: 20

Number of Curriculum Items: 20

Number of Published Curriculum Objects: 20

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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!!!

Who Should Attend

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.

Target Audiences

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.

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.

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Understanding the entire Open Source GIS Curriculum

Lecture 2: Enterprise GIS overview

Lecture 3: Install Postgres

Lecture 4: Install QGIS

Lecture 5: Import our data

Lecture 6: Ways to load data into Postgres/PostGIS

Chapter 2: System Design and Implementation

Lecture 1: Logical Design: Groups, Users, and Layers

Lecture 2: Physical Design – Roles, Users, and Layers – Part 1

Lecture 3: Physical Design – Roles, Users, and Layers – Part 2

Lecture 4: Physical Design – Views

Lecture 5: Physical Design – Constraints

Lecture 6: Physical Design – Triggers

Lecture 7: Clean up code – make sure to run this

Chapter 3: Enterprise GIS Use in Practice

Lecture 1: Accessing Enterprise GIS data from desktop clients

Lecture 2: Simultaneous Multi-user Editing of Enterprise GIS data

Lecture 3: Server-Side Analysis of Enterprise GIS Data

Lecture 4: Accessing Enterprise GIS Data with Python

Lecture 5: A Demonstration of Internet Mapping with Postgres/PostGIS

Lecture 6: Bonus Lecture: Hosting your enterprise GIS in the cloud

Lecture 7: Bonus Lecture: How to keep learning

Instructors

Arthur Lembo
Professor

Rating Distribution

1 stars: 1 votes
2 stars: 1 votes
3 stars: 6 votes
4 stars: 27 votes
5 stars: 42 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu