[GIS] Create table with Geometry Column in hadoop Hive

geoprocessinghadoophivereferences

Is there a way to add a geometry column in hadoop? Please give me some getting-started tutorial for geoprocessing in hadoop. Like, I have a database which have point values and if I take a random point, I need to check all the values which come under 10km radius of that point.

Best Answer

Have you looked at the Esri GIS Tools for Hadoop? It includes an implementation of ST_Geometry for Hive, in the Spatial Framework for Hadoop.

You can start with the samples.

There are example calls to the various ST_Geometry UDFs in the scripts under spatial-framework-for-hadoop/hive/test/.

(Disclosure: I'm a collaborator.) (Update: added more hyperlinks.)

Related Solutions

[GIS] create temporary point geometry feature from coordinates in OGR with Python

Using the coordinates of the linestring geometry feature it is possible to simply create a geometry object like:

 point = ogr.Geometry(ogr.wkbPoint)
 point.AddPoint(g.GetX(j), g.GetY(j))#where j is the iteration in the linestring i.e. 0

that can later be used with: point.Within(polygon)

[GIS] Opening geoprocessing tools causes ArcGIS to hang

My ArcMap was crashing every time I tried to open any geoprocessing tool, or the toolbox itself. Was working fine for a week, until I auto-downloaded some updates last time I shut down the computer. Then all of a sudden I couldn't open the toolbox without crashing the program. After a very frustrating 4 hours, I fixed the problem. Not sure if this is the same thing you are experiencing, but maybe it will help others:

I reinstalled ArcMap and Python after de-activating a virus protection program a co-worker had installed (avast free antivirus program, seems like a crap program). I think what had happened was the security software had prevented a critical file from being downloaded and installed during the automatic update which was preventing python from running properly within ArcGIS.

Best Answer

Related Solutions

[GIS] create temporary point geometry feature from coordinates in OGR with Python

[GIS] Opening geoprocessing tools causes ArcGIS to hang

Related Question