View In:   ArcGIS Online Map Viewer

Name: i08_Stations_Discrete_Grab_Water_Quality

Display Field: STATION_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This is a point feature class of environmental monitoring stations maintained in the California Department of Water Resources’ (hereafter the Department) Water Data Library Database (WDL) for discrete “grab” water quality sampling stations. The WDL database contains DWR-collected, current and historical, chemical and physical parameters found in drinking water, groundwater, and surface waters throughout the state. This dataset is comprised of a Stations point feature class and a related “Period of Record by Station and Parameter” table. The Stations point feature class contains basic information about each station including station name, station type, latitude, longitude, and the dates of the first and last sample collection events on record. The related Period of Record Table contains the list of parameters (i.e. chemical analyte or physical parameter) collected at each station along with the start date and end date (period of record) for each parameter and the number of data points collected. The Lab and Field results data associated with this discrete grab water quality stations dataset can be accessed from the California Natural Resources Agencies Open Data Platform at https://data.cnra.ca.gov/dataset/water-quality-data or from DWR’s Water Data Library web application at http://wdl.water.ca.gov/waterdatalibrary/index.cfm.

Copyright Text: California Department of Water Resources

Default Visibility: true

MaxRecordCount: 1000

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.38482559742E7
YMin: 3834629.1094999984
XMax: 1.3538676470299996E7
YMax: 5190009.0205999985
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: false

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 )
• STATION_ID ( type: esriFieldTypeString, alias: STATION_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STATION_ID )
• STATION_NAME ( type: esriFieldTypeString, alias: STATION_NAME, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STATION_NAME )
• FULL_STATION_NAME ( type: esriFieldTypeString, alias: FULL_STATION_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FULL_STATION_NAME )
• STATION_NUMBER ( type: esriFieldTypeString, alias: STATION_NUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STATION_NUMBER )
• STATION_TYPE ( type: esriFieldTypeString, alias: STATION_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STATION_TYPE )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• COUNTY_NAME ( type: esriFieldTypeString, alias: COUNTY_NAME, editable: true, nullable: true, length: 30, defaultValue: null, modelName: COUNTY_NAME )
• SAMPLE_COUNT ( type: esriFieldTypeInteger, alias: SAMPLE_COUNT, editable: true, nullable: true, defaultValue: null, modelName: SAMPLE_COUNT )
• SAMPLE_DATE_MIN ( type: esriFieldTypeDate, alias: SAMPLE_DATE_MIN, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SAMPLE_DATE_MIN )
• SAMPLE_DATE_MAX ( type: esriFieldTypeDate, alias: SAMPLE_DATE_MAX, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SAMPLE_DATE_MAX )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMENTS )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SOURCE )
• LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_MODIFIED_DATE )
• MODIFIED_BY ( type: esriFieldTypeString, alias: MODIFIED_BY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MODIFIED_BY )
• DATE_DATA_REFERS_TO ( type: esriFieldTypeDate, alias: DATE_DATA_REFERS_TO, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_DATA_REFERS_TO )

Templates:

• Name: i08_Stations_Discrete_Grab_Water_Quality
  Description:
  Prototype:
  MODIFIED_BY: null
  DATE_DATA_REFERS_TO: null
  STATION_ID: null
  STATION_NAME: null
  FULL_STATION_NAME: null
  STATION_NUMBER: null
  STATION_TYPE: null
  LATITUDE: null
  LONGITUDE: null
  COUNTY_NAME: null
  SAMPLE_COUNT: null
  SAMPLE_DATE_MIN: null
  SAMPLE_DATE_MAX: null
  COMMENTS: null
  SOURCE: null
  LAST_MODIFIED_DATE: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• Stations_Water_Quality_POR (0) -- Related To: i08_Stations_Discrete_Grab_Water_Quality_POR (1)

Capabilities: Query

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   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata