Name: SAFE

Display Field: ASSET_TYPE

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

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: Asset_Type_Subtype

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSET_TYPE_SUBTYPE ( type: esriFieldTypeSmallInteger, alias: Asset Type Subtype, editable: true, nullable: true, defaultValue: 0, modelName: Asset_Type_Subtype )
• ASSET_TYPE ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Asset_Type , Coded Values: [Extinguisher: Extinguisher] , [Emergency Light: Emergency Light] , [Unknown: Unknown] , ...10 more... )
• ASSET_TAG ( type: esriFieldTypeString, alias: Asset Tag, editable: true, nullable: false, length: 20, defaultValue: null, modelName: Asset_Tag )
• SITE ( type: esriFieldTypeString, alias: Site, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Site , Coded Values: [301 Building: 301 Building] , [310 W. Martin: 310 W. Martin] , [Alexander: Alexander] , ...261 more... )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Location )
• LEGACYID ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LegacyID )
• FLOOR ( type: esriFieldTypeString, alias: Floor, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Floor , Coded Values: [Basement: Basement] , [1st Floor: 1st Floor] , [2nd Floor: 2nd Floor] , ...12 more... )
• ROOM_TYPE ( type: esriFieldTypeString, alias: Room Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Room_Type , Coded Values: [Attic: Attic] , [Break Room: Break Room] , [Classroom: Classroom] , ...43 more... )
• ROOM_ID ( type: esriFieldTypeString, alias: Room ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Room_ID )
• MAKE ( type: esriFieldTypeString, alias: Make, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Make )
• MODEL ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• TYPE ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Type )
• CERTIFICATION_DATE ( type: esriFieldTypeDate, alias: Certification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Certification_Date )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Install_Date )
• INSTALL_CONTRACTOR ( type: esriFieldTypeString, alias: Install Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Install_Contractor )
• LIFECYCLE_YRS ( type: esriFieldTypeString, alias: Lifecycle Yrs, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Lifecycle_Yrs )
• SIZE_ ( type: esriFieldTypeString, alias: Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Size_ )
• WEIGHT ( type: esriFieldTypeString, alias: Weight, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Weight )
• FACILITYID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: false, length: 20, defaultValue: null, modelName: FacilityID )
• EXISTING ( type: esriFieldTypeString, alias: Existing, editable: true, nullable: false, length: 20, defaultValue: Yes, modelName: Existing , Coded Values: [Yes: Yes] , [No: No] )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• FO_ASSET_ID ( type: esriFieldTypeString, alias: FO_ASSET_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FO_ASSET_ID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Types:

ID: 11
Name: Other
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• EXISTING:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 11
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 10
Name: Ladder
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Werner: Werner] , [Other: Other]
• TYPE:
  Coded Values:
• CERTIFICATION_DATE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• INSTALL_CONTRACTOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• SIZE_:
  Coded Values: [4 ft.: 4 ft.] , [6 ft.: 6 ft.] , [8 ft.: 8 ft.] , ...5 more...
• WEIGHT:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Ladder
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 10
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 1
Name: AED
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Phillips: Phillips] , [Other: Other]
• INSTALL_CONTRACTOR:
  Coded Values:
• SIZE_:
  Coded Values:
• WEIGHT:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: AED
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 1
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 0
Name: Unknown
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• EXISTING:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 0
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 3
Name: Digital Video Recorder
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• CERTIFICATION_DATE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• INSTALL_CONTRACTOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• SIZE_:
  Coded Values:
• WEIGHT:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Digital Video Recorder
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 3
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 2
Name: Camera
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Altronix: Altronix] , [APC: APC] , [Bosch: Bosch] , ...5 more...
• CERTIFICATION_DATE:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• SIZE_:
  Coded Values:
• WEIGHT:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Camera
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 2
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 5
Name: Emergency System
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [FCI: FCI] , [Fike: Fike] , [Fire Lite: Fire Lite] , ...2 more...
• TYPE:
  Coded Values: [Fire: Fire] , [Other: Other]
• CERTIFICATION_DATE:
  Coded Values:
• INSTALL_CONTRACTOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• SIZE_:
  Coded Values:
• WEIGHT:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Emergency System
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 5
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 4
Name: Emergency Light
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Cooper: Cooper] , [Dual Lite: Dual Lite] , [EELP: EELP] , ...5 more...
• TYPE:
  Coded Values: [Emergency: Emergency] , [Exit: Exit] , [Combo: Combo] , ...1 more...
• CERTIFICATION_DATE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• INSTALL_CONTRACTOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• SIZE_:
  Coded Values:
• WEIGHT:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Emergency Light
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 4
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 7
Name: Extinguisher
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Amerex: Amerex] , [Ansul : Ansul ] , [Badger: Badger] , ...6 more...
• TYPE:
  Coded Values: [ABC: ABC] , [BC: BC] , [Other: Other]
• INSTALL_DATE:
  Coded Values:
• INSTALL_CONTRACTOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• SIZE_:
  Coded Values:
• WEIGHT:
  Coded Values: [2.5: 2.5] , [5: 5] , [10: 10] , ...2 more...
• EXISTING:
  Inherited
Templates:
• Name: Extinguisher
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 7
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 6
Name: Exit Light
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Cooper: Cooper] , [Other: Other]
• CERTIFICATION_DATE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• INSTALL_CONTRACTOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• SIZE_:
  Coded Values:
• WEIGHT:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Exit Light
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 6
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 9
Name: Fire Suppression Panel
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Auto-pulse: Auto-pulse] , [Fenwal: Fenwal] , [Fike: Fike] , ...1 more...
• TYPE:
  Coded Values: [Halon 1301: Halon 1301] , [FM200: FM200] , [Other: Other]
• CERTIFICATION_DATE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• INSTALL_CONTRACTOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• SIZE_:
  Coded Values:
• WEIGHT:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Fire Suppression Panel
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 9
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 8
Name: Fire Suppression Device
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• INSTALL_DATE:
  Coded Values:
• INSTALL_CONTRACTOR:
  Coded Values:
• LIFECYCLE_YRS:
  Coded Values:
• SIZE_:
  Coded Values:
• WEIGHT:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Fire Suppression Device
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 8
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  TYPE: null
  CERTIFICATION_DATE: null
  INSTALL_DATE: null
  INSTALL_CONTRACTOR: null
  LIFECYCLE_YRS: null
  SIZE_: null
  WEIGHT: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

Relationships:

• FACILITY_AND_OPERATIONS_ASSETS (5) -- Related To: FACILITY AND OPERATIONS ASSETS (1)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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