Data

Posted on February 21, 2012

0


The success of the project in meeting the objectives defined, partly depends on the access to agricultural data on the production and distribution of fruits and vegetables that can be used for predictions.  However, it is  discovered that there is hardly any open agricultural data available, with few exceptions of data made available in accessible formats.  Data, especially the ones that is needed are locked up in PDF files.  Although these data is available for reading, to re use these data (as in this case where data is needed for visualisations to aid in making predictions) involve manually entering these data into tables again, which for this project is probably simpler than writing a program to extract these data.

Below contains a few source of statistical data that is somewhat related to this project, and the date that this information was first accessed:

09-02-2012

Grenada Agricultural Census 1995 – Main results (Food and Agricultural Organisation)

http://www.fao.org/fileadmin/templates/ess/documents/world_census_of_agriculture/main_results_by_country/Grenada_1995.pdf

USDA Farmer Cooperative Statistics

http://www.rurdev.usda.gov/rbs/pub/CIR%2045_13.pdf

Problems encountered by Cooperatives – USDA

http://www.rurdev.usda.gov/rbs/pub/cir27.pdf

Loss in Agriculture – USA

http://www.rurdev.usda.gov/rbs/pub/sr55.pdf

Irrigated Global Land and Harvest of major crops

http://www.geo.uni-frankfurt.de/ipg/ag/dl/f_publikationen/2008/FHP_06_Portmann_et_al_2008.pdf (Parent site – http://www.geo.uni-frankfurt.de/ipg/ag/dl/forschung/MIRCA/index.html)

Technology and Other information related to Grenada

http://www.landnetamericas.org/docs/Grenada%20assesment.pdf

Grenada 2006 Demography and main export

http://icmpolicy.cta.int/filesstk/Grenada-Final-Report-03.07.06.pdf

21-02-2012

Grenada Review 2008 and 2009 – includes downloadable statistics in PDF format:

http://www.gov.gd/ministries/agriculture.html

Annual Agricultural Review 09

http://www.gov.gd/egov/docs/reports/MOA_annual_review_09.pdf

Annual Agricultural Review 08

http://www.gov.gd/egov/docs/reports/MOA_annual%20review_2008.pdf

22-02-2012

OECS Good Agricultural Practise for producing fresh fruits and vegetables

http://www.iica.int/Eng/regiones/caribe/SaintLucia/IICA%20Office%20Documents/OECS%20GAPS%20CERTIFICATION%20PROTOCOL%20GUIDANCE%20DOCUMENT.pdf

Researched into database technologies, particularly MYSQL workbench for creating a database model.  Listened web seminar series on MYSQL – available online: http://www.mysql.com/news-and-events/on-demand-webinars/display-od-538.html  (may require registration to access files).

23-02-2012

US Department of Agriculture datasets: http://www.data.gov/list/agency/20/0/catalog/raw/page/1/count/50 

From these datasets a suitable one was chosen on Agricultural Productivity in the United States: http://explore.data.gov/Agriculture/Agricultural-Productivity-in-the-United-States/fee6-c2rk.  This dataset was converted into CSV format.  A database was designed using MYSQL – phpMyAdmin, to store the US productivity dataset.  The dataset was imported into the database – this would be used as a starting point for visualising data on web site, although the completed version should enable real time visualisation of data.  (Also see post on data visualisation)

03-03-2012

World Bank Agricultural Data

http://search.worldbank.org/data?qterm=agriculture&language=&format=&os=40

GapMinder Datasets

http://www.gapminder.org/data/

Advertisements