Re: Spatial query for the Nearest location given a lat and long?

Use a function like this one:

select station_id, station_name, distance(stations_2.geom,(select geom from stations_1 where station_id = 34)) as dist from stations_2 where station_id <> 34 order by dist asc

hope this one speaks for itself, it returns a table ordered by distance, from the nearest to the furthest, process the result in a view or something.

Good luck!



bdbeames schreef:

I'm completely new to this so I need some help writing a query.

What I have is two tables with weather station information: id, name,
latitude, longitude, extra.

I am using google map where a user can click on a station from one of the
tables, I obtain the $latitude and $longitude points of that location.  I
now want to use these to find the nearest weather station in my other table
based on the $latitude and $longitude point.

All that I need back from the query is the id and name of the nearest
station.  Could someone help me write a simple query to do this. 

My development environment is Linux/Apache/Postgres/php.

Thanks.
  

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users