5

Using Geospatial Data with Amazon Aurora PostgreSQL

PostgreSQL has risen in popularity to become one of the most common geospatial platforms for storing structured relational data. Creating your own geodatabase a decade ago was reserved for the most experienced administrators. Today, we can instantly spin up a globally replicated database in the cloud using infrastructure as code (IaC).

This chapter will teach you how to create, populate, use, and visualize an Amazon Aurora PostgreSQL geodatabase on Amazon Web Services (AWS). Specifically, we will cover the following topics:

  • Setting up the database
  • Connecting to the database
  • Geospatial data loading
  • Queries and transformations
  • Architectural considerations

Amazon Aurora is an AWS service that ...

Get Geospatial Data Analytics on AWS now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.