On Tue, Sep 9, 2008 at 3:14 AM, Nicolas Ribot <[EMAIL PROTECTED]> wrote:

> No for surfaces. You will have to project your data into a planar
> projection system to do so (UTM for instance). This thread may be
> useful in your case to find the correct UTM zone according to your
> objects coordinates:


Untrue, the maths is just a little harder! And you need to assume the globe
is a sphere (ala distance_sphere()):

If you're dealing with lat-lon "rectangles" you want something like this:
http://mathforum.org/dr.math/faq/formulas/faq.sphere.html#spherecap

If you're dealing with arbitrary polygons its a bit more complicated:
http://groups.google.com/group/comp.infosystems.gis/browse_frm/thread/af0401d07c3068b5?lnk=igtc


HTH,

Rob :)
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to