[postgis-users] Determine if point is north of another point

[GOO Creations]

Thank you, that worked.

Peter

On 2011/04/16 08:12 PM, Stephen Woodbridge wrote:
> On 4/16/2011 12:14 PM, GOO Creations wrote:
>> Hi all
>>
>> I'm looking for a way to determine if a point P1 is (more or less) north
>> of point P2. Is there any easy way of doing this.
>>
>> I've thought of using the latitudes of the points, but I having problems
>> constructing the query (especially since the latitudes can be positive
>> and negative)
>>
>> Any help will be appreciated
>
> select * from points where st_y(the_geom) > <some latitude> order by 
> st_y(the_geom);
>
> more north is always greater latitude.
>
> -Steve
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>