MapServer / MapServer-import

3 stars 2 forks source link

mapserver query Problem ms4w4.8.1 #1746

Open tbonfort opened 12 years ago

tbonfort commented 12 years ago

Reporter: counter0strike@eyou.com Date: 2006/04/11 - 06:37

This is mymapfile:

#
# Start of map file
#
# Sample map file for a chameleon app.
#
MAP
  EXTENT 0 0 8600 3000
  FONTSET "/ms4w/apps/projectgis/etc/fonts.txt"
  IMAGECOLOR 0 0 0
  IMAGETYPE png
  SYMBOLSET "/ms4w/apps/projectgis/etc/symbols.sym"
  SIZE 400 300
  STATUS ON
  UNITS METERS
  NAME "DEMO"

  DEBUG ON
  OUTPUTFORMAT
    NAME "png"
    MIMETYPE "image/png"
    DRIVER "GD/PNG"
    EXTENSION "png"
    IMAGEMODE "PC256"
    TRANSPARENT FALSE
  END

  LEGEND
    IMAGECOLOR 255 255 255
    KEYSIZE 20 10
    KEYSPACING 5 5
    LABEL
      SIZE MEDIUM
      TYPE BITMAP
      BUFFER 0
      COLOR 0 0 0
      FORCE FALSE
      MINDISTANCE -1
      MINFEATURESIZE -1
      OFFSET 0 0
      PARTIALS TRUE
      POSITION CC
    END
    POSITION LL
    STATUS OFF
  END

  QUERYMAP
    COLOR 255 255 0
    SIZE -1 -1
    STATUS OFF
    STYLE HILITE
  END

  SCALEBAR
    COLOR 0 0 0
    IMAGECOLOR 255 255 255
    INTERVALS 4
    LABEL
      SIZE MEDIUM
      TYPE BITMAP
      BUFFER 0
      COLOR 0 0 0
      FORCE FALSE
      MINDISTANCE -1
      MINFEATURESIZE -1
      OFFSET 0 0
      PARTIALS TRUE
    END
    POSITION LL
    SIZE 200 3
    STATUS OFF
    STYLE 0
    UNITS MILES
  END

  WEB
    IMAGEPATH "/ms4w/tmp/ms_tmp/"
    IMAGEURL "/ms_tmp/"
      METADATA
      END
    QUERYFORMAT text/html
    LEGENDFORMAT text/html
    BROWSEFORMAT text/html
  END
    #
# Start of reference map
#
    REFERENCE
      IMAGE "../images/keymap.png"
      EXTENT -1000 -2000 9600 5000
       STATUS OFF
       COLOR -1 -1 -1
       OUTLINECOLOR 255 0 0
       SIZE 120 80      
    END
LAYER
    CLASSITEM "color"
    CONNECTION "host=192.168.1.1 port=5432 dbname=bc password=postgres 
user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from testdwg_lin"
    FILTER "layer ='CJT'"
    GROUP "CJT"
      METADATA
        "queryable" "true"
      END
    NAME "CJT"
    SIZEUNITS PIXELS
    STATUS DEFAULT
    TOLERANCEUNITS PIXELS
    TYPE LINE
    UNITS METERS
    CLASS
      NAME "7"
      EXPRESSION "7"
      TEMPLATE  "ttt_template.html"
      METADATA
      END
      STYLE
        ANGLE 360
        COLOR 0 0 0
        SYMBOL 0
      END
    END
  END

LAYER
    CLASSITEM "color"
    CONNECTION "host=192.168.1.1 port=5432 dbname=bc password=postgres 
user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from testdwg_lin"
     FILTER "layer ='±£»¤ÃºÖù'"
    GROUP "±£»¤ÃºÖù"
      METADATA
        "queryable" "true"
      END
    NAME "±£»¤ÃºÖù"
    SIZEUNITS PIXELS
    STATUS DEFAULT
    TOLERANCEUNITS PIXELS
    TYPE LINE
    UNITS METERS
    CLASS
        TEMPLATE  "ttt_template.html"
      NAME "7"
      EXPRESSION "7"
      METADATA
      END
      STYLE
        ANGLE 360
        COLOR 0 0 0
        SYMBOL 0
      END
    END
  END

  LAYER
    CLASSITEM "color"
    CONNECTION "host=192.168.1.1 port=5432 dbname=bc password=postgres 
user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from testdwg_lin"
    FILTER "layer ='±£»¤ÃºÖùÏß'"
    GROUP "±£»¤ÃºÖùÏß"
      METADATA
      "queryable" "true"
      END
    NAME "±£»¤ÃºÖùÏß"
    SIZEUNITS PIXELS
    STATUS DEFAULT
    TOLERANCEUNITS PIXELS
    TYPE LINE
    UNITS METERS
    CLASS
        TEMPLATE  "ttt_template.html"
      NAME "3"
      EXPRESSION "3"
      METADATA
      END
      STYLE
        ANGLE 360
        COLOR 0 255 0
        SYMBOL 0
      END
    END
    CLASS
        TEMPLATE  "ttt_template.html"
      NAME "6"
      EXPRESSION "6"
      METADATA
      END
      STYLE
        ANGLE 360
        COLOR 255 0 255
        SYMBOL 0
      END
    END
    CLASS
        TEMPLATE "ttt_template.html"
      NAME "7"
      EXPRESSION "7"
      METADATA
      END
      STYLE
        ANGLE 360
        COLOR 0 0 0
        SYMBOL 0
      END
    END
  END

  LAYER
    CLASSITEM "color"
    CONNECTION "host=192.168.1.1 port=5432 dbname=bc password=postgres 
user=postgres"
    CONNECTIONTYPE POSTGIS
    DATA "the_geom from testdwg_lin"
    FILTER "layer ='³åË¢´ø'"
    GROUP "³åË¢´ø"
      METADATA
      "queryable" "true"
      END
    NAME "³åË¢´ø"
    SIZEUNITS PIXELS
    STATUS DEFAULT
    TOLERANCEUNITS PIXELS
    TYPE LINE
    UNITS METERS
    CLASS
    TEMPLATE "ttt_template.html"
      NAME "7"
      EXPRESSION "7"
      METADATA
      END
      STYLE
        ANGLE 360
        COLOR 0 0 0
        SYMBOL 0
      END
    END
  END
LAYER
  GROUP "ÆäËü"
  NAME other_lin
  METADATA
    "queryable" "true"
  END
  TYPE LINE
  STATUS ON
  CONNECTIONTYPE postgis
  CONNECTION "host=202.113.25.109 port=5432 dbname=bc password=postgres 
user=postgres"
  DATA "the_geom from testdwg_lin"

  CLASSITEM "Layer"
  CLASS
      TEMPLATE "ttt_template.html"
    EXPRESSION "¶¨Òåµã"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END
  CLASS

    EXPRESSION "dx"
    COLOR 255 255 255
    STYLE
        WIDTH 4
    END
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    TEMPLATE "ttt_template.html"
    EXPRESSION "±£»¤ÃºÖù"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END

  CLASS
    EXPRESSION "±±Òí"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "±³Ð±"
    COLOR 255 0 0
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "²É¿ÕÇø"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "³åË¢´ø"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "´åׯ±£»¤·¶Î§"
    COLOR 255 255 0
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "µ¥ÏßÒѾòÏïµÀ"
    COLOR 255 128 64
    STYLE
        WIDTH 4
    END
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "µÈ¸ßÏß"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "µÈ¸ßÏߣ¬"
    COLOR 255 255 255
   # OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "µØÃæ×ê¿×"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "µØÃæ×ê¿×"
    COLOR 255 0 0
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "¶Ï²ã"
    COLOR 255 0 0
    STYLE
        WIDTH 2
    END
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "·½¸ñÍø"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "¸÷¼¶µ¼Ïßµã"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "¹¤×÷ÃæÔÂÍƽø¶È"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "¾®Ìï±ß½ç"
    COLOR 255 255 255
    STYLE
        WIDTH 10
    END
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "¾ò½ø½ø¶È"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "ÄÏÒí"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "Éè¼ÆÏïµÀ"
    COLOR 0 0 255
    STYLE
        WIDTH 2
    END
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "Ë®ÎÄ¿×"
    COLOR 0 0 255
    STYLE
        WIDTH 2
    END
    #OUTLINECOLOR 12 12 12
  END

  CLASS
    EXPRESSION "Ïò±³Ð±"
    COLOR 255 0 0
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "ÒѾòÏïµÀ"
    COLOR 255 128 64
    STYLE
        WIDTH 2
    END
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "ÒôƵµç͸ÊÓ"
    COLOR 255 0 255
    #OUTLINECOLOR 12 12 12
  END
  CLASS
    EXPRESSION "Ö¸±±Õë"
    COLOR 255 255 255
    #OUTLINECOLOR 12 12 12
  END
END # layer

#Îı¾²ã
LAYER # States label layer begins here
    GROUP        "Îı¾"
    NAME         all_texts 
    METADATA
     # "LAYER"       "layer"
     # "DESCRIPTION" "textstring"
     # "STYLE"       "sytle"
      "queryable"   "true"
    END
    TYPE    POINT
    STATUS       ON
    CONNECTIONTYPE postgis
    CONNECTION "host=192.168.1.1 port=5432 dbname=bc password=postgres 
user=postgres"
    DATA "the_geom from testdwg_text"

    LABELITEM "textstring"
    CLASSITEM "id"
    TOLERANCE 2

    CLASS
      EXPRESSION "1"
      TEMPLATE "ttt_query.html"
      COLOR 255 0 0
        SYMBOL 2
        SIZE 10
     #  NAME "hyk"
        LABEL
          COLOR 255 255 255
          POSITION CL     
          PARTIALS FALSE
          TYPE TRUETYPE
          FONT simkai
          SIZE 8     
        END 
    END
    CLASS
      EXPRESSION "2"
      TEMPLATE "ttt_query.html"
      COLOR 255 0 0
        SYMBOL 2
        SIZE 10
     #  NAME "hyk"
        LABEL
          COLOR 255 255 255
          POSITION CL     
          PARTIALS FALSE
          TYPE TRUETYPE
          FONT simkai
          SIZE 8     
        END 
    END

    CLASS
      EXPRESSION "3"
      TEMPLATE "ttt_query.html"
      COLOR 255 0 0
        SYMBOL 2
        SIZE 10
     #  NAME "hyk"
        LABEL
          COLOR 255 255 255
          POSITION CL     
          PARTIALS FALSE
          TYPE TRUETYPE
          FONT simkai
          SIZE 8     
        END 
    END

    CLASS
      EXPRESSION "4"
      TEMPLATE "ttt_query.html"
      COLOR 255 0 0
        SYMBOL 2
        SIZE 10
     #  NAME "hyk"
        LABEL
          COLOR 255 255 255
          POSITION CL     
          PARTIALS FALSE
          TYPE TRUETYPE
          FONT simkai
          SIZE 8     
        END 
    END

    CLASS
      EXPRESSION "49"
      TEMPLATE "ttt_query.html"
      COLOR 255 0 0
        SYMBOL 4
        SIZE 10
        #NAME "hyk"
        LABEL
          COLOR 255 255 255
          POSITION CL    
          PARTIALS FALSE
          TYPE TRUETYPE
          FONT simkai
          SIZE 8     
        END 
    END

    CLASS
      EXPRESSION "162"
      TEMPLATE "ttt_query.html"
      COLOR 255 0 0
        SYMBOL 2
        SIZE 10
     #  NAME "hyk"
        LABEL
          COLOR 255 255 255
          POSITION CL     
          PARTIALS FALSE
          TYPE TRUETYPE
          FONT simkai
          SIZE 8     
        END 
    END

    CLASS
      EXPRESSION "130"
      TEMPLATE "ttt_query.html"
      COLOR 255 0 0
        SYMBOL 3
        SIZE 10
      # NAME "hyk"
        LABEL
          COLOR 255 255 255
          POSITION CL     
          PARTIALS FALSE
          TYPE TRUETYPE
          FONT simkai
          SIZE 8     
        END
      END

      CLASS
      EXPRESSION "131"
      TEMPLATE "ttt_query.html"
      COLOR 255 0 0
        SYMBOL 4
        SIZE 10
        #NAME "hyk"
        LABEL
          COLOR 255 255 255
          POSITION CL   
          PARTIALS FALSE
          TYPE TRUETYPE
          FONT simkai
          SIZE 8     
        END 
    END

END # layer
  # End of LAYER DEFINITIONS -------------------------------

END # Map File

when I perform querybyrect operation,some correct results return,but some 
can't display and the following error appear.Please help me! 
Fatal error: [MapServer Error]: msQueryByRect(): No matching record(s) found. 
in E:\ms4w\apps\projectgis\htdocs\map_query.php on line 251
tbonfort commented 12 years ago

Author: assefa Date: 2006/08/22 - 18:37

Is the message valid in the sense that the query should not find elements ?

If that is the case, you can avoid warning by using the @ in front of your 
query command ( @$map->queryByRect($oGeorefRect);
tbonfort commented 12 years ago

Author: assefa Date: 2008/06/03 - 16:25 Closing. The error message is valid when features are not found.