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

1. In ArcCatalog, create a folder connection to Computer > GDCStorage > ESCI525 > BEG_WTexas_ARC > forCD.In this new Folder Connection, expand GIS_proj then expand Basemap.the Catalog pane, expand the Workshop_Data folder and then expand SpatialJoindata.gdb. 
2. Drag geologic_features_poly.shp into the Map. Right click geologic_features_poly and click Data > Export Features.
3. Name the Output Feature Class as geologic_features_poly. Click Run.
4. Remove the original geologic_features_poly from your Map.
5. With the geologic_features_poly layer selected, go to the Appearance tab and select Symbology.
6. Under Symbology, use the dropdown box to select Unique Values. Change the Value Field to FEATURE. Select the Color Scheme that you would like. Exit the Symbology tab.
7. Click on Toolboxes > Analysis > Tools > Overlay > Spatial Join.
8. Under Target Features, select GIS_Wells. Under Join Features, select geologic_features_poly. Rename the Output Feature Class as GIS_Wells_SpatialJoin. Retain the default setting of Join_one_to_one for Join Operation.
9. Retain all other default settings. Click Run.
10. Remove the GIS_Wells layer.
11. Re-lable the GIS_Wells_SpatialJoin layer as described in Importing an Excel Sheet.
12. Above the ribbon, on the Quick Access toolbar, click the Save button.