2e:null 2f:["$","title",null,{"children":"FAOSTAT: Components of the bulk-file | wolfiex | Observable"}] 34:T416,chart = { const svg = d3.select(DOM.svg(width, height)); svg.append("g") .call(xAxis); svg.append("g") .call(yAxis); svg.append("g") .attr("stroke-width", 1.5) .attr("fill", "none") .selectAll("circle") .data(data) .join("circle") .attr("stroke", d=> d3.interpolateViridis(c(parseInt(d.FileRows)))) .attr("fill", d=> d3.interpolateViridis(c(parseInt(d.FileRows)))) .attr("fill-opacity",.3) .attr("cx", d => x(parseTime(d.DateUpdate))) .attr("cy", d => y(parseInt(d.FileRows))) .attr("r", d => z(parseInt(d.FileRows))) .on('mouseover',d=>{document.getElementById('name').innerHTML= d.DatasetName; document.getElementById('description').innerHTML= d.DatasetDescription; document.getElementById('dump').innerHTML= JSON.stringify(d , undefined, 2)//.replace(',',',
.
'); console.log(d)}) .on('click', function(d) { window.open(d.FileLocation, '_blank' ); }); return svg.node(); }35:[] 32:{"id":"59fd74737bd05649","slug":"components-of-the-bulk-download-from-the-foastat-page","title":"FAOSTAT: Components of the bulk-file","thumbnail":"a4ffc08e142064feb9c3f711a3f6fab17c55608b5e1e61e3356fffe2d6b92cb7","access_level":"public","create_time":"$D2019-05-14T16:50:26.017Z","update_time":"$D2019-05-20T11:09:37.364Z","view_time":null,"first_public_time":"$D2019-05-14T18:31:37.994Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"5ac3a182adb31463","login":"wolfiex","name":"","avatar_url":"https://avatars-next.observableusercontent.com/920ad9da2e8dc46272a1a9d71eb3bddb5e1daea20ee8a2ee301b59af578ad9af","tier":"starter_2024"},"version":289,"publish_version":289,"role":null,"authored":false,"authors":[{"type":"individual","id":"3e68e1c0f733af7c","login":"wolfiex","name":"","avatar_url":"https://avatars-next.observableusercontent.com/920ad9da2e8dc46272a1a9d71eb3bddb5e1daea20ee8a2ee301b59af578ad9af","tier":null}],"members":[{"type":"individual","id":"3e68e1c0f733af7c","login":"wolfiex","name":"","avatar_url":"https://avatars-next.observableusercontent.com/920ad9da2e8dc46272a1a9d71eb3bddb5e1daea20ee8a2ee301b59af578ad9af","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"FAOSTAT: Components of the bulk-file","cells":[{"id":0,"value":"md`# FAOSTAT: Components of the bulk-file\nHidden away there exists a json file containing links and metadata about each item within this dataset.\nThese are plotted with *y = No lines* and *x = date last updated*\n (Node size represents linelength, and thus filesize). \n\n#### Location\nhttp://fenixservices.fao.org/faostat/static/bulkdownloads/datasets_E.json\n\n#### Hover \nTo see the item name.\n#### Click \nTo download the zipped csv file.\n\nAim - need a format of how these are best suited for SEI needs.\n\n## Results\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":137,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":267,"value":"html`

Dataset:

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":263,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":255,"value":"md`#### Just program stuff here...\n\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":87,"value":"x = d3.scaleTime()\n .domain(d3.extent(data, d =>parseTime(d.DateUpdate)))\n .range([margin.left, width - margin.right])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"y = d3.scaleLog()\n .domain([Math.min(...data.map(d=>parseInt(d.FileRows))),d3.max(data, d => parseInt(d.FileRows))]).nice()\n .range([height - margin.bottom, margin.top])\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":92,"value":"xAxis = g => g\n .attr(\"transform\", `translate(0,${height - margin.bottom})`)\n .call(d3.axisBottom(x).ticks(width / 80).tickSizeOuter(0))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":151,"value":"yAxis = g => g\n .attr(\"transform\", `translate(${margin.left},0)`)\n .call(d3.axisLeft(y).ticks(width / 80).tickSizeOuter(0))\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"z = d3.scaleLog()\n .domain(d3.extent(data.map(d=>parseInt(d.FileSize.replace('kB',''))))).nice()\n .range([1,10])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":211,"value":"c = d3.scaleLog()\n .domain(d3.extent(data.map(d=>parseInt(d.FileRows)))).nice()\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":95,"value":"parseTime = d3.timeParse(\"%Y-%m-%d\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"function timeFormat(x){\n let splits = (x).split('T');\n let newDate = parseTime(splits[0])\n return newDate;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"value":"margin = ({top: 20, right: 30, bottom: 30, left: 40})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":101,"value":"d3format = require(\"d3-format\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"impdata = d3.json('https://raw.githubusercontent.com/wolfiex/FAO_data/master/bulksave.json',)//\"http://fenixservices.fao.org/faostat/static/bulkdownloads/datasets_E.jso\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":72,"value":"data = impdata.Datasets.Dataset.filter(d=>parseTime(d.DateUpdate)>new Date('2001')).filter(d=>parseInt(d.FileRows)>100)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"d3 = require(\"d3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"height = 600","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 33:"$32:body"