Spill Incidents in the State of New York

[troboukis]

Please complete all of the following sections, or the ghost of Joseph Pulitzer will spookily dance around your issue! A completed version of this template can be found at https://github.com/jsoma/data-studio-projects/issues/1

Pitch

Spills in New York

Summary

What kind of spills are the most common in the State of New York? What are the hazardous materials that end up in Hudson River and other waterfronts? Under State law and regulations, spills that could pollute the lands or waters of the state must be reported by the spiller (and, in some cases, by anyone who has knowledge of the spill). Examples of what may be included in a spill record includes: Administrative information (DEC region and unique seven-digit spill number). Program facility name. Spill date/time. Location. Spill source and cause. Material(s) and material type spilled. Quantity spilled and recovered. Units measured. Surface water bodies affected. Close date (cleanup activity finished and all paperwork completed).

Details

Possible headline(s):

Data set(s): https://data.ny.gov/Energy-Environment/Spill-Incidents/u44d-k5fk Code repository: https://github.com/troboukis/DATA_STUDIO/blob/master/3_PROJECT/OIL_SPILLS.ipynb Possible problems/fears/questions:

Work so far

Have produced a couple of graphs. A bit behind on the project.

Checklist

This checklist must be completed before you submit your draft.

• [ ] I have already spent time with my data set, opening it, exploring it, etc
• [ ] I have created a "DIARY.md" file to save links and list all of the terrible, no good problems I come across
• [ ] My issue links to my data set(s)
• [ ] My issue links to my code repository
• [ ] My issue explains what I'd like to explore in the data set
• [ ] My issue includes images - either inspiration or what I've done so far

[Palarisk]

Hi, this is really interesting! I love your colors and how the charts look like. However, you definitely need more labels etc explanation what's happening in these charts: what are the units for frequency, what do units mean?

[SiruiZhu]

The dataset looks fascinating! Here I come up with some suggestion:

• Maybe give an unit for axis x for your first chart?

• and the axis-y lables are unclear for now.

[troboukis]

Update

Your project content: images/words/etc

This is a map which shows the spills in the State of NY. I'll produce more maps which will show the spill of hazardous material, and probably a closer map to show the spills in NYC.

Any changes in direction or topic?

I'll focus in producing maps and maybe a couple of graphs.

Problems/Questions

The progress is slow, but will excel this week. Trying to find a documentation page for the data.

Checklist

• [x] I have included my visuals
• [x] I have filled out the sections above
• [ ] I have been updating my DIARY.md with details about my process
• [x] I have uploaded/updated any Jupyter Notebooks or other datasets into my code repository

[sarahslo]

i like knowing what is spilled in the hudson river. can you tell us who is spilling and what they are spilling? knowing what is being spilled is very interesting. my next question is, who spilled?!

can you give us what happens after the spill? are there fines or cleanups done? i want to know if you can get away with this?!

[troboukis]

This is exactly what I decided to focus on :) (I'll get rid of the white lines)

[tsp2123]

Hey, great map. Just out of curiosity is Sodium Bisulffite or Hydraulic Oil or some of the other weird scientify names known as something colloquial by which you can refer to it? If so I'd change that. Otherwise, great1

[sarahslo]

what is the difference here between the orange and the yellow dots? is there a way you can make the color relate to the thing? so we can see where all the diesel are, where all the sludge is...icons could also help us.

i think you can do a series of maps here, because once you get into manhattan the scale is too wide to see detail.

nice work. still want to know who?!

[troboukis]

Final

https://troboukis.github.io/troboukis/spills/

This is the latest version. The text is garbage (as Soma would say). I've added more information on the maps to get a better idea of the circumstances under which the spill occurred. I don't have conclusive data on who did what (unless it's stated otherwise on the dataset). If I where to publish it now, I'd look more into the area around Brooklyn and Queens. I'd join the dataset with data from enviromentals research which show the level of the chemicals in the houses in the area.

Project visuals/text

Details

Headline: Toxic Spills in the Hudson Published website version:

Code repository:

Final data set(s):

What did you find to be the most difficult part of this project?

Are you satisfied with what you produced? Is there anything you would like to change or improve?

I used the project for practising Qgis and illustrator. On that end I'm kind of happy.

Checklist

• [x ] I have included my visuals
• [ x] I have posted my project to my project website
• [ ] I have been updating my DIARY.md with details about my process
• [ x] I have uploaded/updated any Jupyter Notebooks or other datasets into my code repository