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…4 min read·Mar 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…5 min read·Dec 3, 2021--1--1
Mathias SchläfferDasymetric Spatial Interpolation in BigQueryMapping census population to H3 hexagons7 min read·Nov 13, 2020--1--1
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…12 min read·Jan 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…7 min read·Sep 23, 2018--7--7
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…7 min read·Aug 19, 2018--5--5