By hand. But we're going to see if we can set up access to give us the right csv data. We'll have to add several new fields and create (like we did for the current silly form) speed classifications for many of our customers.
The REALLY silly part for us? Most of our business customers buy the same type of account that our residential customers. Yet they (the fcc) think that there should be some quick and easy way for us to tell the difference based on something that we don't even keep track of. deep sigh marlon ----- Original Message ----- From: "Randy Cosby" <dco...@infowest.com> To: "WISPA General List" <wireless@wispa.org> Sent: Monday, March 16, 2009 2:00 PM Subject: Re: [WISPA] WAS: speaking of ARIN now 477 > Did you guys end up creating a CSV file to upload, or do it by hand, by > tract? > > > > David E. Smith wrote: >> Marlon K. Schafer wrote: >> >> >>> We had almost 7000 square miles of coverage to deal with. I don't know >>> how >>> many census tracts we had but there were roughly a dozen zip codes >>> before. >>> >> >> We went from about twenty-five ZIPs to.. about twenty-five census >> tracts. There was basically no correlation between the two, of course. >> >> Even after paying someone to geo-code our customer list, we still had to >> review about half our customers and assign them tracts by hand. (If your >> customer base is heavily urbanized, I imagine you could automatically >> geocode a lot more customers; we have a lot of "Rural Route" addresses, >> which tend to get put in comically wrong places.) >> >> At least next time around it'll be less painful. (We're retaining the >> customer-census associations, so we'll only have to manually map our new >> customers. This will work until, say, 2012 or so, when they draw up new >> tracts based on the 2010 census.) >> >> David Smith >> MVN.net >> >> >> >> -------------------------------------------------------------------------------- >> WISPA Wants You! Join today! >> http://signup.wispa.org/ >> -------------------------------------------------------------------------------- >> >> WISPA Wireless List: wireless@wispa.org >> >> Subscribe/Unsubscribe: >> http://lists.wispa.org/mailman/listinfo/wireless >> >> Archives: http://lists.wispa.org/pipermail/wireless/ >> > > -- > Randy Cosby > Vice President > InfoWest, Inc > > work: 435-773-6071 > email: rco...@infowest.com > > http://www.linkedin.com/in/randycosby > > > > -------------------------------------------------------------------------------- > WISPA Wants You! Join today! > http://signup.wispa.org/ > -------------------------------------------------------------------------------- > > WISPA Wireless List: wireless@wispa.org > > Subscribe/Unsubscribe: > http://lists.wispa.org/mailman/listinfo/wireless > > Archives: http://lists.wispa.org/pipermail/wireless/ -------------------------------------------------------------------------------- WISPA Wants You! Join today! http://signup.wispa.org/ -------------------------------------------------------------------------------- WISPA Wireless List: wireless@wispa.org Subscribe/Unsubscribe: http://lists.wispa.org/mailman/listinfo/wireless Archives: http://lists.wispa.org/pipermail/wireless/
