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



_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.eu