Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
Sign in
  • KNIME Hub
  • Nodes
  • Add Column using ECQL expressions
NodeNode / Other

Add Column using ECQL expressions

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.

Node details

Input ports
  1. Spatialized entities Type: Data
    Entities with spatial features
Output ports
  1. Entities Type: Data
    The entities with the computation result

Related workflows & nodes

  1. Bing Isochrone (To Share)
    redjunglebear > Public > Bing Isochrone (To Share)

No known nodes available

Extension

This node is part of the extension

KNIME Spatial Processing Nodes
Version 1.2.2
Short link

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2021 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits