Telco System Database Structure & Background Information

Sample Boundary Map for Torrance CA. Telco and Cable Service Area

SoftMedia’s Telco System Database Group is comprised of (5) individual database group;

1.    TeleCom2008 - Database - 5,804 Records      Product Code 201
 
The Telecom 2008 database is a detailed database of Telephone Companies and includes complete
  contact data with management, telephone, addresses and emails. Each record provides data on 
  service type including those providing cable television service.   

2.      Lata2008- Database - 124,169 Records            Product Code 202
A LATA is a geographical area in which the local telephone company is allowed to carry local and long distance toll calls. The LATA boundary is the point where your call is handed off from your local carrier to your long-distance company. These areas were defined at Divestiture, when Judge Greene broke up the AT&T monopoly in 1984. The companies LATA database goes far beyond data provided by others and 
includes NPA (Area Code), NXX (Prefix), Zip Code, City, State, and LATA Number.
SoftMedia's LATA2008 database can be imported into most mapping software programs so that you can create your own unique LATA Maps. 

3.      Telephone2008- Database - 193,938 Records            Product Code 203
The Telco2008 is the most complete set of data currently available for the Industry. With over 193,000 records the Telco2008 database list 25 datafields for all combinations of NPA/NXX/Zip Codes. Each 5 digit zip code covers all NXX codes for Wireless, PCS and Wireline operators. 

 4.      TelephoneCable2008- Database - 193,938 Records            Product Code 204
       Th
TelephoneCable database includes all of the data available in Telephone2008, Plus it includes the
       Systemname of the Cable Operator and the number of Subscribers, House-Hold by 5 digit zip code.
       You can view Telephone Cable data by area code, prefix, house-holds, cable franchise, digital service, 
       Internet, Telco service providers or hundreds of combinations. 
      
This new version of has an additional data field called ‘COMMALIAS’. This datafield is the    
       community alias name  As an example; Most of the Primary zip codes have the same name in large
       cities such as Los Angeles or New York. The community alias is the alias name given to small
       communities within the large city areas. (Example: Los Angeles = Whittier)

      SoftMedia’s cablecomzip files can be imported into most mapping software programs. 
(Sample Map)  

Structure for table: Telecom2008.DBF/Telco2008.dbf                    Product Code 201
Number of data records: 5,804
Field         Field Name             Type               Width

1

Company Name

Character

35

Legal Name of Telco

2

Address

Character

10

Physical Address

3

City

Character

10

City

4

State

Character

25

State

5

 City/State/Zipcode

Character

3

Mailing City/State/Zip Code for labeling convenience

6

Zipcode 

Character

25

Zip Code

7

Fax Number

Character

75

Office Fax Number

8 Telephone   15 Main Telephone Number

9

General Manager

Character

45

General Manager 

10

Web Site

Character

15

URL 

11

Email

Character

15

GM Email

12 Service Type Character   10 RBOC, ILEC, CLEC, etc...
13 Corporate Owners Character   45 Corporate Owner

Structure for table: Telephone2008.DBF                            Product Code 203
Number of data records: 193,939
Field         Field Name             Type              Width

1

AREACODE (NPA)

Character

10

3-Digit Area Code

2

PREFIX  (NXX)

Character

10

The area designated as the area within which a LEC or CLC may provide local exchange services.

3

COMZIP

Character

10

5-Digit Zip Code associated with the State and City

4

COUNTY

Character

25

County of City within Service Area.

5

STATE

Character

3

State by 5-Digit Zip Code for Service Area

6

CITY

Character

25

City of Service Area.

7

REGION

Character

15

Name of Geographical Region in the US.

8

DIVISION

Character

15

Name of Division within Regions.

9

LATITUDE

Character

15

Latitude of Centroid of Zip Code in Service Area

10

LONGITUDE

Character

15

Longitude of Centroid of Zip Code in Service Area

11

TELCOOPER 

Character

45

Name of Telephone Company serving the area.

12

TOTALPOP

Character

15

Total Population within the Service Area Zip Code.

13

TOTALHH

Character

15

Total House Holds within the Service Area Zip Code.

14

OCN

Character

45

Unique Operating Company Number

15

RATECENTER

Character

45

A geographically specified area used for determining mileage and/or usage dependent rates in the Public Switched Telephone Network. A rate center is not always the exact equivalent of an Exchange Area, but can be.  

16

CLLI

Character

20

Common Language Location Identifier.

17

TYPE

Character

10

Codes to Identify various service types; CLC (Competitive Local Carrier), CLEC (Competitive Local Exchange Carrier), IEC (InterExchange Carrier) see the list of acronyms for details.  

18

SWNAME

Character

35

Manufacturer/Suppier of Switch Equipment

19

SWTYPE

Character

35

Model/Type of Switch Equipemnet

20

LATA

Character

55

3 Digit Code for each Local Access Transport Area.

Structure for table: Telephonecable.DBF                            Product Code 204
Number of data records: 193,939
Field        Field Name              Type               Width

1

AREACODE (NPA)

Character

10

3-Digit Area Code

2

PREFIX  (NXX)

Character

10

The area designated as the area within which a LEC or CLC may provide local exchange services.

3

COMZIP

Character

10

5-Digit Zip Code associated with the State and City

4

COUNTY

Character

25

County of City within Service Area.

5

STATE

Character

3

State by 5-Digit Zip Code for Service Area

6

CITY

Character

25

City of Service Area.

7

CITYALIAS

Character

75

Alias Name for City in Service Area

8

DMANAME & Rank

Character

45

Name of Designated Market area

9

REGION

Character

15