Does any of this info help? http://bakergis.com/kybroadbandprovider/ -RickG
On Wed, Feb 24, 2010 at 5:00 PM, <cc...@dot11net.com> wrote: > It's finally ready. We ran into some issues writing this mostly because > the free geocoding services have a hit-rate limit and a hard count limit > per day for geocoding addresses. So, here are some instructions (these are > on the web page as well). The file you will need to upload is in the > following format: > > First,Last,Address,City,State,Zip,Lat,Lon,Upload Rate,Download > Rate,Technology_Code > > (no spaces after commas) > > Here is an example: > > John,Doe,6908 Wooded Acres Trail,Mansfield,TX,76063,,,3,3,7 > Jim,Smith,7400 Wooded Acres Trail,Mansfield,TX,76063,,,3,3,7 > Jane,Doe,7116 Lakes End Ct.,Mansfield,TX,76063,32.4567,-97.38764,3,5,7 > > The numbers following the lat,lon fields are the rate codes defined by the > FCC, and the Technology Code defined by the FCC. These are: > > Upload Rates: > 1 Less than or equal to 200 kbps > 2 Greater than 200 kbps and less than 768 kbps > 3 Greater than or equal to 768 kbps and less than 1.5 mbps > 4 Greater than or equal to 1.5 mbps and less than 3 mbps > 5 Greater than or equal to 3 mbps and less than 6 mbps > 6 Greater than or equal to 6 mbps and less than 10 mbps > 7 Greater than or equal to 10 mbps and less than 25 mbps > 8 Greater than or equal to 25 mbps and less than 100 mbps > 9 Greater than or equal to 100 mbps > > Download Rates: > > (there is no 1) > 2 Greater than 200 kbps and less than 768 kbps > 3 Greater than or equal to 768 kbps and less than 1.5 mbps > 4 Greater than or equal to 1.5 mbps and less than 3 mbps > 5 Greater than or equal to 3 mbps and less than 6 mbps > 6 Greater than or equal to 6 mbps and less than 10 mbps > 7 Greater than or equal to 10 mbps and less than 25 mbps > 8 Greater than or equal to 25 mbps and less than 100 mbps > 9 Greater than or equal to 100 mbps > > Technology Codes: > > 1 Asymmetric xDSL > 2 Symmetric xDSL > 3 Other Wireline > 4 Cable Modem > 5 Optical Carrier (fiber to the end user) > 6 Satellite > 7 Terrestrial Fixed Wireless > 8 Terrestrial Mobile Wireless > 9 Electric Power Line > 0 All Other > > > > You can include the Lat, Lon if you have them and things will go much > faster, or you can leave them blank and they will be geocoded for you. If > a whole lot of people try to geocode, we may hit the hard limits on our > accounts and the program will not complete. We would prefer if you submit > data already geocoded. So, to help with that, I have attached an adobe air > application (also downloadable at http://www.wispmon.com/air_geocoder.zip) > that you can use to geocode your database prior to submission. You may > need to install adobe air to run it...get it at adobe.com for free. Save > the attached application to your desktop and double click it. It should be > pretty intuitive. It takes a file in format: > > First,Last,Address,City,State,Zip > > An example would be: > John,Doe,6908 Wooded Acres Trail,Mansfield,TX,76063 > Jim,Smith,7400 Wooded Acres Trail,Mansfield,TX,76063 > > This processes about 4 entries per second. > > You can also use any of the mapping services to geocode your database if > you are a good coder, or the link suggested the other day at: > > https://webgis.usc.edu/Services/Geocode/BatchProcess/Default.aspx > > > After geocoding, if you decide to go that route, go to the link at the > bottom of the page. Once you have uploaded your data to our utility, you > will be taken to a map of your customers, and can view/copy/paste the data > from the page and the result files will be emailed to you as well. Any > questions need to go to cc...@wispmon.com. One final thing...if you are > geocoding on our server as opposed to on your desktop, the process can > take a while. We tested about 1100 addresses and it took about 5 minutes > to geocode and generate the files. Even if the geocoding craps out because > of hard limits, you will be taken to a map. Look at the "Result Data" tab. > If the fields are blank, then send us an email and we'll see what went > wrong. If you have more than 2000 addresses to geocode and you plan on > using the server, please hit me off list before trying the utility at > cc...@wispmon.com. > > To get to the util, go to http://www.wispmon.com > > In the upper left you will see the link to the FCC 477 Util. > > Regards, > > Cameron > > > > > > > -------------------------------------------------------------------------------- > 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/