[mapserver-users] SQL Server 2008 layer only partially displaying

[Milena]

Hi all,

I have been trying to display a WMS layer from a SQL server database. Now, I
managed successfully to connect to the database and some part of the layer
appeared when Getmap requested but not all the polygons I should be seeing.
The strange thing is every time I refresh the request different parts of the
layer appear. Does anybody know why this might be? Also if I remove the
Class from the Layer, nothing is displayed. Map detail below

Thanks!

Milen

MAP 
  NAME Spatial 
  IMAGECOLOR 0 255 255 
  SIZE 600 800
  IMAGETYPE png 
  PROJECTION 
   "init=epsg:4326" #latlon on WGS84 
  END 
  EXTENT 100.000000 -35.000000 129.000000 -11.000000
  # lon/lat extents of WA tenements
  WEB 
    IMAGEPATH "/tmp/ms_tmp/" 
    IMAGEURL "/ms_tmp/" 
    METADATA 
      "map" "C:/ms4w/apps/Spatial/config.map" 
      "ows_schemas_location" "http://schemas.opengeospatial.net" 
      "ows_title" "Sample WMS" 
      "ows_abstract" "Sample WMS of Spatial" 
      "ows_keywordlist" "Spatial,WMS,Maxwell" 
      "ows_onlineresource"
"http://localhost:8080//spatial?map=C:/ms4w/apps/Spatial/config.map&" 
      "wms_srs" "EPSG:4326" #latlon       
      "wms_feature_info_mime_type" "text/plain" 
      "wms_feature_info_mime_type" "text/html" 
      "wms_server_version" "1.1.1" 
      "wms_formatlist" "image/png,image/gif,image/jpeg" 
      "wms_format" "image/gif" 
    END #metadata 
  END #web 
  LAYER
  NAME "tenements"
  CONNECTIONTYPE PLUGIN
  PLUGIN "C:/ms4w/Apache/specialplugins/msplugin_mssql2008.dll"

  CONNECTION "Server=.\SQL_2008;Database=LeaseCDemo2008GIS;Integrated
Security=true"

  DATA "geom from dbo.WA_Tenements USING UNIQUE ID USING SRID=0"
  TYPE POLYGON

  STATUS DEFAULT

  METADATA 
      "ows_title" "tenements" 
  END #metadata 
  PROJECTION 
     "init=epsg:4326" 
  END
  EXTENT 100.000000 -35.000000 129.0000000 -11.00000000
  TOLERANCE 0
  MAXSCALE 100000000
  CLASS
        NAME  "tenements"
        STYLE
	    COLOR 255 235 190
            OUTLINECOLOR  0 0 0
        END #style

  END #class
  END #Layer
End #Map
      
-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/SQL-Server-2008-layer-only-partially-displaying-tp5905621p5905621.html
Sent from the Mapserver - User mailing list archive at Nabble.com.