I am relatively new to GIS.
- I have an existing shapefile of New Zealand islands that details island name, Lat/Long, island group, area, etc. Included in this shapefile is a unique FID for each island. This information is quite extensive (polygons are provided down to the rock stack level: <0.01 ha in size) but is missing some information. Islands that are quite small, for example, often do not have a name. For my analysis I wanted to add in some of this classification information.
- I have imported a CSV file from excel that attempts to fill in some of this missing information: I have manually added in names and archipelago groups that were missing from many islands. The FID of these islands remains the same as the shapefile, I just used excel to "fill in the holes" because excel is so easy to manipulate.
- I want to append the information that I have added in the CSV file to the existing NZ island shapefile. From my (limited) experience using a JOIN in GIS adds in a new column. Instead, I want to fill in the existing holes of the shapefile with information from my CSV file, based on the unique FID.
Does this make sense?