PostGIS Training Packages

Get Training from the Experts

Who better to learn from than the project visionaries themselves? As lead contributors, we offer unsurpassed user and developer training programs for PostGIS.

Choose from our existing course material, or let us tailor a training session to your specific needs and application. We offer instructor-based training at our office, or anywhere in the world at your location or via the web. Contact us for pricing based on location, participants and custom material.

Sample Course Outline

Please note that times are flexible - they are used primarily to demonstrate the approximate length of each session.

Day 1

Time Description of topics covered
8:30 - 10:00 am Introduction to Spatial Concepts
  • Geometric Datatypes
  • Metadata Views
10:15 - 11:45 am Installation
  • Configuration
  • Installing PostgreSQL
  • Installing PostGIS
  • Creating a Spatially Enabled Database
1:00 - 2:30 pm Using PostGIS - Part 1
  • Connecting to the Database
  • Simple Spatial SQL
  • Loading Data
  • Insert Statements
  • Feature Manipulation Engine (FME)
  • OGR
2:45 - 4:30 pm Using PostGIS - Part II
  • Creating Spatial Indexes
  • Using Spatial Indexes
  • Indexes and Query Plans
  • When Query Plans Go Bad
  • Spatial Comparators

Day 2

Time Description of topics covered
8:30 - 10:00 am Exporting Data
  • Shapefile Writer (pgsql2shp)
  • Feature Manipulation Engine (FME)
  • OGR
  • Database Dumps
  • Query Exports
10:15 - 11:45 am Viewing Data
  • Options
  • Mapserver and PostGIS
1:00 - 2:30 pm Database Administration
  • Tables
  • Role Management
  • Vacuum
  • Analyze
  • Cluster
  • Accepted Host Configuration
2:45 - 4:30 pm Compatability with Oracle SDO and ArcSDE
  • Overview
  • Interoperability

Open Source Company

Refractions sponsors and develops PostGIS as an open source project in collaboration with developers from around the world. Visit the PostGIS open source community site at postgis.refractions.net.

Get a Quote Now

Get in touch, tell us your plans, and we'll figure out the technology mix and development that makes sense for you.

Start now...