6 Replies Latest reply: Jun 19, 2012 2:19 PM by 920209 RSS

    SRID role in scalebar rendering

    857965
      Hello! Friends,
      Plz help me to render my geometries.
      [1] My geometries got little bit difference in shapes on GIS Map tool & MapViewer tool.
      [2] Is it necessary to use SRID in themes/basemap, I am using SRID:8307 (WGS84 coord system)
      [3] How MapViewer find scale range automatically ? , since I have to use JavaBean based API, how to control the scale of themes?


      Regards,
      Gajendra
        • 1. Re: SRID role in scalebar rendering
          857965
          plz help.
          • 2. Re: SRID role in scalebar rendering
            554130
            Hi,
            [1] do you have samples

            [2] yes

            [3] sorry, i have no experience with the java bean api, but did you read chapter 4.3.6 from the mapviewer users guide?

            regards Arnd
            • 3. Re: SRID role in scalebar rendering
              857965
              Hello! Dear Friend,

              In your opinion what would be better to developm map applin. with Java API Or other API.
              Since, My requirement is just render my geometries with scale .

              I got following log, My output just render scale bar not the required geometry.
              I don't know how to determine appropriate range of scale to display my map.


              pr 28, 2011 3:56:04 PM oracle.sdovis.SRS getOptimalQueryWindow
              FINEST: *** isGeodetic=true, unit=DECIMAL DEGREE
              Apr 28, 2011 3:56:04 PM oracle.sdovis.SRS getOptimalQueryWindow
              FINEST: before adjusting: minX = -124.60674157303372, maxX=-120.1932584269663 minY=36.8, maxY=38.8 w=4.413483146067415, h=2.0
              Apr 28, 2011 3:56:04 PM oracle.sdovis.SRS getOptimalQueryWindow
              FINEST: After adjusting: minX = -124.60674157303372, maxX=-120.1932584269663 minY=36.8, maxY=38.8 w=4.413483146067415, h=2.0
              Apr 28, 2011 3:56:04 PM oracle.sdovis.DBMapMaker isThemeToBePrepared
              INFO: Scale definition for theme THEME1 is out of range.
              11/04/28 15:56:04 Current ML/PL application: SELECT lag.mine,laav.L_A_NO L_A_NO FROM LEASE_APPL_GEOMS lag,LEASE_APPL_ANNOT_V laav WHERE lag.application_id = 434 and lag.ver = 'R0' and laav.LEASE_ID = lag.APPLICATION_ID and laav.TYPE = 'A'
              11/04/28 15:56:04 jdbc flag >>0
              11/04/28 15:56:04 mv.getEnabledThemes >> [Ljava.lang.String;@66b1f4
              Apr 28, 2011 3:56:05 PM oracle.sdovis.DBMapMaker renderEm
              INFO: **** time spent on loading features: 1047ms.
              Apr 28, 2011 3:56:05 PM oracle.sdovis.RenderingEngine prepareForRendering
              FINEST: xfm: 222.49999999999974 0.0 0.0 -222.49999999999974 27724.99999999997 8632.999999999989
              Apr 28, 2011 3:56:05 PM oracle.sdovis.VectorRenderer render
              FINER: time to render theme THEME1 with 0 styled features: 0ms


              Thanks!
              • 4. Re: SRID role in scalebar rendering
                554130
                FINER: time to render theme THEME1 with 0 styled features: 0ms

                Your request contains no features!!

                Can you see features using mapbuilder tool?

                Regards Arnd.
                • 5. Re: SRID role in scalebar rendering
                  857965
                  Hello! Arnd,
                  Still get only scale bar, without map.
                  is it must to add styles to jdbc themes?that's the reason for not showing map.
                  & what the base of generated scale ? e.g showing me scale of .485686...

                  Following is complete log :

                  Apr 29, 2011 12:48:22 PM oracle.lbs.mapserver.oms getXMLDocument
                  FINEST: request= <?xml version="1.0" standalone="yes"?>
                  <map_request
                  title=" "
                  datasource="mvdemo"
                  srid="8307"
                  width="982"
                  height="445"
                  bgcolor="#ffffff"
                  antialiase="true"
                  format="PNG_URL"
                  >
                  <center size="2.0">
                  <geoFeature>
                  <geometricProperty typeName="center">
                  <Point srsName="SDO:8307">
                  <coordinates>-122.4,37.8</coordinates>
                  </Point>
                  </geometricProperty>
                  </geoFeature>
                  </center>
                  <scale_bar
                  position="SOUTH_WEST"
                  mode="METRIC_MODE"
                  label_color="#000000"
                  label_halo_size="2.5"
                  />
                  <themes>
                  <theme name="theme1">
                  <jdbc_query
                  spatial_column="MINE"
                  render_style="C.NEW_COLOR_STYLE"
                  jdbc_srid="8307"
                  datasource="mvdemo"
                  asis="true">SELECT lag.mine,laav.L_A_NO L_A_NO FROM LEASE_APPL_GEOMS lag,LEASE_APPL_ANNOT_V laav WHERE lag.application_id = 434 and lag.ver = 'R0' and laav.LEASE_ID = lag.APPLICATION_ID and laav.TYPE = 'A'
                  </jdbc_query>
                  </theme>
                  </themes>
                  </map_request>
                  Apr 29, 2011 12:48:22 PM oracle.lbs.mapserver.oms doPost
                  FINER: [oms] received request: <?xml version="1.0" standalone="yes"?>
                  <map_request
                  title=" "
                  datasource="mv ...
                  Apr 29, 2011 12:48:22 PM oracle.lbs.mapserver.core.MapperPool getMapper
                  FINER: getMapper(mvdemo) begins...
                  Apr 29, 2011 12:48:22 PM oracle.lbs.mapserver.core.MapperPool getMapper
                  FINER: getMapper() succeeded.
                  Apr 29, 2011 12:48:22 PM oracle.lbs.mapserver.core.RealWorker addJDBCTheme
                  FINEST: adding a JDBC Theme:
                  ThemeDescriptor=
                  name=theme1
                  type=2
                  minScale=Infinity
                  maxScale=-Infinity
                  srid=8307
                  transparency=1.0
                  host=null
                  sid=null
                  port=null
                  user=null
                  mode=null
                  query=SELECT lag.mine,laav.L_A_NO L_A_NO FROM LEASE_APPL_GEOMS lag,LEASE_APPL_ANNOT_V laav WHERE lag.application_id = 434 and lag.ver = 'R0' and laav.LEASE_ID = lag.APPLICATION_ID and laav.TYPE = 'A'
                  spatialColumn=MINE
                  renderStyleName=C.NEW_COLOR_STYLE
                  labelColumn=
                  labelStyleName=
                  renderStyleDef=null
                  labelStyleDef=null
                  localThem=null
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.SRS getOptimalQueryWindow
                  FINEST: *** isGeodetic=true, unit=DECIMAL DEGREE
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.SRS getOptimalQueryWindow
                  FINEST: before adjusting: minX = -124.60674157303372, maxX=-120.1932584269663 minY=36.8, maxY=38.8 w=4.413483146067415, h=2.0
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.SRS getOptimalQueryWindow
                  FINEST: After adjusting: minX = -124.60674157303372, maxX=-120.1932584269663 minY=36.8, maxY=38.8 w=4.413483146067415, h=2.0
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.LoadThemeData run
                  FINER: LoadThemeData running thread: Thread-257
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.theme.DynGeomThemeProducer rewriteQuery
                  FINER: [Master scale] 0.4314606741573033 [Theme scale factor] 1.0
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.theme.DynGeomThemeProducer rewriteQuery
                  FINEST: jtvpxfmfxed: xl=-125.0
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.theme.DynGeomThemeProducer rewriteQuery
                  FINEST: [ THEME1 ]: -125.0,36.8,-120.1932584269663,38.8
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.theme.DynGeomThemeProducer prepareData
                  FINEST: [DynGeomTheme] rewritten query: SELECT lag.mine,laav.L_A_NO L_A_NO FROM LEASE_APPL_GEOMS lag,LEASE_APPL_ANNOT_V laav WHERE lag.application_id = 434 and lag.ver = 'R0' and laav.LEASE_ID = lag.APPLICATION_ID and laav.TYPE = 'A'
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.theme.DynGeomThemeProducer prepareData
                  FINER: Fetch size: 100
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.theme.DynGeomThemeProducer prepareData
                  FINER: Retrieving geometries...
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.theme.DynGeomThemeProducer prepareData
                  FINER: Read all geometries.
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.theme.DynGeomThemeProducer prepareData
                  INFO: [THEME1] sql exec time: 140ms, total time loading 0 feature:156ms
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.DBMapMaker renderEm
                  INFO: **** time spent on loading features: 156ms.
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.RenderingEngine prepareForRendering
                  FINEST: xfm: 222.49999999999974 0.0 0.0 -222.49999999999974 27724.99999999997 8632.999999999989
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.VectorRenderer render
                  FINER: time to render theme THEME1 with 0 styled features: 0ms
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.VectorRenderer label
                  FINER: time to label theme THEME1 with 0 styled features: 0ms
                  Apr 29, 2011 12:48:22 PM oracle.sdovis.DBMapMaker renderEm
                  INFO: **** time spent on rendering: 63ms
                  Apr 29, 2011 12:48:22 PM oracle.lbs.mapserver.core.MapperPool freeMapper
                  FINER: freeMapper() begins...
                  Apr 29, 2011 12:48:22 PM oracle.lbs.mapserver.core.RealWorker generateMapImage
                  FINER: [RealWorker] preparation time: 16ms
                  Apr 29, 2011 12:48:22 PM oracle.lbs.mapserver.core.RealWorker generateMapImage
                  FINER: [RealWorker] querying/rendering time: 219ms
                  Apr 29, 2011 12:48:22 PM oracle.lbs.mapserver.core.RealWorker generateMapImage
                  FINER: [RealWorker] packing time: 62ms
                  Apr 29, 2011 12:48:22 PM oracle.lbs.mapserver.core.RealWorker generateMapImage
                  FINER: [RealWorker] --------------- total time: 297ms


                  Thanks a lot for treat me.
                  • 6. Re: SRID role in scalebar rendering
                    920209
                    can someone help me please...its the same relatd error...:(


                    Jun 20, 2012 12:39:44 AM oracle.lbs.mapserver.oms doPost
                    FINER: [oms] received request: <?xml version="1.0" standalone="yes" ?><info_request datasource="rema" format="s ...
                    Jun 20, 2012 12:39:44 AM oracle.lbs.mapserver.core.InfoWorker processDirectInfoRequest
                    FINEST: Processing <info_request> :
                    select name from user_sdo_styles

                    Jun 20, 2012 12:39:53 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: J2EE user: null
                    Jun 20, 2012 12:39:53 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-User-Dn: null
                    Jun 20, 2012 12:39:53 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-User-Guid: null
                    Jun 20, 2012 12:39:53 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-Subscriber: null
                    Jun 20, 2012 12:39:53 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-Subscriber-Dn: null
                    Jun 20, 2012 12:39:53 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-Subscriber-Guid: null
                    Jun 20, 2012 12:39:53 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Lang/Territory: null
                    Jun 20, 2012 12:39:53 AM oracle.lbs.mapserver.oms getXMLDocument
                    FINEST: request= <?xml version="1.0" standalone="yes" ?><info_request datasource="rema" format="strict" >
                    select * from BOUNDARY where rownum &lt; 2
                    </info_request>

                    Jun 20, 2012 12:39:53 AM oracle.lbs.mapserver.oms doPost
                    FINER: [oms] received request: <?xml version="1.0" standalone="yes" ?><info_request datasource="rema" format="s ...
                    Jun 20, 2012 12:39:53 AM oracle.lbs.mapserver.core.InfoWorker processDirectInfoRequest
                    FINEST: Processing <info_request> :
                    select * from BOUNDARY where rownum < 2

                    Jun 20, 2012 12:40:19 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: J2EE user: null
                    Jun 20, 2012 12:40:19 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-User-Dn: null
                    Jun 20, 2012 12:40:19 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-User-Guid: null
                    Jun 20, 2012 12:40:19 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-Subscriber: null
                    Jun 20, 2012 12:40:19 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-Subscriber-Dn: null
                    Jun 20, 2012 12:40:19 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-Subscriber-Guid: null
                    Jun 20, 2012 12:40:19 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Lang/Territory: null
                    Jun 20, 2012 12:40:19 AM oracle.lbs.mapserver.oms getXMLDocument
                    FINEST: request= <?xml version="1.0" standalone="yes" ?><info_request datasource="rema" format="strict" >
                    select srid from user_sdo_geom_metadata where table_name = 'BOUNDARY'
                    </info_request>

                    Jun 20, 2012 12:40:19 AM oracle.lbs.mapserver.oms doPost
                    FINER: [oms] received request: <?xml version="1.0" standalone="yes" ?><info_request datasource="rema" format="s ...
                    Jun 20, 2012 12:40:19 AM oracle.lbs.mapserver.core.InfoWorker processDirectInfoRequest
                    FINEST: Processing <info_request> :
                    select srid from user_sdo_geom_metadata where table_name = 'BOUNDARY'

                    Jun 20, 2012 12:40:38 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: J2EE user: null
                    Jun 20, 2012 12:40:38 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-User-Dn: null
                    Jun 20, 2012 12:40:38 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-User-Guid: null
                    Jun 20, 2012 12:40:38 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-Subscriber: null
                    Jun 20, 2012 12:40:38 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-Subscriber-Dn: null
                    Jun 20, 2012 12:40:38 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Osso-Subscriber-Guid: null
                    Jun 20, 2012 12:40:38 AM oracle.lbs.mapserver.oms getAuthenticatedUserIds
                    FINEST: Lang/Territory: null
                    Jun 20, 2012 12:40:38 AM oracle.lbs.mapserver.oms getXMLDocument
                    FINEST: request= <?xml version="1.0" standalone="yes"?>
                    <map_request
                    datasource="rema"
                    width="415"
                    height="380"
                    bgcolor="#a6caf0"
                    antialiase="true"
                    format="JAVA_IMAGE_COMPRESSED"
                    >
                    <center size="47.37">
                    <geoFeature>
                    <geometricProperty typeName="center">
                    <Point>
                    <coordinates>-72.913456,19.13</coordinates>
                    </Point>
                    </geometricProperty>
                    </geoFeature>
                    </center>
                    <themes>
                    <theme name="boundry">
                    <jdbc_query
                    spatial_column="THE_GEOM"
                    render_style="L.MAJOR TOLL ROAD"
                    jdbc_srid="4326"
                    datasource="rema"
                    asis="false">select THE_GEOM,ID from BOUNDARY
                    </jdbc_query>
                    </theme>
                    </themes>
                    </map_request>
                    Jun 20, 2012 12:40:38 AM oracle.lbs.mapserver.oms doPost
                    FINER: [oms] received request: <?xml version="1.0" standalone="yes"?>
                    <map_request
                    datasource="rema"
                    width= ...
                    Jun 20, 2012 12:40:38 AM oracle.lbs.mapserver.core.MapperPool getMapper
                    FINER: getMapper(rema) begins...
                    Jun 20, 2012 12:40:38 AM oracle.lbs.mapserver.core.MapperPool getMapper
                    FINER: getMapper() succeeded.
                    Jun 20, 2012 12:40:38 AM oracle.lbs.mapserver.core.RealWorker addJDBCTheme
                    FINEST: adding a JDBC Theme:
                    ThemeDescriptor=
                    name=boundry
                    type=2
                    minScale=Infinity
                    maxScale=-Infinity
                    srid=4326
                    transparency=1.0
                    host=null
                    sid=null
                    port=null
                    user=null
                    mode=null
                    query=select THE_GEOM,ID from BOUNDARY
                    spatialColumn=THE_GEOM
                    renderStyleName=L.MAJOR TOLL ROAD
                    labelColumn=
                    labelStyleName=
                    renderStyleDef=null
                    labelStyleDef=null
                    localThem=null
                    Jun 20, 2012 12:40:38 AM oracle.sdovis.SRS getOptimalQueryWindow
                    FINEST: *** isGeodetic=true, unit=DECIMAL DEGREE
                    Jun 20, 2012 12:40:38 AM oracle.sdovis.SRS getOptimalQueryWindow
                    FINEST: before adjusting: minX = -98.77996915789473, maxX=-47.04694284210526 minY=-4.555, maxY=42.815 w=51.733026315789466, h=47.37
                    Jun 20, 2012 12:40:38 AM oracle.sdovis.SRS getOptimalQueryWindow
                    FINEST: After adjusting: minX = -98.77996915789473, maxX=-47.04694284210526 minY=-4.555, maxY=42.815 w=51.733026315789466, h=47.37
                    Jun 20, 2012 12:40:38 AM oracle.sdovis.LoadThemeData2 run
                    FINER: LoadThemeData2 running thread: [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'
                    Jun 20, 2012 12:40:38 AM oracle.sdovis.theme.DynGeomThemeProducer rewriteQuery
                    FINER: [Master scale] 11.967157894736841 [Theme scale factor] 1.0
                    Jun 20, 2012 12:40:38 AM oracle.sdovis.theme.DynGeomThemeProducer rewriteQuery
                    FINEST: jtvpxfmfxed: xl=-99.0
                    Jun 20, 2012 12:40:38 AM oracle.sdovis.theme.DynGeomThemeProducer rewriteQuery
                    FINEST: [ BOUNDRY ]: -99.0,-4.555,-47.04694284210526,42.815
                    Jun 20, 2012 12:40:38 AM oracle.sdovis.theme.DynGeomThemeProducer rewriteQuery
                    FINER: View ResX: 415.0 View resY: 380.0
                    Jun 20, 2012 12:40:38 AM oracle.sdovis.theme.DynGeomThemeProducer rewriteQuery
                    FINER: Database Version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
                    With the Partitioning, OLAP, Data Mining and Real Application Testing options
                    Jun 20, 2012 12:40:38 AM oracle.sdovis.theme.DynGeomThemeProducer prepareData
                    FINEST: [DynGeomTheme] rewritten query: SELECT * FROM ( select THE_GEOM,ID from BOUNDARY ) WHERE MDSYS.SDO_FILTER(THE_GEOM, MDSYS.SDO_GEOMETRY(2003, 4326, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(-99.0,-4.555,-47.04694284210526,42.815)), 'querytype=WINDOW') = 'TRUE'
                    Jun 20, 2012 12:40:39 AM oracle.sdovis.theme.DynGeomThemeProducer prepareData
                    FINER: Fetch size: 100
                    Jun 20, 2012 12:40:39 AM oracle.sdovis.theme.DynGeomThemeProducer prepareData
                    FINER: Retrieving geometries...
                    Jun 20, 2012 12:40:39 AM oracle.sdovis.theme.DynGeomThemeProducer prepareData
                    FINER: Read all geometries.
                    Jun 20, 2012 12:40:39 AM oracle.sdovis.theme.DynGeomThemeProducer prepareData
                    INFO: [BOUNDRY] sql exec time: 141ms, total time loading 0 feature:250ms
                    Jun 20, 2012 12:40:39 AM oracle.sdovis.DBMapMaker renderEm
                    INFO: **** time spent on loading features: 250ms.
                    Jun 20, 2012 12:40:39 AM oracle.sdovis.RenderingEngine prepareForRendering
                    FINEST: xfm: 8.021954823728098 0.0 0.0 -8.021954823728098 792.4084500738863 343.4599957779185
                    Jun 20, 2012 12:40:39 AM oracle.sdovis.VectorRenderer render
                    FINER: time to render theme BOUNDRY with 0 styled features: 0ms
                    Jun 20, 2012 12:40:39 AM oracle.sdovis.VectorRenderer label
                    FINER: time to label theme BOUNDRY with 0 styled features: 0ms
                    Jun 20, 2012 12:40:39 AM oracle.sdovis.DBMapMaker renderEm
                    INFO: **** time spent on rendering: 62ms
                    Jun 20, 2012 12:40:39 AM oracle.lbs.mapserver.core.MapperPool freeMapper
                    FINER: freeMapper() begins...
                    Jun 20, 2012 12:40:39 AM oracle.lbs.mapserver.core.RealWorker generateMapImage
                    FINER: [RealWorker] preparation time: 47ms
                    Jun 20, 2012 12:40:39 AM oracle.lbs.mapserver.core.RealWorker generateMapImage
                    FINER: [RealWorker] querying/rendering time: 359ms
                    Jun 20, 2012 12:40:39 AM oracle.lbs.mapserver.core.RealWorker generateMapImage
                    FINER: [RealWorker] packing time: 47ms
                    Jun 20, 2012 12:40:39 AM oracle.lbs.mapserver.core.RealWorker generateMapImage
                    FINER: [RealWorker] --------------- total time: 453ms




                    please help me m not able to rectify...
                    rema