Georeferencing is a CARTO service that gathers location data, from many different sources, to get the geographical coordinates associated with latitude/longitude columns, city names, postal codes, administrative boundaries, IP addresses, or street addresses. Since CARTO uses coordinates to plot data, the more finite your data (such as an address), the better your results (versus a city name).
The Georeference analysis in CARTO Builder enables you to generate location coordinates directly from a map layer. For this guide, let's convert the location of Paris addresses by latitude and longitude.
We will use the location of Paris addresses, provided by openaddresses.io. This example displays the intense flooding that occurred in Paris; similar to the flood that occurred in 1910. The data is derived from Open Data of Paris, and the results are applied as point coordinates.
Import the template .carto file, packaged from "Download resources" of this guide and create the map. Builder opens with Paris data as the first map layer, Natural_water as the second map layer, and Flood_zone as the third map layer.
Notice that the Paris map layer does not identify what type of geometry the data contains.
Switch to the Data View of the Paris map layer and you will notice that there are various columns with address information.
Since the original data is in French, the translation of languages may complicate the geocoding of data. We will use the
lat columns from our dataset to georeference all of the geometry coordinates.
Click the ANALYSIS tab to add an analysis to the Paris map layer.
Select Georeference from the Add a new analysis options.
Keep Longitude and Latitude selected as the Georeference TYPE.
You must enter the LATITUDE and LONGITUDE parameters before applying the analysis. For this example, select the lat and lon columns from the Paris dataset.
Click APPLY. The analysis confirmation dialog appears, which you can use to apply styling.
Click STYLE THIS ANALYSIS to visually enhance the buildings within the flood-zone.
Optionally, download the final .carto file from the "Download resources" of this guide to see the styling options that were applied.
The analysis geocoded the Paris data into point geometries, and the Georeference analysis is linked to the map layer. You can continue to explore the point geometry data for Paris.
If you are a developer and have access to the CARTO Engine's to manage your data, view the Geocoding Functions that can be applied with the Data Services API.
We would love to hear from you! Was it easy to understand? Do you need more information? Let us know.