[asterisk-biz] NPA-NXX to City, State Database

[Alex Balashov]

www.localcallingguide.com is great, but you can't internalise the 
database, just use it on a per-incident basis really.  Unless you want to 
work out some sort of deal with them to batch queries to their XML query
interface as part of an OSS system I suppose.

On Thu, 31 Jan 2008, Peter Beckman wrote:

> OK, So I have the LERG.  It's ugly.  NWYRCYZN02 is not pretty.  Neither is
> "NEW YORK METRO NY".  Some entries state "BROOKLYN" or "QUEENS" or
> something else.  I want an NPA-NXX database that corresponds to a valid
> USPS City, State.
>
> What do YOU use to tell your customers who do not understand what a rate
> center is WHERE a DID/DDI is "located?"  Is there a database other than the
> LERG you rely on?  Who has the best and most accurate data?  _IS_ there a
> source of accurate data?
>
> The biggest problem I have is that for large metro areas, New York, NY for
> example, it covers a lot of territory. If "Bronx, NY" is a valid city,
> state combo for the USPS, it's good for me.  But there is no Queens, NY
> that I can find.  Queens is a county, (queens village and queensbury, ny do
> exist), but not a city like Bronx.
>
> Did you know that Manhattan, NY and Queens, NY do NOT exist according to
> the USPS, but Staten Island, Bronx and Brooklyn, NY do?  Talk about
> confusion.
>
> Beckman
> ---------------------------------------------------------------------------
> Peter Beckman                                                  Internet Guy
> beckman at angryox.com                                 http://www.angryox.com/
> ---------------------------------------------------------------------------
>
> _______________________________________________
> --Bandwidth and Colocation Provided by http://www.api-digital.com--
>
> asterisk-biz mailing list
> To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-biz
>

--
Alex Balashov
Evariste Systems
Web    : http://www.evaristesys.com/
Tel    : +1-678-954-0670
Direct : +1-678-954-0671