1 / 8

Climsoft Database for Chad Built at ACMAD

Climsoft Database for Chad Built at ACMAD. Rationale.

hanne
Download Presentation

Climsoft Database for Chad Built at ACMAD

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Climsoft Database for Chad Built at ACMAD

  2. Rationale Data management staff and climate scientists seconded to ACMAD from NMHSs, normally bring climate data from their countries for use on their short projects at ACMAD. In most cases, the data are stored in Excel spreadsheet format, or as text files, and not suitably organized for the required analysis on their projects at ACMAD. Such data are now imported into a CLIMSOFT database specific to a given country. The required output from the CLIMSOFT database then becomes easier to be formatted for the required analysis. On return to the NMHS, the seconded member of staff takes the CLIMSOFT database for use at the NMHS once CLIMSOFT has been installed. Normally the data is for a few stations selected for analysis so the database will be small and easy to carry.

  3. Training for Building Country Database • A data management officer from Chad was the first to be involved in building a country database in mid 2012. • The first part of the training was CLIMSOFT, with emphasis on metadata, importing of data and extraction of data products for analysis. • The second and last part of the training was the actual process of importing data brought from the country.

  4. Input Data and Ingestion into CLIMSOFT database for Chad • The data brought from Chad was in CLICOM format but with observation values and flags separated by a semi-colon instead of a comma. • On a computer running on the French version of the Windows OS, or configured to French in the Regional and Language Settings of the Windows Control panel, the data requires replacing the semi-colon with a comma, decimal symbol from comma to dot and list separator from semi-colon to comma. So there was need to go through this procedure before the data from Chad could be imported into CLIMSOFT. • The option for importing CLICOM data is already in CLIMSOFT. One needs to browse for the CLICOM data file before the module can be executed.

  5. CLICOM Data Semi-colon Separated

  6. CLICOM Data Comma Separated

  7. Control Panel Configuration for Decimal Symbol and List Separator

  8. Data Products from Database • After importing the data, different products could be extracted e.g. daily, 10-day and monthly • The project for the seconded staff from Chad involved using a provided tool for climate monitoring. The tool runs in Excel. A facility already available in CLIMSOFT was used for extracting data in the required format for this tool.

More Related