Timeline for How to build query expression to display text from one-to-many relationship in ArcMap?
Current License: CC BY-SA 3.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 23, 2013 at 14:25 | answer | added | dblanchett | timeline score: 3 | |
| Oct 23, 2013 at 11:06 | comment | added | blah238 |
Just use a newline (\n) instead of a comma. If for some reason that doesn't work, another delimiter could be used, and then a (much simpler) label expression could be used to split it back out to multiple lines.
|
|
| Oct 23, 2013 at 10:58 | comment | added | blah238 | @PolyGeo this could be done as part of the query: stackoverflow.com/a/8803563/386205 | |
| Oct 23, 2013 at 10:13 | history | edited | PolyGeo♦ | CC BY-SA 3.0 |
Grammar
|
| Oct 23, 2013 at 10:12 | comment | added | PolyGeo♦ | I don't think it is annotation (in the ArcGIS sense) being sought here - it looks like labelling using stacked text derived from a one-to-many relationship. | |
| Oct 23, 2013 at 10:09 | comment | added | PolyGeo♦ | @blah238 I don't work with query layers but am curious how they are used to put out the stacked text evident in the graphic. Consequently, I think the "wolfmapper" solution would be my preference. | |
| Oct 23, 2013 at 8:58 | comment | added | blah238 | You could also create a spatial view if you want to persist its definition in the DB. | |
| Oct 23, 2013 at 8:55 | comment | added | blah238 | I think it would be much more efficient to use a query layer than the label expression solution proposed in the linked question. I don't have an example handy though. | |
| Oct 23, 2013 at 8:50 | comment | added | Mounaim | database stored in potgresQL i use arcSDE | |
| Oct 23, 2013 at 8:49 | comment | added | Jens | possible duplicate of Label one to many relationship class. The comment of @Georg shows a solution. | |
| Oct 23, 2013 at 8:49 | comment | added | Mounaim | I want to show on the parcel all the owners "it's a relational annotation " | |
| Oct 23, 2013 at 8:47 | comment | added | blah238 | Also, is your data stored in a file geodatabase, personal geodatabase, or enterprise geodatabase? | |
| Oct 23, 2013 at 8:43 | comment | added | blah238 | What do you want to happen when multiple persons are associated with a parcel? | |
| Oct 23, 2013 at 8:27 | history | asked | Mounaim | CC BY-SA 3.0 |