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-boun...@lists.osgeo.org [mailto:mapserver-users- > boun...@lists.osgeo.org] Puolesta Geograma > Lähetetty: 3. syyskuuta 2014 13:57 > Vastaanottaja: mapserver-users@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@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@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@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@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@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@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@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users