tGeocoder Table

Stores the geocode resources available in Touchstone.

The premium geocodes obtained by licensing this feature are restricted for use only within Touchstone and cannot be used outside of Touchstone. These are identified by the GeocoderCode = 'Syncsort' column in Touchstone AIRExposure, AIRReference and AIRResults databases. For the Export feature, these premium geocodes are either encrypted or removed during export to comply with these contractual restrictions. Direct extracts of premium geocodes from the Touchstone databases are also contractually prohibited.

Creation Date	2/16/2011 6:00 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	6
Data Space Used	8.00 KB
Index Space Used	8.00 KB

Column Name	Description	Datatype	Length
GeocoderCode	Code that represents the geocode resource. Geo = AIRGeography RMS = RMS SYNCSORT = Syncsort TIG = Tiger TOM = TOMTOM TRI = Trillium UN = Unknown The premium geocodes obtained by licensing this feature are restricted for use only within Touchstone and cannot be used outside of Touchstone. These are identified by the GeocoderCode = 'Syncsort' column in Touchstone AIRExposure, AIRReference and AIRResults databases. For the Export feature, these premium geocodes are either encrypted or removed during export to comply with these contractual restrictions. Direct extracts of premium geocodes from the Touchstone databases are also contractually prohibited.	varchar	10
Geocoder	Name of the geocode resource. Corresponds to the code in GeocodeCode.	varchar	40
Description	Description of the geocode resource.	varchar	1024

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

GeocoderCode

Code that represents the geocode resource.

Geo = AIRGeography
RMS = RMS
SYNCSORT = Syncsort
TIG = Tiger
TOM = TOMTOM
TRI = Trillium
UN = Unknown

The premium geocodes obtained by licensing this feature are restricted for use only within Touchstone and cannot be used outside of Touchstone. These are identified by the GeocoderCode = 'Syncsort' column in Touchstone AIRExposure, AIRReference and AIRResults databases. For the Export feature, these premium geocodes are either encrypted or removed during export to comply with these contractual restrictions. Direct extracts of premium geocodes from the Touchstone databases are also contractually prohibited.

varchar

10

Geocoder

Name of the geocode resource.

Corresponds to the code in GeocodeCode.

varchar

40

Description

Description of the geocode resource.

varchar

1024

Related Objects

AIRReference Database