Name: FM_Asset_Object
Display Field: iMSName
Type: Table
Geometry Type: N/A
Description: null
Service Item Id: ebae4623ee6146baae930d07be14fac5
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: ASSETGROUP
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
AssetID
(
type: esriFieldTypeString, alias: Asset Identifier, length: 50
)
-
Display
(
type: esriFieldTypeString, alias: Display Name, length: 255
)
-
Location
(
type: esriFieldTypeString, alias: Location Description, length: 255
)
-
Address
(
type: esriFieldTypeString, alias: Address, length: 255
)
-
OwnedBy
(
type: esriFieldTypeSmallInteger, alias: Owned By
, Coded Values:
[1: Our Agency]
, [2: Private]
, [100: Other]
)
-
MaintBy
(
type: esriFieldTypeSmallInteger, alias: Maintained By
, Coded Values:
[1: Our Agency]
, [2: Private]
, [100: Other]
)
-
PrimaryImage
(
type: esriFieldTypeString, alias: Primary Image, length: 255
)
-
CondInspScore
(
type: esriFieldTypeSmallInteger, alias: Condition Score
)
-
CondInspDate
(
type: esriFieldTypeDate, alias: Condition Date, length: 8
)
-
WarrantyDate
(
type: esriFieldTypeDate, alias: Warranty Date, length: 8
)
-
InstallDate
(
type: esriFieldTypeDate, alias: Install Date, length: 8
)
-
InstallCost
(
type: esriFieldTypeDouble, alias: Install Cost
)
-
ExpReplaceDate
(
type: esriFieldTypeDate, alias: Exp Replace Date, length: 8
)
-
ExpReplaceCost
(
type: esriFieldTypeDouble, alias: Exp Replace Cost
)
-
Age
(
type: esriFieldTypeDouble, alias: Age
)
-
Criticality
(
type: esriFieldTypeString, alias: Criticality, length: 25
)
-
iPoF
(
type: esriFieldTypeDouble, alias: Failure Probability
)
-
iCoF
(
type: esriFieldTypeDouble, alias: Failure Consequence
)
-
iBRE
(
type: esriFieldTypeDouble, alias: Business Risk
)
-
iMSPU
(
type: esriFieldTypeDouble, alias: Maint Under Perform
)
-
iMSPO
(
type: esriFieldTypeDouble, alias: Maint Over Perform
)
-
iMSR
(
type: esriFieldTypeDouble, alias: Maint Score
)
-
iMCFY
(
type: esriFieldTypeSmallInteger, alias: Maint Curve Fast Yr
)
-
iMCSY
(
type: esriFieldTypeSmallInteger, alias: Maint Curve Slow Yr
)
-
iMCAY
(
type: esriFieldTypeSmallInteger, alias: Maint Curve Avg Yr
)
-
iMSName
(
type: esriFieldTypeString, alias: Maint Strategy Name, length: 255
)
-
iCalcDate
(
type: esriFieldTypeDate, alias: OpInsights Calc Date, length: 8
)
-
IndFacID
(
type: esriFieldTypeString, alias: Indoors Facility Identifier, length: 255
)
-
IndLevID
(
type: esriFieldTypeString, alias: Indoors Level Identifier, length: 255
)
-
Comments
(
type: esriFieldTypeString, alias: Comments, length: 255
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, length: 255
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
-
LastActivityDate
(
type: esriFieldTypeDate, alias: Last Service Date, length: 8
)
-
LastActivityID
(
type: esriFieldTypeString, alias: Last Activity Id, length: 255
)
-
LastActivityDesc
(
type: esriFieldTypeString, alias: Last Activity Type, length: 255
)
-
ExpirationDate
(
type: esriFieldTypeDate, alias: Expiration Date, length: 8
)
-
structure_boundary_globalid
(
type: esriFieldTypeGUID, alias: structure_boundary_globalid, length: 38
)
-
FM_Asset_Group
(
type: esriFieldTypeSmallInteger, alias: FM_Asset_Group
, Coded Values:
[0: Unknown]
, [2: HVAC]
, [3: Irrigation]
, ...37 more...
)
-
FM_Asset_Type
(
type: esriFieldTypeSmallInteger, alias: FM_Asset_Type
, Coded Values:
[0: Unknown]
, [3: Automatic Transfer Switch Generator]
, [5: AC System]
, ...91 more...
)
-
purchasedate
(
type: esriFieldTypeDate, alias: purchasedate, length: 8
)
-
departmentid
(
type: esriFieldTypeSmallInteger, alias: departmentid
, Coded Values:
[0: Unknown]
, [1: Water Distribution]
, [2: Wastewater Treatment Plant]
, ...2 more...
)
-
fldLocationID
(
type: esriFieldTypeString, alias: fldLocationID, length: 255
)
-
fldEquipDescription
(
type: esriFieldTypeString, alias: fldEquipDescription, length: 255
)
-
fldEqTypeID
(
type: esriFieldTypeString, alias: fldEqTypeID, length: 255
)
-
UNFCObject
(
type: esriFieldTypeString, alias: UNFCObject, length: 255
)
-
fldModelNo
(
type: esriFieldTypeString, alias: fldModelNo, length: 255
)
-
fldSerialNo
(
type: esriFieldTypeString, alias: fldSerialNo, length: 255
)
-
fldAssetNo
(
type: esriFieldTypeString, alias: fldAssetNo, length: 255
)
-
fldDatePurch
(
type: esriFieldTypeString, alias: fldDatePurch, length: 255
)
-
fldPurchPrice
(
type: esriFieldTypeDouble, alias: fldPurchPrice
)
-
fldDateInService
(
type: esriFieldTypeString, alias: fldDateInService, length: 255
)
-
fldWarrantyDays
(
type: esriFieldTypeSmallInteger, alias: fldWarrantyDays
)
-
fldLifeExpectancy
(
type: esriFieldTypeSmallInteger, alias: fldLifeExpectancy
)
-
fldInServiceStatus
(
type: esriFieldTypeString, alias: fldInServiceStatus, length: 255
)
-
fldComments
(
type: esriFieldTypeString, alias: fldComments, length: 255
)
-
fldEqTypeCode
(
type: esriFieldTypeString, alias: fldEqTypeCode, length: 255
)
-
ASSETGROUP
(
type: esriFieldTypeInteger, alias: ASSETGROUP
)
-
ASSETTYPE
(
type: esriFieldTypeSmallInteger, alias: ASSETTYPE
)
-
structure_junction_globalid
(
type: esriFieldTypeGUID, alias: Structure Junction Object GlobalID, length: 38
)
-
fm_building_globalid
(
type: esriFieldTypeGUID, alias: fm_building_globalid, length: 38
)
-
lifecyclestatus
(
type: esriFieldTypeSmallInteger, alias: lifecyclestatus
, Coded Values:
[0: Unknown]
, [1: Proposed]
, [2: Approved]
, ...7 more...
)
-
model
(
type: esriFieldTypeString, alias: model, length: 64
)
-
fldEquipID
(
type: esriFieldTypeSmallInteger, alias: fldEquipID
)
-
wwtps_site_globalid
(
type: esriFieldTypeGUID, alias: wwtps_site_globalid, length: 38
)
-
fldDepartmentID
(
type: esriFieldTypeString, alias: fldDepartmentID, length: 255
)
-
fldVendorID
(
type: esriFieldTypeSmallInteger, alias: fldVendorID
)
-
fldMfgID
(
type: esriFieldTypeSmallInteger, alias: fldMfgID
)
-
migratetogis
(
type: esriFieldTypeString, alias: migratetogis, length: 255
)
-
designtype
(
type: esriFieldTypeSmallInteger, alias: designtype
)
-
fldEqPriorityID
(
type: esriFieldTypeSmallInteger, alias: fldEqPriorityID
)
Types:
ID: 0
Name: Uknown
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
lifecyclestatus:
Inherited
ID: 1
Name: Emergency Backup Power
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [11: Automatic Transfer Switch Generator]
, [12: Stationary Generator]
, ...4 more...
-
lifecyclestatus:
Inherited
ID: 2
Name: HVAC
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [21: AC System]
, [22: Exhaust Fan]
, ...5 more...
-
lifecyclestatus:
Inherited
ID: 3
Name: Irrigation
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [31: Landscape Irrigation]
-
lifecyclestatus:
Inherited
ID: 4
Name: Weather Instrument
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [41: Rain Gauge]
-
lifecyclestatus:
Inherited
ID: 5
Name: Lifting Device
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [51: Bridge Crane]
, [52: Electric Hoist]
, ...1 more...
-
lifecyclestatus:
Inherited
ID: 6
Name: Gate
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [101: Gate]
, [102: Stop Log]
, ...2 more...
-
lifecyclestatus:
Inherited
ID: 7
Name: Conveyor
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [701: Plow Belt Conveyor]
, [702: Portable Belt Conveyor]
, ...2 more...
-
lifecyclestatus:
Inherited
ID: 8
Name: Motor
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [81: Electric Motor]
-
lifecyclestatus:
Inherited
ID: 9
Name: Plumbing
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [91: Air Valve Lines]
, [92: Chlorine Valve LInes]
, ...3 more...
-
lifecyclestatus:
Inherited
ID: 10
Name: Access Control
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [1001: Fence]
, [1002: Gate]
, ...1 more...
-
lifecyclestatus:
Inherited
ID: 11
Name: Communication
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [1101: Communication Repeater]
, [1102: Communication Tower]
, ...1 more...
-
lifecyclestatus:
Inherited
ID: 12
Name: Cabinet
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [1201: Lock Out Tag Out Cabinet]
, [1202: Power Correction Cabinet]
, ...1 more...
-
lifecyclestatus:
Inherited
ID: 13
Name: Pressure Washer
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [1301: Portable Pressure Washer]
-
lifecyclestatus:
Inherited
ID: 14
Name: Control Panel
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [1401: Blower Control Panel]
, [1402: Control Panel]
, ...8 more...
-
lifecyclestatus:
Inherited
ID: 15
Name: Controller
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [1501: Actuator]
, [1502: Chlorine Regulator]
, ...6 more...
-
lifecyclestatus:
Inherited
ID: 16
Name: UV System
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [1601: UV Acid Bath]
, [1602: UV Bank]
, ...3 more...
-
lifecyclestatus:
Inherited
ID: 17
Name: SCADA
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [1701: SCADA Computer System]
, [1702: SCADA Field Interface Unit]
-
lifecyclestatus:
Inherited
ID: 19
Name: Gear
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [1901: Gear Box]
, [1902: Speed Reducer]
-
lifecyclestatus:
Inherited
ID: 20
Name: Mixer
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [201: PAX Mixer]
, [202: Post Aeration MIxer]
, ...1 more...
-
lifecyclestatus:
Inherited
ID: 21
Name: NA
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
lifecyclestatus:
Inherited
ID: 22
Name: N/A
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
lifecyclestatus:
Inherited
ID: 23
Name: Auger
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Uknown]
, [2301: Lime Auger]
, [2302: Lime Feed Auger]
, ...3 more...
-
lifecyclestatus:
Inherited
ID: 24
Name: Storage
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [2401: Lime Silo]
, [2402: Sludge Dumpster]
-
lifecyclestatus:
Inherited
ID: 25
Name: Blower
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [2501: Aeration Blower]
, [2502: Belt Press Lime Blower]
-
lifecyclestatus:
Inherited
ID: 26
Name: Cathodic Protection
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [2601: Cathodic Protection]
-
lifecyclestatus:
Inherited
ID: 27
Name: Biofilter
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [2701: Biofilter Irrigation]
, [2702: Biofilters]
, ...1 more...
-
lifecyclestatus:
Inherited
ID: 28
Name: Final Clarifier
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [2801: Algae Sweep]
, [2802: Center Ring]
-
lifecyclestatus:
Inherited
ID: 29
Name: Lighting
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [2901: Aviation Light]
, [2902: Yard Lighting]
-
lifecyclestatus:
Inherited
ID: 30
Name: Odor Control
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [301: Odor Control System]
-
lifecyclestatus:
Inherited
ID: 31
Name: Dumpster Veyor
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [3101: Dumpster Veyor]
, [3102: Dumpster Veyor Tracks]
-
lifecyclestatus:
Inherited
ID: 32
Name: Screen
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [3201: Debris Screeen]
, [3202: Filter Screen]
, ...1 more...
-
lifecyclestatus:
Inherited
ID: 33
Name: Plow
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [3301: Plow]
-
lifecyclestatus:
Inherited
ID: 34
Name: Room
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [3401: Belt Press Office]
, [3402: PTA Grit Snail Room]
, ...7 more...
-
lifecyclestatus:
Inherited
ID: 36
Name: Sequencing Batch Reactor
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [3601: Scum Collector]
-
lifecyclestatus:
Inherited
ID: 37
Name: Bin Activator
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
lifecyclestatus:
Inherited
ID: 38
Name: Biosolids Storage Area Belt Press
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [3801: Sludge Staging Area]
, [3802: Y Strainer Cleanout]
, ...1 more...
-
lifecyclestatus:
Inherited
ID: 39
Name: Grinder
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [3901: Channel Grinder]
-
lifecyclestatus:
Inherited
ID: 35
Name: Grit
Domains:
-
OwnedBy:
Inherited
-
MaintBy:
Inherited
-
FM_Asset_Group:
Inherited
-
FM_Asset_Type:
Inherited
-
departmentid:
Inherited
-
ASSETTYPE:
Coded Values:
[0: Unknown]
, [3501: Grit Chamber]
, [3502: Grit Slurry Cup]
, ...1 more...
-
lifecyclestatus:
Inherited
Relationships:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata