topic Re: How to split GPS data points into different road function class (eg. Interstate, arterial etc.,) in Geoprocessing Questions

How to split GPS data points into different road function class (eg. Interstate, arterial etc.,)

rohitj — Mon, 15 Sep 2014 18:26:19 GMT

So we have a lot of gps data points for a test vehicle which needs to be analyzed. My attribute table has a lot of columns like vehicle speed, acceleration etc., I have added XY dataset and all the points are visible and I can represent each of attributes in color codes over a base map. Is there any way to split the data points like when the vehicle was in Interstate, arterial, etc., so that I can do some statistical analysis on that split data.

Re: How to split GPS data points into different road function class (eg. Interstate, arterial etc.,)

DanPatterson_Retired — Mon, 15 Sep 2014 19:29:06 GMT

You can produce separate shapefiles using the SplitLayerByAttributes toolbox if you have data in a field that will allow for separation according to some class.

Re: How to split GPS data points into different road function class (eg. Interstate, arterial etc.,)

rohitj — Mon, 15 Sep 2014 19:44:47 GMT

Hey Dan Patterson,

Thanks for the reply, The problem is I am not having the road function class as an attribute in the shape file. Is there a way to add that attribute automatically to the present shape file. Because It cant be done manually as its a big data file with almost 30000 points.

I have collected Road class map from the state department of transportation website. But I can use that as a overlay in a separate layer and it doesn't have any attributes.

I am inserting the image for your reference. The road functional class now displays the different class of roads in different colors. I want to add this attribute to my shape file and split it accordingly. Is there a way to do it. Please help!

Re: How to split GPS data points into different road function class (eg. Interstate, arterial etc.,)

DanPatterson_Retired — Mon, 15 Sep 2014 20:00:34 GMT

I am assuming that you have ruled out Joins and Relates or more specifically, the Spatial Join for some reason? or am I wrong?

Re: How to split GPS data points into different road function class (eg. Interstate, arterial etc.,)

rohitj — Mon, 15 Sep 2014 20:06:17 GMT

hey,

I have tried that. But the thing is the road classification layer is not having any attribute table to match it to my current shape file. Is there any other way?

Re: How to split GPS data points into different road function class (eg. Interstate, arterial etc.,)

DanPatterson_Retired — Mon, 15 Sep 2014 20:22:00 GMT

with a spatial join, attributes are not used, but the geometry is used. In essence, you can find the highway closest to a given point by spatially joining the polyline to the point

Re: How to split GPS data points into different road function class (eg. Interstate, arterial etc.,)

rohitj — Mon, 15 Sep 2014 21:10:38 GMT

Hey,

I have tried it, Its taking a very long time. Maybe because both the datasets are big. Thank you for the help. Hope It works...

Re: How to split GPS data points into different road function class (eg. Interstate, arterial etc.,)

DanPatterson_Retired — Mon, 15 Sep 2014 21:18:24 GMT

So do I...I failed to mention, that it is good practice to test procedures on small sets of data to see if they yield the correct results and to assess the time taken to run the procedure given a certain sample size... mea culpa

Re: How to split GPS data points into different road function class (eg. Interstate, arterial etc.,)

rohitj — Tue, 16 Sep 2014 16:10:58 GMT

Hey,

Thanks a lot... It Worked!!!!

Re: How to split GPS data points into different road function class (eg. Interstate, arterial etc.,)

rohitj — Tue, 16 Sep 2014 16:55:07 GMT

hey,

I am getting this error message when m trying to execute

this tool does not exist.

Failed to execute (SplitLayerByAttributes)

Re: How to split GPS data points into different road function class (eg. Interstate, arterial etc.,)

DanPatterson_Retired — Tue, 16 Sep 2014 18:01:52 GMT

That is because you aren't using a shapefile residing in a folder...what it was tested on and designed to work with

Re: How to split GPS data points into different road function class (eg. Interstate, arterial etc.,)

rohitj — Tue, 16 Sep 2014 20:00:46 GMT

Thank you again. Its working flawless..