Name: Building Equipment

Display Field: Building

Type: Table

Geometry Type: N/A

Description:

Service Item Id: efdb09e89d7a44528455037bbfa5cf21

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GUID ( type: esriFieldTypeGUID, alias: GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: GUID )
• Building ( type: esriFieldTypeString, alias: Building, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Building , Coded Values: [CCD-3010: 3010 CCD] , [CCD-3019: 3019 CCD] , [CCD-ARC: ARC] , ...14 more... )
• Floor ( type: esriFieldTypeString, alias: Floor, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Floor , Coded Values: [00BF: Basement] , [01FL: 1st Floor] , [02FL: 2nd Floor] , ...6 more... )
• Room ( type: esriFieldTypeString, alias: Room, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Room )
• Asset_Type ( type: esriFieldTypeString, alias: Asset Type (MUNIS), editable: true, nullable: true, length: 50, defaultValue: null, modelName: Asset_Type , Coded Values: [AIR COMPRESSOR: AIR COMPRESSOR] , [AIR CONDITIONING: AIR CONDITIONING] , [AIR HANDLING UNITS: AIR HANDLING UNITS] , ...42 more... )
• Asset_Code ( type: esriFieldTypeString, alias: Asset Code (MUNIS), editable: true, nullable: true, length: 50, defaultValue: null, modelName: Asset_Code )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Description )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• Model_Year ( type: esriFieldTypeString, alias: Model Year, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model_Year )
• Serial_Num ( type: esriFieldTypeString, alias: Serial Number, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Serial_Num )
• Install_Date ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Install_Date )
• Estimated_Life ( type: esriFieldTypeString, alias: Estimated Useful Life (Years), editable: true, nullable: true, length: 25, defaultValue: null, modelName: Estimated_Life )
• Likelihood_Fail ( type: esriFieldTypeString, alias: Likelihood of Failure, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Likelihood_Fail , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Criticality ( type: esriFieldTypeString, alias: Criticality, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Criticality , Coded Values: [Catastrophic: Catastrophic] , [High: High] , [Low: Low] , ...1 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 255, defaultValue: null, modelName: Creator )
• Created_Date ( type: esriFieldTypeDate, alias: Created_Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: Created_Date )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Comments )
• EAM_NUM ( type: esriFieldTypeString, alias: EAM Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EAM_NUM )
• Asset_Type_Other ( type: esriFieldTypeString, alias: Asset Type (Other), editable: true, nullable: true, length: 75, defaultValue: null, modelName: Asset_Type_Other )
• Parent_Code ( type: esriFieldTypeString, alias: Parent Code (MUNIS), editable: true, nullable: true, length: 50, defaultValue: null, modelName: Parent_Code )
• Serv_Dept ( type: esriFieldTypeString, alias: Servicing Department (MUNIS), editable: true, nullable: true, length: 8, defaultValue: 1620, modelName: Serv_Dept )
• Description_MUNIS ( type: esriFieldTypeString, alias: Description (MUNIS), editable: true, nullable: true, length: 100, defaultValue: null, modelName: Description_MUNIS )
• Parent_Dept ( type: esriFieldTypeString, alias: Parent Department (MUNIS), editable: true, nullable: true, length: 8, defaultValue: 1620, modelName: Parent_Dept )
• Category ( type: esriFieldTypeString, alias: Category (MUNIS), editable: true, nullable: true, length: 3, defaultValue: E, modelName: Category )
• Admin_Dept ( type: esriFieldTypeString, alias: Administrative Department (MUNIS), editable: true, nullable: true, length: 8, defaultValue: 1620, modelName: Admin_Dept )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Status , Coded Values: [Active: Active] , [Retired: Retired] )

Templates:

• Name: Building Equipment
  Description:
  Prototype:
  Admin_Dept: 1620
  Category: E
  GUID: null
  Building: null
  Floor: null
  Room: null
  Asset_Type: null
  Asset_Code: null
  Description: null
  Manufacturer: null
  Model: null
  Model_Year: null
  Serial_Num: null
  Install_Date: null
  Estimated_Life: null
  Likelihood_Fail: null
  Criticality: null
  Status: null
  Parent_Dept: 1620
  Description_MUNIS: null
  Comments: null
  EAM_NUM: null
  Asset_Type_Other: null
  Parent_Code: null
  Serv_Dept: 1620
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• OCGIS.BuildingInteriorSpace (0) -- Related To: Building Interior Spaces (0)
• OCGIS.BuildingInteriorSpace (1) -- Related To: Basement (13)
• OCGIS.BuildingInteriorSpace (2) -- Related To: First Floor (14)
• OCGIS.BuildingInteriorSpace (3) -- Related To: Second Floor (15)
• OCGIS.BuildingInteriorSpace (4) -- Related To: Third Floor (16)
• OCGIS.BuildingInteriorSpace (5) -- Related To: Fourth Floor (17)
• OCGIS.BuildingInteriorSpace (6) -- Related To: Mechanical Floor (18)
• OCGIS.BuildingInteriorSpace (7) -- Related To: Fifth Floor (19)
• OCGIS.Building (8) -- Related To: Buildings (3)

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Sync,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: Created_Date
• Creator Field: Creator
• Edit Date Field:
• Editor Field:

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

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