[GRASS-user] Load PostGIS layer with tow geometry columns

[Eloi Ribeiro]

On Tue, Apr 5, 2011 at 13:17, Martin Landa <landa.martin  gmail.com> wrote:

> Hi,
>
> 2011/4/5 Eloi Ribeiro <eloi.ribeiro  gmail.com>:
> > This is what I'm trying to do:
> > v.in.ogr dsn="PG:host=localhost dbname=bd_ceamsig user=postgres"
> > layer=sch_ambiente.escv_incendios_todos where="anyo=2009" output=temp
>
> missing `format=PostgreSQL` ?
>
> Martin
>
>
Thanks for your quick reply Martin,

Actually it's not a format parameter that I miss but a parameter that would
define which geometry I want to use in case there is more than one geometry
per layer/postgis table.

Example. In my table '*escv_incendios_todos'* I have tow filds/columns with
geometry, one is called geom_23030 (coord. syst. epsg 23030) and the other
geom_4258 (coord. syst. epsg 4258) and a trigger maintaining this
tow geometry's synchronized. In the geometry_columns table there are
tow entry's for the '*escv_incendios_todos' *table:

3970433;"''";"sch_ambiente";"escv_incendios_todos";"geom_23030";2;23030;"MULTIPOLYGON"
3970434;"''";"sch_ambiente";"escv_incendios_todos";"geom_4258";2;4258;"MULTIPOLYGON"

So when I try to load '*escv_incendios_todos'* in GRASS there is no way to
define which geometry I want to use. And the error  'ERROR: Layer
<layer_name> not available' jumps out.

By now I worked around by deleting the entry with the geometry I'm not
interested on the geometry_columns table and then insert it again.

Thanks. Regards,
-------------- próxima parte ----------
Um anexo em HTML foi limpo...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20110405/af58e691/attachment.html