bit off topic: street name database US

[rcamarda]

I'm thinking of doing some basic parsing of address. I want to seprate
out the house number from the street name from the suffix. I have the
suffix's from the USPS, but I cant find a database of US street names.
Anyone come across one or know where I can get one?
TIA
Rob
/end off topic

[Brian Cryer]

Re: bit off topic: street name database US

"rcamarda" <rcamarda@cable speed.com> wrote in message
news:1127439693 .974508.70290@o 13g2000cwo.goog legroups.com...[color=blue]
> I'm thinking of doing some basic parsing of address. I want to seprate
> out the house number from the street name from the suffix. I have the
> suffix's from the USPS, but I cant find a database of US street names.
> Anyone come across one or know where I can get one?
> TIA
> Rob
> /end off topic[/color]

Its probably not in a convenient format, but you could try parsing
streetnames from TIGER data - www.census.gov/geo/www/tiger/index.html. TIGER
data is used by a lot of applications and is free. They might do a separate
street name download, but I couldn't get to the site when I tried just now
to look.

Hope this is useful.
--
Brian Cryer

https://www.cryer.co.uk/brian

[rcamarda]

Re: bit off topic: street name database US

Brian,
That did the trick, thanks! I found the detail files in Tiger located
here: http://www.census.gov/geo/www/tiger/...tgr2004se.html
I used GETRIGHT to download all the zip files (over 1,600). There is a
ton of data that I dont need, ill just use SQL to keep the unique
street names. I plan to get all the unique street names and all the
street suffixes. If anyone is interested in the data when I'm done,
post and I'll send you the info.

After I get all the text data loaded, my next step will be parse out
the addresses, so I'm sure I'll be posting in this group again!

Cheers,
Rob