Show all categories
Data mapping

Feature available on Personal and Professional plans

Current limits

Personal Plan - up to 1,000 (thousand) addresses per month

Professional Plan - up to 10,000 (ten thousand) addresses per month

🌎 📍

With this feature you will be able to enter address bases as points on the map:

Understand how Mapping happens

Our planet was cut into quadrants by horizontal lines, parallels, or latitude and vertical lines, meridians, or longitude.

Lat and Long for the intimate ones.

This cutout simplifies the identification of points on the Earth's surface and it is with it that we are going to work.

IBGE

⚠️

The process is subtle, so be careful to avoid errors.

For everything to go well you must have a complete list of address data to map.

There are two possible paths:

  1. You have a full address base
  2. Do you have a base that has already gone through the mapping process
Examples of tables

1 - Base not yet mapped

In the first option all address details are mandatory (in black) and the latitude and longitude (geographical coordinates) are optional (green), while fields that are not related to the mapping can be ignored (Jump option)

Required fields:

  1. Name
  2. Street
  3. Number
  4. District
  5. Postal Code
  6. town
  7. State
  8. Country

2 - Pre-mapped base

In the second option, the base has already undergone a mapping process in another system, also known as geocoding, so the geographical coordinates are filled in in their decimal format.

Decimal format of Lat and Long

The number of digits increases accuracy

Even on already mapped bases, the fields of Name and Street remain mandatory (in black) to identify the point on the map.

Required fields:

  1. Name
  2. Street
  3. Latitude
  4. Longitude

This table with addresses or geographical coordinates must be exported from Excel, Google Sheets or any other spreadsheet system, in CSV format (Comma Separated Values or Comma Separated Values).

In practice, the spreadsheet will be transformed into a text document, where commas play the role of columns.

⚠️

CSV is the most commonly used format for importing tables, but it's not error-free.

Mapfry is prepared to recognize the most common patterns.

If the field assignment step presents a result like the one below, you are probably trying to import a CSV file in a format that does not comply with the standards currently recognized by the platform.

As a contour path, we recommend that you open your file in Google Drive as a Google Sheets sheet and download it as a CSV from there.

CSV separated by semicolons

Importing databases to the Mapfry platform

You now find the “My Data” option in the Layers modal:

Click “Add data”

New “My Data” option

Select the CSV file that will be imported

Upload the file

The system will perform a diagnosis for errors in your file

Errors make it impossible to map data and must be corrected or deleted from the original table.

Error diagnosis

Indicate what addressing information each column refers to

This information will be used to assign the points to the map.

Associating address fields

Voilà

Your data is ready to be viewed on the map!

Select your data layer

It's seeing is believing

Now you have the privileged view of your points in contrast to market data.

Example of visualizing points on the map

Data points and layers

⚠️

Questions, suggestions, and errors: hello@mapfry.com

Rate 👇

Did this article help you?