| 1 -- FloodWatchCategory = 'High Risk' AND DebrisProne = 'NO' |
| 2-- FloodWatchCategory = 'High Risk' AND DebrisProne = 'YES' |
| 3 -- FloodWatchCategory = 'Moderate Risk' AND DebrisProne = 'NO' |
| 4 -- FloodWatchCategory = 'Moderate Risk' AND DebrisProne = 'YES' |
| 5 - FloodWatchCategory = 'Removed' AND DebrisProne = 'NO' |
| 6 - FloodWatchCategory = 'Removed' AND DebrisProne = 'YES' |
| 7 -- FloodWatchCategory is NULL AND DebrisProne = 'YES' |