Learning the FOSS4g Stack:Enterprise GIS w/ Postgres/PostGIS
Training
Online
Description
-
Type
Training
-
Methodology
Online
-
Class hours
4h
-
Duration
Flexible
-
Start date
Different dates available
"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."
Facilities
Location
Start date
Start date
About this course
"Install Postgres and PostGISDesign a Postgres database with multiple users and rolesLoad spatial and attribute data into Postgres and PostGISManage data by including constraints, views, and indexesConnect GIS software and clients to the Enterprise Postgres databasePerform simultaneous multi-user editing of GIS dataIssue spatial and non-spatial SQL to perform geographic analysisDevelop and external application (kiosk) in PythonPublish 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 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."
"Students should know what GIS is, and have some experience using GISStudents should be excited to learn about how to implement an Enterprise GIsAlthough 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."
"-100% online -Access to the course for life -30 days warranty money back -Available from desktop or mobile app -Can begin and finish the course any time -Can repeat the course any times"
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 3 years
Subjects
- Design
- QGIS
- Internet
- Access
- GIS
- GIS Data
- GIS Training
- GIS Technology
- PostGIS
- Postgres
- QGIS Training
- QGIS tutorial
- Programmers
- Programming skills
- WebGIS
- Web Programming
- GIS Analyst
- Geographic Information Systems
- QGIS Orientation
- QGIS Project
Teachers and trainers (1)
AulaGEO Academy
Specialized center in Geospatial, Engineering and Operations
We choose the best courses and make them available to new audiences in the spectrum CAD - GIS - BIM - Digital Twins Our training offer covers the entire spectrum of data intelligence: Capture - Modeling - Design - Construction - Operation. The creators of courses with which we have decided to work or promote have been carefully selected, to offer a complementary set of knowledge. We firmly believe that today people do not seek courses to fill their walls with diplomas; but to make their abilities more productive.
Course programme
Understanding the entire Open Source GIS Curriculum
Enterprise GIS overview
Install Postgres
Install QGIS
Import our data
Ways to load data into Postgres/PostGIS
System Design and Implementation
Logical Design: Groups, Users, and Layers
Physical Design - Roles, Users, and Layers - Part 1
Physical Design - Roles, Users, and Layers - Part 2
Physical Design - Views
Physical Design - Constraints
Physical Design - Triggers
Clean up code - make sure to run this
Enterprise GIS Use in Practice
Accessing Enterprise GIS data from desktop clients
Simultaneous Multi-user Editing of Enterprise GIS data
Server-Side Analysis of Enterprise GIS Data
Accessing Enterprise GIS Data with Python
A Demonstration of Internet Mapping with Postgres/PostGIS
Bonus Lecture: Hosting your enterprise GIS in the cloud
Bonus Lecture: How to keep learning"
Learning the FOSS4g Stack:Enterprise GIS w/ Postgres/PostGIS