Skip to main content
Avalara Help Center

Guidelines for the AvaTax for Communications Geo Batch import template

You can process multiple records at once to geocode addresses in batch. You can import a .csv file that includes either addresses or latitude/longitude pairs. More information on how to import these files is available in the Import a file for geocoding multiple records at once guide. 

Guidelines for the Geo Batch Address template

This file can be used to determine the PCode and other useful information for a set of street addresses. Addresses must contain street number and street name. Addresses must also contain either the city/state combination or ZIP code. 

Valid examples:

  •  8675 West 96th Street, Overland Park, KS
  •  8675 West 96th Street, 66212

Input

Column Column heading Data type Use Description
A Identifier String Required A unique identifier for the address. You may use any numerical identifier you choose (e.g., customer number, account number, etc.)
B StreetAddress String Required The street address.
C City String Conditionally required

The city name.

Required if the ZIP code is not provided.

D State String Conditionally required

The two-letter ISO (International Organization for Standardization) code for the state.

Required if the ZIP code is not provided.

E Zip String Conditionally required The ZIP/postal code.

Use the:

  • Five digit ZIP Code (12345)
  • Nine digit ZIP+4 Code (12345-6789)

Required if the City and State are not provided.

 

Output

Column Column heading Data type Description
A Identifier String A unique identifier for the address. You may use any numerical identifier you choose (e.g., customer number, account number, etc.). This will match the Identifier from the input file.
B Score Double value

A percentage, represented as a decimal, indicating the accuracy of the address match in the mapping database. A higher percentage indicates a more accurate match, with 1.0 being a perfect match.

More information on the scoring process can be found in the AvaTax for Communications Geo product user manual.

C PCode Integer The Avalara PCode of the matching address.  This PCode correlates to the set of taxes that are applicable to the address.  In rare circumstances, the value of the PCode could be returned as -1, which means it is unassigned.  This could happen if there is no mapping from its FIPS Code to a PCode.  If a PCode of -1 is returned, please contact Avalara support.
D JurisdictionName String The name of the jurisdiction identified by the PCode property.
E FipsCode Long

The FIPS code (Federal Information Processing Standards) of the matching address. FIPS codes are 10 digit numbers in the format of:

SSCCCPPPPP, where SS = State Code, CCC = County Code and PPPPP = Place Code.

If the state code has a leading zero, that will be lost. If the location is in a special tax jurisdiction the FIPS code returned will be assigned by Avalara.  Any FIPS codes that start with a “99” in the state location are Avalara, Inc. codes for special tax jurisdictions. This FIPS code or the PCode can be used in the AFC software product to calculate the correct taxes for the jurisdiction.

F Unincorporated Integer Boolean indicating if the matching address is outside the city limits of a town.  When this value is returned as 0, then the location is within the city limits.  When the value is returned as 1, the location is outside the city limits. 
G County String The name of the county the matching address is within.
H Latitude Double The latitude of the matching address.
I Longitude Double The longitude of the matching address.
J StreetAddress String The street address provided in the input file.
K City String

The city name provided in the input file.

L State String The two-letter ISO (International Organization for Standardization) code for the state provided in the input file.
M Zip String The ZIP/postal code provided in the input file.
N CassAddress String The Coding Accuracy Support System (CASS) certified address.
O CassCity String The USPS preferred city name.
P CassState String The two-letter ISO (International Organization for Standardization) code for the state.
Q CassZip String

The ZIP/postal code in one of the following formats:

  • Five digit ZIP Code (12345)
  • Nine digit ZIP+4 Code (12345-6789)
R FeatureID Integer The Geographic Names Information System (GNIS) feature id is a unique, permanent geographic feature identifier assigned by the U.S. Board on Geographic Names.
S CensusTract Integer The ID of the Census Tract, which is a contiguous group of census block groups, geocoded based on census data. 
T CensusBlockGroup Integer

The ID of the individual Census Block, which is the smallest area surrounded by streets, geocoded based on census data.

Guidelines for the Geo Batch Latitude/Longitude template

This file can be used to determine the PCode and other useful information for a batch of latitude/longitude pairs.

Input

Column Column heading Data type  Use Description
A Identifier String Required A unique identifier for the latitude/longitude pair. You may use any numerical identifier you choose (e.g., customer number, account number, etc.)
B Latitude Double Required The latitude.
C Longitude Double Required

The longitude.

 

Output

Column Column heading Data type Description
A Identifier String A unique identifier for the latitude/longitude pair. You may use any numerical identifier you choose (e.g., customer number, account number, etc.)
B Latitude Double The latitude provided in the input file.
C Longitude Double The longitude provided in the input file.
D Country String The 3-letter ISO (International Organization for Standardization) code for the country.
E State String

The two-letter ISO (International Organization for Standardization) code for the state.

F City String The USPS preferred city name.
G County String The name of the county the provided coordinates are within.
H PCode Integer The Avalara PCode of the latitude/longitude pair.  This PCode correlates to the set of taxes that are applicable to the latitude/longitude pair. In rare circumstances, the value of the PCode could be returned as -1, which means it is unassigned.  This could happen if there is no mapping from its FIPS Code to a PCode.  If a PCode of -1 is returned, please contact Avalara support.
I FeatureID Integer The Geographic Names Information System (GNIS) feature id is a unique, permanent geographic feature identifier assigned by the U.S. Board on Geographic Names.

 

  • Was this article helpful?