[GRASS-user] Export coordinates of 3D line feature into csv format?

Hi

I would like to export a 3D line feature into a csv format, as in:

x y z
1 2 3
.
.
.

I am not interested in the attribute tab;e, as I need the coordinates incl z.

Is this possible? I only managed to export the attribute table so far (which I do not need…)

Cheers,

Rainer


Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology, UCT), Dipl. Phys. (Germany)

Centre of Excellence for Invasion Biology
Stellenbosch University
South Africa

Tel : +33 - (0)9 53 10 27 44
Cell: +33 - (0)6 85 62 59 98
Fax (F): +33 - (0)9 58 10 27 44

Fax (D): +49 - (0)3 21 21 25 22 44

email: Rainer@krugs.de

Skype: RMkrug

On Fri, 2011-07-08 at 11:19 +0200, Rainer M Krug wrote:

Hi

I would like to export a 3D line feature into a csv format, as in:

x y z
1 2 3

.

.

.

I am not interested in the attribute tab;e, as I need the coordinates incl z.

FIrst create attrib columns for the X-Y-Z values:
v.db.addcol col=“x double precision, y double precision z double predision”
Then put the values into those columns
v.to.db option=coor column=“x,y,z”
Now export the attrib table as you did before.

Is this possible? I only managed to export the attribute table so far (which I do not need…)

Cheers,

Rainer


Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology, UCT), Dipl. Phys. (Germany)

Centre of Excellence for Invasion Biology
Stellenbosch University
South Africa

Tel : +33 - (0)9 53 10 27 44
Cell: +33 - (0)6 85 62 59 98
Fax (F): +33 - (0)9 58 10 27 44

Fax (D): +49 - (0)3 21 21 25 22 44

email: Rainer@krugs.de

Skype: RMkrug

This mail was received via Mail-SeCure System.

_______________________________________________
grass-user mailing list
[grass-user@lists.osgeo.org](mailto:grass-user@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/grass-user](http://lists.osgeo.org/mailman/listinfo/grass-user)

This mail was received via Mail-SeCure System.

On Fri, Jul 8, 2011 at 1:16 PM, Micha Silver <micha@arava.co.il> wrote:

On Fri, 2011-07-08 at 11:19 +0200, Rainer M Krug wrote:

Hi

I would like to export a 3D line feature into a csv format, as in:

x y z
1 2 3

.

.

.

I am not interested in the attribute tab;e, as I need the coordinates incl z.

Hi Micha,

v.db.addcol col=“x double precision, y double precision z double predision”
Then put the values into those columns
v.to.db option=coor column=“x,y,z”
Now export the attrib table as you did before.

This does unfortunately not work, as I have a line feature and not a point feature - and I would like to extract the co-ordinates of all vertexes of each line. I need this data, as I have to do some analysis afterwards for which I need the z-co-ordinate of each vertex. I could convert the lines to points, but how do I know which ones belong to which line and in which order?

Rainer

Is this possible? I only managed to export the attribute table so far (which I do not need…)

Cheers,

Rainer


Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology, UCT), Dipl. Phys. (Germany)

Centre of Excellence for Invasion Biology
Stellenbosch University
South Africa

Tel : +33 - (0)9 53 10 27 44
Cell: +33 - (0)6 85 62 59 98
Fax (F): +33 - (0)9 58 10 27 44

Fax (D): +49 - (0)3 21 21 25 22 44

email: Rainer@krugs.de

Skype: RMkrug

This mail was received via Mail-SeCure System.

_______________________________________________
grass-user mailing list
[grass-user@lists.osgeo.org](mailto:grass-user@lists.osgeo.org)
[http://lists.osgeo.org/mailman/listinfo/grass-user](http://lists.osgeo.org/mailman/listinfo/grass-user)

This mail was received via Mail-SeCure System.


Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology, UCT), Dipl. Phys. (Germany)

Centre of Excellence for Invasion Biology
Stellenbosch University
South Africa

Tel : +33 - (0)9 53 10 27 44
Cell: +33 - (0)6 85 62 59 98
Fax (F): +33 - (0)9 58 10 27 44

Fax (D): +49 - (0)3 21 21 25 22 44

email: Rainer@krugs.de

Skype: RMkrug

On 08/07/11 15:57, Rainer M Krug wrote:

On Fri, Jul 8, 2011 at 1:16 PM, Micha Silver <micha@arava.co.il
<mailto:micha@arava.co.il>> wrote:

    __
    On Fri, 2011-07-08 at 11:19 +0200, Rainer M Krug wrote:

    Hi

    I would like to export a 3D line feature into a csv format, as in:

    x y z
    1 2 3
    .

    I am not interested in the attribute tab;e, as I need the
    coordinates incl z.

Hi Micha,

    v.db.addcol <vectormap> col="x double precision, y double precision
    z double predision"
    Then put the values into those columns
    v.to.db <vectormap> option=coor column="x,y,z"
    Now export the attrib table as you did before.

This does unfortunately not work, as I have a line feature and not a
point feature - and I would like to extract the co-ordinates of
all vertexes of each line. I need this data, as I have to do some
analysis afterwards for which I need the z-co-ordinate of each vertex. I
could convert the lines to points, but how do I know which ones belong
to which line and in which order?

v.to.db option=start / option=end will give you the beginning and end coordinates of line beginnings and ends. AFAIK, this will not include each vertex of a line, only nodes.

Or you can use v.build option=dump, although the result will need some treatment to be usable.

Moritz