Residential investor Vesteda is working on a new website. If an available rental home has a garden, the location of the garden must be listed on the webpage of that home. This information was not yet available in the database. We were instructed to determine the location of the garden based on the coordinates of the homes.
The dataset that was available contained the address and coordinates of all residences.
We used data from the Key Register of Addresses and Buildings (in Dutch: BAG) through an API to verify whether a residential property was an apartment or a single-family home. We then supplemented the dataset with the cadastral map per parcel through the Land Registry API. Based on that, we calculated the centroid (the center point) of the plot.
If a plot only contained the coordinates of one residential property, we calculated the angle between the coordinates of the house and the centroid of the plot. Based on this, we determined the sun position (for example: East).
We enriched the housing database with an extra column, called 'garden location'. It is now known per address whether the garden faces East, Southwest, etc.
For the data that we filtered from the dataset, we created an image archive. In the image you can see:
- the calculated wind direction as text
- a pink dot for the coordinates of the house
- a green dot in front of the centroid of the plot
The script we wrote is fully automated and requires little processing power. If new homes are added in the future, we can determine the garden location of all homes at the touch of a button.
To ensure high reliability of the data, we optimised the model through several automatic iterations. As a result, the script has a reliability of 97%. We determined this on the basis of a manual sample of 500 samples. The script can be applied to all kinds of coordinates (for example also to WGS 84, Rijksdriehoek coordinates, etc.).
You might ind this interesting too
Social listening in the real estate market
Vesteda was curious if social listening – monitoring and analysing social media discussions about a brand, competitors, products or hashtags/keywords – could add value to the organisation. To this end, we started a project that consisted of two parts: exploring possibilities for social listening in the Corporate Communication department and applying social listening in an ongoing Data Science project.
Turn (big) data into practical insights, valuable models, and automated systems.
What is the data pressure cooker?
Consultancy.nl interviewed our Alex about the data pressure cooker. We launched this new service in spring 2020. During a data pressure cooker, we spend 5 days working with an organisation's data. Based on the outcomes, the client decides whether it wants to take further steps in the field of data-driven working.
Customer Experience Optimisation
Residential investor Vesteda is working on a new website. This must offer (potential) tenants and B2B customers, such as investors and pension funds, an optimal online experience. Buyer personas of the various B2C target groups had already been developed. Together with Vesteda, we also started to map out the B2B target groups. In addition, together with the customer, we developed the optimal customer journeys for the most important buyer personas.
100+ data consultants working on your data issues
As your data partner, we help you achieve your goals step by step using data. We provide strategic advice and practical implementation. From data to action. Together with you, we map out your wishes and needs. You are then introduced to the data professionals who can help you. They can fall back on our entire team for this.