Fix W205AG 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 = 'CLARKS SUMMIT' and State = 'PA'

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

Number of rows returned = 1
Start: 1754167561.8689
End: 1754167561.869
Elapsed time: 0.1211 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
16400 PA Clarks Summit -1 51 5433 41.492878 -75.704904 570 0 0 0 0 0 16400 5126 4213880 -5 -1 69

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

NULL

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

array(13) { ["zipcode"]=> string(5) "18411" ["zip3"]=> string(3) "184" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(13) "CLARKS SUMMIT" ["zipstate"]=> string(2) "PA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "41.48" ["iplongitude"]=> string(5) "-75.7" ["ziplocation"]=> string(22) "NA-US-PA-CLARKS SUMMIT" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "10993" ["zippopulation"]=> string(5) "19464" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "184" ["zipcity"]=> string(13) "CLARKS SUMMIT" ["zipstate"]=> string(2) "PA" }

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

array(22) { ["id"]=> string(5) "16400" ["State"]=> string(2) "PA" ["CityName"]=> string(13) "Clarks Summit" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "51" ["Population"]=> string(4) "5433" ["Latitude"]=> string(9) "41.492878" ["Longitude"]=> string(10) "-75.704904" ["PrimaryAC"]=> string(3) "570" ["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) "16400" ["Population2000"]=> string(4) "5126" ["FIPS"]=> string(7) "4213880" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "69" }

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

No Rows in Recordset!

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

19 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
16984	PA	Scranton	0	188	81805	41.410629	-75.667411	570		0		0	0	0	0	16984	76415	4269000	-5	-1	69
16776	PA	Nanticoke	-1	49	12267	41.199514	-75.999119	570		0		0	0	0	0	16776	10955	4252584	-5	-1	69
16328	PA	Berwick	-1	66	10976	41.056843	-76.247732	570		0		0	0	0	0	16328	10774	4205888	-5	-1	69
16375	PA	Carbondale	-1	38	10664	41.572082	-75.50082	570		0		0	0	0	0	16375	9804	4211232	-5	-1	69
16912	PA	Pittston	-1	76	9389	41.323865	-75.788894	570		0		0	0	0	0	16912	8104	4261048	-5	-1	69
16400	PA	Clarks Summit	-1	51	5433	41.492878	-75.704904	570		0		0	0	0	0	16400	5126	4213880	-5	-1	69
16824	PA	Olyphant	-1	42	5222	41.46263	-75.595617	570		0		0	0	0	0	16824	4978	4256792	-5	-1	69
16589	PA	Honesdale	0	109	4972	41.574214	-75.255966	570		0		0	0	0	0	16589	4874	4235520	-5	-1	69
17060	PA	Tunkhannock	-1	56	2251	41.540836	-75.947703	570		0		0	0	0	0	17060	1911	4277784	-5	-1	69
16518	PA	Forest City	-1	0	1846	41.650907	-75.46818	570		0		0	0	0	0	16518	1855	4226560	-5	-1	69
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
39999	PA	Mifflinville	-1	0	1329	41.028617	-76.307175			0		0	0	0	0		1213	4249312	-5	-1	69
16578	PA	Hawley	-1	25	1244	41.478225	-75.179154	570		0		0	0	0	0	16578	1303	4233200	-5	-1	69
16468	PA	Dushore	-1	0	738	41.525227	-76.399924	570		0		0	0	0	0	16468	663	4220528	-5	-1	69
39996	PA	Meshoppen	-1	0	439	41.614691	-76.046276			0		0	0	0	0		459	4248856	-5	-1	69
16642	PA	Laceyville	-1	0	436	41.645337	-76.160451	570		0		0	0	0	0	16642	396	4240744	-5	-1	69
69526	PA	Mountain Top		0	0	41.138082	-75.931634			0	0	0	0	0	0	0	15269	4251384	-5	-1	69
17035	PA	Sweet Valley	-1	0		41.288634	-76.142277	570		0		0	0	0	0	17035			-5	-1	69
16560	PA	Hamlin	0	14		41.422497	-75.335384	570		0		0	0	0	0	16560			-5	-1	69
16311	PA	Bear Creek	-1	0		41.192177	-75.716073	570		0		0	0	0	0				-5	-1	69

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

45 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
18411	CLARKS SUMMIT	PA	19464	Clarks Summit	69
18466	TOBYHANNA	PA	12134
18444	MOSCOW	PA	11721	Moscow
18407	CARBONDALE	PA	11187	Carbondale	69
18436	LAKE ARIEL	PA	10997	Lake Ariel
18431	HONESDALE	PA	10706	Honesdale	69
18428	HAWLEY	PA	9695	Hawley	69
18447	OLYPHANT	PA	8911	Olyphant	69
18403	ARCHBALD	PA	6187	Archbald
18433	JERMYN	PA	5718	Jermyn
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
18414	DALTON	PA	4924	Dalton
18424	GOULDSBORO	PA	4633
18452	PECKVILLE	PA	4085
18421	FOREST CITY	PA	4034	Forest City	69
18419	FACTORYVILLE	PA	3759	Factoryville
18472	WAYMART	PA	3522	Waymart
18434	JESSUP	PA	3514	Jessup
18426	GREENTOWN	PA	3370
18446	NICHOLSON	PA	3133	Nicholson
18458	SHOHOLA	PA	2440	Shohola
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
18405	BEACH LAKE	PA	1980	Beach Lake
18445	NEWFOUNDLAND	PA	1878	Newfoundland
18470	UNION DALE	PA	1852	Union Dale
18464	TAFTON	PA	1166
18465	THOMPSON	PA	1099	Thompson
18415	DAMASCUS	PA	970
18425	GREELEY	PA	934
18438	LAKEVILLE	PA	924
18417	EQUINUNK	PA	890
18453	PLEASANT MOUNT	PA	881	Pleasant Mount
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
18435	LACKAWAXEN	PA	839
18427	HAMLIN	PA	670	Hamlin	69
18439	LAKEWOOD	PA	433	Lakewood
18451	PAUPACK	PA	427
18430	HERRICK CENTER	PA	0
18437	LAKE COMO	PA	0	Lake Como
18443	MILANVILLE	PA	0
18441	LENOXVILLE	PA	0
18455	PRESTON PARK	PA	0
18456	PROMPTON	PA	0	Prompton
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
18460	SOUTH STERLING	PA	0
18461	STARLIGHT	PA	0
18462	STARRUCCA	PA	0	Starrucca
18463	STERLING	PA	0
18469	TYLER HILL	PA	0

Station W205AG-FX

City CLARKS SUMMIT-PA

City , is located in DMAID: