Please check the attached excel table.
In the excel table you want to import, the first three field should contain the following data:
PONT_ID PozX PozY
then comes the other fields (e.g species, land usage etc)
Then save the excel as txt (tabbed format)
After that rename the extension from .txt to .crd.
Then you are able to load this .crd file into DigiTerra Explorer v6, and you can see your points in the right positions.
Everything about spatial data conversion into digital GIS formats.
2 posts • Page 1 of 1
We have an Excel file, that contains attributes, coordinates and description about the used codes.
Let's see the process step-by-step:
1. Open MS Excel.
2. Select the records:
NO SPECIES HEIGHT (M) STEM GIRTH (M) CROWN SPREAD (M) AGE CLASS PHYSIOLOGICAL CONDITION STRUCTURAL CONDITION PRELIMINARY MANAGEMENT RISK CATEGORY PRIORITY EASTING NORTHING
987 Birch sp. 3,5 0,55 31 M Good Surface roots damaged. Tight fork. No visual defects observed. Crown lifted as part of extras to original works - CCTV clearance works L 404952,094 281017,906
3. Open Notepad and Ctrl+V (Paste)
4. Replace all "," to "."
5. Save txt.
6. Open DigiTerra Explorer and select the projection
7. Add the txt file.
8. Open "Source panel" and select
"X position field:" "Easting" and
"Y position field:" "Northing"
9. Delete first record because it doesn't contain real data, just the second line of the excel sheet:
LOCATION - SPORTS GROUND
10. Save this layer as .map file.
11. Open notepad again.
12. Paste the code lists from the excel sheet. (It has to be supervised, becouse it doesn't match with names of the fields). so:
$ AGE CLASS
EM Early mature
OM Over mature
$ RISK CATEGORY
H High target area
M Medium target area
L Low target area
A Needs urgent attention
B Needs attention in next 6 -18 months
C Work needed within 24 months
13. save the codes.txt
14. Rename the extension of codes.txt to cadbury_codes.cdt.
15. In DigiTerra Explorer open Settings>Record panel, and set codes.cdt as default code dictionary for this map project.
Who is online
Users browsing this forum: No registered users and 1 guest