R-Hydronet Data Format Instructions

The following information, tables, and examples explain the formats of all necessary data files for a complete and succesful upload of your data series data.

  1. Each data series should have at least three files associated with it; a Station Attribute Inventory file containing all attributes associated with every station in the data series, a Data Series file containing all monitored time series or climatology data, and at least one Citation file listing a bilbliographic reference for the data series. All of these files need to be plain ASCII files. The Station Attribute Inventory file and the Data Series files also need to have all data fields tab delimited and all character strings delinated by double quotes.

  2. Below you will find a series of tables and examples which list all appropriate fields and formats for each of the above mentioned files. TABLE I. lists the fields that need to be contained within the Station Attribute Inventory file. Example 1. lists a portion of a properly formatted Station Attribute Inventory file. TABLE II lists the fields that need to be contained within the Data Series file. Example 2. lists a properly formatted Data Series file. Example 3. lists a properly formatted Citation File. Example 4. lists the necessary naming conventions for the above files.

  3. Data should represent the years from 1967 - present. If data are not available for a particular station over all of these years, please give all data that were reported (as in the example shown in TABLE II).

  4. Please fax a copy of the Station Description File for our records to this telephone fax number in the USA: (+1) 603-862- 0188 in c/o Michael Routhier.

  5. Data may be transferred to the R-Hydronet Database in one of the following manners:

    1. Via ftp

      ftp r-hydronet.sr.unh.edu
      login: anonymous
      password: your email address
      cd /pub/incoming/r-hydronet
      put yourfile

    2. In ASCII file format on 1.4 megabyte (HD) 3-1/2" floppy disk, formatted for either PC or MacIntosh, and mailed to:

      R-HydroNET Database
      c/o Michael Routhier
      Complex Systems Research Center, Rm. 452, Morse Hall
      39 College Rd.
      University of New Hampshire
      Durham, NH, 03824
      USA

    3. Directly via the WWW page

    Please send an e-mail message to mike.routhier@unh.edu to notify us when you have sent the data, by either ftp or regular mail, and we will notify you when we have received the data. Please include your name, address, phone and fax numbers, and e- mail address. We may need to contact you if there are problems with the data or data files.


TABLE I
Station Attribute Inventory file fields and data types.

*** DATA FIELDS SHOULD BE TAB-DELIMITED ***
*** All TEXT STRINGS SHOULD BE DELINIATED WITH DOUBLE QUOTES ****
*** MISSING DATA SHOULD BE GIVEN THE VALUE -9999 ***
*** DO NOT USE COMMAS TO SEPARATE LARGE NUMBERS ***

If information is not available for any field, or does not apply to the site, then fill in the data with -9999; see examples in Example 1. Variable Codes for each data series entry are listed in Table III. Country Names and 3-letter Country Codes for each country are listed in TABLE IV.

Field NumberREQUIRED INFORMATIONUNITS of MEASURE
1 Site ID# 3-letter country code + site number
2 Variable Code character code as definded from Table III
3 Dataset Type character, either Climateology or Time Series
4 Source character
5 Site Name character
6 Country character
7 River character, name of river monitored
8 Site Location Latitude Decimal degrees of lat. Use negative numbers to represent South.
9 Site Location Longitude Decimal degrees of lon. Use negative numbers to represent West
10 Site Elevation value in meters above sea level
11 Contributing Upstream Area value in square kilometers, do not include commas in large numbers
12 Begining Year First year of record
13 End Year Last year of record
14 Years in Record Number of year of record

Example 1: Portion of a Station Attribute Inventory file for discharge stations in Brazil.

"BRA01""qa""Time Series""UNESCO""Obidos" "Brazil""Amazonas"-1.91-55.553746187461928198355
"BRA02""qa""Time Series""UNESCO""Porto Formoso""Brazil""Parnaiba"-3.43-42.4020282000-9999-9999-9999
"BRA03""qa""Time Series""UNESCO""Itupiranga""Brazil""Tocantins"-5.13-49.35-9999727900-9999-9999-9999


TABLE II
Data Series file fields and data types

*** DATA FIELDS SHOULD BE TAB-DELIMITED ***
*** All TEXT STRINGS SHOULD BE DELINIATED WITH DOUBLE QUOTES ****
*** MISSING DATA SHOULD BE GIVEN THE VALUE -9999 ***
*** DO NOT USE COMMAS TO SEPARATE LARGE NUMBERS ***

If information is not available for any field, or does not apply to the site, then fill in the data with -9999; see examples in Example 1. Variable Codes for each data series entry are listed in Table III. Country Names and 3-letter Country Codes for each country are listed in TABLE IV.

Field NumberREQUIRED INFORMATIONUNITS of MEASURE
1 Site ID# 3-letter country code + site number
2 Variable Code character code as definded from Table III.
3 Year Year of Measurement, -9999 if Climatology Data Series.
4 Jan Value in specified units of variable code from Table III.
5 Feb Value in specified units of variable code from Table III.
6 Mar Value in specified units of variable code from Table III.
7 Apr Value in specified units of variable code from Table III.
8 May Value in specified units of variable code from Table III.
9 Jun Value in specified units of variable code from Table III.
10 Jul Value in specified units of variable code from Table III.
11 Aug Value in specified units of variable code from Table III.
12 Sep Value in specified units of variable code from Table III.
13 Oct Value in specified units of variable code from Table III.
14 Nov Value in specified units of variable code from Table III.
15 Nov Value in specified units of variable code from Table III.

Example 2: Portion of a properly formatted Data Sieres file.
 
"BRA01""pr"198018798337244290210106123111215198141
"BRA01""pr"1981215251273302240182123153150119156186
"BRA01""pr"1982150-9999-9999-9999250165110140100-9999178164
"BRA01""ta"198125.425.226.126.224.625.825.025.925.626.726.226.3
"BRA01""ta"198225.925.926.025.525.426.127.726.526.026.226.926.2
"BRA01""cl"1979-9999-9999-999991.388.073.256.374.267.389.783.887.4
"BRA01""cl"198082.467.392.185.184.374.369.566.674.085.787.681.1
"BRA01""qa"198012023314744317123819407121029221053819942517497113758110250593663100921


Example 3: An example of a properly formatted Citation File.

Vorosmarty, C.J. and Fekete, B.M. and Tucker, B.A. River Discharge Database,
     Version 1.0 (RivDIS v1.0), Volumes 0 through 6.  A contribution to
     IHP-V Theme 1, Technical Documents in Hydrology Series. Paris, UNESCO,
     1986.


Example 4: Examples of a properly named uploadable files.

  • attributes.txt: Naming convention for an uploadable Attribute Inventory file.
  • dataseries.txt: Naming convention for an uploadable Data Series file.
  • citation.txt: Naming convention for an uploadable Citation file.


    TABLE III
    2-Letter Variable Codes to be used in reporting monthly data.

    REPORTED VARIABLEREQUIRED VARIABLE CODEREQUIRED UNITS of MEASURE
    precipitationprmm/month
    mean daily air temperature averaged for the monthta degrees C
    minimum daily air temperature averaged for the monthtmdegrees C
    maximum daily air temperature averaged for the monthtxdegrees C
    mean monthly vapor pressurevpmillibars
    mean monthly relative humidityrhpercent
    wind speedwnmeters per second
    (m s-1)
    mean monthly cloud coverclpercent
    mean monthly downwelling solarrdcal per meter2 per day
    radiation
    (cal m-2 day-1)
    mean monthly dischargeqa cubic meters per second
    (m3 s-1)
    river stage heightsh meters (m)
    air pressureps millibars


    TABLE IV
    Country Codes to be used in the Station-ID codes.

    CountryCountry Code
    CountryCountry Code
    Antigua & BarbudaANT
    GuyanaGUY
    ArgentinaARG
    HaitiHAI
    ArubaARU
    HondurasHON
    BarbadosBAR
    JamaicaJAM
    BermudaBER
    MexicoMEX
    BahamasBHA
    NicaraguaNIC
    BoliviaBOL
    PanamaPAN
    BrazilBRA
    ParaguayPAR
    British Virgin IslandsBVI
    PeruPER
    BelizeBZE
    St. Kitts & NevisSTK
    ChileCHI
    St. LuciaSTL
    ColombiaCOL
    St. Vincent & GrenadaSTV
    Costa RicaCOS
    SurinameSUR
    CubaCUB
    Turks & CaicosTCI
    DominicaDMI
    Trinidad & TobagoTRI
    Dominican RepublicDOM
    UruguayURU
    EcuadorECU
    VenezuelaVEN
    El SalvadorELS
    Netherlands AntillesNAN
    GrenadaGUA