To have a unique id for each house is neat but I think there are loads of situations you’d have to account for so that there isn’t any ambiguity in the assignment of unique ids. If any ambiguities exist inevitably you will have exceptions in the system which defeats the point. For example -Subdivision of a lot. -Joining of lots. -You said every house… what about two houses on the same lot? -What about apartments buildings? -What happens when one or more houses are demolished and an apartment building goes up? Etc etc

I work in manufacturing and this sounds a lot like the problem of part numbering, and let me tell you, it’s not a trivial problem and the company I work for thought it was and got it wrong.