Using Open Source Tools to Create an Enterprise GIS

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

Ratings: 4.01 / 5.00




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.


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

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.