Hi!

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 :)

Greets
--
Alex
User:AleXXw



On Wed, Mar 28, 2012 at 20:57, Maarten Dammers <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:
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
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.eu