[GRASS-user] Joining vectors by location

Richard Chirgwin rchirgwin at ozemail.com.au
Sun Nov 27 17:06:45 EST 2011

On 27/11/11 5:30 AM, Daniel Lee wrote:
> 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 <http://gebaeude.cat> FROM gebaeude, 
> globalstrahlung WHERE gebaeude.cat <http://gebaeude.cat> = 
> globalstrahlung.alk_id;
> 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.

What do you get if you run db.connect -p in the relevant mapset?

Richard C

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20111128/fa2df76b/attachment.html

More information about the grass-user mailing list