The Map Help page
Instructions and tips on how to use the map features.
To do
File Structure
Your spreadsheet should have these columns:| Field | Data Type | Definition | Required | Used for Geocoding |
|---|---|---|---|---|
| Name | String | Person's name, name of a feature, name of a place | No | Yes |
| Address | String | Street address, e.g., 1600 Pennsylvania Ave. | No | Yes |
| City | String | No | ||
| State | String | 2 character state abbreviation (e.g., VA, CO, MT) | No | |
| Zip Code | String | No | ||
| Notes | String | No | ||
| Latitude | Number | If you do not fill this in, you are logged in, and have appropriate permissions, the program will determine it using Address, City, State | Yes | |
| Longitude | Number | If you do not fill this in, you are logged in, and have appropriate permissions, the program will determine it using Address, City, State | Yes | |
| Accuracy | Number | From Geocodio: Each geocoded result from Geocodio is returned with an accuracy score, which is a decimal number ranging from 0.00 to 1.00. This score is generated by the internal Geocodio engine based on how accurate the result is believed to be. The higher the score, the better the result. | No | |
| Accuracy_Type | String | Indicates where the point of the latitude/longitude is. It is an indicator of accuracy. See the definitions below. | No | |
| Group | String | Groups of similar points or points near each other. | No | |
| Stop | Number (integer) | The order of the points or addresses within each group. | No |
Accuracy_Type
Value Description
rooftop The exact point was found with rooftop level accuracy
point The exact point was found from address range interpolation where the range contained a single point
range_interpolation The point was found by performing address range interpolation
nearest_rooftop_match The exact house number was not found, so a close, neighboring house number was used instead
intersection The result is an intersection between two streets
street_center The result is a geocoded street centroid
place The point is a city/town/place zip code centroid
county The point is a county centroid
state The point is a state centroid
If you do not have these fields in your spreadsheet, the program will add them.
Name can be a person's name, the name of a feature, the name of a place (e.g., The Grand Canyon), or anything you want it to be.
Export file from map to see structure, use that file for your data.
Geocoding
Accuracy number and accuracy type
other things
Using the Map App --- Summary from Copilot
This page explains how to load data, inspect it, and display it on the interactive map. The Map app accepts CSV or Excel files and can geocode addresses when latitude/longitude are not provided (geocoding is available for signed-in users).
Quick Overview
- Prepare a spreadsheet (CSV or .xlsx) with one row per address.
- Upload the file and the map will display (if the data passes the QC step)
Preparing your spreadsheet
The app expects columns that identify locations. Recommended columns:
| Column | Type / Notes |
|---|---|
address | Street address or free-form address text (required if lat/lon not provided). |
city | Optional — helps geocoding accuracy. |
state | Optional — helps geocoding accuracy. |
postal_code | Optional. |
latitude / longitude | Optional — if present, the app uses these directly and skips geocoding. |
group | Optional — used to create a layer or group of pins on the map. |
label | Optional — text that will appear in popups. |
If validation fails, fix the file locally and re-upload. The app displays helpful errors and example fixes.
Upload and map data
- Go to the Maps page and click Upload
Customizing Routes
- Click a pin to open a popup that lets you edit row details.
Built-in example datasets
Use the example datasets (available in the UI) to explore the map without uploading.
Searching and filtering
The Search view provides instant filtering:
- Type one or more search words — words are combined with AND logic.
- Click a result to open the corresponding pin on the map and edit the entry.
Exporting data
Export options are available from the UI:
- CSV — strips HTML from notes and exports columns.
- Excel (.xlsx) — styled workbook with headers and timestamps.
Geocoding behavior
- If
latitudeandlongitudeare present, the app uses them directly. - When lat/lon are missing, signed-in users are geocoded using a geocoding provider.