How can relief programs map the location of each house in a refugee camp and link it with individuals that live there?

From TechCampGlobal
Jump to: navigation, search

Presentation Video

Presentation Video

Project Information

Project Title: How can relief programs map the location of each house in a refugee camp and link it with individuals that live there?

Group Number: 1

NGO Project Lead: TBBC and IRC

Project Participants: Juan, Tanawat, Anand, Dr. Noppadol, Jose, Frank

Summary of the Problem

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

Currently, TBBC collects and keeps record of food distribution data in camps along the Thai-Burma border. However, the current method of collection is used in electronic forms of excel format or in paper. Distribution is done by households and the amount of rations given depends on the age and the number of household members. For instance, certain amount of rations should be given more to households with children which is essential for their physical development. Head of families have food ration cards to present to the distributor in order to receive rations. However, there no systematic way of being able to track and analyze the current data collected. Therefore, it is crucial to have a more systematic way to monitor food distribution to camp recipients. It is also important to be able to keep updated information and monitor the population in camps in real time. GIS comes into play to be able to verify and confirm acceptance of food support distributed by to household in camps and also help us prepare for logistics and budgeting.

Proposed Solution

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

Develop a database that stores food distribution data by family household, which is linked with GIS software (ESRI).

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?

Electronic data collection – Episurveyor (software), Andriod mobile devices with gps capability (hardware)

Geo data analysis and mapping – ESRI software

Database – SQLSever Express, MySQL, PostgresQL (open source), filemakerpro, etc

Existing solutions or relevant links

Existing data already collected under “excel” format. Thai government citizen profiling project supported by ESRI

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.

1.Collect accurate reliable data and verify existing (baseline) data which is originally in excel format and paper form.

  • a.Food and ration distribution data (amount/volume distributed)
  • b.Family composition data
  • c.Geo data

2.Develop database and geo mapping (database development through hiring software development firm, geo mapping through ESRI software)

  • a.Population movement
  • b.Food budgeting
  • c.Logistics




  • a.Mobile phones
  • b.Internet connection

3.Undocumented Population

  • a.Population movements

4.Training staff to use databases, mobile tech

5.Avoiding data burden

TechCamp Bangkok Folder