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?