3.4 Spatial Intersection (transformative join)
Sometimes you face the need to crop spatial objects by polygon boundaries. For example, we found the total length of the railroads inside of each county in Demonstration 4 in Chapter 1.4 by cutting off the parts of the railroads that extend beyond the boundary of counties. Also, we just saw that area-weighted averages cannot be found using st_join()
because it does not provide information about how much area of each HUC unit is intersecting with each of its intersecting counties. If we can get the geometry of the intersecting part of the HUC unit and the county, then we can calculate its area, which in turn allows us to find area-weighted averages of joined attributes. For these purposes, we can use sf::st_intersection()
. Below, how st_intersection()
works for lines-polygons and polygons-polygons intersections. Intersections that involve points using st_intersection()
is the same as using st_join()
because points are length-less and area-less (nothing to cut). Thus, it is not discussed here.
3.4.1 st_intersection()
While st_intersects()
returns the indices of intersecting objects, st_intersection()
returns intersecting spatial objects with the non-intersecting parts of the sf
objects cut out. Moreover, attribute values of the source sf
will be merged to its intersecting sfg
in the target sf
. We will see how it works for lines-polygons and polygons-polygons cases using the toy examples we used to explain how st_intersects()
work. Here is the figure of the lines and polygons (Figure 3.22):
ggplot() +
geom_sf(data = polygons, aes(fill = polygon_name), alpha = 0.3) +
scale_fill_discrete(name = "Polygons") +
geom_sf(data = lines, aes(color = line_name)) +
scale_color_discrete(name = "Lines")
lines and polygons
The following code gets the intersection of the lines and the polygons.
(
intersections_lp <- st_intersection(lines, polygons) %>%
mutate(int_name = paste0(line_name, "-", polygon_name))
)
Simple feature collection with 3 features and 3 fields
geometry type: LINESTRING
dimension: XY
bbox: xmin: 0 ymin: 0 xmax: 2.5 ymax: 2
CRS: NA
line_name polygon_name x int_name
1 line 1 polygon 1 LINESTRING (0 0, 2 0.4) line 1-polygon 1
2 line 2 polygon 1 LINESTRING (1.5 0.5, 2 1.25) line 2-polygon 1
3 line 2 polygon 2 LINESTRING (2.166667 1.5, 2... line 2-polygon 2
As you can see in the output, each instance of the intersections of the lines and polygons become an observation (line 1-polygon 1, line 2-polygon 1, and line 2-polygon 2). The part of the lines that did not intersect with any of the polygons is cut out and does not remain in the returned sf
. To see this, see Figure 3.23 below:
ggplot() +
#--- here are all the original polygons ---#
geom_sf(data = polygons, aes(fill = polygon_name), alpha = 0.3) +
#--- here is what is returned after st_intersection ---#
geom_sf(data = intersections_lp, aes(color = int_name), size = 1.5)
This further allows us to calculate the length of the part of the lines that are completely contained in polygons, just like we did in Chapter 1.4. Note also that the attribute (polygon_name
) of the source sf
(the polygons) are merged to their intersecting lines. Therefore, st_intersection()
is transforming the original geometries while joining attributes (this is why I call this transformative join).
polygons and polygons
The following code gets the intersection of polygon 1 and polygon 3 with polygon 2.
(
intersections_pp <- st_intersection(polygons[c(1,3), ], polygons[2, ]) %>%
mutate(int_name = paste0(polygon_name, "-", polygon_name.1))
)
Simple feature collection with 2 features and 3 fields
geometry type: POLYGON
dimension: XY
bbox: xmin: 0.5 ymin: 1.5 xmax: 2.3 ymax: 3.2
CRS: NA
polygon_name polygon_name.1 x
1 polygon 1 polygon 2 POLYGON ((0.5 2, 2 2, 2 1.5...
2 polygon 3 polygon 2 POLYGON ((0.5 2.5, 0.5 3.2,...
int_name
1 polygon 1-polygon 2
2 polygon 3-polygon 2
As you can see in Figure 3.24, each instance of the intersections of polygons 1 and 3 against polygon 2 becomes an observation (polygon 1-polygon 2 and polygon 3-polygon 2). Just like the lines-polygons case, the non-intersecting part of polygons 1 and 3 are cut out and do not remain in the returned sf
. We will see later that st_intersection()
can be used to find area-weighted values from the intersecting polygons with help from st_area()
.
ggplot() +
#--- here are all the original polygons ---#
geom_sf(data = polygons, aes(fill = polygon_name), alpha = 0.3) +
#--- here is what is returned after st_intersection ---#
geom_sf(data = intersections_pp, aes(fill = int_name))
3.4.2 Area-weighted average
Let’s now get back to the example of HUC units and county-level corn acres data. We would like to find area-weighted average of corn acres instead of the simple average of corn acres.
Using st_intersection()
, for each of the HUC polygons, we find the intersecting counties, and then divide it into parts based on the boundary of the intersecting polygons.
(
HUC_intersections <- st_intersection(HUC_IA, IA_corn) %>%
mutate(huc_county = paste0(HUC_CODE, "-", county_code))
)
Simple feature collection with 349 features and 5 fields
geometry type: GEOMETRY
dimension: XY
bbox: xmin: 203228.6 ymin: 4470941 xmax: 736832.9 ymax: 4822687
CRS: EPSG:26915
First 10 features:
HUC_CODE county_code year acres geometry huc_county
1 07080207 083 2018 183500 POLYGON ((482916.4 4711686,... 07080207-083
2 07080205 083 2018 183500 POLYGON ((499779.4 4696836,... 07080205-083
3 07080105 083 2018 183500 POLYGON ((461846.1 4683469,... 07080105-083
4 10170204 141 2018 167000 POLYGON ((269432.3 4793329,... 10170204-141
5 10230003 141 2018 167000 POLYGON ((271607.5 4754542,... 10230003-141
6 10230002 141 2018 167000 POLYGON ((267630 4790936, 2... 10230002-141
7 07100003 081 2018 184500 POLYGON ((436142.9 4789503,... 07100003-081
8 07080203 081 2018 184500 MULTIPOLYGON (((459473.3 47... 07080203-081
9 07080207 081 2018 184500 POLYGON ((429601.9 4779600,... 07080207-081
10 07100005 081 2018 184500 POLYGON ((420999.1 4772191,... 07100005-081
The key difference from the st_join()
example is that each observation of the returned data is a unique HUC-county intersection. Figure 3.25 below is a map of all the intersections of the HUC unit with HUC_CODE ==10170203
and the four intersecting counties.
tm_shape(filter(HUC_intersections, HUC_CODE == "10170203")) +
tm_polygons(col = "huc_county") +
tm_layout(frame = FALSE)
Note also that the attributes of county data are joined as you can see acres
in the output above. As I said earlier, st_intersection()
is a spatial kind of spatial join where the resulting observations are the intersections of the target and source sf
objects.
In order to find the area-weighted average of corn acres, you can use st_area()
first to calculate the area of the intersections, and then find the area-weighted average as follows:
(
HUC_aw_acres <- HUC_intersections %>%
#--- get area ---#
mutate(area = as.numeric(st_area(.))) %>%
#--- get area-weight by HUC unit ---#
group_by(HUC_CODE) %>%
mutate(weight = area / sum(area)) %>%
#--- calculate area-weighted corn acreage by HUC unit ---#
summarize(aw_acres = sum(weight * acres))
)
Simple feature collection with 55 features and 2 fields
geometry type: GEOMETRY
dimension: XY
bbox: xmin: 203228.6 ymin: 4470941 xmax: 736832.9 ymax: 4822687
CRS: EPSG:26915
# A tibble: 55 x 3
HUC_CODE aw_acres geometry
<chr> <dbl> <GEOMETRY [m]>
1 07020009 251140. POLYGON ((421317.4 4797758, 421179.2 4797632, 421079.3 479…
2 07040008 165000 POLYGON ((602943.6 4817205, 602935.1 4817167, 602875.1 481…
3 07060001 105224. MULTIPOLYGON (((631611.9 4817707, 631609.2 4817706, 631519…
4 07060002 140192. POLYGON ((593286.7 4817067, 593403.8 4817047, 593583.8 481…
5 07060003 149000 MULTIPOLYGON (((646504.9 4762382, 646518 4762383, 646554.8…
6 07060004 162121. POLYGON ((653200.4 4718423, 652967.7 4718504, 652457.7 471…
7 07060005 142428. POLYGON ((735347.8 4642385, 734779.1 4642296, 734459 46422…
8 07060006 159628. POLYGON ((692755.3 4694862, 692788.3 4694758, 692788.3 469…
9 07080101 115574. POLYGON ((667472 4558778, 667391.8 4558691, 667221.7 45585…
10 07080102 160017. POLYGON ((635032.8 4675786, 635247.8 4675644, 635367.8 467…
# … with 45 more rows