Latest Contributions by DouglasMinnigh

Hello, I am trying to automate a process. I get an email that has a request number, GPS points, and an email to respond to. I currently convert that email to a text file and put it on a shared drive. Then I map the GPS points from the text file. I create a polygon from those GPS points. I create a map titled by the request number. Zoom to appropriate scale. Export to PDF to the shared drive and email to the person that requested it. Are there any ways to automate this process? I was thinking if I had multiple text files, is there a way to extract the request number, GPS points (can range from 3-6 Lat/Long), and email associated with each text files and combine them all into a table. Any help is appreciated, Thanks If the end result was like this that would be great! Lat Long Request Email Address 40.2354 -79.54545 request 1 email 1 40.3624 -79.70275 request 1 email 1 40.4894 -79.86005 request 1 email 1 40.6164 -80.01735 request 1 email 1 40.7434 -80.17465 request 1 email 1 40.8704 -80.33195 request 1 email 1 40.9974 -80.48925 request 1 email 1 41.1244 -80.64655 request 1 email 1 41.2514 -80.80385 request 1 email 1 41.3784 -80.96115 request 1 email 1 41.5054 -81.11845 request 2 email 2 41.6324 -81.27575 request 2 email 2 41.7594 -81.43305 request 2 email 2 41.8864 -81.59035 request 2 email 2 42.0134 -81.74765 request 2 email 2 42.1404 -81.90495 request 2 email 2 42.2674 -82.06225 request 2 email 2 42.3944 -82.21955 request 2 email 2 42.5214 -82.37685 request 2 email 2 ... View more

I was curious to know how one would merge line segments that have similiar start and end points. For example: FID     Start     End 1          0          7 2          7          53 3          53         82 4         108         123 5         123         135 I want to be able to turn these 5 segments into 2 by using their start and end points. I do not think a dissolve would work for this but i could be wrong. Any suggestions? ... View more