X

Shay Shmeltzer's Oracle Development Tools Tips

Working with the ADF DVT Map Component

Shay Shmeltzer
Director of Product Management - Oracle

The map component provided by the ADF Faces DVT set of components is one that we are always ending up using in key demos - simply because it is so nice looking, but also because it is quite simple to use.

So in case you need to show some geographical data, or if you just want to impress your manager, here is a little video that shows you how to create two types of maps.

The first one is a color themed map - where you show different states with different colors based on the value of some data point there. The other is a point theme - basically showing specific locations on the map. For both cases I'm using the Oracle provided mapviewer instance at http://elocation.oracle.com/mapviewer.

You can find more information about using the map component in the Web User Interface Developer's Guide here and in the tag doc and components demo.

For the first map the query I'm using (on the HR demo schema in the Oracle DB) is:

SELECT
    COUNT(EMPLOYEES.EMPLOYEE_ID) , Department_name , STATE_PROVINCE
FROM
    EMPLOYEES,     DEPARTMENTS,     LOCATIONS
WHERE employees.department_id=departments.department_id
and Departments.location_id=locations.location_id
GROUP BY Department_name,    LOCATIONS.STATE_PROVINCE


Join the discussion

Comments ( 33 )
  • Guest Thursday, December 15, 2011

    Hi Shay,

    Thanks for the quick demo on the DVT Map. Is it possible to show the Satellite view on the map component instead of Map View? - Just like Google map, trying to enable the options like "Map View", "Satellite View" in the DVT Map component, but could not find a base map name for the Satellite option.

    Thanks,

    Jeba.


  • Shay Thursday, December 15, 2011

    Jeba,

    I believe that the mapviewer guys added support for layering Google maps see:

    http://oraclemaps.blogspot.com/2009/10/google-maps-tiles-in-mapviewer-app.html

    http://docs.oracle.com/cd/E14571_01/web.1111/e10145/vis_omaps.htm#BACDBCBI

    So you should be asking this on their discussion forum.


  • Daniel Friday, May 4, 2012

    Hi Shay,

    is it possible to develop new charts for ADF DVT?

    Cheers,

    Daniel


  • Shay Friday, May 4, 2012

    Daniel - can you elaborate on what specifically you are looking for?

    Are you looking to build a new type of chart that DVT doesn't provide right now? Which one?


  • Daniel Friday, May 4, 2012

    Basically, charts in OBIEE (therefore DVT) are just fine but what if I need to produce the following chart: http://bit.ly/L9TdOh ?

    Since we need to produce industry-specific dashboards... it would be great to be able to use some new charts...


  • Shay Friday, May 4, 2012

    Hi Daniel - I don't think we have a mechanism in place to allow you doing this. I guess you'll need to use some other software solution to generate the image of the graph and then bring it into your ADF Faces application using an af:image component.


  • guest Thursday, August 2, 2012

    Hi Shay,

    Thanks for the post.

    Can we use the "http://elocation.oracle.com/mapviewer" fro production?

    we have a requirement to show the information as a pins on the map and user can select a pin and see the information of that pin, as you have shown in the second example.

    My another question is, will this behave same in mobile browser? Can we get the zoom in/out and selecting a particular point on map and displaying a tabular info on mobile browsers?

    Thanks,

    Ravi


  • Shay Thursday, August 2, 2012

    Ravi, you shouldn't be using the elocation server for your production system. For production you'll want to have a local installation of MapViewer on your WebLogic server - get it here:

    http://www.oracle.com/technetwork/middleware/mapviewer/overview/index-090261.html

    As far as running on mobile devices - The map component is certified on iOS browser see for example:

    http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/ADFFacesTouch/ADFFacesTouch.html

    Official Android support is planned for a future patch/version


  • guest Sunday, September 30, 2012

    How to add new thematic map or floor plan to use in adf dvt:map ?


  • shay Friday, October 5, 2012

    guest - a quick google will bring you to our tutorial on adding Thematic Map:

    http://docs.oracle.com/cd/E18941_01/tutorials/jdtut_11r2_58/jdtut_11r2_58_4.html


  • guest Friday, October 5, 2012

    Sorry, but my question is not how to use the component, but how to add new "custom" thematic map or my own map or my own floor plan. I need to use another country map or another floor design.

    thanks in advance.


  • Shay Friday, October 5, 2012

    guest, we haven't exposed the ability to add your own image for a map to the public yet - this is planned for an upcoming patch.


  • Renan Sunday, October 28, 2012

    Hello Shay!

    Thanks for the tutorial, it was very useful!!!

    I'm having a problem that some of the map toolbar buttons are not working... You can check on the Oracle Rich Client demo here:

    http://jdevadf.oracle.com/adf-richclient-demo/faces/index.jspx#%2Fcomponents%2Fmap.jspx

    At least here the following buttons are not working (you click and the cursor doesn't change):

    - Area

    - Distance

    - Point Selection

    And all the specific forms selector in toolbar...

    Do you know how to solve this? Or I'm doing something wrong?

    Thanks in advance,

    Renan.


  • shay Wednesday, October 31, 2012

    Renan - seems to be a bug introduced in 11.1.2.3 - I reported it and it should be fixed in the next version. If this is a show stopper for you, please work with Oracle support to escalate and get a patch.


  • Shaheer badar Thursday, February 28, 2013

    Hello Shay!

    This is very nice post. I want to know, how to get the information of Latitude and Longitude using oracle elocation. I want to store Latitude and Longitude information of difference cities in database.

    Regards,

    Shaheer Badar


  • Shay Thursday, February 28, 2013

    The Oracle MapViewer can also provide you with geolocation information in the URL - http://elocation.oracle.com/geocoder/gcserver

    You can ask further question on the MapViewer server forum - https://forums.oracle.com/forums/forum.jspa?forumID=727


  • guest Thursday, June 6, 2013

    Shay, when I tried this exercise using the 11.1.1.7, I am just getting the map and not the color. I got this error in jdev console. DVT-26005: theme "mapColorTheme1" cannot be displayed: row 10 with id=dvt_geomap10 does not have a location value

    What does this mean?


  • guest Tuesday, December 3, 2013

    I drag and arop the employeeview1 into panelbox.I want to display the map image(google map).I want to create geographic map it showing the error as

    "Failed to retrieve data from MapView server,Please check your map URLs "


  • Shay Tuesday, December 3, 2013

    guest - you should check the URL you provided for your mapserver and your proxy settings in JDeveloper.


  • Hemant Saturday, December 7, 2013

    Shay,

    I tried to replicate the same in Jdev 11.1.1.7 and getting following error

    java.lang.NullPointerException

    at oracle.adfinternal.view.faces.bi.renderkit.geoMap.GeoMapRenderer.encodeColorStyle(GeoMapRenderer.java:2743)

    The page just shows the map without any data imposed on it.

    Tried with BAR GRAPH themes with different schema but getting same error.

    Thanks.


  • yasser Monday, October 20, 2014

    I like Oracle Mapviewer work ADF by Jdeveloper but I wont to add action on Map using Jdeveloper and save (X,Y) on Database can you help me


  • emanuele Wednesday, February 3, 2016

    Hi, the dvt map has the functionality to use directions (routing)?


  • guest Monday, February 22, 2016

    hello hi ,

    does the map works if only the country field is specified?


  • Shay Shmeltzer Monday, February 22, 2016

    guest - if you just want to show data based on country I would suggest you look at the thematic map component - http://jdevadf.oracle.com/adf-richclient-demo/faces/feature/thematicMap/index.jspx


  • guest Friday, September 16, 2016

    Hi Shay,

    Can we export hierarchyViewer component to PDF?

    Asking because hierarchyViewer is rendered as flash content in UI at runtime.

    Thanks.


  • Shay Shmeltzer Saturday, September 17, 2016

    guest - the hierarchy viewer can render in HTML instead of Flash and then be printed details in the doc:

    https://docs.oracle.com/middleware/1212/adf/ADFUI/dv_hviewer.htm#ADFUI9951


  • Rasto Tuesday, December 6, 2016

    Shay,

    Should it possible to display multiple map components on a single page, bound to the same model.

    Instead of showing a single map with a collection of map points we would like to iterate through address records and show each separately, with its own little map view.

    We tried this but couldn't make it work.

    Thank you,

    Rasto


  • Anu Thursday, March 2, 2017

    Hi Shay,

    This is very very nice post.but my requirement is slightly different when user selects any region then all location should show in diagram as per selected region.

    Ex. suppose user select Mumbai as a region then all location like Andheri, Bandra, Kurala, Boriwali,…et

    All show in a diagram.. Please help me how can achieve this.

    Regards,

    Anu


  • Shay Shmeltzer Thursday, March 2, 2017

    Anu - for region highlighting have a look at the thematic map component:

    http://jdevadf.oracle.com/adf-richclient-demo/faces/feature/thematicMap/index.jspx


  • khadidja Sunday, June 4, 2017
    thanks a lot . it is very useful , but i have problem in the theme . whene i tried to do the same as you (with my map) ,so i chose a theme ,but the map at runtime didn't change .

    my question is how to chose a theme , and did you create this theme just for rendering the map with bar!

    please help me ,
    best reguard
    khadida
  • Shay Monday, June 5, 2017
    khadida - I'm not sure which theme you chose - you should post your question with more details about the specific values you set and the errors you got on the ADF forum at: https://community.oracle.com/community/java/java_development_tools/application_development_in_java/jdeveloper_and_adf/content?customTheme=otn
  • Dali Monday, December 4, 2017
    What about Route or Direction ? how can i create a Route?
  • shay Monday, December 4, 2017
    Dali - the map component doesn't support rendering routes on it out of the box.
    You might need to opt out for embedding a different map component such as google maps instead.
    https://pinboard.in/search/u:OracleADF?query=google_maps
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.