Struggling with the monuments database - WikimediaZA

25 Jun 2012

Hey all,

we got 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. Download the file on
http://geneeskundestuderen.com/SampleDeclaredSites.xls

I'm no real database expert, who could help us with extracting all the
necessary information out of this file?

Regards,
Maarten

2012/6/25 maarten deneckere &lt;maartendeneckere(a)gmail.com&gt;

...
  ---------- Forwarded message ----------
 From: Nicholas Wiltshire &lt;NWILTSHIRE(a)sahra.org.za&gt;
 Date: 2012/6/25
 Subject: Re: Struggling with the monuments database
 To: maarten deneckere &lt;maartendeneckere(a)gmail.com&gt;

 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,
 Nic

 >> maarten deneckere
&lt;maartendeneckere(a)gmail.com&gt; 22/06/2012 18:39 >>>  Hey Nicholas,

 I hope everything goes well. I'm back on holiday and focussing again on the
 competition :-)

 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.

 Groete,
 Maarten Deneckere