Lab: Using  Handheld GPS to Create a Point Database

Create a database with pictures taken on spring break.  This has the following objectives:


  1. Fill out a table, showing how you coded the database and how you would filter it to find each customer category.  Insure the filter is complete and in the proper format (you might want to cut and paste it to get the quotation marks correct).
  2. Database
  3. Screenshot of your database overlaid on both the landsat and DEM you used for the last lab. 
  4. A discussion of what you would revise about the structure of your database if you had to redo it. If your design was perfect, defend it; otherwise suggest anything you learned about designing a database that become obvious as you collected and displayed data.
  5. Discussion of the pros and cons of the camera as a GPS and GIS collection device.


  1. Design the database you will create. 
  2. Collect data, using either:
  3. Create photo DB
  4. Add attribute data to each record to the database with the photo names and locations.
  5. New image to open the Landsat imagery.
  6. Database (on map toolbar) to overlay your database on the imagery
  7. Correct GPS locations to match the imagery.  The imagery might be old, so consider that in your edits.  If you used the phone, you might also have several photos with the same GPS location.  You might want to move the point from where you were standing to take the picture, to the location of the object in the photo.
  8. Merge databases.
  9. Plot, Label all records to put a label next to the record if desired.
  10. Grayscale and subdue map can allow emphasis on map overlays instead of the base map.
  11. Bring up the photos if you used the camera option.  Record display after you Double click on a record in data base.
  12. KML export for Google earth.

Advanced related options, not required for this lab but worth knowing about:

  1. Link web pages to database.
  2. Distance from point: you can find the distance of every parking spot from a particular point, and then filter by distance, or color code on the map by distance.

Last revision 8/3/2017