[postgis-users] Help Needed For State Border Crossing Calculation
strk at keybit.net
Tue Oct 4 09:30:37 PDT 2011
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.
> 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
You could compute state containment, order by time and get the one
with minimum time value for each state.
() Free GIS & Flash consultant/developer
More information about the postgis-users