The following file formats
are supported in Browser...
NOTE THAT THE FIRST 4 FORMATS ARE THE
USER DEFAULT TYPES. i.e. if you add your own data type to the database...
the files will be assumed to be one of the following 4 formats.
--------------------------
User Daily Column
Format
--------------------------
Westbrook data
// The first line contains
the file identifier. In this case "Westbrook data".
// You can include as
many comments as you like... even at then end of the file... so long as
they are commenced with the "//"symbol.
// The date format must
be as outlined below... be sure to include leading zeros... i.e. 01/01/1987
instead of 1/1/1987.
// You can include as
many columns of data as you like.
// The next line must
contain the data names. Make sure that names containing more than 2 words
are contained in quotes... i.e. "irrigation (mm)".
"Date","Rainfall (mm)","irrigation
(mm)","Runoff (mm)" ... (note that "..." just means you can add more data
here!!)
01/01/1987,
18.00, 0.00, 4.30 ...
02/01/1987,
0.00, 0.00, 0.00 ...
03/01/1987,
4.00, 0.00, 0.00 ...
04/01/1987,
0.00, 0.00, 2.31 ...
05/01/1987,
0.00, 0.00, 0.00 ...
06/01/1987,
0.00, 0.00, 0.00 ...
.
.
.
//More comments here
if you like
Top
----------------------------
User Monthly
Column Format
----------------------------
Westbrook data
// The first line contains
the file identifier. In this case "Westbrook data".
// You can include as
many comments as you like... even at then end of the file... so long as
they are commenced with the "//" symbol.
// The date format must
be as outlined below... be sure to include leading zeros... i.e. 01/1987
instead of 1/1987.
// You can include as
many columns of data as you like.
// The next line must
contain the data names. Make sure that names containing more than 2 words
are contained in quotes... i.e. "irrigation (mm)"
"Date","Rainfall (mm)","irrigation
(mm)","Runoff (mm)" ... (note that "..." just means you can add more data
here!!)
01/1987,
134.00, 0.00, 4.30 ...
02/1987,
30.00, 0.00, 0.00 ...
03/1987,
33.00, 0.00, 0.00 ...
04/1987,
12.00, 50.00, 2.31 ...
05/1987,
3.00, 50.00, 0.00 ...
06/1987,
43.00, 0.00, 0.00 ...
.
.
.
//More comments here
if you like
Top
-------------------------
User Monthly
Row Format
-------------------------
PDO Values
// The first line contains
the data identifier. In this case "PDO Values".
// You can include as
many comments as you like... even at then end of the file... so long as
they are commenced with the "//" symbol.
// The only data information
which is required is the year in the first column. The next columns correspond
to the months.
// You dont need to
include month labels (like the next line) but it doesn't hurt to include
them as comments.
// YEAR
JAN FEB MAR APR
MAY JUN JUL AUG
SEP OCT NOV DEC
//
1900
0.04 1.32 0.49 0.35 0.77
0.65 0.95 0.14 -0.24 0.23
-0.44 1.19
1901
0.79 -0.12 0.35 0.61 -0.42 -0.05
-0.60 -1.20 -0.33 0.16 -0.60 -0.14
1902
0.82 1.58 0.48 1.37 1.09
0.52 1.58 1.57 0.44 0.70
0.16 -1.10
1903
0.86 -0.24 -0.22 -0.50 0.43 0.23
0.40 1.01 -0.24 0.18 0.08
-0.03
1904
0.63 -0.91 -0.71 -0.07 -0.22 -1.53
-1.58 -0.64 0.06 0.43 1.45
0.06
1905
0.73 0.91 1.31 1.59 -0.07
0.69 0.85 1.26 -0.03 -0.15
1.11 -0.50
.
.
.
//More comments here
if you like
Top
---------------------------
User Yearly
Column Format
---------------------------
Westbrook data
// The first line contains
the file identifier. In this case "Westbrook data".
// You can include as
many comments as you like... even at then end of the file... so long as
they are commenced with the "//" symbol.
// The date format must
be as outlined below...
// You can include as
many columns of data as you like.
// The next line must
contain the data names. Make sure that names containing more than 2 words
are contained in quotes... i.e. "irrigation (mm)".
"Year","Rainfall (mm)","irrigation
(mm)","Runoff (mm)" ... (note that "..." just means you can add more data
here!!)
1987,
234.00, 0.00,
4.30 ...
1988,
230.00, 0.00,
0.00 ...
1989,
133.00, 0.00,
0.00 ...
1990,
45.00, 50.00,
2.31 ...
1991,
3.00, 50.00,
0.00 ...
1992,
67.00, 0.00,
0.00 ...
.
.
.
//More comments here
if you like
Top
---------------------------------------
PERFECT Daily
File Format (daily.asc)
---------------------------------------
"Day","Month","Year","CropID","TillageID","Rainfall
(mm)","irrigation (mm)","Runoff (mm)","Soil Evaporation (mm)","Transpiration
(mm)","Drainage (mm)","Soil Water (mm)","Soil Water Deficit (mm)","Soil
Water 1 (mm)","Soil Water 2 (mm)","Soil Water 3 (mm)","Soil Water 4 (mm)","Crop
Stage","Leaf Area Index (cm2/cm2)","Crop Cover (%)","Dry Matter (kg/ha)","Root
Depth (mm)","Water Stress Index","Temperature Index","Crop Residue (kg/ha)","Residue
Cover (%)","Soil Erosion (t/ha)","Minimum Temperature (oC)","Maximum Temperature
(oC)","Solar Radiation (MJ/m2)","Pan Evaporation (mm)","Runoff Curve Number"
1, 1,1987, 0, 0, 18.00, 0.00,
4.30, 5.20, 0.00,
0.55, 252.95, 0.00, 23.00,
42.00, 187.95, 0.00, 0.00,
0.00, 0.00, 0.00,
0.00, 0.00, 0.00,
0.00, 0.00, 3.09, 16.50,
29.50, 21.00, 5.20, 73.
2, 1,1987, 0, 0, 0.00, 0.00,
0.00, 4.60, 0.00,
0.51, 247.84, -7.95, 18.40, 42.00,
187.44, 0.00, 0.00,
0.00, 0.00, 0.00,
0.00, 0.00, 0.00,
0.00, 0.00, 0.00, 17.00,
29.50, 19.00, 5.80, 73.
3, 1,1987, 0, 0, 4.00, 0.00,
0.00, 4.00, 0.00,
0.48, 247.36, -2.84, 18.40, 42.00,
186.96, 0.00, 0.00,
0.00, 0.00, 0.00,
0.00, 0.00, 0.00,
0.00, 0.00, 0.00, 17.50,
27.00, 24.00, 6.40, 73.
4, 1,1987, 0, 0, 0.00, 0.00,
0.00, 2.31, 0.00,
0.45, 244.59, -2.36, 16.09, 42.00,
186.51, 0.00, 0.00,
0.00, 0.00, 0.00,
0.00, 0.00, 0.00,
0.00, 0.00, 0.00, 11.50,
28.50, 26.00, 6.40, 73.
5, 1,1987, 0, 0, 0.00, 0.00,
0.00, 1.42, 0.00,
0.42, 242.76, 0.41, 14.67,
42.00, 186.09, 0.00, 0.00,
0.00, 0.00, 0.00,
0.00, 0.00, 0.00,
0.00, 0.00, 0.00, 12.50,
30.00, 29.00, 7.00, 73.
6, 1,1987, 0, 0, 0.00, 0.00,
0.00, 1.12, 0.00,
0.39, 241.24, 2.24, 13.54,
42.00, 185.70, 0.00, 0.00,
0.00, 0.00, 0.00,
0.00, 0.00, 0.00,
0.00, 0.00, 0.00, 14.00,
33.50, 30.00, 8.40, 73.
.
.
.
Top
-------------------------------------------
PERFECT Monthly
File Format (monthly.asc)
-------------------------------------------
"Day",
"Month", "Year", "Rainfall (mm)", "irrigation (mm)", "Runoff (mm)", "Soil
Evaporation (mm)", "Transpiration (mm)", "Drainage (mm)", "Soil Water (mm)",
"Leaf Area Index (cm2/cm2)", "Crop Cover (%)", "Dry Matter (kg/ha)", "Crop
Residue (kg/ha)", "Residue Cover (%)", "Soil Erosion (t/ha)", "Minimum
Temperature (oC)", "Maximum Temperature (oC)", "Solar Radiation (MJ/m2)",
"Pan Evaporation (mm)"
31,
1, 1957, 81.0, 0.0, 3.7, 71.2, 0.0,
12.9, 238.2, 0.0, 0.0, 0.0, 0.0,
0.0, 2.3, 18.1, 31.7, 23.6,
5.9
28,
2, 1957, 27.0, 0.0, 0.0, 32.2, 0.0,
6.8, 226.2, 0.0, 0.0, 0.0, 0.0,
0.0, 0.0, 18.5, 31.1, 20.8,
5.3
31,
3, 1957, 56.0, 0.0, 0.0, 41.9, 0.0,
4.2, 236.1, 0.0, 0.0, 0.0, 0.0,
0.0, 0.0, 15.5, 30.1, 19.8,
4.8
30,
4, 1957, 14.0, 0.0, 0.0, 22.7, 0.0,
3.8, 223.6, 0.0, 0.0, 0.0, 0.0,
0.0, 0.0, 13.6, 29.2, 17.0,
4.4
31,
5, 1957, 0.0, 0.0, 0.0, 9.6,
0.0, 0.5, 213.5, 0.0, 0.0, 0.0,
0.0, 0.0, 0.0, 5.3, 23.4,
15.3, 3.2
30,
6, 1957, 31.0, 0.0, 0.0, 18.3, 0.0,
0.1, 226.1, 0.0, 0.0, 0.0, 0.0,
0.0, 0.0, 6.4, 21.2, 11.8,
2.1
.
.
.
Top
-----------------------------------------
PERFECT Yearly
File Format (annual.asc)
-----------------------------------------
"Day",
"Month", "Year", "Rainfall (mm)", "irrigation (mm)", "Runoff (mm)", "Soil
Evaporation (mm)", "Transpiration (mm)", "Drainage (mm)", "Soil Water (mm)",
"Leaf Area Index (cm2/cm2)", "Crop Cover (%)", "Dry Matter (kg/ha)", "Crop
Residue (kg/ha)", "Residue Cover (%)", "Soil Erosion (t/ha)", "Minimum
Temperature (oC)", "Maximum Temperature (oC)", "Solar Radiation (MJ/m2)",
"Pan Evaporation (mm)"
31, 12, 1957, 368.0, 0.0, 5.8, 357.6,
0.0, 40.9, 208.6, 0.0, 0.0,
0.0, 0.0, 0.0, 3.8, 11.7,
27.4, 19.3, 4.7
31, 12, 1958, 760.0, 0.0, 115.6, 311.7, 413.9,
0.0, 127.4, 2.3, 75.0, 764.7,
0.0, 0.0, 61.6, 12.7, 26.6, 18.0,
4.6
31, 12, 1959, 742.0, 0.0, 72.6, 317.2,
365.1, 0.0, 114.5, 3.9, 100.0, 4757.2,
0.0, 0.0, 16.5, 11.7, 25.8, 17.7,
4.3
31, 12, 1960, 450.0, 0.0, 0.0, 294.9,
209.3, 0.0, 60.3, 2.7,
89.0, 2581.7, 0.0, 0.0, 0.0, 11.0,
26.2, 18.7, 5.0
31, 12, 1961, 570.0, 0.0, 17.1, 221.9,
311.0, 0.0, 80.3, 3.2, 100.0,
6819.0, 0.0, 0.0, 0.6, 11.0,
25.9, 18.4, 4.9
31, 12, 1962, 653.0, 0.0, 20.3, 223.6,
401.2, 0.0, 88.2, 0.1,
3.2, 25.5, 0.0, 0.0, 12.1, 11.3,
26.1, 17.8, 4.6
.
.
.
Top
---------------------------------
APSIM Daily
File Format (out.*)
---------------------------------
Summary_file = saved\sum.005
Title = dalby wheat
Date
day rain radn maxt
mint drain es esw
runoff residue_cover residue_wt iwh_lai
iwh_yield
( )
(day) (mm) (MJ/m2) (oC) (oC)
(mm) (mm) (mm) (mm)
(m^2/m^2) (kg/ha) (m2/m2)
(g/m2)
1/01/1988
1 0.200 20.740 33.000 17.400
0.000 5.014 250.286 0.000
0.174 478.424
0.000 0.000
2/01/1988
2 0.000 23.430 33.800 23.000
0.007 3.972 246.306 0.000
0.170 465.887
0.000 0.000
3/01/1988
3 0.000 23.790 32.500 21.000
0.014 1.614 244.678 0.000
0.169 461.495
0.000 0.000
4/01/1988
4 34.000 19.140 30.800 19.700 0.021
4.625 271.900 2.131 0.160
435.267 0.000
0.000
5/01/1988
5 2.000 17.110 28.200 19.200
0.027 3.763 270.110 0.000
0.152 413.031
0.000 0.000
6/01/1988
6 0.000 22.720 29.000 17.800
0.033 3.133 266.944 0.000
0.148 400.916
0.000 0.000
.
.
.
Top
---------------------------------------------
SILO Daily File
Format (OLD FORMAT) (*.sil)
---------------------------------------------
Statio|Year| M| D|
Max| S| Min| S| Rain| S| Evap| S| Rad| S| VP| S
Patched data for station
40123
40123|1999| 1|
1| 23.0|25| 19.5|25| 18.0| 0| 3.2|25| 11.0|25|23.0|25
40123|1999| 1|
2| 23.5|25| 19.5|25| 21.0| 0| 3.8|25| 10.0|25|25.0|25
40123|1999| 1|
3| 26.0|25| 18.0|25| 42.0| 0| 3.0|25| 12.0|25|24.0|25
40123|1999| 1|
4| 26.0|25| 19.5|25| 25.5| 0| 2.2|25| 13.0|25|25.0|25
40123|1999| 1|
5| 26.5|25| 19.5|25| 0.0| 0| 2.4|25| 24.0|25|22.0|25
.
.
.
Top
--------------------------------
SILO Daily File
Format (*.sil)
--------------------------------
"17701231" 365
-99.9 999 -99.9 999 9999.9 999 999.9 999 999.9 999 999.9 999
9999.9 9999.9 31/12/1770
""
" This file is SPACE
DELIMITED for easy import into both spreadsheets and programs."
"The first line 17701231
contains dummy data and is provided to allow spreadsheets to sense the
columns"
" To read into a spreadsheet
select DELIMITED and SPACE."
" "
" "
"=========
The following essential information and notes should be kept in the data
file =========="
"
"
"The
Data Drill system and data are copyright to the Queensland Govt, Department
of Natural Resources."
"This
data is supplied to the licencee only and may not be given, lent, or sold
to any other party"
"
"
"Notes:"
"
* Data Drill for Lat, Long: -27.00 150.00 (DECIMAL DEGREES), 27 00'S 150
00'E Your Ref: Sample"
"
* Extracted from Silo on 20010702"
"
* Please read the documentation on the datadrill at http://www.dnr.qld.gov.au/silo"
"
"
"
* As evaporation is read at 9am, it has been shifted to the day before"
"
ie The evaporation measured on 20 April is in row for 19 April"
"
* The 6 Source columns Smx-Svp indicate the source of the data to their
left"
"
25 = interpolated daily observations, 75 = interpolated long term average"
"
* Relative Humidity has been calculated using 9am VP, T.Max and T.Min"
"
RHmaxT is estimated Relative Humidity at Temperature T.Max"
"
RHminT is estimated Relative Humidity at Temperature T.Min"
"
* The accuracy of the data depends on many factors including date, location,
and variable"
"
for consistency data is supplied using one decimal place, however it is
not accurate to that precision."
"
Further information is available from http://www.dnr.qld.gov.au/silo"
" "
Date
Day T.Max Smx T.Min Smn Rain
Srn Evap Sev Radn Ssl
VP Svp RHmaxT RHminT Date2
(yyyymmdd)
( ) (oC) ( ) (oC) ( ) (mm)
( ) (mm) ( ) (MJ/m2) () (hPa)
( ) (%) (%) (ddmmyyyy)
19990620
171 20.0 25 -1.5 25
0.0 25 1.8 25 15.0
25 8.0 25 34.2
100.0 20/06/1999
19990621
172 20.5 25 -1.5 25
0.0 25 2.4 25 13.0
25 8.0 25 33.2
100.0 21/06/1999
19990622
173 21.5 25 -1.0 25
0.0 25 2.0 25 14.0
25 8.0 25 31.2
100.0 22/06/1999
19990623
174 19.5 25 1.0 25
0.0 25 2.6 25 12.0
25 8.0 25 35.3
100.0 23/06/1999
19990624
175 20.0 25 7.0 25
6.0 25 1.8 25 13.0
25 11.0 25 47.1
100.0 24/06/1999
.
.
.
Top
--------------------------------
IQQM Daily File
Format (out.*)
--------------------------------
Title: IQQM data file(IQQM
IO format )
Date:10/03/2000 Time:11:51:38.96
Site : NS1 Irrigator
(Node No. 14)
Type : Natural Flow
Units: ML/d
Date : 01/10/1890 to
30/09/1997 Interval : Daily
Year:1890
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
01 02 03 04 05
06 07 08 09 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25
26 27 28 29 30
31 Total
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Jan -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1?
Feb -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1?
-1?
Mar -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1?
Apr -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1?
-1?
May -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1?
Jun -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1?
-1?
Jul -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1?
Aug -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1?
Sep -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1? -1? -1?
-1? -1? -1? -1? -1? -1?
-1?
Oct 226
324 342 330 306 285 262 456 386
297 255 227 205 782 837 717
633 559 494 535 6490 2984 1145 952 906
789 704 632 573 517 471 24622
Nov 426
386 352 319 291 265 243 223 204
188 173 158 2218 12186 6827 3627 2530 1997 1699 1473 1313 1178
1060 958 868 788 719 656 602
550 44477
Dec 506
466 436 400 366 345 316 294 275
258 236 221 208 192 186 184
165 150 137 130 434 359 261 188
155 136 121 161 176 605 385
8452
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-1?
Year:1891
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
01 02 03 04 05
06 07 08 09 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24
25 26 27 28 29
30 31 Total
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Jan 313
282 253 226 202 184 165 146
133 5858 10740 9817 8775 9568 12114 17675 10730 7431 7290 5345 11161 11194
7823 11201 8885 6971 5393 4262 3556 2996 2555 183245
Feb 2211 1940 1728 7117
12068 9509 6793 5020 3921 3152 2604 2225 1945 1725 1542
1395 1270 1159 1061 970 891 818
1129 946 759 661 597 552
75708
.
.
.
Top
--------------------------------------
IQQM Daily File
2-Col Format (out.*)
--------------------------------------
NS8.IRR
Crop depletion
mm
01/01/1890
126.4
02/01/1890
130.8
03/01/1890
135.4
04/01/1890
139.7
05/01/1890
143.1
06/01/1890
147.6
.
.
.
Top
----------------------------------
IQQM Monthyl
File Format (out.*)
----------------------------------
Glenlyon Dam
Current Storage
ML
10/1890 7796628.0
11/1890 7603182.0
12/1890 7775485.0
01/1891 7951708.0
02/1891 7141308.0
03/1891 7797833.0
.
.
.
Top |