Name: AQUA

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: [Pool Water Feature: Pool Water Feature] , [Lifeguard Chair: Lifeguard Chair] , [Pool Filtration System: Pool Filtration System] , ...6 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: RoomID )
• 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 )
• SN ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SN )
• TYPE ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Type )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Install_Date )
• FACILITYID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• EXISTING ( type: esriFieldTypeString, alias: Existing, editable: true, nullable: true, 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: 1
Name: Diving Board
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Durafirm: Durafirm] , [KDI Paragon: KDI Paragon] , [SR Smith: SR Smith] , ...1 more...
• TYPE:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Diving Board
  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
  SN: null
  TYPE: null
  INSTALL_DATE: null
  FACILITYID: null
  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
  SN: null
  TYPE: null
  INSTALL_DATE: null
  FACILITYID: null
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 3
Name: Lifeguard Chair
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• SN:
  Coded Values:
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Lifeguard Chair
  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
  SN: null
  TYPE: null
  INSTALL_DATE: null
  FACILITYID: null
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 2
Name: Ladder
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [KDI Paragon: KDI Paragon] , [Other: Other]
• SN:
  Coded Values:
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Ladder
  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
  SN: null
  TYPE: null
  INSTALL_DATE: null
  FACILITYID: null
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 5
Name: Pool Filtration System
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Defender: Defender] , [MerMade: MerMade] , [Pentair: Pentair] , ...3 more...
• SN:
  Coded Values:
• TYPE:
  Coded Values: [Sand: Sand] , [DE: DE]
• EXISTING:
  Inherited
Templates:
• Name: Pool Filtration 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
  SN: null
  TYPE: null
  INSTALL_DATE: null
  FACILITYID: null
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 4
Name: Pool Blanket Reel
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Recreonics: Recreonics] , [Other: Other]
• SN:
  Coded Values:
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Pool Blanket Reel
  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
  SN: null
  TYPE: null
  INSTALL_DATE: null
  FACILITYID: null
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 7
Name: Pool Water Feature
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Rainbird: Rainbird] , [Waterplay: Waterplay] , [Other: Other]
• SN:
  Coded Values:
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Pool Water Feature
  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
  SN: null
  TYPE: null
  INSTALL_DATE: null
  FACILITYID: null
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 6
Name: Pool Slide
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Splashtacular: Splashtacular] , [Natural Structures: Natural Structures] , [Other: Other]
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Pool Slide
  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
  SN: null
  TYPE: null
  INSTALL_DATE: null
  FACILITYID: null
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 8
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: 8
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  SN: null
  TYPE: null
  INSTALL_DATE: null
  FACILITYID: null
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

Relationships:

• FACILITY_AND_OPERATIONS_ASSETS (1) -- 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