...
- 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, use the dropdown menu to select Current Map [Map]. The coordinate system should now be GCS_North_American_1927.
- Click Run.
- In the Contents pane, rick-click on GIS_Wells_Pts and select Zoom to Layer.
- Right-click GIS_Wells_Pts and select Label.
- 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 box, double click api_number. The Expression box should now read $feature.api_number.
- Click Apply.
- Above the ribbon, on the Quick Access toolbar, click the Save button.
Spatial Join
- 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.
- Drag geologic_features_poly.shp into the Map. Right click geologic_features_poly and click Data > Export Features.
- Name the Output Feature Class as geologic_features_poly. Click Run.
- Remove the original geologic_features_poly from your Map.
- With the geologic_features_poly layer selected, go to the Appearance tab and select Symbology.
- 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.
- Click on Toolboxes > Analysis > Tools > Overlay > Spatial Join.
- 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.
- Retain all other default settings. Click Run.
- Remove the GIS_Wells layer.
- Re-lable the GIS_Wells_SpatialJoin layer as described in Importing an Excel Sheet.
- Above the ribbon, on the Quick Access toolbar, click the Save button.