The US Environmental Protection Agency (EPA) has an incredible amount of data available to people, and the Risk-Screening Environmental Indicators (RSEI) microdata is a whopper of a dataset. RSEI is an air model which organizes results from environmantal data collected. Specifically, it tallies the quantities of release and transfer of chemicals, and is used to rate the air you breathe. The EPA is re-releasing this data by way of Amazon’s public data portal for anyone to use and visualize.
We took a look at the data and decided our Torque engine would be a great way to show how the readings have changed over time. With 27 years of data for 400 listed chemicals over 45,000 facilities, there’s a lot to show. We narrowed it down to a small area (SF Bay Area) and Joined the RSEI 1km grid to the Aggregated microdata to produce the map below, showing 1992-2014 changes in toxic concentrations.
What we have done exactly here is assign the ‘toxconc’ value to each grid cell for the 22 years of data we are using and merged that with the year of data, then visualized them, colored over a range. Since our values went from .000004 to 13 million, we used a custom torque aggregation function that mapped the values across a ramp:
The parameters for this function are:
avg((log(toxconc)+ (-min_toxconc) )*100.0/(max_toxconc-min_toxconc)<br>
The log transforms our values from .000004 to 13 million to -5.36 to 7.13. Then we simply shift the origin and scale so each value is between 0 and 100.
This gave us a balanced look at the data in the grid and made it possible to understand the nuances. Using chroma.js, we developed a color ramp based on a perceptual color space that assigned a color to each value to give it a continuous tone.
Using the power of CartoDB, we’ve brought the history of these 748K points into and can see the story of the air we breathe much more clearly.
Happy mapping (and breathing!)
As announced at Google Cloud Next ‘20, we are very pleased to provide more details about our BigQuery Tiler which is now available as a beta.News
Please fill out the below form and we'll be in touch real soon.