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!
Exciting news for Snowflake users! As part of our commitment to enabling geospatial analysis natively within the cloud, today we are announcing the launch of our Spatial Ex...News
The demands on Spatial Data Scientists and Developers to produce ever more complex data visualizations and geospatial apps within shorter timeframes are constantly increasi...News
Last year, Google Cloud announced a new initiative bring partner solutions to the network edge, enabling a wide range of clients in industries such as CPG, Retail, and Manu...News
Please fill out the below form and we'll be in touch real soon.