Fix K210ET Station DMA

Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix K210ET 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 = 'MOAPA' and State = 'NV'

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

Number of rows returned = 1
Start: 1754168753.6164
End: 1754168753.6165
Elapsed time: 0.1311 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
13134 NV Moapa -1 0 36.691647 -114.651381 702 0 0 0 0 0 -8 -1 32

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

NULL

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

array(13) { ["zipcode"]=> string(5) "89025" ["zip3"]=> string(3) "890" ["ziptype"]=> string(6) "PO BOX" ["zipcity"]=> string(5) "MOAPA" ["zipstate"]=> string(2) "NV" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "36.63" ["iplongitude"]=> string(7) "-114.62" ["ziplocation"]=> string(14) "NA-US-NV-MOAPA" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "519" ["zippopulation"]=> string(3) "991" ["zipincome"]=> string(7) "8388607" }

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

array(3) { ["zip3"]=> string(3) "890" ["zipcity"]=> string(9) "HENDERSON" ["zipstate"]=> string(2) "NV" }

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

array(22) { ["id"]=> string(5) "13111" ["State"]=> string(2) "NV" ["CityName"]=> string(9) "Henderson" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(1) "0" ["Population"]=> string(5) "64942" ["Latitude"]=> string(9) "36.029249" ["Longitude"]=> string(11) "-115.025286" ["PrimaryAC"]=> string(3) "702" ["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) "13111" ["Population2000"]=> string(6) "175381" ["FIPS"]=> string(7) "3231900" ["cTZoffset"]=> string(2) "-8" ["DST"]=> string(2) "-1" ["DMAID"]=> string(2) "32" }

**** 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
13120	NV	Las Vegas	0	752	258295	36.194168	-115.22206	702		1		1	0	0	0	13120	478434	3240000	-8	-1	32
13111	NV	Henderson	0	0	64942	36.029249	-115.025286	702		0		0	0	0	0	13111	175381	3231900	-8	-1	32
38414	NV	Spring Valley	-1	0	51726	36.11252	-115.250198			0		0	0	0	0		117390	3268585	-8	-1	32
38411	NV	North Las Vegas	-1	0	47707	36.228511	-115.146593			0		0	0	0	0		115488	3251800	-8	-1	32
13144	NV	Pahrump	-1	131	7424	36.208669	-116.012071	775		0		0	0	0	0	13144	24631	3253800	-8	-1	32
13122	NV	Laughlin	0	178	4791	35.141554	-114.618512	702		0		0	0	0	0	13122	7076	3241000	-8	-1	32
13164	NV	Tonopah	-1	1	3616	38.069058	-117.230502	775		0		0	0	0	0	13164	2627	3273600	-8	-1	32
13086	NV	Beatty	-1	128	1623	36.909337	-116.754531	775		0		0	0	0	0	13086	1154	3205100	-8	-1	32
13089	NV	Caliente	-1	0	1111	37.615199	-114.514106	702		0		0	0	0	0	13089	1123	3208500	-8	-1	32
1279	AZ	Dolan Springs	-1	0	1090	35.615835	-114.260804	928		0		0	0	0	0		1867	419630	-7	0	32
id	State	CityName	RuralArea	PopCount	Population	Latitude	Longitude	PrimaryAC	ZoneDesc	EartlinkDSL	ISPCount	CovadDSL	VerizonDSL	allegiance	SBC	RateCenterCityid	Population2000	FIPS	cTZoffset	DST	DMAID
69188	NV	Bunkerville		0	0	36.765276	-114.136356			0	0	0	0	0	0	0	1014	3208100	-8	-1	32
13145	NV	Panaca	-1	0		37.759736	-114.972405	775		0		0	0	0	0	13145			-8	-1	32
13147	NV	Pioche	-1	0		37.759736	-114.972405	775		0		0	0	0	0	13147			-8	-1	32
13150	NV	Round Mountain	-1	33		37.583805	-116.598559	775		0		0	0	0	0	13150			-8	-1	32
13134	NV	Moapa	-1	0		36.691647	-114.651381	702		0		0	0	0	0				-8	-1	32
13109	NV	Goldfield	-1	0		37.722454	-117.796454	775		0		0	0	0	0	13109			-8	-1	32
13098	NV	Dyer	-1	0		37.585111	-117.604871	775		0		0	0	0	0				-8	-1	32
63667	NV	Logandale		0						0	0	0	0	0	0	63667			-8	-1	32
13142	NV	Overton	-1	0		36.570259	-114.473191	702		0		0	0	0	0	13142			-8	-1	32

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

40 records found!

zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
89031	NORTH LAS VEGAS	NV	48996	North Las Vegas	32
89052	HENDERSON	NV	38648	Henderson	32
89074	HENDERSON	NV	38386	Henderson	32
89030	NORTH LAS VEGAS	NV	37689	North Las Vegas	32
89032	NORTH LAS VEGAS	NV	31235	North Las Vegas	32
89015	HENDERSON	NV	30967	Henderson	32
89014	HENDERSON	NV	30076	Henderson	32
89002	HENDERSON	NV	24976	Henderson	32
89012	HENDERSON	NV	23313	Henderson	32
89081	NORTH LAS VEGAS	NV	21281	North Las Vegas	32
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
89084	NORTH LAS VEGAS	NV	16445	North Las Vegas	32
89011	HENDERSON	NV	14840	Henderson	32
89048	PAHRUMP	NV	12946	Pahrump	32
89005	BOULDER CITY	NV	12140	Boulder City
89044	HENDERSON	NV	12009	Henderson	32
89027	MESQUITE	NV	9418	Mesquite
89060	PAHRUMP	NV	7106	Pahrump	32
89029	LAUGHLIN	NV	4587	Laughlin	32
89086	NORTH LAS VEGAS	NV	3482	North Las Vegas	32
89061	PAHRUMP	NV	3343	Pahrump	32
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
89040	OVERTON	NV	2610	Overton	32
89085	NORTH LAS VEGAS	NV	2431	North Las Vegas	32
89019	JEAN	NV	2184	Jean
89049	TONOPAH	NV	2059	Tonopah	32
89045	ROUND MOUNTAIN	NV	1397	Round Mountain	32
89008	CALIENTE	NV	920	Caliente	32
89020	AMARGOSA VALLEY	NV	898	Amargosa Valley
89033	NORTH LAS VEGAS	NV	877	North Las Vegas	32
89001	ALAMO	NV	769	Alamo
89043	PIOCHE	NV	752	Pioche	32
zipcode	zipcity	zipstate	zippopulation	cityname	DMAID
89034	MESQUITE	NV	567	Mesquite
89046	SEARCHLIGHT	NV	476	Searchlight
89017	HIKO	NV	0	Hiko
89010	DYER	NV	0	Dyer	32
89013	GOLDFIELD	NV	0	Goldfield	32
89054	SLOAN	NV	0
89037	COYOTE SPRINGS	NV	0	Coyote Springs
89067	COYOTE SPRINGS	NV	0	Coyote Springs
89087	NORTH LAS VEGAS	NV	0	North Las Vegas	32
89039	CAL NEV ARI	NV	0

Station K210ET-FX

City MOAPA-NV

City , is located in DMAID: