Page History

...

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, use the dropdown menu to select Current Map [Map]. The coordinate system should now be GCS_North_American_1927. 
15. Click Run.
16. In the Contents pane, rick-click on GIS_Wells_Pts and select Zoom to Layer.
17. Right-click GIS_Wells_Pts and select Label.
18. Right-click GIS_Wells_Pts and select Label Properties. A 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 box, double click api_number. The Expression box should now read $feature.api_number.
21. Click Apply.
22. Above the ribbon, on the Quick Access toolbar, click the Save button.

Spatial Join

For more practice with Symbology, check out our short course: Introduction to Geoprocessing

1. In the Catalog pane, expand the Workshop_Data folder and then expand SpatialJoindata.gdb. 
2. Right-click on geologic_features_poly and select Add to Current Map. 
3. In the Contents pane, right-click on geologic_features_poly and select Symbology. 
4. From the Symbology pane, use the dropdown menu to select Unique Values. Change the Field 1 selection to FEATURE. 
5. From the Color Scheme drop-down, select the color scheme that you would like. 
6. From the Ribbon, click the Analysis tab.
7. In the Geoprocessing group, click the Tools button. The Geoprocessing pane will appear on the right side of the screen. 
8. In the Geoprocessing pane, type Contour. 
9. Select Spatial Join (Analysis Tools).
10. Under Target Features, select GIS_Wells_Pts.
11. Under Join Features, select geologic_features_poly. 
12. Rename the Output Feature Class as GIS_Wells_SpatialJoin. 
13. Retain the default setting of Join_one_to_one for the Join Operation.
14. Retain all other default settings. 
15. Click Run.
16. In the Contents pane, right-click on GIS_Wells_Pts and select Remove.
17. In the Contents pane, click on GIS_Wells_SpatialJoin and rename GIS_Wells. 
18. Above the ribbon, on the Quick Access toolbar, click the Save button.