It's officially September. And you know what that means: it's once again time for further validation that no one around here can drive worth a lick.
Washington-Area Drivers, Already Terrible, Are Getting Worse
Hey Pal, Did You Get A Load Of The Nerd?
Washington is wonky. But according to recent data complied by the National Science Foundation, we're merely the seventh-most geeky place in the country.
D.C. Does Have A 311 Request Tracking Map, After All
In yesterday's Go Home Already, I bemoaned the fact that D.C. was lacking an equivalent to this awesome map of New York City's 311 service requests. As it turns out, I just needed to do a little more digging around the Office of the Chief Technology Officer's data website.
D.C. Tops In Households Earning More Than $200,000 Per Year
According to data published by the Census Bureau, D.C. is the national leader in the percentage of households that earn over $200,000 a year. The rest of the metropolitan area is not doing too shabby either: Maryland and Virginia place fourth and seventh, respectively.
Data Nerds: Wave Goodbye To Your Productivity Today
If you're anything like me and enjoy looking at colorful maps which show large amounts of data in an easily digestible format, you'll probably want to spend a fair amount of time parsing through the information provided in the New York Times' "Every City, Every Block" feature. The interactive maps utilize five-year results from the U.S. Census Bureau's American Community Survey, which was released yesterday.
WMATA Opens Up Bus Data For Public Use
Calling all developers: Metro has now given you the chance to play around with its bus data.
Today's Shiny New Metro Tool
With a tip of the cap to Greater Greater Washington, we thought you might enjoy this useful web application, which shows where Metrorail trains are in real time.
D.C. Circulator Performance: Now Incredibly Simple To Track
Have you ever wondered how many people ride the Circulator, how often it shows up on time or even how much fare money the public-private venture brings in? Well, that basic data is now just one click away -- the District Department of Transportation unveiled CirculatorDashboard today, a new website which will allow transit and data nerds like yours truly to easily keep an eye on the performance of D.C.'s shiny red buses.
WMATA Announces Plans To Make Data More Accessible
Good news for software geeks, transit nerds, and anybody who rides public transit and owns a computer: Metro is serious about opening its data.
Circulator Data Added to Google Transit
Bus trips on the DC Circulator can now be mapped within Google Transit, D.C. Mayor Adrian Fenty announced today. The move means that anyone attempting to get directions from Google Maps within the city will now see Circulator routes when selecting "By public transit" as the sorting option.
WMATA Wants to Spend $500K to Be Told Its Data is Worthless
Greater Greater Washington's Michael Perkins has been doing great work chasing down why, exactly, WMATA and Google can't come to an agreement and get Metro data into Google Transit. This post gets into the details, but the short version is that WMATA isn't inclined to play nice with Google, apparently because the agency thinks its schedule data might be worth something. No, they're not sure if they can get any money for it, but they'd like to find out: Metro has been talking about bidding out a half million-dollar contract for a consultant who can tell them whether they might be able to monetize their schedule data.
Today Perkins saves them the trouble by reporting the likely answer: no. He's got Google on record saying that they don't pay New York for its transit data, despite a history of the MTA trying to extract money from those using its data. If the Big Apple can't shake down Google, what hope do our local transit bureaucrats have? It's looking an awful lot like WMATA is stonewalling developers, inconveniencing its riders and preparing to waste $500k for nothing. Maybe Metro should focus on moving people around the city and leave the dreams of internet mogul-dom to the Californians.
D.C. Sends Out High Schoolers Private Data By Mistake
The Post is reporting that the D.C. Office of the State Superintendent of Education accidentally emailed personal information belonging to roughly 2,400 D.C. high school students out to about 1,000 people last week. The mistake reportedly happened when an employee who works in the Higher Education Financial Services Program, which administers the District's Tuition Assistance Grant Program that helps eligible college-bound D.C. residents pay the difference between in-state and out-of-state tuition at state universities across the country, inadvertently attached a spreadsheet to an email she was sending out to applicants. What kind of information was in that spreadsheet? "Student names, e-mail and home addresses, phone and Social Security numbers and dates of birth." Major drag, and major mistake.
Metro Police Scrub Crime Narratives From Public Data
Earlier this month, Derek Willis twittered that the Metro Police Department had stripped crime incident narratives from its public data feed. Former District resident Ben Walsh noticed and decided to find out why. The reason? MPD manager of Internet communications Kaylin Castelli blames listserves.
A First Look at WMATA's New GTFS Data
There were long delays, petition drives, and some final technical hiccups, but WMATA has finally released its schedule data in the Google Transit Feed Specification format. What does that mean? Well, most obviously it means that Google Transit will soon be adding D.C. to its list of supported cities (UPDATE: or perhaps not — see below for a comment from Michael Perkins of GGW, who explains that there are lingering complications surrounding WMATA's legal relationship with Google). But far more exciting is the opportunity this dataset represents to third-party developers. You can bet that geeks across the region were feverishly importing schedule data into databases last night (I certainly was).
So what's in a GTFS file, anyway? You can read the full spec here if you'd like, but the short version is actually pretty simple: a bunch of text files are zipped up into a single archive, which can be downloaded from the transit agency's website — in WMATA's case, the file clocks in around 20 megabytes. These comma-separated text files have names like routes.txt, stops.txt and stop_times.txt, and they can be opened in a text editor or spreadsheet program. The setup is pretty simple to understand: for example, stops.txt contains a list of bus and rail stops, complete with information like name, latitude and longitude, and assigns each one an ID. stop_times.txt, on the other hand, has a bunch of entries that assign arrival and departure times to individual routes, linking back to the stop information via each stop's ID.

