20260226 15254400 1.0 TRUE CreateFeatureclass C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory DetentionAndRetention Polygon # 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\DetentionAndRetention AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention 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\DetentionAndRetention 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\DetentionAndRetention 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\DetentionAndRetention 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\DetentionAndRetention 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\DetentionAndRetention 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\DetentionAndRetention 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\DetentionAndRetention 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\DetentionAndRetention 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\DetentionAndRetention AssetType Text # # 30 "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\DetentionAndRetention 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\DetentionAndRetention 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\DetentionAndRetention SedimentDebrisBuildUp 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\DetentionAndRetention WaterLevel Text # # 20 "Water Level" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention AdditionalConnections Text # # 10 "Additional COH assets connected to this?" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention 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\DetentionAndRetention 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\DetentionAndRetention Owner Owner # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention BMPForDevelopment YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention HasBeenMaintained YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention InspectionStatus InspectionStatus # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention DrainageArea DrainageArea # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention City City # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention AssetType DetentionAndRetention_AssetType # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention ErosionSigns YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention FloodingEvidence YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention SedimentDebrisBuildUp SedimentDebrisBuildUp # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention WaterLevel WaterLevel # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\DetentionAndRetention AdditionalConnections YesNo # 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=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.DetentionAndRetention</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>1</evaluation_order></ReorderAttributeRule></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 Detention Retention Basins Feature service for capturing Stormwater Detention and Retention Basins as part of the 2025 BF&S Stormwater Inventory. Includes a related table for inspection records. Detention and Retention Basins iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=