I am looking for feedback on editing and tabular reporting against a versioned enterprise GDB (Oracle, in our case).

 

Over time, we have come to regard an edit version as authoritative: people consult it with the expectation of seeing changes in real time.

 

The edit version is edited daily by ~4 technicians, and then we do a nightly reconcile/post/compress. I have never seen anything “wrong” enough with the edit version that someone asked me not to reconcile and post the day’s work. We don’t have any versions that persist long-term.

 

The existence of this edit version makes at least two things difficult: one is spatial views, and the other is tabular reporting. Both of these are possible with DEFAULT, but trying to target a specific edit version seems to be another matter entirely. For tabular reporting, we use the method described here: https://gis.stackexchange.com/a/164978/48394, but it’s not very performant.

 

Questions for the group:

1.       Should we be looking at editing DEFAULT instead? Stop versioning altogether? Pros/cons?

2.       Is anyone using spatial views that hit a specific edit version? How?

3.       Is anyone doing tabular reporting against a specific edit version, using a method other than that described above? How?

 

Thanks!

Andy