[postgis-users] Help Needed For State Border Crossing Calculation

[Sandro Santilli]

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