Hi everyone. I am new to these forums, and new to utility gis mapping. I thought this might be a good place to get some peer advice on workflow. I am working on our stormwater inventory. We have an old partial inventory of our system that was done a few years back. We have found a lot of discrepancies, so we are reinventorying the system. I have a geodatabase that contains feature classes for each type of infrastructure ( catch basins, junction box, outfall, etc.) of the old inventory and one that contains all the information of the new inventory. The new inventory is collected via GPS weekly, so I am constantly updating these files. I need to be able to give my GIS data to an online company that we will be using to manage all stormwater reporting requirements and it has an online GIS feature. I will not be able to update this information freely, so I need to be able to have both the old and new information available on the website. I will probably be able to update the GIS data on this website annually since there is a cost for updating. All of the old inventory is labeled by a specific ID. The new inventory has the same id, with some additional structures that will need to be renamed to fit the existing numbering scheme.
I guess my question is what is the best way to combine these two files into one file, and where two points are representing the same structure delete the old data? In this case, the old point and new point will not be identical. The gps points will be slightly different and the new data will have more attributes than the old data.
I'm sorry if this is lengthy, but I am having a hard time coming up with the best way to manage this data. I am not aware of all the extensions available, so I might miss an easy way to acheive this task. Thank you so much for your help.