Announcement : All noncommercial projects registered to use Earth Engine before
April 15, 2025 must
verify noncommercial eligibility to maintain Earth Engine access.
Send feedback
ee.FeatureCollection.loadBigQueryTable
Stay organized with collections
Save and categorize content based on your preferences.
Reads data from a BigQuery table and presents the results as a FeatureCollection.
Usage Returns ee.FeatureCollection.loadBigQueryTable(table, geometryColumn )
FeatureCollection
Argument Type Details table
String Path to BigQuery table in a `project.dataset.table` format. geometryColumn
String, default: null The 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.
var features = 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.
var line = 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 using
geemap
for interactive development.
import ee
import geemap.core as geemap
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
Send feedback
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-06-23 UTC.
Need to tell us more?
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-06-23 UTC."],[],[]]