About this Dataset

Microplastics In Drinking Water From Accredited Labs

Alpha Version Data (has undergone several rounds of internal review from the Moore Institute and is ready for external review)

This mock dataset is part of the Microplastics Data Portal and is intended to eventually serve as the data shared by state-accredited labs for microplastics in drinking water. It was created by discussions with domain experts. Data comes with a template with mock data entry and a rules file that can be used to validate the data using the Data Validation Portal.
Organization: State of California
Last updated: 2023-01-20T07:50:42.217009
Tags: alpha, microplastic

Tables

Methodology Rules

@usgov.ca_gov_microplastics_in_drinking_water_from_accredited_labs.methodology_rules

6.77 kB
18 rows
5 columns

CREATE TABLE methodology_rules (
  "name" VARCHAR,
  "description" VARCHAR,
  "valid_example" VARCHAR,
  "severity" VARCHAR,
  "rule" VARCHAR
);

Method Template

@usgov.ca_gov_microplastics_in_drinking_water_from_accredited_labs.method_template

14.13 kB
1 row
18 columns

CREATE TABLE method_template (
  "methodologyid" VARCHAR,
  "samplingdevice" VARCHAR,
  "airfiltration" VARCHAR,
  "airfiltrationtype" VARCHAR,
  "clothingpolicy" VARCHAR,
  "nonplasticpolicy" VARCHAR,
  "sealedenvironment" VARCHAR,
  "sealedenvironmenttype" VARCHAR,
  "sievemeshsizes" VARCHAR,
  "filtertype" VARCHAR,
  "filterdiameter" BIGINT,
  "filterporesize" BIGINT,
  "visidmethod" VARCHAR,
  "visualsoftware" VARCHAR,
  "pickingstrategy" VARCHAR,
  "vismagnification" BIGINT,
  "matidmethod" VARCHAR,
  "matidsoftware" VARCHAR
);

Particle Template

@usgov.ca_gov_microplastics_in_drinking_water_from_accredited_labs.particle_template

21.9 kB
1 row
17 columns

CREATE TABLE particle_template (
  "particleid" VARCHAR,
  "methodologyid" VARCHAR,
  "sampleid" VARCHAR,
  "photoid" VARCHAR,
  "spectraid" VARCHAR,
  "finalanalysisdate" TIMESTAMP,
  "comments" VARCHAR,
  "polymer" VARCHAR,
  "morphology" VARCHAR,
  "color" VARCHAR,
  "length" BIGINT,
  "width" BIGINT,
  "height" BIGINT,
  "mass" DOUBLE,
  "surfacearea" DOUBLE,
  "volume" BIGINT,
  "tactile" VARCHAR
);

Sample Rules

@usgov.ca_gov_microplastics_in_drinking_water_from_accredited_labs.sample_rules

5.3 kB
8 rows
5 columns

CREATE TABLE sample_rules (
  "name" VARCHAR,
  "description" VARCHAR,
  "valid_example" VARCHAR,
  "severity" VARCHAR,
  "rule" VARCHAR
);

Sample Template

@usgov.ca_gov_microplastics_in_drinking_water_from_accredited_labs.sample_template

7.38 kB
1 row
8 columns

CREATE TABLE sample_template (
  "sampleid" VARCHAR,
  "ownerorganization" VARCHAR,
  "analysisorganization" VARCHAR,
  "reportingorganization" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "collectiondate" TIMESTAMP,
  "samplevolume" BIGINT
);