Page Comparison

This section provides an overview of the file formats supported by Source. Table 1 lists the supported time-series data file formats. Raster data file formats are listed in Table 2. Several GIS, graphics and other formats that are also recognised by Source are listed in Table 3 but are not otherwise described in this guide. Click on the link associated with each file extension to go directly to information about that time series.

...

Anchor
TimeseriesDataFormats TimeseriesDataFormats

Table 1. Text-based time-series data file formats

Table 2. Text-based raster data file formats

Table 3. Other supported file formats

Anchor
Annual stochastic time series Annual stochastic time series

Annual stochastic time series

The .AR1 format contains replicates of annual time-series data generated using the AR(1) stochastic method. The file format is shown in Table 4. This format is not the same as the AR(1) format (.GEN) generated and exported by the Stochastic Climate Library.

Table 4. AR1 data file format

...

Arcinfo grid coverages can be converted to .ASC files using ESRI’s GRIDASCII command. ASC files can be imported into ArcGIS using the ASCIIGRID command.

Table 5. .ASC data file format

where:

nc is the number of columns

nr is the number of rows

xref is either XLLCENTER (centre of the grid) or XLLCORNER (lower left corner of grid)

yref is either YLLCENTER (centre of the grid) or YLLCORNER (lower left corner of grid)

(x,y) are the coordinates of the origin (by centre or lower left corner of the grid)

size is the cell side length

sentinel is a null data string (eg -9999)

value is a data point. There should be nc × nr data points.

Anchor
AWBM daily time series AWBM daily time series

AWBM daily time series

An AWBM daily time series format file (.AWB) is an ASCII text file containing daily time series data formatted as shown in Table 6. Dates (the year and month) were optional in the original AWBM file format, but are not optional in the format used in Source.

Table 6. AWB data file format

where:

ndays is the number of days in the month (28..31)

value is the data point corresponding with a given day in the month (ie. ndays columns)

year is the year of observation (four digits)

month is the month of observation (one or two digits).

Anchor
SWAT BSB time series SWAT BSB time series

SWAT BSB time series

A .BSB is a line-based fixed-format file, typically used by applications written in FORTRAN. The SWAT BSB subbasin output file contains summary information for each of the subbasins in a watershed. The reported values for the variables are the total amount or weighted average of all hydrological response units (HRUs) within the subbasin. The format is shown in Table 7.  For more details, refer to the SWAT 2012 input/output manual (Arnold et al., 2012).

The .BSB file format specifies data time step numbers, but not dates. When imported into Source via File Data Sources, the user has the opportunity to manually set the correct data start date.

Table 7. .BSB data file format (first 7 data columns only). The .BSB format also includes an 8 line header, which is not shown.

where:

id is the basin identifier (4-digit integer, left aligned, e.g. "1")

gis is the GIS value (8-digit integer, right-aligned, eg. "1")

month is the month (or day of year for daily data) of observation (4-digit integer, right-aligned, eg. "0")

area is the basin area in square kilometers (real, right aligned, eg "1.14170E+02")

precip is the basin precipitation in millimetres (real, right aligned, eg "1.2000").

snomelt is the basin snow melt in millimetires (real, right aligned, eg "0.111E+01")

pet is the basin potential evapotranspiration (PET) in millimetres (real, right aligned, eg "0.900E+01")

Anchor
BOM 6 minute time series BOM 6 minute time series

BOM 6 minute time series

A .BSM (also .PLUV) is a fixed-format file, typically supplied by the Australian Bureau of Meteorology for 6 minute pluviograph data. The file has two header lines (record types 1 and 2) followed by an arbitrary number of records of type 3. The formats of record types 1..3 are shown in Table 8 and Table 9, respectively.

...

blank ASCII space characters

Table 9. .BSM data file format (record type 2)

where:

snum is the station number

year is the year of the observation (four digits)

month is the month of the observation (one or two digits, right-aligned, space padded)

day is the date of the observation (one or two digits, right-aligned, space padded)

rain_i is a rainfall data point as explained below.

Anchor
Comma delimited time series Comma delimited time series

Comma delimited time series

A .CDT comma delimited time-series format file is an ASCII text file that contains regular (periodic) time-series data. The file type commonly has no header line but, if required, it can support a single line header of "Date,Time series 1".

You can use the .CDT format to associate observations with a variety of time interval specifications. Table 10 shows to specify daily data aggregated at the monthly level, and Table 11 is about the more traditional daily time series (one date, one observation). Table 12 explains how to supply data in six-minute format. The Source will displays and exports the date in the full ISO datetime format.

Table 10. .CDT data file format (time series with monthly data)

where:

mm is the month of observation (two digits, eg. 09)

yyyy is the year of observation (four digits, eg. 2011)

value is the observed value (eg. 2600).

Although mm/yyyy format is used in the cdt file, Source displays and exports the date in 01/mm/yyyy 12:00 yyyy-mm-01 format.

Table 11. .CDT data file format (daily time series with daily data)

where:

date is the date of observation in ISO format (eg. 2000-12-31, and Source displays and exports the date in yyyy-mm-dd12:00 format).

value is the observed value (eg. 2600).

Table 12. .CDT data file format (six-minute time series)

where:

date is the date of observation in ISO format (eg. 2000-12-31)

time is the time of observation in hours and minutes (eg 23:48)

date time looks like 2000-12-31 23:48.

value is the observed value (eg. 10). 

Anchor
Comma-separated value Comma-separated value

Comma-separated value

A comma separated value or .CSV file is an ASCII text file that contains data in a variety of representations. When a .CSV contains regular (periodic) time-series data, there are at least two columns of data. The first contains a time-stamp and the remaining columns contain data points associated with the time-stamp. The format is shown in Table 13. All columns are separated using commas. Annual data can be entered using the notation 01/yyyy, where yyyy is a year. Header lines in .CSV files are usually optional.

Table 13. .CSV data file format

...