[postgis-users] Incorrect results from queries specifying an SRID

[Wood Brent]

--- cp <cplists at yeroc.ca> wrote:
> Hello,
> 
> I'm getting some unexpected results from queries that specify an SRID.  
> I have a table with features (MULTILINESTRING) stored with an SRID of 
> 4267 (NAD27).  Querying with a geometry with a matching SRID returns the 
> expected results:

I think you'll find "normal" spatial queries do not use projection data
on-the-fly. You'll need to reproject one dataset to the same projection as the
other. The transform funtion will do this.


Brent Wood