Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart (Programming Language) Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
IT & Software Other IT & Software GIS

Open Source GIS: Enterprise GIS w/ Postgres/PostGIS

Create an enterprise GIS with Postgres SQL, QGIS, and PostGIS to manage users, and support multiple GIS software clients
Rating: 4.4 out of 54.4 (40 ratings)
199 students
Created by Arthur Lembo
Last updated 4/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll 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!!!

Requirements

  • Students should know what GIS is, and have some experience using GIS
  • Students should be excited to learn about how to implement an Enterprise GIs
  • Although this class provides a lot of hand-holding 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.

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


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

Course content

3 sections • 20 lectures • 3h 45m total length

  • Preview07:31
  • Preview18:29
  • Install Postgres
    05:55
  • Install QGIS
    02:31
  • Import our data
    13:16
  • Ways to load data into Postgres/PostGIS
    09:37

  • Logical Design: Groups, Users, and Layers
    19:30
  • Physical Design - Roles, Users, and Layers - Part 1
    17:22
  • Physical Design - Roles, Users, and Layers - Part 2
    09:02
  • Physical Design - Views
    11:48
  • Physical Design - Constraints
    06:46
  • Physical Design - Triggers
    18:49
  • Clean up code - make sure to run this
    02:02

  • Accessing Enterprise GIS data from desktop clients
    07:36
  • Simultaneous Multi-user Editing of Enterprise GIS data
    09:24
  • Server-Side Analysis of Enterprise GIS Data
    18:06
  • Accessing Enterprise GIS Data with Python
    12:22
  • A Demonstration of Internet Mapping with Postgres/PostGIS
    12:07
  • Bonus Lecture: Hosting your enterprise GIS in the cloud
    15:33
  • Bonus Lecture: How to keep learning
    07:23

Instructor

Arthur Lembo
Professor
Arthur Lembo
  • 4.2 Instructor Rating
  • 3,369 Reviews
  • 12,468 Students
  • 19 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.