<html style="direction: ltr;">
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="latin-charset" bgcolor="#FFFFFF"
text="#000000">
On 24/11/2011 10:47, Daniel Lee wrote:
<blockquote
cite="mid:CAJHDHfqW_ruDBqP9TBu+-rHxFVC+GHZavLgHgvS=CF8eJEp5Yg@mail.gmail.com"
type="cite">
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="gmail_quote">
<div class="im">
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
You can use v.distance with dmax=0 to do such a "spatial
join" between polygons and points:<br>
<br>
v.db.addcolumn YourCentroids col='poly_cat int'<br>
v.distance from=YourCentroids to=YourPolygons upload=cat
column=poly_cat dmax=0<br>
<br>
This should upload the category values of your polygons
to the attribute value of your centroids. If you then
want to join the two tables, you can use v.db.join.<br>
</blockquote>
</div>
</div>
</blockquote>
</div>
<div>Alright, I tried that out and it worked pretty well. At least
the spatial join - the table join didn't work because I'm
working with GRASS' native vector format, which apparently uses
DBF. I'm currently trying to upload the data into my PostGIS DB
to do the next step, but I'm having some trouble there - I get
the following error when using v.out.ogr:</div>
<div><br>
</div>
</blockquote>
<br>
Could it be that you're confusing two things: <br>
1- Configure GRASS to use a PostgreSQL database for attribute data<br>
vs<br>
2- Move your vector layers out to a PostGIS spatial database<br>
<br>
These are not the same. If you want to export a GRASS layer out to a
PostGIS DB then v.out.ogr is the right module.<br>
If, on the other hand, you want to keep your data as GRASS vectors,
but move the *attributes* to PostgreSQL then do:<br>
(straight from the man page...)<br>
db.connect driver=pg database="host=myserver.itc.it,dbname=mydb"<br>
db.login user=myname [pass=secret]<br>
db.connect -p<br>
This will set your default database connection to PostgreSQL,
instead of dbf. Now you should copy your vectors to a new name in
the mapset, and let GRASS make the Postgresql attribute tables.<br>
g.copy <vector1>,<newvector1><br>
The new copies will still be GRASS vectors, but with their attribs
in PostgreSQL database.<br>
<br>
<br>
<blockquote
cite="mid:CAJHDHfqW_ruDBqP9TBu+-rHxFVC+GHZavLgHgvS=CF8eJEp5Yg@mail.gmail.com"
type="cite">
<div><span class="Apple-style-span" style="color: rgb(34, 34, 34);
font-family: arial, sans-serif; font-size: 13px;
background-color: rgba(255, 255, 255, 0.917969); ">ERROR 1:
ERROR: permission denied for relation geography_columns</span><br
style="color: rgb(34, 34, 34); font-family: arial, sans-serif;
font-size: 13px; background-color: rgba(255, 255, 255,
0.917969); ">
<br style="color: rgb(34, 34, 34); font-family: arial,
sans-serif; font-size: 13px; background-color: rgba(255, 255,
255, 0.917969); ">
</div>
</blockquote>
<br>
This is a permissions prob within PostGIS... You need to GRANT ALL
ON geography_columns TO <username>;<br>
<br>
HTH,<br>
Micha<br>
<br>
<blockquote
cite="mid:CAJHDHfqW_ruDBqP9TBu+-rHxFVC+GHZavLgHgvS=CF8eJEp5Yg@mail.gmail.com"
type="cite">
<div><span class="Apple-style-span" style="color: rgb(34, 34, 34);
font-family: arial, sans-serif; font-size: 13px;
background-color: rgba(255, 255, 255, 0.917969); ">ERROR 1:
PostgreSQL driver doesn't currently support database creation.</span><br
style="color: rgb(34, 34, 34); font-family: arial, sans-serif;
font-size: 13px; background-color: rgba(255, 255, 255,
0.917969); ">
<span class="Apple-style-span" style="color: rgb(34, 34, 34);
font-family: arial, sans-serif; font-size: 13px;
background-color: rgba(255, 255, 255, 0.917969); ">Please
create database with the `createdb' command.</span></div>
<div><span class="Apple-style-span" style="color: rgb(34, 34, 34);
font-family: arial, sans-serif; font-size: 13px;
background-color: rgba(255, 255, 255, 0.917969); "><br>
</span></div>
<div><span class="Apple-style-span" style="color: rgb(34, 34, 34);
font-family: arial, sans-serif; font-size: 13px;
background-color: rgba(255, 255, 255, 0.917969); ">Which is
strange, because I'm the owner of the database and it exists
already. I've already checked to make sure I'm the owner of
the tables too.</span></div>
<div><span class="Apple-style-span" style="color: rgb(34, 34, 34);
font-family: arial, sans-serif; font-size: 13px;
background-color: rgba(255, 255, 255, 0.917969); "><br>
</span></div>
<div><span class="Apple-style-span" style="color: rgb(34, 34, 34);
font-family: arial, sans-serif; font-size: 13px;
background-color: rgba(255, 255, 255, 0.917969); ">Not too
experienced with PostGIS, it's probably a newbie error...
Anyway, that's where I'm at at the moment :)</span></div>
<br>
This mail was received via Mail-SeCure System.<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
grass-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:grass-user@lists.osgeo.org">grass-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/grass-user">http://lists.osgeo.org/mailman/listinfo/grass-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<p><br>
</p>
</body>
</html>