I've been set a challenge which is a bit out of my comfort zone. I'm an esri developer trying to break into the open source world.
I've been asked to automate the update of some oracle SDO datasets. I have a boundaries dataset (X) that needs to match topologically with OS Mastermap data. At the moment, the Mastermap update is a manual process (disk in the post!). If a boundary in the OS data is updated e.g a field is reduced as a result of a new road, the same field in dataset X needs to be updated accordingly. At first, I'm expected to flag up any changes that will need to be made to dataset X. Eventually, dataset X will be updated automatically. I also need to store the changes made for audit purposes. I've been challenged to achive the above with an open source stack.
My initial thoughts are that a workflow could look like – download update -> import dataset -> select all new and updated toids in OS dataset -> some kind of spatial query to identify effected features in dataset x-> export selected features to archive -> edit selected to snap to new OS boundaries.
Has anyone attempted something similar? What tooling would the community recommend?