20260226 15254700 1.0 TRUE CreateFeatureclass C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory OpenChannelsAndDitches 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\OpenChannelsAndDitches AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches LastMaintenanceDate Date # # # "Date Last Maintained" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches USIntakeElevationLowestPoint "Double (64-bit floating point)" # # # "US Intake Elevation (Lowest Point)" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches DSOutletElevationLowestPoint "Double (64-bit floating point)" # # # "DS Outlet elevation (Lowest Point)" NULLABLE NON_REQUIRED # AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches 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\OpenChannelsAndDitches Owner Owner # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches BMPForDevelopment YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches HasBeenMaintained YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches PreCleaning PreCleaning # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches InspectionStatus InspectionStatus # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches DrainageArea DrainageArea # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches City City # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches LocationCode LocationCode # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches AssetType OpenChannelsAndDitches_AssetType # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches ErosionSigns YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches CracksOrDamage YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches FloodingEvidence YesNo # AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches SedimentDebris SedimentDebrisBuildUp # UpdateSchema E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\OpenChannelsAndDitches "<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>USIntakeElevationLowestPoint</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\OpenChannelsAndDitches "<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>DSOutletElevationLowestPoint</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\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.OpenChannelsAndDitches</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Get US-DS MH ID as Asset ID</rule_name><rule_type>CALCULATION</rule_type><expression>// get layer function getLayer(name){ return FeatureSetByName($datastore, name, ["AssetID"], true) } // determine if feat is empty function IsEmptyButBetter(data) { if (IsEmpty(data)) return true; for (var x in data) return false; return true; } var asset_types = ["geohub.GIS.Manhole", "geohub.GIS.Inlets", "geohub.GIS.OutletsAndDischarges"] // get line feature and extract start and end points var feat_line = Geometry($feature) Console(feat_line) var sr = feat_line.spatialReference var start_x = feat_line.paths[0][0].x var start_y = feat_line.paths[0][0].y var end_x = feat_line.paths[-1][-1].x var end_y = feat_line.paths[-1][-1].y var start_point = Point({x: start_x, y: start_y, spatialReference: sr}) Console(start_point) var end_point = Point({x: end_x, y: end_y, spatialReference: sr}) Console(end_point) // find intersecting point asset var usid = "NA" var dsid = "NA" for(var index in asset_types){ var a = getLayer(asset_types[index]) var start_int = First(Intersects(start_point, a)) var end_int = First(Intersects(end_point, a)) if(!IsEmptyButBetter(start_int)){ usid = start_int.AssetID } if(!IsEmptyButBetter(end_int)){ dsid = end_int.AssetID } } var assetid = Concatenate([usid, "-", dsid]) 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><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>Get US-DS MH ID as 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.OpenChannelsAndDitches</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Get US-DS MH ID as Asset ID</rule_name><rule_type>CALCULATION</rule_type><expression> // determine if feat is empty function IsEmptyButBetter(data) { if (IsEmpty(data)) return true; for (var x in data) return false; return true; } // get line feature and extract start and end points var feat_line = Geometry($feature) Console(feat_line) var sr = feat_line.spatialReference var start_x = feat_line.paths[0][0].x var start_y = feat_line.paths[0][0].y var end_x = feat_line.paths[-1][-1].x var end_y = feat_line.paths[-1][-1].y var start_point = Point({x: start_x, y: start_y, spatialReference: sr}) Console(start_point) var end_point = Point({x: end_x, y: end_y, spatialReference: sr}) Console(end_point) // find intersecting point asset var usid = "NA" var dsid = "NA" var asset_types = [FeatureSetByName($datastore, "geohub.GIS.Manhole", ["AssetID"], true), FeatureSetByName($datastore, "geohub.GIS.Inlets", ["AssetID"], true), FeatureSetByName($datastore, "geohub.GIS.OutletsAndDischarges", ["AssetID"], true)] for(var index in asset_types){ var a = asset_types[index] var start_int = First(Intersects(start_point, a)) var end_int = First(Intersects(end_point, a)) if(!IsEmptyButBetter(start_int)){ usid = start_int.AssetID } if(!IsEmptyButBetter(end_int)){ dsid = end_int.AssetID } } var assetid = Concatenate([usid, "-", dsid]) 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><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>Get US-DS MH ID as Asset ID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.OpenChannelsAndDitches "<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><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=00022e685648424770304876524c57704e78623672413233547a794c376673777170634d794976736a59524f46736f3d2a00;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.OpenChannelsAndDitches</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Obstruction</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_alias>Obstruction?</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>OpenChannelAndDitches_Obstruction</field_domain><field_default_value>None</field_default_value></AddField></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>stormwater.sde.StormwaterInventory</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68774341552f55435146516a7743585364444236774c566553554f71306b35566b706873673047704c3534383d2a00;ENCRYPTED_PASSWORD=00022e68775059514f3551627a4b724c756937782b6c69304e616a4d37794d5a2b6a55595a554a75524e47524a506b3d2a00;SERVER=hob-age-p03;INSTANCE=sde:postgresql:hob-age-p03;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=hob-age-p03;DATABASE=stormwater;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>stormwater.sde.OpenChannelsAndDitches</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Get US-DS MH ID as Asset ID</rule_name><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression> // determine if feat is empty function IsEmptyButBetter(data) { if (IsEmpty(data)) return true; for (var x in data) return false; return true; } // get line feature and extract start and end points var feat_line = Geometry($feature) Console(feat_line) var sr = feat_line.spatialReference var start_x = feat_line.paths[0][0].x var start_y = feat_line.paths[0][0].y var end_x = feat_line.paths[-1][-1].x var end_y = feat_line.paths[-1][-1].y var start_point = Point({x: start_x, y: start_y, spatialReference: sr}) Console(start_point) var end_point = Point({x: end_x, y: end_y, spatialReference: sr}) Console(end_point) // find intersecting point asset var usid = "NA" var dsid = "NA" var asset_types = [FeatureSetByName($datastore, "stormwater.sde.Manhole", ["AssetID"], true), FeatureSetByName($datastore, "stormwater.sde.Inlets", ["AssetID"], true), FeatureSetByName($datastore, "stormwater.sde.OutletsAndDischarges", ["AssetID"], true)] for(var index in asset_types){ var a = asset_types[index] var start_int = First(Intersects(start_point, a)) var end_int = First(Intersects(end_point, a)) if(!IsEmptyButBetter(start_int)){ usid = start_int.AssetID } if(!IsEmptyButBetter(end_int)){ dsid = end_int.AssetID } } var assetid = Concatenate([usid, "-", dsid]) 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\SDE on PostgreSQL-hob-age-p03-stormwater.sde\stormwater.sde.StormwaterInventory\stormwater.sde.OpenChannelsAndDitches" "<operationSequence><workflow><AlterAttributeRule><rule_name>Get US-DS MH ID as Asset ID</rule_name><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression> // determine if feat is empty function IsEmptyButBetter(data) { if (IsEmpty(data)) return true; for (var x in data) return false; return true; } // get line feature and extract start and end points var feat_line = Geometry($feature) Console(feat_line) var sr = feat_line.spatialReference var start_x = feat_line.paths[0][0].x var start_y = feat_line.paths[0][0].y var end_x = feat_line.paths[-1][-1].x var end_y = feat_line.paths[-1][-1].y var start_point = Point({x: start_x, y: start_y, spatialReference: sr}) Console(start_point) var end_point = Point({x: end_x, y: end_y, spatialReference: sr}) Console(end_point) // find intersecting point asset var usid = "NA" var dsid = "NA" var asset_types = [FeatureSetByName($datastore, "stormwater.sde.Manhole", ["AssetID"], true), FeatureSetByName($datastore, "stormwater.sde.Inlets", ["AssetID"], true), FeatureSetByName($datastore, "stormwater.sde.OutletsAndDischarges", ["AssetID"], true)] for(var index in asset_types){ var a = asset_types[index] var start_int = First(Intersects(start_point, a)) var end_int = First(Intersects(end_point, a)) if(!IsEmptyButBetter(start_int)){ usid = start_int.AssetID } if(!IsEmptyButBetter(end_int)){ dsid = end_int.AssetID } } var assetid = Concatenate([usid, "-", dsid]) 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\SDE on PostgreSQL-hob-age-p03-stormwater.sde\stormwater.sde.StormwaterInventory\stormwater.sde.OpenChannelsAndDitches" "<operationSequence><workflow><AlterAttributeRule><rule_name>Get US-DS MH ID as Asset ID</rule_name><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression> // determine if feat is empty function IsEmptyButBetter(data) { if (IsEmpty(data)) return true; for (var x in data) return false; return true; } // get line feature and extract start and end points var feat_line = Geometry($feature) Console(feat_line) var sr = feat_line.spatialReference var start_x = feat_line.paths[0][0].x var start_y = feat_line.paths[0][0].y var end_x = feat_line.paths[-1][-1].x var end_y = feat_line.paths[-1][-1].y var start_point = Point({x: start_x, y: start_y, spatialReference: sr}) Console(start_point) var end_point = Point({x: end_x, y: end_y, spatialReference: sr}) Console(end_point) // find intersecting point asset var usid = "NA" var dsid = "NA" var asset_types = [FeatureSetByName($datastore, "stormwater.sde.Manhole", ["AssetID"], true), FeatureSetByName($datastore, "stormwater.sde.Inlets", ["AssetID"], true), FeatureSetByName($datastore, "stormwater.sde.OutletsAndDischarges", ["AssetID"], true)] for(var index in asset_types){ var a = asset_types[index] var start_int = First(Intersects(start_point, a)) var end_int = First(Intersects(end_point, a)) if(!IsEmptyButBetter(start_int)){ usid = start_int.AssetID } if(!IsEmptyButBetter(end_int)){ dsid = end_int.AssetID } } var assetid = Concatenate([usid, "-", dsid]) 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\SDE on PostgreSQL-hob-age-p03-stormwater.sde\stormwater.sde.StormwaterInventory\stormwater.sde.OpenChannelsAndDitches" "<operationSequence><workflow><AlterAttributeRule><rule_name>Get US-DS MH ID as Asset ID</rule_name><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression> // determine if feat is empty function IsEmptyButBetter(data) { if (IsEmpty(data)) return true; for (var x in data) return false; return true; } // get line feature and extract start and end points var feat_line = Geometry($feature) Console(feat_line) var sr = feat_line.spatialReference var start_x = feat_line.paths[0][0].x var start_y = feat_line.paths[0][0].y var end_x = feat_line.paths[-1][-1].x var end_y = feat_line.paths[-1][-1].y var start_point = Point({x: start_x, y: start_y, spatialReference: sr}) Console(start_point) var end_point = Point({x: end_x, y: end_y, spatialReference: sr}) Console(end_point) // find intersecting point asset var usid = "NA" var dsid = "NA" var asset_types = [FeatureSetByName($datastore, "stormwater.sde.Manhole", ["AssetID"], true), FeatureSetByName($datastore, "stormwater.sde.Inlets", ["AssetID"], true), FeatureSetByName($datastore, "stormwater.sde.OutletsAndDischarges", ["AssetID"], true)] for(var index in asset_types){ var a = asset_types[index] var start_int = First(Intersects(start_point, a)) var end_int = First(Intersects(end_point, a)) if(!IsEmptyButBetter(start_int)){ usid = start_int.AssetID } if(!IsEmptyButBetter(end_int)){ dsid = end_int.AssetID } } var assetid = Concatenate([usid, "-", dsid]) 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\SDE on PostgreSQL-hob-age-p03-stormwater.sde\stormwater.sde.StormwaterInventory\stormwater.sde.OpenChannelsAndDitches" "<operationSequence><workflow><AlterAttributeRule><rule_name>Get US-DS MH ID as Asset ID</rule_name><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression> // determine if feat is empty function IsEmptyButBetter(data) { if (IsEmpty(data)) return true; for (var x in data) return false; return true; } // get line feature and extract start and end points var feat_line = Geometry($feature) Console(feat_line) var sr = feat_line.spatialReference var start_x = feat_line.paths[0][0].x var start_y = feat_line.paths[0][0].y var end_x = feat_line.paths[-1][-1].x var end_y = feat_line.paths[-1][-1].y var start_point = Point({x: start_x, y: start_y, spatialReference: sr}) Console(start_point) var end_point = Point({x: end_x, y: end_y, spatialReference: sr}) Console(end_point) // find intersecting point asset var usid = "NA" var dsid = "NA" var asset_types = [FeatureSetByName($datastore, "stormwater.sde.Manhole", ["AssetID"], true), FeatureSetByName($datastore, "stormwater.sde.Inlets", ["AssetID"], true), FeatureSetByName($datastore, "stormwater.sde.OutletsAndDischarges", ["AssetID"], true)] for(var index in asset_types){ var a = asset_types[index] var start_int = First(Intersects(start_point, a)) var end_int = First(Intersects(end_point, a)) if(!IsEmptyButBetter(start_int)){ usid = start_int.AssetID } if(!IsEmptyButBetter(end_int)){ dsid = end_int.AssetID } } var assetid = Concatenate([usid, "-", dsid]) 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>" Server=hob-age-p03; Service=sde:postgresql:hob-age-p03; Database=stormwater; User=sde; Version=sde.DEFAULT ArcSDE Connection BF&S Stormwater Inventory Absolute Open Channels Ditches Feature service for capturing Stormwater Open Channels and Ditches as part of the 2025 BF&S Stormwater Inventory. Includes a related table for inspection records. Open Channels and Ditches iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=