[postgis-users] RE: Getting the nearest street name from GPS point

YC Nyon ycnyon at pd.jaring.my
Tue Mar 11 05:48:50 PST 2003


Hi,

I am developing some GPS vehicle tracking reports using PHP. Currently, the
lat/lon is kept in a MySQL database. What i want to do is  based on the each
lat /lon values, do a query to Postgis and return the nearest street name to
the points. A maximum distance tolerence would be good.
The street shape file is already loaded into PostGIS.

Right now, I'm not sure what Postgis query to use.

Thanks
Nyon



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003




More information about the postgis-users mailing list