Name: Real Property-Building

Display Field: Facility_Name

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• School_ID (type: esriFieldTypeString, alias: School ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Facility_ID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Building_Number (type: esriFieldTypeString, alias: Building Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Facility_Name (type: esriFieldTypeString, alias: Facility Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Building_Name (type: esriFieldTypeString, alias: Building Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Building_Use (type: esriFieldTypeString, alias: Building Use, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true, Coded Values: [Active School: Active School], [Admin: Admin], [Closed: Closed], ... 4 more ...)
• Facility_Type (type: esriFieldTypeString, alias: Facility Type, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true, Coded Values: [Vacant Land: Vacant Land], [Closed: Closed], [Active School: Active School], ... 14 more ...)
• Facility_Address (type: esriFieldTypeString, alias: Facility Address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• CPS_Maintenance_Program (type: esriFieldTypeString, alias: CPS Maintenance Program, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true, Coded Values: [CPS: CPS], [Opt In: Opt In], [Closed: Closed], ... 2 more ...)
• Quality_Region (type: esriFieldTypeString, alias: Quality Region, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [QS-1A: QS-1A], [QS-1B: QS-1B], [QS-2A: QS-2A], ... 18 more ...)
• Building_Location (type: esriFieldTypeString, alias: Building Location, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Assessment_Year (type: esriFieldTypeSmallInteger, alias: Assessment Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Number_of_Floors (type: esriFieldTypeSmallInteger, alias: Number of Floors, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 10])
• Year_Constructed (type: esriFieldTypeSmallInteger, alias: Year Constructed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Building_Size_SQFT (type: esriFieldTypeInteger, alias: Building Size SQFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Classroom_Count (type: esriFieldTypeSmallInteger, alias: Classroom Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Classroom_Size_SQFT (type: esriFieldTypeInteger, alias: Total Classroom Size SQFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Carpet_Classroom_Size_SQF (type: esriFieldTypeInteger, alias: Total Carpet Classroom Size SQFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Classroom_Carpet (type: esriFieldTypeInteger, alias: Total Classroom Carpet, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Wood_Classroom_Size_SQFT (type: esriFieldTypeInteger, alias: Total Wood Classroom Size SQFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Total_Classroom_Wood (type: esriFieldTypeInteger, alias: Total Classroom Wood, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Auditorium_Count (type: esriFieldTypeSmallInteger, alias: Auditorium Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Auditorium_Size (type: esriFieldTypeInteger, alias: Auditorium Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Gym_Count (type: esriFieldTypeSmallInteger, alias: Gym Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Gym_Size (type: esriFieldTypeInteger, alias: Gym Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pool_Count (type: esriFieldTypeSmallInteger, alias: Pool Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pool_Size (type: esriFieldTypeInteger, alias: Pool Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Luncnroom_Count (type: esriFieldTypeSmallInteger, alias: Luncnroom Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lunchroom_Size (type: esriFieldTypeInteger, alias: Lunchroom Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Kitchen_Count (type: esriFieldTypeSmallInteger, alias: Kitchen Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Kitchen_Size (type: esriFieldTypeInteger, alias: Kitchen Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Admin_Office_Count (type: esriFieldTypeSmallInteger, alias: Admin Office Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Admin_Office_Size (type: esriFieldTypeInteger, alias: Admin Office Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Restroom_Count (type: esriFieldTypeSmallInteger, alias: Restroom Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Restroom_Size (type: esriFieldTypeInteger, alias: Restroom Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Restroom_Urinal (type: esriFieldTypeSmallInteger, alias: Restroom Urinal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Restroom_Toilet (type: esriFieldTypeSmallInteger, alias: Restroom Toilet, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Restroom_Sink (type: esriFieldTypeSmallInteger, alias: Restroom Sink, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Locker_Room_Count (type: esriFieldTypeSmallInteger, alias: Locker Room Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Locker_Room_Size (type: esriFieldTypeInteger, alias: Locker Room Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Locker_Room_Urinal (type: esriFieldTypeSmallInteger, alias: Locker Room Urinal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Locker_Room_Toilet (type: esriFieldTypeSmallInteger, alias: Locker Room Toilet, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Locker_Room_Sink (type: esriFieldTypeSmallInteger, alias: Locker Room Sink, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Entrance_Count (type: esriFieldTypeSmallInteger, alias: Entrance Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Entrance_Door (type: esriFieldTypeSmallInteger, alias: Entrance Door, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cooridor_Count (type: esriFieldTypeSmallInteger, alias: Cooridor Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Corridor_Size (type: esriFieldTypeInteger, alias: Corridor Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Janitor_Closet_Count (type: esriFieldTypeSmallInteger, alias: Janitor Closet Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BM_Name (type: esriFieldTypeString, alias: Building Manager Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• BM_Email (type: esriFieldTypeString, alias: BM Email, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• BM_Phone (type: esriFieldTypeString, alias: BM Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FM_Name (type: esriFieldTypeString, alias: Facility Manager Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• FM_Email (type: esriFieldTypeString, alias: FM Email, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• FM_Phone (type: esriFieldTypeString, alias: FM Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ENG1_Name (type: esriFieldTypeString, alias: ENG1 Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ENG1_Email (type: esriFieldTypeString, alias: ENG1 Email, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ENG1_Phone (type: esriFieldTypeString, alias: ENG1 Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ENG2_Name (type: esriFieldTypeString, alias: ENG2 Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ENG2_Email (type: esriFieldTypeString, alias: ENG2 Email, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ENG2_Phone (type: esriFieldTypeString, alias: ENG2 Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ENG3_Name (type: esriFieldTypeString, alias: ENG3 Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ENG3_Email (type: esriFieldTypeString, alias: ENG3 Email, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ENG3_Phone (type: esriFieldTypeString, alias: ENG3 Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CM_Name (type: esriFieldTypeString, alias: Custodial Manager Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• CM_Email (type: esriFieldTypeString, alias: CM Email, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• CM_Phone (type: esriFieldTypeString, alias: CM Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SRCM_Name (type: esriFieldTypeString, alias: Senior Custodial Manager Name, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [QS-1A: QS-1A], [QS-1B: QS-1B], [QS-2A: QS-2A], ... 18 more ...)
• SRCM_Email (type: esriFieldTypeString, alias: SRCM Email, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• SRCM_Phone (type: esriFieldTypeString, alias: SRCM Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• DCM_Name (type: esriFieldTypeString, alias: District Custodial Manager Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• DCM_Email (type: esriFieldTypeString, alias: DCM Email, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• DCM_Phone (type: esriFieldTypeString, alias: DCM Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• FML_Name (type: esriFieldTypeString, alias: Facility Management Lead Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• FML_Email (type: esriFieldTypeString, alias: FML Email, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• FML_Phone (type: esriFieldTypeString, alias: FML Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• RM_Name (type: esriFieldTypeString, alias: Regional Manager Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• RM_Email (type: esriFieldTypeString, alias: RM Email, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• RM_Phone (type: esriFieldTypeString, alias: RM Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)

Templates:

Name: Real Property-Building
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• CPS_Maintenance_Program: CPS
• Number_of_Floors: 1
• Classroom_Count: 0
• Auditorium_Count: 0
• Gym_Count: 0
• Pool_Count: 0
• Luncnroom_Count: 0
• Kitchen_Count: 0
• Admin_Office_Count: 0
• Restroom_Count: 0
• Restroom_Urinal: 0
• Restroom_Toilet: 0
• Restroom_Sink: 0
• Locker_Room_Count: 0
• Locker_Room_Urinal: 0
• Locker_Room_Toilet: 0
• Locker_Room_Sink: 0
• Entrance_Count: 0
• Entrance_Door: 0
• Cooridor_Count: 0
• Janitor_Closet_Count: 0

Relationships:

• ReProp_Campus (7) -- Related To: ReProp_Campus (6)
• ReProp_Campus (8) -- Related To: ReProp_Campus (6)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/22/2023 5:31:09 PM

Schema Last Edit Date: 2/22/2023 5:31:09 PM

Data Last Edit Date: 2/22/2023 5:31:09 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat