determine quadrant (north, east, south, west) of adjacent polygons

Discussion created by bemmelvb on Feb 22, 2011
Latest reply on Mar 10, 2011 by lorenc05

Is there a tool, workaround to determine the quadrant (north, east, south, west) of adjacent polygons for a record in a polygon-layer.

For example the result would be for province1
adjacent polygons:
province5: north
province10: west

I've a workaround which is:
- spatial join the polygon-layer with itself. Join to many. Add field ID. Intersect option.
- export to Excel, determine in excel based on the x,y-centroids of the polygon and the adjacent polygon in which quadrant its location is (which is quite complex if start from scratch)

The excel-part I would like to do in ArcGIS. Is it possible?
Thanks in advance.