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

Call for upcoming dates or on-site delivery.
1 Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services. 2 Include course and course materials only. 3 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

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