Dataset: Water Quality Data

Water Quality Laboratory Results

station_id Station Id	station_name Station Name	full_station_name Full Station Name	station_number Station Number	station_type Station Type	status Status	county_name County Name	sample_code Sample Code	sample_date Sample Date	sample_depth_units Sample Depth Units	parameter Parameter	result Result	reporting_limit Reporting Limit	units Units	method_name Method Name
8135	01S04E32C001M	01S04E32C001M	01S04E32C001M	Groundwater	Public, Review Status Unknown	Alameda	WDIS_0719152	Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)	Feet	Conductance	3480	1	uS/cm	EPA 120.1
8135	01S04E32C001M	01S04E32C001M	01S04E32C001M	Groundwater	Public, Review Status Unknown	Alameda	WDIS_0719152	Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)	Feet	Dissolved Boron	7.7	0.1	mg/L	Std Method 4500-B, C
8135	01S04E32C001M	01S04E32C001M	01S04E32C001M	Groundwater	Public, Review Status Unknown	Alameda	WDIS_0719152	Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)	Feet	Dissolved Calcium	68	1	mg/L	EPA 215.2
8135	01S04E32C001M	01S04E32C001M	01S04E32C001M	Groundwater	Public, Review Status Unknown	Alameda	WDIS_0719152	Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)	Feet	Dissolved Chloride	758	0.1	mg/L	Std Method 4500-Cl, B
8135	01S04E32C001M	01S04E32C001M	01S04E32C001M	Groundwater	Public, Review Status Unknown	Alameda	WDIS_0719152	Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)	Feet	Dissolved Magnesium	59	0.1	mg/L	Std Method 3500-Mg, E
8135	01S04E32C001M	01S04E32C001M	01S04E32C001M	Groundwater	Public, Review Status Unknown	Alameda	WDIS_0719152	Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)	Feet	Dissolved Sodium	510	1	mg/L	Std Method 3500-Na, D
8135	01S04E32C001M	01S04E32C001M	01S04E32C001M	Groundwater	Public, Review Status Unknown	Alameda	WDIS_0719152	Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)	Feet	Total Alkalinity	270	1	mg/L as CaCO3	EPA 310.1
8135	01S04E32C001M	01S04E32C001M	01S04E32C001M	Groundwater	Public, Review Status Unknown	Alameda	WDIS_0719152	Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)	Feet	Total Hardness	412	1	mg/L as CaCO3	EPA 130.2
8135	01S04E32C001M	01S04E32C001M	01S04E32C001M	Groundwater	Public, Review Status Unknown	Alameda	WDIS_0719152	Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)	Feet	pH	8	0.1	pH Units	EPA 150.1
8166	01S04W04A001M	01S04W04A001M	01S04W04A001M	Groundwater	Public, Review Status Unknown	Alameda	WDIS_0744257	Fri Jul 18 1975 09:50:00 GMT+0000 (Coordinated Universal Time)	Feet	Conductance	1430	1	uS/cm	EPA 120.1

station_id

Station Id

station_name

Station Name

full_station_name

Full Station Name

station_number

Station Number

station_type

Station Type

latitude

Latitude

longitude

Longitude

status

Status

county_name

County Name

sample_code

Sample Code

sample_date

Sample Date

sample_depth

Sample Depth

sample_depth_units

Sample Depth Units

parameter

Parameter

result

Result

reporting_limit

Reporting Limit

units

Units

method_name

Method Name

8135

01S04E32C001M

Groundwater

Public, Review Status Unknown

Alameda

WDIS_0719152

Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)

Feet

Conductance

3480

uS/cm

EPA 120.1

8135

01S04E32C001M

Groundwater

Public, Review Status Unknown

Alameda

WDIS_0719152

Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)

Feet

Dissolved Boron

7.7

0.1

mg/L

Std Method 4500-B, C

8135

01S04E32C001M

Groundwater

Public, Review Status Unknown

Alameda

WDIS_0719152

Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)

Feet

Dissolved Calcium

mg/L

EPA 215.2

8135

01S04E32C001M

Groundwater

Public, Review Status Unknown

Alameda

WDIS_0719152

Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)

Feet

Dissolved Chloride

758

0.1

mg/L

Std Method 4500-Cl, B

8135

01S04E32C001M

Groundwater

Public, Review Status Unknown

Alameda

WDIS_0719152

Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)

Feet

Dissolved Magnesium

0.1

mg/L

Std Method 3500-Mg, E

8135

01S04E32C001M

Groundwater

Public, Review Status Unknown

Alameda

WDIS_0719152

Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)

Feet

Dissolved Sodium

510

mg/L

Std Method 3500-Na, D

8135

01S04E32C001M

Groundwater

Public, Review Status Unknown

Alameda

WDIS_0719152

Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)

Feet

Total Alkalinity

270

mg/L as CaCO3

EPA 310.1

8135

01S04E32C001M

Groundwater

Public, Review Status Unknown

Alameda

WDIS_0719152

Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)

Feet

Total Hardness

412

mg/L as CaCO3

EPA 130.2

8135

01S04E32C001M

Groundwater

Public, Review Status Unknown

Alameda

WDIS_0719152

Wed May 03 1967 09:00:00 GMT+0000 (Coordinated Universal Time)

Feet

0.1

pH Units

EPA 150.1

8166

01S04W04A001M

Groundwater

Public, Review Status Unknown

Alameda

WDIS_0744257

Fri Jul 18 1975 09:50:00 GMT+0000 (Coordinated Universal Time)

Feet

Conductance

1430

uS/cm

EPA 120.1

CREATE TABLE lab_results ( "station_id" BIGINT, "station_name" VARCHAR, "full_station_name" VARCHAR, "station_number" VARCHAR, "station_type" VARCHAR, "latitude" DOUBLE, "longitude" DOUBLE, "status" VARCHAR, "county_name" VARCHAR, "sample_code" VARCHAR, "sample_date" TIMESTAMP, "sample_depth" DOUBLE, "sample_depth_units" VARCHAR, "parameter" VARCHAR, "result" VARCHAR, "reporting_limit" DOUBLE, "units" VARCHAR, "method_name" VARCHAR );

Water Quality Data

Table List

Lab Results

@usgov.ca_gov_water_quality_data_c4036.lab_results

station_id

station_name

full_station_name

station_number

station_type

latitude

longitude

status

county_name

sample_code

sample_date

sample_depth

sample_depth_units

parameter

result

reporting_limit

units

method_name

Share link