[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