In this post, we show you how to migrate spatial (geospatial) data from self-managed PostgreSQL, Amazon RDS for PostgreSQL, or Amazon Aurora PostgreSQL-Compatible Edition to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition using AWS Database Migration Service (AWS DMS). Spatial data is useful for applications such as mapping, routing, asset tracking, and geographic visualization. We walk through setting up your environment, configuring AWS DMS, and validating the successful migration of spatial datasets.
Geospatial data represents physical network paths, building locations, and elements that cross space. It includes critical data that helps identify geographic locations and enables insight generation for various applications. This type of data can be represented using a 2D coordinate system with latitude and longitude coordinates. The data can take multiple forms including:
- Points (such as GPS coordinates)
- Lines (such…