HDMS Wiki Home

  • UnrecognizedWatershedCodes
    		•  Last edited by Margaret_Ormes on May 19, 2003 12:23 pm

    The "Watershed" QC

    Watershed values in the HDMS are constrained by entries in the D_WATERSHED domain table.

    This procedure is not finalized.

    As a QC procedure, use the NHCD_WATERSHED symbolic field for comparison purposes as it should help discover typographical errors in the data. However, for some programs, nearly all if not all WATERSHED values will fail because the WATERSHED code system is not the same as the one used for the Central BCD conversion. In those cases, the expected procedure is to accept the standard codes used in that program into their Biotics 4 database.

    The D_WATERSHED domain table has been populated with all the 8-digit codes for the entire U.S., Puerto Rico, and Virgin Islands, so there will be no need to populate the table from those BCDs. The "standard" watershed codes are 8 digits long, but there are more precise longer codes--11 digits. Those Heritage Programs who wish to retain their 11-digit watershed codes will have to load them into the D_WATERSHED domain table prior to the conversion. In addition, they may have to modify the conversion spreadsheet to change the mapping from NHCD_WATERSHED to WATERSHED.

    Note that the conversion by default will load new items into the D_WATERSHED table. However, where possible, clean up those records that are clearly bad data so that the D_WATERSHED table does not get loaded up with bad domain records.

    QC Procedure:

    In EOR:

    1. SELECT EOR WITH WATERSHED NOT EQ NHCD_WATERSHED
    2. LIST EOR WATERSHED NHCD_WATERSHED
    3. If you like what you see (or no records were found), you don't have to do anything else.

    In SBR:

    1. SELECT SBR WITH WATERSHED NOT EQ NHCD_WATERSHED
    2. LIST SBR WATERSHED NHCD_WATERSHED
    3. If you like what you see (or no records were found), you don't have to do anything else.

    Back to DataQc