Courses by Category
Click on a category below to see a listing of courses.

This course is available for customized on-site delivery for groups of 3 or more students.
Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

Introduction to GIS with PostGIS & MapServer (3 days)

Our PostGIS & MapServer training class teaches you the fundamentals of Geographic Information Systems (GIS) - including common conventions, and methods of managing and manipulating GeoSpatial data using the open-source PostGIS extentions to PostgreSQL.

Students attending this course will learn how to install, query, import, export, and manage GeoSpatial data within the PostgreSQL/PostGIS environment. The MapServer portion of this course teaches students how to utilize MapServer to generate static and interactive maps using data stored in the PostgreSQL relational database with PostGIS extensions.

Introduction to GIS with PostGIS & MapServer Course Calendar (3 days)


Call for upcoming dates or on-site delivery.
¹ Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services. ² Include course and course materials only. ³ Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone. For government and education pricing, please contact us.

Recommended Pre-requisites

Students attending this course should have the following:

An understanding of relational database fundamentals, including the ability to write SQL queries.
The ability to perform basic file management and editing tasks using the Linux file system (GUI editors are fine)

Course Outline/Agenda

This PostGIS and MapServer training course covers the following topics:

GIS Fundamentals
- What is GIS?
  - The Raster Model
  - Raster data structures
  - Vector data
- Spatial Coordinate systems
- Spatial Relativity
- Projections
- Understanding Polygon Access
- Geometries
Installing PostGIS
- PostGIS Pre-Install Steps
- Installed Files
- Creating a PostGIS Enabled Database
  - PostGIS Upgrades
- Exercises
PostGIS Data Loads
- Importing Shape Files
- Exercises
PostGIS Features
- PostGIS and OpenGIS
  - PostGIS and SRID's
- PostGIS Metadata Tables
- Expressing Spatial Objects
Creating PostGIS Tables & Loading Data
- Creating PostGIS Tables
- Removing Geometry Columns
  - Exercises
- Loading GIS Data
- Creating Indexes
- Exercises
Simple PostGIS Queries (Simple Features for SQL)
- PostGIS Queries
- Basic Intersection Queries
  - Exercises
- Areas from Polygons
  - Exercises
- Computing Centroids
- Coordinate Transformations
  - Exercises
- Aggregate Functions
  - Exercises
- Geometry Relationship functions
  - Exercises
- Other Geometry Functions
  - Exercises
Visualizing PostGIS Results
- Using uDig
  - Installing uDig
- Attaching to a Data Source
- Connecting to a WMS Server
- Adding PostGIS Sources
- Managing Layers
- Adding Custom Layers
- Displaying Meta-Data
- Navigating the Maps
  - Exercises
- Using ArcExplorer
Deploying UMN MapServer
- About MapServer
- Installing MapServer
- Creating Map files
- Setting Web Display Parameters
- Determining Map Information
  - General MAP File Format
- Exercises
- Defining Map Layers
  - Sample MAP File with Layer
- Adding Scale Information
- Exercises
- Specifying Class Information
- Performing Joins
- Styles
- Labels
- Exercises
Interactive Maps
- MapServer Browse Mode
- Creating the Web Template
- Exercises
- Setting Fonts
- Exercises

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

View course guide table of contents
Requires Adobe Acrobat Reader

Enroll in this course

PostgreSQL Admin Training Logo

View upcoming course calendar

info@otg-nc.com
877-258-8987