draws. codes. travels. makes. eth architecture graduate. Working on making geo data more accessible @cividi
Published
Edited
Apr 1, 2021
air_raw = d3
.json(
`https://data.stadt-zuerich.ch/api/3/action/datastore_search?resource_id=4466ec4a-b215-4134-8973-2f360e53c33d&sort=Datum%20desc&limit=32000&filters={%22Standort%22:%22${air_sensor}%22}`
)
.then(function(r) {
r.result.records.forEach(function(d) {
d.date = dateParser(d.Datum);
d.value = +d.Wert;
d.unit = d.Einheit;
});
return r.result.records;
})
air_sums = d3.rollup(
air_raw,
v => d3.mean(v, d => d.value),
d => d.Parameter,
d => dateWithoutTime(d.date)
)
velo = d3.json(`https://data.stadt-zuerich.ch/api/3/action/datastore_search?resource_id=ebe5e78c-a99f-4607-bedc-051f33d75318&sort=DATUM%20desc&filters={%22FK_STANDORT%22:%22${bike_sensor}%22}&limit=32000`).then( function(r) {
r.result.records.forEach(function(d) {
d.date = dateParser2(d.DATUM);
d.value = +d['VELO_IN'] + +d['VELO_OUT'];
d.unit = 'Velos';
});
return r.result.records
})
fuss = d3.json(`https://data.stadt-zuerich.ch/api/3/action/datastore_search?resource_id=ebe5e78c-a99f-4607-bedc-051f33d75318&sort=DATUM%20desc&filters={%22FK_STANDORT%22:%22${people_sensor}%22}&limit=32000`).then( function(r) {
r.result.records.forEach(function(d) {
d.date = dateParser2(d.DATUM);
d.value = +d['FUSS_IN'] + +d['FUSS_OUT'];
d.unit = 'Personen';
});
return r.result.records
})
dateParser = d3.timeParse("%Y-%m-%dT%H:%M%Z");
dateParser2 = d3.timeParse("%Y-%m-%dT%H:%M");
dateParser2("2021-01-01T02:30")
f = d3.formatLocale(".","'");
locale = d3.formatLocale({
decimal: ".",
thousands: "'",
grouping: [3],
currency: ["", "\u00a0CHF"],
})
fformat = locale.format(",.4r")
fformat(1564)
lookup = function(array,parameter,key) {
return array.filter(d => d.Parameter === parameter)[0][key]
}
countSum = function(array,valueKey){
return fformat(array.map(d => d[valueKey]).reduce((accumulator, currentValue) => accumulator + currentValue))
}
[ ...d3.rollup(velo, v => d3.sum(v, d => d.value), d => dateWithoutTime(d.date)).values() ]
d3.rollup(fuss, v => d3.sum(v, d => d.value), d => dateWithoutTime(d.date))
groupedDayAverage = function(array){
let sums = [ ...d3.rollup(array, v => d3.sum(v, d => d.value), d => dateWithoutTime(d.date)).values() ]
return fformat(sums.reduce((total, val) => total + val) / sums.length)
}
dateWithoutTime = function(d){
return new Date(d.getFullYear(),d.getMonth(), d.getDate())
}
tformatter = d3.timeFormat('%d.%m. %H:%M')
tformatter_short = d3.timeFormat('%d.%m.')
d3 = require("d3", "d3-array")
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
