Jump to content

 
Photo

Labeling streets more than one name

- - - - -

  • Please log in to reply
6 replies to this topic

#1
MostlyHarmless

MostlyHarmless

    Key Contributor

  • Validated Member
  • PipPipPip
  • 52 posts
  • Gender:Male
  • Location:Chicago
  • United States

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

Posted Image

#2
dsl

dsl

    Master Contributor

  • Validated Member
  • PipPipPipPip
  • 225 posts
  • Gender:Male
  • Location:Denver
  • United States

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

#3
MostlyHarmless

MostlyHarmless

    Key Contributor

  • Validated Member
  • PipPipPip
  • 52 posts
  • Gender:Male
  • Location:Chicago
  • United States

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

#4
frax

frax

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 2,301 posts
  • Gender:Male
  • Location:Stockholm, Sweden
  • Interests:music, hiking, friends, nature, photography, traveling. and maps!
  • Sweden

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.
Hugo Ahlenius
Nordpil - custom maps and GIS
http://nordpil.com/
Twitter

#5
MostlyHarmless

MostlyHarmless

    Key Contributor

  • Validated Member
  • PipPipPip
  • 52 posts
  • Gender:Male
  • Location:Chicago
  • United States

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

#6
wick

wick

    Contributor

  • Validated Member
  • PipPip
  • 27 posts
  • Gender:Male
  • United States

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


Jesse Wickizer
Maps.com

#7
MostlyHarmless

MostlyHarmless

    Key Contributor

  • Validated Member
  • PipPipPip
  • 52 posts
  • Gender:Male
  • Location:Chicago
  • United States

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->