{"id":14227,"date":"2022-07-25T10:10:22","date_gmt":"2022-07-25T15:10:22","guid":{"rendered":"https:\/\/iowahighwayends.net\/blog\/?p=14227"},"modified":"2022-07-28T00:20:20","modified_gmt":"2022-07-28T05:20:20","slug":"a-ragbrai-database-with-some-assistance","status":"publish","type":"post","link":"https:\/\/iowahighwayends.net\/blog\/2022\/07\/a-ragbrai-database-with-some-assistance\/","title":{"rendered":"A RAGBRAI database, with some assistance"},"content":{"rendered":"

\"\"
\nJune 19, 1977\/October 3, 2010:<\/strong> A daily map for RAGBRAI V, photographed from microfilm. The 1977 and 2022 routes share some similarities, including an overnight stop in Ida Grove, a route south of US 18 from Whittemore to New Hampton, and an end in Lansing.<\/em><\/p>\n

Back when I was working at the Des Moines Register<\/em>, I wondered if there was a compilation of all the RAGBRAI towns<\/a>, or even all the routes. The answer appeared to be no, so I did what I do best and started digging through archives. I knew\/found out when town maps were published (June in early years, or each day during the ride, eventually moving to a full map on the third Sunday in March). I created an internal database and then a simple list of towns for each year, as shown in the Register’s<\/em> maps. I uploaded the compilation of the latter\u00a010 years ago Saturday<\/a>\u00a0and have updated it ever year since.<\/p>\n

Well, it appears this work has not gone unnoticed.<\/a> Needless to say, the Register’s<\/em> database is fancier. I’d like to think my list’s presentation has its own strengths, though. I suppose this counts under “turnabout is fair play” \u2014 after all, the lists were compiled from the newspaper in the first place. There is a credit, which I appreciate greatly.<\/p>\n

\n

Back in the halcyon days of blogging, there was a code, exemplified in this book from 2008<\/a>: “the true coin of the realm in the blogosphere is links. … As a general rule, the more bloggers who link to your blog or to your individual posts, the more influential you are as a blogger.” (The book was rendered obsolete almost immediately, as Facebook ate nearly the entire blogosphere during Obama’s first term and Google strangled RSS in 2013<\/a>. Now Safari doesn’t even have built-in RSS.)<\/p>\n

I’m glad my information is being found useful, but an e-mail and a link about it would be appreciated along with a credit.<\/p>\n

UPDATE 7\/28\/22: A couple locations I wrote in a specific style are replicated that way in the database. Hmmm<\/em>.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

June 19, 1977\/October 3, 2010: A daily map for RAGBRAI V, photographed from microfilm. The 1977 and 2022 routes share some similarities, including an overnight stop in Ida Grove, a route south of US 18 from Whittemore to New Hampton, … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[18,6],"tags":[],"class_list":["post-14227","post","type-post","status-publish","format-standard","hentry","category-iowa-miscellaneous","category-maps"],"_links":{"self":[{"href":"https:\/\/iowahighwayends.net\/blog\/wp-json\/wp\/v2\/posts\/14227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iowahighwayends.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iowahighwayends.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iowahighwayends.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/iowahighwayends.net\/blog\/wp-json\/wp\/v2\/comments?post=14227"}],"version-history":[{"count":5,"href":"https:\/\/iowahighwayends.net\/blog\/wp-json\/wp\/v2\/posts\/14227\/revisions"}],"predecessor-version":[{"id":14235,"href":"https:\/\/iowahighwayends.net\/blog\/wp-json\/wp\/v2\/posts\/14227\/revisions\/14235"}],"wp:attachment":[{"href":"https:\/\/iowahighwayends.net\/blog\/wp-json\/wp\/v2\/media?parent=14227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iowahighwayends.net\/blog\/wp-json\/wp\/v2\/categories?post=14227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iowahighwayends.net\/blog\/wp-json\/wp\/v2\/tags?post=14227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}