I leave in south east Houston, not far from NASA Johnson Space Center. It's been a terrible few days for H-town.
As I sat Su-Tu watching flood waters rise towards my front door, I was constantly monitoring the nearest creek level gage:
I noticed the download to Excel button and downloaded the two files. I've uploaded the JMP datafile. Please take a look and run the Graph Builder script. I have a few questions for the community:
My house had a happy ending. Water came within 4" of topping my front door sill 0300 Tu. I was very fortunate. One third of the homes in my town were flooded. Time to go and help those less fortunate.
Updated 20170907: new file with compelete event data + NOAA hurricane track
Glad to see that the rain has stopped and the water is receding a little bit.
Let me attempt to answer the first question about the internet open. JMP tries to see what data exists on the web page, and your web page contains a lot of data. The one lower down the list that starts with 123 is the creek level, and then below that another one that starts with the date will be the rainfall. You can't know that unless you import all the selected items and realize which are the important ones to import. If you import all the highlighted rows, you see that the flood frequency and historical storm tables come in also. The data comes in with no column headers, so you need to enter those yourself.
Given that this website has a handy export to excel option, that would be easier than the internet open for this example.
I'm going to bookmark this web page and track to see how long it takes the creek to get back within its banks.
I'll work on another graph of the rainfall to see if I can find anything different than the presentation you already created.
I'm glad to hear you survived. My thoughts and well wishes go out to you and the others impacted by the storm.
If you do a transform on date by day and hour and then nest them I was able to get wider bars for the rain previous hour.