...
- From the Ribbon, click the Analysis tab.
- In the Geoprocessing group, click the Tools button. The Geoprocessing pane will appear on the right side of the screen.
- In the Geoprocessing pane, type Excel to Table.
- Select Excel to Table (Conversion Tools).
- For Input Excel File, click the Browse button.
- On the right side of the Browse window, click Folders.
- On the left side of the Browse window, double click the Workshop_Data folder and choose IGOR_masterlist
- Under Output Table, name the table GIS_Wells.
- From the Sheet drop down, choose the GIS_Wells sheet. This ensures that the GIS_Wells sheet will be the data converted from an excel table to a geodatabase table.
- Click Run.
- In the Contents pane, right-click the GIS_Wells table and select Display XY Data.
- Name the layer GIS_Wells_Pts.
- Ensure that the X Field states "longitude" and the Y Field states "latitude".
- For Coordinate System. Name the Layer GIS_Wells. For Spatial Reference, use the dropdown menu to select Current Map [Map]. The Spatial Reference coordinate system should now be GCS_North_American_1927.
- Click Run.
- Zoom to the In the Contents pane, rick-click on GIS_Wells Layer if you are unable to see the points_Pts and select Zoom to Layer.
- Right-click GIS_Wells_Pts and click select Label.
- Open Right-click GIS_Wells_Pts and select Label Properties. A new pane, Label Class, will open on the right side of the screen.
- Under the Expression box, clear the current input.
- Under the Fields boxWells1 Label Properties. Go to the Labels Class tab and under Class > Expression, clear the Expression code. Under Fields, double click api_number. Click applyThe Expression box should now read $feature.api_number.
- Click Apply.
- Above the ribbon, on the Quick Access toolbar, click the Save button.
...