Name: FCA With Cost

Display Field: building_name_assessment

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 851f8e70ce33484c89770a917c5a1a73

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 4000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

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

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• uniquerowid ( type: esriFieldTypeGUID, alias: uniquerowid, length: 38 )
• date_collected ( type: esriFieldTypeDate, alias: date_collected, length: 8 )
• assessment ( type: esriFieldTypeString, alias: assessment, length: 255 )
• assessment_id ( type: esriFieldTypeString, alias: assessment_id, length: 255 )
• site ( type: esriFieldTypeString, alias: site, length: 255 )
• district ( type: esriFieldTypeString, alias: district, length: 255 )
• building_name_assessment ( type: esriFieldTypeString, alias: building_name_assessment, length: 255 )
• parking_lot ( type: esriFieldTypeString, alias: parking_lot, length: 255 )
• floor ( type: esriFieldTypeString, alias: floor, length: 255 )
• room_number ( type: esriFieldTypeString, alias: room_number, length: 255 )
• latitude ( type: esriFieldTypeDouble, alias: latitude )
• longitude ( type: esriFieldTypeDouble, alias: longitude )
• system ( type: esriFieldTypeString, alias: system, length: 255 )
• subsystem ( type: esriFieldTypeString, alias: subsystem, length: 255 )
• input_component ( type: esriFieldTypeString, alias: input_component, length: 255 )
• other_component ( type: esriFieldTypeString, alias: other_component, length: 255 )
• input_component_code ( type: esriFieldTypeString, alias: input_component_code, length: 255 )
• rem_life_code ( type: esriFieldTypeString, alias: rem_life_code, length: 255 )
• Priority ( type: esriFieldTypeInteger, alias: Priority )
• bldg_sq_ft ( type: esriFieldTypeInteger, alias: bldg_sq_ft )
• percent_coverage ( type: esriFieldTypeInteger, alias: percent_coverage )
• quantity ( type: esriFieldTypeInteger, alias: quantity )
• uom ( type: esriFieldTypeString, alias: uom, length: 255 )
• uom_other ( type: esriFieldTypeString, alias: uom_other, length: 255 )
• window_height ( type: esriFieldTypeInteger, alias: window_height )
• window_width ( type: esriFieldTypeInteger, alias: window_width )
• life_range ( type: esriFieldTypeInteger, alias: life_range )
• notes ( type: esriFieldTypeString, alias: notes, length: 255 )
• def_count ( type: esriFieldTypeInteger, alias: def_count )
• deficiency_yesno ( type: esriFieldTypeString, alias: deficiency_yesno, length: 255 )
• ada_count ( type: esriFieldTypeInteger, alias: ada_count )
• ada_yesno ( type: esriFieldTypeString, alias: ada_yesno, length: 255 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• assessment_photo_name ( type: esriFieldTypeString, alias: assessment_photo_name, length: 1000 )
• attachment_count ( type: esriFieldTypeInteger, alias: attachment_count )
• photos_reviewed ( type: esriFieldTypeString, alias: photos_reviewed, length: 255 )
• siteid ( type: esriFieldTypeString, alias: siteid, length: 255 )
• buildingid ( type: esriFieldTypeString, alias: buildingid, length: 255 )
• reporting_system ( type: esriFieldTypeString, alias: reporting_system, length: 255 )
• Code ( type: esriFieldTypeString, alias: Code, length: 1073741822 )
• UnitCost ( type: esriFieldTypeDouble, alias: UnitCost )
• TotalCost ( type: esriFieldTypeDouble, alias: TotalCost )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata