Santigo,
In such scenario, I would advise you create compound IDs. And then
again, forget the wikipedia lists for a moment. By referencing the
source you can all recover from whatever damage you'll be doing.
So, for instance, suppose:
* Monument A, from list A, has id 3
* Monument B, from list B, has no id
* Monument A is also at list C, with id 5
If you created a compound ID (primary key) like this (source,id
auto_increment) with an attribute (field) alt_source_id, when you insert
the values, you'll do (pseudocode):
INSERT (a, 3, NULL);
INSERT (b, NULL, NULL);
INSERT OR UPDATE (a,3,5);
And you'll get:
a,3,5 => maps to ID A3, or A-3, whatever you want
b,1,NULL => maps to ID B1, or B-1...
See my mail a couple of minutes ago for an idea using parserfunctions to
decide what to do when publishing to wikipedia lists. For instance, you
could entirely hide "source=b" ids.... or later on, you could decide to
switch the Ids (3 for 5 in row "a", etc) and regenerate the lists.
Storing "extra" attributes was one of the reasons I found the WLM
monuments database insufficient. Nobody's fault, though, our solution is
far more time-consuming to implement and would require a lot of code
refactoring (bots and alike)... but we can regenerate the wikipedia
lists which are far older than WLM, which contain wikilinks inside the
descriptions (we actually did it), thus allowing us to know which
wikipedia articles the monument entry refers to...
-NT
Em 23-05-2012 14:24, Santiago Navarro Sanz escreveu:
Last year Wikimedia Spain only listed monuments
declared "Bien de
Interés Cultural" and registered and listed on Ministry site, with the
code given by ministry. But this site is not very accurated. Many
regional goverments have their own site with their own ID, different
from ministry. And these lists are usually more accurated and they have
more monuments not listed in the site of the ministry.
Why do I say this? Because we find monuments with two different ID (one
given by ministry and another by regional goverment). Both are official.
Must we show both? In my opinion yes, because both ID are useful and
encycopedical information. How does it afect to the database of WLM?
Examples of this case could be: Catalonia, Aragon, Murcia, Valencia or
Andalucia.
But usually, like in Castille and León or Basque Country, there is not
an ID available in their sites. In these two cases we can find a unique
number for identifing them in the url. Could we use this number as ID?
And then, there is a third case. When we have monuments but nowhere
there is a ID or something like that available. What can we do in this
cases? Could we create an ID for the contest? How can we show that this
code is not official to wikipedia readers? Examples: Navarre or Cantabria.
I'm very busy in my real life at this moment, but in one month I'll be
active another time in this project.
Thank you for your opinions, suggestions and advices.
Regards!!
Santiago Navarro
Wikimedia España
user:Millars
_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.eu