I have a database of fire hydrants (HYD). The positions aren't very exact, the other fields are very useful. I also have a database of GPS'd fire hydrants (GPS). We are manually moving the HYD points to snap to the GPS points, and will then do a join on spatially equal features.
Being manual, this gets tedious, and it can be helpful if a visual indication shows you have actually successfully snapped the HYD to the GPS point. (lets say the HYD point goes from red to yellow, for instance, or changes size/shape, etc)
I've come at this from different angles, but can't seem to find a good way with PostGIS or QGIS to make this visual change happen.
Help? Also, note, we are doing this with approx 40 features types, and some will involve lines touching points. Similar enough concept, though.