bigquery-geo-viz
bigquery-geo-viz copied to clipboard
Erratic visualization behavior
Run the following query and then open in the geo viz app. Upon clicking to utilize street view, the behavior of the viz becomes erratic.
SELECT *
FROM bigquery-public-data.san_francisco_bikeshare.bikeshare_station_info as t1
WHERE
ST_WITHIN(ST_GEOGPOINT(lon, lat),
ST_MAKEPOLYGON(ST_GEOGFROMTEXT("""LINESTRING(
-122.41028583847944 37.797426773624345,
-122.39778035397875 37.79923820799601,
-122.39614117965742 37.79277567798291,
-122.40880525911727 37.790152515674635)"""))
)
@adampilz I don't think BigQuery-geo-viz maintained, but you can try Dekart. Example querying san francisco bikeshare