Import places file formatting

Custom Place files can be imported into ContentTools as a .csv or .txt file. Files must contain a list of Places with descriptive fields separated by a delimiter (Comma, Tab, or Pipe "|"). Places can also be imported using our Places APIs.

The import file must include a Place Name and either address information or latitude and longitude coordinates. All other fields are optional. If you do not include a field, empty pipes must be included in your .txt file as placeholders.

The fields should be listed in the following order:

Place Name (Required)

  • Max character count = 320

  • The name need not be unique

  • Can contain alphanumeric and special characters except comma, tab, and pipe

Place ID (Optional)

  • Max character count = 24

  • The name must be unique. (If a previously used name is entered, a notification will appear stating the ID is not available.)

  • Can contain alphanumeric and special characters

Latitude (Optional if Address Information is provided)

  • Latitude (in decimal degrees format): must be a number from -90 to +90. (South latitudes are represented by a minus sign).

Longitude (Optional if Address Information is provided)

  • Longitude (in decimal degrees format): must be a number from -180 to +180. (West longitudes are represented by a minus sign).

Address Information (Optional if Latitude/Longitude is provided)

  • Street Address (Optional)

    • Can contain alphanumeric and special characters except comma, tab, and pipe

    • Max character count = 100

  • City (Required)

    • Can contain alphanumeric and special characters except comma, tab, and pipe

    • Max character count = 100

  • State (Required)

    • Must be a two-letter abbreviation.

  • Zip Code (Required)

    • Can contain alphanumeric and special characters except comma, tab, and pipe

    • Max character count = 25

  • Country (Optional)

  • If both address and lat/long are in the import file, then the location will be plotted using the lat/long.

  • If only address is present in the import file, then the address will be used to geocode and find the coordinates for the Place. The Place is then plotted using the coordinates.

  • If only coordinates are present in the import file, then the place is plotted using the lat/long. No reverse geocoding will be performed to identify the address of the place.

Phone Number (Optional)

  • Can contain alphanumeric and special characters except comma, tab, and pipe

  • Max character count = 15

Comments (Optional)

  • Can contain alphanumeric and special characters except comma, tab, and pipe

  • Max character count = 250

Site Name (Optional)

  • Max character count = 100

  • Name need not be unique

  • Can contain alphanumeric and special characters except slash (/), backslash (\), or caret (^) characters

Site Shape Points (Optional)

  • Shape points are lat/lons (see format above) delimited by the pipe character (|). Each point is a lat/lon separated by one comma (,).

  • At least three shape points are required.

Site Gates (Optional)

Gates are first delimited by the caret character (^). For each gate, the fields are separated by pipes again (|). The fields are, in order:

  • Coords (actual physical location; location within the Site) - Required

  • SnapCoords (location on the road; gate entrance connecting road to Site) - Required

  • Type (0 for Entry, 1 for Exit, 2 for Entry/Exit) - Required

  • AutoRestricted (1 for true; anything else for false [typically 0]) - Required

  • TruckRestricted (1 for true; anything else for false [typically 0]) - Required

  • Gate Note (string, with ^, |, and \ characters each escaped with preceding backslash \ character) - Optional

Site Gates are optional but, if passed, all above required fields except for the Gate Note must be populated.

Gate Paths cannot be imported.

Site Notes

Notes the driver can review at any point during a trip:

  • Max character count = 1000

  • Can contain alphanumeric and special characters except slash (/), backslash (\), or caret (^) characters