Fix W235CA Station DMA

Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix W235CA Station DMA

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2009-06-13 09:56:14" ["dmarank"]=> string(1) "0" ["dmaID"]=> string(1) "0" ["dmaType"]=> string(1) "C" ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(13) "United States" ["Population25up"]=> string(9) "300000000" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(2) "WW" }
Database: media
SQL: select * from cities where CityName = 'PISGAH FOREST' and State = 'NC'

Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
cities	ref	CityName	CityName	53	const	1	Using where

Number of rows returned = 0
Start: 1754168035.7856
End: 1754168035.7857
Elapsed time: 0.1490 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NC','Pisgah Forest',-1)

*** city ***************

array(22) { ["id"]=> string(5) "79995" ["State"]=> string(2) "NC" ["CityName"]=> string(13) "Pisgah Forest" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> NULL ["Population"]=> NULL ["Latitude"]=> NULL ["Longitude"]=> NULL ["PrimaryAC"]=> NULL ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> NULL ["ISPCount"]=> NULL ["CovadDSL"]=> NULL ["VerizonDSL"]=> NULL ["allegiance"]=> NULL ["SBC"]=> NULL ["RateCenterCityid"]=> NULL ["Population2000"]=> NULL ["FIPS"]=> NULL ["cTZoffset"]=> NULL ["DST"]=> string(1) "0" ["DMAID"]=> NULL }

****** zip code ************

array(13) { ["zipcode"]=> string(5) "28768" ["zip3"]=> string(3) "287" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(13) "PISGAH FOREST" ["zipstate"]=> string(2) "NC" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "35.27" ["iplongitude"]=> string(6) "-82.67" ["ziplocation"]=> string(22) "NA-US-NC-PISGAH FOREST" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "3142" ["zippopulation"]=> string(4) "5565" ["zipincome"]=> string(7) "8388607" }

******* zip3 ***********

array(3) { ["zip3"]=> string(3) "287" ["zipcity"]=> string(14) "HENDERSONVILLE" ["zipstate"]=> string(2) "NC" }

**** zip3 city**************

array(22) { ["id"]=> string(5) "11162" ["State"]=> string(2) "NC" ["CityName"]=> string(14) "Hendersonville" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(3) "104" ["Population"]=> string(4) "7284" ["Latitude"]=> string(9) "35.320586" ["Longitude"]=> string(10) "-82.461596" ["PrimaryAC"]=> string(3) "828" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "0" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "11162" ["Population2000"]=> string(5) "10420" ["FIPS"]=> string(7) "3730720" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "60" }

**** cities in DMA per station **************

No Rows in Recordset!

***** cities in DMA by city *************

50 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
18042	SC	Greenville	0	216	58282	34.844313	-82.385428	864		1		0	0	0	0	18042	56002	4530850	-5	-1	60
18157	SC	Spartanburg	0	176	43467	34.946771	-81.927603	864		1		0	0	0	0	18157	39673	4568290	-5	-1	60
17967	SC	Anderson	0	170	26184	34.514506	-82.648944	864		0		0	0	0	0	17967	25514	4501360	-5	-1	60
18043	SC	Greenwood	0	37	20807	34.189756	-82.154816	864		0		0	0	0	0	18043	22071	4530895	-5	-1	60
18019	SC	Easley	-1	63	15195	34.823371	-82.590394	864		0		0	0	0	0	18019	17754	4521985	-5	-1	60
18154	SC	Simpsonville	0	107	11708	34.733375	-82.260001	864		0		0	0	0	0	18154	14352	4566580	-5	-1	60
40668	SC	Mauldin	-1	0	11587	34.780854	-82.300517			0		0	0	0	0		15224	4545115	-5	-1	60
18005	SC	Clemson	-1	131	11096	34.68493	-82.814777	864		0		0	0	0	0	18005	11939	4514950	-5	-1	60
18044	SC	Greer	-1	90	10322	34.930304	-82.225052	864		0		0	0	0	0	18044	16843	4530985	-5	-1	60
18176	SC	Union	-1	96	9836	34.717308	-81.624924	864		0		0	0	0	0	18176	8793	4573105	-5	-1	60
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
18083	SC	Laurens	-1	73	9694	34.500717	-82.018271	864		0		0	0	0	0	18083	9916	4540615	-5	-1	60
18006	SC	Clinton	-1	57	7987	34.471257	-81.875023	864		0		0	0	0	0	18006	8091	4515295	-5	-1	60
18151	SC	Seneca	0	142	7726	34.684145	-82.955778	864		0		0	0	0	0	18151	7652	4565095	-5	-1	60
11162	NC	Hendersonville	-1	104	7284	35.320586	-82.461596	828		0		0	0	0	0	11162	10420	3730720	-5	-1	60
17964	SC	Abbeville	-1	1	5778	34.178572	-82.3792	864		0		0	0	0	0	17964	5840	4500100	-5	-1	60
11037	NC	Black Mountain	0	70	5418	35.619208	-82.325434	828		0		0	0	0	0	11037	7511	3706140	-5	-1	60
11046	NC	Brevard	-1	1	5388	35.241625	-82.728701	828		0		0	0	0	0	11046	6789	3707720	-5	-1	60
11221	NC	Marion	-1	48	4765	35.68315	-82.005855	828		0		0	0	0	0	11221	4943	3741420	-5	-1	60
17978	SC	Belton	-1	69	4646	34.52563	-82.496129	864		0		0	0	0	0	17978	4461	4505365	-5	-1	60
18190	SC	Woodruff	0	93	4365	34.74053	-82.03258	864		0		0	0	0	0	18190	4229	4579090	-5	-1	60
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
18133	SC	Piedmont	-1	43	4143	34.70414	-82.461427	864		0		0	0	0	0	18133	4684	4556365	-5	-1	60
11093	NC	Cullowhee	-1	0	4029	35.309704	-83.183726	828		0		0	0	0	0	11093	3579	3715880	-5	-1	60
18058	SC	Honea Path	-1	46	3841	34.4474	-82.393044	864		0		0	0	0	0	18058	3504	4534810	-5	-1	60
18178	SC	Walhalla	-1	56	3755	34.767263	-83.064321	864		0		0	0	0	0	18178	3801	4574095	-5	-1	60
18173	SC	Travelers Rest	-1	54	3069	34.9701	-82.437814	864		0		0	0	0	0	18173	4099	4572430	-5	-1	60
18132	SC	Pickens	-1	61	3042	34.8817	-82.707477	864		0		0	0	0	0	18132	3012	4556140	-5	-1	60
11129	NC	Franklin	-1	89	2873	35.181144	-83.381685	828		0		0	0	0	0	11129	3490	3724640	-5	-1	60
18012	SC	Cowpens	-1	45	2176	35.016181	-81.80424	864		0		0	0	0	0	18012	2279	4517260	-5	-1	60
11393	NC	Weaverville	0	129	2107	35.695809	-82.558444	828		0		0	0	0	0	11393	2416	3771560	-5	-1	60
11346	NC	Spruce Pine	-1	51	2010	35.913743	-82.069999	828		0		0	0	0	0	11346	2030	3764260	-5	-1	60
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
11361	NC	Sylva	0	115	1809	35.374199	-83.217686	828		0		0	0	0	0	11361	2435	3766500	-5	-1	60
18060	SC	Inman	-1	1	1742	35.047493	-82.090329	864		0		0	0	0	0	18060	1884	4535755	-5	-1	60
11371	NC	Tryon	-1	1	1680	35.208913	-82.238984	828		0		0	0	0	0	11371	1760	3768580	-5	-1	60
11051	NC	Burnsville	-1	107	1482	35.918542	-82.297549	828		0		0	0	0	0	11051	1623	3709140	-5	-1	60
18018	SC	Due West	-1	0	1220	34.33211	-82.387131	864		0		0	0	0	0	18018	1209	4521040	-5	-1	60
11048	NC	Bryson City	0	135	1145	35.426982	-83.447681	828		0		0	0	0	0	11048	1411	3708480	-5	-1	60
11080	NC	Clyde	-1	0	1041	35.533021	-82.911686	704		0		0	0	0	0	11080	1324	3713280	-5	-1	60
11167	NC	Highlands	0	112	948	35.054129	-83.202351	828		0		0	0	0	0	11167	909	3731360	-5	-1	60
18039	SC	Gray Court	-1	0	914	34.608563	-82.114189	864		0		0	0	0	0	18039	1021	4530355	-5	-1	60
11266	NC	Old Fort	-1	45	720	35.629541	-82.179178	828		0		0	0	0	0	11266	963	3748920	-5	-1	60
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
11302	NC	Robbinsville	-1	29	709	35.322823	-83.807788	828		0		0	0	0	0	11302	747	3757020	-5	-1	60
18155	SC	Six Mile	-1	56	562	34.801983	-82.817857	864		0		0	0	0	0	18155	553	4566760	-5	-1	60
40621	SC	Cross Hill	-1	0	469	34.310186	-81.984188			0		0	0	0	0	40621	601	4517890	-5	-1	60
18147	SC	Salem	-1	58	192	34.888599	-82.974666	864		0		0	0	0	0	18147	126	4562980	-5	-1	60
37483	NC	Dillsboro	-1	0	95	35.369671	-83.251114			0		0	0	0	0		205	3717180	-5	-1	60
11053	NC	Candler	-1	0				828		0		0	0	0	0				-5	-1	60
11068	NC	Cherokee	-1	0				828		0		0	0	0	0	11068			-5	-1	60
18025	SC	Enoree	-1	0		34.749045	-81.882943	864		0		0	0	0	0	18025			-5	-1	60
11061	NC	Cashiers	-1	62		35.111978	-83.099488	828		0		0	0	0	0	11061	196	3710800	-5	-1	60
17939	RI	Portsmouth	0	135		41.58523	-71.264197	401		0		0	1	0	0	17939			-5	-1	60

**** cities in zip3 **************

65 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
28752	MARION	NC	22290	Marion	60
28792	HENDERSONVILLE	NC	21168	Hendersonville	60
28734	FRANKLIN	NC	19590	Franklin	60
28715	CANDLER	NC	19048	Candler	60
28787	WEAVERVILLE	NC	16686	Weaverville	60
28786	WAYNESVILLE	NC	15174	Waynesville	161
28704	ARDEN	NC	15146	Arden
28739	HENDERSONVILLE	NC	14540	Hendersonville	60
28716	CANTON	NC	13388	Canton	161
28732	FLETCHER	NC	13344	Fletcher	161
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
28712	BREVARD	NC	12933	Brevard	60
28714	BURNSVILLE	NC	11419	Burnsville	60
28791	HENDERSONVILLE	NC	10468	Hendersonville	60
28779	SYLVA	NC	10102	Sylva	60
28711	BLACK MOUNTAIN	NC	9602	Black Mountain	60
28748	LEICESTER	NC	9543	Leicester
28753	MARSHALL	NC	8350	Marshall	161
28721	CLYDE	NC	7882	Clyde	60
28730	FAIRVIEW	NC	7645	Fairview	161
28778	SWANNANOA	NC	7619	Swannanoa
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
28777	SPRUCE PINE	NC	6996	Spruce Pine	60
28713	BRYSON CITY	NC	6965	Bryson City	60
28731	FLAT ROCK	NC	6479	Flat Rock
28719	CHEROKEE	NC	6304	Cherokee	60
28771	ROBBINSVILLE	NC	6115	Robbinsville	60
28761	NEBO	NC	5833
28762	OLD FORT	NC	5587	Old Fort	60
28768	PISGAH FOREST	NC	5565	Pisgah Forest
28754	MARS HILL	NC	5397	Mars Hill	161
28759	MILLS RIVER	NC	5376
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
28785	WAYNESVILLE	NC	5289	Waynesville	161
28722	COLUMBUS	NC	4969	Columbus
28705	BAKERSVILLE	NC	4765	Bakersville
28782	TRYON	NC	4735	Tryon	60
28723	CULLOWHEE	NC	4536	Cullowhee	60
28789	WHITTIER	NC	4234
28729	ETOWAH	NC	3226	Etowah
28756	MILL SPRING	NC	3061
28701	ALEXANDER	NC	2971
28741	HIGHLANDS	NC	2868	Highlands	60
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
28751	MAGGIE VALLEY	NC	2660	Maggie Valley
28742	HORSE SHOE	NC	2647
28726	EAST FLAT ROCK	NC	2623	East Flat Rock
28773	SALUDA	NC	2433	Saluda
28790	ZIRCONIA	NC	2321
28717	CASHIERS	NC	2081	Cashiers	60
28763	OTTO	NC	2070
28746	LAKE LURE	NC	1864	Lake Lure
28709	BARNARDSVILLE	NC	1828	Barnardsville
28740	GREEN MOUNTAIN	NC	1741
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
28772	ROSMAN	NC	1689	Rosman
28743	HOT SPRINGS	NC	1476	Hot Springs
28747	LAKE TOXAWAY	NC	1451
28745	LAKE JUNALUSKA	NC	1389	Lake Junaluska
28766	PENROSE	NC	1342
28783	TUCKASEGEE	NC	992
28774	SAPPHIRE	NC	750
28781	TOPTON	NC	664
28718	CEDAR MOUNTAIN	NC	594
28736	GLENVILLE	NC	521
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
28775	SCALY MOUNTAIN	NC	0
28702	ALMOND	NC	0
28708	BALSAM GROVE	NC	0
28733	FONTANA DAM	NC	0
28735	GERTON	NC	0

***** stations in DMA*************

26 records found!

stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
22710	BTRN			World Wide Web	WW	79841
23163	CRN1			World Wide Web	WW	79841
23164	CRN2			World Wide Web	WW	79841
23165	CRN3			World Wide Web	WW	79841
23166	CRN4			World Wide Web	WW	79841
23167	CRN5			World Wide Web	WW	79841
23168	CRN6			World Wide Web	WW	79841
42585	CSPAN1			World Wide Web	WW	79841
42586	CSPAN2			World Wide Web	WW	79841
42587	CSPAN3			World Wide Web	WW	79841
stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
22711	ESPN			World Wide Web	WW	79841
58943	EWTN			World Wide Web	WW	79841
22652	Fox News			World Wide Web	WW	79841
22712	Fox Sports			World Wide Web	WW	79841
41312	GCN1			World Wide Web	WW	79841
41481	GCN4			World Wide Web	WW	79841
77684	GCN5			World Wide Web	WW	79841
32729	MOYL			World Wide Web	WW	79841
44298	NPR			World Wide Web	WW	79841
44299	PRI			World Wide Web	WW	79841
stationid	CallSign	Licensee	Service	citynamex	Statex	cityid
22707	Radio America			World Wide Web	WW	79841
44583	SportsByline			World Wide Web	WW	79841
23558	TalkStar			World Wide Web	WW	79841
40372	TammyRadio			World Wide Web	WW	79841
44584	TheBlaze			World Wide Web	WW	79841
44301	YSN			World Wide Web	WW	79841

Station W235CA-FX

City PISGAH FOREST-NC

City Pisgah Forest, NC is located in DMAID: