$180 – $198

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

Event Information

Share this event

Date and Time

Location

Location

Mapbox Headquarters

50 Beale Street

San Francisco, CA 94105

View Map

Refund Policy

Refund Policy

Contact the organizer to request a refund.

Eventbrite's fee is nonrefundable.

Event description

Description

Learning Objectives

This three-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.

Your Instructor

Zach Noah, who says: "I am passionate about public transit and using open data to improve the lives of people all around me. I currently work as a React developer who moonlights as a backend developer. My greatest achievement is developing a system to collect the location of the AC transit fleet every 30 seconds and store it in a Postgres/PostGIS database."

This Workshop Meets Three Times

  • Monday, November 4 (6:00 - 9:00 p.m.)

  • Monday, November 11 (6:00 - 9:00 p.m.)

  • Monday, November 18 (6:00 - 9:00 p.m.)

Questions?

Contact Rick Kos, BayGeo's Education Director at rkos@baygeo.org

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

Mapbox Headquarters

50 Beale Street

San Francisco, CA 94105

View Map

Refund Policy

Contact the organizer to request a refund.

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved