Functionality description

  • Import from TXT,DBF to DBF files, output data export to TXT files, MS-Excel, other formats …
  • Adjusting data
    • creating cross-tables, restructuring to one data column
    • calculating monthly, seasonal and annual averages (sums, extremes)
    • calculating differences (ratios/log-ratios) between two series (e.g. tested and reference series)
    • replacing values, transformations
    • combining series, adjusting table structure etc.
  • Data transformations
    • standardization
    • differencing
    • filters
    • grid points calculation
  • Basic statistical characteristics computation
  • Correlation analysis
  • Finding outliers and extreme values (interquartile ranges)
  • Distribution fit testing, CDF, return period calculation
    • normal distribution
    • gamma distribution
    • generalized extreme value (GEV) distribution
       (output: CDF values, parameters of the distribution, fit test, values for P-P and Q-Q plot, etc.)
  • Further statistics: SPI, regional regression, RPI, …
  • Number of days characteristics (Daily data):
    • applying limit value, minimum number of consecutive days
    • getting count, percentage of days, effective or active sum, percentage of values
    • day frequencies, k-day periods, …
  • Data quality control by comparing base station to its neighbours (the same options as for reference series calculation, see further)
    • stations can be selected by combination of correlations, distances, difference in altitude, the same region
    • standardization to base station AVG, STD, or altitude
    • expected value calculation from neighbouring stations
  • Series reconstructions
    • finds near stations that can be used for combining (complementing) of missing periods
  • Reference series calculation
    • stations can be selected by combination of correlations, distances, difference in altitude, the same region
    • (weighted) average from the best correlated stations
    • (weighted) average from the nearest stations
    • (weighted) average of all stations available for a given year and month (within a given region)
    • standardization of neighbours to base station AVG, STD, altitude
       (output: reference series, information file with list of stations used for calculation – can be modified, etc.)
  • Connection with AnClim software (homogeneity testing done on the background)
  • Adjusting series for inhomogeneities
    • various statistics for decision making about suggested adjustments (correlations improvement, t-tests, STD change, regression, etc.)
    • smooting adjustments
    • tools for daily data adjustments (“delta” method, “variable” correction such as HOM, SPLIDHOM, …)
       (output: values – adjustments for each month, t-test, change in correlations after the adjustments, etc.)
  • Filling missing values:
    • from differences (ratios)
    • using linear regression
       (output: t and F test for periods to be used for filling missing values, etc.)
  • Tools for validation and correction of RCM (model) outputs:
    • calculating station technical series for given grid points
    • Bias,RMSE,MAE … characteristics
    • Comparing basic statistical characteristics of two datasets
    • frequencies distribution (of differences, …)
    • variable corrections of model outputs (based on percentiles, …)

  • Connection with R software:
    • launching of R scripts is available, thus you can prepare and process anything
       (ProClimDB prepares intput, calls R functions and then gets the output back into ProClimDB environment)
  • Connection with ESRI ArcView 3.2:
    • launching of ArcView (Avenue) scripts, so far available: getting point values from a Grid, calculating maps, summarize zones, converting ASC to Grid and back
       (ProClimDB prepares intput, calls ArcView functions and then gets the output back into ProClimDB environment, full automatization – e.g. for all days, months, years, …)
  • Connection with LoadData software (homogeneity testing done on the background)

  • Processing in batch mode:
    • all the needed tasks can be listed in a file and fulfilled by one button press. You just wait for the results …
    • this function can be also used to record and save all your functions processing and options settings