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:
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:
|
| 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. |