Skip to content

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


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.



Posted in

Dennis Bourn

For over two decades, Dennis Bourn and the team at Bourn Technology have been helping engineering firms, law practices and many other businesses across New Orleans and the surrounding areas get the most from the technology they value so much. To find out more information about what the right MSP can bring to the table, or to learn more about aligning your IT with your long-term goals as a business, please don't delay - contact Bourn Technology today.

Leave a Comment

Stay in the Know

Subscribe to our email newsletter today to receive updates on the latest news, cybersecurity tips and tricks and more. Enter your name and email address below to be the first to know.

Download Your FREE E-book Today

efficient business ebook cover

Not everything is black and white in business. Yet the importance of business efficiency is indisputable. To find out everything you need to know about the best choices for your business, download your copy of our free eBook - Efficient Businesses Run On Efficient I.T.

Ebook download - blog sidebar