20260226 15254800 1.0 TRUE CreateFeatureclass C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory OutletsAndDischarges Point # 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\OutletsAndDischarges AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges 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\OutletsAndDischarges BMPForDevelopment Text # # 10 "BMP for a Development?" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges HasBeenMaintained Text # # 10 "From first appearance, has it been maintained?" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges 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\OutletsAndDischarges InstallDate Date # # # "Installation Date" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges 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\OutletsAndDischarges 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\OutletsAndDischarges HUC12_Code Text # # 25 "HUC12 Code" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges 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\OutletsAndDischarges 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\OutletsAndDischarges 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\OutletsAndDischarges 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\OutletsAndDischarges 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\OutletsAndDischarges Elevation "Double (64-bit floating point)" # # # Elevation NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges ElevationPoint Text # # 25 "Elevation Point" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges AssetType Text # # 50 "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\OutletsAndDischarges DirectDischarge Text # # 10 "Direct Discharge" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges DischargeBody Text # # 255 "Discharge Body" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges 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\OutletsAndDischarges 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\OutletsAndDischarges 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\OutletsAndDischarges 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\OutletsAndDischarges 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\OutletsAndDischarges 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\OutletsAndDischarges 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\OutletsAndDischarges 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\OutletsAndDischarges Owner Owner # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges BMPForDevelopment YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges HasBeenMaintained YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges PreCleaning PreCleaning # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges InspectionStatus InspectionStatus # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges HUC12_Code HUC12Code # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges DrainageArea DrainageArea # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges City City # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges LocationCode LocationCode # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges ElevationPoint ElevationPointType # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges AssetType OutletsAndDischarges_AssetType # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges DirectDischarge YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges Material OutletsAndDischarges_Material # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges ErosionSigns YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges CracksOrDamage YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges SettlementOrShifting SettlementOrShifting # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges FloodingEvidence YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges SedimentDebris SedimentDebrisBuildUp # UpdateSchema E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OutletsAndDischarges "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate Elevation</rule_name><rule_type>CALCULATION</rule_type><expression>return Geometry($feature).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>Elevation</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 Elevation</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" CopyMultiple "E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild_without_Inspection_Tables.gdb\StormwaterInventory\DetentionAndRetention FeatureClass;E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild_without_Inspection_Tables.gdb\StormwaterInventory\Inlets FeatureClass;E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild_without_Inspection_Tables.gdb\StormwaterInventory\Manhole FeatureClass;E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild_without_Inspection_Tables.gdb\StormwaterInventory\OpenChannelsAndDitches FeatureClass;E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild_without_Inspection_Tables.gdb\StormwaterInventory\OutletsAndDischarges FeatureClass;E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild_without_Inspection_Tables.gdb\StormwaterInventory\Pipes FeatureClass;E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild_without_Inspection_Tables.gdb\StormwaterInventory\Walls FeatureClass;E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild_without_Inspection_Tables.gdb\StormwaterInventory\Weir FeatureClass" E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory DetentionAndRetention;Inlets;Manhole;OpenChannelsAndDitches;OutletsAndDischarges;Pipes;Walls;Weir "DetentionAndRetention FeatureClass geohub.GIS.DetentionAndRetention #;Inlets FeatureClass geohub.GIS.Inlets #;Manhole FeatureClass geohub.GIS.Manhole #;OpenChannelsAndDitches FeatureClass geohub.GIS.OpenChannelsAndDitches #;OutletsAndDischarges FeatureClass geohub.GIS.OutletsAndDischarges #;Pipes FeatureClass geohub.GIS.Pipes #;Walls FeatureClass geohub.GIS.Walls #;Weir FeatureClass geohub.GIS.Weir #;DetentionAndRetention__ATTACHREL RelationshipClass geohub.GIS.DetentionAndRetention__ATTACHREL #;Inlets__ATTACHREL RelationshipClass geohub.GIS.Inlets__ATTACHREL #;Manhole__ATTACHREL RelationshipClass geohub.GIS.Manhole__ATTACHREL #;OpenChannelsAndDitches__ATTACHREL RelationshipClass geohub.GIS.OpenChannelsAndDitches__ATTACHREL #;OutletsAndDischarges__ATTACHREL RelationshipClass geohub.GIS.OutletsAndDischarges__ATTACHREL #;Pipes__ATTACHREL RelationshipClass geohub.GIS.Pipes__ATTACHREL #;Walls__ATTACHREL RelationshipClass geohub.GIS.Walls__ATTACHREL #;Weir__ATTACHREL RelationshipClass geohub.GIS.Weir__ATTACHREL #;DetentionAndRetention__ATTACH TableDataset geohub.GIS.DetentionAndRetention__ATTACH #;Inlets__ATTACH TableDataset geohub.GIS.Inlets__ATTACH #;Manhole__ATTACH TableDataset geohub.GIS.Manhole__ATTACH #;OpenChannelsAndDitches__ATTACH TableDataset geohub.GIS.OpenChannelsAndDitches__ATTACH #;OutletsAndDischarges__ATTACH TableDataset geohub.GIS.OutletsAndDischarges__ATTACH #;Pipes__ATTACH TableDataset geohub.GIS.Pipes__ATTACH #;Walls__ATTACH TableDataset geohub.GIS.Walls__ATTACH #;Weir__ATTACH TableDataset geohub.GIS.Weir__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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>Material</field_name><domain_name>OutletsAndDischarges_Material</domain_name></AssignDomainToField></workflow></operationSequence> Append E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges NO_TEST "Owner "Owner (Public or Private)" true true false 20 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,Owner,0,19;BMPForDevelopment "BMP for a Development?" true true false 10 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,BMPForDevelopment,0,9;HasBeenMaintained "From first appearance, has it been maintained?" true true false 10 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,HasBeenMaintained,0,9;InspectionDate "Inspection Date" true true false 8 Date 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,InspectionDate,-1,-1;InstallDate "Installation Date" true true false 8 Date 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,InstallDate,-1,-1;PreCleaning "Pre-Cleaning?" true true false 50 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,PreCleaning,0,49;InspectionStatus "Inspection Status" true true false 50 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,InspectionStatus,0,49;HUC12_Code "HUC12 Code" true true false 25 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,HUC12_Code,0,24;DrainageArea "Drainage Area" true true false 10 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,DrainageArea,0,9;AssetID "Asset ID" true true false 100 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,AssetID,0,99;StreetNameNo "Street (Name & Number)" true true false 255 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,StreetNameNo,0,254;City "City" true true false 20 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,City,0,19;LocationCode "Location Code" true true false 50 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,LocationCode,0,49;Elevation "Elevation" true true false 8 Double 8 38,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,Elevation,-1,-1;ElevationPoint "Elevation Point" true true false 25 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,ElevationPoint,0,24;AssetType "Asset Type" true true false 50 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,AssetType,0,49;DirectDischarge "Direct Discharge" true true false 10 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,DirectDischarge,0,9;DischargeBody "Discharge Body" true true false 255 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,DischargeBody,0,254;Material "Material" true true false 50 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,Material,0,49;ErosionSigns "Signs of Erosion?" true true false 10 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,ErosionSigns,0,9;CracksOrDamage "Presence of Cracks or Damage?" true true false 10 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,CracksOrDamage,0,9;SettlementOrShifting "Settlement or Shifting?" true true false 50 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,SettlementOrShifting,0,49;FloodingEvidence "Evidence of Flooding?" true true false 10 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,FloodingEvidence,0,9;SedimentDebris "Sediment & Debris Build-Up?" true true false 20 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,SedimentDebris,0,19;OutfallTerminationID "Outfall ID of Termination" true true false 50 Text 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,OutfallTerminationID,0,49;StructureNumber "Structure Number" true true false 4 Long 0 10,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,StructureNumber,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory_old\geohub.GIS.OutletsAndDischarges_old,GlobalID,-1,-1" # # # NOT_UPDATE_GEOMETRY NO_ENFORCE_DOMAINS 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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</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.HUC12_Code + "-" + $feature.DrainageArea + "-" + 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, HUC12 code, and Drainage Area 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>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" RemoveSpatialIndex "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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" AddSpatialIndex "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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" 0 0 0 RemoveSpatialIndex "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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" AddSpatialIndex "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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" 0 0 0 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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>StructureNumber</field_name></DeleteField></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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DeleteField><field_name>StructureNumber</field_name></DeleteField></workflow><workflow><AlterAttributeRule><rule_name>Calculate AssetID</rule_name><rule_description>Calculates the Asset ID using the Structure Number, HUC12 code, and Drainage Area fields.</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>return 1</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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><rule_type>CALCULATION</rule_type><expression>var huc12s = FeatureSetByName($datastore, "geohub.GIS.HUC12", ["HUC_12"], true) var huc_int = First(Intersects(huc12s, $feature)).HUC_12 return huc_int</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>HUC12_Code</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category><triggering_fields>shape</triggering_fields></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Calculate AssetID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><rule_type>CALCULATION</rule_type><expression>var huc12s = FeatureSetByName($datastore, "geohub.GIS.HUC12", ["HUC_12"], true) var huc_int = First(Intersects(huc12s, $feature)).HUC_12 return huc_int</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>HUC12_Code</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category><triggering_fields>shape</triggering_fields></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Calculate AssetID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><rule_type>CALCULATION</rule_type><expression>var huc12s = FeatureSetByName($datastore, "geohub.GIS.HUC12", ["HUC_12"], true) var huc_int = First(Intersects(huc12s, $feature)).HUC_12 return huc_int</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>HUC12_Code</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category><triggering_fields>shape</triggering_fields></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow><workflow><DeleteAttributeRule><rule_name>Calculate AssetID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><DeleteAttributeRule><rule_name>Calculate AssetID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><DeleteAttributeRule><rule_name>Calculate AssetID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><DeleteAttributeRule><rule_name>Calculate AssetID</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><rule_type>CALCULATION</rule_type><expression>var huc12s = FeatureSetByName($datastore, "geohub.GIS.HUC12", ["HUC_12"], true) var huc12_code = First(Intersects(huc12s, $feature)).HUC_12 return huc12_code</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>Get HUC12 ID from </rule_description><field_name>HUC12_Code</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category><triggering_fields>shape</triggering_fields></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><rule_type>CALCULATION</rule_type><expression>var huc12s = FeatureSetByName($datastore, "geohub.GIS.HUC12", ["HUC_12"], true) var huc12_int = Intersects(huc12s, $feature) if(!IsEmpty(huc12_int)){ var huc12_code = First(huc12_int).HUC_12 return huc12_code }</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>Get HUC12 ID from </rule_description><field_name>HUC12_Code</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category><triggering_fields>shape</triggering_fields></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><rule_type>CALCULATION</rule_type><expression>var huc12s = FeatureSetByName($datastore, "geohub.GIS.HUC12", ["HUC_12"], true) var huc12_int = Intersects(huc12s, $feature) if(!IsEmpty(huc12_int)){ var huc12_code = First(huc12_int).HUC_12 return huc12_code }else{ return "Outside of HUC12 boundaries" }</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>Get HUC12 ID from </rule_description><field_name>HUC12_Code</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category><triggering_fields>shape</triggering_fields></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><rule_type>CALCULATION</rule_type><expression>var huc12_fs = FeatureSetByName($datastore, "geohub.GIS.HUC12", ["HUC_12"], false) var huc12_int = Intersects(huc12_fs, Geometry($feature)) var huc12 = First(huc12_int) if(huc12 == null) return; return huc12.HUC_12 </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>Get HUC12 ID from </rule_description><field_name>HUC12_Code</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category><triggering_fields>shape</triggering_fields></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate Drainage Area Name</rule_name><rule_type>CALCULATION</rule_type><expression>// look up dictionary var huc12_code_name = { "040400010508": "CAL", "040400010506": "DUC", "040400010507": "GEO", "040400010505": "TUR", "040400010502": "BEA", "040400010504": "DER" } // get HUC 12 feature set and intersect with current feature var huc12_fs = FeatureSetByName($datastore, "geohub.GIS.HUC12", ["HUC_12"], false) var huc12_int = Intersects(huc12_fs, Geometry($feature)) var huc12 = First(huc12_int) // if not null, lookup the code name and return, else return null if(huc12 == null) return; return huc12_code_name[huc12.HUC_12]</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>DrainageArea</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category><triggering_fields>shape</triggering_fields></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate Drainage Area Name</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate AssetID</rule_name><rule_type>CALCULATION</rule_type><expression>var huc12_sequences = { "CAL": "geohub.GIS.HUC12_CAL_ASSETID", "DUC": "geohub.GIS.HUC12_DUC_ASSETID", "GEO": "geohub.GIS.HUC12_GEO_ASSETID", "TUR": "geohub.GIS.HUC12_TUR_ASSETID", "BEA": "geohub.GIS.HUC12_BEA_ASSETID", "DER": "geohub.GIS.HUC12_DER_ASSETID" } var drainarea = $feature.DrainageArea if(drainarea == null) return ; // early exit var huc12_db_seq = huc12_sequences[drainarea] var next_val = Text(NextSequenceValue(huc12_db_seq), "000") var assetid = Concatenate([drainarea, next_val]) 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>False</triggering_events_update><rule_description>Calculates the Asset ID for outfalls using the DrainageArea field and database sequences. Which database sequence is used is determined by the Drainage Area code name. </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</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=00022e684f4477556545596a7662356a6d41783332504b706549302b497875755651566b79676e5264624a326575493d2a00;ENCRYPTED_PASSWORD=00022e68504b48675438666e49466f42652f766b61612b335631534e4469416d3377636b64742b47377658727552673d2a00;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.OutletsAndDischarges</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>StructureNumber</field_name></DeleteField></workflow></operationSequence> UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><rule_description>Get HUC12 ID from </rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>var huc12_fs = FeatureSetByName($datastore, "geohub.GIS.HUC12", ["HUC_12"], false) var huc12_int = Intersects(huc12_fs, Geometry($feature)) var huc12 = First(huc12_int) if(huc12 == null) return; return huc12.HUC_12 </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><triggering_fields>shape</triggering_fields></AlterAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate HUC 12 Code</rule_name><rule_description>Get HUC12 ID from </rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>var huc12_fs = FeatureSetByName($datastore, "geohub.GIS.HUC12", ["HUC_12"], false) var huc12_int = Intersects(huc12_fs, Geometry($feature)) var huc12 = First(huc12_int) if(huc12 == null) return; return huc12.HUC_12 </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><triggering_fields>shape</triggering_fields></AlterAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate Drainage Area Name</rule_name><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// look up dictionary var huc12_code_name = { "040400010508": "CAL", "040400010506": "DUC", "040400010507": "GEO", "040400010505": "TUR", "040400010502": "BEA", "040400010504": "DER" } // get HUC 12 feature set and intersect with current feature var huc12_fs = FeatureSetByName($datastore, "geohub.GIS.HUC12", ["HUC_12"], false) var huc12_int = Intersects(huc12_fs, Geometry($feature)) var huc12 = First(huc12_int) // if not null, lookup the code name and return, else return null if(huc12 == null) return; return huc12_code_name[huc12.HUC_12]</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><triggering_fields>shape</triggering_fields></AlterAttributeRule></workflow></operationSequence>" AddField E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges InvertElevation DOUBLE # # # "Invert Elevation" NULLABLE NON_REQUIRED # UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OutletsAndDischarges "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate Elevation</rule_name><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>return Geometry($feature).z*3.28084</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.OutletsAndDischarges "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate Elevation</rule_name><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>return Geometry($feature).z*3.28084</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.OutletsAndDischarges "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate Elevation</rule_name><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>return Geometry($feature).z*3.28084</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\SDE on PostgreSQL-hob-age-p03-stormwater.sde\stormwater.sde.StormwaterInventory\stormwater.sde.OutletsAndDischarges" "<operationSequence><workflow><DisableAttributeRules><rule_name>Calculate HUC 12 Code</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow><workflow><DisableAttributeRules><rule_name>Calculate Drainage Area Name</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow></operationSequence>" UpdateSchema "E:\HobartProResources\SDE on PostgreSQL-hob-age-p03-stormwater.sde\stormwater.sde.StormwaterInventory\stormwater.sde.OutletsAndDischarges" "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate AssetID</rule_name><rule_description>Calculates the Asset ID for outfalls using the DrainageArea field and database sequences. Which database sequence is used is determined by the Drainage Area code name. </rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>var huc12_sequences = { "CAL": "huc12_cal_assetid", "DUC": "huc12_duc_assetid", "GEO": "huc12_geo_assetid", "TUR": "huc12_tur_assetid", "BEA": "huc12_bea_assetid", "DER": "huc12_der_assetid" } var drainarea = $feature.DrainageArea if(drainarea == null) return ; // early exit var huc12_db_seq = huc12_sequences[drainarea] var next_val = Text(NextSequenceValue(huc12_db_seq), "000") var assetid = Concatenate([drainarea, next_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></workflow></operationSequence>" Server=hob-age-p03; Service=sde:postgresql:hob-age-p03; Database=stormwater; User=sde; Version=sde.DEFAULT ArcSDE Connection BF&S Stormwater Inventory Absolute Outlets Discharges Feature service for capturing Stormwater Outlets and Discharges as part of the 2025 BF&S Stormwater Inventory. Includes a related table for inspection records. Outlets and Discharges iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=