Geocoding is the process of translating physical addresses into latitudes and longitudes in order to enable your data to be displayed and analyzed in a geographic context (on top of a map).
Content Manager enables geocoding of data with street level precision by importing a table containing addresses or by geocoding addresses manually. You load the data to be geocoded and then visualize it on top of the map.
Content manager provides the ability to reverse geocode addresses too. Reverse Geocoding is the process of translation geographic coordinates (latitudes and longitudes) into physical addresses.
Before loading the data, it is important that it contains required columns and that its structure is correct to avoid misinterpretations.
Click here to learn more about GeoAnalytics Builder geographic coverage.Before loading a Microsoft Excel file into the content manager, it is important to make sure required columns are available. In order to geocode data properly, the following columns are required: Name, City, Zip Code, Country.
To get better geocoding precision, you may want to have additional data columns: Address, State.
It is important the data spreadsheet is free from irrelevant information and has a good structure to prevent misinterpretation. Possible action that can be done before importing data is removing contextual information.
The tabular format of the data in an Excel spreadsheet will be represented as a data table in the content manager. The first row with data in the spreadsheet will be interpreted as names of the data columns in the table, and the following row will be interpreted as data rows.
The following illustration shows a spreadsheet containing some contextual information above the actual data table. This will cause misinterpretation of the data.
You can geocode addresses from data files that are saved locally on you computer. Geocodes can be retrieved from addresses contained in a Microsoft Excel spreadsheet, or you can geocode addresses entered manually as well. Imported .xls or .xlsx files are geocoded automatically. The imported data is geocoded automatically and can then be visualized in a geographic context in order to assess the geographic quality of your data.
Tip: To interpret an Excel worksheet correctly, you may need to make some data preparation before loading it.
Procedure
You can reverse geocode latitude and longitudes coordinates from data files that are saved locally on your computer. Physical addresses can be retrieved from geographic coordinates contained in a Microsoft Excel spreadsheet.
Tip: To interpret an Excel worksheet correctly, you may need to make some data preparation before loading it.
Procedure