Spatial Queries, Table Joins, and Relates in ArcGIS Pro

Learn essential Geographic Information Systems (GIS) data manipulation techniques through a comprehensive 34-minute video tutorial focused on spatial queries, table joins, and relates in ArcGIS Pro. Master fundamental database concepts starting with basic SQL queries before advancing to specialized GIS spatial operators. Follow along with hands-on demonstrations of key tools including Identify, Select by Graphic, Select by Location, Select by Attribute, and Definition Query. Explore the power of joining tables for enhanced cartographic visualization, performing spatial joins to combine geographic features, and creating relates for flexible data relationships. Practice these concepts using the ArcGIS Pro software with step-by-step guidance from GIS expert Dr. Brian Tomaszewski, complete with detailed explanations and real-world applications. Access a free 21-day ArcGIS Pro trial to implement these critical data management and analysis skills that form the foundation of effective GIS work.

Syllabus

Beginning
Introduction
What is a Query?
Table, Rows, and Columns – Basic Structured Query Language SQL
Overview of Structured Query Language SQL
Structured Query Language SQL WHERE Clause in a GIS Context
Spatial Operators for Querying
Introduction to Hands On Part 1 – Identify, Select by Graphic, Select by Location, Select by Attribute, Definition Query
Identify Tool Demonstration
Select by Graphic Demonstration
Select by Location Demonstration
Select by Attribute Demonstration
Definition Query Demonstration
Table Join Concept Discussion
Table Joining for Cartography Concept Discussion
Spatial Join Concept Discussion
Relate Concept Discussion
Table Join Demonstration
Spatial Join Demonstration
Relate Demonstration
Video Summary