Datawheel/pantheon2

Berlin lat/lon pointing to Poland

Closed this issue · 1 comments

Berlin lat/lon pointing to Poland

FIXED!

Screen Shot 2019-10-03 at 3 45 17 PM

had to change:

max(subq.lat) as lat, 
max(subq.lon) as lon, 

to

mode() within group (order by subq.lat) as lat,
mode() within group (order by subq.lon) as lon,