20260226 15254300 1.0 TRUE CreateFeatureclass C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory Culvert Polyline # No Yes # # 0 0 0 # "Same as template" EnableAttachments C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert Owner Text # # 20 "Owner (Public or Private)" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert InspectionDate Date # # # "Inspection Date" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert Weather Text # # 50 Weather NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert PreCleaning Text # # 50 Pre-Cleaning? NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert DateCleaned Date # # # "Date Cleaned" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert InspectionStatus Text # # 50 "Inspection Status" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert DrainageArea Text # # 10 "Drainage Area" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert AssetID Text # # 100 "Asset ID" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert StreetNameNo Text # # 255 "Street (Name & Number)" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert City Text # # 20 City NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert LocationCode Text # # 50 "Location Code" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert USElevation "Double (64-bit floating point)" # # # "Upstream Elevation" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert DSElevation "Double (64-bit floating point)" # # # "Downstream Elevation" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert AssetType Text # # 20 "Asset Type" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert Material Text # # 50 Material NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert TotalLength "Double (64-bit floating point)" # # # "Total Length (from wall to wall of segment)" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert ErosionSigns Text # # 10 "Signs of Erosion?" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert CracksOrDamage Text # # 10 "Presence of Cracks or Damage?" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert SettlementOrShifting Text # # 50 "Settlement or Shifting?" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert FloodingEvidence Text # # 10 "Evidence of Flooding" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert FlowControl Text # # 10 "Flow Control?" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert SedimentDebris Text # # 20 "Sediment & Debris Build-Up?" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert OutfallTerminationID Text # # 50 "Outfall ID of Termination" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert StructureNumber "Long (32-bit integer)" # # # "Structure Number" NULLABLE NON_REQUIRED # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert Owner Owner # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert Weather WeatherCondition # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert PreCleaning PreCleaning # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert InspectionStatus InspectionStatus # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert DrainageArea DrainageArea # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert City City # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert LocationCode LocationCode # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert AssetType Culvert_AssetType # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert Material Culvert_Material # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert ErosionSigns YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert CracksOrDamage YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert SettlementOrShifting SettlementOrShifting # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert FloodingEvidence YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert FlowControl YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert SedimentDebris SedimentDebrisBuildUp # UpdateSchema E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate Upstream Elevation</rule_name><rule_type>CALCULATION</rule_type><expression>var feat_line = Geometry($feature) var start_z = feat_line.paths[0][0].z return start_z</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>USElevation</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate Upstream Elevation</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Culvert "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate Downstream Elevation</rule_name><rule_type>CALCULATION</rule_type><expression>var feat_line = Geometry($feature) var end_z = feat_line.paths[-1][-1].z return end_z</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>DSElevation</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate Downstream Elevation</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" CopyMultiple "E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild_without_Inspection_Tables.gdb\StormwaterInventory\Culvert FeatureClass" E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory Culvert "Culvert FeatureClass geohub.GIS.Culvert #;Culvert__ATTACHREL RelationshipClass geohub.GIS.Culvert__ATTACHREL #;Culvert__ATTACH TableDataset geohub.GIS.Culvert__ATTACH #" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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'><FeatureDataset>geohub.GIS.StormwaterInventory</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686752734142732f6374345a484b444d35376c646430337341774d4f6762366c5266502b69793876536777493d2a00;ENCRYPTED_PASSWORD=00022e684743707a4350596b6f4d695838567a4a746945345a5254314a6468444c4b7a3132383776435654736332303d2a00;SERVER=219.1.0.6;INSTANCE=sde:sqlserver:219.1.0.6;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=219.1.0.6;DATABASE=geohub;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>geohub.GIS.Culvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>SettlementOrShifting</field_name><domain_name>SettlementOrShifting</domain_name></AssignDomainToField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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'><FeatureDataset>geohub.GIS.StormwaterInventory</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686752734142732f6374345a484b444d35376c646430337341774d4f6762366c5266502b69793876536777493d2a00;ENCRYPTED_PASSWORD=00022e684743707a4350596b6f4d695838567a4a746945345a5254314a6468444c4b7a3132383776435654736332303d2a00;SERVER=219.1.0.6;INSTANCE=sde:sqlserver:219.1.0.6;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=219.1.0.6;DATABASE=geohub;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>geohub.GIS.Culvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate Asset ID</rule_name><rule_type>CALCULATION</rule_type><expression>var StructureNum = $feature.StructureNumber var AssetID = $feature.OutfallTerminationID + "-" + text(StructureNum)</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Calculates the Asset ID using the Structure Number and Outfall Termination ID fields. </rule_description><field_name>AssetID</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate Asset ID </rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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'><FeatureDataset>geohub.GIS.StormwaterInventory</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686752734142732f6374345a484b444d35376c646430337341774d4f6762366c5266502b69793876536777493d2a00;ENCRYPTED_PASSWORD=00022e684743707a4350596b6f4d695838567a4a746945345a5254314a6468444c4b7a3132383776435654736332303d2a00;SERVER=219.1.0.6;INSTANCE=sde:sqlserver:219.1.0.6;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=219.1.0.6;DATABASE=geohub;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>geohub.GIS.Culvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate AssetID</rule_name><rule_type>CALCULATION</rule_type><expression>var StructureNum = $feature.StructureNumber var AssetID = $feature.OutfallTerminationID + "-" + text(StructureNum) return AssetID</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Calculates the Asset ID using the Structure Number and Outfall Termination ID fields.</rule_description><field_name>AssetID</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate AssetID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.Culvert "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate Upstream Elevation</rule_name><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>var feat_line = Geometry($feature) var start_z = (feat_line.paths[0][0].z)*3.28084 return start_z</expression><category>-1</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.Culvert "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate Downstream Elevation</rule_name><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>var feat_line = Geometry($feature) var end_z = (feat_line.paths[-1][-1].z)*3.28084 return end_z</expression><category>-1</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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'><FeatureDataset>geohub.GIS.StormwaterInventory</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68754170734e79643979622f5670674d344e35336a586c2f4e464a5445444f77566f73766a547556345849343d2a00;ENCRYPTED_PASSWORD=00022e686241696f32572b4a706b74714e707a575374396f685731337466714642736e4b6a4348344b4b794b61726b3d2a00;SERVER=219.1.0.6;INSTANCE=sde:sqlserver:219.1.0.6;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=219.1.0.6;DATABASE=geohub;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>geohub.GIS.Culvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DisableAttributeRules><rule_name>Calculate AssetID</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><AlterAttributeRule><rule_name>Calculate AssetID</rule_name><rule_description>Calculates the Asset ID using the Structure Number and Outfall Termination ID fields.</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>var StructureNum = $feature.StructureNumber var AssetID = $feature.OutfallTerminationID + "-" + text(StructureNum) return AssetID</expression><category>-1</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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'><FeatureDataset>geohub.GIS.StormwaterInventory</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68754170734e79643979622f5670674d344e35336a586c2f4e464a5445444f77566f73766a547556345849343d2a00;ENCRYPTED_PASSWORD=00022e686241696f32572b4a706b74714e707a575374396f685731337466714642736e4b6a4348344b4b794b61726b3d2a00;SERVER=219.1.0.6;INSTANCE=sde:sqlserver:219.1.0.6;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=219.1.0.6;DATABASE=geohub;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>geohub.GIS.Culvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate AssetID</rule_name><rule_description>Calculates the Asset ID using the Structure Number and Outfall Termination ID fields.</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>var seq_val = NextSequenceValue("GIS.CULVERT_ASSETID") var assetid = Concatenate("culvert-", Text(seq_val)) return assetid</expression><category>-1</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule><EnableAttributeRules><rule_name>Calculate AssetID</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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'><FeatureDataset>geohub.GIS.StormwaterInventory</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68754170734e79643979622f5670674d344e35336a586c2f4e464a5445444f77566f73766a547556345849343d2a00;ENCRYPTED_PASSWORD=00022e686241696f32572b4a706b74714e707a575374396f685731337466714642736e4b6a4348344b4b794b61726b3d2a00;SERVER=219.1.0.6;INSTANCE=sde:sqlserver:219.1.0.6;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=219.1.0.6;DATABASE=geohub;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>geohub.GIS.Culvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate AssetID</rule_name><rule_description>Calculates the Asset ID using the Structure Number and Outfall Termination ID fields.</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>var StructureNum = $feature.StructureNumber var AssetID = $feature.OutfallTerminationID + "-" + text(StructureNum) return AssetID</expression><category>-1</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.Culvert "<operationSequence><workflow><DisableAttributeRules><rule_name>Calculate Upstream Elevation</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><AlterAttributeRule><rule_name>Calculate Upstream Elevation</rule_name><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>var feat_line = Geometry($feature) var start_z = (feat_line.paths[0][0].z)*3.28084 return start_z</expression><category>-1</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow><workflow><DisableAttributeRules><rule_name>Calculate Downstream Elevation</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><AlterAttributeRule><rule_name>Calculate Downstream Elevation</rule_name><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>var feat_line = Geometry($feature) var end_z = (feat_line.paths[-1][-1].z)*3.28084 return end_z</expression><category>-1</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.Culvert "<operationSequence><workflow><DisableAttributeRules><rule_name>Calculate AssetID</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><AlterAttributeRule><rule_name>Calculate AssetID</rule_name><rule_description>Calculates the Asset ID using the Structure Number and Outfall Termination ID fields.</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>var StructureNum = $feature.StructureNumber var AssetID = $feature.OutfallTerminationID + "-" + text(StructureNum) return AssetID</expression><category>-1</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.Culvert "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate AssetID from DB Sequence</rule_name><rule_type>CALCULATION</rule_type><expression>Console(Concatenate("Culvert_", Text(NextSequenceValue("CULVERTS_ASSETID")))) Concatenate("Culvert_", Text(NextSequenceValue("CULVERTS_ASSETID")))</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Calculate AssetID from "CULVERTS_ASSETID" DB Sequence</rule_description><field_name>AssetID</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate AssetID from DB Sequence</rule_name><evaluation_order>4</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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'><FeatureDataset>geohub.GIS.StormwaterInventory</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686752734142732f6374345a484b444d35376c646430337341774d4f6762366c5266502b69793876536777493d2a00;ENCRYPTED_PASSWORD=00022e684743707a4350596b6f4d695838567a4a746945345a5254314a6468444c4b7a3132383776435654736332303d2a00;SERVER=219.1.0.6;INSTANCE=sde:sqlserver:219.1.0.6;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=219.1.0.6;DATABASE=geohub;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>geohub.GIS.Culvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>LocationCode</field_name></RemoveDomainFromField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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'><FeatureDataset>geohub.GIS.StormwaterInventory</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686752734142732f6374345a484b444d35376c646430337341774d4f6762366c5266502b69793876536777493d2a00;ENCRYPTED_PASSWORD=00022e684743707a4350596b6f4d695838567a4a746945345a5254314a6468444c4b7a3132383776435654736332303d2a00;SERVER=219.1.0.6;INSTANCE=sde:sqlserver:219.1.0.6;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=219.1.0.6;DATABASE=geohub;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>geohub.GIS.Culvert</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>LocationCode</field_name><domain_name>LocationCode</domain_name></AssignDomainToField></workflow></operationSequence> UpdateSchema "E:\HobartProResources\SDE on PostgreSQL-hob-age-p03-stormwater.sde\stormwater.sde.StormwaterInventory\stormwater.sde.Culvert" "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate AssetID from DB Sequence</rule_name><rule_description>Calculate AssetID from "CULVERTS_ASSETID" DB Sequence</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>Console(Concatenate("Culvert_", Text(NextSequenceValue("culverts_assetid")))) Concatenate("Culvert_", Text(NextSequenceValue("culverts_assetid")))</expression><category>-1</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" Server=hob-age-p03; Service=sde:postgresql:hob-age-p03; Database=stormwater; User=sde; Version=sde.DEFAULT ArcSDE Connection Culverts MapServer Feature service for capturing Stormwater Culverts as part of the 2025 BF&S Stormwater Inventory. Includes a related table for inspection records. Culverts iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=