spatial-data-lab / knime-geospatial-extension

This repository is built for KNIME-CGA Geospatial Project, and the goal is to build Python-based nodes for geospatial analysis in KNIME Analytic Platform.
MIT License
25 stars 10 forks source link

Lat/Lon to Geometry issues #97

Open labulatif opened 1 year ago

labulatif commented 1 year ago

Hi!

I’m trying to convert two columns Latitude and Longitude to geometry using the new node Lat/Lon to Geometry, however, the node is not executed and the following message is shown: Execute failed: construct from string not available yet

The issue seems to be related to the existence of string data columns with the Lat Lon columns. I tried to remove string data columns and the Lat/Lo to Geometry worked correctly.

I’m working with string, integer and double data type columns. My first try was to keep only latitude and longitude columns and it worked. After I tried to add string columns and it worked as well. After that, I added the integer columns and the node failed again. Then I removed string and integer columns, keeping only double columns (including lat and lon) and the node failed again, showing the following message: Execute failed: java.lang.IllegalStateException: Customization of entry point failed. With that message I’ve found at Knime Console the following message: WARN DefaultPythonGateway Python standard output: WARN DefaultPythonGateway Python standard error: Traceback (most recent call last):

File “C:\Users\Lisandro.eclipse\903338280_win32_win32_x86_64\plugins\org.knime.python3.nodes_4.7.0.v202211291148\src\main\python_node_backend_launcher.py”, line 56, in import knime.extension.nodes as kn File “C:\Users\Lisandro.eclipse\903338280_win32_win32_x86_64\plugins\org.knime.python3.nodes_4.7.0.v202211291148\src\main\python\knime\extensioninit.py”, line 54, in import knime.api.views as _kv File “C:\Users\Lisandro.eclipse\903338280_win32_win32_x86_64\plugins\org.knime.python3.views_4.7.0.v202211290817\src\main\python\knime\api\views.py”, line 360, in import matplotlib File “C:\Users\Lisandro.eclipse\903338280_win32_win32_x86_64\plugins\sdl.harvard.geospatial.channel.bin.win32.x86_64_1.0.0.202212061406\env\lib\site-packages\matplotlibinit.py”, line 113, in from . import _api, _version, cbook, _docstring, rcsetup File “C:\Users\Lisandro.eclipse\903338280_win32_win32_x86_64\plugins\sdl.harvard.geospatial.channel.bin.win32.x86_64_1.0.0.202212061406\env\lib\site-packages\matplotlib\rcsetup.py”, line 27, in from matplotlib.colors import Colormap, is_color_like File “C:\Users\Lisandro.eclipse\903338280_win32_win32_x86_64\plugins\sdl.harvard.geospatial.channel.bin.win32.x86_64_1.0.0.202212061406\env\lib\site-packages\matplotlib\colors.py”, line 56, in from matplotlib import _api, _cm, cbook, scale File “C:\Users\Lisandro.eclipse\903338280_win32_win32_x86_64\plugins\sdl.harvard.geospatial.channel.bin.win32.x86_64_1.0.0.202212061406\env\lib\site-packages\matplotlib\scale.py”, line 22, in from matplotlib.ticker import ( File “C:\Users\Lisandro.eclipse\903338280_win32_win32_x86_64\plugins\sdl.harvard.geospatial.channel.bin.win32.x86_64_1.0.0.202212061406\env\lib\site-packages\matplotlib\ticker.py”, line 138, in from matplotlib import transforms as mtransforms File “”, line 1007, in _find_and_load File “”, line 986, in _find_and_load_unlocked File “”, line 680, in _load_unlocked File “”, line 846, in exec_module File “”, line 941, in get_code File “”, line 1040, in get_data MemoryError When I tried to run the Lat/Lon to Geometry again, Knime stopped working, I got three beeps in my computer, and it stopped working as well. The only solution was to force shutdown…

Any idea on how to solve this?

koettert commented 1 year ago

Hello @labulatif, I'm sorry to hear this problem. Is it possible that the double and/or int columns do contain only missing values? If not can you please have a look into the KNIME log file (in KNIME AP go to View->Open KNIME log) if you can find further information e.g. another stacktrace. Thanks for your help Tobias