school of geography faculty of environment querying with arcgis
TRANSCRIPT
![Page 1: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/1.jpg)
School of GeographyFACULTY OF ENVIRONMENT
Querying with ArcGIS
![Page 2: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/2.jpg)
What is Querying?
• A request to select features or records from a database
• Often written as a statement or logical expression
• Types of queries:
• Interactive
• click on features using the Identify tool
• Find tool
• Distance tool
• Select by Attribute (SQL query)
• Select by Location (spatial query)
• Select by Graphic
![Page 3: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/3.jpg)
Selection Tools
• Select and clear individual features from the Tools toolbar
• Various selection options from the Selection menu
![Page 4: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/4.jpg)
Dynamic Linkage
![Page 5: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/5.jpg)
Selection Options in ArcMap
• Specify interactive selection method + Selection Option (Selection Options)
![Page 6: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/6.jpg)
Select by Attribute
• Uses an SQL where clause to select features
• Save and reload selection expressions
Selected features in blue
Right click in the
Field box
![Page 7: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/7.jpg)
Other Features
• Search on a text name – enclose in single brackets
• Use wildcard characters - % or * for any length; _ for one character in combination with LIKE
• Use Boolean operators to look in more than one column, i.e. AND, OR, NOT, etc.
• Is NULL – to search for null values
• Get Unique Values + Go To:
• Substring (“STATE_NAME”,1,2) = ‘Te’
![Page 8: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/8.jpg)
Select by Location
• Is a spatial query
• Use features in one layer to select features in another
• Examples are to select features in A that are:
• Completely contain B
• Intersect with B
• Are within a specified distance of B
• Are completely within B
• Etc.
![Page 9: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/9.jpg)
Example of a Query by Location
![Page 10: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/10.jpg)
Results of the Query
Addresses within 50m of motorway Further refined to choose only
dwellings
![Page 11: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/11.jpg)
Select by Graphics
• Draw a graphic to select features
• Works with interactive selection methods
![Page 12: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/12.jpg)
Save Selection
Or export
as a shapefile
Data Export Data
![Page 13: School of Geography FACULTY OF ENVIRONMENT Querying with ArcGIS](https://reader036.vdocuments.us/reader036/viewer/2022062805/5697bfba1a28abf838ca0412/html5/thumbnails/13.jpg)
Querying in ArcMap
Hands-on Exercise #8