Re: [WISPA] [WISPA Members] Possible way to create a free tool for 477 reporting data at the tract level

2010-02-20 Thread Mac Dearman
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

Re: [WISPA] [WISPA Members] Possible way to create a free tool for 477 reporting data at the tract level

2010-02-19 Thread Cameron Crum
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

Re: [WISPA] [WISPA Members] Possible way to create a free tool for 477 reporting data at the tract level

2010-02-18 Thread Mac Dearman
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

Re: [WISPA] [WISPA Members] Possible way to create a free tool for 477 reporting data at the tract level

2010-02-18 Thread Matt Liotta
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

Re: [WISPA] [WISPA Members] Possible way to create a free tool for 477 reporting data at the tract level

2010-02-18 Thread Scott Reed
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. Mac Dearman wrote: I would be glad to start a $$ pool to have someone develop a tool for WISPA members to get

Re: [WISPA] [WISPA Members] Possible way to create a free tool for 477 reporting data at the tract level

2010-02-18 Thread David E. Smith
On Thu, Feb 18, 2010 at 09:54, Scott Reed scottr...@onlyinternet.netwrote: 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. How accurate is it, though? We actually tried something similar to that, and when

Re: [WISPA] [WISPA Members] Possible way to create a free tool for 477 reporting data at the tract level

2010-02-18 Thread Scott Reed
I am mostly rural with about 370 subs. It hit all but 4 of them that had valid addresses. It showed me 2 that I had mistyped addresses and 2 were the billing not the service address. David E. Smith wrote: On Thu, Feb 18, 2010 at 09:54, Scott Reed scottr...@onlyinternet.netwrote: The

Re: [WISPA] [WISPA Members] Possible way to create a free tool for 477 reporting data at the tract level

2010-02-18 Thread David E. Smith
On Thu, Feb 18, 2010 at 10:30, Scott Reed scottr...@onlyinternet.netwrote: I am mostly rural with about 370 subs. It hit all but 4 of them that had valid addresses. It showed me 2 that I had mistyped addresses and 2 were the billing not the service address. Weird. Out of curiosity, does

Re: [WISPA] [WISPA Members] Possible way to create a free tool for 477 reporting data at the tract level

2010-02-18 Thread Scott Reed
Yes, as far as I know my entire area has 911 addressing. That would make a huge difference. David E. Smith wrote: On Thu, Feb 18, 2010 at 10:30, Scott Reed scottr...@onlyinternet.netwrote: I am mostly rural with about 370 subs. It hit all but 4 of them that had valid addresses. It

Re: [WISPA] [WISPA Members] Possible way to create a free tool for 477 reporting data at the tract level

2010-02-17 Thread Rick Harnish
WISPA will gladly place this on our webpage if we can find someone to help get it in place. Thanks, Rick From: members-boun...@wispa.org [mailto:members-boun...@wispa.org] On Behalf Of Brian Webster Sent: Wednesday, February 17, 2010 7:20 PM To: WISPA List; memb...@wispa. org; Motorla

Re: [WISPA] [WISPA Members] Possible way to create a free tool for 477 reporting data at the tract level

2010-02-17 Thread Scott Reed
I will be working on that in the morning as I have all my customers geocoded for Lat/Lon, but need the census stuff. When I get something that works, I will get it to Rick. Rick Harnish wrote: WISPA will gladly place this on our webpage if we can find someone to help get it in place.