I'm new in the group and no have much experience in Spatial area.
I'm looking for information about the posibility of use google places apis to get point of interest from Oracle Spatial / MapBuilder / MapViewer in order to use point of interest from google with own spatial information.
Any comment is welcome.
Can you provide more details on your use case?
MapViewer is usually used to query and display spatial information from an Oracle database (i.e. spatial information manged using Oracle Spatial and Graph or Oracle Locator). So if your spatial information is in an Oracle database and in tables/columns using the SDO_GEOMETRY type then use MapViewer to query and display it.
Google Places API gives access to google's database of POI and other info (like events).
The Oracle Maps tutorial (part of the mvdemo sample application in the Quickstart Kit on OTN here ) is a great starting point.
var mpoint = MVSdoGeometry.createPoint(mapCenterLon,mapCenterLat,8307);
mapview = new MVMapView(document.getElementById("map"), baseURL);
var themebasedfoi = new MVThemeBasedFOI('themebasedfoi1','mvdemo.customers');
My researching is about the following scenario:
OBIEE as BI Application
Mapviewer as aplication to show the maps
Google Maps as background map
Administrative boundaries & customers points in Oracle Database via SDO_GEOMETRY
Google Places as PoI provider
1) My customer want is creatng analysis using customers localization (Latitude, Longitute - in a SDO_GEOMETRY point ) that are in a distance below to 500 mts of any point of Interest for instance.
2) Same as above but using administrative boundaries.
3) Paint in a map point of Sales and Point of interest and select in a map some PoS to create a cluster as is showed in ([Sample Data Set for MapViewer Quickstart HTML5 Demos|http://www.oracle.com/technetwork/middleware/mapviewer/downloads/index.html])
Currently my customer is using this functionallity using just google maps (case 1). The problem is this solution is becoming ungoverned because they have a lot of users and implies many customization.
The wish of using google places is because google keep "up-to-date" the information and avoid us the manteince of this kind of information.
1) I don't know if it is possible
2) If yes, do you have any example to this?
3) If no, There is some solution like this in Oracle Spatial - MapViewer roadmap
4) In other case, I think one solution is incorporate the point of interest into oracle tables, there is any other?
Many many thanks and regards
PS: Jayant I will send you an invitation via linkedin to keep in contact
See examples in the OBIEE SampleApp. Specifically the Business in distance range in 8.11 Oracle Spatial dashboard.
You'd use a variant of that in your case. I'd suggest contact Albert Godfrind for help if you know him or some Oracle BI pre-sales folks.
Doing this mapviewer is simple. Get the POIs from google places display on a map as MV FOI. User clicks on a POI get that foi's geometry pass it to your theme as a bind variable. The theme itself is defined as a spatial query (using sdo_within_distance) with a bind variable. Something like
SQL> select styling_rules from user_sdo_themes where name = 'CUSTOMER_NEARBY';
<?xml version="1.0" standalone="yes"?>
<field column="NAME" name="Name"/>
<field column="ACCOUNT_MGR" name="Account Mgr"/>
<field column="SALES" name="Sales"/>
<features asis="true" style="M.ALL_CITY_L1_8X8"> (sdo_within_distance(location,:1,'distance=500 unit=meter')='TRUE') </features>
<label column="ACCOUNT_MGR" style="T.BLUE_SERIF_10"> 1 </label>
You'd use foi.getGeometry() to get the location clicked on and then pass that it to the theme as a query parameter
var themebasedfoi2 = new MVThemeBasedFOI('themebasedfoi2','mvdemo.customers_nearby');