Google Earth Engine

Extension Package provided by CARTO

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.

Download the Google Earth Engine extension package

These component make use of cloud functions deployed and maintained by CARTO on a GCP project.

Usage of these functions is limited to 100/month per connection.

These functions are available for the US BigQuery region.

Please get in touch with us at [e-mail] if you need to deploy your own version of the functions.

Summary Region

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 Draw Custom Features 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 reducer 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.

Summary Table

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.

• Reducer: Select a reducer 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_<reducer> that contains the value of the reduce operation.

Get Elevation

Description

Retrieves and summarizes elevation data from Google Earth Engine for specified polygons.

Inputs

• Source table: This component is limited to an input of 10 rows with polygons. It's tipically used along with a Draw Custom Features input to define the regions that will be summarized.

Settings

• Geometry column: Select a column from the input table that contains polygons.

• Reducer: Select a reducer function

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.

Get NDVI

Description

Retrieves and summarizes the Normalized Difference Vegetation Index (NDVI) obtained with NIR (B8) and RED (B4) bands from Google Earth Engine data for specified polygons and date ranges.

Inputs

• Source table: This component is limited to an input of 10 rows with polygons. It's tipically used along with a Draw Custom Features input to define the regions that will be summarized.

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.

Get Precipitation

Description

Retrieves and summarizes precipitation data from Google Earth Engine for specified polygons and date ranges.

Inputs

• Source table: This component is limited to an input of 10 rows with polygons. It's tipically used along with a Draw Custom Features input to define the regions that will be summarized.

Settings

• Geometry column: Select a column from the input table that contains polygons.

• Reducer: Select a reducer function.

• 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.