Please see the attached picture re the fields in question.
Are the data points? or a polyline? or do you only have the data in a table
Hi Dan, The fibre loop is a data point. So the AsBuiltLength represents the difference between begin and endmeasure. I want to add an algorithm to the AsBuiltLength field: AsBuiltLength = endmeasure -beginmeasure [or vice versa]. This will save a bit of time. Cheers, Sean
I take it you aren't using arcmap which would be a simple field calculation, so perhaps you might want to elaborate on which part of the 'Developer' forest you are in. You can Share to a more directed space if you want (access to the top right of your question)
Thanks, I'll return to the question on Monday.
Hi Dan, I am using ArcMap. I'm definitely in a forest, so I can't elaborate too much. Would you have any recommendations for sharing/tags?
And you seem to indicate that you already have the information in fields... hence, no coding needed, no application development needed, just use the field calculator
http://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/fundamentals-of-field-calculations.htm
and Pythagorean theorem to the rescue... assuming you can calculate the difference in the x and y coordinates from the fields. If you don't have them, then you can actually calculate the same values using the field calculator and retrieving the start and end points using arcpy in the field calculator.
Sean, if your data is in a relational database, a trigger could calculate the AsBuiltLength on an update to the endmeasure and beginmeasure fields (obviously checking that both are populated)..