skip navigation
Geography Department Banner.  Click to link to Geography Department Website
California State University, Northridge Logo.  Click to link to the C.S.U.N. home page.

Geography 107

Introduction to Human Geography - Lab Mapping Local Favorites

Image: I house

Lab 1: Mapping Local Favorites

 

For this assignment you will be introduced to two additional mapping applications and a couple of spreadsheet applications. You will also contribute five of your favorite places for the class (and the world) to consider.


Before you start:

  1. Do not begin this assignment the night before it is due.
  2. You may want to do this exercises on campus if you do not have a fast internet connection at home.
  3. Please stop by my office if you need help with this assignment.
  4. You may want to print out the instructions and work from the hard copy. This may save you some effort (but not ink)
  5. You may want to print the results page out (once you’ve clicked submit at the end of this exercise) as proof that you completed the exercise.
  6. Remember to press TAB (or use your mouse) to move your cursor between response (answer) boxes.
  7. Do not press enter until you’re ready to submit your answers. If you do, an incomplete set of answers will be sent to me. You may click the back button at that point and continue where you left off. I’ll grade only the last submission.
  8. DO remember to put your name in the appropriate response box below.

Student Learning Outcomes:

Below are listed the learning outcomes for this assignment.

  1. Students will correctly identify or define several vocabulary terms associated with the topic.
  2. Students will identify some of the known uses of geospatial technologies.
  3. Students will use an online mapping software to construct a map.
  4. Students will contribute data to a 'cloud computing' application, to create a wiki-style map with fellow students.

Part 1: Background.

Step 1. Read the background paragraph below, watch an associated video clip and answer the questions associated with the passages.

Geospatial technologies, including Geographic Information Systems (GIS) and Global Positioning Systems (GPS) are becoming increasingly commonplace technological tools of the new century. It is imperitive that college educated persons learn some of the basic functions of GIS and GPS, especially if they have taken a geography course. These are the tools of the 21st century geographer and like the paper roadmap, everyone should know a little about how to make these technologies work for them. You should also know that the U.S. Department of Labor has identified geospatial industries as one of the top three growth fields for the next decade (only behind biotechnology and nanotechnology). This means that skill in this area should help you get a job after you graduate.

To provide you with some additional background, please watch this video from Penn State Geospatial Revolution Project, then answer the following questions.


Question 1: In the segment of the video regarding the mapping of wildfire risk, the woman guest (Kass Green) suggest which of the following layers could be added together to make a map of wildfire risks in California.

Fire station locations, ethnicity and population density
Slope (terrain), roadways and vegetation (fuel)
Known arsonists, fire stations and wildfire history.
All of these should be put together.

Continuing from the video :

Question 2: What political campaign did the video identify as "taking to a new level" their mapping of voters and trends.

George Bush
Arnold Schwartzenegger
Barack Obama
None of these

Question 3: Complete the following sentence using a term or phrase from the drop down menu below:

According to a speaker in the video, "Geospatial intelligence has become, really, the foundation for just about anything that happens in the ____________________."

 

Question 4: What country is referenced in the segment about the attacks on people in Darfur, monitored by satellites by Amnesty International?
(select from the drop down menu below).

Question 5: Geospatial technologies are at the basis of the third fastest growing employment sector. Which of the following is growing faster?
(select from the drop down menu below).

:


Part 2: Converting Addresses into Latitude and Longitude Points

In this section of the lab, you will participate in a group effort along with your classmates to construct a map of your favorite places in Los Angeles.

Step 2: Your job is to think of five places you really like. They can be restaurants, parks, bowling alleys, coffee shops, etc. Any place that has an address is suitable, but make sure it's a public place, not some place like your grandma's house...or your boyfriend's parents house.

Use the phone book or Google Maps to find the addresses of the five locations you would like to share with others in the class.

Step 3: Once you have found your five location addresses, you need to build a tiny database of your favorite places. The best thing to do is to put them in a spreadsheet program like Microsoft Excel. I've created an example for you below using just some of my favorite local restaurants, but you can put other sorts of places in your database.

Address Table
Place Name Address City State ZIP Comments
Pho 999 Restaurant 7255 Reseda Blvd Reseda CA 91335 I love this place and so do my kids. We get the number 50 bowl every time. They appear to incorporate some other flavors into their dishes, making this place maybe a "California Fusion" restaurant as much as it is Vietnamese.
King's Burger 9345 Reseda Blvd Northridge CA 91324 I go here for lunch often. They've got a ton of stuff on the menu, including (from experts) very good sushi. I like the blackjack burger best.
Jerry's Pizzeria 22035 Sherman Way Canoga Park CA 91303 This is a bit of a dive, but locals have been going here since the 1950s. Good pizza, pretty greasy but my kids are welcome and they're pretty laid back here, serving beer and showing ball games.
Pita Pocket 9127 Reseda Blvd Northridge CA 91324 I really like the Schwarma Laffa here. It's like a Middle Eastern burrito. Good crowds at lunchtime and very friendly, family owned atmosphere. Lots of good sides too, like babaganoush.
Brent's Deli 19565 Parthenia Northridge CA 91324 Killer New York Style Deli. Come hungry to this place because they'll serve you more than you'd ever guess. I like the Rueben sandwich most.

Here's an exact copy of this small database in Microsoft Excel fomat (.xls) .

You should download it, open it in a spreadsheet program (like Microsoft Excel) erase my entries and put your own in instead. Directions are included in the file.

Step 4. Once you have your database ready in a spreadsheet, you must open an online mapping program called batchgeocode.com (click to open in a new window).

This is one of the most valuable little pieces of free software on the internet because it allows visitors to this site to get highly accurate point maps from an address database. This process is called geocoding (or sometimes address matching).

Batchgeocode.com is a very useful tool for marketing, economic, political and social geographers, as well people who just want to make some maps of their addresses.

Step 5. Once you're in batchgeocode.com, you can follow their pretty simple instructions for making a map, but I'll provide the steps here as well.

  1. Skip Step one. The default setting is for tab-delimited (or comma delimited) data. Leave it there.
  2. Click once in the Step 2 window in batchgeocode.com and press Ctrl+A to select all. Then press delete to empty the Step 2 window.
  3. Open you spreadsheet program.
  4. Copy the white and pink cells in your database (highlight it and press Ctrl+C)
  5. Paste it (press Ctrl+V )into the Step 2 window in batchgeocode.com
  6. Click on the "Validate Source" button. Make sure that the word "Address" appears in the little box to the right of the word address under Step #4. The same should appear for the word "City", "State" and "ZIP". Don't worry about the comments field.
    • THESE FIELDS MUST MATCH. It's the only way the software can figure out what you are trying to match.
  7. Once you've validated the fields click on the "Run Geocoder" button and the software will make a map of your addresses. Occasionally an address can't be found, but that's becoming rare.
    • Batchgeocode.com will interpret the address data for you, find it on a map and return to you, in a window under Step #6, your original database, but it will include latitude and longitude coordinates in two new colums: bg_lat and bg_long.
    • Note the instructions provided about the map you've made. You can embed it in your own website or save it as a .KML file, which you could send to your friends that have Google Earth.
  8. Just above the map that you created is a window under the words "Step #6". You'll click in that box, press Ctrl+A to select all and then Ctrl+C to copy it back into your clipboard.
  9. Paste the data back into your spreadsheet. The only thing that should be different is that the latitude and longitude columns should now have data.

Step 6. Open the Google Doc that I sent you earlier in the week.

Step 7: Paste that which you have copied out of the window in Step #6 in batchgeocode into the spaces to the right of YOUR name. You will have 5 rows of data assigned to you. The columns will match those that you will have copied out of batchgeocode.com

Question 6: What is the process called in which you use software to convert address data into latitude and longitude coordinates?

:

Question 7: Longitude coordinate of your fifth site?

 

and the

.

 

Are you ready to submit the assignment?

(pick one from the drop down list).

When you click the button below, you will be directed to a web page that shows your answers. The instructor will get a copy of this email as well, but you may want to keep a copy for your records. If you are curious about the correct answers, please bring your questions to class.

C.S.U.N. Seal About Dr. Graves | Site Map | Contact Dr. Graves | ©2003 Steven M. Graves - Geography Department, California State University - Northridge