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
141 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
56 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
287 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 ...