i have a problem with annotation (ok i will explain) : in database i have :

  1. parcelle : a geometry table that contain polygons
  2. personne : a table contain parcel's owners
  3. pll_personne : is the relationship (n,n) between the (1) & (2)

enter image description here

what i want is : to display parcels with annotation Name of there owners see picture please

enter image description here

there is somebody that can help i'm very Jam !! :(


If you are storing your data in PostgreSQL your best bet is probably using a query layer. You should be able to define a query that joins Personne and Parcelle table through pll_parcelle and includes the names of the parcelle and owner. You can then join this table to your Parcelle layer to use in labeling.

Hope this helps

  • one parcel has more than one owner so i can create a table that has columns (id_pll,owners) and in onwners i will put data like this (owner1 concat owner2 ).....the problem is it will be in one line (owner1 owner2 owner3). – Mounaim Oct 3 '13 at 15:53
  • When you are concatenating the owner names you could try putting a carriage return or new line character between each owner name. – dblanchett Oct 3 '13 at 21:22
  • do you think it will be saved in database with the return to new line ? – Mounaim Oct 4 '13 at 14:00
  • Sorry I'm not sure what you are asking, but you should be able to save the concatenated names separated with carriage returns although I am not familiar with PostGres – dblanchett Oct 7 '13 at 13:40

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.