Water Quality Data

State of California

@usgov.ca_gov_water_quality_data_c4036

Table List

2 tables(33.51 MB)

Lab Results

Field Results

Field Results

@usgov.ca_gov_water_quality_data_c4036.field_results

Water Quality Field Results

12.16 MB
1208898 rows
22 columns

station_id Station Id	station_name Station Name	station_number Station Number	full_station_name Full Station Name	station_type Station Type	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	fdr_result Fdr Result	fdr_reporting_limit Fdr Reporting Limit	uns_name Uns Name	mth_name Mth Name
12	H.O. Banks Headworks	KA000331	Delta P.P. Headworks at H.O. Banks PP	Surface Water	Public, Review Status Unknown	Alameda	OM0168A0001	Thu Jan 04 1968 07:45:00 GMT+0000 (Coordinated Universal Time)	1	Feet	DissolvedOxygen	9.2	0.2	mg/L	EPA 360.2 (Field)
12	H.O. Banks Headworks	KA000331	Delta P.P. Headworks at H.O. Banks PP	Surface Water	Public, Review Status Unknown	Alameda	OM0168A0001	Thu Jan 04 1968 07:45:00 GMT+0000 (Coordinated Universal Time)	1	Feet	ElectricalConductance	515	1	uS/cm	Std Method 2510-B (Field)
12	H.O. Banks Headworks	KA000331	Delta P.P. Headworks at H.O. Banks PP	Surface Water	Public, Review Status Unknown	Alameda	OM0168A0001	Thu Jan 04 1968 07:45:00 GMT+0000 (Coordinated Universal Time)	1	Feet	WaterTemperature	6.7	0.1	°C	EPA 170.1 (Field)
12	H.O. Banks Headworks	KA000331	Delta P.P. Headworks at H.O. Banks PP	Surface Water	Public, Review Status Unknown	Alameda	OM0168A0001	Thu Jan 04 1968 07:45:00 GMT+0000 (Coordinated Universal Time)	1	Feet	pH	7.3	0.1	pH Units	EPA 150.1 (Field)
12	H.O. Banks Headworks	KA000331	Delta P.P. Headworks at H.O. Banks PP	Surface Water	Public, Review Status Unknown	Alameda	OM0268A0006	Thu Feb 01 1968 08:10:00 GMT+0000 (Coordinated Universal Time)	1	Feet	DissolvedOxygen	9.7	0.2	mg/L	EPA 360.2 (Field)
12	H.O. Banks Headworks	KA000331	Delta P.P. Headworks at H.O. Banks PP	Surface Water	Public, Review Status Unknown	Alameda	OM0268A0006	Thu Feb 01 1968 08:10:00 GMT+0000 (Coordinated Universal Time)	1	Feet	ElectricalConductance	720	1	uS/cm	Std Method 2510-B (Field)
12	H.O. Banks Headworks	KA000331	Delta P.P. Headworks at H.O. Banks PP	Surface Water	Public, Review Status Unknown	Alameda	OM0268A0006	Thu Feb 01 1968 08:10:00 GMT+0000 (Coordinated Universal Time)	1	Feet	WaterTemperature	6.7	0.1	°C	EPA 170.1 (Field)
12	H.O. Banks Headworks	KA000331	Delta P.P. Headworks at H.O. Banks PP	Surface Water	Public, Review Status Unknown	Alameda	OM0268A0006	Thu Feb 01 1968 08:10:00 GMT+0000 (Coordinated Universal Time)	1	Feet	pH	7.5	0.1	pH Units	EPA 150.1 (Field)
12	H.O. Banks Headworks	KA000331	Delta P.P. Headworks at H.O. Banks PP	Surface Water	Public, Review Status Unknown	Alameda	OM0268A0013	Wed Feb 07 1968 10:30:00 GMT+0000 (Coordinated Universal Time)	1	Feet	DissolvedOxygen	7.6	0.2	mg/L	EPA 360.2 (Field)
12	H.O. Banks Headworks	KA000331	Delta P.P. Headworks at H.O. Banks PP	Surface Water	Public, Review Status Unknown	Alameda	OM0268A0013	Wed Feb 07 1968 10:30:00 GMT+0000 (Coordinated Universal Time)	1	Feet	ElectricalConductance	720	1	uS/cm	Std Method 2510-B (Field)


CREATE TABLE field_results (
  "station_id" BIGINT,
  "station_name" VARCHAR,
  "station_number" VARCHAR,
  "full_station_name" 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,
  "anl_data_type" VARCHAR,
  "parameter" VARCHAR,
  "fdr_result" DOUBLE,
  "fdr_text_result" VARCHAR,
  "fdr_date_result" TIMESTAMP,
  "fdr_reporting_limit" DOUBLE,
  "uns_name" VARCHAR,
  "mth_name" VARCHAR,
  "fdr_footnote" VARCHAR
);