In May Kurt Menke presented the Community Health Maps project, and conducted a training at the Medical University of South Carolina College of Nursing. The presentation was recorded and is now available online. The presentation was about 45 minutes and includes the powerpoint slides, audio and visual. This is a great way for you to learn more about the project from the comfort of your own office!
By Guest Blogger: Derek Toth – Communities in Schools Charleston
The Teen Health Leadership Program (THLP) is in their eight year of existence at St. John’s High School on Johns Island. The program gathers leaders of the school together and focuses on a health topic they feel is affecting their community and assists the community in understanding this topic through the use of media dissemination. In the past, topics included Autism, Cancer, Stress, Obesity and Alcohol and Drugs and This year, the students wanted to look at their community as a whole with a topic of Environmental Health.
The THLP students wanted to see what makes their Sea Island community different. The Sea Islands are composed of John’s Island, Wadmalaw Island, Seabrook Island and Kiawah Island outside of Charleston, South Carolina. Students primarily come from John’s and Wadmalaw Islands. These islands are extremely different for many reasons. The students wanted to be able to translate these differences in a new form for the Teen Health Leadership Program. The students were presented with an opportunity to use the Community Health Mapping tools discussed on this blog, and some training made available from the National Library of Medicine. With GIS, the students can pin point differences within the islands for their community to see.
(This January Kurt Menke conducted a Community Health Map training at the Medical University of South Carolina College of Nursing. Two teachers with Communities in Schools Charleston attended and the next afternoon Kurt Menke went to St. John’s High School and showed the students how to map their campus with their iPhones.)
The students used smart phones, along with an app named iForm, to map points of interest with GPS. They collected well water locations, ground and city water sources, as well as, places in the community to purchase food. The food resources they mapped included farmers markets, produce stands, grocery stores and local farms. The students were able to indicate these points on a map. Google maps was used to create the final map.
With the final map they were able to determine that people on Wadmalaw Island have less access to food and water than those on St. John’s Island. For example, Wadmalaw Island is limited in places to buy produce or groceries, and has limited access to the farms that John’s Island has. Residents of Wadmalaw Island are on well water, and obtain their produce at the local grocery store on Johns Island, as opposed to driving to one of the many local farms.
The final map was inserted into the Environmental Health project for the community to have a unique perspective of their Sea Island Community. Overall, the students felt that using their smart phones to map their community was easy to learn and fun. They were able to grasp the information quickly and seemed pleased with their results. The group feels it reached it’s goal of accomplishing a fresh look at the Sea Islands and felt it added to their presentation on Environmental Health.
CartoDB is an online cloud based platform for storing and visualizing spatial data. It is the perfect tool for the third part of the workflow (outlined in the Introduction). You can sign up for a free account, which gives you 50Mb of storage space. Data can be collected with a smart phone or tablet with iForm, and brought directly into CartoDB. It is a very intuitive platform. You can literally drag and drop a spreadsheet onto the CartoDB page and have the data upload to your account. It will accept the most common geospatial file formats including: spreadsheets and comma delimited text files with addresses or coordinates, KML/KMZ, GPX, and shapefiles. Below is an example of a spreadsheet of Baltimore Dialysis Centers in CartoDB. This shows the spreadsheet in Data View .
After telling CartoDB which columns contain the latitude and longitude values, the data can be viewed in Map View (below). Here the default Positron basemap is being used. There are a variety of basemaps to choose from including imagery, Stamen maps and Nokia maps.
Once multiple data layers have been uploaded you can create a visualization. Below is a map focusing on Balitmore Diabetes. It includes Baltimore neighborhoods classified by the number of diabetics, food deserts and dialysis centers. CartoDB provides wizards and other tools for styling your data. The dynamic map can be accessed here: http://cdb.io/1G4xP7j
Visualizations can be shared via hyperlinks and embedded into webpages. CartoDB also has great documentation including:
- CartoDB Editor Documentation
- A comprehensive series of tutorials breaking tasks up into Basic, Medium and Advanced categories
- Tips and Tricks
Sign up for a free account and take it for a spin. On a related note Community Health Maps is almost done with a complete curriculum for community health mapping. It consists of six labs. The final lab shows you how to work with CartoDB from setting up an account to sharing a visualization. Stay tuned!
If you’ve followed this blog, you know that the goal of the Community Health Maps initiative is to help community organizations identify and apply low-cost and easy-to-use online mapping tools (GIS). If you are a first time visitor to this site we encourage you to peruse the blog entries.
The purpose of these tools is to improve understanding and visualization of health conditions in the community so that attention might be best directed to reduce health disparities. This site is a collaborative effort between the National Library of Medicine, the Center for Public Service Communications, and Bird’s Eye View.
To help advance this mission we have developed a survey. The goal of this survey is to assess community health organizations’ satisfaction with GIS / mapping resources currently available to them. The information will be used to improve NLM’s Community Health Maps site and tailor it to specific user requirements.
You are encouraged to click the link below and take this brief survey.
Today the next stable version of QGIS was released. It is being called QGIS version 2.8 ‘Wien‘. Wien is German for ‘Vienna‘ which was the host city for the QGIS developer meetings in 2009 and 2014.
Recently a new version of QGIS has been released every four months. This rapid pace of development has its pros and cons. On the plus side, the software is rapidly growing and improving. On the con side it has made it difficult to maintain documentation. It has also been an issue for people working on large projects. They have had to deal with the software changing every four months.
QGIS 2.8 is a special release because it is the first in a series of long-term releases (LTR’s). The idea is that one release per year will be an LTR. This means that the LTR release will be supported and available for download for one year. This way people needing stability can use this until the next LTR is released a year from now.
Some of the highlights are:
- Numerous bug fixes and stability improvements
- QGIS Browser is more responsive
- Ability to select the units in the Measure tool
- Improvements to editing: better control of snapping and a new suite of Advanced Digitizing tools
- Improvements to the Map Composer such as better control over coordinate graticules and map rotation.
- Symbology improvements such as filling polygons with raster images, ability to have multiple styles per layer.
The detailed list of new features can be found here: http://www2.qgis.org/en/site/forusers/visualchangelog28/index.html
Visit the download page and take the new version for a spin. Remember you can install it on Windows, Mac and Linux!
Unfortunately the most recent iOS system update rendered the EPI Collect app unusable. Apparently it is no longer being supported on the Apple platform. With this discovery, and a training in Charleston just around the corner, we set out to find a replacement. We searched for another free app for iPads and iPhones that allows you to develop your own data collection form. Fortunately we discovered iForm which turns out to be even easier to use, and more robust. (NOTE: It is also available for Android devices.)
This app has a lot of similarities with ODK Collect which we recommend for Android users (ODK Collect is described in the Field Data Collection blog post). With iForm you create a free account on the companion iFormBuilder website. You use their online form builder to create your data collection form. The form builder has over 30 different types of data inputs to choose from! For example: text, number, date, time, pick list, phone number, location (GPS coordinates) and images (photographs). Individual data elements can be set up as questions for the data collectors such as: What is the name of the site?
Once the form is developed you can begin to collect data.
- Open the app on your mobile device and login.
- Tap the Sync button and all the forms and records that are associated with your account will be downloaded to the device.
- Head out to your project site and collect data.
- At the first data collection site simply open the data collection form, answer each question, and click Done to save the information.
- Repeat at each site.
If you are collecting data while in cellular coverage, the data will be synced to your iFormBuilder cloud account as you go. If you leave cellular coverage that is OK. The on-board GPS receiver on your mobile device will still allow you to collect your locations. Once you are back within cellular range you can Sync your data to your iFormBuilder cloud account. The data can be viewed on the mobile device in tabular or map format. Back in the office the data can be downloaded from the iFormBuilder site in several formats, the most useful of being an Excel spreadsheet. The data in the spreadsheet can then be brought in QGIS or CartoDB and mapped.
iForm has some additional features that stream line data collection. You can link your iFormBuilder account to a DropBox or Box account. With this link established your data and photos will be uploaded to a DropBox folder automatically. There are also tools for assigning a form to different users. This allows you to develop one data collection form and share that among a team of data collectors.
The free iFormBuilder account has some limits. You are limited to 10 forms and 100 records per form. However, you can log in to your account, export the data, and delete those online records and continue data collection.
In summary, iForm is a powerful and intuitive free app for collecting community health data with iPhones, iPad, and Android devices.
Recently Kurt Menke headed to Charleston, South Carolina to train several groups how to map their communities. This region is also known as the ‘lowcountry’ due to the flat, low elevation geography. The training was hosted by the Medical University of South Carolina (MUSC) and included people from Communities in Schools – Charleston (CISC) and the MUSC College of Nursing.
First everyone learned how collect GPS field data with iPads. For this we used a new app named iForm. This app was used in lieu of EPI Collect, which no longer supported on iOS. (The next blog post will cover iForm in more detail.) iForm is an app very similar to the Android app ODK Collect, allowing a custom data collection form to be developed. To practice we collected bike rack locations and seating areas around the MUSC campus. The afternoon was spent working with everyone’s data. GPS data points were brought into QGIS and shown against some local Charleston GIS data layers.
The points were also uploaded to CartoDB. CartoDB is another new component of the Community Health Mapping workflow. It has become more intuitive than GIS Cloud and worked really well. (Note: There will be a post on using CartoDB soon too.)
The following day I visited CISC’s Derek Toth and three of his students at St. John’s High School on John’s Island, SC. Over a working lunch Mr. Toth showed students how easy it is to collect GPS points with their iPhones. We collecting several points while walking around the campus.
Afterwards we went back inside and showed them how to upload the points into CartoDB and make a map. The figure below shows the results of 45 minutes worth of work! Click on the map to open the live version.
This spring these three juniors will be leading the charge to map their island! They will be presenting their work to the National Library of Medicine later this spring. I look forward to seeing their work!