A Calustra - Eloy Coto Pereiro Home About Books

Unlocking Fiber Deployment in the town council: A Citizen's Journey of Using Data


European Union is pushing some money to all countries to develop infrastructure for the regions. The kind of infrastructure does not matter, and the regions ask for their needs. One of the biggest for many town councils in my area is deploying FFTH to all homes, but as normal, some issues are in place.

I knew about these public funds! And I also knew that some telecoms operators where I live got money to connect thousands of homes to FFTH. Sadly, time passed, and I didn't see any development, so I started to get suspicious that the funds were not reaching the right place. So over the years, I shared this information with all political parties to make them aware; some of them supervised it others said I was lying. A few months ago, the new mayor called me asking for help, so I decided to help to execute and supervise these public funds.

After our first call with the Telecoms Operators, the information could have been more transparent, so one of the first goals was to know if all the houses they said have FFTH connections were correct or not, and validate their data with mine.

To achieve this goal, I took advantage of two sources of truth:

All houses' directions: In Spain, there is a way to register the houses to the govt(Catastro), so each plot has a reference number, and you know the direction and coordinates of that house. I ended up mapping thousands of house directions in simple GeoJson files.

Real internet connection: This is easy to do if you can ask the operator if you have coverage. One of the landing pages out there has a way to know if you have fiber connection, so it was easy to scrape all the council house directions and, from there, map true/false.

Having this info allowed the mayor to have a lot of information; at the same time, in April'22 we sent all the directions that were not with FFTH coverage to the Spanish government to be able to receive funds to cover during the following years.

During the following months, we learnt that each Wednesday, they updated the coverage so that we could track the progress weekly. Because we have all this information, we can chase them, follow the process and unlock the issues.

In the end, during 2022, we ended with more than 1500 houses with FFTH, and more than 240 with deployment-ready, but with license issues with Spanish Govt for the interconnection, a minor thing that should be finished in the coming weeks.

Over this time, I learned a lot of things:

Overall, I'm super happy to do this pro-bono project. Over the years, I had this problem, and I needed to work with a crappy 4G connection. I learnt how difficult it is to deal with the town council, government, and telecoms operator, and not only having the data but also helping the telecoms unlock their deployments. It makes me happy the public funds reach almost all people and make a difference in how the town council tackle issues with data, so it has been an excellent experience for me.


Related articles: