TRI Webtoy is an embedded json database application that uses optimized data for high performance. Using the U.S. EPA's database of toxic chemicals released to the environment, this app allows the public to quickly and easily explore quantities of toxic chemicals that U.S. Companies release into communities. U.S. Companies are required by law to report this information yearly to the U.S Environmental Protection Agency.

Comments about TRI Webtoy can be sent to the author: Will Smith (turboperl@gmail.com)


Data

Source: U.S. EPA TRI (Toxics Release Inventory) 2013 National Analysis dataset (released October 2014, Updated Nov 24, 2014).

For better performance, Webtoy's data has been optimzed and stored within the app's client-side java script using json's and requires no server-side component to run. To shorten startup time, care was taken to optimize the data for small storage. For example, the database in flat file format is 15M and once optimized just 4M.

This design model is useful for small database apps that must be low cost to build, high performance, and require no server-side overhead.


Settings

This is where the query is defined and conditions set to subset the data as well as select options such as for table decimal places, etc. Click the Data Table Tab to see the result. All reports will be created under these data constraints until the settings are changed or "Cleared" from the Settings Tab.


Drill Downs

Click any row in a report to drill down. This row will now become a constraint and all other reports will use this constraint. For example, select Group By Chemical, then click the 'Data Table' Tab to display a Chemical Report. To drill down on the chemical "1,1,1-TRICHLOROETHANE" click the row for this chemical. A drill down dialog will be displayed from which a drill down can be selected. All subsequent reports will use the condition chemical=1,1,1-TRICHLOROETHANE. This is a very easy way to do multiple sequential drill downs. The drill downs are displayed above each table. Drill downs can be deleted individually or all of them can be cleared.

Table decimal places:   Max Map markers:   Table Color:
Restrict facilities to a circular buffer:
    Radius:   Address    Lat: Lng: