Downloadable Boundary Database Files and Instructions

Download Boundary Databases By Individual County or By State.


Downloading Boundary Databases
The Streamlined Sales Tax Project (SSTP) compliant boundary database (file) is available for the entire State of Ohio.  The database is comprised of three record types; 9-digit ZIP Code, 5-digit ZIP Code and address level.

Download File Format
The structure and data elements of each record type (9-digit ZIP, 5-digit ZIP and Address level) are the same. However, the record types will not necessarily have data in each field.  The following table illustrates the table structure and shows which fields are available in each record type. All data elements, including those that are null (no value), are required and have been included in the boundary database. A placeholder (comma) is included for null data elements.

Data Element Field Address Level ZIP+4 Level 5-digit ZIP Level Description Address Level Example
1 Record Type Must equal "A" Must equal "4" Must equal "Z" Indicates format of record. A - Address
4 - Zip + 4
Z - Zip
2 Beginning Effective Date Required Required Required Date in CCYYMMDD format. Indicates the beginning date the table should be used to retrieve address boundary data. 20040101
3 Ending Effective Date Required Required Required Date in CCYYMMDD format. Indicates the last date the table should be used to retrieve address boundary data. 20040331
4 Low Address Range Required Null Null This field is used for two types of address data. For street addresses, it contains the low address range of the street address(s). For PO Boxes, it contains the low end of a range of PO Box number(s). 19
5 High Address Range Required Null Null This field is used for two types of address data. For street addresses, it contains the high address range of the street address(s). For PO Boxes, it contains the high end of a range of PO Box number(s). 99
6 Odd/Even Range Indicator Dependent Null Null Indicates if the given range of address(s) is odd or even. Null for PO Boxes. (E = Even, O = Odd) O
7 Street Pre-Directional Abbreviation Dependent Null Null Indicates pre-directional information for street addresses. May be null if unknown. Null for PO Boxes. (N = North, S = South, etc.) S
8 Street Name Required Null Null Name of Street HIGH
9 Street Suffix Abbreviation Dependent Null Null Indicates the type of street. (ST = Street, AVE = Avenue, etc.) ST
10 Street Post Directional Optional - present if exists Null Null Indicates post-directional information for street addresses. May be null if unknown. Null for PO Boxes. (N = North, S = South, etc.  
11 Address Secondary Optional - present if exists Null Null  
12 Address Secondary Low Optional - present if exists Null Null    
13 Address Secondary High Optional - present if exists Null Null    
14 Address Secondary Odd/Even Range Indicator Optional - present if exists Null Null    
15 City Name Required Null Null Name of city. COLUMBUS
16 ZIP Code Required Null Null 5-digit ZIP Code 43215
17 Plus 4 Required Null Null 4-digit ZIP Code 6108
18 ZIP Code Low Null Required Required Low range for a 5-digit ZIP Code
20 ZIP Extension Low Null Required Null Low range for a 4-digit ZIP extension  
19 ZIP Code High Null Required Required High range for a 5-digit ZIP Code  
21 ZIP Extension High Null Required Null High range for a 4-digit ZIP extension  
22 Composite SER Code Null (for OH) Null (for OH) Null (for OH) If present, indicates the state is a composite state and that the vendor is to report the individual tax rates under the composite code.  
23 FIPS State Code Required Required Required State FIPS code (See FIPS Codes below) 39
24 FIPS State Indicator Optional Optional Optional Equal to state FIPS code if state tax applies. Equal to "00" if state tax rate does not apply 049
25 FIPS County Code Required Required Required County FIPS code (See FIPS Codes below) 049
26 FIPS Place (Municipality Code) Optional – present if within Municipality Optional – present if within Municipality Optional – present if within Municipality Municipality FIPS code (See FIPS Codes below) 18000
27 FIPS Place Class Code Optional Optional Optional Place Class FIPS code  
28 Longitude Data Null Null Null Expressed as a coordinate in decimal degrees.  
29 Latitude Data Null Null Null Expressed as a coordinate in decimal degrees.  
30 Special Tax District Code Source #1       Source of Special Jurisdiction. (ST = State) ST
31 Special Tax District Code #1       Special tax district number. This number represents transit districts and is assigned by the Ohio Department of Taxation. 25000
32 Type of Taxing Authority Code #1 Used when a state has special taxing jurisdictions.  
... ...  
87 Special Tax District Code Source #20 Source of Special Jurisdiction. (ST = State)  
88 Special Tax District Code #20 Special tax district number. This number represents transit districts and is assigned by the Ohio Department of Taxation.  
89 Type of Taxing Authority Code #20 Used when a state has special taxing jurisdictions.  


Example of Boundary Database
4,20040901,20041231,,,,,,,,,,,,,,,43002,43002,0000,0145,,39,39,049,,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
4,20040901,20041231,,,,,,,,,,,,,,,43002,43002,0151,0175,,39,39,049,,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
4,20040901,20041231,,,,,,,,,,,,,,,43002,43002,0181,0236,,39,39,049,,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
4,20040901,20041231,,,,,,,,,,,,,,,43002,43002,0241,0296,,39,39,049,,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
4,20040201,20041231,,,,,,,,,,,,,,,43002,43002,0301,0476,,39,39,049,,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Z,20040901,20041231,,,,,,,,,,,,,,,43002,43002,,,,39,39,049,,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Z,20040901,20041231,,,,,,,,,,,,,,,43004,43004,,,,39,39,049,,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Z,20040901,20041231,,,,,,,,,,,,,,,43016,43016,,,,39,39,049,,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Z,20040901,20041231,,,,,,,,,,,,,,,43017,43017,,,,39,39,049,,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Z,20040901,20041231,,,,,,,,,,,,,,,43026,43026,,,,39,39,049,,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
A,20040901,20041231,1,43,O,E,10TH,AVE,,,,,,Columbus,43201,2111,,,,,,39,39,049,18000,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
A,20040901,20041231,2,28,E,E,10TH,AVE,,,,,,Columbus,43201,2198,,,,,,39,39,049,18000,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
A,20040901,20041231,2700,2752,E,E,10TH,AVE,,,,,,Columbus,43219,2202,,,,,,39,39,049,18000,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
A,20040901,20041231,2701,2751,O,E,10TH,AVE,,,,,,Columbus,43219,2201,,,,,,39,39,049,18000,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
A,20040901,20041231,2753,2799,O,E,10TH,AVE,,,,,,Columbus,43219,3795,,,,,,39,39,049,18000,,,,ST,25000,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,


FIPS Codes
Federal information processing standards codes (FIPS codes) are a standardized set of numeric or alphabetic codes issued by the National Institute of Standards and Technology (NIST) to ensure uniform identification of geographic entities. FIPS codes are used heavily by federal, state, regional and local government. The entities covered include: states and statistically equivalent entities, counties and statistically equivalent entities, named populated and related location entities (such as city, places and county subdivisions).

A FIPS Code is used to associate each boundary to the corresponding tax rates. More information on FIPS Codes is available at
the  NIST   website.

Ohio FIPS Codes
The FIPS Code for the State of Ohio is 39.  County and Municipality FIPS Codes can be downloaded by clicking on the links below. These comma delimited test files (.csv) contain the FIPS Codes for Ohio counties and municipalities.

Download County FIPS Codes
Download Municipal FIPS Codes
Download Transit FIPS Place Codes

Download Boundary Databases By Individual County or By State.