I am trying to join the OS Building Heights CSV file with the OS MasterMap Topography Layer. They have both been paid / they are NOT the free OS data and so definitely include the data I need. This is in order to create a building height plan of my study area.
Having googled it numerous times, I am under the impression that I need to join the TOID field in the OS MasterMap Topo layer with the equivalent number in, what is called, 'field 1' of the building heights CSV file.
Problem is... when they join, all the 'new' fields which have been joined all say 'NULL'. An example of the number in 'field 1' is osgb1000002107214922 and an example of a number in TOID is 0001000034928367. So the Building Heights CSV file displays 'osgb' before the number and the OS Topo does not.
There is far too much data to go through and add in/remove the 'osgb', so does anyone have any other solutions or know where on earth I am going wrong?
Or could explain to me how to join these datasets in QGIS?