I'm currently caught in a wormhole trying to figure out how to go about my project:
I'm creating a model in ArcGIS Pro 3.3.0 to generate a Master Address Table (MAT) for my municipality. We're using Survey123 Web Browser to collect subaddresses within our existing parcels (units, apartments, etc.). The Survey123 data will be downloaded, cleaned and added to a master subaddress shapefile, to later be added to another table of all addresses (MAT). I just did a lot of reading on UID's and found that Global ID's can repeat and are not necessarily 'unique'.
I need help determining how to (1) create a process that will allow the new entries to be added to the master subaddresses, without overwriting the data that has already been cleaned and entered. I currently have the Append Tool in my model, (2) but it will not function until I have established a UID.
Potential Solutions(?) :
1. Play with settings in append tool to ensure the clean data is not overwritten or use a different tool if this isn't possible.
2. Determine how to auto-generate UID's in Survey123 Web Browser, that will not repeat, especially if part of the solution to issue #1 is to delete the previous entries from the survey after they've been exported. The ideal situation would be to have a new UID every entry, even if one was deleted or scrapped to avoid error in the data.
Each subaddress will be assigned another UID after they're compiled, both old and new but before combining with the parcel addresses (separate sequence format), so I don't need the UID to serve any other purpose other than being unique to allow the data to be appended to the existing/previously entered data table. I'm suspicious of the web browsers capabilities, and fearful of having to create this in Survey123 Connect.
If anyone has any thoughts/suggestions/questions, all are welcome and very much appreciated! I keep reading and reading and my brain is going in circles... Thank you.
