6 replies to this topic

[MostlyHarmless]

I've got an ArcMAP question. I have a streets shapefile that I want to label with multiple names. The shapefile only has one name, but has a look-aside dbf with more names. Each name in the dbf is in a different row, so joining won't work here. I know how to use the label manager to make multiple labels for a feature, but how would I accomplish labeling a street with multiples names like this?

Here is a picture of what I mean. On the left is the actual shapefile, on the right is the look aside

[dsl]

In short- this is not possible. ArcGIS does not have an internal method of labeling features from a related table. However, some ingenious people have come up with alternatives. Here is an article and here is an arcscript. I've never used either, so I couldn't say which is better. The script creates map annotation, so you lose all the dynamic capabilities of a label.

Hope that helps.

Cheers,
David

[MostlyHarmless]

I will try these tomorrow at work. Thank you for the help!

[frax]

I would try to play with that join table to get all the alternative names in one column with one id - so that you can do a one-to-one join. Access or Excel are usually good tools for this.

[MostlyHarmless]

Grr, I'm having no luck. I thought maybe there'd be an easier solution

[wick]

Grr, I'm having no luck. I thought maybe there'd be an easier solution

You should arrange the alternate street names into separate columns instead of separate rows so you have 1 record ID with multiple Alternate Name fields instead of multiple (duplicate) record IDs in the alternate names table.
To do this, paste the alternate name table into the attached Excel sheet - after copying the formulas to all the rows of data, delete the extra rows marked "DELETE".

Then in ArcMap you can join by record ID and set up additional labeling classes for the alternate name fields.

Attached Files

•  RowsToColumns.zip   2.27K   41 downloads

[MostlyHarmless]

Thats a great idea wick. Unfortunately, my company as converted to (cringe) MSO 2007...thus there is no support for editing .dbf files. This could definitely work though

EDIT: I think this can work by exporting as CSV from excel 2007