Published
Edited
Oct 26, 2021
raw_2017 = d3.csv("https://s3.eu-west-1.amazonaws.com/data.ixmaps.com/Crime/Italy/INT00062_Delitti_denunciati__-_dati_anno_2017_-_dati_Provinciali.csv")
Inputs.Table(raw_2017)
process_data = function(raw_data){
var data = Data.import({"source":raw_data,"type":"json"});
// aggiunge colonna con il l'incidenza (valore per 100.000)
var provinciaIndex = data.column("Provincia").index;
var valueIndex = data.column("TOT DELITTI COMMESSI").index;
data.addColumn({destination:"INCIDENCE"},function(row){
return (row[valueIndex]/pA[row[provinciaIndex]]*100000);
});
// crea tabella pivot con una colonna per reato
var pivot = data.pivot({
"lead":"Provincia",
"columns": "REATO",
"value": "INCIDENCE",
"keep": ["ANNO"]
});
// alcuni nomi delle Province devono essere cambiate per essere compatibile con i confini da ISTAT
corrNames(pivot);
return pivot;
}
delitti_2017 = process_data(raw_2017);
Inputs.Table(delitti_2017.json())
raw_2018 = d3.csv("https://s3.eu-west-1.amazonaws.com/data.ixmaps.com/Crime/Italy/INT00062_Delitti_denunciati__-_dati_anno_2018_-_dati_Provinciali.csv")
delitti_2018 = process_data(raw_2018);
raw_2019 = d3.dsv(',',"https://s3.eu-west-1.amazonaws.com/data.ixmaps.com/Crime/Italy/INT00062_Delitti_denunciati__-_dati_anno_2019_-_dati_Provinciali.csv")
delitti_2019 = process_data_2019(raw_2019);
merger = new Data.Merger();
final = merger
.addSource(delitti_2017, {
lookup: "Provincia",
columns: ["Provincia",filter.codice],
label: ["Provincia","TOTALE_DELITTI_2017"]
})
.addSource(delitti_2018, {
lookup: "Provincia",
columns: ["Provincia",filter.codice],
label: ["Provincia","TOTALE_DELITTI_2018"]
})
.addSource(delitti_2019, {
lookup: "Provincia",
columns: ["Provincia",filter.codice],
label: ["Provincia","TOTALE_DELITTI_2019"]
})
.realize();
Inputs.Table(final.json())
province = d3.json("https://s3.eu-central-1.amazonaws.com/maps.ixmaps.com/Istat/province_2019/Province_s.geojson.gz")
georef = () => {
return {
"layer": "Prov2019_name",
"field": "$item$",
"field100": "",
"style": {
"type": "FEATURES|NOLEGEND|LOCKED",
"colorscheme": [
"none"],
"linecolor":"none",
"dbtable": "PROVINCE",
"itemfield": "DEN_UTS",
"lookupfield": "geometry",
"title": "Italy Province 2019"
}
}
};
delitti = {
var reg = [];
var columnsA = delitti_2017.columnNames();
reg.push({name: columnsA[columnsA.length-2], codice: columnsA[columnsA.length-2]});
for( var c =2; c < columnsA.length-2; c++ ){
reg.push({name: columnsA[c], codice: columnsA[c]});
}
return reg;
}
p = d3.csv("https://s3.eu-west-1.amazonaws.com/data.ixmaps.com/ISTAT/DCIS_POPRES_Province_2019.csv")
Inputs.Table(p)
pA = Data.import({"source":p,"type":"json"
}).lookupArray("Value","Territorio");
pA["Aosta"] = pA["Valle d'Aosta / Vallée d'Aoste"]
pA["Bolzano"] = pA["Provincia Autonoma Bolzano / Bozen"]
pA["Trento"] = pA["Provincia Autonoma Trento"]
pA["Forli'-Cesena"] = pA["Forlì-Cesena"]
process_data_2019 = function(raw_data){
var data = Data.import({"source":raw_data,"type":"json"});
corrNames(data);
var provinciaIndex = data.column("Provincia").index;
var valueIndex = data.column("Totale Delitti commesi").index;
data.addColumn({destination:"INCIDENCE"},function(row){
return (row[valueIndex]/pA[row[provinciaIndex]]*100000);
});
var pivot = data.pivot({
"lead":"Provincia",
"columns": "Reato",
"value": "INCIDENCE",
"keep": ["ANNO"]
});
return pivot;
}
corrNames = function (data){
data.column("Provincia").map(function(value){
if (value == "Forli' - Cesena"){
return "Forli'-Cesena";
}
if (value == "Pesaro - Urbino"){
return "Pesaro e Urbino";
}
if (value == "Reggio Emilia"){
return "Reggio nell'Emilia";
}
if (value == "Reggio Calabria"){
return "Reggio di Calabria";
}
return value;
});
return data;
}
ixmaps = require('https://gjrichter.github.io/ixmaps/ui/js/htmlgui_api.js')
Data = require('https://gjrichter.github.io/data.js/data.js')
Inputs = require("@observablehq/inputs@0.7.21/dist/inputs.umd.min.js")
$ = require('https://code.jquery.com/jquery-3.3.1.min.js')
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.
