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

With the power of spatial database SQL queries married to the open source QGIS program you can become the true spatial wizard that you’ve always wanted to be. The class will start out with some basic data conversions between shapefiles and Spatialite databases. A discussion of open source GDAL and ORG tools will be presented. Then the students will jump into mapping with the desktop GIS program, QGIS. Students will become familiar with loading and symbolizing data with this full-featured open source GIS program. Then the power of spatial databases will be explored with the desktop open source program, Spatialite gui. Not only the ability to query the data using SQL but also the ability to create GIS layers using spatial queries will demonstrated. Results from these SQL processes will be displayed and visualized in QGIS. Students will become much more familiar with the concepts and practices of using spatial databases to conduct GIS analysis. Each student will be required to bring their own laptops. Both Spatialite and QGIS run on Windows, Mac and Linux computers. The students will be required to download and install these programs before the class. An FTP link will be given to each student before the class to access the data and class materials.

Intended Audience: Beginners
Tech requirements: Participants must provide their own laptops (Windows, Mac, or Linux) with Java 8 installed.