[GRASS-user] Joining vectors by location
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> =
> 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?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the grass-user