[mapserver-users] help -- PostGIS data not displaying as expected, works with shapefiles though!

[Ben Madin]

Sean,

On 01/05/2012, at 12:50 PM, Sean Twomey <stwomey at hotmail.com> wrote:

> I get the following error when I execute the map file at the bottom of this message: 
> 
> msDrawMap(): Image handling error. Failed to draw layer named 'nationalPark'. msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR: Operation on two geometries with different SRIDs 
> 
> I can get this to work when its just a shapefile, but it doesn't work when its coming from PostGIS.  I am using Mapserver 6.0.2 with postgresql 9.1 and postgis 1.5.3

It sounds like maybe your shape file has been imported with a different geometry to that which you are telling it in your request:

   DATA 'the_geom FROM "nationalPark" USING UNIQUE gid USING srid=3005'

would suggest that the data is in the database in the EPSG:3005 (British Columbia Albers) projection. Check that it is …?

cheers

Ben