How to use Mapping technologies to collect data and influence government spending and decision making

From TechCampGlobal
Jump to: navigation, search

Group 10

Project Title:

How to use Mapping technologies to collect data and influence government spending and decision making

Project Presentation Video

Project Participants:

Manisha, Rao, Prasha, Nadeem, Sanjay, Mikel, Praveen and Munaf

NGO Project Lead:


Technologist Project Lead:

Mikel and Praveen

Project Presenter:


Group Number:


Problem Set Format

Problem sets and solutions provide a method that details everything you need to get support to a critical problem to which an NGO or a grassroots organization faces.

Summary of the Problem

This is a description of the problem situation. What kind of people mission better if this problem is solved?

Manual paper based process of doing surveys, collecting data and doing data entry. Outsourcing is required for data cleanup and converting it into visuals

  1. “How can this process be internalized and minimize cost” and
  2. “How to use Participatory Rural Appraisal data (i.e. a paper based hand drawn map) and convert it into digital maps?” (e.g. Open defecation issue)
  3. “Advocacy of women harassment / protection issues correlated to location of certain establishments”

Summary of the Proposed Solution

This should provide an outline of the basic need that would solve the above problem.

  1. Internalizing the process
  • a. Using a software platform to manage, clean, analyze, visualize and print data
  • b. Training for internal staff to use this software
  1. Converting PRA data into Digital forms
  • a. Collecting the data using a GPS device
  1. “Advocacy of women harassment / protection issues correlated to location of certain establishments”
  • Base Map Data
    • Alcohol shops
    • Tobacco shops
    • Schools
  • Actual Reports (Physical verification will be required)
    • Crimes against women

Technology to Solve the Problem

Areas of technology that you believe have the potential to solve this problem? (eg mobile devices, social networks, geospatial technology, etc.). As the proposed solution could be used?


Collecting data 1.Simple Data

  • a. SMS (Frontline)

2. Complex Data (via Man-on-street)

  • a. Survey Monkey
  • b. Indaba
  • c. Google Docs
  • d. ODK (Open data kit) (offline capabilities)

Via Android Device

  1. Affordable Tablets (Aakash 2 – Rs 2180)
  2. Micromax Smartphone (~Rs 3000-4000)

Analyzing Data

  1. Data analysis and visualization can be done using Indaba
  2. Data is available in spreadsheet format (w/ training output can be achieved)


i.e. Hand drawn map

Use this as a guide to start.

1. Ways to collect map data

  • a. Mobile device with GPS
  • b. Leverage satellite imagery available on OpenStreetMaps and layer it with PRA
  • c. Walking Paper

2. Edit

  • a. Web-based / Desktop Editors

3. Print

  • a. Export directly from OpenStreetMap and print it


Crowd sourcing information and presenting it via USHAHIDI

Eg. We prepare a map with Alcohol shops, tobacco shops, schools via Open Street Map

Second layer of information such as ‘Crime against women’ can be collated and presented via USHAHIDI

Final product = a consolidated map showing correlation between ‘Crime against women’ and geo locations of specific establishments.

Existing solutions or relevant links What other information could help technologists working on this idea?

  1. Harassmap available on USHAHIDI
  2. Mapkibera – case study on using open street map
  3. Community mapping for exposure in Indonesia
  4. Case studies on Get Indaba website

Follow-on Actions

Once a potential solution has been developed, what is your plan of action to implement it? Should arise as a series of steps and goals, preferably together with actions assigned to a specific group of people.

A) 1. Run Pilot

  • a. Buy 1 Aakash for Rs 3000 on ebay
  • b. Find a volunteer within staff to be a part of this pilot
  • c. Give volunteer training via skype – Mikel volunteers
  • i. Support via mail
  • d. Volunteer replicates existing paper questionnaire into digital form
  • e. Volunteer goes on the field and asks questions and inputs via Aakash
  • f. 2 weeks later, all the output will be on one spreadsheet
  • g. Training 2 – on excel analysis
  • h. Volunteer prepares final output (statistical distribution etc.)
  • i. Regroup – was pilot successful? Learnings?

2. Run the real thing

  • a. Bulk deal on ebay…

B) PRA into Digital

  1. Take existing PRA (ensure high resolution imagery exists)
  2. Train volunteer on OpenStreetMap and editing functionality
  3. Take existing Satellite imagery from OpenStreetMap and manually incorporate data from PRA using OSM Edit functionality
  4. Print via OSM

C) Advocacy for women using Maps

  1. Choose Computer literate Volunteer
  2. Train volunteer on using OpenStreetMaps
  3. Physical verification of sites with Alcohol/Tobacco shops
  4. Mapping the same on OSM
  5. Praveen will train Volunteer on crowdsourcing via USHAHIDI (deploying SMS based system)
  6. Encourage public to give us physical location of ‘crimes against women’
  7. Black and white print ad / pamphlets / news channel / PR highlighting SMS number
  8. Convert this into a USHAHIDI map to be presented to government
  9. Happy ending