Hey! This content applies only to previous CARTO products

Please check if it's relevant to your use case. On October 2021 we released a new version of our platform.
You can learn more and read the latest documentation at docs.carto.com

Questions / Working with Data / SQL

I cannot geocode my country names dataset, although my column only has very few unique values

Learn a workaround to geocode more than 500 rows of country names with SQL and Builder analysis.

CARTO country geocoder analysis has a 500 rows limit. If your dataset has more than 500 rows but very few unique country name values there is a workaround for your use case:

Create a master table with unique country names

Open the original dataset and switch to SQL mode
Run the following query:

SELECT DISTINCT country FROM table

Create a new dataset from this query
Create a new map with the original dataset and the new one
Geocode the new dataset using Builder geocoding analysis
Add the geometries from this geocoded layer to the original dataset using Builder Add columns from second dataset analysis