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!
Today, at the Spatial Data Science Conference, we presented the recently launched Data Observatory 2.0 (DO). A new platform to discover and consume location data for spatia...News
Data is an essential ingredient for spatial analysis—which is predicated on access to your own data, plus useful third-party data. In the end, spatial analysis is about put...News
The 3rd annual Spatial Data Science Conference is just three weeks away and we couldn’t be more excited. Being held at Columbia University, this year’s iteration of the for...News
Please fill out the below form and we'll be in touch real soon.