Tag Archives: Android

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.

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 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 iPhone

Health Care Facilities data collection form on an iPhone

Once 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 Options

Fulcrum Data Export Options

I 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 Website

iFormBulder Website

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?

A form being designed on the iFormBuilder site

A data collection form being designed on the iFormBuilder 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.
Data collection form while out collecting data on an iPad

Data collection form while out collecting data on an iPad

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.

Field data being viewed on a map on an iPad

Field data being viewed on a map within the iForm app on an iPad

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.

Technology + Youth = Change


by Chad Noble-Tabiolo

It all started in May 2013 when I watched the documentary entitled Revolutionary Optimists on PBS’s Independent Lens. It showed how young people from a slum in Kolkata, India were able to map the deficient and unsafe water taps in their community, in order to plea with the government for more and safe drinking water lines. The film highlighted technology in an unconventional way. It showed GIS-technology as an innovative tool to mobilize youth for social change.

This heralded the beginning of a partnership with Map Your World to develop a mapping project in the Philippines in the summer of 2013. Through coordination with domestic and international partners, the youth mapping program was implemented in Southville 7 — an impoverished and neglected slum community, about three-hours south of metro Manila. The issues faced in Southville 7 ranged from lack of access to jobs, water and electricity to food insecurity and child and maternity health; and because of a lack of response from both the government and non-governmental sectors, the project was aimed to raise awareness and demand change.

In just a few weeks, a dozen phones were donated. Youth, ranging from 15 to 23 years old, were trained to go house-to-house to collect data. By the end of three months, 3000 families were surveyed and the needs of the community were mapped. Depicted below is Map 1, which shows the families who have direct access to water in their homes.

Families who have direct access to water in their homes.

Map 1 – Families who have direct access to water in their homes.

Because of the unequal distribution of resources, it was evident who had direct access to water and who did not. Map 2 shows those families who did not have direct access to water. These families had to walk more than 1 kilometer to a communal water tap.

Families who had to walk more than 1 kilometer  to water.

Map 2 – Families who had to walk more than 1 kilometer to access fresh drinking water.

Lastly, Map 3, represents the top four needs according to the three different subdivisions or sites in Southville 7.  Collectively these maps and data provide an opportunity for proper and adequate planning for public health infrastructure and needs.

The top four needs according to the three different subdivisions or sites in Southville 7: Jobs, Water, Electricity and Healthcare.

Map 3 – The top four needs according to the three different subdivisions or sites in Southville 7: Jobs, Water, Electricity and Healthcare.

The Android mobile phones used by the youth were powered by open-source applications for GPS-mapping and data collection. ODK Collect or Open Data Kit was the data collection tool utilized in the project. It can be found on the Android market. (NOTE: This tool is also described in the Community Health Mapping blog post on Field Data Collection). This tool is functional only after uploading a survey form that is created in Microsoft Excel and uploaded to the companion site www.formhub.org. The maps were created online with Map Your World, an online community mapping tool inspired by the Revolutionary Optimists documentary.

Map Your World Banner

Map Your World Banner

In the end, the 30 youth involved in the mapping project were able to accomplish an endeavor that many people in their community had not expected. They were able to successfully map who in their community had access to water, electricity, jobs and vaccination for children under five years old, among others. They became leaders who are now equipped with leadership and technological skills that many in their community lack. They were empowered to raise awareness about the social injustices and health inequalities existing among them.

One of the community mappers with an array of Android phones.

One of the community mappers with an array of Android phones.

The Southville 7’s mapping work was primarily a vehicle for instilling hope, and the use of GPS/mapping-technology offered an opportunity for the youth to be the voice for their community. According to one youth, “For me, mapping is like knowing. Knowing the problems, and how people are coping with them. Through the work we can open the eyes of the people, not only the things that can help them, but things that can help us all.

Youth mapping their community

Youth mapping their community

Field Data Collection

The workflow covered in the Introduction included three phases: 1) Field Data Collection, 2) Desktop Analysis, and 3) Data Visualization. Here we’ll discuss phase 1.

We encourage the use of smart phones and tablets for data collection for these reasons:

  • Most already have them!
  • Many know how to use them
  • They’re intuitive
  • They’re portable
  • 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!

Equally as important they are accurate enough for most public health community mapping needs.  For a discussion on their accuracy read this post.

There are a myriad of data collection apps available. Part of choosing one comes down to the operating system you are using. We’ll cover the three best apps we found for iOS and Android. Our full report and individual user step by step user manuals for each can be found here.

iOS (Apple iPhones and iPads)

The two best data collection apps for Apples iOS are EpiCollect and GIS Pro. They both allow you to customize the data attributes you collect. One big difference is that EPI Collect is free and GIS Pro, at $299, is the most expensive piece of software we considered in our workflow. However, with that price tag comes a lot of great intuitive functionality.

EpiCollect (available for both iOS and Android)

To get started with EpiCollect you install the app on your device via Apple’s App Store. You then visit the EpiCollect website  and set up a project. Simply give the project a name and design your data collection form. The form can be set up with a variety of attribute columns. For example, feature type, name, description and photo. For most users it takes a practice run to get used to the workflow to set up a data collection form. The second time it goes very smoothly. The project can then be uploaded, via your email address, to your iOS EpiCollect app. Examples of the data collection screen are shown below. On the left is the home screen, on the right is the data collection screen.

EpiCollect Data Collection

EPI Collect Data Collection

 

After data collection, you can sync the mobile app with the website. The data can then be viewed both on the mobile app or on the website. The website also allows for the spatial data to be exported as either an XML or CSV file. Data collected by EpiCollect is limited to point locations. The data can then be brought into a desktop GIS such as QGIS. This will be covered in a future blog post.

GIS Pro

GIS Pro is essentially a lightweight GIS application for iOS. Once purchased a user can have the app on both an iPhone and an iPad. However, each unique user needs their own license. As with EpiCollect, the user can set up custom data collection fields. One additional feature here is that users can collect point, line or polygon (area) data sets within the same project. The data can also be exported in a shapefile format which is then ready to be used by any desktop GIS package. GISPro also allows for sharing of GIS layers. With this feature a team of data collectors can all be working off of the same GIS layer. This is a valuable feature. With the high cost does come great functionality compared to EpiCollect. This was determined to be part of the best workflow and is reviewed more thoroughly in the final report.

GIS Pro

GIS Pro – Exporting Data

Android

In addition to EpiCollect, the other great app for Android devices is OpenData Kit, known as ODK Collect. The app is free. It is even more intuitive and makes project management even easier than EpiCollect.

To get started you will use a companion website called FormHub. Simply sign up for a free account and design your form. Here your data collection form is designed in MS Excel, and a template Excel file makes generating your first form easy. Once designed upload your form and sync your device to your account and you are ready to collect data. On the device the data collection form presents itself as a series of pages for each question.

ODK Collect Workflow

ODK Collect Workflow

When you are back in range of a network simply sync the app with your account. The data will then be available for download from the website in several formats.

Summary

These are the best apps we found out of dozens reviewed. All three were successfully tested in 2013 by our partners were found to work well. For additional reading download the full report . Step by step user manuals for each can be found here.