Lab 7 - Queries

Lab 7 – Attribute and Location Queries In this lab exercise, you will become familiar with using attribute and location queries to select features and answer spatial questions. Queries can be applied to vector data and are used often in GIS analyses. Attribute queries select features based on their attribute values whereas location queries select features based on their spatial relationship to features of a second vector dataset. To answer some of the queries below, you may need to use multiple queries. I strongly recommend you d o all your analyses in ModelBuilder so that you can easily revise your workflow, if needed, after taking the lab quiz . I suggest creating a new model for each major task. For each question, you can use the Copy Features tool to export the selected features into a feature class. In this exercise you will create models that:  Use attribute queries (use Select or Select Layer by Attribute )  Use location queries (use Select Layer by Location )  Use queries in a series  Export selected features to a new feature class (use Copy Features ) For this exercise, you will need to use the following data:  towns.shp (from lab 1)  Soils.shp (from lab 2)  Lakes.shp (from lab 1)  land_cover_2011.shp (from lab 2)  Rivers.shp (from lab 1)  Building_footprints_South_Kingstown (from lab 3)  Wetlands.shp (from lab 1)  Dams.shp (from lab 7) Task descriptions: 1) Answering questions with attribute queries: use either the Select Layer By Attributes or Select tools to complete the following tasks and answer the questions. If using Select Layer By Attributes , you can use Copy Features to copy the selected features to a new feature class. a) From the “towns.shp”, create a dataset containing all the features that have the value of “Washington” in the “County” field. Name the feature class “Washington_towns.”. How many features are in Washington_towns (hint: look in the attribute table)? (0.5 pts) b) For the “Lakes.shp”, use Calculate Geometry Attributes to add a field with area in hectares. i. Create a dataset with Lakes that have areas > 50 hectares. How many lakes are within this size range? (0.5 pts) ii. Create a dataset with Lakes that have areas that are between 50 and 100 hectares. How many lakes are within this size range? (0.5 pts)

c) For the “Rivers.shp”, use Calculate Geometry Attributes to add a field called “Miles” and populate it by calculating the length of the features in miles. i) Create a dataset with all river features that have a “StrmOrder” of 1. How many features are there? (0.5 pts) ii) What is the total length (in miles) of these rivers features? (0.5 pts) d) For the “Dams.shp”: i) Create a dataset that contains dam features that have the word “Pond” or “POND” in their name (note that queries are case sensitive). How many features are there? (0.5 pts) ii) Select the “POTTER POND” dam and zoom to its location. Make sure the coordinate system of the map frame is in RI state plane (feet). To set the map frame’s coordinate system, right- click on Map and select Properties . Under Coordinate Systems , make sure “NAD 1983 State Plane Rhode Island FIPS 3800 (US Feet)” is selected. What are the dam’s coordinates (in eastings/northings) in feet? (hint: to get the dam’s coordinates, right-click on the dam location, select “Copy Coordinates”, and paste the coordinates below) This task does not need to be done in a model. (0.5 pts) 2) Answering questions with both attribute and location queries: use the Select By Attribute and Select By Location tool to answer the following questions. a) For the Dams and Washington_towns layers: i) Create a dataset with dams located within the Washington_towns features (created in Task 1, part a). How many dams are there? (0.5 pts) ii) Create a dataset with dams in Washington_towns that are located within 10 m of a feature in the Lakes layer. How many features are there? (0.5 pts)

iv) Create a dataset with buildings that either intersect a prime farmland feature OR are within 50 m of a feature in Wetlands. How many features are there ? (0.5 pts) d) The following tasks use the land_cover_2011 and Building_footprints_South_Kingstown layers: i) Create a dataset with land_cover_2011 features have “Residential” in their class name (“Descr_2011” field ). Note that there are 5 residential land cover classes. The “contains the text” operator is convenient for this case because it avoids the need for 5 clauses in the query, but this operator is finicky. Using “Residential” as the search text does not work but using “Residentia” works fine. ii) How many features correspond to residential classes iii) Create a dataset with buildings that are on residential land cover . How many features are there ? (0.5 pts) iv) Create a dataset with buildings that do not intersect “residential” land cover features. How many features are there? (0.5 pts) After completing all tasks:  Complete the Lab 7 Quiz . You can retake the quiz once (the two attempts will be averaged)  You do not need to submit any material for this assignment.