2 ms·
How was the DB structured? For example was "brown house down from church" in some sort of structured field ("Address 1") or more open ended? What if the brown h
by dmix 9y ago
How was the DB structured? For example was "brown house down from church" in some sort of structured field ("Address 1") or more open ended? What if the brown house was painted red, could those with local knowledge update it in a timely way?
And why would Canada Post need your data? Was it just a typical slow moving state enterprise or did you guys just do a better job? They likely had many decades more experience than your company...
- grecy 9y agoThis was all in a commercial off-the-shelf provisioning tool that probably every telco in North America uses, so the database was very structured. There were forced fields like "address line 1", "Address line 2", and our staff had just forced in whatever would go. Updating it was certainly possible, though I don't think much effort was being made. In those communities we probably had less than 50 unique addresses, in some other places we have tens of thousands. Canada Post had no info on these communities, and they decided ours was better than nothing. Remember, we are talking extremely, extremely remote villages in the Arctic Circle, many of which are fly in only (no roads).