NRCS Logo United States Department of Agriculture Natural Resources Conservation Service National Water and Climate Center
CDBS Logo

Centralized
DataBase System
Reference Card

A Water Supply Forecasting
Product for Users of the
Centralized Forecasting System


Table of Contents

Background

Communications

Getting Started

Searching for Data

Modifying a Search

After the Searching is Over

Other Helpful Commands

Leaving CDBS

An Actual Session on CDBS

Who Do You Contact for More Help?

Additional Information


Background

The Centralized Forecasting System (CFS) is a series of interactive computer programs that collect, analyze, store, and make available water supply forecast data. The Centralized DataBase System (CDBS), an integral part of CFS, contains historic data for snow course, SNOTEL, streamflow, monthly precipitation, reservoir storage and NOAA climatic values (daily temperature and precipitation for selected stations in the western states).

While much of the information available from CFS is accessible from the National Water and Climate Center Web Pages, there is still some valuable information that can only be retrieved from CFS -- including historical data contained in CDBS. Access to CFS (and therefore, CDBS) is free to anyone needing snow survey and water supply forecasting related information. All that is required is that you complete and return a CFS Access Agreement. Access agreements are available from your state Snow Survey & Water Supply Forecasting Program contact if you live in the West (Alaska, Arizona, California, Colorado, Idaho, Montana, Nevada, New Mexico, Oregon, Utah, Washington, and Wyoming) or from the National Water and Climate Center for those of you who live outside of the Western U.S.


Communications

CFS can be accessed via the Internet or by dial-up modem.


Internet

Internet Address (telnet and ftp):
      wcc.nrcs.usda.gov


Dial-Up Modem

Parameters:
      Parity       None
      Data Bits       8
      Stop Bits       1
      Echo       Off


System Status

A recorded message concerning System Status can be reached at:
     (503) 414-3199


Getting Started

From the CFS Main Menu, type:
     CFS DATABASE DBQ


Searching for Data

Searches must be initiated using the following format:
     find [keyword] [descriptor]

Once a search has been initiated using find, use:
     and [keyword] [descriptor]
to refine the search;
     or [keyword] [descriptor]
to expand the search.


find or f

Used to begin all searches. You can also use f in place of find.
     find state nv
     f state nv
Initiates the search by looking for all data in Nevada.


and

Used to refine searches.
     find state nv and county humboldt
Refines the search by looking for sites found in Humboldt County, Nevada.


or

Used to expand searches.
     find state nv or state ca
Expands the search by looking for sites found in Nevada or California.


Keyword datatype or dt

Refers to the type of data, including:
      clim       daily NOAA climate data
      resd       daily reservoir data
      snot       daily SNOTEL data
      strd       daily streamflow data
      prec       monthly precipitation data
      resv       monthly reservoir data
      snow       monthly snow course data
      strm       monthly streamflow data
Temperature data can be found in snot and clim sites.
     find datatype prec
     find dt prec
Searches for all monthly precipitation sites.


Keyword state

Can be a state name, two-character state abbreviation, or state FIPS (Federal Information Processing System) code.
     find state nevada
     find state nv
     find state 32
Searches for all sites in Nevada.


Keyword county

County name or combination of 2-digit state and 3-digit county FIPS codes. When using the county name, also use the state to avoid confusion with other counties of the same name in other states.
     find county humboldt and state nv
     find county 32013
Searches for all sites in Humboldt County, Nevada.


Keyword station

CFS or other site identification.
     find station 10J04S
Searches for all sites with 10J04S as its site identification.


Keyword sitename

Site name. Must be an exact match unless it is used with a wildcard. Names consisting of three or more words must be enclosed in quotation marks (").
     find sitename marlette lake
Searches for all sites with the name Marlette Lake.
     find sitename "wildrose ranger stn"
Searches for all sites with the name Wildrose Ranger Stn.


Keyword huc

8-digit hydrologic unit code. Searches can also be done using 2-digit increments of the huc.
     find huc 16
Searches for all sites in the Great Basin
     find huc 1604
Searches for all sites in the Black Rock Desert-Humboldt River Basin
     find huc 160401
Searches for all sites in the Humboldt River Basin
     find huc 16040105
Searches for all sites in the Middle Humboldt


Keyword elevation or elev

Elevation in feet. Searches are displayed in increments of 1000 feet.
     find elevation 1500
     find elev 1500
     find elevation 1999
     find elev 1999
     find elevation 1000
     find elev 1000
Searches for all sites with an elevation of 1000-1999 feet.


Keyword latitude or lat

Latitude in degrees. Searches are conducted in increments of whole degrees.
     find latitude 33
     find lat 33
Searches for all sites found between latitude 33'00" and 33'59".


Keyword longitude or long

Longitude in degrees. Searches are conducted in increments of whole degrees.
     find longitude 113
     find long 113
Searches for all sites found between longitude 113'00" and 113'59".


Wildcard *

A special character that can be used in station or sitename descriptors to represent any character or any group of characters. You must have at least two characters before the *.
     find sitename ma*
Searches for sites whose names begin with "ma", such as Marlette Lake.


Wildcard ?

A special character that can be used in station or sitename descriptors to represent any single character. You must have at least 2 characters before the first ?.
     find station 10J0?
Searches for sites with a 5-character station id beginning with 10J0, such as 10J01, 10J02, and 10J03.


Wildcard [ ]

These brackets allow you to substitute a range of numbers or characters for any single character within a station or sitename descriptor. You must have at least 2 characters before the first set of brackets.
     find station 10J0[1-3]
     find station 10J0[1,2,3]
Searches for sites with 10J01, 10J02, and 10J03 as their station id.


Example Searches

     find state wa and county chelan and datatype prec
Searches for all monthly precipitation sites in Chelan County, Washington

     find huc 130100 and datatype snot
Searches for all SNOTEL sites in the Rio Grande Headwaters

     f datatype clim and lat 41 and long 123
Searches for all NOAA climate stations between latitude 41'00"-41'59" and longitude 123'00"-123'59"

     f sitename marl* and dt snow
Searches for all snow course sites with names that begin with "marl"

     f state mt or state wy and dt strm
Searches for all monthly streamflow stations in Montana or Wyoming

     f state nv and county elko and dt resv and elev 9000
Searches for all monthly reservoir stations in Elko County, Nevada located from 9000-9999 feet in elevation


Modifying a Search

To see how these next commands work, assume the following search has been initiated:
     find county humboldt and state nv and elev 6000 and dt snow


ccl

Use ccl at the cdbs prompt (cdbs ::) to list the current search commands.
     cdbs :: ccl
Generates output that looks something like this:
      find       county       humboldt
      and       state       nv
      and       elev       6000
      and       dt       snow


backup or oops

Use backup or oops to move backwards in the search criteria one step. Or use backup # or oops # to move backwards in the search criteria # number of steps.
     cdbs :: backup [or oops]
     cdbs :: ccl
           find       county       humboldt
           and       state       nv
           and       elev       6000
     cdbs :: backup 2 [ or oops 2]
     cdbs :: ccl
           find       county       humboldt
Note: Each time a backup or oops command is given, the search is reinitiated using the remaining search criteria.


history or hist

Use history or hist to display all commands issued since the last find command.
     cdbs :: history [or hist]
           find       county       humboldt
           ccl


After the Searching is Over

After conducting the search, you can:


Data Lists

list or l       displays a list of sites on the screen
flist       writes a list of sites to a file
listbyid       displays a list of sites, sorted by site identification, on the screen
flistbyid       writes a list of sites, sorted by site identification, to a file
listbyname       displays a list of sites, sorted by name, to the screen
flistbyname       writes a list of sites, sorted by name, to a file

Data Output

table       generates a tabular report containing data for each site selected by the user in an 80-column format
table132       generates a tabular report containing data for each site selected by the user in a 132-column format
cards       generates machine-readable output for PRELUDE, WATSTOR, TK, and tab-separated formats
Note: Selections for data output must be done using the most current data list.
Note: If you have selected multiple clim or snot sites for output, use s to skip to the next station at the sensor prompt.

Data Analysis

colsum       Provides a summary of monthly data in ascending, descending or chronological order and frequency analysis for individual sites
compute       Provides various calculations of site data, including mean, median, standard deviation, and probability distribution
index       Provides a summary of monthly data and frequency analysis for a combination of sites
days       Uses data from NOAA climate stations to provide an analysis of the number of days that meet user-specified temperature and precipitation thresholds
frost       Uses data from NOAA climate stations to provide probabilities of the dates of the last frost in the spring and the first frost in the fall developed for 24, 28, or 32 degrees F.
growth       Uses data from NOAA climate stations to provide probabilities of the number of continuous days where temperatures will not fall below 24, 28, or 32 degrees F.
stats       Provides monthly total, average, maximum, and minimum values for daily data
taps       Uses data from NOAA climate stations to provide a summary and probability analysis of temperature and precipitation

Other Helpful Commands

commands       provides a list of all CDBS commands available
keys       provides a list of keywords and a description of each

Leaving CDBS

At the cdbs:: prompt, you can enter any of the following to leave CDBS:
      q       quit       done
      bye       exit       end


An Actual Session on CDBS

This is where any banner or news messages would appear.  In this
session,responses that you would normally enter will appear in the
following style:

	typical response


         Centralized Data Base System (CDBS)    (Version 1.14)  04/29/92

cdbs :: find state nv and county humboldt and dt snow

        525 stations found

        56 stations found

        13 stations found

cdbs :: list


 No. ST CTY Type      HUC  Station Lat. Long. Elev. Sitename
---- -- --- ---- -------- -------- ---- ----- ----- --------
   1 32 013 SNOW 17120008    19H01 4147 11937  6720 BALD MT.
   2 32 013 SNOW 16040109    17H02 4145 11732  6700 BUCKSKIN, LOWER
   3 32 013 SNOW 16040109   17H02S 4145 11732  6700 BUCKSKIN, LOWER SNOTEL
   4 32 013 SNOW 16040109    17H01 4147 11732  7200 BUCKSKIN, UPPER
   5 32 013 SNOW 16040201    18H01 4158 11812  6500 DISASTER PEAK
   6 32 013 SNOW 16040201   18H01S 4158 11812  6500 DISASTER PEAK SNOTEL
   7 32 013 SNOW 16040108    17J02 4054 11734  6560 GOLCONDA #2
   8 32 013 SNOW 16040109    17H04 4139 11724  7800 GRANITE PEAK
   9 32 013 SNOW 16040109   17H08S 4139 11724  7800 GRANITE PEAK SNOTEL
  10 32 013 SNOW 16040109    17H05 4131 11738  6000 LAMANCE CREEK
  11 32 013 SNOW 16040109   17H07S 4131 11738  6000 LAMANCE CREEK SNOTEL
  12 32 013 SNOW 16040109    17H03 4141 11732  6700 MARTIN CREEK
  13 32 013 SNOW 17050106    17H06 4100 11700  6300 QUINN RIDGE  AM

cdbs :: table


Select Number(s) (from listing  --  CR to leave)
: 12

Enter a file name to APPEND ALL selected tables to disk.
Press the RETURN key if you do not want this option.
        : (RETURN)

***  Type bye, done, q, or quit to skip over a site  ***

***  Type abort to return to :: prompt  ***

Precede a file name with append, or 'a' for appending mode
with blanks as separators between that and the file name

Station : 17H03, MARTIN CREEK

Enter a file name if output is to disk - CR if output is to terminal
                : (RETURN)
/odb/nv/snow32

Station : 17H03, MARTIN CREEK
-------

Unit = inches
year    January        February        March          April           May
     June
     date dep  swe  date dep  swe  date dep  swe  date dep  swe  date dep  swe
date dep  swe
     ---- --- ----- ---- --- ----- ---- --- ----- ---- --- ----- ---- --- -----
---- --- -----
32-1                               3/04 033  13.3
33-1                               3/01 020   6.5
34-1                               3/02 021   6.4

35-1                               3/07 030   7.9
36-1                               3/03 030   9.4
37-1                               2/28 023   7.0
38-1                               3/01 030   8.9
39-1                               3/04 029   6.3

40-1                               2/28 024   7.9
41-1                               2/28 029   9.0 3/29 022   8.1
42-1                               3/03 033   9.5 3/31 029   9.8
43-1                               3/01 032  11.9 4/02 021   8.4
44-1                               2/23 030   4.3 3/24 026   8.4

45-1                               3/01 026   8.1 3/27 043  13.4
46-1                               3/03 030   7.2 4/07 027   7.8
47-1                               2/28 011   3.8 3/31 002   1.1
48-1                               2/28 018   6.8 4/01 028   9.7
49-1                               3/01 027   7.5 4/02 026   8.6

50-1                               2/28 022   7.3 4/06 024   8.7
51-1                               2/25 034   9.2 4/01 016   6.1
52-1                               3/01 053  21.2
53-1                               2/24 021   6.8 4/01 011   4.4
54-1                               2/24 018   5.6 3/30 015   4.9

55-1                               3/02 021   6.5 3/29 016   4.9
56-1                1/31 033  10.0 3/01 033  10.8 4/02 023   9.1
57-1                2/01 019   4.2 2/27 017   6.5 3/29 020   8.4
58-1                1/31 026   6.8 2/25 027   9.1 4/02 039  14.2
59-1                1/30 019   4.2 2/25 030   7.9 4/01 020   7.7

60-1                1/27 022   4.9 3/01 031   9.0 3/29 019   8.6
61-1                1/26 016   4.2 2/27 018   6.2 3/27 019   6.1
62-1                1/31 021   6.0 2/28 039  12.5 3/28 042  15.2
63-1                2/05 000   0.0 2/25 000   0.0 3/27 000   0.0
64-1                1/30 024   5.5 2/25 025   6.6 3/26 037  10.2

65-1                1/28 029  10.0 2/25 025  10.4 3/30 021  10.0
66-1                1/31 021   4.0 2/23 024   6.3 3/28 020   7.0
67-1                1/30 037  12.2 2/23 036  12.7 3/27 033  12.3
68-1                2/01 028   5.8 2/29 015   5.2 3/27 013   4.8
69-1                1/30 052  16.2 2/24 061  19.8 3/26 054  22.5

70-1                1/28 025   8.3 2/24 025   9.3 3/26 026   9.8
71-1                1/28 019   7.3 2/23 020   7.1 3/29 019   8.1
72-1                1/25 030   9.0 2/25 041  10.9 3/30 001   0.1
73-1                1/29 029   7.3 2/28 032   9.3 3/27 034   9.3
74-1                1/28 027   7.4 3/05 029   9.0 3/28 023   6.3

75-1                               2/25 041  12.8 E/ST      18.5
76-1                               2/23  17   4.1 3/30  25   8.3
77-1                               2/24  11   2.3 3/30  16   4.3
78-1                               2/28  37  11.8 3/27  27  11.9
79-1                               2/27  32   6.6 3/26  23   6.9

80-1                               2/26  35  11.2 3/26  45  11.4
81-1                2/03  17   3.6 2/27   9   2.3 3/25   5   1.7
82-1                1/29 036  10.1 2/25 021   8.6 E/ST      11.5 4/23 017   7.4
83-1 1/01  42  10.1                2/22  51  17.8 3/28  60  23.2
84-1 1/01      10.3 1/31  33  11.3 2/18  50  16.8 4/03  46  17.0

85-1 1/01  21   4.8 2/01  28   9.4 3/01  31   9.4 3/20  40  10.9
86-1                E/ST       6.6 2/27  35  12.7
87-1 E/ST       2.0 E/ST       3.4 2/27  32   8.4 4/01  22   8.0
88-1 E/ST       2.9                2/23  17   4.9 3/31   6   2.4 E/ST   0   0.0
89-1 E/ST       6.6                2/23  41  13.5 3/30  33  12.9


FIRST OF MONTH MEASUREMENTS
average depth and swe :
           32   6.1       26   7.1       28   8.8       25   9.0        9   3.7

years       2     6       23    25       58    58       45    47        2     2
       0     0
1961-1990 average :
           32   6.1       26   7.4       29   9.3       27   9.7        9   3.7

years       2     6       18    20       29    29       26    28        2     2
       0     0


NOTES: -O/dd - October, J/dd - November, K/dd - December, E/ST - estimate
       -Card type 1 = First of Month, 2 = Mid-month, and 3 = Special Measurement


Station : 17H03, MARTIN CREEK

Enter a file name if output is to disk - CR if output is to terminal
                : q

cdbs :: ccl

        f       state           nv
        and     county          humboldt
        and     datatype        snow

cdbs :: oops

        525 stations found

        56 stations found

cdbs :: ccl

        f       state           nv
        and     county          humboldt

cdbs :: and dt clim

        19 stations found

cdbs :: and sitename wi*

        1 stations found


cdbs :: list


 No. ST CTY Type      HUC  Station Lat. Long. Elev. Sitename
---- -- --- ---- -------- -------- ---- ----- ----- --------
   1 32 013 CLIM 16040108     9171 4054 11748 04300 WINNEMUCCA WSO AIRPORT

cdbs :: taps


Select Number(s) (from listing  --  CR to leave)
: 1

Enter a file name to APPEND ALL selected tables to disk.
Press the RETURN key if you do not want this option.
        : (RETURN)
Enter the beginning year [1929] 1961
Enter the ending year [1991] 1990

The selected years are from 1961 - 1990
Growing Degree Days Threshold (CR for default of 40 deg. F) : (RETURN)
Enter a file name if output is to disk - CR if output is to terminal
                : (RETURN)

TAPS Station : WINNEMUCCA WSO AIRPORT, 9171
start yr. - 1961   end yr. - 1990

          |              Temperature             |        Precipitation
          |--------------------------------------|----------------------------
          |     |     |     |2 years in 10|      |     |2 yrs in 10|
          |     |     |     |  will have  |  avg |     | will have |  average
          |-----|-----|-----|-------------|no. of|     |-----------| number of
  Month   | avg | avg | avg |  max |  min |grow'n| avg | less| more| days with
          |daily|daily|     | temp.| temp.|degree|     | than| than| 0.10 inch
          | max | min |     | >than| <than|days* |(in.)|(in.)|(in.)| or more
------------------------------------------------------------------------------
January   | 42.0| 16.8| 29.4|   63 |  -12 |   17 | 0.74| 0.26| 1.13|     2
February  | 48.9| 22.8| 35.8|   68 |   -5 |   44 | 0.62| 0.27| 0.92|     2
March     | 54.4| 25.2| 39.8|   75 |    6 |   86 | 0.78| 0.39| 1.11|     2
April     | 62.3| 29.5| 45.9|   85 |   11 |  198 | 0.84| 0.34| 1.26|     2
May       | 72.4| 37.7| 55.0|   94 |   19 |  470 | 0.83| 0.34| 1.41|     2
June      | 82.8| 45.9| 64.3|  102 |   28 |  729 | 0.86| 0.27| 1.44|     2
July      | 92.7| 51.2| 71.9|  104 |   35 |  988 | 0.27| 0.05| 0.51|     0
August    | 90.3| 48.7| 69.5|  103 |   33 |  913 | 0.45| 0.12| 0.86|     1
September | 80.1| 38.9| 59.5|   97 |   20 |  579 | 0.40| 0.11| 0.74|     1
October   | 68.1| 29.4| 48.7|   88 |   12 |  288 | 0.62| 0.18| 1.05|     1
November  | 52.3| 23.3| 37.8|   73 |    0 |   69 | 0.94| 0.37| 1.42|     3
December  | 42.7| 17.1| 29.9|   63 |  -13 |   18 | 0.88| 0.28| 1.36|     3
----------|-----|-----|-----|------|------|------|-----|-----|-----|----------
----------|-----|-----|-----|------|------|------|-----|-----|-----|----------
Yearly :  |-----|-----|-----|------|------|------|-----|-----|-----|----------
----------|-----|-----|-----|------|------|------|-----|-----|-----|----------
  Average | 65.7| 32.2| 49.0| ---- | ---- | ---- | --- | --- | --- |   ---
----------|-----|-----|-----|------|------|------|-----|-----|-----|----------
  Extreme |  108|  -37| --- |  105 |  -20 | ---- | --- | --- | --- |   ---
----------|-----|-----|-----|------|------|------|-----|-----|-----|----------
  Total   | --- | --- | --- | ---- | ---- | 4399 | 8.21| 6.54| 9.80|    21
----------|-----|-----|-----|------|------|------|-----|-----|-----|----------
------------------------------------------------------------------------------

     *A growing degree day is a unit of heat available for plant growth.
It can be calculated by adding the maximum and minumum daily temperatures,
dividing the sum by 2, and subtracting the temperature below which growth
is minimal for the principal crops in the area (Threshold :  40.0 deg. F)

----------

Press the RETURN key to see this station again,
otherwise enter q to return to the main CDBS prompt : q

cdbs :: q
cdbs wsfs.cp 13-OCT-92 10:43:52 288

Who Do You Contact for More Help?

State Contact E-Mail Phone
Alaska Rick McClure ambcs@ak.nrcs.usda.gov (907) 271-2424
Arizona Larry Martinez lmartine@azso.az.nrcs.usda.gov (602) 280-8841
California Marianne Hallet mhallet@ca.nrcs.usda.gov (530) 757-8305
Colorado Mike Gillespie mgillesp@co.nrcs.usda.gov (303) 236-2910 Ext. 235
Idaho Ron Abramovich rabramo@id.nrcs.usda.gov (208) 378-5740
Montana Roy Kaiser rkaiser@mt.nrcs.usda.gov (406) 587-6991
Nevada Dan Greenlee dgreenle@nvirm.nv.nrcs.usda.gov (702) 784-5878
New Mexico Dan Murray dmurray@nmso.nm.nrcs.usda.gov (505) 761-4436
Oregon Stanley Fox sfox@or.nrcs.usda.gov (503) 414-3266
Utah Randall Julander rjulande@utdmp.utsnow.nrcs.usda.gov (801) 524-5213
Washington Scott Pattee spattee@wa.nrcs.usda.gov (360) 428-7684 Ext. 141
Wyoming Dave Taylor dot@wyese.wy.nrcs.usda.gov (307) 261-6481
National Chris Pacheco cpacheco@wcc.nrcs.usda.gov (503) 414-3056

Additional Information

State Fips Codes:
      AK ... 02       AZ ... 04       CA ... 06
      CO ... 08       ID ... 16       MT ... 30
      NV ... 32       NM ... 35       OR ... 41
      UT ... 49       WA ... 53       WY ... 56


National Water & Climate Center Links:
Water Supply Forecasts | Climate | Snow | Water Sciences | Soil Climate Analysis Network
NWCC Home Page | Search | Site Map | E-Mail