Name: STP SPREADSHEET

Display Field: ASSET_NO

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 100000

Supported Query Formats: JSON, geoJSON

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 )
• ASSET_NO ( type: esriFieldTypeString, alias: STP ASSET NO, editable: true, nullable: false, length: 15, defaultValue: null, modelName: ASSET_NO )
• FUNC_LOC ( type: esriFieldTypeString, alias: FUNCTIONAL LOCATION, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FUNC_LOC )
• DESC_FUNC_LOC ( type: esriFieldTypeString, alias: DESCRIPTION OF FUNCTIONAL LOCATION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DESC_FUNC_LOC )
• MAINT_PLANT ( type: esriFieldTypeString, alias: UNIT OFFICE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAINT_PLANT )
• SOURCE_CODE ( type: esriFieldTypeString, alias: SOURCE CODE, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SOURCE_CODE )
• PROC_TYPE ( type: esriFieldTypeString, alias: PROCESS TYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PROC_TYPE )
• TAKEOVER_DT ( type: esriFieldTypeDate, alias: TAKEOVER DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TAKEOVER_DT )
• EFF_STD ( type: esriFieldTypeString, alias: EFFLUENT STANDARD, editable: true, nullable: true, length: 5, defaultValue: null, modelName: EFF_STD )
• LA_AMIS ( type: esriFieldTypeString, alias: LOCAL AUTHORITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LA_AMIS )
• DOE_CAT ( type: esriFieldTypeString, alias: DOE CATEGORY, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DOE_CAT )
• STP_TYPE ( type: esriFieldTypeString, alias: STP TYPE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: STP_TYPE )
• CPE ( type: esriFieldTypeInteger, alias: CURRENT PE, editable: true, nullable: true, defaultValue: null, modelName: CPE )
• DPE ( type: esriFieldTypeInteger, alias: DESIGNED PE, editable: true, nullable: true, defaultValue: null, modelName: DPE )
• MUL_PLANT_TYPE ( type: esriFieldTypeString, alias: MULTIPLE PLANT TYPE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MUL_PLANT_TYPE )
• OPI_VISIT ( type: esriFieldTypeDouble, alias: OPI VISIT, editable: true, nullable: true, defaultValue: null, modelName: OPI_VISIT )
• APPROVED_VISIT ( type: esriFieldTypeDouble, alias: APPROVED VISIT, editable: true, nullable: true, defaultValue: null, modelName: APPROVED_VISIT )
• INCOMING_AMP ( type: esriFieldTypeDouble, alias: TNB INCOMING AMP, editable: true, nullable: true, defaultValue: null, modelName: INCOMING_AMP )
• STP_SECURITY ( type: esriFieldTypeString, alias: STP SECURITY, editable: true, nullable: true, length: 15, defaultValue: null, modelName: STP_SECURITY )
• MANNED_PLANT_CAT ( type: esriFieldTypeString, alias: MANNED PLANT CATEGORY, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MANNED_PLANT_CAT )
• EWS ( type: esriFieldTypeString, alias: EWS, editable: true, nullable: true, length: 5, defaultValue: null, modelName: EWS )
• SCADA ( type: esriFieldTypeString, alias: SCADA, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SCADA )
• SLUDGE_TF ( type: esriFieldTypeString, alias: SLUDGE TREATMENT FACILITY, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SLUDGE_TF )
• SLUDGE_INTERWORKS ( type: esriFieldTypeString, alias: INTERWORKS SLUDGE (SLUDGE FACILITY), editable: true, nullable: true, length: 5, defaultValue: null, modelName: SLUDGE_INTERWORKS )
• TOT_MAJOR_EQUIP ( type: esriFieldTypeSmallInteger, alias: TOTAL MAJOR EQUIP, editable: true, nullable: true, defaultValue: null, modelName: TOT_MAJOR_EQUIP )
• TOT_NONMAJOR_EQUIP ( type: esriFieldTypeSmallInteger, alias: TOTAL NON-MAJOR EQUIP, editable: true, nullable: true, defaultValue: null, modelName: TOT_NONMAJOR_EQUIP )
• TOT_OEO_EE ( type: esriFieldTypeSmallInteger, alias: TOTAL OEO EE, editable: true, nullable: true, defaultValue: null, modelName: TOT_OEO_EE )
• TOT_OEO_IS ( type: esriFieldTypeSmallInteger, alias: TOTAL OEO IS, editable: true, nullable: true, defaultValue: null, modelName: TOT_OEO_IS )
• PMA_PMT ( type: esriFieldTypeString, alias: PMA/PMT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PMA_PMT )
• TARIFF_CAT ( type: esriFieldTypeString, alias: TNB TARIFF CATEGORY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TARIFF_CAT )

Templates:

• Name: STP SPREADSHEET
  Description:
  Prototype:
  PMA_PMT: null
  TARIFF_CAT: null
  ASSET_NO:
  FUNC_LOC: null
  DESC_FUNC_LOC: null
  MAINT_PLANT: null
  SOURCE_CODE: null
  PROC_TYPE: null
  TAKEOVER_DT: null
  EFF_STD: null
  LA_AMIS: null
  DOE_CAT: null
  STP_TYPE: null
  CPE: null
  DPE: null
  MUL_PLANT_TYPE: null
  OPI_VISIT: null
  APPROVED_VISIT: null
  INCOMING_AMP: null
  STP_SECURITY: null
  MANNED_PLANT_CAT: null
  EWS: null
  SCADA: null
  SLUDGE_TF: null
  SLUDGE_INTERWORKS: null
  TOT_MAJOR_EQUIP: null
  TOT_NONMAJOR_EQUIP: null
  TOT_OEO_EE: null
  TOT_OEO_IS: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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