Fix WCMV FM Station DMA

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

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9999" ["dmaType"]=> NULL ["Minority"]=> NULL ["QualType"]=> NULL ["DMAName"]=> string(7) "Unrated" ["Population25up"]=> string(1) "0" ["scanned"]=> NULL ["AvgLatitude"]=> NULL ["AvgLongitude"]=> NULL ["State"]=> string(0) "" }
Database: media
SQL: select * from cities where CityName = 'LELAND' and State = 'MI'

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

Number of rows returned = 0
Start: 1754150081.3952
End: 1754150081.3968
Elapsed time: 1.5550 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('MI','Leland',-1)

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

array(22) { ["id"]=> string(5) "79881" ["State"]=> string(2) "MI" ["CityName"]=> string(6) "Leland" ["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) "49654" ["zip3"]=> string(3) "496" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(6) "LELAND" ["zipstate"]=> string(2) "MI" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "45.01" ["iplongitude"]=> string(6) "-85.76" ["ziplocation"]=> string(15) "NA-US-MI-LELAND" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "451" ["zippopulation"]=> string(3) "774" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "496" ["zipcity"]=> string(13) "TRAVERSE CITY" ["zipstate"]=> string(2) "MI" }

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

array(22) { ["id"]=> string(4) "8988" ["State"]=> string(2) "MI" ["CityName"]=> string(13) "Traverse City" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "168" ["Population"]=> string(5) "15155" ["Latitude"]=> string(9) "44.760084" ["Longitude"]=> string(10) "-85.612319" ["PrimaryAC"]=> string(3) "231" ["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(4) "8988" ["Population2000"]=> string(5) "14532" ["FIPS"]=> string(7) "2680340" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "192" }

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

No Rows in Recordset!

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

18 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8988	MI	Traverse City	0	168	15155	44.760084	-85.612319	231		0		0	0	0	0	8988	14532	2680340	-5	-1	192
8509	MI	Cadillac	0	175	10104	44.250962	-85.413696	231		0		0	0	0	0	8509	10000	2612320	-5	-1	192
8773	MI	Manistee	0	91	6734	44.243567	-86.32149	231		0		0	0	0	0	8773	6586	2650720	-5	-1	192
8879	MI	Petoskey	0	172	6056	45.369174	-84.967882	269		0		0	0	0	0	8879	6080	2663820	-5	-1	192
8334	ME	Oakland	-1	4	3510	44.547268	-69.712968	207		0		0	0	0	0	8334	2758	2354525	-5	-1	192
8532	MI	Charlevoix	-1	86	3116	45.316572	-85.258042	231		0		0	0	0	0	8532	2994	2614780	-5	-1	192
8727	MI	Kalkaska	0	125	1952	44.734569	-85.179945	231		0		0	0	0	0	8727	2226	2642260	-5	-1	192
8634	MI	Frankfort	-1	91	1546	44.633701	-86.234938	231		0		0	0	0	0	8634	1513	2630260	-5	-1	192
8738	MI	Lake City	0	19	858	44.332505	-85.213159	231		0		0	0	0	0	8738	923	2644480	-5	-1	192
8729	MI	Kingsley	-1	0	738	44.584293	-85.537335	231		0		0	0	0	0	8729	1469	2643340	-5	-1	192
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8482	MI	Beulah	-1	125	421	44.630292	-86.094284	231		0		0	0	0	0	8482	363	2608100	-5	-1	192
36504	MI	Thompsonville	-1	0	416	44.52016	-85.941689			0		0	0	0	0		457	2679600	-5	-1	192
8626	MI	Fife Lake	-1	93	394	44.576097	-85.351596	231		0		0	0	0	0	8626	466	2628000	-5	-1	192
8698	MI	Honor	-1	14	292	44.665567	-86.022118	231		0		0	0	0	0	8698	299	2639080	-5	-1	192
8676	MI	Harrietta	-1	43	157	44.308382	-85.699231	231		0		0	0	0	0	8676	169	2636720	-5	-1	192
8904	MI	Reed City	-1	153		43.874226	-85.509276	231		0		0	0	0	0	8904	2430	2667820	-5	-1	192
8649	MI	Glen Arbor	-1	0		44.873421	-85.98867	231		0		0	0	0	0				-5	-1	192
62732	MI	Interlochen		45				231		0		0	0	0	0	62732			-5	-1	192

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

61 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49684	TRAVERSE CITY	MI	32444	Traverse City	192
49686	TRAVERSE CITY	MI	27152	Traverse City	192
49601	CADILLAC	MI	17240	Cadillac	192
49660	MANISTEE	MI	10941	Manistee	192
49646	KALKASKA	MI	6738	Kalkaska	192
49651	LAKE CITY	MI	5998	Lake City	192
49690	WILLIAMSBURG	MI	5525	Williamsburg
49649	KINGSLEY	MI	5310	Kingsley	192
49643	INTERLOCHEN	MI	5269	Interlochen	192
49659	MANCELONA	MI	5199	Mancelona
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49677	REED CITY	MI	5118	Reed City	192
49663	MANTON	MI	4574	Manton
49631	EVART	MI	4486	Evart
49682	SUTTONS BAY	MI	3847	Suttons Bay
49615	BELLAIRE	MI	3716	Bellaire
49665	MARION	MI	3453	Marion
49637	GRAWN	MI	2982	Grawn
49635	FRANKFORT	MI	2913	Frankfort	192
49657	MC BAIN	MI	2910
49633	FIFE LAKE	MI	2855	Fife Lake	192
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49617	BEULAH	MI	2853	Beulah	192
49668	MESICK	MI	2839	Mesick
49676	RAPID CITY	MI	2766
49650	LAKE ANN	MI	2679	Lake Ann
49621	CEDAR	MI	2648	Cedar
49655	LEROY	MI	2461
49614	BEAR LAKE	MI	2285	Bear Lake
49688	TUSTIN	MI	2210	Tustin
49622	CENTRAL LAKE	MI	2182	Central Lake
49629	ELK RAPIDS	MI	2099	Elk Rapids
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49639	HERSEY	MI	2070	Hersey
49620	BUCKLEY	MI	2039	Buckley
49648	KEWADIN	MI	1955
49664	MAPLE CITY	MI	1843
49616	BENZONIA	MI	1808	Benzonia
49683	THOMPSONVILLE	MI	1680	Thompsonville	192
49670	NORTHPORT	MI	1656	Northport
49653	LAKE LEELANAU	MI	1640	Lake Leelanau
49680	SOUTH BOARDMAN	MI	1603	South Boardman
49640	HONOR	MI	1475	Honor	192
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49644	IRONS	MI	1454	Irons
49645	KALEVA	MI	1356	Kaleva
49630	EMPIRE	MI	1327	Empire
49656	LUTHER	MI	1230	Luther
49689	WELLSTON	MI	1176	Wellston
49679	SEARS	MI	1067
49625	COPEMISH	MI	1029	Copemish
49675	ONEKAMA	MI	998	Onekama
49612	ALDEN	MI	961	Alden
49632	FALMOUTH	MI	900	Falmouth
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49623	CHASE	MI	896
49619	BRETHREN	MI	878	Brethren
49685	TRAVERSE CITY	MI	852	Traverse City	192
49654	LELAND	MI	774	Leland
49638	HARRIETTA	MI	682	Harrietta	192
49613	ARCADIA	MI	655
49618	BOON	MI	633
49636	GLEN ARBOR	MI	624	Glen Arbor	192
49642	IDLEWILD	MI	480
49667	MERRITT	MI	477	Merritt
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49696	TRAVERSE CITY	MI	446	Traverse City	192

Station WCMV-FM

City LELAND-MI

City Leland, MI is located in DMAID: