Lab7_assignment

.docx

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