I have a data set of a sewage pipe network and point data (assets). I would like to:
- first calculate the flow direction of pipes (polyline feature)
- assign IDs to the pipelines using asset IDs (connecting). Eg, pipeline x starts from asset number 11 to asset number 10. I want to update the pipeline columns, one with downstream value of 10 (from asset) and another of upstream value of 11 (asset ID).
I have tried network analyst with ArcGIS but got stuck when trying to assign the IDs. Open to Python or any other code, or Modelbuilder.