How does the system geo-pin locations in Tab 6 of CDIF if address fields are incorrect or incomplete (e.g., city entered as state, missing postal code, duplicate city names)?

• When location data is uploaded in Tab 6 (CDIF), the system does not validate the semantic correctness of individual address fields before geo-pinning. Instead, it combines all available address components into a single string and sends it to Google’s Geocoding API to determine the latitude and longitude.
• How the Address Is Processed:
• The system concatenates address fields in the following order:

                Street Address 1 + Street Address 2 + City + State + Postal Code + Country

• This combined string is sent to Google for geo-pinning.
• Scenario Clarifications
  1. If City Name Is Entered in the State Field (or vice versa):
     • The system does not block the upload.
     • It does not validate whether the City and State values are logically correct.
     • As long as the Country is valid, Google attempts to interpret the full address string and return the best possible match.
     • Accuracy depends on the completeness and correctness of other address components.
  2. If Multiple Cities Share the Same Name:

• When multiple possible matches exist (e.g., duplicate city names within a country), the system relies entirely on Google’s response.
• If multiple results are returned, the system selects the match based on location_type priority, in this order:
  1. ROOFTOP (highest precision)
  2. RANGE_INTERPOLATED
  3. GEOMETRIC_CENTER
  4. APPROXIMATE (lowest precision)
  5. If more than one result has the same highest priority (e.g., multiple ROOFTOP matches), the system selects the first result returned by the API.
• 
  
  1. If Postal Code Is Missing:
     • The system still proceeds with geo-pinning using available fields.
     • Precision may be reduced.
     • The returned coordinates may point to:
       1. A city center
       2. A broader geographic area
     • In some cases, Google may derive and return a postal code even if it was not provided in the upload.
  2. If Country Field Is Incorrect (e.g., Country Entered as State Name):
     • The Country field is critical for accurate geocoding.
     • If Country is incorrect or misplaced, geo-pinning accuracy may significantly degrade.
     • Google will attempt interpretation, but results may not match the intended location.

Example

• For the address:

Multi Packaging Solutions
16 EAST PARK ROAD
LEICESTER
England
 GB

• Google returned a ROOFTOP-level match and geo-pinned it as:
  1.  Park Rd, Leicester LE5 4QA, UK

• Best Practice Recommendations to ensure accurate geo-pinning:
  • Always provide a correct Country
  • Include Postal Code whenever available
  • Ensure City and State are entered in appropriate fields
  • Provide complete street-level details
  • Review locations that appear less precise after upload

Incomplete or incorrectly structured addresses increase ambiguity, especially when duplicate city names exist.