Finding scattered seismic files in a Kingdom Project

Every now and then, a Geophysicist will run Automatic Gain Control or some other function on a seismic volume in a Kingdom Project. This results in a new seismic file being created. During the process the geophysicists is asked where he would like to save the file, and the program defaults to the last accessed folder. The last accessed folder usually ends up being the colorbar folder. If the geophysicist just clicks OK, a seismic file is created with a name like seismic0001200.ksd. The file name dosent give much to go on about which project it belongs to. The way I handle this to go directly to the database for each project and query for the seismic volumes in the project. The following SQL statement will output all the volumes in all the surveys in a project.

select dbo.T000000_T_SeismicData.ID, SurveyID, PathLocator, SeismicPathLocator, dbo.T000000_T_SeismicType.Name from dbo.T000000_T_SeismicData
LEFT JOIN dbo.T000000_T_SeismicType on
dbo.T000000_T_SeismicData.ID = dbo.T000000_T_SeismicType.ID

The name returned in PathLocator is the file name minus the extension .1 or .ksd.

The SeismicPathLocator can contain nothing, meaning the root of the project directory. It may contain a path starting with a \, indicating the root of the same drive letter. Or it may contain a relative path starting at the project folder, indicated by no \ at the begining.

Below is an example of the output of this query

query

Once you have located the files, you can move them to the project directory and open the kingdom project. Dont forget to move the KNX file as well as the KND file.  Open a seismic line and choose the volume that you have moved. An error will pop up alerting you to the fact that the seismic file is not where it should be and asks you to select the file. Browse to where you have moved it and select the appropriate file. Your project is now neat and tidy and much easier to manage.

 

 

Leave a Reply

Your email address will not be published.