All I can say is guys like you (Cameron) that donate their time and effort and have the ability to do this - -well - - are just fine folks. I wish I had a little Geek in me, but I am full blooded redneck :-) I can't even code a combination lock, but if you ever get this way I can surely make you a gumbo or jambalaya that is fittin for a King or grill you some Redfish that you'll never forget.
Mac > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Cameron Crum > Sent: Friday, February 19, 2010 6:13 AM > To: [email protected]; [email protected] > Subject: Re: [WISPA] [WISPA Members] Possible way to create a free tool > for 477 reporting data at the tract level > > OK, so I got distracted by my business today and won't have this ready > until Monday or Tuesday. However, it will do a lot. It will take an > input file of csv format, and not only will it return the properly > formatted file for the 477 form, but it will show you all your > customers > on a map with the census tracts overlaid so you can visually verify. > I'll keep the list updated as to the progress. > > Cameron > > On 2/19/2010 1:15 AM, Cameron Crum wrote: > > I have this app done and am wrapping up the front end to allow anyone > > to upload a csv file with a list of addresses that will be geocoded > > and then referenced to a tract. Output will be a csv file so you can > > do what you like with it. I should have it up on our site by the end > > of the day and will keep you all posted. > > > > Cameron > > > > On 2/19/2010 10:46 AM, Brian Webster wrote: > >> Here is the list of state FIPS codes needed: > >> 01 Alabama > >> 02 Alaska > >> 04 Arizona > >> 05 Arkansas > >> 06 California > >> 08 Colorado > >> 09 Connecticut > >> 10 Delaware > >> 11 District of Columbia > >> 12 Florida > >> 13 Georgia > >> 15 Hawaii > >> 16 Idaho > >> 17 Illinois > >> 18 Indiana > >> 19 Iowa > >> 20 Kansas > >> 21 Kentucky > >> 22 Louisiana > >> 23 Maine > >> 24 Maryland > >> 25 Massachusetts > >> 26 Michigan > >> 27 Minnesota > >> 28 Mississippi > >> 29 Missouri > >> 30 Montana > >> 31 Nebraska > >> 32 Nevada > >> 33 New Hampshire > >> 34 New Jersey > >> 35 New Mexico > >> 36 New York > >> 37 North Carolina > >> 38 North Dakota > >> 39 Ohio > >> 40 Oklahoma > >> 41 Oregon > >> 42 Pennsylvania > >> 44 Rhode Island > >> 45 South Carolina > >> 46 South Dakota > >> 47 Tennessee > >> 48 Texas > >> 49 Utah > >> 50 Vermont > >> 51 Virginia > >> 53 Washington > >> 54 West Virginia > >> 55 Wisconsin > >> 56 Wyoming > >> 72 Puerto Rico > >> > >> Thank You, > >> Brian Webster > >> > >> -----Original Message----- > >> *From:* [email protected] > >> [mailto:[email protected]]*on Behalf Of *Scott Reed > >> *Sent:* Friday, February 19, 2010 11:14 AM > >> *To:* [email protected] > >> *Subject:* Re: [WISPA Members] [WISPA] Possible way to create a > >> free tool for 477 reporting data at the tract level > >> > >> I have a tool that will take a comma separated file in and > return > >> the file needed for Form477. I do not have a web interface or > >> anything for it, yet. > >> The file must be: > >> ID,Latitude,Longitude,upload,download > >> where ID is any identifier you want, upload is the upload speed > >> per the FCC list and download is the download speed per the FCC > list. > >> As long as I don't get overwhelmed, I can accept CSV files at > >> WISPAForm477[at]nwwnet.net and email the result back to you. > >> This is not a quick process but for a couple of weeks I will do > >> what I can. In the email you must tell me what state(s) to run > >> the data for. It would be best to give me the census number of > >> the state(s), but I can find it if need be. > >> > >> Scott Reed wrote: > >>> Ok, not all, but a lot of what was being complained about. > >>> And I agree, an application that would have data ready to > submit > >>> would be nice. > >>> > >>> Matt Liotta wrote: > >>>> Guess it depends on what you mean by it all. What I would > >>>> create would actually submit the data to the FCC in a format > >>>> they accept. IMHO, it is not enough to have a customer > database > >>>> with the information the FCC wants. You need to be able to > send > >>>> the data they desire in a format they specify. All of this can > >>>> be automated. > >>>> > >>>> -Matt > >>>> > >>>> On Feb 18, 2010, at 10:55 AM, Scott Reed wrote: > >>>> > >>>>> The USC site the Brian found last night does it all. > >>>>> Submit a database, get back a database with your lat, lon, > >>>>> county fips and tract. > >>>>> Database can be .csv or MS Access, maybe more. > >>>>> > >>>>> Matt Liotta wrote: > >>>>>> You raise the money. I'll do the programming. WISPA can keep > the money. > >>>>>> > >>>>>> -Matt > >>>>>> > >>>>>> On Feb 18, 2010, at 10:07 AM, Mac Dearman wrote: > >>>>>> > >>>>>> > >>>>>>> I would be glad to start a $$ pool to have someone develop > a tool for WISPA > >>>>>>> members to get the data we need for the form 477. On second > thoughts - - it > >>>>>>> would be better if we allowed everyone to use it (members > and non members) > >>>>>>> if we could just get them to report! > >>>>>>> > >>>>>>> Mac > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>> > >>>>>>>> -----Original Message----- > >>>>>>>> From:[email protected] [mailto:wireless- > [email protected]] On > >>>>>>>> Behalf Of Rick Harnish > >>>>>>>> Sent: Wednesday, February 17, 2010 6:48 PM > >>>>>>>> To:[email protected];[email protected]; 'WISPA > List'; > >>>>>>>> 'Motorla List Beehive'; 'WISPA Board' > >>>>>>>> Subject: Re: [WISPA] [WISPA Members] Possible way to > create a free tool > >>>>>>>> for 477 reporting data at the tract level > >>>>>>>> > >>>>>>>> WISPA will gladly place this on our webpage if we can find > someone to > >>>>>>>> help > >>>>>>>> get it in place. > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> Thanks, > >>>>>>>> > >>>>>>>> Rick > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> From:[email protected] [mailto:members- > [email protected]] On > >>>>>>>> Behalf > >>>>>>>> Of Brian Webster > >>>>>>>> Sent: Wednesday, February 17, 2010 7:20 PM > >>>>>>>> To: WISPA List; memb...@wispa. org; Motorla List Beehive; > WISPA Board > >>>>>>>> Subject: [WISPA Members] Possible way to create a free > tool for 477 > >>>>>>>> reporting data at the tract level > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> I just found this web page that talks about a free API > that could be > >>>>>>>> used on > >>>>>>>> a web page to do address lookup/geocode as well as map to > the proper > >>>>>>>> census > >>>>>>>> tract and/or census block. I'm not a programmer but maybe > someone on > >>>>>>>> the > >>>>>>>> list could look at this and put together something that > could be used. > >>>>>>>> Ideally it would do both single and batch lookups. If > there is a way to > >>>>>>>> also > >>>>>>>> standardize the address fields to increase the accuracy > that would be a > >>>>>>>> big > >>>>>>>> plus. > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> > https://webgis.usc.edu/Services/Geocode/WebService/GeocoderWebService.a > >>>>>>>> spx > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> Thank You, > >>>>>>>> > >>>>>>>> Brian Webster > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> No virus found in this incoming message. > >>>>>>>> Checked by AVG -www.avg.com > >>>>>>>> Version: 8.5.435 / Virus Database: 271.1.1/2691 - Release > Date: > >>>>>>>> 02/17/10 > >>>>>>>> 07:35:00 > >>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>>>> ---------------------------------------------------------- > ------------- > >>>>>>>> --------- > >>>>>>>> WISPA Wants You! Join today! > >>>>>>>> http://signup.wispa.org/ > >>>>>>>> ---------------------------------------------------------- > ------------- > >>>>>>>> --------- > >>>>>>>> > >>>>>>>> WISPA Wireless List:[email protected] > >>>>>>>> > >>>>>>>> Subscribe/Unsubscribe: > >>>>>>>> http://lists.wispa.org/mailman/listinfo/wireless > >>>>>>>> > >>>>>>>> Archives:http://lists.wispa.org/pipermail/wireless/ > >>>>>>>> No virus found in this incoming message. > >>>>>>>> Checked by AVG -www.avg.com > >>>>>>>> Version: 8.5.435 / Virus Database: 271.1.1/2694 - Release > Date: > >>>>>>>> 02/17/10 22:30:00 > >>>>>>>> > >>>>>>> ----------------------------------------------------------- > --------------------- > >>>>>>> WISPA Wants You! Join today! > >>>>>>> http://signup.wispa.org/ > >>>>>>> ----------------------------------------------------------- > --------------------- > >>>>>>> > >>>>>>> WISPA Wireless List:[email protected] > >>>>>>> > >>>>>>> Subscribe/Unsubscribe: > >>>>>>> http://lists.wispa.org/mailman/listinfo/wireless > >>>>>>> > >>>>>>> Archives:http://lists.wispa.org/pipermail/wireless/ > >>>>>>> > >>>>>> > >>>>>> _______________________________________________ > >>>>>> > >>>>>> WISPA Membership Mailing List > >>>>>> > >>>>>> ----------------------------------------------- > >>>>>> > >>>>>> > >>>>> > >>>>> -- > >>>>> Scott Reed > >>>>> Owner > >>>>> NewWays Networking, LLC > >>>>> Wireless Networking > >>>>> Network Design, Installation and Administration > >>>>> Mikrotik Advanced Certified > >>>>> www.nwwnet.net > >>>>> (765) 855-1060 > >>>>> _______________________________________________ > >>>>> > >>>>> WISPA Membership Mailing List > >>>>> > >>>>> ----------------------------------------------- > >>>> > >>>> -------------------------------------------------------------- > ---------- > >>>> > >>>> _______________________________________________ > >>>> > >>>> WISPA Membership Mailing List > >>>> > >>>> ----------------------------------------------- > >>> > >>> -- > >>> Scott Reed > >>> Owner > >>> NewWays Networking, LLC > >>> Wireless Networking > >>> Network Design, Installation and Administration > >>> Mikrotik Advanced Certified > >>> www.nwwnet.net > >>> (765) 855-1060 > >>> --------------------------------------------------------------- > --------- > >>> > >>> _______________________________________________ > >>> > >>> WISPA Membership Mailing List > >>> > >>> ----------------------------------------------- > >> > >> -- > >> Scott Reed > >> Owner > >> NewWays Networking, LLC > >> Wireless Networking > >> Network Design, Installation and Administration > >> Mikrotik Advanced Certified > >> www.nwwnet.net > >> (765) 855-1060 > >> > >> > >> _______________________________________________ > >> > >> WISPA Membership Mailing List > >> > >> ----------------------------------------------- > > > > > > _______________________________________________ > > > > WISPA Membership Mailing List > > > > ----------------------------------------------- > > > > ----------------------------------------------------------------------- > --------- > WISPA Wants You! Join today! > http://signup.wispa.org/ > ----------------------------------------------------------------------- > --------- > > WISPA Wireless List: [email protected] > > Subscribe/Unsubscribe: > http://lists.wispa.org/mailman/listinfo/wireless > > Archives: http://lists.wispa.org/pipermail/wireless/ > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.435 / Virus Database: 271.1.1/2699 - Release Date: > 02/20/10 07:34:00 -------------------------------------------------------------------------------- WISPA Wants You! Join today! http://signup.wispa.org/ -------------------------------------------------------------------------------- WISPA Wireless List: [email protected] Subscribe/Unsubscribe: http://lists.wispa.org/mailman/listinfo/wireless Archives: http://lists.wispa.org/pipermail/wireless/
