Spatial SQL (#maptimeDavis)

Description

This workshop is intended to give participants an introduction to spatial SQL through working with a graphical user interface (GUI) with some examples of common analysis processes as well as offer participants resources for continued learning.      

Learning Objectives

By the end of this workshop, participants will be able to:

• Import data into an sqlite database
• Write queries to answer questions about the data
• ·Understand the difference between attribute queries and geometry queries
• View spatial tables and views in QGIS.  

Prerequisites

Participants should have an introductory understanding of SQL and databases. For example, participants should have an understanding of how to write a select statement and understand what a relational database is. We encourage participants to attend DataLab's "Introduction to databases and data storage technologies" on April 7, 2022 to gain these skills if needed.

Software

Participants who plan to follow along should install SpatiaLite and QGIS on their computers.   

Instructor: Michele Tobias         

Instructor Bio: Michele Tobias is a biogeomorphologist with a background in geospatial methods for ecology. At DataLab, she helps researchers understand and design geospatial methods and workflows, from data collection to spatial analysis to data visualization and cartography. Michele earned her PhD from UC Davis in Geography where she studied California’s sandy beach ecosystem with a mix of traditional phytosociological methods and innovative remote sensing tools. She has a bachelor’s degree in Geography (focused on biogeography) and German (focusing on linguistics) from UCLA and a master’s degree in Ecology (resource ecology & management) from University of Michigan. She worked at the UC Davis Information Center for the Environment as a postdoctoral scholar. Michele’s research interests include applying spatial analysis methods to new avenues of research.