Is there a way to label points in a regular interval in ArcGIS 10? [SOLVED]

Question

Estou trabalhando com linhas em estradas representadas por uma grande grande quantidade de pontos em sequencia. Uma vez que colocar o nome de todos os pontos tornaria a identificação impossível, gostaria de saber se existe uma maneira de rotulá-los a cada 25.

Tentei uma consulta SQL para exibir qualquer label que terminasse com 25 mas não houve retorno.

[UPDATE]
Resolvi o 'problema' com uma consulta SQL.

Na aba Label, dentro da janela de Propriedades do Layer, fiz como mostra a imagem abaixo. A única coisa que precisei modificar foi o intervalo: ao invés de exibir labels a cada 25 pontos, decidi por mostrá-los a cada 50.

--
I'm working with lines on roads represented by a large number of sequencial points. Since labeling all of them would make the points impossible to identify, I'd like to know if there is a way to label them in a interval of each 25.

I've tried an SQL query for showing anything ending with 25 but no records were returned.

[UPDATE]
I have solved this 'problem' with SQL.

On the Label tab inside the Layer Properties box, I've done like it's in the image bellow:

The only thing I've had to change was the interval: instead of showing labels on each 25 points, I've decided to show on each 50.

Thank you for all your answers.

Answer 1

I believe using a label buffer in ArcGIS would accomplish this. I don't have ArcMap in front of me right now, but if you go into the properties of your point layer, then the labeling tab you should be able to find options for this. - do not allow overlapping labels - set the buffer to 25 units (then adjust the buffer as needed)

More info at the ESRI help: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//003s00000040000000.htm

Another option is to add a field to your point feature class which you could use to query for labeling purposes...for example call the field LABELS and then mark either TRUE or FALSE. Mark every 25th point as TRUE. You could then choose to define groups of labels and only turn labels on for LABELS = TRUE.

Answer 2

The Maplex extension is a good tool for labeling in tight locations if you have access to it. Here are two possible solutions.

Leaderline

Load the Labeling toolbar in ArcMap (Maplex) and turn it on to the BEST option. Go to the Properties>Labeling tab of your point layer and click the Symbol button. Select the option at the bottom that has the leaderline ("Bullet Leader"). Next, select the Properties button within the Symbol Selector dialog. Then, select the Advanced Text tab>Properties button and assign the Leader Tolerance to at least 15. Select the field you want to label and set the font to a small font size.

Leaderline alternate left/right

This method is a bit more involved. Assuming that your data was collecting in a somewhat consecutive/linear fashion you can label with leaderlines, but alternate the leader by left and right side. First, follow the steps for Leaderline above. Create two labeling classes (Even and Odd) within the layers Properties>Labeling tab, for the Method option select "Define classes of features and label each class differently" option. For the Even class select the SQL Query button and paste this code in (refer to this link for geodatabase feature class SQL Query examples). This SQL statement is for Shapefiles.

MOD ("FID",  2)  = 0 

Next, within the Layer Properties>Labeling tab select the Placement Properties button, Label Position tab>Position button and select the "Northeast" option. Finally, apply these same steps to the "Odd" class. Update the SQL Query to:

MOD ("FID",  2)  = 1

And update the label Position to "Southwest". Also make sure that the "Never remove (allow overlap)" option is checked for both classes located here, Placement Properties>Conflict Resolution tab. The leaderlines should alternate now.

Answer 3

The answer is in the question box, as an update. Thank you all for the help.