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

List:       postgis-users
Subject:    [postgis-users]
From:       David Blasby <dblasby () refractions ! net>
Date:       2003-04-15 18:01:27
Message-ID: 3E9C48F7.5080607 () refractions ! net
[Download RAW message or body]

Pedro Salazar wrote:

>David,
>
>sorry to bother you agin but I think you could help me on this.
>
>I'm getting this error when I try to see if geom overlaps my box3d:
>
>ERROR:  Operation on two GEOMETRIES with different SRIDs
>
>It's so strange that instead of using a custom point, I use the points
>from the table: 
>
>SELECT * FROM geom_poi WHERE geom && expand(geom, 200);
>
>How is that possible? Could you help here one more time?
>
>BTW, I'm working with 2D. I don't know if it matters...
>
Ah, there is a little gotch-ya here.  BOX3Ds do not have an SRID, so it 
can cause problem:
Use:

setSRID(expand(geom, 200) , <SRID>) 


Where <SRID> is the SRID of data in your geom_poi  table.

dave



>  
>



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