[postgis-users] list of the closest borders

[Doug Fischer]

Sorry but I just noticed that I made an error in my post.  What I  
meant to say was the SW corner of PA and in the table the distance to  
PA should be 0 because the Point is in PA.

Thanks,
Doug

On Sep 9, 2008, at 8:52 AM, Doug Fischer wrote:

> I am new to GIS / PostGIS so please forgive me if this is a simple  
> question.
>
> Assuming that I have a database populated with all of the proper  
> data, I need to do determine a list of the closest borders from a  
> point including distances.
>
> ex.
> If I have a point located in the SE corner of PA, I would like to  
> run a query that will return a list containing something like the  
> following:
>
>
> Border
> Distance in miles
> PA
> A
> OH
> B
> MD
> C
> WV
> D
> VA
> E
>
> Is there a function in PostGIS that can do this type of thing? Does  
> anyone have an example?
>
> Thank you very much.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080909/bb2dc357/attachment.html>