So I have an sf object/data frame with 11 rows. The geometry is formatted as wkt strings. Some rows have MULTIPOINT geometry, while some have POINT geometry.
I was able to extract the coordinates and reformat them to lat long. Now I have a list of 18 pairs of coordinates. The data frame has only 11 rows, so I think they won’t merge well even if I include longitude points as a new column and a latitude column for the latitude points and append them to the data frame, but I have other data in the original table that is needed for the mapping of the coordinates. How can I include these extracted coordinates into the table / any other suggestions for how to make this work?