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/CAJidMY+LT1AoMdfBXZquZK2rb9UVEuC5gt=ghR+tB=evvoy...@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.

