IMPORT TMC Statement

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

This statement allows for the loading of TMC (Traffic Message Channel) codes for street links.

Syntax

Alchemy

IMPORT TMC [ID = %id_col, TMCCODE = %tmc_col] FROM "path\src_file" WHERE condition;

Nomenclature

id_col	The street link ID.
tmc_col	The TMC code.
path\src_file	Specifies the path and file containing the GIS shapefile data.
condition	A logic expression that is satisfied by a subset of the data in path\src_file. This expression, along with the WHERE keyword, is optional.

Example

The following example imports TMC codes from a table. The (fictional) table has a column street_id that contains unique IDs of street links and a column tmc that contains the TMC codes.

Alchemy

Copy

IMPORT TMC [
  ID = %street_id,
  TMCCODE = %tmc
] FROM "tmccodes";

Column Names

The following GBFS columns are available for population through the Alchemy IMPORT TMC command.

Column	Description	Type	Length	Values
ID	The street link ID	Number	Must fit in 64-bits
TMCCODE	The TMC code	Text	Variable