Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. From the Ribbon, click the Analysis tab.
  2. In the Geoprocessing group, click the Tools button. The Geoprocessing pane will appear on the right side of the screen. 
  3. In the Geoprocessing pane, type Excel to Table
  4. Select Excel to Table (Conversion Tools).
  5. For Input Excel File, click the Browse button.
  6. On the right side of the Browse window, click Folders.
  7. On the left side of the Browse window, double click the Workshop_Data folder and choose IGOR_masterlist
  8. Under Output Table, name the table GIS_Wells.
  9. 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. 
  10. Click Run.
  11. In the Contents pane, right-click the GIS_Wells table and select Display XY Data.
  12. Name the layer GIS_Wells_Pts
  13. Ensure that the X Field states "longitude" and the Y Field states "latitude". 
  14. 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. 
  15. Click Run.
  16. 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.
  17. Right-click GIS_Wells_Pts and click select Label.
  18. Open Right-click GIS_Wells_Pts and select Label PropertiesA new pane, Label Class, will open on the right side of the screen.
  19. Under the Expression box, clear the current input. 
  20. 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.
  21. Click Apply.
  22. Above the ribbon, on the Quick Access toolbar, click the Save button.

...