Join Adam Wilbert for an in-depth discussion in this video Selecting elements with SQL, part of ArcGIS Essential Training.
- Another way that we can make selections,…is to leverage the massive amount of attributes…that our layers typically contain.…We can do this using a standard…query language called SQL.…In ArcMap, this is called making a selection by attributes.…In the case of our map of Washington here,…I've added an incredibly detailed transportation layer,…obtained from the State Department of Natural Resources.…You might have noticed that it takes…quite a while to draw on the screen.…Now, what I want to do is use the atrributes…that are present in this data layer…in order to make selections.…First, let's go ahead and take a look at those attributes.…I'm going to right-click on this…WA_TRANSPORTATION layer,…and choose open attribute table.…
If I look down here at the bottom,…I've got over 880,000 roads and transportation segments.…Across the top, we have all of the attributes…that are going to be useful for us in making our selections.…There's two in particular that I want to focus on.…This one here called TRANS<u>RTE</u>TY,…
Author
Adam Wilbert
Released
10/22/2014- Getting to know the ArcMap interface
- Geocoding addresses
- Measuring distances
- Adding and importing data
- Labeling and adding graphs
- Editing layer properties
- Seeing multiple views
- Making selections
- Exploring geospatial data with ArcCatalog
- Working with vector and raster data
- Styling the map
- Adding your own data
- Using the ModelBuilder
- Adding a legend and annotations
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome59s
-
Using the exercise files1m 23s
-
Working with GIS data files3m 19s
-
-
1. Getting Started with a Geographic Information System (GIS)
-
What is GIS?4m 48s
-
Changing the map's scale5m 19s
-
Working with bookmarks6m 55s
-
Geocoding addresses5m 46s
-
Measuring distances3m 5s
-
-
2. Organizing the Map
-
Adding data to the map6m 5s
-
Labeling features7m 25s
-
Adding graphs2m 32s
-
-
3. Working with Data Layers
-
Editing layer properties2m 53s
-
Identifying features3m 39s
-
4. Seeing Multiple Views of the Map
-
5. Selecting Map Elements
-
Making selections3m 50s
-
Selecting elements with SQL5m 17s
-
-
6. Exploring Geospatial Data
-
Exploring the Catalog window6m 52s
-
Introducing ArcCatalog7m 26s
-
Connecting to data sources2m 51s
-
-
7. Geoprocessing Tasks
-
Exploring ArcToolbox7m 13s
-
Creating buffers4m 9s
-
-
8. Working with Vector Data
-
Exploring vector data2m 39s
-
Using GPS tracks5m 11s
-
9. Working with Raster Data
-
Understanding raster data4m 29s
-
Working with air photos3m 17s
-
Merging rasters3m 47s
-
Using the Raster Calculator4m 44s
-
-
10. Styling the Map
-
Changing point symbology5m 18s
-
Changing line symbology5m 39s
-
Changing polygon symbology3m 54s
-
Classifying data3m 56s
-
Changing raster symbology4m 39s
-
Creating layer files2m 29s
-
-
11. Creating Your Own Data
-
Georeferencing an image7m 26s
-
Joining data2m 54s
-
Preserving topology4m 11s
-
-
12. Exploring the ModelBuilder
-
Running toolbox models6m 12s
-
Sharing a model4m 29s
-
-
13. Finishing the Map
-
Working with map layouts6m 14s
-
Using the Draw toolbar4m 22s
-
Adding map annotations1m 45s
-
Creating a legend6m 27s
-
-
Conclusion
-
Next steps1m 21s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Selecting elements with SQL