On Tue, Oct 04, 2011 at 09:50:41PM +0530, rajeev singhal wrote: > Dear All, > > We are working on a project where we have a requirement to calculate the > miles driven by a vehicle statewise. Driver can > drive the vehicles in multiple states of the country and we have to show > miles driven in each state of the country. > > We are getting GPS Coordinates of the vehicle every 1 sec. and State Border > Data will also get available, Now my query is: > > 1. In what format should i ask for State Borders data that will be easier to > store in PostGIS database.
shapefiles > 2. How to find compare GPS Coordinates data that is coming every 1 sec with > State Borders data to find the GPS Record that corresponds to Border > Crossing. You could compute state containment, order by time and get the one with minimum time value for each state. --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
