Icon

JKISeason3-29_​Berlin Christmas Markets

Berlin Christmas Markets

Challenge 29

Level: Medium

Description: Christmas is right on the corner, and many of those who celebrate it are currently looking for souvenirs and gifts for their loved ones. To facilitate their search, let’s create a data app that allows people to find nearby Christmas markets given an address and a maximum distance. Data app users should be able to visualize the locations, along with their distances from the given address. In our example, we focus on the Berlin Christmas markets of 2023, but feel free to experiment with other geospatial datasets that have information on Christmas markets. Hint: Since the dataset is in German, you can use the Translator component from KNIME Community Hub to translate the addresses.

Author: Sanket Joshi

URL: Dataset https://hub.knime.com/alinebessa/spaces/Just%20KNIME%20It!%20Season%203%20-%20Datasets/Challenge%2029%20-%20Dataset~r-O7eMEw-0TjibEK/

Christmas Markets in Berlin.xlsxNode 3https://nominatim.openstreetmap.org/search?q=boundingboxonly boundingboxboundingbox by ","arrays to lat and lontwo points with target location betweenaverage lataverage lonreplace "" with "+"linkNode 81Christmas Markets in Berlin.csvNode 83RowIDNode 85Node 86Node 871s because of api limitationExcel Reader Web InteractionEnd (Labs) GET Request XPath Column Filter Cell Splitter Column Renamer Math Formula Math Formula String Manipulation(Multi Column) String Manipulation Table Row toVariable Loop Start CSV Writer Variable toTable Row Joiner RowID RowID Variable Loop End Data app_BerlinChristmas Markets Wait... Christmas Markets in Berlin.xlsxNode 3https://nominatim.openstreetmap.org/search?q=boundingboxonly boundingboxboundingbox by ","arrays to lat and lontwo points with target location betweenaverage lataverage lonreplace "" with "+"linkNode 81Christmas Markets in Berlin.csvNode 83RowIDNode 85Node 86Node 871s because of api limitationExcel Reader Web InteractionEnd (Labs) GET Request XPath Column Filter Cell Splitter Column Renamer Math Formula Math Formula String Manipulation(Multi Column) String Manipulation Table Row toVariable Loop Start CSV Writer Variable toTable Row Joiner RowID RowID Variable Loop End Data app_BerlinChristmas Markets Wait...

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: RB
Created at: 2024-12-04
On NodePit since: 2024-12-08
Last update: 2024-12-17
Created with KNIME version: v5.3.2
Tags: JKISeason3-29

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!