Effect on power lines in Florida (Hurricane Irma Sept 2017)

MyViz
4 min readSep 19, 2017

Following snapshots of dashboards and charts help understand the impact of Hurricane IRMA on Florida’s power lines.

  1. Various power providers in Florida

A very simple Pie chart (Chart:1) explains market share of different power providers based on total number of customer accounts. Total number of accounts is 10.4 million. The highest share (46.7% accounts) belongs to FPL (Florida Power & Light) followed by DE (Duke Energy), Municipals and Cooperatives. TE (Tampa electric), GF (Gulf Power), and FPU (Florida Public Utilities) have <10% share with FPU being the lowest among all.

Chart 1: Share of each provider by number of accounts

2. Outage scenario as it progressed each day

The daily progress (Dashboard 1:) for outages indicate that customers started loosing power slowly along the path of the storm. As Hurricane Irma approached Florida most of the southern counties lost power first. The percentage of outages spread fast with Sept 11 (Day 2) being worst for all of Florida (Chart 2:). There were 4.94 million customers without power in the state on Day 2. However, all the power providers worked hard to restore lights which brought down the number of customers without power to 2.14 million by end of Day 5 (Sept 14).

The most outages on Day 1 were in Monroe County (83%) whereas, on Day 5 the Highlands County had the most outages (80%). On Day 5 there was considerable improvement as seen by Monroe County numbers down to 61%. Also, Collier County went from 80% on Day 1 to 60% on Day 5. Palm Beach county improved from 74% outages on Day 1 to only 17% on Day 5. Similarly, Hardee county went from 77% to only 25%. Although, there will be more improvements as power providers continue to work, on Day 5 Highlands County (80% outages) needs most work followed by Putnam (48% outages) and Suwannee (32% outages).

On Dashboard 1: Daily progress

3. A closer look at outages on DAY 2

As seen in Chart2:, the Day 2 during the storm (Sept 11) was the day of most impact all over the state of Florida. There were outages in almost every county sparing just a few on the Northwestern tip of the map. Southern part of the state was most affected with Monroe County outages staying at 83% on Day 2 but Hendry County outages reaching 100% followed by Highlands (99%), Hardee (92%), and Okeechobee (90%). Outages were spread across the state with some of the northern counties getting more affected than the others like Lafayette and Columbia (both 91% outages).

Chart 2: Sept 12, 2017 (Day 2) Outages all over Florida

4. Overall picture on 09/14/2017 (DAY 5)

The overall scenario on Day 5 (Dashboard 2:) shows that only 14% of the total customers were without power and 53% customers got their power restored. Thanks to the continuous efforts of all the providers to keep their customers safe. There were only 2.34 million customers without power on Day 5.

Dashboard 2: Overall scenario on DAY 5

5. Number of outages vs. Percentage outages (by county comparison)

The representation of outages by county gives two different scenarios. The bar chart representation shows that Miami-Dade was the county with highest number of outages. Whereas in graphical representation on the map, Highlands is the county with highest percentage of outages (80%).

On Day 5, as seen in the (Chart 3:), Miami-Dade County was the one with highest number of outages (299.94k) followed by Lee county with 270.01k. Although these numbers were highest their percentage of outages based on total customers in that county indicate much smaller percentages. In fact Miami-Dade had only 26% outages whereas Lee had 62%. Similarly, on Day 5 Highlands county total number of customer without power was 49.88k which in percentage number was the highest at 80% outages. On the other hand, Broward was 201.06k outages equivalent to 21% and Palm Beach at 164.77k which was equivalent to 21% outages.

Chart 3: Day 5 Number of outages in various counties

--

--

MyViz

My Name is Rashmi Deshpande. Passionate about Analytics, Visualization, and Diabetes. www.linkedin.com/in/rashmi-deshpande-5a325a139