Layer: Water Quality Complaints and Spill Reports (ID:1)

View In: Map Viewer

Name: Water Quality Complaints and Spill Reports

Display Field: WQSR_BASIN_NAME_TEXT

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: DWW WQ_SPILLS presents point data from the SPU Source Control Team’s database.

Copyright Text:

Min. Scale: 10000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"WQSR_CASE_TYPE","uniqueValueGroups":[{"heading":"Case Type","classes":[{"label":"Spill Response","description":"Spill Response","symbol":{"type":"esriPMS","url":"8efb621eedb5f36e946e4ebbbc61aeb8","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAMCAYAAABr5z2BAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABJklEQVQokbWRv26DQAzGfacoD8BWKc+AIjliAikzKt3YMqJ0gyEDY8IW8QbHkCkDDCyl4gmYEPcCUeZ0hwxZuKtAUdVWoX9U1eNn+2d/9gj+GKN/A3DOUQhhUUpPiBj9CsA5X0opGSEE2raFqqqWQohA07TsS0BZlt3EtZQSj8cjhGEITdOA7/s4nU6fqqril8vlQdf1000ApZSdz+c7xhgkSQJCiF53HAdM0wTP81BRlDUAPA5a2O12EMcxSCk/6Hme93aCICCDFgghG9d12Xw+h+12C4fDodcnkwmsViswDIMLIbJBACJGRVE8q6rK9vv9fZqmUNc1LBaLl/F4nM1ms7fVBy1cD2R1b7RteyOlPFFKI0Tkn2tvAt5t0zVYQ/lvAT+NV6gOecjJ4OHWAAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":9,"angle":0,"xoffset":0,"yoffset":0},"values":[["Spill Response"]]},{"label":"Water Quality","description":"Water Quality","symbol":{"type":"esriPMS","url":"61bdf4f93214a98a5789ac22e70bbc36","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAoAAAAMCAYAAABbayygAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA3UlEQVQYlWNhIBKwkK0wvfld5cxaoXa8CuPangh///GvPKf5zckptSL7cCr8+5199drHv/h9pdlmZXW9splWJvYCQ2FgxSuP25/+2f34w8Cw7tFv5UA5lkNpDf8NZjUwfkNRyM7CWP37/39mDykWhh3P/jBsf/pHNVjh3RQGBoYkFIXf/zAIP/jyj+H1D0Yw/+uf/ww/fv9XwLCanYXh9u//DJpPvv0D80XYGRnYmP+fwVD46t3/aDdJ5p0vvjMYMDMy/BLnZN6+pEm4DEPhgWliXxgYGKyxBzcJMQMAHf1UB9pMeUIAAAAASUVORK5CYII=","contentType":"image/png","width":7,"height":9,"angle":0,"xoffset":0,"yoffset":0},"values":[["Water Quality"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"8efb621eedb5f36e946e4ebbbc61aeb8","imageData":"iVBORw0KGgoAAAANSUhEUgAAABAAAAAMCAYAAABr5z2BAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABJklEQVQokbWRv26DQAzGfacoD8BWKc+AIjliAikzKt3YMqJ0gyEDY8IW8QbHkCkDDCyl4gmYEPcCUeZ0hwxZuKtAUdVWoX9U1eNn+2d/9gj+GKN/A3DOUQhhUUpPiBj9CsA5X0opGSEE2raFqqqWQohA07TsS0BZlt3EtZQSj8cjhGEITdOA7/s4nU6fqqril8vlQdf1000ApZSdz+c7xhgkSQJCiF53HAdM0wTP81BRlDUAPA5a2O12EMcxSCk/6Hme93aCICCDFgghG9d12Xw+h+12C4fDodcnkwmsViswDIMLIbJBACJGRVE8q6rK9vv9fZqmUNc1LBaLl/F4nM1ms7fVBy1cD2R1b7RteyOlPFFKI0Tkn2tvAt5t0zVYQ/lvAT+NV6gOecjJ4OHWAAAAAElFTkSuQmCC","contentType":"image/png","width":12,"height":9,"angle":0,"xoffset":0,"yoffset":0},"value":"Spill Response","label":"Spill Response"},{"symbol":{"type":"esriPMS","url":"61bdf4f93214a98a5789ac22e70bbc36","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAoAAAAMCAYAAABbayygAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA3UlEQVQYlWNhIBKwkK0wvfld5cxaoXa8CuPangh///GvPKf5zckptSL7cCr8+5199drHv/h9pdlmZXW9splWJvYCQ2FgxSuP25/+2f34w8Cw7tFv5UA5lkNpDf8NZjUwfkNRyM7CWP37/39mDykWhh3P/jBsf/pHNVjh3RQGBoYkFIXf/zAIP/jyj+H1D0Yw/+uf/ww/fv9XwLCanYXh9u//DJpPvv0D80XYGRnYmP+fwVD46t3/aDdJ5p0vvjMYMDMy/BLnZN6+pEm4DEPhgWliXxgYGKyxBzcJMQMAHf1UB9pMeUIAAAAASUVORK5CYII=","contentType":"image/png","width":7,"height":9,"angle":0,"xoffset":0,"yoffset":0},"value":"Water Quality","label":"Water Quality"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[185,252,179,255],"toColor":[185,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,179,252,255],"toColor":[250,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,182,255],"toColor":[252,204,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,230,252,255],"toColor":[179,230,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,191,252,255],"toColor":[184,191,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,249,182,255],"toColor":[252,249,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,239,255],"toColor":[252,215,239,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,252,231,255],"toColor":[197,252,231,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,189,255],"toColor":[252,182,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,222,255],"toColor":[252,182,222,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[233,252,212,255],"toColor":[233,252,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[215,215,252,255],"toColor":[215,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,235,210,255],"toColor":[252,235,210,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field: WQSR_CASE_TYPE

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
WQSR_CASE_ID (type: esriFieldTypeInteger, alias: CaseID, SQL Type: sqlTypeOther, nullable: true, editable: true)
WQSR_CASE_ST_DATE (type: esriFieldTypeDate, alias: CaseStartDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
WQSR_CASE_TYPE (type: esriFieldTypeString, alias: CaseType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
WQSR_SITE_ID (type: esriFieldTypeInteger, alias: SiteID, SQL Type: sqlTypeOther, nullable: true, editable: true)
WQSR_SITE_ADDRESS_TEXT (type: esriFieldTypeString, alias: SiteAddress, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
WQSR_CALR_PRBLM_DESC (type: esriFieldTypeString, alias: CallerProblemDescription, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
WQSR_CALR_PRBLM_DESC_2 (type: esriFieldTypeString, alias: CallerProblemDescription, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
WQSR_SEWER_CLS_DESC (type: esriFieldTypeString, alias: SewerClassDescription, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
WQSR_BASIN_NAME_TEXT (type: esriFieldTypeString, alias: BasinName, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
WQSR_SUBBASIN_NAME_TEXT (type: esriFieldTypeString, alias: SubbasinName, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
WQSR_POLLUTANT_MS4_FLAG (type: esriFieldTypeInteger, alias: PollutantMS4, SQL Type: sqlTypeOther, nullable: true, editable: true)
WQSR_RCHD_WTRBDY_FLAG (type: esriFieldTypeInteger, alias: ReachedWaterBody, SQL Type: sqlTypeOther, nullable: true, editable: true)
WQSR_POLLUTANT_DESC (type: esriFieldTypeString, alias: PollutantDescription, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
WQSR_PRBLM_CAUSE_TEXT (type: esriFieldTypeString, alias: ProblemCause, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
WQSR_SRC_LOC_FLAG (type: esriFieldTypeString, alias: SourceLocated, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
WQSR_CASE_STATUS_FLAG (type: esriFieldTypeString, alias: CaseStatus, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
WQSR_CASE_SUMMARY_TEXT (type: esriFieldTypeString, alias: CaseSummary, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
WQSR_CASE_SUMMARY_TEXT_2 (type: esriFieldTypeString, alias: CaseSummary, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
WQSR_SITE_VISIT_DATE (type: esriFieldTypeDate, alias: SiteVisitDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
WQSR_X_COORD (type: esriFieldTypeDouble, alias: XCoordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
WQSR_Y_COORD (type: esriFieldTypeDouble, alias: YCoordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

WQSR_CASE_TYPE: Spill Response

WQSR_CASE_TYPE: Water Quality

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/12/2026 9:52:23 AM

Schema Last Edit Date: 2/12/2026 9:52:23 AM

Data Last Edit Date: 2/12/2026 9:52:23 AM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat