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

[Tamas Szekeres]

Milena,

Could you inspect in the SQL Server Profiler what kind of SQL requests are
happening in the subsequent requests?

Best regards,

Tamas



2011/1/10 Milena <mgebreab at maxgeo.com>

>
> 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.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110110/5b6b0870/attachment.htm>