Geospatial analysis with AWS Redshift

Question

We are using Redshift for data warehousing. We have a lot of geospatial information in our data and we wanted to churn it to understand User behaviour.

Has anyone done any geospatial analysis with Redshift. Do not see any direct support for GIS tools with Redshift.

Any suggestions?

score 3 · Answer 1 · answered Nov 22 '19 at 19:03

3

As of today Redshift supports spatial queries. https://docs.aws.amazon.com/redshift/latest/dg/geospatial-overview.html

answered Nov 22 '19 at 19:03

Joe Harris

13,671
4
47
54

score 1 · Answer 2 · edited Oct 20 '17 at 00:07

1

It is possible to add some basic geospatial support to Reshshift using Python UDFs as described in this blog.

Here is a permanent link to the original solution used in the blog.

edited Oct 20 '17 at 00:07

influent

1,337
3
14
31

answered Nov 04 '16 at 15:27

PyreneesJim

155
1
3
10

1

I would suggest you to read [why-is-linking-bad](http://meta.stackexchange.com/questions/7515/why-is-linking-bad) – Patrick Trentin Nov 04 '16 at 15:53
1

A link to explain why linking is bad. :) – dtbarne Mar 07 '19 at 17:17

Geospatial analysis with AWS Redshift

2 Answers2