Data collection

Community Health Maps Webinar Series

In August 2020 Community Health Maps is partnering with the University of Michigan Libraries to present a short webinar series. These will be live presentations followed by a Q & A session. They will also be recorded and available afterwards via YouTube.

Mapping COVID-19 with QGIS

August 14, 2020

This one hour webinar teaches how to map the COVID-19 pandemic using free data and open source software. The presentation begins with an introduction to Community Health Maps, a program to empower underserved populations with free mapping tools. Community Health Maps case studies will demonstrate the successful use of these tools. The remainder focuses on downloading and mapping COVID-19 data using QGIS, the world’s leading open source desktop GIS software. By the end of the webinar you will know how to download data, import the data into QGIS, symbolize it, and make a map of COVID-19 cases per one million people by county. This webinar will be recorded and made available via YouTube.

REGISTER HERE

Layout 1.jpg

Collecting Field Data Using Free and Open Source Software:
Input and QGIS

August 21, 2020

There are two new options for field data collection related to QGIS named Input/Mergin and QField, and both will be introduced in this webinar. Each app runs on both iOS and Android. Since they are free to use, offer great functionality, and can be used on any platform, they are the recommended field data collection apps for Community Health Mappers. Due to time constraints, this webinar will focus on Input. You will see how to set up a typical data collection form using QGIS. You will also learn to use the Mergin plugin to move data back and forth between a computer and a mobile device. Sample data will be collected and Mergin will again be used to bring the data into QGIS where we’ll map it. This webinar will be recorded and made available via YouTube.

REGISTER HERE

Editing Points in Fulcrum

I am often asked if and how points can be edited in Fulcrum. Yes, you can edit points in Fulcrum! This short post will show you how. Fulcrum is not only a way to collect community data, it's also a platform for showing that data on a map and a database you can edit. For this example, I will use the App I designed for the recent ASTHO workshop in Hawaii. We collected points around the conference facility at the Ala Moana Hotel. If a point isn't located correctly I can go in and edit the location in Fulcrum.To demonstrate this I have opened my ASTHO app. To see the data I will click on the records icon to open the data in map view. From here I simply click on a point I want to edit. The data form for that point opens. To put the data into Edit mode I click the pencil icon2018-08-16_120747. To change the location I click the Edit Location button. Then I click on the map at the location where the point should be moved. To save my edits I click the green Accept edits button 2018-08-16_120800.FulcrumEditPointLocationI can also edit the attributes of a point. It is a similar process. First I click on the point I need to edit. Then I click the pencil icon. I scroll down to find the attribute I need to edit and make the change. Once done click the green check mark button to accept the changes.FulcrumEditAttributesI can also add new points from this interface in Fulcrum. To do this I simply click the green Add point button 2018-08-16_121106 and populate the attributes. If I have elements where were set to required in my App, I will have to populate them here, just as I did with my mobile device in the field.So if you have collected some data and realize it needs some correction you can do that directly in Fulcrum prior to downloading it. Also note that the data can also be edited in QGIS and Carto. I'll cover those procedures in future posts.Happy mapping!

Fulcrum Community

Last year Fulcrum rolled out a new service named Community. They describe it as a, "no cost, short term crowdsourced data collection solution for qualified humanitarian projects." It works like Fulcrum, but you need to apply for a license. The application form is short and is right on the Community home page. In the application you need to describe your purpose and how long you will be collecting data. You also need to provide a project description. If approved you can invite any number of data collectors via email to share  your App (data collection form).  It is generally aimed at humanitarian agencies, non-profits, or government agencies. They restrict commercial use of this service.2018-03-01_153006We used this last fall during King Tide data collection in Miami and it was a big success. In fact there are four main categories highlighted on the Fulcrum Community page: Hurricane, Tornado, Flood and Fire. If you click on Flood, the King Tide project is the first in the list. Clicking on it brings up a map with the data collected.2018-03-01_152857One caveat is that the data collected falls into the public domain and can be downloaded freely by anyone. This is possible because the data are anonymized, meaning any private information is scrubbed. The data remain available for viewing and download after the event ends.2018-03-01_153348It won't be appropriate unless there is some sort of disaster relief or environmental issue that demands it, but it is another tool to keep in your Community Health Maps toolkit!

Mapping Curb Ramp Accessibility around a Silver Spring, MD Assisted Living Facility

Submitted by Jenny Rewolinski, University of Maryland, B.S. Community Health 2016I just completed a spring internship with the National Library of Medicine (NLM). My goal was to demonstrate what a typical user of the Community Health Maps (CHM) blog might experience, while using the low cost resources it reviews to develop a mapping project with a public health focus. I read through the case studies on the CHM blog and used its labs to develop my project plan and to guide my related decisions.Because of my experience with elderly relatives and my background in public health, I centered my project on how the senior population of a nearby Assisted Living Facility might safely navigate local sidewalks. According to the 2014 American Community Survey, 23% of people over 65 have some sort ambulatory disability. With this in mind, I decided to map local curb ramps --sloped transitions between sidewalks and streets which function as accessibility enhancements to help those with mobility issues to cross streets safely.JennyDataCollectionI used CHM Lab 1: Field Data Collection to learn how to design my own data collection form using iForm. My Curb Ramp form captured curb ramp location, conditions, and other observations such as seniors using the curb ramps, steep or damaged curb ramps, and a lack of sidewalks in the area. As discussed in a prior blog post, How Accurate is the GPS on my Smart Phone?, phone geolocation is usually accurate up to 8 meters. This was not precise enough for my curb ramp data, so I corrected for this on my form.  Over the course of 8 hours spanning 2 days, and with 2 other interns I collected 103 existing curb ramps and locations where curb ramps might aid accessibility.iFormCurbRampFormNext, I brought my iForm curb ramp data from my phone into the QGIS software by using instructions from CHM Lab 2: Bringing Field Data into QGIS.  I also used CHM Labs 3: Combining Field Data with Other Organizational Data and CHM Lab 4: Basic Spatial Analysis  to add data layers and to perform spatial analysis to finalize my map.MapThis is my project map! I completed construction of my map using CHM Lab 5: Cartography with QGIS. In addition to my curb ramp data points, I added data layers for sidewalks, roads, places of interest (such as grocery stores, restaurants, bus stops,  theaters), and my Assisted Living Facility. My goal was to raise awareness of how accessibility can impact seniors’ sense of autonomy and empowerment, and their ability to exercise and to lead a healthier lifestyle. This map also provides recommendations for where more curb ramps should be placed based on observations during data collection. I plan to discuss this map and curb ramp recommendations with the city of Silver Spring and to create “safest route” guides for popular local destinations.SafestRouteGIS has a huge potential to help us analyze health issues. When I began my project at NLM, I thought I would simply be mapping the location of curb ramps near a local Assisted Living Facility; however I discovered the significant need for more curb ramps as well as sidewalks around my project area.I believe the conclusions I was able to reach by using the low cost CHM resources CHM are accurate and workable. I came to NLM with little to no GIS knowledge yet I learned from the CHM GIS labs, collected curb ramp data points and created a map that may bring awareness to a public health issue. In doing so I believe my experience is typical of many CHM users.

If I can do it, you can too!

Fulcrum Updates The App Designer

We introduced Fulcrum in a recent post and are very impressed with this tool. Recently Fulcrum updated their App Designer. Fields are now divided into categories from the most common and basic fields, to the most advanced.  The groups of fields have also been color coded from green to red to make this arrangement more intuitive. The five categories are: Basic, Choice, Design, Media and Advanced. At the top are Basic fields which include Text, Numbers, Date etc. This reorganization makes finding fields and developing a form even faster.FulcrumAppDesignerOne category of interest is Design. These are fields that can be used to organize your data collection form. Sections allow you to divide your form into parts. For example, you could separate your main survey questions from your data collector metadata questions. The example App below has two sections: Main section and Data Collection Information.SectionsFulcrumOrganizing your questions like this can help data collectors complete the form, especially for form with a lot of questions. The screenshot below shows how the above form is rendered on a smartphone.IMG_9524In future posts we will give some helpful hints to working with Fulcrum including sharing forms, managing data and downloading data. Stay tuned!

Community Health Mapping: A New Year Review

To start the New Year I thought I’d begin with a review of Community Health Mapping (CHM). There are a lot of new project partners, and I thought it would be a good time to give a project overview. CHM is a collaborative effort between the National Library of MedicineCenter for Public Service Communications and Bird’s Eye View. The National Library of Medicine is funding the initiative.The overall goal is to empower community organizations serving vulnerable or underserved populations with low cost, intuitive mapping technology. Therefore we’ve been working with programs organizations who:

  • Focus on vulnerable populations
  • Frequently use and collect data
  • Need effective, scalable & easy to use mapping tools
  • Lack resources (i.e., for proprietary GIS training & software)

We have identified a suite of tools that allow you to collect custom field data, analyze that data, combine it with other spatial datasets, and generate both static maps and/or dynamic maps on the internet. This allows organizations to collect and work with their own data, and if appropriate, share it with others. CHM involves three components that meet all basic mapping needs:

  • Field Data Collection
  • Desktop Analysis and Cartography
  • Internet Mapping

Community Health Mapping WorkflowA given project may not require all three, however, collectively these components address the basic needs of all mapping projects.Field Data Collection:Rather than focusing on the use of expensive GPS receivers, we recommend the use of smart phones and tablets for these reasons:

  • Most community-based organizations already have them!
  • Many know how to use them
  • They're intuitive
  • They're portable
  • They come with an on board GPS receiver (iPhone 5 uses GPS + GLONASS)
  • Have on board cameras
  • Can connect to wireless networks
  • Access to the internet
  • Email is available
  • “There's an app for that!”

SmartPhones and Tablets vs. Traditional GPS ReceiversOf course an important consideration is horizontal accuracy. You can read our blog post on that topic to see if mobile smart devices meet your project needs.When collecting data you need to be able to develop your own custom data collection form. The top three mobile apps we have found are:

Desktop Analysis and Cartography:After community field data collection, the next step typically involves bringing the data into a desktop GIS. This is the middle step in the workflow. Here the data can be viewed against basemaps such as Google or OpenStreetMap, and combined with other organizational data. This is also where analyses (proximity, density etc.) can be conducted. Presentation quality maps can also be generated in this step.The software we found to be the best fit is QGIS. This is an open source desktop GIS software. It has many strengths:

  • It can consume many kinds of data, including all the data that would come out of the field data collection apps.
  • It is both intuitive and robust.
  • It has a large suite of geoprocessing tools for analyzing data.
  • It will run on Windows, Mac, or Linux.
  • It is free to download and install.
  • It is well documented.
  • There is a large user community.
  • New functionality is being continuously added. New stable versions are being released every 4 months!

Baltimore Diabetes Data in QGIS DesktopWeb PresentationOften you may want to present an interactive map of your results. Interactive means the map reader can zoom in/out, pan the map and turn layers off and on. For this we recommend CartoDB.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 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.CartoDB also has great documentation including:

Baltimore Diabetes Data in CartoDBIn ConclusionThis blog has a lot of resources including reviews of mapping technology and case studies. You might begin by clicking on some of the links in this entry. We are also working on a 6 lab CHM curriculum that interested parties will be able to use to hone their skills. Stay tuned for that!We are always looking for new partners and continuously work to support current project partners. If you are interested, or have questions please don't hesitate to contact John Scott (jscott at cpsc.com) or Kurt Menke (kurt at birdseyeviewgis.com). Most importantly get out and do some mapping in 2016!   

Field Data Collection with Fulcrum

Fulcrum was reviewed in our initial survey of field data collection apps in 2012, and almost made the top three. In the last 3 years Fulcrum has improved and has become perhaps the most intuitive and useful data collection app we've evaluated period.It is available for both iOS and Android. It isn't free, but the subscription fee is affordable. It costs anywhere from $18 - $25 per month. The three pricing plans give you 10 - 30Gb of online storage, which is substantial. Fulcrum offers a free 30 day trial which includes all the functionality. You can use this option to test Fulcrum for your projects. In the following example, I will be using a health care facility data collection form to show how Fulcrum works.Fulcrum has the most intuitive data collection form builder of any app we've seen. When you design a form Fulcrum calls it an 'app'. Simply drag and drop from the Add Fields section to your 'app' to add questions (see figure below). Available data input types include text, numbers, date, single or multiple choice, photos, videos, and audio.  There are no tricks to collecting GPS locations as with iForm. Fulcrum collects locations automatically.A health care facility data collection form in Fulcrum.Once a field has been added simply set you parameters. The figure below shows the facility type question being edited. To do this simply click on a field, and fill out the details. It's so easy a 50 year old can do it!The health care facility type question parameters.The companion mobile app can be downloaded for free from the Apple Store or the Google Play Store. Once installed, login and your data collection app(s) will sync with your mobile device. The figure below shows the health care facilities data collection app on an iPhone. Answering the questions is intuitive. Once collected your data will be synced with your cloud account.Health Care Facilities data collection form on an iPhoneOnce back in the office, login to your account, select your data collection app, and choose Start Export Wizard. You will be taken to the page below. Choose your file format. A complete array of GIS formats is available including: shapefiles, geodatabases, KML, PostGIS and Spatialite.  Choose any other appropriate options and click Next to download your data.Fulcrum Data Export OptionsI highly recommend that everyone involved in Community Health Mapping evaluate Fulcrum. Along with iForm and ODK Collect is a CHM recommended data collection tool. There is a monthly subscription fee but it is low. It is the easiest and most flexible tool we've found. You can use the free 30 day trial period to see if it works for you.

Field Data Collection with iForm

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.)iFormBulder WebsiteThis 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?A form being designed on the iFormBuilder siteOnce 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.

Data collection form while out collecting data on an iPadIf 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.Field data being viewed on a map on an iPadiForm 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.

Community Health Maps Conducts a Training in the South Carolina Lowcountry

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.MUSC Community Health Mapping Training SessionFirst 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.MUSC Data Points in QGISThe 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.IMG_5459Afterwards 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.St Johns High School MapThis 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!St. Johns High School Mapping Team

Noise Pollution and Health in the Urban Environment: A Pilot Project

In October 2013, the Seattle Indian Health Board’s (SIHB’s) Urban Indian Health Institute (UIHI) completed a noise pollution pilot study. The goals of this project were: 1) to evaluate the feasibility of community data collection and analysis via a low cost GPS/GIS workflow, and 2) to offer recommendations on the feasibility and next steps for scalability to the larger Urban Indian Health Organization (UIHO) network. The collected data could additionally illustrate community health needs when merged with health or other contextual data for analysis, but these analyses were not the primary focus of this pilot. We chose to look at noise pollution because it is an environmental health concern that has been linked to a variety of health conditions in both occupational and community studies and it is easy to measure with portable devices.For field data collection, we used an iPad Mini with the GISPro and Decibel 10th apps. For mapping and spatial analysis, we used the open source desktop GIS software QGIS (www.qgis.org). While GISPro is a paid iPad app, the other programs are free. Data collection participants were staff recruited from the SIHB’s administrative, clinical and UIHI departments. We selected participants from this pool because they are representative of the staff at UIHOs who likely have limited experience with data collection and GIS. UIHI project staff trained seven participants in the iPad workflow and data collection process. This workflow consisted of five steps: 1) collect noise data with Decibel 10th, 2) export noise data via email, 3) take a site picture, 4) collect GIS data with GISPro and 5) export that GIS data.Select pictures of data collection sites, taken by study participants using an iPad Mini; Seattle, WAWhen the volunteer participants were finished with data collection, project staff compiled and analyzed the data using QGIS and Stata. Data were merged with socioeconomic indicators from the American Community Survey by zip code. Participating staff were asked for their feedback about their experience and the usability of the tools.Average decibel reading at the 17 data collection sites and per capita income of zip codes, location of the Seattle Indian Health Board indicated by yellow star; Seattle, WA; October 2013That feedback, combined with the experience of project staff, suggested that the GIS software tools were user-friendly and highly effective. Thus, they are likely to be attractive to organizations with limited technology budgets. However, some of the other resources necessary for this project (i.e. the GISPro mapping app, the iPad and general GIS software expertise) are expensive and may be limitations for many UIHOs. In the future, the UIHI would like to use these tools to better understand the health of the community, as well as assist UIHOs in conducting similar projects in their service area.For more information about this project, view the project brief at http://www.uihi.org/wp-content/uploads/2014/08/GIS-Project-Brief_20140604.pdf.The UIHI is a division of the SIHB and is one of 12 Indian Health Service tribal epidemiology centers (TECs). Unlike the other TECs that focus on geography-specific tribal populations, the UIHI is national in scope, focusing on American Indians and Alaska Natives (AI/ANs) living in urban areas. The UIHI supports the efforts of Urban Indian Health Organizations (UIHOs) nationally, as they serve the health and social support needs of their urban AI/AN communities.The Center for Public Service Communications and the National Library of Medicine provided funding for the UIHI to complete this project.