Removing records based on a suppression file in StreetSweeper Pro
A suppression file can be used to identify and remove records from a Project.
Products affected: StreetSweeper® Pro
A suppression file can be used to identify and remove records from a Project. Criteria used to determine if a record matches one in the suppression file is set by the user.
To use suppression files, you must merge them into your Project. Please review Merging Two or More Databases.
- Select Address Tools > Purge & Suppression.
- Check the fields that will be used by the application to match records to those in the suppression file. By default, Address Line 1, Address Line 2, Province, and Postal Code are checked. These can be removed if address fields will not be used to match records.
- Select the options that will be used to identify matches:
- If fields must match exactly, select Exact Match on Name.
- If fields must be close but not an exact match to be identified as a duplicate, select Near Match on Name.
- If rural postal codes and rural route addresses should not be identified as duplicates, check this box. This is helpful if the Project contains a high number of RR or GD addresses rather than civic-style addresses.
- Select how results are handled by checking the appropriate Result Options.
- To have suppression results display on a separate screen after processing is finished, select Display results when complete.
- To automatically delete records that are to be suppressed, select Remove marked items from database.
- To create an export file with suppressed records, select Export marked items from database.
- To print the suppression report, select Print report.
- The final file merged into a Project is the default suppression file. To change this file, select the Change Suppression File button, identify the correct file, and click the Select button.
- When you have completed setting your options, select OK to start the suppression process. The suppression file will be automatically removed from your Project after processing.
- If you have additional suppression files, repeat the process from step 2 for each suppression file.
After the suppression process is complete, you will be returned to the main dashboard. The database view will be filtered to show only suppressed records.
UPDATED: 01 October 2024