Storm sewer data entry.
Students will enter their collected storm sewer data into a database
using a PHP coded database online form.
1. At the beginning of class, show students in Google Earth where Broughal Middle School is located. Highlight the geographic coordinates. Broughal is located at 40.60807N, -75.39071W.
2. Show students the location of these geographic coordinates
with reversed positive and negative signs.
-40.60807N, 75.39071W.
3. Begin data entry by having students enter two “Test Run” data collection sheets into the online database. Have students select “Test Run” in the Group name field. These are practice data entry for the students that you will later remove from the cumulative data set.
4. Explain that the date is from the data collection sheet and not the current date. Emphasize the proper format to enter data collection dates: (mm/dd/yyyy): (For example, 10/29/2007)
5. Explain the importance of the negative sign for entering longitude.
Emphasize that all digits recorded for latitude and longitude each data sheet
must be entered into the database.
6. Review and explain the intersection choice selection by noting to students how the intersection data was recorded on the data collection sheet. Show the students how to select the appropriate field on the Web database form to enter this information.
7. Review and explain the check box on the data collection sheet that notes the street location of the storm sewer or drain. Show the students how to select the appropriate Street direction field on the Web database form to enter this information.
8. After the “Test Run” data has been entered, have students enter the collected storm sewer data into the online database.
9. After 15 minutes of data entry, display an output KML file in Google Earth. Note data errors to students. Show all points that are not in the sampling area. Discuss how these points may have been entered into the database.
10. Continue to have students enter the collected storm sewer data into the online database.
Materials needed:
Completed data collection sheets
Online database access
Instructional Sequence | GIS Storm Sewers Unit
|
Copyright ©2008 Broughal NASA Explorer School/Lehigh University
Partnership. All rights reserved.
|