DSWAP Removal Efficiency Database
This is the web interface to the database of removal efficiencies observed in wastewater treatment. It represents the knowledge reported in the scientific literature as of 2022 with regard to selected chemical or biological contaminants and treatment technologies.
The unit of values reported differs between chemical contaminants (e.g. antibiotics or other drugs) and biological items (such as genetic markers). The values are computed from concentrations (or loads) in a treatment module's input (Cin) and output (Cout) as follows:
| Contaminant group | Reported value | Unit | Definition |
|---|---|---|---|
| Chemical | Percentage removal efficiency | % | PRE = (Cin - Cout) / Cin * 100 |
| Biological | Log removal value | - | LRV = log10(Cin / Cout) |
Use the navigation tabs at the top of the page to check the different functions of this web interface. For security reasons, the provided features differ between an online installation of this app (server mode) and local installations.
This interface allows a summary table to be filtered and sorted.
To filter the table to data of interest, click into the box displayed below a column header. Depending on the column type, you can either select from a set of values or enter a search string. In the latter case, only records matching the entered (sub)string will be shown.
To sort results, use the triangle symbols displayed next to the column headers.
The SQL interface
This interface allows SQL 'select' queries to be executed on the database. Refer to the relationship model shown at the bottom of the page to formulate your query. Note that, for security reasons, the allowed set of characters in SQL select statements was reduced to a minimum. Consequently, even some very common queries will not run.
Enter the SQL query string into the form and click the submit button. Tabular output resulting from the query will be displayed below the form. In case of an incorrect query, the respective error message will be displayed.
A set of sample queries can be found below. It is recommended to develop new queries in a local text editor so as to prevent a loss of work in case of network problems or other issues.
Example queries
Find the total number of records stored in the database
select count (*) from efficiencies
Return the entire table of contaminants
select * from contaminants
Find the number of records per contaminant
SELECT description AS Contaminant, COUNT (*) AS Records FROM efficiencies AS ef LEFT JOIN contaminants AS co ON ef.id_contaminant = co.id_contaminant GROUP BY description
Relationship model of the database
This interactive web page has been developed at the TU Dresden Institute of Hydrobiology as a contribution to the DSWAP project. The latter is part of the PRIMA Programme supported by the European Union.
Contact:
Prof. Dr. Thomas Berendonk
TU Dresden, Institute of Hydrobiology
01062 Dresden
Germany
phone: +49 351 463 34 956
email: thomas dot berendonk (at) tu-dresden dot de
Contributors to prototype version:
MSc. Aparna Chandrasekar (literature review)
Dr. David Kneis (database and web interface)
Responsible for integration of new data:
email: david dot kneis (at) tu-dresden dot de
Privacy policy
We use only cookies that are absolutely necessary exclusively for the provision of the service. This means specifically that no so-called tracking cookies are used to record or analyse user movements and the surfing behaviour of users of our site. In the given context, cookies enable the server to accept user input and to send the results back to the web browser. The cookies will be set automatically by access of this web page, except if setting cookies is disabled in the browser settings. Data processing takes place on the legal basis of section ยง6 para.1 lit. f GDPR. Storage of cookies is limited to the duration of the browser-session and any cookies will be removed after closing the browser.
AccessibilityThis web application is a prototype which is currently not meant for use by the general public. Therefore, some of its content is not yet accessible without barriers in accordance with EU legislation (Directive (EU) 2016/2102) and national law. Any barries will be removed to the maximum possible extent in a future version meant for public access. In the meantime, please contact the developers to find a suitable solution (see impressum).
DisclaimerThe site and the site elements are provided on an 'as is' and 'as available' basis. To the fullest extent permitted under applicable law, the developers and providers of this site expressly disclaims all representations and warranties of any kind with respect to the site, the site elements and any other products or services available on or through this site, whether, express or implied, including, but not limited to, any and all warranties (1) of merchantability or fitness for a particular purpose; (2) of non-infringement and title; (3) that any use of the site will be free from any interruptions, delays, inaccuracies, server down-time, errors or omissions; (4) that the site will be secure, or free of viruses, worms or other harmful components; (5) that the site and/or the site elements will satisfy your requirements or expectations; and (6) that information, data or materials presented or displayed on this site are correct, accurate or reliable.
Links to external web sites are provided as a convenience. The developers and providers of this site bear no responsibility for the accuracy, legality or content of the external site or for that of subsequent links. Contact the external site for answers to questions regarding its content.
These statements have been borrowed, with partial adaptation, from the web sites of the associated press and the library of congress.