20230127 09311900 1.0 FALSE ssRoads 002 file://\\COPDFS1\Department\DPW\GIS LOC\Roads\DPW_Roads.gdb Local Area Network Projected GCS_NAD_1983_2011 Linear Unit: Foot_US (0.304801) NAD_1983_2011_StatePlane_Rhode_Island_FIPS_3800_Ft_US <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' 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/3.0.0'><WKT>PROJCS[&quot;NAD_1983_2011_StatePlane_Rhode_Island_FIPS_3800_Ft_US&quot;,GEOGCS[&quot;GCS_NAD_1983_2011&quot;,DATUM[&quot;D_NAD_1983_2011&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Transverse_Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,328083.3333333333],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-71.5],PARAMETER[&quot;Scale_Factor&quot;,0.99999375],PARAMETER[&quot;Latitude_Of_Origin&quot;,41.08333333333334],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,6568]]</WKT><XOrigin>-18120300</XOrigin><YOrigin>-47742100</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>103144</WKID><LatestWKID>6568</LatestWKID></ProjectedCoordinateSystem> 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\VHB Road Work Data\RoadProjectsVHB_1.10.23.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoadProjects_Service</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>HisProj</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField DPWRoadProjects_BAA HisProj "CIP_2020" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "Contract 10" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisProj "CIP_2020" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "Contract 07" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisProj "CIP_2020" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "Contract 08" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisProj "CIP_2020" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "Contract 09" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisProj "CIP_2020" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "DPD" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "Unknown" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisProj "CIP_2020" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisProj "Other" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "RI Energy (Gas)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "RI Energy (Gas)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisProj "Other" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisProj "Other" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "RI Energy (Gas)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisProj "Other" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "RI Energy (Gas)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "RI Energy (Gas)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisProj "Other" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "RI Energy (Gas)" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisProj "Other" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisProj "Other" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisCont "RIDOT" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisRepMeth "Mill & Overlay" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisRepMeth "Mill & Overlay" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisRepMeth "Mill & Overlay" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA CIP_P_N "CIP_2020" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA PropCIPCon "Crack Seal 1" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA CIPM_S "Complete" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA CIPM_Con "Indus, Inc." "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA CIP_P_N "Crack Seal 01" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA PropCIPCon "CS1" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA CIP_P_N "Crack Seal 02" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA CIPM_S "Complete" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA CIPM_Con "Indus, Inc." "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA CIP_P_N "Contract 8" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA CIP_P_N "Contract 9" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA CIP_P_N "Contract 10" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA CIPM_S "Complete" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA CIP_P_N "Contract 11" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPWRoadProjects_BAA HisDate 4/8/22 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Roads-All Fields" Length !SHAPE_Length! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Roads-All Fields" Length !SHAPE_Length! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Roads-All Fields" Miles !Length!/5280 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Roads-All Fields" Miles !Length!/5280 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Roads-All Fields" Miles round(!Miles!,3) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Roads-All Fields" Length round(!Length!,0) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Roads-All Fields" Area round(!Length!*!Width!,0) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Roads-All Fields" SqYards round(!Area!/9,0) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "Roads-All Fields" SqYards round(!Area!/9,1) "Python 3" # Text NO_ENFORCE_DOMAINS AddRelate DPWRoads pavementid Project_Lookup$ Project_Lookup$.pavementid Relate1 "One to many" RemoveRelate DPWRoads # CopyMultiple "'I:\GIS LOC\VHB Road Work Data\RoadProjectsVHB_1.10.23.gdb\DPWRoadProjects_Service' FeatureClass" "I:\GIS LOC\VHB Road Work Data\RoadProjectsVHB_1.10.23.gdb" DPWRoadProjects_Service_1 "DPWRoadProjects_Service FeatureClass DPWRoadProjects_Service_1 #" Rename "I:\GIS LOC\VHB Road Work Data\RoadProjectsVHB_1.10.23.gdb\DPWRoadProjects_Service_1" "I:\GIS LOC\VHB Road Work Data\RoadProjectsVHB_1.10.23.gdb\DPWRoads" FeatureClass CopyMultiple "'I:\GIS LOC\VHB Road Work Data\RoadProjectsVHB_1.10.23.gdb\DPWRoads' FeatureClass" "I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb" DPWRoads "DPWRoads FeatureClass DPWRoads #" 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>EstCost</field_name><field_name>CIPContrac</field_name><field_name>CIPFundTy</field_name><field_name>CIPUnitCst</field_name><field_name>CIPCstNoUt</field_name><field_name>CIPUtyCost</field_name><field_name>CIPTotCst</field_name><field_name>HisRepMeth</field_name><field_name>HisCont</field_name><field_name>HisContr</field_name><field_name>HisMaDate</field_name><field_name>HisMaCont</field_name><field_name>HisMaContr</field_name><field_name>PWSB_Reim</field_name><field_name>CIPM_P_T</field_name><field_name>CIPM_L</field_name><field_name>CIPM_C_Y</field_name><field_name>CIPM_S</field_name><field_name>CIPM_Con</field_name><field_name>CIP_P_N</field_name><field_name>PropCIPCon</field_name><field_name>CIPM_ScheduleSeason</field_name><field_name>CIPM_ScheduleDate</field_name><field_name>HisDate2</field_name><field_name>HisYear2</field_name><field_name>HisRepMeth2</field_name><field_name>HisCont2</field_name><field_name>HisContr2</field_name><field_name>HisMaDate2</field_name><field_name>HisMaCont2</field_name><field_name>HisMaContr2</field_name><field_name>CreationDate</field_name><field_name>Creator</field_name><field_name>EditDate</field_name><field_name>Editor</field_name><field_name>HisMaMethod</field_name><field_name>HisProj</field_name></DeleteField></workflow></operationSequence> FeatureClassToFeatureClass "I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads" "I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb" DPWRoads_rev # "pavementid "Pavement ID" true true false 4 Long 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,pavementid,-1,-1;StreetName "Street Name" true true false 100 Text 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,StreetName,-1,-1;FromStreet "From Street" true true false 80 Text 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,FromStreet,-1,-1;ToStreet "To Street" true true false 80 Text 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,ToStreet,-1,-1;Length "Length" true true false 8 Double 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,Length,-1,-1;Miles "Miles" true true false 8 Double 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,Miles,-1,-1;Width "Width" true true false 8 Double 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,Width,-1,-1;Owner "Owner" true true false 25 Text 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,Owner,-1,-1;FuncClass "Functional Class" true true false 50 Text 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,FuncClass,-1,-1;Ward "Ward" true true false 50 Text 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,Ward,-1,-1;Ward2 "Ward 2" true true false 50 Text 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,Ward2,-1,-1;pavementty "Pavement Type" true true false 100 Text 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,pavementty,-1,-1;Area "Area" true true false 8 Double 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,Area,-1,-1;SqYards "Square Yards" true true false 8 Double 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,SqYards,-1,-1;BenValue "Benefit Value" true true false 8 Double 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,BenValue,-1,-1;PCI_2020 "PCI 2020" true true false 4 Long 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,PCI_2020,-1,-1;HisDate "History Date" true true false 8 Date 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,HisDate,-1,-1;HisYear "History Year" true true false 4 Long 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,HisYear,-1,-1;SHAPE_Length "SHAPE_Length" false true true 8 Double 0 0 ,First,#,I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads,SHAPE_Length,-1,-1" # Rename "I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads_rev" "I:\GIS LOC\VHB Road Work Data\VHB_Nov2022\VHB_Nov2022.gdb\DPWRoads" FeatureClass AddRelate DPWRoads pavementid History_Roads_Link pavementid Relate1 "One to many" RemoveRelate DPWRoads # AddRelate DPWRoads pavementid History_Roads_Link pavementid Relate1 "One to many" RemoveRelate DPWRoads # AddRelate DPWRoads pavementid History_Roads_Link History_Roads_Link.PAVEMENTID Relate1 "One to many" RemoveRelate DPW_Roads Relate1 AddRelate DPW_Roads pavementid History_Roads_Link PAVEMENTID History "One to many" AddRelate "Road History (Other)" pavementid History_Roads_Link PAVEMENTID Relate2 "One to many" RemoveRelate "Road History (Other)" # AddRelate "Road History (Other)" pavementid History_Roads_Link PAVEMENTID Relate1 "One to many" RemoveRelate DPW_Roads # AddRelate DPW_Roads pavementid History_Roads_Link History_Roads_Link.PAVEMENTID History "One to many" RemoveRelate DPW_Roads # AddRelate DPW_Roads OBJECTID History_Roads_Link History_Roads_Link.ROADS_OBID Relate1 "Many to many" RemoveRelate DPW_Roads # AddRelate DPW_Roads OBJECTID History_Roads_Link History_Roads_Link.ROADS_OBID Relate1 "One to many" CalculateField DPW_Roads Ward 1 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 2 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 3 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 4 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 5 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 6 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 6 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 7 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 8 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 9 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 10 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 11 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 12 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward2 12 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 12 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 1 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 2 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 4 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 5 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 6 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 13 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 14 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 15 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward 01 Arcade # Text NO_ENFORCE_DOMAINS 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\Roads\DPW_Roads.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Ward2</field_name></DeleteField></workflow></operationSequence> CalculateField DPW_Roads Ward "01" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "02" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "03" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "04" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "05" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "06" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "07" Arcade # Text NO_ENFORCE_DOMAINS RemoveRelate DPW_Roads # CalculateField DPW_Roads Ward "02,03" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "10,11" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "11,13" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "03,04" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "04,12" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "05,12" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "06,12" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "01,12" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "04,14" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "01,02" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "02,03" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "02,03" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "05,14" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "05,06" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "06,15" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "07,15" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "08" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "08,09" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "08,11" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "08,13" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "09" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "09,10" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "09,11" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "13" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "13,15" Arcade # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Ward "08,13" Arcade # Text NO_ENFORCE_DOMAINS 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\Roads\DPW_Roads.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Segment_id</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> AddField DPW_Roads ONEHOT_StreetName_ADDISON_PL "Long (32-bit integer)" # # # "ADDISON PL (StreetName_One-hot)" NULLABLE NON_REQUIRED # EncodeField DPW_Roads StreetName One-hot # "End time" # AddField DPW_Roads ONEHOT_StreetName_ADDISON_PL_1 "Long (32-bit integer)" # # # "ADDISON PL (StreetName_One-hot)_1" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ADELAIDE_AVE__E_ "Long (32-bit integer)" # # # "ADELAIDE AVE (E) (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ADELAIDE_AVE__W_ "Long (32-bit integer)" # # # "ADELAIDE AVE (W) (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ADELPHI_AVE "Long (32-bit integer)" # # # "ADELPHI AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ADIE_ST "Long (32-bit integer)" # # # "ADIE ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ADMIRAL_ST "Long (32-bit integer)" # # # "ADMIRAL ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ADMIRAL_ST__EB_ "Long (32-bit integer)" # # # "ADMIRAL ST (EB) (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ADMIRAL_ST__WB_ "Long (32-bit integer)" # # # "ADMIRAL ST (WB) (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ADRIAN_HALL_WAY "Long (32-bit integer)" # # # "ADRIAN HALL WAY (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AFRICA_ST "Long (32-bit integer)" # # # "AFRICA ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AGNES_ST "Long (32-bit integer)" # # # "AGNES ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AINSWORTH_ST "Long (32-bit integer)" # # # "AINSWORTH ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALABAMA_AVE "Long (32-bit integer)" # # # "ALABAMA AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALASKA_ST "Long (32-bit integer)" # # # "ALASKA ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALBERT_ST "Long (32-bit integer)" # # # "ALBERT ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALBRO_ST "Long (32-bit integer)" # # # "ALBRO ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALDEN_ST "Long (32-bit integer)" # # # "ALDEN ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALDINE_ST "Long (32-bit integer)" # # # "ALDINE ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALDRICH_ST "Long (32-bit integer)" # # # "ALDRICH ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALDRICH_TER "Long (32-bit integer)" # # # "ALDRICH TER (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALEPPO_ST "Long (32-bit integer)" # # # "ALEPPO ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALEXANDER_ST "Long (32-bit integer)" # # # "ALEXANDER ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALFRED_STONE_RD "Long (32-bit integer)" # # # "ALFRED STONE RD (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALGER_AVE__N_ "Long (32-bit integer)" # # # "ALGER AVE (N) (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALGER_AVE__S_ "Long (32-bit integer)" # # # "ALGER AVE (S) (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALGONQUIN_ST "Long (32-bit integer)" # # # "ALGONQUIN ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALICANT_ST "Long (32-bit integer)" # # # "ALICANT ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALLENS_AVE "Long (32-bit integer)" # # # "ALLENS AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALLSTON_ST "Long (32-bit integer)" # # # "ALLSTON ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALMA_ST "Long (32-bit integer)" # # # "ALMA ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALMIRA_AVE "Long (32-bit integer)" # # # "ALMIRA AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALMY_ST "Long (32-bit integer)" # # # "ALMY ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALPHONSO_ST "Long (32-bit integer)" # # # "ALPHONSO ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALPINE_ST "Long (32-bit integer)" # # # "ALPINE ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALTHEA_ST "Long (32-bit integer)" # # # "ALTHEA ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALTO_ST "Long (32-bit integer)" # # # "ALTO ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALTON_RD "Long (32-bit integer)" # # # "ALTON RD (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALTON_ST "Long (32-bit integer)" # # # "ALTON ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALUMNI_AVE__E_ "Long (32-bit integer)" # # # "ALUMNI AVE (E) (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALUMNI_AVE__W_ "Long (32-bit integer)" # # # "ALUMNI AVE (W) (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALVERSON_AVE "Long (32-bit integer)" # # # "ALVERSON AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALVES_ST "Long (32-bit integer)" # # # "ALVES ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALVES_WAY "Long (32-bit integer)" # # # "ALVES WAY (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ALVIN_ST "Long (32-bit integer)" # # # "ALVIN ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AMANDA_WAY "Long (32-bit integer)" # # # "AMANDA WAY (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AMBOY_ROAD "Long (32-bit integer)" # # # "AMBOY ROAD (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AMBROSE_ST "Long (32-bit integer)" # # # "AMBROSE ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AMERICA_ST "Long (32-bit integer)" # # # "AMERICA ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AMES_ST "Long (32-bit integer)" # # # "AMES ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AMHERST_ST "Long (32-bit integer)" # # # "AMHERST ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AMITY_ST "Long (32-bit integer)" # # # "AMITY ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AMITY_STREET "Long (32-bit integer)" # # # "AMITY STREET (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AMORY_ST "Long (32-bit integer)" # # # "AMORY ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AMSTERDAM_ST "Long (32-bit integer)" # # # "AMSTERDAM ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AMY_ST "Long (32-bit integer)" # # # "AMY ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ANCHOR_ST "Long (32-bit integer)" # # # "ANCHOR ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ANDEM_ST "Long (32-bit integer)" # # # "ANDEM ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ANDERSON_ST "Long (32-bit integer)" # # # "ANDERSON ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ANDREWS_ST "Long (32-bit integer)" # # # "ANDREWS ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ANDY_ST "Long (32-bit integer)" # # # "ANDY ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ANGELL_CT "Long (32-bit integer)" # # # "ANGELL CT (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ANGELL_ST "Long (32-bit integer)" # # # "ANGELL ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ANN_ST "Long (32-bit integer)" # # # "ANN ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ANNIE_ST "Long (32-bit integer)" # # # "ANNIE ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ANSEL_AVE "Long (32-bit integer)" # # # "ANSEL AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ANTHONY_AVE "Long (32-bit integer)" # # # "ANTHONY AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_APPIAN_ST "Long (32-bit integer)" # # # "APPIAN ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_APPLEGATE_LN "Long (32-bit integer)" # # # "APPLEGATE LN (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_APPLETON_ST "Long (32-bit integer)" # # # "APPLETON ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_APRIL_CT "Long (32-bit integer)" # # # "APRIL CT (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ARBOR_DR "Long (32-bit integer)" # # # "ARBOR DR (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ARCADE_ST "Long (32-bit integer)" # # # "ARCADE ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ARCH_ST "Long (32-bit integer)" # # # "ARCH ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ARDMORE_AVE "Long (32-bit integer)" # # # "ARDMORE AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ARDOENE_ST "Long (32-bit integer)" # # # "ARDOENE ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ARDWICK_ST "Long (32-bit integer)" # # # "ARDWICK ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ARGOL_ST "Long (32-bit integer)" # # # "ARGOL ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ARLINE_ST "Long (32-bit integer)" # # # "ARLINE ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ARLINGTON_AVE "Long (32-bit integer)" # # # "ARLINGTON AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ARMINGTON_AVE "Long (32-bit integer)" # # # "ARMINGTON AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ARMSTRONG_AVE "Long (32-bit integer)" # # # "ARMSTRONG AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ARNOLD_ST "Long (32-bit integer)" # # # "ARNOLD ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ASCHAM_ST "Long (32-bit integer)" # # # "ASCHAM ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ASHBURTON_ST "Long (32-bit integer)" # # # "ASHBURTON ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ASHMONT_ST "Long (32-bit integer)" # # # "ASHMONT ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ASHTON_ST "Long (32-bit integer)" # # # "ASHTON ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ASTRAL_AVE "Long (32-bit integer)" # # # "ASTRAL AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ATILA_ST "Long (32-bit integer)" # # # "ATILA ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ATKINS_ST "Long (32-bit integer)" # # # "ATKINS ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ATLANTIC_AVE "Long (32-bit integer)" # # # "ATLANTIC AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ATLAS_ST "Long (32-bit integer)" # # # "ATLAS ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ATWELLS_AVE "Long (32-bit integer)" # # # "ATWELLS AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ATWOOD_ST "Long (32-bit integer)" # # # "ATWOOD ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ATWOOD_ST__N_ "Long (32-bit integer)" # # # "ATWOOD ST (N) (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_ATWOOD_ST__S_ "Long (32-bit integer)" # # # "ATWOOD ST (S) (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AUDREY_ST "Long (32-bit integer)" # # # "AUDREY ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AUDUBON_AVE "Long (32-bit integer)" # # # "AUDUBON AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AUGUST_ST "Long (32-bit integer)" # # # "AUGUST ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AUGUSTA_ST "Long (32-bit integer)" # # # "AUGUSTA ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AURELIA_DR "Long (32-bit integer)" # # # "AURELIA DR (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AURORA_ST "Long (32-bit integer)" # # # "AURORA ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AUTUMN_ST "Long (32-bit integer)" # # # "AUTUMN ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AVENTINE_AVE "Long (32-bit integer)" # # # "AVENTINE AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AVON_ST "Long (32-bit integer)" # # # "AVON ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AYRAULT_ST "Long (32-bit integer)" # # # "AYRAULT ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_AYRAULT_ST__Y_INT_ "Long (32-bit integer)" # # # "AYRAULT ST (Y-INT) (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BABCOCK_ST "Long (32-bit integer)" # # # "BABCOCK ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BADGER_RD "Long (32-bit integer)" # # # "BADGER RD (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BAFFIN_CT "Long (32-bit integer)" # # # "BAFFIN CT (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BAGALIA_DR "Long (32-bit integer)" # # # "BAGALIA DR (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BAILEY_BLVD "Long (32-bit integer)" # # # "BAILEY BLVD (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BAILEY_CT "Long (32-bit integer)" # # # "BAILEY CT (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BAINBRIDGE_AVE "Long (32-bit integer)" # # # "BAINBRIDGE AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BAKER_ST "Long (32-bit integer)" # # # "BAKER ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BALCOM_ST "Long (32-bit integer)" # # # "BALCOM ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BALDWIN_CT "Long (32-bit integer)" # # # "BALDWIN CT (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BALMORAL_AVE "Long (32-bit integer)" # # # "BALMORAL AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BALTIMORE_ST "Long (32-bit integer)" # # # "BALTIMORE ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BALTON_RD "Long (32-bit integer)" # # # "BALTON RD (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BANCROFT_ST "Long (32-bit integer)" # # # "BANCROFT ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BARBARA_ST "Long (32-bit integer)" # # # "BARBARA ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BARBERRY_HILL "Long (32-bit integer)" # # # "BARBERRY HILL (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BARBOUR_DR "Long (32-bit integer)" # # # "BARBOUR DR (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BARDEN_ST "Long (32-bit integer)" # # # "BARDEN ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BARKER_ST "Long (32-bit integer)" # # # "BARKER ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BARNES_ST "Long (32-bit integer)" # # # "BARNES ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BARONE_CT "Long (32-bit integer)" # # # "BARONE CT (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BARROWS_ST "Long (32-bit integer)" # # # "BARROWS ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BARRY_RD "Long (32-bit integer)" # # # "BARRY RD (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BARSTOW_ST "Long (32-bit integer)" # # # "BARSTOW ST (StreetName_One-hot)" NULLABLE NON_REQUIRED # AddField DPW_Roads ONEHOT_StreetName_BARTLETT_AVE "Long (32-bit integer)" # # # "BARTLETT AVE (StreetName_One-hot)" NULLABLE NON_REQUIRED # 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\Roads\DPW_Roads.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>ONEHOT_StreetName_ADDISON_PL</field_name><field_name>ONEHOT_StreetName_ADDISON_PL_1</field_name><field_name>ONEHOT_StreetName_ADELAIDE_AVE__E_</field_name><field_name>ONEHOT_StreetName_ADELAIDE_AVE__W_</field_name><field_name>ONEHOT_StreetName_ADELPHI_AVE</field_name><field_name>ONEHOT_StreetName_ADIE_ST</field_name><field_name>ONEHOT_StreetName_ADMIRAL_ST</field_name><field_name>ONEHOT_StreetName_ADMIRAL_ST__EB_</field_name><field_name>ONEHOT_StreetName_ADMIRAL_ST__WB_</field_name><field_name>ONEHOT_StreetName_ADRIAN_HALL_WAY</field_name><field_name>ONEHOT_StreetName_AFRICA_ST</field_name><field_name>ONEHOT_StreetName_AGNES_ST</field_name><field_name>ONEHOT_StreetName_AINSWORTH_ST</field_name><field_name>ONEHOT_StreetName_ALABAMA_AVE</field_name><field_name>ONEHOT_StreetName_ALASKA_ST</field_name><field_name>ONEHOT_StreetName_ALBERT_ST</field_name><field_name>ONEHOT_StreetName_ALBRO_ST</field_name><field_name>ONEHOT_StreetName_ALDEN_ST</field_name><field_name>ONEHOT_StreetName_ALDINE_ST</field_name><field_name>ONEHOT_StreetName_ALDRICH_ST</field_name><field_name>ONEHOT_StreetName_ALDRICH_TER</field_name><field_name>ONEHOT_StreetName_ALEPPO_ST</field_name><field_name>ONEHOT_StreetName_ALEXANDER_ST</field_name><field_name>ONEHOT_StreetName_ALFRED_STONE_RD</field_name><field_name>ONEHOT_StreetName_ALGER_AVE__N_</field_name><field_name>ONEHOT_StreetName_ALGER_AVE__S_</field_name><field_name>ONEHOT_StreetName_ALGONQUIN_ST</field_name><field_name>ONEHOT_StreetName_ALICANT_ST</field_name><field_name>ONEHOT_StreetName_ALLENS_AVE</field_name><field_name>ONEHOT_StreetName_ALLSTON_ST</field_name><field_name>ONEHOT_StreetName_ALMA_ST</field_name><field_name>ONEHOT_StreetName_ALMIRA_AVE</field_name><field_name>ONEHOT_StreetName_ALMY_ST</field_name><field_name>ONEHOT_StreetName_ALPHONSO_ST</field_name><field_name>ONEHOT_StreetName_ALPINE_ST</field_name><field_name>ONEHOT_StreetName_ALTHEA_ST</field_name><field_name>ONEHOT_StreetName_ALTO_ST</field_name><field_name>ONEHOT_StreetName_ALTON_RD</field_name><field_name>ONEHOT_StreetName_ALTON_ST</field_name><field_name>ONEHOT_StreetName_ALUMNI_AVE__E_</field_name><field_name>ONEHOT_StreetName_ALUMNI_AVE__W_</field_name><field_name>ONEHOT_StreetName_ALVERSON_AVE</field_name><field_name>ONEHOT_StreetName_ALVES_ST</field_name><field_name>ONEHOT_StreetName_ALVES_WAY</field_name><field_name>ONEHOT_StreetName_ALVIN_ST</field_name><field_name>ONEHOT_StreetName_AMANDA_WAY</field_name><field_name>ONEHOT_StreetName_AMBOY_ROAD</field_name><field_name>ONEHOT_StreetName_AMBROSE_ST</field_name><field_name>ONEHOT_StreetName_AMERICA_ST</field_name><field_name>ONEHOT_StreetName_AMES_ST</field_name><field_name>ONEHOT_StreetName_AMHERST_ST</field_name><field_name>ONEHOT_StreetName_AMITY_ST</field_name><field_name>ONEHOT_StreetName_AMITY_STREET</field_name><field_name>ONEHOT_StreetName_AMORY_ST</field_name><field_name>ONEHOT_StreetName_AMSTERDAM_ST</field_name><field_name>ONEHOT_StreetName_AMY_ST</field_name><field_name>ONEHOT_StreetName_ANCHOR_ST</field_name><field_name>ONEHOT_StreetName_ANDEM_ST</field_name><field_name>ONEHOT_StreetName_ANDERSON_ST</field_name><field_name>ONEHOT_StreetName_ANDREWS_ST</field_name><field_name>ONEHOT_StreetName_ANDY_ST</field_name><field_name>ONEHOT_StreetName_ANGELL_CT</field_name><field_name>ONEHOT_StreetName_ANGELL_ST</field_name><field_name>ONEHOT_StreetName_ANN_ST</field_name><field_name>ONEHOT_StreetName_ANNIE_ST</field_name><field_name>ONEHOT_StreetName_ANSEL_AVE</field_name><field_name>ONEHOT_StreetName_ANTHONY_AVE</field_name><field_name>ONEHOT_StreetName_APPIAN_ST</field_name><field_name>ONEHOT_StreetName_APPLEGATE_LN</field_name><field_name>ONEHOT_StreetName_APPLETON_ST</field_name><field_name>ONEHOT_StreetName_APRIL_CT</field_name><field_name>ONEHOT_StreetName_ARBOR_DR</field_name><field_name>ONEHOT_StreetName_ARCADE_ST</field_name><field_name>ONEHOT_StreetName_ARCH_ST</field_name><field_name>ONEHOT_StreetName_ARDMORE_AVE</field_name><field_name>ONEHOT_StreetName_ARDOENE_ST</field_name><field_name>ONEHOT_StreetName_ARDWICK_ST</field_name><field_name>ONEHOT_StreetName_ARGOL_ST</field_name><field_name>ONEHOT_StreetName_ARLINE_ST</field_name><field_name>ONEHOT_StreetName_ARLINGTON_AVE</field_name><field_name>ONEHOT_StreetName_ARMINGTON_AVE</field_name><field_name>ONEHOT_StreetName_ARMSTRONG_AVE</field_name><field_name>ONEHOT_StreetName_ARNOLD_ST</field_name><field_name>ONEHOT_StreetName_ASCHAM_ST</field_name><field_name>ONEHOT_StreetName_ASHBURTON_ST</field_name><field_name>ONEHOT_StreetName_ASHMONT_ST</field_name><field_name>ONEHOT_StreetName_ASHTON_ST</field_name><field_name>ONEHOT_StreetName_ASTRAL_AVE</field_name><field_name>ONEHOT_StreetName_ATILA_ST</field_name><field_name>ONEHOT_StreetName_ATKINS_ST</field_name><field_name>ONEHOT_StreetName_ATLANTIC_AVE</field_name><field_name>ONEHOT_StreetName_ATLAS_ST</field_name><field_name>ONEHOT_StreetName_ATWELLS_AVE</field_name><field_name>ONEHOT_StreetName_ATWOOD_ST</field_name><field_name>ONEHOT_StreetName_ATWOOD_ST__N_</field_name><field_name>ONEHOT_StreetName_ATWOOD_ST__S_</field_name><field_name>ONEHOT_StreetName_AUDREY_ST</field_name><field_name>ONEHOT_StreetName_AUDUBON_AVE</field_name><field_name>ONEHOT_StreetName_AUGUST_ST</field_name><field_name>ONEHOT_StreetName_AUGUSTA_ST</field_name><field_name>ONEHOT_StreetName_AURELIA_DR</field_name><field_name>ONEHOT_StreetName_AURORA_ST</field_name><field_name>ONEHOT_StreetName_AUTUMN_ST</field_name><field_name>ONEHOT_StreetName_AVENTINE_AVE</field_name><field_name>ONEHOT_StreetName_AVON_ST</field_name><field_name>ONEHOT_StreetName_AYRAULT_ST</field_name><field_name>ONEHOT_StreetName_AYRAULT_ST__Y_INT_</field_name><field_name>ONEHOT_StreetName_BABCOCK_ST</field_name><field_name>ONEHOT_StreetName_BADGER_RD</field_name><field_name>ONEHOT_StreetName_BAFFIN_CT</field_name><field_name>ONEHOT_StreetName_BAGALIA_DR</field_name><field_name>ONEHOT_StreetName_BAILEY_BLVD</field_name><field_name>ONEHOT_StreetName_BAILEY_CT</field_name><field_name>ONEHOT_StreetName_BAINBRIDGE_AVE</field_name><field_name>ONEHOT_StreetName_BAKER_ST</field_name><field_name>ONEHOT_StreetName_BALCOM_ST</field_name><field_name>ONEHOT_StreetName_BALDWIN_CT</field_name><field_name>ONEHOT_StreetName_BALMORAL_AVE</field_name><field_name>ONEHOT_StreetName_BALTIMORE_ST</field_name><field_name>ONEHOT_StreetName_BALTON_RD</field_name><field_name>ONEHOT_StreetName_BANCROFT_ST</field_name><field_name>ONEHOT_StreetName_BARBARA_ST</field_name><field_name>ONEHOT_StreetName_BARBERRY_HILL</field_name><field_name>ONEHOT_StreetName_BARBOUR_DR</field_name><field_name>ONEHOT_StreetName_BARDEN_ST</field_name><field_name>ONEHOT_StreetName_BARKER_ST</field_name><field_name>ONEHOT_StreetName_BARNES_ST</field_name><field_name>ONEHOT_StreetName_BARONE_CT</field_name><field_name>ONEHOT_StreetName_BARROWS_ST</field_name><field_name>ONEHOT_StreetName_BARRY_RD</field_name><field_name>ONEHOT_StreetName_BARSTOW_ST</field_name><field_name>ONEHOT_StreetName_BARTLETT_AVE</field_name></DeleteField></workflow></operationSequence> CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!) "Python 3" "segment_dict = {} def get_segment_id(street_name): if street_name in segment_dict: segment_dict[street_name] += 1 else: segment_dict[street_name] = 1 return segment_dict[street_name] " Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!) "Python 3" "segment_dict = {} def get_segment_id(StreetName): if StreetName in segment_dict: segment_dict[StreetName] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName] " Text NO_ENFORCE_DOMAINS 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\Roads\DPW_Roads.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Coordinate</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateGeometryAttributes DPW_Roads "Coordinate LINE_START_X;Coordinate LINE_START_Y" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "Coordinate LINE_START_X" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\Roads\DPW_Roads.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Coordinate</field_name><new_field_name>xCoordinate</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AddField><field_name>yCoordinate</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateGeometryAttributes DPW_Roads "yCoordinate LINE_START_Y" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "yCoordinate LINE_START_Y" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!) "Python 3" "segment_dict = {} def get_segment_id(StreetName): if StreetName in segment_dict: segment_dict[StreetName] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName] " Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!,!xCoordinate!) "Python 3" "segment_dict = {} def get_segment_id(StreetName,xCoordinate): if StreetName in segment_dict: segment_dict[StreetName] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName] " Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!,!xCoordinate!) "Python 3" "segment_dict = {} Xcoordinate_dict = {} def get_segment_id(StreetName,xCoordinate): if StreetName in segment_dict: segment_dict[StreetName] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName] " Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!,!xCoordinate!) "Python 3" "segment_dict = {} def get_segment_id(StreetName,xCoordinate): if StreetName in segment_dict: segment_dict[StreetName] += 1 if xCoordinate in segment_dict: segment_dict[xCoordinate] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName] " Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!) "Python 3" "segment_dict = {} def get_segment_id(StreetName): if StreetName in segment_dict: segment_dict[StreetName] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName]" Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!) "Python 3" "segment_dict = {} def get_segment_id(StreetName): if StreetName in segment_dict: segment_dict[StreetName] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName]" Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!) "Python 3" "segment_dict = {} def get_segment_id(StreetName): if StreetName in segment_dict: segment_dict[StreetName] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName]" Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!) "Python 3" "segment_dict = {} def get_segment_id(StreetName): if StreetName in segment_dict: segment_dict[StreetName] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName]" Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!) "Python 3" "segment_dict = {} def get_segment_id(StreetName): if StreetName in segment_dict: segment_dict[StreetName] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName]" Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!) "Python 3" "segment_dict = {} def get_segment_id(StreetName): if StreetName in segment_dict: segment_dict[StreetName] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName]" Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!) "Python 3" "segment_dict = {} def get_segment_id(StreetName): if StreetName in segment_dict: segment_dict[StreetName] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName]" Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Segment_id get_segment_id(!StreetName!) "Python 3" "segment_dict = {} def get_segment_id(StreetName): if StreetName in segment_dict: segment_dict[StreetName] += 1 else: segment_dict[StreetName] = 1 return segment_dict[StreetName]" Text NO_ENFORCE_DOMAINS 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\Roads\DPW_Roads.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>sequentialcoords</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField DPW_Roads sequentialcoords SequentialNumber() "Python 3" "# Calculates a sequential number # More calculator examples at esriurl.com/CalculatorExamples rec=0 def SequentialNumber(): global rec pStart = 1 pInterval = 1 if (rec == 0): rec = pStart else: rec = rec + pInterval return rec" Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads sequentialcoords SequentialNumber(!xCoordinate!) "Python 3" "# Calculates a sequential number # More calculator examples at esriurl.com/CalculatorExamples rec=0 def SequentialNumber(xCoordinate): global rec pStart = 1 pInterval = 1 if (rec == 0): rec = pStart else: rec = rec + pInterval return rec" Text NO_ENFORCE_DOMAINS 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\Roads\DPW_Roads.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>New_segment_id</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\Roads\DPW_Roads.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>sequentialcoords</field_name><field_name>New_segment_id</field_name></DeleteField></workflow></operationSequence> 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\Roads\DPW_Roads.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>AddressStart</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateGeometryAttributes DPW_Roads "AddressStart CURVE_COUNT" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "AddressStart EXTENT_MIN_X" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "xCoordinate LINE_END_X" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "xCoordinate LINE_START_X" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "AddressStart LINE_END_X" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\Roads\DPW_Roads.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>AddressStart</field_name><new_field_name>xEnd</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence> 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\Roads\DPW_Roads.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>DPWRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>xEnd</field_name></DeleteField></workflow><workflow><AddField><field_name>xEnd1</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateGeometryAttributes DPW_Roads "xEnd1 LINE_END_X" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "xEnd1 LINE_END_X" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "Length LINE_END_X" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "Length LENGTH" # # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "Length LENGTH" "US Survey Feet" # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "Miles LENGTH" "US Survey Miles" # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "Length LENGTH" "US Survey Miles" # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "Length LENGTH" "US Survey Feet" # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "Miles LENGTH" "US Survey Miles" # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "Miles LENGTH" "US Survey Miles" # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "Miles LENGTH" "US Survey Miles" # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes DPW_Roads "Miles LENGTH" "US Survey Miles" # PROJCS["NAD_1983_StatePlane_Rhode_Island_FIPS_3800_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",328083.3333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-71.5],PARAMETER["Scale_Factor",0.99999375],PARAMETER["Latitude_Of_Origin",41.08333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" Append MissingRoadsNormalized DPW_Roads "Use the field map to reconcile field differences" "pavementid "Pavement ID" true true false 4 Long 0 0,First,#;StreetName "Street Name" true true false 100 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoadsNormalized,StreetName,0,100;FromStreet "From Street" true true false 80 Text 0 0,First,#;ToStreet "To Street" true true false 80 Text 0 0,First,#;Length "Length" true true false 8 Double 0 0,First,#;Miles "Miles" true true false 8 Double 0 0,First,#;Width "Width" true true false 8 Double 0 0,First,#;Owner "Owner" true true false 25 Text 0 0,First,#;FuncClass "Functional Class" true true false 50 Text 0 0,First,#;Ward "Ward" true true false 50 Text 0 0,First,#;pavementty "Pavement Type" true true false 100 Text 0 0,First,#;Area "Area" true true false 8 Double 0 0,First,#;SqYards "Square Yards" true true false 8 Double 0 0,First,#;BenValue "Benefit Value" true true false 8 Double 0 0,First,#;PCI_2020 "PCI 2020" true true false 4 Long 0 0,First,#;HisDate "History Date" true true false 8 Date 0 0,First,#;HisYear "History Year" true true false 4 Long 0 0,First,#;Segment_id "Segment_id" true true false 4 Long 0 0,First,#;xCoordinate "xCoordinate" true true false 4 Long 0 0,First,#;yCoordinate "yCoordinate" true true false 4 Long 0 0,First,#;xEnd1 "xEnd1" true true false 4 Long 0 0,First,#" # # Append MissingRoads DPW_Roads "Use the field map to reconcile field differences" "pavementid "Pavement ID" true true false 4 Long 0 0,First,#;StreetName "Street Name" true true false 100 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoadsNormalized,StreetName,0,100;FromStreet "From Street" true true false 80 Text 0 0,First,#;ToStreet "To Street" true true false 80 Text 0 0,First,#;Length "Length" true true false 8 Double 0 0,First,#;Miles "Miles" true true false 8 Double 0 0,First,#;Width "Width" true true false 8 Double 0 0,First,#;Owner "Owner" true true false 25 Text 0 0,First,#;FuncClass "Functional Class" true true false 50 Text 0 0,First,#;Ward "Ward" true true false 50 Text 0 0,First,#;pavementty "Pavement Type" true true false 100 Text 0 0,First,#;Area "Area" true true false 8 Double 0 0,First,#;SqYards "Square Yards" true true false 8 Double 0 0,First,#;BenValue "Benefit Value" true true false 8 Double 0 0,First,#;PCI_2020 "PCI 2020" true true false 4 Long 0 0,First,#;HisDate "History Date" true true false 8 Date 0 0,First,#;HisYear "History Year" true true false 4 Long 0 0,First,#;Segment_id "Segment_id" true true false 4 Long 0 0,First,#;xCoordinate "xCoordinate" true true false 4 Long 0 0,First,#;yCoordinate "yCoordinate" true true false 4 Long 0 0,First,#;xEnd1 "xEnd1" true true false 4 Long 0 0,First,#" # # Append MissingRoads DPW_Roads "Use the field map to reconcile field differences" "pavementid "Pavement ID" true true false 4 Long 0 0,First,#;StreetName "Street Name" true true false 100 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoadsNormalized,StreetName,0,100;FromStreet "From Street" true true false 80 Text 0 0,First,#;ToStreet "To Street" true true false 80 Text 0 0,First,#;Length "Length" true true false 8 Double 0 0,First,#;Miles "Miles" true true false 8 Double 0 0,First,#;Width "Width" true true false 8 Double 0 0,First,#;Owner "Owner" true true false 25 Text 0 0,First,#;FuncClass "Functional Class" true true false 50 Text 0 0,First,#;Ward "Ward" true true false 50 Text 0 0,First,#;pavementty "Pavement Type" true true false 100 Text 0 0,First,#;Area "Area" true true false 8 Double 0 0,First,#;SqYards "Square Yards" true true false 8 Double 0 0,First,#;BenValue "Benefit Value" true true false 8 Double 0 0,First,#;PCI_2020 "PCI 2020" true true false 4 Long 0 0,First,#;HisDate "History Date" true true false 8 Date 0 0,First,#;HisYear "History Year" true true false 4 Long 0 0,First,#;Segment_id "Segment_id" true true false 4 Long 0 0,First,#;xCoordinate "xCoordinate" true true false 4 Long 0 0,First,#;yCoordinate "yCoordinate" true true false 4 Long 0 0,First,#;xEnd1 "xEnd1" true true false 4 Long 0 0,First,#" # # Append MissingRoads DPW_Roads "Use the field map to reconcile field differences" "pavementid "Pavement ID" true true false 4 Long 0 0,First,#;StreetName "Street Name" true true false 100 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoadsNormalized,StreetName,0,100;FromStreet "From Street" true true false 80 Text 0 0,First,#;ToStreet "To Street" true true false 80 Text 0 0,First,#;Length "Length" true true false 8 Double 0 0,First,#;Miles "Miles" true true false 8 Double 0 0,First,#;Width "Width" true true false 8 Double 0 0,First,#;Owner "Owner" true true false 25 Text 0 0,First,#;FuncClass "Functional Class" true true false 50 Text 0 0,First,#;Ward "Ward" true true false 50 Text 0 0,First,#;pavementty "Pavement Type" true true false 100 Text 0 0,First,#;Area "Area" true true false 8 Double 0 0,First,#;SqYards "Square Yards" true true false 8 Double 0 0,First,#;BenValue "Benefit Value" true true false 8 Double 0 0,First,#;PCI_2020 "PCI 2020" true true false 4 Long 0 0,First,#;HisDate "History Date" true true false 8 Date 0 0,First,#;HisYear "History Year" true true false 4 Long 0 0,First,#;Segment_id "Segment_id" true true false 4 Long 0 0,First,#;xCoordinate "xCoordinate" true true false 4 Long 0 0,First,#;yCoordinate "yCoordinate" true true false 4 Long 0 0,First,#;xEnd1 "xEnd1" true true false 4 Long 0 0,First,#" # # Append MissingRoads DPW_Roads "Use the field map to reconcile field differences" "pavementid "Pavement ID" true true false 4 Long 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,pavementid,-1,-1;StreetName "Street Name" true true false 100 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,StreetName,0,100;FromStreet "From Street" true true false 80 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,FromStreet,0,80;ToStreet "To Street" true true false 80 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,ToStreet,0,80;Length "Length" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,Length,-1,-1;Miles "Miles" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,Miles,-1,-1;Width "Width" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,Width,-1,-1;Owner "Owner" true true false 25 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,Owner,0,25;FuncClass "Functional Class" true true false 50 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,FuncClass,0,50;Ward "Ward" true true false 50 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,Ward,0,50;pavementty "Pavement Type" true true false 100 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,pavementty,0,100;Area "Area" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,Area,-1,-1;SqYards "Square Yards" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,SqYards,-1,-1;BenValue "Benefit Value" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,BenValue,-1,-1;PCI_2020 "PCI 2020" true true false 4 Long 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,PCI_2020,-1,-1;HisDate "History Date" true true false 8 Date 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,HisDate,-1,-1;HisYear "History Year" true true false 4 Long 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,HisYear,-1,-1;Segment_id "Segment_id" true true false 4 Long 0 0,First,#;xCoordinate "xCoordinate" true true false 4 Long 0 0,First,#;yCoordinate "yCoordinate" true true false 4 Long 0 0,First,#;xEnd1 "xEnd1" true true false 4 Long 0 0,First,#" # # Append MissingRoads DPW_Roads "Use the field map to reconcile field differences" "pavementid "Pavement ID" true true false 4 Long 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,pavementid,-1,-1;StreetName "Street Name" true true false 100 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,StreetName,0,100;FromStreet "From Street" true true false 80 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,FromStreet,0,80;ToStreet "To Street" true true false 80 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,ToStreet,0,80;Length "Length" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,Length,-1,-1;Miles "Miles" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,Miles,-1,-1;Width "Width" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,Width,-1,-1;Owner "Owner" true true false 25 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,Owner,0,25;FuncClass "Functional Class" true true false 50 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,FuncClass,0,50;Ward "Ward" true true false 50 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,Ward,0,50;pavementty "Pavement Type" true true false 100 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,pavementty,0,100;Area "Area" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,Area,-1,-1;SqYards "Square Yards" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,SqYards,-1,-1;BenValue "Benefit Value" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,BenValue,-1,-1;PCI_2020 "PCI 2020" true true false 4 Long 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,PCI_2020,-1,-1;HisDate "History Date" true true false 8 Date 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,HisDate,-1,-1;HisYear "History Year" true true false 4 Long 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\MissingRoads,HisYear,-1,-1;Segment_id "Segment_id" true true false 4 Long 0 0,First,#;xCoordinate "xCoordinate" true true false 4 Long 0 0,First,#;yCoordinate "yCoordinate" true true false 4 Long 0 0,First,#;xEnd1 "xEnd1" true true false 4 Long 0 0,First,#" # # Append The_Missing_Roads DPW_Roads "Use the field map to reconcile field differences" "pavementid "Pavement ID" true true false 4 Long 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,pavementid,-1,-1;StreetName "Street Name" true true false 100 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,StreetName,0,100;FromStreet "From Street" true true false 80 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,FromStreet,0,80;ToStreet "To Street" true true false 80 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,ToStreet,0,80;Length "Length" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,Length,-1,-1;Miles "Miles" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,Miles,-1,-1;Width "Width" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,Width,-1,-1;Owner "Owner" true true false 25 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,Owner,0,25;FuncClass "Functional Class" true true false 50 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,FuncClass,0,50;Ward "Ward" true true false 50 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,Ward,0,50;pavementty "Pavement Type" true true false 100 Text 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,pavementty,0,100;Area "Area" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,Area,-1,-1;SqYards "Square Yards" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,SqYards,-1,-1;BenValue "Benefit Value" true true false 8 Double 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,BenValue,-1,-1;PCI_2020 "PCI 2020" true true false 4 Long 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,PCI_2020,-1,-1;HisDate "History Date" true true false 8 Date 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,HisDate,-1,-1;HisYear "History Year" true true false 4 Long 0 0,First,#,I:\GIS LOC\Roads\DPW_Roads.gdb\The_Missing_Roads,HisYear,-1,-1;Segment_id "Segment_id" true true false 4 Long 0 0,First,#;xCoordinate "xCoordinate" true true false 4 Long 0 0,First,#;yCoordinate "yCoordinate" true true false 4 Long 0 0,First,#;xEnd1 "xEnd1" true true false 4 Long 0 0,First,#" # # ExportFeatures DPW_Roads "I:\GIS LOC\Roads\DPW_Roads.gdb\ssRoads" "Owner <> 'State'" NOT_USE_ALIAS "StreetName "Street Name" true true false 100 Text 0 0,First,#,DPW_Roads,StreetName,0,100;FromStreet "From Street" true true false 80 Text 0 0,First,#,DPW_Roads,FromStreet,0,80;ToStreet "To Street" true true false 80 Text 0 0,First,#,DPW_Roads,ToStreet,0,80;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,DPW_Roads,Shape_Length,-1,-1;Length "Length" true true false 8 Double 0 0,First,#,DPW_Roads,Length,-1,-1;Miles "Miles" true true false 8 Double 0 0,First,#,DPW_Roads,Miles,-1,-1;Width "Width" true true false 8 Double 0 0,First,#,DPW_Roads,Width,-1,-1;Area "Area" true true false 8 Double 0 0,First,#,DPW_Roads,Area,-1,-1;SqYards "Square Yards" true true false 8 Double 0 0,First,#,DPW_Roads,SqYards,-1,-1;Owner "Owner" true true false 25 Text 0 0,First,#,DPW_Roads,Owner,0,25;FuncClass "Functional Class" true true false 50 Text 0 0,First,#,DPW_Roads,FuncClass,0,50;Ward "Ward" true true false 50 Text 0 0,First,#,DPW_Roads,Ward,0,50" # 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/3.0.0'><WorkspaceConnectionString>DATABASE=I:\GIS LOC\Roads\DPW_Roads.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>ssRoads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Date</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Date2</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Date3</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Date4</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Date5</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> 20240402 09270500 20240402 09270500 Esri ArcGIS 12.7.0.26828 StreetSweepingRoads streets City of Providence DPW Street Sweeping Streets File Geodatabase Feature Class dataset EPSG 8.2.10(10.3.1) 0 Simple FALSE 0 TRUE FALSE ssRoads Feature Class 0 Shape Shape Geometry 0 0 0 Feature geometry. Esri Coordinates defining the features. OBJECTID OBJECTID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. StreetName Street Name String 100 0 0 FromStreet From Street String 80 0 0 ToStreet To Street String 80 0 0 Length Length Double 8 0 0 Miles Miles Double 8 0 0 Width Width Double 8 0 0 Owner Owner String 25 0 0 FuncClass Functional Class String 50 0 0 Ward Ward String 50 0 0 Area Area Double 8 0 0 SqYards Square Yards Double 8 0 0 Shape_Length Shape_Length Double 8 0 0 Length of feature in internal units. Esri Positive real numbers that are automatically generated. 20240402 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2AabZ rJ5jQiWTs8vzsPxPNWHVXC7lBC8jI6VX2X8v3nggH+yDIf6Y/Wl+wI3+ulmm9mfA/TFYryIWnwor 2t5BbQvC8oHlOVAHPy9untUwu5JP9TayP6F/lB/GmwwRWuqMEjVRLHkEDuP/AK1XXkSNSzsFUdyc ChXFBStZvYq+XfS/eljhX/YXLD8Tx+lVLHT4mSWC4eSYxSEbXY7cHkfL06EVbbUIScQq8x/6ZqSD +PT9aqvHqT3DzW8SQK+MiR/myO+BkdMd+1LS4mo3XUnuoYre3iaKNI0hlDbVAAwfkP6MT+FQvewW lyjySqMxspGfTkH+lNfSJruJ1ub+Ryw24RQqjg/Xvg/hUEWm6eNPkneIqfI3Ak7ipH170Pe5Mrp6 K3/AJVeXVrqOVVMdpCQy71/1jd/ypb2XzrxUToBzWpuIhUuMNtG4e+OaxwWkuGlAwp4qam1jW1kN e23xuqsdzDGewqH7JLGRsn5zk4HsOP0q6kgYFehHapFQAcCsfQm19ymLaZt2LhgDnjJ4pTZS7y3n kck8Zq5SigLIqG1crHmYl0Qjd7nvUL2sqKsjTF2UfN/tcVoGmnHSgdkV9Om82FoWPzRjK57p6fh/ LFW6yYG+z6iCeAG2t/ut/wDX21rkYJFerg6jlDlfQ4q0OV6CUUUV2GIUUUUAFFFFABRRSgEnA60A JUirt+Zhk9hSquDhRuf9BTbg+WoQHMsnGfQVx1q/2YnZRw/2pCREzSMxPyqfzNWiGHI5pkMQjUAd B/Op+1cp1jUkDcdDT6YyBuo/GhA28Iec9DQMmRRyx+6P1phYsST1p8vy4TGAP1plAgqIExttPIPS paayhhj8qAHZzRzUasc47jqKfmgCp/aFuSREWmYdo1Lfyo829l/1dusY7GVv6DmrYwq4AAA7Cq89 /bW6M0kygKMkA5NT6kO6+JlO6gkaSMSXLNcEERpH8uM9Tn0q1Bp1vDGgcedKvWWQ5JNZlnq8e0zt bTySzc5C9F7AZq3Hd393xFaiBSpw8hyQfp/9ehW3M48rfMaI4GFAA9qZJKkYLSSKo9zVKC0vZCTd 3bleyx4Qf4/rVhLK0jYEQqzjoz/O35nJp6mt5PZDRfxMMW6STe6LkfnVNC7XX2WWHy98vm7SQflx uPTt2rYqrtDasJABlICufqelJoicW7XZUMtxIMPkZp0cLYCKufetMRCU42g/WjG3jGMVPJ3NOUqS WyPIF24bqCKQW8nTbjHrTL+QCWCIyBN7csTjCjk1K2oxE4iWSZvRF/qeKHGLZLlG9mV2+ScxEHdt 3fhnFFNnedrqCV4BFGSYyS2WOegx9cU6spKzJTvcQ9Krh9rY/KpJH7CodrSH2HeoKK9xGXld8Y2o WP1HI/lWmrbkVj1Kg/pVS8UiwlCgHcNp/Hj/AAqxArLbxK4wyqAa9DArVnLiCSiiivSOUKKKKACi iigByIXbAqcxbPlHTualijEa+560+uCtWcnZbHoUaKirvcYoSOPjgCqcX7+Zpm+iCp54SyHDkA9q AgVQi8dq5zoJVIxTqAABgUY5piCpP9Wuf426ewqnPeLBIiqokO75kB5xVgsWcs3U0APDkDDDcvpQ ygLuU5Xv7U2lVipyKAG/SkJx2pzIAN8f3e6+lJkYz2oAYwz8y9RRvFDFivy/nQEXHU0AZumwi906 Ge4leUsvzDd8oI4Pp3FTXsECQRxLGqiSVFOB1XIJGfoDUOjv5ZurVgVEcpZc9MHn+easZF7doU/1 MJJLf3mIIwPzNTbQxsuW3UjAVeFAAHQelaKEFFz6VCLVO5JqZVC8AVME1uapFG+QrPbzCVlAkRCM 8csP/wBX41qK0aHONxqjfRGazmRThip2n0PY0xNStmtopmkUeYgYDvyKu9mTdRk7l9pFJyYx+dZc V9AJ7pl3yOZNu2NS5AXgdOlOm1F0hklitpHCKWyw2g4Gas2sXk2kSdwoyaV7ib5pLlI1ub0nMdqq D1mcDP5ZqGAXF9EJZrlkySCkQxg/WrrSog+Z1GPU1jxava29zcxKzSgsJB5Yyeev8h+dD8xSsmuZ mkmn2qMG8oM395zu/nVgYUbQAB6Csxr2/mEbW1oFRs5aQ9PwFEVrfSybru5ITbykXy4OfXr0p+hS aXwon1VlFhIS6qyjchY4+Yciod6yASRnKOAy/Q8ip47O2Q7liUt/fbk/nVKAbI/K/wCeTGPHoAfl /wDHcVlUXUl35tRzLzTC3l5z0pzHmq0soaZI1+Z2OFUdSaxG2luExae7trZccfvpBnoBwB/P8q0D yarWlo9qJDK++aQ5cjp7AVZr2MLS5I37nFWnd2CiiiuoxCiiigAqSAAyjNR0+M4kX61E/hZUPiRe 70UHrSMdq15p6o0tyR6URjPzH8KQjIx3NPHTjpSAXFNkkWKNnbooyaXvVK6YT3Mdup6fMT/npQgJ LcRzhbny1D4I3DuKs0ABVAHQUdqGAYooBpudxwKAHbyp+U80y5nhhjWR8gswXYBnJPpTwoHTrTHV ZFKtyKAF3bx8vT1pywtjhTj6VUgd7e8WHHmK3PPRRUv9owyEnzD1xTsBktZqniCITTTypJER87cE g8dMep4rWee3tlCNJHGBwFz/ACFZeoo90I5zayKsTA7mbHGeeOvetSK0t4hmOJeec9aheRjDdqJF 9vDjEEE0vvt2j9cUYv5e8MA/Fz/TH61cwQM44FFOxpyt7sp/2er/AOvmmlPoW2j/AMdxU8VvBBjy okTjHyqBUneiiw1FIqahvaFIY8eZLIqrnpx8xz+CmgW1zL/rrsqP7sKhf1OaVirakMkBYYiTn1Y8 H8lahtRt8lY2MrDtEC38qWhn7rbbZCdGtjOZH3PnB+clj29fp6UPbQ22oW0iRqocGI8cD+IfqP1q XzryX/V2wjHrK39BzVLVbK8msWkN2Q0X7wLGuOnPBob00FKyXuo1JJobdcySJGvuQKonWLd3KQK8 7YONg4P4niqo023yG+Z2zksxzmnttjIRFCqoxgCodRIq8mOS+u5sgQJAB3dtx/If41GYCXd5J5HZ zlguFUnGOnJ7etSjoKQ8ms5TbE433Izbw4z5ZP1dj/M0+yRVuHnSNFSMFEKqBlu5/pRMWCpHH/rZ W2J7ep/AZP4VYCJEiwx/cQYHv71vhqTnPXZGNWSjsFFFFewcYUUUUAFFFFABUkKF3BHQVHV2IbYR nisa0+SOhtQhzy1JCaRBvY7uFUZNIcnnt2FJG5RiHXKnqa889EcTli2MZ7elHQU5kyuYzuX07im7 lxknFAAo3tj1qKO2S3lcxsSDwAcf571NDlYS56twv0pOtACEZoJ2rQTj/CgKWIyMn0oAaAzNk8Cp AMEZ4BqVUCgkYZx29KiYlmyetADzGSPlIb6VAVIYZ/GpBkcjrUgIk4bhux9aAGKoPXp3qFrGCVt2 GXthcYFWSh24HbqKUN5Q2kc9aaArTxiSF0PRgRTLCYvZRHABUbTx6cVXutQaKBpYrO4lCjJ4C8fi c/pVbTpHltUX7XDEXyxRV+fnnvjt7VF9TF1FzqxtMxRhvb5TwST0qq15AhC79zeijNH2KEnMu+Vv WRv6DAqdFWMYRVQeijFM095lKW9mDxIlqwMjbVMh29s9Kl8m5k/1lyE9okH8zmmH97qqjqsMZb6M eB+mamuJPJt5JO6qcfWkQlu2ylaafbyvNPKhmLSEI0p3/KOO/vmtIAKoCgADsKylvLm2s4VWwlGR 8zORhSeScDJ657VLG4uTiTUVyf8AlnGNh/Xn9KSaJhKMVZLUl1K+Gn2UlxtDlP4c8msePxVE8S+b aS7n3DYBngCttLC2Q5Me8nu5LZ/OnyQQvGUaNdpBHAxxVamvvM5ay12MwRxmKTG4RIcckbc5NOXV RPdxxrBIrOQG3fwgqSP5VpQRxbdyooDOxXA7Z4/TFSvCpYNtGR3xXO3HsRD4UNjII461KqgfWq7x lTkGkE7CKXJyVUkflW2HqU4NuS1M6sZSWjJ7X5nmuvrFH9OrH+Q/A1JSIoS1t0XoIlP4nk/zpa9K jG0bvdnJN9AooorcgKKKKACiilVSxAHWgCSCPe+T0FWuGHtTY0wu3sOp9aep3c9u1edVqc8j0qNP kiLRRS1kagEKtkHb+NSGJJeX2g/3vWmYCjLfgKAGkPt+goAWX720dF4FRZ6hetTygFQw57E1DjAw KAEA96cCVzg4pAeM0fhQAo4PHFP8zP3wG/nSJE79BgepqTZFH947z6CgBojD/cP4GneSE5kbHsKa 07HhQFHtTRIcYb5h709AJTMmflQE+poEy4/1f61nC7KzusyeUpOEyc54qX7TEQCsy4IyOaNQIdRY raMqn5nIUfief0zU7QRPGI2jVlAxgjtWZc2kr3tsi3kxbcZDuCkce2Pepbm51G0UEQx3K/xbMqcf r3xULcyUrt3RZ+xxrzE8kXsjcflUMgv45YhHIkqZ+beuP5VCmtwqmLiGaFwcEFcjPtir0V5bT/6q eNvo3NPQaUHsZlvqDQT3El3ayxl2HIG75eg6VNcalZ3CRxLcJ+8kAZScEDPP6gVoMgdSDyD1rObS 7Oe+CvCGEUXU85LE/wD6/wAaVtBSjJKyZqbg3IIOfSo5IIZRiSNWHuKoy6QN6NbTSQbAANrE9xnr kDgelW1hvEXKTRSgdpF2n8xx+lMpt9UR/wBnon+olkh9lbj8qgu3vrW1lkWWOXCnG5cEnt0q01xN GP31pIo/vIQw/wAf0qndXUVw8ECPyXDtu+XAXkdfcAVLskRJxtpoxsUQiEcY6IoUVI57VG8m08YZ vRPmP6UC11Gc5S38sesn+A/xrCz7DulohTycelVJj5fm57rirx0pkXdd3TAHtu2/ljmqt7p8CWzy RQzu2VCksQDyPU5/Sjkl2JlJpMvONuxR2RR+gptXgtq4zMdj9CqtnH6UeRZnpKwr14TSilZnLKk2 7poo0Vf+yWx6T0v2CM9JhWntoi9hMz6Ks3dsLVFfeXycYUVUSWJxkSY6dQe9NVIvqDozXQcBk4FW oosD371FA8JJ/eLu56nHTrVrICfLg+mK5q9W/uo6aFHl96W4jHJ8tfxp4GBgUxFKjnknqacTjrXM dItOBGemaSP5/u9O5p+9U+5yfWgA2c5fqe3elc4Az07KKbuGzg/MeppRG7rgKfrTAFbflCAMjFRj PTHNWFttpBZwPYUsz+Uw2KAW5yaLdwI1tzjLYUe9Luij+6u4+pp4JEeXOT945/SofMDffUH3HBoA cZywwwyPam7Fb7jfgaNgb7jZ9jTCCDyMUgFKkHBGDSyAAhR260+JyMknKr61SvrmSFo2igLgk7sf Tj9aLATMquMMAR71CI4YMhQAG5x+GP6UsN3DMMqwB9DUvFGqAy4r+1fU5naUKqIqBmGFzyTyeOhF a0LLJ86EMmCdwORWNoaeabq8wf38rcEehx/ICtNrC2Zg3lhHwSWT5T+YpK5lDmtce8Ub/eRTznpW fNo1nJykYRhnBU45xiknsdQgmeW2vGZM8Ryc5/GmreajCQs9mJF/vRH2z3plNr7SCTTJ40T7LdyK UB++cgn6Utob9BNKUjnDyEZB2t8vy9OnbPXvSS65bQxv5ySROqk7ZFxnA6Zq5ZtGtpBFHKkmyNdz A9eOv41JFouSUWM/tFIxieGaE/7SEj8xxVm3uYJo2MUySeysDikyCoPXNJiOMFgACevvQnqaJO+5 L5pU/KaZKyPjKKT3JWo/M+XPc9qFBPJqZS6DY5GKcoAv0ApJLubd5cTZfG5iTwi+ppsrMoCxjMjH CiobiPyoEtEO5riQCVz1bjLfhgY/GkmzOTtohEknK+bHGp3f8tp2wSPUAZwKbiVpBLcOHK8oo6A+ vvVqYjy2A6AYAque30FbUIqc7Myq+5G4h5OaKKK9U4gpckd6SikA7e3941IkQwdyj5uoxSxxYG49 ewqYVxV6y+GJ2UKbXvSIRaW+4MYxkZ/Wmi2cEvHKVBJOD061ZKk4HalI49a5031OsryzvAE3EFFQ tI/b2A96mjlSUkKwJHUdxU0aFzhRx39KaNNtoZo3LYCnOB/EfenuAOskpCxj5R2FTpbEDMjAVYyC uFO30NU5orgHO7cKLATb4I/ujcaje5c8D5RUAY9xilwWPAJpXAVmJGSTVgL5kUe7qP5VHsVOZCB7 d6erHq3BfoPQU0ASMv3Wzzzx2qMxEj5CG+lJLu3EkU0ZFIA5pwkPQ4Ye9L5ueHG7+dKqIzDDYHcG gBzBNgUHaTyQajZGXqOPWiTcXJYYzSK7L0NAELW0TfwgfSqxs5lOFm4+laO5G+8MH1FHlejjH1p3 YGLptpc22nQCK8YEoG2yKCOeenB/Wrn2m9XPmQRyDj5omwfyP+NUNKguZNLtWluHT92vyhQOMetb YSMrxgcetQkZQjoraFJL2FnHn+ZDjs6kD8xkVajmjOfJdZFJ6g5/lTQVPykZ9qhksraRt3lAN/eX g09S/eQmpolwtvbvGp82UZBHUDk/oDUT6VZgMI4hGxXblCR/I0kERGpkGV5Eij4DnO0n/wCtmp7i Ty4JpD2HBpebJSTvKSKOn29wkMsi3ZKbyEEibgFAx2x3zVnzpf4oUkHrG/P5HH86ci+Tp0cfRtoz 9TyahrOTsJRslqTC7hXiQPEf+miEfr0/Wnfa4SdsbiV8fdjO4/p0/GmwMzTIhOQT0PNTT2FtJKX8 sK4PDJwacVzK4Wn0JbaHa7SyY81lxjqEHpVZsS6o7DpBHt46Euf6Bf1o+z3MWfJu2+kg3frVCxa+ eWV1IJ3MZt64UsMABT9BVPsJu1lY0ZMKh9TxVc1NOckEHjHT3qGu3C07JyOfEy15QooorsOYKnii x8zfgKIosfM3X0qU88VxV8R9mJ10aP2pAByTT1HekAyalSNnOFH41xxV9TrQ3knAGTUq24T55CT/ ALIpdywghOW7tUJc53biD61oMfJcEDAG1fakRgy7WOVPQ+lAdXGHGfcUeV3Tke1IBC0kBz1Q9xyK mjuAw+Vgp9D0qEOy9PyNIY4nOeUb1HSgC8pDjlQD6jmopY58YjZee+MVmPdLBc+Q0uGxnIq1HK6n KuTTuABI4XzIxkk9McU1pGMh3Hr0qwLmKT5Zl2n1pWtVcZRgRRbsBDvbbjORTac0UkXVSR603INI AoNLTlQFSScAUAAkYcdR6Gl/dt/sn9KQxkDKncPamUAPMbLzjI9RTaVWK9DTvNXugzQBz2i3yfYN oWeUq7LjGcAEitEXcpPy2c2PU4FR2CR2ou4gMbZjwPcBv61diZpGbAwMDr9RUq5nCMuVamc95epO VSx425JL0pv70H/kHnGeSJPfHpWoI2EjtxznHIoCPhgxGMetVYvkfcw9PvbuSSWT7CcSSEFt/YdO 1LJLqFyohNku0t8x8zGQO3Sr2m8WuP8AaP8AOrmalLQzjBuO5QkkvJFx9iUc/wDPX/61RbLz/n0X /v7/APWrTyM0vFJwT3K5H3M+H7ZHKr/ZFOD083/61Tma+OT9hXr/AM9f/rVZyKcJ0UEM3emopaIO Vrr+RT8y/bhbNFJ/iMvT9Kd5Ys7JIN2ZDku3uTk/zqw93Go+XJNUXcyOWY8mt6VFyeuxjUqKGqd2 IzbjSUUdTXekkrI4m23dihSegqxHGE5PJ/lU8KiOPayg55NBhDHdG2QP4e9cNetJ+7HY7aVBR1e5 HkDJqaG3aT5uik9ajSPeSW4Vepq7E/7otkKDwoNc8Y9zoAQwxjAG4jtmonnfoBtA7CmMrKcnP1pf MyMONwqxgJFf7w/EUGLPKkH+dHlq3KHn0NMYlG+YEGkAhXB6c0oJByDiniTI+YBhRtVvunn0NAB5 gbh1z7jrQY88oc+3emFSpwRg0A9xQBFLbxyHLINw6HHNV/JntmDxOWTnKetaW4eXlxnJ49absVvu N+B4pgUFvUMYM0bJxzkVYXfHhoXwOuM8GnSQhuHTn3qtLFLvV4X+4mxYzwO3/wBegDQivs8Srg+o qUwxTcqQD6is6182feWiKbTjk/eqYblPBKmi/cCR4XjP94eopGYFVUduv1py3LA/vASPUU8hJF3Y DD1XqKAIASDkHFP3hvvr+IpfK3cowb270wgqcEYpAO2J138frS74l42E+9RZ5qRYWddwHFAFW1tE ijmLMzu7iRnbrkAD+QFUjq86yzI9sxRfu7e/NackzGPAAGTg4FMVTvX5T19KaHFWWhQXV2bcfssg C8NntzTG1tkLq1pLkEg4+v8A9atBvvH60UDsY9rdXUUaKbVlQncS3UAmpF1gNEsgt5OTjB69SM1s zj7h7FRUPU4FLRCirKwZyM+1C8fWgnH1qJpMDC9fWlFSm7RInUUVqPd8A881ASTSZzRXoUaKprzP PqVXN+QUUUVuZBU9vHltx6CoVUswA6mr6qEUKO1c9epyxsup0YenzSu+gE4BpEUs3Bxjkn0oIZ2C r1pX+YeUh+QfePqa8+13c7h0jib12jp71JODtTHAxTI1Ay2OFqaObd8r9+hx0qxlcSsnXpTw0cg/ un26VJIij7wx/tL0qAwHJZTke1IB5jI5HI9RSbzjDDcPQ01WZe5B9qlD5jLOA3OBkUAMEcZHynaf Q0hUqcGnkRlNxBHOMA0rgScoRgDoaAGCRgMHkehqgbiS3ZzJG7A5YYOcAdqtq6vnaQcHBpccYPIo Aat1HNhVOCONp68dakVdzACq0lnDIc4Kn/ZOKST7VAySRgNEqbNo+8x45/LNPcC60p3YABX0NIES T7vyn0NV7aX7SHKowKHBzVgfJET3bgfSkA1lZDnH41Ju/drvG4n+VRq7Lxnj0NPLLJjPykflQAmx X+4fwNRlWjbcuVNPZGXnqPUUCRgMHkehoAUSLJ98bG/vCleSWMfMAy+vWkwj9DtPoaAXi+np1Bpg LE0c0gXyxn2qdrhIm2Y6UQ7AhkVcE9qgfZuOcMe596NgM2O8gmjWSOVGQ8ghuPSpo5hIAySAj1Br mkWxDxM0RCpAGUA4AUn0+tWbXUrO1g2xK+wyDaPdv/1VmK50HmHPIWl3f7K1WWQEgg07d8+1qnmf QLk0kplCqcAL6VE0gWonc7iAeKZXZDDOVnNnJPE9Iji5NNoorrjCMFaKOWUnJ3YUUUVoIKKKdGu9 wO3epbSV2NK7sie2jwN579KnJwPekyFX2p0eAvnN0H3RXmznzyuenCChGyA/uUxn94/X2FC4xgUx csxkbv0pfPjhdTIcAmpLJn+VQnfqaYDgg+lBO4k+tOjGMuei/wA6AJN4jAQjIPUHtSGPjfEcj07i oSSTk9TUisYkDD7zfyp3AYcs3uadJ94IOg4qVNkp3KMP6VW3AswBBIOD7GgCWZSMDHyjoai6jFOV 2Xofwp25G+8uD6ikBTNpNlWhlIWNcBT060wXbQhvtS7FXOX7f5+lXrh0tbbczgLnk/yqMIlyoXCu p9Rmn6gKhEh+XkZI/KnyH5sDoOKrXMBZojA5UQn5F7H60ts08jukyqu3GH/vGiwEq5Ukjj6VJ5m4 YcZ96aY2XqKaO9ICTYG+42fY9aJF2BRjnGTTKcJGAwfmHoaAEVmXocU7crfeGD6ijCN0O0+/SkaN l5xx7UAKYjjK4Ye1IjMCFHfjBpoJByKsQtkGRwDt70IAllEbBQoIFRYjPO9h7Yqve3UVrtZiSHJ7 dKejpIoYMMGmwMayQXKbV8szYIZQMcA8UPEu0IYY1KnP3RVC0uEguZS1wQisVw3HzFj/AEAq/FNH dOyI+SuC1YqMnLlj1Mm3FXY9N20BRn3qcFsDJyaKK9GlhoU9d2cU60pbaDsgjpzSFSBntSUV0Wa2 I5k9wopSQeopQhJ45pcyW+gcjfw6jaKcE5waeETOOSaiVemupaoTfQi61ajTYOeppqqFbgU4Ak5J rkr1+dcq2OmlR5NXuPjUyuF6CpnHmfKo+VeBQg8uLPdun0pwUlBgVjFaHQiPPYjB9KqxmK5vXUI4 eEjLhuD7YqW/uktYQHzvbO3ii1h8mH3bk1WwyUnLH+VPf5QE/E/Wqk90IJEwoZsg4PGRVjJJyetI ByruYCh23MT27Uq/LGT3bimYLHA6mgB6fKhfueBWY9s9rMZrdS5c5YE9O/485rTkPIUdBxSRjBLn ov8AOmBXt7hLhTtI3D7y+lWI1ycn7o61UmtRISYvkkPRhRFe8/Z5vlkXgk8BjRYCa4ijuRtlXcM5 xVc2txApe3nwCpCow/z9KuomTk8KOtOLLKcfdI6ehoQGcl64kYTRFFzgd6to6SDKMGHsaWROqsv4 Gqn2QrbPDFKVLtuLY5+lGgF1XZeh/A07KN1G0+o6VThkuPPSGSIYI++DwKtMpU4IxSAUxsORyPUU 2lDFehxTt6t99fxFAEdOV2U8GlMeeUO4frTeR1oAfuVjhlwfValdCsQROe5qOFd0mT0HJpruWkLU wI3RXG11BHoRTI4oYt3X5mLdfWpnlYxt8u5scetZv27yAI51bzABnj2oXkBkzSBHxJbo8an+7nkg k/ypsGpLvjK2yq8xUAnrgkDHvRRSpaS0M5JOOpsUUUV6x5gUUUUAFSwtgkevSiisqmsHcum2pKwp ypJNMEnzDI4oorno04tO6N6tSSasyzwKfGu9wO3eiiuFbnWTf6yT0UfoKPNxwqjA9RmiitSirJ9p luSskKfZiM/MA2fp6frU5OfwoopsCrBM080q7laJT0IzzUszBY9vmCMsdqsRnBPAooo6gMt4DCX3 MCWOflyB+XakuJZ42UxAgAj5iMjnjBooo6gWPr1p7/KoT8T9aKKQBHwS/wDdHH1qEgM4yAWByM0U UAVpJ5bGSU3Ts8Zbdv7DgcY/OrTHIDDoRmiimwJFfI2ycjse4qpHdwzzvFG2SjYPv/nBoooQFnNO EjKMdR6GiikA4BH4Hyse3amOhQ4YUUUdAG5I5HWpPMyMON3v3oooAlJEUIKZy/PNRb1b7y4PqKKK bADGcFlO4UzNFFJgf//Z