0 ×

Add Column using ECQL expressions

KNIME Spatial Processing Nodes version 1.2.2.v201911131528 by EIFER (European Institute for Energy Research)

Add to WKT (Well-known Text) geometries a column computed using the Contextual Query Language

When your expression returns a numeric, Boolean or String result, you have to define the type of the column into which this results will be stored and the name of this column. If your expression returns a geometry, you can either process it as a geometry, and replace the original geometry; or store it as a String into a novel column.

Examples of queries:

  • compute the area: "area(the_geom)"
  • compute a centroid: "centroid(the_geom)"
  • compute a buffer: "buffer(the_geom, 10)"
  • compute the distance to a point defined by flow two Double flow variables x and y: "distance(the_geom,$${Dx}}$,$${Dy}}$)"
More examples can be found here: Geoserver ECQL Tutorial

Note that the units used in the query depend on the Coordinate Reference System.

The actual processing is done by the awesome geotools library.


The query in Contextual Query Language
The type of the column to create. Ensure it is consistent with the result of the query
The name of the column to create

Input Ports

Entities with spatial features

Output Ports

The entities with the computation result

Best Friends (Incoming)

Best Friends (Outgoing)



To use this node in KNIME, install KNIME Spatial Processing Nodes from the following update site:


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.