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. Cablesys2009- 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. Cable2009- Database Product Code 100
For the convenience of our customers, SoftMedia provides a second database identical to the cablesys2009 file with the duplicates removed. This database contains over 2700 listings and should be used for Mailing, Emailing, Faxing etc…

3. MSO2009- Database Included in Product Code 100
The 3rd database in our cable group, mso2009, 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 cable2009 database. By using a “Relational” database
    software program, you can connect the databases allowing you to view the cable2009 data and
    the comzip2009 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: CABLE2009.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: MSO2009-.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	50

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

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

Structure for table: CABLECOMZIP.DBF Product Code 101
Number of data records: 42542
Field Field Name Type Width

1	SYSTEMID	Character	9	System Identification number
2	COMZIP	Character	10	Community/Zip Code
3	COMMUNITY	Character	40	Community Name
4	COMSTATE	Character	2	Community/State
5	SYSTEMNAME	Character	50	System Assumed Name
6	ADDRESS	Character	30	System Mailing Address
7	CITY	Character	24	System Mailing City
8	STATE	Character	9	System Mailing State
9	ZIPCODE	Character	9	System Mailing Zip Code
10	COMMALIAS	Character	35	Alias name for community (Example: Los Angeles = Whittier)
11	COUNTY	Character	34	County community located in
12	DIGANALOG	Character	15	Digital or Analog Service
13	LATITUDE	Character	25	Community Latitude Centroid
14	LONGITUDE	Character	25	Community Longitude Centroid
15	BASICSUBS	Character	20	Total Subs within community
16	SYSSUBS	Character	20	Total Subscribers for Franchise
17	PLANTMILES	Character	20	Total Cable Plant Miles for Community/Zip Code
18	TOTALPOP	Character	20	Total Population for Community/Zip Code
19	TOTALHH	Character	20	Total Households for Community/Zip Code
20	WHITEPOP	Character	20	Total White Population in Community/Zip Code
21	BLACKPOP	Character	20	Total Black Population in Community/Zip Code
22	HISPPOP	Character	20	Total Hispanic Population in Community/Zip Code
23	HHINCOME	Character	20	Household Income in Community/Zip Code
24	HHVALUE	Character	20	Average HH Value
25	TOTALSYS	Character	20	Total subscriber for the Franchise (Nation Wide)
26	DIGITAL	Character	10	Digital or Analog Service
27	MODEM	Character	11	Manufacturer of Internet/Modems
28	SERVICE	Character	11	Name/Type of Internet Service
29	MARKETNAME	Character	35	Name of Market Area
30	MARKETRANK	Character	5	Ranking of Market Area

Back to Previous Page