Name: Sewer Maintenance

Display Field: FACILITYID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 337ad7a4e21a4e319bc2cc86aba4711c

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

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: 15, defaultValue: null, modelName: FACILITYID )
• COMMENTS ( type: esriFieldTypeString, alias: Percent Blocked, editable: true, nullable: true, length: 150, defaultValue: null, modelName: COMMENTS )
• BASIN_ID ( type: esriFieldTypeString, alias: BASIN_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BASIN_ID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• MAINTBY ( type: esriFieldTypeString, alias: MAINTBY, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MAINTBY )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ADDRESS )
• LS ( type: esriFieldTypeString, alias: LS, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LS )
• PIPE_SIZE ( type: esriFieldTypeString, alias: PIPE_SIZE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PIPE_SIZE )
• PIPE_MATERIAL ( type: esriFieldTypeString, alias: PIPE_MATERIAL, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PIPE_MATERIAL )
• CONTRACTOR ( type: esriFieldTypeString, alias: CONTRACTOR, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CONTRACTOR )
• MH_NO ( type: esriFieldTypeString, alias: MH_NO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MH_NO )
• DEPTH ( type: esriFieldTypeString, alias: DEPTH, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DEPTH )
• BRICK ( type: esriFieldTypeString, alias: BRICK, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BRICK )
• PRECAST ( type: esriFieldTypeString, alias: PRECAST, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PRECAST )
• RAIN_GUARD ( type: esriFieldTypeString, alias: RAIN_GUARD, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RAIN_GUARD )
• REHAB ( type: esriFieldTypeString, alias: REHAB, editable: true, nullable: true, length: 10, defaultValue: null, modelName: REHAB )
• MH_TO ( type: esriFieldTypeString, alias: MH_TO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MH_TO )
• MH_FROM ( type: esriFieldTypeString, alias: MH_FROM, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MH_FROM )
• CUSTOMER_PROBLEM ( type: esriFieldTypeString, alias: CUSTOMER_PROBLEM, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CUSTOMER_PROBLEM , Coded Values: [YES: YES] , [NO: NO] )
• NOTIFIED ( type: esriFieldTypeString, alias: NOTIFIED, editable: true, nullable: true, length: 15, defaultValue: null, modelName: NOTIFIED , Coded Values: [Door Hang: Door Hang] , [Called: Called] , [In Person: In Person] )
• CITY_PROBLEM ( type: esriFieldTypeString, alias: CITY_PROBLEM, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CITY_PROBLEM , Coded Values: [YES: YES] , [NO: NO] )
• DIG_UP ( type: esriFieldTypeString, alias: DIG_UP, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DIG_UP , Coded Values: [YES: YES] , [NO: NO] )
• CLEANED ( type: esriFieldTypeString, alias: CLEANED, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CLEANED , Coded Values: [YES: YES] , [NO: NO] )
• DIRTY ( type: esriFieldTypeString, alias: DIRTY, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DIRTY , Coded Values: [YES: YES] , [NO: NO] )
• MAINTTYPE ( type: esriFieldTypeString, alias: Maintenance Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINTTYPE )
• DATE ( type: esriFieldTypeDate, alias: DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE )
• CAP_SIZE ( type: esriFieldTypeString, alias: CAP_SIZE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CAP_SIZE_1 )
• REPLACED ( type: esriFieldTypeString, alias: REPLACED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AMOUNT_REPLACED_1 )
• CREW ( type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CREW )
• LINE_TYPE ( type: esriFieldTypeString, alias: Line Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LINE_TYPE , Coded Values: [Main Line: Main Line] , [Lateral: Lateral] )
• TYPE ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TYPE , Coded Values: [Clay: CL] , [PVC: PVC] , [DI: DI] , ...3 more... )
• DateInstalled ( type: esriFieldTypeDate, alias: DateInstalled, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInstalled )
• MAINT_COMPLETED ( type: esriFieldTypeString, alias: MAINT_COMPLETED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAINT_COMPLETED )

Templates:

• Name: Sewer Maintenance
  Description:
  Prototype:
  DateInstalled: null
  TYPE: null
  FACILITYID: null
  COMMENTS: null
  BASIN_ID: null
  MAINT_COMPLETED: null
  MAINTBY: null
  ADDRESS: null
  LS: null
  PIPE_SIZE: null
  PIPE_MATERIAL: null
  CONTRACTOR: null
  MH_NO: null
  DEPTH: null
  BRICK: null
  PRECAST: null
  RAIN_GUARD: null
  REHAB: null
  MH_TO: null
  MH_FROM: null
  CUSTOMER_PROBLEM: null
  NOTIFIED: null
  CITY_PROBLEM: null
  DIG_UP: null
  CLEANED: null
  DIRTY: null
  MAINTTYPE: null
  DATE: null
  CAP_SIZE: null
  REPLACED: null
  CREW: null
  LINE_TYPE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• LiftStationBasinBoundary (2) -- Related To: Lift Station Basin (0)
• LiftStationBasinBoundary (5) -- Related To: NFI Tracking (1)
• LiftStationBasinBoundary (8) -- Related To: Smoke Test Tracking (2)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync

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

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata