Parent Layer: Storm Water

Name: Stormwater Culvert

Display Field: FacilityID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 25000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 18055.954822

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.210093020885866E7
YMin: 5733474.335367278
XMax: -1.2040293180115199E7
YMax: 5759130.134281791
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: AssetType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [130, 130, 130, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: Arch Culvert
  Label: Arch Culvert
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [78, 78, 78, 255]
  Width: 15
• Value: Box Culvert
  Label: Box Culvert
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [78, 78, 78, 255]
  Width: 15
• Value: Bridge Culvert
  Label: Bridge Culvert
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [78, 78, 78, 255]
  Width: 15
• Value: Pipe Culvert
  Label: Pipe Culvert
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 15
• Value: Unknown
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [178, 178, 178, 255]
  Width: 15
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: AssetGroup

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• FacilityID ( type: esriFieldTypeString, alias: Facility Identifier, length: 40 )
• InstallDate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• InstallYear ( type: esriFieldTypeSmallInteger, alias: Install Year )
• LifeExpectancy ( type: esriFieldTypeInteger, alias: Life Expectancy )
• LifecycleStatus ( type: esriFieldTypeString, alias: Lifecycle Status, length: 20 )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 255 )
• ProjectID ( type: esriFieldTypeString, alias: Project ID, length: 35 )
• ProjectType ( type: esriFieldTypeString, alias: Project Type, length: 35 )
• AssetGroup ( type: esriFieldTypeSmallInteger, alias: Asset Group )
• AssetType ( type: esriFieldTypeString, alias: Asset Type, length: 255 )
• CasingType ( type: esriFieldTypeString, alias: Casing Type, length: 255 )
• Material ( type: esriFieldTypeString, alias: Material, length: 20 )
• JointType ( type: esriFieldTypeString, alias: Joint Type, length: 255 )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter )
• SecondaryDiameter ( type: esriFieldTypeDouble, alias: Diameter: Casing )
• Dimensions ( type: esriFieldTypeString, alias: Dimensions: Culverts, length: 100 )
• MainShape ( type: esriFieldTypeString, alias: Main Shape, length: 50 )
• PipeType ( type: esriFieldTypeString, alias: Pipe Type, length: 255 )
• FromLocation ( type: esriFieldTypeString, alias: From Location, length: 20 )
• ToLocation ( type: esriFieldTypeString, alias: To Location, length: 20 )
• AsBuiltLength ( type: esriFieldTypeDouble, alias: As-Built Length )
• DownStreamElevation ( type: esriFieldTypeDouble, alias: Downstream Elevation )
• UpstreamElevation ( type: esriFieldTypeDouble, alias: Upstream Elevation )
• VerticalDatum ( type: esriFieldTypeString, alias: Vertical Datum, length: 20 )
• Slope ( type: esriFieldTypeDouble, alias: Slope )
• WaterType ( type: esriFieldTypeString, alias: Water Type, length: 30 )
• OwnedBy ( type: esriFieldTypeSmallInteger, alias: Owned By )
• ManagedBy ( type: esriFieldTypeSmallInteger, alias: Managed By )
• OperationalArea ( type: esriFieldTypeString, alias: Drainage Basin, length: 255 )
• ScannedAsBuilt ( type: esriFieldTypeString, alias: Scanned As-Built, length: 200 )
• ScannedAsBuilt_Page ( type: esriFieldTypeString, alias: As-Built Page, length: 250 )
• TVSurveyReport ( type: esriFieldTypeString, alias: TV Survey Report, length: 200 )
• TVSurveyVideo ( type: esriFieldTypeString, alias: TV Survey Video, length: 200 )
• TVSurveyDate ( type: esriFieldTypeDate, alias: TV Survey Date, length: 8 )
• ConnectionPermit ( type: esriFieldTypeString, alias: Connection Permit, length: 255 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 250 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• Most_Recent_CCTV ( type: esriFieldTypeDate, alias: Most Recent CCTV Inspection, length: 8 )
• TVSurveyCompany ( type: esriFieldTypeString, alias: TV Survey Company, length: 255 )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )
• ConditionMainScore ( type: esriFieldTypeString, alias: Condition Main Score, length: 50 )
• SedimentationMainScore ( type: esriFieldTypeString, alias: Sedimentation Main Score, length: 50 )
• Age ( type: esriFieldTypeDouble, alias: Age )
• RemainingLife ( type: esriFieldTypeDouble, alias: Remaining Life )
• MostRecentJetting ( type: esriFieldTypeDate, alias: MostRecentJetting, length: 8 )

Types:

ID: 0
Name: Unknown
Domains:
• LifecycleStatus:
  Coded Values: [PreActive: Pre-Active] , [AsBuilt: As-Built] , [Active: Active] , ...5 more...
• ProjectType:
  Coded Values: [RID: RID] , [SID: SID] , [Private Contract: Private Contract] , ...12 more...
• AssetType:
  Coded Values: [Interior: Interior Mains 12" and Less] , [Local: Local Mains >12" and < 36"] , [System: System Mains 36" and Larger] , ...5 more...
• CasingType:
  Coded Values: [Access Tunnel: Access Tunnel] , [Casement: Casement] , [Conduit Bridge: Conduit Bridge] , ...4 more...
• Material:
  Coded Values: [Truss: Truss] , [UNK: Unk] , [RPM: Truss] , ...40 more...
• JointType:
  Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...11 more...
• Diameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• SecondaryDiameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• MainShape:
  Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more...
• WaterType:
  Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...7 more...
• OwnedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...
• ManagedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...

---

ID: 1
Name: Gravity Main
Domains:
• LifecycleStatus:
  Coded Values: [PreActive: Pre-Active] , [AsBuilt: As-Built] , [Active: Active] , ...5 more...
• ProjectType:
  Coded Values: [RID: RID] , [SID: SID] , [Private Contract: Private Contract] , ...12 more...
• AssetType:
  Coded Values: [Interior: Interior Mains 12" and Less] , [Local: Local Mains >12" and < 36"] , [System: System Mains 36" and Larger] , ...5 more...
• CasingType:
  Coded Values: [Access Tunnel: Access Tunnel] , [Casement: Casement] , [Conduit Bridge: Conduit Bridge] , ...4 more...
• Material:
  Coded Values: [Truss: Truss] , [UNK: Unk] , [RPM: Truss] , ...40 more...
• JointType:
  Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...11 more...
• Diameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• SecondaryDiameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• MainShape:
  Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more...
• WaterType:
  Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...7 more...
• OwnedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...
• ManagedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...

---

ID: 2
Name: Pressure Pipe
Domains:
• LifecycleStatus:
  Coded Values: [PreActive: Pre-Active] , [AsBuilt: As-Built] , [Active: Active] , ...5 more...
• ProjectType:
  Coded Values: [RID: RID] , [SID: SID] , [Private Contract: Private Contract] , ...12 more...
• AssetType:
  Coded Values: [Force: Force Main] , [Pressurized: Pressurized Main]
• CasingType:
  Coded Values: [Access Tunnel: Access Tunnel] , [Casement: Casement] , [Conduit Bridge: Conduit Bridge] , ...4 more...
• Material:
  Coded Values: [Truss: Truss] , [UNK: Unk] , [RPM: Truss] , ...40 more...
• JointType:
  Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...11 more...
• Diameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• SecondaryDiameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• MainShape:
  Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more...
• WaterType:
  Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...7 more...
• OwnedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...
• ManagedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...

---

ID: 3
Name: Culvert
Domains:
• LifecycleStatus:
  Coded Values: [PreActive: Pre-Active] , [AsBuilt: As-Built] , [Active: Active] , ...5 more...
• ProjectType:
  Coded Values: [RID: RID] , [SID: SID] , [Private Contract: Private Contract] , ...12 more...
• AssetType:
  Coded Values: [Unknown: Unknown] , [Pipe Culvert: Pipe Culvert] , [Box Culvert: Box Culvert] , ...2 more...
• CasingType:
  Coded Values: [Access Tunnel: Access Tunnel] , [Casement: Casement] , [Conduit Bridge: Conduit Bridge] , ...4 more...
• Material:
  Coded Values: [Truss: Truss] , [UNK: Unk] , [RPM: Truss] , ...40 more...
• JointType:
  Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...11 more...
• Diameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• SecondaryDiameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• MainShape:
  Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more...
• WaterType:
  Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...7 more...
• OwnedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...
• ManagedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...

---

ID: 4
Name: French Drain
Domains:
• LifecycleStatus:
  Coded Values: [PreActive: Pre-Active] , [AsBuilt: As-Built] , [Active: Active] , ...5 more...
• ProjectType:
  Coded Values: [RID: RID] , [SID: SID] , [Private Contract: Private Contract] , ...12 more...
• AssetType:
  Coded Values: [Interior: Interior Mains 12" and Less] , [Local: Local Mains >12" and < 36"] , [System: System Mains 36" and Larger] , ...5 more...
• CasingType:
  Coded Values: [Access Tunnel: Access Tunnel] , [Casement: Casement] , [Conduit Bridge: Conduit Bridge] , ...4 more...
• Material:
  Coded Values: [Truss: Truss] , [UNK: Unk] , [RPM: Truss] , ...40 more...
• JointType:
  Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...11 more...
• Diameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• SecondaryDiameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• MainShape:
  Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more...
• WaterType:
  Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...7 more...
• OwnedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...
• ManagedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...

---

ID: 5
Name: Casing
Domains:
• LifecycleStatus:
  Coded Values: [PreActive: Pre-Active] , [AsBuilt: As-Built] , [Active: Active] , ...5 more...
• ProjectType:
  Coded Values: [RID: RID] , [SID: SID] , [Private Contract: Private Contract] , ...12 more...
• AssetType:
  Coded Values: [Access Tunnel: Access Tunnel] , [Casement: Casement] , [Conduit Bridge: Conduit Bridge] , ...4 more...
• CasingType:
  Coded Values: [Access Tunnel: Access Tunnel] , [Casement: Casement] , [Conduit Bridge: Conduit Bridge] , ...4 more...
• Material:
  Coded Values: [Truss: Truss] , [UNK: Unk] , [RPM: Truss] , ...40 more...
• JointType:
  Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...11 more...
• Diameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• SecondaryDiameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• MainShape:
  Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more...
• WaterType:
  Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...7 more...
• OwnedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...
• ManagedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...

---

ID: 8
Name: Virtual Drain Line
Domains:
• LifecycleStatus:
  Coded Values: [PreActive: Pre-Active] , [AsBuilt: As-Built] , [Active: Active] , ...5 more...
• ProjectType:
  Coded Values: [RID: RID] , [SID: SID] , [Private Contract: Private Contract] , ...12 more...
• Material:
  Coded Values: [Truss: Truss] , [UNK: Unk] , [RPM: Truss] , ...40 more...
• JointType:
  Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...11 more...
• Diameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• SecondaryDiameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• MainShape:
  Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more...
• WaterType:
  Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...7 more...
• OwnedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...
• ManagedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...

---

ID: 7
Name: Other
Domains:
• LifecycleStatus:
  Coded Values: [PreActive: Pre-Active] , [AsBuilt: As-Built] , [Active: Active] , ...5 more...
• ProjectType:
  Coded Values: [RID: RID] , [SID: SID] , [Private Contract: Private Contract] , ...12 more...
• Material:
  Coded Values: [Truss: Truss] , [UNK: Unk] , [RPM: Truss] , ...40 more...
• JointType:
  Coded Values: [Flange: Flange] , [Weld: Weld] , [Bond: Bond] , ...11 more...
• Diameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• SecondaryDiameter:
  Coded Values: [1.5: 1 1/2"] , [1.25: 1 1/4"] , [1: 1"] , ...40 more...
• MainShape:
  Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more...
• WaterType:
  Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...7 more...
• OwnedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...
• ManagedBy:
  Coded Values: [1: City of Billings] , [-1: Yellowstone County] , [-2: State of Montana] , ...19 more...

---

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata