Name: Switchgear

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:

N/A

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 )
• POSITIONING ( type: esriFieldTypeString , alias: Positioning , length: 20 , Coded Values: [Interior: Interior] , [Exterior: Exterior] )
• VOLTS ( type: esriFieldTypeString , alias: Volts , length: 20 )
• AMPS ( type: esriFieldTypeString , alias: Amps , length: 20 )
• AMPINTERRUPTCAP ( type: esriFieldTypeString , alias: Ampere Interrupting Capacity , length: 20 )
• PHASES ( type: esriFieldTypeString , alias: Phases , length: 30 )
• MANUFACTUID ( type: esriFieldTypeString , alias: Manufacturer UID , length: 255 )
• SERVICELIFE ( type: esriFieldTypeDouble , alias: SERVICELIFE )

Relationships:

• Area (46) -- Related To: Area (36)
• Building (111) -- Related To: Building (42)
• sde_SanDigeo.DBO.wwfGrounds (208) -- Related To: Grounds (56)
• Site Structure (282) -- Related To: Site Structure (79)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata