20260226
15254900
1.0
TRUE
CreateFeatureclass C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory Pipes 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\Pipes
AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes 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\Pipes 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\Pipes 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\Pipes DateCleaned Date # # # "Date Cleaned" NULLABLE NON_REQUIRED #
AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes 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\Pipes 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\Pipes AssetID Text # # 100 "Asset ID (Upstream to Downstream)" NULLABLE NON_REQUIRED #
AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes 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\Pipes 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\Pipes 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\Pipes USElevation "Double (64-bit floating point)" # # # "Upstream Elevation" NULLABLE NON_REQUIRED #
AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes DSElevation "Double (64-bit floating point)" # # # "Downstream Elevation" NULLABLE NON_REQUIRED #
AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes 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\Pipes TotalLength "Double (64-bit floating point)" # # # "Total Length (from wall to wall of segment)" NULLABLE NON_REQUIRED #
AddField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes 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\Pipes 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\Pipes 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\Pipes 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\Pipes Owner Owner #
AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes PreCleaning PreCleaning #
AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes InspectionStatus InspectionStatus #
AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes DrainageArea DrainageArea #
AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes City City #
AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes LocationCode LocationCode #
AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes Material Pipes_Material #
AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes CracksOrDamage YesNo #
AssignDomainToField C:\Users\KathrynClifton\Downloads\_Hobart_IN_Database_Rebuild\hobart-stormwater-inventory-db-design\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes SedimentDebris SedimentDebrisBuildUp #
UpdateSchema E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate Downstream Elevation</rule_name><rule_type>CALCULATION</rule_type><expression>var feat_line = Geometry($feature)
var end_z = feat_line.paths[-1][-1].z
return end_z</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>DSElevation</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate Downstream Elevation</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate Upstream Elevation</rule_name><rule_type>CALCULATION</rule_type><expression>var feat_line = Geometry($feature)
var start_z = feat_line.paths[0][0].z
return start_z</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>USElevation</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate Upstream Elevation</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema E:\HobartProResources\Testing\Hobart_IN_Database_Rebuild.gdb\StormwaterInventory\Pipes "<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
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><ReorderAttributeRule><rule_name>Calculate Upstream 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=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.Pipes</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 "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.Pipes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DisableAttributeRules><rule_name>Calculate Upstream Elevation</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><AlterAttributeRule><rule_name>Calculate Upstream Elevation</rule_name><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>var feat_line = Geometry($feature)
var start_z = feat_line.paths[0][0].z
return start_z</expression><category>-1</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow><workflow><DisableAttributeRules><rule_name>Calculate Downstream Elevation</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><AlterAttributeRule><rule_name>Calculate Downstream Elevation</rule_name><exclude_from_client_eval>False</exclude_from_client_eval><severity>-1</severity><expression>var feat_line = Geometry($feature)
var end_z = feat_line.paths[-1][-1].z
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=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.Pipes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate Upstream Elevation from Point Intersection</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 start_point = Point({x: start_x, y: start_y, spatialReference: sr})
Console(start_point)
// find intersecting point asset
var asset_types = [FeatureSetByName($datastore, "geohub.GIS.Manhole", ["InvertElevation"], true),
FeatureSetByName($datastore, "geohub.GIS.Inlets", ["InvertElevation"], true), FeatureSetByName($datastore, "geohub.GIS.OutletsAndDischarges", ["InvertElevation"], true)]
for(var index in asset_types){
var a = asset_types[index]
var start_int = First(Intersects(start_point, a))
if(!IsEmptyButBetter(start_int)){
return start_int.InvertElevation
}
}
</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>USElevation</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate Upstream Elevation from Point Intersection</rule_name><evaluation_order>4</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.4.0'><FeatureDataset>geohub.GIS.StormwaterInventory</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686752734142732f6374345a484b444d35376c646430337341774d4f6762366c5266502b69793876536777493d2a00;ENCRYPTED_PASSWORD=00022e684743707a4350596b6f4d695838567a4a746945345a5254314a6468444c4b7a3132383776435654736332303d2a00;SERVER=219.1.0.6;INSTANCE=sde:sqlserver:219.1.0.6;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=219.1.0.6;DATABASE=geohub;USER=gis;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>geohub.GIS.Pipes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate Downstream Elevation from Point Intersection</rule_name><rule_type>CALCULATION</rule_type><expression>// DS Elevation
// 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 end_x = feat_line.paths[-1][-1].x
var end_y = feat_line.paths[-1][-1].y
var end_point = Point({x: end_x, y: end_y, spatialReference: sr})
Console(end_point)
// find intersecting point asset
var asset_types = [FeatureSetByName($datastore, "geohub.GIS.Manhole", ["InvertElevation"], true),
FeatureSetByName($datastore, "geohub.GIS.Inlets", ["InvertElevation"], true), FeatureSetByName($datastore, "geohub.GIS.OutletsAndDischarges", ["InvertElevation"], true)]
for(var index in asset_types){
var a = asset_types[index]
var end_int = First(Intersects(end_point, a))
if(!IsEmptyButBetter(end_int)){
Console(end_int)
return end_int.InvertElevation
}
}</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>USElevation</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate Downstream Elevation from Point Intersection</rule_name><evaluation_order>5</evaluation_order></ReorderAttributeRule></workflow><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, "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><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 Upstream Elevation from Point Intersection</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 start_point = Point({x: start_x, y: start_y, spatialReference: sr})
Console(start_point)
// find intersecting point asset
var asset_types = [FeatureSetByName($datastore, "geohub.GIS.Manhole", ["InvertElevation"], true),
FeatureSetByName($datastore, "geohub.GIS.Inlets", ["InvertElevation"], true), FeatureSetByName($datastore, "geohub.GIS.OutletsAndDischarges", ["InvertElevation"], true)]
for(var index in asset_types){
var a = asset_types[index]
var start_int = First(Intersects(start_point, a))
if(!IsEmptyButBetter(start_int)){
return start_int.InvertElevation
}
}
</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=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.Pipes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DeleteAttributeRule><rule_name>Calculate Downstream Elevation from Point Intersection</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=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.Pipes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Calculate Downstream Elevation from Point Intersection</rule_name><rule_type>CALCULATION</rule_type><expression>// DS Elevation
// 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 end_x = feat_line.paths[-1][-1].x
var end_y = feat_line.paths[-1][-1].y
var end_point = Point({x: end_x, y: end_y, spatialReference: sr})
Console(end_point)
// find intersecting point asset
var asset_types = [FeatureSetByName($datastore, "geohub.GIS.Manhole", ["InvertElevation"], true),
FeatureSetByName($datastore, "geohub.GIS.Inlets", ["InvertElevation"], true), FeatureSetByName($datastore, "geohub.GIS.OutletsAndDischarges", ["InvertElevation"], true)]
for(var index in asset_types){
var a = asset_types[index]
var end_int = First(Intersects(end_point, a))
if(!IsEmptyButBetter(end_int)){
Console(end_int)
return end_int.InvertElevation
}
}</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>DSElevation</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Calculate Downstream Elevation from Point Intersection</rule_name><evaluation_order>5</evaluation_order></ReorderAttributeRule></workflow></operationSequence>"
Snap Pipes "Manholes END '3.5 Feet'"
Snap Pipes "Inlets END '3.5 Feet'"
UpdateSchema E:\HobartProResources\GeoHub-Production.sde\geohub.GIS.StormwaterInventory\geohub.GIS.Pipes "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate Upstream Elevation from Point Intersection</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 start_point = Point({x: start_x, y: start_y, spatialReference: sr})
Console(start_point)
// find intersecting point asset
var asset_types = [FeatureSetByName($datastore, "geohub.GIS.Manhole", ["InvertElevation"], true),
FeatureSetByName($datastore, "geohub.GIS.Inlets", ["Elevation"], true), FeatureSetByName($datastore, "geohub.GIS.OutletsAndDischarges", ["InvertElevation"], true)]
for(var index in asset_types){
var a = asset_types[index]
var start_int = First(Intersects(start_point, a))
if(!IsEmptyButBetter(start_int)){
return start_int.InvertElevation
}
}
</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.Pipes "<operationSequence><workflow><AlterAttributeRule><rule_name>Calculate Upstream Elevation from Point Intersection</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 start_point = Point({x: start_x, y: start_y, spatialReference: sr})
Console(start_point)
// find intersecting point asset
var asset_types = [FeatureSetByName($datastore, "geohub.GIS.Manhole", ["InvertElevation"], true),
FeatureSetByName($datastore, "geohub.GIS.Inlets", ["InvertElevation"], true), FeatureSetByName($datastore, "geohub.GIS.OutletsAndDischarges", ["InvertElevation"], true)]
for(var index in asset_types){
var a = asset_types[index]
var start_int = First(Intersects(start_point, a))
if(!IsEmptyButBetter(start_int)){
return start_int.InvertElevation
}
}
</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>stormwater.sde.StormwaterInventory</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68694c4c7462585768467a65726e7134697943596b7662324536522f65565644437a765731704978797139383d2a00;ENCRYPTED_PASSWORD=00022e687631387745522f6b3049354c617741466a496976784a4d372f596261444c496555764d38636942515264733d2a00;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.Pipes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>stquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>Structural Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>omquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>O&M Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>pacpquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>PACP Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></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=00022e68694c4c7462585768467a65726e7134697943596b7662324536522f65565644437a765731704978797139383d2a00;ENCRYPTED_PASSWORD=00022e687631387745522f6b3049354c617741466a496976784a4d372f596261444c496555764d38636942515264733d2a00;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.Pipes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>stquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>Structural Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>omquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>O&M Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>pacpquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>PACP Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></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=00022e68694c4c7462585768467a65726e7134697943596b7662324536522f65565644437a765731704978797139383d2a00;ENCRYPTED_PASSWORD=00022e687631387745522f6b3049354c617741466a496976784a4d372f596261444c496555764d38636942515264733d2a00;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.Pipes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>stquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>Structural Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>omquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>O&M Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>pacpquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>PACP Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></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=00022e68694c4c7462585768467a65726e7134697943596b7662324536522f65565644437a765731704978797139383d2a00;ENCRYPTED_PASSWORD=00022e687631387745522f6b3049354c617741466a496976784a4d372f596261444c496555764d38636942515264733d2a00;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.Pipes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>stquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>Structural Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>omquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>O&M Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>pacpquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>PACP Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></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=00022e68694c4c7462585768467a65726e7134697943596b7662324536522f65565644437a765731704978797139383d2a00;ENCRYPTED_PASSWORD=00022e687631387745522f6b3049354c617741466a496976784a4d372f596261444c496555764d38636942515264733d2a00;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.Pipes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>stquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>Structural Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>omquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>O&M Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>pacpquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>PACP Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></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=00022e68694c4c7462585768467a65726e7134697943596b7662324536522f65565644437a765731704978797139383d2a00;ENCRYPTED_PASSWORD=00022e687631387745522f6b3049354c617741466a496976784a4d372f596261444c496555764d38636942515264733d2a00;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.Pipes</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddField><field_name>stquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>Structural Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>omquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>O&M Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>pacpquickrating</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_alias>PACP Quick Rating</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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
Pipes
Feature service for capturing Stormwater Pipes as part of the 2025 BF&S Stormwater Inventory. Includes a related table for inspection records.
Pipes
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk
GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY
QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ
hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW
kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG
YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF
ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh
WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB
GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY
FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA
hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG
BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ
YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=