Heat maps without Geospatial Extension

[mgroos]

Hello all, hello @stelfrich,

for the visualization of about 1.000 Locations we used the “Get Request” to get the Latitudes and Longtitudes and in the end we have the “OSM Map Viewer”.

Following an example of the data, thats provided in the “Column Filter”

Our current output is the following. Green = count <4; red = count >4

Now we want to visualize it in Heat maps.

The nodes of geospatial extension didn´t work for us: either there is an error or the software sends “no response” for a long time.

Is there a way to include Heat Maps on the “OSM Map Viewer”?

Thank you in advance.

Best regards
Margarethe

[steffen_KNIME]

Hi mgroos,

could you elaborate on the geospatial errors? What is the error? Does the KNIME log provide additional information (View → Open KNIME log)?

Best regards
Steffen

[mgroos]

Hi Steffen,

f.e. I tried to drop the node “Geometry to Lat/Long”, this appears:
t

I see that something is missing, but don´t know how to solve that…

Best regards
Margarethe

[steffen_KNIME]

Thanks, could you also please provide the KNIME log?

[Daniel_Weikert]

There are Heatmap nodes in KNIME. Would that be an option to test?
br

[mgroos]

Oh sorry about that.

2023-01-06 18:29:47,914 : ERROR : main : : ArrowColumnStoreFactory : : : Failed to initialize LZ4 libraries. The Columnar Table Backend won’t work properly.
java.lang.UnsatisfiedLinkError: no jnilz4 in java.library.path: C:\Program Files\KNIME;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0;C:\WINDOWS\System32\OpenSSH;C:\Users\MG\AppData\Local\Microsoft\WindowsApps;C:\Users\MG\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\MG\AppData\Local\Programs\MiKTeX\miktex\bin\x64;.
at java.base/java.lang.ClassLoader.loadLibrary(Unknown Source)
at java.base/java.lang.Runtime.loadLibrary0(Unknown Source)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.bytedeco.javacpp.Loader.loadLibrary(Loader.java:1807)
at org.bytedeco.javacpp.Loader.load(Loader.java:1416)
at org.bytedeco.javacpp.Loader.load(Loader.java:1227)
at org.bytedeco.javacpp.Loader.load(Loader.java:1203)
at org.bytedeco.lz4.global.lz4.(lz4.java:14)
at java.base/java.lang.Class.forName0(Native Method)
at java.base/java.lang.Class.forName(Unknown Source)
at org.bytedeco.javacpp.Loader.load(Loader.java:1282)
at org.bytedeco.javacpp.Loader.load(Loader.java:1227)
at org.bytedeco.javacpp.Loader.load(Loader.java:1219)
at org.knime.core.columnar.arrow.ArrowColumnStoreFactory.(ArrowColumnStoreFactory.java:85)
at org.knime.python3.nodes.CloseablePythonNodeProxy.(CloseablePythonNodeProxy.java:124)
at org.knime.python3.nodes.CloseablePythonNodeProxyFactory.createProxy(CloseablePythonNodeProxyFactory.java:92)
at org.knime.python3.nodes.CachedNodeProxyProvider.createPythonNodeFromCache(CachedNodeProxyProvider.java:220)
at org.knime.python3.nodes.CachedNodeProxyProvider.getNodeFactoryProxy(CachedNodeProxyProvider.java:195)
at org.knime.python3.nodes.extension.ExtensionNodeSetFactory$DynamicExtensionNodeFactory.createNodeModel(ExtensionNodeSetFactory.java:220)
at org.knime.python3.nodes.extension.ExtensionNodeSetFactory$DynamicExtensionNodeFactory.createNodeModel(ExtensionNodeSetFactory.java:1)
at org.knime.core.node.NodeFactory.callCreateNodeModel(NodeFactory.java:520)
at org.knime.core.node.Node.(Node.java:307)
at org.knime.core.node.workflow.WorkflowManager.addNodeAndApplyContext(WorkflowManager.java:844)
at org.knime.core.ui.wrapper.WorkflowManagerWrapper.createAndAddNode(WorkflowManagerWrapper.java:140)
at org.knime.workbench.editor2.commands.CreateNodeCommand.lambda$0(CreateNodeCommand.java:183)
at org.knime.workbench.ui.async.AsyncUtil.wfmAsyncSwitch(AsyncUtil.java:130)
at org.knime.workbench.editor2.commands.CreateNodeCommand.execute(CreateNodeCommand.java:182)
at org.eclipse.gef.commands.CommandStack.execute(CommandStack.java:228)
at org.knime.workbench.editor2.WorkflowEditorDropTargetListener.handleDropAsync(WorkflowEditorDropTargetListener.java:531)
at org.knime.workbench.editor2.WorkflowEditorDropTargetListener.lambda$5(WorkflowEditorDropTargetListener.java:494)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:132)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4043)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3648)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1155)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1046)
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)
at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:644)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:551)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:156)
at org.knime.product.rcp.KNIMEApplication.start(KNIMEApplication.java:191)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:136)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:402)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:659)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:596)
at org.eclipse.equinox.launcher.Main.run(Main.java:1467)
Caused by: java.lang.UnsatisfiedLinkError: Could not find jnilz4 in class, module, and library paths.
at org.bytedeco.javacpp.Loader.loadLibrary(Loader.java:1792)
… 51 more

[steffen_KNIME]

Good morning Margarethe,

thanks for the logs. The issue with the Geospatial nodes seem to be that the extension KNIME Columnar Table Backend is missing.
Could you install the extension and try the Geospatial nodes again please?

Background: Looks like your KNIME Analytics Platform has been updated several times, and did not have the Columnar Table Backend preinstalled. This issue will be fixed and should not happen in future releases anymore.

Best regards
Steffen

[mgroos]

Thanks a lot!

It works now.

Best regards
Margarethe