Latest Contributions by FeatherWilson

I am creating an layer file from and Excel spreadsheet. I am editing new points by creating a feature point that shows up as zeros in the Excel spreadsheet layer file and changing the coordinates and other data and saving the attribute table. It would be convenient to have the program allow editing the Excel generated layer file directly. Wm Feathergail Wilson PG 21, CPG 3566 B.A., B.S., M.A. University of Texas @ Austin Strata Geological Services 13505 FM 462 Bandera (Tarpley), Texas 78003 Office: 830-562-3680 Cell 830-688-1624 Email: [email protected] ... View more

Steps for editing earthquake points within a layer file originally created in Excel 1. Spot the reported Earthquake with the XY tool in Long/Lat on the map 2. Open Earthquake attribute file – scroll to base 3. Open Editor tool 4. Open Create feature tool and edit the Earthquake file – spot the spot 5. The spot shows up at the base of the attribute table with zeros – fill in the County-Long/Lat-Magnitude-Year 6. Save edits – close the table My suggestion is to save steps 4-6 by incorporating them into the program to directly edit the attribute table originally created in Excel instead of the work-around described above. I don’t know how to describe this without your watching how I do it. Thanks Feather Wm Feathergail Wilson PG 21, CPG 3566 B.A., B.S., M.A. University of Texas @ Austin Strata Geological Services 13505 FM 462 Bandera (Tarpley), Texas 78003 Office: 830-562-3680 Cell 830-688-1624 Email: [email protected] ... View more

It might work if I could copy my 708 rows and incorporate them into a feature class. Many times with other Excel files I have the latitude of adding additional data fields. I’m sorry you failed to receive the screen shot because it explains a lot. I will try it again now. Wm Feathergail Wilson PG 21, CPG 3566 B.A., B.S., M.A. University of Texas @ Austin Strata Geological Services 13505 FM 462 Bandera (Tarpley), Texas 78003 Office: 830-562-3680 Cell 830-688-1624 Email: [email protected] ... View more

In other words, I could save a few steps by just editing the layer file created from the Excel file by not having to create a point and then re-editing the Excel Earthquake layer file. Other wise I have to rename the Excel file and reload it up to the map. Presently there 708 Earthquake points. When I work a smaller area with just well spots I may have only about 20-30 points. Geologists use these mapping techniques in many companies and settings with ArcGIS 10.6. I am an old consultant having worked for several major oil companies and my sons work for majors as geologists and use ArcGIS presently. Wm Feathergail Wilson PG 21, CPG 3566 B.A., B.S., M.A. University of Texas @ Austin Strata Geological Services 13505 FM 462 Bandera (Tarpley), Texas 78003 Office: 830-562-3680 Cell 830-688-1624 Email: [email protected] ... View more

Attached is a screen shot of the Earthquake Excel. layer file that I wish to edit each time I receive a new USGS earthquake report. The only way that I can edit the table is to create a point on the map with the edit tool and then it shows up in the table as zeros and then I have to put in the coordinates and the data. It would far more convenient just to place the data into the table directly . Perhaps you have a better solution. Sometimes I need to just use a similar table from an Excel file for well spotting and subsequent mapping that I generally use just once. However, working with an earthquake map over all of Texas over long periods of time the one time solution is an inconvenience. Wm Feathergail Wilson PG 21, CPG 3566 B.A., B.S., M.A. University of Texas @ Austin Strata Geological Services 13505 FM 462 Bandera (Tarpley), Texas 78003 Office: 830-562-3680 Cell 830-688-1624 Email: [email protected] ... View more

I have not received my stylus yet but I opened ArcGIS and opened the curve tool with my finger and drew a crude curve. So I think this might work. This is the map that I previously created with a mouse. Wm Feathergail Wilson PG 21 Strata Geological Services 13505 FM 462 Bandera (Tarpley), Texas 78003 Office: 830-562-3680 Cell 830-688-1624 Email: [email protected] ... View more

No, but I have just ordered a stylus tool and I spoke to an ESRI representative and he walked me through free hand feature tool. When I receive the stylus, I will begin to experiment. This is a map that I created with the mouse, which is very difficult, Wm Feathergail Wilson PG 21 Strata Geological Services 13505 FM 462 Bandera (Tarpley), Texas 78003 Office: 830-562-3680 Cell 830-688-1624 Email: [email protected] ... View more