Announcement: All noncommercial projects registered to use Earth Engine beforeApril 15, 2025 mustverify noncommercial eligibility to maintain access. If you have not verified by September 26, 2025, your access may be on hold.

ee.FeatureCollection.loadBigQueryTable

  • TheloadBigQueryTable function reads data from a BigQuery table and returns aFeatureCollection.

  • The function requires the path to the BigQuery table and optionally accepts a parameter for the geometry column.

  • Examples demonstrate how to useloadBigQueryTable in both JavaScript and Python to load and display geographical features from a BigQuery table.

 Reads data from a BigQuery table and presents the results as a FeatureCollection.

UsageReturns
ee.FeatureCollection.loadBigQueryTable(table,geometryColumn)FeatureCollection
ArgumentTypeDetails
tableStringPath to BigQuery table in a `project.dataset.table` format.
geometryColumnString, default: nullThe name of the column to use as the main feature geometry. If not specified, the first column with GEOGRAPHY type will be used.

Examples

Code Editor (JavaScript)

// Load stations from the New York Subway System.varfeatures=ee.FeatureCollection.loadBigQueryTable({table:'bigquery-public-data.new_york_subway.stations',geometryColumn:'station_geom',});// Display all relevant features on the map.Map.setCenter(-73.90,40.73,11);Map.addLayer(features,{'color':'black'},'Stations from New York Subway System');// Print all stations in the "Astoria" line.varline=features.filter(ee.Filter.eq('line','Astoria'));print(line);Map.addLayer(line,{'color':'yellow'},'Astoria line');

Python setup

See the Python Environment page for information on the Python API and usinggeemap for interactive development.

importeeimportgeemap.coreasgeemap

Colab (Python)

# Load stations from the New York Subway System.features=ee.FeatureCollection.loadBigQueryTable(table="bigquery-public-data.new_york_subway.stations",geometryColumn="station_geom")# Display all relevant features on the map.m=geemap.Map()m.set_center(-73.90,40.73,11)m.add_layer(features,{'color':'black'},'Stations from New York Subway System')# Print all stations in the "Astoria" line.line=features.filter(ee.Filter.eq('line','Astoria'))display(line)m.add_layer(line,{'color':'yellow'},'Astoria line')m

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-06-23 UTC.