Water Quality Sampling Data

City of Austin

@usgov.city_of_austin_water_quality_sampling_data

Table List

1 table(17.75 MB)

Table 1

@usgov.city_of_austin_water_quality_sampling_data.table_1

17.75 MB
1477595 rows
24 columns

data_ref_no DATA REF NO	sample_ref_no SAMPLE REF NO	project PROJECT	watershed WATERSHED	site_type SITE TYPE	sample_site_no SAMPLE SITE NO	site_name SITE NAME	lat_dd_wgs84 LAT DD WGS84	lon_dd_wgs84 LON DD WGS84	sample_date SAMPLE DATE	time_null TIME NULL	collecting_group Collecting Group	medium MEDIUM	param_type PARAM TYPE	parameter PARAMETER	unit UNIT	qc_flag QC FLAG	method METHOD	filter FILTER
2308323	448739	Groundwater	Barton Creek	Well	735	USGS Well 301526097463201 (Rabb Well)	30.25120544	-97.78089142	12/07/1947 12:00:00 AM	Y	ATCHD	Ground Water	Nutrients	NITRATE AS N	MG/L	U	UNKNOWN	Total
2308163	448739	Groundwater	Barton Creek	Well	735	USGS Well 301526097463201 (Rabb Well)	30.25120544	-97.78089142	12/07/1947 12:00:00 AM	Y	ATCHD	Ground Water	Major Ions	CHLORIDE	MG/L	U	UNKNOWN	Total
2308160	448739	Groundwater	Barton Creek	Well	735	USGS Well 301526097463201 (Rabb Well)	30.25120544	-97.78089142	12/07/1947 12:00:00 AM	Y	ATCHD	Ground Water	Major Ions	SODIUM	MG/L	U	UNKNOWN	Total
2308159	448739	Groundwater	Barton Creek	Well	735	USGS Well 301526097463201 (Rabb Well)	30.25120544	-97.78089142	12/07/1947 12:00:00 AM	Y	ATCHD	Ground Water	Major Ions	MAGNESIUM	MG/L	U	UNKNOWN	Total
2308158	448739	Groundwater	Barton Creek	Well	735	USGS Well 301526097463201 (Rabb Well)	30.25120544	-97.78089142	12/07/1947 12:00:00 AM	Y	ATCHD	Ground Water	Major Ions	CALCIUM	MG/L	U	UNKNOWN	Total
2308162	448739	Groundwater	Barton Creek	Well	735	USGS Well 301526097463201 (Rabb Well)	30.25120544	-97.78089142	12/07/1947 12:00:00 AM	Y	ATCHD	Ground Water	Major Ions	SULFATE	MG/L	U	UNKNOWN	Total
2308324	448739	Groundwater	Barton Creek	Well	735	USGS Well 301526097463201 (Rabb Well)	30.25120544	-97.78089142	12/07/1947 12:00:00 AM	Y	ATCHD	Ground Water	Solids/Conductivity	TOTAL DISSOLVED SOLIDS	MG/L	U	UNKNOWN	Dissolved
2308161	448739	Groundwater	Barton Creek	Well	735	USGS Well 301526097463201 (Rabb Well)	30.25120544	-97.78089142	12/07/1947 12:00:00 AM	Y	ATCHD	Ground Water	Alkalinity/Hardness/pH	BICARBONATE (AS HCO3)	MG/L	U	UNKNOWN	Total
2308322	448739	Groundwater	Barton Creek	Well	735	USGS Well 301526097463201 (Rabb Well)	30.25120544	-97.78089142	12/07/1947 12:00:00 AM	Y	ATCHD	Ground Water	Alkalinity/Hardness/pH	CALCIUM+MAGNESIUM HARDNESS (AS CACO3)	MG/L	U	UNKNOWN	Total
1031	88	Groundwater	Barton Creek	Spring	35	Barton Spring	30.2635351223695	-97.7709796798271	05/02/1986 12:00:00 AM	Y	WRE	Ground Water	Nutrients	AMMONIA AS N	MG/L	R	SM 4500-NH3 F	Total


CREATE TABLE table_1 (
  "data_ref_no" BIGINT,
  "sample_ref_no" BIGINT,
  "project" VARCHAR,
  "watershed" VARCHAR,
  "site_type" VARCHAR,
  "sample_site_no" BIGINT,
  "site_name" VARCHAR,
  "lat_dd_wgs84" DOUBLE,
  "lon_dd_wgs84" DOUBLE,
  "sample_date" VARCHAR,
  "time_null" VARCHAR,
  "collecting_group" VARCHAR,
  "sample_id" VARCHAR,
  "medium" VARCHAR,
  "depth_in_meters" DOUBLE,
  "param_type" VARCHAR,
  "parameter" VARCHAR,
  "qc_type" VARCHAR,
  "qualifier" VARCHAR,
  "result" DOUBLE,
  "unit" VARCHAR,
  "qc_flag" VARCHAR,
  "method" VARCHAR,
  "filter" VARCHAR
);