I'm opening a PostgreSQL Table on QGIS which has multiple rows related to the same object (think of how you'd register distinct apartments on the same building).

I do get to style it based on any of it's columns, but at the same time I know that some of the objects have distinct values for some of the fields (valuation, for example).

Which of the rows is QGIS taking the value on which the style is based?

  • 1
    it should be using all of them! in the case of spatially coincident apartments, you just won't see the apartments below the top one - which you can set using symbol levels... Jun 14, 2016 at 17:36
  • Mhhhh, and what about Labels, shouldn't both work the same way? When I label the object only one of the rows gets labeled. Jun 14, 2016 at 17:42
  • 1
    I would have to guess it's because there are too many colliding labels, so QGIS isn't displaying them... there is an option to 'show all labels, including colliding' which you can check on... Jun 14, 2016 at 17:43
  • You have nailed it my friend, when I check the 'including coliding' box, all labels, well, collide. Is there a way to represent this in a readable manner? Jun 14, 2016 at 17:45
  • And the same with styling, I'm trying to map how the apartments in each bulding have been valuated. I'd probably need to use some sort of 3D cadastre or even split each object and then assign the rows to the result. But maybe there is a better way to do this. Jun 14, 2016 at 17:50


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.