The code from earlier worked perfectly, but the only thing is it doesn't include syntax for the UniqueIDs.
Is there a way to modify it to include the UniqueIDs also if its ok with you we can scrap out the dates from the script. Thanks (see code below)
def main():
import arcpy
import os
# Local variables
mygdb = r"C:\Users\samuel_ezeiruaku\Documents\output_work\DesignPressure\PHMSA_reporting\PT_BestRecord\HT_Overlap_Inscope.gdb"
mytable = os.path.join(mygdb, "PNGTS_RefinedPT")
# Read input table into dictionary
itemsdict = {}
with arcpy.da.SearchCursor(mytable, ["HT_Item_Number", "Begin_Station_Num_m", "End_Station_Num_m"]) as s_cursor:
for item, begin, end in s_cursor:
itemsdict[item] = (begin, end)
# Identify segments
allsegments = [i[0] for i in itemsdict.values()] + [i[1] for i in itemsdict.values()]
segments = tuple(sorted(set(allsegments)))
del allsegments
# Create output table
arcpy.CreateTable_management(mygdb, "SegmentSequence_output")
mytable_out = os.path.join(mygdb, "SegmentSequence_output")
arcpy.AddField_management(mytable_out, "BeginFt", "FLOAT")
arcpy.AddField_management(mytable_out, "EndFt", "FLOAT")
arcpy.AddField_management(mytable_out, "SegmentItems", "TEXT", field_length=255)
# Write segment items to output table
with arcpy.da.InsertCursor(mytable_out, ["BeginFt", "EndFt", "SegmentItems"]) as i_cursor:
for enum, seg in enumerate(segments):
try:
begin = seg
end = segments[enum + 1]
except IndexError:
break
seg_items = [k for k, v in itemsdict.items() if v[0] <= begin and v[1] >= end]
row = (begin, end, str(seg_items).strip('[]'))
i_cursor.insertRow(row)
if __name__ == '__main__':
main()
