2

I've got a shapefile lines with ID attribute and .dbf with values which corresponds do ID. Every value in dbf is in different record.

I want to style lines and display label using these values from dbf. I tried to use Join tool in layer's properties in QGIS but it joined only a few of values.

enter image description here


I shown you just a simplified example...

My "real life" problem is a little bit different. I've got a shapefile with geometry of roads. Every link of the roads has a unique ID attribute. On the other hand I've got a dbf file with information about road restriction.

Structure of dbf is: road_linkID - type - value

road_link1 - max_height - 2
road_link1 - speed limit - 50
road_link1 - max_weight - 3,5
road_link2 - speedlimit - 60
road_link3 - max_weight - 3,5
road_link3 - speedlimit - 60
road_link3 - max_height - 4

When I'm using layer\properties\join to my road.shp adds one column with only one parameter:

road_link1 - max_height - 2
road_link2 - speedlimit - 60
road_link3 - max_weight - 3,5
  • 1
    It sounds like you already have the solution but something went wrong. Maybe you can provide the join / link command you used if you cant find the error yourself. If it only joined / linked a few values, you may have given the wrong data for the attributes to join or have some ghostsigns (e.g. spaces) that prevent a proper join or link. – Papierwolf Feb 22 '16 at 11:48
  • Is the .dbf file supposed to belong to the .shp file? – Joseph Feb 22 '16 at 12:23
  • it's just a simplified example.... – pawaelus Feb 22 '16 at 12:37
  • Could you perhaps share your data so that others could test it? From the example you gave, your shapefile only contains 3 attributes whereas your .dbf contains more (rows = features; columns = attributes). I think maybe you want to add more columns? – Joseph Feb 22 '16 at 14:32
  • Here is my data: wikisend.com/download/158200/test.7z – pawaelus Feb 22 '16 at 20:31
2

Is it possible to modify your .dbf file ? In your case with your simple data "join" is one to one relationship. In my opinion it should looks like this:

enter image description here

And layer with lines:

enter image description here

Now you can make join with: Layer>Properties:

enter image description here

The result looks like this:

enter image description here

  • I think it would be enough. I can't modify my dbf by hand because it's data of whole country so, it would took years to change everything. Do you know which tools I could use to modify? – pawaelus Mar 1 '16 at 13:12
  • Try to open and edit it with an excel app. – Artec Mar 1 '16 at 15:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.