Map File Structure

Field

Data Type

Definition

Required

Used for Geocoding

Name

String

Person's name, name of a feature, name of a place

Yes

Address

String

Street address, e.g., 1600 Pennsylvania Ave.

Yes

City

String

State

String

2 character state abbreviation (e.g., VA, CO, MT)

Zip Code

String

Notes

String

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.

Accuracy_Type

String

Indicates where the point of the latitude/longitude is. It is an indicator of accuracy. See the definitions below.

Group

String

Groups of similar points or points near each other.

Stop

Number (integer)

The order of the points or addresses within each group.

Required Fields = No: 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.

Hint: Export a file from the map to see its structure and use that file for your data.

Accuracy Type

Accuracy_Type

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

Step by Step

Prepare a spreadsheet (CSV or .xlsx) with one row per address, using the structure displayed above.

Upload the file (Choose the File button followed by Upload Spreadsheet button) and the map will display (if the data passes the QC step)

If your file is missing latitude and longitude, the app will geocode addresses for signed-in users. Guests can still upload and preview data but geocoding will be disabled.

If validation fails, fix the file locally and re-upload. The app displays helpful errors and example fixes.

Mapping Routes

Follow the steps below to upload data, clean it, then adjust routes and map the data.

Pick a sample dataset to load and view on the map.

Sources: Top 100 Mountains | National Parks (US) | Largest Lakes by Volume | Largest Lakes by Depth

Status of Data

Data Status: TBD