Many operations can be done with vector data.
Finding features of interest based on attributes.
Sample SQL queries
Species | Age | Height |
Pine | 10 | 5 |
Pine | 95 | 28 |
Oak | 200 | 25 |
Oak | 5 | 4 |
Sample SQL queries
Species | Age | Height |
Pine | 10 | 5 |
Pine | 95 | 28 |
Oak | 200 | 25 |
Oak | 5 | 4 |
Sample SQL queries
Species | Age | Height |
Pine | 10 | 5 |
Pine | 95 | 28 |
Oak | 200 | 25 |
Oak | 5 | 4 |
Sample SQL queries
Species | Age | Height |
Pine | 10 | 5 |
Pine | 95 | 28 |
Oak | 200 | 25 |
Oak | 5 | 4 |
Sample SQL queries
Species | Age | Height |
Pine | 10 | 5 |
Pine | 95 | 28 |
Oak | 200 | 25 |
Oak | 5 | 4 |
How many rows in this table would the following query return?
Where "SPECIES" = "Pine" AND "SPECIES" = "Oak"
Species | Age | Height |
Pine | 10 | 5 |
Pine | 95 | 28 |
Oak | 200 | 25 |
Oak | 5 | 4 |
Birch | 5 | 4 |
How many rows in this table would the following query return?
Where "SPECIES" = "Pine" OR "SPECIES" = "Oak"
Species | Age | Height |
Pine | 10 | 5 |
Pine | 95 | 28 |
Oak | 200 | 25 |
Oak | 5 | 4 |
Birch | 5 | 4 |
Looking at spatial relationships within or between layers.
Use Select by Location when you want to check for spatial relationships. There are many relationships we can check for:
These methods create new layers with altered "geometries". Geometry is a term we use to refer to points, lines, and/or polygons in a vector layer.
Use the Buffer tool to create a new Polygon layer based on distance.
Example From ESRI Docs
Use the Buffer tool to create a new Polygon layer based on distance.
Buffering Tsunami Shelters
Dissolve aggregates features.
Example From ESRI Docs
Dissolve aggregates features.
Dissolve Tsunami Shelter Buffers
This tool allows us to aggregate vector objects in a layer, either completely or by specific attribute values.
When we have multiple data layers and we want to combine them to form a new output.
Use the Clip tool to cut one layer down to the boundaries of another.
Example From ESRI Docs
Input
Output
Use the erase tool to remove the area of one layer from another.
Example From ESRI Docs
Input
Output
Intersect lets us see only where layers overlap and combine overlapping attributes.
Example From ESRI Docs
Input
Output
Use the Union tool to combine multiple layers, split features where they overlap and combine attributes.
Use the Union tool to combine multiple layers, split features where they overlap and combine attributes.
There are many more vector overlay tools! I have presented some of the the most frequently used tools, but if you have specific use cases you may need others. I can't cover them all, and I don't want to overwhelm folks.
Clip and erase remove portions of layer based on location relative to another layer but they do not alter the attribute table.