Main Page

From ProdStat
Jump to: navigation, search

The aim of this wiki is to import the UN FAO's[1] 'ProdStat' database [2] [3] into a Semantic MediaWiki (SMW). By doing so, we aim to achieve two key objectives:

  1. Gain hands on experience with data modelling in the SMW system.
  2. Produce a community platform for discussing global food production.


Data

Countries:
Countries Data points
United Kingdom 195
Finland 186
Kyrgyzstan 186
Colombia 186
Cuba 186
Iceland 186
Bangladesh 186
Eritrea 186
Ireland 186
Egypt 186
… further results
Items:
Items Data points
Potatoes 2,924
Bananas 109
Barley 90
Apples 84
Apricots 63
Avocados 55
Asparagus 30
Artichokes 22
Arecanuts 6
Lentils 3
… further results


Notes

Issues related to the first objective

  • How best to model the relatively simple data structure of the ProdStat database in SMW?
    • Page tuples vs. multi-valued properties?
      • Multi-valued properties were never fully supported. Page tuples are the way to go, especially with the new SIO extension.
    • Categories, are they necessary?
      • Answer: Not strictly, but they provide a lot of convenience. I would certainly never consider not using categories in future. Also, the RDF 'class' concept that categories are used to capture is a useful one. See Semantic concepts.

Issues related to the second objective

  • Navigating the data.
  • Querying the data.
  • Producing reports based on queries.


Status

Data Import

Data Navigation and Query

Competition?

Could be a bad idea, but I'd like to host a 'build a report' competition to get people interested.


Import

Code

See https://github.com/dbolser/ProtStat