Scenario: Obtaining detailed geographic information using address and geographic coordinates - 6.3

Talend Components Reference Guide

EnrichVersion
6.3
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

This scenario describes a three-component Job which send HTTP request to Google Places API and obtain detailed geographic information based on the geographic coordinates we provide.

Setting up the Job

  1. Drop the following components from the Palette onto the design workspace: tFixedFlowInput, tGoogleMapLookup and tLogRow

  2. Connect tFixedFlowInput to tGoogleMapLookup and tGoogleMapLookup to tLogRow using Main links.

Configuring the components

  1. Double-click tFixedFlowInput to display its Basic settings view to define its properties.

  2. Click Edit schema to open a dialog box that displays the data structure of input data and define the data you want to pass to tGoogleMapLookup, two columns in this scenario, lat and lng respectively to hold the geographic coordinates.

  3. Set the Type of column lat and column lng to Double. Leave rest of the settings as they are. Then, click OK to close the dialog box.

  4. Click Use Single Table in the Mode area, fill the Value field of the lat column with 37.5300125 and that of the lng column with -122.2624254.

  5. Double-click tGoogleMapLookup to display its Basic settings view and define its properties.

  6. Select the latitude and longitude columns defined in the input schema, lat and lng respectively in this example, and leave the rest of settings as they are.

  7. Double-click tLogRow to display its Basic settings view and define its properties.

  8. Select Vertical (each row is a key/value list) in the Mode area and Print unique name in the Title printing mode area.

Executing the Job

  • Save your Job and press F6 to execute it.

    Google Places API has query limits for applications that submit requests. For further information about the usage limits of Google Places API, see Usage Limits and Billing.

The detailed geographic information of the given coordinates location is obtained from the Google Map database and printed onto the console.