No cute graphics today. I awoke this morning somewhat unmotivated and did some content research for Belgium over a couple of hours. Then I fixed a couple of minor issues in the Change Report/What’s New code.
I’ve now returned to the map subsystem localization issue and am making good progress. I’ll continue this, this evening.
A number of changes to the database, including the addition of previously unknown locomotives occurred today. As always, the daily change report is available below:
This morning as I began to look at the “localization” problem that affected our ability to present a nice “mapping” experience, I was confronted with 2750 locomotives with faulty localization data, 1720 where localization had failed and another 1030 where localization had never been attempted.
The utility that performs the localization task was rewritten. And now we are down to 296 locomotives with faulty localization data, and we have a good idea why, for each one. So yes. Happy. I am happy. Pikachu is happy. Progress is being made.
(I put Pikachu over there for my granddaughter, just so you know.)
Next task is to provide Editors with a tool to fix failed localization issues.
The method most commonly used to create a map to a locomotive’s location is called “geocoding”. In brief, we supply you with a map of the general area, you find the locomotive, drop a marker on it and we’re in business.
The problem with this idea, of course, is that we have to have the geographic coordinates (latitude and longitude) of a point somewhere vaguely in the neighborhood of our target locomotive. Usually this point is the “average center” of a geographic object, like a city. With 21,516 locomotives in our database, I can pretty well assure you that no one went through that list, found the middle of each city containing a locomotive, and then entered that into the locomotive’s record as its “localization coordinates”.
Rather a utility program was written to use the Google Maps Geocoding API to obtain these coordinates and enter them into the database. Now API is a term that is often bandied about, but seldom explained. It stands for Application Programming Interface. And what it means in the simplest possible terms is that a series of “functions” have been written to allow my computer to chat politely with your computer.
So when I returned to attack various issues with the website I became aware that there were 1720 locomotives (7.99%) in the database for which localization had failed and another 1030 (4.78%) for which localization had never been attempted. So naturally I brought out that little utility program I had written and used earlier and told it to go to work. And the thing failed on every single one of the 2750 locomotives it looked at. What?!? It used to work just fine. Why not now?
Several days of dread and avoidance ensued. I didn’t want to look at it, didn’t want to debug it. And finally I did. It took an hour to discover that Google had changed the API, so an additional parameter was required. And I fixed it, tested it and sat back grinning.
Today’s Programming Plans
I’m going to modify the localization utility so that when it encounters a location it cannot geocode it will log the location, the locomotive’s id and the failure code, so that I can investigate why this happened, and if necessary manually correct it.
I’m going to modify the admin routine that allows an editor to move a locomotive from one place to another, so that once the locomotive has been placed in its new location, localization is performed to make mapping possible.
Will also add a menu item that allows an editor to manually localize a locomotive.
With all that having been said, the daily change report is, of course, available at:
/What’s New? Which is connected to the silly oval button on the site’s front page, has changed rather dramatically. Try it. I think you might like it. Additionally, starting today we display the name of the editor who made the particular change so you know who to blame (or praise).
In other news, my next programming effort, beginning this evening will be considerable enhancements to the way maps are displayed and administered.
As always, today’s change report is available below:
Since I’ve been elbow deep in the part of the system that keeps records about what has happened to the content and information within the database that hold the locomotive records I have had occassion to visit the page behind the “What’s New” button on the home page, and I really don’t like that page. I don’t like the design, the layout, the way the information is presented or the assumptions it makes about what the user might want to know or not know about the contents of the database regarding “What’s New”.
So, I’m going to fix that over the next couple of days. Not going to patch up the existing page. I’m going to rewrite it from the ground up. I will make a demo version of it available as soon as I am far enough along to give all you nice site visitors something to criticize, ridicule or (unlikely) praise.
Over the past few days, I’ve been through all the operational locomotives in the United States, searching Youtube for clips we could use for each locomotive. We began with 890 video clips system wide, and today we ended up with 1193 clips, system wide a change of +303 videos. Was a lot of fun.
Now, onward and upward. Programming is in the offing for today. There are a few minor tweaks to the Change Reports module that I want to make. I want to add a Notes Added category, and I want to add Details Edited to the Change Log. Details Edited is currently only accounted for in the most recent change data and vanishes when it is superceded. And, as always, here’s a link to today’s Change Report:
When I first began posting these Website Updates it was my intention to provide a daily listing of the changes to the data in the website, photos, videos and maps added, locomotives whose information had been editted and so forth. This soon became an issue because my pencil and paper record keeping skills leave a lot to be desired, and my memory isn’t what it never was. So…a nefarious plot was hatched to use a computer (gasp!) to do my work for me.
Steamlocomotive.info collects two kinds of data in this regard. Each locomotive’s record contains information about the most recent change made to it. And a database table called WhatsNew tracks major changes. So using these two piles of information, I wrote a system I called Change Reports. There’s a button on the front page called, “Change Reports” cleverly enough which will let you explore this system. You can choose any date or any month back to the middle of 2016 and see what was done on that date or in that month. And now for the fun part: I’m going to publish a link to the day’s report in each of these updates, so you can see what I and the other editors have been up to. The remainder of the updates will deal with new features, new content, new interesting things, etc. So without further ado, here’s a link to today’s report. I hope you enjoy it:
I’ve been rather quiet the last couple of days as I am working on a new feature for the website that I hope you’ll enjoy when it is finished. I expect to release it this weekend.
So what does it do? It allows you to choose a date, or a month between June 6, 2016 and the present and see all the changes that were made to the locomotives in the database on that date or in that month. It is working pretty well now, but needs some cosmetic enhancements before I unleash it on our unsuspecting visitors.
I may make a preview version of it available later today depending upon how the work goes. I’ll announce that here, and provide some instructions on its use.
I must admit I’ve been rather lazy the last couple of days. I have updated technical details of a few locomotives, added maps for 31 locomotives and photos for another 11. But I didn’t keep a detailed list of what I was doing this time. I shall endeavour to do better in my next update.