Cable Info

Cable System Database Structure & Background Information

Sample Cable Boundary Map for Torrance California Area
Time Warner Cable System for Charolette NC with ICO overlays

SoftMedia’s Cable System Database Group is comprised of (4) individual databases;

1. Cablesys2008- Database Product Code 100
The cable system database covers 11,000 franchises in the U.S. With the consolidation of operations, a specific office and management group manages more than one franchise, therefore there are duplicate addresses, management etc., in this database.

2. Cable2008- Database Product Code 100
For the convenience of our customers, SoftMedia provides a second database identical to the cablesys2008 file with the duplicates removed. This database contains over 2700 listings and should be used for Mailing, Emailing, Faxing etc…

3. MSO2008- Database Included in Product Code 100
The 3rd database in our cable group, mso2008, file is the MSO Database.(Multiple System Operators) corporate owners database. This database covers the 307 corporate owners.

4. CABLECOMZIP Database                     Product Code 101
    The 4^th database cablecomzip, is a database of over 42,500 communities and five digit zip codes. When
    the FCC authorizes a new Franchise they are issued a “SYSTEM IDENTIFICATION NUMBER”,
    systemid. Each community and zip code within that franchise has the same systemid number, therefore,
    by indexing/sorting by the systemid number you can view all of the communities and zip codes within
    a franchise.

    The systemid number is also present in the cable2008 database. By using a “Relational” database
    software program, you can connect the databases allowing you to view the cable2008 data and
    the comzip2008 data at the same time.

    The comzip database is ideal for loading into a mapping program. If your mapping software contains 5 digit
    zip code boundaries you can create coverage map’s of each franchise area and overlay demographics or
    other data that you need.

    The community zip code database has been named ‘CABLECOMZIP’. This new version of the
    community/zip database now has in excess of 42500 records. In addition it has an additional data field
    called ‘COMMALIAS’. This datafield is 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. We recommend a program called “Maptitude” created by Caliper Corp. Information on this software can be found at; http://www.caliper.com

Structure for table: CABLE2008.DBF Product Code 100
Number of data records: 3135
Field Field Name Type Width

1	SYSTEMNAME	Character	50	System Assumed Name
2	ADDRESS	Character	35	Mailing Address
3	MAILCITY	Character	35	Mailing City (Office)
4	COUNTY	Character	45	County of Office
5	STATE	Character	15	Mailing State
6	ZIPCODE	Character	5	Mailing Zip Code
7	GM	Character	75	General Manager Name
8	GMEMAIL	Character	75	General Manager Email Address
9	ENGMGR	Character	45	Engineering Manager Name
10	ENGEMAIL	Character	75	Engineering Manager Email Address
11	AREAMGR	Character	75	Area/Region Manager
12	AMPHONE	Character	75	Area/Regional Manager Telephone
13	AMEMAIL	Character	75	Area/Region Manager Email Address
14	TELEPHONE	Character	15	Office Telephone
15	ALTPHONE	Character	15	Alternate Telephone Number
16	FAX	Character	15	Office Fax
17	MKTMGR	Character	40	Advertising Manager Name
18	MKTEMAIL	Character	75	Advertising Manager Email Address
19	WEBSITE	Character	45	Web Site URL
20	TOTALSUBS	Numeric	8	Total Subscribers for system
21	SYSMILES	Numeric	8	Total Miles of cable plant for system
22	HHPASSED	Numeric	8	Total Households passed in the Franchise
23	SYSTEMHH	Numeric	8	Total Households in Franchise
24	DIGITAL	Character	10	Digital or Analog Service
25	MODEM	Character	55	Modem Manufacturer
26	SERVICE	Character	55	Type of Service
27	MARKETNAME	Character	45	Market Name
28	MARKETRANK	Character	5	Market Rank
29	SYSTEMID	Character	10	System (Franchise ID Number) Identification Number

Structure for table: MSO2008-.DBF Included in Product Code 100
Number of data records: 308
Field Field Name Type Width

1	OWNERMSO	Character	50	Corporate Owner
2	ADDRESS	Character	30	Address
3	MAILADDRES	Character	13	Address #2(PO Box)
4	CITY	Character	25	Mail City
5	STATE	Character	2	Mail State
6	ZIPCODE	Character	10	Zip Code
7	TELEPHONE	Character	12	Telephone
8	FAX	Character	12	Fax
9	BASICSUBS	Numeric	9	Total Basicsubs for Operator
10	SYSOWNED	Numeric	6	Total Number of Systems Owned
11	ENGMANAGER	Character	20	Engineering Manager
12	CHIEFEXOFF	Character	20	CEO
13	CHIEFOPOFF	Character	20	Executive VP
14	CHIEFFIOFF	Character	20	Financial Officer
15	PROGRAMMER	Character	20	Programming Manager
16	ADMANAGER	Character	20	Advertising Manager
17	MCSZ	Character	30	Mail, City, State, Zip code (For mailing labels)
18	WEBSITE	Character