Name: Storm Structures

Display Field: SNG_ST_NO

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Feature class of storm sewer and irrigation structures within the Persigo 201 boundary in and surrounding the city of Grand Junction. This dataset contains various attributes about the sturctures including structure type, owner, and elevation of structures. This data is created and updated by the GIS department for Storm Sewer department.

Service Item Id: 0f7b89cbba564f3797d51a21098c638d

Copyright Text: City of Grand Junction GIS

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 697106.4891701723
YMin: 4317557.152770594
XMax: 733795.0584176341
YMax: 4336020.432664262
Spatial Reference: 32612  (32612)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SNG_TYPE_CD
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 9
  Label: COMBINED SEWER MH
  Description: N/A
  Symbol:
  
• Value: 2
  Label: STORM MANHOLE
  Description: N/A
  Symbol:
  
• Value: 33
  Label: UNDER DRAIN
  Description: N/A
  Symbol:
  
• Value: 17
  Label: AREA DRAIN
  Description: N/A
  Symbol:
  
• Value: 1
  Label: CATCH BASIN
  Description: N/A
  Symbol:
  
• Value: 8
  Label: END STORM PIPE / CULVERT
  Description: N/A
  Symbol:
  
• Value: 12
  Label: END STUB
  Description: N/A
  Symbol:
  
• Value: 24
  Label: AIRVENT
  Description: N/A
  Symbol:
  
• Value: 4
  Label: OPEN CHANNEL SHOTS
  Description: N/A
  Symbol:
  
• Value: 7
  Label: CROSS
  Description: N/A
  Symbol:
  
• Value: 13
  Label: STORM SEWER CLEANOUT
  Description: N/A
  Symbol:
  
• Value: 27
  Label: VORTEX SEPARATOR
  Description: N/A
  Symbol:
  
• Value: 21
  Label: SPLITER BOX
  Description: N/A
  Symbol:
  
• Value: 25
  Label: STORM GATE VALVE
  Description: N/A
  Symbol:
  
• Value: 26
  Label: FLAP GATE
  Description: N/A
  Symbol:
  
• Value: 14
  Label: MATERIAL CHANGE
  Description: N/A
  Symbol:
  
• Value: 19
  Label: STORM PUMP
  Description: N/A
  Symbol:
  
• Value: 15
  Label: REDUCER
  Description: N/A
  Symbol:
  
• Value: 16
  Label: ABANDONED STRUCTURE
  Description: N/A
  Symbol:
  
• Value: 30
  Label: SAND SEPARATOR
  Description: N/A
  Symbol:
  
• Value: 6
  Label: TEE
  Description: N/A
  Symbol:
  
• Value: 10
  Label: IRR MANHOLE
  Description: N/A
  Symbol:
  
• Value: 3
  Label: IRR BOX/VAULT
  Description: N/A
  Symbol:
  
• Value: 5
  Label: END OF IRRIGATION PIPE
  Description: N/A
  Symbol:
  
• Value: 18
  Label: IRR VENT
  Description: N/A
  Symbol:
  
• Value: 20
  Label: IRR VALVE
  Description: N/A
  Symbol:
  
• Value: 23
  Label: IRR CLEANOUT
  Description: N/A
  Symbol:
  
• Value: 11
  Label: IRR HEADGATE
  Description: N/A
  Symbol:
  
• Value: 29
  Label: IRR SERVICE
  Description: N/A
  Symbol:
  
• Value: 22
  Label: IRR PUMP
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• SNG_USER15 ( type: esriFieldTypeSmallInteger, alias: SNG_USER15 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SNG_ST_NO ( type: esriFieldTypeString, alias: Structure #, length: 20 )
• SNG_ID ( type: esriFieldTypeInteger, alias: Unique Number )
• SNG_DB ( type: esriFieldTypeSmallInteger, alias: In GBA Database? , Coded Values: [0: False] , [1: True] )
• LastModBy ( type: esriFieldTypeString, alias: Last Modified By, length: 40 )
• LastModDate ( type: esriFieldTypeDate, alias: Last Modified date, length: 8 )
• LastSynDate ( type: esriFieldTypeDate, alias: Last Synchronized Date, length: 8 )
• SNG_BASIN ( type: esriFieldTypeString, alias: DS Line, length: 10 )
• SNG_X ( type: esriFieldTypeDouble, alias: X coordinate )
• SNG_Y ( type: esriFieldTypeDouble, alias: Y coordinate )
• SNG_USER8 ( type: esriFieldTypeInteger, alias: Obj # )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• SNG_RIM_ELE ( type: esriFieldTypeDouble, alias: Rim Elevation )
• SNG_TYPE_CD ( type: esriFieldTypeInteger, alias: Structure Type , Coded Values: [9: COMBINED SEWER MH] , [8: END STORM PIPE / CULVERT] , [7: CROSS] , ...27 more... )
• SNG_STAT_CD ( type: esriFieldTypeInteger, alias: Status , Coded Values: [952: Parent Out of Service] , [5: REMOVED] , [4: NOT FOUND] , ...4 more... )
• SNG_USER5 ( type: esriFieldTypeString, alias: Picture, length: 50 )
• SNG_LCLN_DT ( type: esriFieldTypeDate, alias: Last Cleaning Date, length: 8 )
• SNG_NCLN_DT ( type: esriFieldTypeDate, alias: Next Cleaning Date, length: 8 )
• SNG_FUNC_CD ( type: esriFieldTypeInteger, alias: Owner , Coded Values: [9: AIRPORT] , [8: CMU] , [7: FEDERAL] , ...8 more... )
• SNG_RIM_CD ( type: esriFieldTypeInteger, alias: Rim Status , Coded Values: [0: N/A] , [1: RECORD DRAWINGS] , [2: SITE PLANS] , ...7 more... )
• SNG_CFREQ ( type: esriFieldTypeInteger, alias: Cleaning Freq )
• SNG_CFREQ_CD ( type: esriFieldTypeInteger, alias: Cleaning Freq Units , Coded Values: [5: Years] , [4: Months] , [3: Weeks] , ...2 more... )
• SNG_IN ( type: esriFieldTypeInteger, alias: # of In Conduits )
• SNG_OUT ( type: esriFieldTypeInteger, alias: # of Out Conduits )
• SNG_COVR_CD ( type: esriFieldTypeInteger, alias: Cover Type , Coded Values: [4: UNDER DRAIN] , [3: OPEN SLOT] , [2: GRATE] , ...2 more... )
• SNG_LOCATIO ( type: esriFieldTypeString, alias: Gen. Location, length: 100 )
• SNG_ADR_BDG ( type: esriFieldTypeInteger, alias: Address )
• SNG_ADR_DIR ( type: esriFieldTypeString, alias: Direction, length: 2 , Coded Values: [W: W] , [SW: SW] , [SE: SE] , ...5 more... )
• SNG_ADR_STR ( type: esriFieldTypeString, alias: Street Name, length: 50 , Coded Values: [MARGARITA: MARGARITA] , [RIDGE LINE: RIDGE LINE] , [BLUE MOON: BLUE MOON] , ...2565 more... )
• SNG_ADR_TY ( type: esriFieldTypeString, alias: Type, length: 4 , Coded Values: [RUN: RUN] , [LNDG: LNDG] , [VIA: VIA] , ...76 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SNG_DEPTH ( type: esriFieldTypeDouble, alias: Struct Invert (Elv) )
• SNG_USER41CD ( type: esriFieldTypeString, alias: Conflict, length: 10 , Coded Values: [6: UNKNOWN] , [5: OTHER] , [4: GAS/ELECTRIC] , ...4 more... )
• SNG_USER21 ( type: esriFieldTypeString, alias: Headgate Number, length: 250 )
• SNG_USER22 ( type: esriFieldTypeString, alias: Canal ID, 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 )

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

  Iteminfo   Thumbnail   Metadata