Fix WPCJ FM Station DMA

Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix WPCJ 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 = 'PITTSFORD' and State = 'MI'

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

Number of rows returned = 0
Start: 1754170248.9352
End: 1754170248.9353
Elapsed time: 0.1512 ms No Rows in Recordset!

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

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

array(22) { ["id"]=> string(5) "80063" ["State"]=> string(2) "MI" ["CityName"]=> string(9) "Pittsford" ["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) "49271" ["zip3"]=> string(3) "492" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "PITTSFORD" ["zipstate"]=> string(2) "MI" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(4) "41.9" ["iplongitude"]=> string(6) "-84.43" ["ziplocation"]=> string(18) "NA-US-MI-PITTSFORD" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(4) "1007" ["zippopulation"]=> string(4) "1859" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "492" ["zipcity"]=> string(7) "JACKSON" ["zipstate"]=> string(2) "MI" }

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

array(22) { ["id"]=> string(4) "8720" ["State"]=> string(2) "MI" ["CityName"]=> string(7) "Jackson" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "208" ["Population"]=> string(5) "37446" ["Latitude"]=> string(9) "42.244085" ["Longitude"]=> string(10) "-84.407206" ["PrimaryAC"]=> string(3) "517" ["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) "8720" ["Population2000"]=> string(5) "36316" ["FIPS"]=> string(7) "2641420" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "121" }

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

No Rows in Recordset!

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

14 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8746	MI	Lansing	0	297	127321	42.717585	-84.554916	989		0		0	0	0	0	8746	119128	2646000	-5	-1	121
8598	MI	East Lansing	0	0	50677	42.740384	-84.481675	517		0		0	0	0	0		46525	2624120	-5	-1	121
8720	MI	Jackson	0	208	37446	42.244085	-84.407206	517		0		0	0	0	0	8720	36316	2641420	-5	-1	121
8430	MI	Adrian	0	111	22097	41.896526	-84.037827	517		0		0	0	0	0	8430	21574	2600440	-5	-1	121
8434	MI	Albion	0	118	10066	42.246741	-84.753299	517		0		0	0	0	0	8434	9144	2600980	-5	-1	121
8549	MI	Coldwater	0	259	9607	41.942794	-85.002533	517		0		0	0	0	0	8549	12697	2617020	-5	-1	121
8692	MI	Hillsdale	0	136	8170	41.922802	-84.632946	517		0		0	0	0	0	8692	8233	2638460	-5	-1	121
8533	MI	Charlotte	0	123	8083	42.560441	-84.834696	517		0		0	0	0	0	8533	8389	2614820	-5	-1	121
8658	MI	Grand Ledge	-1	18	7579	42.752499	-84.746434	517		0		0	0	0	0	8658	7813	2633420	-5	-1	121
8570	MI	De Witt	-1	18	3964	42.835983	-84.575631	517		0		0	0	0	0	8570	4702	2622120	-5	-1	121
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
8707	MI	Hudson	0	96	2580	41.856448	-84.351189	517		0		0	0	0	0	8707	2499	2639720	-5	-1	121
36487	MI	Spring Arbor	-1	0	2010	42.206988	-84.549589			0		0	0	0	0		2188	2675620	-5	-1	121
8759	MI	Litchfield	-1	15	1317	42.04293	-84.757048	517		0		0	0	0	0	8759	1458	2647980	-5	-1	121
8498	MI	Brooklyn	-1	6	1027	42.10649	-84.247276	517		0		0	0	0	0	8498	1176	2611000	-5	-1	121

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

54 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49201	JACKSON	MI	31779	Jackson	121
49221	ADRIAN	MI	29700	Adrian	121
49203	JACKSON	MI	28618	Jackson	121
49202	JACKSON	MI	14274	Jackson	121
49286	TECUMSEH	MI	13188	Tecumseh
49242	HILLSDALE	MI	10944	Hillsdale	121
49224	ALBION	MI	9318	Albion	121
49230	BROOKLYN	MI	9108	Brooklyn	121
49240	GRASS LAKE	MI	7545	Grass Lake
49251	LESLIE	MI	5326	Leslie
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49270	PETERSBURG	MI	5287	Petersburg
49285	STOCKBRIDGE	MI	4912	Stockbridge
49269	PARMA	MI	4862	Parma
49228	BLISSFIELD	MI	4843	Blissfield
49250	JONESVILLE	MI	4753	Jonesville
49247	HUDSON	MI	4620	Hudson	121
49265	ONSTED	MI	4459	Onsted
49236	CLINTON	MI	4206	Clinton
49245	HOMER	MI	3679	Homer
49267	OTTAWA LAKE	MI	3610	Ottawa Lake
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49256	MORENCI	MI	3219	Morenci
49246	HORTON	MI	2898
49229	BRITTON	MI	2892	Britton
49274	READING	MI	2833	Reading
49249	JEROME	MI	2822	Jerome
49277	RIVES JUNCTION	MI	2809	Rives Junction
49254	MICHIGAN CENTER	MI	2797	Michigan Center
49237	CONCORD	MI	2637	Concord
49283	SPRING ARBOR	MI	2636	Spring Arbor	121
49253	MANITOU BEACH	MI	2546
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49284	SPRINGPORT	MI	2535	Springport
49266	OSSEO	MI	2468	Osseo
49234	CLARKLAKE	MI	2391	Clarklake
49233	CEMENT CITY	MI	2256	Cement City
49272	PLEASANT LAKE	MI	2196
49259	MUNITH	MI	2172	Munith
49252	LITCHFIELD	MI	2162	Litchfield	121
49232	CAMDEN	MI	2133	Camden
49220	ADDISON	MI	2101	Addison
49241	HANOVER	MI	2051	Hanover
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49287	TIPTON	MI	1917	Tipton
49271	PITTSFORD	MI	1859	Pittsford
49235	CLAYTON	MI	1799	Clayton
49264	ONONDAGA	MI	1680	Onondaga
49238	DEERFIELD	MI	1455	Deerfield
49255	MONTGOMERY	MI	1136	Montgomery
49227	ALLEN	MI	1128	Allen
49288	WALDRON	MI	1128	Waldron
49262	NORTH ADAMS	MI	1018	North Adams
49268	PALMYRA	MI	950
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
49276	RIGA	MI	912
49248	JASPER	MI	787
49279	SAND CREEK	MI	747	Sand Creek
49282	SOMERSET CENTER	MI	0

Station WPCJ-FM

City PITTSFORD-MI

City Pittsford, MI is located in DMAID: