I used to work mapping in EMS. It is absolutely not that simple, nor will it ever be. Yes, Google was often wrong. Sometimes I would drive out to a street to make sure I had not lost my mind.

Sometimes, the local addressing authority was wrong, and I would have to prove it to them. "But it was checked!" It was checked wrong. Street numbers would be off by thousands. It would take some pointing out of obvious problems in the progression of numbers, plus a plat, plus an email from the building manager to prove to them that I knew what I was talking about.

I was contacted by a woman who kept having drivers for all kinds of services attempt to use her driveway as a street, even if she had a sign up, which she did. Her local municipality was no help. Nobody was. She was irked and frantic, as these trucks would destroy her driveway, lawn, even garden.

Much digging ensued. It turned out that the proximal source of the error was a statewide system, one of many which Google simply hoovers up and digests like a baleen whale siphoning up plankton, then digests and tries to "make work." I got the proximal source to make a correction, which they might publish in another three months. The original source of the error was a long-missing minor street from many decades ago, which I had to find in caches of searches and the like.

It was idle curiosity, but it took me about twenty hours of digging on evenings and weekends.

Address points are easy. Parcels, aka the polygons upon which zero to many address points might rest, are harder. Road networks are terrifically hard. I managed to catalog ten different cases of road discontinuity in the process of trying to find such things in an automatic fashion. And I might not be bright enough to have enumerated them all!

And then we have cases of people who deliberately insist that their address number is "00." As in the first two-thirds of a certain not-so-secret agent's code number. Or imagine the fools who decide to put up a sign at the end of their long driveway and simply declare that it was a road.

Each county has its own addressing standards, and included in each are addresses from the Olden Days, real wild west stuff, which the authorities are just itching to scrape out of their systems once and for all.

Road addressing is Fractally Bad.