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_si... and https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Historic_sites/Unused_im... (+de and fr) and these will only work when the real KGS numbers are added.
Maarten
Greets
Alex User:AleXXw http://de.wikipedia.org/wiki/Benutzer:AleXXw
On Wed, Mar 28, 2012 at 20:57, Maarten Dammers <maarten@mdammers.nl mailto:maarten@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 WikiLovesMonuments@lists.wikimedia.org <mailto: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