View allAll Photos Tagged spreadsheets
I made my own 'Top Of The Pops' 1970's LP cover (as found at car boot sales now for 5p) to use for my music XLS spreadsheet I sell on CD. Yes, it's Kylie Minogue.
It lists all number one albums & singles, both Live Aid acts+tracks, Brit award winners, TV and radio programme music poll results, plus lists every track on every Now album.
DJ's love it as they can find that track on the 100+ Now albums quickly and find out what was number one on any day since 1950's incl sheet music number ones! I've sold 100's with many return customers (for updates) and word of mouth sales. I was the first to ever produce this and sell it in early 2004 (mainly on ebay) yet people have copied my idea and now also do it but mine is still the original, biggest and best. On the official NOW website I even got it/me mentioned (google .. bobasonic spreadsheet ). A bargain for £1 to £5 depending on it's contents (one list to all lists)! It's took me 100's of hours of work.
Detail of the body and controls of the Nikon D500.
Example Images from Nikon D500 Experience guide to the D500.
Setup your Menus and Custom Settings, for various shooting situations, with help from my Nikon D500 Setup Guide Spreadsheet:
blog.dojoklo.com/2016/05/24/nikon-d500-setup-guide-spread...
3 areas (each 4mx 4m) sown just for bee pictures - plants honey bees find attractive but which I have not already got any photos of bees on! Planning ahead for my spreadsheet project docs.google.com/spreadsheets/d/1-_uJANb_oKgIZLEvm0mFjYq3W...
Ages since I have updated that google docs spreadsheet - no excuse now that I am retired! On my to do list for this week!
the 3 areas are:
Crimson clover =Trifolium incarnatum
Lucerne/Alfalfa = Medicago sativa
White Mustard= Sinapis alba
The Jesus and Mary Chain - Sowing Seeds
Gear available for purchase is listed here: docs.google.com/spreadsheets/d/1zrBzcCe2moh0CvZkhUuWSKXi2...
As an ongoing fascination with making fake map-looking things in Excel via formatted pivot tables, here's one showing global earthquakes.
All about the process at: uxblog.idvsolutions.com
Taken at the very official business meeting at the end of Fantasy Faire 2026. So many spreadsheets and TPS reports.
Attention, downtown office workers: Pigeons don't care that your Excel spreadsheet isn't formatting right. This one made it to Explore.
spreadsheets.google.com/ccc?key=pabeKVWjuoTX0kiPI8ZoRag&a...
equipped with 2 bullpup anti-personnel auto pistols designed for "crowd control" at point blank range.
mechaton attachments:
- Armor Plating and bulky ( defense )
-backpack sensor pod ( targeting )
-auto pistols x2 ( Hand to hand x2 )
Detail of the body and controls of the Nikon D500.
Example Images from Nikon D500 Experience guide to the D500.
Setup your Menus and Custom Settings, for various shooting situations, with help from my Nikon D500 Setup Guide Spreadsheet:
blog.dojoklo.com/2016/05/24/nikon-d500-setup-guide-spread...
© 2021 George McVitie. All rights reserved.
A Photo from Day 9 of a 10 day 9 night "Railway Tour" of 13 Museums and Heritage Railway Locations. The Main Aim was to get as many Steam Train Journeys to add to my Steam Powered Journeys Spreadsheet which is my modern "Trainspotting" record.
Another Double Railway Day and I decided to go to the North Norfolk Railway (NNR) in the morning and I can move onto the Mid Norfolk Railway (MNR) in the afternoon. It is only about 50 minutes by car between the 2 railways.
When I arrived at Sheringham Station on the North Norfolk Railway (NNR), there were 2 Steam Trains operating along the line.
Here, after travelling along the line to Holt Station, this Photo is of Riddles designed and Swindon Works built 92203 - "Black Prince" - a BR Std. Class 9F - 2-10-0 just before the run round.
On 2021-11-11, this photo was added to 100 Views Unlimited www.flickr.com/groups/100viewsunlimited/ Group Pool.
On 2021-11-13, this photo was added to Favorites: <5 Group Pool www.flickr.com/groups/favs1/ with 4 Faves at the time.
On 2021-12-09, this photo was added to 200 Views Unlimited www.flickr.com/groups/200viewsunlimited_/ Group Pool.
On 2021-12-17, this photo was Promoted to Favorites: 5 Group Pool www.flickr.com/groups/favs5/
On 2022-01-19, this photo was added to 300 Views Unlimited www.flickr.com/groups/2389359@N21/ Group Pool.
On 2022-03-07, this photo was added to 400 Views
Unlimited www.flickr.com/groups/2341915@N25/ Group Pool.
On 2022-05-09, this photo was added to 500 Views Unlimited www.flickr.com/groups/500viewsunlimited_/ Group Pool.
On 2023-08-31, this photo was added to 750 Views Unlimited www.flickr.com/groups/750_views/ Group Pool.
© 2021 George McVitie. All rights reserved.
A Photo from Day 4 of a 10 day 9 night "Railway Tour" of 13 Museums and Heritage Railway Locations. The Main Aim was to get as many Steam Train Journeys to add to my Steam Powered Journeys Spreadsheet which is my modern "Trainspotting" record.
The West Somerset Railway runs trains from Bishops Lydeard station to Dunster with a bus transfer to Minehead at the moment due to a problem with a level crossing.
There is ample car parking at the Bishops Lydeard end of the line so I started there.
The day I went during the sort of main summer holidays, there were 3 steam excursion running hauled by Steam Locomotives.
Here, a Cab photo of 7822 "Foxcote Manor" which is about to power the Steam Excursion I have a ticket for.
7822 is a Collett designed GWR "Manor Class" 4-6-0 loco.
For More Info ...>>>
preservedbritishsteamlocomotives.com/7822-foxcote-manor/
On 2021-12-15, this photo was added to 200 Views Unlimited www.flickr.com/groups/200viewsunlimited_/ Group Pool.
On 2022-02-16, this photo was added to 300 Views Unlimited www.flickr.com/groups/2389359@N21/ Group Pool.
On 2022-05-15, this photo was added to 400 Views
Unlimited www.flickr.com/groups/2341915@N25/ Group Pool.
On 2022-08-28, this photo was added to 500 Views Unlimited www.flickr.com/groups/500viewsunlimited_/ Group Pool.
On 2023-01-04, this photo was Promoted to Favorites: 5 Group Pool www.flickr.com/groups/favs5/
On 2023-09-24, this photo was added to 750 Views Unlimited www.flickr.com/groups/750_views/ Group Pool.
Wood anemone (Anemone nemorosa) is a native flower - It looks great at this time of year in flower under the trees at Rowallane.
Popular with the bees collecting pollen. Cream coloured pollen load very clear in this picture.
A new one for my Honey bees on named flowers set set
And will also go on the botanically sorted spreadsheet at:
docs.google.com/spreadsheets/d/1-_uJANb_oKgIZLEvm0mFjYq3W...
Detail of the body and controls of the Nikon D500.
Example Images from Nikon D500 Experience guide to the D500.
Setup your Menus and Custom Settings, for various shooting situations, with help from my Nikon D500 Setup Guide Spreadsheet:
blog.dojoklo.com/2016/05/24/nikon-d500-setup-guide-spread...
Written by Anna
I'm going to make a zine about body image. It's called Tell me about your body in 10 words or less.
You can participate by filling in the Google Form here
Well, its not quite Miffy or Maisy mouse...but for a bbq for friends in our shareclub, a cake depicting a spreadsheet showing the share value for one year . Look how well we did - it is accurate and representational.
As I was cutting it up, Treasurer, Mark, requested the top right corner!!!
Christmas rose. - pure white flowers.
I have this in a pot on the patio. In full flower at present and great to see the bees on it.
For my Honey bees on named flowers set set
And will also go on the botanically sorted spreadsheet at:
docs.google.com/spreadsheets/d/1-_uJANb_oKgIZLEvm0mFjYq3W...
And some music, just if you like:
Velvet Underground -Run Run Run
© 2021 George McVitie. All rights reserved.
A Photo from Day 9 of a 10 day 9 night "Railway Tour" of 13 Museums and Heritage Railway Locations. The Main Aim was to get as many Steam Train Journeys to add to my Steam Powered Journeys Spreadsheet which is my modern "Trainspotting" record.
Another Double Railway Day and I decided to go to the North Norfolk Railway (NNR) in the morning and I can move onto the Mid Norfolk Railway (MNR) in the afternoon. It is only about 50 minutes by car between the 2 railways.
When I arrived at Sheringham Station on the North Norfolk Railway (NNR), there were 2 Steam Trains operating along the line.
Here, after travelling along the line from Weybourne to Holt and then along the whole line to Sheringham Station, this last Photo before moving onto the Mid Norfolk Railway (MNR) is of 90775 - recently named "The Royal Norfolk Regiment" which was built by North British of Glasgow as a WD/10 Class loco similar to a 9F - 2-10-0 just after arriving at Sheringham and moving to the Head Shunt as the first part of a run round.
On 2021-11-17, this photo was added to 100 Views Unlimited www.flickr.com/groups/100viewsunlimited/ Group Pool.
On 2021-11-20, this photo was added to 200 Views Unlimited www.flickr.com/groups/200viewsunlimited_/ Group Pool.
On 2021-12-13, this photo was added to 300 Views Unlimited www.flickr.com/groups/2389359@N21/ Group Pool.
On 2022-03-24, this photo was added to Favorites: <5 Group Pool www.flickr.com/groups/favs1/ with 2 Faves at the time.
On 2022-03-26, this photo was added to 400 Views
Unlimited www.flickr.com/groups/2341915@N25/ Group Pool.
On 2022-06-21, this photo was added to 500 Views Unlimited www.flickr.com/groups/500viewsunlimited_/ Group Pool.
On 2024-06-15, this photo was added to 750 Views Unlimited www.flickr.com/groups/750_views/ Group Pool.
Reto #39 de la Familia Fotera: Reto Lectura.
Aquí los enlaces a los participantes en el reto
www.facebook.com/groups/retosfamiliafotera/
docs.google.com/spreadsheet/ccc?key=0AuUb_ql9WMzHdDNoY2Nt...
Spreadsheet used to compile, sort and map keywords for page level search engine optimization of websites.
Find more keyword SEO tools and advice at TopRank's Online Marketing Blog.
© 2021 George McVitie. All rights reserved.
A Day Trip to the North Yorkshire Moors Railway for the first day of their Steam Gala,
As Usual, the Main Aim was to get as many Steam Train Journeys to add to my Steam Powered Journeys Spreadsheet which is my modern "Trainspotting" record.
Here, Just passing 80136 with a Teak set and approaching Goathland Station is 5428 "Eric Treacy", a Stanier "Black 5" built by Armstrong Whitworths of Newcastle for the LMS with a 4-6-0 wheel arrangement.
For more info about 5428 "Eric Treacy" ...
www.nymr.co.uk/lms-5mt-black-5-4-6-0-no-45428-eric-treacy
On 2022-02-05, this photo was added to Favorites: <5 Group Pool www.flickr.com/groups/favs1/ with 2 Faves at the time.
On 2022-02-06, this photo was added to 100 Views Unlimited www.flickr.com/groups/100viewsunlimited/ Group Pool.
On 2022-02-08, this photo was added to 200 Views Unlimited www.flickr.com/groups/200viewsunlimited_/ Group Pool.
On 2022-02-16, this photo was added to 300 Views Unlimited www.flickr.com/groups/2389359@N21/ Group Pool.
On 2022-03-14, this photo was added to 400 Views
Unlimited www.flickr.com/groups/2341915@N25/ Group Pool.
On 2022-05-09, this photo was added to 500 Views Unlimited www.flickr.com/groups/500viewsunlimited_/ Group Pool.
On 2024-02-06, this photo was added to 750 Views Unlimited www.flickr.com/groups/750_views/ Group Pool.
© 2021 George McVitie. All rights reserved.
A Photo from Day 6 of a 10 day 9 night "Railway Tour" of 13 Museums and Heritage Railway Locations. The Main Aim was to get as many Steam Train Journeys to add to my Steam Powered Journeys Spreadsheet which is my modern "Trainspotting" record but unfortunately I didn't get any journeys on this day.
The Severn Valley Railway (SVR) runs trains along a 16 mile Heritage line from Kidderminster station to Bridgenorth station .Highly is one of the stations along the line and there is The Engine House Museum there.
The day I went during the sort of main summer holidays, there were 4 steam Locomotive running on various Steam Excursions where due to Covid19, Compartments were being sold to families and there were some tables for groups of 2 or 4 people but nothing really suitable for the solo traveler.
Here, in The Engine House museum very near Highley Station I took this photo of 600 Gordon, a 2-10-0 locomotive built by North British Locomotive Company, Glasgow as Works Number 25437 for the Longmoor Military Railway (LMR).
Later 600 Gordon was renumbered WD 73651.
For More info about WD 600 - "Gordon" - see ...
preservedbritishsteamlocomotives.com/600-gordon-wd-73651/
On 2021-11-21, this photo was added to 200 Views Unlimited www.flickr.com/groups/200viewsunlimited_/ Group Pool.
On 2022-02-18, this photo was added to 300 Views Unlimited www.flickr.com/groups/2389359@N21/ Group Pool.
On 2022-05-28, this photo was added to 400 Views
Unlimited www.flickr.com/groups/2341915@N25/ Group Pool.
On 2022-11-03, this photo was added to 500 Views Unlimited www.flickr.com/groups/500viewsunlimited_/ Group Pool.
On 2022-11-25, this photo was added to 750 Views Unlimited www.flickr.com/groups/750_views/ Group Pool.
On 2022-12-19, this photo was added to 1,000 Views Unlimited Group Pool www.flickr.com/groups/1000viewsunlimited/
Over the past few years, we've been using the What To Withdraw Tool from ITHAKA to weed our print serials that are in the JSTOR archive. Not all of the volumes are already in the archive, and some titles we continue to receive in print for one reason or another (although we moved as many as we could to online-only). I maintain a spreadsheet that I use to track which volumes need to be withdrawn every year, and where we are in the process of having the whole run fall into the JSTOR archive coverage. I've spent most of today gathering data, adding 51 new titles to the list, creating reports for Stacks Maintenance and Serials staff, and updating holdings data in our OpenURL knowledgebase.
www.cjr.org/feature/a_see-through_society.php?page=all
Excerpt:
People are eager for access to information, and public officials who try to stand in the way will discover that the Internet responds to information suppression by routing around the problem. Consider the story of a site you’ve never seen, ChicagoWorksForYou.com. In June 2005, a team of Web developers working for the city of Chicago began developing a site that would take the fifty-five different kinds of service requests that flow into the city’s 311 database—items like pothole repairs, tree-trimming, garbage-can placement, building permits, and restaurant inspections—and enable users to search by address and “map what’s happening in your neighborhood.” The idea was to showcase city services at the local level.
ChicagoWorks was finished in January 2006, with the support of Mayor Richard Daley’s office. But it also needed to be reviewed by the city’s aldermen and, according to a source who worked on the project, “they were very impressed with its functionality, but they were shocked at the possibility that it would go public.” Elections were coming up, and even if the site showed 90 percent of potholes being filled within thirty days, the powers-that-be didn’t want the public to know about the last 10 percent. ChicagoWorksForYou.com was shelved.
But the idea of a site that brings together information about city services in Chicago is alive and kicking. If you go to EveryBlock.com, launched in January 2008, and click on the Chicago link, you can drill down to any ward, neighborhood, or block and discover everything from the latest restaurant-inspection reports and building permits to recent crime reports and street closures. It’s all on a Google Map, and if you want to subscribe to updates about a particular location and type of report, the site kicks out custom RSS feeds. Says Daniel O’Neil, one of EveryBlock’s data mavens, “Crime and restaurant inspections are our hottest topics: Will I be killed today and will I vomit today?”
EveryBlock exists thanks to a generous grant from the Knight News Challenge, but its work, which covers eleven cities, including New York, San Francisco, and Washington, D.C., offers a glimpse of the future of ubiquitous and hyperlocal information. EveryBlock’s team collects most of its data by scraping public sites and spreadsheets and turning it into understandable information that can be easily displayed and manipulated online.
It may not be long before residents of the cities covered by EveryBlock decide to contribute their own user-generated data to flesh out the picture that city officials might prefer to hide. EveryBlock founder Adrian Holovaty tells me that his team is figuring out ways for users to connect directly to each other through the site. Forums that allowed people to congregate online by neighborhood or interest would enable EveryBlock users to become their cities’ watchdogs. If city agencies still won’t say how many potholes are left unfilled after thirty days, people could share and track that information themselves.
COMPLETE TEXT
A See-Through Society
HOW THE WEB IS OPENING UP OUR DEMOCRACY
Publication: Columbia Journalism Review
Micah Sifry
January 15, 2009
It may be a while before the people who run the U.S. House of Representatives’ Web service forget the week of September 29, 2008. That’s when the enormous public interest in the financial bailout legislation, coupled with unprecedented numbers of e-mails to House members, effectively crashed www.house.gov. On Tuesday of that week, a day after the House voted down the first version of the bailout bill, House administrators had to limit the number of incoming e-mails processed by the site’s “Write Your Representative” function. Demand for the text of the legislation was so intense that third-party sites that track Congress were also swamped. GovTrack.us, a private site that produces a user-friendly guide to congressional legislation, had to shut down. Its owner, Josh Tauberer, posted a message reading, “So many people are searching for the economic relief bill that GovTrack can’t handle it. Take a break and come back later when the world cools off.”
Once people did get their eyes on the bill’s text, they tore into it with zeal. Nearly a thousand comments were posted between September 22 and October 5 on PublicMarkup.org, a site that enables the public to examine and debate the text of proposed legislation set up by the Sunlight Foundation, an advocacy group for government transparency (full disclosure: I am a senior technology adviser to Sunlight). Meanwhile, thousands of bloggers zeroed in on the many earmarks in the bill, such as the infamous reduction in taxes for wooden-arrow manufacturers. Others focused on members who voted for the bill, analyzing their campaign contributors and arguing that Wall Street donations influenced their vote.
The explosion of public engagement online around the bailout bill signals something profound: the beginning of a new age of political transparency. As more people go online to find, create, and share vital political information with one another; as the cost of creating, combining, storing, and sharing information drops toward zero; and as the tools for analyzing data and connecting people become more powerful and easier to use, politics and governance alike are inexorably becoming more open.
We are heading toward a world in which one-click universal disclosure, real-time reporting by both professionals and amateurs, dazzling data visualizations that tell compelling new stories, and the people’s ability to watch their government from below (what the French call sousveillance) are becoming commonplace. Despite the detour of the Bush years, citizens will have more opportunity at all levels of government to take an active part in understanding and participating in the democratic decisions that affect their lives.
Log On, Speak Out
The low-cost, high-speed, always-on Internet is changing the ecology of how people consume and create political information. The Pew Internet & American Life Project estimates that roughly 75 percent of all American adults, or about 168 million people, go online or use e-mail at least occasionally. A digital divide still haunts the United States, but among Americans aged eighteen to forty-nine, that online proportion is closer to 90 percent. Television remains by far the dominant political information source, but in October 2008, a third of Americans said their main provider of political information was the Internet—more than triple the number from four years earlier, according to another Pew study. Nearly half of eighteen-to-twenty-nine-year-olds said the Internet was their main source of political info.
Meanwhile, we’re poised for a revolution in participation, not just in consumption, thanks to the Web. People talk, share, and talk back online. According to yet another study by Pew, this one in December 2007, one in five U.S. adults who use the Internet reported sharing something online that they created themselves; one in three say they’ve posted a comment or rated something online.
People are eager for access to information, and public officials who try to stand in the way will discover that the Internet responds to information suppression by routing around the problem. Consider the story of a site you’ve never seen, ChicagoWorksForYou.com. In June 2005, a team of Web developers working for the city of Chicago began developing a site that would take the fifty-five different kinds of service requests that flow into the city’s 311 database—items like pothole repairs, tree-trimming, garbage-can placement, building permits, and restaurant inspections—and enable users to search by address and “map what’s happening in your neighborhood.” The idea was to showcase city services at the local level.
ChicagoWorks was finished in January 2006, with the support of Mayor Richard Daley’s office. But it also needed to be reviewed by the city’s aldermen and, according to a source who worked on the project, “they were very impressed with its functionality, but they were shocked at the possibility that it would go public.” Elections were coming up, and even if the site showed 90 percent of potholes being filled within thirty days, the powers-that-be didn’t want the public to know about the last 10 percent. ChicagoWorksForYou.com was shelved.
But the idea of a site that brings together information about city services in Chicago is alive and kicking. If you go to EveryBlock.com, launched in January 2008, and click on the Chicago link, you can drill down to any ward, neighborhood, or block and discover everything from the latest restaurant-inspection reports and building permits to recent crime reports and street closures. It’s all on a Google Map, and if you want to subscribe to updates about a particular location and type of report, the site kicks out custom RSS feeds. Says Daniel O’Neil, one of EveryBlock’s data mavens, “Crime and restaurant inspections are our hottest topics: Will I be killed today and will I vomit today?”
EveryBlock exists thanks to a generous grant from the Knight News Challenge, but its work, which covers eleven cities, including New York, San Francisco, and Washington, D.C., offers a glimpse of the future of ubiquitous and hyperlocal information. EveryBlock’s team collects most of its data by scraping public sites and spreadsheets and turning it into understandable information that can be easily displayed and manipulated online.
It may not be long before residents of the cities covered by EveryBlock decide to contribute their own user-generated data to flesh out the picture that city officials might prefer to hide. EveryBlock founder Adrian Holovaty tells me that his team is figuring out ways for users to connect directly to each other through the site. Forums that allowed people to congregate online by neighborhood or interest would enable EveryBlock users to become their cities’ watchdogs. If city agencies still won’t say how many potholes are left unfilled after thirty days, people could share and track that information themselves.
Such a joint effort is no stretch to young people who have grown up online. Consider just a couple of examples: since 1999, RateMyTeachers.com and RateMyProfessors.com have collected more than sixteen million user-generated ratings on more than two million teachers and professors. The two sites get anywhere from half a million to a million unique visitors a month. Yelp.com, a user-generated review service, says its members have written more than four million local reviews since its founding in 2004. As the younger generation settles down and starts raising families, there’s every reason to expect that its members will carry these habits of networking and sharing information into tracking more serious quality-of-life issues, as well as politics.
Cities Lead the Way
Recognizing this trend, some public officials are plunging in. In his “State of the City” speech in January 2008, New York Mayor Mike Bloomberg promised to “roll out the mother of all accountability tools.” It is called Citywide Performance Reporting, and Bloomberg promised it would put “a wealth of data at people’s fingertips—fire response times, noise complaints, trees planted by the Parks Department, you name it. More than five hundred different measurements from forty-five city agencies.” Bloomberg, whose wealth was built on the financial-information company he built, says he likes to think of the service as a “Bloomberg terminal for city government—except that it’s free.”
Bloomberg’s vision is only partly fulfilled so far. A visitor to the city’s site (nyc.gov) would have a hard time finding the “Bloomberg terminal for city government” because it’s tucked several layers down on the Mayor’s Office of Operations page, with no pointers from the home page.
Still, the amount of data it provides is impressive. You can learn that the number of families with children entering the city shelter system is up 31 percent over last year, and that the city considers this a sign of declining performance by the system. Or you can discover that the median time the city department of consumer affairs took to process a complaint was twenty-two business days, and that that is considered positive! Another related tool, called NYC*scout, allows anyone to see where recent service requests have been made, and with a little bit of effort you can make comparisons between different community districts. New York’s monitoring tools still leave much to be desired, however, because they withhold the raw data—specific addresses and dates-of-service requests—that are the bones of these reports. This means the city is still resisting fully sharing the public’s data with the public.
Compare that to the approach of the District of Columbia. Since 2006, all the raw data it has collected on government operations, education, health care, crime, and dozens of other topics has been available for free to the public via 260 live data feeds. The city’s CapStat online service also allows anyone to track the performance of individual agencies, monitor neighborhood services and quality-of-life issues, and make suggestions for improvement. Vivek Kundra, D.C.’s innovative chief technology officer, calls this “building the digital public square.” In mid-October, he announced an “Apps for Democracy” contest that offered $20,000 in cash prizes for outside developers and designers of Web sites and tools that made use of the city’s data catalog.
In just a few weeks, Kundra received nearly fifty finished Web applications. The winners included:
* iLive.at, a site that shows with one click all the local information around one address, including the closest places to go shopping, buy gas, or mail a letter; the locations of recently reported crimes; and the demographic makeup of the neighborhood;
* Where’s My Money, DC?—a tool that meshes with Facebook and enables users to look up and discuss all city expenditures above $2,500; and
* Stumble Safely, an online guide to the best bars and safe paths on which to stumble home after a night out.
The lesson of the “Apps for Democracy” contest is simple: a critical mass of citizens with the skills and the appetite to engage with public agencies stands ready to co-create a new kind of government transparency.
Under traditional government procurement practices, it would have taken Kundra months just to post a “request for proposals” and get responses. Finished sites would have taken months, even years, for big government contractors to complete. The cost for fifty working Web sites would have been in the millions. Not so when you give the public robust data resources and the freedom to innovate that is inherent to today’s Web.
The Whole Picture
So, how will the Web ultimately alter the nature of political transparency? Four major trends are developing.
First, the day is not far off when it will be possible to see, at a glance, the most significant ways an individual, lobbyist, corporation, or interest group is trying to influence the government. Here’s how Ellen Miller, executive director of the Sunlight Foundation and a longtime proponent of open government, sees the future of transparency online: “If I search for Exxon, I want one-click disclosure,” she says. “I want to see who its pac is giving money to, who its executives and employees are supporting, at the state and federal levels; who does its lobbying, whom they’re meeting with and what they’re lobbying on; whether it’s employing former government officials, or vice versa, if any of its ex-employees are in government; whether any of those people have flown on the company’s jets. And then I also want to know what contracts, grants, or earmarks the company has gotten and whether they were competitively bid.”
She continues: “If I look up a senator, I want an up-to-date list of his campaign contributors—not one that is months out of date because the Senate still files those reports on paper. I want to see his public calendar of meetings. I want to know what earmarks he’s sponsored and obtained. I want to know whether he is connected to a private charity that people might be funneling money to. I want to see an up-to-date list of his financial assets, along with all the more mundane things, like a list of bills he’s sponsored, votes he’s taken, and public statements he’s made. And I want it all reported and available online in a timely fashion.”
This vision isn’t all that far away. In the last three years, thanks in large measure to support from Sunlight, OMB Watch (a nonprofit advocacy organization that focuses on budget issues, regulatory policy, and access to government) created FedSpending.org, a searchable online database of all government contracts and spending. The Center for Responsive Politics (OpenSecrets.org), meanwhile, has developed searchable databases of current lobbying reports, personal financial disclosure statements of members of Congress, sponsored travel, and employment records of nearly ten thousand people who have moved through the revolving door between government and lobbying. Taxpayers for Common Sense (Taxpayer.net) is putting the finishing touches on a complete online database of 2008 earmarks.
The National Institute on Money in State Politics, headed by Ed Bender, is filling in the picture at the state level, aiming to give the public “as complete a picture as possible of its elected leaders and their actions, and offer information that helps the public understand those actions,” he says. “This would start with the candidates running for offices, their biographies and their donors, and would follow them into the statehouses to their committee assignments and relationships with lobbyists, and finally to the legislation that they sponsor and vote for, and who benefits from those actions.”
The incoming Obama administration, meanwhile, has expressed a commitment to expanding government transparency, promising as part of its “ethics agenda” platform (change.gov/agenda/ethics_agenda) to create a “centralized Internet database of lobbying reports, ethics records, and campaign-finance filings in a searchable, sortable, and downloadable format,” as well as a “ ‘contracts and influence’ database that will disclose how much federal contractors spend on lobbying, and what contracts they are getting and how well they complete them.”
To insure that all citizens can access such a database, we can hope that Obama pushes universal Internet access as part of his investment in infrastructure. As Andrew Rasiej and I argued in Politico in December, “Just as we recognized with the Universal Service Act in the 1930s that we had to take steps to ensure everyone access to the phone network, we need to do the same today with affordable access to high-speed Internet. Everything else flows from this. Otherwise, we risk leaving half our population behind and worsening inequality rather than reducing it.”
3-D Journalism
A second trend propelling us toward a greater degree of political transparency is data visualization. The tools for converting boring lists and lines of numbers into beautiful, compelling images get more powerful every day, enabling a new kind of 3-D journalism: dynamic and data-driven. And in many cases, news consumers can manipulate the resulting image or chart, drilling into its layers of information to follow their own interests. My favorite examples include:
* The Huffington Post’s Fundrace, which mapped campaign contributions to the 2008 presidential candidates by name and address, enabling anyone to see whom their neighbors might be giving to;
* The New York Times’s debate analyzer, which converted each candidate debate into an interactive chart showing word counts and speaking time, and enabled readers to search for key words or fast forward; and
* The Sunlight Foundation and Taxpayers for Common Sense’s Earmarks Watch Map (earmarkwatch.org/mapped),which layered the thousands of earmarks in the fiscal 2008 defense-appropriations bill over a map of the country allowing a viewer to zero in on specific sites and see how the Pentagon scatters money in practically every corner of the U.S.
The use of such tools is engendering a collective understanding of, as Paul Simon once sang, the way we look to us all. As news consumers grow used to seeing people like CNN’s John King use a highly interactive map of the United States to explain local voting returns, demand for these kinds of visualizations will only grow.
Little Brother Is Watching, Too
The third trend fueling the expansion of political transparency is sousveillance, or watching from below. It can be done by random people, armed with little more than a camera-equipped cell phone, who happen to be in the right place at the right time. Or it can be done by widely dispersed individuals acting in concert to ferret out a vital piece of information or trend, what has been called “distributed journalism.” In effect, Big Brother is being watched by millions of Little Brothers.
For example, back in August, San Francisco Mayor Gavin Newsom was having coffee at a Starbucks in Malibu when he was spotted by a blogger who took a couple of photos and posted them online. The blogger noted that Newsom was “talking campaign strategy” with someone, but didn’t know who. The pictures came to the attention of San Francisco Chronicle reporter Carla Marinucci, who identified that person as political consultant Garry South. Soon political bloggers were having a field day, pointing out that the liberal mayor was meeting with one of the more conservative Democratic consultants around. This is sousveillance at its simplest.
The citizen-journalism project “Off the Bus,” which ultimately attracted thousands of volunteer reporters who posted their work on The Huffington Post during the 2008 election, was sousveillance en masse. Much of their work was too opinionated or first-person oriented to really break news, but Mayhill Fowler’s reporting of Barack Obama’s offhand remarks at a San Francisco fundraiser about “bitter” blue-collar workers at least briefly changed the course of the campaign. And there are numerous examples of bloggers and their readers acting in concert to expose some hidden fact. The coalition of bloggers known as the “Porkbusters” were at the center of an effort to expose which senator had put a secret hold on a bill creating a federal database of government spending, co-sponsored by none other than Barack Obama and Tom Coburn. Porkbusters asked their readers to call their senators, and by this reporting process, discovered that Senator Ted Stevens of Alaska was the culprit. Soon thereafter, he released his hold. Likewise, Josh Marshall has frequently asked readers of Talking Points Memo to help him spot local stories that might be part of a larger pattern. It was this technique that helped him piece together the story of the firings of U.S. Attorneys around the country, for which he won the Polk Award.
The World’s A-Twitter
The final trend that is changing the nature of transparency is the rise of what some call the World Live Web. Using everything from mobile phones that can stream video live online to simple text message postings to the micro-blogging service Twitter, people are contributing to a real-time patter of information about what is going on around them. Much of what results is little more than noise, but increasingly sophisticated and simple-to-use filtering tools can turn some of it into information of value.
For example, in just a matter of weeks before the November election in the U.S., a group of volunteer bloggers and Web developers loosely affiliated with the blog I edit, techPresident.com, built a monitoring project called Twitter Vote Report. Voters were encouraged to use Twitter, as well as other tools like iPhones, to post reports on the quality of their voting experience. Nearly twelve thousand reports flowed in, and the result was a real-time picture of election-day complications and wait times that a number of journalistic organizations, including NPR, PBS, and several newspapers, relied on for their reporting.
Nothing to Hide
The question for our leaders, as we head into a world where bottom-up, user-generated transparency is becoming more of a reality, is whether they will embrace this change and show that they have nothing to hide. Will they actively share all that is relevant to their government service with the people who, after all, pay their salaries? Will they trust the public to understand the complexities of that information, instead of treating them like children who can’t handle the truth?
The question for citizens, meanwhile, is, Will we use this new access to information to create a more open and deliberative democracy? Or will citizens just use the Web to play “gotcha” games with politicians, damaging the discourse instead of uplifting it?
“People tend not to trust what is hidden,” write the authors of the November 2008 report by a collection of openness advocates entitled “Moving Toward a 21st Century Right-to-Know Agenda.” “Transparency is a powerful tool to demonstrate to the public that the government is spending our money wisely, that politicians are not in the pocket of lobbyists and special-interest groups, that government is operating in an accountable manner, and that decisions are made to ensure the safety and protection of all Americans.” In the end, transparency breeds trust. Or rather, transparency enables leaders to earn our trust. In the near future, they may have to, because more and more of us are watching.
Since 1957, when the USSR launched Sputnik 1 into orbit, thousands of satellites have been launched into space. Whilst some of them are operational, many have failed over time remaining in orbit as floating junk... and potentially devastating debris. European Infrastructure news online consider the implications that such space junk could have on today's society.
Be sure to check out our infographics resource because it contains all our twitter profile names and RSS feeds so you can get them first.
© 2021 George McVitie. All rights reserved.
A Photo from Day 6 of a 10 day 9 night "Railway Tour" of 13 Museums and Heritage Railway Locations. The Main Aim was to get as many Steam Train Journeys to add to my Steam Powered Journeys Spreadsheet which is my modern "Trainspotting" record but unfortunately I don't get any journeys on this day.
The Severn Valley Railway (SVR) runs trains along a 16 mile Heritage line from Kidderminster station to Bridgenorth station .Highly is one of the stations along the line and there is The Engine House Museum there.
The day I went during the sort of main summer holidays, there were 4 steam Locomotive running on various Steam Excursions where due to Covid19, Compartments were being sold to families and there were some tables for groups of 2 or 4 people but nothing really suitable for the solo traveler.
Here, from Highley Station, I managed to get a photo of 43106.
43106 an Ivatt designed LMS "Class 4" 4MT 2-6-0 loco which was buit at LNER's Darlington Works.
On 2021-11-16, this photo was added to 200 views Unlimited www.flickr.com/groups/200viewsunlimited_/ Group Pool.
On 2021-12-06, this photo was added to Favorites: <5 Group Pool www.flickr.com/groups/favs1/ with 3 Faves at the time.
On 2022-01-03, this photo was added to 300 Views Unlimited www.flickr.com/groups/2389359@N21/ Group Pool.
On 2022-03-09, this photo was added to 400 Views
Unlimited www.flickr.com/groups/2341915@N25/ Group Pool.
On 2022-05-19, this photo was added to 500 Views Unlimited www.flickr.com/groups/500viewsunlimited_/ Group Pool.
On 2024-07-01, this photo was added to 750 Views Unlimited www.flickr.com/groups/750_views/ Group Pool.
I should really put together a spreadsheet and graph to determine if the chips per dollar takes a spike upwards at any point.
© 2021 George McVitie. All rights reserved.
A Photo from Day 6 of a 10 day 9 night "Railway Tour" of 13 Museums and Heritage Railway Locations. The Main Aim was to get as many Steam Train Journeys to add to my Steam Powered Journeys Spreadsheet which is my modern "Trainspotting" record but unfortunately I didn't get any journeys on this day.
The Severn Valley Railway (SVR) runs trains along a 16 mile Heritage line from Kidderminster station to Bridgenorth station .Highly is one of the stations along the line and there is The Engine House Museum there.
The day I went during the sort of main summer holidays, there were 4 steam Locomotive running on various Steam Excursions where due to Covid19, Compartments were being sold to families and there were some tables for groups of 2 or 4 people but nothing really suitable for the solo traveler.
Here, in The Engine House museum very near Highley Station I took this photo of 4566, a Churchward designed and Swindon Works built for the GWR 2-6-2T loco.
On 2021-12-25, this photo was added to 300 Views Unlimited www.flickr.com/groups/2389359@N21/ Group Pool.
On 2022-01-08, this photo was added to Favorites: <5 Group Pool www.flickr.com/groups/favs1/ with 3 Faves at the time.
On 2022-02-16, this photo was added to 400 Views
Unlimited www.flickr.com/groups/2341915@N25/ Group Pool.
On 2022-05-18, this photo was added to 500 Views Unlimited www.flickr.com/groups/500viewsunlimited_/ Group Pool.
On 2024-02-18, this photo was added to 750 Views Unlimited www.flickr.com/groups/750_views/ Group Pool.
© 2021 George McVitie. All rights reserved.
A Photo from Day 8 of a 10 day 9 night "Railway Tour" of 13 Museums and Heritage Railway Locations. The Main Aim was to get as many Steam Train Journeys to add to my Steam Powered Journeys Spreadsheet which is my modern "Trainspotting" record.
When planning this "Rail Tour" I had hoped to go the Great Central Railway (GCR) at Loughborough but a lack of Timetables on their web site and a shortage of anything i viewed as attractive in terms numbers of Steam Locomotives in service on this day (Saturday) prompted a change of plan.
I decided to go to the Embsay and Bolton Abbey Railway (EBA) in the morning and I can move onto the Keighley and Worth Valley Railway (KWVR) in the afternoon. It is only about 30 minutes by car between the 2 railways.
I joined at Embsay and was given a whole compartment to travel in to keep me away from other passengers. I think the railway must have been wanting to be careful and not take any risks of possibly allowing Covid to spread on their Railway.
Here, after travelling along the line to Bolton Abbey Station, No. 7 "Beatrice" was using the head shunt before running round the carriages to get ready for the return journey.
"Beatrice" No. 7 is a Hunslet Works No. 2705 0-6-0ST loco.
On 2021-11-03, this photo was added to 100 Views Unlimited www.flickr.com/groups/100viewsunlimited/ Group Pool.
On 2021-11-11, this photo was added to 200 Views Unlimited www.flickr.com/groups/200viewsunlimited_/ Group Pool.
On 2021-12-15, this photo was added to Favorites: <5 Group Pool www.flickr.com/groups/favs1/ with 3 Faves at the time.
On 2021-12-18, this photo was added to 300 Views Unlimited www.flickr.com/groups/2389359@N21/ Group Pool.
On 2022-03-23, this photo was added to 400 Views
Unlimited www.flickr.com/groups/2341915@N25/ Group Pool.
On 2022-08-05, this photo was added to 500 Views Unlimited www.flickr.com/groups/500viewsunlimited_/ Group Pool.
On 2024-08-12, this photo was added to 750 Views Unlimited www.flickr.com/groups/750_views/ Group Pool.
© 2021 George McVitie. All rights reserved.
A Photo from Day 9 of a 10 day 9 night "Railway Tour" of 13 Museums and Heritage Railway Locations. The Main Aim was to get as many Steam Train Journeys to add to my Steam Powered Journeys Spreadsheet which is my modern "Trainspotting" record.
Another Double Railway Day and I decided to go to the North Norfolk Railway (NNR) in the morning and I can move onto the Mid Norfolk Railway (MNR) in the afternoon. It is only about 50 minutes by car between the 2 railways.
When I arrived at Sheringham Station on the North Norfolk Railway (NNR), there were 2 Steam Trains operating along the line.
Here, after travelling along the line from Weybourne to Holt and then along the whole line to Sheringham Station, this Photo is of 90775 - recently named "The Royal Norfolk Regiment" which was built by North British of Glasgow as a WD/10 Class loco similar to a 9F - 2-10-0 just after arriving at Sheringham.
On 2021-11-17, this photo was added to 100 Views Unlimited www.flickr.com/groups/100viewsunlimited/ Group Pool.
On 2021-11-24, this photo was added to 200 Views Unlimited www.flickr.com/groups/200viewsunlimited_/ Group Pool.
On 2022-01-12, this photo was added to Favorites: <5 Group Pool www.flickr.com/groups/favs1/ with 3 Faves at the time.
On 2022-01-16, this photo was added to 300 Views Unlimited www.flickr.com/groups/2389359@N21/ Group Pool.
On 2022-04-06, this photo was added to 400 Views
Unlimited www.flickr.com/groups/2341915@N25/ Group Pool.
On 2022-08-05, this photo was added to 500 Views Unlimited www.flickr.com/groups/500viewsunlimited_/ Group Pool.
Nikon D500 - Simulated view of the D500 Viewfinder, showing selectable AF Points limited to 15.
Example Images from Nikon D500 Experience guide to the D500.
Setup your Menus and Custom Settings, for various shooting situations, with help from my Nikon D500 Setup Guide Spreadsheet:
blog.dojoklo.com/2016/05/24/nikon-d500-setup-guide-spread...
A typical Roman cut-and-thrust sword of the 3rd-4th cents AD from Gheyta in Egypt. In The Manchester Museum, University of Manchester, UK. Background removed with Slazzer.
* The length is given here as 26.5 cm, presumably an error for 26.5 inches: docs.google.com/spreadsheets/d/1uLf_h8NFma7jEUpc7dmVbX67C... (no. 224).
Nikon D500 - an informal ISO Test, both JPEG and NEF (RAW).
JPEG images make use of Auto 1 White Balance, High ISO NR-Normal and Long Exposure NR-On.
Example Images from Nikon D500 Experience.
Setup your Menus and Custom Settings, for various shooting situations, with help from my Nikon D500 Setup Guide Spreadsheet:
blog.dojoklo.com/2016/05/24/nikon-d500-setup-guide-spread...
Drawings in the Detail Section of the MWS&DB
Had a long phone chat with Phil Halcrow 24-11-24 about the old days and 60 years of life since we last saw each other. I introduced him to caving and SUSS and share a few trips. He went onto many years of mapping, surveying and early IT in drilling and NSW Water Management....
Some sheets were plotted in pencil from Surveyor Field books @ 1:9600, and took a week or two. using 80ch scales, if I remember correctly, still have them with the Darmstadt Slide rules and 7 figure log tables, see below..
other dwgs were inked in from other workers plots, with careful STAEDTLER® lettering guides for street names and title blocks, and hand lettering elsewhere..
Not as great a collection as the ..
But seems a lot, and needs sorting and indexing, that is why I'm putting it on Flickr..
© 2021 George McVitie. All rights reserved.
A Photo from Day 9 of a 10 day 9 night "Railway Tour" of 13 Museums and Heritage Railway Locations. The Main Aim was to get as many Steam Train Journeys to add to my Steam Powered Journeys Spreadsheet which is my modern "Trainspotting" record.
Another Double Railway Day and I decided to go to the North Norfolk Railway (NNR) in the morning and I can move onto the Mid Norfolk Railway (MNR) in the afternoon. It is only about 50 minutes by car between the 2 railways.
When I arrived at Sheringham Station on the North Norfolk Railway (NNR), there were 2 Steam Trains operating along the line.
Here, after travelling along the line from Weybourne to Holt Station, this Photo is of 90775 - recently named "The Royal Norfolk Regiment" which was built by North British of Glasgow as a WD/10 Class loco similar to a 9F - 2-10-0 just after the run round at Holt.
On 2021-11-14, this photo was added to 100 Views Unlimited www.flickr.com/groups/100viewsunlimited/ Group Pool.
On 2021-11-25, this photo was added to 200 Views Unlimited www.flickr.com/groups/200viewsunlimited_/ Group Pool.
On 2022-02-21, this photo was added to 300 Views Unlimited www.flickr.com/groups/2389359@N21/ Group Pool.
On 2022-06-27, this photo was added to 400 Views
Unlimited www.flickr.com/groups/2341915@N25/ Group Pool.
On 2023-03-05, this photo was added to Favorites: <5 Group Pool www.flickr.com/groups/favs1/ with 3 Faves at the time.
On 2023-03-05, this photo was added to 500 Views Unlimited www.flickr.com/groups/500viewsunlimited_/ Group Pool.
© 2021 George McVitie. All rights reserved.
A Day Trip to the North Yorkshire Moors Railway for the first day of their Steam Gala,
As Usual, the Main Aim was to get as many Steam Train Journeys to add to my Steam Powered Journeys Spreadsheet which is my modern "Trainspotting" record.
Here, Just passing 80136 with a Teak set and arriving at Goathland Station is 5428 "Eric Treacy", a Stanier "Black 5" built by Armstrong Whitworths of Newcastle for the LMS with a 4-6-0 wheel arrangement.
For more info about 5428 "Eric Treacy" ...
www.nymr.co.uk/lms-5mt-black-5-4-6-0-no-45428-eric-treacy
On 2022-02-07, this photo was added to Favorites: <5 Group Pool www.flickr.com/groups/favs1/ with 3 Faves at the time.
On 2022-02-09, this photo was added to 100 Views Unlimited www.flickr.com/groups/100viewsunlimited/ Group Pool.
On 2022-02-16, this photo was added to 200 Views Unlimited www.flickr.com/groups/200viewsunlimited_/ Group Pool.
On 2022-03-21, this photo was added to 300 Views Unlimited www.flickr.com/groups/2389359@N21/ Group Pool.
On 2022-04-21, this photo was added to 400 Views
Unlimited www.flickr.com/groups/2341915@N25/ Group Pool.
On 2022-07-20, this photo was added to 500 Views Unlimited www.flickr.com/groups/500viewsunlimited_/ Group Pool.
On 2024-08-11, this photo was added to 750 Views Unlimited www.flickr.com/groups/750_views/ Group Pool.