A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Topic | Category | Post-it comment | Link (added later) | ||||||||||||||||||||||
2 | Tools | Conversion | Data Baker - Transforming spreadsheets transforming XLS to structured CSV. Open source software designed by Sensible Code Company for ONS | https://github.com/sensiblecodeio/databaker | ||||||||||||||||||||||
3 | Tools | Sites, portals and paper | Florence - Statistical data publishing mainly spreadsheets. Bespoke CMS built by ONS for it's website | https://digitalblog.ons.gov.uk/2017/03/03/what-weve-learnt-about-building-a-publishing-platform/ | ||||||||||||||||||||||
4 | Tools | Sites, portals and paper | PublishMyData: Swirrl platform - ONS Geography, stats publication at DCLG, Scottish Gov, NHS | http://www.swirrl.com/ | ||||||||||||||||||||||
5 | Tools | Sites, portals and paper | ONS website | https://www.ons.gov.uk/ | ||||||||||||||||||||||
6 | Tools | Sites, portals and paper | EU Open Data Portal | https://data.europa.eu/euodp/en/home | ||||||||||||||||||||||
7 | Tools | Sites, portals and paper | NOMIS website | https://www.nomisweb.co.uk/ | ||||||||||||||||||||||
8 | Tools | Sites, portals and paper | Eprints Repository tool | http://www.eprints.org/uk/index.php/eprints-software/ | ||||||||||||||||||||||
9 | Tools | Management | Data Management. Open source databases: MySQL | https://www.mysql.com/ | ||||||||||||||||||||||
10 | Tools | Management | Data Management. Open source databases: PostgreSQL | https://www.postgresql.org/ | ||||||||||||||||||||||
11 | Tools | Management | Data Management. Open source databases: PostGIS | http://postgis.net/ | ||||||||||||||||||||||
12 | Tools | Management | Data Management. Open source databases: Sqlite | https://www.sqlite.org/ | ||||||||||||||||||||||
13 | Tools | Management | Data Management. Open source databases:SpatiaLite | https://www.gaia-gis.it/fossil/libspatialite/index | ||||||||||||||||||||||
14 | Tools | Sites, portals and paper | Global Value Exchange | https://www.gaia-gis.it/fossil/libspatialite/index | ||||||||||||||||||||||
15 | Tools | Sites, portals and paper | OS Open data | https://www.ordnancesurvey.co.uk/business-and-government/products/opendata-products.html | ||||||||||||||||||||||
16 | Tools | Sites, portals and paper | PublishMyData - disseminating on web; managing data collection | http://www.swirrl.com/ | ||||||||||||||||||||||
17 | Tools | Sites, portals and paper | ONS website | https://www.ons.gov.uk/ | ||||||||||||||||||||||
18 | Tools | Sites, portals and paper | London datastore | https://data.london.gov.uk/ | ||||||||||||||||||||||
19 | Tools | Sites, portals and paper | PublishMyData | http://www.swirrl.com/ | ||||||||||||||||||||||
20 | Tools | Sites, portals and paper | ONS Geographic Portal | http://geoportal.statistics.gov.uk/ | ||||||||||||||||||||||
21 | Tools | Analysis | Data protocols: OGC standards for data | http://www.opengeospatial.org/standards | ||||||||||||||||||||||
22 | Tools | Analysis | Data protocols: OGC protocols for delivery - WMS, WFS etc | http://www.opengeospatial.org/docs/is | ||||||||||||||||||||||
23 | Tools | Analysis | DFE: XML and collect | |||||||||||||||||||||||
24 | Tools | Conversion | In house: Received by SQL; Converter to Excel | |||||||||||||||||||||||
25 | Tools | Conversion | Data Baker - transforming XLS to structured CSV | https://github.com/sensiblecodeio/databaker | ||||||||||||||||||||||
26 | Tools | Conversion | Grafter (our own) software library for ETL - especially when creating RDF as output | https://github.com/Swirrl/grafter | ||||||||||||||||||||||
27 | Tools | Conversion | Grinder - table to RDF tool. Home made open source | https://github.com/cgutteridge/Grinder | ||||||||||||||||||||||
28 | Tools | Management | Hedgehog dataset publication workflow automation. Home made open source | |||||||||||||||||||||||
29 | Tools | Management | Open source portal / management dev tools - PHP | http://php.net/manual/en/intro-whatis.php | ||||||||||||||||||||||
30 | Tools | Management | Open source portal / management dev tools - Python | https://www.python.org/ | ||||||||||||||||||||||
31 | Tools | Management | Open source portal / management dev tools Node GoLang etc | https://github.com/DakshMiglani/node-golang | ||||||||||||||||||||||
32 | Tools | Management | Open source portal / management dev tools - Web tools and standards (W3C) | https://www.w3.org/standards/ | ||||||||||||||||||||||
33 | Tools | Conversion | GDAL - converting / processing geo data | http://www.gdal.org/ | ||||||||||||||||||||||
34 | Tools | Spreadsheets | Excel spreadsheets | https://products.office.com/en-gb/excel | ||||||||||||||||||||||
35 | Tools | Spreadsheets | Google Sheets | https://www.google.com/sheets/about/ | ||||||||||||||||||||||
36 | Tools | Spreadsheets | Excel spreadsheets | https://products.office.com/en-gb/excel | ||||||||||||||||||||||
37 | Tools | Spreadsheets | Data collection: Excel forms | https://support.office.com/en-gb/article/Simplify-data-entry-with-a-data-form-00bfc75e-f675-46ad-8703-291fc03e4d77 | ||||||||||||||||||||||
38 | Tools | Spreadsheets | Data collection: Web forms | |||||||||||||||||||||||
39 | Tools | Spreadsheets | Data collection: MarkLogic forms | https://github.com/marklogic-community/exampleforms | ||||||||||||||||||||||
40 | Tools | Spreadsheets | Spreadsheets LibreOffice | |||||||||||||||||||||||
41 | Tools | Spreadsheets | Spreadsheets | |||||||||||||||||||||||
42 | Tools | Spreadsheets | Partner Agencies: Excel | https://products.office.com/en-gb/excel | ||||||||||||||||||||||
43 | Tools | Sites, portals and paper | Sharepoint | https://products.office.com/en-us/sharepoint/collaboration | ||||||||||||||||||||||
44 | Tools | Spreadsheets | MS Excel | https://products.office.com/en-gb/excel | ||||||||||||||||||||||
45 | Tools | Sites, portals and paper | Sharepoint | https://products.office.com/en-us/sharepoint/collaboration | ||||||||||||||||||||||
46 | Tools | Sites, portals and paper | Sharepoint | https://products.office.com/en-us/sharepoint/collaboration | ||||||||||||||||||||||
47 | Tools | Management | Validation: does the data match the agreed structure | |||||||||||||||||||||||
48 | Tools | Management | Data publication: PublishMyData (Stardog) | http://www.stardog.com/ | ||||||||||||||||||||||
49 | Tools | Management | Data publication: Elastic Search | https://www.elastic.co/products/elasticsearch | ||||||||||||||||||||||
50 | Tools | Management | Data publication: Web page;Excel, CSV, PDF, Word doc | |||||||||||||||||||||||
51 | Tools | Management | Graph database (Stardog) - storing and querying data | http://www.stardog.com/ | ||||||||||||||||||||||
52 | Tools | Management | My PHP | http://php.net/my.php | ||||||||||||||||||||||
53 | Tools | Management | SAP Business Objects - web intelligence, dashboards, SAP Lumira | https://www.sap.com/uk/products/bi-platform.html | ||||||||||||||||||||||
54 | Tools | Management | SAP Lumira | https://saplumira.com/ | ||||||||||||||||||||||
55 | Tools | Conversion | SPSS | https://www.ibm.com/analytics/us/en/technology/spss/ | ||||||||||||||||||||||
56 | Tools | Conversion | Post Gre SQL | https://www.postgresql.org/ | ||||||||||||||||||||||
57 | Tools | Conversion | Toad for Oracle | https://www.quest.com/products/toad-for-oracle/ | ||||||||||||||||||||||
58 | Tools | Conversion | SQL Developer | http://www.oracle.com/technetwork/developer-tools/sql-developer/what-is-sqldev-093866.html | ||||||||||||||||||||||
59 | Tools | Conversion | Florence Bespoke CMS for ONS | https://github.com/ONSdigital/florence | ||||||||||||||||||||||
60 | Tools | Analysis | Data storage and analysis; Excel | https://products.office.com/en-gb/excel | ||||||||||||||||||||||
61 | Tools | Analysis | Data storage and analysis; SQL Server | https://www.microsoft.com/en-us/sql-server/sql-server-2016 | ||||||||||||||||||||||
62 | Tools | Analysis | Data storage and analysis; Access | https://products.office.com/en-gb/access | ||||||||||||||||||||||
63 | Tools | Analysis | Data storage and analysis; SPSS | https://www.ibm.com/analytics/us/en/technology/spss/ | ||||||||||||||||||||||
64 | Tools | Visualisation | Visualisation and mapping: OpenLayers | https://openlayers.org/ | ||||||||||||||||||||||
65 | Tools | Visualisation | Visualisation and mapping: Leaflet | http://leafletjs.com/ | ||||||||||||||||||||||
66 | Tools | Visualisation | Visualisation and mapping: OSM | https://www.openstreetmap.org/#map=6/54.910/-3.432 | ||||||||||||||||||||||
67 | Tools | Visualisation | Visualisation and mapping: Cesium | https://cesiumjs.org/ | ||||||||||||||||||||||
68 | Tools | Visualisation | Visualisation and mapping: Stats: R+ | https://www.r-project.org/ | ||||||||||||||||||||||
69 | Tools | Visualisation | Visualisation and mapping: Shiny | https://shiny.rstudio.com/gallery/ | ||||||||||||||||||||||
70 | Tools | Visualisation | Visualisation and mapping: D3 | https://d3js.org/ | ||||||||||||||||||||||
71 | Tools | Visualisation | Stats: R+ | https://www.r-project.org/ | ||||||||||||||||||||||
72 | Tools | Visualisation | Stats: Shiny | https://shiny.rstudio.com/ | ||||||||||||||||||||||
73 | Tools | Visualisation | Stats: D3 | https://d3js.org/ | ||||||||||||||||||||||
74 | Tools | Sites, portals and paper | Social media channels: Twitter | https://twitter.com/ | ||||||||||||||||||||||
75 | Tools | Sites, portals and paper | Social media channels: Facebook | https://www.facebook.com | ||||||||||||||||||||||
76 | Tools | Sites, portals and paper | Social media channels: blogs | |||||||||||||||||||||||
77 | Tools | Visualisation | Minecraft | https://minecraft.net/en-us/?ref=m | ||||||||||||||||||||||
78 | Tools | Visualisation | QGIS | http://www.qgis.org/en/site/ | ||||||||||||||||||||||
79 | Tools | Visualisation | D3 (and other JS libraries) Viz | https://d3js.org/ | ||||||||||||||||||||||
80 | Tools | Visualisation | Google Maps - simple geographical visualisation | https://www.google.co.uk/maps/ | ||||||||||||||||||||||
81 | Tools | Visualisation | OpenStreetMap - simple geographical visualisation | https://www.openstreetmap.org/#map=6/54.910/-3.432 | ||||||||||||||||||||||
82 | Tools | Analysis | R - checking and analysing data | https://www.r-project.org/ | ||||||||||||||||||||||
83 | Tools | Visualisation | High charts | https://www.highcharts.com/ | ||||||||||||||||||||||
84 | Tools | Visualisation | ESRI | https://www.esri.com/en-us/home | ||||||||||||||||||||||
85 | Tools | Visualisation | PostGIS | http://postgis.net/ | ||||||||||||||||||||||
86 | Tools | Visualisation | PostGRES | https://www.postgresql.org/ | ||||||||||||||||||||||
87 | Tools | Visualisation | Geoserver | http://geoserver.org/ | ||||||||||||||||||||||
88 | Tools | Visualisation | R Shiny - visualising data | https://shiny.rstudio.com/ | ||||||||||||||||||||||
89 | Tools | Visualisation | ESRI | https://www.esri.com/en-us/home | ||||||||||||||||||||||
90 | Tools | Visualisation | D3 for data visualisations | https://d3js.org/ | ||||||||||||||||||||||
91 | Tools | Sites, portals and paper | Cloud servers Google Cloud running online services | https://cloud.google.com/ | ||||||||||||||||||||||
92 | Tools | Sites, portals and paper | Cloud servers AWS running online services | https://aws.amazon.com/ | ||||||||||||||||||||||
93 | Tools | Visualisation | Leaflet.js library for visualising map and Geo data | http://leafletjs.com/ | ||||||||||||||||||||||
94 | Pains | Conversion | Graphite PHP, RDF Lib; homemade; Open source | |||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 |