[GRASS-user] Joining vectors by location

Daniel Lee lee at isi-solutions.org
Sat Nov 26 13:30:20 EST 2011

Just another thing that's really weird - I ended up exporting the
geometries from GRASS to shapefiles, importing them to PostGIS with
shp2pgsql and viewing them in QGIS from the DB directly, just to see if
that would work. It did, just fine. Then I tried to view them with the
Geoserver again and still nothing. But now they're definitely in the
database. I also tried querying them to see if I could match them over
their primary keys -
SELECT gebaeude.cat FROM gebaeude, globalstrahlung WHERE gebaeude.cat =

and that of course gave me the cats back in the order they were in
globalstrahlung.alk_id. But it's still not a permanent table join like what
I'm trying to do in GRASS. Very strange. Maybe the solution would be to use
a mapset with SQLite?? Never tried that before. Then I could export the
data from there to a shapefile and import it into PostGIS, since I can't
get GRASS to export directly. I mean, it's a horrible workaround, but it's
the best solution that comes to mind.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20111126/412ff8ab/attachment.html

More information about the grass-user mailing list