Hub
Pricing About
NodeNode / Other

Filter WKT data using ECQL queries

Community NodesSpatial ProcessingTransform
Drag & drop
Like

Filters WKT (Well-known Text) geometries according to their characteristics or geometries using the Contextual Query Language Only the lines for which the expression is true will be kept.

Examples of queries:

  • Select entities whom area is smaller than 10 units: "area(the_geom) ≤ 10"
  • Select entities whom area between 10000 and 30000: "area(the_geom) BETWEEN 10000 AND 30000"
More examples can be found here: Geoserver CQG Tutorial

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

The actual processing is done by the powerful geotools library .

Node details

Input ports
  1. Type: Table
    Spatialized entities
    Entities with spatial features
Output ports
  1. Type: Table
    Filtered entities
    The filtered entities

Extension

The Filter WKT data using ECQL queries node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits