Developing Open Source SpatiaLite Databases in QGIS

The workshop will introduce principles and practices about spatial database management using open-source GIS, specifically QGIS and its spatial database SpatiaLite. The workshop will also provide hands-on training about both basic and advanced spatial Structured Query Language (SQL) queries in SpatiaLite. Previous experience with GIS is required.

July 11, 2022, 11:00am Eastern Time – September 8, 2022, 4:30pm Eastern Time

Webinar Ended


Xiang ChenXiang Chen, University of Connecticut

Dr. Xiang Chen is an Assistant Professor in the Department of Geography at the University of Connecticut, USA. His research interests are focused on GIScience and community health. He employs GIS to understand the socioeconomic and health inequalities across urban communities.

Eligibility and capacity

We will select up to 20 graduate students to participate in this workshop. Selection will be based on your AAG membership status, your research needs, and time of registration. If you are selected, we will notify you ahead of the workshop and provide you all the workshop details and session links. If you are selected, the expectation is that you will participate in all sessions of the workshop.


The selected participants should have a basic understanding and experience of GIS. The students need to have used at least one GIS software (e.g., ArcGIS, ArcGIS Pro, QGIS). The students can be from any sub-discipline in Geography and can be on any graduate-level (e.g., master, Ph.D.).

Detailed schedule

This workshop will meet at the following times (Eastern Time):

  • Session 1: AAG Welcome Session, 11:00am – 12: 30pm, Monday, July 11
  • Session 2: Lecture 1—Fundamentals of Spatial Database Systems, 10:00am – 12:00pm, Tuesday, July 12
  • Session 3: Optional Office Hours, 10:00 – 11:00am, Wednesday, July 13
  • Session 4: Lecture 2—SQL Queries, 10:00am – 12:00pm, Thursday, July 14
  • Session 5: Lecture 3—SpatiaLite Applications, 10:00 – 11:00am, Friday, July 15
  • Session 6: Optional Office Hours, 11:00am – 12:00pm, Friday, July 15

Throughout the week, expect to also spend a few hours working independently on readings or short assignments for the workshop.