GoogleCloudPlatform / bigquery-geo-viz

Visualize Google BigQuery geospatial data using Google Maps Platform APIs
https://bigquerygeoviz.appspot.com/
Apache License 2.0
111 stars 40 forks source link

Erratic visualization behavior #49

Open adampilz opened 2 years ago

adampilz commented 2 years ago

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)""")) )

delfrrr commented 7 months ago

@adampilz I don't think BigQuery-geo-viz maintained, but you can try Dekart. Example querying san francisco bikeshare