Database querying.
Students will analyze their collected storm sewer data by querying
the database.
Warm up:
1. Instruct students to launch AEJEE and load the following shape
files:
Northampton and Lehigh County Roads, and student collected storm sewer data
points.
2. Ask students to look at the placement of the storm sewers on their map and locate the best intersection to build a new indoor paint ball and laser tag building on the southside of Bethlehem.
3. Have select students come up to the board one at a time to mark the placements of where they think storm drains should be located. Have students articulate their reasons for their placement choices. Discuss patterns with storm sewers.
4. Model how to query data with the Query Builder Tool in AEJEE.
5. Query SewerType = double to show the results of double grated sewers.
6. Explicitly show how each record from the database will appear in the bottom window and that each location will be highlighted on the GIS map display.
7. Query SewerType = single to show the results of double grated sewers.
8. Query streetName = Packer to show the results of storm sewer locations on Packer Ave.
9. Distribute the Querying the Map in AEJEE handout to students.
10. Have students complete the worksheet.
11. Review and discuss student responses.
Materials needed:
Handout: Querying the Map in AEJEE [Query.doc]
GIS files: Northampton Roads, Lehigh
County Roads, Rivers, and student collected
storm sewer data points.
Instructional Sequence | GIS Storm Sewers Unit
|
Copyright ©2008 Broughal NASA Explorer School/Lehigh University
Partnership. All rights reserved.
|