fyi.
---------- Forwarded message ---------- From: Maarten Dammers <maar...@mdammers.nl> Date: Sun, Apr 15, 2012 at 00:24 Subject: Re: [Wiki Loves Monuments] Add kgs nr in Switzerland To: wikilovesmonume...@lists.wikimedia.org Hi Alex, Op 28-3-2012 23:42, Alexander Wagner schreef: Database with all data form http://kgs-gis.admin.ch/kgs.php 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 https://commons.wikimedia.org/wiki/Template:Cultural_property_of_national_significance_in_Switzerland and https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Historic_sites/Unused_images_of_Cultural_properties_of_national_significance_in_Switzerland (+de and fr) and these will only work when the real KGS numbers are added. Maarten Greets -- Alex User:AleXXw On Wed, Mar 28, 2012 at 20:57, Maarten Dammers <maar...@mdammers.nl> 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 http://kgs-gis.admin.ch/kgs.php > 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 > https://fisheye.toolserver.org/browse/multichill/bot/erfgoed/NRHP_refnums.py?hb=true > for that. Could probably be adapted to work for Switzerland too. > > Maarten > > > _______________________________________________ > Wiki Loves Monuments mailing list > wikilovesmonume...@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments > http://www.wikilovesmonuments.eu _______________________________________________ Wiki Loves Monuments mailing list wikilovesmonume...@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu _______________________________________________ Wiki Loves Monuments mailing list wikilovesmonume...@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu _______________________________________________ http://wikimedia.ch Wikimedia CH website Wikimediach-l mailing list https://lists.wikimedia.org/mailman/listinfo/wikimediach-l