We all know the statistic that 80% of all information is spatial, but I guess like most people I’m not clear where that particular figure has come from, and thinking about it.. I not convinced it is actually true. There is much information held in databases around the world which is about activities which happen at specific locations, but as much as 80% ?
Another much repeated statistic is that Ordnance Survey makes 5000 changes to the national geospatial database every day – this time however, although I’m not sure where the statistic came from, I can put more accurate figures in place.
As part of the development of a new Oracle Spatial database system, we have looked at the number of transactions going through the database in order to scale the system, a 10 node RAC cluster by the way ..
In general day to day operations the OS actually makes between 30-50,000 changes per day, representing the modification of existing features in the database and the addition of new features into the landscape, things like new housing estates.
Over the past few years however a larger than average amount of change has been happening as a result of the Positional Accuracy Improvement Programme, resulting in peaks of 500,000 changes in a day !!
These figures sound a lot especially compared to the often stated 5,000 changes a day, but you need to remember the database contains around a billion individual features.
We really did need a new database !!!
Written and submitted from home, using my home 802.11 network.