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 <[email protected]> wrote: > From: Andre Koopal <[email protected]> > Subject: Re: [Wiki Loves Monuments] Spanish database [Was: European stats and > other cool tools] > To: "Wiki Loves Monuments Photograph Competition" > <[email protected]> > 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 <[email protected]> > wrote: > > > > > From: Nuno Tavares <[email protected]> > > > Subject: Re: [Wiki Loves Monuments] Spanish > database [Was: European stats and other cool tools] > > > To: [email protected] > > > 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 > > > [email protected] > > > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > > > http://www.wikilovesmonuments.eu > > > > > > > _______________________________________________ > > Wiki Loves Monuments mailing list > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > > http://www.wikilovesmonuments.eu > > _______________________________________________ > Wiki Loves Monuments mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > http://www.wikilovesmonuments.eu > _______________________________________________ Wiki Loves Monuments mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu
