Working with SQL Spatial and QGIS

Loading Map....

Date/Time
Date(s) - 10/18/2018
9:00 am - 4:30 pm

Location
Westminster City Park Recreation Center

Categories


This workshop will work with the basics of SQL and SQL spatial functions in a PostgreSQL/PostGIS database using Datagrip as the UI, then visualizing and styling the results in 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, buffer and distance calculations, geometry transformations with lines and centroids, creating tables and data management, accessing and styling PostGIS layers in QGIS, and creating static map images.


Instructor: Matthew Baker, Denver Public Schools


Instructor: Dave Murray, City of Westminster and UCD Instructor


Bring a laptops with QGIS [qgis.org] and DataGrip [jetbrains.com] installed.

Bookings

Ticket Type Price Spaces
Non-Member Ticket $85.00
Member Ticket $60.00