1

I wanted to have an common (between two shapefile's) column filled in by certain criteria by creating a buffer first (based on that criteria) and the do some spatial join steps. However I noticed that the column's of the shapefile were added to my new buffer shapefile after doing the spatial join to the buffer.

I assumed that, because the columns did not share a name this was a problem. So I made sure to that the name of respective columns were to same. I redid the proces, but the same thing happened, so I deleted all fields that were not necessary (after making a copy of the shapefile). I redid it again and the same thing happened.

To illustrate enter image description here

How can I prevent this, what I am doing wrong here?

Edit: Go here if you want to know what I originally wanted: Filling a field in a layer using a spatial relation with another layer/shapefile?

Improve this question
9
  • 1
    As far as I know Spatial Joins in QGIS always create new columns, there is no way to update existing columns using a Spatial Join.
    – AndreasK
    Commented Mar 28, 2017 at 13:17
  • ....Oke then can you give me a another suggestion. I can simply solve this by deleting the street column. Then do the spatial join, however since this column wil be linked to another calculation, I sadly cannot do that.
    – ThunderSpark
    Commented Mar 28, 2017 at 13:19
  • Hmm, maybe I do not really get what you want. You could also copy the data from column "Straat_1" to column "Straat" and then you delete "Straat_1". Which Spatial Join Tool are you using?
    – AndreasK
    Commented Mar 28, 2017 at 13:33
  • please check here this is what I originally wanted gis.stackexchange.com/questions/233784/…. It is join attribute based on location that I use.
    – ThunderSpark
    Commented Mar 28, 2017 at 13:39
  • 1
    As commented before, my thoughts are for you to move away from the shapefile to and from PostGIS interaction, and use the offline editing plugin to convert the PostGIS database to a local spatialite file that can be used in the field and then be synced with PostGIS. One of the main advantages of a database is that you can use scripts to do the things that you are trying to do. If I am understanding things correctly.
    – Martin Hügi
    Commented Mar 28, 2017 at 16:50

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.