Data Visualization

Creating a COVID-19 Temporal Animation with QGIS

One of the most powerful new features released with QGIS v3.14 is the Temporal Controller, which allows you to enable time in your maps. It can be used to temporally enable vector, raster, mesh and WMS(T) data. The Temporal Controller is now a core part of QGIS and has several variables associated with it that allow you to create powerful visualizations and animations. It contains most of the functionality found in the Time Manager plugin.

Here you will learn how to use it with the New York Times COVID-19 data to produce a county-based animation of the outbreak in the U.S.

Getting the Data

To begin, download the current New York Times live COVID-19 data, a U.S. Counties with population shapefile and a State boundaries layer from the U.S. Census. Unzip the county and state data.

Add the Data to QGIS & do some basic styling

Add all three datasets to QGIS 3.14, then use either the QuickMapServices or MapTiler plugin to add an OpenStreetMap basemap. If you have not installed these, you can do so from the Plugins menu option Manage and Install Plugins.

Next you will symbolize the States with a simple black outline and no fill. Press F7 to open the Layer Styling Panel. Make sure the states layer is the target layer in the panel.

  • Select the Simple fill component.

  • Change the Fill style to No brush.

  • Increase the Stroke width to 0.46.

The NYT data is structured such that there is an entry for each county for each day of the pandemic. For each date it has both the cumulative number of confirmed COVID-19 cases and deaths.

2020-08-10_162130.jpg

Processing the Data

The only data processing step is joining the COVID-19 data to the counties layer by FIPS code. This is a 5 digit code (2 for the state and 3 for the county) which is a unique identifier for each county in the country.

You will use the Join Attributes by Field Value processing algorithm. Use the Processing menu to open the Processing Toolbox. Use search box at the top of the Toolbox to search for ‘Join’. This will filter the available tools. Locate the Join Attributes by Field Value processing algorithm in the Vector general section. Fill it out as shown below being careful to select the Join type of Create separate feature for each matching feature (one-to-many).

Warning: This is going to create a very large dataset with over 400,000 features. It may take quite awhile to process depending on the speed of you machine.

2020-08-10_163329.jpg

Symbolizing the COVID-19 Data

When the data has been processed you can symbolize it. Again the size of this dataset makes it a bit unwieldy. Since the goal is an animation which builds towards the current total of COVID-19 cases, you want to set up the classes so they make sense for the latest date in the dataset. To figure this out, you will temporarily filter the data for the most current date.

  • Open Layer Properties for the layer.

  • Choose the Source tab.

  • In the Provider Feature Filter section click on the Query Builder button.

  • In the Fields box highlight the date field.

  • In the Values box click All. Again this is a big dataset so it may take a few moments for QGIS to compute a list of all the dates.

  • Form an expression in the Provider Specific Filter Expression box. First double-click on the date field to enter that in the lower box. Then click on the equals operator. Finally double-click on the most current date.

  • Click OK.

2020-08-10_164257.jpg

When finished, a small filter icon will appear to the right of the layer in the Layers Panel. If you hover over that filter your expression will appear. Now you will work on styling the filtered dataset.

  • Make sure the correct counties layer is the target layer in the Layer Styling Panel.

  • Where it reads Single symbol, change it to Graduated. The Graduated renderer allows you to symbolize the counties based on a numeric field.

  • You can begin by simply choosing the cases field as the Value.

  • Click the Classify button and you will see the counties classified into the default 5 classes in your default color ramp.

  • Choose Equal Counts as the Mode.

  • Increase the number of Classes to 7.

  • Use the Color ramp selector to find a nice color ramp. Here I’m using the RdYlBu ramp.

  • Right-click on it and choose Invert. This is necessary if using the RdYlBu ramp so that the counties with the highest number of cases are red.

  • Next you will change all the outlines for all the classes to a thin white line. To do this, click on the colored bar next to Symbol.

    • Select Simple fill.

    • Change the Stroke color to white and the Stroke width to 0.06.

    • Click the blue back arrow button to return to the main layer styling options.

2020-08-10_171438.jpg

Normalizing the data by population

This is now turning into a nice map. However, it will be more informative to normalize the number of cases against the population. Otherwise we risk making a map of just population centers. In the Value section where you chose cases as the field, click the Expression button. The Expression Dialog window opens with cases as the expression. Here you will divide cases by population and multiply by 1,000,000. This will give you the cases as a rate per 1,000,000 people.

2020-08-10_172204.jpg
  • Put your cursor to the right of the word cases and click the / division symbol button.

  • Expand the Field and Values values section. You will see a list of all the attribute columns in the dataset.

  • Double-click on POPULATION to add field to your expression.

  • Next, wrap cases / “POPULATION” in parentheses.

  • Finally, enter a multiplication * symbol followed by the number 1000000 without thousands separators.

  • Click OK.

  • In the Layer Styling Panel click Classify again to see your map as cases per 1,000,000. You can also enter custom values. For example, you can set the upper limit for the first class to an even 2,500 versus the 2,508.62.

2020-08-10_172443.jpg

Now that you have the styling set, you will clear your layer filter. Click on the filter icon in the Layers Panel to open the Query Builder. Click Clear and OK.

Working with the Temporal Controller

Now you can work with the Temporal Controller.

  • Open Layer Properties for the counties layer and choose the Temporal tab.

  • Set the Configuration to Single Field with Date/Time and point it to the date column.

  • Set the Event duration to 1 week.

  • Close Layer Properties.

2020-08-11_081417.jpg

The layer will likely take awhile to render so you may want to turn it off now that you have it set up.

Decorations

Next you will work on some Decorations to add to the animation. These will allow you to add a title, legend and data source to the map canvas.

From the View menu find Decorations and choose Title Label. Click Enable Title Label and enter COVID-19 Cases per 1M by Date (NYT). Choose a font and a background color and click OK.

To add the legend to the map canvas, you will set one up in the Print Composer. Start a new Print Composition and add just a Legend. Configure it how you’d like and take a screenshot or reduce the size of the composition to fit to the legend and export it as an image.

Back at the main QGIS window revisit View —> Decorations and choose Image. Click Enable Image and load your legend. Use the Size and Horizontal/Vertical settings to place it in a good spot.

You can use the View —> Decorations—> Copyright Label to put the url to the New York Times GitHub repository on the map.

2020-08-11_082832.jpg

Labeling Time

Finally you will create a point layer to place the current day on the map. Click on the Layer menu and choose Create Layer —> New Geopackage Layer. Be sure to make it a point layer.

2020-08-11_083127.jpg

Put the layer into edit mode and create a point where you’d like the date to appear. Save your edits. Open Layer Properties and select the Temporal tab. Enable Temporal and set the Configuration to Redraw Layer Only. This tells QGIS to redraw this layer each frame.

Now you will symbolize and label this layer. For symbology change the renderer from Single symbol to No symbols. You don’t need to see the point. You will be using this layer to simply label time.

In the Layer Styling Panel switch to the Labels tab. Set labels to Single Labels. Click the Expression button to the right of Value. There are a series of variables tied to the Temporal Controller. Expand the Variables section and double-click on the @map_start_time variable to add it to your expression. This variable represents the start of the map’s time range. As you step through time on the map, this variable will update to represent the current start date for the map. You can use the format_date() function to put this time into your preferred format. If you highlight the format_date() function you will see some help in the right side of the expression window. Reference the example below. Also note that QGIS provides a preview of what your expression returns. Look in the lower left corner of the expression window. You can check this to ensure the expression is formatting the date as you wish. When finished click OK.

2020-08-11_084008.jpg

Lastly, choose a font for your time label.

Activating Time

Now you are ready to activate the Temporal Controller panel. Click on the Temporal Controller button on the Map Navigation toolbar, or use View—> Panels to activate it. Once visible, click the Animated Temporal Navigation button (right-most with green arrow) in the Temporal Controller panel.

2020-08-11_084703.jpg

Exporting Still Images

Set the Step to 1 days. You can now use the Temporal controls to step through time. However, the data are so large it will probably be awkwardly slow. Notice the Export Animation button to the right of the Step. Click this, and set it up to export out a series of still images, one per day.

2020-08-11_084932.jpg

Creating the Final Animation in GIMP

Once the images have exported you can use the open source image editing software GIMP to create the animation. You can install it from the link.

Open GIMP and choose File —> Open as Layers. This will likely take a couple minutes as it loads all the still images.

2020-08-11_085248.jpg

Once it has finished loading the layers click Filters —> Animation —> Optimize (for GIF). This step too will take a couple minutes. Finally choose File —> Export As and export as a GIF. Set the File type as GIF and choose a folder for the export. Click Export and in the Export Image as GIF window be sure to check the As animation box. You can also choose the Loop forever option.

2020-08-11_090309.jpg

You will end up with something similar to the animation shown below! This same workflow can be used to create similar animations for deaths or for other countries.

DailyCOVID.gif

Vector Borne Disease Surveillance Workshop for State Based Health Officials

The Second Vector Borne Disease Surveillance Workshop

IMG_-k478cs

On June 18 & 19, 2019, eight state based health officials took the second Vector Borne Disease Surveillance workshop in Providence, Rhode Island. This was the second of two 2-day workshops aimed specifically at tackling the spread of diseases like Dengue fever, West Nile and Zika viruses. As with the first one, this was a Community Health Maps training specifically designed to demonstrate how to collect and work with geographic data related to vector borne diseases, i.e. those that are transmitted to humans via other animals such as mosquitoes. Attendees represented health departments in: Colorado, Georgia, Kansas, Louisiana, Mississippi, New Mexico, Virginia and Guam.Again this workshop was a team effort. The training was organized by the Association of State and Territorial Health Officials (ASTHO). Participants attendance was funded by CDC’s National Center for Emerging and Zoonotic Infectious Diseases. Travel for the trainers was funded by the National Library of Medicine, (funding for the workshop is provided under a sub-award from the National Library of Medicine to ICF International). This particular CHM workshop was taught in conjunction with ASTHO’s State Environmental Health Directors (SEHD) Peer Network Annual Meeting.After an introduction to the Community Health Maps project - it's origins, workflow and examples of past projects - participants learned to create a data collection form and use their smartphones to map features (trees, signs, benches etc...) around the conference site using Fulcrum.For the remainder of the first day, the group took the data they collected earlier and imported into QGIS. In this section they became familiar with QGIS and how to symbolize layers and make a print map.IMG_-bb3hhdIn addition to the data collected on site, we worked with mosquito data acquired courtesy of Dr. Chris Barker  covering Madera County, CA. The data included mosquito trap results over five years, virus testing, mosquito biting complaints, storm drains, parcel boundaries, roads and a hypothetical case of Dengue fever.The second day focused on generating vector borne disease surveillance products. The participants:A) generated trend graphs of mosquito populations through time via the QGIS Data Plotly plugin,unnamed-5.jpgB) generated heatmaps of mosquito populations,heatmapsC) calculated the minimum infection rate per year for West Nile and St. Louis Encephalitis viruses,mirD) identified potential mosquito sources to be inspected (storm drains) using a combination of a buffer operation (done against mosquito complaints with the distance  the species is known to be able to travel) and select by location against storm drains,stormdrainstobeinspected (1)E) identified parcels at risk due to their proximity to a fictional outbreak of Dengue Fever,denguefeverand F) learned to animate temporal data using the QGIS Time Manager plugin. Here the mosquito population (heatmap) is being animated weekly for the year 2018 with mosquito management zones be displayed.HouseCallAnimationHeatMapAll participants received official QGIS certificates for their participation.These workshop materials will part of the suite of https://communityhealthmaps.nlm.nih.gov/resources/ available through the Community Health Maps program in the near future.If you are interested in having this taught for you or your colleagues contact Kurt Menke (kurt@birdseyeviewgis.com)

Pacific islanders Dive Deep into Community Health Maps Workflow

The First Vector Borne Disease Surveillance Workshop

0607191556-e1560536068216.jpgOn June 8 & 9, 2019, twelve pacific island public health professionals met in Honolulu, HI to participate in a Community Health Maps training specifically designed to demonstrate how to collect and work with geographic data related to vector borne diseases, i.e. those that are transmitted to humans via other animals such as mosquitoes. Attendees represented: American Samoa, the Federated States of Micronesia, Guam, the Commonwealth of the Northern Mariana Islands, the Republic of the Marshall Islands and the Republic of Palau.This was the first of two, two-day, workshops aimed specifically at tackling the spread of diseases like Dengue fever, West Nile and Zika viruses. It was a team effort. The training was organized by the Association of State and Territorial Health Officials (ASTHO). Participants attendance was funded by CDC’s National Center for Environmental Health. Travel for the trainers was funded by the National Library of Medicine, (funding for the workshop is provided under a sub-award from the National Library of Medicine to ICF International). This particular CHM workshop was taught in conjunction with ASTHO’s Insular Area Climate and Health Summit.After an introduction to the Community Health Maps project - it's origins, workflow and examples of past projects - participants learned to create a data collection form and use their smartphones to map features (trees, signs, benches etc...) around the IMG_20190610_214340_314_1_previewconference site using FulcrumParticipants saw how this particular part of the workflow could be applied in their home regions to digitally locate areas of standing water and/ or sand pits that are some examples of breeding habitat for mosquitoes. Others anticipated mapping salt water resistant taro, households where infections have occurred and other geographic factors that contribute to the spread of vector borne diseases.For the remainder of the first day the group took the data they created earlier and imported into QGIS, a sophisticated geographic visualization desktop software. In this section they became familiar with QGIS and how to symbolize layers and make a print map.In addition to the data collected on site, we worked with mosquito data acquired courtesy of Dr. Chris Barker  covering Madera County, CA. The data included mosquito trap results over five years, virus testing, mosquito biting complaints, storm drains, parcel boundaries, roads and a hypothetical case of Dengue fever.IMG_1909_1_previewThe second day focused on generating vector borne disease surveillance products. Kurt Menke developed a curriculum to demonstrate how a GIS can create maps and statistical charts that transform simple text and numbers in a database into intuitive graphics that communicate information quickly and accurately. The previous blog post has more detail about the specific vector borne disease surveillance products participants learn to create.20190607_114226(0)_1_previewThe attendees had a wide range of GIS skills from introductory to advanced capabilities. We experienced many of the common technical difficulties when working in a hotel conference room, older and newer computers and variations with different operating systems (Windows and Macs) as well. Despite all the differences, all of the participants: A) collected data with their smartphones, B) exported their data to a desktop GIS, C) used prepared data to create geographically accurate statistics, D) generated heatmaps of mosquito populations, E) calculated the minimum infection rate per year for West Nile and St. Louis Encephalitis viruses, F) identified potential sources using buffer operations with distances specific species are know to be able to travel, G) identified parcels at risk due to their proximity to a fictional outbreak of Dengue Fever and H) generated trend graphs of mosquito populations through time via the QGIS Data Plotly plugin. All participants received official QGIS certificates.The skills required to complete these tasks are not always simple and straight forward. The participants of this workshop expressed great enthusiasm and persistence in figuring it all out... making mistakes and trying again. Many expressed a need for more training and a desire to have more specialized trainings on site specifically related to projects they are already working on.The second workshop in the series will be taught next week in Providence, RI at the GIS Surveillance Workshop. This will be attended by State based health officials.This vector borne disease surveillance version of the Community Health Maps workflow showcases the analysis and data visualization capabilities of QGIS, as well as, the data collection capabilities of Fulcrum. It represents perhaps the greatest potential for applied use of Community Health Maps to date.These workshop materials will part of the suite of https://communityhealthmaps.nlm.nih.gov/resources/ available through the Community Health Maps program in the near future.If you are interested in having this taught for you or your colleagues contact Kurt Menke (kurt@birdseyeviewgis.com)

Vector Borne Disease Surveillance with QGIS - A Series of Two Day Workshops

This spring, with funding provided by the Association of State and Territorial Health Officials (ASTHO), Kurt Menke developed a two day workshop that combines elements of the standard Community Health Maps workflow with vector borne disease surveillance analyses.The workshop begins with an introduction to Community Health Maps, and learning how to use Fulcrum to develop a data collection form and collect community GIS data with a smartphone. Participants will then be introduced to QGIS. They will learn how to add the field data just collected, and symbolize it. They will then download some open data and create a map.The second day focuses on a suite of mosquito trap data acquired from Madera County, CA, by Dr. Chris Barker at UC Davis. There are 5 years of mosquito trap data and mosquito virus testing data. There are also anonymized data for mosquito biting complaints, mosquito management zones, storm drain locations, parcels and roads.Collectively this provides a rich yet manageable dataset. With it participants will learn to use to create information such as:mosquitosPerYearChart.pngculexquinqheatmap2019-05-23_1731322019-05-23_173733This workshop represents applied real-world workflows. These are many of the standard products needed by public health officials and typically produced by researchers. Having this sort of analysis and data visualization available via an open source package means anyone willing to take a few days to learn can produce them! This is especially true as the needed input data can be collected via Fulcrum if they don't already exist.This workshop will be taught twice in June. Both workshops will be part of the Community Health Maps project and are partly funded by the National Library of Medicine (funding for the workshop is provided under a sub-award from the National Library of Medicine to ICF International). The first iteration will be taught in conjunction with the Insular Area Climate and Health Summit in Honolulu, HI. This will be attended by public health officials from many of the Pacific Territories.The second workshop will be taught in Providence, RI at the GIS Surveillance Workshop. This will be attended by State based health officials.This material really showcases the analysis and data visualization capabilities of QGIS.  It represents perhaps the greatest potential for applied use of Community Health Maps to date. This workshop will part of the suite of Resources available through the Community Health Maps program in the near future.If you are interested in having this taught for you or your colleagues contact Kurt Menke (kurt@birdseyeviewgis.com). 

Community Health Maps at Rising Voices 7

Last week Community Health Maps traveled to Boulder, Colorado to teach a pre-conference workshop at Rising Voices 7. The theme was Converging Voices: Building relationships and practices for intercultural science. The conference was hosted by the National Center for Atmospheric Research (NCAR). The workshop was well attended with about two dozen participants representing numerous AI/AN tribes and other organizations. These workshop was part of the Community Health Maps project and was funded by the National Library of Medicine (funding for the workshop was provided under a sub-award from the National Library of Medicine to ICF International).The goal of Rising Voices is to "advance science through collaborations". Participants learn how indigenous and western scientific knowledge systems can compliment one another and advance our understanding of important issues in our communities. The focus is on climate.2019-05-20_164427At three hours the workshop was slightly shorter than normal. This allowed us to focus on field data collection with Fulcrum and web mapping with Carto. With a few minutes to spare Kurt Menke shared QGIS. Since he didn't have time to really demonstrate the use of QGIS he focused on the open source aspect. As an open source project, QGIS is both GIS software and a community. As such it aligns with the ethics many communities try to foster at Rising Voices.2019-05-22_080251 

Discover QGIS 3.x - A Workbook for Classroom or Independent Study

Today Discover QGIS 3.x was published by Locate Press. Authored by Community Health Mapper Kurt Menke, this is an update of the original title, using QGIS v3.6 and covering spatial analysis, data management, and cartography. It is designed to teach mapping and GIS using QGIS. As such it begins with basics. It is a comprehensive up-to-date workbook built for both the classroom and professionals looking to build their skills.It is designed to take advantage of the latest QGIS features, and will guide you in improving your maps and analysis.The book is a complete resource and includes:

  • Lab exercises
  • Challenge exercises
  • All data, discussion questions, and solutions

What's new in this edition:

  • Updated to QGIS 3.6
  • Fifteen new exercises
  • A new section, Advanced Data Visualization, covering:
    • Blending modes
    • Live layer effects
    • Geometry generators
    • Rendering Points
    • Time Manager
    • Native 3D
    • Mesh data
  • Appendices covering:
    • Keyboard shortcuts
    • Useful Plugins
    • Getting involved

To see what's included in the book, download the Table of Contents (PDF). Discover QGIS 3.x is available in color as an ebook or paper back.2nd_ed_draft_covercropped

Mapping Field Photos in QGIS

We are on the eve of another QGIS release. Version 3.6 will be released any day now. This will mark an important milestone in QGIS development. QGIS 3.4 will become the first long-term release for the 3.x line. With 3.6 will come one specific change pertinent to this topic: the Raster Image Marker. Consider this post a small preview of what you can expect with v3.6!In the typical CHM workshop attendees are shown how to use Fulcrum to download data collection points. These include photos. It is also possible to quickly and easily map any geotagged photo from your smartphone using just QGIS. For this example, I am using some photos I took yesterday during a hike with my iPhone.

    1. Using the Processing Toolbox, search for and open the Import Geotagged Photos tool and set it up as shown in below, pointing the tool to the folder containing your photos and naming the output point file.ImportGeoTaggedPhotos
    2. The data are in geographic coordinates (latitude and longitude). It will be helpful to project the photopoints to a Cartesian coordinate system such as UTM or State Plane. To do this right-click on the photopoints layer in the Layers Panel and choose Export --> Save As from the context menu.
    3. In the Save Vector Layer As window save a new copy of the layer. If you need help determining which coordinate system to use feel free to reach out to Kurt Menke (kurt at birdseyeviewgis.com). He is happy to help!SaveVectorLayerAs
    4. Now you have a couple interesting ways to visualize these points. First you can generate something called a Wedge Buffer.  These are pie shaped polygons that you can set up to represent the field-of-view of the photograph.wedgebuffers
    5. Search the Processing Toolbox for the Create Wedge Buffers tool.  The Input Layer will be the reprojected photopoints. The Buffers output can be a shapefile in your photos folder. The real trick is using what is known as a Data Defined Override. In QGIS you can use values in attribute columns or expressions for tool inputs instead of putting in a single typed value. In the animation below, a Data Defined Override is being used for the Azimuth parameter. This determines which way the wedge will be pointed. The Import Geotagged Photos tool extracts more than just photo location. It also extracts direction, altitude etc. Here the Azimuth parameter is simply being pointed to the direction attribute column and this orients the wedge in the direction the photo was taken! The only other parameter to set is the Outer Radius. This determines how long the wedge will be. Here it is being set to 300 meters.wedgebuffers
    6. Now there are both photo locations as points, and wedge buffers showing the field-of-view! wedgebufferscreated

 

  1.  Next let's improve the default symbology for the wedge buffers using a Shapeburst fill. You will open the Layer Styling Panel (F7) and set the wedge buffers as the target layer. Next select the Simple Fill component and switch the Symbol layer type from Simple fill to Shapeburst fill. You can then set the two colors to use. Here I am using red and transparent. You can then set a distance for the effect and play with other settings like Blur strength. shapeburst
  2. Finally you will learn a feature that will be released with QGIS 3.6: Raster Image Markers. Here the target layer is the photopoints layer. The Symbol layer type is being switched from Simple fill to Raster image marker. Then the Data Defined Override for the image is being set to the photo field, and the Rotation parameter is being set to the rotation field!rasterimagemarker
  3. Now the photos have been mapped. Their field-of-view is being represented by a wedge buffer, and the photo itself is added to the map with a Raster image marker!photosmapped

Stay tuned for more tips on mapping and updates about this latest QGIS release.

A Pair of Community Health Maps Workshops at the ASTHO Climate and Health Summit

During the last week of May the Community Health Maps team (Janice Kelly, John Scott and Kurt Menke) traveled to Honolulu to participate in the Association of State and Territorial Health Officials (ASTHO) Insular Area Climate and Health Summit. There were representatives from:

  • American Samoa
  • Commonwealth of the Northern Mariana Islands
  • Federated States of Micronesia
  • Guam
  • Palau
  • Puerto Rico
  • Marshall Islands
  • U.S. Virgin Islands
  • Hawaii Department of Health
  • Pacific Island Health Officers Association (PIHOA)
  • ASTHO
  • CDC
  • NOAA
7516756736_IMG_4910The first afternoon was focused on the impacts of climate change, preparedness and building resilience. There were great presentations on climate change (Capt. Barry Choy - NOAA), an overview of the tools and programs available from the CDC (Paul Schramm), and issues with vector-borne diseases and mosquitoes (Janet McAllister).  The ASTHO grantees then gave some some sobering presentations on current issues people are dealing with in the Mariana Islands, Micronesia and the U.S. Virgin Islands.img-7852.jpgThe second day focused more on tools and resources. There were more detailed talks given by the CDC on Technical Assistance for Vector Control and Tools and Resources for Climate and Water Safety. That afternoon we taught a 3.5 hour Community Health Maps Train-the-Trainers workshop to a group of health officials from each territory.  We went through the entire CHM workflow: A) how to design a data collection form, B) how to collect data, C) how to make a map in Carto and D) how to bring the data into QGIS.
The last morning we taught a second Community Health Maps workshop open to everyone. We had about 30 attendees and again went through the entire CHM workflow.img-7880.jpgMost of the trainees had little to no GIS training yet instantly knew how mapping could apply to their work and lives. They want to map everything related to hurricane relief, salt water resistant taro farms, infrastructure related to mosquito outbreaks etc. A benefit of having the community do this is that they can be in charge of their own data and it helps build community relationships.Over the three days I heard a lot of side discussions about the usefulness of the free/low cost/open source CHM approach. The cost of proprietary solutions is often a significant barrier to entry into the world of community data collection and mapping. We were gratified to hear some very positive feedback on the workshops and CHM overall during the closing session. There seems to be a lot of potential in CHM helping both U.S. Territories and ASTHO deal with the immediate and long-term health issues related to climate.

Mapping South Florida's King Tides

By John C. Scott - Center for Public Service Communications

Community Health Maps (CHM) recently joined forces with community based organizations and residents in North Miami, and Florida International University faculty to map health risks associated with the 2017 King Tides, September 19th and 20th and again on October 7th , the time of the highest of the inundations.

Several communities in Miami experienced predictable tidal flooding during the highest tides of the year. The Shorecrest community is among them. Sampling of the flood waters during previous King Tides has established that they contain elevated concentrations of bacteria. The aim of this project was to prepare residents of the community to record and map data that will help them plan their daily activities to protect their health, and give them tools to communicate with the city and county about their environmental health risks.

King Tides flood the streets of the Shorecrest neighborhood while community members collect data.

King Tides flood the streets of the Shorecrest neighborhood while community members collect data.

Complicating the task of collecting data in the community was Hurricane Irma which hit South Florida only a week before the September measurements, causing dislocation of residents, power outages and other disruptions that resulted in the decision not to tax neighborhood residents by expecting them to learn the CHM workflow and map hazards in the community.

For the CHM/King Tides mapping project, community members were trained on the CHM workflow before collecting and mapping environmental health data during the King Tides in the Shorecrest community of Miami. A physical tool box containing needed technology, sampling equipment, key contact information, and protocols for community engagement in data collection during King Tides was created by Jan Booher of Unitarian Universalist Justice Florida and Drs. Tiffany Troxler and Susan Jacobson of Florida International University Wetland Ecosystems Research Lab and School of Communications, respectively. Based on the initial data collection and mapping effort with the Fall 2017 tides, a community report will be generated in collaboration with community leaders to be shared with residents and decision-makers in the community and with appropriate members of City of Miami and Miami-Dade County staffs.

For those of you who are new to Community Health Maps, the initiative was founded on the premise that community-based organizations, environmental health advocacy groups, public health agencies are in a better position to serve their constituents when they can collect and maintain their own data, rather than relying solely on national, state or city agencies, or majority-institution partners to provide data to them.

The CHM approach involves using relatively low cost tablets and smartphone platforms, combined with a selection of low/no-cost applications that run on them, to collect data in order to better understand health status or health risks to the community and support decision-making leading to appropriate allocation of resources to improve health conditions and prevent or mitigate risk. Using the CHM workflow, those data can then be analyzed, shared and presented using low cost/open source software. These tools allow expert and novice users, with little budget resource, to implement mapping workflows.

A common way in which prospective users have learned the CHM workflow is through our CHM Training Workshops. The CHM workshop presents an opportunity to learn and discuss new ideas and methodologies, which will empower community organizations, teachers, and students serving vulnerable or underserved populations with low cost, intuitive mapping technology. During the workshops, we also share experiences where the CHM workflow has helped MPH programs and other academic health centers and community-focused organizations visualize their data and better understand and portray their significance to the community.

The Florida King Tides was a more ambitious project than usual for CHM. While most of the work of the CHM team consists of training and building capacity of communities to map and better-understand their health risk to environmental factors, this was our first opportunity to work in the field with users of the workflow. Together with the core CHM team of NLM, Center for Public Service Communications and Bird’s Eye View, CHM teamed with Unitarian Universalist Justice Florida (UUJF) and it’s The Rising Together project, which works residents in vulnerable communities in coastal Florida about how to prepare for and react to the public health effects of climate change. Through its association with UUJF, the Community Health Maps team also trained and worked with Quaker Earthcare Witness, New Florida Majority, and Florida International University’s Wetland Ecosystems Research Lab and School of Communication and Journalism.

Map made in QGIS of the September King tide data collection showing flood water salinity levels.

Map made in QGIS of the September King tide data collection showing flood water salinity levels.

It is our vision that data collected by neighborhood residents about conditions affecting environmental health can be visualized via CHM, together with databases available from city, county, state and federal governments to, as one example, identify potential predictable impact of future king tides so that public transportation and school walking routes can be modified to avoid health risks.

Map showing water depth in comparison to elevation above sea level

Map showing water depth in comparison to elevation above sea level

While collecting data for risk maps a Miami Herald reporter stopped by the Shorecrest neighborhood where we were working. Here's his story about our initiative.

A Busy Summer with a QGIS Conference in Denmark and FOSS4G in Boston

This summer Kurt Menke first attended the 3rd Annual QGIS User Conference, Hackfest and Developer meeting in Denmark. From there he traveled to Boston to attend the Free and Open Source for Geospatial (FOSS4G) International Conference. TriptoNodeboThe QGIS conference was small and intimate and a lot of new information was shared by the developers about the future of QGIS.1k0a4924There was so much presented that this will be a separate future blog post. While there Kurt conducted a full day workshop on Data Visualization and Cartography in QGIS.DG3tVwdXUAAnHgyHe shared many of the new sophisticated and powerful data styling tools now found in QGIS including: 2.5D, 3D, Live Layer Effects, Inverted Polygon Shapeburst Fills, Blending Modes, and some plugins such as Time Manager. Perhaps this could be a workshop shared with CHM partners at a future date? Some examples are shown below:FeatureBlendingDKManhattan3DCyclonesIn Boston Kurt presented the Community Health Maps project. The talk was well attended and there was a lot of interest. Fulcrum was a sponsor of the conference, and Kurt was able to meet with several of the Fulcrum representatives. While there he learned about Fulcrum Community. This is a new initiative designed to help humanitarian agencies, non-profits, NGOs, or Government entities. To begin you need to request a Fulcrum Community account. One important caveat is that data collected via a Fulcrum Community account is anonymized, free, and open to all by default. It is essentially an initiative that will help in larger crowd sourcing efforts. More details will be forthcoming as Kurt explores this and how it may apply to Community Health Mappers.This month (September), Community Health Maps will be travelling to the University of Connecticut (Community Medicine and Health Care) and to Miami to teach workshops. The workshop at the University of Connecticut will be to a large diverse audience. The Miami workshops will be focused on showing community members how to map damage and issues related to King Tides.Stay tuned for blog posts on: 1) the future of QGIS, 2) Fulcrum Community, 3) experiences in Connecticut and 4) Miami.