New Features in Google Geo
Fusion Tables, Places API and
The Future of Mobile Mapping

Mano Marks, Senior Developer Advocate, Google

Berlin GTUG
May 29th, 2011

@ManoMarks

Introduction

Agenda

Google Fusion Tables
Google Places API
More Resources

Google Fusion Tables

In the Beginning there was code

Responses

Engineer: Cool!

build
build
build

Non-Engineer: Uh, can't I just do it in Excel?

The Promises

Fusion Tables

Mapping without code

Better mapping with code

Mapping without code

sample table

Features

Generates clickable raster
100MB upload, 250MB per Google Account
100K rows in a layer
Easy user interface

Better mapping with code

Integration with Maps API
Direct access through easy Fusion Tables API
Spatial queries

Radius
Bounding Box
Nearest Neighbor

New Styling launched at I/O

Fusion Tables dynamic querying

Source: http://project.wnyc.org/

Style in Code - new!

...      var australia = new google.maps.LatLng(-25, 133);
      map = ...
      layer = new google.maps.FusionTablesLayer({
        query: {
          select: 'geometry',
          from: '815230'
        },
        styles: [{
          polygonOptions: {
            fillColor: "#00FF00",
            fillOpacity: 0.3
          }
        }, {
          where: "birds > 300",
          polygonOptions: {
            fillColor: "#0000FF"
          }
        }, {
          where: "population > 5",
          ...});
      layer.setMap(map);

Google Fusion Tables - SQL API

table

SELECT name FROM 790805 LIMIT 5;

name,address
FIRST CUP,"2911 VAN NESS AVE , 94109"
UNION STREET COFFEE ROASTERY,"2191 UNION ST , 94123"
NAPOLI PIZZA RESTAURANT,"1045 POLK ST , 94109"
WAYO,"1407 VAN NESS AVE , 94109"
MIFUNE RESTAURANT,"1737 POST ST , 94115"

demo

Google Fusion Tables - Nearest Neighbor

 SELECT * FROM 790805
 ORDER BY ST_Distance(
   address, LatLng(37.7832, -122.4035))
 LIMIT 5;

demo

Google Fusion Tables - Nearest Neighbor

Google Fusion Tables - Intersections

Google Places API

Search and Autocomplete

Autocomplete

Places API

Place search
Autocomplete
Place detail retrieval
Checkin management
Add Places
Delete Places

Places API methods of access

Maps API directly
Direct web service

Checkin

Webservice only
Improves search - only for your app!
Anonymous - only tracks number of checkins

Checkin Code

POST https://maps.googleapis.com/maps/api/place/check-in/json?sensor=true_or_false&key=api_key HTTP/1.1
Host: maps.googleapis.com

{
  "reference": "place_reference"
}

POST https://maps.googleapis.com/maps/api/place/check-in/json?sensor=true&key=AIzaSyAiFpFd85eMtfbvmVNEYuNds5TEF9FjIPI HTTP/1.1
Host: maps.googleapis.com

{
  "reference": "CmRRAAAATpOheNdDJDp5cdz1EGLqiGWhdrUnsyvn5plkWb6IbydAdnExNaDAdXBxRjhaFINDJU1UvLkVU5ZTFmUDsIDRrUCm-9Q7XLu6vi-bspAju4GG2XzRhv9ZBy9yJbK2PJVOEhD3QlprissY-rI0w3Ego93jGhSy7x8zDUYSrovufH1OxUGkcbjHBg"
}

Add/Delete Places

Immediately available to your app
May be moderated into Google Places datastore

Add Place Code

POST https://maps.googleapis.com/maps/api/place/add/json?sensor=true_or_false&key=api_key HTTP/1.1
Host: maps.googleapis.com

{
  "location": {
    "lat": -33.8669710,
    "lng": 151.1958750
  },
  "accuracy": 50,
  "name": "Google Shoes!",
  "types": ["shoe_store"],
  "language": "en-AU"
}