How to import excel table into DigiTerra Explorer v6?

Everything about spatial data conversion into digital GIS formats.
User avatar
peterm
Posts: 91
Joined: Sat Aug 29, 2009 10:41 am
Location: Budapest, Hungary
Contact:

How to import excel table into DigiTerra Explorer v6?

Postby peterm » Tue Mar 29, 2011 4:14 pm

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.
Attachments
point_text.zip
(4.09 KiB) Downloaded 380 times

User avatar
peterm
Posts: 91
Joined: Sat Aug 29, 2009 10:41 am
Location: Budapest, Hungary
Contact:

Re: How to import excel table into DigiTerra Explorer v6?

Postby peterm » Tue Jul 26, 2011 2:27 pm

The Task:
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
Y Young
EM Early mature
M Mature
OM Over mature
V Veteran

$ RISK CATEGORY
H High target area
M Medium target area
L Low target area

$ PRIORITY
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.


Return to “Data conversion”

Who is online

Users browsing this forum: No registered users and 1 guest