I am hoping to generate some ideas on how I should best handle a weekly update of some GIS data, particularly the attributes.
This seems simple enough but I wanted to see what other’s thought. I am working on a project where we have some parcels and each one has a status (with like 9 different options). Each week, we update this status with a new status, but only when it needs updating. The parcels have unique identifiers.
We get this info in the form of an Excel sheet (with the unique parcel number and the new status, etc.). So far, I have been manually updating each parcel’s status with the new status since this is the quick and dirty way, but I want to find a more automated solution.
Based on this vague information, what are your thoughts on the most efficient way of handling this?
(to shorten this post, I’ll put some thoughts in a reply below)