jf87 / scalable_web_systems

Apache License 2.0
1 stars 5 forks source link

North latitude, east longitude queries #7

Open Pantkowsky opened 6 years ago

Pantkowsky commented 6 years ago

Hi,

It's a more general question about a problem which we had stumbled upon while doing assignment 3 - We have picked a random location in Copenhagen, got the latitude and longitude from google maps and made a query based on that data in BigQuery console. However, no results are returned?

Question came up from parsing latitudes and longitudes of Denmark's polygons, taken from geofabrik.de (as specified in the assignment's description). These, when later queried in BigQuery console do not return any results. Are we doing something wrong?

jf87 commented 6 years ago

Did you specify sensible longitude and latitude bands? What is your input? It should return a result.

Pantkowsky commented 6 years ago

What do you mean by sensible bands? We have fetched the Denmark's polygons from geofabrik.de, got the array of longitudes and latitudes and picked random pairs as a query in BigQuery console, to see if anything is returned from such a query. No results have been found though.