Vicenç:
The "unique id" is only relevant in the context/table of a country,
because the aggregated/overall table would be a merge of all "country
tables". In that table, the ID would have always to be a compound key
like "countrycode,id".
It seems, however, for Spain you shouldn't use integers. I personally
don't like reducing "R-I-51-0010580" to the integer "10580", unless you
are pretty sure "R-I-51" can be inferred from other data (like "R-I"
being a classification, 51 being the "comunidad autonoma" identifier,
etc).
And, from what I've seen so far, it won't work either for Portugal, as
it seems we will face a similar issue whenever I merge "Madeira" and
"Azores" island heritage.
Reference page:
http://commons.wikimedia.org/wiki/Commons:Wiki_Loves_Monuments_2011/Monument...
--
Nuno Tavares
Wikimedia Portugal
http://www.wikimedia.pt
Imagine um mundo onde é dada a qualquer pessoa a possibilidade de ter livre acesso ao somatório de todo o conhecimento humano. É isso o que estamos a fazer.
Participe também:
http://www.wikimedia.pt
Dom, 2011-03-13 às 20:13 +0100, Siebrand Mazeland escreveu:
> Hi Vicenç. Please consider the concept of "unique identifier"[1]. The
> only purpose it has is that it must be able to uniquely identify an
> entity, in this case a momument. A uniquely identified monument can
> have multiple properties. One of those could be the country it is in
> (or normalised a country id which is the unique identifier of a
> country name), or a reference to a unique identifier in a country's
> system, a municipality's system or an autonomous region's system for
> monuments.
>
>
> Unique identifiers are completely trivial and the only requirement is
> that they are unique and that you do not run out of them before your
> collection is complete. Unique identifiers are usually optimised for
> data processing, and databases index integers usually pretty well.
>
>
> Cheers!
>
>
> Siebrand
>
>
> [1]
http://en.wikipedia.org/wiki/Unique_identifier
>
>
> Van: Vicenç Riullop
vriullop@hotmail.com
> Beantwoorden - Aan: Wiki Loves Monuments Photograph Competition
>
wikilovesmonuments@lists.wikimedia.org
> Datum: Sun, 13 Mar 2011 16:01:02 +0000
> Aan:
wikilovesmonuments@lists.wikimedia.org
> Onderwerp: [Wiki Loves Monuments] Unique identifiers
>
>
>
> I have some doubts about the identifiers. How will we distinguish if
> monument number 50 is from Nederland or Andorra? Perhaps should it be
> identified with a prefix (NL-50, AD-50), or perhaps is there any
> solution in mind?
>
>
>
> Moroever, in Spain we can find different formats in different sources:
> "(R.I.) - 51 - 0010580 - 00000", "R-I-51-0010580", and others.
> Obviously we need to unify to an unique format and we are discussing
> it with wm-es, but I would appreciate some inputs. "R.I." or "R-I"
> stands for Registro de Inmuebles (buildings' register) and "51" is the
> category for monuments. Probably it is not a good idea to ask
> participants to type acomplicated number format with spaces, zeros,
> etc. One solution is to reduce it to its numeric form "10580" or
> perhaps to construct a simplified format like "RI510010580". What are
> the technical implications about identifiers, and which would be the
> best approach?
>
>
>
> _______________________________________________
> Wiki Loves Monuments mailing list
> WikiLovesMonuments@lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
>
http://www.wikilovesmonuments.eu