Amazon Redshift announces spatial functionality enhancements
Amazon Redshift launched native spatial data processing support in November 2019, with a polymorphic data type GEOMETRY, and more than 40 SQL spatial functions. This capability enables you to store, retrieve, and process spatial data so you can enhance your business insights by integrating spatial data into your analytical queries. Now, Amazon Redshift supports over 30 new spatial functions such as validation, simplification of geometries, new spatial relationships like “Crosses” and “ContainsProperly”. Furthermore, Amazon Redshift enhanced the spatial functionality with multiple capabilities such as ODBC/JDBC support for GEOMETRY data, support for importing spatial data in Shapefile format, and spatial join performance improvements.
Source:: Amazon AWS