>From the "Topical Gazetteers" section of USGS GNIS download page <http://geonames.usgs.gov/domestic/download_data.htm>:
<http://geonames.usgs.gov/docs/stategaz/POP_PLACES_20141202.zip> is a pipe delimited file which contains city and county info. hth dt On Mon, Jan 5, 2015 at 12:54 PM, Stephen Russell <[email protected]> wrote: > Oh yeah, that second one is probably as trustworthy as SPAM in that who > will keep up on new additions or changes that you know the USPS is going to > do going forward. > > Just a heads up on the value of your data vs the cost of the data. > > On Mon, Jan 5, 2015 at 1:40 PM, Jeff Johnson <[email protected]> wrote: > >> Stephen: That second one is a great one. Thanks, >> >> >> On 1/5/2015 12:26 PM, Stephen Russell wrote: >> >>> You can get dumps from here or details about their WS. >>> >>> http://www.geonames.org/export/ >>> >>> >>> You have to put in country because the world is bigger than you are >>> thinking today. >>> >>> http://www.geonames.org/postalcode-search.html?q=38115&country=US >>> >>> >>> >>> >>> >>> >>> On Mon, Jan 5, 2015 at 1:03 PM, Jeff Johnson <[email protected]> wrote: >>> >>> That's a good one Stephen but no county. >>>> >>>> Thanks, >>>> >>>> >>>> On 1/5/2015 11:58 AM, Stephen Russell wrote: >>>> >>>> Try this: >>>>> http://ziptasticapi.com/38115 >>>>> >>>>> >>>>> >>>>> On Mon, Jan 5, 2015 at 11:45 AM, Jeff Johnson <[email protected]> wrote: >>>>> >>>>> Ken: That's a great file, but I also need cities. >>>>> >>>>>> Thanks, >>>>>> >>>>>> >>>>>> On 1/5/2015 10:33 AM, Ken McGinnis wrote: >>>>>> >>>>>> This may have what you want: >>>>>> >>>>>>> https://www.census.gov/geo/reference/codes/cou.html >>>>>>> >>>>>>> Note that each county in the us has a 'fips' code. We use it in our >>>>>>> database to track taxes. >>>>>>> >>>>>>> CA,06,081,San Mateo County,H1 is from that file. 06=California, 081= >>>>>>> San >>>>>>> Mateo County. census.gov has a lot of other information. >>>>>>> >>>>>>> >>>>>>> On 1/5/2015 8:32 AM, Ted Roche wrote: >>>>>>> >>>>>>> My favorite is "El Pueblo Nuestra Senora la Reina de los Angeles de >>>>>>> >>>>>>>> Porciuncula." >>>>>>>> >>>>>>>> Or, "L.A." for short. >>>>>>>> >>>>>>>> I don't think there is a finite list Prefixes, or Suffixes, for that >>>>>>>> matter. We have "Townships" and "Purchase" and all sorts of quirky >>>>>>>> names >>>>>>>> in >>>>>>>> New Hampshire I hadn't encountered elsewhere. "Gilmanton Ironworks" >>>>>>>> for >>>>>>>> example. >>>>>>>> >>>>>>>> I did use a commercial service when building a geo-spatial list for a >>>>>>>> client around a decade ago. They supplied name(s) -- most >>>>>>>> city/town/villages have several -- along with ZIP codes and >>>>>>>> long/lat. I >>>>>>>> think you can get SOME of that from USPS and Kevin suggests, and you >>>>>>>> might >>>>>>>> also check the U.S. Census Bureau, that has lots of stuff, much of it >>>>>>>> publicly available. >>>>>>>> >>>>>>>> OTOH, we might ask what you're up to. Rather than build local data >>>>>>>> that's >>>>>>>> likely out-of-date before you're done parsing, maybe there are >>>>>>>> already >>>>>>>> some >>>>>>>> services on the web that can supply what you're after. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Jan 5, 2015 at 10:31 AM, Jeff Johnson <[email protected]> >>>>>>>> wrote: >>>>>>>> >>>>>>>> When parsing addresses some cities can be two or three words. Has >>>>>>>> >>>>>>>> anyone >>>>>>>>> seen a list of prefixes? For example "New" in "New River" or "St." >>>>>>>>> in >>>>>>>>> "St. >>>>>>>>> Johns". >>>>>>>>> >>>>>>>>> TIA >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Jeff >>>>>>>>> >>>>>>>>> Jeff Johnson >>>>>>>>> [email protected] >>>>>>>>> SanDC, Inc. >>>>>>>>> (623) 582-0323 >>>>>>>>> SMS (602) 717-5476 >>>>>>>>> Fax 623-869-0675 >>>>>>>>> >>>>>>>>> www.san-dc.com >>>>>>>>> www.cremationtracker.com >>>>>>>>> www.agentrelationshipmanager.com >>>>>>>>> >>>>>>>>> [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/caao+qoxtfkodybam1mspmj2xr3mhwmdspnz8xnaybwmkr+t...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
