View In:   ArcGIS Online Map Viewer

Name: Maintenance Needed

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 43afe550472548f0aab865d3ce07d414

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 475633.8869435787
YMin: 107532.75872214139
XMax: 504392.8310659975
YMax: 143869.42095682025
Spatial Reference: 103711  (103711)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: MAINTTVSTATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Needs Jetting
  Label: Needs Jetting
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [51, 51, 51, 255]
  Width: 8
• Value: Needs Jetting - High Priority
  Label: Needs Jetting - High Priority
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [51, 51, 51, 255]
  Width: 8
• Value: Re-televise
  Label: Re-televise
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [51, 51, 51, 255]
  Width: 8
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: MAINTTVSTATUS

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...66 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...50 more... )
• MAINSHAPE ( type: esriFieldTypeString, alias: Main Shape, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINSHAPE , Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Oblong: Oblong] , ...5 more... )
• LINEDYEAR ( type: esriFieldTypeString, alias: Year Lined, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LINEDYEAR )
• LINERTYPE ( type: esriFieldTypeString, alias: Liner Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LINERTYPE , Coded Values: [CP: Cured in Place] , [FF: Fold and Form or Deform/Reform] , [SN: Segmented Panel] , ...4 more... )
• FROMMH ( type: esriFieldTypeString, alias: From Manhole, editable: true, nullable: true, length: 11, defaultValue: null, modelName: FROMMH )
• TOMH ( type: esriFieldTypeString, alias: To Manhole, editable: true, nullable: true, length: 11, defaultValue: null, modelName: TOMH )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WATERTYPE , Coded Values: [Treated: Treated Water] , [Combined: Combined Waste Water] , [Potable: Potable Water] , ...6 more... )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Our Agency] , [-1: Private] , [-2: Other] )
• SUMFLOW ( type: esriFieldTypeDouble, alias: Flow Summary, editable: true, nullable: true, defaultValue: null, modelName: SUMFLOW )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• DOWNELEV ( type: esriFieldTypeDouble, alias: Downstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: DOWNELEV )
• UPELEV ( type: esriFieldTypeDouble, alias: Upstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: UPELEV )
• SLOPE ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: SLOPE )
• INSTALLDATE ( type: esriFieldTypeString, alias: Install Date, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSTALLDATE )
• LIFTAREA ( type: esriFieldTypeString, alias: Lift Area, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LIFTAREA )
• PURPOSE ( type: esriFieldTypeString, alias: Purpose, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PURPOSE )
• JETTING ( type: esriFieldTypeString, alias: Last Jetting Date, editable: true, nullable: true, length: 50, defaultValue: null, modelName: JETTING )
• BORING ( type: esriFieldTypeString, alias: Last Rodding Date, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BORING )
• BUCKET ( type: esriFieldTypeString, alias: Last Bucket Date, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BUCKET )
• TELVYR ( type: esriFieldTypeSmallInteger, alias: Televised Year, editable: true, nullable: true, defaultValue: null, modelName: TELVYR )
• TELVVIEWNU ( type: esriFieldTypeString, alias: Televising Video, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TELVVIEWNU )
• BOOK ( type: esriFieldTypeString, alias: BOOK, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BOOK )
• MAINTENANCE ( type: esriFieldTypeString, alias: MAINTENANCE, editable: true, nullable: true, length: 250, defaultValue: null, modelName: MAINTENANCE , Coded Values: [ABANDONED-FILLED: ABANDONED-FILLED] , [Blown Service: Blown Service] , [Drop Pipe: Drop Pipe] , ...2 more... )
• TV_CONTRACTOR ( type: esriFieldTypeString, alias: TV_CONTRACTOR, editable: true, nullable: true, length: 250, defaultValue: null, modelName: TV_CONTRACTOR )
• PROJECT ( type: esriFieldTypeString, alias: PROJECT, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PROJECT )
• TELDVD ( type: esriFieldTypeString, alias: TELDVD, editable: true, nullable: true, length: 250, defaultValue: null, modelName: TELDVD )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH, editable: true, nullable: true, defaultValue: null, modelName: LENGTH )
• FLUSHING ( type: esriFieldTypeString, alias: FLUSHING, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FLUSHING )
• JETTINGDATE ( type: esriFieldTypeDate, alias: Jetting Field Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: JETTINGDATE )
• BORINGDATE ( type: esriFieldTypeDate, alias: Boring Field Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BORINGDATE )
• FLUSHINGDATE ( type: esriFieldTypeDate, alias: Flushing Field Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FLUSHINGDATE )
• FIELDNOTES ( type: esriFieldTypeString, alias: FIELDNOTES, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FIELDNOTES )
• SERVICETECH1 ( type: esriFieldTypeString, alias: Jetting Field Tech 1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERVICETECH1 , Coded Values: [Andy Rongstad: Andy Rongstad] , [Cory Olson: Cory Olson] , [Josh Meyer: Josh Meyer] , ...4 more... )
• SERVICETECH2 ( type: esriFieldTypeString, alias: Jetting Field Tech 2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SERVICETECH2 , Coded Values: [Andy Rongstad: Andy Rongstad] , [Cory Olson: Cory Olson] , [Josh Meyer: Josh Meyer] , ...4 more... )
• LASTJETTINGTECHS ( type: esriFieldTypeString, alias: Last Jetting Techs, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LASTJETTINGTECHS )
• LASTBORINGTECHS ( type: esriFieldTypeString, alias: Last Rodding Techs, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LASTBORINGTECHS )
• LASTFLUSHINGTECHS ( type: esriFieldTypeString, alias: Last Flushing Techs, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LASTFLUSHINGTECHS )
• BORINGTECH1 ( type: esriFieldTypeString, alias: Field Boring Tech 1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BORINGTECH1 , Coded Values: [Andy Rongstad: Andy Rongstad] , [Cory Olson: Cory Olson] , [Josh Meyer: Josh Meyer] , ...4 more... )
• BORINGTECH2 ( type: esriFieldTypeString, alias: Field Boring Tech 2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BORINGTECH2 , Coded Values: [Andy Rongstad: Andy Rongstad] , [Cory Olson: Cory Olson] , [Josh Meyer: Josh Meyer] , ...4 more... )
• MAINTTVDATE ( type: esriFieldTypeDate, alias: Maintenance TV Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MAINTTVDATE )
• MAINTTVTECH1 ( type: esriFieldTypeString, alias: Maintenance Tech 1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINTTVTECH1 , Coded Values: [Andy Rongstad: Andy Rongstad] , [Cory Olson: Cory Olson] , [Josh Meyer: Josh Meyer] , ...4 more... )
• MAINTTVTECH2 ( type: esriFieldTypeString, alias: Maintenance Tech 2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINTTVTECH2 , Coded Values: [Andy Rongstad: Andy Rongstad] , [Cory Olson: Cory Olson] , [Josh Meyer: Josh Meyer] , ...4 more... )
• MAINTTVSTATUS ( type: esriFieldTypeString, alias: Maintenance Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINTTVSTATUS , Coded Values: [Needs Rodding: Needs Rodding] , [Needs Jetting: Needs Jetting] , [Maintenance Complete: Maintenance Complete] , ...2 more... )
• TVRODDING ( type: esriFieldTypeString, alias: TV IN LIEU OF RODDING, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TVRODDING , Coded Values: [Yes: Yes] , [No: No] )
• TVJETTING ( type: esriFieldTypeString, alias: TV IN LIEU OF JETTING, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TVJETTING , Coded Values: [Yes: Yes] , [No: No] )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength() )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Issue ( type: esriFieldTypeString, alias: Issue, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Issue )
• IssueDate ( type: esriFieldTypeDate, alias: IssueDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: IssueDate )
• PotentialSlipline ( type: esriFieldTypeString, alias: PotentialSlipline, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PotentialSlipline )

Types:

ID: Needs Jetting
Name: Needs Jetting
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• MAINSHAPE:
  Inherited
• LINERTYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• MAINTENANCE:
  Inherited
• SERVICETECH1:
  Inherited
• SERVICETECH2:
  Inherited
• BORINGTECH1:
  Inherited
• BORINGTECH2:
  Inherited
• MAINTTVTECH1:
  Inherited
• MAINTTVTECH2:
  Inherited
• MAINTTVSTATUS:
  Inherited
• TVRODDING:
  Inherited
• TVJETTING:
  Inherited
Templates:
• Name: Needs Jetting
  Description:
  Prototype:
  ACTIVEFLAG: 1
  ENABLED: 1
  OWNEDBY: 1
  WATERTYPE: null
  MAINTTVTECH2: null
  IssueDate: null
  FACILITYID: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINEDYEAR: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  MAINTBY: 1
  SUMFLOW: null
  LASTUPDATE: null
  LASTEDITOR: null
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  INSTALLDATE: null
  LIFTAREA: null
  PURPOSE: null
  JETTING: null
  BORING: null
  BUCKET: null
  TELVYR: null
  TELVVIEWNU: null
  BOOK: null
  MAINTENANCE: null
  TV_CONTRACTOR: null
  PROJECT: null
  TELDVD: null
  LENGTH: null
  FLUSHING: null
  JETTINGDATE: null
  BORINGDATE: null
  FLUSHINGDATE: null
  FIELDNOTES: null
  SERVICETECH1: null
  SERVICETECH2: null
  LASTJETTINGTECHS: null
  LASTBORINGTECHS: null
  LASTFLUSHINGTECHS: null
  BORINGTECH1: null
  BORINGTECH2: null
  MAINTTVDATE: null
  MAINTTVTECH1: null
  MAINTTVSTATUS: Needs Jetting
  TVRODDING: null
  TVJETTING: null
  Issue: null
  PotentialSlipline: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Needs Jetting - High Priority
Name: Needs Jetting - High Priority
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• MAINSHAPE:
  Inherited
• LINERTYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• MAINTENANCE:
  Inherited
• SERVICETECH1:
  Inherited
• SERVICETECH2:
  Inherited
• BORINGTECH1:
  Inherited
• BORINGTECH2:
  Inherited
• MAINTTVTECH1:
  Inherited
• MAINTTVTECH2:
  Inherited
• MAINTTVSTATUS:
  Inherited
• TVRODDING:
  Inherited
• TVJETTING:
  Inherited
Templates:
• Name: Needs Jetting - High Priority
  Description:
  Prototype:
  IssueDate: null
  Issue: null
  FACILITYID: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINEDYEAR: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  WATERTYPE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  SUMFLOW: null
  LASTUPDATE: null
  LASTEDITOR: null
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  INSTALLDATE: null
  LIFTAREA: null
  PURPOSE: null
  JETTING: null
  BORING: null
  BUCKET: null
  TELVYR: null
  TELVVIEWNU: null
  BOOK: null
  MAINTENANCE: null
  TV_CONTRACTOR: null
  PROJECT: null
  TELDVD: null
  LENGTH: null
  FLUSHING: null
  JETTINGDATE: null
  BORINGDATE: null
  FLUSHINGDATE: null
  FIELDNOTES: null
  SERVICETECH1: null
  SERVICETECH2: null
  LASTJETTINGTECHS: null
  LASTBORINGTECHS: null
  LASTFLUSHINGTECHS: null
  BORINGTECH1: null
  BORINGTECH2: null
  MAINTTVDATE: null
  MAINTTVTECH1: null
  MAINTTVTECH2: null
  MAINTTVSTATUS: Needs Jetting - High Priority
  TVRODDING: null
  TVJETTING: null
  PotentialSlipline: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Re-televise
Name: Re-televise
Domains:
• MATERIAL:
  Inherited
• DIAMETER:
  Inherited
• MAINSHAPE:
  Inherited
• LINERTYPE:
  Inherited
• WATERTYPE:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• MAINTENANCE:
  Inherited
• SERVICETECH1:
  Inherited
• SERVICETECH2:
  Inherited
• BORINGTECH1:
  Inherited
• BORINGTECH2:
  Inherited
• MAINTTVTECH1:
  Inherited
• MAINTTVTECH2:
  Inherited
• MAINTTVSTATUS:
  Inherited
• TVRODDING:
  Inherited
• TVJETTING:
  Inherited
Templates:
• Name: Re-televise
  Description:
  Prototype:
  IssueDate: null
  Issue: null
  FACILITYID: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINEDYEAR: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  WATERTYPE: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  SUMFLOW: null
  LASTUPDATE: null
  LASTEDITOR: null
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  INSTALLDATE: null
  LIFTAREA: null
  PURPOSE: null
  JETTING: null
  BORING: null
  BUCKET: null
  TELVYR: null
  TELVVIEWNU: null
  BOOK: null
  MAINTENANCE: null
  TV_CONTRACTOR: null
  PROJECT: null
  TELDVD: null
  LENGTH: null
  FLUSHING: null
  JETTINGDATE: null
  BORINGDATE: null
  FLUSHINGDATE: null
  FIELDNOTES: null
  SERVICETECH1: null
  SERVICETECH2: null
  LASTJETTINGTECHS: null
  LASTBORINGTECHS: null
  LASTFLUSHINGTECHS: null
  BORINGTECH1: null
  BORINGTECH2: null
  MAINTTVDATE: null
  MAINTTVTECH1: null
  MAINTTVTECH2: null
  MAINTTVSTATUS: Re-televise
  TVRODDING: null
  TVJETTING: null
  PotentialSlipline: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Analytic   Apply Edits   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata