List,

To help on debugging I've forced an error in the postgis connection te see the actual query. This is:

'DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(tc_vlak_geometry)),'NDR'),geoidn::text from "NL.IMRO.0026.SVBBU-0001x" WHERE (geoidn='geoidNL.IMRO.0026.SVBBU-0001') and (tc_vlak_geometry && setSRID( 'BOX3D(140016 460631,166758 490080)'::BOX3D,28992) )'

I've also got rid off all destracting details so I've ended up with the mapfile on the end of this message.

MArco

MAP
   NAME "NL.IMRO.0026.SVBBU-0001"
   IMAGETYPE png
   UNITS METERS
   EXTENT 140016 460631 166758 490080
   PROJECTION
      "init=epsg:28992"
   END
WEB METADATA
               "ows_title"           "NL.IMRO.0026.SVBBU-0001"
"wms_onlineresource" "http://tercera-go.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/80.101.100.35_check/NL.IMRO.0026.SVBBU-0001/wkt/NL.IMRO.0026.SVBBU-0001-test.map&"; "wfs_onlineresource" "http://tercera-go.tercera-ro.nl/cgi-bin/mapserv?map=../html/plancheck_test/data/80.101.100.35_check/NL.IMRO.0026.SVBBU-0001/wkt/NL.IMRO.0026.SVBBU-0001-test.map&";

           "wfs_srs"               "EPSG:28992"
           "wms_srs"               "EPSG:28992"
       END
   END
LAYER
   name "geoidNL.IMRO.0026.SVBBU-0001_vlak"

   PROJECTION
      "init=epsg:28992"
   END

METADATA
           "ows_title"           "geoidNL.IMRO.0026.SVBBU-0001_vlak"
       "gml_include_items"     "geoidn,idealisatie"
       #"gml_featureid"     "geoidn"
       "wfs_featureid"    "geoidn"
       "wfs_extent"        "140016 460631 166758 490080"
END

   STATUS on
   TYPE polygon
   DUMP true

   CONNECTIONTYPE postgis
   CONNECTION "host=localhost user=tc_check dbname=80.101.100.35"
DATA 'tc_vlak_geometry from "NL.IMRO.0026.SVBBU-0001" using unique geoidn using srid=28992'
   FILTER "geoidn='geoidNL.IMRO.0026.SVBBU-0001'"
TEMPLATE "dummy.html"
   CLASS
       STYLE
               COLOR 0 0 0
               OUTLINECOLOR 255 0 0
       END
   END
END


END
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to