Redshift and Quicksight for Spatial Data

Question 1: Is Redshift the optimal solution for storing geospatial data for analytics, or should we consider PostgreSQL with PostGIS instead? What limitations might we encounter with Redshift for this purpose?

-> You can store geospatial data in Redshift using GEOMETRY and GEOGRAPHY data types. https://docs.aws.amazon.com/redshift/latest/dg/geospatial-overview.html

The considerations for storing spatial data for Redshift are mentioned here ->https://docs.aws.amazon.com/redshift/latest/dg/spatial-limitations.html.

For any advice related to choosing between multiple technologies for your use-case, I would request you to check with AWS solutions architect team https://aws.amazon.com/contact-us/sales-support/ as they are equipped to guide better on such inquiries .

Question 2: Does QuickSight support the functionality to select and visualize different data layers on a base map?

->For details around what QuickSight base maps support, I would request you to review the documentation available here ->https://docs.aws.amazon.com/quicksight/latest/user/geospatial-data-prep.html and https://docs.aws.amazon.com/quicksight/latest/user/geospatial-charts.html .