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


Number of rows returned = 0
Start: 1754176739.2178
End: 1754176739.2179
Elapsed time: 0.1850 ms No Rows in Recordset!

*** insert into cities(State,CityName,ruralarea) values('NY','Durhamville',-1)

*** city ***************
array(22) { ["id"]=> string(5) "80144" ["State"]=> string(2) "NY" ["CityName"]=> string(11) "Durhamville" ["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) "13054" ["zip3"]=> string(3) "130" ["ziptype"]=> string(8) "STANDARD" ["zipcity"]=> string(11) "DURHAMVILLE" ["zipstate"]=> string(2) "NY" ["ziploctype"]=> string(7) "PRIMARY" ["ziplatitude"]=> string(5) "43.12" ["iplongitude"]=> string(6) "-75.67" ["ziplocation"]=> string(20) "NA-US-NY-DURHAMVILLE" ["decommissioned"]=> string(5) "false" ["taxreturns"]=> string(3) "744" ["zippopulation"]=> string(4) "1312" ["zipincome"]=> string(7) "8388607" }
******* zip3 ***********
array(3) { ["zip3"]=> string(3) "130" ["zipcity"]=> string(9) "LIVERPOOL" ["zipstate"]=> string(2) "NY" }
**** zip3 city**************
array(22) { ["id"]=> string(5) "13565" ["State"]=> string(2) "NY" ["CityName"]=> string(9) "Liverpool" ["RuralArea"]=> string(1) "0" ["PopCount"]=> string(2) "93" ["Population"]=> string(4) "2624" ["Latitude"]=> string(9) "43.105967" ["Longitude"]=> string(10) "-76.209564" ["PrimaryAC"]=> string(3) "315" ["ZoneDesc"]=> NULL ["EartlinkDSL"]=> string(1) "0" ["ISPCount"]=> NULL ["CovadDSL"]=> string(1) "0" ["VerizonDSL"]=> string(1) "1" ["allegiance"]=> string(1) "0" ["SBC"]=> string(1) "0" ["RateCenterCityid"]=> string(5) "13565" ["Population2000"]=> string(4) "2505" ["FIPS"]=> string(7) "3642884" ["cTZoffset"]=> string(2) "-5" ["DST"]=> string(2) "-1" ["DMAID"]=> NULL }
**** cities in DMA per station **************
No Rows in Recordset!

**** cities in zip3 **************
44 records found!
zipcodezipcityzipstatezippopulationcitynameDMAID
13021AUBURNNY31058Auburn77
13027BALDWINSVILLENY27650Baldwinsville77
13090LIVERPOOLNY26337Liverpool
13069FULTONNY19739Fulton77
13045CORTLANDNY19439Cortland179
13088LIVERPOOLNY18946Liverpool
13039CICERONY15407Cicero
13031CAMILLUSNY14099Camillus
13057EAST SYRACUSENY13212East Syracuse
13066FAYETTEVILLENY11455Fayetteville
zipcodezipcityzipstatezippopulationcitynameDMAID
13032CANASTOTANY10386Canastota
13041CLAYNY9355
13078JAMESVILLENY8134
13037CHITTENANGONY7640Chittenango
13036CENTRAL SQUARENY7311Central Square
13035CAZENOVIANY6634Cazenovia
13029BREWERTONNY6090Brewerton
13077HOMERNY5647Homer
13073GROTONNY5355Groton
13068FREEVILLENY4276Freeville
zipcodezipcityzipstatezippopulationcitynameDMAID
13082KIRKVILLENY4083
13084LA FAYETTENY3979
13053DRYDENNY3793Dryden
13030BRIDGEPORTNY3553Bridgeport77
13074HANNIBALNY3504Hannibal
13080JORDANNY3149Jordan
13033CATONY3115Cato
13060ELBRIDGENY2521Elbridge
13040CINCINNATUSNY2228Cincinnatus
13044CONSTANTIANY2224Constantia
zipcodezipcityzipstatezippopulationcitynameDMAID
13092LOCKENY2015
13076HASTINGSNY1981
13042CLEVELANDNY1823Cleveland
13063FABIUSNY1634Fabius
13052DE RUYTERNY1563De Ruyter
13034CAYUGANY1505Cayuga
13083LACONANY1470Lacona
13054DURHAMVILLENY1312Durhamville
13026AURORANY1098Aurora
13028BERNHARDS BAYNY1020
zipcodezipcityzipstatezippopulationcitynameDMAID
13081KING FERRYNY987
13061ERIEVILLENY921
13071GENOANY897
13072GEORGETOWNNY633Georgetown
Station W279CK-FX
City DURHAMVILLE-NY

City Durhamville, NY is located in DMAID: