NodeXL and ArcGIS

Jul 9, 2013 at 4:28 PM
Edited Jul 9, 2013 at 4:31 PM
I am looking for a way to export a network graph as a layer for ArcGIS. The goal of the task is pretty straightforward. I have a set of socially connected individuals who each have a physical address (entered as a column value for each vertex). I want to geocode the addresses while also showing the network relationships (edges)... the goal being to highlight both the social and spatial aspects of the network. It seems as if ArcGIS schematics or network analyst tools should be able to accommodate this, but if so it is not obvious to me. As I am dealing with just a few dozen individuals this could be done in a manual fashion, but that misses the larger point. Thanks for your ideas and help.
Jul 18, 2013 at 7:36 PM
Here is my way...
Add ID to each relation, then make a list of points like example Image, you can add as many columns you need - you will need geographic coordinates for sure - you can export them from addresses using google spreadsheet (read below) Then create a point layer based on geographic coordinates in ArcGis, after that use tool Point to Line tool from Data Management and set your ID field as Line_Field. You should get final line layer. You can add degree information to merged point layer and visualize that by increased symbol size.

Here is how you can export coordinate from address. Ex:
Open empty google spreadsheet and:
  1. Put your address in A1 cell.
  2. Copy following statement to the B1 cell
  3. Replace SOURCE CELL ADDRESS in the code to the A1
=importXML("" & "&q=" &SOURCE CELL ADDRESS& "&key=" & "ABQIAAAA-O3c-Om9OcvXMOJXreXHAxSsTL4WIgxhMZ0ZK_kHjwHeQuOD4xSbZqVZW2U_OWOxMp3YPfzZl2GavQ","/kml/Response/Placemark[1]/Point/coordinates")

PS. It obviously doesnt work for PO Box addresses...
Jul 18, 2013 at 7:54 PM

Thanks so much for the response. It makes perfect sense.

Jul 18, 2013 at 8:42 PM
the other thing to note is you can only have 50 google xml calls at a time in a sheet, if you want to use this you have to do a copy values, to limit the number of formulas

No problem...