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.

NEW! We also now offer a self-paced PostGIS course, perfect for individuals to learn at their own pace, see http://refractions.net/company/news/20111111/ for details.

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
  • Why use PostGIS
  • Geometric Datatypes
  • Geometry Validity
  • 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
  • PostGIS Functions
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 Advanced Concepts
  • Shapefile Writer (pgsql2shp)
  • DE9IM Definition and Usage
  • ST_Relate
  • Topology
  • OGR
  • Database Dumps
  • Query Exports
10:15 - 11:45 am Queries and Viewing Data
  • Spatial Joins and Overlays
  • Geometry Contructors and Accessors
  • 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 Advanced PostGIS Modules
  • CUBE indexs
  • Clustering
  • PG Routing

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...