Differences

This shows you the differences between two versions of the page.

--- okfn:census-ch [2013/06/02 01:22] – created loleg
+++ okfn:census-ch [2013/06/09 09:08] (current) – loleg
@@ Line 1: / Line 1: @@
-====== OKFN National Census Worksheet. Switzerland ======
+====== OKFN National Census Worksheet Switzerland
+ ======
+=== Summary ===
+<html>
+<table dir="ltr" border="0" cellpadding="0" cellspacing="0" class="tblGenFixed" id="tblMain"><tbody><tr class="rShim"><td class="rShim" style="width:0;"></td><td class="rShim" style="width:120px;"></td><td class="rShim" style="width:120px;"></td><td class="rShim" style="width:120px;"></td><td class="rShim" style="width:120px;"></td><td class="rShim" style="width:120px;"></td><td class="rShim" style="width:120px;"></td><td class="rShim" style="width:120px;"></td><td class="rShim" style="width:120px;"></td><td class="rShim" style="width:120px;"></td><td class="rShim" style="width:120px;"></td><td class="rShim" style="width:120px;"></td></tr><tr dir="ltr"><td class="hd"><p style="height:16px;">.</p></td><td dir="ltr" class="s0">Dataset</td><td dir="ltr" class="s1">Data Availability [Does the data exist?]</td><td dir="ltr" class="s1">Data Availability [Is it in digital form?]</td><td dir="ltr" class="s1">Data Availability [Is it machine readable? (E.g. spreadsheet not PDF)]</td><td dir="ltr" class="s1">Data Availability [Available in bulk? (Can you get the whole dataset easily)]</td><td dir="ltr" class="s1">Data Availability [Is it publicly available, free of charge?]</td><td dir="ltr" class="s1">Data Availability [Is it openly licensed? (as per the http://OpenDefinition.org/)]</td><td dir="ltr" class="s1">Data Availability [Is it up to date?]</td><td dir="ltr" class="s1">Location of Data Online</td><td dir="ltr" class="s1">Date it became available</td><td dir="ltr" class="s1">Details and comments</td></tr><tr dir="ltr"><td class="hd"><p style="height:16px;">.</p></td><td dir="ltr" class="s2">Company Register</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">No </td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">No </td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3"><a target="_blank" href="http://www.google.com/url?q=http://www.bfs.admin.ch/bfs/portal/de/index/themen/00/05/blank/02.html&amp;sa=D&amp;usg=ALhdy2-JhiSyywVIXZ-ll3XeOqaq9QFdPw">http://www.bfs.admin.ch/bfs/portal/de/index/themen/00/05/blank/02.html</a></td><td class="s4">11/1/2011</td><td dir="ltr" class="s3">Premium subscribers can download all data from http://www.moneyhouse.ch/en/companysearch.htm</td></tr><tr dir="ltr"><td class="hd"><p style="height:16px;">.</p></td><td dir="ltr" class="s2">Election Results (national)</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">No </td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3"><a target="_blank" href="http://www.google.com/url?q=http://www.parlament.ch/E/DOKUMENTATION/WEBSERVICES-OPENDATA/Pages/default.aspx&amp;sa=D&amp;usg=ALhdy29HxnU6Mk12w0VFWyCU5r3eEzyDrA">http://www.parlament.ch/E/DOKUMENTATION/WEBSERVICES-OPENDATA/Pages/default.aspx</a></td><td class="s4">8/6/2011</td><td dir="ltr" class="s3">Open web service data may be used only with special conditions</td></tr><tr dir="ltr"><td class="hd"><p style="height:16px;">.</p></td><td dir="ltr" class="s2">Government Budget (National, high level, not detailed)</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">No </td><td dir="ltr" class="s3">No </td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">No </td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3"><a target="_blank" href="http://www.google.com/url?q=http://www.efv.admin.ch/d/dokumentation/finanzberichterstattung/budget.php&amp;sa=D&amp;usg=ALhdy2-saEJQkwCIdroHFxQF5aRKk71qIA">http://www.efv.admin.ch/d/dokumentation/finanzberichterstattung/budget.php</a></td><td class="s4">2008</td><td dir="ltr" class="s3">Reports, summaries, and extracts are accessible, but nowhere is an open license indicated.</td></tr><tr dir="ltr"><td class="hd"><p style="height:16px;">.</p></td><td dir="ltr" class="s2">Government Spending (National, transactional level data)</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3"><a target="_blank" href="http://www.google.com/url?q=http://www.pxweb.bfs.admin.ch/Database/German_18%2520-%2520%25C3%2596ffentliche%2520Verwaltung%2520und%2520Finanzen/18.3%2520-%2520Ausgaben%2520der%2520%25C3%25B6ffentlichen%2520Haushalte/18.3%2520-%2520Ausgaben%2520der%2520%25C3%25B6ffentlichen%2520Haushalte.asp?lang%3D1%26prod%3D18%26secprod%3D3%26openChild%3Dtrue&amp;sa=D&amp;usg=ALhdy2--VX5nbpdpWO6Uw2RgBdbhJiAr3g">http://www.pxweb.bfs.admin.ch/Database/German_18%20-%20%C3%96ffentliche%20Verwaltung%20und%20Finanzen/18.3%20-%20Ausgaben%20der%20%C3%B6ffentlichen%20Haushalte/18.3%20-%20Ausgaben%20der%20%C3%B6ffentlichen%20Haushalte.asp?lang=1&amp;prod=18&amp;secprod=3&amp;openChild=true</a></td><td class="s4">5/11/2012</td><td dir="ltr" class="s3">License is similar to BY-NC</td></tr><tr dir="ltr"><td class="hd"><p style="height:16px;">.</p></td><td dir="ltr" class="s2">Legislation (laws and statutes) - National</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">No </td><td dir="ltr" class="s3">No </td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3"><a target="_blank" href="http://www.google.com/url?q=http://www.admin.ch/ch/d/as/index.html&amp;sa=D&amp;usg=ALhdy2_aYxQwn7MFYtdyVOY8RubpWyLKPw">http://www.admin.ch/ch/d/as/index.html</a></td><td class="s4">2010</td><td dir="ltr" class="s3">We need to do some research on their new data model</td></tr><tr dir="ltr"><td class="hd"><p style="height:16px;">.</p></td><td dir="ltr" class="s2">National Map (Low resolution: 1:250,000 or better)</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">No </td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3"><a target="_blank" href="http://www.google.com/url?q=http://www.geo.admin.ch/internet/geoportal/en/home/services.html&amp;sa=D&amp;usg=ALhdy28cevaf23QsW68td0LUzuNu8d_xyg">http://www.geo.admin.ch/internet/geoportal/en/home/services.html</a></td><td dir="ltr" class="s3">17/08/2010</td><td dir="ltr" class="s3">From 16/9/2013 this will move to the national OGD portal</td></tr><tr dir="ltr"><td class="hd"><p style="height:16px;">.</p></td><td dir="ltr" class="s2">National Postcode/ZIP database</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3"><a target="_blank" href="http://www.google.com/url?q=http://www.cadastre.ch/internet/cadastre/de/home/products/plz/data.html&amp;sa=D&amp;usg=ALhdy28RELNTrs1l6wL3hsPyMxSEypOQxQ">http://www.cadastre.ch/internet/cadastre/de/home/products/plz/data.html</a></td><td class="s4">8/7/2010</td><td dir="ltr" class="s3">Commercial use requires attribution</td></tr><tr dir="ltr"><td class="hd"><p style="height:16px;">.</p></td><td dir="ltr" class="s2">National Statistical Data (economic and demographic information)</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3"><a target="_blank" href="http://www.google.com/url?q=http://www.bfs.admin.ch/bfs/portal/fr/index/infothek/interactiv.html&amp;sa=D&amp;usg=ALhdy29N3usVIp9MBRVcSJ042SESrFa17Q">http://www.bfs.admin.ch/bfs/portal/fr/index/infothek/interactiv.html</a></td><td dir="ltr" class="s3">13/07/2011</td><td dir="ltr" class="s3">Bulk data in proprietary, though free, software format</td></tr><tr dir="ltr"><td class="hd"><p style="height:16px;">.</p></td><td dir="ltr" class="s2">Public Transport Timetables</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">No </td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3">Yes</td><td dir="ltr" class="s3"><a target="_blank" href="http://www.google.com/url?q=http://transport.opendata.ch/&amp;sa=D&amp;usg=ALhdy28K36xiqW1rCn9dtEd3D2eXGpZWYA">http://transport.opendata.ch/</a></td><td dir="ltr" class="s3">30/03/2012</td><td dir="ltr" class="s3">Maintained by the Open Data community</td></tr></tbody></table>
+</html>
+=== Details ===
 National Map
 http://www.geo.admin.ch/internet/geoportal/en/home/services.html
+* NB: Ab 16. September wird swisstotpo voraussichtlich diese und andere als OGD deklarierte Datensätze nicht mehr über den toposhop sondern über www.opendata.admin.ch anbieten
    * Data exists
    * It's unclear if it's openly licensed
-     * Lets clarify this point - I'm pretty sure the map is not open at this time, and has both licensing and bulk download costs. Therefore the answer should be NO.
+     * > NO: The map has both licensing and bulk download costs.
    * It's publicy available
    * It's machine-readable
@@ Line 20: / Line 30: @@
    * It's publicy available
    * It's unclear if it's machine-readable
-     * > NO to this because Excel basis daten are provided for Kennzahlen, but only PDF for budget.
+     * > NO: Excel basis daten are provided for Kennzahlen, but only PDF for budget.
    * It's digital
    * It's unclear if it's up-to-date
@@ Line 43: / Line 53: @@
 Company Register
 http://www.moneyhouse.ch/en/companysearch.htm
+http://www.bfs.admin.ch/bfs/portal/de/index/themen/00/05/blank/02.html
+http://www.zefix.ch/zfx-cgi/hrform.cgi/hraPage?alle_eintr=on&pers_sort=original&pers_num=0&language=1&col_width=366&amt=007
    * Data exists
    * It's unclear if it's openly licensed
-     * > NO.
+     * > YES:
+       * Can be reused, at no fee.
+       * If published as Handelsregisterdaten must be reused as is.
+       * Besides, regulation of data protection act must be respected.
    * It's publicy available
    * It's unclear if it's machine-readable
-     * > NO. (Premium access does not qualify, I think)
+     * > NO. Premium access does not qualify.
    * It's digital
    * It's up-to-date
@@ Line 59: / Line 74: @@
    * Data exists
    * It's unclear if it's openly licensed
-     * > ?? Can someone explain http://www.bfs.admin.ch/bfs/portal/de/index/dienstleistungen/premiere_visite/02/02_03/legal.html
+     * http://www.bfs.admin.ch/bfs/portal/de/index/dienstleistungen/premiere_visite/02/02_03/legal.html
+     * > YES, similar to BY-NC license.
    * It's publicy available
    * It's machine-readable
@@ Line 65: / Line 81: @@
    * It's up-to-date
    * It's unclear if it's available in bulk
-     * > ??
+     * > YES, http://www.pxweb.bfs.admin.ch/Database/French_18%20-%20Administration%20et%20finances%20publiques/18.1%20-%20Survol/18.1%20-%20Survol.asp?lang=2&prod=18&secprod=1&openChild=true
 Legislation
@@ Line 71: / Line 87: @@
    * Data exists
    * It's openly licensed
-     * > NO: typical copyright applies
+     * > YES: no copyright for Swiss legislation (Art. 5 al. 1 litera a of the Copyright Act)
    * It's publicy available
    * It's unclear if it's machine-readable
-     * > NO: bunch of PDFs does not qualify.
+     * > NO: a bunch of PDFs (and non-semantic HTML) does not qualify.
+       * Recent changes made, the repository now works with "classified compliation" as a term, not sure how this relates to the data model behind the interface, something we should ask
    * It's digital
    * It's up-to-date
@@ Line 86: / Line 103: @@
    * Data exists
    * It's openly licensed
+     * YES: Free to be reused, when mentioning the source (http://www.admin.ch/opc/de/classified-compilation/19920252/index.html#a20)
+     * YES: Note, however, that sometimes fees may apply
    * It's publicy available
    * It's machine-readable
@@ Line 91: / Line 110: @@
    * It's up-to-date
    * It's unclear if it's available in bulk
-     * > Can someone clarify?
+     * > YES: most statistics can be downloaded as PC-Axis cubes, which can be converted to another database format with the software available here: http://www.scb.se/Pages/List____346331.aspx
 Postcode/ZIP database
-https://match.postmail.ch/match_zip?SIT_ID=5&SPRCDE=1
+http://www.cadastre.ch/internet/cadastre/de/home/products/plz/data.html
    * Data exists
    * It's openly licensed
-     * > NO: commercial restrictions apply.
+     * > YES: "Die Datensätze stehen jeweils in den beiden Bezugsrahmen LV03 und LV95 auf www.cadastre.ch/plz zur Verfügung. Der Datensatz darf frei verwendet werden. Bei kommerzieller Anwendung verlangen wir eine Quellangabe «Amtliche Vermessung Schweiz / swisstopo». "
    * It's publicy available
    * It's machine-readable
    * It's digital
    * It's unclear if it's up-to-date
-     * > Can someone clarify?
+     * > YES.
    * It's available in bulk
@@ Line 115: / Line 134: @@
    * It's up-to-date
    * It's unclear if it's available in bulk
-     * > Can someone clarify; i.e. can the entire network map be downloaded?
+     * > NO. Available in Bulk heisst schon, dass man alles auf's mal runterladen kann, und das ist bei so einer API definitiv nicht der Fall.
 Environmental pollutants
@@ Line 132: / Line 151: @@
    * It's unclear if it's available in bulk
      * > NO.