-------------------------------------------------------------------------------- File clim_xx_queryParams.txt Summary of query parameters. QRY_NO: unique query number USER_ID: your ID number - mapped to your username/password TITLE: your query name. Defaults to Qxx where xx is the qry_no DATE_OF_ENTRY: date submitted MIN_LAT: | MAX_LAT: |defines latitude longitude extents MIN_LON: | MAX_LON: | MIN_DATE: defaults to 01/01/1900 MAX_DATE: defaults to current date MIN_MONTH: defaults to 1 MAX_MONTH: defaults to 12 AREA_NAME: polygon name if specified DEPTH: depth ranges of form value +/-range i.e 0,5,10,5 GEN_STATS: not implemented KEEP_STATS:T(rue) if requested statistics KEEP_JOIN: T(rue) if requested individual data values STN_INDEX: T(rue) if requested station index LAT_BLOCK: latitude blocking if requested LON_BLOCK: longitude blocking if requested TEM_SAL: T(rue) if requested only records containing temperature and salinity BIN_AVG: T(rue) if requested bin averaging AREA_TYPE: R if rectangle, A if polygon area -------------------------------------------------------------------------------- File clim_xx_j.qry Complete profile data Datafile Structure: Column Name Ending Column ========================================= AREA_NAME 30 :polygon name or RECT (for rectangle) STN_ID 40 :unique station identifier DEPTH 50 :nominal bin depth from your query criteria PRESSURE 60 :actual pressure (db) of observation CRUISE_DATE 70 :DD/MM/YYYY of observation YEAR 80 : MONTH 90 : MIN_LATITUDE 100:minimum latitude of query box (used to identify blocking sub-areas) MIN_LONGITUDE 110:minimum longitude of query box (used to identify blocking sub-areas) LATITUDE 120:actual latitude of observation LONGITUDE 130:actual longitude of observation TEMPERATURE 140:deg C SALINITY 150:psu SIGMAT 160:computed sigma-t (only if both temperature and salinity exist) -------------------------------------------------------------------------------- File clim_xx_a.qry Time series statistics Datafile Structure: Column Name Ending Column ========================================= AREA_NAME 31 :polygon name or RECT (for rectangle) DEPTH 42 :nominal bin depth from your query criteria YEAR 53 : MONTH 64 : MIN_LATITUDE 75 :minimum latitude of query box (used to identify blocking sub-areas) MIN_LONGITUDE 86 :minimum longitude of query box (used to identify blocking sub-areas) MIN_TEMPERATURE 97 :| MAX_TEMPERATURE 108 :|temperature statistics AVG_TEMPERATURE 119 :| CNT_TEMPERATURE 130 : statistics sample size MIN_SALINITY 141 :| MAX_SALINITY 152 :|salinity statistics AVG_SALINITY 163 :| CNT_SALINITY 174 : statistics sample size MIN_SIGMAT 185 :| MAX_SIGMAT 196 :|sigma-t statistics AVG_SIGMAT 207 :| CNT_SIGMAT 218 : statistics sample size STD_TEMPERATURE 229 :| STD_SALINITY 240 :|standard deviation about AVG_xxx STD_SIGMAT 251 :| -------------------------------------------------------------------------------- File clim_xx_b.qry Seasonal Cycle Datafile Structure: Column Name Ending Column ========================================= AREA_NAME 30 :polygon name or RECT (for rectangle) DEPTH 40 :nominal bin depth from your query criteria MONTH 50 : MIN_LATITUDE 60 :minimum latitude of query box (used to identify blocking sub-areas) MIN_LONGITUDE 70 :minimum longitude of query box (used to identify blocking sub-areas) MIN_TEMPERATURE 80 :| MAX_TEMPERATURE 90 :|temperature statistics AVG_TEMPERATURE 100 :| STDDEV_TEMPERATURE 110 :| CNT_TEMPERATURE 120 : number of data months (sample size) for statistics TOT_TEMPERATURE 130 : total number of observations over all years for the month MIN_SALINITY 140 :| MAX_SALINITY 150 :|salinity statistics AVG_SALINITY 160 :| STDDEV_SALINITY 170 :| CNT_SALINITY 180 : number of data months (sample size) for statistics TOT_SALINITY 190 : total number of observations over all years for the month MIN_SIGMAT 200 :| MAX_SIGMAT 210 :|sigma-t statistics AVG_SIGMAT 220 :| STDDEV_SIGMAT 230 :| CNT_SIGMAT 240 : number of data months (sample size) for statistics TOT_SIGMAT 250 : total number of observations over all years for the month -------------------------------------------------------------------------------- File clim_xx_i.qry Station index (all parameters are self explanatory) Datafile Structure: Column Name Ending Column ========================================= AREA_NAME 30 :polygon name or RECT (for rectangle) STN_ID 40 CRUISE_ID 50 LATITUDE 60 LONGITUDE 70 CRUISE_DATE 80 DD/MM/YYYY CRUISE_TIME 90 MAXIMUM_DEPTH 100