From GPS to PostGIS with simplicity
This article is a simple procedure to import your GPS data into PostGIS without pain, it merely boils down to: And you are done, your layer is now a table in PostGIS database that you can query as you wish.…
landercy.be
Grasp more from your process, make analytics, focus on what matters.
landercy.be
Grasp more from your process, make analytics, focus on what matters.
jlandercy
Building a tree structure with a recursive query in SQL
When modeling dataset we often need to represent hierarchical relation between objects. If the information is easy to store in a classical RDBMS querying the full hierarchical structure might not be obvious at the first glance. In this article we…
Make GeoDjango+DRF as flexible as you wish by binding Raw Query to Serializers
When building API with Django, Django Rest Framework is generally a good choice. If you need to extend the requirements to support GIS query then you will probably find the extension DRF-GIS convenient as it nicely fill the gap for…
Automatize your statistical tests with Python, Pandas and SciPy
Synthetic dataset First let’s import few packages to do the job. Now we can create a synthetic dataset to support the discussion: Pandas aggregation magic The key to make easy and flexible aggregation with pandas is to define function with…
Tropospheric Ozone correlations
In this post we review some well known properties of tropospheric Ozone. Exercise is performed on 10 years of observations through specific correlations between Ozone, Nitrogen Dioxide and meteorological parameters. Objective is to draw a knowledge baseline about the Ozone.
Adjustment of an ordinary differential equation
This post shows how ODE parameters as well as initial condition can be adjusted to experimental data using Python. Adjusting ODE parameters is good topic to introduces specific methodology such as parameter normalization and sample bootstrapping.
Using pollution roses to highlight traffic influence at Brussel’s 11th Canal Lock
Pollution rose is a very important tool when dealing with Air Quality Monitoring, they help to understand from which wind sectors the pollution arises and when correlating pollution roses at several locations it can be used to triangulate specific sources…
Adjustment of a series expansion with Python
Python and scipy package are very powerful when dealing with optimization problem. We present in this article a double optimization problem involving root find of a rational trigonometric equation and a non linear adjustment of a series expansion.
Adjustment of an integral function with Python
Python is a very convenient companion for function adjustment and scientific computing in general. We present in this article a simple problem where the scipy package is the sufficient toolbox to tackle an non linear adjustment problem involving a numerical…