Monthly Archives: July 2013

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.

 

 

Converting a survey plat in degrees to XY coordinates for use in mapping software (Kingdom, ArcGIS, etc.)

Use this spreadsheet to convert lat/long degrees to XY coordinates.  The primary use of this spreadsheet was to allow the user to convert old paper copies of drilling & production units (Louisiana DNR Office of Conservation Units) into a usable format for display in their mapping software.  In my case, we converted the lat/long “call points” which were posted on the plat as a bearing and distance, and convert them over to the Louisiana State Plane XY Lambert coordinate system.  Once in XY format, the values can be copied into most software to display the polygon shapes.  The mapping software we use are IHS/SMT Kingdom and ArcGIS.

XY Conversion Spreadsheet (for plotting survey plats) 071813

Using Kingdom licenses over the internet

It is possible to allow users to access a networked kingdom license server over the internet thereby enabling users working from home or while away from the office. The license server listens for requests on UDP port 5093, so you can use NAT on your router to redirect those requests to your license server. Once that is set up, you can enter your public IP address or DNS name that resolves to it into the license section of your 2d3dpak.set file located in your home folder.

C:\Users\<your user name>\KingdomSuite\2d3dpak.set (windows 7)

Below is that section from my 2d3dpak.set file.

[License]
LSServer=KINGDOM.GEOTECHTOOLBOX.COM

** If you can, create a firewall rule allowing only the IP addresses if your remote locations to access the redirected ports. Otherwise, it is possible for someone you don’t know to check out a license. This isn’t always possible if the remote location has a dynamic IP address or if the user will be traveling to unknown locations.