Google Maps extension

With the Google Maps extension, you can create Google Maps mashups easily. You can generate a report object with a Google Map with markers placed on the map. The marker's speech bubble can contain your own data. Placement of the pins can be done by using location data (latitude & longitude) or simply pass the address on as a location.

Maps attributes: size, center and zoom value can be controlled with parameters. If no map attributes are given, the default size of the map is used. The map is centered using markers and automatic zooming is done to fit the markers into the map.

Commands

dbr.googlemaps - Display Google Maps mashup
dbr.googlemaps.heatmap - Use Google Maps Heatmap layer
dbr.googlemaps.link_in_title - Whether to show single linked report in the title or in the marker
dbr.googlemaps.polyline - Draw a polyline between the points
dbr.googlemaps.route - Draw route between the points
dbr.googlemaps.kml - Include KML-file into the maps
dbr.googlemaps.geojson - Include GeoJSON-file into the maps

Syntax

select 'dbr.googlemaps', 'coordinates' | 'address' {,title, width, height, lat, lng, zoom, map_type}
select 'dbr.googlemaps.heatmap', 1[, 'HeatmapLayerOptions']
select 'dbr.googlemaps.link_in_title', true
select 'dbr.googlemaps.polyline', color, width
select 'dbr.googlemaps.route', 'driving' | 'walking' | 'bicycling' | 'transit'
select 'dbr.googlemaps.kml', url_to_kml_file
select 'dbr.googlemaps.geojson', url_to_geojson_file

Using address bubble:
select address, bubble_html {, marker {, shadow} }

Using latitude/longitude bubble:
select latitude, longitude, bubble_html {, marker {, shadow{, marker_label } } }

Using latitude/longitude-based heatmap (faster):
select latitude, longitude [, PointWeight] }

Using address-based heatmap (slower):
select address [, PointWeight] }

Where:

lat, lng
latitude and longitude of the map center, use 0 to autocenter
map_type
'roadmap', 'satellite', 'terrain' or 'hybrid'
marker/shadow
The optional 'marker' and 'shadow' are a URL to pictures to be shown on the map. myDBR comes preinstalled with some of the common markers, but you can also use your own pictures as markers. If you are using your own pictures the format is 'URL::x::y[::center]' where the x and y represent the size of the picture in pixels and optional center parameter centers the marker.
HeatmapLayerOptions
Optional Google Maps HeatmapLayerOptions as JavaScript object literals like "dissipating:false,radius:2"
PointWeight
The PointWeight object allows you to additionally specify a weight for that data point. Applying a weight to a data point will cause the PointWeight to be rendered with greater intensity.

Google Maps API key

myDBR Google Maps extension uses Google Maps API V3 and when addresses are used it uses server-side geocoding. If you have a Google Maps API key, you can use it in user/defaults.php by adding the following line into it:

$mydbr_defaults['google_maps_api_key']='YOUR_API_KEY';

Maps API for Business

The Maps API for Business agreement with Google gives you a better geocoding service with myDBR. To define your Maps API for Business ID's add following line into user/defaults.php:

$mydbr_defaults['chart']['google_maps_business'] = array('client_id' => 'clientID', 'private_key' => 'vNIXE0xscrmjlyV-12Nj_BvUPaw=');

Where client_id is your client ID and private_key is your Private Key from your Maps API for Business account.

Usage

/* Mashup based on address */
select 'dbr.googlemaps', 'address';

select address, bubble_html
from mydb.data;

/* Mashup based on coordinates */
select 'dbr.googlemaps', 'coordinates';

select latitude, longitude, bubble_html
from mydb.data;

Explanation

The command allows you to generate a Google Maps mashup (map, markers on the map and the bubble). The command has two variations of input, one with coordinated (latitude and longitude) and one with the address based placing the marker.

Example - 'dbr.googlemaps' coordinates

Report place markers on a map based on their latitude and longitude.

/* We'll zoom the map to Paris */
select 'dbr.googlemaps', 'coordinates', 'French sightseeing', 400, 400;

select 48.858863, 2.294362, 'la Tour Eiffel'
union
select 48.861397, 2.335432, 'Musee du Louvre';

Example - 'dbr.googlemaps' address

Report place markers on a map based on their address. Using address is quite flexible in Google Maps so we can just place the names we're looking for. This will produce the same result as the example above. The first column is used as the search criteria and the second one is used in the bubbles.

/* Center to US */
select 'dbr.googlemaps', 'address', 'Capitals of US States', 1200, 800;

select concat(state, ',', capital), capital
from mydb.us_states;

Using preinstalled markers

myDBR comes with a set of preinstalled markers.

Here is the list of preinstalled markers and the URL to be used. With preinstalled markers, myDBR automatically knows the size of the maker and applies the appropriate shadow to it.

Plain URL Dot URL Pushpin URL
blue blue-dot blue-pushpin
green green-dot grn-pushpin
pink pink-dot pink-pushpin
purple purple-dot purple-pushpin
red red-dot red-pushpin
yellow yellow-dot ylw-pushpin
orange orange-dot    

Example usage of preinstalled markers

select 'dbr.googlemaps', 'address', 'French sightseeing', 400, 400;

select 'la Tour Eiffel', 'la Tour Eiffel', 'green'
union
select 'Musee du Louvre', 'Musee du Louvre', 'red-pushpin';

Using own markers

You can also use your own markers (any picture) with myDBR. To do this you need to provide the URL and the size of the picture (using '::' notation at the end of URL).

Example usage of own markers

select 'dbr.googlemaps', 'address', 'French sightseeing', 400, 400;

select 'la Tour Eiffel', 'la Tour Eiffel', 'http://maps.google.com/mapfiles/ms/micons/cabs.png::32::32'
union
select 'Musee du Louvre', 'Musee du Louvre', '/myimages/monalisa.jpg::58::51';

Using Heatmaps

Heatmap support uses Google Maps Heatmap Layer.

Showing two heatmaps, one without options one with options

select 'dbr.googlemaps', 'coordinates';
select 'dbr.googlemaps.heatmap', 1;

select latitude, longitude
from mydata;

select 'dbr.googlemaps', 'coordinates';
select 'dbr.googlemaps.heatmap', 1, 'dissipating:false';

select latitude, longitude, weight
from mydata;

Using custom SVG marker

You can use custom SVG markers in Google Maps by adding an SVG chart as a marker parameter.

SVG marker

Define the SVG image you wish to use as a marker:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<svg xmlns="http://www.w3.org/2000/svg" width="100" height="100">
<circle cx="50" cy="50" r="49" fill="red" fill-opacity="0.2" stroke="gray" stroke-width="1"/>
</svg>
select 'dbr.parameters.show';
select 'dbr.googlemaps', 'coordinates', 'Biggest cities in US', 700, 500;

select latitude, longitude, name, f_map_city_size(''user/images/circle.svg', population), '','', population
from us_cities
order by population desc;

where the f_map_city_size-function returns the size (in pixels) of the SVG image relative to population. For example: "user/images/circle.svg::160::160::center".

Routes

The route option allows for route planning

select 'dbr.googlemaps', 'address', '', 500, 600;
select 'dbr.googlemaps.route', 'walking';

select 'Parc Monceau, Paris'
union
select 'Arc de Triomphe'
union
select 'Eiffel tower';

Include a KML-file and GeoJSON file and extend map functionality

You can also include a KML and GeoJSON files to the map and access the Google Maps API in your report to further extend the map functionality

The Google_map.get_map_object-function can be used to get the Google Maps object. The function takes a resultclass as a parameter.

Show Chicago Transit Map

select 'dbr.resultclass', 'sample_map';
select 'dbr.googlemaps', 'coordinates', '', 700, 850, 0, 0, 9;
select 'dbr.googlemaps.kml', 'http://googlemaps.github.io/js-v2-samples/ggeoxml/cta.kml';
select 'dbr.googlemaps.geojson', 'user/chicago.geojson';

select 'Chicago';

select 'dbr.javascript', "Google_map.get_map_object('sample_map').data.setStyle({fillColor: '#94F2AC',strokeColor:'#888' ,strokeWeight: 1});";

Geocode caching

myDBR will cache the geocode results (address to latitude/longitude conversion) into mydbr_geocode-table. One can disable the feature with $mydbr_defaults['geocode']['cache']-option.