Geocoding in FoodChain-Lab
Tasks
- Perform a geocoding by using the Geocoding workflow from https://github.com/SiLeBAT/BfROpenLa….
- Use “Street”, “HouseNumber”, “City” and “Country” as input parameters.
- Do the geocoding by using the MapQuest Geocoding Service.
Step 1

Step 2
- For using MapQuest you have to register and create a key at https://developer.mapquest.com
- This key has to be entered in the KNIME preferences.
- Select File < Preferences in the menu bar.

Step 3
- The Preferences dialog will pop up.
- Here you can specify all preferences for KNIME and FoodChain-Lab.

Step 4
- Select KNIME < Geocoding in the navigation tree on the left.
- Enter your MapQuest Application Key and press OK.

Step 5
- To perform geocoding we need one column with addresses in our data table. The Supply Chain Reader puts out all parts of the address (street, city, …) in different columns.
- The address column is created via the Address Creator node.
- Double click on this node to open its dialog.

Step 6
- In the dialog you can specify the columns that should used for creating the address column.

Step 7
- Since we want to do the Geocoding based on “Street”, “HouseNumber”, “City” and “Country”, we have to set the Country Column to “Country” and the Postal Code Column to “none”.
- Press OK to close the dialog.

Step 8
- Since we changed the settings, the node resets automatically.
- Press OK.

Step 9
- The configuration for the Address Creator has been updated.

Step 10
- Right click on the Address Creator node and select Execute.

Step 11
- Now that we updated the Address, the geocoding can be set up.
- Double click on the Geocoding node to open its dialog.

Step 12
- Here you can specify the Service Provider for geocoding and the column that should be used.
- Both are already correctly set, so we don’t need to change anything here.

Step 13
- For many requests geocoding services return multiple results (e.g. when there are two streets with the same name).
- To deal with this we have to decide if we just want to use the first or look at all choices and try to find the best.
- Looking manually at all choices is a lot of work for large data sets. In this tutorial select Use first and press OK.

Step 14
- Right click on the Geocoding node and select Execute.

Step 15
- The execution can take a while.
- The progress bar under the node shows what percentage of data has been processed.

Step 16
- When the execution is finished, we can look at the results.
- Right click on the Geocoding node and select Coordinates.

Step 17
- In the dialog that pops up, you can look at the whole data table.

Step 18
- Scroll to the right to look at the columns with latitude and longitude (the two rightmost columns).
- Some geocoding requests were not successful. MapQuest returned US coordinates, although all addresses are in Germany.
