[GRASS-user] exporting only a table from a vector

GRASS GRASS user
1

Dear all,

I have a vector map with its attributes on GRASS
and I would like to export only the table (not the vector),
and select some fields during the export.

Is there a way of do it on GRASS?

Kind regards

miltinho astronauta
brazil

2

On Fri, 2008-08-01 at 16:19 -0300, Milton Cezar Ribeiro wrote:
[...]

2008/8/1, Nikos Alexandris <nikos.alexandris@felis.uni-freiburg.de>:

[...]

        Hi Milton.
        
        If you use sqlite as DBMS you can open your sqlite.db file
        with
        sqlitebrowser and export your table of interest as a .csv
        file. Later
        you can import for example in openoffice for further editing.

[...]

Milton, I assume it works for you this way. Anyway, I am writing back to
note that it was not my intention NOT to cc in the list. For some reason
I don't hit always the reply-to-all button lately :-?

Cheers, Nikos

3

On Friday 01 August 2008, Nikos Alexandris wrote:

On Fri, 2008-08-01 at 16:19 -0300, Milton Cezar Ribeiro wrote:
[...]

> 2008/8/1, Nikos Alexandris <nikos.alexandris@felis.uni-freiburg.de>:

[...]

> Hi Milton.
>
> If you use sqlite as DBMS you can open your sqlite.db file
> with
> sqlitebrowser and export your table of interest as a .csv
> file. Later
> you can import for example in openoffice for further editing.

[...]

db.select should do what you want. I use it regularly to make CSV file for
export.

Cheers,

--
Dylan Beaudette
Soil Resource Laboratory
http://casoilresource.lawr.ucdavis.edu/
University of California at Davis
530.754.7341

4

On Fri, Aug 1, 2008 at 8:41 PM, Milton Cezar Ribeiro
<miltinho.astronauta@gmail.com> wrote:

Dear all,

I have a vector map with its attributes on GRASS
and I would like to export only the table (not the vector),
and select some fields during the export.

Is there a way of do it on GRASS?

Yes: db.out.ogr

Description:
Exports attribute tables into various formats.

Markus

5

On 02/08/08 02:53, Dylan Beaudette wrote:

On Friday 01 August 2008, Nikos Alexandris wrote:

On Fri, 2008-08-01 at 16:19 -0300, Milton Cezar Ribeiro wrote:
[...]

2008/8/1, Nikos Alexandris <nikos.alexandris@felis.uni-freiburg.de>:

[...]

        Hi Milton.

        If you use sqlite as DBMS you can open your sqlite.db file
        with
        sqlitebrowser and export your table of interest as a .csv
        file. Later
        you can import for example in openoffice for further editing.

[...]

db.select should do what you want. I use it regularly to make CSV file for export.

Or (maybe easier): v.db.select.

Moritz

6

Thanks to all your help,

Several of your suggestions solved my problem with this task.

Kind regards,

miltinho astronauta
brazil

2008/8/2, Moritz Lennert <mlennert@club.worldonline.be>:

On 02/08/08 02:53, Dylan Beaudette wrote:

On Friday 01 August 2008, Nikos Alexandris wrote:

On Fri, 2008-08-01 at 16:19 -0300, Milton Cezar Ribeiro wrote:
[…]

2008/8/1, Nikos Alexandris <nikos.alexandris@felis.uni-freiburg.de>:

[…]

Hi Milton.

If you use sqlite as DBMS you can open your sqlite.db file
with
sqlitebrowser and export your table of interest as a .csv
file. Later
you can import for example in openoffice for further editing.

[…]

db.select should do what you want. I use it regularly to make CSV file for export.

Or (maybe easier): v.db.select.

Moritz

grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user