The purpose of lab 3 was to develop my skills in composing queries and using them to extract data from a database. Queries are extremely useful, and you can use them to find pretty much any specific information about a set of data that you want.
Part One: United States
For part one I worked with the US counties data. The first problem asked to write a multiple criteria query based on population statistics.
After selecting the counties successfully, I created a graduated color map of them by population.
The second problem was similar but more complex than the first. It required picking out states individually, creating a layer from them, and then creating another layer from the counties we selected based on the age and sex attributes. After some trial and error, I managed to pick out the right counties.
The next task was to add to the above map by adding counties from a few more states, and also adding a second criteria of counties with over 30,000 houses. The finished map came out like this:
Part Two: Wisconsin
The second part of the lab had me working with Wisconsin data, and writing more specific queries. The first asked for cities near lakes, and with a specific population and land area. It required two separated queries.
Attribute query.
Location query
The final selection left me with 3 cities, and a map that looks like this:
The final task was to select multiple rivers, and then create a map similar to the one above.
No comments:
Post a Comment