GIS in the Rockies is pleased to offer pre-conference workshops related to important topics in the GIS industry on Tuesday, September 18, 2018. There are a limited number of openings for each workshop, so please sign up for a workshop during the registration process. If you have already registered for the conference, you can modify your existing registration to add a workshop.

Introduction to Landsat Data Collections

Time: TBD
Instructor: Ramesh Sivanpillai, University of Wyoming
Cost: $25

Landsat series of satellites ( provide invaluable Earth Observation data for monitoring and mapping natural and man-made resources.  These data are available to users from the US Geological Survey (USGS) at no-cost since 2008.   Starting in 2016, USGS started organizing Landsat data in a tiered collection structure based on data quality and level of processing.  Users interested in time-series analyses will be able to evaluate and select Landsat images base on this tiered structure.  This lecture and demonstration-style workshop will introduce remote sensing concepts and characteristics of Landsat data and products such as vegetation indices, burn severity products etc.  Participants will also learn on how to search and download these data and products from USGS archives.  Upon successful completion participants will receive a completion certificate.

Intended Audience: GIS practitioners and others familiar with spatial (raster and vector) data.
Tech requirements: Participants must provide their own laptops.

Working with SQL Spatial in PostGIS with QGIS Visualization

Time: 1:00 p.m. – 4:30 p.m.
Instructor: Matthew Baker (Denver Public Schools)
Cost: $125

This workshop will give an overview of a PostgreSQL database hosted in the Amazon cloud, how to write basic queries against non-spatial relational data using DataGrip, then introducing the PostGIS spatial data and functions to spatially enable data and queries. From there, the basics of creating and managing data using SQL, and how to visualize the results using QGIS. Topics and workflows include counts, grouping, and filter operations, basic geometry operations and coordinate system transformations, exporting results to a spreadsheet, calculating area, spatial intersects, point-in-polygon, geometry transformations with lines and centroids, creating tables of results, accessing and styling PostGIS layers in QGIS, and creating static map images.

Intended Audience: Users of QGIS looking to integrate PostGIS into their workflows; ArcGIS users looking to learn about spatially-enabled relational databases; Database analysts looking to learn about spatial data.
Tech requirements: Participants must provide their own laptops (Windows, Mac, or Linux) with Java 8 installed.

Advanced OpenStreetMap

Time: TBD
Instructors: Mike Thompson (Humanitarian OpenStreetMap Team)
Fee: $25

This is an enhanced and updated version of the workshop of the same title from the 2016 GISITR. OpenStreetMap (OSM) is the collaborative project to create a free editable map of the world. Among many other uses, OSM is being used to support humanitarian missions around the World.  Many GIS professionals, academics and students have been introduced to OSM through humanitarian mapathons where an easy to use, in-browser editor called iD is usually used.  During this workshop participants will discover through hands on exercises how to access the power of the more advanced JOSM (Java OpenStreetMap) editor. Participants will explore JOSM’s building tool, extrude mode, way accuracy mode, support for topology, validation function, search function, filtering, and support for OSM “relations.” Participants will first gain an understanding of the unique and flexible OSM data structure that has allowed the project to evolve over its 13-year existence to cover not only its namesake streets, but points of interest, buildings, land cover, land use, trails, aeronautical features, maritime features and 100’s of other types of map features.   Understanding of the OSM data structure will enable the participant to quickly grasp the concepts of JOSM. The knowledge attained will enable more efficient contributions to OSM and enable them to make more effective use of OSM data in their professional / academic careers.

Intended Audience:GIS professionals, academics and students who wish to learn more about OpenStreetMap
Tech requirements: Participants must provide their own laptops (Windows, Mac, or Linux) with Java 8 installed.