make.opendata.ch wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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
     * > NO: The map has both licensing and bulk download costs.
   * It's publicy available
   * It's machine-readable
   * It's digital
   * It's up-to-date
   * It's available in bulk

Government Budget
http://www.efv.admin.ch/d/dokumentation/oeff_finanzen/index.php
http://www.efv.admin.ch/d/dokumentation/finanzberichterstattung/budget.php
   * Data exists
   * It's unclear if it's openly licensed
     * > NO: only reports, summaries, and extracts are accessible, and nowhere is an open license indicated.
   * It's publicy available
   * It's unclear if it's machine-readable
     * > 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
     * > YES, the website is updated regularly.
   * It's unclear if it's available in bulk
     * > NO: only reports, summaries, and extracts are accessible.

Election Results
http://www.parlament.ch/E/WAHLEN-ABSTIMMUNGEN/PARLAMENTSWAHLEN/Pages/default.aspx
http://www.parlament.ch/E/DOKUMENTATION/WEBSERVICES-OPENDATA/Pages/default.aspx
   * Data exists
   * It's unclear if it's openly licensed
     * > NO: "reproduction of any part of the website requires the prior written consent" and the open web service data may be used only with special conditions
   * It's publicy available
   * It's unclear if it's machine-readable
     * > YES: web services are available
   * It's digital
   * It's up-to-date
   * It's unclear if it's available in bulk
     * > YES: web services are available

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
     * > 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.
   * It's digital
   * It's up-to-date
   * It's unclear if it's available in bulk
     * > YES: premium subscribers can download all data.

Government Spending
http://www.pxweb.bfs.admin.ch/Dialog/statfile.asp?lang=2&prod=18
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&prod=18&secprod=3&openChild=true
   * Data exists
   * It's unclear if it's openly licensed
     * 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
   * It's digital
   * 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
http://www.admin.ch/ch/d/as/index.html
   * Data exists
   * It's openly licensed
     * > 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: 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
   * It's unclear if it's available in bulk
     * > NO: can't find a download link anywhere

National Statistics
http://www.bfs.admin.ch/bfs/portal/fr/index/infothek/interactiv.html
http://www.bfs.admin.ch/bfs/portal/de/index/infothek/interactiv.html#parsys_96871 or
http://www.pxweb.bfs.admin.ch/dialog/statfile.asp?lang=1 ??
   * 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
   * It's digital
   * It's up-to-date
   * It's unclear if it's available in bulk
     * > 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
http://www.cadastre.ch/internet/cadastre/de/home/products/plz/data.html
   * Data exists
   * It's openly licensed
     * > 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
     * > YES.
   * It's available in bulk

Public Transport
http://transport.opendata.ch/
   * Data exists
   * It's unclear if it's openly licensed
     * > YES. This data can be used without restrictions.
   * It's publicy available
   * It's machine-readable
   * It's digital
   * It's up-to-date
   * It's unclear if it's available in bulk
     * > 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
http://www.bafu.admin.ch/umwelt/indikatoren/index.html?lang=de
   * Data exists
   * It's unclear if it's openly licensed
     * > NO.
   * It's unclear if it's publicy available
     * > NO.
   * It's unclear if it's machine-readable
     * > YES.
   * It's unclear if it's digital
     * > YES.
   * It's unclear if it's up-to-date
     * > NO: many indicators are 5 years old+
   * It's unclear if it's available in bulk
     * > NO.