Calculating the closest target postal code using manual entry in StreetSweeper Pro
If you have multiple target postal codes, Geosmart will calculate the closest of those postal codes for each record in your database. You can use this information to determine the closest target postal code for each record and to select records that fall within a prescribed distance from the closest target postal code.
Products affected: StreetSweeper® Pro
If you have multiple target postal codes, Geosmart will calculate the closest of those postal codes for each record in your database. You can use this information to determine the closest target postal code for each record and to select records that fall within a prescribed distance from the closest target postal code.
- For the most accurate results, it is recommended that you run Correction/Validation or Validation on your database prior to adding location data.
- Select Address Tools > Geosmart.
- Select Create a distance list.
- Enter the first postal code in the box below Postal Code. Select Add to list. The postal code will appear in the viewing box on the right.
- Continue adding additional postal codes. If you make an error, select the postal code from the viewing box and select Remove from list.
- When all postal codes have been added, select Process.
- StreetSweeper Pro will return to the Database View during and after processing. To view results, scroll to the right of the database until you see the fields GEO_NEARESTPC and GEO_DISTANCE. The GEO_NEARESTPC field will display the closest of the target postal codes to the record. GEO_DISTANCE field is the calculated distance, in kilometers, between the record and that target postal code.
- You can specify the maximum and minimum distances of your export file by selecting File > Export File and entering in these distances where indicated.
UPDATED: 04 January 2024