Upload/Return File Instructions

Uploading Municipal Address Database
Rates and jurisdictions provided through this upload are subject to revision on a calendar year basis. Submitted files must be in comma delimited text format (.CSV) with no header row and with the following fields in the order specified in the Upload File Format description below. Note: The Address, City, Zip Code, and Month/Year fields are required and must contain valid alpha/numeric text. If the field is optional, you may leave that field blank in your file, but you need to account for the field in the comma delimited format. If you have any questions concerning the Upload File Format, please review the sample file at the bottom of this page.

Upload File Format
The structure of the upload file is as follows:

Field Name Description Format Length
User # * Optional User Record ID alpha/numeric 15
Address ** Street Name and Number alpha/numeric 61
Suite Suite, P.O. Box, Apt, Lot alpha/numeric 61
City ** City Name alpha 29
State State Abbreviation (OH only) alpha 2
Zip Code ** 5-digit Zip Code numeric 5
Zip Plus Zip+4 Extension numeric 4
Month/Year ** MM/YYYY Format numeric 7
* The User # field in the file format pertains to the record number in which you identify this address on your system.
** Address, City, Zip Code, and Month/Year fields are required.
  Month/Year cannot be before 01/2003 and cannot be in the future.
Retrieving Updated Municipal Address Database
Following your submission, please check the Upload/Return File Status Page . This page will display the status of your submissions and upon completion of the batch processing, your return file(s) will be available to download. The last 2 submissions will always be available for re-download. Each retrieval will consist of two downloadable files named "{user_id}_{job_id}MTAR.csv" and "{user_id}_{job_id}MTAE.csv" where {user_id} represents the numeric identity of your online user account and {job_id} corresponds to the sequential Upload Job ID of your file at the time of submission.

Results File Format
The structure of the results file is as follows:

Field Name Description Format Length
User # Optional User Record ID alpha/numeric 15
Reference # Reference ID for the specific transaction (9999-9999999999) alpha/numeric 15
Address USPS Standardized Address Line 1 alpha/numeric 61
Suite USPS Standardized Address Line 2 alpha/numeric 61
City USPS Standardized City Name alpha 29
State State Abbreviation alpha 2
Zip Code USPS Standardized 5-digit Zip Code numeric 5
Zip Plus USPS Standardized Zip+4 Extension numeric 4
Month/Year MM/YYYY Format numeric 7
County Name Name of the county in which the address is located. alpha 20
Municipality Name Name of the municipality in which the address is located. alpha 20
Municipal FIPS Code Municipal FIPS Code. numeric 5
Municipal Income Tax Rate Municipal Income Tax Rate (9.9999) numeric 6
Date Processed MM/DD/YYYY Format numeric 10

Error File Format
The structure of the error file is as follows:

Field Name Description Format Length
User # Optional User Record ID alpha/numeric n/a
Reference # Reference ID for the specific transaction (9999-999999999) alpha/numeric 15
Address Street Name and Number alpha/numeric 61
Suite Suite, P.O. Box, Apt, Lot alpha/numeric 61
City City Name alpha 29
State State Abbreviation alpha 2
Zip Code 5-digit Zip Code numeric 5
Zip Plus Zip+4 Extension numeric 4
Month/Year MM/YYYY Format numeric 7
Result Type Error Match Code alpha/numeric 4

Error Codes

Error Match Code Description
E010 Required fields were not provided.
E011 Input zip code was not in Ohio.
E012 City was not found.
E020 Could not locate matching street.
E022 Could not locate this street number.
E023 Match is unresolved.
E024 Could not locate this street number.
E027 Could not match directional information.
E030 Invalid month/year.
E033 Address found was not in Ohio.
E034 Required fields were not provided.
E035 Invalid input state (OH only).


Examples Files

Sample Upload File
1,1615 GARFIELD AVE,,ASHLAND,OH,44805,,01/2004
2,7137 MARTIN RD,,WEST SALEM,OH,44287,,12/2003
3,5002 N MYERS RD,,GENEVA,OH,44041,,4/2004
4,6698 DEERVIEW DR,,LOVELAND,OH,45140,,7/2002
5,6702 US 20,,METAMORA,OH,43540,,8/2004
6,2383 RT 61 S,,NORWALK,OH,44857,,11/2003
7,13834 FANCHER RD,,JOHNSTOWN,OH,43031,,2/2004
8,29761 STANLEY RD,,NEW MARSHFIELD,OH,45766,,6/2002
9,4454 WING VIEW LN,,KETTERING,OH,45429,,4/2004
10,9439 MEADOWTRAIL CT,,LOVELAND,OH,45140,,12/2003

Sample Results File
1,1104-4384,1615 GARFIELD AVE, ,ASHLAND,OH,44805,3549,1/2004,ASHLAND,ASHLAND,02568,0.015,11/18/2004
2,1104-4385,7137 MARTIN RD, ,WEST SALEM,OH,44287,9065,12/2003,WAYNE,,,0,11/18/2004
3,1104-4386,5002 N MYERS RD, ,GENEVA,OH,44041,7704,4/2004,ASHTABULA,,,0,11/18/2004
4,1104-4387,6698 DEERVIEW DR, ,LOVELAND,OH,45140,5919,7/2002,CLERMONT,,,0,11/18/2004
5,1104-4388,6702 US HIGHWAY 20, ,METAMORA,OH,43540,9739,8/2004,FULTON,,,0,11/18/2004
6,1104-4389,2383 STATE ROUTE 61, ,NORWALK,OH,44857,9183,11/2003,HURON,,,0,11/18/2004
7,1104-4390,13834 FANCHER RD, ,JOHNSTOWN,OH,43031,8129,2/2004,LICKING,,,0,11/18/2004
8,1104-4391,29761 STANLEY RD, ,NEW MARSHFIELD,OH,45766,8903,6/2002,VINTON,,,0,11/18/2004
9,1104-4392,4454 WING VIEW LN, ,KETTERING,OH,45429,3102,4/2004,MONTGOMERY,KETTERING,40040,0.0175,11/18/2004

Sample Error File
10,1104-4393,9439 MEADOWTRAIL CT, ,LOVELAND,OH,45140, ,12/2003,E022


Upload your Municipal Address File