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

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.