Layers:

Layer: Orange County Schools (1)

Name: Orange County Schools

Display Field: building_site

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 851f8e70ce33484c89770a917c5a1a73

Copyright Text:

Default Visibility: true

MaxRecordCount: 4000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -79.19900999999999
YMin: 35.87913000000003
XMax: 35.945940000000064
YMax: 36.11082000000005
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: site
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: <all other values>
UniqueValueInfos:
• Value: A.L. Stanback Middle 304
  Label: A.L. Stanback Middle 304
  Description: N/A
  Symbol:
  
• Value: Administrative Annex
  Label: Administrative Annex
  Description: N/A
  Symbol:
  
• Value: Administrative Annex II (Transp Dispatch)
  Label: Administrative Annex II (Transp Dispatch)
  Description: N/A
  Symbol:
  
• Value: Carrboro Elementary
  Label: Carrboro Elementary
  Description: N/A
  Symbol:
  
• Value: Carrboro High
  Label: Carrboro High
  Description: N/A
  Symbol:
  
• Value: Cedar Ridge High School 310
  Label: Cedar Ridge High School 310
  Description: N/A
  Symbol:
  
• Value: Central Elementary 312
  Label: Central Elementary 312
  Description: N/A
  Symbol:
  
• Value: Central Office
  Label: Central Office
  Description: N/A
  Symbol:
  
• Value: Chapel Hill High
  Label: Chapel Hill High
  Description: N/A
  Symbol:
  
• Value: Culbreth Middle
  Label: Culbreth Middle
  Description: N/A
  Symbol:
  
• Value: East Chapel Hill High
  Label: East Chapel Hill High
  Description: N/A
  Symbol:
  
• Value: Efland Cheeks Elementary 324
  Label: Efland Cheeks Elementary 324
  Description: N/A
  Symbol:
  
• Value: Ephesus Elementary
  Label: Ephesus Elementary
  Description: N/A
  Symbol:
  
• Value: Estes Hill Elementary
  Label: Estes Hill Elementary
  Description: N/A
  Symbol:
  
• Value: Frank Porter Graham Elementary
  Label: Frank Porter Graham Elementary
  Description: N/A
  Symbol:
  
• Value: Glenwood Elementary
  Label: Glenwood Elementary
  Description: N/A
  Symbol:
  
• Value: Grady A. Brown Elementary 328
  Label: Grady A. Brown Elementary 328
  Description: N/A
  Symbol:
  
• Value: Gravelly Hill Middle 327
  Label: Gravelly Hill Middle 327
  Description: N/A
  Symbol:
  
• Value: Hillsborough Elementary 329
  Label: Hillsborough Elementary 329
  Description: N/A
  Symbol:
  
• Value: Lincoln Center
  Label: Lincoln Center
  Description: N/A
  Symbol:
  
• Value: Maintenance Department
  Label: Maintenance Department
  Description: N/A
  Symbol:
  
• Value: McDougle Middle/Elementary
  Label: McDougle Middle/Elementary
  Description: N/A
  Symbol:
  
• Value: Morris Grove Elementary
  Label: Morris Grove Elementary
  Description: N/A
  Symbol:
  
• Value: New Hope Elementary 330
  Label: New Hope Elementary 330
  Description: N/A
  Symbol:
  
• Value: Northside Elementary
  Label: Northside Elementary
  Description: N/A
  Symbol:
  
• Value: Orange High School 332
  Label: Orange High School 332
  Description: N/A
  Symbol:
  
• Value: Orange Middle 316
  Label: Orange Middle 316
  Description: N/A
  Symbol:
  
• Value: Partnership Academy Alternative School
  Label: Partnership Academy Alternative School
  Description: N/A
  Symbol:
  
• Value: Pathways Elementary 336
  Label: Pathways Elementary 336
  Description: N/A
  Symbol:
  
• Value: Phillips Middle
  Label: Phillips Middle
  Description: N/A
  Symbol:
  
• Value: Phoenix Academy
  Label: Phoenix Academy
  Description: N/A
  Symbol:
  
• Value: Rashkis Elementary
  Label: Rashkis Elementary
  Description: N/A
  Symbol:
  
• Value: River Park Elementary 308
  Label: River Park Elementary 308
  Description: N/A
  Symbol:
  
• Value: Scroggs Elementary
  Label: Scroggs Elementary
  Description: N/A
  Symbol:
  
• Value: Seawell Elementary
  Label: Seawell Elementary
  Description: N/A
  Symbol:
  
• Value: Smith Middle
  Label: Smith Middle
  Description: N/A
  Symbol:
  
• Value: Transportation Department
  Label: Transportation Department
  Description: N/A
  Symbol:
  
• Value: Welcome Center
  Label: Welcome Center
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• building_site ( type: esriFieldTypeString, alias: building_site, length: 1073741822 )
• building ( type: esriFieldTypeString, alias: building, length: 1073741822 )
• site ( type: esriFieldTypeString, alias: site, length: 1073741822 )
• building_id ( type: esriFieldTypeString, alias: building_id, length: 1073741822 )
• Field5 ( type: esriFieldTypeString, alias: Field5, length: 1073741822 )
• Field5_X ( type: esriFieldTypeDouble, alias: Field5_X )
• Field5_Y ( type: esriFieldTypeDouble, alias: Field5_Y )
• site_id ( type: esriFieldTypeString, alias: site_id, length: 1073741822 )
• sqft ( type: esriFieldTypeInteger, alias: sqft )
• yr_built ( type: esriFieldTypeString, alias: yr_built, length: 1073741822 )
• fencing ( type: esriFieldTypeInteger, alias: fencing )
• parking_lot ( type: esriFieldTypeInteger, alias: parking_lot )
• sidewalk ( type: esriFieldTypeInteger, alias: sidewalk )
• playground_asphalt ( type: esriFieldTypeInteger, alias: playground_asphalt )
• roof ( type: esriFieldTypeInteger, alias: roof )
• floors ( type: esriFieldTypeInteger, alias: floors )
• latitude ( type: esriFieldTypeDouble, alias: latitude )
• longitude ( type: esriFieldTypeDouble, alias: longitude )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Layer: Condition Assessment (2)

Name: Condition Assessment

Display Field: building_name_assessment

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 851f8e70ce33484c89770a917c5a1a73

Copyright Text:

Default Visibility: false

MaxRecordCount: 4000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: -84.45700570599996
YMin: 5.6843418860808015E-14
XMax: 36.07670000000007
YMax: 39.168804882000074
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [170, 153, 56, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: 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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID )
• uniquerowid ( type: esriFieldTypeGUID, alias: RowID, length: 38 )
• date_collected ( type: esriFieldTypeDate, alias: Date Collected, length: 8 )
• assessment ( type: esriFieldTypeString, alias: Select Assessment Type, length: 255 )
• assessment_id ( type: esriFieldTypeString, alias: Assessment Record ID, length: 255 )
• site ( type: esriFieldTypeString, alias: Site, length: 255 )
• building_name_assessment ( type: esriFieldTypeString, alias: Building, length: 255 )
• parking_lot ( type: esriFieldTypeString, alias: Parking Lot, length: 255 )
• floor ( type: esriFieldTypeString, alias: Floor, length: 255 )
• room_number ( type: esriFieldTypeString, alias: Room Name or Number, length: 255 )
• latitude ( type: esriFieldTypeDouble, alias: Latitude )
• longitude ( type: esriFieldTypeDouble, alias: Longitude )
• system ( type: esriFieldTypeString, alias: System, length: 255 )
• subsystem ( type: esriFieldTypeString, alias: Select a Subsystem, length: 255 )
• input_component ( type: esriFieldTypeString, alias: Select a Component, length: 255 )
• other_component ( type: esriFieldTypeString, alias: Specify Component, length: 255 )
• input_component_code ( type: esriFieldTypeString, alias: Component Pricing Code, length: 255 )
• rem_life_code ( type: esriFieldTypeString, alias: rem_life_code, length: 255 )
• bldg_sq_ft ( type: esriFieldTypeInteger, alias: Building Square Feet )
• percent_coverage ( type: esriFieldTypeInteger, alias: Percentage of Coverage )
• quantity ( type: esriFieldTypeInteger, alias: Quantity )
• uom ( type: esriFieldTypeString, alias: Unit of Measure, length: 255 )
• uom_other ( type: esriFieldTypeString, alias: Unit of Measure (Other), length: 255 )
• window_height ( type: esriFieldTypeInteger, alias: Window Height (ft) )
• window_width ( type: esriFieldTypeInteger, alias: Window Width (ft) )
• life_range ( type: esriFieldTypeInteger, alias: life range )
• notes ( type: esriFieldTypeString, alias: Notes or Other, length: 255 )
• def_count ( type: esriFieldTypeInteger, alias: Deficiency Count )
• deficiency_yesno ( type: esriFieldTypeString, alias: Is there a deficiency?, length: 255 )
• ada_count ( type: esriFieldTypeInteger, alias: ADA Deficiency Count )
• ada_yesno ( type: esriFieldTypeString, alias: Is there an ADA deficiency?, 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: Asssessment Photo Name(s), length: 1000 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• 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 )

Tables:

Table: Building With Cost (4)

Name: Building With Cost

Display Field: site_name

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 )
• globalid ( type: esriFieldTypeGUID, alias: globalid, length: 38 )
• site_name ( type: esriFieldTypeString, alias: site_name, length: 255 )
• building_name ( type: esriFieldTypeString, alias: building_name, length: 255 )
• building_id ( type: esriFieldTypeString, alias: building_id, length: 255 )
• building_year_built ( type: esriFieldTypeInteger, alias: building_year_built )
• building_sq_ft ( type: esriFieldTypeInteger, alias: building_sq_ft )
• building_roof ( type: esriFieldTypeInteger, alias: building_roof )
• site_fencing ( type: esriFieldTypeInteger, alias: site_fencing )
• site_parkinglot ( type: esriFieldTypeInteger, alias: site_parkinglot )
• site_sidewalk ( type: esriFieldTypeInteger, alias: site_sidewalk )
• site_play_asphalt ( type: esriFieldTypeInteger, alias: site_play_asphalt )
• building_floor ( type: esriFieldTypeInteger, alias: building_floor )
• building_notes ( type: esriFieldTypeString, alias: building_notes, length: 500 )
• building_photo_name ( type: esriFieldTypeString, alias: building_photo_name, length: 500 )
• parentrowid ( type: esriFieldTypeGUID, alias: parentrowid, length: 38 )
• 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 )
• district ( type: esriFieldTypeString, alias: district, length: 255 )
• school_type ( type: esriFieldTypeString, alias: school_type, length: 255 )
• UnitCost ( type: esriFieldTypeSmallInteger, alias: UnitCost )
• TotalReplacementCost ( type: esriFieldTypeInteger, alias: TotalReplacementCost )

Table: FCA Deficiencies (5)

Name: FCA Deficiencies

Display Field: def_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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• deficiency_parent_record ( type: esriFieldTypeString, alias: Parent Record, length: 255 )
• def_assessment ( type: esriFieldTypeString, alias: Parent Assessment, length: 255 )
• def_system ( type: esriFieldTypeString, alias: Parent System, length: 255 )
• def_subsystem ( type: esriFieldTypeString, alias: Parent Subsystem, length: 255 )
• def_input_component ( type: esriFieldTypeString, alias: Parent Component, length: 255 )
• def_subcategory ( type: esriFieldTypeString, alias: Parent Subcategory (Subsystem), length: 255 )
• deficiencyitem ( type: esriFieldTypeString, alias: Deficiency Item, length: 255 )
• unitofmeasurement ( type: esriFieldTypeString, alias: Unit of Measurement, length: 255 )
• def_quantity ( type: esriFieldTypeInteger, alias: Quantity )
• locationnote ( type: esriFieldTypeString, alias: Location / Note, length: 500 )
• def_comments ( type: esriFieldTypeString, alias: Deficiency Comments, length: 1000 )
• priority ( type: esriFieldTypeString, alias: Priority, length: 255 )
• def_code ( type: esriFieldTypeString, alias: Deficiency Code, length: 255 )
• def_date_collected ( type: esriFieldTypeDate, alias: Date Collected, length: 8 )
• parentrowid ( type: esriFieldTypeGUID, alias: ParentRowID, length: 38 )
• 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 )
• def_site ( type: esriFieldTypeString, alias: Parent Site, length: 256 )
• def_building_name_assessment ( type: esriFieldTypeString, alias: Parent Building, length: 256 )
• def_photo_name ( type: esriFieldTypeString, alias: Deficiency Photo Name(s), length: 1000 )
• parentsiteid ( type: esriFieldTypeString, alias: Parent Site ID, length: 255 )
• parentbuildingid ( type: esriFieldTypeString, alias: Parent Building ID, length: 255 )
• def_reporting_system ( type: esriFieldTypeString, alias: Reporting System, length: 255 )

Table: FCA With Cost (6)

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 )

Table: FCA Predictor (7)

Name: FCA Predictor

Display Field: 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 )
• district ( type: esriFieldTypeString, alias: district, length: 255 )
• siteid ( type: esriFieldTypeString, alias: siteid, length: 255 )
• site ( type: esriFieldTypeString, alias: site, length: 255 )
• buildingid ( type: esriFieldTypeString, alias: buildingid, length: 255 )
• building ( type: esriFieldTypeString, alias: building, length: 255 )
• floor ( type: esriFieldTypeString, alias: floor, length: 255 )
• room_number ( type: esriFieldTypeString, alias: room_number, length: 255 )
• system ( type: esriFieldTypeString, alias: system, length: 255 )
• reporting_system ( type: esriFieldTypeString, alias: reporting_system, length: 255 )
• subsystem ( type: esriFieldTypeString, alias: subsystem, length: 255 )
• input_component ( type: esriFieldTypeString, alias: input_component, length: 255 )
• input_component_code ( type: esriFieldTypeString, alias: input_component_code, length: 255 )
• life_code ( type: esriFieldTypeString, alias: life_code, length: 255 )
• expected_life ( type: esriFieldTypeInteger, alias: expected_life )
• remaining_life ( type: esriFieldTypeInteger, alias: remaining_life )
• RuL_percent ( type: esriFieldTypeDouble, alias: RuL_percent )
• 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 )
• UnitCost ( type: esriFieldTypeDouble, alias: UnitCost )
• TotalCost ( type: esriFieldTypeDouble, alias: TotalCost )
• window_height ( type: esriFieldTypeInteger, alias: window_height )
• window_width ( type: esriFieldTypeInteger, alias: window_width )
• 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 )
• attachment_count ( type: esriFieldTypeInteger, alias: attachment_count )
• photos_reviewed ( type: esriFieldTypeString, alias: photos_reviewed, 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 )
• latitude ( type: esriFieldTypeDouble, alias: latitude )
• longitude ( type: esriFieldTypeDouble, alias: longitude )

Table: Deficiency Predictor (8)

Name: Deficiency Predictor

Display Field: deficiency_parent_record

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 )
• globalid ( type: esriFieldTypeGUID, alias: globalid, length: 38 )
• deficiency_parent_record ( type: esriFieldTypeString, alias: deficiency_parent_record, length: 255 )
• site_id ( type: esriFieldTypeString, alias: site_id, length: 255 )
• site ( type: esriFieldTypeString, alias: site, length: 256 )
• building_id ( type: esriFieldTypeString, alias: building_id, length: 255 )
• building ( type: esriFieldTypeString, alias: building, length: 256 )
• assessment ( type: esriFieldTypeString, alias: assessment, length: 255 )
• reporting_system ( type: esriFieldTypeString, alias: reporting_system, length: 255 )
• system ( type: esriFieldTypeString, alias: system, length: 255 )
• subsystem ( type: esriFieldTypeString, alias: subsystem, length: 255 )
• input_component ( type: esriFieldTypeString, alias: input_component, length: 255 )
• subcategory ( type: esriFieldTypeString, alias: subcategory, length: 255 )
• deficiencyitem ( type: esriFieldTypeString, alias: deficiencyitem, length: 255 )
• unitofmeasurement ( type: esriFieldTypeString, alias: unitofmeasurement, length: 255 )
• quantity ( type: esriFieldTypeInteger, alias: quantity )
• UnitCost ( type: esriFieldTypeDouble, alias: UnitCost )
• TotalCost ( type: esriFieldTypeDouble, alias: TotalCost )
• locationnote ( type: esriFieldTypeString, alias: locationnote, length: 500 )
• def_comments ( type: esriFieldTypeString, alias: def_comments, length: 1000 )
• priority ( type: esriFieldTypeString, alias: priority, length: 255 )
• def_code ( type: esriFieldTypeString, alias: def_code, length: 255 )
• def_date_collected ( type: esriFieldTypeDate, alias: def_date_collected, length: 8 )
• parentrowid ( type: esriFieldTypeGUID, alias: parentrowid, length: 38 )
• 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 )

Table: Cost Summary By Bldg (9)

Name: Cost Summary By Bldg

Display Field: siteid

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: esriFieldTypeDouble, alias: OBJECTID )
• siteid ( type: esriFieldTypeString, alias: siteid, length: 255 )
• site ( type: esriFieldTypeString, alias: site, length: 255 )
• Building ( type: esriFieldTypeString, alias: Building, length: 255 )
• buildingid ( type: esriFieldTypeString, alias: buildingid, length: 255 )
• Current_Deficiencies ( type: esriFieldTypeDouble, alias: Current_Deficiencies )
• Yr_1_to_5_LC_Cost ( type: esriFieldTypeDouble, alias: Yr_1_to_5_LC_Cost )
• Yr_6_to_10_LC_Cost ( type: esriFieldTypeDouble, alias: Yr_6_to_10_LC_Cost )
• Total5YrNeed ( type: esriFieldTypeDouble, alias: Total5YrNeed )
• Total10YrNeed ( type: esriFieldTypeDouble, alias: Total10YrNeed )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )