View In:   WSDOT ArcGIS Online map viewer

Name: Stormwater Debris Rack - Field

Display Field: ProjectName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This is a view of the DebrisRack featureclass created with the following query: LifeCycleCurrentStatus= 'Active' AND (WSDOTownership in ('Yes', 'Unknown') OR WSDOTownership IS NULL) AND SWLocationVerified = 'Yes' This feature class contains WSDOT’s stormwater debris racks. A debris rack is a structural device such as grates or rods used to prevent debris from entering a drainage structure, and can include a barred culvert end if the bars are intended to keep debris from entering the pipe. Additional terms used to describe this type of structural device are“trash rack” or “bee hive”. The majority of the data collected so far are within the Phase I and Phase II 2009 NPDES Municipal Stormwater Permit Areas.

Copyright Text: WSDOT ESO

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -1.3597679072216067E7
YMin: 6070288.558822467
XMax: -1.3597677412571225E7
YMax: 6070289.685540229
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [122, 138, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• WSDOTownership ( type: esriFieldTypeString, alias: WSDOTownership, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WSDOTownership )
• WSDOTresponsible ( type: esriFieldTypeString, alias: WSDOTresponsible, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WSDOTresponsible )
• AsBuiltPlanNum ( type: esriFieldTypeString, alias: AsBuiltPlanNum, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AsBuiltPlanNum )
• ContractNum ( type: esriFieldTypeString, alias: ContractNum, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ContractNum )
• DesignStandardRefDoc ( type: esriFieldTypeString, alias: DesignStandardRefDoc, editable: true, nullable: true, length: 80, defaultValue: null, modelName: DesignStandardRefDoc )
• LandUse ( type: esriFieldTypeString, alias: LandUse, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LandUse )
• WaterFlowDirection ( type: esriFieldTypeString, alias: WaterFlowDirection, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WaterFlowDirection )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )
• StormwaterSystemID ( type: esriFieldTypeInteger, alias: StormwaterSystemID, editable: true, nullable: true, defaultValue: null, modelName: StormwaterSystemID )
• AccessoryEquip ( type: esriFieldTypeString, alias: AccessoryEquip, editable: true, nullable: true, length: 150, defaultValue: null, modelName: AccessoryEquip )
• PrimaryFunction ( type: esriFieldTypeString, alias: PrimaryFunction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PrimaryFunction )
• LocationCollectionMethod ( type: esriFieldTypeString, alias: LocationCollectionMethod, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocationCollectionMethod )
• LocationCollectionProgram ( type: esriFieldTypeString, alias: LocationCollectionProgram, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LocationCollectionProgram )
• DataDevelopmentNotes ( type: esriFieldTypeString, alias: DataDevelopmentNotes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: DataDevelopmentNotes )
• LocationFieldNotes ( type: esriFieldTypeString, alias: LocationFieldNotes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: LocationFieldNotes )
• MaintenanceConcerns ( type: esriFieldTypeString, alias: MaintenanceConcerns, editable: true, nullable: true, length: 150, defaultValue: null, modelName: MaintenanceConcerns )
• LifeCycleCurrentStatus ( type: esriFieldTypeString, alias: LifeCycleCurrentStatus, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LifeCycleCurrentStatus )
• LifeCycleStatusDate ( type: esriFieldTypeDate, alias: LifeCycleStatusDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LifeCycleStatusDate )
• WSDOTFeatureNumber ( type: esriFieldTypeString, alias: WSDOTFeatureNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WSDOTFeatureNumber )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Notes )
• DrainageArea ( type: esriFieldTypeDouble, alias: DrainageArea, editable: true, nullable: true, defaultValue: null, modelName: DrainageArea )
• DrainageAreaUnits ( type: esriFieldTypeString, alias: DrainageAreaUnits, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DrainageAreaUnits )
• GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: GlobalID )
• AccessInstructions ( type: esriFieldTypeString, alias: AccessInstructions, editable: true, nullable: true, length: 200, defaultValue: null, modelName: AccessInstructions )
• LastUpdatedBy ( type: esriFieldTypeString, alias: LastUpdatedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LastUpdatedBy )
• FeatureDesignDate ( type: esriFieldTypeDate, alias: FeatureDesignDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FeatureDesignDate )
• FeatureBuildDate ( type: esriFieldTypeDate, alias: FeatureBuildDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FeatureBuildDate )
• FeatureCurrentMeasurementDate ( type: esriFieldTypeDate, alias: FeatureCurrentMeasurementDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FeatureCurrentMeasurementDate )
• FeatureRetireDate ( type: esriFieldTypeDate, alias: FeatureRetireDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FeatureRetireDate )
• RecordUpdateDate ( type: esriFieldTypeDate, alias: RecordUpdateDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RecordUpdateDate )
• BMPTypeID ( type: esriFieldTypeInteger, alias: BMPTypeID, editable: true, nullable: true, defaultValue: null, modelName: BMPTypeID )
• ProjectName ( type: esriFieldTypeString, alias: ProjectName, editable: true, nullable: true, length: 150, defaultValue: null, modelName: ProjectName )
• GPSDeviceName ( type: esriFieldTypeString, alias: GPSDeviceName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GPSDeviceName )
• SpatialAccuracy ( type: esriFieldTypeString, alias: SpatialAccuracy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SpatialAccuracy )
• AverageAccuracy ( type: esriFieldTypeDouble, alias: AverageAccuracy, editable: true, nullable: true, defaultValue: null, modelName: AverageAccuracy )
• DifferentialCorrection ( type: esriFieldTypeString, alias: DifferentialCorrection, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DifferentialCorrection )
• OffsetDistance ( type: esriFieldTypeDouble, alias: OffsetDistance, editable: true, nullable: true, defaultValue: null, modelName: OffsetDistance )
• OffsetType ( type: esriFieldTypeString, alias: OffsetType, editable: true, nullable: true, length: 40, defaultValue: null, modelName: OffsetType )
• WorstAccuracy ( type: esriFieldTypeDouble, alias: WorstAccuracy, editable: true, nullable: true, defaultValue: null, modelName: WorstAccuracy )
• HorizontalAccuracy ( type: esriFieldTypeDouble, alias: HorizontalAccuracy, editable: true, nullable: true, defaultValue: null, modelName: HorizontalAccuracy )
• HorizontalUnits ( type: esriFieldTypeString, alias: HorizontalUnits, editable: true, nullable: true, length: 20, defaultValue: null, modelName: HorizontalUnits )
• CollectionDate ( type: esriFieldTypeDate, alias: CollectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CollectionDate )
• RecordCreateDate ( type: esriFieldTypeDate, alias: RecordCreateDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RecordCreateDate )
• ActualWorkStartDate ( type: esriFieldTypeDate, alias: ActualWorkStartDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ActualWorkStartDate )
• DesignStandardDate ( type: esriFieldTypeDate, alias: DesignStandardDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DesignStandardDate )
• PhysicalCompletionDate ( type: esriFieldTypeDate, alias: PhysicalCompletionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PhysicalCompletionDate )
• Photo1 ( type: esriFieldTypeString, alias: Photo1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Photo1 )
• Photo1Desc ( type: esriFieldTypeString, alias: Photo1Desc, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Photo1Desc )
• Photo2 ( type: esriFieldTypeString, alias: Photo2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Photo2 )
• Photo2Desc ( type: esriFieldTypeString, alias: Photo2Desc, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Photo2Desc )
• Photo3 ( type: esriFieldTypeString, alias: Photo3, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Photo3 )
• Photo3Desc ( type: esriFieldTypeString, alias: Photo3Desc, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Photo3Desc )
• MaintenanceBMPID ( type: esriFieldTypeString, alias: MaintenanceBMPID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MaintenanceBMPID )
• ExternalAssocID ( type: esriFieldTypeString, alias: ExternalAssocID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ExternalAssocID )
• ExternalAssocIDSource ( type: esriFieldTypeString, alias: ExternalAssocIDSource, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ExternalAssocIDSource )
• Region ( type: esriFieldTypeString, alias: Region, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Region )
• RelRouteQual ( type: esriFieldTypeString, alias: RelRouteQual, editable: true, nullable: true, length: 7, defaultValue: null, modelName: RelRouteQual )
• RelRouteType ( type: esriFieldTypeString, alias: RelRouteType, editable: true, nullable: true, length: 2, defaultValue: null, modelName: RelRouteType )
• DirectionOfInventory ( type: esriFieldTypeString, alias: DirectionOfInventory, editable: true, nullable: true, length: 1, defaultValue: null, modelName: DirectionOfInventory )
• ARM ( type: esriFieldTypeSingle, alias: ARM, editable: true, nullable: true, defaultValue: null, modelName: ARM )
• SRMP ( type: esriFieldTypeSingle, alias: SRMP, editable: true, nullable: true, defaultValue: null, modelName: SRMP )
• AheadBackIndicator ( type: esriFieldTypeString, alias: AheadBackIndicator, editable: true, nullable: true, length: 1, defaultValue: null, modelName: AheadBackIndicator )
• LRSDate ( type: esriFieldTypeDate, alias: LRSDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LRSDate )
• MaintenanceArea ( type: esriFieldTypeSmallInteger, alias: MaintenanceArea, editable: true, nullable: true, defaultValue: null, modelName: MaintenanceArea )
• StateRouteNumber ( type: esriFieldTypeString, alias: StateRouteNumber, editable: true, nullable: true, length: 3, defaultValue: null, modelName: StateRouteNumber )
• AssetReferenceText ( type: esriFieldTypeString, alias: AssetReferenceText, editable: true, nullable: true, length: 15, defaultValue: null, modelName: AssetReferenceText )
• AssetReferenceNumber ( type: esriFieldTypeInteger, alias: AssetReferenceNumber, editable: true, nullable: true, defaultValue: null, modelName: AssetReferenceNumber )
• AssetGUID ( type: esriFieldTypeGUID, alias: AssetGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: AssetGUID )
• SWAttributeVerified ( type: esriFieldTypeString, alias: SWAttributeVerified, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SWAttributeVerified )
• SWLocationVerified ( type: esriFieldTypeString, alias: SWLocationVerified, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SWLocationVerified )
• RecordCreatedBy ( type: esriFieldTypeString, alias: RecordCreatedBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RecordCreatedBy )
• GDB_GEOMATTR_DATA ( type: esriFieldTypeBlob, alias: GDB_GEOMATTR_DATA, editable: true, nullable: true, defaultValue: null, modelName: GDB_GEOMATTR_DATA )

Templates:

• Name: Stormwater Debris Rack - Field
  Description:
  Prototype:
  RecordCreatedBy: null
  GDB_GEOMATTR_DATA: null
  WSDOTownership: null
  WSDOTresponsible: null
  AsBuiltPlanNum: null
  ContractNum: null
  DesignStandardRefDoc: null
  LandUse: null
  WaterFlowDirection: null
  Location: null
  StormwaterSystemID: null
  AccessoryEquip: null
  PrimaryFunction: null
  LocationCollectionMethod: null
  LocationCollectionProgram: null
  DataDevelopmentNotes: null
  LocationFieldNotes: null
  MaintenanceConcerns: null
  LifeCycleCurrentStatus: null
  LifeCycleStatusDate: null
  WSDOTFeatureNumber: null
  Notes: null
  DrainageArea: null
  DrainageAreaUnits: null
  GlobalID: {00000000-0000-0000-0000-000000000000}
  AccessInstructions: null
  LastUpdatedBy: null
  FeatureDesignDate: null
  FeatureBuildDate: null
  FeatureCurrentMeasurementDate: null
  FeatureRetireDate: null
  RecordUpdateDate: null
  BMPTypeID: null
  ProjectName: null
  GPSDeviceName: null
  SpatialAccuracy: null
  AverageAccuracy: null
  DifferentialCorrection: null
  OffsetDistance: null
  OffsetType: null
  WorstAccuracy: null
  HorizontalAccuracy: null
  HorizontalUnits: null
  CollectionDate: null
  RecordCreateDate: null
  ActualWorkStartDate: null
  DesignStandardDate: null
  PhysicalCompletionDate: null
  Photo1: null
  Photo1Desc: null
  Photo2: null
  Photo2Desc: null
  Photo3: null
  Photo3Desc: null
  MaintenanceBMPID: null
  ExternalAssocID: null
  ExternalAssocIDSource: null
  Region: null
  RelRouteQual: null
  RelRouteType: null
  DirectionOfInventory: null
  ARM: null
  SRMP: null
  AheadBackIndicator: null
  LRSDate: null
  MaintenanceArea: null
  StateRouteNumber: null
  AssetReferenceText: null
  AssetReferenceNumber: null
  AssetGUID: null
  SWAttributeVerified: null
  SWLocationVerified: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata