Solve OD cost matrix ??? Compute new field in « Line » objects table

Question

Dear all,
I am running several OD cost matrix analysis. Working with the "Lines" table output, I am wondering if it???s possible to add (or compute) a field during the solve process. By default the field names of the Lines table are:

ObjectID/Shape/Name/OriginID/DestinationID/DestinationRank/Total_Length

For example is it possible to have a Name2 field that would work exactly the same as the Name field ? Or another field like OriginID that contains a values from the Origins table ?

Here???s my situation :
Origins and destinations are addresses (point features) of my city and have the same table structure :

ObjectID/Shape/StreetName/StreetNum/AddressID/NeighbourID
« AddressID » is a unique address identifier. « NeighbourID » identify the zone (neighbourhood) in which the address point is located. My goal is to get the following « Lines » table after solving the OD cost matrix :

ObjectID/Shape/Name/OriginID/DestinationID/DestinationRank/Total_Length/OriginNeighbourID/DestinationNeighbourID/Name2 (see screenshot attached)

The only thing I found is the "add field to analysis layer" tool, but as far as I know it only adds field to Origins, Destinations, Barriers prior to the analysis.

Any idea ?
Best regards,
Theo

ideal_Lines_tableout.jpg

BrokenSearch.jpg

AndrewWilson1_1-1760486257962.png

AZendel · Answer

Maybe I'm missing something here, but this seems way too unnecessarily difficult.  I was able to use the "add field to analysis layer" tool to add a field that did show up in my output service area lines, but it was always completely null when trying several different input options in the tool.  I eventually used "Select Data" tool with the 'facilities' option and then copy features to export a point feature class with the "STOP_ID" field in my input point layer.  Then I joined the output lines using Facilities.ObjectID = ServiceAreaLines.FacilityID.  Then I used "Calculate Field" to finally get the STOP_ID onto the output service areas lines.

Why can't users just specify a series of fields in the "Add locations" tool and those fields be present (and populated) in all of the Network Analyst output!?!?!?

I think the documentation on this issue needs to be more fleshed out.  Sample geoprocessing models would also be helpful.

MelindaMorang1 · Answer

Is there a way to do this with python geoprocessing?  This is probably just a stupid problem, but I can't seem to figure out how to work with the Lines sublayer in python after I create it.

I want to:
- Create fields in the Lines layer correspinding to my unique stop ids that were in the origin and destination sublayers
- Export the Lines layer attributes table, including the new fields with the stop id, to a csv

I've figured out how to calculate the OD Matrix in python, but after it's created, I can't figure out how to do anything with it in python, although I'm able to manipulate it by hand from ArcMap.  I'm really stuck.

TheophileEmmanouilidis · Answer

Dear Jay,

Thanks a lot for your answer that helped me enough to succeed  😄
I've attached 2 screenshots of my OD Cost Matrix layer in Modelbuilder thinking that they might be helpfull to somebody.

Best regards,
Theo

OD cost matrix 2 modelbuilder.jpg

OD cost matrix modelbuilder.jpg

image001.png

eSearchWidget_files.zip