Hello, I have a bit on a conundrum. I have asset GIS data sitting in an ESRI Geodatabase, and the same data sitting separately in an asset management database. My job is to keep both databases in sync with each other. It has been some time since the initial copy was done so there are some differences in data and they have fallen out of sync. The asset management database is the point of truth for attribute data, with the GIS database being the point of truth for geometry data.
The ultimate goal is to have this data displayed on web maps, so when changes are made in the asset management database a daily scripted process using FME will write this attribute information to the ESRI table.
There are a number of ways I am considering approaching this. One such approach is creating a new dataset from the spatial data with only the primary key, and performing a table join with the attribute data coming from the attribute management database as an imported CSV and publishing these joined datasets as a map image.
Another method could be using a change detection in FME and updating the ESRI table when changes are made in the asset management database.
I am sure there are many options, but I am unsure with how best to approach this, and if anyone has any information or advice it would be greatly appreciated.
