Loading Events

« All Events

  • This event has passed.

Spatial SQL (#maptimeDavis)

May 10 @ 10:00 am - 12:00 pm

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 and “Introduction to SQL for Querying Databases” on April 11, 2022 to gain these skills if needed.

Software: Please install Spatialite (instructions here: https://github.com/ucdavisdatalab/Spatial_SQL/blob/master/Install.md ) and QGIS (available at https://qgis.org/ ) before the workshop. Both of these programs are free and open source and are available for Mac, Windows, and Linux.           

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.

Location: Zoom. Click link below to APPLY to this workshop.

Apply to workshop: https://registration.genomecenter.ucdavis.edu/events/SpatialSQLmaptimeDavis/apply/

Cost: Free of charge.

Details

Date:
May 10
Time:
10:00 am - 12:00 pm
Event Tags:
, , , , , , , ,

Resources

Workshop Reader




Organizer

DataLab

Venue

Zoom