Fix K261AY 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 = 'BRIDGEPORT' and State = 'CA'

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

Number of rows returned = 1
Start: 1754177071.3622
End: 1754177071.3625
Elapsed time: 0.3440 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
1778 CA Bridgeport 0 158 38.248505 -119.19876 760 0 0 0 0 0 1778 -8 -1 127

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

NULL

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

array(13) { ["zipcode"]=> string(5) "93517" ["zip3"]=> string(3) "935" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "BRIDGEPORT" ["zipstate"]=> string(2) "CA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "38.27" ["iplongitude"]=> string(7) "-119.33" ["ziplocation"]=> string(19) "NA-US-CA-BRIDGEPORT" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "393" ["zippopulation"]=> string(3) "665" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "935" ["zipcity"]=> string(9) "LANCASTER" ["zipstate"]=> string(2) "CA" }

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

array(22) { ["id"]=> string(4) "2091" ["State"]=> string(2) "CA" ["CityName"]=> string(9) "Lancaster" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "427" ["Population"]=> string(5) "97291" ["Latitude"]=> string(8) "34.68698" ["Longitude"]=> string(11) "-118.154062" ["PrimaryAC"]=> string(3) "661" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "1" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(4) "2091" ["Population2000"]=> string(6) "118718" ["FIPS"]=> string(6) "640130" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "127" }

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

No Rows in Recordset!

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

28 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
2091	CA	Lancaster	0	427	97291	34.68698	-118.154062	661		0		1	1	0	0	2091	118718	640130	-8	-1	127
2292	CA	Palmdale	0	389	68842	34.581005	-118.100603	661		0		1	0	0	0	2292	116670	655156	-8	-1	127
33009	CA	Fountain Valley	-1	0	53691	33.708618	-117.956295			0		0	0	0	0		54978	625380	-8	-1	127
2005	CA	Hesperia	-1	129	50418	34.412903	-117.306189	760		0		0	1	0	0	2005	62582	633434	-8	-1	127
1704	CA	Apple Valley	0	0	46079	34.511486	-117.21201	760		0		0	0	0	0		54239	602364	-8	-1	127
2564	CA	Victorville	0	374	40674	34.520459	-117.344525	760		0		0	1	1	0	2564	64029	682590	-8	-1	127
2368	CA	Ridgecrest	0	377	27725	35.620932	-117.675749	760		0		0	1	1	0	2368	24927	660704	-8	-1	127
1734	CA	Barstow	0	342	21472	34.876259	-117.034818	760		0		0	1	1	0	1734	21119	604030	-8	-1	127
2615	CA	Yucca Valley	0	274	13701	34.126041	-116.416463	760		0		0	1	0	0	2615	16865	687056	-8	-1	127
2550	CA	Twentynine Palms	-1	96	11821	34.138277	-116.072409	760		0		0	1	0	0	2550	14764	680994	-8	-1	127
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
2380	CA	Rosamond	0	346	7430	34.865786	-118.206856	661		0		0	0	0	0	2380	14349	662826	-8	-1	127
1792	CA	California City	0	271	5955	35.161119	-117.873033	760		0		0	1	0	0	1792	8385	609780	-8	-1	127
1755	CA	Big Bear Lake	0	328	5351	34.241295	-116.903289	909		0		0	1	0	0	1755	5438	606434	-8	-1	127
2163	CA	Mammoth Lakes	0	268	4785	37.636893	-118.978915	760		0		0	1	0	0	2163	7093	645358	-8	-1	127
2046	CA	Joshua Tree	0	277	3898	34.126979	-116.31858	760		0		0	1	0	0	2046	4207	637554	-8	-1	127
2200	CA	Mojave	0	344	3763	35.016867	-118.189145	661		0		0	0	0	0	2200	3836	648452	-8	-1	127
1762	CA	Bishop	0	338	3475	37.365087	-118.394896	760		0		0	1	0	0	1762	3575	606798	-8	-1	127
2121	CA	Lone Pine	0	330	1818	36.586402	-118.070668	760		0		0	0	0	0	2121	1655	642580	-8	-1	127
1683	CA	Acton	-1	0	1471	34.472777	-118.183696	661		0		0	0	0	0		2390	600212	-8	-1	127
1758	CA	Big Pine	0	106	1158	37.165377	-118.296321	760		0		0	0	0	0	1758	1350	606616	-8	-1	127
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
68237	CA	Johannesburg		0	0	35.369564	-117.638983			0	0	0	0	0	0	0	176	637400	-8	-1	127
1778	CA	Bridgeport	0	158		38.248505	-119.19876	760		0		0	0	0	0	1778			-8	-1	127
1905	CA	Edwards	0	338		35.294405	-118.905173	661		0		0	0	0	0	1905			-8	-1	127
2033	CA	Independence	-1	143		36.80577	-118.202307	760		0		0	0	0	0	2033	574	636350	-8	-1	127
2541	CA	Trona	0	159		34.839964	-115.967051	760		0		0	0	0	0	2541			-8	-1	127
2037	CA	Inyokern	-1	53		35.64743	-117.813795	760		0		0	0	0	0	2037	984	636658	-8	-1	127
2354	CA	Randsburg	0	283		35.367588	-117.654189	760		0		0	0	0	0	2354	77	659668	-8	-1	127
2158	CA	Lucerne Valley	-1	156		34.770403	-116.206281	760		0		0	0	0	0	2158			-8	-1	127

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

32 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
93536	LANCASTER	CA	48248	Lancaster	127
93550	PALMDALE	CA	48104	Palmdale	127
93535	LANCASTER	CA	45851	Lancaster	127
93551	PALMDALE	CA	39678	Palmdale	127
93552	PALMDALE	CA	26212	Palmdale	127
93534	LANCASTER	CA	24548	Lancaster	127
93555	RIDGECREST	CA	24004	Ridgecrest	127
93561	TEHACHAPI	CA	21006	Tehachapi	81
93560	ROSAMOND	CA	13552	Rosamond	127
93514	BISHOP	CA	10011	Bishop	127
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
93543	LITTLEROCK	CA	9046	Littlerock
93505	CALIFORNIA CITY	CA	7123	California City	127
93546	MAMMOTH LAKES	CA	6723	Mammoth Lakes	127
93510	ACTON	CA	6716	Acton	127
93591	PALMDALE	CA	4371	Palmdale	127
93501	MOJAVE	CA	3030	Mojave	127
93523	EDWARDS	CA	2354	Edwards	127
93532	LAKE HUGHES	CA	2088	Lake Hughes
93527	INYOKERN	CA	1719	Inyokern	127
93545	LONE PINE	CA	1557	Lone Pine	127
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
93553	PEARBLOSSOM	CA	1419
93513	BIG PINE	CA	1370	Big Pine	127
93516	BORON	CA	1337	Boron
93562	TRONA	CA	1017	Trona	127
93518	CALIENTE	CA	828
93544	LLANO	CA	767
93517	BRIDGEPORT	CA	665	Bridgeport	127
93526	INDEPENDENCE	CA	544	Independence	127
93529	JUNE LAKE	CA	491	June Lake
93531	KEENE	CA	484	Keene
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
93512	BENTON	CA	0	Benton
93563	VALYERMO	CA	0

Station K261AY-FX

City BRIDGEPORT-CA

City , is located in DMAID: