One problem solved

I scrolled through the votes by polling place for the problematic second election of 1924. I found that when I ordered rows by polling place numbers and look at the handful of major cities, all of their votes were recorded on a row lower than they should have been. The errant entry was the village of Blandorf, quite high on the list. When I adjusted the row one up, all of the cities lined up. Searching towards the bottom of the data base, I found an entry for Blandorf with all of the correct voting information but somehow given an Oldenburg polling place number. Problem identified and solved.

While I had the early archived list of votes results, I took the opportunity to correct another shortcoming to my Project_Master. When I created the version that I am now using, I did not include the Reichstag elections for 1898 and 1907. Those votes have now been entered and my next step will be to calculate the percentage of votes cast in each place for the competing parties. Once that is finished, I will include the several special elections held in the Imperial period (when a deputy either died or resigned). I had not added the later in earlier version as they seemed to tax the permissible columns in xls. As I have added material lately, this does not seem to be a problem. I wonder what is different? If space is available, it might be interesting to find and add results for the presidential election of 1925 or the various plebiscites that were held during the Weimar era.

OOPS

At the new year, I thought that I had resuscitated my GIS. Not so. The shapefile still needed work around the edges. As in any project, its those outstanding edges that were the most difficult.

When that task was finally complete and I tried to populate it with my data file, I noticed that many polling places were showing no results. This could not be the case, as I had notes on the handful of polling places for which I did not have data. A meticulous review of my Project_Master file indicated that perhaps 1/8 of my data was missing. How? Why? Did I lose data in the conversion for xls to cvs (required by QGIS?

Fortunately, after much searching, I was able to find an uncorrupted backup file. I made a spreadsheet of the missing polling place data and am presently integrating the "lost" data into my Project_Master file. Doing so, I uncovered another problem. The results for the second national election in 1924 were jumbled. I will have to diagnose that problem before I continue.

The creation of the original GIS map took +3000 hours; creating the data file (not counting the time collecting data) took a further +2000. I am comforted that all of this work was not lost!

Happy New Year!

This evening, I finished restoring my GIS of constituencies (Wahlorten). What a hectic two weeks. It would never have been possible if my daughter and son-in-law had time off from work and were able to watch our granddaughter.

I used a combination of Flur and Gemärkung boundaries available for download from the Lower Saxony Geodata Office. These took a little adjusting and I had to be careful when combining two Gemärkungen into one Wahlort.

My next task will be to check for any input mistakes on my part and to verify that all of the constituencies are represented. Then I need to clean up the banks of the Elbe, Weser and Ems, along with the North Sea coast. Time permitting, I will try to recreate the water details that I drew in my original GIS.

Lastly, I need to make sure that all of the polling place cites and town are present, as well as census places in each constituency where voters fond multiple towns vote in one location. This is all a huge relief, preparatory to returning to my spatial analysis of votes cast for the German Democratic Party 1919-1933 as part of my current Theodor Tantzen essay.