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

Add Column using ECQL expressions

Community Nodes Spatial Processing Transform
Drag & drop
Like
Copy short link

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. Type: Table
    Spatialized entities
    Entities with spatial features
Output ports
  1. Type: Table
    Entities
    The entities with the computation result

Extension

The Add Column using ECQL expressions node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Bing Isochrone (To Share)
    redjunglebear > Public > Bing Isochrone (To Share)

No known nodes available

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
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits