Name: Motor
Display Field: ASSETNAME
Type: Table
Geometry Type: N/A
Description: null
Definition Expression: N/A
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, AMF
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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID
, alias: OBJECTID
)
-
ASSETID
(
type: esriFieldTypeString
, alias: Asset ID
, length: 100
)
-
ASSETNAME
(
type: esriFieldTypeString
, alias: Asset Name
, length: 255
)
-
ASSETTYPE
(
type: esriFieldTypeString
, alias: Asset Type
, length: 50
)
-
ASSETOWNER
(
type: esriFieldTypeString
, alias: Asset Owner
, length: 50
, Coded Values:
[Airports: Airports]
, [HHSA: HHSA]
, [Parks: Parks]
, ...3 more...
)
-
LEGACYID
(
type: esriFieldTypeString
, alias: Legacy ID
, length: 50
)
-
TAGNUMBER
(
type: esriFieldTypeString
, alias: Tag Number
, length: 50
)
-
STATUS
(
type: esriFieldTypeString
, alias: Status
, length: 30
, Coded Values:
[In Service: In Service]
, [Out of Service: Out of Service]
, [Spare: Spare]
)
-
PARENTID
(
type: esriFieldTypeString
, alias: Parent ID
, length: 100
)
-
STARTUPDATE
(
type: esriFieldTypeDate
, alias: Startup Date
, length: 8
)
-
WARRANTYDATE
(
type: esriFieldTypeDate
, alias: Warranty Date
, length: 8
)
-
CONDITIONSCORE
(
type: esriFieldTypeSmallInteger
, alias: Condition Score
)
-
CONDITIONDATE
(
type: esriFieldTypeDate
, alias: Condition Date
, length: 8
)
-
ADDRESS
(
type: esriFieldTypeString
, alias: Address
, length: 255
)
-
LOCATION
(
type: esriFieldTypeString
, alias: Location
, length: 255
)
-
SITE
(
type: esriFieldTypeString
, alias: Site
, length: 30
, Coded Values:
[JUWWTP0019: Heise Park WWTP]
, [PVWWTP0007: Pine Valley WWTP]
, [SVWWPS0010: Rancho San Diego PS]
, ...39 more...
)
-
MANUFACTURER
(
type: esriFieldTypeString
, alias: Manufacturer
, length: 30
)
-
MANPHONE
(
type: esriFieldTypeString
, alias: Manufacturer Phone #
, length: 16
)
-
MANWEBSITE
(
type: esriFieldTypeString
, alias: Manufacturer Website
, length: 30
)
-
MODEL
(
type: esriFieldTypeString
, alias: Model
, length: 30
)
-
SERIALNO
(
type: esriFieldTypeString
, alias: Serial Number
, length: 30
)
-
VENDOR
(
type: esriFieldTypeString
, alias: Vendor
, length: 30
)
-
SPECLINK
(
type: esriFieldTypeString
, alias: Spec Link
, length: 64
)
-
OMLINK
(
type: esriFieldTypeString
, alias: O&M Link
, length: 64
)
-
SYSTEM
(
type: esriFieldTypeString
, alias: System Designator
, length: 40
, Coded Values:
[Conveyance: Conveyance]
, [Screening: Screening]
, [Grit Removal: Grit Removal]
, ...10 more...
)
-
LOF
(
type: esriFieldTypeSmallInteger
, alias: LoF Score
)
-
COF
(
type: esriFieldTypeSmallInteger
, alias: CoF Score
)
-
RISK
(
type: esriFieldTypeSmallInteger
, alias: Risk Score
)
-
CRITICALITY
(
type: esriFieldTypeString
, alias: Criticality
, length: 16
, Coded Values:
[High: High]
, [Medium: Medium]
, [Low: Low]
)
-
REPLACEVALUE
(
type: esriFieldTypeDouble
, alias: Replacement Value
)
-
VALUEDATE
(
type: esriFieldTypeDate
, alias: Valuation Date
, length: 8
)
-
NOTES
(
type: esriFieldTypeString
, alias: Notes
, length: 255
)
-
CREATOR
(
type: esriFieldTypeString
, alias: Creator
, length: 30
)
-
CREATEDATE
(
type: esriFieldTypeDate
, alias: Created
, length: 8
)
-
EDITOR
(
type: esriFieldTypeString
, alias: Editor
, length: 30
)
-
EDITDATE
(
type: esriFieldTypeDate
, alias: Edited
, length: 8
)
-
MTRTYPE
(
type: esriFieldTypeString
, alias: Type
, length: 15
, Coded Values:
[Induction: Induction]
, [Synchronous: Synchronous]
, [Series: Series]
, ...2 more...
)
-
WATTS
(
type: esriFieldTypeString
, alias: Watts
, length: 20
)
-
HP
(
type: esriFieldTypeString
, alias: Horsepower
, length: 20
)
-
RPM
(
type: esriFieldTypeSmallInteger
, alias: Rotations per Minute
)
-
PWRSUPPLY
(
type: esriFieldTypeString
, alias: Power Supply
, length: 20
, Coded Values:
[Alternating Current: Alternating Current]
, [Direct Current: Direct Current]
)
-
PHASES
(
type: esriFieldTypeString
, alias: Phases
, length: 30
)
-
CYCLES
(
type: esriFieldTypeString
, alias: Cycles
, length: 20
)
-
RANGECYCLEPERSEC
(
type: esriFieldTypeString
, alias: Range of Cycle per Second
, length: 20
)
-
FRAMESIZE
(
type: esriFieldTypeString
, alias: Frame Size
, length: 20
)
-
DUTY
(
type: esriFieldTypeString
, alias: Duty
, length: 20
, Coded Values:
[Severe: Severe]
, [Continuous: Continuous]
, [Extreme: Extreme]
, ...1 more...
)
-
FRAMETYPE
(
type: esriFieldTypeString
, alias: Frame Type
, length: 20
)
-
AMPS
(
type: esriFieldTypeString
, alias: Amperage
, length: 20
)
-
VOLTS
(
type: esriFieldTypeString
, alias: Volts
, length: 20
)
-
INSULATIONCLASS
(
type: esriFieldTypeString
, alias: Insulation Class Code
, length: 8
, Coded Values:
[Class A: Class A]
, [Class B: Class B]
, [Class F: Class F]
, ...1 more...
)
-
WINDINGCONFIG
(
type: esriFieldTypeString
, alias: Winding Configuration
, length: 20
)
-
SPECIALFEATURES
(
type: esriFieldTypeString
, alias: Special Features
, length: 255
)
-
MOUNTTYPE
(
type: esriFieldTypeString
, alias: Mount
, length: 10
, Coded Values:
[Horizontal: Horizontal]
, [Vertical: Vertical]
)
-
SHAFTTYPE
(
type: esriFieldTypeString
, alias: Shaft
, length: 20
, Coded Values:
[Single Output: Single Output]
, [Double Output: Double Output]
)
-
LUBEGREASE
(
type: esriFieldTypeString
, alias: Lubrication, Grease
, length: 30
)
-
LUBEOIL
(
type: esriFieldTypeString
, alias: Lubrication, Oil
, length: 30
)
-
WEIGHT
(
type: esriFieldTypeSmallInteger
, alias: Weight
)
-
SERVICELIFE
(
type: esriFieldTypeDouble
, alias: SERVICELIFE
)
Relationships:
Supported Operations:
Query
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata