> Perhaps someone can check wit a tool/bot/query which lists have double id's so that we can check and fix that. Who can do that?
>
> Greetings - Romaine
>
> --- On Thu, 8/25/11, Andre Koopal <
andre@molens.org> wrote:
>
>> From: Andre Koopal <
andre@molens.org>
>> Subject: Re: [Wiki Loves Monuments] Spanish database [Was: European stats and other cool tools]
>> To: "Wiki Loves Monuments Photograph Competition" <
wikilovesmonuments@lists.wikimedia.org>
>> Date: Thursday, August 25, 2011, 7:48 PM
>> On Thu, Aug 25, 2011 at 11:42:44AM
>> -0700, Romaine Wiki wrote:
>> > I do not get it...
>> >
>> > I watched this:
>> >
http://www.wikilovesmonuments.org.pt/tools/stats-eu/index2.php?format=table&item[]=total&item[]=name&item[]=name_pct&item[]=address&item[]=address_pct&item[]=municipality&item[]=municipality_pct&item[]=coordinates&item[]=coordinates_pct&item[]=image&item[]=image_pct&width=1000&height=700&filter[]=be-vlg&breakdown=municipality&groupby=item&color=heatpct
>> >
>> > I took as example As. In the table on the wiki it has
>> 26 rows and 3 pictures. (Both since september 2009.)
>> >
>> > The table of the link above says 23 rows and 2
>> pictures.
>>
>> Hi Romaine,
>>
>> The stats comes from the database that Maarten made, I
>> dived a bit into
>> this, and in the table from As I see 2 duplicate id's.
>> (
http://nl.wikipedia.org/wiki/Lijst_van_onroerend_erfgoed_in_As)
>>
>> As the id is the unique key, only the last one will make it
>> in the database.
>>
>> Regards,
>>
>> Andre
>> >
>> >
>> > Another one: Rotselaar: On the wiki 25 rows and 3
>> pictures. In the table of the link above 23 rows and 0
>> pictures.
>> >
>> > I tried a lot others, all with errors. Also for be-wal
>> the same errors.
>> >
>> > Greetings - Romaine
>> >
>> >
>> >
>> > --- On Thu, 8/25/11, Nuno Tavares <
nuno.tavares@wikimedia.pt>
>> wrote:
>> >
>> > > From: Nuno Tavares <
nuno.tavares@wikimedia.pt>
>> > > Subject: Re: [Wiki Loves Monuments] Spanish
>> database [Was: European stats and other cool tools]
>> > > To:
wikilovesmonuments@lists.wikimedia.org
>> > > Date: Thursday, August 25, 2011, 2:40 AM
>> > > Dear spanish fellows:
>> > >
>> > > I've notice some quality problems in the
>> municipality names
>> > > of the
>> > > objects on es/es-ct/es-vc lists. Sometimes they
>> are [[like
>> > > this]],
>> > > others "like this" and also "{{ordre|like
>> this}}". In my
>> > > opinion, this
>> > > is half-way for problems in managing the lists.
>> > >
>> > >
http://www.wikilovesmonuments.org.pt/tools/stats-eu/index2.php?format=table&item[]=total&item[]=name&item[]=name_pct&item[]=address&item[]=address_pct&item[]=municipality&item[]=municipality_pct&item[]=coordinates&item[]=coordinates_pct&item[]=image&item[]=image_pct&width=1000&height=700&filter[]=es-vc&filter[]=es&filter[]=es-ct&breakdown=municipality&groupby=item&color=heatpct
>> > >
>> > >
>> > > It's pretty easy to clean that up, but I'm still
>> not sure
>> > > if Maarten is
>> > > loading the database from wiki lists (thus
>> overriding any
>> > > fixes we
>> > > perform). Get in touch with me if you need help.
>> > >
>> > > PS: I don't have much opportunities to hang
>> around IRC, but
>> > > feel free to
>> > > ping me in Skype.
>> > >
>> > > PS2: Andorra and France seem to suffer the same
>> symptoms.
>> > >
>> > > --
>> > > 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
>> > >
>> > > Em
25-08-2011 02:49, Nuno Tavares escreveu:
>> > > > Hey again,
>> > > >
>> > > > Didn't I say I love statistics? :-)
>> > > >
>> > > > You can now have your "heat" list adding the
>> option
>> > > "color=heatpct":
>> > > >
>> > > >
http://www.wikilovesmonuments.org.pt/tools/stats-eu/index2.php?format=table&item[]=total&item[]=name&item[]=name_pct&item[]=address&item[]=address_pct&item[]=municipality&item[]=municipality_pct&item[]=coordinates&item[]=coordinates_pct&item[]=image&item[]=image_pct&width=1000&height=700&filter[]=pt&breakdown=municipality&groupby=item&color=heatpct
>> > > >
>> > > >
>> > > >
>> > >
>> > > _______________________________________________
>> > > Wiki Loves Monuments mailing list
>> > >
WikiLovesMonuments@lists.wikimedia.org
>> > >
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
>> > >
http://www.wikilovesmonuments.eu
>> > >
>> >
>> > _______________________________________________
>> > Wiki Loves Monuments mailing list
>> >
WikiLovesMonuments@lists.wikimedia.org
>> >
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
>> >
http://www.wikilovesmonuments.eu
>>
>> _______________________________________________
>> Wiki Loves Monuments mailing list
>>
WikiLovesMonuments@lists.wikimedia.org
>>
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
>>
http://www.wikilovesmonuments.eu
>>
>
> _______________________________________________
> Wiki Loves Monuments mailing list
>
WikiLovesMonuments@lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
>
http://www.wikilovesmonuments.eu
>
_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.eu