Over 20 years of data mangling, I’ve bought my share of demographics databases.
They’ve often turned out to be little more than slices of the US Census Bureau data. But early on it was worth it. Buying tapes from the Government was too time consuming, expensive and painful.
The dawn of the Internet brought a slight lifting of the Government’s skirt.
But while some data was posted to the web, it was too limited. And using the site was, well, stupid.
Eventually, I gave up. Cycled the Census Bureau site out of my short term memory. Zapped it.
That brings us to this morning.
The Background:
My town is trying to determine what, if any, wireless services make sense for a small midwestern city to offer without suppressing private investment. In the process, I posted the concerns of the Bettendorf Wireless Task Force (WTF), and asked you for input.
The response has been better than a guy has a right to expect… And by better, I mean higher quality.
Nearly every commenter brought important insight, with the result that you really got me thinking about the digital divide. I called our local Economic Development director, Steve Van Dyke, for more detailed demographics than I shared and linked to in the earlier article.
Van Dyke, who offers no pretense of being a web whiz, stepped me through the selections at… you guessed it… the US Census Bureau, to gems like this:
P87. POVERTY STATUS IN 1999 BY AGE - Universe: Population for whom poverty status is determined
Census 2000 Summary File 3 (SF 3)
|
ZIP: 52722 |
|
|
Total: |
33,466 |
|
Income in 1999 below poverty level: |
1,596 |
|
Under 5 years |
166 |
|
5 years |
32 |
|
6 to 11 years |
172 |
|
12 to 17 years |
128 |
|
18 to 64 years |
912 |
|
65 to 74 years |
95 |
|
75 years and over |
91 |
|
Income in 1999 at or above poverty level: |
31,870 |
|
Under 5 years |
1,928 |
|
5 years |
422 |
|
6 to 11 years |
2,828 |
|
12 to 17 years |
3,194 |
|
18 to 64 years |
19,793 |
|
65 to 74 years |
2,087 |
|
75 years and over |
1,618 |
U.S. Census Bureau: Census 2000.
Other Census data revealed that our town of 33K has just 285 households below the poverty line, out of 12,000. That makes closing the digital divide sound almost possible… at least the income-based portion of the divide.
I’m slowly hatching a plot that might work. And once again, I need your insight.
My Big Idea:
- Work with local groups, like the Chamber of Commerce, Rotary, churches, synagogues, mosques, etc, to get govt and biz to donate decommissioned PCs to our local non-profit computer group (QCS);
- Talk QCS (or similar) into creating a Special Interest Group (ReSIG) that recycles the PCs;
- Have ReSIG load an image of desktop Linux with OpenOffice, Firefox web browser and Thunderbird email client (or similar) on each;
- Encourage ReSIGgers (or others, like Boy Scouts or DeMolay) to deliver pcs and train the beneficiaries;
- Convince a local provider to offer free or low cost service;
- Beg local NGOs to help subsidize what’s left.
It seems to me that everybody wins. Local donaters and NGOs get free publicity for supporting a good, focused cause, and donatees get Internet access with zero government cost. The program’s even environmentally friendly, as throwaways are re-used locally, saving freight and gas. My kind of city program.
Could it work? Any ideas on how to help it go with minimal effort? Have a snappy name? What works in your town?
Oh. And if you’re thinking about stealing my Big Idea… feel free. Let the rest of us know how your project worked out.

8 comments
Comments feed for this article
July 30th, 2006 at 11:13 am
Allen Kiddoo
Been there done that.
pccgs.org in Muscatine just down ribber has been organized for over a year now.
We have rebuilt an donated over 50 computers to needy and other NPOs.
July 31st, 2006 at 8:26 am
BJ Gillette
Hi Allen.
RE: Just down the ribber…
(For you outworlders, Muscatine, IA is just 26 miles south of the Quad Cities, on the Mississippi River, on a beautiful lightly trafficked 4 lane. It is the hometown of Bandag, Hon Industries and Stanley Consultants.)
I was hoping somebody would come up with an already working model. Can you point us all to your roadmap?
Do you have a Linux image file you\’d be willing to share?
How does your recycle stream work?
Example:
Hon/Bandag old pcs -> PCGS -> Trainers (like Scouts) -> Free or Discounted Internet (City of Musc).
August 1st, 2006 at 8:31 am
CThomas
Don’t know about social progs. Census B page has data, still too many confusing dropdowns.
August 1st, 2006 at 9:38 am
BJ Gillette
Hi CThomas.
RE: Census B page has data, still too many confusing dropdowns.
Agreed. The site has several input screens (including the first) that are close to inscrutable. Really sad.
But if you can figure out input, you can get to a lot of useful information.
August 2nd, 2006 at 7:04 am
Robert Pogson
This idea has been used around the world, particularly in schools where a computer budget is often an after-thought or less essential. Modern curriculums emphasize using computers in schools, so necessity has become the mother of invention.
Schools have access to older computers from storage areas, donations from homes and businesses and even organizations like Computers for Schools (in Canada). These old machines need a 100 mbits/s ethernet NIC, a netowrk switch, and one newer machine on the network with some resources like RAM/storage/newer CPU and preferably a gigabit/s ethernet NIC to connect to a gigabit port on the switch. Gigabit is optional. It just permits the newer machine to act as terminal server to more clients. Even an off-the-shelf PC with 512 MB or more can make a good server for 10 or more thin clients. Each thin client needs 50 MB RAM over what is needed to run the system. On the newer machine install K12LTSP, EdUbuntu, or any GNU/Linux distro with the LTSP packages. This permits machines that can PXE boot to boot from the server without needing modification except BIOS setting. No hard drive needed. Machines that cannot boot PXE can use a boot loader on floppy or CD from Rom-o-matic.
I have been using whatever machines I can get my hands on in schools for seven years now. Last year, a newer machine failed and I was able to install a minimal system on a Pentium I, add a 100 mbits/s NIC and the ten year old PC looked like stuff was running on an AMD64 3000, which it was…
This approach can be used in homes with multiple PCs, community clubs, schools, libraries and business offices. It is a great way to extend the life of equipment and to get the maximum value from expenditures on computer hardware.
Robert Pogson
August 2nd, 2006 at 9:27 am
BJ Gillette
Hi Robert.
Good to hear some details from an old pro. As I understand it, our local schools are pretty much 100% state of the art.
Personally, I’m intrigued by the idea of focusing an effort on getting working eqpt and service to that percentage of those 285 households below the poverty line who would actually make productive use of them.
And there lies another challenge…
August 2nd, 2006 at 12:21 pm
J Butts
Mr. Gillette,
Here is an organization in the San Francisco Bay Area that does the same thing you are investigating:
http://www.accrc.org/
I’m sure you if contact someone at the organization they would be happy to assist you.
I donated a couple of computers there recently. They make you pay to dontate to cover their expenses but I’m sure you will be able to come up with a plan that works for your area.
August 2nd, 2006 at 4:36 pm
BJ Gillette
Hi J.
Wow. Looks like a great outfit. Thanks for the tip.