Input Record Format - 23.1

Spectrum Global Geocoding Guide

Product type
Software
Portfolio
Locate
Product family
Spectrum
Product
Spectrum > Geocoding > Global Geocoding
Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Global Geocoding Guide
Topic type
Installation
Overview
How Do I
Reference
Configuration
Copyright
2023
First publish date
2007
ft:lastEdition
2024-02-17
ft:lastPublication
2024-02-17T09:43:31.076389

The Enterprise Designer specifies the allowable input file formats for the type of dataflow in use. Typically, the dataflow would read the input record as either a text, database or XML file. Each of these input file types have specific format requirements which are covered in detail in the Spectrum Technology Platform Dataflow Designer's Guide. For instance, for an input text file, the guide covers the permitted record types, character encoding, field separators, etc.

The following are a couple of example input record text files. These example input records contain an optional header line, as well as optional input fields.

Example Geocoding Input Record

The following is an example text input record file with USA addresses.
mainAddress;areaName3;areaName1;postalCode;country
26 EDISON DR;NISKAYUNA;NY;12309;USA
92 MCCRACKEN RD;MILLBURY;MA;01527;USA
22 CARRIAGE LN;NEWARK;DE;19711;USA
8 HARBOR VIEW RD; S BURLINGTON;VT;05403;USA
124 VERNON RD;GREENVILLE;PA;16125;USA
31 FORD ST;MAUMEE;OH;43537;USA
155 WINTER ST;S WALPOLE;MA;02071;USA 

Example Reverse Geocoding Input Record

The following is an example text input record file with input coordinates.
X|Y|Country
-72.672229|42.076406|USA
-82.436915|34.870463|USA
-95.7849|42.1603|USA
-113.532|53.5421|CAN
-71.2577|46.8461|CAN
-115.423|32.6561|MEX 

Example Address Autocomplete Input Record

The following is an example text input record file.
MainAddressLine;AreaName1;AreaName3;PostCode1;County;Country;OriginX;OriginY
ABBOTSFIELD;;Toronto;;;;;
札幌市中央;;;;;;;
Broadway;;;;;; -74.00218;40.719025      

Example KeyLookup Input Record

The following is an example text input record file.
Key;KeyType;Country
P0000GL5UVYI; PB_KEY;USA
P0000GL41OME;PB_KEY;USA
GASA_422263850; GNAF_PID;AUS
GANSW705177946;GNAF_PID;AUS