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?

| improve this question | | | | |
  • 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... – DPSSpatial Jun 14 '16 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. – Facundo Perez Jun 14 '16 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... – DPSSpatial Jun 14 '16 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? – Facundo Perez Jun 14 '16 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. – Facundo Perez Jun 14 '16 at 17:50

Your Answer

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

Browse other questions tagged or ask your own question.