City analysis for eventzimmer

location_counts.sql

COPY (SELECT locations.latitude, locations.longitude, (SELECT COUNT(*) FROM eventzimmer.events WHERE events.location = locations.name) FROM eventzimmer.locations) TO stdout WITH csv;

location_counts.tsv

48.52616,9.06128,19
48.516638,9.058842,23
48.526122,9.064106,44
48.521314,9.05735,11
48.524378,9.060555,0
48.52147,9.08288,26
48.485595,9.222472,25
48.541379,9.059727,36
48.529562,9.046918,1
48.520562,9.050905,21
48.520562,9.050905,11
48.499628,9.063168,59
48.495475,9.206449,56
48.513823,9.071786,67
48.515184,9.063384,5
48.51987,9.052652,48
48.522898,9.054252,60
48.521057,9.047971,41
48.522898,9.054252,5
48.513955,9.053803,2
48.513876,9.065748,0
48.519948,9.055308,0
48.518213,9.057703,2
48.513308,9.065657,2
48.515319,9.05083,1
48.516937,9.061812,59
48.51824,9.058246,32
48.5193608,9.0585869,3
48.4922381,9.2144615,9
48.521143,9.0577463,3
48.521143,9.0577463,18
48.7796179,9.1673455,50
48.7848033,9.1786246,77
48.3712096,8.9609695,7
48.7991183,9.1858991,33
48.2709967,8.8498761,42
48.2586279,8.8542185,60
48.7974711,9.2264063,43
48.7675385,9.251578,64
48.2697902,8.8491816,1
48.2679181,8.8511864,0
48.2720768,8.8570032,30
48.778811,9.1771159,4
48.7821935,9.1775027,10
48.6475272,9.4540965,18
48.6112,9.54205000000002,3
48.6488101,9.4535406,31
48.6486728,9.4523224,20
48.2030389,9.0475952,46
48.6491445,9.4481496,3
48.1423719,11.5704663,73
48.5195585,9.0564853,2
48.5419376,9.0478161,8
48.510331,9.0784735,9
48.5244121,9.0597217,2
48.5259421,9.0583541,16
48.522171,9.0578909,13
48.4903328,9.2133903,10
48.7760815,9.184154,46
48.7638025,9.1706208,23
48.7732704,9.1785843,36
48.7638025,9.1706208,21
48.7742239,9.179606,30
48.772065,9.180227,2
48.7755912,9.1827879,19
48.7651756,9.1684051,41
48.7736111,9.1766402,0
48.7799348,9.1935686,0
48.7799348,9.1935686,8
48.5241,9.0177,12
48.4911908,9.2069775,35
48.5110945,9.062192,67
48.5203862,9.0525618,0
48.5163935,9.0553781,15
48.5222843,9.061179,12
48.520458,9.05561,1
48.53626,9.069,1
48.51788,9.06114,1
48.53076,9.06547,2