Verizon Connect GeoBase 4.99

Alchemy Data Import Tool

Alchemy Functions

array.add Function

array.contains Function

array.first Function

array.flatten Function

array.get_at Function

array.set_at Function

getKphSpeedCat Function

getMphSpeedCat Function

intersection Function

string.contains Function

string.endswith Function

string.split Function

string.startswith Function

string.substring Function

getMphSpeedCat Function

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

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

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

Syntax

Alchemy

Copy

getMphSpeedCat(speed);

Nomenclature

speed

Required. 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

Copy

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

getMphSpeedCat Function

Syntax

Nomenclature

Returns

Example

See Also