Name: FCA Predictor

Display Field: assessment

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fbda163d146947cb9ecc07cb7582358c

Copyright Text:

Default Visibility: false

MaxRecordCount: 4000

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
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 )
• uniquerowid ( type: esriFieldTypeGUID, alias: uniquerowid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: uniquerowid )
• date_collected ( type: esriFieldTypeDate, alias: date_collected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: date_collected )
• assessment ( type: esriFieldTypeString, alias: assessment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: assessment )
• assessment_id ( type: esriFieldTypeString, alias: assessment_id, editable: true, nullable: true, length: 255, defaultValue: null, modelName: assessment_id )
• district ( type: esriFieldTypeString, alias: district, editable: true, nullable: true, length: 255, defaultValue: null, modelName: district )
• siteid ( type: esriFieldTypeString, alias: siteid, editable: true, nullable: true, length: 255, defaultValue: null, modelName: siteid )
• site ( type: esriFieldTypeString, alias: site, editable: true, nullable: true, length: 255, defaultValue: null, modelName: site )
• buildingid ( type: esriFieldTypeString, alias: buildingid, editable: true, nullable: true, length: 255, defaultValue: null, modelName: buildingid )
• building ( type: esriFieldTypeString, alias: building, editable: true, nullable: true, length: 255, defaultValue: null, modelName: building )
• floor ( type: esriFieldTypeString, alias: floor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: floor )
• room_number ( type: esriFieldTypeString, alias: room_number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: room_number )
• system ( type: esriFieldTypeString, alias: system, editable: true, nullable: true, length: 255, defaultValue: null, modelName: system )
• reporting_system ( type: esriFieldTypeString, alias: reporting_system, editable: true, nullable: true, length: 255, defaultValue: null, modelName: reporting_system )
• subsystem ( type: esriFieldTypeString, alias: subsystem, editable: true, nullable: true, length: 255, defaultValue: null, modelName: subsystem )
• input_component ( type: esriFieldTypeString, alias: input_component, editable: true, nullable: true, length: 255, defaultValue: null, modelName: input_component )
• input_component_code ( type: esriFieldTypeString, alias: input_component_code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: input_component_code )
• life_code ( type: esriFieldTypeString, alias: life_code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: life_code )
• expected_life ( type: esriFieldTypeInteger, alias: expected_life, editable: true, nullable: true, defaultValue: null, modelName: expected_life )
• remaining_life ( type: esriFieldTypeInteger, alias: remaining_life, editable: true, nullable: true, defaultValue: null, modelName: remaining_life )
• RuL_percent ( type: esriFieldTypeDouble, alias: RuL_percent, editable: true, nullable: true, defaultValue: null, modelName: RuL_percent )
• Priority ( type: esriFieldTypeInteger, alias: Priority, editable: true, nullable: true, defaultValue: null, modelName: Priority )
• bldg_sq_ft ( type: esriFieldTypeInteger, alias: bldg_sq_ft, editable: true, nullable: true, defaultValue: null, modelName: bldg_sq_ft )
• percent_coverage ( type: esriFieldTypeInteger, alias: percent_coverage, editable: true, nullable: true, defaultValue: null, modelName: percent_coverage )
• quantity ( type: esriFieldTypeInteger, alias: quantity, editable: true, nullable: true, defaultValue: null, modelName: quantity )
• uom ( type: esriFieldTypeString, alias: uom, editable: true, nullable: true, length: 255, defaultValue: null, modelName: uom )
• UnitCost ( type: esriFieldTypeDouble, alias: UnitCost, editable: true, nullable: true, defaultValue: null, modelName: UnitCost )
• TotalCost ( type: esriFieldTypeDouble, alias: TotalCost, editable: true, nullable: true, defaultValue: null, modelName: TotalCost )
• window_height ( type: esriFieldTypeInteger, alias: window_height, editable: true, nullable: true, defaultValue: null, modelName: window_height )
• window_width ( type: esriFieldTypeInteger, alias: window_width, editable: true, nullable: true, defaultValue: null, modelName: window_width )
• notes ( type: esriFieldTypeString, alias: notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes )
• def_count ( type: esriFieldTypeInteger, alias: def_count, editable: true, nullable: true, defaultValue: null, modelName: def_count )
• deficiency_yesno ( type: esriFieldTypeString, alias: deficiency_yesno, editable: true, nullable: true, length: 255, defaultValue: null, modelName: deficiency_yesno )
• ada_count ( type: esriFieldTypeInteger, alias: ada_count, editable: true, nullable: true, defaultValue: null, modelName: ada_count )
• ada_yesno ( type: esriFieldTypeString, alias: ada_yesno, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ada_yesno )
• attachment_count ( type: esriFieldTypeInteger, alias: attachment_count, editable: true, nullable: true, defaultValue: null, modelName: attachment_count )
• photos_reviewed ( type: esriFieldTypeString, alias: photos_reviewed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: photos_reviewed )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• latitude ( type: esriFieldTypeDouble, alias: latitude, editable: true, nullable: true, defaultValue: null, modelName: latitude )
• longitude ( type: esriFieldTypeDouble, alias: longitude, editable: true, nullable: true, defaultValue: null, modelName: longitude )

Templates:

• Name: FCA Predictor
  Description:
  Prototype:
  latitude: null
  longitude: null
  uniquerowid: null
  date_collected: null
  assessment: null
  assessment_id: null
  district: null
  siteid: null
  site: null
  buildingid: null
  building: null
  floor: null
  room_number: null
  system: null
  reporting_system: null
  subsystem: null
  input_component: null
  input_component_code: null
  life_code: null
  expected_life: null
  remaining_life: null
  RuL_percent: null
  Priority: null
  bldg_sq_ft: null
  percent_coverage: null
  quantity: null
  uom: null
  UnitCost: null
  TotalCost: null
  window_height: null
  window_width: null
  notes: null
  def_count: null
  deficiency_yesno: null
  ada_count: null
  ada_yesno: null
  attachment_count: null
  photos_reviewed: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

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

Child Resources:   Field Groups   Contingent Values

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