Spatial 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
Determine 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
Dasymetric Spatial Interpolation in BigQueryMapping census population to H3 hexagonsNov 13, 20201Nov 13, 20201
Published inTowards 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
Published inTowards 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
Published inTowards 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