make.opendata.ch wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== Medical Time Line =====

{{:project:medicaltimeline.png?400|}}

Demo: http://mhlai.myvnc.com/mtl/

A web page that helps you pinpoint the foods containing potentially allergenic nutrients... and vice versa.
  
===== Our starting idea =====

An apps that collect all your health related events along your life time line. This apps also collects info from open data bases related to your health condition. 

Ex. Imagine you develop some food allergy. You record it and you record the food you eat. The apps imports from the open data base the specific ingredients in your food that could cause your allergy and set it on your timeline. 
  

===== History of the project =====

  * Brainstorm around the ideas, "medical time line" & "input allergenics foods in time line"
  * Search for some allergenic data base
  * Mockups
 
{{:project:medicaltimeline1.png?200|}}
{{:project:medicaltimeline4.png?200|}}

  * Still searching for a descent allergenic/nutrient database
  * Calling Migros, Coop, ETH etc: "Do you have an allergenic database ?" -> A lot of call transfers... but no database available.
  * YES! we found one usable allergenic/nutrient database
  * Start coding in .dotnet
  * Good night
  * Continue coding
  * We loose too much time searching for a good database to be able to implement all the functionnalities  before 16:00.. Yes, we knew that we were a little bit too ambitious... 3 ideators for 1 coder is not the good mix ;-) 
  * The project will at least complete the request to the database... the timeline will be left for future extensions

==== Presentation (en français) ====

{{youtube>CTwCV-8Su8A?medium}}

===== Data =====

  * http://ndb.nal.usda.gov/ndb/foods/list
  * http://foodallergens.ifr.ac.uk/

===== Team =====

  * [[user:leonard]]
  * [[user:mhlai]]
  * [[user:mpolitis]]
  * [[user:suckow]]

===== Ideas =====

  * Use twitter to announce health events (but what about privacy ?)
  * Look for swiss food data base ...
  * 

===== Time Line Database Tables Structure =====

^ Time Line Table ^^^^^^
| Start Date | End Date | Event | Event Descr | Age at Event | Link to Specific Record in external Database (Nutrient, food or Drugs)|


^ User Table ^^
|qui | date de naissance|


^Nutrient Table ^^^^^
|NDB_No	| Shrt_Desc | NutrDesc | Nutr_Val | FdGrp_Desc |


^Product/Food Table ^^^^^
|Shrt_Desc | NDB_No | NutrDesc | Nutr_Val | FdGrp_Desc |


===== Problems to be solved =====

  * Best way to integrate personnal events and info from data base ?


===== MoSCoW classification of features =====

  * Must have = M
    * Display life events along time line  ✘ (not implemented)
    * Navigate along time line  ✘   (not implemented)
    * Input life/health events  ✘   (not implemented)
    * Import and search info from dedicated external database  :-) ✔
  * Should have = S
    * Export/Import time life report
    * Annotate time lines
  * Could have = C
    * Publicly share some (anonymized) part of time line
    * Compare time lines
  * Would have ... nice but not this time = W
    * Make coffee

===== Mockups =====

{{:project:medicaltimeline1.png?500|}}

{{:project:medicaltimeline4.png?500|}}

===== Documents =====

{{:project:usda_welcome.png?500|}}
{{:project:food_groups.png?500|}}
{{:project:food_item_nutrients.png?500|}}
{{:project:food_item_nutrients.png?500|}}
{{:project:nutrients_definitions.png?500|}}
{{:project:sr24_doc.pdf|}}

===== Links =====

  * Here it is !
    * http://mhlai.myvnc.com/mtl/

{{tag>status:demo health}}