Downhole Survey Coordinates

Click the Build button to load or create the SQL query. The downhole survey coordinates are transformed to the target coordinate system as specified on the Settings tab of the Plan View Property Editor. Easting and Northing downhole coordinates are used to display the trace in Plan view by joining the points for each drillhole.

The list of system columns should be as follows (bold are required fields):

PROJECT, SITE_ID, COORDSYS, EASTING, NORTHING, HEIGHT		

The default query used to obtain the downhole survey coordinates should be similar to the following:

SELECT 
	PROJECT,
	SITE_ID,
	COORDSYS,
	EASTING,
	NORTHING,
	HEIGHT
FROM
	GB_DOWNHOLE_SURVEY_COORDS
WHERE
	PROJECT = N'?Select Project?' AND INSTANCE = 1
ORDER BY 
	PROJECT, SITE_ID, DEPTH