Name: Storm Pipes

Display Field: STORM_USMH

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 16000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 5388747.124836132
YMin: 3414422.002863303
XMax: 5451197.445473298
YMax: 3493462.9710933864
Spatial Reference: 103045  (6463)  VCSWkid(105703)  LatestVCSWkid(6360)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Storm_Pipe_Symbol
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: Public; Interceptor
  Label: Public Interceptor (Pipe 60" or Greater)
  Description:
  Symbol:
  Style: esriSLSDash
  Color: [255, 255, 0, 255]
  Width: 1
• Value: Public; Trunk
  Label: Public Trunk (Pipe 36" to 59")
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 12
• Value: Public; Collector
  Label: Public Collector (Pipe Less than 36")
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 12
• Value: Public; Draintile
  Label: Public Draintile (HDPE Pipe 8" or Less)
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 12
• Value: Public; Culvert
  Label: Public Culvert
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 4
• Value: Public; Open Channel
  Label: Public Open Channel
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [168, 0, 0, 255]
  Width: 2
• Value: Public; Unknown
  Label: Public Unknown Diameter
  Description:
  Symbol:
  Style: esriSLSDash
  Color: [255, 255, 255, 255]
  Width: 1
• Value: Private; Active
  Label: Private Pipe
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 12
• Value: Other Government
  Label: Other Government
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 12
• Value: Proposed
  Label: Proposed Pipe
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [225, 225, 225, 255]
  Width: 3
• Value: Abandoned / Removed
  Label: Abandoned / Removed
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 12
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [AssetID] CONCAT " - " CONCAT [STORM_PIPE_LENGTH] CONCAT " ft - " CONCAT [STORM_PIPE_HEIGHT] CONCAT " in "
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 9
Font Family: Arial
Font Style: italic
Font Weight: normal
Font Decoration: none

Min. Scale: 600.0
Max. Scale: 0.0

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: STORM_PIPE_TYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 10 )
• STORM_PIPE_TYPE ( type: esriFieldTypeSmallInteger, alias: Pipe Type )
• STORM_PIPE_STYPE ( type: esriFieldTypeSmallInteger, alias: Pipe Subtype )
• STORM_PIPE_STATUS ( type: esriFieldTypeString, alias: Pipe Status, length: 30 , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...2 more... )
• STORM_PIPE_MATERIAL ( type: esriFieldTypeString, alias: Pipe Material, length: 30 , Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CAS: Cast Iron] , ...24 more... )
• STORM_PIPE_SHAPE ( type: esriFieldTypeString, alias: Pipe Shape, length: 30 , Coded Values: [A: Arched (with flat bottom)] , [B: Barrel (e.g. beer barrel shape)] , [C: Circular] , ...8 more... )
• STORM_PIPE_SLOPE ( type: esriFieldTypeDouble, alias: Slope % )
• STORM_PIPE_LENGTH ( type: esriFieldTypeDouble, alias: Pipe Length (ft) )
• STORM_PIPE_HEIGHT ( type: esriFieldTypeInteger, alias: Pipe Height )
• STORM_PIPE_WIDTH ( type: esriFieldTypeInteger, alias: Pipe Width )
• STORM_NOTES1 ( type: esriFieldTypeString, alias: Notes1, length: 250 )
• STORM_NOTES2 ( type: esriFieldTypeString, alias: Notes2, length: 250 )
• STORM_USMH ( type: esriFieldTypeString, alias: US Structure, length: 25 )
• STORM_PIPE_USINVERT ( type: esriFieldTypeDouble, alias: US Invert )
• STORM_DSMH ( type: esriFieldTypeString, alias: DS Structure, length: 25 )
• STORM_PIPE_DSINVERT ( type: esriFieldTypeDouble, alias: DS Invert )
• CR_QUAD ( type: esriFieldTypeString, alias: Quadrant, length: 30 , Coded Values: [NE: NE] , [NW: NW] , [SE: SE] , ...2 more... )
• CR_OWNER ( type: esriFieldTypeString, alias: Owner, length: 30 , Coded Values: [Cedar Rapids: Cedar Rapids] , [Private: Private] , [Marion: Marion] , ...6 more... )
• CR_WATERSHED ( type: esriFieldTypeString, alias: Watershed, length: 50 , Coded Values: [Hoosier Creek: Hoosier Creek] , [Morgan Creek: Morgan Creek] , [Prairie Creek: Prairie Creek] , ...5 more... )
• PROJECT ( type: esriFieldTypeString, alias: Project Number, length: 50 )
• YR_CONSTRUCTED ( type: esriFieldTypeSmallInteger, alias: Year Constructed )
• LAST_INSPECTED ( type: esriFieldTypeSmallInteger, alias: Last Inspected )
• LINED ( type: esriFieldTypeSmallInteger, alias: Lined , Coded Values: [0: No] , [1: Mainline] , [2: Mainline and Laterals] )
• LINING_YEAR ( type: esriFieldTypeSmallInteger, alias: Year Lined )
• LINING_PROJECT ( type: esriFieldTypeString, alias: Project Lined, length: 30 )
• LINING_METHOD ( type: esriFieldTypeString, alias: Lining Method, length: 30 )
• LINING_CONDITION ( type: esriFieldTypeString, alias: Lining Condition, length: 30 )
• LINING_NOTES ( type: esriFieldTypeString, alias: Lining notes, length: 250 )
• CASING ( type: esriFieldTypeSmallInteger, alias: Casing , Coded Values: [0: No] , [1: Yes] )
• CASING_NOTES ( type: esriFieldTypeString, alias: Casing Notes, length: 250 )
• ON_RM_ROUTE ( type: esriFieldTypeSmallInteger, alias: On RM Route , Coded Values: [0: No] , [1: Yes] )
• SDE_OBJ_ID ( type: esriFieldTypeDouble, alias: SDE_OBJ_ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• 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 )
• Storm_Pipe_Symbol ( type: esriFieldTypeString, alias: Storm_Pipe_Symbol, length: 250 )
• DATASOURCE ( type: esriFieldTypeString, alias: Data Source, length: 30 , Coded Values: [Proposed Plans: Proposed Plans] , [Final Plans: Final Plans] , [As-Built Drawings: As-Built Drawings] , ...9 more... )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• CIP_Status ( type: esriFieldTypeString, alias: CIP_Status, length: 30 , Coded Values: [Conceptual: Conceptual] , [Proposed: Proposed] , [Complete: Complete] )
• CIP_Type ( type: esriFieldTypeString, alias: CIP_Type, length: 30 , Coded Values: [Lining: Lining] , [Replacement: Replacement] , [New Construction: New Construction] , ...2 more... )
• CIP_Number ( type: esriFieldTypeString, alias: CIP_Number, length: 30 )
• CIP_Notes ( type: esriFieldTypeString, alias: CIP_Notes, length: 250 )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• Mobile_Type ( type: esriFieldTypeSmallInteger, alias: Mobile_Type , Coded Values: [1: Gravity; Interceptor] , [2: Gravity; Trunk] , [3: Gravity; Collector] , ...9 more... )
• Year_Last_Inventoried ( type: esriFieldTypeSmallInteger, alias: Year_Last_Inventoried )
• Installation_Method ( type: esriFieldTypeString, alias: Installation_Method, length: 50 )
• Subwatershed ( type: esriFieldTypeString, alias: Subwatershed, length: 75 )
• PACP_Location ( type: esriFieldTypeString, alias: PACP_Location, length: 5 , Coded Values: [A: Primary major arterial roads, interstates, numbered roads or town/city center roads for heavy vehicles.] , [B: Secondary roads, non-numbered suburban/rural for heavy vehicles.] , [C: Local rural streets with light traffic, town and city back streets, estate streets and curbside parking areas.] , ...15 more... )
• Inspection_Date ( type: esriFieldTypeDate, alias: Inspection_Date, length: 8 )
• STQuickRating ( type: esriFieldTypeString, alias: Structural_Quick_Rating, length: 5 )
• OMQuickRating ( type: esriFieldTypeString, alias: O&M_Quick_Rating, length: 5 )
• PACPQuickRating ( type: esriFieldTypeString, alias: PACP_Quick_Rating, length: 5 )
• STPipeRatingsIndex ( type: esriFieldTypeDouble, alias: Structural_Index_Rating )
• OMPipeRatingsIndex ( type: esriFieldTypeDouble, alias: O&M_Index_Rating )
• OverallPipeRatingsIndex ( type: esriFieldTypeDouble, alias: Overall_Index_Rating )
• LoFPACP ( type: esriFieldTypeDouble, alias: Likelihood_of_Failure )
• Risk ( type: esriFieldTypeDouble, alias: Risk )
• LUCITY_ID ( type: esriFieldTypeInteger, alias: Lucity ID )
• STORM_PIPE_ID ( type: esriFieldTypeInteger, alias: Storm Pipe ID )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• Cleaning_Date ( type: esriFieldTypeDate, alias: Cleaning Date, length: 8 )
• TV_Date ( type: esriFieldTypeDate, alias: Next TV Date, length: 8 )

Types:

ID: 1
Name: Gravity
Domains:
• STORM_PIPE_STYPE:
  Coded Values: [1: Interceptor] , [2: Trunk] , [3: Collector] , ...4 more...
• STORM_PIPE_STATUS:
  Inherited
• STORM_PIPE_MATERIAL:
  Inherited
• STORM_PIPE_SHAPE:
  Inherited
• CR_OWNER:
  Inherited
• CR_QUAD:
  Inherited
• CR_WATERSHED:
  Inherited
• LINED:
  Inherited
• CASING:
  Inherited
• ON_RM_ROUTE:
  Inherited
• DATASOURCE:
  Inherited
• CIP_Type:
  Inherited
• CIP_Status:
  Inherited
• Enabled:
  Inherited
• Installation_Method:
  Coded Values: [Open Cut: Open Cut] , [Directional Bore: Directional Bore] , [Pipe Burst: Pipe Burst] , ...1 more...
• Subwatershed:
  Coded Values: [Cedar River: Cedar River] , [Czech Village: Czech Village] , [Downtown: Downtown] , ...20 more...
• PACP_Location:
  Inherited

---

ID: 2
Name: Force
Domains:
• STORM_PIPE_STYPE:
  Coded Values: [1: Interceptor] , [2: Trunk] , [3: Collector] , ...4 more...
• STORM_PIPE_STATUS:
  Inherited
• STORM_PIPE_MATERIAL:
  Inherited
• STORM_PIPE_SHAPE:
  Inherited
• CR_OWNER:
  Inherited
• CR_QUAD:
  Inherited
• CR_WATERSHED:
  Inherited
• LINED:
  Inherited
• CASING:
  Inherited
• ON_RM_ROUTE:
  Inherited
• DATASOURCE:
  Inherited
• CIP_Type:
  Inherited
• CIP_Status:
  Inherited
• Enabled:
  Inherited
• Installation_Method:
  Coded Values: [Open Cut: Open Cut] , [Directional Bore: Directional Bore] , [Pipe Burst: Pipe Burst] , ...1 more...
• Subwatershed:
  Coded Values: [Cedar River: Cedar River] , [Czech Village: Czech Village] , [Downtown: Downtown] , ...20 more...
• PACP_Location:
  Inherited

---

Relationships:

• Sewer.DBO.TV_Surveys (0) -- Related To: Sewer.DBO.TV_Surveys (5)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata