Opened 18 years ago

Closed 18 years ago

#1505 closed defect (worksforme)

layer close called on PostGIS layer when getfeature on a shapefile layer

Reported by: bartvde@… Owned by: assefa
Priority: high Milestone: FUTURE
Component: WFS Server Version: unspecified
Severity: normal Keywords:
Cc:

Description

When I do a GetFeature request on a shapefile layer, and I have a PostGIS layer
in my MAP file and a Mapserver CGI without PostGIS support, I get the following
in my  GML:

        <stragisweb:HUISNUMMER>1</stragisweb:HUISNUMMER>
        <stragisweb:TOEVOEGING></stragisweb:TOEVOEGING>
        <stragiTue Oct 25 17:46:41 2005 - msPOSTGISLayerClose(): Query error. ms
POSTGISLayerClose called but unimplemented!(mapserver not compiled with postgis
support)
sweb:WOONPLAATS>LEIDERDORP</stragisweb:WOONPLAATS>
        <stragisweb:PLAATS_NEN>LEIDERDORP</stragisweb:PLAATS_NEN>
        <stragisweb:GEMEENTE>LEIDERDORP</stragisweb:GEMEENTE>
        <stragisweb:BVLK_ID>30FZ2002196</stragisweb:BVLK_ID>
        <stragisweb:X>96537</stragisweb:X>
        <stragisweb:Y>464064</stragisweb:Y>
        <stragisweb:KWALITEIT>1</stragisweb:KWALITEIT>
      </stragisweb:acn>
    </gml:featureMember>
</wfs:FeatureCollection>

This is the request:

<GetFeature service="WFS" version="1.0.0" xmlns="http://www.opengis.net/wfs"
xmlns:gml="http://www.opengis.net/gml" xmlns:ogc="http://www.opengis.net/ogc"
xmlns:xlink="http://www.w3.org/1999/xlink"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://schemas.opengis.net/wfs/1.0.0 WFS-basic.xsd"><Query
typeName="acn"><ogc:Filter><ogc:And><ogc:PropertyIsLike wildCard='*'
singleChar='.' escape='!'
matchCase='false'><ogc:PropertyName>PSTK</ogc:PropertyName><ogc:Literal>2353TH*</ogc:Literal></ogc:PropertyIsLike><ogc:PropertyIsLike
wildCard='*' singleChar='.' escape='!'
matchCase='false'><ogc:PropertyName>HUISNUMMER</ogc:PropertyName><ogc:Literal>*</ogc:Literal></ogc:PropertyIsLike></ogc:And></ogc:Filter></Query></GetFeature>

This is the MAP file:

# CONVENTIES VOOR NAAMGEVING LAGEN CQ MODULES
# NAAM VAN DE KAARTLAAG = NAAM VAN DE MODULE
# WANNEER ER MEERDERE GEOMETRIE TYPEN ZIJN VOOR EEN KAARTLAAG, ZOALS BISRAP_PUNT
EN BISRAP_VLAK
# DAN IS HET DEEL VOOR DE _ DE MODULENAAM.
# CONVENTIE: ALLE KAARTLAAG NAMEN LOWERCASE

MAP

  NAME "StraGISWeb"
  CONFIG PROJ_LIB /ms4w/apps/stragisweb/proj
  CONFIG GDAL_DATA /ms4w/apps/stragisweb/gdal_data
  STATUS ON
  EXTENT 90500 460500 99500 466650
  #EXTENT 91500 460500 98500 466500
  SIZE 650 400
  #SIZE 265 130
  FONTSET "fonts/fonts.list"
  SYMBOLSET "symbols/stragisweb.sym"
  #IMAGECOLOR 189 222 189
  IMAGECOLOR 255 255 255
  SHAPEPATH "../../mdwh/data/"
  TRANSPARENT OFF
  UNITS METERS

  PROJECTION
    "init=epsg:28992"
  END
  
  # 24 bit PNG output
  OUTPUTFORMAT
    NAME png
    DRIVER "GD/PNG"
    MIMETYPE "image/png"
    EXTENSION PNG
    IMAGEMODE RGBA
    TRANSPARENT ON
  END
  
  # 8 bit PNG output
  #OUTPUTFORMAT
  #  NAME png
  #  DRIVER "GD/PNG"
  #  MIMETYPE "image/png"
  #  IMAGEMODE PC256
  #  EXTENSION "png"
  #END

  WEB
    METADATA
      WMS_TITLE "StraGIS Web WMS"
      WMS_ABSTRACT "WMS StraGISWeb"
      WMS_ACCESSCONSTRAINTS "none"
      WMS_SRS "EPSG:28992"
      WFS_TITLE "StraGIS Web WFS"
      ows_schemas_location "http://schemas.cubewerx.com/schemas/"
      wfs_namespace_prefix "stragisweb"
      wfs_namespace_uri "http://www.syncera.net/stragisweb"
    END

END

REFERENCE
  EXTENT 91500 460500 98500 466500
  IMAGE mdwh.png
  STATUS ON
  COLOR -1 -1 -1
  OUTLINECOLOR 255 0 0
  SIZE 265 130
END

LEGEND
  IMAGECOLOR 255 255 255
  KEYSIZE 18 12
  KEYSPACING 5 5
  LABEL
    SIZE 8
    TYPE truetype
    FONT arial
    BUFFER 0
    COLOR 0 0 0
    FORCE FALSE
    MINDISTANCE -1
    MINFEATURESIZE -1
    OFFSET 0 0
    PARTIALS TRUE
  END
  POSITION LL
  STATUS ON
END
 
SCALEBAR
  STATUS ON
  COLOR 0 0 0
  OUTLINECOLOR 0 0 0
  BACKGROUNDCOLOR 255 255 255
  IMAGECOLOR 255 255 255
  TRANSPARENT ON
  UNITS METERS
  INTERVALS 3
  SIZE 250 3
  LABEL
    SIZE SMALL
    COLOR 0 0 0
  END
END

LAYER
  NAME "top250"
  METADATA
    wms_title "Top 250 raster"
  END
  STATUS ON
  MINSCALE 100000
  DATA "topdienst/TM250/M250.tif"
  TYPE RASTER
END

LAYER
  NAME "top100"
  METADATA
    wms_title "Top 100 raster"
  END
  STATUS ON
  MINSCALE 50000
  MAXSCALE 100000
  DATA "topdienst/TM100/M100.tif"
  TYPE RASTER
END

LAYER
  NAME "top50"
  METADATA
    wms_title "Top 50 raster"
  END
  STATUS ON
  MAXSCALE 50000
  MINSCALE 12500
  DATA "topdienst/TM050/M050.tif"
  TYPE RASTER
END

LAYER
  NAME "luchtfoto"
  METADATA
    wms_title "Luchtfoto"
  END
  STATUS ON
  MINSCALE 1500
  MAXSCALE 12500
  #OFFSITE 0 0 0
  TYPE RASTER
  DATA "luchtfoto/Leiderdorp_2005.tif"
END

LAYER
  NAME "tekst"
  METADATA
    wms_title "GBKN tekst"
  END
  STATUS ON
  TYPE ANNOTATION
  CONNECTIONTYPE OGR
  CONNECTION "basis/geo/tekst.TAB"
  MAXSCALE 2000
  PROJECTION
    "init=epsg:28992"
  END
  TOLERANCE 5
  LABELITEM tekst
  LABELANGLEITEM hoek
  SYMBOLSCALE 1000
  CLASS
    COLOR 255 0 0
    OUTLINECOLOR 0 0 0
    MINSIZE 15
    MAXSIZE 50
    MAXSCALE 2000
    LABEL
      TYPE TRUETYPE
      FONT "arial"
      SIZE 8
      COLOR 0 0 0
      POSITION auto
    END
  END
END

LAYER
  NAME "kadperceel"
  GROUP GBKN
  METADATA
    wms_title "Percelen"
    wfs_title "Percelen"
    gml_include_items "all"
  END
  STATUS ON
  DUMP TRUE
  TYPE POLYGON
  DATA "basis/geo/percelen"
  MINSCALE 0
  MAXSCALE 2000
  PROJECTION
    "init=epsg:28992"
  END
  LABELITEM SECNUM
  LABELANGLEITEM HOEK
  FILTERITEM "AANDUID"
  CLASS
    NAME "kadperceel"
    STYLE
      OUTLINECOLOR 150 150 150
      SIZE 1
    END
    MINSCALE 500
    MAXSCALE 2000
  END
  CLASS
    STYLE
      OUTLINECOLOR 150 150 150
      SIZE 1
    END
    MINSCALE 0
    MAXSCALE 500
    LABEL
      TYPE truetype
      FONT "arial"
      SIZE 7
      COLOR 0 0 200
      POSITION auto
    END
  END
END

LAYER
  NAME "overige"
  METADATA
    wms_title "Overige"
  END
  STATUS ON
  TYPE LINE
  CONNECTIONTYPE OGR
  CONNECTION "basis/geo/overige.TAB"
  MAXSCALE 10000
  PROJECTION
    "init=epsg:28992"
  END
  CLASS
    NAME "overige"
    COLOR 0 153 0
    OUTLINECOLOR 0 153 0
  END
END

LAYER
  NAME "grens"
  METADATA
    wms_title "Grens"
  END
  STATUS ON
  TYPE LINE
  CONNECTIONTYPE OGR
  CONNECTION "basis/geo/grens.TAB"
  MAXSCALE 10000
  PROJECTION
    "init=epsg:28992"
  END
  CLASS
    NAME "grens"
    COLOR 204 153 0
    OUTLINECOLOR 204 153 0
  END
END

LAYER
  NAME "acn"
  METADATA
    wms_title "Acn"
    wfs_title "Acn"
    gml_include_items "all"
  END
  DUMP TRUE
  STATUS ON
  TYPE POINT
  DATA "basis/geo/Adrloc_point"
  MAXSCALE 501
  PROJECTION
    "init=epsg:28992"
  END
  TOLERANCE 12
  TOLERANCEUNITS METERS
  LABELITEM "STRAATNAAM"
  CLASS
    COLOR 153 0 153
    OUTLINECOLOR 153 0 153
    SYMBOL "circle"
    SIZE 5
    TEXT ([STRAATNAAM][HUISNUMMER])
    LABEL
      TYPE truetype
      FONT "arial"
      POSITION AUTO
      SIZE 8
      COLOR 153 0 153
    END
  END
END

LAYER
  NAME "hnrlabel"
  METADATA
    wms_title "Huisnummers"
  END
  STATUS ON
  TYPE ANNOTATION
  CONNECTIONTYPE OGR
  CONNECTION "basis/geo/hnrlabel.TAB"
  MINSCALE 200
  MAXSCALE 501
  PROJECTION
    "init=epsg:28992"
  END
  TOLERANCE 8
  LABELITEM TEKST
  LABELANGLEITEM HOEK
  CLASS
    LABEL
      TYPE TRUETYPE
      FONT "arial"
      SIZE 8
      COLOR 127 127 127
      POSITION auto
    END
  END
END

LAYER
  NAME "huisnummer"
  METADATA
    wms_title "Huisnummers"
  END
  STATUS ON
  TYPE ANNOTATION
  CONNECTIONTYPE OGR
  CONNECTION "basis/geo/hnrtekst.TAB"
  MINSCALE 0
  MAXSCALE 501
  PROJECTION
    "init=epsg:28992"
  END
  TOLERANCE 8
  LABELITEM TEKST
  LABELANGLEITEM HOEK
  CLASS
    LABEL
      TYPE TRUETYPE
      FONT "arial"
      SIZE 8
      COLOR 127 127 127
      POSITION auto
    END
  END
  #TEMPLATE "blank.html"
END

LAYER
  NAME "strtekst"
  METADATA
    wms_title "Straatnamen"
  END
  STATUS ON
  TYPE ANNOTATION
  CONNECTIONTYPE OGR
  CONNECTION "basis/geo/strtekst.TAB"
  MINSCALE 0
  MAXSCALE 2000
  PROJECTION
    "init=epsg:28992"
  END
  TOLERANCE 5
  LABELITEM tekst
  LABELANGLEITEM hoek
  SYMBOLSCALE 1000
  CLASS
    COLOR 0 0 0
    OUTLINECOLOR 0 0 0
    LABEL
      TYPE TRUETYPE
      FONT "Arial"
      SIZE 10
      COLOR 99 99 99
      POSITION auto
    END
  END
END

LAYER
  NAME "water"
  METADATA
    wms_title "Water"
  END
  STATUS ON
  TYPE LINE
  CONNECTIONTYPE OGR
  CONNECTION "basis/geo/oppwater.TAB"
  MAXSCALE 10000
  PROJECTION
    "init=epsg:28992"
  END
  TRANSPARENCY 70
  CLASS
    NAME "water"
    COLOR 51 51 255
    OUTLINECOLOR 51 51 255
  END
END

LAYER
  NAME "bebouw"
  METADATA
    wms_title "Bebouwing"
  END
  STATUS ON
  TYPE LINE
  CONNECTIONTYPE OGR
  CONNECTION "basis/geo/bebouw.TAB"
  MAXSCALE 5000
  PROJECTION
    "init=epsg:28992"
  END
  TRANSPARENCY 70
  LABELITEM KLASSE
  CLASS
    NAME " "
    COLOR 255 102 0
    OUTLINECOLOR 255 102 0
  END
END

LAYER
  NAME "wegen"
  METADATA
    wms_title "Wegen"
  END
  STATUS ON
  TYPE LINE
  CONNECTIONTYPE OGR
  CONNECTION "basis/geo/wegen.TAB"
  MAXSCALE 10000
  PROJECTION
    "init=epsg:28992"
  END
  TRANSPARENCY 70
  CLASS
    NAME " "
    COLOR 0 0 0
    OUTLINECOLOR 0 0 0
    SIZE 1
  END
END

LAYER
  NAME "gemgrens"
  METADATA
    wms_title "Gemeentegrenzen"
  END
  STATUS ON
  TYPE LINE
  CONNECTIONTYPE OGR
  CONNECTION "basis/geo/gemgrens.TAB"
  PROJECTION
    "init=epsg:28992"
  END
  CLASS
    NAME " "
    SYMBOL "circle"
    COLOR 240 230 140
    SIZE 3
  END
END

LAYER
  NAME "basisgebieden"
  METADATA 
    wms_title "Basisgebieden"
    stragisweb_searchfield "ogc_fid"
    stragisweb_displayfield "naam_mdwh"
    stragisweb_spreadsheet "true"
  END
  STATUS ON
  TEMPLATE "blank.html"
  TYPE POLYGON
  CONNECTION "user=postgres password=stragisweb dbname=mdwh host=127.0.0.1"
  CONNECTIONTYPE postgis
  DATA "wkb_geometry from basisgebieden_conept4 USING UNIQUE oid"
  PROJECTION
    "init=epsg:28992"
  END
  TRANSPARENCY 50
  CLASS
    NAME "basisgebied"
    STYLE
      SYMBOL "circle"
      OUTLINECOLOR 255 0 0
      SIZE 2
    END
  END
END
  
LAYER
  NAME "bedrijven"
  METADATA
    wms_title "WM-plichtige bedrijven"
    stragisweb_searchfield "loc_id"
    stragisweb_displayfield "loc_naam"
    stragisweb_spreadsheet "false"
  END
  TYPE POINT
  CONNECTION "user=stragisweb password=synstragisweb dbname=mdwh host=127.0.0.1"
  CONNECTIONTYPE postgis
  DATA "the_geom from milieu.vw_bedrijven_intern USING UNIQUE oid"
  FILTERITEM "loc_id"
  CLASSITEM "meldingkleur"
  MAXSCALE 25000
  TEMPLATE "blank.html"
  STATUS ON
  PROJECTION
    "init=epsg:28992"
  END
  CLASS
    EXPRESSION "1"
    NAME "Melding"
    STYLE
      SYMBOL "circle"
      SIZE 10
      COLOR 51 204 51
      OUTLINECOLOR 0 0 0
    END
  END
  CLASS
    EXPRESSION "2"
    NAME "Vergunning"    
    STYLE
      SYMBOL "circle"
      SIZE 10
      COLOR 51 102 255
      OUTLINECOLOR 0 0 0
    END
  END
  CLASS
    EXPRESSION "3"
    NAME "Beide"    
    STYLE
      SYMBOL "circle"
      SIZE 10
      COLOR 51 204 204
      OUTLINECOLOR 0 0 0
    END
  END
  CLASS
    EXPRESSION /[4-7]/
    NAME "Provincie"    
    STYLE
      SYMBOL "circle"
      SIZE 10
      COLOR 255 0 0
      OUTLINECOLOR 0 0 0
    END
  END
#  CLASS
#    EXPRESSION "0"
#    NAME "Geen van beide"
#    STYLE
#      SYMBOL "circle"
#      SIZE 10
#      COLOR 255 255 51
#      OUTLINECOLOR 0 0 0
#    END
#  END
  CLASS
    NAME "Selectie"    
    STYLE
      SYMBOL "circle"
      SIZE 10
      COLOR 255 51 204
      OUTLINECOLOR 0 0 0
    END
  END
END

END

Change History (2)

comment:1 by assefa, 18 years ago

Cc: mapserver-bugs@… added
Owner: changed from mapserverbugs to assefa
looking into it.

comment:2 by assefa, 18 years ago

Milestone: FUTURE
Resolution: worksforme
Status: newclosed
I had a look into a few weeks back and could not really reproduce it.
Marking it as works for me. Bart, repopen if needed.
Note: See TracTickets for help on using tickets.