Match Abbreviations, Strip Punctuation and Excess White Space in Addresses When Validating
When validating student addresses, the difference between St. Maria and St Maria can cause it to fail. The same with the difference between Av, Ave, and Avenue. All mean the same thing, but if the street table only contains one variation then only that one variation will pass validation. The street address parser could be much more intelligent, checking if the final 'word' in the student and street table addresses match any of a set of known street type variations and then validating true if both are in the same class of street type
Winston
shared this idea
-
bubailey
commented
Please adjust the Streets table / Address Verification process to understand that "Street" and "St" are the same!
The Streets table validation process does not work through common abbreviations. It believes "742 Evergreen Terrace" is a different place from "742 Evergreen Terr." and this causes serious confusion for our families and enrollment staff.
