In the new Australian Defence Force data acquired by the Vanuatu Government Lands Survey and Registry Department, there are some discrepancies in the data attributes. Two examples are 2,8882 contour elevations around South Efate and Oval Place Names. These makes it difficult to control labeling the places or contours in a map window.
The best way around is to remove all the labels in the data itself and thus I found SQL select to be the best tool to fix this. See below window on how to do this.
In the SQL select dialogue box:
For table field, select Places_P (orginal table name), and in condition field, input P_Name="Oval".
Some Place Names includes Oval text. In that case use condition P_Name like "%oval".
For the contour issues, select table Contour_L, and condition is Elevation=28882. Do not use thousand comma seperator.
In the SQL select dialogue box:
For table field, select Places_P (orginal table name), and in condition field, input P_Name="Oval".
Some Place Names includes Oval text. In that case use condition P_Name like "%oval".
For the contour issues, select table Contour_L, and condition is Elevation=28882. Do not use thousand comma seperator.
