Scripts to convert text file to polygon.

Question

I am try to learn python and need to deal with the following:
At the end of each day the two foresters upload the gps data to you by ftp so you can process and re-format the data. The data comes to you as a text file (AS.txt and SB.txt). The text file field columns are: ID, Common Name, Diameter at Breast Height (DBH), Staff, Longitude, & Latitude. There are some errors within the data that need fixed:
â?¢ Spelling errors within Common Name field â?? here all names should be spelled correctly and capitalized.
â?¢ DBH 0 values â?? for collector AS a DBH of 0 should be changed to 14, AND for collector SB a DBH of 0 should be changed to 16.
Develop a script or set of scripts to automate the quality control and re-formatting steps. If you can help I can send the text files. I am trying to put together the complete script syntax.
I am having a tough time gathering the scripts I need.

SB.txt.zip

AB.txt.zip

ProfilePic.png

MuratDemircan_0-1623329605921.png

DanielWebb1 · Answer

Ok I have clarity now. There is no polygon, just points. Also, this project is done in Modelbuilder, which creates the python script and usable text files. Thanks to all that helped.

Anonymous User · Answer

Original User: clthompson

I'm also confused, these look like individual points, not the verticies along the boundary of a traverse that might describe a stand or a plot.  The easiest thing you could do with those is to create an XY theme, and then use select by attribute combined with the field calculator to make some of the adjustments, and then copy the rows the of the event theme into a new shapefile.  This will create a point shapefile for you attributed with the column headers you specified.  Can you clarify the point versus polygon issue?

RaphaelR · Answer

For the name matching you could also try difflib.getclosematches()
import difflib
...
Name = difflib.get_close_matches(Name, ["Ash", "Hickory", "Oak", "Dogwood", "Maple"])[0]