Tags » Data 2

Say it with flowers - bringing open data to a new audience (hopefully)

When we set the Innovation and Intelligence Lab up, we were very keen that we would be totally open about what we’re doing. Blogging as we go along, getting stuff out early on in the development process, and capturing all the decisions we were making so that we, and others, can learn from what goes well, and what doesn’t. 855 more words

Data

Data is...

When considering evidence and artifacts for our own growth and for evaluation, it is wise to broaden our understanding of “data”. Numbers do not tell the whole story. 36 more words

Learning

What Hasan Elahi's project, Tracking Transience, can tell us about the commercial use of tracking technologies.

Originally written Spring 2013, at SUNY Purchase. 

Hassan Elahi is an artist and professor who begun tracking himself in 2002. His project Tracking Transience is concerned with exposing the mundane in his life in order to make that information meaningless. 2,514 more words

Technology

Plotting with the Highcharts.js API

<script src="http://code.highcharts.com/highcharts.js"></script>
<script src="http://code.highcharts.com/modules/exporting.js"></script>
<div id="container" style="min-width: 310px; max-width: 800px; height: 1200px; margin: 0 auto"></div>

$(function () {
        $('#container').highcharts({
            chart: {
                type: 'bar'
            },
            title: {
                text: ''
            },
            subtitle: {
                text: 'Source: Reuters Institute Digital News Report 2014'
            },
            xAxis: {
                categories: ['USA', 'UK', 'Germany', 'France', 'Denmark', 'Finland', 'Spain', 'Italy', 'Brazil', 'Japan'],
                title: {
                    text: null
                }
            },
            yAxis: {
                min: 0,
                title: {
                    text: 'Percent of surveyed sample',
                    align: 'high'
                },
                labels: {
                    overflow: 'justify'
                }
            },
            tooltip: {
                valueSuffix: '%'
            },
            plotOptions: {
                bar: {
                    dataLabels: {
                        enabled: true
                    }
                }
            },
            legend: {
                layout: 'vertical',
                align: 'right',
                verticalAlign: 'top',
                x: -40,
                y: 100,
                floating: true,
                borderWidth: 1,
                backgroundColor: (Highcharts.theme && Highcharts.theme.legendBackgroundColor || '#FFFFFF'),
                shadow: true
            },
            credits: {
                enabled: false
            },
            series: [{
                name: 'Lists/Stories',
                data: 
            }, {
                name: 'Video/Audio',
                data: 
            }, {
                name: 'Live pages',
                data: 
            }, {
                name: 'Pictures/Graphics',
                data: 
            }]
        });
    });

Full output here. Preview:

Visualization

Plotting with the plot.ly API

var data = [{"name":"Gaseous fuel","type":"scatter","fill":"tonexty","mode":"lines","xsrc":"isnerd:1:0I4LU2RD2QVQRQS0Q35GU4N1D97CL8EI","ysrc":"isnerd:1:MG6030IZ7H4OZ5WH8Z0BZNN9E4MEJMIT","uid":"cbaea7","line":{"shape":"linear"},"marker":{"line":{}},"textfont":{},"error_y":{"visible":true,"type":"percent","array":,"traceref":"0","symmetric":true},"error_x":{},"connectgaps":false,"autobinx":true,"autobiny":true,"colorbar":{},"xbins":{"start":1949.5,"end":2019.5,"size":10},"ybins":{"start":-40000,"end":120000,"size":20000},"zmin":0,"zmax":20,"contours":{"start":2,"size":2,"end":18.02}},{"name":"Liquid fuel","type":"scatter","fill":"tonexty","mode":"lines","xsrc":"isnerd:1:0I4LU2RD2QVQRQS0Q35GU4N1D97CL8EI","ysrc":"isnerd:1:QRC9D8VKPOBSQ7TRFE4ZYM9KO7VJZQP5","uid":"092b82","line":{},"marker":{"line":{}},"textfont":{},"error_y":{"visible":true,"array":,"type":"percent","traceref":"1"},"error_x":{},"autobinx":true,"autobiny":true,"colorbar":{},"xbins":{"start":1919.5,"end":2039.5,"size":20},"ybins":{"start":-100000,"end":600000,"size":100000},"zmin":0,"zmax":20,"contours":{"start":2,"size":2,"end":18.02}},{"name":"Solid fuel","type":"scatter","fill":"tonexty","mode":"lines","xsrc":"isnerd:1:0I4LU2RD2QVQRQS0Q35GU4N1D97CL8EI","ysrc":"isnerd:1:HIWFG08N46UFGKAQD6T2PUCS3YVCK31J","uid":"665793","line":{},"marker":{"line":{}},"textfont":{},"error_y":{"visible":true,"array":,"type":"percent","traceref":"2"},"error_x":{},"autobinx":true,"autobiny":true,"colorbar":{},"xbins":{"start":1919.5,"end":2039.5,"size":20},"ybins":{"start":-500000,"end":2000000,"size":500000},"zmin":0,"zmax":20,"contours":{"start":2,"size":2,"end":18.02}}];
var layout = {"title":"CO2 emissions from consumption of fuel types (with error)","xaxis":{"range":,"type":"linear","showline":false,"mirror":false,"linecolor":"#444","linewidth":1,"tick0":0,"dtick":10,"ticks":"","ticklen":5,"tickwidth":1,"tickcolor":"#444","nticks":0,"showticklabels":true,"tickangle":"auto","exponentformat":"SI","showexponent":"all","showgrid":true,"gridcolor":"#eee","gridwidth":1,"autorange":true,"rangemode":"normal","autotick":true,"zeroline":true,"zerolinecolor":"#444","zerolinewidth":1,"titlefont":{"family":"Droid Sans, sans-serif","size":0,"color":""},"tickfont":{"family":"Droid Sans, sans-serif","size":0,"color":""},"overlaying":false,"domain":,"position":0,"anchor":"y","title":"Year"},"yaxis":{"range":[-81795.59269444444,1554116.2611944443],"type":"linear","showline":false,"mirror":false,"linecolor":"#444","linewidth":1,"tick0":0,"dtick":500000,"ticks":"","ticklen":5,"tickwidth":1,"tickcolor":"#444","nticks":0,"showticklabels":true,"tickangle":"auto","exponentformat":"SI","showexponent":"all","showgrid":true,"gridcolor":"#eee","gridwidth":1,"autorange":true,"rangemode":"normal","autotick":true,"zeroline":true,"zerolinecolor":"#444","zerolinewidth":1,"titlefont":{"family":"Droid Sans, sans-serif","size":0,"color":""},"tickfont":{"family":"Droid Sans, sans-serif","size":0,"color":""},"overlaying":false,"domain":,"position":0,"anchor":"x","title":"CO2 emissions in kilo-tonnes"},"legend":{"bgcolor":"#fff","bordercolor":"#444","borderwidth":0,"font":{"family":"Droid Sans, sans-serif","size":0,"color":""},"traceorder":"reversed","xanchor":"left","yanchor":"top","x":1.02,"y":1},"width":1214,"height":404,"autosize":true,"margin":{"l":80,"r":80,"t":100,"b":80,"pad":2,"autoexpand":true},"paper_bgcolor":"#fff","plot_bgcolor":"rgb(217, 217, 217)","barmode":"overlay","bargap":0.2,"bargroupgap":0,"boxmode":"overlay","boxgap":0.3,"boxgroupgap":0.3,"font":{"family":"Droid Sans, sans-serif","size":12,"color":"#444"},"titlefont":{"family":"","size":0,"color":""},"dragmode":"zoom","hovermode":"x","separators":".,","hidesources":false,"smith":false,"showlegend":true};
Plotly.plot(Tabs.get(), data, layout); 

Output (non-interactive version):

Visualization

Eliminate your duplicate data row problems with simple SQL

We’ve all faced this problem: Duplicate rows in our data. It messes up our reports and causes general confusion and consternation for people we supply¬†data to. 867 more words

Data

The final frontier (part 3 of the Dynamic Tiling saga)

Previously I spoke about the Dynamic Tile Service and how it creates tile images in real-time; its ability to easily create custom styles and colours for maps; and, its ability to tile point and polygon data sets. 416 more words

Data