CARTO User Manual

CARTO User Manual

Geocoding data

Two types of geocoding are available: address-level geocoding, which transforms a given address into its corresponding point location, and latitude/longitude geocoding, which converts a pair of latitude and longitude coordinates into a point geometry.

To geocode your data, select a connection and click on the table you would like to geocode from the collapsible tree. Then, click on the Geocode data button at the top right of the screen. Please note that this option will only be available if your table does not have a geography column.

Data Explorer geocode data

A new dialog will open for you to choose whether to geocode your table by address or by latitude/longitude.

Data Explorer geocode data

By address

To geocode your data, select geocode by Address and fill in the options:

  • select the column of your table that contains the addresses to geocode.
  • optionally, select the country where your addresses are located. This is recommended as it generally improves the geocoding results.
  • optionally, specify the name of the geometry column (geom by default) where the result of the geocoding will be stored.

Data Explorer geocode data

Then, click on Continue. A new dialog will appear allowing you to confirm your selection. Click on the Geocode button to confirm or click Cancel to abort the process.

Data Explorer geocode data

As a result of the geocoding process, two new columns will be added to your existing table: a geometry column with the locations of your addresses, and a carto_geocode_metadata column with additional information regarding the geocoding results.

By latitude / longitude

To geocode your data, select geocode by Address and fill in the options:

  • select the columns of your table where the latitude and longitude coordinates are stored.
  • optionally, specify the name of the geometry column (geom by default) where the result of the geocoding will be stored.

Data Explorer geocode data

Then, click on Continue. A new dialog will appear allowing you to confirm your selection. Click on the Geocode button to confirm or click Cancel to abort the process.

Data Explorer geocode data

As a result of the geocoding process, a new geometry column will be added to your existing table containing the points corresponding to your latitude/longitude coordinates.