What type of database tasks should we do with it? I have done some DB programming, but
I don't know any of the real advanced stuff.
From: maarten deneckere <maartendeneckere(a)gmail.com>
To: Isla Haddow-Flood <islahf(a)africacentre.net>et>; dumisanin(a)iburst.co.za; Lourie
Pieterse <louriepieterse(a)yahoo.com>om>; Charlene Foster <afrastocracy(a)gmail.com>om>;
Blessing Chataira <blessing(a)itoca.org>
Cc: wikimediaza <WikimediaZA(a)lists.wikimedia.org>
Sent: Monday, June 25, 2012 10:35 AM
Subject: Fwd: Struggling with the monuments database
in attach a sample file of the monuments database. I asked this to allow us to see what
kind of information we can use, and what type of processing we have to do.
I'm no real database expert, who could help us with extracting all the necessary
information out of this file?
---------- Forwarded message ----------
From: Nicholas Wiltshire <NWILTSHIRE(a)sahra.org.za>
Subject: Re: Struggling with the monuments database
To: maarten deneckere <maartendeneckere(a)gmail.com>
Hi Maarten - thanks for your email. Attached is the sample extract of the database. I just
migrated the sites to our server on Friday and am busy linking up the declaration history
to the sites. You can ignore the Primary key column - between you and I we'll simply
assign a new autoincrement ID field numbered 1-3580 so that it's easy later on to
match our dbase to the wiki photos.
I'll send you the MOU as soon as Herma is done checking it - but she mentioned that I
should not expect it this week - but at least you can carry on with the sample as the
structure is half the job..
All the best,
>> maarten deneckere
<maartendeneckere(a)gmail.com> 22/06/2012 18:39 >>>
I hope everything goes well. I'm back on holiday and focussing again on the
From the earlier competition in Europe I know we will run into some
problems on the monument database. We have to process it and turn it into a
data structure that we can use on Wikipedia, on Commons and on our own
website. This takes quite a lot of work.
Can you send us a "sample" of the monument database? Let's say of about 200
monuments in a certain region. We will use this sample data to learn what
kind of processing we have to do on the whole data set. This will speed up
the process if we would get the full database.
Off course, this is a sample file: we will only use it to test the
processing and will remove all the information afterwards.