20200226 10194300 1.0 TRUE CopyFeatures "Closest Facility 2\Incidents" D:\Users\gpasquier\Documents\GIS_Projects\Union_City_CA\Union_City_CA.gdb\UnionCity_AddressLocations_withStationRanks # # # # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.3.0'><WorkspaceConnectionString>DATABASE=D:\Users\gpasquier\Documents\GIS_Projects\Union_City_CA\Union_City_CA.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>UnionCity_AddressLocations_withStationRanks</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>ClosestStation1</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>ClosestStation1</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>ClosestStation2</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>ClosestStation2</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>ClosestStation3</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>ClosestStation3</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField UnionCity_AddressLocations_withStationRanks ClosestStation1 !ClosestFacility_Routes_Rank1_Name![1] "Python 3" # CalculateField UnionCity_AddressLocations_withStationRanks ClosestStation1 !ClosestFacility_Routes_Rank1_Name![2] "Python 3" # CalculateField UnionCity_AddressLocations_withStationRanks ClosestStation1 !ClosestFacility_Routes_Rank1_Name![0:1] "Python 3" # CalculateField UnionCity_AddressLocations_withStationRanks ClosestStation1 !ClosestFacility_Routes_Rank1_Name![0:1:1] "Python 3" # CalculateField UnionCity_AddressLocations_withStationRanks ClosestStation1 !ClosestFacility_Routes_Rank1_Name![0:2:1] "Python 3" # CalculateField UnionCity_AddressLocations_withStationRanks ClosestStation2 !ClosestFacility_Routes_Rank2_Name![0:2:1] "Python 3" # CalculateField UnionCity_AddressLocations_withStationRanks ClosestStation3 !ClosestFacility_Routes_Rank3_Name![0:2:1] "Python 3" # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.3.0'><WorkspaceConnectionString>DATABASE=D:\Users\gpasquier\Documents\GIS_Projects\Union_City_CA\Union_City_CA.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>UnionCity_AddressLocations_withStationRanks</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>ClosestTime1</field_name><field_type>DATE</field_type><field_alias>ClosestTime1</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>ClosestTime2</field_name><field_type>DATE</field_type><field_alias>ClosestTime2</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>ClosestTime3</field_name><field_type>DATE</field_type><field_alias>ClosestTime3</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> ConvertTimeField "Address Points" ClosestFacility_Routes_Rank1_Total_TravelTime M ClosestFacility_Routes_Rank1_Total_TravelTime_Converted Text yyyyMMddHHmmss DeleteField "Address Points" ClosestFacility_Routes_Rank1_Total_TravelTime_Converted ConvertTimeField "Address Points" ClosestFacility_Routes_Rank1_Total_TravelTime M ClosestFacility_Routes_Rank1_Total_TravelTime_Converted Text mm:ss DeleteField "Address Points" ClosestFacility_Routes_Rank1_Total_TravelTime DeleteField "Address Points" ClosestFacility_Routes_Rank1_Total_TravelTime_Converted UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.3.0'><WorkspaceConnectionString>DATABASE=D:\Users\gpasquier\Documents\GIS_Projects\Union_City_CA\Union_City_CA.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>UnionCity_AddressLocations_withStationRanks</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>TravelTime1</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>TravelTime1</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField "Address Points" ClosestTime1 !ClosestFacility_Routes_Rank2_Total_TravelTime! "Python 3" # CalculateField "Address Points" ClosestTime1 "!ClosestFacility_Routes_Rank2_Total_TravelTime! / 24" "Python 3" # CalculateField "Address Points" ClosestTime1 "!ClosestFacility_Routes_Rank2_Total_TravelTime! / 60" "Python 3" # CalculateField "Address Points" ClosestTime1 "!ClosestFacility_Routes_Rank2_Total_TravelTime! / 1440 " "Python 3" # ConvertTimeField "Address Points" ClosestTime1 'Not Used' ClosestTime1_Converted Text m:ss DeleteField "Address Points" ClosestTime2 DeleteField "Address Points" ClosestTime3 UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.3.0'><WorkspaceConnectionString>DATABASE=D:\Users\gpasquier\Documents\GIS_Projects\Union_City_CA\Union_City_CA.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>UnionCity_AddressLocations_withStationRanks</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>ClosestTime2</field_name><field_type>DATE</field_type><field_alias>ClosestTime2</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>ClosestTime3</field_name><field_type>DATE</field_type><field_alias>ClosestTime3</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> DeleteField "Address Points" TravelTime1 UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.3.0'><WorkspaceConnectionString>DATABASE=D:\Users\gpasquier\Documents\GIS_Projects\Union_City_CA\Union_City_CA.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>UnionCity_AddressLocations_withStationRanks</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Routes_TotalTravelTime1</field_name><field_type>DOUBLE</field_type><field_alias>Routes_TotalTravelTime1</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField UnionCity_AddressLocations_withStationRanks Routes_TotalTravelTime1 !ClosestFacility_Routes_Rank1_EndTime!-!ClosestFacility_Routes_Rank1_StartTime! "Python 3" # CalculateField UnionCity_AddressLocations_withStationRanks Routes_TotalTravelTime1 "!ClosestFacility_Routes_Rank1_EndTime!- !ClosestFacility_Routes_Rank1_StartTime!" "Python 3" # CalculateField "Address Points" ClosestTime2 !ClosestTime1! "Python 3" # CalculateField "Address Points" ClosestTime3 !ClosestFacility_Routes_Rank3_Total_TravelTime! "Python 3" # CalculateField "Address Points" ClosestTime3 !ClosestFacility_Routes_Rank3_Total_TravelTime!/1440 "Python 3" # CalculateField "Address Points" ClosestTime2 !ClosestFacility_Routes_Rank2_Total_TravelTime!/1440 "Python 3" # CalculateField "Address Points" ClosestTime1 !Routes_TotalTravelTime1!/(24*60) "Python 3" # DeleteField "Address Points" ClosestTime1_Converted ConvertTimeField "Address Points" ClosestTime1 'Not Used' ClosestTime1_Converted Text mm:ss ConvertTimeField "Address Points" ClosestTime2 'Not Used' ClosestTime2_Converted Text mm:ss ConvertTimeField "Address Points" ClosestTime2 'Not Used' ClosestTime2_Converted Text mm:ss.s ConvertTimeField "Address Points" ClosestTime1 'Not Used' ClosestTime1_Converted Text mm:ss.s ConvertTimeField "Address Points" ClosestTime3 'Not Used' ClosestTime3_Converted Text mm:ss.s ConvertTimeField "Address Points" ClosestTime1_Converted mm:ss.s ClosestTime1_Min Text "mm "minutes" ss "seconds"" ConvertTimeField "Address Points" ClosestTime1_Converted mm:ss.s ClosestTime1_Min Text "mm 'Minutes' ss 'Seconds'" ConvertTimeField "Address Points" ClosestTime1_Converted mm:ss.s ClosestTime1_Display Text "mm 'minutes' ss 'seconds'" DeleteField "Address Points" ClosestTime1_Min ConvertTimeField "Address Points" ClosestTime2_Converted mm:ss.s ClosestTime2_Display Text "mm 'minutes' ss 'seconds'" ConvertTimeField "Address Points" ClosestTime2_Converted mm:ss.s ClosestTime2_Display Text "mm 'minutes' ss.2 'seconds'" ConvertTimeField "Address Points" ClosestTime2 mm:ss.s ClosestTime2_Display Text "mm 'minutes' ss 'seconds'" ConvertTimeField "Address Points" ClosestTime1 mm:ss.s ClosestTime1_Display Text "mm 'minutes' ss 'seconds'" ConvertTimeField "Address Points" ClosestTime1 mm:ss.s ClosestTime1_Display Text "mm 'minutes' ss 'seconds'" ConvertTimeField "Address Points" ClosestTime2 mm:ss.s ClosestTime2_Display Text "mm 'minutes' ss 'seconds'" ConvertTimeField "Address Points" ClosestTime3 mm:ss.s ClosestTime3_Display Text "mm 'minutes' ss 'seconds'" address address point updated Union City Address Points