[mapserver-users] Oracle layer partially drawn
Rahkonen Jukka (Tike)
jukka.rahkonen at mmmtike.fi
Wed Sep 3 04:29:37 PDT 2014
Hi,
For minimizing the possibility that it is some projection error, could you do the import again by adding -lco SRID=4326 into the ogr2ogr command? Drop the old table first and delete the corresponding row from ALL_SDO_GEOM_METADATA.
-Jukka-
> -----Alkuperäinen viesti-----
> Lähettäjä: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-
> bounces at lists.osgeo.org] Puolesta Geograma
> Lähetetty: 3. syyskuuta 2014 13:57
> Vastaanottaja: mapserver-users at lists.osgeo.org
> Aihe: Re: [mapserver-users] Oracle layer partially drawn
>
> Hello Tike,
>
> First, thanks for your help!
>
> - Checked that the layer has all the data (the same records in PostGis and
> Oracle).
> - DEBUG 5 is on
> - Cannot try ORG connection (it gives me an error, I do not know why)
> - Scaledoms, transparency, wms_extent and spatial index recreated in Oracle
> removed but no change
>
> - The test you suggested:
>
> · Downloaded:
> http//www.naturalearthdata.com/download/10m/cultural/ne_10m_populated_
> places.zip
> · Loaded info to Oracle using ogr2ogr -f oci oci:user/pass at orcl
> ne_10m_populated_places.shp
> · New "NE_10M_POPULATED_PLACES.map", as follows:
> -------------------------------------------------------
> MAP
> NAME TEST
> EXTENT -180 -90 180 90
> SYMBOLSET "symbols.sym"
> FONTSET "fonts.txt"
> DEBUG ON
> 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" "WMS"
> "wms_abstract" ""
> "wms_srs" "epsg:4326 epsg:23030"
> "wms_enable_request" "*"
> "wms_onlineresource"
> "http://v-0049:8080/fcgi-
> bin/mapserv.exe?map=C:\ms4w\maps\NE_10M_POPULATED_PLACES.map"
> labelcache_map_edge_buffer "-10"
> END
> END
> PROJECTION
> "init=epsg:4326"
> END
>
> CONFIG MS_ERRORFILE
> "c:\ms4w_3_0_6\maps\logs\NE_10M_POPULATED_PLACES.log"
> DEBUG 5
> CONFIG "CPL_DEBUG" "ON"
> CONFIG "PROJ_DEBUG" "ON"
>
> 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 "NE_10M_POPULATED_PLACES"
> STATUS ON
> TYPE POINT
> CONNECTIONTYPE oraclespatial
> CONNECTION "FONDO_2014_06/FONDO_2014_06 at orcl"
> DATA "ora_geometry from NE_10M_POPULATED_PLACES using unique
> ogr_fid srid 4326"
> SIZEUNITS pixels
> LABELITEM "name"
> PROJECTION
> "init=epsg:4326"
> END
> TYPE truetype
> CLASS
> STYLE
> COLOR 254 0 0
> SIZE 1
> END
> SYMBOL "circle"
> NAME "default"
> LABEL
> FONT "arial"
> ANGLE 0
> COLOR 0 0 0
> TYPE truetype
> SIZE 10
> POSITION Auto
> PARTIALS FALSE
> FORCE FALSE
> OUTLINECOLOR 254 254 254
> END
> END
> METADATA
> "wms_title" "public.smaltown_point_500k"
> "wms_abstract" "Capa del Servicio WMS"
> #"wms_extent" "-180 -90 180 90"
> "wms_layer_group" "/TINSAMaps"
> "gml_include_items" "all"
> END
> PROCESSING "CLOSE_CONNECTION=DEFER"
> END # Layer
>
> END # Map File
> -------------------------------------------------------
>
> · Request made:
> http://v-0049:8081/fcgi-
> bin/mapserv.exe?map=C:\ms4w_3_0_6\maps\NE_10M_POPULATED_PLACES.m
> ap&LAYERS=NE_10M_POPULATED_PLACES&TRANSPARENT=TRUE&SERVICE=W
> MS&VERSION=1.1.1&REQUEST=GetMap&STYLES=&FORMAT=image%2Fpng&SR
> S=EPSG%3A4326&BBOX=-180,-90,180,90&WIDTH=768&HEIGHT=384&d
>
> · Log got:
> -------------------------------------------------------
> [Wed Sep 03 12:57:47 2014].724000 CGI Request 1 on process 5764 [Wed Sep
> 03 12:57:47 2014].740000 msDrawMap(): rendering using outputformat named
> png (AGG/PNG).
> [Wed Sep 03 12:57:47 2014].740000 msOracleSpatialLayerOpen called with:
> ora_geometry from NE_10M_POPULATED_PLACES using unique ogr_fid srid
> 4326 (Layer pointer 02E88CB8) [Wed Sep 03 12:57:48 2014].490000
> msOracleSpatialLayerOpen. Shared connection not available. Creating one.
> [Wed Sep 03 12:57:48 2014].490000
> msConnPoolRegister(NE_10M_POPULATED_PLACES,user/pass at orcl,02EB1D08)
> [Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerFreeItemInfo was
> called.
> [Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerInitItemInfo was
> called.
> [Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes was
> called.
> [Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes. Using
> this Sql to retrieve the data: SELECT name, ogr_fid,rownum, ora_geometry
> FROM NE_10M_POPULATED_PLACES WHERE SDO_FILTER( ora_geometry,
> MDSYS.SDO_GEOMETRY(2003, :srid,
> NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates
> ),'querytype=window') = 'TRUE'
> [Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes. Bind
> values: srid:4326 minx:-179.765625 miny:-89.765625 maxx:179.765625
> maxy:89.765625
> [Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes getting
> ordinate definition.
> [Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes
> converting to OCIColl.
> [Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes bind by
> name and object.
> [Wed Sep 03 12:57:48 2014].505000 msOracleSpatialLayerWhichShapes name
> and object now bound.
> [Wed Sep 03 12:57:48 2014].896000 msOracleSpatialLayerFreeItemInfo was
> called.
> [Wed Sep 03 12:57:48 2014].896000 msOracleSpatialLayerClose was called.
> Layer: 02E88CB8, Layer name: NE_10M_POPULATED_PLACES. Layer
> connection:
> user/pass at orcl
> [Wed Sep 03 12:57:48 2014].896000 msOracleSpatialLayerClose. Cleaning
> layerinfo handlers.
> [Wed Sep 03 12:57:48 2014].896000 msOracleSpatialLayerClose. Release the
> Oracle Pool.
> [Wed Sep 03 12:57:48 2014].896000
> msConnPoolRelease(NE_10M_POPULATED_PLACES,user/pass at orcl,02EB1D08)
> [Wed Sep 03 12:57:48 2014].896000 msDrawLabelCache():
> labelcache_map_edge_buffer = 10
> [Wed Sep 03 12:57:49 2014].130000 msOracleSpatialLayerClose was called.
> Layer: 02E88CB8, Layer name: NE_10M_POPULATED_PLACES. Layer
> connection:
> user/pass at orcl
> -------------------------------------------------------
>
> · Image got:
>
> <http://osgeo-
> org.1560.x6.nabble.com/file/n5159854/NE_10M_POPULATED_PLACES.png>
>
> As you can see, the result is not correct.
>
>
>
> --
> View this message in context: http://osgeo-org.1560.x6.nabble.com/Oracle-
> layer-partially-drawn-tp5159828p5159854.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