Google Earth Engine
Extension Package provided by CARTO
Last updated
Was this helpful?
Extension Package provided by CARTO
Last updated
Was this helpful?
This extension provides powerful Google Earth Engine integration for spatial analysis.
It includes components for summarizing raster data over polygons and efficiently processing large-scale vector data with Earth Engine imagery.
These tools enable users to perform advanced geospatial analysis by combining BigQuery's data processing capabilities with Earth Engine's vast satellite imagery and geospatial datasets.
Description
Summarizes Google Earth Engine raster data over a polygon. Users specify an image, band, and reducer function for efficient spatial analysis.
Inputs
Source table: This component is limited to an input of 10 rows with polygons. It's tipically used along with a input to define the regions that will be summarized.
Settings
Geometry column: Select a column from the input table that contains polygons.
GEE Image ID: (Optional) Provide a Google Earth Engine image ID. Provider either this or a GEE Image expression.
GEE Image expression: (Optional) Provider a Google Earth Engine expression that returns a single image. Provider either this or a GEE Image ID.
Band: Specify which band from the image will be used for the reduce operation.
Reducer: Select a function
Scale in meters: Specify a size in meters to define the scale of your operation.
Outputs
Output table: This component return a table with the same columns as the Source table, with an additional one named ee_summary_<reducer> that contains the value of the reduce operation.
Description
Summarizes Google Earth Engine raster data over polygons on a BigQuery table. Users specify an image, band, and reducer function for efficient spatial analysis.
Inputs
Source table: A table that contains polygons.
Settings
Geometry column: Select a column from the input table that contains polygons.
GEE Image ID: (Optional) Provide a Google Earth Engine image ID. Provider either this or a GEE Image expression.
GEE Image expression: (Optional) Provider a Google Earth Engine expression that returns a single image. Provider either this or a GEE Image ID.
Band: Specify which band from the image will be used for the reduce operation.
Scale in meters: Specify a size in meters to define the scale of your operation.
Outputs
Output table: This component return a table with the same columns as the Source table, with an additional one named ee_<reducer> that contains the value of the reduce operation.
Description
Inputs
Settings
Geometry column: Select a column from the input table that contains polygons.
Outputs
Output table: This component return a table with the same columns as the Source table, with an additional one named ee_<reducer>_elevation that contains the value of the reduce operation.
Description
Inputs
Settings
Geometry column: Select a column from the input table that contains polygons.
Start date: Type a YYYY-MM-DD that defines the start date to consider for your analysis.
End date: Type a YYYY-MM-DD that defines the end date to consider for your analysis.
Outputs
Output table: This component return a table with the same columns as the Source table, with an additional one named ee_ndvi that contains the mean NDVI value of the polygon.
Description
Inputs
Settings
Geometry column: Select a column from the input table that contains polygons.
Start date: Type a YYYY-MM-DD that defines the start date to consider for your analysis.
End date: Type a YYYY-MM-DD that defines the end date to consider for your analysis
Outputs
Output table: This component return a table with the same columns as the Source table, with an additional one named ee_<reducer>_precipitation that contains the value of the reduce operation.
Reducer: Select a function
Retrieves and summarizes for specified polygons.
Source table: This component is limited to an input of 10 rows with polygons. It's tipically used along with a input to define the regions that will be summarized.
Reducer: Select a function
Retrieves and summarizes the Normalized Difference Vegetation Index (NDVI) obtained with NIR (B8) and RED (B4) bands for specified polygons and date ranges.
Source table: This component is limited to an input of 10 rows with polygons. It's tipically used along with a input to define the regions that will be summarized.
Retrieves and summarizes for specified polygons and date ranges.
Source table: This component is limited to an input of 10 rows with polygons. It's tipically used along with a input to define the regions that will be summarized.
Reducer: Select a function.