Mathias SchläfferSpatial Autocorrelation and Moran's I in SQL and BigQuerySpatial lag and autocorrelation is discussed in many spatial or geographic data science resources. One common metric calculated to describe…Mar 24, 2022Mar 24, 2022
Mathias SchläfferDetermine the Winding of a Polygon in BigQuery to calculate Interior AnglesIn this article I will show how to quickly determine the winding of a polygon. This can be used f.e. to calculate all interior angles for…Dec 3, 20211Dec 3, 20211
Mathias SchläfferDasymetric Spatial Interpolation in BigQueryMapping census population to H3 hexagonsNov 13, 20201Nov 13, 20201
Mathias SchläfferinTowards Data ScienceHow to go from bias to buyerThere are many articles on estimating house prices, and many articles about webscraping. While both plays a part in this article, I want…Jan 25, 2019Jan 25, 2019
Mathias SchläfferinTowards Data ScienceUsing Google maps’ Location History to calculate and visualize my own costs of traffic congestionDuring a year of employment at the Vrije Universiteit in Amsterdam, I worked on modelling a scheme of tradable road permits to battle peak…Sep 23, 20187Sep 23, 20187
Mathias SchläfferinTowards Data ScienceUsing a Markov chain sentence generator in Python to generate ‘real fake news’.Let’s be honest: today’s news headlines are crazy. They are especially crazy if they concern Donald Trump. So crazy sometimes that you ask…Aug 19, 20185Aug 19, 20185