Name: Storm Gravity Main TV Condition

Display Field: TVVIDEONAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Separated and combined sewer gravity mains.

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000

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: 745280.533967793
YMin: 776095.9639807865
XMax: 763074.9119407274
YMax: 800194.5515446216
Spatial Reference: 102668  (2241)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: TVCONDITION
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [255, 235, 175, 255]
Width: 1
Default Label:
UniqueValueInfos:
• Value: Poor-Structural
  Label: Poor-Structural
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [197, 0, 255, 255]
  Width: 2
• Value: Poor-Maintenance
  Label: Poor-Maintenance
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 115, 223, 255]
  Width: 2
• Value: Poor
  Label: Poor
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 2
• Value: Fair
  Label: Fair
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 2
• Value: Good
  Label: Good
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [54, 227, 51, 255]
  Width: 2
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
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:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, length: 20 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• MATERIAL ( type: esriFieldTypeString, alias: Material, length: 20 , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...35 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...29 more... )
• MAINSHAPE ( type: esriFieldTypeString, alias: Main Shape, length: 50 , Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more... )
• LINEDYEAR ( type: esriFieldTypeString, alias: Year Lined, length: 4 )
• LINERTYPE ( type: esriFieldTypeString, alias: Liner Type, length: 20 , Coded Values: [CP: Cured in Place] , [FF: Fold and Form or Deform/Reform] , [SN: Segmented Panel] , ...4 more... )
• FROMMH ( type: esriFieldTypeString, alias: From Manhole, length: 11 )
• TOMH ( type: esriFieldTypeString, alias: To Manhole, length: 11 )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] , ...1 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] , ...1 more... )
• SUMFLOW ( type: esriFieldTypeDouble, alias: Flow Summary )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• DOWNELEV ( type: esriFieldTypeDouble, alias: Downstream Depth )
• UPELEV ( type: esriFieldTypeDouble, alias: Upstream Depth )
• SLOPE ( type: esriFieldTypeDouble, alias: Slope )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• TVOPERATOR ( type: esriFieldTypeString, alias: TV Operator, length: 25 )
• TVDATE ( type: esriFieldTypeDate, alias: TV Date, length: 8 )
• TVVIDEONAME ( type: esriFieldTypeString, alias: TV Video File Name, length: 75 )
• AVGPERFT ( type: esriFieldTypeDouble, alias: Average Problems Per Foot )
• DRAINDISTRICT ( type: esriFieldTypeString, alias: Drainage District, length: 50 , Coded Values: [MARIAH: Mariah Storm] , [7thS: 7th South Storm] , [DI: Deseret Industries Storm] )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• O_SID ( type: esriFieldTypeString, alias: SID from Oasis, length: 50 )
• SBDVSNYEAR ( type: esriFieldTypeInteger, alias: Subdivision Year )
• CLEANEDBY ( type: esriFieldTypeString, alias: Cleaned By, length: 30 )
• YEARCLEANED ( type: esriFieldTypeString, alias: Year Cleaned, length: 4 )
• TVCWID ( type: esriFieldTypeString, alias: TV Cityworks ID, length: 25 )
• TVCWACTVTYTYPE ( type: esriFieldTypeString, alias: TV Cityworks Activity Type, length: 25 , Coded Values: [Inspection: Inspection] , [WorkOrder: WorkOrder] , [Request: Request] )
• STATUS ( type: esriFieldTypeString, alias: Pipe Status, length: 25 , Coded Values: [Planned: Planned] , [Constructed: Constructed] , [Abandoned: Abandoned] )
• Location ( type: esriFieldTypeString, alias: Location, length: 250 )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID for CW Line Length, length: 30 )
• TVCONDITION ( type: esriFieldTypeString, alias: TV Condition, length: 7 , Coded Values: [Poor: Poor] , [Fair: Fair] , [Good: Good] , ...2 more... )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )
• PIPETYPE ( type: esriFieldTypeString, alias: Pipe Type, length: 50 )
• TVCOMMENTS ( type: esriFieldTypeString, alias: TV Comments, length: 300 )
• TROUBLESPOTS ( type: esriFieldTypeSmallInteger, alias: Number of Trouble Spots in Line )
• ABANDONED ( type: esriFieldTypeString, alias: Abandoned, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• CLEANDDATE ( type: esriFieldTypeDate, alias: Cleaned Date, length: 8 )
• DRAINDEST ( type: esriFieldTypeString, alias: Drainage Destination, length: 25 , Coded Values: [River: River] , [Ground: Ground] )

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

  Iteminfo   Thumbnail   Metadata