I will reconvert my data again in PostGIS. I think ogr2or creates a oid automatically. Thanks for helping out
Steven On Nov 19, 2007 4:01 PM, Marcos Sánchez Provencio <[EMAIL PROTECTED]> wrote: > Try setting debug and see what querys get the database. > > > El lun, 19-11-2007 a las 15:31 +0100, Steven De Vriendt escribió: > > update: > > when I use SRID=-1 I get a map in return but I'm still unable to query > > it.. > > > > Steven > > > > On Nov 19, 2007 3:26 PM, Steven De Vriendt <[EMAIL PROTECTED]> > > wrote: > > Marcos, > > > > When I try your suggestion Mapserver returns: > > > > − > > <ServiceExceptionReport version="1.1.0"> > > − > > <ServiceException> > > > > msDrawMap(): Image handling error. Failed to draw layer named > > 'percelen'. > > msPOSTGISLayerWhichShapes(): Query error. Error executing > > POSTGIS SQL statement (in FETCH ALL): DECLARE mycursor BINARY > > CURSOR FOR SELECT > > asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text > > from (SELECT * FROM b_capa_percid) AS foo WHERE the_geom && > > setSRID('BOX3D( 76945.5918856108 > > 189996.502536997,91328.1081143621 201805.497460877)'::BOX3D, > > 31300 ) > > -ERROR: Operation on two geometries with different SRIDs > > > > > > </ServiceException> > > </ServiceExceptionReport> > > > > > > > > On Nov 19, 2007 3:19 PM, Marcos Sánchez Provencio > > <[EMAIL PROTECTED]> wrote: > > try > > DATA "the_geom from (SELECT * FROM b_capa_percid) as > > foo > > using srid=31300 using unique gid" > > > > > > > > El lun, 19-11-2007 a las 09:48 +0100, Steven De > > Vriendt escribió: > > > > > DATA "the_geom from b_capa_percid" > > > > > > > > > > > >