Lab7_assignment
.docx
keyboard_arrow_up
School
University of California, Davis *
*We aren’t endorsed by this school
Course
150
Subject
Geology
Date
Apr 3, 2024
Type
docx
Pages
3
Uploaded by AmbassadorAntelope1675
Lab 7: Joins and Overlays
You may finish the tutorial after step 42
Chapter 10 Teaching Tutorial Questions
1)
How many wells are situated on limestone?
2)
Which field contains the post office names?
3)
How many streets are more than two miles (10,560 feet) from a post office?
5)
What is the total area of the proposed thinning in square kilometers?
Chapter 10 Practice Exercises
Use spatial joins and the data in mgisdata\Austin\Austin geodatabase to answer the following questions.
6)
A tennis club is implementing an after-school tennis program. Use a spatial join to determine the closest tennis court to each school. What is the average and median distance of schools to tennis courts in miles? Create a histogram of distances (in miles), out of the attribute table. Export a PDF and insert it into your lab submission. HINT
: see the Distance Joins section of the tutorial, starting pg 329 (streets/post offices example). Set schools
as the target layer, tennis_court
as Join Features, name the Output Feature Class Schools_TennisCourt, set the Match Option as closest, use US Survey Miles, add Tennis_School_Dist
as Distance Field Name and click Run.
Add schools’ layer to the map:
Open the Catalog Pane => gisclass => mgisdata => Austin => Austin.gdb => Facilties => schools
.
Add schools’ layer to the map:
Open the Catalog Pane => gisclass => mgisdata => Austin => Austin.gdb => Parks => tennis_courts
. Go to the content pane and open the attribute table of Schools_TennisCourt and look at the distance. They are very high to be in miles. The next step should be to convert these distance from feet into miles. Make sure Schools_TennisCourt is selected and go to Data => Field to create a new field. Add both name and Alias Dist_Miles
, set Data Type as float and Number format as Numeric. Save and close the field view.
Go the attribute table of Schools_TennisCourt, right-click on Dist_Miles and choose “calculate field” and divide it by 5280 (1 mile = 5280 feet)
7)
The University of Texas at Austin received a grant for water quality education. Each school will study aspects of the watershed in which it is located. Create a list of schools, each with its designated watershed. Sort the list alphabetically by school name and create a clearly labeled and well-formatted table, including the grade range and watershed name.
Include a sentence that highlights which watershed has the most schools, and how many it has. Export a PDF and insert it into your lab submission.
HINT
: see the Merged point to polygon joins
section of the tutorial, starting pg 328.
Set watersheds
as the Target Features and schools as Join Features. Name schools_in_watershed
as Output Feature Class, use Join one to one
as Join Operation set Match Option to Contains. Change merge rule as sum and run. Don’t worry about removing fields, Add Watersheds
layer to the map:
Open the Catalog Pane => gisclass => mgisdata => Austin => Austin.gdb => Environmental => Watersheds
. Select the layer schools_in_watershed
and go to table => field and make make visible only the following fields: Jount_Count
, DCM_NAME, GRADERANGE
and CAMPNAME
. Then save and close the field view.
Right click on Jount_Count and select “Sort Descending” to get the watershed that has the highest schools. Export that table and format it using excel.
8)
Septic systems are commonly used in low-density housing areas, but the impacts on aquifers may be of concern. Map the areas in Austin where the census tract population densities are less than 1,000 people per square mile (use the polygon layer containing census tracts) and where the geologic unit names (geology layer) contain Limestone or Terrace or Alluvium (case sensitive, make sure to select the OR operator). Submit a map layout
showing your final overlay result with some transparency over an Imagery basemap. Use a caption
of 1-3 complete sentences to explain the data in the map. Make sure to include all the normal map elements.
HINT
: Add tracts
layer to the map:
Open the Catalog Pane => gisclass => mgisdata => Austin => Austin.gdb => Administrative =>
tracts
. Go to geoprocessing and type intersect.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help