removed a column id and added a column city from table weathers
adjusted views