Icon

connect Oracle Spatial, read Geometry an reproject

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.

read Data from dbwith SQL Statementreproject WKT toits base geometryin this caseepsg:4326for examplereproject toepsg:3857for examplecalculate areaOracle Connector DB Query Reader WKT to Geometry Projection Area read Data from dbwith SQL Statementreproject WKT toits base geometryin this caseepsg:4326for examplereproject toepsg:3857for examplecalculate areaOracle Connector DB Query Reader WKT to Geometry Projection Area

Nodes

Extensions

Links