$120 – $132

Dive into PostGIS: A Beginners Guide to Spatial Databases - Spring 2019

Event Information

Share this event

Date and Time

Location

Location

City College of San Francisco - Mission Campus

1125 Valencia Street

San Francisco, CA 94110

View Map

Refund Policy

Refund Policy

Contact the organizer to request a refund.

Event description

Description

Brief Description:

This two-session workshop is aimed at GIS practitioners who are proficient with GIS principles and GIS software but wish to learn more about relational databases, especially spatial ones. We will first develop a shared, basic understanding of non-spatial SQL (structured query language) queries and a quick overview of basic SQL.

Next, we will move on to data management in PostGIS, a free, open-source platform that adds support for geographic objects to the PostgreSQL object-relational database. Using PostGIS, we will convert shapefiles to PostGIS tables and add spatial data manually with SQL statements. Since PostGIS supports multiple formats for data entry and retrieval, the workshop will quickly touch on that.

Once the basics of data management have been established, we will practice performing selections by location as well as an assortment of powerful geoprocessing functions. To do this, students will work in the free, open-source QGIS platform to visualize the results of the geoprocessing operations and perform edits in QGIS that are saved to the database.

Note that students will be required to bring a laptop with QGIS pre-installed. We will use a browser-based Postgres/PostGIS client with a remotely-hosted database that the instructor will set up. All workshop materials, including the SQL statements used in lessons, will be hosted on a website with a bit.ly link.

By completing this workshop you will be able to:

  • Describe the basics of non-spatial SQL with emphasis on data types, simple selectors, and insert statements.
  • Set projections for PostGIS tables
  • Understand the difference between geometry and geography spatial data types
  • Use SQL to insert data (points, lines, polygons) using several geographic data formats.
  • Connect to a PostGIS database with QGIS and edit tables in QGIS
  • Spatially query data
  • Perform basic geoprocessing operations using SQL.

This workshops meets once per week (6:00 - 9:00 p.m.) for two sessions: April 1 and April 8.

Important Notes:

  • The workshop venue may change based on classroom availability. Registered students will be given advance notice if this is the case.

  • If the workshop is held, as planned, at CCSF's Mission campus, computers will be provided for workshop exercises. Alternately, students are welcome to bring their own laptops.

  • If the workshop must be moved to another venue, students will be required to bring their own wi-fi enabled laptops to class, either a PC or a Mac.

Instructor: Zach Noah.

FAQs
For more information about this workshop, the GIS Educaton Center, and our refund policy, please visit ccsfgis.org

Share with friends

Date and Time

Location

City College of San Francisco - Mission Campus

1125 Valencia Street

San Francisco, CA 94110

View Map

Refund Policy

Contact the organizer to request a refund.

Save This Event

Event Saved