Lab: Using Handheld GPS to Create a Point Database
Create a database with pictures taken on spring break. This
has the following objectives:
- Decide how to code attributes, so that the database will be useful
for three distinct groups. You can define who those groups are.
- Collect and code the data attibutes.
- Distribute the database as a KML file
- 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).
- Database with at least 35 photos, exported to Google Earth (KMZ file)
- Your final database. (DBF file)
- Screenshot of your database overlaid on both the landsat and DEM you
used for the last lab.
- Make sure this has a labeled UTM grid. This means not using
quick clipboard exports,
- Grayscale and subdue the imagery.
- 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.
- Discussion of the pros and cons of the camera as a GPS and GIS
- Design the database you will create.
- Collect data, using either:
- Create photo DB
- Add attribute data to each record to the database with the photo names and
to open the Landsat imagery.
Database (on map
toolbar) to overlay your database on the imagery
- 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.
- Merge databases.
Label all records to put a label next
to the record if desired.
- Grayscale and subdue map can
allow emphasis on map overlays instead of the base map.
- Bring up the photos if you used the camera option.
display after you Double click on a record in
KML export for Google earth.
- Can include the photos in the display in Google Earth, and you
control the size by selecting the deliberate export and picking the
"thumbnail only" option for the images, and pick a reasonable size
(100's if pixels).
- You can also
adjust the labels, to make sure they do not overpower the display.
- You can put in icons, and use them to show the photos (or edit in
Advanced related options, not required for this lab but worth
- Link web pages to database.
- 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