nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

XY data with date and time references for vertexes - need to make a line

DionaAustill

I have some data as follows:

INDEX RCR UTC DATE UTC TIME LOCAL DATE LOCAL TIME MS VALID LATITUDE N/S LONGITUDE E/W HEIGHT SPEED Distance
1 T 9/27/2013 15:24:34 9/27/2013 8:24:34 0 SPS 46.299584 N -105.973519 W 832 m 0.059 km/h 0.00 m
2 T 9/27/2013 15:25:34 9/27/2013 8:25:34 0 SPS 46.299511 N -105.973503 W 835 m 0.003 km/h 0.00 m
3 T 9/27/2013 15:26:34 9/27/2013 8:26:34 0 DGPS 46.299497 N -105.973463 W 838 m 0.027 km/h 8.27 m

What they would like is a line with graduated colors so they can tell the route the cow took in their travels. They are putting a GPS unit on cows on Tuesday and removing them Friday so each file has about 1713 lines of data. I would like to make a line with points and somehow number the points or make a graduated line that turns from say red to blue so they can tell where they started and ended and how long they stayed at certain points. Any ideas would be greatly appreciated!

Thanks,
Diona

Trouver plus de publications taguées avec

Accepted answers

All comments

michaelcollins1

This could be as simple as creating symbology using the FID of the segments in the Value Field (assuming that the order is first to last timewise), then using something like the green to red colour ramp

CPoynter

Look at using "points to line" tool. Then create points using "vertices to point" tool.

You will need to calculate how long cow was at each point for time spent at each point. Time sampling period is going to be an issue. As cows may move location, but the movement isn't picked up (i.e. they will just be found at a new location without a 'speed' of movement). Resolution of data can be an issue. In your sample over 2 minutes the cows moved 3 times but only once over a distance of 8m

Is there an option to filter data?

Regards,

Craig

RobertBorchert

I hope I can respond without to much confusion.

You have a unique identifier for each cow? I will assume the sample data you posted is for one cow for this.

I will use the local time. I reformatted your data in excel such that

Local Date is column E formatted as date
Locat Time is Column F formatted as time
Latitude is I
Longitude is J
Distance ended up in column M (but will not be used)

I added 3 new columns
LatitudeTO in column N
LongitudeTO in column O
TimeAtLocation in column P

Assuming your data is sorted by date and time earliest to latest and all data is for a single cow.

In cell N2 (LatitudeTO) put in =I3
In cell O2 put in =J3
In cell P2 put =f3-f2

These will populate your to X,Y and time a location 1

Drag these formulas down to the bottom of the spreadsheet.

Now save your data a .csv this is important because it will embed the formulas as actual data.

Open your .csv up and delete the last entry. There will be no to x,y or time at this point because it is the destination.

bring your .csv into your ArcGIS and use the X,Y to line and the Lat and Long attributes.

After your done you can also generate a point feature from the same table with the original lat long. You can symbolize the points with the time at location attribute.

Keep spaces out of the column headers to make things smoother. Also, remove the W and N designations and make sure there are no spaces in the lat long columns.

I have some data as follows:

INDEX RCR UTC DATE UTC TIME LOCAL DATE LOCAL TIME MS VALID LATITUDE N/S LONGITUDE E/W HEIGHT SPEED Distance
1 T 9/27/2013 15:24:34 9/27/2013 8:24:34 0 SPS 46.299584 N -105.973519 W 832 m 0.059 km/h 0.00 m
2 T 9/27/2013 15:25:34 9/27/2013 8:25:34 0 SPS 46.299511 N -105.973503 W 835 m 0.003 km/h 0.00 m
3 T 9/27/2013 15:26:34 9/27/2013 8:26:34 0 DGPS 46.299497 N -105.973463 W 838 m 0.027 km/h 8.27 m

What they would like is a line with graduated colors so they can tell the route the cow took in their travels. They are putting a GPS unit on cows on Tuesday and removing them Friday so each file has about 1713 lines of data. I would like to make a line with points and somehow number the points or make a graduated line that turns from say red to blue so they can tell where they started and ended and how long they stayed at certain points. Any ideas would be greatly appreciated!

Thanks,
Diona

DionaAustill

[ATTACH=CONFIG]32291[/ATTACH]

I did what you suggested, but still have problems when I use XY to line. I'm attaching the results to see if you can spot what I am doing wrong. Where I question myself is in the setup box, I'm not sure what to use for beginning and ending.

Thanks,
Diona

xy.png

CPoynter

Data needs to be structured so that coords for point 1 are starting Lat_S and Lon_S and point 2 coords are Lat_E and Lon_E.

INDEX LOCAL_DATE LOCAL_TIME LATITUDE_S LONGITUDE_S LATITUDE_E LONGITUDE_E
1 9/27/2013 8:24:34 46.299584 -105.973519 46.299511 -105.973503
2 9/27/2013 8:25:34 46.299511 -105.973503 46.299497 -105.973463
3 9/27/2013 8:26:34 46.299497 -105.973463 46.299497 -105.973463

You need to connect from one point to the next and double up your last coord to end the connections.

Start X = Lon_S
Start Y = Lat_S
End X = Lon_E
End Y = Lat_E

Even those these tools should work with CSV or Tables in GDB I have found the odd instance where just using a CSV file and creating a shapefile will work as opposed to creating or using files within the GDB.

DionaAustill

Well closer. Now I get an Exception 001143: Background server threw an exception.

This is what I am putting into the XYtoLine box:
[ATTACH=CONFIG]32306[/ATTACH]

And the data is attached in an excel workbook (for some reason this forum won't upload .cvs files).

I feel so close - wish I could find a class that just worked with xy data.

Thanks for all your help!
Diona

8 13448n.xlsx

XYTOLine.png

CPoynter

Ok have a solution. ArcGIS doesn't like your table. Using the CSV right-click on it in Catalog and use 'Create Feature Class' > 'From XY Table'. Using the table from the point file created set-up the 'XY to Line' tool. Your lines should be created.

Picture1.jpg

DionaAustill

Ok, I finally got it to work. I had to export the data into a shape file, then it worked fine. One exception is the last line went way off to point 0,0 instead of ending. I just went and edited the layer and deleted it. Now on to figure out how to make this line a graduated color line. If you have any ideas, I would love to hear them!

Thanks for all your help! [ATTACH=CONFIG]32358[/ATTACH]

result.jpg

CPoynter

If you copy your last starting coords and paste them as your ending coords your line will end at last given point. 0,0 is how ArcGIS will fill in your table for empty values.

What are you basing your graduation of line on? What value / field?

DionaAustill

I will base it on time. I am trying to figure out how to automate with a macro or something, how to sort out the times that have 00 or 30 minutes. The field is hour:minutes:seconds. I did it manually but that takes a while. I come up with 74 lines that I would want to do a graduated line with. I wish I had time to spend on this but keep getting interrupted so thanks for all your help!

Diona

CPoynter

Have a look at the datetime function/module within python. You might be able to do a calculation using it.

Or have a look at the 'Calculate End Time' tool within ArcGIS.

Take note that date and time will need to be separate fields for shapefiles but can be one field in a GDB.

DionaAustill

To give an update on this. I found an ESRI trainer that helped me step through this and build a model I use as a tool. The result is a line but you can go to symbology and make the line three colors, one for each day. That way you can see where the animal spent his time on each day. I use it both ways. I also went to an Esri class in Denver on Analyzing which was very good. We went over models and animation. Thanks for all your suggestions!

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.