Connecting PostGIS to KNIME
Hi, I’m trying to connect PostGIS to KNIME. I have a PostgreSQL table with a geometry column I’m trying to visualise using Geospatial View. But the geometry column is not detected. A workaround I found is to first convert it into GeoJSON in the DB Query Reader using SQL: select ST_AsGeoJSON(geom) from mytable;
This however is slow when using large datasets. See the logic here below.
Is there a way to use the PostGIS geometry column directly?
Cheers, Jelmer