NIM057846 for No Product Found

Bug ID Number	NIM057846
Submitted	June 1, 2010
Last Modified	April 2, 2025
Applies to	No Product Found
Version found	9.3.
Status	Duplicate

Additional Information

Duplicate of NIM057847

Workaround

See attachment for details with screen shots...Open ArcMap and add data layer.Open ArcToolbox > Data Management Tools > Features, and select Add XY Coordinates.Select the point layer as input, and click OK. X and Y coordinates for the points will be added to the attribute table of the shapefile.Open the attribute table for the point layer.Right click the layer intended to be used for labeling and select “Sort Ascending”.Select the Options button and select “select all”.Once everything in the table is highlighted right click on one of the gray boxes to the left and select “copy selected”.Open up a blank excel spread sheet. Right click in the top left corner cell and select paste.You will notice that the label attribute is still sorted in ascending order and that the FID is not.In Excel, reformat the fields, changing fields containing characters to TEXT format, number fields to NUMBER format, and assigning the correct number of decimal places to the number fields so that all the data in the fields in maintained properly. For the POINT_X and POINT_Y fields, be sure to specify a NUMBER field, with at least 6 decimal places.Next, select the top row, and format the field headers as TEXT.Finally, select all populated cells in the table, and go to File > Print Area > Set Print Area.Next, click on the FID so that the column is highlighted. Click “Sort & Filter” then “Sort Smallest to Largest”. If you are using Microsoft Office 2003, select the tool Sort Ascending.Select “Continue with the current selection”.Repeat setting the Print Area to be on the safe side.Select File then Save As. Be sure to save it as Excel 97-2003 Workbook (*.xls). Delete Sheet2 and Sheet 3, then Save again.In ArcMap use the Add data button to navigate to the excel sheet. When it is opened, select sheet1$ and then the Add Button.In ArcMap make sure the Source tab is selected table of contents. Right click on the table and select Display XY Data.Select POINT_X as the X Field:Select POINT_Y as the Y Field:Click on the Edit button > Select > Geographic Coordinate Systems > World, select WGS 1984.prj, and click Add > Apply and OK. An Events theme will be created in the ArcMap Data Frame. If you receive a warning message about a missing ObjectID field, click “Yes” on the warning.In ArcMap right click on the newly created Sheet1S Events layer and select Data > Export data.Select a suitable output location for the new shapefile, assign a meaningful name with the .shp extension, then click OK.Click “Yes” on the dialog when asked to add the exported data to the map as a layer.In the TOC, remove the Events layer, and the XLS spreadsheet, then switch to the Display tab.Right click on the newly created shapefile and select open attribute table.If you right click on the attribute called Label and select properties, you will notice that it is of type double. We will need to create a new field of type Short Integer, so that the labels will not display with decimals.In the attribute table select the options button and select Add field.Give the field a unique name and make it type Short Integer.Right click on the newly created field and select Field Calculator.Select yes if this dialog appears.Double click on the attribute called LABEL and select ok. You will use this new field as your label field. In this example you would use lbl as the label field because it is an Integer field.Right click the layer and select Properties.Select the Symbology tab. Select Quantities > Graduated colors.Click on Classify to set up the Classification Scheme (Manual) and values that are to be assigned to this map. For this example using data for Maryland and Delaware, you have 5 classes.For the Field value select the attribute you just created and populated for labeling.Select all the symbols, using the mouse cursor and the Shift key.Right click in the blue selection area, and click on Properties for Selected Symbol(s)…. And in the Symbol Selector dialog, pick the green filled circle (Circle 2)and click OK.Select a color ramp to apply to the data. The circle colors will change from green to the appropriate color from the selected ramp.At this point, the circle categories will be created, and colored based on the color ramp. If different colors need to be used, you can double click on a particular circle, and change the fill color for that specific symbol in the Symbol Properties dialog > Properties.Click Apply and OK to apply the symbology to the circles in the map.Now to labeling those circles.Select the Labels tab.FOR THIS PROCESS, USE THE ESRI STANDARD LABEL ENGINE. There are limitations with the Maplex Label Engine that are preventing labels from being placed properly.Check “Label features in this layer”.For Method: select “Define classes of features and label each class differently”.Select the “Get Symbol Classes” button. Use the drop down arrow for classes to select each class separately and1)set the label field to the new field that you created that is of type Short Integer 2) select the Placement Properties button > place label on top of the point.On the Conflict Detection tab, you may check the box to “Place overlapping labels”. However, at smaller map scales, some of the labels overrun each other. If this box is not checked, at smaller map scales, some labels do not draw. You will need to decide how this option needs to be set. 3) check the box that says label features in this class.When the settings have been set for all of the classes select apply.You can see that colors are not numbered properly.From the Labels toolbar, select the Label priority ranking button and sort them from highest to lowest.Label values and colors for the marker symbols will now match in the ArcMap Data Frame.You will notice that points which have values of zero in the label field are not labeled.