Dust Deposition data refers to data that is collected within a collection tray of a specified area over a indeterminate number of days. The dust sample is sent off to the laboratory and the results are returned in terms of mg/sample or ug/sample or similar (ie Total Solids = 41 mg). On receiving the data the results are corrected for the sampling area, and the duration and are normally reported as mg/m2/30 days or similar.
ESdat (with SQL Server Upgrade, only) can accomodate Dust Deposition data that is provided as "ug" and needs to be converted to "mg/m3/month" (or similar) by the system.
Information on the Dust Deposition Sampling is imported into the "Dust Deposition_Samples" table. This table supplements the "Chemistry_Samples" table, providing information specific to Dust Deposition Sampling. The import template is generated as shown below.
The “Dust Deposition Samples” Import Template will be shown as follows and can be populated:
•Field_ID: Must match the Samples Field ID as sent to the lab for analysis.
•Start/End_Date: The Date (and time) when sampling started/ended.
•Capture Area: The Area of sampling in the Area Units.
•Area Units: the measurement units, in one dimension (ie m rather than m2)
•Days to be corrected to: The sampling duration (End Date minus Start Date) can be extrapolated to a specific required duration, thus allowing standardisation of duration in the results.
•Other Sampling Fields: Other sampling fields (such as Location, Sampled By) are captured in the generic sampling fields, and are typically specified when importing the lab data.
•Outputs are corrected for Sample Area and Duration. Typical outputs include Exceedance Tables and graphs:
Laboratory data is imported in the normal manner, but the Matrix Type will need to be set to a value such as "Dust", which will need to have a Matrix State (see zRef_Matrix_Types) of "DustDep". The Field ID values will be matched and the area and duration correction applied automatically.
If receiving dust results reported in ug/m3 the ESdat Dust Deposition functionality is not needed, so there shouldn’t be an entry in the “Dust_Deposition_Samples” table, and the Matrix Type should have a Matrix State of “Gas” (see zRef_Matrix_Types). Some laboratories may by default report the same result in both "ug" and "um/m3", however this means some results will need correction, and some wont, which is not supported in ESdat - users should elect to either use the ESdat Dust Deposition corrections or not, and request the laboratory to report accordingly.
Outputs are as per normal outputs (ie tables and graphs), for example below: