4 ms·
How i would do it: 1. Create a table with quad tiles of appropriate size/level as Parquet. Put it in s3 and map it as a table in AWS Athena (Trino) 2. Put the
by fifilura 2y ago
How i would do it:
1. Create a table with quad tiles of appropriate size/level as Parquet. Put it in s3 and map it as a table in AWS Athena (Trino)
2. Put the census data in s3/Athena.
3. Join using Trino geospatial functions. https://trino.io/docs/current/functions/geospatial.html https://trino.io/docs/current/functions/geospatial.html
The result for all quad tiles will be there within a couple of minutes.