Notice: A non well formed numeric value encountered in /home/radiotest/adm/fixdma.php on line 12
Fix K257CQ 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 = 'KAHULUI' and State = 'HI'
TableTypePossible KeysKeyKey LengthRefRowsExtra
citiesrefCityNameCityName53const1Using where


Number of rows returned = 1
Start: 1754175943.708
End: 1754175943.7087
Elapsed time: 0.7329 ms 1 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
3742HIKahului-101688920.881756-156.46744680800000201461522700-10063

*** city ***************
NULL
****** zip code ************
array(13) { ["zipcode"]=> string(5) "96732" ["zip3"]=> string(3) "967" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(7) "KAHULUI" ["zipstate"]=> string(2) "HI" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "20.87" ["iplongitude"]=> string(7) "-156.45" ["ziplocation"]=> string(16) "NA-US-HI-KAHULUI" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(5) "10071" ["zippopulation"]=> string(5) "17192" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "967" ["zipcity"]=> string(7) "WAIPAHU" ["zipstate"]=> string(2) "HI" }
**** zip3 city**************
array(22) { ["id"]=> string(4) "3769" ["State"]=> string(2) "HI" ["CityName"]=> string(7) "Waipahu" ["RuralArea"]=> string(2) "-1" ["PopCount"]=> string(1) "0" ["Population"]=> string(5) "31435" ["Latitude"]=> string(7) "21.3925" ["Longitude"]=> string(10) "-158.01071" ["PrimaryAC"]=> string(3) "808" ["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"]=> NULL ["Population2000"]=> string(5) "33108" ["FIPS"]=> string(7) "1579700" ["cTZoffset"]=> string(3) "-10" ["DST"]=> string(1) "0" ["DMAID"]=> string(2) "63" }
**** cities in DMA per station **************
No Rows in Recordset!

***** cities in DMA by city *************
43 records found!
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
3739HIHonolulu018236527221.30895-157.8261828080010037393716571517000-10063
3737HIHilo01053780819.70552-155.085918808001003737407591514650-10063
3743HIKailua-103681819.649973-155.9940288080000098701523000-10063
3745HIKaneohe-103544821.4092-157.79908480800000349701528250-10063
3769HIWaipahu-103143521.3925-158.0107180800000331081579700-10063
3763HIWahiawa-101738621.502574-158.02293880800000161511572650-10063
3742HIKahului-101688920.881756-156.46744680800000201461522700-10063
34378HIKihei-101110720.759122-156.45722800000167491536500-10063
3767HIWailuku01041068820.891923-156.502177808001003767122961577450-10063
3750HILahaina-10907320.886122-156.6746028080000091181542950-10063
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
3732HIAiea-10890621.3859-157.9309278080000090191500550-10063
3765HIWaianae-10875821.447714-158.17921380800000105061574450-10063
34371HIKapaa-10814922.088281-159.3377060000094721528850-10063
34424HIWaimea-10597221.961662-159.6736040000017871578800-10063
34410HIPukalani-10587920.840039-156.3438080000073801565900-10063
3753HILihue099553621.97481-159.36557680800100375356741545200-10063
3754HIMakawao-10540520.853657-156.3169518080000063271548050-10063
3734HIHaiku-10450920.921381-156.30431980800000-10063
3764HIWaialua-10394321.5753-158.1294578080000037611574000-10063
34359HIHolualoa-10383419.616353-155.9682780000061071515700-10063
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
34350HIHanamaulu-10361121.997387-159.3571330000032721511650-10063
34367HIKalaheo-10359221.92443-159.5293580000039131524950-10063
32781ASPago Pago-103519-14.2412-170.7195770000013-163
3748HIKaunakakai042265821.088968-157.01254280800000374827261531100-10063
34340HICaptain Cook-10259519.498211-155.9042750000032061503850-10063
3735HIHaleiwa-10244221.59005-158.1139288080000022251510750-10063
3752HILanai City041240020.827574-156.92191280800000375231641543700-10063
34400HIPaia-10209120.910694-156.376340000024991560200-10063
34379HIKilauea-10168522.211103-159.4096090000020921536650-10063
3749HIKualapuu-10166121.160641-157.0665538080000019361539500-10063
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
34375HIKeaau-10158419.621072-155.0417060000020101532900-10063
34398HIPahala-10152019.204109-155.4790050000013781559750-10063
34415HIVolcano-10151619.449831-155.2354930000022311572350-10063
34341HIEleele-10148921.910489-159.584330000020401507000-10063
34376HIKealakekua-10145319.526436-155.9228910000016451533950-10063
34351HIHanapepe-10139521.916392-159.5904140000021531511800-10063
34407HIPrinceville-10124422.223513-159.4853920000016981565075-10063
34338HIAnahola-10118122.145049-159.3129690000019321502200-10063
34356HIHawi-1092420.241917-155.834013000009381513600-10063
3736HIHana-1068320.770017-155.994179808000007091511350-10063
idStateCityNameRuralAreaPopCountPopulationLatitudeLongitudePrimaryACZoneDescEartlinkDSLISPCountCovadDSLVerizonDSLallegianceSBCRateCenterCityidPopulation2000FIPScTZoffsetDSTDMAID
3759HIPaauilo-1062020.043769-155.370323808000005711559300-10063
34349HIHanalei-1046122.206653-159.500713000004781511500-10063
3760HIPearl City-1021.408333-157.96690280800000309761562600-10063
**** cities in zip3 **************
48 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
96797WAIPAHUHI60366Waipahu63
96706EWA BEACHHI48268Ewa Beach
96789MILILANIHI46664Mililani
96744KANEOHEHI46556Kaneohe63
96734KAILUAHI40200Kailua63
96720HILOHI37207Hilo63
96701AIEAHI35697Aiea63
96792WAIANAEHI33249Waianae63
96782PEARL CITYHI32267Pearl City63
96786WAHIAWAHI29939Wahiawa63
zipcodezipcityzipstatezippopulationcitynameDMAID
96707KAPOLEIHI28516Kapolei
96793WAILUKUHI22792Wailuku63
96753KIHEIHI19553Kihei63
96740KAILUA KONAHI18960Kailua Kona
96732KAHULUIHI17192Kahului63
96761LAHAINAHI15968Lahaina63
96746KAPAAHI13416Kapaa63
96766LIHUEHI12848Lihue63
96768MAKAWAOHI12697Makawao63
96749KEAAUHI10325Keaau63
zipcodezipcityzipstatezippopulationcitynameDMAID
96743KAMUELAHI9807Kamuela
96778PAHOAHI8045Pahoa
96795WAIMANALOHI7968Waimanalo
96791WAIALUAHI6091Waialua63
96708HAIKUHI6042Haiku63
96790KULAHI5940
96712HALEIWAHI5538Haleiwa63
96738WAIKOLOAHI5054Waikoloa
96750KEALAKEKUAHI4514Kealakekua63
96762LAIEHI4137Laie
zipcodezipcityzipstatezippopulationcitynameDMAID
96727HONOKAAHI4102Honokaa
96756KOLOAHI3999Koloa
96741KALAHEOHI3885Kalaheo63
96748KAUNAKAKAIHI3479Kaunakakai63
96704CAPTAIN COOKHI3442Captain Cook63
96779PAIAHI3245Paia63
96717HAUULAHI3161Hauula
96754KILAUEAHI2888Kilauea63
96771MOUNTAIN VIEWHI2490Mountain View
96725HOLUALOAHI2430Holualoa63
zipcodezipcityzipstatezippopulationcitynameDMAID
96731KAHUKUHI2303Kahuku
96760KURTISTOWNHI2271Kurtistown
96772NAALEHUHI1596Naalehu
96783PEPEEKEOHI1567Pepeekeo
96722PRINCEVILLEHI1531Princeville63
96713HANAHI1366Hana63
96781PAPAIKOUHI1343Papaikou
96730KAAAWAHI1235Kaaawa
Station K257CQ-FX
City KAHULUI-HI

City , is located in DMAID: