if there's no discernable location associated with the tweet, drop down and use the location associated with the profile.
write default "U" to vetted field.