0

I have a problem with annotation In an Enterprise Geodatabase.

In the 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

How do I display parcels with annotation Name of their owners (see picture)?

enter image description here

Improve this question

1 Answer 1

Reset to default
1

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.

Improve this answer
4
  • 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, 2013 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, 2013 at 21:22
  • do you think it will be saved in database with the return to new line ?
    – Mounaim
    Oct 4, 2013 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, 2013 at 13:40

Your Answer

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

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