Fix W243AF 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 = 'FLINT HILL' and State = 'VA'

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

Number of rows returned = 0
Start: 1754168870.2079
End: 1754168870.208
Elapsed time: 0.1819 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('VA','Flint Hill',-1)

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

array(22) { ["id"]=> string(5) "80023" ["State"]=> string(2) "VA" ["CityName"]=> string(10) "Flint Hill" ["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) "22627" ["zip3"]=> string(3) "226" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(10) "FLINT HILL" ["zipstate"]=> string(2) "VA" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "38.76" ["iplongitude"]=> string(5) "-78.1" ["ziplocation"]=> string(19) "NA-US-VA-FLINT HILL" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "449" ["zippopulation"]=> string(3) "780" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "226" ["zipcity"]=> string(10) "WINCHESTER" ["zipstate"]=> string(2) "VA" }

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

array(22) { ["id"]=> string(5) "20581" ["State"]=> string(2) "VA" ["CityName"]=> string(10) "Winchester" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(3) "179" ["Population"]=> string(5) "21947" ["Latitude"]=> string(9) "39.178355" ["Longitude"]=> string(10) "-78.166771" ["PrimaryAC"]=> string(3) "276" ["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) "20581" ["Population2000"]=> string(5) "23585" ["FIPS"]=> string(7) "5186720" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "225" }

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

No Rows in Recordset!

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

8 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ISPCount	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
20581	VA	Winchester	0	179	21947	39.178355	-78.166771	276		20581	23585	5186720	-5	-1	225
20336	VA	Front Royal	-1	100	11880	38.925768	-78.191914	276		20336	13589	5129968	-5	-1	225
20534	VA	Strasburg	-1	0	3762	38.99055	-78.358615	540		20534	4017	5176000	-5	-1	225
20584	VA	Woodstock	-1	0	3182	38.877075	-78.511521	540		20584	3952	5187712	-5	-1	225
20209	VA	Berryville	-1	11	3097	39.150973	-77.982395	540		20209	2963	5106968	-5	-1	225
20317	VA	Elkton	-1	36	1935	38.408298	-78.620321	540		20317	2042	5125408	-5	-1	225
20531	VA	Stephens City	0	4		39.086098	-78.219601	540		20531	1146	5175344	-5	-1	225
63658	VA	Gore		12					0	63658			-5	-1	225

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

28 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
22630	FRONT ROYAL	VA	24004	Front Royal	225
22602	WINCHESTER	VA	23322	Winchester	225
22601	WINCHESTER	VA	20057	Winchester	225
22655	STEPHENS CITY	VA	16259	Stephens City	225
22603	WINCHESTER	VA	11470	Winchester	225
22657	STRASBURG	VA	8855	Strasburg	225
22611	BERRYVILLE	VA	7282	Berryville	225
22664	WOODSTOCK	VA	7068	Woodstock	225
22642	LINDEN	VA	3722
22645	MIDDLETOWN	VA	3154	Middletown
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
22625	CROSS JUNCTION	VA	3013
22624	CLEAR BROOK	VA	2287
22656	STEPHENSON	VA	2118
22637	GORE	VA	1784	Gore	225
22644	MAURERTOWN	VA	1767
22620	BOYCE	VA	1744	Boyce
22610	BENTONVILLE	VA	1566
22660	TOMS BROOK	VA	1488	Toms Brook
22663	WHITE POST	VA	1291
22652	FORT VALLEY	VA	1138	Fort Valley
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
22650	RILEYVILLE	VA	802
22627	FLINT HILL	VA	780	Flint Hill
22654	STAR TANNERY	VA	653
22639	HUME	VA	573
22640	HUNTLY	VA	0
22643	MARKHAM	VA	0
22649	MIDDLETOWN	VA	0	Middletown
22641	STRASBURG	VA	0	Strasburg	225

Station W243AF-FX

City FLINT HILL-VA

City Flint Hill, VA is located in DMAID: