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 is a journalist/developer on the Interactive News team at The New York Times. Before the Times, he worked at The Dallas Morning News, the Austin American-Statesman and the Fort Worth Star-Telegram.

  • Ariana Giorgi is a Senior Computational Journalist at the Dallas Morning News where she writes and contributes to stories involving data analysis. @ArianaNGiorgi

Related Tipsheets

No tipsheets have yet been uploaded for this event.