Queries and transformations

Geospatial data provides answers to some of our most difficult business questions, but we must know how to ask the questions. While this topic will be introduced here, additional details will be provided in the Querying Geospatial Data with Amazon Athena chapter. In the AWS cloud, you have the option to use traditional SQL clients to query the database directly, or one of the SQL interfaces provided in the AWS console. SQL clients that you may already be familiar with provide a familiar interface to your geospatial data. Amazon RDS and Athena offer convenient interfaces through a web browser that do not require local installation of any software.

If you have an existing Aurora Serverless v1 database with a compatible version of PostgreSQL, the Query Editor tool can be used in the RDS section of the AWS console. There are many flexible options to access your datasets based on your use case and client environment. The Aurora Serverless PostgreSQL database...