[postgis-users] Return point Lat, Long of ST_Distance(a.geog, b.geog)

[Lopez, Anthony]

All,

I am wondering if it is possible to return the lat, long coordinates of the point that the ST_Distance(a.geog, b.geog) function basis its distance calculation on.  Essentially, I'm after ST_ClosestPoint(), but using geography instead of geometry.


thanks,

Anthony

Anthony Lopez | GIS Analyst
Strategic Energy Analysis Center
National Renewable Energy Laboratory

1617 Cole Blvd Golden, Colorado 80401
ph 303.275.3654

anthony.lopez at nrel.gov<mailto:anthony.lopez at nrel.gov> | www.nrel.gov<http://www.nrel.gov/>