[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Nearest line from a point
From:       Jaime Casanova <jaime () 2ndquadrant ! com>
Date:       2011-08-22 8:23:33
Message-ID: CAJKUy5gycpu5WNJP2SGLC+dDMKjZvNtM2Lxxe5X3osby=b10AA () mail ! gmail ! com
[Download RAW message or body]

On Mon, Aug 22, 2011 at 2:27 AM, Jaime Casanova <jaime@2ndquadrant.com> wrote:
>
> and answering your question the column is of type geometry so i don't
> know why the casts to geography (this also happens in the explain i'm
> posting here), maybe because of the SRID i choose? (which is 4326)
>

and the answer is: yes, it's because of the SRID

http://postgis.refractions.net/documentation/manual-1.5/ch04.html#PostGIS_Geography
"""
Standard geometry type data will autocast to geography if it is of SRID 4326.
"""

can this be the reason of the problem? what SRID should i have be using?

-- 
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]