20240925 23434600 1.0 FALSE Culvert 002 file://\\ETSS706GISFS1\Corparcgisshare\iew\projects\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\UG_Final_DitchCulvert_12102024.gdb Local Area Network Projected GCS_WGS_1984 Linear Unit: Meter (1.000000) WGS_1984_Web_Mercator_Auxiliary_Sphere <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.4.0'><WKT>PROJCS[&quot;WGS_1984_Web_Mercator_Auxiliary_Sphere&quot;,GEOGCS[&quot;GCS_WGS_1984&quot;,DATUM[&quot;D_WGS_1984&quot;,SPHEROID[&quot;WGS_1984&quot;,6378137.0,298.257223563]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Mercator_Auxiliary_Sphere&quot;],PARAMETER[&quot;False_Easting&quot;,0.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,0.0],PARAMETER[&quot;Standard_Parallel_1&quot;,0.0],PARAMETER[&quot;Auxiliary_Sphere_Type&quot;,0.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem> ExportFeatures UG_Ditch_Culvert_FS\Culvert S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Culverts # NOT_USE_ALIAS "assettype "Asset type" true true false 0 Short 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,assettype,-1,-1;assetid "Asset ID" true true false 64 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,assetid,0,64;material "Material" true true false 0 Short 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,material,-1,-1;pipeshape "Culvert Shape" true true false 0 Short 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,pipeshape,-1,-1;diameter "Diameter" true true false 0 Double 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,diameter,-1,-1;width "Width" true true false 0 Double 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,width,-1,-1;height "Height" true true false 0 Double 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,height,-1,-1;wall "Wall" true true false 0 Short 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,wall,-1,-1;upelev "Upstream Elevation" true true false 0 Double 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,upelev,-1,-1;downelev "Downstream Elevation" true true false 0 Double 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,downelev,-1,-1;slope "Slope" true true false 0 Double 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,slope,-1,-1;installdate "Install Date" true true false 29 Date 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,installdate,-1,-1;lifecyclestatus "Lifecycle Status" true true false 0 Short 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,lifecyclestatus,-1,-1;ownedby "Owned By" true true false 0 Short 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,ownedby,-1,-1;maintby "Maintained By" true true false 0 Short 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,maintby,-1,-1;notes "Notes" true true false 2000 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,notes,0,2000;spatialsource "Spatial Source" true true false 0 Short 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,spatialsource,-1,-1;spatialconfidence "Spatial Confidence" true true false 0 Short 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,spatialconfidence,-1,-1;globalid "Global ID" false false true 38 GlobalID 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,globalid,-1,-1;creationdate "Creation date" true true false 29 Date 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,creationdate,-1,-1;creator "Creator" true true false 255 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,creator,0,255;lastupdate "Last update" true true false 29 Date 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,lastupdate,-1,-1;updatedby "Updated by" true true false 255 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,updatedby,0,255;SHAPE__Length "SHAPE__Length" false true true 0 Double 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,SHAPE__Length,-1,-1;created_user "created_user" false true true 255 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,created_user,0,255;created_date "created_date" false true true 29 Date 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,created_date,-1,-1;last_edited_user "last_edited_user" false true true 255 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,last_edited_user,0,255;last_edited_date "last_edited_date" false true true 29 Date 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,last_edited_date,-1,-1;status "Status" true true false 50 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,status,0,50;existingwo "Existing Work Order" true true false 24 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,existingwo,0,24;inspectiondate "Inspection Date" true true false 29 Date 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,inspectiondate,-1,-1;standwater "Standing Water" true true false 24 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,standwater,0,24;sedimentaccumulation "Sediment Accumulation" true true false 24 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,sedimentaccumulation,0,24;stormprobseverity "Storm Problem Severity" true true false 50 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,stormprobseverity,0,50;erosion "Erosion" true true false 50 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,erosion,0,50;settlingpres "Settling Present" true true false 50 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,settlingpres,0,50;sysconveyanceissue "System Conveyance Issue" true true false 50 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,sysconveyanceissue,0,50;assetcondition "Asset Condition" true true false 0 Long 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,assetcondition,-1,-1;syscleaningissue "System Cleaning Issue" true true false 50 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,syscleaningissue,0,50;recommendedaction "Recommended Action" true true false 100 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,recommendedaction,0,100;gencomments "General Comments" true true false 512 Text 0 0,First,#,UG_Ditch_Culvert_FS\Culvert,gencomments,0,512" # ChangePrivileges S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.County_Boundary;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Culverts;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Culverts__ATTACH;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Ditches;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Ditches__ATTACH;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Field_Notes_areas;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Field_Notes_areas__ATTACH;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Field_Notes_points;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Field_Notes_points__ATTACH;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Inlets;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Outfalls;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Project_Area_Divisions;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.South_Central_East_PolyLine;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.South_Central_West_PolyLine;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.South_East_PolyLine;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.South_West_PolyLine Web_User_UG "Grant view privileges" "Grant edit privileges" AddGlobalIDs S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.County_Boundary;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Culverts;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Ditches;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Field_Notes_areas;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Field_Notes_points;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Inlets;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Outfalls;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Project_Area_Divisions;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.South_Central_East_PolyLine;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.South_Central_West_PolyLine;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.South_East_PolyLine;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.South_West_PolyLine;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Field_Notes_points__ATTACH;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Field_Notes_areas__ATTACH;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Ditches__ATTACH;S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Culverts__ATTACH EnableArchiving S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Culverts EnableReplicaTracking S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Culverts 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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>spatialsource</field_name><domain_name>Spatial_Source</domain_name></AssignDomainToField></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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>erosion</field_name><domain_name>ErosionLevel</domain_name></AssignDomainToField></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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>existingwo</field_name><domain_name>YesNo</domain_name></AssignDomainToField></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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>standwater</field_name><domain_name>YesNo</domain_name></AssignDomainToField></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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>sedimentaccumulation</field_name><domain_name>YesNo</domain_name></AssignDomainToField></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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>stormprobseverity</field_name><domain_name>IssueLevel</domain_name></AssignDomainToField></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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>sysconveyanceissue</field_name><domain_name>IssueLevel</domain_name></AssignDomainToField></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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>syscleaningissue</field_name><domain_name>IssueLevel</domain_name></AssignDomainToField></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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>recommendedaction</field_name><domain_name>RecommendedAction</domain_name></AssignDomainToField></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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>settlingpres</field_name><domain_name>GroundSettling</domain_name></AssignDomainToField></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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>status</field_name><domain_name>PipeStatus</domain_name></AssignDomainToField></workflow></operationSequence> CalculateField DBO.Culverts spatialsource 5 Python # 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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddField><field_name>assetcondition2</field_name><field_type>SHORT</field_type><field_precision>5</field_precision><field_alias>Asset Condition</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>AssetCondition1</field_domain></AddField></workflow></operationSequence>" CalculateField DBO.Culverts assetsscondition2 1 Python # Text NO_ENFORCE_DOMAINS CalculateField DBO.Culverts assetsscondition2 2 Python # Text NO_ENFORCE_DOMAINS CalculateField DBO.Culverts assetsscondition2 3 Python # Text NO_ENFORCE_DOMAINS CalculateField DBO.Culverts assetsscondition2 4 Python # Text NO_ENFORCE_DOMAINS CalculateField DBO.Culverts assetsscondition2 5 Python # Text NO_ENFORCE_DOMAINS CalculateField DBO.Culverts assetcondition2 5 Python # Text NO_ENFORCE_DOMAINS CalculateField DBO.Culverts assetcondition2 4 Python # Text NO_ENFORCE_DOMAINS CalculateField DBO.Culverts assetcondition2 3 Python # Text NO_ENFORCE_DOMAINS CalculateField DBO.Culverts assetcondition2 2 Python # Text NO_ENFORCE_DOMAINS CalculateField DBO.Culverts assetcondition2 1 Python # 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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>assetsscondition2</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.2.0'><WorkspaceConnectionString>SERVER=Etss706gissql3;INSTANCE="sde:sqlserver:Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="Etss706gissql3\IEW, 51756;Encrypt=no;TrustServerCertificate=yes";DATABASE=SDE_IEW_UGWyandotte;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=OSA</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>assetcondition</field_name></DeleteField></workflow></operationSequence> AlterField S:\UG_of_Wyandotte_KC\Maps\UG_Analysis2\SDE_IEW_UGWyandotte_AD.sde\DBO.Culverts assetcondition2 assetcondition # "Short (16-bit integer)" 2 NULLABLE DO_NOT_CLEAR CopyMultiple "'S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\SQLServer-Etss706gissql3_IEW, 51756-SDE_IEW_UGWyandotte.sde\DBO.Culverts' FeatureClass;'S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\SQLServer-Etss706gissql3_IEW, 51756-SDE_IEW_UGWyandotte.sde\DBO.Ditches' FeatureClass" S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\UG_Culvert_Review.gdb Culverts;Ditches "DBO.Culverts FeatureClass Culverts #;DBO.Ditches FeatureClass Ditches #;DBO.Culverts__ATTACHREL RelationshipClass Culverts__ATTACHREL #;DBO.Ditches__ATTACHREL RelationshipClass Ditches__ATTACHREL #;DBO.Culverts__ATTACH TableDataset Culverts__ATTACH #;DBO.Ditches__ATTACH TableDataset Ditches__ATTACH #" 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.3.0'><WorkspaceConnectionString>DATABASE=S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\UG_Culvert_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>risktoproperty</field_name><field_type>TEXT</field_type><field_length>24</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>YesNo</field_domain></AddField></workflow><workflow><AddField><field_name>risktopavement</field_name><field_type>TEXT</field_type><field_length>24</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>YesNo</field_domain></AddField></workflow><workflow><AddField><field_name>creekname</field_name><field_type>TEXT</field_type><field_length>70</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>workordercount</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>priorityscore</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>replacementcost</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>nextactioncost</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Working\DBO.Culverts risktoproperty 'Yes' Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts risktopavement 'Yes' Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts recommendedaction 'None' Python # 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.3.0'><WorkspaceConnectionString>DATABASE=S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\UG_Culvert_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>requirescleaning</field_name><field_type>TEXT</field_type><field_length>24</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>YesNo</field_domain></AddField></workflow></operationSequence> CalculateField Working\DBO.Culverts recommendedaction 'Requires Cleaning' Python # Text NO_ENFORCE_DOMAINS DeleteField Working\DBO.Culverts requirescleaning "Delete Fields" CalculateField Working\DBO.Culverts recommendedaction 'Needs Design' Python # Text NO_ENFORCE_DOMAINS Append Ditches Working\DBO.Culverts "Use the field map to reconcile field differences" "assettype "Asset type" true true false 2 Short 0 0,First,#;assetid "Asset ID" true true false 64 Text 0 0,First,#;material "Material" true true false 2 Short 0 0,First,#;diameter "Diameter" true true false 8 Double 0 0,First,#;upelev "Upstream Elevation" true true false 8 Double 0 0,First,#;downelev "Downstream Elevation" true true false 8 Double 0 0,First,#;slope "Slope" true true false 8 Double 0 0,First,#;installdate "Install Date" true true false 8 Date 0 0,First,#;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#;ownedby "Owned By" true true false 2 Short 0 0,First,#;maintby "Maintained By" true true false 2 Short 0 0,First,#;notes "Notes" true true false 2000 Text 0 0,First,#;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#;globalid "Global ID" false false true 38 GlobalID 0 0,First,#;creationdate "Creation date" true true false 8 Date 0 0,First,#;creator "Creator" true true false 255 Text 0 0,First,#;lastupdate "Last update" true true false 8 Date 0 0,First,#;updatedby "Updated by" true true false 255 Text 0 0,First,#;status "Status" true true false 255 Text 0 0,First,#;existingwo "Existing Work Order" true true false 24 Text 0 0,First,#;inspectiondate "Inspection Date" true true false 8 Date 0 0,First,#;ditchbottomwidth "Ditch Bottom Width (ft)" true true false 8 Double 0 0,First,#;ditchdepth "Ditch Depth" true true false 8 Double 0 0,First,#;bedmaterial "Bed Material" true true false 50 Text 0 0,First,#;obswaterlevel "Standing Water" true true false 50 Text 0 0,First,#;sedimentaccumulation "Sediment Accumulation" true true false 255 Text 0 0,First,#;stormprobseverity "Storm Problem Severity" true true false 50 Text 0 0,First,#;erosion "Erosion" true true false 50 Text 0 0,First,#;sysconveyanceissue "System Conveyance Issue" true true false 50 Text 0 0,First,#;syscleaningissue "System Cleaning Issue" true true false 50 Text 0 0,First,#;recommendedaction "Recommended Action" true true false 100 Text 0 0,First,#;gencomments "General Comments" true true false 512 Text 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#;assetcondition "Asset Condition" true true false 2 Short 0 0,First,#;risktoproperty "Risk to Property" true true false 24 Text 0 0,First,#;risktopavement "Risk to Pavement" true true false 24 Text 0 0,First,#;creekname "Creek Basin Name" true true false 70 Text 0 0,First,#;workordercount "Work Order Count" true true false 2 Short 0 0,First,#;priorityscore "Priority Score" true true false 8 Double 0 0,First,#;replacementcost "Replacement Cost" true true false 8 Double 0 0,First,#;nextactioncost "Next Action Cost" true true false 8 Double 0 0,First,#" # "NewDitch = 'Yes' And Migrate IS NULL And (CulvertColor = 'Orange' Or CulvertColor = 'Yellow' Or CulvertColor = '4')" # NOT_UPDATE_GEOMETRY CalculateField Working\DBO.Culverts spatialsource 3 Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts assetcondition 2 Python # Text NO_ENFORCE_DOMAINS Append Ditches Working\DBO.Culverts "Use the field map to reconcile field differences" "assettype "Asset type" true true false 2 Short 0 0,First,#;assetid "Asset ID" true true false 64 Text 0 0,First,#;material "Material" true true false 2 Short 0 0,First,#;diameter "Diameter" true true false 8 Double 0 0,First,#;upelev "Upstream Elevation" true true false 8 Double 0 0,First,#;downelev "Downstream Elevation" true true false 8 Double 0 0,First,#;slope "Slope" true true false 8 Double 0 0,First,#;installdate "Install Date" true true false 8 Date 0 0,First,#;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#;ownedby "Owned By" true true false 2 Short 0 0,First,#;maintby "Maintained By" true true false 2 Short 0 0,First,#;notes "Notes" true true false 2000 Text 0 0,First,#;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#;globalid "Global ID" false false true 38 GlobalID 0 0,First,#;creationdate "Creation date" true true false 8 Date 0 0,First,#;creator "Creator" true true false 255 Text 0 0,First,#;lastupdate "Last update" true true false 8 Date 0 0,First,#;updatedby "Updated by" true true false 255 Text 0 0,First,#;status "Status" true true false 255 Text 0 0,First,#;existingwo "Existing Work Order" true true false 24 Text 0 0,First,#;inspectiondate "Inspection Date" true true false 8 Date 0 0,First,#;ditchbottomwidth "Ditch Bottom Width (ft)" true true false 8 Double 0 0,First,#;ditchdepth "Ditch Depth" true true false 8 Double 0 0,First,#;bedmaterial "Bed Material" true true false 50 Text 0 0,First,#;obswaterlevel "Standing Water" true true false 50 Text 0 0,First,#;sedimentaccumulation "Sediment Accumulation" true true false 255 Text 0 0,First,#;stormprobseverity "Storm Problem Severity" true true false 50 Text 0 0,First,#;erosion "Erosion" true true false 50 Text 0 0,First,#;sysconveyanceissue "System Conveyance Issue" true true false 50 Text 0 0,First,#;syscleaningissue "System Cleaning Issue" true true false 50 Text 0 0,First,#;recommendedaction "Recommended Action" true true false 100 Text 0 0,First,#;gencomments "General Comments" true true false 512 Text 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#;assetcondition "Asset Condition" true true false 2 Short 0 0,First,#;risktoproperty "Risk to Property" true true false 24 Text 0 0,First,#;risktopavement "Risk to Pavement" true true false 24 Text 0 0,First,#;creekname "Creek Basin Name" true true false 70 Text 0 0,First,#;workordercount "Work Order Count" true true false 2 Short 0 0,First,#;priorityscore "Priority Score" true true false 8 Double 0 0,First,#;replacementcost "Replacement Cost" true true false 8 Double 0 0,First,#;nextactioncost "Next Action Cost" true true false 8 Double 0 0,First,#" # "NewDitch = 'Yes' And Migrate IS NULL And (CulvertColor = 'Green')" # NOT_UPDATE_GEOMETRY CalculateField Working\DBO.Culverts assetcondition 4 Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts spatialsource 3 Python # Text NO_ENFORCE_DOMAINS Append Ditches Working\DBO.Culverts "Use the field map to reconcile field differences" "assettype "Asset type" true true false 2 Short 0 0,First,#;assetid "Asset ID" true true false 64 Text 0 0,First,#;material "Material" true true false 2 Short 0 0,First,#;diameter "Diameter" true true false 8 Double 0 0,First,#;upelev "Upstream Elevation" true true false 8 Double 0 0,First,#;downelev "Downstream Elevation" true true false 8 Double 0 0,First,#;slope "Slope" true true false 8 Double 0 0,First,#;installdate "Install Date" true true false 8 Date 0 0,First,#;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#;ownedby "Owned By" true true false 2 Short 0 0,First,#;maintby "Maintained By" true true false 2 Short 0 0,First,#;notes "Notes" true true false 2000 Text 0 0,First,#;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#;globalid "Global ID" false false true 38 GlobalID 0 0,First,#;creationdate "Creation date" true true false 8 Date 0 0,First,#;creator "Creator" true true false 255 Text 0 0,First,#;lastupdate "Last update" true true false 8 Date 0 0,First,#;updatedby "Updated by" true true false 255 Text 0 0,First,#;status "Status" true true false 255 Text 0 0,First,#;existingwo "Existing Work Order" true true false 24 Text 0 0,First,#;inspectiondate "Inspection Date" true true false 8 Date 0 0,First,#;ditchbottomwidth "Ditch Bottom Width (ft)" true true false 8 Double 0 0,First,#;ditchdepth "Ditch Depth" true true false 8 Double 0 0,First,#;bedmaterial "Bed Material" true true false 50 Text 0 0,First,#;obswaterlevel "Standing Water" true true false 50 Text 0 0,First,#;sedimentaccumulation "Sediment Accumulation" true true false 255 Text 0 0,First,#;stormprobseverity "Storm Problem Severity" true true false 50 Text 0 0,First,#;erosion "Erosion" true true false 50 Text 0 0,First,#;sysconveyanceissue "System Conveyance Issue" true true false 50 Text 0 0,First,#;syscleaningissue "System Cleaning Issue" true true false 50 Text 0 0,First,#;recommendedaction "Recommended Action" true true false 100 Text 0 0,First,#;gencomments "General Comments" true true false 512 Text 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#;assetcondition "Asset Condition" true true false 2 Short 0 0,First,#;risktoproperty "Risk to Property" true true false 24 Text 0 0,First,#;risktopavement "Risk to Pavement" true true false 24 Text 0 0,First,#;creekname "Creek Basin Name" true true false 70 Text 0 0,First,#;workordercount "Work Order Count" true true false 2 Short 0 0,First,#;priorityscore "Priority Score" true true false 8 Double 0 0,First,#;replacementcost "Replacement Cost" true true false 8 Double 0 0,First,#;nextactioncost "Next Action Cost" true true false 8 Double 0 0,First,#" # "NewDitch = 'Yes' And Migrate IS NULL And CulvertColor IS NULL" # NOT_UPDATE_GEOMETRY CalculateField Working\DBO.Culverts spatialsource 3 Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts assetcondition 4 Python # Text NO_ENFORCE_DOMAINS Append Culverts Working\DBO.Culverts "Use the field map to reconcile field differences" "assettype "Asset type" true true false 2 Short 0 0,First,#;assetid "Asset ID" true true false 64 Text 0 0,First,#;material "Material" true true false 2 Short 0 0,First,#;diameter "Diameter" true true false 8 Double 0 0,First,#;upelev "Upstream Elevation" true true false 8 Double 0 0,First,#;downelev "Downstream Elevation" true true false 8 Double 0 0,First,#;slope "Slope" true true false 8 Double 0 0,First,#;installdate "Install Date" true true false 8 Date 0 0,First,#;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#;ownedby "Owned By" true true false 2 Short 0 0,First,#;maintby "Maintained By" true true false 2 Short 0 0,First,#;notes "Notes" true true false 2000 Text 0 0,First,#;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#;globalid "Global ID" false false true 38 GlobalID 0 0,First,#;creationdate "Creation date" true true false 8 Date 0 0,First,#;creator "Creator" true true false 255 Text 0 0,First,#;lastupdate "Last update" true true false 8 Date 0 0,First,#;updatedby "Updated by" true true false 255 Text 0 0,First,#;status "Status" true true false 255 Text 0 0,First,#;existingwo "Existing Work Order" true true false 24 Text 0 0,First,#;inspectiondate "Inspection Date" true true false 8 Date 0 0,First,#;ditchbottomwidth "Ditch Bottom Width (ft)" true true false 8 Double 0 0,First,#;ditchdepth "Ditch Depth" true true false 8 Double 0 0,First,#;bedmaterial "Bed Material" true true false 50 Text 0 0,First,#;obswaterlevel "Standing Water" true true false 50 Text 0 0,First,#;sedimentaccumulation "Sediment Accumulation" true true false 255 Text 0 0,First,#;stormprobseverity "Storm Problem Severity" true true false 50 Text 0 0,First,#;erosion "Erosion" true true false 50 Text 0 0,First,#;sysconveyanceissue "System Conveyance Issue" true true false 50 Text 0 0,First,#;syscleaningissue "System Cleaning Issue" true true false 50 Text 0 0,First,#;recommendedaction "Recommended Action" true true false 100 Text 0 0,First,#;gencomments "General Comments" true true false 512 Text 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#;assetcondition "Asset Condition" true true false 2 Short 0 0,First,#;risktoproperty "Risk to Property" true true false 24 Text 0 0,First,#;risktopavement "Risk to Pavement" true true false 24 Text 0 0,First,#;creekname "Creek Basin Name" true true false 70 Text 0 0,First,#;workordercount "Work Order Count" true true false 2 Short 0 0,First,#;priorityscore "Priority Score" true true false 8 Double 0 0,First,#;replacementcost "Replacement Cost" true true false 8 Double 0 0,First,#;nextactioncost "Next Action Cost" true true false 8 Double 0 0,First,#" # # # NOT_UPDATE_GEOMETRY CalculateField Working\DBO.Culverts assetcondition 2 Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts spatialsource 3 Python # Text NO_ENFORCE_DOMAINS Append Culverts Working\DBO.Culverts "Use the field map to reconcile field differences" "assettype "Asset type" true true false 2 Short 0 0,First,#;assetid "Asset ID" true true false 64 Text 0 0,First,#;material "Material" true true false 2 Short 0 0,First,#;diameter "Diameter" true true false 8 Double 0 0,First,#;upelev "Upstream Elevation" true true false 8 Double 0 0,First,#;downelev "Downstream Elevation" true true false 8 Double 0 0,First,#;slope "Slope" true true false 8 Double 0 0,First,#;installdate "Install Date" true true false 8 Date 0 0,First,#;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#;ownedby "Owned By" true true false 2 Short 0 0,First,#;maintby "Maintained By" true true false 2 Short 0 0,First,#;notes "Notes" true true false 2000 Text 0 0,First,#;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#;globalid "Global ID" false false true 38 GlobalID 0 0,First,#;creationdate "Creation date" true true false 8 Date 0 0,First,#;creator "Creator" true true false 255 Text 0 0,First,#;lastupdate "Last update" true true false 8 Date 0 0,First,#;updatedby "Updated by" true true false 255 Text 0 0,First,#;status "Status" true true false 255 Text 0 0,First,#;existingwo "Existing Work Order" true true false 24 Text 0 0,First,#;inspectiondate "Inspection Date" true true false 8 Date 0 0,First,#;ditchbottomwidth "Ditch Bottom Width (ft)" true true false 8 Double 0 0,First,#;ditchdepth "Ditch Depth" true true false 8 Double 0 0,First,#;bedmaterial "Bed Material" true true false 50 Text 0 0,First,#;obswaterlevel "Standing Water" true true false 50 Text 0 0,First,#;sedimentaccumulation "Sediment Accumulation" true true false 255 Text 0 0,First,#;stormprobseverity "Storm Problem Severity" true true false 50 Text 0 0,First,#;erosion "Erosion" true true false 50 Text 0 0,First,#;sysconveyanceissue "System Conveyance Issue" true true false 50 Text 0 0,First,#;syscleaningissue "System Cleaning Issue" true true false 50 Text 0 0,First,#;recommendedaction "Recommended Action" true true false 100 Text 0 0,First,#;gencomments "General Comments" true true false 512 Text 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#;assetcondition "Asset Condition" true true false 2 Short 0 0,First,#;risktoproperty "Risk to Property" true true false 24 Text 0 0,First,#;risktopavement "Risk to Pavement" true true false 24 Text 0 0,First,#;creekname "Creek Basin Name" true true false 70 Text 0 0,First,#;workordercount "Work Order Count" true true false 2 Short 0 0,First,#;priorityscore "Priority Score" true true false 8 Double 0 0,First,#;replacementcost "Replacement Cost" true true false 8 Double 0 0,First,#;nextactioncost "Next Action Cost" true true false 8 Double 0 0,First,#" # # # NOT_UPDATE_GEOMETRY CalculateField Working\DBO.Culverts spatialsource 3 Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts assetcondition 4 Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts assetid autoIncrement() Python "rec=0 def autoIncrement(): global rec pStart = 1 pInterval = 1 if (rec == 0): rec = pStart else: 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.3.0'><WorkspaceConnectionString>DATABASE=S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\UG_Culvert_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>numb</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Working\DBO.Culverts numb autoIncrement() Python "rec=0 def autoIncrement(): global rec pStart = 1 pInterval = 1 if (rec == 0): rec = pStart else: rec += pInterval return rec" Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts assetid 'CT-000'+$feature.numb Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts assetid 'CT-00'+$feature.numb Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts assetid 'CT-0'+$feature.numb Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts assetid 'CT-'+$feature.numb 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.3.0'><WorkspaceConnectionString>DATABASE=S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\UG_Culvert_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>numb</field_name></DeleteField></workflow></operationSequence> CalculateField Working\DBO.Culverts standwater 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts sedimentaccumulation 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts stormprobseverity 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts erosion 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts settlingpres 'Unknown' Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts sysconveyanceissue 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts syscleaningissue 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts recommendedaction 'None' Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts risktoproperty 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts risktopavement 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts priorityscore "var setPres = IIf($feature.settlingpres == 'Yes - Significant', 1, IIF($feature.settlingpres == 'Yes - Minor', 0.5, 0)); //var sedAccum = IIF($feature.sedimentaccumulation == 'Yes', 1,0); var stormProb = IIF($feature.stormprobseverity == 'High', 1, IIF($feature.stormprobseverity == 'Medium', 0.5, 0)); var erosion = IIF($feature.erosion == 'High', 2, IIF($feature.erosion == 'Medium', 1, IIF($feature.erosion == 'Low', 0.5,0))); //var sysConIss = IIF($feature.sysconveyanceissue == 'High', 1, IIF($feature.sysconveyanceissue == 'Medium', 0.5, 0)); var sysCleanIss = IIF($feature.syscleaningissue == 'High', 2, IIF($feature.syscleaningissue == 'Medium', 1, IIF($feature.syscleaningissue == 'Low', 0.5, 0))); var assCon = IIF($feature.assetcondition == 1, 2, IIF($feature.assetcondition == 2, 1, IIF($feature.assetcondition == 3, 0.5, 0))) var woCount = IIF($feature.workordercount >= 3, 2, IIF($feature.workordercount == 1 || $feature.workordercount == 2, 1, 0)) return setPres + stormProb + erosion + sysCleanIss + assCon + woCount;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts replacementcost "$feature.Shape_Length *500" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "var needsDesign = IIF(($feature.Shape_Length * 30) < 5000, 5000, $feature.Shape_Length * 30); If($feature.recommendedaction == 'Requires Cleaning') Return ($feature.Shape_Length * 15); Else If($feature.recommendedaction == 'Needs Design') Return needsDesign; Else Return 0;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "var needsDesign = IIF(($feature.Shape_Length * 30) < 10000, 10000, $feature.Shape_Length * 30); If($feature.recommendedaction == 'Requires Cleaning') Return ($feature.Shape_Length * 15); Else If($feature.recommendedaction == 'Needs Design') Return needsDesign; Else Return 0;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "var needsDesign = IIF(($feature.Shape_Length * 30) < 10000, 10000, $feature.Shape_Length * 500); If($feature.recommendedaction == 'Requires Cleaning') Return ($feature.Shape_Length * 15); Else If($feature.recommendedaction == 'Needs Design') Return needsDesign; Else Return 0;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "var needsDesign = IIF(($feature.Shape_Length * 500) < 10000, 10000, $feature.Shape_Length * 500); If($feature.recommendedaction == 'Requires Cleaning') Return ($feature.Shape_Length * 15); Else If($feature.recommendedaction == 'Needs Design') Return needsDesign; Else Return 0;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "110 *30" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "19.25 *30" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "123.69 *30" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "82.29 *30" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "66.45 *30" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "862.86 *30" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "81.38 *30" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "142.74 *30" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (586.12 + 113.38)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (40.742042+ 88.332506)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (1428.609248 + 1008.305973)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (110.27 + 156.23)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (108.45 + 0)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (64.11 + 0)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (34.91 + 0)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (55.09 + 0)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (209.86 + 653.08)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (55.09 + 0)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (19.25 + 0)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (68.55 + 55.14)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (34.91 + 0)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (34.54 + 34.91)*30 Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost (81.38 + 0)*30 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.3.0'><WorkspaceConnectionString>DATABASE=S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\UG_Culvert_Review.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Culverts</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>lengthft</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Working\DBO.Culverts replacementcost "!lengthft! * 500" Python # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts replacementcost "$feature.lengthft * 500" Arcade # Text NO_ENFORCE_DOMAINS CalculateGeometryAttributes Working\DBO.Culverts "lengthft LENGTH_GEODESIC" "US Survey Feet" # PROJCS["NAD_1983_StatePlane_Kansas_North_FIPS_1501_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["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1312333.333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-98.0],PARAMETER["Standard_Parallel_1",38.71666666666667],PARAMETER["Standard_Parallel_2",39.78333333333333],PARAMETER["Latitude_Of_Origin",38.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes Working\DBO.Culverts "lengthft LENGTH_3D" "US Survey Feet" # PROJCS["NAD_1983_StatePlane_Kansas_North_FIPS_1501_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["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1312333.333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-98.0],PARAMETER["Standard_Parallel_1",38.71666666666667],PARAMETER["Standard_Parallel_2",39.78333333333333],PARAMETER["Latitude_Of_Origin",38.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateGeometryAttributes Working\DBO.Culverts "lengthft LENGTH_GEODESIC" "International Feet" # PROJCS["NAD_1983_StatePlane_Kansas_North_FIPS_1501_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["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1312333.333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-98.0],PARAMETER["Standard_Parallel_1",38.71666666666667],PARAMETER["Standard_Parallel_2",39.78333333333333],PARAMETER["Latitude_Of_Origin",38.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateField Working\DBO.Culverts replacementcost "$feature.lengthft * 500" Arcade # Text NO_ENFORCE_DOMAINS CalculateField Working\DBO.Culverts nextactioncost "var needsDesign = IIF(($feature.lengthft * 500) < 10000, 10000, $feature.lengthft * 500); If($feature.recommendedaction == 'Requires Cleaning') Return ($feature.lengthft * 15); Else If($feature.recommendedaction == 'Needs Design') Return needsDesign; Else Return 0;" Arcade # Text NO_ENFORCE_DOMAINS ExportFeatures Working\DBO.Culverts S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\Assets_09252024.gdb\Culverts # NOT_USE_ALIAS "assettype "Asset type" true true false 2 Short 0 0,First,#,Working\DBO.Culverts,assettype,-1,-1;assetid "Asset ID" true true false 64 Text 0 0,First,#,Working\DBO.Culverts,assetid,0,63;material "Material" true true false 2 Short 0 0,First,#,Working\DBO.Culverts,material,-1,-1;pipeshape "Culvert Shape" true true false 2 Short 0 0,First,#,Working\DBO.Culverts,pipeshape,-1,-1;diameter "Diameter" true true false 8 Double 0 0,First,#,Working\DBO.Culverts,diameter,-1,-1;width "Width" true true false 8 Double 0 0,First,#,Working\DBO.Culverts,width,-1,-1;height "Height" true true false 8 Double 0 0,First,#,Working\DBO.Culverts,height,-1,-1;wall "Wall" true true false 2 Short 0 0,First,#,Working\DBO.Culverts,wall,-1,-1;upelev "Upstream Elevation" true true false 8 Double 0 0,First,#,Working\DBO.Culverts,upelev,-1,-1;downelev "Downstream Elevation" true true false 8 Double 0 0,First,#,Working\DBO.Culverts,downelev,-1,-1;slope "Slope" true true false 8 Double 0 0,First,#,Working\DBO.Culverts,slope,-1,-1;installdate "Install Date" true true false 8 Date 0 0,First,#,Working\DBO.Culverts,installdate,-1,-1;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#,Working\DBO.Culverts,lifecyclestatus,-1,-1;ownedby "Owned By" true true false 2 Short 0 0,First,#,Working\DBO.Culverts,ownedby,-1,-1;maintby "Maintained By" true true false 2 Short 0 0,First,#,Working\DBO.Culverts,maintby,-1,-1;notes "Notes" true true false 2000 Text 0 0,First,#,Working\DBO.Culverts,notes,0,1999;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#,Working\DBO.Culverts,spatialsource,-1,-1;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#,Working\DBO.Culverts,spatialconfidence,-1,-1;status "Status" true true false 50 Text 0 0,First,#,Working\DBO.Culverts,status,0,49;existingwo "Existing Work Order" true true false 24 Text 0 0,First,#,Working\DBO.Culverts,existingwo,0,23;inspectiondate "Inspection Date" true true false 8 Date 0 0,First,#,Working\DBO.Culverts,inspectiondate,-1,-1;standwater "Standing Water" true true false 24 Text 0 0,First,#,Working\DBO.Culverts,standwater,0,23;sedimentaccumulation "Sediment Accumulation" true true false 24 Text 0 0,First,#,Working\DBO.Culverts,sedimentaccumulation,0,23;stormprobseverity "Storm Problem Severity" true true false 50 Text 0 0,First,#,Working\DBO.Culverts,stormprobseverity,0,49;erosion "Erosion" true true false 50 Text 0 0,First,#,Working\DBO.Culverts,erosion,0,49;settlingpres "Settling Present" true true false 50 Text 0 0,First,#,Working\DBO.Culverts,settlingpres,0,49;sysconveyanceissue "System Conveyance Issue" true true false 50 Text 0 0,First,#,Working\DBO.Culverts,sysconveyanceissue,0,49;syscleaningissue "System Cleaning Issue" true true false 50 Text 0 0,First,#,Working\DBO.Culverts,syscleaningissue,0,49;recommendedaction "Recommended Action" true true false 100 Text 0 0,First,#,Working\DBO.Culverts,recommendedaction,0,99;risktoproperty "Risk to Property" true true false 24 Text 0 0,First,#,Working\DBO.Culverts,risktoproperty,0,23;risktopavement "Risk to Pavement" true true false 24 Text 0 0,First,#,Working\DBO.Culverts,risktopavement,0,23;assetcondition "Asset Condition" true true false 2 Short 0 0,First,#,Working\DBO.Culverts,assetcondition,-1,-1;gencomments "General Comments" true true false 512 Text 0 0,First,#,Working\DBO.Culverts,gencomments,0,511;creekname "Creek Basin Name" true true false 70 Text 0 0,First,#,Working\DBO.Culverts,creekname,0,69;workordercount "Work Order Count" true true false 2 Short 0 0,First,#,Working\DBO.Culverts,workordercount,-1,-1;priorityscore "Priority Score" true true false 8 Double 0 0,First,#,Working\DBO.Culverts,priorityscore,-1,-1;replacementcost "Replacement Cost" true true false 8 Double 0 0,First,#,Working\DBO.Culverts,replacementcost,-1,-1;nextactioncost "Next Action Cost" true true false 8 Double 0 0,First,#,Working\DBO.Culverts,nextactioncost,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Working\DBO.Culverts,Shape_Length,-1,-1;lengthft "Length (ft)" true true false 8 Double 0 0,First,#,Working\DBO.Culverts,lengthft,-1,-1;globalid "Global ID" false false true 38 GlobalID 0 0,First,#,Working\DBO.Culverts,globalid,-1,-1;creationdate "Creation date" true true false 8 Date 0 0,First,#,Working\DBO.Culverts,creationdate,-1,-1;creator "Creator" true true false 255 Text 0 0,First,#,Working\DBO.Culverts,creator,0,254;lastupdate "Last update" true true false 8 Date 0 0,First,#,Working\DBO.Culverts,lastupdate,-1,-1;updatedby "Updated by" true true false 255 Text 0 0,First,#,Working\DBO.Culverts,updatedby,0,254;created_user "created_user" true true false 255 Text 0 0,First,#,Working\DBO.Culverts,created_user,0,254;created_date "created_date" true true false 8 Date 0 0,First,#,Working\DBO.Culverts,created_date,-1,-1;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#,Working\DBO.Culverts,last_edited_user,0,254;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#,Working\DBO.Culverts,last_edited_date,-1,-1" # CopyMultiple "S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\Assets_09252024.gdb\Culverts FeatureClass" "S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\SQLServer-Etss706gissql3_IEW, 51756-SDE_IEW_UGWyandotte.sde" Culverts_2 "Culverts FeatureClass DBO.Culverts_2 #;Culverts__ATTACHREL RelationshipClass DBO.Culverts__ATTACHREL_1 #;Culverts__ATTACH TableDataset DBO.Culverts__ATTACH_1 #" Rename "S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\SQLServer-Etss706gissql3_IEW, 51756-SDE_IEW_UGWyandotte.sde\DBO.Culverts_2" "S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\SQLServer-Etss706gissql3_IEW, 51756-SDE_IEW_UGWyandotte.sde\DBO.Culverts_Final" FeatureClass Append 'NewData\Group 1\Polylines G1' NewData\Culverts "Use the field map to reconcile field differences" "assettype "Asset type" true true false 2 Short 0 0,First,#;assetid "Asset ID" true true false 64 Text 0 0,First,#;material "Material" true true false 2 Short 0 0,First,#;diameter "Diameter" true true false 8 Double 0 0,First,#;upelev "Upstream Elevation" true true false 8 Double 0 0,First,#;downelev "Downstream Elevation" true true false 8 Double 0 0,First,#;slope "Slope" true true false 8 Double 0 0,First,#;installdate "Install Date" true true false 8 Date 0 0,First,#;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#;ownedby "Owned By" true true false 2 Short 0 0,First,#;maintby "Maintained By" true true false 2 Short 0 0,First,#;notes "Notes" true true false 2000 Text 0 0,First,#;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#;status "Status" true true false 255 Text 0 0,First,#;existingwo "Existing Work Order" true true false 24 Text 0 0,First,#;inspectiondate "Inspection Date" true true false 8 Date 0 0,First,#;ditchbottomwidth "Ditch Bottom Width (ft)" true true false 8 Double 0 0,First,#;ditchdepth "Ditch Depth" true true false 8 Double 0 0,First,#;bedmaterial "Bed Material" true true false 50 Text 0 0,First,#;obswaterlevel "Standing Water" true true false 50 Text 0 0,First,#;sedimentaccumulation "Sediment Accumulation" true true false 255 Text 0 0,First,#;stormprobseverity "Storm Problem Severity" true true false 50 Text 0 0,First,#;erosion "Erosion" true true false 50 Text 0 0,First,#;sysconveyanceissue "System Conveyance Issue" true true false 50 Text 0 0,First,#;syscleaningissue "System Cleaning Issue" true true false 50 Text 0 0,First,#;recommendedaction "Recommended Action" true true false 100 Text 0 0,First,#;risktoproperty "Risk to Property" true true false 24 Text 0 0,First,#;risktopavement "Risk to Pavement" true true false 24 Text 0 0,First,#;assetcondition "Asset Condition" true true false 2 Short 0 0,First,#;gencomments "General Comments" true true false 512 Text 0 0,First,#;creekname "Creek Basin Name" true true false 70 Text 0 0,First,#;workordercount "Work Order Count" true true false 2 Short 0 0,First,#;priorityscore "Priority Score" true true false 8 Double 0 0,First,#;replacementcost "Replacement Cost" true true false 8 Double 0 0,First,#;nextactioncost "Next Action Cost" true true false 8 Double 0 0,First,#;lengthft "Length (ft)" true true false 8 Double 0 0,First,#;globalid "Global ID" false false true 38 GlobalID 0 0,First,#;creationdate "Creation date" true true false 8 Date 0 0,First,#;creator "Creator" true true false 255 Text 0 0,First,#;lastupdate "Last update" true true false 8 Date 0 0,First,#;updatedby "Updated by" true true false 255 Text 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#" # "SymbolID = 0" # NOT_UPDATE_GEOMETRY CalculateField NewData\Culverts assetcondition 4 Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts assetcondition 4 Python # Text NO_ENFORCE_DOMAINS Append 'NewData\Group 1\Polylines G1' NewData\Culverts "Use the field map to reconcile field differences" "assettype "Asset type" true true false 2 Short 0 0,First,#;assetid "Asset ID" true true false 64 Text 0 0,First,#;material "Material" true true false 2 Short 0 0,First,#;diameter "Diameter" true true false 8 Double 0 0,First,#;upelev "Upstream Elevation" true true false 8 Double 0 0,First,#;downelev "Downstream Elevation" true true false 8 Double 0 0,First,#;slope "Slope" true true false 8 Double 0 0,First,#;installdate "Install Date" true true false 8 Date 0 0,First,#;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#;ownedby "Owned By" true true false 2 Short 0 0,First,#;maintby "Maintained By" true true false 2 Short 0 0,First,#;notes "Notes" true true false 2000 Text 0 0,First,#;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#;status "Status" true true false 255 Text 0 0,First,#;existingwo "Existing Work Order" true true false 24 Text 0 0,First,#;inspectiondate "Inspection Date" true true false 8 Date 0 0,First,#;ditchbottomwidth "Ditch Bottom Width (ft)" true true false 8 Double 0 0,First,#;ditchdepth "Ditch Depth" true true false 8 Double 0 0,First,#;bedmaterial "Bed Material" true true false 50 Text 0 0,First,#;obswaterlevel "Standing Water" true true false 50 Text 0 0,First,#;sedimentaccumulation "Sediment Accumulation" true true false 255 Text 0 0,First,#;stormprobseverity "Storm Problem Severity" true true false 50 Text 0 0,First,#;erosion "Erosion" true true false 50 Text 0 0,First,#;sysconveyanceissue "System Conveyance Issue" true true false 50 Text 0 0,First,#;syscleaningissue "System Cleaning Issue" true true false 50 Text 0 0,First,#;recommendedaction "Recommended Action" true true false 100 Text 0 0,First,#;risktoproperty "Risk to Property" true true false 24 Text 0 0,First,#;risktopavement "Risk to Pavement" true true false 24 Text 0 0,First,#;assetcondition "Asset Condition" true true false 2 Short 0 0,First,#;gencomments "General Comments" true true false 512 Text 0 0,First,#;creekname "Creek Basin Name" true true false 70 Text 0 0,First,#;workordercount "Work Order Count" true true false 2 Short 0 0,First,#;priorityscore "Priority Score" true true false 8 Double 0 0,First,#;replacementcost "Replacement Cost" true true false 8 Double 0 0,First,#;nextactioncost "Next Action Cost" true true false 8 Double 0 0,First,#;lengthft "Length (ft)" true true false 8 Double 0 0,First,#;globalid "Global ID" false false true 38 GlobalID 0 0,First,#;creationdate "Creation date" true true false 8 Date 0 0,First,#;creator "Creator" true true false 255 Text 0 0,First,#;lastupdate "Last update" true true false 8 Date 0 0,First,#;updatedby "Updated by" true true false 255 Text 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#" # "SymbolID = 2" # NOT_UPDATE_GEOMETRY CalculateField NewData\Culverts assetcondition 2 Python # Text NO_ENFORCE_DOMAINS Append 'NewData\Group 2\Polylines G2' NewData\Culverts "Use the field map to reconcile field differences" "assettype "Asset type" true true false 2 Short 0 0,First,#;assetid "Asset ID" true true false 64 Text 0 0,First,#;material "Material" true true false 2 Short 0 0,First,#;diameter "Diameter" true true false 8 Double 0 0,First,#;upelev "Upstream Elevation" true true false 8 Double 0 0,First,#;downelev "Downstream Elevation" true true false 8 Double 0 0,First,#;slope "Slope" true true false 8 Double 0 0,First,#;installdate "Install Date" true true false 8 Date 0 0,First,#;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#;ownedby "Owned By" true true false 2 Short 0 0,First,#;maintby "Maintained By" true true false 2 Short 0 0,First,#;notes "Notes" true true false 2000 Text 0 0,First,#;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#;status "Status" true true false 255 Text 0 0,First,#;existingwo "Existing Work Order" true true false 24 Text 0 0,First,#;inspectiondate "Inspection Date" true true false 8 Date 0 0,First,#;ditchbottomwidth "Ditch Bottom Width (ft)" true true false 8 Double 0 0,First,#;ditchdepth "Ditch Depth" true true false 8 Double 0 0,First,#;bedmaterial "Bed Material" true true false 50 Text 0 0,First,#;obswaterlevel "Standing Water" true true false 50 Text 0 0,First,#;sedimentaccumulation "Sediment Accumulation" true true false 255 Text 0 0,First,#;stormprobseverity "Storm Problem Severity" true true false 50 Text 0 0,First,#;erosion "Erosion" true true false 50 Text 0 0,First,#;sysconveyanceissue "System Conveyance Issue" true true false 50 Text 0 0,First,#;syscleaningissue "System Cleaning Issue" true true false 50 Text 0 0,First,#;recommendedaction "Recommended Action" true true false 100 Text 0 0,First,#;risktoproperty "Risk to Property" true true false 24 Text 0 0,First,#;risktopavement "Risk to Pavement" true true false 24 Text 0 0,First,#;assetcondition "Asset Condition" true true false 2 Short 0 0,First,#;gencomments "General Comments" true true false 512 Text 0 0,First,#;creekname "Creek Basin Name" true true false 70 Text 0 0,First,#;workordercount "Work Order Count" true true false 2 Short 0 0,First,#;priorityscore "Priority Score" true true false 8 Double 0 0,First,#;replacementcost "Replacement Cost" true true false 8 Double 0 0,First,#;nextactioncost "Next Action Cost" true true false 8 Double 0 0,First,#;lengthft "Length (ft)" true true false 8 Double 0 0,First,#;globalid "Global ID" false false true 38 GlobalID 0 0,First,#;creationdate "Creation date" true true false 8 Date 0 0,First,#;creator "Creator" true true false 255 Text 0 0,First,#;lastupdate "Last update" true true false 8 Date 0 0,First,#;updatedby "Updated by" true true false 255 Text 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#" # "SymbolID = 2" # NOT_UPDATE_GEOMETRY CalculateField NewData\Culverts assetcondition 2 Python # Text NO_ENFORCE_DOMAINS Append 'NewData\Group 2\Polylines G2' NewData\Culverts "Use the field map to reconcile field differences" "assettype "Asset type" true true false 2 Short 0 0,First,#;assetid "Asset ID" true true false 64 Text 0 0,First,#;material "Material" true true false 2 Short 0 0,First,#;diameter "Diameter" true true false 8 Double 0 0,First,#;upelev "Upstream Elevation" true true false 8 Double 0 0,First,#;downelev "Downstream Elevation" true true false 8 Double 0 0,First,#;slope "Slope" true true false 8 Double 0 0,First,#;installdate "Install Date" true true false 8 Date 0 0,First,#;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#;ownedby "Owned By" true true false 2 Short 0 0,First,#;maintby "Maintained By" true true false 2 Short 0 0,First,#;notes "Notes" true true false 2000 Text 0 0,First,#;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#;status "Status" true true false 255 Text 0 0,First,#;existingwo "Existing Work Order" true true false 24 Text 0 0,First,#;inspectiondate "Inspection Date" true true false 8 Date 0 0,First,#;ditchbottomwidth "Ditch Bottom Width (ft)" true true false 8 Double 0 0,First,#;ditchdepth "Ditch Depth" true true false 8 Double 0 0,First,#;bedmaterial "Bed Material" true true false 50 Text 0 0,First,#;obswaterlevel "Standing Water" true true false 50 Text 0 0,First,#;sedimentaccumulation "Sediment Accumulation" true true false 255 Text 0 0,First,#;stormprobseverity "Storm Problem Severity" true true false 50 Text 0 0,First,#;erosion "Erosion" true true false 50 Text 0 0,First,#;sysconveyanceissue "System Conveyance Issue" true true false 50 Text 0 0,First,#;syscleaningissue "System Cleaning Issue" true true false 50 Text 0 0,First,#;recommendedaction "Recommended Action" true true false 100 Text 0 0,First,#;risktoproperty "Risk to Property" true true false 24 Text 0 0,First,#;risktopavement "Risk to Pavement" true true false 24 Text 0 0,First,#;assetcondition "Asset Condition" true true false 2 Short 0 0,First,#;gencomments "General Comments" true true false 512 Text 0 0,First,#;creekname "Creek Basin Name" true true false 70 Text 0 0,First,#;workordercount "Work Order Count" true true false 2 Short 0 0,First,#;priorityscore "Priority Score" true true false 8 Double 0 0,First,#;replacementcost "Replacement Cost" true true false 8 Double 0 0,First,#;nextactioncost "Next Action Cost" true true false 8 Double 0 0,First,#;lengthft "Length (ft)" true true false 8 Double 0 0,First,#;globalid "Global ID" false false true 38 GlobalID 0 0,First,#;creationdate "Creation date" true true false 8 Date 0 0,First,#;creator "Creator" true true false 255 Text 0 0,First,#;lastupdate "Last update" true true false 8 Date 0 0,First,#;updatedby "Updated by" true true false 255 Text 0 0,First,#;created_user "created_user" true true false 255 Text 0 0,First,#;created_date "created_date" true true false 8 Date 0 0,First,#;last_edited_user "last_edited_user" true true false 255 Text 0 0,First,#;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#" # "SymbolID = 0" # NOT_UPDATE_GEOMETRY CalculateField NewData\Culverts assetcondition 4 Python # Text NO_ENFORCE_DOMAINS AlterField NewData\Culverts priorityscore likelihoodoffailure LOF # 8 NULLABLE DO_NOT_CLEAR AddField NewData\Culverts nextaction Text # # 50 "Next Action Needed" NULLABLE NON_REQUIRED # AddField NewData\Culverts businessriskscore "Short (16-bit integer)" # # # BRE NULLABLE NON_REQUIRED # AddField NewData\Culverts consequenceoffailure "Long (32-bit integer)" # # # COF NULLABLE NON_REQUIRED # DeleteField NewData\Culverts consequenceoffailure "Delete Fields" AddField NewData\Culverts consequenceoffailure "Double (64-bit floating point)" # # # COF NULLABLE NON_REQUIRED # DeleteField NewData\Culverts nextaction "Delete Fields" CalculateField NewData\Culverts recommendedaction 'Inspection' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts replacementcost "$feature.lengthft * 500" Arcade # Text NO_ENFORCE_DOMAINS CalculateGeometryAttributes NewData\Culverts "lengthft LENGTH_GEODESIC" "US Survey Feet" # PROJCS["NAD_1983_StatePlane_Kansas_North_FIPS_1501_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["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1312333.333333333],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-98.0],PARAMETER["Standard_Parallel_1",38.71666666666667],PARAMETER["Standard_Parallel_2",39.78333333333333],PARAMETER["Latitude_Of_Origin",38.33333333333334],UNIT["Foot_US",0.3048006096012192]] "Same as input" CalculateField NewData\Culverts replacementcost "$feature.lengthft * 500" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts nextactioncost "//define formula for "Needs Design" recommended action var needsDesign = IIF(($feature.lengthft * 500) < 10000, 10000, $feature.lengthft * 500); //If recommended action is "Requires Cleaning" the following calculation is applied If($feature.recommendedaction == 'Requires Cleaning') Return ($feature.lengthft * 15); //If recommended action is "Needs Design" the following calculation is applied using the variable defined above Else If($feature.recommendedaction == 'Needs Design') Return needsDesign; //If the recommended action is "Inspection" apply the following calculation Else If($feature.recommendedaction == 'Inspection') Return ($feature.lengthft * 2) //for all other recommended action entries, apply zero costs Else Return 0;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts likelihoodoffailure "//The following variables are set to calculate each individual category score //Settling Present/Driveway Impact Category var setPres = IIf($feature.settlingpres == 'Yes - Significant', 2, IIF($feature.settlingpres == 'Yes - Minor', 1, 0)); //Sediment accumuulation category var sedAccum = IIF($feature.settlingpres == 'Yes', 1, 0) //Consequence of Failure Category //var stormProb = IIF($feature.stormprobseverity == 'High', 1, IIF($feature.stormprobseverity == 'Medium', 0.5, 0)); //Erosion Category var erosion = IIF($feature.erosion == 'High', 2, IIF($feature.erosion == 'Medium', 1, IIF($feature.erosion == 'Low', 0.5,0))); //System Maintenance Category var sysCleanIss = IIF($feature.syscleaningissue == 'High', 2, IIF($feature.syscleaningissue == 'Medium', 1, IIF($feature.syscleaningissue == 'Low', 0.5, 0))); //Asset Condition Category var assCon = IIF($feature.assetcondition == 1, 2, IIF($feature.assetcondition == 2, 1, IIF($feature.assetcondition == 3, 0.5, 0))) //Work Order Count Category var woCount = IIF($feature.workordercount >= 3, 1, IIF($feature.workordercount == 1 || $feature.workordercount == 2, 0.5, 0)) //The following line sums the above individual scores together to calculate the total score return setPres + sedAccum + erosion + sysCleanIss + assCon + woCount;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts likelihoodoffailure "//The following variables are set to calculate each individual category score //Settling Present/Driveway Impact Category var setPres = IIf($feature.settlingpres == 'Yes - Significant', 2, IIF($feature.settlingpres == 'Yes - Minor', 1, 0)); //Sediment accumuulation category var sedAccum = IIF($feature.settlingpres == 'Yes', 1, 0) //Consequence of Failure Category //var stormProb = IIF($feature.stormprobseverity == 'High', 1, IIF($feature.stormprobseverity == 'Medium', 0.5, 0)); //Erosion Category var erosion = IIF($feature.erosion == 'High', 2, IIF($feature.erosion == 'Medium', 1, IIF($feature.erosion == 'Low', 0.5,0))); //System Maintenance Category var sysCleanIss = IIF($feature.syscleaningissue == 'High', 2, IIF($feature.syscleaningissue == 'Medium', 1, IIF($feature.syscleaningissue == 'Low', 0.5, 0))); //Asset Condition Category var assCon = IIF($feature.assetcondition == 1, 2, IIF($feature.assetcondition == 2, 1, IIF($feature.assetcondition == 3, 0.5, 0))) //Work Order Count Category var woCount = IIF($feature.workordercount >= 3, 1, IIF($feature.workordercount == 1 || $feature.workordercount == 2, 0.5, 0)) //The following line sums the above individual scores together to calculate the total score return setPres + sedAccum + erosion + sysCleanIss + assCon + woCount;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts likelihoodoffailure "//The following variables are set to calculate each individual category score //Sediment accumuulation category //var sedAccum = IIF($feature.settlingpres == 'Yes', 1, 0) //Erosion Category var erosion = IIF($feature.erosion == 'High', 2, IIF($feature.erosion == 'Medium', 1, IIF($feature.erosion == 'Low', 0.5,0))); //Settling Present/Driveway Impact Category var setPres = IIf($feature.settlingpres == 'Yes - Significant', 2, IIF($feature.settlingpres == 'Yes - Minor', 1, 0)); //Consequence of Failure Category //var stormProb = IIF($feature.stormprobseverity == 'High', 1, IIF($feature.stormprobseverity == 'Medium', 0.5, 0)); //System Maintenance Category var sysCleanIss = IIF($feature.syscleaningissue == 'High', 2, IIF($feature.syscleaningissue == 'Medium', 1, IIF($feature.syscleaningissue == 'Low', 0.5, 0))); //Asset Condition Category var assCon = IIF($feature.assetcondition == 1, 2, IIF($feature.assetcondition == 2, 1, IIF($feature.assetcondition == 3, 0.5, 0))) //Work Order Count Category var woCount = IIF($feature.workordercount >= 3, 1, IIF($feature.workordercount == 1 || $feature.workordercount == 2, 0.5, 0)) //The following line sums the above individual scores together to calculate the total score return setPres + erosion + sysCleanIss + assCon + woCount;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts likelihoodoffailure "//The following variables are set to calculate each individual category score //Sediment accumuulation category var sedAccum = IIF($feature.sedimentaccumulation == 'Yes', 1, 0) //Erosion Category var erosion = IIF($feature.erosion == 'High', 2, IIF($feature.erosion == 'Medium', 1, IIF($feature.erosion == 'Low', 0.5,0))); //Settling Present/Driveway Impact Category var setPres = IIf($feature.settlingpres == 'Yes - Significant', 2, IIF($feature.settlingpres == 'Yes - Minor', 1, 0)); //Consequence of Failure Category //var stormProb = IIF($feature.stormprobseverity == 'High', 1, IIF($feature.stormprobseverity == 'Medium', 0.5, 0)); //System Maintenance Category var sysCleanIss = IIF($feature.syscleaningissue == 'High', 2, IIF($feature.syscleaningissue == 'Medium', 1, IIF($feature.syscleaningissue == 'Low', 0.5, 0))); //Asset Condition Category var assCon = IIF($feature.assetcondition == 1, 2, IIF($feature.assetcondition == 2, 1, IIF($feature.assetcondition == 3, 0.5, 0))) //Work Order Count Category var woCount = IIF($feature.workordercount >= 3, 1, IIF($feature.workordercount == 1 || $feature.workordercount == 2, 0.5, 0)) //The following line sums the above individual scores together to calculate the total score return setPres + sedAccum + erosion + sysCleanIss + assCon + woCount;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts likelihoodoffailure "//The following variables are set to calculate each individual category score //Sediment accumuulation category var sedAccum = IIF($feature.sedimentaccumulation == 'Yes', 1, 0) //Erosion Category var erosion = IIF($feature.erosion == 'High', 2, IIF($feature.erosion == 'Medium', 1, IIF($feature.erosion == 'Low', 0.5,0))); //Settling Present/Driveway Impact Category var setPres = IIf($feature.settlingpres == 'Yes - Significant', 2, IIF($feature.settlingpres == 'Yes - Minor', 1, 0)); //Consequence of Failure Category //var stormProb = IIF($feature.stormprobseverity == 'High', 1, IIF($feature.stormprobseverity == 'Medium', 0.5, 0)); //System Maintenance Category var sysCleanIss = IIF($feature.syscleaningissue == 'High', 2, IIF($feature.syscleaningissue == 'Medium', 1, IIF($feature.syscleaningissue == 'Low', 0.5, 0))); //Asset Condition Category var assCon = IIF($feature.assetcondition == 1, 2, IIF($feature.assetcondition == 2, 1, IIF($feature.assetcondition == 3, 0.5, 0))) //Work Order Count Category var woCount = IIF($feature.workordercount >= 3, 1, IIF($feature.workordercount == 1 || $feature.workordercount == 2, 0.5, 0)) //The following line sums the above individual scores together to calculate the total score return setPres + sedAccum + erosion + sysCleanIss + assCon + woCount;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts consequenceoffailure "If($feature.stormprobseverity == 'High') Return 10; Else If($feature.stormprobseverity == 'Medium') Return 5; Else If($feature.stormprobseverity == 'Low') Return 2 Else Return 0;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts likelihoodoffailure "//The following variables are set to calculate each individual category score //Sediment accumuulation category var sedAccum = IIF($feature.sedimentaccumulation == 'Yes', 1, 0) //Erosion Category var erosion = IIF($feature.erosion == 'High', 2, IIF($feature.erosion == 'Medium', 1, IIF($feature.erosion == 'Low', 0.5,0))); //Settling Present/Driveway Impact Category var setPres = IIf($feature.settlingpres == 'Yes - Significant', 2, IIF($feature.settlingpres == 'Yes - Minor', 1, 0)); //Consequence of Failure Category //var stormProb = IIF($feature.stormprobseverity == 'High', 1, IIF($feature.stormprobseverity == 'Medium', 0.5, 0)); //System Maintenance Category var sysCleanIss = IIF($feature.syscleaningissue == 'High', 2, IIF($feature.syscleaningissue == 'Medium', 1, IIF($feature.syscleaningissue == 'Low', 0.5, 0))); //Asset Condition Category var assCon = IIF($feature.assetcondition == 1, 2, IIF($feature.assetcondition == 2|| $feature.assetcondition == 3, 1, IIF($feature.assetcondition == 4 || $feature.assetcondition == 5, 0.5, 0))) //Work Order Count Category var woCount = IIF($feature.workordercount >= 3, 1, IIF($feature.workordercount == 1 || $feature.workordercount == 2, 0.5, 0)) //The following line sums the above individual scores together to calculate the total score return setPres + sedAccum + erosion + sysCleanIss + assCon + woCount;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts assetid "var beginNum = 2000 Return 'CT-'+ Text((beginNum + $feature.OBJECTID),'0000');" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts assetid "var beginNum = 2000 Return 'CT-'+ Text((beginNum + $feature.OBJECTID),'0000');" Arcade # Text NO_ENFORCE_DOMAINS DeleteField NewData\Culverts businessriskscore "Delete Fields" AddField NewData\Culverts businessriskexposure "Double (64-bit floating point)" # # # BRE NULLABLE NON_REQUIRED # CalculateField NewData\Culverts consequenceoffailure "If($feature.stormprobseverity == 'High') Return 10; Else If($feature.stormprobseverity == 'Medium') Return 5; Else If($feature.stormprobseverity == 'Low' || $feature.stormprobseverity == 'NA') Return 2 Else Return 0;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts standwater 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts sedimentaccumulation 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts stormprobseverity 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts erosion 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts settlingpres 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts sysconveyanceissue 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts settlingpres 'Unknown' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts syscleaningissue 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts syscleaningissue 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts risktoproperty 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts risktopavement 'NA' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts workordercount 0 Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts consequenceoffailure "If($feature.stormprobseverity == 'High') Return 10; Else If($feature.stormprobseverity == 'Medium') Return 5; Else If($feature.stormprobseverity == 'Low' || $feature.stormprobseverity == 'NA') Return 2 Else Return 0;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turner Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'Turkey Creek' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname 'UNION PACIFIC BOTTOMS' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname "return UPPER($feature.creekname)" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts creekname "return UPPER($feature.creekname)" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts consequenceoffailure "If($feature.stormprobseverity == 'High') Return 10; Else If($feature.stormprobseverity == 'Medium') Return 5; Else If($feature.stormprobseverity == 'Low' || $feature.stormprobseverity == 'NA') Return 2 Else Return 0;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts businessriskexposure "!likelihoodoffailure! * !consequenceoffailure!" Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts businessriskexposure "!likelihoodoffailure! * !consequenceoffailure!" Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts recommendedaction 'No Action' Python # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts likelihoodoffailure "//The following variables are set to calculate each individual category score //Sediment accumuulation category var sedAccum = IIF($feature.sedimentaccumulation == 'Yes', 1, 0) //Erosion Category var erosion = IIF($feature.erosion == 'High' || $feature.erosion == 'Medium', 1, IIF($feature.erosion == 'Low', 0.5, 0)); //Settling Present/Driveway Impact Category var setPres = IIf($feature.settlingpres == 'Yes - Significant', 1, IIF($feature.settlingpres == 'Yes - Minor', 0.5, 0)); //System Maintenance Category var sysCleanIss = IIF($feature.syscleaningissue == 'High', 1, IIF($feature.syscleaningissue == 'Medium', 0.5, 0)); //Asset Condition Category var assCon = IIF($feature.assetcondition == 1, 5, IIF($feature.assetcondition == 2, 2, IIF($feature.assetcondition == 3, 1, IIF($feature.assetcondition == 4 || $feature.assetcondition == 5, 0.5, 0)))) //Work Order Count Category var woCount = IIF($feature.workordercount >= 3, 1, IIF($feature.workordercount == 1 || $feature.workordercount == 2, 0.5, 0)) //The following line sums the above individual scores together to calculate the total score return setPres + sedAccum + erosion + sysCleanIss + assCon + woCount;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts consequenceoffailure "If($feature.stormprobseverity == 'High') Return 10; Else If($feature.stormprobseverity == 'Medium') Return 5; Else If($feature.stormprobseverity == 'Low') Return 2 Else IF($feature.stormprobseverity == 'NA') Return 1; Else Return 0;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts businessriskexposure "Return ($feature.likelihoodoffailure * $feature.consequenceoffailure);" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts nextactioncost "//define formula for "Needs Design" recommended action var needsDesignAsset = IIF(($feature.lengthft * 500) < 10000, 10000, $feature.lengthft * 500); //define cost formula for "Requires Cleaning" recommended action var cleaning = IIF(($feature.lengthft *15) < 1000, 1000, $feature.lengthft * 15) //define cost formula for "Inspection" recommended action var inspection = IIF(($feature.lengthft * 7) < 350, 350, $feature.lengthft * 7) //Check for "Requires Cleaning" and if present, calculate cost value If($feature.recommendedaction == 'Requires Cleaning') Return cleaning; //Check for recommended action is "Needs Design" or "Needs Ditching Asset" and if present, calculate cost value Else If($feature.recommendedaction == 'Needs Design' || $feature.recommendedaction == 'Needs Ditching Asset') Return needsDesignAsset; //Check for recommended action is "Inspection" and if present, calculate cost value Else If($feature.recommendedaction == 'Inspection') Return inspection; //Check for recommended action is "End Section/Headwall" and apply constant cost Else If($feature.recommendedaction == 'End Section/Headwall') Return 3500; //Check for recommended action is "No Action" and if present, calculate cost value Else If($feature.recommendedaction == 'No Action') Return 0; //for all other recommended action entries, including "Other" category. The value of -99 is used as a flag in the database to find invalid entries. If "Other" is present, should try to fit into another category or create one Else Return -99;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts likelihoodoffailure "//The following variables are set to calculate each individual category score //Sediment accumuulation category var sedAccum = IIF($feature.sedimentaccumulation == 'Yes', 0.5, 0) //Erosion Category var erosion = IIF($feature.erosion == 'High' || $feature.erosion == 'Medium', 1, IIF($feature.erosion == 'Low', 0.5, 0)); //Settling Present/Driveway Impact Category var setPres = IIf($feature.settlingpres == 'Yes - Significant', 1, IIF($feature.settlingpres == 'Yes - Minor', 0.5, 0)); //System Maintenance Category var sysCleanIss = IIF($feature.syscleaningissue == 'High' || $feature.syscleaningissue == 'Medium', 0.5, 0); //Asset Condition Category var assCon = IIF($feature.assetcondition == 1, 5, IIF($feature.assetcondition == 2, 2, IIF($feature.assetcondition == 3, 1, IIF($feature.assetcondition == 4 || $feature.assetcondition == 5, 0.5, 0)))) //Work Order Count Category var woCount = IIF($feature.workordercount >= 3, 2, IIF($feature.workordercount == 1 || $feature.workordercount == 2, 1, 0)) //The following line sums the above individual scores together to calculate the total score return setPres + sedAccum + erosion + sysCleanIss + assCon + woCount;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts businessriskexposure "Return ($feature.likelihoodoffailure * $feature.consequenceoffailure);" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts nextactioncost "//define formula for "Needs Design" or "Needs Ditching Asset" values in recommended action var needsDesignAsset = IIF(($feature.lengthft * 500) < 10000, 10000, $feature.lengthft * 500); //define formula for "Requires Cleaning" values in recommended action var requiresClean = IIF(($feature.lengthft * 15) < 1000, 1000, $feature.lengthft * 15); //define formula for "Inspection" values in recommended action var inspect = IIF(($feature.lengthft * 7) < 350, 350, IIF(($feature.lengthft * 7) > 2500, 2500, $feature.lengthft * 7)); //If recommended action is "Needs Design" or "Needs Ditching Asset" the following calculation is applied using the variable defined above If($feature.recommendedaction == 'Needs Design' || $feature.recommendedaction == 'Needs Ditching Asset') Return needsDesignAsset; //If recommended action is "End Section/Headwall" the following is applied Else If($feature.recommendedaction == 'End Section/Headwall') Return 3500; //If recommended action is "Requires Cleaning" the following calculation is applied If($feature.recommendedaction == 'Requires Cleaning') Return requiresClean; //If the recommended action is "Inspection" apply the following calculation Else If($feature.recommendedaction == 'Inspection') Return inspect; //for all other recommended action entries, apply zero costs Else Return 0;" Arcade # Text NO_ENFORCE_DOMAINS CalculateField NewData\Culverts nextactioncost "//define formula for "Needs Design" or "Needs Ditching Asset" values in recommended action var needsDesignAsset = IIF(($feature.lengthft * 500) < 10000, 10000, $feature.lengthft * 500); //define formula for "Requires Cleaning" values in recommended action var requiresClean = IIF(($feature.lengthft * 15) < 1000, 1000, $feature.lengthft * 15); //define formula for "Inspection" values in recommended action var inspect = IIF(($feature.lengthft * 7) < 350, 350, IIF(($feature.lengthft * 7) > 2500, 2500, $feature.lengthft * 7)); //If recommended action is "Needs Design" or "Needs Ditching Asset" the following calculation is applied using the variable defined above If($feature.recommendedaction == 'Needs Design' || $feature.recommendedaction == 'Needs Ditching Asset') Return needsDesignAsset; //If recommended action is "End Section/Headwall" the following is applied Else If($feature.recommendedaction == 'End Section/Headwall') Return 3500; //If recommended action is "Requires Cleaning" the following calculation is applied If($feature.recommendedaction == 'Requires Cleaning') Return requiresClean; //If the recommended action is "Inspection" apply the following calculation Else If($feature.recommendedaction == 'Inspection') Return inspect; //Check for recommended action is "No Action" and if present, calculate cost value Else If($feature.recommendedaction == 'No Action') Return 0; //for all other recommended action entries, including "Other" category. The value of -99 is used as a flag in the database to find invalid entries. If "Other" is present, should try to fit into another category or create one Else Return -99;" ARCADE # TEXT NO_ENFORCE_DOMAINS DeleteField NewData\Culverts DBO_Culverts_Final_nextactionco DELETE_FIELDS ExportFeatures NewData\Culverts S:\UG_of_Wyandotte_KC\Maps\GoogleEarthDataReview\UG_Final_DitchCulvert_12102024.gdb\Culvert # NOT_USE_ALIAS "assettype "Asset type" true true false 2 Short 0 0,First,#,NewData\Culverts,assettype,-1,-1;assetid "Asset ID" true true false 64 Text 0 0,First,#,NewData\Culverts,assetid,0,63;material "Material" true true false 2 Short 0 0,First,#,NewData\Culverts,material,-1,-1;pipeshape "Culvert Shape" true true false 2 Short 0 0,First,#,NewData\Culverts,pipeshape,-1,-1;diameter "Diameter" true true false 8 Double 0 0,First,#,NewData\Culverts,diameter,-1,-1;width "Width" true true false 8 Double 0 0,First,#,NewData\Culverts,width,-1,-1;height "Height" true true false 8 Double 0 0,First,#,NewData\Culverts,height,-1,-1;wall "Wall" true true false 2 Short 0 0,First,#,NewData\Culverts,wall,-1,-1;upelev "Upstream Elevation" true true false 8 Double 0 0,First,#,NewData\Culverts,upelev,-1,-1;downelev "Downstream Elevation" true true false 8 Double 0 0,First,#,NewData\Culverts,downelev,-1,-1;slope "Slope" true true false 8 Double 0 0,First,#,NewData\Culverts,slope,-1,-1;installdate "Install Date" true true false 8 Date 0 0,First,#,NewData\Culverts,installdate,-1,-1;lifecyclestatus "Lifecycle Status" true true false 2 Short 0 0,First,#,NewData\Culverts,lifecyclestatus,-1,-1;ownedby "Owned By" true true false 2 Short 0 0,First,#,NewData\Culverts,ownedby,-1,-1;maintby "Maintained By" true true false 2 Short 0 0,First,#,NewData\Culverts,maintby,-1,-1;notes "Notes" true true false 2000 Text 0 0,First,#,NewData\Culverts,notes,0,1999;spatialsource "Spatial Source" true true false 2 Short 0 0,First,#,NewData\Culverts,spatialsource,-1,-1;spatialconfidence "Spatial Confidence" true true false 2 Short 0 0,First,#,NewData\Culverts,spatialconfidence,-1,-1;status "Status" true true false 50 Text 0 0,First,#,NewData\Culverts,status,0,49;existingwo "Existing Work Order" true true false 24 Text 0 0,First,#,NewData\Culverts,existingwo,0,23;inspectiondate "Inspection Date" true true false 8 Date 0 0,First,#,NewData\Culverts,inspectiondate,-1,-1;standwater "Standing Water" true true false 24 Text 0 0,First,#,NewData\Culverts,standwater,0,23;sedimentaccumulation "Sediment Accumulation" true true false 24 Text 0 0,First,#,NewData\Culverts,sedimentaccumulation,0,23;stormprobseverity "Storm Problem Severity" true true false 50 Text 0 0,First,#,NewData\Culverts,stormprobseverity,0,49;erosion "Erosion" true true false 50 Text 0 0,First,#,NewData\Culverts,erosion,0,49;settlingpres "Settling Present" true true false 50 Text 0 0,First,#,NewData\Culverts,settlingpres,0,49;sysconveyanceissue "System Conveyance Issue" true true false 50 Text 0 0,First,#,NewData\Culverts,sysconveyanceissue,0,49;syscleaningissue "System Cleaning Issue" true true false 50 Text 0 0,First,#,NewData\Culverts,syscleaningissue,0,49;recommendedaction "Recommended Action" true true false 100 Text 0 0,First,#,NewData\Culverts,recommendedaction,0,99;risktoproperty "Risk to Property" true true false 24 Text 0 0,First,#,NewData\Culverts,risktoproperty,0,23;risktopavement "Risk to Pavement" true true false 24 Text 0 0,First,#,NewData\Culverts,risktopavement,0,23;assetcondition "Asset Condition" true true false 2 Short 0 0,First,#,NewData\Culverts,assetcondition,-1,-1;gencomments "General Comments" true true false 512 Text 0 0,First,#,NewData\Culverts,gencomments,0,511;creekname "Creek Basin Name" true true false 70 Text 0 0,First,#,NewData\Culverts,creekname,0,69;workordercount "Work Order Count" true true false 2 Short 0 0,First,#,NewData\Culverts,workordercount,-1,-1;globalid "Global ID" false false true 38 GlobalID 0 0,First,#,NewData\Culverts,globalid,-1,-1;lengthft "Length (ft)" true true false 8 Double 0 0,First,#,NewData\Culverts,lengthft,-1,-1;replacementcost "Replacement Cost" true true false 8 Double 0 0,First,#,NewData\Culverts,replacementcost,-1,-1;nextactioncost "Next Action Cost" true true false 8 Double 0 0,First,#,NewData\Culverts,nextactioncost,-1,-1;likelihoodoffailure "LOF" true true false 8 Double 0 0,First,#,NewData\Culverts,likelihoodoffailure,-1,-1;consequenceoffailure "COF" true true false 8 Double 0 0,First,#,NewData\Culverts,consequenceoffailure,-1,-1;businessriskexposure "BRE" true true false 8 Double 0 0,First,#,NewData\Culverts,businessriskexposure,-1,-1" # 20241210 09572300 20241210 09572300 Esri ArcGIS 13.1.3.41833 Culvert culverts Culverts layer created by TetraTek File Geodatabase Feature Class dataset EPSG 6.18.3(9.3.1.2) 0 Simple FALSE 0 TRUE TRUE Culvert Feature Class 0 OBJECTID OBJECTID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Shape Shape Geometry 0 0 0 Feature geometry. Esri Coordinates defining the features. assettype Asset type SmallInteger 2 0 0 assetid Asset ID String 64 0 0 material Material SmallInteger 2 0 0 pipeshape Culvert Shape SmallInteger 2 0 0 diameter Diameter Double 8 0 0 width Width Double 8 0 0 height Height Double 8 0 0 wall Wall SmallInteger 2 0 0 upelev Upstream Elevation Double 8 0 0 downelev Downstream Elevation Double 8 0 0 slope Slope Double 8 0 0 installdate Install Date Date 8 0 0 lifecyclestatus Lifecycle Status SmallInteger 2 0 0 ownedby Owned By SmallInteger 2 0 0 maintby Maintained By SmallInteger 2 0 0 notes Notes String 2000 0 0 spatialsource Spatial Source SmallInteger 2 0 0 spatialconfidence Spatial Confidence SmallInteger 2 0 0 globalid Global ID GlobalID 38 0 0 status Status String 50 0 0 existingwo Existing Work Order String 24 0 0 inspectiondate Inspection Date Date 8 0 0 risktoproperty Risk to Property String 24 0 0 risktopavement Risk to Pavement String 24 0 0 standwater Standing Water String 24 0 0 sedimentaccumulation Sediment Accumulation String 24 0 0 creekname Creek Basin Name String 70 0 0 workordercount Work Order Count SmallInteger 2 0 0 replacementcost Replacement Cost Double 8 0 0 nextactioncost Next Action Cost Double 8 0 0 lengthft Length (ft) Double 8 0 0 stormprobseverity Storm Problem Severity String 50 0 0 erosion Erosion String 50 0 0 settlingpres Settling Present String 50 0 0 sysconveyanceissue System Conveyance Issue String 50 0 0 assetcondition Asset Condition SmallInteger 2 0 0 syscleaningissue System Cleaning Issue String 50 0 0 recommendedaction Recommended Action String 100 0 0 gencomments General Comments String 512 0 0 likelihoodoffailure LOF Double 8 0 0 consequenceoffailure COF Double 8 0 0 businessriskexposure BRE Double 8 0 0 Shape_Length Shape_Length Double 8 0 0 Length of feature in internal units. Esri Positive real numbers that are automatically generated. 20241210 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3QEY4 OaTsfzphdMjDAfjTt6E/fX86kBQMkntilU/JTTIgwA657DNKvDYoAU9aPShhSdQAKAD/ABpM8049 KQDk0gE2gkZqtNbK8yHJA3Zx7irWMkD8aguZ44TG8hwCSOhP8qaAnICqAPugUdxVU6jaCPJmAGe4 NDajaKjObhMAcmizAs9sY+tQS5jaNzyqtz7Uz+0LVUJLuB1OYm6flTlu4JjsUsc+sbD+Yp2aAs7g QCD1paoo6pgRzKNx+VW4zU4eYnrHj60WAlIJdW7Cq95P5CZwSTxxTmMqjO9Gx/D0qC7ijvLIluR6 dKT0AltrhZbYbARswpzTsg8EflUdpBFBZr5a4DcmlB+QmpYwbIyp/Cqjz3yykJZhk3cHeOlW97ZU A9afuJz8opAZ8N5fSMm+wKAnDEuPlrR4Ay35UobDAYFJuJ9M0wGuPMU549KarFlOeo4Ip+456Cmy ZUiRQM9CPUUAOReeTjHrSSKDxuHX3pC+9QQeKc3IB9aBiNzPgEdKd60z/ltx6VTfT3aSR1u5ULnk CmBeBwaVhyTWeumyBdv2+4+oIq7GhSJY2cuVGCx6n3pABPpUd1bC5hCF2XBBytTHAGT0FMLhRwd2 egFAEVlCIYdu5mOcEsalP72XYOi8n61ApkkmfAwMc4q5boEG3HJpiEwfSl2NUhGDRjNAXIDaQgEC PrwOaeLOA4+Tp709ulPHAxnmmIh+zQhhhB8vIqT0NOxgU0+lIBzdBR0ApB0zSnk0wEGSaXtS8Dik 7UAIOv1qhd3YhmAcqADgZxjkd6v1XuIY5XjEkav1yCM9qEBBdtA8cIUxHMycZH94Ut8sAtio8tSz Kp4HTNSiytsq3lLlec471BqMSCEMEUyMyjBPXmrW6QiefbJbSRBuWjI4PbFRlLsxpEskfIwXxyPw qKcTR2MzC1QHy2HEvOMfSpopLrylItkzgf8ALX/61K2gx72sJtjFIeAOHPUH61BbXnlTC0umUyH/ AFcg6OP6GpbYi7sleZFG8ZYZ461k6nCjXcUltH5ohR96KTxnGGz6jH86cVd2YG+7xp97GfTFVmyz tGqHbIO/FJYt5dnG0zh2K5MnrVhx5iq8bAleQR3qfIBfLIiWMY+UU0QnGCafHKr+zDqD2p+aVgIv IAXGefWjyyo45qWmvIqDJ/ACiwGR5OpFyEuIsDGCyc9eR1qa3jvYpv380boc8BcGrSwO3LNsz2Wl aJ15Vt4HZuv50rDuMBO8DsakPP4U1QGwynGOCD2pzKQtKwyCT5PnXr3HrT1mQxAd89DxTX/4+EPo DVaUzNIqhW2M5ycjgY4xx60xF0ECduB90fzNOyCQCKpQRzxtv4YHjDGpvMmzkxj8DmgCwMZzg/nT Cy8ncPzpqZkHLDbnkClbYo5AAoAbMI5YWR2wpHODyKz4tJikJdpJgrDaBv7Vf2eYQSoCjtjrU3T6 CgClbWUVvcuyF8gAYLZFaEfHNVwP30n0FWIzwR2oAcc54pwyoxTckDJ6U7NMQxjgjPSn0mMj2poZ lXnnFAD39KTrSn5sUf5zQADpikHJFLnrSUAKDQPejtRnvQAneo5kDyRqehz7dqWRWaNlVyjEcMO1 NcESQDeSRnJ9eKAGS28CxfPuCIM/fbj9ax9auPs72MULSRk3MfzEZVlyMjJ9q1r8b4FjJIDyKpx3 BNV9Rs4Cvnuhdt6YDHgYYYxWkHZpsC2baJ23lTnr944/LNO3HjtUh+7j2qgLabcT9smI+i/4VnuN FG1SE2SKYphIQRksQCcnpzVsSx6e0Vrb27OXQudvqMdT+P6Uyzj3xQBmJ2ruB98kf1NOR7k3c0hj EiqxRPmA2rx7Vbd27iMiO5lN2sG4OLbcJVwcHPzevOOn51d+0skUbwShEkJO1RyTgfkKrrES8iyp sClmIX5C/TBz+J/Kn2UiwmUxBbhFUOWY4IB4xj8K3m1y2Rkk3K7NgtmCKSbAdgvI4+bHSnL5wUbX BH+0KppPJPEX2Bo1fP3wNv0OOetaG4LEOe1crujUZmc/ecAewp0YRCGJZmP8RpgkLOU2nGAd349K B15pXY7E/mKSeafVMnBCkHnJzjineYYkdyeAM4ouFgi5DN6sTT8471RW73OUjBy/IBHSpguekRPu WptAADSzPKGHB2gdjTssFUFckHtzTVjbzArEKpGcLxUhhQ4xkEdCDQAkTjGzuDUnaqzbkuFJ5PTI 7irBZdm4nA60mBGsYaeRmJ2jHAOOcU8RIpBxn6nNMjcMZcEE5H8hUjMqgAnHFACnpQeBiojMOg5+ vFMaYsDghf1p8rFzIlT5mdvU4/KplJH071VhCmMFGIYVFOL3zD5S7hj8KVtR30NAtu47UpbFQRLN 5S7kGcc80/bJ/cH/AH1QBNzRilBHamnr+NAhEOGI6U9vQVGeDkde1SfWmJAOKO31oPFAwaBjWOF+ tNAJ57VBez3EOzyIPNBJDc4xVZLzUCf+QeQv++KQzTqvcGXfGIigbnBbOOntVYXl9uANgTn0anW1 1NcPEWtigywJ3g8jg00Ibci9Btw725UzJnap9frTdQF8bXG63zvXHytycj3q0G+1KrR4IjlIOfY8 0+4iaeMKCBh1bP0Oau9mgKsMmoPPJGxthsC5wrd/xp4W5LsrNEIz/dByP1pYXP2x9ylWlQPtPbHH 9anYbTyRUyGinaxx2ixwl9wVCMk+9SQxQwvK4kYmVtxBYcfSq97p8EkeUihVtwJJQetTiyt8qfIi 3Y6hBQwK4Bn1GXExWNY9pTjBJPX8MfrVOTyk36fKCVlwnmBuduSfwq3Np6R+dLGIUJC4ygIGD/hU K6Qn2d2t/KSSWXzt5TIPFWmu4Fa7gNppbW0DyOrzAZdwSBgAAH0q/bzNawmGYfOMLEC2SwA6n8ak trJo2hd/L3ru3+WuASehx60+9iiktpPMQvhT93hvwNJyT0AjtNQWfeJIWiKLlsmpBeqscDSxNGJR zk/dPpT7NT9mjLAqxRSwOeDiiSRWuBCc5Vd+MdRmp0vsAscmZCrLg9R82cimsDNIy7mEY+Ujpk/W sz+zPPntrq3uJUAKuUd2zj0/+tWvF/F7saJJLYCrb6bHavuid8/7TE/zqz+8AI4+tSfjQDUjI1GJ RyScckmpajUZ3/Wh5Ni8csego3EMlOZ1A7A5psoZrYZ2gYBGaXbtYZ5Y5yac5xbKT0ABNNgQ2to8 fMrkkjGAalC75SF4Vep7n2pzSF/li6/3uwp6JsUKKe2rJ3dkIsMa9FB9zzTn/wBW30paRgWRgO4q W29ykktiPy90aleHA4NWIZBImehHBFRREMg/WmsGRvMQ4Pf3qk76Mlq2qLdFQmdlHzRn6imGWduU RQP9rrT5WLmRKvm7ei+lJmX0WpBx06GjFSUZ6vdebgowUD7xzyf/ANVXf3votO+8fUYp1ADP3pHR abmXPRam7UygBreYQQVX86ZvkXjaPzqdumaiUZ5NIYKZCc7Rx71SglDpKIF+aOVsn3Jya0EHzH6V nWULWglPlSO8sskhwc8Fjj9MVS2ETWSyRwsoRRmRmI6Yyc0h1Apei3MRHIBc8DJHA+tV7fzbeSWR rWQM8jE5YEEE8d6zbqO8l1Y3kcTCDehdFYMSq9eBVqKbdwNq4k8mdZpCFyuwKBkkk54FSlFIB29e 7Dmqiyzz3AnFq6DYVG8jPX0p81vJexmOUyxgcgqQCSPcVDQCu4V3gXg7C4yOMD0qNbom0eRhgI2w kH6f41ELSSEMscUrFuGkZgSR7nOajCE6ZchWIxMMg45OV/8ArU0kFyzfFhZsHh81dp469utNtrmQ WUWyB2AjXHHXin3P2kWzjySQQc8jgYqW1jk+yRbSMbBj8qmzsMjS5mYAm3dcjoR0p3NzEQ8YAbgq 1U5NZtYi6yXGxkOMFcZ5x/SrMMjSAurt5ZPDbeD7j2o5WgJwrxoFGMYxTfKYzNKAofbtB9qjjklk kkjGcKfvHGDU2JM7RJ9eKLMGyrFHdW6MXlEhOfzNWlV1UKNvSo3WQRsCeCOuKWF2WNfNPb73ah3E mOkkaKF5GA2opY49BVAa3aNgCYD14JxWoCGGBgjFM2Jj7q/lSGZ8Wq2zrI8c28KwBwPXOP5GpLbU be6upEV/mUYwRjFPYRCbacDGT0+mP61DdXFlasZ5SFDlUyvc89apCdy35gMuF+Y44xQqF48yHgZ+ UVnx6rYn5hckKWKqQpxx70o1O1lX93O0ikgYAxknpRe2wrX3NJCVgQgfwinkN/exVCLVbWa4Nusx EoO3aV/rVqVHIGDu5BKkdRUlEvPTdSg4HPaqttDMg+fard8AAGrDbwP4T2oAawZG3jgE4Ip4Gepz 7VC4c7EJxlulPwySfLlvUE0ASEDHv2oUELxTSzEcIaUMw/gP5igZPtA4yaTaNwGO1Ob+lMbIGR6Y pkjk+6B6U49MDrQo4FIzqp5YD6mgBw4NN7moJ5DJCyxByx7qMfzqvaJdFnZztAJGTzkdv60AaGfl phIAyTimiHIO52P48UghjHRBQAglLBhGjMDxkcVQitLjzgRlUUjvzx1/OtNPvgDgUqYCn/eP86AK rwrvUtliWGcnPerCqBgAVHIfmDdgwJqTPzZpDAnBVqDxj1FI/wDq+eDnIpc9TQIAelZ11CLa3mUZ 2TSBx7HI4/SriknCmkv4ftFo6Z2lcMG9MHNOL1AS6SE27NcKGVFPzYzis271VrSOxNtDLJCy4dtj AKMDBPFLe7pUhJvYpNzFQuwc5B9/b9addfaIdHjZ51CAKHzHnA/OtIpaXAqWt19oKRzwCNvtHykD IYZPPtznr6VpEtNcwqhKIhbeobHA4HHpVLSZYLiLIPmN8ynA4+8T/WtKKDyg2xQNxyxJyTSluFyS RUAB289B60zf5JAZlO7pkgE0qqIlXJ6cD2rPuNOjDeY+9mafK4b7u44JH4GpVtgXdl243vEcKy4G cg06MOTymOO5GDSI5ezyzKzFOSvIzUqEFRzSvYbVxksSFCcKG9jyKqXFpKz5jYnOMknt6VanXjeP UZqQOuP/AK1O3VEp9GQ20Xlq27ls4JoVEaaRSoYYHBH1pfNALAcZOcmmq5EzbEYjAz+tGyHe7Gi1 geRv3ShRjjHQ96VrO3VlXylwfap4gQGLcMTkiiQoSqN1bpUjK/8AZ8An8wgE9uKmiUIzoOnUU+Nt yDPUcUxsI4c9DwaAJM8ZppPGTQGDD5WH4GkGWOPzoAax/fRcdz/I1LkBgcdaaQBOuRxtOKkJ+XoK ADOewqvMlw7gxuqrjpU4YelLn0H60AJctmBlBO8qQAOuap2qXPmtklRzjPOR7+9aCRqinA59TQQM 56UxDFhZl+aR/wADSpDHHwFyfU81ICcAGjbzmgBQMUgPalzxSHgUAA4zQMYoH3aVec0ARn1HGOlR ySqtuzscKpJJqY9eKrvD+5cJkM5IJHOPekMqjVLFo1P2hcPyODzmp4LmKSBXEoIBIPvVH+zrsEL9 qQsWO0eUAMVctrJ7a2HmOJJASSQuMj0ppCb7EpnRs5Zsf7lPV1YfKwPHekBBAIprordOG7EUaBqR T3Qt5ApAOe9XAQ8fOPmHNVDtB/fJnHRhUyspHBGKGrAmmVpbYSwxomFKyckcEDn/AOtViUI1uYnX cpGCD3qFZFiaXcwA3Z/SomuWlV2t1Ejr0BOFH44qkm9WJvoh4RLZoo4okBfJJ6DioIb1nupfNZRE nA2nI/HvnNVZIp7wWTSMGZiTIobC8dh3qy1n9nlb7PGuxlwwz096Gl13KLqkNgjkEZFNnk8u3aUg YQbjn0qHTwRaxguGKoox6cCre0AENgg8YNRazAxXxFM9tHNl5G8yOI56dxmm6dqSRXH2O5ZftUjk LHHzwOp9vWtSK2t4naQYLSEkMTn8qw1QLr8VxJFGsvlssZ3YzlgORjrjNaK0rgb8vzKSjA7T834U qOpQMflycAE1FDKhhYhChkBYhu5qBPKtY8mXI6lm7fSosBaK+a27GFXv6mljYmbP+yP602xl820R mIycnH406H/WN9B/M0tgJyTmqt3J5TxsD8wzirNVbxSQrkLtA7+tCAni6t7mn4HTFMi6H/eP86d7 0DGsiY5UHnFRrE6ksvI9M81PwfpTQ2xDnqBmgRCZszIuCWBzj8KnDgnBG0+hqMQK58xv9YehHaht wIEg3L/eHagCXtigrmovNA6NuA9etPWZCMhh+NIZOWxx3pdpLAk9KaecnHTpS+YAMHgAdaogkIzS E84qn/a1iw4uFz1x9KkhvLaeTZHMrMBnAoGTnijqKOvNJ1pAAOM+lKpwTR1OO1Jj5T7UAHcimhhj HPU0rDIoTlSPemBEvz3OeyCpZGwcA0y1AAf13HNOl+9Tn2JhtcgXhyo78innBI9qZ/y2/wCA1J71 BoNPHbNN8mM4LLgk44pScsB+tKQcde+RVJtbEtJ7lV7SGS4dXUnCgjnipoYkjhEaDCr2oJJuFbGN ykVIBg47YpNtjSsRLaxIQwXGDuHPQ054FkBByR0PNPHBI7dqdnapJoGQx28UKbY12jgdfTpTmjVs ZyQDnrVP+2bMfedlyM/MvtmnLqto8yxCT52IAGPfFAEssMJjVGUkAgqAe4qr/Z6PeiWSNQxPynOS OKvoN0rMewwKV+3+8Kd2hCCFB1yx96bJbQyoVdAQ2Mj6dKl701iWbavXufSkMjS1hibei7TjGc9q iV9hYLyxAx+ZqxsHclvrTURRM/HRRRcQoDAA7izdwelJIhlXZgrznNP70/3pJgRRho2ZWOcnIwKk A9O9RynLpj1qQjGBTATjIH502QAQvx/CaWM5JyMUkvEbUAKAQOO1O6ig/dyPSjuKQxcDuKTap/hH 5U6jNAEm4ehpG2ke1MuGmEJMCBpOMBjgVSeTUwxP2WEjHXd3qiS6ttb/APPCLI4zsFKkEKyEpEik 91UA1XtJ7qWEtJAqncR8rcYqdZwpAdShPc9KfKyeZEn8XtQOppeq465NJyMnHJqSgBoJ6+xpu1uO O1RSO4by05cjJ9qaTewm0tyYn0oTCpk+9Rxl0cLJt5HBFNJMx8pTgfxEU1HUTloOteQ8h6MxI+lO fqCaeBhFGO1JIpIFEndjirKxXJUXG3PzbelSAE9qhCYulOegJz35qchj7/WpKEKsf4TRtPcdaROp UmlwSeR+NArkE58p0Y/dGeakWRHAIIweajvE/wBHz12nNPjAMScD7ooGKZFPAG4j0pCX77BnsaeB jrTWjSRgWUEr0PpQBHsXAI8npx8tMnLRwtKkSSMBkKq8mpjbxBVwg4GB9KVVCAADAzQBmQ390Yi5 sZAcklcc1bgknu1JeIw7TwHHWp4f9WD681LketAEZEmMZX8BSoAvT86pyXtwkjKLKRhv2hlPbHWk a8uBHuFlJnOCM/rSGXgOKYo/fSD/AGRVJNTlaZIvsM2WBO7t2/xq6n+vf/dFMB+KBj15oqKMf6VI eOgpCIppCsowPue3XIq03UH2qKRVadMqvfORUpPvzTAav3gM02Z08tlkbbkUqE7iSMccVUv4JJTG 8b7SDtPHXNAFm3cmNQxySOD61KRzUMMJSAIWBcc596csyPkBhlThhnoaAJCeaQjmgMp43D86X8aQ yZWVhlTkUp6Gq/ltGS8fTccr260rebOmAuxT1JPNacpnzdB1qSbdfbipSARggEe9NQbF2jovFDZP 0pN63Q4rSzGGADmNip9AeKWOcElHwrjqPWk+b3qnNaTy3W9bgCPHKEZz1/LtRzX3Dltqi686ID8w LdgKIEKgu/32OTWfbWl1DMGe4VlB5Xb2+taIc5ourWQkm3dkTuftBGMsBhR/WpIY9gx/F1J9TUnb INAFDY0gPXNKxHrSCmnnHGakZX6XH/AP61OBlfwqMAGY9vlpxDDoaBh0lVR3qUjHHaoVI3jJ5qVm wSRk0xEdwo+zydeR2qvbZ+zJnk+tWSzEkAHBqGEfuvxP86Qx4+XApkcnms+Bjadp5p5B9Kits7H4 /jP86AJ2PC/SoW/eP5Y/4EafcOUjGBliOBWatxfQ7wtlvAY7WDcn3NAGjJEskflsPlPpxSG2jZt2 Dn61Ta7vlcAWeQVB+909RSLd6hsD/YgeDld3PtQBejjWPcR39aV8eW30NQWstxIG+0QeUR93nORU z/6tsAk4PAoGNtx+4QDpilT/AFz/AEH9aS3yIEyCDjoaVB++f6CgCSoIwfOlbBwTxmpu9GeKQDJO qv3B/SlJ7dfSlxleelMiU8HsBgUxC4wO/NNk5VQOSWFSswRdzdqYiEHc/wB4/pSCw8Z61Rm0i0ml aYxDzCdxOeCfer5pPUUDKFtp1nFMsiQBZV6E9qvnFNZFbB6MOhqMzMhwyE+4piLUeWUsR3PFPX+7 +NIhGCCR1PemF92VQ5J6kdhTEKJOWVFLY7igu4/5ZH8xT1ULwOmKaxyCDQA3zGwT5R/MUxCfmJRq kIwhC9fU1ImQgB9KAKdu+GmQ7nIbIyDx7U/zNucq2T04pYhiecg9SO+e1SAHd9aQwjkVl2qwzjpT xx71HJGnlZI7U0GREHBYEde4oETZyPam7iO3ao/NxgMrAevWpUZXXggigCFTmfHqv9acWIIpCyi4 HzDO3196V1wc0DGkfvBipQ4JweGxTOgzTQSzDB6c0AyY4xjiq0X3CPRiKtHGKy3vlguZoztzuzgn 2oBF3cFBZiAB3NVo5oYRJuuIz8xP3+ntU7Ks0QDLlWHIIqounWcjnFvHsUnt1J60AWVUyR+ZnJYH HtTlceUSTjA5z2pY4kihVI1CqAcAU3AMhGMhl5FACedF/wA9E55HzVLGysxAYE4zgGozDHkfIvA4 4p6IisSqgEjFACnOaXHFJQPWkMMVEnE0nuBUlRqf37/QUwHvIsa5Y4pB8yjFNmhFxGUfoetO/wBW gAJJNAhepx2FNi+UuvvkVIBhcHBPeoXfy3zjkjGPU0AOPzy7Tyq8n61LTI0KpgnnqTSsQOtAwooB 7jkUtIBhOOR1peD6UpwKaVU9aAJkRXBYqMkmpAAowBUaM2CMc5/CnKdwBPaqJHU0/SnnpTaQDD94 AdSelS9Kj3KrbmIAxwTT85pgQxxbJZGB++c1KuMe+aTIDkmlPykUANk6Edqa5/dgZqR1zj0qIg7D noKTAVAOM80piV/Y+ooChaR5CKAKrWIN4rGRsjLD86tGEerH8ai8xjcA/wCz/WpdzY60XGMeFQM8 0RQrsJ5z9aUscc0iMQWxjFADvKULg5/Oqz2Fu7FmjBJ6+9WdxI601m2qWNAEEsSgKsXyufTsKVC8 ahTGTjupHNSRqeXb7zfpT6AGGVto/dP+n+NRea3n48t/u+1WSchfpUQGJ8+q4oAPMbujj8qcsyZ5 JBweoxT/AGoUA9QDxQBGZEA++v50nnJx8x/AE0/av91fyoOOMAUARmVccbifTBpiiRpW52cDOeTV j+H3qNP9c/ToKBgIjg5kk/OmGPpmRvxqUkDrxQBmQfSgQ0JIAMSfmtRSwyl1cOG2nO3GM1ZPrRnI oAhFysgwqsW7rioLy3uJ0QpIFKnOAO1WYRjf/vGpDQBUtYJ4YdrupJOanHmnjK0+kZgi7ielC1YN 2VxpEuOiH8T/AIVGzuhx5efxq4rBo94HBqBgSeAPxoeglrqWF6H6mkj/AIieGJ6UUUxMeaT3oooG Q3MYktmDDIp1s/mW6N6jFFFPoL7RI3CmhutFFIY7qB9KYw4APQUUUACE+WSO1Rsu5dw6jtRRSYER O1lft0PtUlFFIoQ0q8DmiimIOAPaoxiVtxHyA8D196KKAJDik74xRRSGPOML9KY65Axww6GiimBG bhFOH4bHSpUZWj3DkHpRRQIBwaq3P23dm28rH+3n3/8ArUUUDIANX2EE2u7twatQbw37zBfaN2Om aKKAEuseUMkjJFS/8tMr6YNFFAmL1J5pVoopAMHyzMo6MM1IKKKYxBVe6YFwB1HWiit8OrzOfEu0 C2hxCoA4Ipn4UUVjLdm0PhR//9k=