Unveiling the Might of Google’s Earth Engine and BigQuery for Detecting Flooded Roads Using Satellite Data

Unveiling the Might of Google’s Earth Engine and BigQuery for Detecting Flooded Roads Using Satellite Data

Unveiling the Might of Google’s Earth Engine and BigQuery for Detecting Flooded Roads Using Satellite Data

As Seen On

Capturing the potential of Google’s Earth Engine and BigQuery, new capabilities have recently been unveiled, with a primary focus on making large-scale data processing more accessible to a broad audience. Among the notable advancements is the new functionality that allows facile exportation of tabular data from Earth Engine to BigQuery using an uncomplicated one-line command (Export.table.toBigQuery()).

Let’s dive in further to understand what earth engine and BigQuery truly are. Simplifying complex satellite data interpretation, Google’s Earth Engine is a cutting-edge geospatial analysis tool. It brings a ganglion of data sources and computational power at a researcher’s fingertips. BigQuery, on the other hand, is Google Cloud’s fully managed, petabyte-scale, and cost-effective data warehouse designed to make all your data analysts productive.

The new interface promotes extensive analysis, merging Earth Engine data with BigQuery data sources. It facilitates using BigQuery’s influential analysis tools on Earth Engine data and also permits sharing of Earth Engine data with SQL-friendly users.

Now, let’s walk through the step-by-step process of exporting data from Earth Engine to BigQuery. But let’s anchor this learning process in a practical context – identifying flooded roads in adverse weather events.

Why address this issue? Extreme weather events are becoming more common, given the reckoning with climate change. Swift identification of flooded roads after flooding events is crucial in organizing and planning rescue missions, making such tool integrations a potent tool for data analysts and disaster management teams alike.

Open road data sets from BigQuery, when coupled with satellite data mosaics from Earth Engine, can quickly locate flooded road segments. This is where the Earth Engine-BigQuery combination comes into its own, straddling two worlds – on-the-ground terrain data and satellite visibility – but how to implement it?

Steering you through the prerequisites, initially, a new Cloud project needs setting up which necessitates enabling the BigQuery and Earth Engine API. The following steps involve configuring access to the Earth Engine and creating a dataset within the BigQuery workspace. Importantly, billing account must be enabled in the project involving charges as applicable.

Shutting the spotlight on identifying flooded areas in Earth Engine, it is made possible by Google Earth Engine’s Data Catalog containing the Copernicus Sentinel Synthetic Aperture Radar collection. The collection could differentiate standing bodies of water from other environments employing ‘dark’ patches in snapped images, representing areas with low backscatter values.

When adapting this whole process using Python scripts, both Earth Engine and BigQuery provide Pythonesque solutions for users typically inclined towards Python.

This new feature of interlocking Earth Engine data with BigQuery, encapsulated by a one-line command, revolutionizes the way we perceive, process and prepare for natural disasters. It offers a prime example of how harnessing the full potential of technology can eventually contribute to a safer, more resilient world.

The unveiling of such powerful tools hints towards a future where technologies are seamlessly integrated, transforming raw data into actionable wisdom, thereby enabling us to keep pace with rapidly changing world situations.

Casey Jones Avatar
Casey Jones
11 months ago

Why Us?

  • Award-Winning Results

  • Team of 11+ Experts

  • 10,000+ Page #1 Rankings on Google

  • Dedicated to SMBs

  • $175,000,000 in Reported Client

Contact Us

Up until working with Casey, we had only had poor to mediocre experiences outsourcing work to agencies. Casey & the team at CJ&CO are the exception to the rule.

Communication was beyond great, his understanding of our vision was phenomenal, and instead of needing babysitting like the other agencies we worked with, he was not only completely dependable but also gave us sound suggestions on how to get better results, at the risk of us not needing him for the initial job we requested (absolute gem).

This has truly been the first time we worked with someone outside of our business that quickly grasped our vision, and that I could completely forget about and would still deliver above expectations.

I honestly can't wait to work in many more projects together!

Contact Us


*The information this blog provides is for general informational purposes only and is not intended as financial or professional advice. The information may not reflect current developments and may be changed or updated without notice. Any opinions expressed on this blog are the author’s own and do not necessarily reflect the views of the author’s employer or any other organization. You should not act or rely on any information contained in this blog without first seeking the advice of a professional. No representation or warranty, express or implied, is made as to the accuracy or completeness of the information contained in this blog. The author and affiliated parties assume no liability for any errors or omissions.