Saturday, June 15, 2002

Seismic Navigation Data Management

This was a quick interim build to solve a data migration problem. We had seismic navigation / shot point data etc in a large Oracle database which was maintained and loaded by a utility that was running on old Solaris UNIX boxes. We wanted to get rid of the old UNIX boxes and replace them with Windows machines. At the time we were meant to port everything to ArcGIS however back then the SDE feature model was not sufficiently matured to manage attributed shotpoint data with geometric and linearly referenced constraints to the corresponding seismic line. Our solution was to NOT migrate the Oracle database but instead put a quick Windows application on top of it that could manage the loading and editing.

After a few years we migrated the legacy database to SDE using linear referencing and thats how it remains to this day (to my knowledge).