[Qgis-user] Update field based on a value from another layer

[Tony Shepherd (FarmMaps NZ)]

Hi All

 

Am I missing something?  Is there a simple point and click tool in QGIS to
update an existing field in a QGIS layer based on a value in another using a
geographic join?  For example a series of points and a series polygons.  I
want to update a field in points from a value in a field in polygons based
on which polygon the point falls in.  Simple stuff.

 

In a previous life using MapInfo we simply used query editor and

update point_layer set col1 = colx from polygon_layer where obj within any

 

To me, this seems like a very simple everyday thing to do to an existing
table.  I can, of course, use vector -> Join Attributes by Column but why in
this case would I needlessly complicate things by having to create a third
layer?  I don't need an extra layer, I just need to update the one I have
already.

 

I can see that the internet is littered with similar questions dating back
as long as QGIS has been around.  Perhaps I have missed something obvious,
and if so apologies for wasting the time of others, but can you point me to
the tool?

 

Cheers

Tony

 

Tony Shepherd  |  GeoSpatial / Mapping Manager

Ph 027 435 6193  |  E  <mailto:tony at farmmaps.nz> tony at farmmaps.nz

FarmMaps NZ, 3 Kerwood Place, Gore 9740

 



 

 

 <http://tonyshepherd8.wixsite.com/home>
<https://www.wunderground.com/personal-weather-station/dashboard?ID=ISTLGORE
2> 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200624/c47076af/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 3062 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200624/c47076af/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 2467 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200624/c47076af/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 2510 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200624/c47076af/attachment-0001.png>