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 maartendeneckere@gmail.com
---------- Forwarded message ---------- From: Nicholas Wiltshire NWILTSHIRE@sahra.org.za Date: 2012/6/25 Subject: Re: Struggling with the monuments database To: maarten deneckere maartendeneckere@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, Nic
maarten deneckere maartendeneckere@gmail.com 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
Hi Maarten
I can help with this - what do you need done with it? (apologies if this is obvious from earlier posts, I haven't been following the discussion) The Wikimedia projects have an all but non-existent data structure, hence the need for the Wikidata project. It may be easier if I give you a quick call to discuss this - probably easier than email back and forths.
Maarten,
Do you have a copy of the full list available as well?
I would like to write some code that can reformat this as a wikitable and upload the completed table to the en: and af: articles on wikipedia.
Nick
On 25/06/2012 21:23, maarten deneckere wrote:
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 <maartendeneckere@gmail.com mailto:maartendeneckere@gmail.com>
---------- Forwarded message ---------- From: *Nicholas Wiltshire* <NWILTSHIRE@sahra.org.za <mailto:NWILTSHIRE@sahra.org.za>> Date: 2012/6/25 Subject: Re: Struggling with the monuments database To: maarten deneckere <maartendeneckere@gmail.com <mailto:maartendeneckere@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, Nic >>> maarten deneckere <maartendeneckere@gmail.com <mailto:maartendeneckere@gmail.com>> 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
WikimediaZA mailing list WikimediaZA@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikimediaza
wikimediaza@lists.wikimedia.org