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.
Workflow
connect Oracle Spatial, read Geometry an reproject
Used extensions & nodes
Created with KNIME Analytics Platform version 4.7.1
- Go to item
SDL, Harvard, Cambridge US
Version 1.0.0
- Go to item
KNIME AG, Zurich, Switzerland
Version 4.7.0
Loading deployments
Loading ad hoc executions
Legal
By using or downloading the workflow, you agree to our terms and conditions.