Monday, December 12, 2011

The Cruise Ships are to Blame, Right! Right?

I swim in the San Francisco Bay, naked (without a wetsuit). And I belong to a swim club, next door to another such club, filled with like swimmers and rowers. We are very conscientious about water quality in the bay as its our pool and a special place.

In September, a thread sprung up on my swim club’s listserv about our swim hole being ‘posted’, which bluntly put it means there’s poop in the water -- unsafe levels of contamination. This is clearly a less than ideal situation for swimming. While the thread started by examining and trying to interpret the water quality readings, posters quickly turned on docking cruise ships and named them the culprits.

The first few posts were data focused. It began with an email forwarded from the San Francisco Public Utilities Commission (SFPUC) detailing the unhealthy levels of EColi and Enterococcus and led to a series of questions trying to reconcile the email with the data the SFPUC posted to San Francisco’s public data site datasf.org (http://bit.ly/sjfz6O). Initially, respondents were unsure of how to interpret the SFPUC’s water readings: How fresh is the data? Why are the warnings they sent via email different from the data on their website? What is the lag time between when readings are taken and when they are posted? Does this affect our understanding of the water quality?

Even before the questions were answered, it was blame time. It’s the Cruise Ships: “Is it a coincidence that the huge cruise ship just docked at Pier 29? I think not.... (ewwww.....)”.

Me, I’m a data person. I was still interested in understanding how the data was collected and how valid it was. Luckily, by replying to the list I was able to find the Cruise Ship Schedule and within an hour render a viz that shut down the rumor mill.



Based on the data, there was no clear correlation between cruise ship activity and unsafe water quality readings. There were an equal number of weeks in which two ships departed that had failing readings as there were that did not. No single cruise line, last port of departure or departing berth showed any significant correlation either.






What was clear from the data was that only Aquatic Park and Jackrabbit beach had EColi closures, which points to failing drainage or other spillage that drained into the bay.

It would have been great to identify the offending cruise ship company. I settled for returning the conversation to understanding the data and focusing on other sources for investigation: sewer pipes, runoff and local businesses. And then I sent this on to Deb at San Francisco Baykeeper, a non-profit "pollution watchdog" for the San Francisco Bay.  I learned that the contamination was likely linked to the Warf's dilapidated sewage system, which Baykeeper is working with the city to remedy.  Thank you SF Baykeeper!  Keep up the great work.

5 comments:

  1. Hey Leigh--Nice work! I'm playing with Tableau, and I noticed that the raw historical data no longer seem to be available from http://sfwater.org/tasks/beaches.csv (nor from the link in your post). Did you scare them off? ;)
    -Jesse

    ReplyDelete
  2. I was searching the web and Tableau forums for information on Tableau certification and eventually stumbled onto your site. As a former Dolphin, I got a kick out of finding this!

    Unfortunately, I'm still not clear on how or where one gets certified. Is it only at conferences?

    ReplyDelete
  3. Hello Everybody,
    My name is Mrs Sharon Sim. I live in Singapore and i am a happy woman today? and i told my self that any lender that rescue my family from our poor situation, i will refer any person that is looking for loan to him, he gave me happiness to me and my family, i was in need of a loan of S$250,000.00 to start my life all over as i am a single mother with 3 kids I met this honest and GOD fearing man loan lender that help me with a loan of S$250,000.00 SG. Dollar, he is a GOD fearing man, if you are in need of loan and you will pay back the loan please contact him tell him that is Mrs Sharon, that refer you to him. contact Dr Purva Pius,via email:(urgentloan22@gmail.com) Thank you.

    BORROWERS APPLICATION DETAILS


    1. Name Of Applicant in Full:……..
    2. Telephone Numbers:……….
    3. Address and Location:…….
    4. Amount in request………..
    5. Repayment Period:………..
    6. Purpose Of Loan………….
    7. country…………………
    8. phone…………………..
    9. occupation………………
    10.age/sex…………………
    11.Monthly Income…………..
    12.Email……………..

    Regards.
    Managements
    Email Kindly Contact: urgentloan22@gmail.com

    ReplyDelete
  4. MRS.IRENE QUERY FINANCE IS THE BEST PLACE TO GET A LOAN {mrsirenequery@gmail.com}

    God bless you Madam, I will not stop telling the world about your kindness in my life, I am a single mum with kids to look after. My name is Mrs.Rachel Alex, and I am from Singapore Center Drive, Miami Beach, FL . A couple of weeks ago My friend visited me and along our discussion she told me about MRS.IRENE QUERY FINANCE, that they can help me out of my financial situation, I never believed cause I have spend so much money on different loan lenders who did nothing other than running away with my money. I have been in a financial mess for the pass 7 months now,She advised I give it a try so I mailed her and explain all about my financial situation to her, she therefore took me through the loan process and gave me a loan of $180,000.00 at a very low interest rate of 3% and today I am a proud business owner and can now take good care of my kids, If you must contact any firm to get any amount of loan you need with a low interest rate of 3% and better repayment schedule, please contact MRS.IRENE QUERY FINANCE via email{mrsirenequery@gmail.com}

    ReplyDelete
  5. My name is.Mrs.Anna Daniel. I live in Ukraine i am a happy woman today? i need to use this time to tell all people how i got my loan from this honest and God fearing man loan lender that help me with a loan of $84,000 please contact him. if you also need a loan without any problem he name is Dr Purva Pius email (urgentloan22@gmail.com) tell him that is Mrs.Anna Daniel that refer you to he contact Email (urgentloan22@gmail.com)

    ReplyDelete