This content applies to a previous version of CARTO

In October 2021 we released a new version of our platform. You can find the latest documentation at docs.carto.com

Back to Help Center

Geocoding Country Names with Row Limitations

Overview

CARTO’s country geocoder analysis has a 500-row limitation. However, if your dataset contains more than 500 rows but features only a small number of distinct country names, there’s a workaround available.

Solution

Create a master table with unique country names

  1. Open your original dataset and switch to SQL mode
  2. Execute this query:
    SELECT DISTINCT country FROM table
  3. Generate a new dataset from this query result
  4. Create a new map containing both the original dataset and the newly created one
  5. Use Builder geocoding analysis to geocode the new dataset
  6. Employ the “Add columns from second dataset” Builder analysis to transfer geometries from the geocoded layer back to your original dataset

This approach bypasses the row limitation by reducing the dataset to unique values before geocoding, then joining the results back to your full dataset.