Hello Grass users,
I am struggling to import a .e00 vector map into GRASS and retain attributes contained in a separate .dbf file that serves as a lookup table. Here are the details.
I started with an Arc .e00 export file that contains one vector coverage. In addition I received a separate, complementary .dbf file that contains several descriptive fields related to the polygons in the .e00 file.
Here's what I've done so far:
1. Import the .e00 file into GRASS 5.3 (using m.in.e00).
2. Switch to GRASS 5.7
3. Convert the v5.3 vector to a v5.7 vector
I now have both a GRASS vector file and a .dbf file (that was automatically generated during the import). This .dbf file contains two columns: "cat" and "label".
I have a second .dbf file (the one that came with the dataset). This .dbf file has several columns, including a "label" field that matches up with the "label", but this file has no "cat" column (i.e. it is a lookup table based on the field "label").
Now is where I get stuck. How can I link all of the information that is in this second, external table with the table that was generated by m.in.e00?
I hope I have been clear enough. I am fairly new to GRASS and any advice you may have would be much appreciated.
Thank you,
Jed Kaplan
You have to reclass the vector with values from "label" column
and then relink to the new dbf table (v.db.connect).
Unfortunately v.reclass col=label will not work because it is not
of type integer, so you have to generate a reclass file
(db.select | awk ....) or open the dbf file in openoffice
and change the type to integer.
Radim
On Thursday 15 July 2004 19:44, Jed O. Kaplan wrote:
Hello Grass users,
I am struggling to import a .e00 vector map into GRASS and retain
attributes contained in a separate .dbf file that serves as a lookup
table. Here are the details.
I started with an Arc .e00 export file that contains one vector
coverage. In addition I received a separate, complementary .dbf file
that contains several descriptive fields related to the polygons in the
.e00 file.
Here's what I've done so far:
1. Import the .e00 file into GRASS 5.3 (using m.in.e00).
2. Switch to GRASS 5.7
3. Convert the v5.3 vector to a v5.7 vector
I now have both a GRASS vector file and a .dbf file (that was
automatically generated during the import). This .dbf file contains
two columns: "cat" and "label".
I have a second .dbf file (the one that came with the dataset). This
.dbf file has several columns, including a "label" field that matches
up with the "label", but this file has no "cat" column (i.e. it is a
lookup table based on the field "label").
Now is where I get stuck. How can I link all of the information that is
in this second, external table with the table that was generated by
m.in.e00?
I hope I have been clear enough. I am fairly new to GRASS and any
advice you may have would be much appreciated.
Thank you,
Jed Kaplan