Name: swOilWaterSeparator

Display Field: AssetID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 0430ed826b6c47d39aed3e82239b70eb

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 4000

Supported Query Formats: JSON, PBF

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
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 )
• AssetID ( type: esriFieldTypeString, alias: AssetID, length: 35 )
• VaultID ( type: esriFieldTypeString, alias: VaultID, length: 35 )
• CatchBasinID ( type: esriFieldTypeString, alias: CatchBasinID, length: 35 )
• FeatureType ( type: esriFieldTypeString, alias: FeatureType, length: 5 , Coded Values: [CP: Coalescing Plate] , [BF: Baffel] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, length: 30 )
• WarrantyDate ( type: esriFieldTypeDate, alias: WarrantyDate, length: 8 )
• Location ( type: esriFieldTypeString, alias: Location, length: 130 )
• EstimatedEffectiveLife ( type: esriFieldTypeSmallInteger, alias: EstimatedEffectiveLife )
• InstallYear ( type: esriFieldTypeSmallInteger, alias: InstallYear )
• Condition ( type: esriFieldTypeSmallInteger, alias: Condition )
• 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 )
• BASIN ( type: esriFieldTypeString, alias: BASIN, length: 20 , Coded Values: [BC: Boeing Creek] , [MC: McAleer Creek] , [MPS: Middle Puget Sound] , ...4 more... )
• DIGITIZE_METHOD ( type: esriFieldTypeString, alias: DIGITIZE_METHOD, length: 50 , Coded Values: [CAD: Import of Digital CAD file] , [SCAN: Georeferenced, scanned Image of CAD drawing] , [SKETCH: Rough Sketch] , ...10 more... )
• DIGITIZE_SOURCE ( type: esriFieldTypeString, alias: DIGITIZE_SOURCE, length: 50 )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, length: 35 )
• MAINTAIN_ZONE ( type: esriFieldTypeString, alias: MAINTAIN_ZONE, length: 5 , Coded Values: [A-01: A-01] , [A-02: A-02] , [A-05: A-05] , ...48 more... )
• OperatedBy ( type: esriFieldTypeString, alias: OperatedBy, length: 25 , Coded Values: [CREG: City-Regional] , [CRES: City-Residential] , [CCOM: City-Commercial] , ...10 more... )
• OwnedBy ( type: esriFieldTypeString, alias: OwnedBy, length: 255 , Coded Values: [CITY: City of Shoreline] , [CITYO: City (Other)] , [COUNTY: County] , ...4 more... )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, length: 50 )
• Lifecycle ( type: esriFieldTypeString, alias: Lifecycle, length: 5 , Coded Values: [AC: Active] , [PR: Proposed] , [AB: Abandoned] , ...3 more... )

Relationships:

• swVault (15) -- Related To: Vault (32)
• swVault (30) -- Related To: Proposed Vault (65)
• swCatchBasin (3) -- Related To: Catch Basin (3)
• swCatchBasin (19) -- Related To: Proposed Catch Basin (43)
• swCatchBasin (34) -- Related To: Catch Basins (86)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata