Querying and overlaying vector layers, key operations and techniques.
Many operations can be done with vector data.
Finding features of interest based on attributes.
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 to check for spatial relationships such as:
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.
Create a new Polygon layer based on distance.
Example From ESRI Docs
Create a new Polygon layer based on distance.
Buffering Tsunami Shelters
Aggregates features.
Example From ESRI Docs
Aggregates features.
Dissolve 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.
Cut one layer down to the boundaries of another.
Example From ESRI Docs
Cut one layer down to the boundaries of another.
Input
Cut one layer down to the boundaries of another.
Output
Remove the area of one layer from another.
Example From ESRI Docs
Remove the area of one layer from another.
Input
Remove the area of one layer from another.
Output
Output where layers overlap and combine attributes.
Example From ESRI Docs
Output where layers overlap and combine attributes.
Input
Output where layers overlap and combine attributes.
Output
Combine multiple polygon layers, split features where they overlap and combine attributes.
Combine multiple polygon 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.