Does anyone know the equivalent of the spatial join tool in ArcMap that can be used in Hadoop?
I am trying to join point and polygon data in Hadoop and create a new point files that adds the attributes of the polygon data.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
Adapt the GIS Tools for Hadoop samples of Point-in-Polygon join, to output the desired info, rather than output counts.
Something to the effect of the following untested query:
SELECT earthquakes.*, counties.* from earthquakes, counties
WHERE ST_Contains(counties.boundaryshape, ST_Point(earthquakes.longitude, earthquakes.latitude));
I think this would be spatial aggregation based on this article.