[postgis-users] Determine if point is north of another point
GOO Creations
goocreations at gmail.com
Sun Apr 17 02:07:30 PDT 2011
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
>
More information about the postgis-users
mailing list