Water Quality
Insights into Water Quality: An In-depth Examination
@kaggle.sukhmandeepsinghbrar_water_quality
Insights into Water Quality: An In-depth Examination
@kaggle.sukhmandeepsinghbrar_water_quality
This dataset contains water quality samples collected from Puget Sound, lakes, and streams in the region.
Sample ID: Unique identifier for each sample taken.
Grab ID: Identifier for the specific grab instance associated with the sample.
Profile ID: Identifier for the profile associated with the sample.
Sample Number: Sequential number assigned to each sample.
Collect DateTime: Date and time when the sample was collected.
Depth (m): Depth at which the sample was collected, measured in meters.
Site Type: Type of site where the sample was collected (e.g., river, lake, well).
Area: Geographic area or region where the sample was collected.
Locator: Locator information indicating the precise location of the sample.
Site: Specific site or location where the sample was collected.
Parameter: The parameter measured or analyzed in the sample (e.g., pH, dissolved oxygen).
Value: Value of the parameter measured in the sample.
Units: Units of measurement for the parameter value.
QualityId: Identifier indicating the quality of the data.
Lab Qualifier: Qualifier assigned by the laboratory indicating any special conditions or characteristics of the sample.
MDL (Method Detection Limit): Method detection limit for the parameter.
RDL (Reporting Detection Limit): Reporting detection limit for the parameter.
Text Value: Textual representation of the parameter value.
Sample Info: Additional information related to the sample.
Steward Note: Notes or comments provided by the data steward.
Replicates: Number of replicates taken for the sample.
Replicate Of: Identifier indicating the sample of which this is a replicate.
Method: Method used for analysis or measurement.
Date Analyzed: Date when the sample was analyzed.
Data Source: Source of the data.
CREATE TABLE water_quality_1 (
"sample_id" BIGINT,
"grab_id" DOUBLE,
"profile_id" BIGINT,
"sample_number" VARCHAR,
"collect_datetime" VARCHAR,
"depth_m" DOUBLE -- Depth (m),
"site_type" VARCHAR,
"area" VARCHAR,
"locator" VARCHAR,
"site" VARCHAR,
"parameter" VARCHAR,
"value" DOUBLE,
"units" VARCHAR,
"qualityid" BIGINT,
"lab_qualifier" VARCHAR,
"mdl" DOUBLE,
"rdl" DOUBLE,
"text_value" VARCHAR,
"sample_info" VARCHAR,
"steward_note" VARCHAR,
"replicates" DOUBLE,
"replicate_of" DOUBLE,
"method" VARCHAR,
"date_analyzed" TIMESTAMP,
"data_source" VARCHAR
);Anyone who has the link will be able to view this.