-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupdatebgPts_avgTT.py
34 lines (27 loc) · 1.02 KB
/
updatebgPts_avgTT.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
import arcpy, math
from arcpy import env
from array import array
import sqlite3, shutil, time
workspace = "H:\\metroFinal.gdb"
env.workspace = workspace
env.overwriteOutput = True
arcpy.CheckOutExtension("Network")
# Make TTM layers
arcpy.MakeFeatureLayer_management(r"H:\metroFinal.gdb\TravelTimeMatrix_origins", "origins_lyr")
arcpy.MakeFeatureLayer_management(r"H:\metroFinal.gdb\TravelTimeMatrix_destinations", "destinations_lyr")
arcpy.MakeFeatureLayer_management(r"H:\metroFinal.gdb\TravelTimeMatrix_lines", "lines_lyr")
# Other layers
arcpy.MakeFeatureLayer_management(r"metroFinal_FD\bgPts_final", "bgPtsFinal_lyr")
# Store avg_tt's in bgPts_final
oC = arcpy.da.SearchCursor("origins_lyr", ["ORIG_FID", "AVG_TT"])
origfid_tt_dict = {}
for row in oC:
origfid_tt_dict[row[0]] = row[1]
del row
del oC
bgC = arcpy.da.UpdateCursor(r"H:\metroFinal.gdb\metroFinal_FD\bgPts_final", ["ORIG_FID", "AVG_TT"])
for row in bgC:
row[1] = origfid_tt_dict[row[0]]
bgC.updateRow(row)
del row
del bgC