Available Functions for Processing Data During Loads

The table lists functions available for transforming field values when loading data into the Trapeze4 map database.

Table 1. Processing Functions
Function	Description
A+N_ZipCode	Saves an alphanumeric ZIP code/postal code in the MapZip table. Also assigns a Zip ID and stores it in the MapSeg table.
ALPHA_Place	Saves a place name in the MapPlc table. Also assigns an ID and stores it in the MapSeg table.
ALPHA_State	Saves a state name in the MapPlc table. Also assigns an ID and stores it in the MapSeg table.
ALPHA_StatePlace	Saves a state name and place name in the MapPlc table. Also assigns IDs and stores them in the MapSeg table using the formula: stateId*100000+placeID. Arguments must be provided in this order.
ArcInfoPointCoordinate	Saves a longitude or latitude value from an ArcInfo shape file. The coordinate has to be in Decimal Degrees (45.348889). From the ArcInfo columns list, select [Lon] or [Lat].
DecimalDeg2Long	Converts a longitude or latitude string in decimal degrees into long format, with six implied decimal places.
DegMinSec	Converts a longitude or latitude string in degrees, minutes, and seconds (for example, 45 20 56) into decimal degrees (for example, 45.348889). Only one character can appear between numbers.
FillCountyMcdField	Combines a county code with an MCD code using the following formula: county*100000+MCD. Arguments must be provided in this order. Use this function when state and place codes are provided in separate columns.
FillStatePlaceField	Combines a state code with a place code using the following formula: state*100000+place. Arguments must be provided in this order. Use this function when state and place codes are provided in separate columns.
IncrementID	Increments an ID by 1. Use this function when a Trapeze column is set as an index. From the Imported Columns list, select [Id].
ParseStreetName	Parses full street names into four parts: direction prefix, name, type, and direction suffix.
RecSourceSeaId	Records the unique source ID and a corresponding segment ID in the mapSourceRef table.
StreetAliasZlevel	Reads the unique source ID and FromZLevel or ToZLevel value, and creates a mapAlias record if the ZLevel value is -9.
TurnRestrictionsNev TechZLevel	Reads the FromZLevel or ToZLevel from NavTeq data and, depending on the values, creates a record in the mapTurnRestrictions table.
TurnRestrictionsTele AtlasZLevel	Reads the FromZLevel or ToZLevel from TeleAtlas data and, depending on the values, creates a record in the mapTurnRestrictions table.