0
votes
2answers
48 views

Identify circuits/loops in GPS track data

This question will be naive and uneducated, but I gotta start my research somewhere, so I'll ask for references and pointers... Let's say you have a GPS time series with a set of lat/long coordinates ...
0
votes
1answer
76 views

Add GPS tracks directly to a PostGIS table

Disclaimer: I am a total GIS newb and I have a use case I have not seen elsewhere. Background: I drive country roads looking for old building, cemeteries, school houses, etc and I record the ...
1
vote
1answer
235 views

Most Efficient method of Storing Point Data in PostGres/PostGIS to later re-create a track

I am trying to determine the most efficient way to store point data in PostGIS to later re-create tracks Criteria: 1 second updates 100- 200 tracks active at any one time 1 hour max ...
0
votes
0answers
28 views

How to find & send alert SMS for next bus stop in a GPS tracking system (PostGIS DB)? [duplicate]

In my gps tracking system, I have got 5 Stops for a vehicle. Whenever the bus reaches stop 1, the passengers at stop 2 should get an SMS alert. And in the same way for the sops followed by. Stops ...
1
vote
1answer
152 views

How to use Mapserver+Openstreetmap for tracking service effectively?

I have got Asset tracking installations for many clients. The availability of GIS map data for every client location seems to be the tough part. I have got a MapServer WMS installation. Can I use OSM ...
1
vote
1answer
57 views

What is the best way to construct a SQL query that returns the block name for each bus point as it travels?

I have two datasets in postgres; 1) a bunch of points that represent bus locations 2) city block polygons. Each bus has a unique ID and each block polygon has a field that has the block name in it. ...
3
votes
1answer
303 views

Using PostGIS for a large trajectory dataset

I have a spatial trajectory dataset which basically contains about 10E6 (lat,lon,time)-tuples, grouped together by an identifier so they form trajectories. Currently, SQLite is used to store the raw ...