I have a postgres database (postgis enabled with geometry columns), that I want to connect grass to with v.external. However, v.external seems to only "see" one table (layer) in the database, and does not seem to allow a connection with a view.
Since one table contains the site latitude longitude and geometry information, and another table contians the variables of interest from those sites, I created a view that contains both position information and variables of interest in hopes that I could connect to it with grass. So far, this does not seem to be the case.
Any other ideas as to how I might be able to bring a postgis view into grass?
Thanks,
Kirk
Hello Kirk,
Kirk Wythers <kwythers@umn.edu>, [20070131 - 13:24:28]
I have a postgres database (postgis enabled with geometry columns),
that I want to connect grass to with v.external. However, v.external
seems to only "see" one table (layer) in the database, and does not
seem to allow a connection with a view.
Since one table contains the site latitude longitude and geometry
information, and another table contians the variables of interest
from those sites, I created a view that contains both position
information and variables of interest in hopes that I could connect
to it with grass. So far, this does not seem to be the case.
Any other ideas as to how I might be able to bring a postgis view
into grass?
Have you inserted your view as a spatialy enabled view in
geometry_columns?
Perhaps this helps?
Best
Stephan
--
Stephan Holl: www.intevation.de/~stephan| GISpatcher: www.gispatcher.de
Intevation GmbH: www.intevation.de | GAV e.V.: www.grass-verein.de
Georgstr.4: 49074 Osnabrück | Telefon: +49(0)541. 3350832