20240430 15403900 1.0 FALSE ARCGIS.PUB_EDITOR.DPWRoads 002 Server=COPSQL14M; Service=sde:sqlserver:COPSQL14M; Database=ARCGIS; User=Pub_Editor; Version=sde.DEFAULT ArcSDE Connection 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>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</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,#" # # CopyMultiple "'I:\GIS LOC\Roads\DPW_Roads.gdb\DPWRoads' FeatureClass" "I:\GIS LOC\Roads\DPWRoads.gdb" DPWRoads "DPWRoads FeatureClass DPWRoads #" CopyFeatures DPWRoads "G:\Projects\DPW\ProjectFiles\COPSQL14M as PE .sde\ARCGIS.PUB_EDITOR.DPWRoads" # # # # Rename "G:\Projects\DPW\ProjectFiles\COPSQL14M as PE .sde\ARCGIS.PUB_EDITOR.DPWRoads" "G:\Projects\DPW\ProjectFiles\COPSQL14M as PE .sde\ARCGIS.PUB_EDITOR.DPW_Roads" FeatureClass AddRelate DPW_Roads pavementid History_Roads_Link ARCGIS.PUB_EDITOR.DPW_History_Roads_Link_Table.PAVEMENTID "Road History" "One to many" 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>ENCRYPTED_PASSWORD_UTF8=00022e684846526a31314c4f44564a472f7450615150784b314d685248686c56662b524178506f756c6141663143673d2a00;ENCRYPTED_PASSWORD=00022e6851437954313862726a6462697668376b364f6b70524f6c30466f6d43453931725275796f4c7a6665476e553d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>HisType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><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>ENCRYPTED_PASSWORD_UTF8=00022e684846526a31314c4f44564a472f7450615150784b314d685248686c56662b524178506f756c6141663143673d2a00;ENCRYPTED_PASSWORD=00022e6851437954313862726a6462697668376b364f6b70524f6c30466f6d43453931725275796f4c7a6665476e553d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>HisType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><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>ENCRYPTED_PASSWORD_UTF8=00022e684846526a31314c4f44564a472f7450615150784b314d685248686c56662b524178506f756c6141663143673d2a00;ENCRYPTED_PASSWORD=00022e6851437954313862726a6462697668376b364f6b70524f6c30466f6d43453931725275796f4c7a6665476e553d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>HisType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><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>ENCRYPTED_PASSWORD_UTF8=00022e684846526a31314c4f44564a472f7450615150784b314d685248686c56662b524178506f756c6141663143673d2a00;ENCRYPTED_PASSWORD=00022e6851437954313862726a6462697668376b364f6b70524f6c30466f6d43453931725275796f4c7a6665476e553d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>HisType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><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>ENCRYPTED_PASSWORD_UTF8=00022e684846526a31314c4f44564a472f7450615150784b314d685248686c56662b524178506f756c6141663143673d2a00;ENCRYPTED_PASSWORD=00022e6851437954313862726a6462697668376b364f6b70524f6c30466f6d43453931725275796f4c7a6665476e553d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>HisType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><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>ENCRYPTED_PASSWORD_UTF8=00022e684846526a31314c4f44564a472f7450615150784b314d685248686c56662b524178506f756c6141663143673d2a00;ENCRYPTED_PASSWORD=00022e6851437954313862726a6462697668376b364f6b70524f6c30466f6d43453931725275796f4c7a6665476e553d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>HisType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><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>ENCRYPTED_PASSWORD_UTF8=00022e684846526a31314c4f44564a472f7450615150784b314d685248686c56662b524178506f756c6141663143673d2a00;ENCRYPTED_PASSWORD=00022e6851437954313862726a6462697668376b364f6b70524f6c30466f6d43453931725275796f4c7a6665476e553d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>HisType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><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>ENCRYPTED_PASSWORD_UTF8=00022e684846526a31314c4f44564a472f7450615150784b314d685248686c56662b524178506f756c6141663143673d2a00;ENCRYPTED_PASSWORD=00022e6851437954313862726a6462697668376b364f6b70524f6c30466f6d43453931725275796f4c7a6665476e553d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>HisType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><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>ENCRYPTED_PASSWORD_UTF8=00022e684846526a31314c4f44564a472f7450615150784b314d685248686c56662b524178506f756c6141663143673d2a00;ENCRYPTED_PASSWORD=00022e6851437954313862726a6462697668376b364f6b70524f6c30466f6d43453931725275796f4c7a6665476e553d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>HisType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><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>ENCRYPTED_PASSWORD_UTF8=00022e684846526a31314c4f44564a472f7450615150784b314d685248686c56662b524178506f756c6141663143673d2a00;ENCRYPTED_PASSWORD=00022e6851437954313862726a6462697668376b364f6b70524f6c30466f6d43453931725275796f4c7a6665476e553d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>MaintDate</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>MaintYear</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>MaintType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> RemoveRelate DPW_Roads # Append Hosted\DPW_Roads\DPW_Roads DPW_Roads "Use the field map to reconcile field differences" "pavementid "Pavement ID" true true false 4 Long 0 10,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,pavementid,-1,-1;StreetName "Street Name" true true false 100 Text 0 0,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,streetname,0,100;FromStreet "From Street" true true false 80 Text 0 0,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,fromstreet,0,80;ToStreet "To Street" true true false 80 Text 0 0,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,tostreet,0,80;Length "Length" true true false 8 Double 8 38,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,length,-1,-1;Miles "Miles" true true false 8 Double 8 38,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,miles,-1,-1;Width "Width" true true false 8 Double 8 38,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,width,-1,-1;Owner "Owner" true true false 25 Text 0 0,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,owner,0,25;FuncClass "Functional Class" true true false 50 Text 0 0,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,funcclass,0,50;Ward "Ward" true true false 50 Text 0 0,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,ward,0,50;pavementty "Pavement Type" true true false 100 Text 0 0,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,pavementty,0,100;SqYards "Square Yards" true true false 8 Double 8 38,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,sqyards,-1,-1;BenValue "Benefit Value" true true false 8 Double 8 38,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,benvalue,-1,-1;PCI_2020 "PCI 2020" true true false 4 Long 0 10,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,pci_2020,-1,-1;HisDate "History Date" true true false 8 Date 0 0,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,hisdate,-1,-1;HisYear "History Year" true true false 4 Long 0 10,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,hisyear,-1,-1;Segment_id "Segment_id" true true false 4 Long 0 10,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,segment_id,-1,-1;xCoordinate "xCoordinate" true true false 4 Long 0 10,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,xcoordinate,-1,-1;yCoordinate "yCoordinate" true true false 4 Long 0 10,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,ycoordinate,-1,-1;xEnd1 "xEnd1" true true false 4 Long 0 10,First,#,https://webgis.providenceri.gov/server/rest/services/Hosted/DPW_Roads/FeatureServer\15,xend1,-1,-1;HisType "HisType" true true false 255 Text 0 0,First,#;MaintDate "MaintDate" true true false 8 Date 0 0,First,#;MaintYear "MaintYear" true true false 4 Long 0 10,First,#;MaintType "MaintType" true true false 255 Text 0 0,First,#" # # CalculateField "DPW_Roads (sde)" HisYear 2024 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (sde)" HisDate 6/1/2024 "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (sde)" HisType "Mill & Pave" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (sde)" HisType "Mill & Pave" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW Roads" HisDate "6/1/24" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW Roads" HisDate "6/1/24" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW Roads" HisYear "6/1/24" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW Roads" HisYear "2024" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW Roads" HisType "Mill & Overlay" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW Roads" HisDate "8/1/2024" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads HisYear 2024 Arcade "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 HisDate 11/1/24 Arcade "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 HisType "Mill & Overlay" Arcade "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 HisType "Mill & Overlay" Arcade "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 Length $feature['Shape.STLength()'] Arcade "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 Length Round($feature['Shape.STLength()'],0) Arcade "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 Length Round($feature['Shape.STLength()'],0) Arcade "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 Miles Round(($feature.Length*5280),3) Arcade "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 Miles Round(($feature.Length/5280),3) Arcade "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 Miles Round(($feature.Length/5280),4) Arcade "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 Miles Round(($feature.Length/5280),3) Arcade "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 Miles Round(($feature.Length/5280),3) Arcade "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 SqYards Round(($feature.Length*$feature.Width/9),0) Arcade "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 SqYards Round(($feature.Length*$feature.Width),0) Arcade "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 SqYards Round(($feature.Length*$feature.Width/9),0) Arcade "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 SqYards Round(($feature.Length*$feature.Width/9),0) Arcade "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 SqYards Round(($feature.Length*$feature.Width/9),0) Arcade "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 MaintType "" Arcade "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 (By Ward)" Ward None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "01" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "02" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "03" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "04" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "05" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "06" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "07" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "08" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "09" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "10" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "11" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "12" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "13" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "14" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "15" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "01" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "01" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "02" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "04" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "12" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "14" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "14" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "05, 14" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "05, 14" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "05" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "12" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "06" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "06, 15" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "07" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "15" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "07, 15" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "15" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "13" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "11" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "08" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "08" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "09" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward "10" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (By Ward)" Ward None "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads Length !Shape.STLength()! "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 Length $feature['Shape.STLength()'] Arcade "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 Length Round($feature['Shape.STLength()'],0) Arcade "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 Length Round($feature['Shape.STLength()'],0) Arcade "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 Length Round($feature['Shape.STLength()'],0) Arcade "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 Miles Round(($feature.Length/5280),3) Arcade "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 SqYards Round(($feature.Length*$feature.Width/9),0) Arcade "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.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6871637654795a6d4754572f2b69444378414c544853734b6a41517953436f44476f704b48712f494c6154593d2a00;ENCRYPTED_PASSWORD=00022e68746155537a523252702b63526f7535526e347456335441433147785444456a307a6d5a76736c7778666f773d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Length_Feet</field_name><field_type>LONG</field_type><field_precision>10</field_precision><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.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6871637654795a6d4754572f2b69444378414c544853734b6a41517953436f44476f704b48712f494c6154593d2a00;ENCRYPTED_PASSWORD=00022e68746155537a523252702b63526f7535526e347456335441433147785444456a307a6d5a76736c7778666f773d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Length_Feet</field_name><field_type>LONG</field_type><field_precision>10</field_precision><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateGeometryAttributes DPW_Roads "Length LENGTH_GEODESIC" "US Survey Feet" # PROJCS["NAD_1983_2011_StatePlane_Rhode_Island_FIPS_3800_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",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 Length round(!Length!) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateGeometryAttributes DPW_Roads "Miles LENGTH_GEODESIC" "US Survey Miles" # PROJCS["NAD_1983_2011_StatePlane_Rhode_Island_FIPS_3800_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",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 Miles round(!Miles!, 3) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateGeometryAttributes DPW_Roads "Length LENGTH_GEODESIC" "US Survey Feet" # PROJCS["NAD_1983_2011_StatePlane_Rhode_Island_FIPS_3800_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",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 Length round(!Length!) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateGeometryAttributes DPW_Roads "Miles LENGTH_GEODESIC" "US Survey Miles" # PROJCS["NAD_1983_2011_StatePlane_Rhode_Island_FIPS_3800_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",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 Miles round(!Miles!, 3) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateGeometryAttributes DPW_Roads "SqYards LENGTH_GEODESIC" "US Survey Yards" # PROJCS["NAD_1983_2011_StatePlane_Rhode_Island_FIPS_3800_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",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 SqYards "(!Length! * !Width!) / 9 if !Width! > 0 else !SqYards!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads SqYards "(!Length! * !Width!) / 9 if !Width! > 0 else None" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads SqYards "(!Length! * !Width!) / 9 if !Width! > 0 else None" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads SqYards round(!SqYards!) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads SqYards round(!SqYards!, 3) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DPW_Roads SqYards round(!SqYards!, 3) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateGeometryAttributes DPW_Roads "Length LENGTH_GEODESIC" "US Survey Feet" # PROJCS["NAD_1983_2011_StatePlane_Rhode_Island_FIPS_3800_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",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 Length round(!Length!) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateGeometryAttributes DPW_Roads "Miles LENGTH_GEODESIC" "US Survey Miles" # PROJCS["NAD_1983_2011_StatePlane_Rhode_Island_FIPS_3800_Ft_US",GEOGCS["GCS_NAD_1983_2011",DATUM["D_NAD_1983_2011",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 Miles round(!Miles!, 3) "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (SDE)" StreetName replace_suffix(!StreetName!) "Python 3" "def replace_suffix(street_name): replacements = { "STREET": "ST", "AVENUE": "AVE", "BOULEVARD": "BLVD", "ROAD": "RD", "DRIVE": "DR", "COURT": "CT", "LANE": "LN", "TERRACE": "TER", "PLACE": "PL", "HIGHWAY": "HWY" } for full, abbr in replacements.items(): if street_name.upper().endswith(full): return street_name.upper().replace(full, abbr) return street_name" Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (SDE)" FromStreet replace_suffix(!StreetName!) "Python 3" "def replace_suffix(street_name): replacements = { "STREET": "ST", "AVENUE": "AVE", "BOULEVARD": "BLVD", "ROAD": "RD", "DRIVE": "DR", "COURT": "CT", "LANE": "LN", "TERRACE": "TER", "PLACE": "PL", "HIGHWAY": "HWY" } for full, abbr in replacements.items(): if street_name.upper().endswith(full): return street_name.upper().replace(full, abbr) return street_name" Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (SDE)" FromStreet replace_street_type(!FromStreet!) "Python 3" "def replace_street_type(street_name): replacements = { "STREET": "ST", "AVENUE": "AVE", "ROAD": "RD", "BOULEVARD": "BLVD", "DRIVE": "DR", "LANE": "LN", "COURT": "CT", "PLACE": "PL", "TERRACE": "TER" } if street_name: street_name = street_name.upper() for full, abbr in replacements.items(): street_name = street_name.replace(full, abbr) return street_name" Text NO_ENFORCE_DOMAINS CalculateField "DPW_Roads (SDE)" ToStreet replace_street_type(!ToStreet!) "Python 3" "def replace_street_type(street_name): replacements = { "STREET": "ST", "AVENUE": "AVE", "ROAD": "RD", "BOULEVARD": "BLVD", "DRIVE": "DR", "LANE": "LN", "COURT": "CT", "PLACE": "PL", "TERRACE": "TER" } if street_name: street_name = street_name.upper() for full, abbr in replacements.items(): street_name = street_name.replace(full, abbr) return street_name" 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.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682f65696d75336c42555a5557396a2f456a42354a6178376e642b4e724a5678395456415256456373735a493d2a00;ENCRYPTED_PASSWORD=00022e684850685161707755703055536f33326667365a57734c56464c384155496b63396b643554766455726a62453d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></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.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682f65696d75336c42555a5557396a2f456a42354a6178376e642b4e724a5678395456415256456373735a493d2a00;ENCRYPTED_PASSWORD=00022e6845643071766e44626a386c44634b5756426664436b564977596f2b782f44525362747151457365792b75733d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></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.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682f65696d75336c42555a5557396a2f456a42354a6178376e642b4e724a5678395456415256456373735a493d2a00;ENCRYPTED_PASSWORD=00022e6878384c4e68643431776d56704d38542b427a74786d5132616841444b315635384e6947486f3048616a72593d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></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.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6871637654795a6d4754572f2b69444378414c544853734b6a41517953436f44476f704b48712f494c6154593d2a00;ENCRYPTED_PASSWORD=00022e684f5558506a5377343249654f774b46306a635559564c4854614734444d43472f524670764a334a493861413d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></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.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6871637654795a6d4754572f2b69444378414c544853734b6a41517953436f44476f704b48712f494c6154593d2a00;ENCRYPTED_PASSWORD=00022e6858505a3143334a544f6d2b3736354642753976506833796a6837334d3046716a6c4f712f63466a723932633d2a00;SERVER=COPSQL14M;INSTANCE=sde:sqlserver:COPSQL14M;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=COPSQL14M;DATABASE=ARCGIS;USER=Pub_Editor;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARCGIS.PUB_EDITOR.DPW_Roads</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></workflow></operationSequence> 20240502 14490700 20240502 14490700 Esri ArcGIS 12.7.0.26828 DPW Moratorium Roads dpw roads moratorium DPW Moratorium Roads (work done in the last 5 years) Enterprise Geodatabase Feature Class dataset EPSG 8.2.10(10.3.1) 0 Simple FALSE 0 TRUE FALSE ARCGIS.PUB_EDITOR.DPWRoads Feature Class 0 Shape Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. pavementid Pavement ID Integer 4 10 0 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 38 8 Miles Miles Double 8 38 8 Width Width Double 8 38 8 Owner Owner String 25 0 0 FuncClass Functional Class String 50 0 0 Ward Ward String 50 0 0 ARCGIS.PUB_EDITOR.DPWRoads.Area ARCGIS.PUB_EDITOR.DPWRoads.Area Double 8 38 8 pavementty Pavement Type String 100 0 0 Area Area Double 8 0 0 SqYards Square Yards Double 8 38 8 BenValue Benefit Value Double 8 38 8 PCI_2020 PCI 2020 Integer 4 10 0 Segment_id Segment_id Integer 4 10 0 xCoordinate xCoordinate Integer 4 10 0 yCoordinate yCoordinate Integer 4 10 0 xEnd1 xEnd1 Integer 4 10 0 HisDate History Date Date 8 0 0 Shape.STLength() Shape.STLength() Double 0 0 0 HisYear History Year Integer 4 10 0 20240502 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2/ccd unpS5J6cfT86apzjPX3pdx/kazGObvx19ag24kIU7T1APQipjyvTPb9aYFy4PYUwGK24gNwenPeu Y1INqetSxbv3LyR2Sr/sj97N+DAIn4GujvryCztZp7lgkESF3PoAM1j6clvJqSS24uCIkkbZLCyf M5BZssOvGMe5q6btdkS10Ny5LLEzK5XaMYA61T03Tkivbm+mklmlmOE8xifKTA+VR0HIJ/8A1UWm rQakJI4I5fkVJGLAdGzjv/smtBGDqCOo61DUk7FaPUHhLcpj1yaC2zqDgdcdjUgDBjjj3pXZVRmC lmAJCqOp9OaSilsMjYo3ytk8YOD0rIjvbyLWjaNEWgMeY5B0BBIKn0PQj8ar3s+vWemT3839nxtH C0pj8ppOQC23duH06Vcga48sG5lhd3UFmijKqB9CT/OtLWRN7k91dys4jt1JzweOn+f61MF8m1cj uMZphQxNxgrjBI6kVLPtaCNR0JAxUjE+yRNJBMSfMgUhecfeHNT8cY9ajdwNzHhR1J4Aql/bmlJM Iv7RtWkJA2JIGIP4dKLN7Boi66NIBtbYc9RVS70+4uAvl6td2wA5EKxfN9dyE/lVn7VAEJ3/ACqM nBqi2vWDE7DO/YbbeQ/+y0RT6IHbqcneJe2HiK6jS51i5MghiEsZtPvYYhSXUEfgKi1m0vm092uP tkckWJY3u9TWIblOcARdScY7detWr82NxqF9e30GrrCZIzEYfNiAwAA3BHOSRk1S0i0UlS9m9zqF uzRshhw2cYDSyuT1B3YB78CupPRPsY+RVuHtJLm2dbiS4mureWOFLe8uJ3DlNy8k8fdPp6npTtPS A3F9aSxBI94cQ3dzLdMpcZYbEZl+9uPUnmobq7ll0qK0nuoGNhk/ZrVGcBonCkORyQ0e7+7nNa0V pqFxrKxW8EixTWuVAkaxjwjDoI9zn744OK0eiJ6mLFNMdJs4YobpZ7bDFobWKAfupBGzFnJYnPXA 79K9PsI5ksIEuARIBtbM3mH8WIGfyrlIvDV4I3t2REUvcRbldiBFNGGJBYknEir7967C3En2OLz8 ecFG/YeN2Oce3Nc9aaexpBNbkckB370xuxgjI5qn5hfchG3Y20j3wP8AGtMkBs/jwKzdmGmYMpBk LcHP+elZ0Xaoia/wMSiiivSPPHB2AwGP51LHG0oO4nHaoKvxkMoIGABXPXlyLRHRQjzvVld7cqBg kmnQTlD5b8qT+VWW+7n3rPkBEhBrOlJ1G4yNasVStKBpAbe+R2psj7Bk89gKbE2LVGY46jNMDb23 EfKo6VzT912OhSukxQwQYJyzcsfSpEbEig/garMSck9alhII55IFQpagmWN3XkcegqEMFZgTjnPI qTOR15qpcIxk4z0q0ih9rPLKJDNaPb7WIAd1O4eo2k1Zz7UmVZmQZyO+OuRTYm3Q7icnnj6f/qoE SE5UfWmu2E+Zto9zVS1u2vrOK4gCpHKocF+SB16Vz1/rUKa1bvYvLeGJXNyFGY2jXG7aehdSRwuT jIPbFxi2xNpI29dsWv8Aw/qNkmPMltnjU55BZSP61X0/S9PZbW5KzpIyq4R7mUlSRnBBb9DVwanY 3EIeK5idJUBDq2cg9D+tUo5k3hFcFh0wevuKidSUVZCt1INOtpdF1O2jmKMl5CIPlPKvGZH/AFU/ +O10BUE7h8rDuvXrWbqMMuoWVvNbY8+3uY5cE44BAcfihYD61p7iWwFOPpVSlzWkNK2g0O6n5huH XK/1FPVg4JXG3PrVT7BaxkfuFGBjkk8VJFbRRR5hXy885FSUTuoeN43IKspBUjIP51n6LYQ2Fv5M agwRjYgboKsyyPHEdwHswqOBx5S5ZfbtTu0hFmOVd8kZhUFTgc547Vmz24u1WB3kULICPLlZGPXo R2q+QPPjkUggjacfmP61latc3Frpl9d2jqJLdfNG4ZBUHLDH0Bpxu3oD2Kuq+F7S4e1CW/mFpf3s tx+/ZVweR5m7HOKm0WEJ4bs44wP3YKnAx0JGcfhT0j8RSyOBqOmomAQRZO4P0Pmin+HS6aWYJXVp oJpI5CvyjIcnpzjIIPXvVTvKFm7kpK5ZglCDBJBzwfSoX0ucud+rXx57FF/ktaIiiBPyLnNJe3Fv aRNcXE0cMS/ed2CgfnWdNyirFepQ/s2A2k9rPJLPDOhSTz5C3BGCPauLj0QNPbRF1JkdrS7F0HmV 5VGUcqXALMnrntxXVPf3mpJt023aGNv+Xq5QqAPVUOGPtnA+tPh0Cwhk+0NF513kObmb5nLDofQf hit4txvdkuKlsZuiaDbvYv58twrXGWmgjfyY9wAQ4VMcYQDFdGrMtrBtyFUhWHoOn86cjb2jdQOh 3dsf5xUckKzRXEDKSrgnvzn3GKylJyeo0rDb3VtN00f6be29uWPyrJINzfQdT+FFpqqX0wihtbsR kf62SExr/wCPYP6VHFaadpC+ZHb21ruGZJGwrfi3f8adaa3Y3lx5Nm8lxkHMsUTNEP8AgYG39aLK 2iC/crXrSSzuY3YIOMAnnFVlEqL95gMcg5Ga3/LjjHCAD3rOuYHefCoShOeBxXNKMk7omUb7iBdo AzkAdfWilcgsSOnanRANIoPTNe0naN2eda8rIQKTyBnnAq8gJwuKQou4cdKeeBj868+pUc3dno06 agrIRmOc9vSo3VXOAm5qk+9weCehpyqFG3vUJtbFtJ7kQjBj2dCvIz29abINq+WDz1JHrVlcBg55 A4+tMeJW5AyD3/xqZK+ordjLeCcEbJncdwzAf0qxHGYzku7Z7E1ZaDjI/wD11FtYDJBxUNNC1JYy GPv9amyO4B+tVUbYc1LvlPRVH1q4u6KTGqCt05yRuUcZ9M1LGmwEEk5OemMZo8td5YD5gMdDjFKW 2ozMTgDPSqGY+hOiaRcQSj5baeaJwRn5Q7Y/8d2/nVLxBcWd1pcUOlzH7cAJLNbMAspx15GFUgkZ PHNTLbNJqN7aJcS2pvNt2zRkZI2hGUcfLwqcjnk9KuWukrp0P2bTvJtoiMbRHkk+uf6mtLpPmIs2 rGT4YsbXT7JrOe3EF9AVFyqysQ5xkOMnkH+eRW+lnHuEmGU4wu5if0pi6VGtzbXrttuoUKMV6Op6 g+vOCP8A65qy9yqYyGLfTNEnzO4Ky0JECLlVAUP1I9aRlKNzUQlZyNsTBT1J7VYkQSQjcxIxggd6 iw79gycDnNDDKn1+tV1hKgmOWRfTPzD9aehkQkSYk9CvBz7ii19gv3C4QFolP3S3PvQ2M8AbR0qF nzdoCeFBJ/Kp0fcH3AEAccUmUtdSMgOBlBkkAcfnWLcJ9m8SWbOAYLpJLOVSeC330z/3y4/4FWlc rey3sC26rHEDulmbBwM/dVfU+p6e5rO8V28n9l3FxEZBLbFbpBGcN8pywBwcHGexq4LVeZMti1oB WLS4bdzultybUsep2EqCfqAD+NQwB7TxJqEKY23caXKccbwNj/oI6xbC51PSrm9hENrIskX9oRNJ dPKzgABgG2jnIU+nzitCPWrHU9X0mS3lJmJaN43UocPEzjggZGU61bhK7fRkprQ3t8xJyydiMVLI sMmDKqOFww3YO09Mj0PWq76XauBugX35PrSzC0sYzcNGqbyEJAzks2B+uKy9DRkhXnjn3HehlI6j FHmuylVhYbeAWwBVXWrp7PQ7+5g/10VtJIhboGVSRx9aabbsF9C6nbgZHBNPCnBH8+BTI2LQo4G3 coPAx+tE6GR/9cyj0XqfxqWBVOi6f5zXD2kTzMdxZhvOfbOcVcK7ImCAbugDHA4pqw7CMSsevDn+ tPZmUAbSQB9aG29xWMu6lvxGB5cSH1Vzz+n+c02FiYN5++x2nnp61pBFlId4hhemc/yrPkCM5IBA zkDcauhBupcxru0dxKs20fO8/hUcMBk5LMF9atCaJDtf7wHReuK3rVdORGVCjrzskVM4zSAEt0z7 UjOZATGCEB5LDqPpTw+5QSetch2C/KD83X0oJ98fXpRxtx2qN0Zo2CnGfftTASKVpEDn5VPKjHan 7TggZXPHFKABgAY9hSg44/pQBHG7Btj/AHuxH8VJNlhgfiKbMcMCOKYJ5ApOc8d+ahvoJvoCAbsn O0dPrU+4dwT9KYBhAPQUq5C1QDkOS24D86jnk3I8UaBmZSOD0zUgwcnLdP7oNCoMEjuepWgZi+Id MnvEs5rbabiCT7ju6pIhHKsV5xkK2O5UDvV/T7SaBnNxePcXEoGcfLGmOwUdB78mrki4jUbgO54o iQIwwR1yea05ny2ZNlcTGepyR0pV+9z6VWvdSs9NiZ7mZEVfvMxwB9fb3qtFqdvqWGs9Ss24/wCW Uyt/Kps3qPRGg0iRnDbiSPSkSfghgAvUHdznjt+dUNTvbLSbdbm/nCwl1QyMeFJOBk9BU8MsN5Yt LprW87SLuhcn5G5/vAH9KOXS4XJzcxjqf61G94B9xTn1PFRefPBFaLd20Kzzy+URCd6rwxzkgdl9 KkviY4iFVWYdgOaLWArq/wC9LsevXNWFYKj7S2AMkgjgc0y1g3xh5ep6ACkaZYLlgdOmkVBlZFXO eCePy/M07hoySETkYUnGerVHfW0k0Wx5nVTwXhfa2PTPb8KrXGpTHJWyvGQttKCIg9zn9P1ok1Fm s3iFnfIWiyCkQ3DI7ZyM89/SkpO+wkuhzB0fQbOyuNOuY7O0ktZQUmaNCzxN93lh83de/wB2m5tL KbTZbYaaAl7CubTTWiLB28v7+cD79bWo2v2P7PqEaNcz2BJJYBneM/fA98c49QK2ntbbU9OjDN5l u7JKjKf7rB1x+IFdHter2IUSea5SKMu6jAHHOMmsjWtQjm0a4xhWjAkGSDnawPHJ9K2HClTlVPPc Uw28E0RSSBHU8FdgIIPask7O5q1dEN8t1LEGtILaaUHpPIUAHsVU89O1ZYj1qUyRvY6Ts+4ymR2B BHIPyc8V0fIDdfxNRqgEm7P3iO9Lmt0E1cAAEUYUY4wOgpd6scjtgH5a5zVf7Sj1uOW0e4ET2+xz BGjnIbI+8cDqfWrWlzXCwyNMJ3bzOTO0Zbp6IMCpatHmuK+tjZxzxn+VRy7JMrlh82eDUJuEzyaj kmLk44zThTdTYU6kILUtPcokWFYs2Mc81WhgMvPbPT1qJVLsFHU1pIoRQo9PyFbztRjaO7OeF60r y2Q4IqKAOWx07CmserHt607IZcMPofSmyKWG0MVP94d65jrEjdX+eNufY80/5WJ3L+K/4VVZGTJd MseA6dcVYGVQBifx70AOKgcggj2PNO4Xg9T1pF67j0FN/izgc0AISAcHj69KGwqk80446Y/So2AU ZVsdsUgIXYMAADTBywXsasfIfvDHvUSp8xfHygkA7uvPp2qVHW7JtqSMflpw6VGMAnninH2GfpVD M9NFk4MuqalJ0zmVU/8AQVFSoHlhUIOFJq1GLobhIItuDjYTnp70togW0hHfH605e8tRW6FB7XUE ucx6mDFuG6GW3DYHopUqfxOakt9Vt7qS5gt28ySBxHIw+6GxkjPqMjNVPGGoTad4eu5bWWKK7dSk RkfB54JX1PPA9awfCF5aaPo+mWUtleW81wRtMkZZZZH+Zm3DIA68HBxjitlC9PmJvaVjtordEIdw C/qa5RPAtjHq8V1JEkkER+SEjKhQkaKDu9AhPvkeldY5fAClQfelRWBJZy2724FZxnKOzKcU9zz7 WNHh0/UZpbfSFK5F7HEHCq2wbZFGOnykMP8AaBrZi0uf+y7hhG8M7Qs8H2a7cKDj5Ry3PPfge1dL MsDlBMIywJVd2M8jHFcvYeGrktd2lxIYrZHMXmqxeWeI4ZVDHhFAwpxzlSeOtaqo5LV7EuNnoNto 54fE0umy+ILxRLCrwBJEdlcffViwbk8EA9cN6VpPpt5b6hFPNq1xdL5bL5csaDrg5+UDngdqwr2w vprltLt54rK2juisb28OJFfZvjdmJPBwVJ4JPfmtDSLe4Km6ls1tjzFIJJXllZgcEl2/hyOOvBHS qlte4o7mtql/JpFoLn7G89vGm+VkdQVHoATlj7f1xSR65/aDwRaUEmZ1WSV3PywqezY/ixn5fxNW /tHmJtQZb+InotY0vhlY22aXdSWME7h7hYycswOdwOeGPQ5zke4rKPJ13KafQk1V5NVuvI0+4kh+ yMTPdRvgKMcxjsWI/wC+eD1q0mqRW8CR7YVjjQLlrkZwOOSf61JHNDp0S2kVqIo14VdyjPvgnPNU L1LnVppLeC1jSC3w7GbpNJ1Vcj+EcE/gPWj4tOg9tS5CkItibaKKNVdmcRuGyW53Ejufesy2tvsG tRRSXdwthM2bWFXCpHKPmKHAyQeoBOOCMV0Vujx2EcU0glkA2ySbQu8464HSsvULKK8tprOYHY4w CDgqeoYHsQcEH1FVB3ujOXutPuT3mu6fZzGCSaV5RyyQQPMV+oQHH41AviC2cEJaarJzwTYypn8X UCjw9LEts1g0CQ3ducSoowG9JB6huufXI7VqTNiIqQxzxhetS+WLtY0V2Zh1C/llJi0u7VW5Adol /wDZz/Knrc6rGu+WytooVyzNLcEkL36LV6IKrKVhcEH7xwPx/SrDsq9SFqebyHZ9zm7vVNF1EASW N3fbPu4sJWX8yu39asWJhitpBa6TLp8e7dkoiBvwU5/MVrebHlhu+mBUUkhZdozg8/MKUrNcqFbq UwSTubkn1pwxkZ6UlSxwvKDtHTua9BKMIW6Hm+9OV+o+PhcAfMxwpFWpJNkPPXoD3NRJC8TEuOg2 qPX1NSeXuZGbPy84rz5PU9KKshwBAAJyQOvrTZJDHHhcEscDNOJC9SAf60hRXZHBPHTBqShx7kHj 2oOce/p60122IWHUVBEXhcefIrKT1BPA49/rTAtdFA6E80Ac4/PFRtKjOSoZsnjAppeTAAUfMcAE 0ASk8E/ypuwN1+tDJIwOZOh7CkWNB9/c3uSaAEkAHCnBPHtTCY16MMfWnFIxP90fdGOPc1KMAcYA FAblcbiSwUn3PFTqZQoA8sfUE0jMC2B6c07BbkUAKRtA9PemxHJI2gANnFPZHUfMUAHAwDmiOMDc c8nj1NPYnc5zxbaw6gunWJUtJNc7gvYIqncze2OB/tFfStq0g2oI5IU8tcEYUDBHGcdPeoJLaOTV orv5vMEZjAJ4C5z+uB+VXclsZJPanJ+6l2BLW5nTaxpy3TW7XKi5hkCmLqxJHYenPWtGRC+MOyj2 71nWn7jXdUDIdpWG4zj1BX/2SrM2o21tH5k0ixLj78nyj9cUNa2Q0+5W1C1spYPsMvyyzqxjc5yG XBznsQcEfSnaVcX1xaot1EsdxGTHK/RXx/EvsRg+2cdqs21zHeQxzxFZIG5WRWDAj1GODVoOgPO4 fh1ovpYLdSpNYQXNrPBLyZ12OyjDEduR3GeKdBayDTo7e6mM0wTDyAbdx9cdqtEr945wD0zUcj88 cDrSvpYLFCSMwHZjK54PrV6IDb8pBB6DNRsGuUKKM99xqoge1mxhB6bVxmi19QJ3sVdyzSTHPo/T 2qeKIQx7Q7uMn7xzSJIH+7170S3EMHl+Y4TzHCJ7k9BRuxjnz5LADGMGqUsZC78HFaCsQRgDj8qo kvLkk/KTkfN249qqE+V3IqQU42Io1HmB/LBkAwGA+YD6+lWo2kkIDPsyPzqtHIYpAfTgip3dBwo3 hvmC+hq6sOV37mdGopK3YlkEaffnY/Q1Td/nYxSsBjGCoOOPU+/NEsW1Ms+HY9B2FRBQKUaUpK6H OtGDsySFbjzhI0wIxgZAAp1xFc+eh80FTx9KiHFKGZTlSQfbiiVKcFe1/QUcRCQNxkc5q3bLcCM7 AuM5Abqagt4vMk5PA5NaakNgIaqrK1ok0Fe8io88jf8ALIhwDk9acipIgLOWPscCrbOFG0DI7n1q BoVZ9yHa3qOD/wDXrE6CKa1jZPmLADqVYgilSCNQAAWAGPvHNOJdQVkQOp7gf0qMIOsD/wDATSAk 8iJlPBPsWNRzouFjVQCxxjvU+4tz1H61UJ8zU1B5WKLPPYscfyH60DJxEFPyEr9DxTkRt4csMqPl Ap/GP8f8aD1PqO38qAFPX5uDTc+vSlBIG3+dL8pPHB7UAQvkypgc9KeyMF9yajIJlPovGfepCxxk Hp2oAj+6z59KcOlNOcE9TSKflGf50gJGnDjlgG6ENwaeXGCQQahVB5aJKTLIqgF2HLH14ps0EYhZ lBU46g0xCwndM8nUABRmrGST8rY+grjbi+1dItXaylg8mF0iUuzAq5Azt6/3hW015rUbFGttPz1B Nww/9lrRwYlI1JZY4fmdtqlgoLHAyTgD8yKp+RFNeKLqGKZkzsZ0B2/TPSqciaxfxlHXTQmVOG3v yCCP7vcA1dgt7pcSXk8DyA5zDGUGPTBZv51lKLVmnqG4adaSWL3kTFTbNOZYAv8ACrAFgf8Age4/ Qj0q8VP1A/WlAxikJJIOabd9xpDHcLGZJWVEQZYk4Cgdeao2F8mposixlIGOUDHDOvZtvUA9efan avYm/wBPMKzLHhlfaw3K2Dnaw7qaNJuXu7ETSoEmLujovRWVipwfwqkly3DrY0hlV4I/wqCWNLmE 8EY45GMUkpLnyUOCeXb0FSqoEZCjAC4A/GpAzWimhct0x3UcUTmK8tjDcR7gSDkHGCDkEehyK1OO 3ftVeQRtn93tPqDiqVwASK+drDOOMnFRD5YlJIAx602W22ASDLDHIzjH5VGFyQMjkZOBSaAaxBYm pIZhGGGOveopeHUDpikroo8tWLT6HJVlKnO8RzMWO49TTaUdDSV1pW0ORu+ooyTgdTxVpLVMZbdn 61XjUvIAKvN0464rkxDalozrw0VJO6BVCqSvyRjuByafHIXjBC7M8YP+NQxnzjIj/dUjA6VOqhEC rwFGABXMdYdOv5UuAe+KhAmjOARIvX0IokmZQD5TFcDOOSKBkpJ6OMiqiLLNM3mxKq4G1t3JNTxt uXr15II9akwCc9KAKctvMjiTzzgEYUtj8D60lvIkbyu4bfIck59sUk9teToY3Ns8W4kblPA7d+uK q2tjfWsTJGbMAnJG1sdPrTEau5WxtINNaINyGKue471EYCGDBeD/AHWpkQlVsh1zz8r9eTSsMsKZ FwrDcCcbl/Tj86kY7AS3AAzUDTurKrxgZ4Bzx6U37UssYTDDdjOewosBNGxRACO2T70SSrEwBQ7D /F2zSkKVzuzQx3LzRcBnVaVYlZc8fjTUiKkBeUPqen/1qlbAOORikBk3esWyXKQwztNIDgxWymQg 5746fjWhPITZl8e2B+VOhS2tx5ECxR7Vz5cYAwPoKbMCInAGf4h+Jp2V9BI5uEj/AIQqxwhBuJ4S x2/xPOuc/ia6sAE8jP8AwGsKTTLuLw3ZW0aRyXFtJFK8e/AfYwYgH8OKuw6rDdQuIA8dymA8Mi4e PPcj09xx71c9btd2StDRPtj6YqFQ0rFm4jHReOfrTYpXitWkd/tBHTylGT+GaYL4f8+1x16bP/r+ 1QWWEbMrxkAbQMH1FOJwOPXsaYi73WQLtO3kHr9Kkz6nH40ARt88qx546tmqembUvtUgBxsuBIB/ suoOfz3flUliDNG104+aY59cKOB/j+NZOoPd2niiI2TQA3dtsdZkbDNG2VGR0JEjc4P3aqKvdEvu dF0ySPyqrc3EqQ7rYhzuww2k/j29KpLqOqQf8fejMw/v2dwsg/Jtp/Q1SvftWrMpsrWaFouHEt1J bHJ6fcDBvxpqDvrsDkaH227UKAj7v+vdsfz9jUVxqsFva5nuYI5STwzBD19Cawrjw7rFzcwyyCAo m7zIp7+e5V/lOPlIVeuO3c1kaVclRPJbRtFFLDHdE29tDAiZGGG6TsCMcA1vGnFq6ZDm10Oq0zxP BeXqWqvJcbvlJihLKp92AwPz71o+YI7vyufQH9a5PwxYXc+rXOoXEcUdksvmCa4u5JGztGcL8qr0 zuI79xXQjVbDUNReOyZpjEgLzBfk56YPf8M1FSFnZFRlfcuS5JGelR1M+XXAUnHOahrbD25TjxKf ONfIQleo5p67T1Jx7UlIDkkdwa2e5gti5ChBBCgKepJ5NTZ+aoLeXcNh6jpU3rXn1b82p6NG3LoN hP8ApMoHop/nT5pVhjLEEqOMAZqBSIbgHorDBPp6U66cEKmDyc1Fm9I7lyfKrlddRwNxyxJP8Bq1 FcpJH5gDDnHIxVRtPTduKpgdTipsjoBgAYArCLktxK63LakY3DnPelyCeR7cVUWQxnI6dxUySqeM EZ9a1UrlJkhzgkHt1pQcYzz9KgOWvCP4UX9T/wDqqbdgZxmqGB9vpQVVuuD7Gm7zuUAHH1p3mLvC 7TyM5pAMMW0/KxX26ioUkS4u/IkUZUHnBGat4x/9ekbjaPbJxTuBGLfafkZl91OR+VJmYMUZUc+m NpNPBU4KsOTUqtu+8ASPuk/40XEUnu1gXdIrhc4HFSxXKyRhwwwemQKmEcbqyOuQf4W55qL7KBwE DDsQOtAzG0fSJdMlaWRreN5T80VtH94+ryNlnI9Tj6Vqyg+WVLFssBzTwC0mcgbeAPrUcp/dEjsQ f1puTk7sSVkUXsb3TH8zTWM1uDl7OVug/wCmbHp9Dx9KQLp2vtvG+G8te/3JoM9vXB/EH3rYzkDH INc/qn2cz+ZqumzQiPIS+tmLbV/2iuGUfhgetXF3fmJ6FybQ7Vp3ubdpbOeRtzvbPtDn1Zfuk+5B NV5ItZtX3Ex6hEBjch8qVR9Put/47RbrqUUYm0/UINUs2GVWUgPj2kXgj6r+NSjXoIJFj1GGWwdu A0w/dn6OMr+BINHvev8AX3i09C1Y3c1yjHyJlKnDLMhQjjt1B/CrFzJ5du+TglSFBOMnFNWV5LjK 4MfrTL65t7Wzea4dUiXAZmHAycVmnzbFDrNES3hhBUlYwMD2FUtXjCSWF0UGYrpASV7P8n82FMXx HowYFbgt/uW7t/IVT1fWbDUdIu7SJr3zZYmWN10+dtr4+VuE7HB/CtIQd9US2rbm5d2Ftfw+VdRe YgOdpJH9apPbQ6HYv/ZOjxcks6W4SPOB1J7/AK1DpFlHeWlnqM1zdzySIso82TaFJGcbVwOPpWjc i2u4mt5YzNG33kUHn2NLZ26D31MyDxH9umkh0y0F3IiI7MZVRF3DIyRk/oayrrRbq1fSbr7Nb3Vy lxMgjJYRRCUlwc4JIVlGOO/at/R9FtNIXbbxFMBlUZH3S5YDAGON2B7Veubu3tIzLczxQRgZLSOF A/Oq50naGwrXWpgyeF0vGlfUJWu5rgh3CsY4lZcYIQZ5wOpyeBV210y20+XbBGiGQ5dvvFm6ZYnk /jUltrMd5cIllbXNxGTgz+XsjA9QWxuH0zVq6B2g/wB0+tTKUtmNJboiZZPMKq3A6en+etRyKEcj GasOMMGB+9Uc0bEbuuOtOlK09SK0bw03K9AXknviiivQPNFBIII6ipmuWI4AB7moTSVMoRluiozl HZkyYmDI5ySOpq6sZ8qP5t5AwcjvWfG+yQNV9WB+Un5WHWuOvDllddTtw8+aNn0IZpAzbR90frVI 30auVK9DgHcvP61dKKrlX4I71AUQn7i/lXI/M1GRzrPuA4I6gkVZiYbx0J7VGEVeigZ9BU1uu7B4 IJ704q+oX1sP8oLN93Jbnn1pXUAAbRjNS4H3iMHmkODwD+laFDF+TkAc0Ih812YAZwB9KkHbH6Gk JI+lIY4DLAdCTioLmQ4bbgknC5qdTkk+gqNlBXkA88ZFMCLZIjAoAYwBgfh61IhLICV2k9s0dAMf Xijce/P1pASf8tUOOvP+NRgfKOe1SD5lDdOtNIyTgUAB4VsLkgfnTWhX7NgnnZxz3qRiCuMYBpWx t/PH5UwI45VZEU/KxA5PRqeRg88fyqK2jMlrHnJzmkljDONjMjKMAg9qAMU2EF/qt4LQNZPBtU3V s21mlPJBXlWAGOoPX2rXaKf7Jt/dzyhMZkG1XPvjOM1HaW4sI2QLuV5GkZwcsSxySfzq4uSm8fdP eqlK5KRlR/20uFW305R2Hmt/8TUT2V/fTJHfmFIfvH7LPIjZHTkY9avNdSf23FaKFEfkNK3HOdwA /rUryusrbYw2AB1wRQ5W8gsUV8P2AOT9rI/2ruU/+zU9NC0+N1cRSbgQQTM5Ofzq8plLgkKF7gf4 1Jjkilzy7jsjM0Q7La4tu9tcyR4PYE7l/wDHWFT6rJNFplxLanE0aeYvGc45Ix74x+NVP+PDxCzE 4g1BFA7ASoCP/Hlx/wB8Vr7cjnGOnPpTlvcS2sMjmWaCO4QjZIocH2IqA6fYyXP2s28Tz9pGXJHp jNQaXbSWVkmn3DLIqF1iK5/1e75AfcLgfhSwXTxa5PYSMAjwrNAMc4HyuM+x2n/gQotq7B6l2eb7 PF5pRmAPYVTkv0eNgbede2CB0x161eKq6lXXcODyM1BJaWmR/o0X/fAqSjGittR1K4kkkv5YLOIj y4YUVS/c7ycn8sVrbty5OTxVdXjs4pTkRxrliFXP6Co7G7e8V2NrPbgE7fOABYeoAJIH1wfaqd2h LQcetFTSAben41DXdSnzxuebVp8krCik6UUvXitTMSrNtJn923/ATVaionBTVmVCbg7o0XUSptLA OOhP8qqyK0ancuDUbSMwByeKliuPl8uUbkPr2rk+rNPmOt14y02IQ5AIq9aj9yCfQ1Xktucwnevo Ooq0o8uFV/OqrOPL7vUVCMlLXoP7cHv0o5x/9aojCsp3HcCBgFWINOWMqDlyw4xng1ynWOHc0ppe 2f50nX3/AFoAXG2Pr1PpVea3WQ7m3E4/hYirL8bR6CovNjMpQuMg9DQAPwe348U3jgg5FPJz0Ofx zUZ+VtuMDb6dyaALA+W3H+9UQIA5UnNPyRFHjuTmopM7uG4x6UwB5AGy3AGelK1wDbFjhWI4Hr2p kkPnDrhutQopM8UTdEyT/P8ApVJLlv1IvLmt0LaBkiRemO1KWy3I9qXKEAFuRzjvTcgsT6VJYpT0 qs10YpMJ261LJMUjJzVFRlgWBIJrejTUrykc9ao42jESa5gt9UN0YbmaWWBYwkURYAAsevQZJ7nt Ulhei9efEDwsrAFJCpbp6Kxx+NWHijkjZHVXiYbXVhkEHsajtbSz09xFaWsNvEw+5EgQZHsKxlyy VjZXRbAJHuPQUvvnn25NGeOSAD+FVPs9znaLxgM5wYxUpWKJL20gv7V7eePcj4OQcFSDkEHsQeQR 3FZ2n6jcx3v9magn74ZMNxnidRznHZh3H4jjpqRJIkZWSTzDnOSuP0FVtVgtZ7BjeSCFIvnExYKY iOjA9sVcX0Yn3LMq5KlRlgwIGfzqlqNvIbuwu4IyZYJdrY6mNxhh9M7T/wABqtoeuDUA1vK3+kRg lZFQqtwg48xMgZHIzjOCepGCdOdpS/7tQAed2aUrweorpofJKIgG4PzAenU1MPughRkZHNRNGZYN pC7j+Wc0rSCKNiSOO3qaRRBdfLOjY+91x3qPcqupYgAnGTxkmo45JZ3Mkq4xwBii5QyW7qv3uq/U cigCWRM5FReX82BnA6mprci5jWRDlWGQfansFHGQeO1XGpKKsiJ0ozd2VWUAe/pTCMHBq0BtO48t /Kh0WRc9G7VpSrOLtLYyrUFJXjuVuvNJSkFTgjkUH9K7TgAHBoIwaSnKC/yjr2pPTUa10GgkHIrT jLTQIzc8YJ/GqCwSMSNp/KtCMZiCY5XAweM+9c2InFpJbnVhoyTu9hQo6Dij0UHrQWweRzjPtQMY 3VyHYHf/AANCjLAHv6il/hPf9aryQvMMJO0WOSU60wJ92593PPNV2YnImgz7gZFWVCYxyD09aQoS pCkHPYUAVoViMnybgQOVOcflUrnG7Hc46/59KccDGeuOaYdzn15FIAEpbMRXhRnI96cDgDGAPpTU yJpDjA4/rTyV/wAjNADwY1Xdk+vSq2ALkOv8RPX6VI5IUljgAVSa42/OcBVO76Yq4xcr26EznGNk +pcYFZ8nHzLjr6f/AK6dglB9aaGichhg/wB35qhe6I3KUAPTGahjuRTvufaOgqYWycZY4qpU0GpW pXBdty8EFG7fhXXVThFcpyUWqknzF8INuOxGKrFSxbIO5Bx9akjnWdCyEsoODkFR+tNXJJkJ+8a5 TsJFbeAwPX86pXms2VjKY55cTYG2KMF5H+irkn8qzNVGoPfLa25umhcbtlviIY775TyB7IN1Nh8P ujxm4mS2jY7Wgs8oZM/35D87fgRVqMd2yW30Fv8AX7sOIokW0d/uoV8+4I9okPH1Y4Her1potoxj uLsS3U/B3XbBip9gPlB/3RUiafDaoUtkjgjzyEXBP1PU0SxXs6rDZTxW8ePnnKbnz/sg8Z9zn6Uc 6vyx0FbuM102C2atdXIt5kbNu6DMiv22qOW9MDrTdI1g3kSwXsf2TUFGWgkIBdezqOuDg+46GrNn pdnYEyhWecj5riZt8jfien0HHtVfUrL+0hHLEwguIDuguCuSh7j3B6EUJxtYeu5facR5C8t1rF12 URaZBqizB0triOVjGcjyy2xzx6KzH8Kx7jUZ7uaS1vVjiaDmW2LlYgO0ksn8SnHyqvXv7U7XVJv7 Hv8ASQYlCtJEF+zSl2RxuBESjIXD4GT2rSNJrUlzOiXxHo6IPN1K3ixxmV9n/oWKsprWlSEbNSs2 +k6n+tYmnalbSwW+peIpZFRlT7ObkKkZY/3IwSxP+03PpipbzW5r24uYrKySSCJvkmW1LhlwCTvc qg7jqelL2SvYOc3ba6syvlpdRFQSQBID159at5XaGQBlPfOa5ezg0Q3IRpv7SuLjAP8AoqusZ9Mx ptUc9Se3WumW2NtbKluFVE6IowAKznFRLi7kbJycSOPxpUXaxLZYdRntQt9byRh1nj5HQsKTz0ll Kxyo+BnCkVAxZkDfMOvvUA96sblDbSfmI6UyRM8jrXTRrW92WxzV6PN70dyE8VJFIEPI/GmdeKSu uUVJWZxxk4u6NKOUEA4BHrmo3R95baOuQVqokhUFex/SnefKpwCM/SuCrQknpsdsK8ZLUmnupI4w 31zlc9qbDqcLkq+QcZBVW5qGaRrlRE6557ClTTwZM9vY1yJyb90116GhuDKPz5FB4T6n60oChMLx tHSlcDbjqQOlb2LGjAyO/elxjJB6VFvJIPfNS8EdPypAQNbIWLBnVickqeppqrMh4dXUjJ3DkenS pzxn6fzpg4XPqcUAWgGa2TgA+mc1EBjqtPifdEUzgjkU8H+8oJpiKV1IPLIPU9hUNsqOHVh1GDn0 ooroiv3LZzSd66Q2ACCb7LJgYGYX/vD0/Crcturb/wC83IJ9aKK5/M6bGeylWIYYIp8MnlyBvzoo r0Y+/DXqebL3J6dCzd+bJblLaVVkcfKzLkD6iqMWoXcMy2uo2JQscJcW+XjY+/dT9Rj3NFFcC7Ho va5ddtpQ4yQ2OuOKqWWj28c/2yQy3N0eRNcPuK/7o+6v/AQKKKSbS0HY1GjB69DUUk0cKlQBn0Hb 6miip8wKM1w7Nz17DFNBeZt0xO0dQO1FFcvM5PUm9yprXh6PW7ZXaO3W6iBMDTQiRR/vA9R/+uuV 0jRpp9XukSx8vegEnn3LRmORDg4WIAchlIyeQAaKK9CjNqDQpRV0dL4U0q1s7O4t3t4mu7W5eGSQ gsSM705Yk42MvGa3JVi8wAweYz9MkY6f/WooqZtuV2VHRENxHcG1VYpI7QgjlVDbf6VVOhWko86/ urm9GM/v58Rfii4Q/iKKKSk1sNpD0tIi/kxN5SpwNijBHHHIq5DDFCoQqoYDaHAwfxxRRWadxojM RVz8xz605iR0oopsErFdjlmyMGgnvRRXfQk3DU8+vFKpoJTgQRjv2ooq6nwmdPckt8wszvgZHCnv 71ZBcgZH5UUV5yioxTR6EXdtEsRZXG4Aj3oYnc3GOfWiihu5oMG7d0H5ClzyfY0UUgEDNyP50jnA Ax15oooAFJBznmphKcfN19iRRRQB/9k=