Name: Stormwater_Dashboard_TBL

Display Field: WORKORDERID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 42a5434899334254980fc629401a2586

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, editable: true, nullable: false, length: 60, defaultValue: null, modelName: WORKORDERID )
• DESCRIPTION ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 60, defaultValue: null, modelName: DESCRIPTION )
• INITIATEDATE ( type: esriFieldTypeDate, alias: INITIATEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INITIATEDATE )
• ACTUALFINISHDATE ( type: esriFieldTypeDate, alias: ACTUALFINISHDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACTUALFINISHDATE )
• WOCOST ( type: esriFieldTypeDouble, alias: WOCOST, editable: true, nullable: true, defaultValue: null, modelName: WOCOST )
• WOLABORCOST ( type: esriFieldTypeDouble, alias: WOLABORCOST, editable: true, nullable: true, defaultValue: null, modelName: WOLABORCOST )
• WOMATCOST ( type: esriFieldTypeDouble, alias: WOMATCOST, editable: true, nullable: true, defaultValue: null, modelName: WOMATCOST )
• WOEQUIPCOST ( type: esriFieldTypeDouble, alias: WOEQUIPCOST, editable: true, nullable: true, defaultValue: null, modelName: WOEQUIPCOST )
• WOADDRESS ( type: esriFieldTypeString, alias: WOADDRESS, editable: true, nullable: true, length: 130, defaultValue: null, modelName: WOADDRESS )
• Pipe_Cleaned_FT ( type: esriFieldTypeInteger, alias: Pipe_Cleaned_FT, editable: true, nullable: true, defaultValue: null, modelName: Pipe_Cleaned_FT )
• Pipe_Replaced_FT ( type: esriFieldTypeInteger, alias: Pipe_Replaced_FT, editable: true, nullable: true, defaultValue: null, modelName: Pipe_Replaced_FT )
• Pipe_Repairs_Cnt ( type: esriFieldTypeInteger, alias: Pipe_Repairs_Cnt, editable: true, nullable: true, defaultValue: null, modelName: Pipe_Repairs_Cnt )
• Inlets_Repaired_Cnt ( type: esriFieldTypeInteger, alias: Inlets_Repaired_Cnt, editable: true, nullable: true, defaultValue: null, modelName: Inlets_Repaired_Cnt )
• Inlets_Cleaned_Cnt ( type: esriFieldTypeInteger, alias: Inlets_Cleaned_Cnt, editable: true, nullable: true, defaultValue: null, modelName: Inlets_Cleaned_Cnt )
• Ditching_FT ( type: esriFieldTypeInteger, alias: Ditching_FT, editable: true, nullable: true, defaultValue: null, modelName: Ditching_FT )

Templates:

• Name: Stormwater_Dashboard_TBL
  Description:
  Prototype:
  Inlets_Cleaned_Cnt: null
  Ditching_FT: null
  WORKORDERID:
  DESCRIPTION: null
  INITIATEDATE: null
  ACTUALFINISHDATE: null
  WOCOST: null
  WOLABORCOST: null
  WOMATCOST: null
  WOEQUIPCOST: null
  WOADDRESS: null
  Pipe_Cleaned_FT: null
  Pipe_Replaced_FT: null
  Pipe_Repairs_Cnt: null
  Inlets_Repaired_Cnt: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

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

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata