topic Re: Python or ModelBuilder Help in ArcGIS Pro Questions

Python or ModelBuilder Help

JustinMays — Thu, 07 Nov 2019 17:43:29 GMT

Hello All,

I am trying to transition to ArcGIS Pro. I am not very good at programming and needed some help with either Python or ModelBuilder.

I am tasked with creating maps for our documents to show sampling locations. I currently have all the layers such as the basemap, roads, boundaries, etc. added to the project. Currently, I manually import an edited excel file and I use the "display XY Data" to display the Lat and Long of our tracks to the map. The attribute table contains the following information shown in the attached file.

The excel file is data we took while moving in our vehicle that is equipped with GPS. What I am trying to do is use the information and place a marker point and use a style on that point anywhere that our vehicle was parked for more than 5 min. The excel file name is never the same and is created from data from Igor. The excel file is usually named in the following format (XXXXX DAQ Data XXXXXX.xlsx) where "X" are numbers for the date and case number. I am not sure if this is possible but I figured I would start with my question here.

Hopefully I posted this in the correct area!

Thank you in advance for any help!

Justin

Re: Python or ModelBuilder Help

GarrettSeay1 — Thu, 07 Nov 2019 17:45:59 GMT

Can you share some of your excel? In particular, an area where you know you sat 5 min?

Re: Python or ModelBuilder Help

JoeBorgione — Thu, 07 Nov 2019 18:03:30 GMT

You might want to start with excel to table, which will translate your excel table into a geodatabase table format. You provide the in excel name, the out geodata base, and the new table name. IMHO, working with a table is easier than excel worksheets.

Re: Python or ModelBuilder Help

JustinMays — Thu, 07 Nov 2019 18:51:03 GMT

Thank you all for getting back to me. I have attached a excel file as asked. This is a edited file and only contains the information that I need. It is also in xls instead of xlsx but I don't think it matters much.

Thanks again for the help.

Justin

Re: Python or ModelBuilder Help

RobertBorchert — Thu, 07 Nov 2019 18:55:45 GMT

I am wondering what your question is?

right click on your excel table and select Create Feature Class > From XY Table...

It should work unless your somewhere near Willa, Washington

Re: Python or ModelBuilder Help

JustinMays — Thu, 07 Nov 2019 19:02:01 GMT

Hi Robert,

I am trying to automate or at least speed up the process some how by using a Python script or ModelBuilder to bring in the excel files, add them to the map, display all the coordinates on the map, then place a marker on any location where the markers were at a location for more that 5 minutes.

Hope this helps,

Justin

Re: Python or ModelBuilder Help

RobertBorchert — Thu, 07 Nov 2019 19:05:24 GMT

What are you using for GPS. Many if not most will have available software to create points as shape files for you.

Re: Python or ModelBuilder Help

JustinMays — Thu, 07 Nov 2019 19:13:17 GMT

I believe is is an Airmar system. But I get the data from another person in excel format.

Re: Python or ModelBuilder Help

JakeSkinner — Thu, 07 Nov 2019 19:13:59 GMT

Hi Justin,

One way you can do this is the following:

1. Import the table into a File Geodatabase using the Excel to Table tool as Joe Borgione‌ mentioned

2. Create a new TEXT field (i.e. Time_Str) and calculate this to your Time_ field. This will convert your date to a string

3. Create another field of type Long or Double (i.e. Date_Dbl)

3. Calculate the new field (Date_Dbl) by converting the TEXT field to epoch seconds using the field calculator and the following expression:

time.mktime(datetime.datetime.strptime(!Time_Str!, "%m/%d/%Y %I:%M:%S %p").timetuple()) * 1000‍

4. Convert the table to a point feature class using the XY Table to Point tool

5. Dissolve the feature class based on the Latitude and Longitude fields for the Dissolve Fields and the Date_Dbl field for the Statistic Field. Set the Statistic Type to Range

Note, you will want to make sure you Lat/Long fields are exact for when the vehicle was not moving. Looks like some are rounded differently.

6. This should give you an output with a Range field that shows the epoch time of how long the vehicle was not moving.

If the value is greater than 300000, it was idle for more than 5 minutes.

Re: Python or ModelBuilder Help

JustinMays — Thu, 07 Nov 2019 19:18:07 GMT

Thank you for the write up. I will give this a shot. I might not get it completed today but I will respond with the results I get. Thank you all again for the help.

Justin

Re: Python or ModelBuilder Help

RobertBorchert — Thu, 07 Nov 2019 19:53:13 GMT

Are you sure there were any two times that were at least 5 minutes apart

all your readings are a few seconds apart. I took them into MS Access and looked for duplicate locations and the closest to 5 minutes is on that had 24 readins

Then going back to the original table there are a bunch close together. Your GPS rating is fluctuation by a few inches to feet between many readings.

Re: Python or ModelBuilder Help

GarrettSeay1 — Thu, 07 Nov 2019 20:01:41 GMT

I found the same when I did that. I used the Find Identical tool.

Re: Python or ModelBuilder Help

JustinMays — Thu, 07 Nov 2019 20:10:50 GMT

What we are doing is driving around in an area to take samples. We then stop at random locations through out the day. If we are stopped for more than 5 minutes, the client would like me to mark that location on the map.

I have attached an example picture showing some of our tracks and stops. The blue dots represent the locations of stops we made and the yellow dots are all the data from the excel file where we were that day. As it stands now, I manually import the edited data and manually look for locations of where we made stops during the day and add a marker at those locations.