Download query results to a GeoPandas GeoDataFrame
Stay organized with collections
Save and categorize content based on your preferences.
Download query results to a GeoPandas GeoDataFrame.
Code sample
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],[],[[["\u003cp\u003eThis content demonstrates how to download query results from BigQuery directly into a GeoPandas GeoDataFrame.\u003c/p\u003e\n"],["\u003cp\u003eThe provided code sample shows a SQL query to select data from a public BigQuery dataset, including geospatial information.\u003c/p\u003e\n"],["\u003cp\u003eAuthentication with BigQuery is required, utilizing Application Default Credentials as described in the linked documentation.\u003c/p\u003e\n"],["\u003cp\u003eThe code sample leverages the \u003ccode\u003eto_geodataframe()\u003c/code\u003e function to convert BigQuery query results into a GeoPandas GeoDataFrame format.\u003c/p\u003e\n"]]],[],null,["# Download query results to a GeoPandas GeoDataFrame.\n\nCode sample\n-----------\n\n### Python\n\n\nBefore trying this sample, follow the Python setup instructions in the\n[BigQuery quickstart using\nclient libraries](/bigquery/docs/quickstarts/quickstart-client-libraries).\n\n\nFor more information, see the\n[BigQuery Python API\nreference documentation](/python/docs/reference/bigquery/latest).\n\n\nTo authenticate to BigQuery, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for client libraries](/bigquery/docs/authentication#client-libs).\n\n\n sql = \"\"\"\n SELECT created_date, complaint_description,\n ST_GEOGPOINT(longitude, latitude) as location\n FROM bigquery-public-data.austin_311.311_service_requests\n LIMIT 10\n \"\"\"\n\n df = client.query_and_wait(sql).to_geodataframe()\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=bigquery)."]]
