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

[Stephen Woodbridge]

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