Spatial queries in PostGIS

  • Event: 2019 CAR Conference
  • Speakers: Andrew Chavez of The New York Times; Ariana Giorgi of The Dallas Morning News
  • Date/Time: Saturday, Mar. 9 at 11:30am
  • Location: Copper Cove - conference level
  • Audio file: No audio file available.

In this session, you will learn how to write spatial queries in PostGIS in order to make powerful conclusions with your geodata. We’ll go over examples and tricks, while also covering importing and exporting data. 

This class is good for: those comfortable writing their own SQL queries, including how to write “WHERE” and “GROUP BY” statements. Familiarity with writing spatial queries isn’t required, but students should have some basic GIS understanding.

Speaker Bios

  • Andrew Chavez (@adchavez) is a software engineer on the interactive news team at The New York Times.

  • I'm a Computational Journalist at the Dallas Morning News, specializing in analysis and collection for data stories and investigations. Previously, I was a data reporter at the Chronicle of Higher Education and graduated from Columbia's dual degree program in journalism and computer science. @ArianaNGiorgi

Related Tipsheets

No tipsheets have yet been uploaded for this event.