The database is a mess and it is not coming from us. The geoaddress layer from the county has set up abbv such as ST, AVE, LN, etc. From the database, some addresses are mix such as LANE, STREET, ST, LN, and so on. I believe I have seen some kind of scripts somewhere here that could identify and replace the database into abbv. like automate. Where is the documentation for this? Thank you.