Sometimes datasets don’t contain any geospatial columns, but they have names, IP addresses, zip codes, or other information that can be translated into coordinates. CartoDB is able to assist you with this type of data.
When you import a dataset into your CartoDB account, an algorithm looks for data that can be transformed into coordinates (country names, city names, IP addresses, etc.). If there is a low number of duplicate rows and a big enough sample, the algorithm transforms the data for you and pins it on your map. As simple as that—you don’t need to move a finger.
There are some cases where, for whatever reason, CartoDB cannot georeference your dataset automatically. But don’t panic if this happens—we’ve rebuilt our georeferencing UI so it’s more accessible than ever.
If you’d like your data to be geocoded to administrative regions, zip codes, place names, or even convert IP addresses into locations around the world, you just need to follow the instructions on the UI and give the CartoDB algorithm some hints about how to interpret the data.
And if you’d like to transform address information into coordinates, you can do this, as well. Using our high-resolution geocoder you can convert address information into high-resolution Lat. Long. at a low cost: just $15 per 1,000 rows.
Happy data mapping!
Having brought together more than 12,000 experts online in 2020 & 2021, we’re beyond excited to host our long awaited, in-person Spatial Data Science Conference in Lond...
NewsWe’re thrilled to announce we will be attending, sponsoring and presenting at Snowflake Summit 2022 taking place June 13-16 in Las Vegas, Nevada!
NewsWithin the last few years, Spain has been focused on increasing electric vehicle incentives and production; and in 2021, Spain announced that they planned to invest 4.3 bil...
NewsPlease fill out the below form and we'll be in touch real soon.