ArcGIS Desktop

Problem: Unable to display X and Y fields in the Display XY Data dialog box

【相关信息】
Article ID: 42858
Bug Id: N/A
Software:
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1, 10.2.2
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1, 10.2.2
ArcGIS for Desktop Basic 10.1, 10.2, 10.2.1, 10.2.2
Platforms: N/A

【问题描述】
After importing a table with latitude and longitude data from an Excel file into ArcMap, the X and Y Fields are not selectable in the Display XY Data dialog box.

【原因】
This issue occurs when the latitude and longitude field data types are incorrectly set.

1 个回复

EsriSupport

【解决方案】

In the Table Of Contents, right-click the Excel table, and select Data > Export. Browse to the specific location, specify the name (the default name is Export_Output), and save as type: dBase table.
In the 'Do you want to add the new table to the current map' pop-up, click Yes.
Right-click the newly created table, and click Open to open the Table dialog box.
Go to Table Options and select Add Field to add a new field.
To start editing the table, navigate to the Editor toolbar and select Start Editing.
When prompted, select the newly created table.
Right-click the Longitude1 header and select Field Calculator.
In the Field Calculator dialog box, double-click the pre-existing longitude field. Press OK.
Repeat steps 7 and 8 for the Latitude1 field.
Close the table. Save and stop the editing session.
In the Table Of Contents, right-click the Export_Output table, and select Display XY Data.
In the Display XY Data dialog box, select X Field: Longitude1 and Y Field: Latitude1 to specify the coordinates. Click the Edit button.
Navigate to the desired coordinate system, for example: Geographic coordinate system > North America > NAD 1983