Fix WKHC 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 = 'HATTERAS' and State = 'NC'

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: 1754168282.3856
End: 1754168282.3858
Elapsed time: 0.2711 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NC','Hatteras',-1)

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

array(22) { ["id"]=> string(5) "80007" ["State"]=> string(2) "NC" ["CityName"]=> string(8) "Hatteras" ["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) "27943" ["zip3"]=> string(3) "279" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(8) "HATTERAS" ["zipstate"]=> string(2) "NC" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "35.21" ["iplongitude"]=> string(6) "-75.68" ["ziplocation"]=> string(17) "NA-US-NC-HATTERAS" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "398" ["zippopulation"]=> string(3) "648" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "279" ["zipcity"]=> string(14) "ELIZABETH CITY" ["zipstate"]=> string(2) "NC" }

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

array(22) { ["id"]=> string(5) "11106" ["State"]=> string(2) "NC" ["CityName"]=> string(14) "Elizabeth City" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(2) "59" ["Population"]=> string(5) "14292" ["Latitude"]=> string(9) "36.295585" ["Longitude"]=> string(10) "-76.224954" ["PrimaryAC"]=> string(3) "252" ["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) "11106" ["Population2000"]=> string(5) "17188" ["FIPS"]=> string(7) "3720580" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> string(3) "245" }

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

No Rows in Recordset!

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

17 records found!

id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
11106	NC	Elizabeth City	-1	59	14292	36.295585	-76.224954	252		0		0	0	0	0	11106	17188	3720580	-5	-1	245
11105	NC	Edenton	-1	56	5268	36.061855	-76.605766	252		0		0	0	0	0	11105	5394	3720120	-5	-1	245
11001	NC	Ahoskie	-1	61	4391	36.286439	-76.986436	252		0		0	0	0	0	11001	4523	3700500	-5	-1	245
11284	NC	Plymouth	-1	65	4328	35.859729	-76.74777	252		0		0	0	0	0	11284	4107	3753040	-5	-1	245
11184	NC	Kill Devil Hills	0	166	4238	36.025448	-75.670105	252		0		0	0	0	0	11184	5897	3735720	-5	-1	245
11027	NC	Belhaven	-1	0	2269	35.54293	-76.623278	252		0		0	0	0	0	11027	1968	3704640	-5	-1	245
11163	NC	Hertford	-1	0	2105	36.187292	-76.472345	252		0		0	0	0	0	11163	2070	3730900	-5	-1	245
11407	NC	Windsor	-1	61	2056	35.998145	-76.948973	252		0		0	0	0	0	11407	2283	3774680	-5	-1	245
37596	NC	Nags Head	-1	0	1838	35.932004	-75.615085			0		0	0	0	0		2700	3745880	-5	-1	245
37698	NC	Wanchese	-1	0	1380	35.845046	-75.639544			0		0	0	0	0		1527	3770920	-5	-1	245
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
11220	NC	Manteo	-1	0	991	35.904595	-75.669385	252		0		0	0	0	0	11220	1052	3741060	-5	-1	245
11084	NC	Columbia	-1	93	836	35.917902	-76.249688	252		0		0	0	0	0	11084	819	3713940	-5	-1	245
37711	NC	Winfall	-1	0	501	36.214551	-76.456758			0		0	0	0	0		554	3774720	-5	-1	245
11135	NC	Gatesville	-1	64	308	36.40439	-76.758435	252		0		0	0	0	0	11135	281	3725680	-5	-1	245
11390	NC	Waves	-1	0				252		0		0	0	0	0	11390			-5	-1	245
11265	NC	Ocracoke	-1	0		35.112687	-75.975895	252		0		0	0	0	0	11265	769	3748740	-5	-1	245
11052	NC	Buxton	-1	0				252		0		0	0	0	0	11052			-5	-1	245

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

47 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
27909	ELIZABETH CITY	NC	29701	Elizabeth City	245
27932	EDENTON	NC	9972	Edenton	245
27948	KILL DEVIL HILLS	NC	9130	Kill Devil Hills	245
27944	HERTFORD	NC	8794	Hertford	245
27910	AHOSKIE	NC	8247	Ahoskie	245
27958	MOYOCK	NC	8123	Moyock	40
27949	KITTY HAWK	NC	6888	Kitty Hawk
27983	WINDSOR	NC	6409	Windsor	245
27962	PLYMOUTH	NC	5748	Plymouth	245
27954	MANTEO	NC	5270	Manteo	245
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
27921	CAMDEN	NC	4086
27925	COLUMBIA	NC	2936	Columbia	245
27937	GATES	NC	2907
27976	SOUTH MILLS	NC	2768	South Mills
27970	ROPER	NC	2689	Roper
27959	NAGS HEAD	NC	2496	Nags Head	245
27924	COLERAIN	NC	2241	Colerain
27939	GRANDY	NC	2059
27980	TYNER	NC	1705	Tyner
27928	CRESWELL	NC	1557	Creswell
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
27950	KNOTTS ISLAND	NC	1553	Knotts Island
27981	WANCHESE	NC	1385	Wanchese	245
27926	CORAPEAKE	NC	1344
27979	SUNBURY	NC	1259	Sunbury
27935	EURE	NC	1209
27938	GATESVILLE	NC	1177	Gatesville	245
27957	MERRY HILL	NC	1163
27973	SHAWBORO	NC	1108
27929	CURRITUCK	NC	1097
27974	SHILOH	NC	1009	Shiloh
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
27986	WINTON	NC	948	Winton
27919	BELVIDERE	NC	932	Belvidere
27946	HOBBSVILLE	NC	932
27966	POWELLS POINT	NC	918	Powells Point
27953	MANNS HARBOR	NC	785
27947	JARVISBURG	NC	686
27927	COROLLA	NC	666
27922	COFIELD	NC	662	Cofield
27942	HARRELLSVILLE	NC	617	Harrellsville
27916	AYDLETT	NC	528
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
27941	HARBINGER	NC	517
27917	BARCO	NC	499
27923	COINJOCK	NC	477	Coinjock
27964	POINT HARBOR	NC	453
27965	POPLAR BRANCH	NC	424
27978	STUMPY POINT	NC	0
27956	MAPLE	NC	0

Station WKHC-FM

City HATTERAS-NC

City Hatteras, NC is located in DMAID: