How to subset() from data frame using specific rows

You asked for pointers, and didn't provide a reproducible example, so I
offered a pointer.

Sarah,

   I did not realize that your pointer was to the factor component of the
subset() command.

   I think the most parsimonious thing for me to do is to modify the database
table with a new column of the full stream name, then re-export and re-read
into R.

Thanks,

Rich