Our CAD (computer aided dispatch) system places prefixes for streets at the end of the street name which is fine if that is where they belong. However, the Post Office prefers the prefixes to be in their proper place. There is a difference between N Main St and Main St N. In our area, some older communities have two addresses that differ only by their prefix. For example, 100 W Main St and 100 E Main St. Several communities also have streets that encompass the town center in circular form. The only way to know where a store is located is to refer to the NE, NW, SE or SW designation. Maybe natives of the area have some innate sense of where they need to go, but I have spent a great deal of time literally going in circles to find an address.
I have noticed that our county property tax database is set up the same way, so I imagine that the data from CAD may have originated from the county geo records. No matter what the source was, when we extract the data for alarm calls, it comes into our system the way it appears in CAD. This wouldn't be a problem except the Post Office prefers the prefixes to be in their proper place.
Our unit has routinely changed the addresses in accounts to meet postal standards. Unfortunately, this has occasionally led to duplicate accounts being created since CryWolf® can't match streets that have the prefixes in different spots. To solve this problem, I have decided that we will no longer change the addresses but will use the street name as it appears in CAD for the main account address. We will, however, change the address in the responsible party section to meet postal standards. Since this is the address that shows in the envelope window, it should be a good compromise. This seems like a great plan moving forward, but I needed to deal with all of the data already in CryWolf®. Fortunately, I know that CryWolf® doesn't edit the responsible party section streets when you use the tools in Maintenance, and I discovered the Change Street Names function was the best way to update the streets for this project. To edit streets, follow the directions below.
On the general tab, scroll down to Reassignments, and then over and down to Change Street Names.
This opens the Unique Streets pop up box.
I have noticed that our county property tax database is set up the same way, so I imagine that the data from CAD may have originated from the county geo records. No matter what the source was, when we extract the data for alarm calls, it comes into our system the way it appears in CAD. This wouldn't be a problem except the Post Office prefers the prefixes to be in their proper place.
Our unit has routinely changed the addresses in accounts to meet postal standards. Unfortunately, this has occasionally led to duplicate accounts being created since CryWolf® can't match streets that have the prefixes in different spots. To solve this problem, I have decided that we will no longer change the addresses but will use the street name as it appears in CAD for the main account address. We will, however, change the address in the responsible party section to meet postal standards. Since this is the address that shows in the envelope window, it should be a good compromise. This seems like a great plan moving forward, but I needed to deal with all of the data already in CryWolf®. Fortunately, I know that CryWolf® doesn't edit the responsible party section streets when you use the tools in Maintenance, and I discovered the Change Street Names function was the best way to update the streets for this project. To edit streets, follow the directions below.
On the general tab, scroll down to Reassignments, and then over and down to Change Street Names.
This opens the Unique Streets pop up box.
In the example below, I searched for streets that begin with W for West.
To edit, simply click on the street name. This will open the Change Street Name pop up box. Type in the street name as you would like it to appear.
Click OK and the change has been made.
Have fun using this function, and share ways that you have used it in your unit.
Comments
Post a Comment
Thanks for stopping by my little piece of the web. I look forward to reading what you have to say!