---
title: "Maps - Add National Co-ordinates to Point Details"
canonical: "https://servicedesk.maxgeo.com/space/DS/1125712460/Maps%20-%20Add%20National%20Co-ordinates%20to%20Point%20Details"
format: markdown
---
To display the National co-ordinates in the point detail dialog box edit the map views to add the required columns.

For example:

/*=================================================  
Author		Date		Comments  
S.Dexter		12/05/2023	Added National Co-ordinates at request of client

=================================================*/

ALTER VIEW [dbo].[tblVWWSDHColl] AS

SELECT c.Dataset,c.Hole_ID, **c.NAT_East, c.NAT_North, c.NAT_RL,**  
c.LL_Lat, c.LL_Long, C.LL_RL, c.Max_Depth, c.Lease_ID, Prospect,  
convert(date,c.Date_Started,103) as Date_Started, convert(date,C.Date_Completed,103) as Date_Completed,  
	case when c.Hole_Type like 'DD%' then 'DD' else c.Hole_Type end as Hole_Type,  
	c.Hole_Status,lith.Lith1_Code AS BOH_Geol

FROM    dbo.tblDHColl c LEFT OUTER JOIN  
                          (SELECT     DataSet, Hole_id  
                            FROM      dbo.tblVWDHAssays  
                            GROUP BY  DataSet, Hole_ID) t ON c.DataSet = t.DataSet AND c.Hole_ID = t.Hole_id  
						LEFT OUTER JOIN  
                          (SELECT     tblDHLithology.DataSet, tblDHLithology.Hole_id, tblDHLithology.Depth_From,               tblDHLithology.Lith1_Code  
                            FROM      tblDHLithology  
						INNER JOIN  
                            (SELECT   DataSet, Hole_id, MAX(Depth_From) AS Depth_From  
                            FROM      tblDHLithology  
GROUP BY DataSet, Hole_id) AS l 

ON tblDHLithology.DataSet = l.Dataset AND tblDHLithology.Hole_id = l.Hole_id  
AND  tblDHLithology.Depth_From = l.Depth_From) lith ON c.DataSet = lith.DataSet  
AND c.Hole_ID = lith.Hole_id 

WHERE ll_Lat is not null and LL_Long is not null 

![image](media://beb4c496-4738-47d9-b6b4-04b66c9ca6c5)