[mapserver-users] Oracle layer partially drawn

Rahkonen Jukka (Tike) jukka.rahkonen at mmmtike.fi
Wed Sep 3 02:10:32 PDT 2014


Hi,

Could you have arcs in the linestrings in Oracle?  I think that Mapserver supports only " Line string whose vertices are connected by straight line segments." http://docs.oracle.com/cd/B28359_01/appdev.111/b28400/sdo_objrelschema.htm#SPATL494

I am not sure, though, and our documents, which feels also party outdated, do not tell anything about curved geometries of Oracle
http://mapserver.org/input/vector/oracle.html 
http://mapserver.org/installation/oracle.html

If you have only straight lines in Oracle then the issue is somewhere else.

-Jukka Rahkonen-

Geograma wrote:
 
> Hello,
> 
> With MapServer for Windows (3.0.6 updated to MapServer 6.2.0-beta4), I’m
> writing a “.map” that uses data from an Oracle 11g schema. All looks OK but,
> when a map is requested, only some features are drawn. In the log there is no
> error or warning. Anybody knows what is happening? (any suggestion will be
> appreciated)
> 
> Attached are two images, one with the map that should be got (data in a PostGis
> server), another with the map got from Oracle and the “.map” used to generate
> the second image.
> 
> <http://osgeo-org.1560.x6.nabble.com/file/n5159828/oracle.png>
> 
> <http://osgeo-org.1560.x6.nabble.com/file/n5159828/postgis.png>
> 
> Tha ".map" file is as  follows:
> 
> MAP
>    NAME TEST
>    EXTENT -1450047 2763292 2122072 5658922
>   SYMBOLSET "symbols.sym"
>   FONTSET "font.list"
>    LEGEND
>       IMAGECOLOR -1 -1 -1
>       LABEL
>          FONT "vera"
>          ANGLE FOLLOW
>          COLOR 0 0 0
>          ENCODING "UTF-8"
>          TYPE truetype
>          SIZE 8
>       END
>       STATUS ON
>       TRANSPARENT ON
>    END
>    WEB
>       METADATA
>          "wms_encoding" "UTF-8"
>          "wms_title" "title"
>          "wms_abstract" ""
>          "wms_srs" "epsg:23030 epsg:4326"
>          "wms_enable_request" "*"
>          "wms_onlineresource"
> "http://v-0049:8080/fcgi-bin/mapserv.exe?map=C:\\ms4w\\maps\\test.map"
>          labelcache_map_edge_buffer "-10"
>       END
>    END
>    PROJECTION
>       "init=epsg:23030"
>    END
> 
>    #CONFIG MS_ERRORFILE "c:\\ms4w_3_0_6\\maps\\logs\\test.log"
>    #DEBUG 5
> 
>    IMAGECOLOR 153 179 204
> 
>    OUTPUTFORMAT
> 	  NAME png
> 	  DRIVER "AGG/PNG"
> 	  MIMETYPE "image/png"
> 	  IMAGEMODE RGB
> 	  EXTENSION "png"
> 	  FORMATOPTION QUALITY=100
> 	  FORMATOPTION "INTERLACE=OFF"
> 
>    END
> 
>    LAYER
>       NAME "geo_r3_500K-1M"
>       STATUS ON
>       TYPE LINE
>       CONNECTIONTYPE oraclespatial
>       CONNECTION "user/pass at service"
>       DATA "geom from geo_r3 using unique id srid 23030"
> 	  MAXSCALEDENOM 749210
>       MINSCALEDENOM 149750
>       TRANSPARENCY 100
>       SIZEUNITS pixels
> 	  DUMP TRUE
>       PROJECTION
>          "init=epsg:23030"
>       END
>       CLASS
>          STYLE
>             INCLUDE 'defs/roundedline.def'
>             COLOR 170 170 170
>             WIDTH 5
>          END
>          STYLE
>             INCLUDE 'defs/roundedline.def'
>             COLOR 255 255 115
>             WIDTH 2
>          END
>          NAME "default"
>       END
>       METADATA
>          "wms_title" "public.geo_r3_500K-1M"
>          "wms_abstract" "Capa del Servicio WMS"
>          "wms_extent" "-971136.125 3134652.25 1051167.75 4846924.0"
>          "gml_include_items" "all"
>       END
>       PROCESSING "CLOSE_CONNECTION=DEFER"
>    END # Layer
> END # Map File
> 
> 
> 
> --
> View this message in context: http://osgeo-org.1560.x6.nabble.com/Oracle-
> layer-partially-drawn-tp5159828.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


More information about the MapServer-users mailing list