---------- Forwarded message ----------
From: Maarten Dammers <>
Date: Sun, Apr 15, 2012 at 00:24
Subject: Re: [Wiki Loves Monuments] Add kgs nr in Switzerland

Hi Alex,

Op 28-3-2012 23:42, Alexander Wagner schreef:

Database with all data form is ready
on toolserver (u_alexxw_p -> Swiss_KGS_Nr). I hope someone can help me
with the second part :)

I removed the truncating from the three Switzerland tables. This was
causing strange results. Would be nice if someone could help out
getting these numbers added. I already created
(+de and fr) and these will only work when the real KGS numbers are



On Wed, Mar 28, 2012 at 20:57, Maarten Dammers <> wrote:
> Hi Alex,
> CCing the Wiki Loves Monuments list. Maybe someone feels like helping out.
> Op 28-3-2012 0:10, Alexander Wagner schreef:
>> I only found these kgs_nr. Haven't found an easy way to harvest them.
> I found a way, but not an easy one:
> 1) Goto
> 2) Zoom out to max
> 3) check "Kulturgüter" on the left
> 4) Use the (i)-tool on top and draw a rectangle over all switzerland
> 5) all objects are shown in a list below the map. You also can download CSVs, 
> unfortunately seperated in some hundred objecttypelists...
> Would this lists help you creating some script? I hope I don't need to add 
> them manually...
> We would somehow need to download all the csv files and put them in a big 
> table at the toolserver. It's probably not too hard to have a program take 
> the html page and look for all url's containing csv file. For each file 
> download it and insert it in a database at the toolserver.
> Once we have this database we can compare it to the information we already 
> have about Switzerland and match items.
> This is how I did it with the National Register of Historic Places. This 
> information is in the p_erfgoed_nrhp_p database at the toolserver (server: 
> sql). I wrote 
>  for that. Could probably be adapted to work for Switzerland too.
> Maarten
> _______________________________________________
> Wiki Loves Monuments mailing list

Wiki Loves Monuments mailing list

Wiki Loves Monuments mailing list

_______________________________________________ Wikimedia CH website
Wikimediach-l mailing list

Antwort per Email an