Metadata: Created November 2024, product PAC Classic
Overview
Correctly formatting addresses is crucial for accurate legislator matching in Quorum. This guide provides practical steps and standard rules to ensure addresses are properly formatted, leading to improved zip code matching and accurate legislator association.
Correctly Formatting Addresses
Importance of Proper Formatting
- Ensures accurate zip code calculation and legislator matching.
- Prevents errors in data processing and enhances data integrity.
Steps to Fix Address Formatting
Step 1: Enable Zip+4 Option
- Turn on zip+4 option during data import to ensure accurate zip code calculation.
Step 2: Utilize Google Maps and USPS.com
- Use Google Maps and USPS.com to verify and correct address formatting.
- Follow standard rules for address abbreviations and punctuation.
Standard Rules to Follow
- Abbreviate directional indicators (North, South, East, West) properly (e.g., N, S, E, W, NW, NE, SW, SE).
- Remove unnecessary quotes or parenthesis around letter streets.
- Minimize punctuation usage, except for specific cases like hyphenated address ranges or fractional addresses.
Examples of Bad Address Formatting
- North Abbreviation Issue:
- Bad Example: 123 No 114 St, Omaha, NE 68154
- Good Example: 123 N 114th St, Omaha, NE 68154
- Abbreviation and Capitalization Issue:
- Bad Example: 1400 N. IH35 Frontage Rd., Austin, TX 78701
- Good Example: 1400 N INTERSTATE 35, AUSTIN TX 78701
- Abbreviation and Directional Issue:
- Bad Example: 69008 Hwy 190 E Serv Rd, Covington, LA 70433
- Good Example: 69008 Highway 190 Service Rd, Covington, LA 70433
- Abbreviation and Floor Detail Issue:
- Bad Example: 395 W12th Avenue- 7th Floor, Columbus, OH 43210
- Good Example: 395 W 12th Avenue, 7th Floor, Columbus, OH 43210
- Misspelling Issue:
- Bad Example: 22221 N Pepper Rooad, Lake Barrington, IL 60010
- Good Example: 22221 N Pepper Road, Lake Barrington, IL 60010
How to Search for Non-Zip Matched Records
- Utilize advanced search functionality in Quorum to identify records with formatting issues.
- Create and save lists for records that need address corrections.
Final Recommendations
- Address formatting is crucial for accurate data processing and legislator matching.
- Use external resources and adhere to USPS standards for proper address formatting.
- Collaborate with stakeholders to ensure data accuracy and consistency.
Notes:
- Proper address formatting is essential for accurate legislator matching and data integrity.
- Regular maintenance and verification of addresses are necessary to prevent errors and ensure data accuracy.
- Training and guidelines should be provided to staff members responsible for entering or importing data into Quorum.