Name: Cityworks_sde.DBO.ssLiftStationOverheadHoist
Display Field: Name
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
Name
(
type: esriFieldTypeString, alias: Name, length: 255
)
-
Manufacturer
(
type: esriFieldTypeString, alias: Manufacturer, length: 50
)
-
ProductDescription
(
type: esriFieldTypeString, alias: ProductDescription, length: 255
)
-
Model
(
type: esriFieldTypeString, alias: Model, length: 50
)
-
HoistSerialNumber
(
type: esriFieldTypeString, alias: SerialNumber, length: 50
)
-
HoistHeightOfLift
(
type: esriFieldTypeString, alias: HoistHeightOfLift, length: 50
)
-
HoistLoad
(
type: esriFieldTypeString, alias: HoistLoad, length: 50
)
-
HoistDutyClass
(
type: esriFieldTypeString, alias: HoistDutyClass, length: 50
)
-
HoistLoadChainType
(
type: esriFieldTypeString, alias: HoistLoadChainType, length: 50
)
-
HoistReevingSystem
(
type: esriFieldTypeString, alias: HoistReevingSystem, length: 50
)
-
HoistChainLength
(
type: esriFieldTypeString, alias: HoistChainLength, length: 50
)
-
HoistChainSize
(
type: esriFieldTypeString, alias: HoistChainSize, length: 50
)
-
HoistChainClass
(
type: esriFieldTypeString, alias: HoistChainClass, length: 50
)
-
HoistChainGrade
(
type: esriFieldTypeString, alias: HoistChainGrade, length: 50
)
-
HoistChainMaxWorkLoad
(
type: esriFieldTypeString, alias: HoistChainMaxWorkLoad, length: 50
)
-
HoistChainBreakLoad
(
type: esriFieldTypeString, alias: HoistChainBreakLoad, length: 50
)
-
HoistChainTotalBreakingElongati
(
type: esriFieldTypeString, alias: HoistChainTotalBreakingElongation, length: 50
)
-
HoistingMachineryEDMax
(
type: esriFieldTypeString, alias: HoistingMachineryEDMax, length: 50
)
-
HoistingMachineryPower
(
type: esriFieldTypeString, alias: HoistingMachineryPower, length: 50
)
-
HoistingMachineryHoistingSpeed
(
type: esriFieldTypeString, alias: HoistingMachineryHoistingSpeed, length: 50
)
-
ControlsMainVoltage
(
type: esriFieldTypeString, alias: ContolsMainVoltage, length: 50
)
-
ControlsVoltage
(
type: esriFieldTypeString, alias: ControlsVoltage, length: 50
)
-
ControlsPhases
(
type: esriFieldTypeString, alias: ControlsPhases, length: 50
)
-
ControlsFrequency
(
type: esriFieldTypeString, alias: ControlsFrequency, length: 50
)
-
ControlsPendantType
(
type: esriFieldTypeString, alias: ControlsPendantType, length: 50
)
-
ControlsType
(
type: esriFieldTypeString, alias: ControlsControlType, length: 50
)
-
TrolleyType
(
type: esriFieldTypeString, alias: TrolleyType, length: 50
)
-
Warranty
(
type: esriFieldTypeString, alias: Warranty, length: 255
)
-
LifeExpectancy
(
type: esriFieldTypeString, alias: LifeExpectancy, length: 255
)
-
ParentType
(
type: esriFieldTypeString, alias: ParentType, length: 50
)
-
EngProjectNumber
(
type: esriFieldTypeString, alias: EngProjectNumber, length: 50
)
-
GeneralContractor
(
type: esriFieldTypeString, alias: GeneralContractor, length: 50
)
-
Comments
(
type: esriFieldTypeString, alias: Comments, length: 255
)
-
Status
(
type: esriFieldTypeString, alias: Status, length: 50
, Coded Values:
[Planned: Planned]
, [Active: Active]
, [Abandoned: Abandoned]
, ...3 more...
)
-
Location
(
type: esriFieldTypeString, alias: Location, length: 200
)
-
ConsequenceOfFailure
(
type: esriFieldTypeDouble, alias: ConsequenceOfFailure
)
-
ProbabilityOfFailure
(
type: esriFieldTypeDouble, alias: ProbabilityOfFailure
)
-
Mitigation
(
type: esriFieldTypeDouble, alias: Mitigation
)
-
Risk
(
type: esriFieldTypeDouble, alias: Risk
)
-
EstimatedLife
(
type: esriFieldTypeSmallInteger, alias: EstimatedLife
)
-
InstallationDate
(
type: esriFieldTypeDate, alias: InstallationDate, length: 8
)
-
ReplacementCost
(
type: esriFieldTypeDouble, alias: ReplacementCost
)
-
CostingDate
(
type: esriFieldTypeDate, alias: CostingDate, length: 8
)
-
Asset_ID
(
type: esriFieldTypeString, alias: Asset_ID, length: 20
)
-
Parent_ID
(
type: esriFieldTypeString, alias: Parent_ID, length: 50
)
-
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
)
-
GlobalID
(
type: esriFieldTypeGUID, alias: GlobalID, length: 38
)
-
OldParentID
(
type: esriFieldTypeString, alias: OldParentID, length: 50
)
Relationships:
Supported Operations:
Query
Query Attachments
Query Analytic
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata