1
vote
2answers
58 views

Finding routes in which more than one car passed (gps data)

I'm using ArcGIS 10.1. I have point GPS data of routes of several cars over a few days, and I want to find only the routes where more than one or two different cars passed through (Each GPS points ...
2
votes
4answers
96 views

Linking up GPS points taken from rail network

Bit of a newbie here, trying to work out whether any PostGIS functions can help with my task. Apologies in advance if my use of GIS terminology is not up to scratch yet. I have a large database of ...
1
vote
0answers
41 views

windows function with points in a mixed (multipoint/point) table

I have a table comprising multipoints (tracks) and points (stops between tracks). there can be several consecutive multipoints. now, i want to merge any points lying very closely to each other ...
3
votes
1answer
254 views

How to connect particular sets of points with (poly)lines?

I think my problem is quite easy to be solved by the most postgis-users, but i am a bloody beginner: i have a timestamped point-table representing GPS-tracked places of different cars. To distinguish ...
0
votes
2answers
1k views

PostGIS convert geography(Point,4326) to GPS

I got a database with a column of type geography(Point,4326), the data contained looks like 0101000020E610000092E057F66EF73140930035B56CBD4840. How can I convert it to GPS coordinates?
8
votes
4answers
1k views

How to filter wrong GPS points?

I have a database of GPS points. There aren't any tracks, only points. I need to calculate some value for every 100 meters, but sometimes GPS gave a wrong coordinates that lies far from real GPS ...
9
votes
1answer
509 views

How much sense does it make to average (lat,lon) samples in order to increase 2D accuracy of a GPS location?

Several GPS applications, like this one, or this one, acquire multiple (lat,lon) samples of a given location, assuming that the GPS unit is not moving, and then take an average of the samples in order ...