RDES with CountrySTAT - Function and Mechanism of New and Present RDES -

1. RDES with CountrySTAT- Function and Mechanism of New and Present RDES - Takeshi HAGINO Agricultural Statistics Expert GCP/RAS/184/JPN

2. Function and Mechanism of New and Present RDES

3. Topic • Introduction • Function of RDES • Outline of the present RDES • Outline of the new RDES with CountrySTAT 3. Mechanism of CountrySTAT • Requirements for constructing the database with CountrySTAT • Component of RDES with CountrySTAT • Data Conversion • On-going Development

4. Introduction RDES has been operating since March 2003. http://www.faorap-apcas.org Participating Countries (16) Bangladesh, Bhutan, Cambodia, China, Fiji, India, Indonesia, Iran, Lao PDR, Myanmar, Nepal, Pakistan, Philippines, Sri Lanka, Thailand and Viet Nam

5. Function of RDES • RDES is a unitary statistical Information system on Food and Agricultural Statistics in APCAS countries. • Database of APCAS countries • Gateway for internet website (Portal website)

6. Function of RDES Database of APCAS countries • More than 200 records are stored based on the same standard (Definition of Unit, Items, format, etc). • Main data are production of crops and livestock (it is settled 19 core data), which are sub-national and historical based.

7. Function of RDES A Portal Website on Food and Agricultural Statistics in APCAS countries • It has been showing the Country Profile, Contact address of the national Focal Point and hyperlinks for related organizations for statistics in each country. • RDES also show the external hyperlinks to related database/organizations/associations for Agricultural Statistics and Food Security Information on the top page of website, such as the FAOSTAT, UNSTAT, etc.

8. RDES (Regional Data Exchange System) RDES (Regional Data Exchange System) Users • Major Agricultural Statistics Data • 19 core commodities of the sub-regional agricultural production data, such as Rice Paddy, Wheat, Cattle, etc. • Other data (Agricultural Population, price, etc) • Use the same standard (Unit, definition of data item, data format, etc) • Country Profile of the Agricultural Statistics • Gateway to the related statistical organization’s webpage and DB • Major Agricultural Statistics Data • 19 core commodities of the sub-regional agricultural production data, such as Rice Paddy, Wheat, Cattle, etc. • Other data (Agricultural Population, price, etc) • Use the same standard (Unit, definition of data item, data format, etc) • Country Profile of the Agricultural Statistics • Gateway to the related statistical organization’s webpage and DB APCAS Countries not covered by RDES New Zealand France United Kingdom RDES (Regional Data Exchange System) A Portal Website on Food and Agricultural Statistics in APCAS Countries The Project covered countries Get the information Data Input <16 participating countries> Bangladesh Lao PDR Bhutan Myanmar Cambodia Nepal China Pakistan Fiji Philippines India Sri Lanka Indonesia Thailand Iran Viet Nam <Other APCAS countries> Australia Japan (Donor) Malaysia Republic of Korea United States of America Feedback Search the information

9. Function of RDES 1. Front page The RDES front page provides information about the project and links to relevant projects documents. The menu of the left side of the page links to country pages as well as to related external sites.

13. Function of RDES 2. Country pages Country page provides a link to the regional data exchange system of a country (Database), Country profiles, documents related to the country and related external links.

15. Function of RDES • Database • RDES is an interactive web-based system for uploading, storing and downloading/viewing statistical data files. • Each participating country has its own independent database which records the description and location of the statistical data files. • The system accepts the following file types: Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Adobe Acrobat PDFs, etc. • Use of MS-Excel is highly recommended because they are able to modify the data easily more than the other types of files, such as re-tabulation, making a graph, calculation and so on.

17. Outline of the new RDES with CountrySTAT • CountrySTAT, which is developed by FAO Headquarters, is a statistical information system designed to aid in the progress of strategic decision-making for food and agriculture policy at national level. • The software of CountrySTAT is based on PC-AXIS technology with Scandinavian countries, and it has advantage for re-tabulation, mapping and making a graph more than the other statistical software or database. • In addition, the software of CountrySTAT is also functional if it is used for Regional Statistical Database as a basic system and tools on the website.

18. Outline of the new RDES with CountrySTAT • Front page The new RDES’s front page provides information about the project, links to database and links to relevant website.

19. Outline of the new RDES with CountrySTAT • “Navigation” Navigation links to the data on new RDES. It is classified into three categories, Country Data, Selected Indicator in APCAS and All data. • “Search Box” To put the word in Search Box, it is easy to find the required data. For example, if the user needs the data of rice on RDES, the user just puts the word of “rice” in this box, then new RDES system find out all the data of Rice on database. • Links There are two categories of external links. “RDES Links” is shown the hyperlink to Present RDES External link and Country page on RDES. “CountrySTAT Links” is the gateway which is relating the CountrySTAT, such as CountrySTAT website on FAO, PC-Axis website, etc.

21. Outline of the new RDES with CountrySTAT Database Function - Data Query (Select part) After choosing the data, the screen proceeds to the webpage of Data Query. The data was selected by the users, required time, elements, etc. - Result as Table, Graph and Map On the basis of the users’ selection, the new RDES shows the result, inter alia; (1) Table with re-tabulation and aggregation (2) 10 forms of graphs, and (3) Four styles of electric files such as PX-files, MS-Excel, CSV and SDMX (Statistical Data and Metadata Exchange).

22. Search Interface

23. Results on Web

24. Results in Excel

25. Results in CSV

26. Results in XML (SDMX)

27. Results in Charts

28. Results in Maps

29. Mechanism of the new RDES with CountrySTAT

30. Mechanism of the new RDES with CountrySTAT • The software of CountrySTAT is based on PC-AXIS technology with Scandinavian countries, and it has advantage for re-tabulation, mapping and making a graph more than the other statistical software or database. Very useful for the Users! • On the other hand, using the CountrySTAT need only the minimum requirements to construct the database

31. Mechanism of the new RDES with CountrySTAT • Requirementsforconstructing the database with CountrySTAT • The basic system of CountrySTAT is quite simple. • All the people who have a little knowledge of IT can construct the database with CountrySTAT as their own database system.

32. Mechanism of the new RDES with CountrySTAT • Requirement of basic hardware and software • CountrySTAT needs the minimum installation of hardware and software of PC although it is necessary of PC on the Internet webserver. • It is also available to use on the low specification computer as independent database system.

33. Mechanism of the new RDES with CountrySTAT • CPU: Pentium III or more high performance CPU, compatible with IBM-PC. In case of RDES, it can be operated on old architect (Mobile Pentium III, 866Mhz) So it is enough for the operation of CountrySTAT by single cored CPU. • Size of hard disk (HDD): Though it depends on the size of statistics and map, cheapest HDD (Maybe 40GB) is enough for CountrySTAT. In case of new RDES, it is only needed about 150MB of disk space. • OS (Operation System): Windows NT, 2000 and XP with IIS 4.0 or latest version (It is also available to operate under Linux with “Chili Soft ASP”)

34. Mechanism of the new RDES with CountrySTAT • PX-Software: PC-AXIS, PC-Map, PX-Excel, PC-Make, PX-Edit and PX-Web • The software which can edit the ASP and related files: Text editor and Web construct software such as “Microsoft Visual Studio .NET”. In the case of new RDES, “Microsoft Front page” and “Text Editor” for programming are enough.

35. Mechanism of the new RDES with CountrySTAT • Requirement of the knowledge of IT Technology • Any person who has the knowledge of HTML is capable of basic construction the database based on the CountrySTAT software • However, the knowledge of GIS is needed for the map option when you make your country map information as initial set-up. • To study the basic component and operation of CountrySTAT, the time required is only 5 days.

36. Mechanism of the new RDES with CountrySTAT • Component of RDES with CountrySTAT • The major component of CountrySTAT is sustained by ASP file, which works on IIS technology with MS-Windows Server. To change/modify some of ASP file as well as change the parameters, the developer of database with CountrySTAT is easy to customise for their requests. • One of the important file is “Globa2.asp” which is the parameter files on CountrySTAT. • And it also needed some ASP-files, “index.asp” and related ASP.files to modify for the outlook of database, add the logo-types, etc. It is almost the same as html, so it can be easy to modify in each developer.

39. Thank you!!

40. RDES with CountrySTAT- Metadata of RDES - Takeshi HAGINO Agricultural Statistics Expert GCP/RAS/184/JPN

41. Topic • Introduction • Philosophy of Metadata on RDES • Fundamental Metadata of each survey • Metadata which was added when it would be issued/made public • Metadata as a portal website on Food and Agricultural Statistics • Development of Metadata on RDES

42. Introduction 100 ?

43. Introduction • Example: • “100” is data, and with no additional context is meaningless. • With the additional “Metadata" of giving “100” a meaningful name of "Zip Code", you can then understand that “100” represents Tokyo, Japan. • Or, if it is added the unit of “meter” to “100”, “100” becomes as the distance. 100 Metadata is data about information

44. Introduction There are also more sophisticated definitions such as: • "Metadata is structured, encoded data that describe characteristics of information-bearing entities to aid in the identification, discovery, assessment, and management of the described entities." and; • "Metadata” is a set of optional structured descriptions that are publicly available to explicitly assist in locating objects. Reference: Wikipedia (http://en.wikipedia.org)

45. Introduction The man who is standing in front of the Tank.

46. Introduction Name: Takeshi HAGINO Nationality: Japanese Occupation: FAO officer Location: Bangkok, Thailand Title: Agricultural Statistics Expert of the Project, GCP/RAS/184/JPN Etc…. The man who is standing in front of the Tank. He took this photo in Bangkok

47. Introduction Without the less/inaccurate Metadata • Confusion, collapse • Misleads • Loosing the confidential • Etc. Cannot reply the needs of Users With the full/acculate Metadata Can reply the needs of Users To be happy !!

48. Introduction Metadata have to be a compass of the Data What is the appropriate Metadata concept for RDES as the Database and a portal website on Food and Agricultural Stat.?

49. Philosophy of Metadata of RDES As a basic condition…… • Metadata should be helpful, reasonable for the Users Then • To consider the Metadata on RDES, it should be the maximum number of Metadata on RDES based on the basis of the function, statistical database and portal website.

50. Philosophy of Metadata of RDES • There are 2 types of the users; • Heavy Users It means that the user who analyze the statistical data from individual questionnaire, such as re-calculation, etc. • Normal Users It means the the users who only analyze the data from the result, such as monitoring, classification, etc.