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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
