Hub
Pricing About
WorkflowWorkflow

04 Count values in single band

Spatial Data LabHarvard UniversityGoogle Earth Engine
Center for Geographic Analysis at Harvard University profile image
Draft Latest edits on 
Aug 12, 2024 7:09 PM
Drag & drop
Like
Download workflow
Workflow preview
This KNIME workflow demonstrates how to measure built-up density in Massachusetts using Google Earth Engine (GEE) data and a chunk loop to avoid GEE API request payload size limits. The workflow processes US TIGER MAP data for Massachusetts census tracts and ESA WorldCover100 data to count values in a single band, providing a detailed analysis of built-up areas.

File Reader : Reads the shapefile containing Massachusetts census tract data from the US TIGER MAP.
Column Filter : Filters the necessary columns from the input data for further processing.
Chunk Loop Start : Initiates a loop to process data in chunks, preventing the GEE API error due to request payload size limits (10MB).
GeoDataFrame to Feature Collection:Converts the filtered GeoDataFrame to a Google Earth Engine Feature Collection, preparing it for GEE operations.
GEE Collection Image Reader :Reads the ESA WorldCover100 data (10M resolution) from GEE, focusing on the required geographical area.
GEE Count Values in Single Band:Counts the values in a specified single band of the ESA WorldCover100 data within the defined census tracts.
Feature Collection to Table :Converts the GEE Feature Collection with counted values back to a KNIME table format for further analysis.
Loop End : Concludes the chunk loop, aggregating the results from each chunk into a single output table.

Joiner: Joins the results from the GEE operations with additional geospatial data for comprehensive analysis.
Projection : Reprojects the geospatial data to the desired coordinate reference system (CRS) for consistency in analysis.
Area : Calculates the area of each census tract in the reprojected data, aiding in density calculations.
Math Formula : Applies mathematical formulas to compute built-up density using the area and count values.
Geospatial View : Provides a visual representation of the geospatial data, allowing for inspection and validation of the results.
Timer Info : Records the time taken for the entire workflow, providing insights into processing efficiency.

Created By:
Lingbo Liu
lingboliu@fas.harvard.edu
Spatial Data Lab project
Center for Geographic Analysis
Harvard University
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 5.3.0
  • Go to item
    Geospatial Analytics Extension for KNIMETrusted extension

    SDL, Harvard, Cambridge US

    Version 1.2.0

    Center for Geographic Analysis at Harvard University profile image
    Center for Geographic Analysis at Harvard University
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Versions 5.2.2, 5.3.0

    knime
  • Go to item
    KNIME Math Expression (JEP)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.3.0

    knime
  • Go to item
    KNIME Python IntegrationTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.3.0

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Versions 5.2.2, 5.3.0

    knime
  • Go to item
    KNIME ViewsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.3.0

    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

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