473,244 Members | 1,322 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,244 software developers and data experts.

Any hints for converting from ZIP to ZIP+4 for a street address?

Does anyone have an idea on how to find ZIP+4 codes?


a d y k e s @ p a n i x . c o m

Don't blame me. I voted for Gore.
Jul 29 '05 #1
1 2233
>Does anyone have an idea on how to find ZIP+4 codes?

The TIGER data from the Census bureau contains a *LOT* of data.
(If only there was a good way of getting useful information out of
it.) For each *block*, you get info like street name, range of
street numbers, Zip+4 on each side, lat/long coordinates of each
endpoint of the block, and possibly some points in the middle if
it's not straight. It does not, however, try to give street number
ranges that are actually used (e.g. my block is 1200-1298, which
doesn't say that the house at the end of the block is 1232 and
there's no room for 1234-1298). The schema involves lots of big
numbers that are only unique on a per-county basis.

Assuming, for example, that you can match the street address to
a specific block (given that there may be multiple Elm Streets
in nearby towns, and possibly even in the same town, and you may have
to deal with Elm Street, Elm Road, Elm Boulevard, Elm Freeway,
Elm Lake, Elm River, and Elm Memorial Garbage Dump), you could
get the Zip+4. Some of this might be narrowed down with the
5-digit Zip if that was known.

Warning: as I recall, this data takes up more than one DVD and
it's heavily compressed. Putting it in database tables would expand
it a lot.

Oh, yes, I'm also not sure about how accurate the data is or how
up-to-date it is. Also, the data only attempts to include Zip+4
that represent *street* addresses. Zip+4 allocated to banks of
P.O. boxes in a post office aren't included.

Gordon L. Burditt
Jul 29 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Sugapablo | last post by:
I have a database table that contains street addresses in the following format: 123 Any St. 456 Some Rd. 7789 That Blvd. etc. I.e. Street number, street name, standard abbriviation of road...
by: wolftor | last post by:
Does anyone know how to create a query that will separate the street number from the street name? Eg. current address field = 14 Main Street, unit 4 but I want to get: streetno = 14...
by: news1.sympatico.ca | last post by:
I have a single column list in the following format: John Smith 123 Anystreet Anytown, state zip Tel: 333-555-1212 Fax: 333-555-2121 Dave Jones 321 Main Street
by: Raphi | last post by:
Hi, I'm trying to clean up a large database in Access. I have one field for address, which needs to be broken up into Street Number, Street Name, and Street Label (St., Road, etc.) The...
by: Tom Warren | last post by:
About once a year or so for the last 10 years, I update my street address parser and I'm starting to look at it again. This parser splits a street address line into its smallest common elements...
by: Robert Fitzpatrick | last post by:
Thanks to some help here on the list, I've been able to get addresses sorting pretty well, but now I have a issue with same addresses on different streets not grouping the streets. This is what I'm...
by: sridev | last post by:
hi all, i have a xml file.I have converted the xml file to String using OuterXml....... now i am getting like this "<ClientList><Client...
by: HowHow | last post by:
Using Access 2000. I need to group the address by suburb then by street name in my report. Two major problems here: 1. Unit number has the word "Unit" before number 2. Semi detach house has "a"...
by: rob41 | last post by:
I'm in the process of converting numerous queries from access 07 to sql server 05 to improve runtime performance. Below is a sample of code and the error I'm getting. INSERT INTO ( , , ,...
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.