Name: HVAC Equipment

Display Field: assetname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1b5871ab16ca44f4968b04e4fcc8d95c

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• assetid ( modelName: ASSETID_, nullable: true, editable: true, defaultValue: null, length: 100, alias: Asset ID , type: esriFieldTypeString )
• assetname ( modelName: ASSETNAME_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Asset Name , type: esriFieldTypeString )
• assettype ( modelName: ASSETTYPE_, nullable: true, editable: true, defaultValue: null, length: 50, alias: Asset Type , type: esriFieldTypeString )
• assetowner ( modelName: ASSETOWNER_, nullable: true, editable: true, defaultValue: null, length: 50, alias: Asset Owner , type: esriFieldTypeString , Coded Values: [Airports: Airports] , [HHSA: HHSA] , [Parks: Parks] , ...3 more... )
• legacyid ( modelName: LEGACYID_, nullable: true, editable: true, defaultValue: null, length: 50, alias: Legacy ID , type: esriFieldTypeString )
• tagnumber ( modelName: TAGNUMBER_, nullable: true, editable: true, defaultValue: null, length: 50, alias: Tag Number , type: esriFieldTypeString )
• status ( modelName: STATUS_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Status , type: esriFieldTypeString , Coded Values: [In Service: In Service] , [Out of Service: Out of Service] , [Spare: Spare] )
• parentid ( modelName: PARENTID_, nullable: true, editable: true, defaultValue: null, length: 100, alias: Parent ID, type: esriFieldTypeString )
• startupdate ( modelName: STARTUPDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Startup Date , type: esriFieldTypeDate )
• warrantydate ( modelName: WARRANTYDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Warranty Date , type: esriFieldTypeDate )
• conditionscore ( modelName: CONDITIONSCORE_, nullable: true, editable: true, defaultValue: null, alias: Condition Score , type: esriFieldTypeSmallInteger )
• conditiondate ( modelName: CONDITIONDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Condition Date , type: esriFieldTypeDate )
• address ( modelName: ADDRESS_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Address , type: esriFieldTypeString )
• location ( modelName: LOCATION_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location , type: esriFieldTypeString )
• site ( modelName: SITE_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Site, type: esriFieldTypeString , Coded Values: [JUWWTP0019: Heise Park WWTP] , [PVWWTP0007: Pine Valley WWTP] , [SVWWPS0010: Rancho San Diego PS] , ...39 more... )
• manufacturer ( modelName: MANUFACTURER_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Manufacturer , type: esriFieldTypeString )
• manphone ( modelName: MANPHONE_, nullable: true, editable: true, defaultValue: null, length: 16, alias: Manufacturer Phone # , type: esriFieldTypeString )
• manwebsite ( modelName: MANWEBSITE_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Manufacturer Website , type: esriFieldTypeString )
• model ( modelName: MODEL_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Model , type: esriFieldTypeString )
• serialno ( modelName: SERIALNO_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Serial Number , type: esriFieldTypeString )
• vendor ( modelName: VENDOR_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Vendor , type: esriFieldTypeString )
• speclink ( modelName: SPECLINK_, nullable: true, editable: true, defaultValue: null, length: 64, alias: Spec Link , type: esriFieldTypeString )
• omlink ( modelName: OMLINK_, nullable: true, editable: true, defaultValue: null, length: 64, alias: O&M Link , type: esriFieldTypeString )
• system ( modelName: SYSTEM_, nullable: true, editable: true, defaultValue: null, length: 40, alias: System Designator , type: esriFieldTypeString , Coded Values: [Conveyance: Conveyance] , [Screening: Screening] , [Grit Removal: Grit Removal] , ...10 more... )
• lof ( modelName: LOF_, nullable: true, editable: true, defaultValue: null, alias: LoF Score , type: esriFieldTypeSmallInteger )
• cof ( modelName: COF_, nullable: true, editable: true, defaultValue: null, alias: CoF Score , type: esriFieldTypeSmallInteger )
• risk ( modelName: RISK_, nullable: true, editable: true, defaultValue: null, alias: Risk Score , type: esriFieldTypeSmallInteger )
• criticality ( modelName: CRITICALITY_, nullable: true, editable: true, defaultValue: null, length: 16, alias: Criticality , type: esriFieldTypeString , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
• replacevalue ( modelName: REPLACEVALUE_, nullable: true, editable: true, defaultValue: null, alias: Replacement Value , type: esriFieldTypeDouble )
• valuedate ( modelName: VALUEDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Valuation Date , type: esriFieldTypeDate )
• notes ( modelName: NOTES_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Notes, type: esriFieldTypeString )
• creator ( modelName: CREATOR_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Creator , type: esriFieldTypeString )
• createdate ( modelName: CREATEDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Created , type: esriFieldTypeDate )
• editor ( modelName: EDITOR_, nullable: true, editable: true, defaultValue: null, length: 30, alias: Editor , type: esriFieldTypeString )
• editdate ( modelName: EDITDATE_, nullable: true, editable: true, defaultValue: null, length: 29, alias: Edited , type: esriFieldTypeDate )
• hvactype ( modelName: HVACTYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: Type, type: esriFieldTypeString , Coded Values: [Fan: Fan] , [Heater: Heater] , [Self Contained AC Unit: Self Contained AC Unit] , ...4 more... )
• airflowtype ( modelName: AIRFLOWTYPE, nullable: true, editable: true, defaultValue: null, length: 20, alias: Air Flow Type, type: esriFieldTypeString , Coded Values: [Draw-Thru: Draw-Thru] , [Blow-Thru: Blow-Thru] )
• cfm ( modelName: CFM, nullable: true, editable: true, defaultValue: null, alias: CFM Rating, type: esriFieldTypeSmallInteger )
• staticpress ( modelName: STATICPRESS, nullable: true, editable: true, defaultValue: null, alias: Static Pressure Rating, type: esriFieldTypeSmallInteger )
• drivetype ( modelName: DRIVETYPE, nullable: true, editable: true, defaultValue: null, length: 20, alias: Drive, type: esriFieldTypeString , Coded Values: [Direct: Direct] , [Belt: Belt] , [Gearbox: Gearbox] , ...1 more... )
• pulleydimmotor ( modelName: PULLEYDIMMOTOR, nullable: true, editable: true, defaultValue: null, length: 20, alias: Pulley Dimensions (Motor), type: esriFieldTypeString )
• pulleydimfan ( modelName: PULLEYDIMFAN, nullable: true, editable: true, defaultValue: null, length: 20, alias: Pulley Dimensions (Fan), type: esriFieldTypeString )
• beltsize ( modelName: BELTSIZE, nullable: true, editable: true, defaultValue: null, length: 20, alias: Belt Size, type: esriFieldTypeString )
• beltqty ( modelName: BELTQTY, nullable: true, editable: true, defaultValue: null, alias: Belt Quantity, type: esriFieldTypeSmallInteger )
• couplingtype ( modelName: COUPLINGTYPE, nullable: true, editable: true, defaultValue: null, length: 60, alias: Coupling Type, type: esriFieldTypeString )
• filtertype ( modelName: FILTERTYPE, nullable: true, editable: true, defaultValue: null, length: 60, alias: Filter Type, type: esriFieldTypeString )
• filtersize ( modelName: FILTERSIZE, nullable: true, editable: true, defaultValue: null, length: 20, alias: Filter Size, type: esriFieldTypeString )
• filtertqty ( modelName: FILTERTQTY, nullable: true, editable: true, defaultValue: null, alias: Filter Quantity, type: esriFieldTypeSmallInteger )
• evaporatorstyle ( modelName: EVAPORATORSTYLE, nullable: true, editable: true, defaultValue: null, length: 60, alias: Evaporator Style, type: esriFieldTypeString )
• evaporatordim ( modelName: EVAPORATORDIM, nullable: true, editable: true, defaultValue: null, length: 60, alias: Evaporator Dimensions, type: esriFieldTypeString )
• humidinfo ( modelName: HUMIDINFO, nullable: true, editable: true, defaultValue: null, length: 60, alias: Humidification Info, type: esriFieldTypeString )
• compressornameplate ( modelName: COMPRESSORNAMEPLATE, nullable: true, editable: true, defaultValue: null, length: 60, alias: Compressor Nameplate Info, type: esriFieldTypeString )
• heaterelement ( modelName: HEATERELEMENT, nullable: true, editable: true, defaultValue: null, length: 20, alias: Heater Element, type: esriFieldTypeString , Coded Values: [Gas: Gas] , [Electric: Electric] , [Hydronic: Hydronic] )
• couplingsize ( modelName: COUPLINGSIZE, nullable: true, editable: true, defaultValue: null, length: 20, alias: Coupling Size, type: esriFieldTypeString )
• servicelife ( modelName: SERVICELIFE, nullable: true, editable: true, defaultValue: null, alias: SERVICELIFE, type: esriFieldTypeDouble )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: globalid )

Templates:

• Name: HVAC Equipment
  Description:
  Prototype:
  notes: null
  filtersize: null
  criticality: null
  createdate: null
  assetname: null
  replacevalue: null
  assetowner: null
  model: null
  evaporatorstyle: null
  couplingsize: null
  conditionscore: null
  conditiondate: null
  startupdate: null
  staticpress: null
  hvactype: null
  servicelife: null
  tagnumber: null
  system: null
  legacyid: null
  compressornameplate: null
  editdate: null
  status: null
  evaporatordim: null
  lof: null
  omlink: null
  filtertqty: null
  parentid: null
  filtertype: null
  manufacturer: null
  serialno: null
  humidinfo: null
  speclink: null
  drivetype: null
  couplingtype: null
  vendor: null
  heaterelement: null
  warrantydate: null
  assettype: null
  beltsize: null
  editor: null
  creator: null
  address: null
  pulleydimfan: null
  pulleydimmotor: null
  cfm: null
  manwebsite: null
  beltqty: null
  site: null
  airflowtype: null
  assetid: null
  manphone: null
  location: null
  risk: null
  cof: null
  valuedate: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Motor Control Center (220) -- Related To: Motor Control Center (38)
• Instrumentation (221) -- Related To: Instrumentation (32)
• Control Panel (155) -- Related To: Control Panel (21)
• Motor (222) -- Related To: Motor (37)
• Area (51) -- Related To: Area (8)
• Site Structure (223) -- Related To: Site Structure (51)
• Blower Unit (77) -- Related To: Blower Unit (13)
• HVAC Equipment (224) -- Related To: Packaged Unit (40)
• sde_SanDigeo.DBO.wwfGrounds (194) -- Related To: Grounds (28)
• Process Structure (225) -- Related To: Process Structure (43)
• Building (92) -- Related To: Building (14)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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