[GRASS-user] Accessing PostGIS from GRASS 6.2.1

GRASS GRASS user
,
1

Hello members of the list,

I have a problem downloading the right geometries from PostGIS tables.

I have a PostGIS table storing two geometry columns. How can I access these two different columns with v.in.ogr.
v.in.ogr -l dsn=… gives me two times the same name of the table.
A workaround with views or temporary tables won’t work because GRASS accesses the geometry_columns table and there are no entries for temporary tables or views.

cheers from Luxembourg,
Christian

Mit freundlichen Grüssen,

Dipl. Geogr. Christian Braun
Tel: +352- 425991-608
Mobil: +49-179-6845896
Mail: christian.braun@tudor.lu

Resource Centre for Environmental Technologies,
Public Research Centre Henri Tudor,
Technoport Schlassgoart,
66 rue de Luxembourg,
P.O. BOX 144,
L-4002 Esch-sur-Alzette, Luxembourg

2

Hello Christian,

christian.braun@tudor.lu, [20070620 - 12:24:51]

I have a problem downloading the right geometries from PostGIS tables.

I have a PostGIS table storing two geometry columns. How can I access
these two different columns with v.in.ogr.
v.in.ogr -l dsn=... gives me two times the same name of the table.
A workaround with views or temporary tables won't work because GRASS
accesses the geometry_columns table and there are no entries for
temporary tables or views.

Just add 2 entries in geometry_columns, one for the first geom-column,
one for the second. this should work.

btw OGC sais said every layers needs an entry in the geometry_columns
because that is the place where the PostGIS-clients look for layers.
Adding views there makes them work as well.

Best
  Stephan
--
Stephan Holl <stephan.holl@intevation.de>, http://intevation.de/~stephan
Tel: +49 (0)541-33 50 8 32 | Intevation GmbH | AG Osnabrück - HR B 18998
Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner

3

Hi Stephan,

there are two entries by default in the geometry_columns. But the entries are referenced to the table name and this is in my case, of course, the same name. Like I described in my first question.
At the “layer select”-dialog in QGIS for instance it is possible to select the geometry columns itself. I wish to have such a procedure in GRASS to. Something like a flag for v.in.ogr where you can specify the column to use.

Thanks,
Christian

Mit freundlichen Grüssen,

Dipl. Geogr. Christian Braun
Tel: +352- 425991-608
Mobil: +49-179-6845896
Mail: christian.braun@tudor.lu

Resource Centre for Environmental Technologies,
Public Research Centre Henri Tudor,
Technoport Schlassgoart,
66 rue de Luxembourg,
P.O. BOX 144,
L-4002 Esch-sur-Alzette, Luxembourg