Depending on the types of data you are licensed to use with your PC*Miler Web Services Spreadsheets API key, you can enter origins and destinations in the ways described below. When entering a location, specify the region of the world and the country for best results when PC*Miler searches for a matching location.
Region Codes are NA (North America), EU (Europe), AS (Asia), AF (Africa), SA (South America), OC (Oceania), MX (Mexico), ME (Middle East), and WW (Worldwide).
The country codes in each region are available here.
In this article
- Cities
- ZIP/Postal codes
- Latitude/longitude points
- Latitude/longitude points with street addresses
- Street address with city/state
- SPLC
- Custom Places
- Tips on searches
Cities
For cities, it's best to enter a combination of:
- A city, state and ZIP in the U.S. and Mexico.
- A city, province and postal code in Canada.
- A city, country, and postal code in Europe.
Examples
U.S.
Princeton, NJ 08540
Canada
Toronto, ON M4B 1B7
Europe
Bonn, DE 53113
Learn more about postal code formats.
Mexico
Cancun, QR 77500
Learn more about entering Mexican Postal Codes.
ZIP/Postal codes
ZIP/postal codes can be entered without a city name as long as you specify the country where the code is located.
U.S.
08540, US
Canada
M4B 1B7, CA
Europe
30453, DE
Learn more about postal code formats.
Mexico
77500, MX
Learn more about entering Mexican Postal Codes.
Latitude/longitude points
Latitude/longitude points can be entered in decimal degrees (i.e. 40.297222,74.358611) without a city name as long as you specify the country where the code is located.
An example in Kendall Park, NJ:
40.420833,74.561111
An example in Kassel, Germany:
51.315960,9.506306
Latitude/longitude points with street addresses
This functionality geocode the lat/long to the nearest point on the street in the address, rather than to the nearest street in the direction of travel, as would be the case for a lat/long by itself.
The lat/long is added before the address, followed by a semicolon. An example is:
40.211670,74.703480;1200 Kuser Road
Street address with city
If you also include a place name, the street addresses MUST be separated from the preceding place name by a semicolon.
Am Prime-Parc 11, 65479 Raunheim
Trimble Germany; Am Prime-Parc 11, 65479 Raunheim
1 Independence Way, Princeton 08540
Trimble New Jersey; 1 Independence Way, Princeton 08540
SPLC
A nine-digit Standard Point Location Code can be entered if you are licensed for that data.
191690000
Custom Places
Custom Places created in Content Tools can be entered as stops.
Tips on searches
If you find you are getting an Invalid Location Error when entering locations, we recommend that you:
- Use the country and the region settings to avoid ambiguity between postal codes or cities that exist in multiple countries.
- Avoid abbreviations as they can be ambiguous.
- If you are still getting an errors, try our single search test page to diagnose issues with your input.