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

getKphSpeedCat Function

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

The getKphSpeedCat function returns the appropriate SPEED_CAT value for a given speed (specified in kilometers 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

getKphSpeedCat(speed);

Nomenclature

speed

Required. Road-speed, in kilometers per hour.

Returns

The corresponding SPEED_CAT value for the given speed.

Example

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

Alchemy

Copy

IMPORT STREETS [
  ...
  speed_cat = getKphSpeedCat(%legal_speed_kph),
  ...
]

getKphSpeedCat Function

Syntax

Nomenclature

Returns

Example

See Also