Fix K228CZ Station DMA

array(0) { }

*** DMA ***

array(12) { ["odbcts"]=> string(19) "2019-07-16 06:29:49" ["dmarank"]=> string(4) "9999" ["dmaID"]=> string(4) "9998" ["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 = 'CAMBRIDGE' and State = 'ID'

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

Number of rows returned = 1
Start: 1754168365.0769
End: 1754168365.0773
Elapsed time: 0.4501 ms 1 records found!
id State CityName RuralArea PopCount Population Latitude Longitude PrimaryAC ZoneDesc EartlinkDSL ISPCount CovadDSL VerizonDSL allegiance SBC RateCenterCityid Population2000 FIPS cTZoffset DST DMAID
4587 ID Cambridge -1 0 374 44.571535 -116.678013 208 0 0 0 0 0 4587 360 1612520 -7 -1 108

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

NULL

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

array(13) { ["zipcode"]=> string(5) "83610" ["zip3"]=> string(3) "836" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(9) "CAMBRIDGE" ["zipstate"]=> string(2) "ID" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "44.62" ["iplongitude"]=> string(6) "-116.7" ["ziplocation"]=> string(18) "NA-US-ID-CAMBRIDGE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "416" ["zippopulation"]=> string(3) "780" ["zipincome"]=> string(7) "8294912" }

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

array(3) { ["zip3"]=> string(3) "836" ["zipcity"]=> string(5) "NAMPA" ["zipstate"]=> string(2) "ID" }

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

array(22) { ["id"]=> string(4) "4679" ["State"]=> string(2) "ID" ["CityName"]=> string(5) "Nampa" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "92" ["Population"]=> string(5) "28365" ["Latitude"]=> string(9) "43.574807" ["Longitude"]=> string(11) "-116.563559" ["PrimaryAC"]=> string(3) "208" ["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) "4679" ["Population2000"]=> string(5) "51867" ["FIPS"]=> string(7) "1656260" ["cTZoffset"]=> string(2) "-7" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "108" }

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

No Rows in Recordset!

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

22 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
4580	ID	Boise	0	327	125738	43.606651	-116.2261	208		0		0	0	0	0	4580			-7	-1	108
4679	ID	Nampa	-1	92	28365	43.574807	-116.563559	208		0		0	0	0	0	4679	51867	1656260	-7	-1	108
4586	ID	Caldwell	-1	58	18400	43.658239	-116.68039	208		0		0	0	0	0	4586	25967	1612250	-7	-1	108
4668	ID	Meridian	0	0	9596	43.614229	-116.398963	208		0		0	0	0	0	4668	34919	1652120	-7	-1	108
4675	ID	Mountain Home	-1	42	7913	43.136812	-115.694474	208		0		0	0	0	0	4675	11143	1654730	-7	-1	108
4692	ID	Payette	-1	47	5592	44.075175	-116.929928	208		0		0	0	0	0	4692	7054	1661300	-7	-1	108
4613	ID	Emmett	-1	4	4601	43.872834	-116.494902	208		0		0	0	0	0	4613	5490	1625570	-7	-1	108
4736	ID	Weiser	-1	42	4571	44.249712	-116.967799	208		0		0	0	0	0	4736	5343	1686140	-7	-1	108
34690	ID	Eagle	-1	0	3327	43.693093	-116.346366			0		0	0	0	0		11085	1623410	-7	-1	108
4617	ID	Fruitland	-1	0	2400	44.016035	-116.92145	208		0		0	0	0	0	4617	3805	1628990	-7	-1	108
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
4665	ID	McCall	-1	2	2005	44.910906	-116.103087	208		0		0	0	0	0	4665	2084	1648790	-7	-1	108
4635	ID	Homedale	-1	1	1963	43.61898	-116.936836	208		0		0	0	0	0	4635	2528	1638170	-7	-1	108
4652	ID	Kuna	-1	0	1955	43.493092	-116.418936	208		0		0	0	0	0	4652	5382	1644290	-7	-1	108
4669	ID	Middleton	0	0	1851	43.706353	-116.620228	208		0		0	0	0	0	4669	2978	1652660	-7	-1	108
4690	ID	Parma	0	0	1597	43.786009	-116.942656	208		0		0	0	0	0	4690	1771	1660940	-7	-1	108
4681	ID	New Plymouth	-1	43	1313	43.970689	-116.820449	208		0		0	0	0	0	4681	1400	1656980	-7	-1	108
4589	ID	Cascade	-1	0	877	44.515575	-116.043681	208		0		0	0	0	0	4589	997	1613150	-7	-1	108
4662	ID	Marsing	-1	0	798	43.545484	-116.807811	208		0		0	0	0	0	4662	890	1650950	-7	-1	108
34718	ID	Notus	-1	0	380	43.726082	-116.801866			0		0	0	0	0		458	1658060	-7	-1	108
4587	ID	Cambridge	-1	0	374	44.571535	-116.678013	208		0		0	0	0	0	4587	360	1612520	-7	-1	108
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
4667	ID	Melba	-1	41	252	43.373487	-116.529194	208		0		0	0	0	0	4667	439	1651850	-7	-1	108
68663	ID	Garden City		0	0	43.645561	-116.266132			0	0	0	0	0	0	0	10624	1629620	-7	-1	108

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

48 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
83646	MERIDIAN	ID	34900	Meridian	108
83686	NAMPA	ID	34372	Nampa	108
83642	MERIDIAN	ID	29511	Meridian	108
83605	CALDWELL	ID	22255	Caldwell	108
83687	NAMPA	ID	21027	Nampa	108
83651	NAMPA	ID	20252	Nampa	108
83607	CALDWELL	ID	19697	Caldwell	108
83616	EAGLE	ID	19058	Eagle	108
83647	MOUNTAIN HOME	ID	16417	Mountain Home	108
83634	KUNA	ID	14859	Kuna	108
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
83617	EMMETT	ID	12006	Emmett	108
83661	PAYETTE	ID	7524	Payette	108
83644	MIDDLETON	ID	7321	Middleton	108
83672	WEISER	ID	6216	Weiser	108
83669	STAR	ID	6028	Star
83619	FRUITLAND	ID	5762	Fruitland	108
83638	MCCALL	ID	5138	McCall	108
83660	PARMA	ID	4460	Parma	108
83655	NEW PLYMOUTH	ID	3448	New Plymouth	108
83628	HOMEDALE	ID	3392	Homedale	108
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
83676	WILDER	ID	3316	Wilder
83641	MELBA	ID	2669	Melba	108
83648	MOUNTAIN HOME A F B	ID	2558
83639	MARSING	ID	2455	Marsing	108
83611	CASCADE	ID	1919	Cascade	108
83612	COUNCIL	ID	1488	Council
83622	GARDEN VALLEY	ID	1383	Garden Valley
83629	HORSESHOE BEND	ID	1338	Horseshoe Bend
83623	GLENNS FERRY	ID	1237	Glenns Ferry
83654	NEW MEADOWS	ID	1226	New Meadows
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
83615	DONNELLY	ID	1101	Donnelly
83626	GREENLEAF	ID	1057	Greenleaf
83631	IDAHO CITY	ID	1010	Idaho City
83624	GRAND VIEW	ID	886	Grand View
83610	CAMBRIDGE	ID	780	Cambridge	108
83604	BRUNEAU	ID	557	Bruneau
83627	HAMMETT	ID	522
83645	MIDVALE	ID	485	Midvale
83602	BANKS	ID	0
83643	MESA	ID	0
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
83637	LOWMAN	ID	0	Lowman
83633	KING HILL	ID	0
83670	SWEET	ID	0	Sweet
83666	PLACERVILLE	ID	0	Placerville
83632	INDIAN VALLEY	ID	0	Indian Valley
83650	MURPHY	ID	0	Murphy
83657	OLA	ID	0
83677	YELLOW PINE	ID	0	Yellow Pine

Station K228CZ-FX

City CAMBRIDGE-ID

City , is located in DMAID: