View Entering Latitude and Longitude in a Fare File
Entering Latitude and Longitude in a Fare File
This article describes how (and why) to add Latitude and Longitude values to a fare file to improve accuracy of mapping pickup and drop off locations.
Hudson Reservation and Dispatching systems have long been integrated with mapping application(s) allowing agents and dispatchers to view client pickup and drop off locations on a map. Most mapping locations will "read" the address that is entered in a reservation and display it properly. From time to time, through no bug or problem with Hudson’s applications, a 3rd party mapping application will inaccurately display the location of a city or town. The mapping application will look at the city/town in the reservation record, will also look at street address, state and even zip code when trying to look up and display a location. If the mapping application does not or can not find a valid match (even though there may be nothing wrong with the address in the reservation) it can display the pickup or drop off location in the incorrect place - often in an entirely different state or part of the country.
If this occurs for any locations that are contained in your fare file(s), it is possible to enter the Latitude and Longitude coordinates for that location (if known), into the fare record. When this information exists in the fare file, it indicates to the mapping program that the city / town / location should be plotted at the specified coordinates, and should not be looked up in the mapping database.
To add the Latitude and Longitude into the Fare table
- Open your primary fare table or the fare table for your principal airport.
- Identify the location(s) that typically map incorrectly
- Across from this location, find the column labeled "Location Map Info"
- Enter the data in the format <Latitude>,<Longitude>
- Latitude is often written in three different formats:
- Degrees Minutes Seconds (48o 36’ 12")
- Degrees Decimal Minutes (48o 36.12’)
- Degrees Decimal Degrees (48.3612o)
- It is this LAST format that must be used when adding latitude and longitude data to a fare table, though the " o " symbol is omitted.
- About latitude and longitude
Latitude measures how far north or south of the Equator a place is located. The Equator is situated at 0°, the North Pole at 90° north (or simply 90°, since a positive latitude number implies north), and the South Pole at 90° south (or –90°). Latitude measurements range from 0° to (+/-)90°.
Longitude measures how far east or west of the Prime Meridian a place is located. The Prime Meridian runs through Greenwich, England. Longitude is measured in terms of east, implied by a positive number, or west, implied by a negative number. Longitude measurements range from 0° to (+/-)180°. (From Microsoft Map Point Help file).
- There are numerous sources for latitude and longitude data, including Microsoft MapPoint.
- Sample airport locations that are expressed in correct Latitude, Longitude Format are provided for example purposes:
- BOS: 42.36405,-71.01018
- ORD: 41.98029,-87.90461
- LAX: 33.94273,-118.40940
(HWeb 1.89f, (3147))