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 <http://de.wikipedia.org/wiki/Benutzer:AleXXw>



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




_______________________________________________
Wiki Loves Monuments mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.eu

_______________________________________________
Wiki Loves Monuments mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.eu

Reply via email to