Click or drag to resize

getMphSpeedCat Function

Verizon Connect Logo
Print this page
Learn more about Verizon Connect GeoBase.
Get information about the latest release
getMphSpeedCat Function

The getMphSpeedCat function returns the appropriate SPEED_CAT value for a given speed (specified in miles per hour).

Tip Tip

It's recommended that you use this function to populate the SPEED_CAT column of an IMPORT STREETS statement.

Syntax

Alchemy
getMphSpeedCat(speed);

Nomenclature

speedRequired. Road-speed, in miles per hour.

Returns

The corresponding SPEED_CAT value for the given speed.

Example

In the following example the getMphSpeedCat function is used in conjunction with an IMPORT STREETS statement to populate the SPEED_CAT column.

Alchemy
IMPORT STREETS [
  ...
  speed_cat = getMphSpeedCat(%legal_speed_mph),
  ...
]

See Also