Thursday, April 16, 2020

Healthcare Worker Deaths from Coronavirus (COVID-19): Update - 71 deaths, CDC Study

As of 4/15, 71 healthcare workers have died of coronavirus (COVID-19) in the US. Updated numbers at:

  • Roughly half of deaths occurred among Nurses and Certified Nursing Assistants
  • Median age = 56 years old, range 20 - 75 years old
  • Most have occurred in Hospitals. Of note, VA hospitals have had 8 COVID-related deaths
  • New York State (13), Michigan (8), New Jersey (8), and Florida (7) are the states with most healthcare worker fatalities

The code and data for this project are available on GitHub:

The CDC has published a study and found only 27-related deaths, highlighting shortcomings in recording deaths and occupation, and recording the impact of COVID-19 on healthcare workers:

Saturday, March 28, 2020

Healthcare worker deaths in the US from novel Coronavirus (COVID-19)

Created a quick app based on news reports:

  • Eight-related deaths so far. I hope not to have to update this. 
  • Healthcare workers will make up a disproportionate percent of cases and possibly also fatalities. 
  • The app was created using R, rshiny(package), and for hosting
  • Map will be updated daily.
  • China only reported 5 deaths in healthcare workers. Healthcare personnel made up 4% of cases. Fifteen percent of healthcare workers that got ill were classified as severe cases. (

Thursday, April 14, 2016

The Last Post...

After some soul searching, I've decided to stop writing regular blog posts.  It has been my pleasure to help out people interested in doing spatial things...and for free!  The GIS world is large, diverse, friendly, and super smart!  I've enjoyed getting to know what other people are working on around the world and how to approach very complex problems! I've learned a lot in the process, and I hope you have too!

Why stop?  Well, projects were getting more complex and time consuming, including a post on GeoServer, which didn't get finished, and more maps using Leaflet.  Believe it or not, I have more than 100 ideas for posts--which never got done!  I also spent extra time creating a few YouTube videos.  -The process is just too time consuming,  I plan to devote more time to trying to develop a QGIS plugin and hiking in the Mid-Atlantic region. My only regret is that I didn't finish the GeoDA tutorial. That was never my intention.  My favorite thing has been to watch QGIS grew into the platform it is today!

Lastly, I've decided to re-double my efforts at work in violence prevention and reducing firearm homicides in Baltimore City (  If you are still interested in following me, subscribe to my Twitter feed @jontheepi:

All the best!

Sunday, February 21, 2016

Spatial Analysis with GeoDa: Part II - Importing Data and Tools

GeoDa opens as a "floating bar" which you will find nice as you do analysis and realize multiple linked windows can be arranged.  The maps and graphs are interactive, as I'll show in later posts, show selecting features in one window will highlight the same parts in other windows.

When I learn a new piece of software, I always go from left to right.  
File Menu
The "File" menu allows you to import data, save and load projects (self-named *.gda files), and export selected data. In addition, there is a nice Project Information option that tells the title, data source and type, project name, number of observations and fields.

Data Formats
Users can import a wide array of file formats: shapefile, SQLite/SpatialLite, *.csv , .xls, .dbf, .json, .gml, .kml, and MapInfo files.  Remember, are analyzing vector data, so points, lines, and polygons. Remember map projections matter, since spatial weights are created based on distance!

GeoDa does a great job of offering multiple file types to import.
Tools Menu: Spatial Weights
Spatial weights are used to model spatial relationships. Using GeoDa, we can create spatial weights based on contiguity/bordering (think chess moves: rook or queen), distance, and the number of nearest neighbors.  Imagine a grid or matrix that has a row and column for every feature.  The cells are populated using 0/1 for weights based on contiguity (where a feature borders another) or distances for distanced based weights.

  • Generally, do not go above 2nd order of contiguity: 1st order contiguity is neighbors, 2nd order is neighbors of neighbors.  Anything beyond this becomes extremely difficult to interpret.
  • The GeoDa Center also has PySAL an open source Python library that can be used to create spatial weights and perform spatial analysis.
The first option is "Select" if you have already created weights.  The second option is "Create."  Here you will a couple of options to examiner spatial relationships in your data.  Which one you choose should be based on the phenomenon you are studying. Like other types of analysis, you will also want to examine how different spatial weights affect your results.
Connectivity Histogram
Another one of GeoDa's cool features is a histogram that shows the number of features with a specific number of features.  It can also help you clear up any questions you have about different types of contiguity and how spatial relationships are modeled.

On the histogram a right, the bar/bin for two neighbors is selected.
On the map at left the county is highlighted. Selecting other bars would highlight more features.
Users can also see the distribution of the spatial weights from the histogram.
In case you tabular data, you can create points from this menu. You can also create a bounding box or grid.  Next time, we'll look at the Table and Map toolbars.

Want blog or YouTube updates?  You can follow me @jontheepi:

Wednesday, February 3, 2016

Spatial Analysis with GeoDa: Part I - Introduction

GeoDa ( is a free and open source cross-platform program for exploratory (spatial) data analysis or EDA/ESDA and maximum likelihood spatial regression. It has been downloaded nearly 150,000 times and is available on Windows, OS X, and Linux.  ASU's GeoDa center is home to Luc Anselin, e.g. Anselin's Moran's I a local indicator of spatial autocorrelation or LISA.

Update #1: It looks like an older version of GeoDa's source code is available (circa 2014) but not more current versions:

Why use GeoDa?
You are interested in spatial analysis of vector data (points, lines, polygons) and statistics.  This includes looking for clusters of count or rate data, which have similar attribute values, performing regression (asking why a certain pattern exists), observed/predicted values, residuals, and diagnostics. Spatial statistics are commonly used in mainly fields including health, criminology, and pretty much everything!

If you are using GIS for a problem, at some point, you should consider spatial statistics.  The human brain and eye can only see so much.  Some patterns aren't easily apparent.

Spatial analysis can come at a cost ($), and this is why GeoDa is so great!  It is free, open source, and has great capabilities  It even includes some advanced options which you can't currently find in ArcGIS.

GeoDa includes the ability to make choropleth maps, graphs, Thiessen polygons, creating spatial weights using queen and rook contiguity (which requires a high level license in ArcGIS), graphing features by number of neighbors, linked graphs you can 'brush,' LISAs, and regression. We will dive deeper into features later--there is a lot to cover.

A list of GeoDa's features can be found at:  Also, here is a list of its modeling features:

Examples of Use
In 2014, I wrote about a simple use case: examining health insurance rates at the county-level:

More to come...
This is the first part in a series that explores GeoDa's functions and spatial statistics. If there is something you would like to see, leave it in the comment section below.

Want blog or YouTube updates?  You can follow me @jontheepi:

Thursday, January 21, 2016

Looking at Weather Maps and Data for Winter Storm Jonas

Previously, I've written about Being Weather Ready: The Open Source Way and Weather GIS, Data, and Viewers. I would probably stop blogging about the weather if there weren't bigger storms each year. Family, friends, and coworkers often ask me what the weather will be like or get confused about updated/changing predictions.  Maybe yours do to!
NOAA has recently quadrupled their computing power which will lead to better forecasts for everything from winter storms to major hurricanes.
Fortunately, there is a lot of great information, maps, and data out there, if you know where to look! Winter storms don't carry official names. But,the Weather Channel has adopted this idea and named the upcoming storm "Jonas."

Local Forecast Office
The National Weather Service (NWS) has local forecast offices spread throughout the country. Often, the offices have specific pages to deal with certain weather threats.

For example, the Sterling Office for DC-Virginia-Maryland has a Winter Weather Page: The maps below show the:
  • At the top, links and headlines highlight key weather threats and message
  • Minimum, most likely, and maximum amount of snowfall
  • Storm track, time of onset, and reported snowfalls are all clearly labeled. 
  • Warning areas are highlighted at a county level. Clicking the map takes you to the local forecast in text--with additional links to hourly graphs.
  • Probabilities are given for different snowfall amounts
  • Weather fronts are highlighted nationally
  • Lastly, always check the time stamp of the forecast map, since forecasts change frequently.
I'm from Baltimore, so the expected snowfall is between 23-25 inches, Range 7 to 27 inches.  The storm is expected to start between 3 to 5 pm. See weather forecasting is not that hard! (just kidding).  Be sure to read any text warnings and messages. Surface winds will be the 30 mph range with gusts possibly exceeding 50 mph. For more on effects of wind speed, check out: 
The NWS packs a lot of information neatly into their web page.
Although a 'long' web page, there is a clear hierarchy of information from
most important to least important and specific weather information to
general climate information.
Some weather information can't be captured well on maps, so you will also have to look at graphs.

NWS also has a GIS Data Portal ( so you can make your own maps. But you don't have to go through all those steps and can use web-based map tools like NOWCOAST ( for real-time information and the easier to use Enhanced Data Display ( There is also a briefing site:

Storm Results
See below from the NWS, or check out the NY Times map "How much snow has fallen?"
Jonas shaped up to be everything the predictions were!

Satellite Imagery

A Snow Blanket for the East Coast.  NASA Earth Observatory images (first, second)
 by Joshua Stevens, using Landsat data from the 
U.S. Geological Survey.
 NASA image (third) by Jeff Schmaltz, 
LANCE/EOSDIS Rapid Response.
Caption by Mike Carlowicz.

Map Examples
Some maps convey their message better than others.  Weather maps are no exception...What do you think about the maps below? You be the judge...

Easiest on the Eyes
USA Today had the most pleasing storm map that I could find. Simple and effective.

  • At this scale, the classification and increment of snowfall is appropriate. Although not described in the text, the mapmaker assumes the reader will see that Washington and Charleston, highlighted differently in white, will receive the most snowfall.

Source: USA Today
Hard on the Eyes
The Weather Channel loves translucent boxes, apparently.  This map of regional temperatures and precipitation probably combines too much information on one map. 

  • Precipitation type is also classified into different colors and different icons (snowflakes and rain drops). 

The second places cities and accumulation totals in boxes which makes it harder to read.  The boxes for cities probably is not necessary.
Source: Weather Channel via AccuWeather

Too Slow...but...
Lastly, it is notable to add that ESRI deploys personnel for large disasters, and usually posts a quick map.  Although in this case, their snow map animation is nothing to get excited about:

  • However, one nice feature, which I wish I saw more of in other interactive maps, are spatial bookmarks that allow the viewer to jump to certain places in the map.

Slow animation but spatial bookmarks (drop-down at the top) are a nice touch and speed navigation.

Monday, January 4, 2016

Video: Open GIS Data Portals

Open GIS data portals are becoming more common, and can contain lots of geospatial data, but is it a case of too much of a good thing?

What is a Portal?
An internet site providing access or links to other sites. In the case of open GIS data, the file may appear on the same page, link out to another website (or portal) or require more digging.  In addition, some GIS portals have links to web map services.

Search is the thing...
Open data portals house more and more data and therefore can become more difficult to search over time. Creating complex searches is sometimes not available and can slow the discovery process.

What are they made of?
Open data portals leverage free and open, propriety, or hybrid data and/or GIS platforms.

Here one minute, gone the next...
While often data can be downloaded directly, some sites link to external or partner data sources. Some data may seem accessible and near-at-hand but actually require more searching and digging.

In some cases, this is the result of syndicated data sets. For example, on federal data portals, local and state governments can have their data sets metadata appear in search results and link out to the resource.  In others, this can be overused, frustrating, or lead to broken links or missing resources. Sometimes going directly to the source can be easier than navigating a much larger data portal.

We will look at several open data portals for geospatial data:
Also check out for a neat interactive map of open data portals worldwide.

Looking for an open data portal?  Check out the interactive and searchable map on