Geospatial data can be defined as information regarding objects or events that include location as additional attributes. This means that you can map features that represent real-world phenomena into latitude and longitude coordinates from earth’s surface. With this, you can perform analysis, generate insights and create a clear picture of a given situation. For example, in an emergency context, humanitarian organizations apply geospatial analysis to find health facilities nearby an earthquake epicenter, improving operations while reducing response times.

We can leverage the understanding of different circumstances by applying location information in a given context. However, it becomes necessary to have well-defined concepts and terminology. Working with geospatial data requires a minimum basis that can facilitate the daily work of many developers and analysts.

In this talk, I will provide an introduction of performing taks and working with geospatial data using duckdb. We will take advantage of this modern tool, that provides it users the ease of getting started, working with it and also integrate with different programming languages, such as Python. At the end of this talk, attendees will have a clear view about what is geospatial data, how to collect it and run geospatial operations. I will select common and open data sources used in emergency context. However, the knowledge can be re-used in any real world scenario.

The schedule of this talk is the following:

• Installation of duckdb (10 seconds).
• Basics of GIS (10 minutes).
• Loading geospatial data in duckdb (5 minutes) using custom functions.
• Operations with vector data (intersection of polygons, aggregation of points, etc.) (10 minutes).
• Data export using geospatial standards (3 minutes).
• Common issues found (2 minutes).