[postgis-users] Nearest line from a point

Jaime Casanova jaime at 2ndquadrant.com
Mon Aug 22 01:23:33 PDT 2011

On Mon, Aug 22, 2011 at 2:27 AM, Jaime Casanova <jaime at 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

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

More information about the postgis-users mailing list