Enterprise GIS Made Easy

Name: Enterprise GIS Made Easy
Rating: 4.5 (165 reviews)

Step by step instructions for implementing multi-user, multi-platform GIS for free

Created byMichael Miller

Last updated 11/2019

English

English [Auto],

What you'll learn

What enterprise GIS is and how it works
How enterprise GIS can benefit your organization
How to set up a PostGIS database on a hosted server for only a few dollars per month
How to access that data from QGIS, ArcGIS, and other clients

Course content

7 sections • 24 lectures • 4h 25m total length

Introduction6:09
Learn to implement your own enterprise GIS using open source software. Set up a fully functional multi-user database with affordable hosting and client access.
What is enterprise GIS?6:29
Explore what enterprise GIS is and how it differs from desktop GIS, emphasizing its multi-user, database-backed model for geospatial data and scalable cross-platform access.
What is a server? What is a client?9:56
Define servers as software that listens for requests and returns responses, from time and file servers to web and database servers, while clients initiate requests and interpret responses.
More about database servers16:37
Discover how modern database servers use robust, secure, sequel-based querying to support millions of users, store tabular and spatial data, and enable spatial analysis with extensions like Postgres sequel.
Files vs. Client-server7:13
Contrast file based architectures with client-server databases to show how multi-user edits avoid data loss and corruption through incremental updates and versioning.
Who needs enterprise GIS?7:58
Identify who benefits from an enterprise GIS and how centralized databases enable real-time collaboration. See how open-source tools support multiple clients, permissions, and web or mobile data viewing.

Steps to migrating to GIS3:15
Learn to set up an enterprise GIS by provisioning a database server, creating editor and reader roles, migrating data with QGIS, configuring privileges, and connecting via pgAdmin.
Exploring hosting solutions18:20
Compare A2 hosting and AQ GIS for enterprise GIS hosting, detailing remote access, storage, pricing, and built-in tools like PostGIS, pgAdmin, GeoServer, and Scout.
Setting up a hosting account with A2 hosting6:12
Sign up for a web hosting service to run a PostgreSQL database, choose a swift plan, register a domain, and review pricing, backups, and future management.
Creating a database and setting up user accounts on A2 hosting8:54
Create and manage a PostgreSQL database on A2 hosting, add editor and reader users, assign them to the database, access via phpPgAdmin, and request remote access via support.
Setting up a hosting account with AcuGIS4:44
Set up a university database with PostGIS via a hosting account, using cPanel, creating the Enterprise database and reader/editor users, and enabling PostGIS on servers worldwide.

Using QGIS to load data into A2 hosting19:31
Use QGIS to load shapefile data into a PostGIS database via the DB Manager, converting filenames to lowercase, creating a spatial index, and importing layers into the public schema.
Using shp2pgsql to load data into AcuGIS8:05
Load zipped shapefiles into the AQ J.S. enterprise database using the shape-to-postgres loader, specify srid 4326, set the public schema, and create a spatial index.
Using shp2pgsql to load data into AcuGIS - pt 28:59
learn how to load shapefiles into AcuGIS with shp2pgsql, resolve permission issues, and grant editor and reader privileges in pgAdmin for the public schema.

Exploring user priveleges in QGIS9:23
Explore how QGIS enforces database-level and field-level privileges across enterprise data, demonstrating editor and reader roles, and secure editing of polygons and attributes in shapefiles and hosted datasets.
Adding a user and setting user priveleges9:55
Add a new manager user, grant read and write access across tables, then fine-tune field privileges—restricting geometry edits and specific columns—using pgAdmin and UI tools.

Connecting to your database from ArcGIS8:34
Learn to connect ArcGIS to a PostGIS database with query layers, validate connections, and load tables with correct geometry and spatial reference for efficient geospatial analysis.
Managing your database with pgAdmin412:01
Explore how to manage a PostgreSQL database with pgAdmin4, including connecting to an instance, navigating databases and schemas, and understanding ownership, privileges, and prefixes for organization.
Managing your database with pgAdmin4 - pt 218:16
Explore common database objects in PostgreSQL with pgAdmin4, including schemas, tables, views, sequences, triggers, and PostGIS types, and learn to write and run spatial SQL queries using the query tool.
Web mapping applications as clients for your Enterprise GIS14:47
Learn how a live web mapping application connects multiple clients to a single enterprise geodatabase, enabling real-time viewing, editing, and spatial analyses across desktop, web, and mobile.
Creating new tables with the QGIS DBManager12:03
Learn to use the qgis db manager to access postgresql databases, view table details and geometry types, and create or edit tables with spatial data.

Organizing your data for optimum performance17:42
Organize enterprise gis data to maximize performance by using fast transfer speeds, local solid-state drives for large background data, and central database for shared data, with scale-dependent rendering.
Where to go next14:38
Explore next steps in enterprise GIS by expanding your PostGIS and QGIS knowledge, mastering spatial databases, web mapping with Leaflet, and mobile data collection with field apps like QField.

Requirements

A basic understanding of desktop GIS software
A desire to expand your skill set into enterprise GIS

Description

Many GIS Professionals start their careers as GIS users with an education in other fields. They may be very good at cartography and spatial analysis and other GIS specific tasks but lack the IT background needed to understand and implement a multi-user, enterprise GIS.

As a result many smaller organizations struggle as they grow and find themselves needing multi-user access to their data from multiple locations. They frequently find themselves unable to edit shared data because of file-locks and other issues or put their data at risk by storing it on cloud-drives. Many of them know that enterprise solutions exist but commercial solutions are very expensive and they don't have time to understand all the open-source tools that are available.

If this rings true to you, please consider taking this course. I explain how an open-source GIS enterprise works, what software you need to get started, how to start an instance of PostGIS on a hosted server for a few dollars per month, how to load your data into that hosted database and set up user accounts to control access, and how to connect to your data from a variety of sources including commercial desktop GIS software.

Who this course is for:

GIS Professionals with a solid understanding of desktop GIS that have interest or need to move into an enterprise GIS system to provide multi-user access, from multiple locations, on multiple platforms.

Enterprise GIS Made Easy

What you'll learn

Explore related topics

Course content

Introduction6 lectures • 54min

Getting started with enterprise GIS5 lectures • 41min

Loading data into your database3 lectures • 37min

Managing user priveleges2 lectures • 19min

Connecting to your database from different hosts5 lectures • 1hr 6min

FInal considerations2 lectures • 32min

Bonus Lecture1 lecture • 16min

Requirements

Description

Who this course is for: