Starting from the Oracle Connector Node, the DB Query Reader follows with an SQL statement, such as:
SELECT
SD_UTIL.TO_WKTGEOMETRY ("columnname with the geometry data") AS geometry_column_wkt
FROM
"TABLENAME"
Then a WKT to Geometry Node follows to project the WKT back into its original geometry.
In this case project into another geometry an calculate area.
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!