IMD Water Quality Portal Archive 5/7/2025 by US Government | Environmental and Climate Sciences

About this Dataset

IMD Water Quality Portal Archive 5/7/2025

This is a backup of all Inventory and Monitoring Network discrete water quality data uploaded to the EPA Water Quality Exchange/ STORET as of May 2025.
Organization: Department of the Interior
Last updated: 2025-06-01T07:15:59.759301
Tags: aquatic, chemistry, contaminates, water-quality

Tables

P6-projected Output Nps Codes-05-May-2025-154552

@usgov.doi_gov_imd_water_quality_portal_archive_5_7_2025.p6_projected_output_nps_codes_05_may_2025_154552

43.2 MB
1437921 rows
81 columns


CREATE TABLE p6_projected_output_nps_codes_05_may_2025_154552 (
  "unnamed_0" BIGINT,
  "organizationidentifier" VARCHAR,
  "organizationformalname" VARCHAR,
  "activityidentifier" VARCHAR,
  "activitytypecode" VARCHAR,
  "activitymedianame" VARCHAR,
  "activitymediasubdivisionname" VARCHAR,
  "activitystartdate" TIMESTAMP,
  "activitystarttime_time" VARCHAR,
  "activitystarttime_timezonecode" VARCHAR,
  "activityenddate" VARCHAR,
  "activityendtime_time" VARCHAR,
  "activityendtime_timezonecode" VARCHAR,
  "activitydepthheightmeasure_measurevalue" VARCHAR,
  "activitydepthheightmeasure_measureunitcode" VARCHAR,
  "activitydepthaltitudereferencepointtext" VARCHAR,
  "activitytopdepthheightmeasure_measurevalue" VARCHAR,
  "activitytopdepthheightmeasure_measureunitcode" VARCHAR,
  "activitybottomdepthheightmeasure_measurevalue" VARCHAR,
  "activitybottomdepthheightmeasure_measureunitcode" VARCHAR,
  "projectidentifier" VARCHAR,
  "activityconductingorganizationtext" VARCHAR,
  "monitoringlocationidentifier" VARCHAR,
  "activitycommenttext" VARCHAR,
  "samplecollectionmethod_methodidentifier" VARCHAR,
  "samplecollectionmethod_methodidentifiercontext" VARCHAR,
  "samplecollectionmethod_methodname" VARCHAR,
  "samplecollectionequipmentname" VARCHAR,
  "resultdetectionconditiontext" VARCHAR,
  "characteristicname" VARCHAR,
  "resultsamplefractiontext" VARCHAR,
  "resultmeasurevalue" VARCHAR,
  "resultmeasure_measureunitcode" VARCHAR,
  "measurequalifiercode" VARCHAR,
  "resultstatusidentifier" VARCHAR,
  "statisticalbasecode" VARCHAR,
  "resultvaluetypename" VARCHAR,
  "resultweightbasistext" VARCHAR,
  "resulttimebasistext" VARCHAR,
  "resulttemperaturebasistext" VARCHAR,
  "precisionvalue" VARCHAR,
  "resultcommenttext" VARCHAR,
  "subjecttaxonomicname" VARCHAR,
  "sampletissueanatomyname" VARCHAR,
  "resultanalyticalmethod_methodidentifier" VARCHAR,
  "resultanalyticalmethod_methodidentifiercontext" VARCHAR,
  "resultanalyticalmethod_methodname" VARCHAR,
  "methoddescriptiontext" VARCHAR,
  "laboratoryname" VARCHAR,
  "analysisstartdate" VARCHAR,
  "resultlaboratorycommenttext" VARCHAR,
  "detectionquantitationlimittypename" VARCHAR,
  "detectionquantitationlimitmeasure_measurevalue" VARCHAR,
  "detectionquantitationlimitmeasure_measureunitcode" VARCHAR,
  "providername" VARCHAR,
  "activitystarttime_timezonecode_offset" VARCHAR,
  "activitystartdatetime" VARCHAR,
  "activityendtime_timezonecode_offset" VARCHAR,
  "activityenddatetime" VARCHAR,
  "monitoringlocationname" VARCHAR,
  "monitoringlocationtypename" VARCHAR,
  "monitoringlocationdescriptiontext" VARCHAR,
  "huceightdigitcode" VARCHAR,
  "sourcemapscalenumeric" VARCHAR,
  "horizontalaccuracymeasure_measurevalue" VARCHAR,
  "horizontalaccuracymeasure_measureunitcode" VARCHAR,
  "horizontalcollectionmethodname" VARCHAR,
  "horizontalcoordinatereferencesystemdatumname" VARCHAR,
  "verticalmeasure_measurevalue" VARCHAR,
  "verticalmeasure_measureunitcode" VARCHAR,
  "verticalcollectionmethodname" VARCHAR,
  "verticalcoordinatereferencesystemdatumname" VARCHAR,
  "countrycode" VARCHAR,
  "statecode" BIGINT,
  "countycode" BIGINT,
  "longitudemeasure" DOUBLE,
  "latitudemeasure" DOUBLE,
  "unit_code" VARCHAR,
  "unit_name" VARCHAR,
  "networkcode" VARCHAR,
  "networkname" VARCHAR
);