Name: Grounds

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 )
• GRNDSTYPE ( type: esriFieldTypeString , alias: Type , length: 30 , Coded Values: [Pavement: Pavement] , [Hardscape: Hardscape] , [Landscape: Landscape] , ...1 more... )
• SERVICELIFE ( type: esriFieldTypeDouble , alias: SERVICELIFE )

Relationships:

• sde_SanDigeo.DBO.wwfAirSystem (10) -- Related To: Air System (34)
• Antenna (13) -- Related To: Antenna (35)
• sde_SanDigeo.DBO.wwfAutomaticTransferSwitch (55) -- Related To: Automatic Transfer Switch (37)
• sde_SanDigeo.DBO.wwfBackFlowPreventer (59) -- Related To: Backflow Preventer (38)
• sde_SanDigeo.DBO.wwfBeltFilterPress (68) -- Related To: Belt Filter Press (39)
• sde_SanDigeo.DBO.wwfBlowerUnit (79) -- Related To: Blower Unit (41)
• sde_SanDigeo.DBO.wwfCathodicProtectionUnit (119) -- Related To: Cathodic Protection Unit (44)
• sde_SanDigeo.DBO.wwfChemicalFeedEquipment (130) -- Related To: Chemical Feed Equipment (45)
• sde_SanDigeo.DBO.wwfCircuitBreaker (133) -- Related To: Circuit Breaker (46)
• Communication Device (137) -- Related To: Communications Device (47)
• sde_SanDigeo.DBO.wwfCompressor (146) -- Related To: Compressor (48)
• sde_SanDigeo.DBO.wwfControlPanel (155) -- Related To: Control Panel (49)
• sde_SanDigeo.DBO.wwfDoorOrHatch (166) -- Related To: Door or Hatch (50)
• sde_SanDigeo.DBO.wwfFilter (173) -- Related To: Filter (52)
• sde_SanDigeo.DBO.wwfGenerator (182) -- Related To: Generator (54)
• sde_SanDigeo.DBO.wwfGrinder (186) -- Related To: Grinder (55)
• sde_SanDigeo.DBO.wwfHMITerminal (189) -- Related To: HMI Terminal (57)
• sde_SanDigeo.DBO.wwfHopper (190) -- Related To: Hopper (58)
• sde_SanDigeo.DBO.wwfHVACEquipment (191) -- Related To: HVAC Equipment (59)
• Instrumentation (192) -- Related To: Instrumentation (60)
• sde_SanDigeo.DBO.wwfLiftEquipment (193) -- Related To: Lift Equipment (61)
• sde_SanDigeo.DBO.wwfLightingSystem (194) -- Related To: Lighting System (62)
• sde_SanDigeo.DBO.wwfMobileEquip (195) -- Related To: Mobile Equipment (64)
• sde_SanDigeo.DBO.wwfMotorControlCenter (196) -- Related To: Motor Control Center (66)
• sde_SanDigeo.DBO.wwfOdorControlUnit (197) -- Related To: Odor Control Unit (67)
• sde_SanDigeo.DBO.wwfPackagedUnit (198) -- Related To: Packaged Unit (68)
• sde_SanDigeo.DBO.wwfPiping (199) -- Related To: Piping (69)
• sde_SanDigeo.DBO.wwfPLC (200) -- Related To: Programmable Logic Controller (70)
• sde_SanDigeo.DBO.wwfProcessStructure (201) -- Related To: Process Structure (71)
• sde_SanDigeo.DBO.wwfPumpUnit (202) -- Related To: Pump Unit (73)
• sde_SanDigeo.DBO.wwfSafetyEquipment (203) -- Related To: Safety Equipment (75)
• sde_SanDigeo.DBO.wwfScreen (204) -- Related To: Screen (76)
• Security Equipment (205) -- Related To: Security Equipment (77)
• sde_SanDigeo.DBO.wwfShopEquipment (206) -- Related To: Shop Equipment (78)
• sde_SanDigeo.DBO.wwfSiteStructure (207) -- Related To: Site Structure (79)
• sde_SanDigeo.DBO.wwfSwitchgear (208) -- Related To: Switchgear (81)
• sde_SanDigeo.DBO.wwfTank (209) -- Related To: Tank (82)
• sde_SanDigeo.DBO.wwfTransformer (210) -- Related To: Transformer (83)
• sde_SanDigeo.DBO.wwfUPS (211) -- Related To: Uninterruptible Power Supply (84)
• sde_SanDigeo.DBO.wwfValve (212) -- Related To: Valve (85)
• sde_SanDigeo.DBO.wwfVault (213) -- Related To: Vault (86)
• sde_SanDigeo.DBO.wwfVFD (214) -- Related To: Variable Frequency Drive (87)
• sde_SanDigeo.DBO.wwfWimsController (215) -- Related To: WIMS Controller (88)
• wwfSite (1) -- Related To: Facilities Site (29)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata