Parent Layer: Storm & Irrigation

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: b9f9204d35224c2abf209dfcfdb06f17

Copyright Text: City of Grand Junction GIS

Default Visibility: true

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 8000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.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)

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 Result Pagination Token: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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 Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

• SNG_USER15 ( nullable: true, alias: SNG_USER15, type: esriFieldTypeSmallInteger )
• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• SNG_ST_NO ( nullable: true, length: 20, alias: Structure #, type: esriFieldTypeString )
• SNG_ID ( nullable: true, alias: Unique Number, type: esriFieldTypeInteger )
• SNG_DB ( nullable: true, alias: In GBA Database?, type: esriFieldTypeSmallInteger )
• LastModBy ( nullable: true, length: 40, alias: Last Modified By, type: esriFieldTypeString )
• LastModDate ( nullable: true, length: 8, alias: Last Modified date, type: esriFieldTypeDate )
• LastSynDate ( nullable: true, length: 8, alias: Last Synchronized Date, type: esriFieldTypeDate )
• SNG_BASIN ( nullable: true, length: 10, alias: DS Line, type: esriFieldTypeString )
• SNG_X ( nullable: true, alias: X coordinate, type: esriFieldTypeDouble )
• SNG_Y ( nullable: true, alias: Y coordinate, type: esriFieldTypeDouble )
• SNG_USER8 ( nullable: true, alias: Obj #, type: esriFieldTypeInteger )
• Enabled ( nullable: true, alias: Enabled, type: esriFieldTypeSmallInteger )
• AncillaryRole ( nullable: true, alias: AncillaryRole, type: esriFieldTypeSmallInteger )
• SNG_RIM_ELE ( nullable: true, alias: Rim Elevation, type: esriFieldTypeDouble )
• SNG_TYPE_CD ( nullable: true, alias: Structure Type, type: esriFieldTypeInteger )
• SNG_STAT_CD ( nullable: true, alias: Status, type: esriFieldTypeInteger )
• SNG_USER5 ( nullable: true, length: 50, alias: Picture, type: esriFieldTypeString )
• SNG_LCLN_DT ( nullable: true, length: 8, alias: Last Cleaning Date, type: esriFieldTypeDate )
• SNG_NCLN_DT ( nullable: true, length: 8, alias: Next Cleaning Date, type: esriFieldTypeDate )
• SNG_FUNC_CD ( nullable: true, alias: Owner, type: esriFieldTypeInteger )
• SNG_RIM_CD ( nullable: true, alias: Rim Status, type: esriFieldTypeInteger )
• SNG_CFREQ ( nullable: true, alias: Cleaning Freq, type: esriFieldTypeInteger )
• SNG_CFREQ_CD ( nullable: true, alias: Cleaning Freq Units, type: esriFieldTypeInteger )
• SNG_IN ( nullable: true, alias: # of In Conduits, type: esriFieldTypeInteger )
• SNG_OUT ( nullable: true, alias: # of Out Conduits, type: esriFieldTypeInteger )
• SNG_COVR_CD ( nullable: true, alias: Cover Type, type: esriFieldTypeInteger )
• SNG_LOCATIO ( nullable: true, length: 100, alias: Gen. Location, type: esriFieldTypeString )
• SNG_ADR_BDG ( nullable: true, alias: Address, type: esriFieldTypeInteger )
• SNG_ADR_DIR ( nullable: true, length: 2, alias: Direction, type: esriFieldTypeString )
• SNG_ADR_STR ( nullable: true, length: 50, alias: Street Name, type: esriFieldTypeString )
• SNG_ADR_TY ( nullable: true, length: 4, alias: Type, type: esriFieldTypeString )
• GlobalID ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• SNG_DEPTH ( nullable: true, alias: Struct Invert (Elv), type: esriFieldTypeDouble )
• SNG_USER41CD ( nullable: true, length: 10, alias: Conflict, type: esriFieldTypeString )
• SNG_USER21 ( nullable: true, length: 250, alias: Headgate Number, type: esriFieldTypeString )
• SNG_USER22 ( nullable: true, length: 250, alias: Canal ID, type: esriFieldTypeString )
• created_user ( nullable: true, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• SNG_MODEL ( nullable: true, length: 255, alias: SNG_MODEL, type: esriFieldTypeString )
• SNG_USER25 ( nullable: true, length: 255, alias: SNG_USER25, type: esriFieldTypeString )
• Shape ( nullable: true, alias: Shape, type: esriFieldTypeGeometry )

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

  Iteminfo   Thumbnail   Metadata