| Database Table |
| KWS & KWS_TIER.PAT |
| Database: | info | Instance: | Type: | pat | Application: |
| Description: | KEY WATERSHED |
| Location: | /fsfiles/ref/library/gis |
| Field and Code Definitions |
| Column | Description | Key | Type | Length | Precision | Scale | Null |
| kws_id | N | c | 1 |
| Code | Description |
| C | CALIFORNIA | O | OREGON | W | WASHINGTON |
| kws_id | N | c | 2 |
| Code | Description |
| F | FISH (SPECIES LISTED IN GANG REPORT, APP D) |
| kws_id | N | c | 3 |
| Code | Description |
| - | DASH SEPARATOR |
| kws_id | N | n | 5 |
| Code | Description |
| NN | SYSTEM GENERATED NUMBER |
| kws_name | N | c | 75 |
| Code | Description |
| NAME | KEY WATERSHED NAME (LISTED IN FEMAT V-H) |
| kws_own | N | c | 5 |
| Code | Description |
| BLM | BLM KEY WATERSHED | NF | USFS KEY WATERSHED |
| kws_tier | N | n | 1 |
| Code | Description |
| 1 | TIER 1 KEY WATERSHED | 2 | TIER 2 KEY WATERSHED |