Lab: Using Handheld GPS/Phone to Create a Point Database
Create a database with pictures taken of monuments around the yard. 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 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 15 photos, exported to Google Earth (KMZ file).
You need at least one from each of the following location:
- Seawall near Annapolis Harbor
- Central yard
- Vicinity Alumni Hall
- Jet drainage basin
- At least 5 attributes for each monument
- Your final database. (DBF file)
- Screenshot of your database overlaid on a orthophoto of the Academy.
- 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
- Discussion of the difference between the NAIP and one of the other
imagery data sets.
- Design the database you will create. You
the rules for field names.
- Collect data, using either:
- Create photo DB
- Add attribute data to each record to the database with the photo names and
- Get two images covering part of the Academy from the
USGS Earth Explorer,
one NAIP which will cover all of the Academy, and one high-resolution and
cover a much smaller area.
It will be large, so get the most recent and the one that best covers your
photos. Look at the coverage on the map or the metadata and browse
image to verify you have the correct image unless you want to download a lot
of imagery; you must have at least one the monuments on each image.
to open the orthoimagery
Database (on map
toolbar) to overlay your database on the imagery.
Icons from thumbnails can be
- 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 10/19/2018