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 / Mapping Yourself

Photo of an I house

THIS LAB IS NOW SERVED ON MOODLE- PLEASE USE UPDATED MOODLE VERSION.

Introduction to Community Mapping and Geocoding - Geography 107

Maps are an important communication and analysis tool. In this lab you are going to create a point map from address data. This sort of mapping is important in a host of sub disciplines within geography. It is especially important among business and economic geographers who use address maps to help them do business. It has a host of medical and health geography applications as well.

In this assignment you will be introduced to two mapping applications and a two spreadsheet applications.

You will also contribute the collaborative construction of map of favorite places (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 or screen capture 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 remember to put your name in the appropriate response box below.

Student Learning Outcomes:

Below are the learning outcomes for this assignment.

  1. Students will correctly identify or define several vocabulary terms associated geospatial technologies.
  2. Students will identify some of the known uses of geospatial technologies.
  3. Students will use an online mapping software to construct a map and convert address data to latitude and longitude coordinate data.
  4. Students will contribute data via spreadsheet 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, open the trailer video here at the Geospatial Revolution website (opens new window) hosted by Penn State

Make sure you are watching the "Trailer", which is a 5 minute introductory video, explaining how geospatial technologies are affecting our lives.

Question 1: According to the U.S. Department of Labor, which of the following industries is poised to see the 3rd most growth over the next decade?

USE THE MOODLE VERSION PLEASE

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

Continuing from the video :

Question 3: What politician's election campaign did the video identify as "taking to a new level" their mapping of voters and trends.

Question 4: 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 ____________________."

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 or girlfriend's 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.

Once you have found your five location addresses, you will 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.

Step 3: Open your spreadsheet program (like Excel) . You have two options at this point.

  1. You may try to copy and paste the table below directly into your spreadsheet...this may work with some browsers (Firefox) but not others...or
  2. Open the this link which should prompt you to download an Excel file, which you can then open in your spreadsheee program.
Address Table
Place Name Address City State ZIP Comments Latitude Longitude
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 a spreadsheet open that looks somewhat like the table above, erase MY (Dr. Graves') entries and replace them with your own favorite places. Put the street address, city, state and ZIP code in the appropriate cells. Keep your places local, please. Then write a short blurb about this place.

Step 5. Once you have your database ready in a spreadsheet, you must open an online mapping mapping program called batchgeo (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 make highly accurate point maps from an address database. This process is called geocoding (or sometimes address matching).
  • Batchgeo 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 6. Once you're in batchgeo, you can follow their pretty simple instructions for making a map, but I'll provide the steps here as well.

  1. In the "Step 1: Paste your data below " window click once, to highlight (turn blue) the data that is already there. Press Delete to remove it.
  2. Open yourspread sheet containing your favorite places and addresses (Excel). *Press and hold alt, then press tab to move between open programs*
  3. Copy the white and pink cells in your database (highlight it and press Ctrl+C)
  4. Return the the batchgeo website (Alt+Tab)
  5. Make sure your cursor is in the Step 1 window, then paste (Ctrl+V ) what you copied from the spreadsheet into the Step 1 window
  6. Click on the "Map Now" button.
  7. Batchgeo will interpret your address data, display it on a map in a window. Check it out! You've made a map...or had a program make it for you.
  8. To get the latitude and longitude data that you need to complete this exercise you have two options:
  1. OPTION 1:
    • Scroll back up to the Step 1 window. Click in the window once (or twice) to highlight (or turn blue) the data like you did in Step 1 before.
    • Copy this highlighted data paste back into your spreadsheet (Excel) file.
    • This is your original database, but it includes latitude and longitude coordinates in two new colums: bg_lat and bg_long.
    • It also includes a column that verifies the ZIP code and a column that tells you how it found your address.
  2. OPTION 2:
    • Click on the "Save/Share/Embed" button below the map that batchgeo just made.
    • A new window will pop up. Give enter the appropriate data and email this file to your own email address.
    • Open your email program and find the email from batchgeo
    • Click on the second link under "Edit your map" to open your map in a web browser.
    • Scroll down until you find the window "Edit Map Markers"
    • Click in the "Edit Map Markers " window/box , which should highlight it in blue (press Ctrl+A to select all if not) then copy it (Ctrl+C ) back into your clipboard.
    • Paste the data back into your spreadsheet (Ctrl+V) . The only thing that should be different is that the latitude and longitude columns should now have data, and you may have two new additional columns (bg_postal and bg_accuracy)

***You may need to erase a row of data if you find that you a second row of data headers across the top of your spreadsheet.

**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 or can use Google Maps.

Step 6. Save your spreadsheet file and consult the batchgeo website and then answer the questions below.

Question 5: What is the file format used by Google Earth and Google Maps to make maps? (It's mentioned above and in Batchgeo.com)

Question 6: Fill in the blank. What is the name of the process whereby you use software to convert address data into latitude and longitude coordinates?

Question 7: Which of the following latitude and longitude coordinates are probably in Los Angeles County?

That was the last question, so you have completed the question and answer portion of the assignment.

You have two tasks remaining. DO BOTH!

  1. You need to fill in your name and submit your answers for this part of the assignment (Step 8; Part 2 - see below).
  2. You need to open the webpage containing the webform that will allow you to submit your information to the group map.

Step 7. Click on the link below to open a Part 3 of this assignment. It will allows you to enter your data into a Google Form that will in turn map your locations and your comments on a Google Map along with the others students....then...navigate back to this page to click the submit button below.

Part 3 Link: Enter your data to help build the class map

Step 8. Fill in the information below and click submit. Don't forget to finish your work in Step 7 above.

(pick one from the drop down list).

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