使用BigQuery查询地理空间数据 [英] Query geospatial data with BigQuery

问题描述

您好，我希望根据GPS坐标获取公共位置（餐厅，酒店，电影院等）邻居列表。如果你有经纬度或GPS坐标作为列，你绝对可以从中获取矩形区域BigQuery在坐标上使用WHERE比较，然后聚合在选定的行上。

BigQuery中的标量操作也非常强大 - 您可以添加各种算术函数到您的查询并仍然获得优异的性能。

您在链接页面上查找列出的示例查询： 返回一个集合（37.46，-122.50）。

在使用余弦曲线定律确定的近似圆内返回多达100个点的集合以科罗拉多州丹佛市为中心（39.73，-104.98）。

Hi I would like to obtain a list of public locations (restaurant, hotels, cinema etc.) neighbours based on GPS coordinates. Is this possible with BigQuery ?

解决方案

If you have lat-lon or GPS coordinates as columns, you could definitely grab rectangular regions from BigQuery using WHERE comparisons on the coordinates and then aggregate on the selected rows.

The scalar operations available in BigQuery are pretty powerful too -- you can add a variety of arithmetic functions to your query and still get excellent performance.

You find listed example queries on the linked page:

• Return a collection of points within a rectangular bounding box centered around San Francisco (37.46, -122.50).
• Return a collection of up to 100 points within an approximated circle determined by the using the Spherical Law of Cosines, centered around Denver Colorado (39.73, -104.98).

这篇关于使用BigQuery查询地理空间数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！