Spike: How might we best convert GeoJSON to Well Known Text?

[LtChae]

GeoJSON is a standard for working with geographical data, but it is not well supported by Presto. If we could take geojson and its properties and turn it into tabular data with a column for the geometry in Well Known Text format, it would allow users to take advantage of Presto's powerful geospatial functions for joining and analysis.

Possible Solutions:

• Adapter to convert the data prior to reaper receiving it
• Extend Odo to handle this conversion
• Leverage the new transformations to make the conversion in the pipeline

There is an elixir library for this: https://github.com/bryanjos/geo

As well as a variety of Python ones.