Name: BFPDevices

Display Field: ASSETID

Type: Table

Geometry Type: N/A

Description:

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 )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETID )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MANUFACTURER , Coded Values: [Ameco: Ameco] , [Ames: Ames] , [Apollo: Apollo] , ...23 more... )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TYPE , Coded Values: [AVB: AVB] , [CV: CV] , [DBC: DBC] , ...25 more... )
• MODEL ( type: esriFieldTypeString, alias: MODEL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODEL )
• SIZE ( type: esriFieldTypeString, alias: SIZE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SIZE , Coded Values: [0.5: 0.5] , [0.75: 0.75] , [1.0: 1.0] , ...14 more... )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LOCATION )
• DEVICERISKLEVEL ( type: esriFieldTypeString, alias: DEVICERISKLEVEL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEVICERISKLEVEL , Coded Values: [Res: Residential] , [Com: Commercial] , [High: High] )
• DEVICEFUNCTION ( type: esriFieldTypeString, alias: DEVICEFUNCTION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: DEVICEFUNCTION )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS , Coded Values: [In Service: In Service] , [Inactive: Inactive] , [InactiveClosed: Inactive/Closed] , ...3 more... )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• SITEIDTEXT ( type: esriFieldTypeString, alias: SITEIDTEXT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SITEIDTEXT )
• DateLastInspected ( type: esriFieldTypeDate, alias: DateLastInspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateLastInspected )
• UMAssetTagNumber ( type: esriFieldTypeString, alias: UMAssetTagNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UMAssetTagNumber )
• UMMaintenanceRegion ( type: esriFieldTypeString, alias: UMMaintenanceRegion, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UMMaintenanceRegion )
• DateLastTested ( type: esriFieldTypeDate, alias: DateLastTested, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateLastTested )
• CREATEDUSER ( type: esriFieldTypeString, alias: CREATEDUSER, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CREATEDUSER )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )
• MODIFIEDUSER ( type: esriFieldTypeString, alias: MODIFIEDUSER, editable: false, nullable: true, length: 50, defaultValue: null, modelName: MODIFIEDUSER )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 500, defaultValue: null, modelName: COMMENTS )
• PROTECTSTREATEDSYSTEM ( type: esriFieldTypeString, alias: PROTECTSTREATEDSYSTEM, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PROTECTSTREATEDSYSTEM , Coded Values: [Yes: Yes] , [No: No] )

Templates:

• Name: BFPDevices
  Description:
  Prototype:
  COMMENTS: null
  PROTECTSTREATEDSYSTEM: null
  ASSETID: null
  MANUFACTURER: null
  TYPE: null
  MODEL: null
  SIZE: null
  LOCATION: null
  DEVICERISKLEVEL: null
  DEVICEFUNCTION: null
  STATUS: null
  DateLastTested: null
  SITEIDTEXT: null
  DateLastInspected: null
  UMAssetTagNumber: null
  UMMaintenanceRegion: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• BFPLocations (0) -- Related To: BFPLocations. (5)

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

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: DATECREATED
• Creator Field: CREATEDUSER
• Edit Date Field: DATEMODIFIED
• Editor Field: MODIFIEDUSER

Supports Query With Historic Moment: true

Supports Coordinates Quantization: false

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