2a:null 2b:["$","title",null,{"children":"Charlottesville ADU Data | Rory Stolzenberg | Observable"}] 30:T18cb,plot = { var residentialUses = ["Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion", "Single Family Attached", "Duplex", "Triplex", "Quadplex", "Three-Level Split", "Four-Level Split", "Condominium", "Apartments"]; //var data = _.clone(filter.parcels.features); var data = _.clone(adu_totals.nonconforming_adus); data = data.filter(function(d){ var sqft = getSqft(d); var acreage = turf.area(d)/4046.86; return d.properties.Residential === true && residentialUses.indexOf(getUseCode(d)) !== -1 && //sqft>= 1000 && sqft <= 1600 public_spaces.indexOf(d.properties.ParcelNumber) === -1 && commercial.indexOf(d.properties.ParcelNumber) === -1 && d.properties.UseCode != "Vacant Land" && //d.properties.ResidentialDetails.YearBuilt != "0" && //d.properties.SquareFootageFinishedLiving > 6500 && //getYearBuilt(d) >= 2000 && //acreage < .4 && acreage > .3 && true//["Single Family", "Single Family + ADU(s)"].indexOf(getUseCode(d,true, true)) !== -1; }); var axes = AXES(data) if(COLOR_KEY == 'UseCode'){ var sortNum = function(use){ switch(use){ case "Single Family" : return 1; case "Single Family-1 Conversion" : return 1.1; case "Single Family-2 Conversion" : return 1.2; case "Single Family-3 Conversion" : return 1.3; case "Single Family Attached" : return 2; case "Duplex" : return 2.1; case "Triplex" : return 3; case "Quadplex" : return 4; case "Apartments" : return 5; case "Condominium" : return 6; default: return 7 } } /*var uses = _.uniq(data.map(d => getUseCode(d, true))).sort(function(a, b){ return sortNum(a) - sortNum(b) }) for(var x in uses){ axes[COLOR_KEY].fillColor({properties: {UseCode: uses[x]}}) }*/ //data = _.sortBy(data, d => sortNum(getUseCode(d, true))) } console.log(axes[COLOR_KEY].color.domain()) console.log(data); var margin = {top: 40, right: 20, bottom: 40, left: 60}, wi = width - margin.left - margin.right, height = Math.round(width*2/3) - margin.top - margin.bottom; const svgWrapper = d3.select(DOM.svg(wi + margin.left + margin.right, height + margin.top + margin.bottom)) .attr("width", wi + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom) .style("background-color", BACKGROUND_COLOR) .style("font-family", "Arial") .style("color", TEXT_COLOR) var svg = svgWrapper.append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")") var x = d3.scaleLinear() .range([0, wi]); var y = d3.scaleLinear() .range([height, 0]); var xAxis = d3.axisBottom(x).tickFormat(d3.format("d")); var yAxis = d3.axisLeft(y).tickFormat(axes[Y_AXIS].tickFormat); var getX = getYearBuilt; var getY = axes[Y_AXIS].fnLimited; x.domain(d3.extent(data, getX)); //x.domain([1969, 1972]); var ydomain = y.domain(d3.extent(data, getY)); if(axes[Y_AXIS].nice) ydomain.nice(); // x-axis svg.append("g") .attr("class", "x axis") .attr("transform", "translate(0," + height + ")") .style("font-size", ".8em") .style("font-weight", "bold") .call(xAxis) .append("text") .attr("class", "label") .attr("x", wi) .attr("y", -6) .style("fill", TEXT_COLOR) .style("text-anchor", "end") .text("Year Built"); // y-axis svg.append("g") .attr("class", "y axis") .style("font-size", ".8em") .style("font-weight", "bold") .call(yAxis) .append("text") .attr("class", "label") .attr("transform", "rotate(-90)") .attr("y", 6) .attr("dy", ".71em") .style("fill", TEXT_COLOR) .style("text-anchor", "end") .text(axes[Y_AXIS].name); addMedianLine(svg, data, x, y, getX, axes[Y_AXIS].fn, axes[Y_AXIS].format, wi, height) addMeanLine(svg, data, x, y, getX, axes[Y_AXIS].fn, axes[Y_AXIS].format, wi, height) // draw dots svg.selectAll(".dot") .data(data) .enter().append("circle") .attr("class", "dot") .attr("r", axes[Y_AXIS].dotSize) .attr("cx", function(d) { return x(getX(d)); }) .attr("cy", function(d) { return y(getY(d)); }) .style("fill", axes[COLOR_KEY].fillColor) .style('stroke', "#888") .style('stroke-width', ".2px") //.style("z-index", d => sortNum(getUseCode(d, true))*10) .on("mouseover", function(d){ d3.select(this).attr("r", axes[Y_AXIS].dotSize*2).style('stroke', "#D62728").style('stroke-width', "1px") plot_tooltip.style("visibility", "visible").html(tooltipString(d,LATEST_YEAR)) }) .on("mousemove", onMousemove(plot_tooltip)) .on("mouseout", function(d){ d3.select(this).attr("r", axes[Y_AXIS].dotSize).style('stroke', "#888").style('stroke-width', ".2px"); plot_tooltip.style("visibility", "hidden"); }) var legend = svg.selectAll(".legend") .data(axes[COLOR_KEY].color.domain()) .enter().append("g") .attr("class", "legend") .attr("transform", function(d, i) { return "translate(" + axes[Y_AXIS].legendOffsetX + "," + (i * 20 - margin.top/2) + ")"; }); legend.append("rect") .attr("x", wi - 18) .attr("width", 18) .attr("height", 18) .style("fill", axes[COLOR_KEY].color); legend.append("text") .attr("x", wi - 24) .attr("y", 9) .attr("dy", ".35em") .style("text-anchor", "end") .style("fill", TEXT_COLOR) .text(function(d) { return axes[COLOR_KEY].legendFormat(d); }); svg.append("text") .attr("x", (wi / 2)) .attr("y", 0 - (margin.top / 2)) .attr("text-anchor", "middle") .style("font-size", "18px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text("Homes in Charlottesville"); return svgWrapper.node(); }31:T14b5,use_map = { var COLOR_KEY = 'UseCode'; var data = _.clone(filter.parcels.features); // data = data.filter(function(d){ // return public_spaces.indexOf(d.properties.ParcelNumber) === -1 && //commercial.indexOf(d.properties.ParcelNumber) === -1 && // typeof getUseCode(d, true) !== 'undefined' && // d.properties.UseCode.indexOf("Conversion") !== -1 && // ADU_PROHIBITED_ZONES.indexOf(zone_strip_historic(d.properties.Zoning)) !== -1 // (d.properties.Residential === true || // (d.properties.Commercial === true && getUseCode(d, true).indexOf("Apartments") !== -1) // ) && // d.properties.UseCode.indexOf("Vacant") === -1 && // d.properties.UseCode.indexOf("Hospital") === -1 && // d.properties.UseCode.indexOf("Medical") === -1 && // d.properties.UseCode.indexOf("Club") === -1 && // d.properties.UseCode.indexOf("Office") === -1 && // d.properties.UseCode.indexOf("Hotel") === -1 && // d.properties.UseCode.indexOf("Garage") === -1 && // d.properties.UseCode.indexOf("Church") === -1 && // d.properties.UseCode.indexOf("Bank") === -1 && // d.properties.UseCode !== "Retail" && // d.properties.UseCode !== "Retail Store" && // d.properties.UseCode.indexOf("Fire Station") === -1 && // d.properties.UseCode.indexOf("Elem") === -1 && // d.properties.UseCode.indexOf("Warehouse") === -1 && // d.properties.UseCode.indexOf("Restaurant") === -1 && // d.properties.UseCode.indexOf("Industrial") === -1 && // d.properties.UseCode.indexOf("Market") === -1 && // d.properties.UseCode.indexOf("Common") === -1 && // d.properties.UseCode.indexOf("Commercial") === -1 && // d.properties.UseCode.indexOf("College") === -1 && // d.properties.UseCode.indexOf("Parking") === -1 //&& //d.properties.ResidentialDetails.YearBuilt != "0"; // }); console.log(_.uniq(data.map(d=>d.properties.Zoning).map(zone_strip_historic)).sort()) console.log("non-conforming: "+data.length) console.log("non-conforming 1s: ", data.filter(d=>d.properties.UseCode == "Single Family-1 Conversion").length) console.log("non-conforming 2s: ", data.filter(d=>d.properties.UseCode == "Single Family-2 Conversion").length, data.filter(d=>d.properties.UseCode == "Single Family-2 Conversion").length * 2) console.log("non-conforming 3s: ", data.filter(d=>d.properties.UseCode == "Single Family-3 Conversion").length, data.filter(d=>d.properties.UseCode == "Single Family-3 Conversion").length * 3) var axes = AXES(data) const height = 1 * width; console.log(width,height); const svg = d3.select(DOM.svg(width, height)) .style("font-family", "Arial") .style("fill", BACKGROUND_COLOR); let projection = d3.geoAlbers(); const path = d3.geoPath().projection( projection ) const graticule = d3.geoGraticule() projection .scale(1) .translate([0, 0]); const b = path.bounds(filter.parcels); const s = 0.95 / Math.max((b[1][0] - b[0][0]) / width, (b[1][1] - b[0][1]) / height); const t = [(width - s * (b[1][0] + b[0][0])) / 2, (height - s * (b[1][1] + b[0][1])) / 2]; projection .scale(s) .translate(t) svg.append("path") .datum(graticule) .attr("class", "graticule") .attr("d", path); svg.append("g") .selectAll("path") .data(data) .enter().append("path") .attr("d", path) .style('fill', function(d){ var code = getUseCode(d,true); switch(code){ case "Vacant Land": return "#aaa" case "Cemetery": return "#999" case "Apartments 1-10 units": code = "Apartments" case "Apartments 11-20 Units": code = "Apartments" case "Apartments over 20 units": code = "Apartments" case "Mixed Retail w/Res Units": code = "Mixed Use Apartments & Retail" default: return axes[COLOR_KEY].color(code) } }) //.style('stroke', TEXT_COLOR) //.style('stroke-width', ".2px") .on("mouseover", d => { usemap_tooltip.style("visibility", "visible").html(tooltipString(d,LATEST_YEAR))}) .on("mousemove", onMousemove(usemap_tooltip)) .on("mouseout", d => usemap_tooltip.style("visibility", "hidden")); var fontSize = Math.floor(height/60); var legend = svg.selectAll(".legend") .data(axes[COLOR_KEY].color.domain()) .enter().append("g") .attr("class", "legend") .attr("transform", function(d, i) { return "translate(" + axes[COLOR_KEY].legendOffsetX + "," + (i * height/44 + 16) + ")"; }); legend.append("rect") .attr("x", width - height/50) .attr("width", height/50) .attr("height", height/50) .style("fill", axes[COLOR_KEY].color); legend.append("text") .attr("x", width - width/40) .attr("y", fontSize) .style("text-anchor", "end") .style("fill", TEXT_COLOR) .style("font-size", fontSize+"px") .text(function(d) { return axes[COLOR_KEY].legendFormat(d);}); svg.append("text") .attr("x", width/5) .attr("y", 80) .attr("text-anchor", "middle") .style("font-size", "30px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text("Properties by use"); return svg.node(); }32:T4f8,adu_totals = { var data = _.clone(filter.parcels.features); var adus = data.filter(d => { return typeof getUseCode(d, true) !== 'undefined' && d.properties.UseCode.indexOf("Conversion") !== -1 }) console.log('len',adus.length) console.log(_.uniq(adus.map(d=>d.properties.Zoning).map(zone_strip_historic)).sort()) var unknown_adus = adus.filter(d=>['PUD','MLTP'].indexOf(zone_strip_historic(d.properties.Zoning)) !== -1) var legal_adus = adus.filter(d=>ADU_PERMITTED_ZONES.indexOf(zone_strip_historic(d.properties.Zoning)) !== -1) var nonconforming_adus = adus.filter(d=>ADU_PROHIBITED_ZONES.indexOf(zone_strip_historic(d.properties.Zoning)) !== -1) console.log("unknown adus",_.uniq(legal_adus.map(d=>d.properties.Zoning).map(zone_strip_historic)).sort()) console.log("legal adus",_.uniq(legal_adus.map(d=>d.properties.Zoning).map(zone_strip_historic)).sort()) console.log("nonconform adus",_.uniq(nonconforming_adus.map(d=>d.properties.Zoning).map(zone_strip_historic)).sort()) return { legal_adus_len: legal_adus.length, nonconforming_adus_len: nonconforming_adus.length, unknown_adus_len: unknown_adus.length, legal_adus: legal_adus, nonconforming_adus: nonconforming_adus, unknown_adus: unknown_adus, } }33:T4af,filter = { //if(CACHE) // return d3.json(FILTER_CACHE_URL); var results = { parcels: _.clone(parcels), assessments: _.clone(assessments), residential_data: _.clone(residential_data), commercial_data: _.clone(commercial_data), base_data: _.clone(base_data), } iterate(results); var adus = results.parcels.features.filter(function(d){ return typeof getUseCode(d, true) !== 'undefined' && d.properties.UseCode.indexOf("Conversion") !== -1 }) var unknown_adus = adus.filter(d=>['PUD','MLTP'].indexOf(zone_strip_historic(d.properties.Zoning)) !== -1) var legal_adus = adus.filter(d=>ADU_PERMITTED_ZONES.indexOf(zone_strip_historic(d.properties.Zoning)) !== -1) var nonconforming_adus = adus.filter(d=>ADU_PROHIBITED_ZONES.indexOf(zone_strip_historic(d.properties.Zoning)) !== -1) switch(WHICH_ADUS){ case 'all': results.parcels.features = adus; break; case 'conforming': results.parcels.features = legal_adus; break; case 'nonconforming': results.parcels.features = nonconforming_adus; break; case 'unknown': results.parcels.features = unknown_adus; break; } return results; }34:T24e6,createMap = function(YEAR, ASSESSMENT_TYPE){ const height = 1 * width; var fontSize = Math.floor(height/12); var strokeWidth = Math.round(width/200)/10; //console.log(width,height); console.log('bg',BACKGROUND_COLOR) const svg = d3.select(DOM.svg(width, height)) .style("font-family", "Arial") .style("background-color", BACKGROUND_COLOR) .on("click", toggleRotate); let projection = d3.geoAlbers(); const path = d3.geoPath().projection( projection ) const graticule = d3.geoGraticule() var green = true; var data = filter.parcels.features; /*data.sort((a, b) => { //sort closest to this year last var yrA = getYearBuilt(a); var yrB = getYearBuilt(b); if(typeof yrA === 'undefined') return -1; if(typeof yrB === 'undefined') return 1; return Math.abs(yrB - YEAR) - Math.abs(yrA - YEAR); });*/ var residentialParcels = data.filter(function(d){ return d.properties.Residential === true && public_spaces.indexOf(d.properties.ParcelNumber) === -1 && commercial.indexOf(d.properties.ParcelNumber) === -1 && d.properties.Assessments[YEAR] && d.properties.Assessments[YEAR].ImprovementValue && getUseCode(d) != "Vacant Land"; }); var residentialParcelsLatest = data.filter(function(d){ return d.properties.Residential === true && public_spaces.indexOf(d.properties.ParcelNumber) === -1 && commercial.indexOf(d.properties.ParcelNumber) === -1 && d.properties.Assessments[LATEST_YEAR] && d.properties.Assessments[LATEST_YEAR].ImprovementValue && getUseCode(d) != "Vacant Land"; }); var vals = []; var fn = d => parseInt(d.properties.Assessments[LATEST_YEAR][ASSESSMENT_TYPE]); //use LATEST_YEAR so scale stays across years residentialParcelsLatest.forEach(d => vals.push(fn(d))) vals = _.uniq(vals).sort((a, b) => a-b); //console.log(vals); var start = vals[0] var end = d3.quantile(vals, .9) //top 10% is red var domain = [start, end];//[ d3.min(residentialParcels, fn), d3.max(residentialParcels, fn)] //_.clone(axis.domain); var axis = AXES(data)["Assessment"]; //console.log(axis); var residentialParcels = data.filter(function(d){ return d.properties.Residential === true && public_spaces.indexOf(d.properties.ParcelNumber) === -1 && commercial.indexOf(d.properties.ParcelNumber) === -1 && d.properties.Assessments[YEAR] && d.properties.Assessments[YEAR].ImprovementValue && getUseCode(d) != "Vacant Land"; }); var residentialParcelsLatest = data.filter(function(d){ return d.properties.Residential === true && public_spaces.indexOf(d.properties.ParcelNumber) === -1 && commercial.indexOf(d.properties.ParcelNumber) === -1 && d.properties.Assessments[LATEST_YEAR] && d.properties.Assessments[LATEST_YEAR].ImprovementValue && getUseCode(d) != "Vacant Land"; }); var vals = []; var fn = d => parseInt(d.properties.Assessments[LATEST_YEAR][ASSESSMENT_TYPE]); //use LATEST_YEAR so scale stays across years residentialParcelsLatest.forEach(d => vals.push(fn(d))) vals = _.uniq(vals).sort((a, b) => a-b); //console.log(vals); var start = vals[0] var end = d3.quantile(vals, .9) //top 10% is red var domain = [start, end];//[ d3.min(residentialParcels, fn), d3.max(residentialParcels, fn)] //_.clone(axis.domain); //console.log('domain', domain); function fillColor(parcel) { // Reported LotSquareFeet turns out not to be very accurate. Lots of missing data // Instead, calculate based on the parcel geometry // const sqft = parcel.properties.LotSquareFeet const sqft = turf.area(parcel)*9.322 // eyeballed conversion from LotSquareFeet to this parcel.properties.lot_sf = sqft; //console.log(parcel.properties.Assessment) if(parcel.properties.ParcelNumber == "200247000"){console.log("200247000",parcel)}; if(public_spaces.indexOf(parcel.properties.ParcelNumber) !== -1) return "#17410d"; if(commercial.indexOf(parcel.properties.ParcelNumber) !== -1) return "#987654"; if(vacant.indexOf(parcel.properties.ParcelNumber) !== -1) return "#aaa"; if(typeof parcel.properties.Assessments === 'undefined'){// three parcels too small to see, probably mistakes return "#000"; } var ignore = ["180060100"]; if(ignore.indexOf(parcel.properties.ParcelNumber) !== -1) return; var assessment = parcel.properties.Assessments[YEAR] if(typeof assessment === 'undefined'){ //console.log(parcel.properties) if(typeof subdivisions[parcel.properties.ParcelNumber] === 'undefined'){ //console.log("No assessment available!", YEAR, parcel.properties.ParcelNumber,parcel.properties); if(ASSESSMENT_TYPE == "TotalValue") missing[YEAR].push(parcel.properties.ParcelNumber) return "#333"; } var replacementParcelNum = subdivisions[parcel.properties.ParcelNumber] var replacementParcel = _.find(data, function(d){ return d.properties.ParcelNumber == replacementParcelNum; }) //console.log(replacementParcelNum, replacementParcel) if(typeof replacementParcel.properties.Assessments === 'undefined'){ //console.log("No assessment!", YEAR, replacementParcel.properties.ParcelNumber,replacementParcel.properties); if(ASSESSMENT_TYPE == "TotalValue") missing[YEAR].push(replacementParcel.properties.ParcelNumber) return "#333"; } assessment = replacementParcel.properties.Assessments[YEAR]; } if(assessment.ImprovementValue == 0) return "#aaa"; assessment = assessment[ASSESSMENT_TYPE] if(parcel.properties.Commercial && parcel.properties.UseCode.indexOf("Apartments") === -1){ var hi = 3000000 var lo = 200000 if(assessment > hi) assessment = hi //else if(assessment < lo) //return "#cccccc" assessment = (assessment - lo)/(hi - lo) return d3.interpolatePuBu(assessment) }else if(parcel.properties.Residential){ var hi = 600000 var lo = 100000 if(assessment > hi) assessment = hi //else if(assessment < lo) //return "#cccccc" assessment = (green ? 1 : 0) + (green ? -1 : 1) * (assessment - lo)/(hi - lo) return (green ? d3.interpolateRdYlGn : d3.interpolateYlOrRd)(assessment) }else if(getUseCode(parcel, true) == "Apartments"){ //console.log(getUseCode(parcel)); return "#B999C6"; }else{ return "#222"; } /*var hi = domain[1] var lo = domain[0] if(assessment > hi) assessment = hi //else if(assessment < lo) //return "#cccccc" assessment = (green ? 1 : 0) + (green ? -1 : 1) * (assessment - lo)/(hi - lo) return (green ? d3.interpolateRdYlGn : d3.interpolateYlOrRd)(assessment)*/ } projection .scale(1) .translate([0, 0]); const b = path.bounds(filter.parcels); const s = 0.95 / Math.max((b[1][0] - b[0][0]) / width, (b[1][1] - b[0][1]) / height); const t = [(width - s * (b[1][0] + b[0][0])) / 2, (height - s * (b[1][1] + b[0][1])) / 2]; projection .scale(s) .translate(t) svg.append("path") .datum(graticule) .attr("class", "graticule") .attr("d", path) var defaultStroke = (DARK_MODE ? BACKGROUND_COLOR : TEXT_COLOR); //var newBuildStroke = "#0055ff" svg.append("g") .selectAll("path") .data(data) .enter().append("path") .attr("d", path) .style('fill', fillColor) .style('stroke', defaultStroke) .style('stroke-width', strokeWidth) /*.style('stroke', d => { console.log(arguments) var built = getYearBuilt(d); return (built <= YEAR && built > YEAR-3 ? newBuildStroke : defaultStroke) }) .style('stroke-width', d => { var built = getYearBuilt(d); return (built <= YEAR && built > YEAR-3 ? Math.sqrt(d.properties.lot_sf)/200 : strokeWidth) })*/ .on("mouseover", d => { map_tooltip.style("visibility", "visible").html(tooltipString(d,YEAR))}) .on("mousemove", onMousemove(map_tooltip)) .on("mouseout", d => map_tooltip.style("visibility", "hidden")); svg.append("text") .attr("x", width/5) .attr("y", height/6) .attr("text-anchor", "middle") .style("font-size", fontSize+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text(YEAR); svg.append("text") .attr("x", width/5) .attr("y", height/6 - fontSize + fontSize/18) .attr("text-anchor", "middle") .style("font-size", fontSize/3+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text(ASSESSMENT_TYPE.replace("Value"," Value")); svg.append("text") .attr("x", width/5) .attr("y", height/6 - fontSize - fontSize/3) .attr("text-anchor", "middle") .style("font-size", fontSize/3+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text(GEOGRAPHY + " ADUs: "); var legendOptions = { wi: width, legendOffsetX: width/20, legendOffsetY: height/10, color: d3.scaleSequential((green ? d3.interpolateRdYlGn : d3.interpolateYlOrRd)).domain((green ? domain.reverse() : domain)), domain : (green ? domain.reverse() : domain), reverse: green, median: d3.median(residentialParcels,d => (d.properties.Assessments[YEAR] ? d.properties.Assessments[YEAR][ASSESSMENT_TYPE] : null))} addLegendGradient(svg, axis, legendOptions) return svg.node(); }35:T7a9,viewof replaced = { var data = filter.parcels.features//.filter(d => getYearBuilt(d) > 1999) var fmt = d3.format("$,.0f"); function tabulate(data, columns) { const div = d3.select(html`

`); var table = div.append('table') var thead = table.append('thead') var tbody = table.append('tbody'); // append the header row thead.append('tr') .selectAll('th') .data(columns).enter() .append('th') .text(function (column) { return column; }); // create a row for each object in the data var rows = tbody.selectAll('tr') .data(data) .enter() .append('tr'); // create a cell in each row for each column var cells = rows.selectAll('td') .data(function (row) { return columns.map(function (column) { return {column: column, value: row[column]}; }); }) .enter() .append('td') .text(function (d) { return d.value; }); return div.node(); } console.log(data.length) var replaced = []; _.forEach(data, d => { var built = getYearBuilt(d); var priorAssessments = {}; var priorAssessment; for(var yr in d.properties.Assessments){ if(yr < built && d.properties.Assessments[yr].ImprovementValue != 0){ priorAssessments[yr] = d.properties.Assessments[yr]; priorAssessment = d.properties.Assessments[yr]; } } if(typeof priorAssessment !== 'undefined'){ replaced.push({YearBuilt: built, Before: fmt(priorAssessment.TotalValue), After: fmt(d.properties.Assessment), ImprovementsBefore: fmt(priorAssessment.ImprovementValue), ImprovementsAfter: fmt(d.properties.Assessments[2019].ImprovementValue), UseCode: getUseCode(d), ParcelNumber: d.properties.ParcelNumber, parcel: d}) } }) replaced = _.sortBy(replaced, "YearBuilt"); return tabulate(replaced, ["YearBuilt", "Before", "After", "ImprovementsBefore", "ImprovementsAfter", "UseCode", "ParcelNumber"]); }36:T1344,map_yr_built /*= { const YEAR = "2019"; const height = 0.8 * width; console.log(width,height); const svg = d3.select(DOM.svg(width, height)); let projection = d3.geoAlbers(); const path = d3.geoPath().projection( projection ) const graticule = d3.geoGraticule() function fillColor(parcel) { // Reported LotSquareFeet turns out not to be very accurate. Lots of missing data // Instead, calculate based on the parcel geometry // const sqft = parcel.properties.LotSquareFeet const sqft = turf.area(parcel)*9.322 // eyeballed conversion from LotSquareFeet to this //console.log(parcel.properties.Assessment) if(parcel.properties.ParcelNumber == "200247000"){console.log("200247000",parcel)}; var public_spaces = ["190034000", "180039400", "200066000", "180038000", "210089000", "210087000", "190032000", "190032100", "190033000", "190080000", "190035390", "190035250", "190010100", "18A046000", "200278000", "21B001000", "21B016000", "21A129000", "200271000"] if(public_spaces.indexOf(parcel.properties.ParcelNumber) !== -1) return; var commercial = ["21B004600", "21B004100", "21B004400", "21B004500", "21B003000", "21B003A00", "21B004700", "21B002100", "21B004000", "21B002A00", "21B002200", "21B004200", "21B002000"] if(commercial.indexOf(parcel.properties.ParcelNumber) !== -1) return; var vacant = ["21A100002", "21A100003", "21A100004", "21A100005", "21A100006", "21A100007", "200121000", "200122000", "200125000", "200126000", "200129000", "200131100", "200131200", "200142000", "200143000", "200144000", "200145000", "200146000", "200147000", "200148000", "200196000", "200259260", "200259270", "200259280", "200259290", "200259301", "200259310", "200259320", "200259330", "200259340", "200259350", "200259370", "200259380"] if(vacant.indexOf(parcel.properties.ParcelNumber) !== -1) return if(typeof parcel.properties.Assessments === 'undefined'){// three parcels too small to see, probably mistakes return "#000"; } var ignore = ["180060100"]; if(ignore.indexOf(parcel.properties.ParcelNumber) !== -1) return; var subdivisions = { "210111001": "210111000", "200261100": "200261000", "180037001": "180037000", "190010001": "190010000", "200063001": "200063000", "200022001": "200022000", "200022002": "200022000", "200019002": "200019000", "200025001": "200025000", "200025002": "200025000", "200025003": "200025000", "210133100": "210133000", "210132100": "210132000", "21A100001": "21A100000", "21A100002": "21A100000", "21A100003": "21A100000", "21A100004": "21A100000", "21A100005": "21A100000", "21A100006": "21A100000", "21A100007": "21A100000", }; var assessment = parcel.properties.Assessments[YEAR] if(typeof assessment === 'undefined'){ console.log(parcel.properties) if(typeof subdivisions[parcel.properties.ParcelNumber] === 'undefined'){ console.log("No assessment available!", parcel.properties.ParcelNumber,parcel.properties); return "#0000FF"; } var replacementParcelNum = subdivisions[parcel.properties.ParcelNumber] var replacementParcel = _.find(filter.parcels.features, function(d){ return d.properties.ParcelNumber == replacementParcelNum; }) console.log(replacementParcelNum, replacementParcel) if(typeof replacementParcel.properties.Assessments === 'undefined'){ console.log("No assessment!", replacementParcel.properties.ParcelNumber,replacementParcel.properties); return "#0000FF"; } assessment = replacementParcel.properties.Assessments[YEAR]; } if(assessment.ImprovementValue == 0) return "#cccccc"; var built = parcel.properties.YearBuilt var hi = 2019 var lo = 1950 if(built > hi) built = hi //else if(assessment < lo) //return "#cccccc" built = (built - lo)/(hi - lo) return d3.interpolateReds(built) } projection .scale(1) .translate([0, 0]); const b = path.bounds(filter.parcels.features); const s = 0.95 / Math.max((b[1][0] - b[0][0]) / width, (b[1][1] - b[0][1]) / height); const t = [(width - s * (b[1][0] + b[0][0])) / 2, (height - s * (b[1][1] + b[0][1])) / 2]; projection .scale(s) .translate(t) svg.append("path") .datum(graticule) .attr("class", "graticule") .attr("d", path); svg.append("g") .selectAll("path") .data(filter.parcels.features) .enter().append("path") .attr("d", path) .style('fill', fillColor) .style('stroke', '#0001') return svg.node(); }*/ 37:T7b0,//parcels = d3.json("https://opendata.arcgis.com/datasets/0e9946c2a77d4fc6ad16d9968509c588_72.geojson") /*parcels = (CACHE ? (EVEN_MORE_CACHE ? {type: "FeatureCollection", features: []} : d3.json(PARCELS_URL)) : new Promise(resolve => { function json(response) { return response.json() }; var fetchParcels = function(offset, cb){ console.log('fetchParcels',offset) fetch("https://gisweb.charlottesville.org/arcgis/rest/services/OpenData_1/MapServer/72/query?where=1%3D1&outFields=*&outSR=4326&f=geojson&resultOffset="+offset, {"credentials":"omit","referrer":"http://opendata.charlottesville.org/datasets/parcel-area-details/geoservice?geometry=-78.673%2C37.993%2C-78.02%2C38.087","referrerPolicy":"no-referrer-when-downgrade","body":null,"method":"GET"}) .then(json) .then(function(data){ console.log(data); cb(null, data.features) }); }; var fetchAll = function(cb){ return fetch("https://gisweb.charlottesville.org/arcgis/rest/services/OpenData_1/MapServer/72/query?where=1%3D1&outFields=*&outSR=4326&returnCountOnly=true&f=json", {"credentials":"omit","referrer":"http://opendata.charlottesville.org/datasets/parcel-area-details/geoservice?geometry=-78.673%2C37.993%2C-78.02%2C38.087","referrerPolicy":"no-referrer-when-downgrade","body":null,"method":"GET"}) .then(json) .then(function(data){ console.log(data); var count = data.count; var perquery = 1000; console.log(count); console.log(_.range(0,count, perquery)) return async.mapLimit(_.range(0,count, perquery), 1, fetchParcels, function(){ console.log(arguments); var geo = {type: "FeatureCollection", features: []}; var sets = arguments[1]; for(var x in sets){ geo.features.push.apply(geo.features, sets[x]) } cb(geo); }) }) }; return fetchAll(resolve); }) );*/38:T537f,frysspring = { return ["200177000", "200064000", "190037400", "200115000", "21A039000", "180053000", "210074000", "220090200", "200152000", "220126100", "200259240", "210064000", "18A088000", "180043000", "200190000", "200211000", "190035360", "21B016301", "210102100", "18A134000", "200259270", "18A012000", "21A099200", "21A079000", "21A087000", "21A129140", "220051000", "21B030000", "210026000", "190036200", "200259140", "200230000", "21A087500", "200267300", "220002000", "210017000", "21A047000", "210034000", "200259350", "21B046000", "190037600", "200028000", "220090300", "200025002", "180015280", "21A001400", "220038000", "18A101000", "200011000", "18A133000", "21A099000", "21B026000", "21A006000", "190037250", "21A087100", "200269400", "210002000", "200126200", "190034170", "210092400", "220003000", "21B016450", "210110000", "18A127000", "220057000", "180049100", "200226000", "21A132100", "21A049000", "200258000", "200178000", "220101800", "220101900", "210082000", "210053000", "210060000", "220152000", "21B044000", "180005200", "200238000", "21A099900", "18A037000", "210006200", "220153000", "21A146400", "190008000", "210076000", "21A133000", "200247100", "210077000", "21B004600", "220089000", "200166000", "190016000", "21A129000", "21A035000", "2100923A0", "220146000", "180015130", "18A105000", "210102000", "180040000", "21A129110", "190036300", "200066000", "21A099800", "220018100", "21A092000", "190037900", "210025000", "190046100", "200259340", "220111000", "180015220", "200077100", "18A063000", "200225000", "190076000", "220031000", "200039000", "21A0014A0", "200130000", "21B016460", "21A130600", "200118000", "220046101", "220134000", "190035160", "180031000", "200228000", "18A021100", "190032100", "200134000", "200234000", "200242000", "18A008000", "200183000", "210112000", "220166000", "21A129600", "180015260", "18A085000", "210116000", "200155000", "200270400", "21A100A00", "21B016120", "200274000", "21A140100", "200087000", "190035170", "180006000", "18A055000", "200097000", "200222000", "210117000", "220118000", "190078000", "180015140", "190035900", "200061000", "200236000", "21A059000", "190037000", "200025003", "210051000", "200077000", "21A096000", "220168000", "190075000", "220154000", "200213000", "220140000", "190035380", "180011000", "21A100006", "18A084000", "21B016440", "18A017000", "220046600", "220102000", "200268300", "21A080000", "21A130100", "200214000", "200259250", "21A127000", "18A104000", "220101200", "180015160", "220046140", "18A013000", "21B016180", "210105260", "210093100", "220103000", "210029000", "210105110", "18A030000", "190045A00", "21A090200", "190066000", "200128000", "21B031000", "220126000", "210108000", "220026000", "210020000", "220086100", "200246200", "18A010000", "200055000", "190062000", "21A004000", "210105130", "21A101000", "210008000", "200114000", "200219000", "21A129160", "220022B00", "21A054000", "200269200", "180017300", "180049000", "190037140", "220034000", "190037370", "190035390", "21A090100", "21A098000", "21A016000", "190019000", "18A100000", "200254000", "200023000", "210131300", "21A099190", "190070000", "200232000", "21A056000", "21A046000", "220044000", "200103000", "21A099100", "190034100", "200144000", "21A089000", "210124000", "18A129000", "21B036000", "220182000", "180005400", "18A092000", "210105000", "200147000", "210021000", "18A032300", "200200000", "220006000", "220125000", "200275000", "18A109000", "21A051000", "220123000", "190037200", "220167000", "21A115000", "200156000", "180005100", "21A100007", "220020100", "200259500", "210095000", "200259150", "220159100", "21A136000", "190067000", "220101120", "200060000", "18A069000", "220101100", "200010100", "200276100", "180007000", "220056000", "220046210", "180027000", "18A153000", "200104000", "200016000", "220097000", "21B016200", "21A022000", "200003100", "220063100", "21A009000", "21A130500", "18A157000", "180056000", "220053000", "200129000", "21B032000", "210004000", "21A131600", "200221000", "200046000", "21A100004", "200259330", "220046110", "220027000", "210097000", "220071000", "200113100", "220151000", "18A140000", "190052000", "21B016110", "210042000", "21A137000", "200259130", "200193000", "180048100", "200014100", "200204000", "200259160", "210105160", "200241000", "200124000", "21B045000", "18A086000", "190035200", "190068000", "18A058000", "200218000", "210035000", "21B021000", "190035330", "220142000", "190035370", "21A001700", "200008100", "190022000", "21B016280", "210101000", "21A129800", "190036400", "200259200", "200013000", "190035350", "190079000", "18A096000", "21A090900", "18A070000", "190034201", "210092100", "21A028000", "200093100", "180015210", "200259280", "21A100000", "21B016230", "220150000", "21A099400", "21A100003", "220046000", "200072000", "190037190", "220085000", "220046200", "220111100", "180041000", "180033000", "21B016320", "200262000", "190050000", "200271000", "200075000", "190034320", "200168000", "190042000", "21B016350", "190012000", "210122000", "180015900", "210028000", "21B016410", "200186000", "18A093000", "220133000", "200108000", "200132000", "210105220", "190034270", "18A079000", "220132000", "220011000", "220075000", "18A023000", "180060000", "200271400", "200260000", "220121000", "18A032000", "220172000", "21B020000", "190003000", "18A009000", "200250000", "21A011000", "210105700", "190034290", "18A119000", "21A013000", "220090000", "200052000", "2100921A0", "21A108000", "21A129150", "190035250", "190041000", "18A051000", "190034260", "200131000", "200259360", "190009000", "210131200", "180039200", "190036500", "200025000", "200265100", "200138000", "220059000", "220135000", "180032000", "21A0017A0", "21A0013A0", "210005A00", "210065000", "190037500", "18A137000", "21A095000", "21B016100", "180015270", "21A081000", "21A078000", "220086200", "210079000", "190037101", "180015250", "21A099140", "180018100", "200158000", "18A077000", "220040000", "190037230", "220129000", "200268200", "180038000", "200198000", "21A125000", "18A083000", "190056000", "180019000", "210070000", "21A131400", "190057000", "220023000", "190035301", "210105101", "180015200", "21A062000", "18A053000", "200270200", "220101101", "220037000", "200079000", "200031000", "190036000", "190034250", "190035230", "220016000", "18A076000", "200223000", "220102100", "200075100", "190014000", "180044000", "220015000", "200106000", "21B016300", "21A001100", "210009000", "18A062000", "220062000", "220077000", "200028300", "220139000", "200202000", "21A100B00", "220048000", "190034300", "190036100", "18A031000", "210047000", "18A151000", "200261000", "200197000", "220156000", "210099000", "21A134000", "190073000", "18A110000", "21A050000", "18A090000", "200259100", "18A111000", "210090100", "190010100", "210014000", "200089000", "18A094000", "180015230", "190027000", "21A146100", "200161000", "18A019000", "180039100", "200246300", "18A123000", "210120000", "200151000", "200272000", "200038000", "18A020000", "220021A00", "200268400", "21A097000", "220158000", "190032300", "21B016190", "190029000", "200049000", "220114000", "200180000", "200233000", "200142000", "220144100", "190037120", "21A088100", "21A058000", "220128000", "200131200", "180059000", "22B183000", "21A007000", "200082000", "220127000", "190034301", "220176000", "190037170", "18A120000", "200259290", "210046000", "21A114000", "21A012000", "210067000", "220082000", "180025000", "21B039000", "220046180", "220130000", "21A088000", "180037000", "21B016240", "190080000", "18A145000", "200018000", "21B016140", "220189100", "21A099500", "21A052000", "21A099130", "21B004100", "220041000", "200224000", "18A035000", "190030000", "200113300", "200041200", "210105100", "220045000", "220108000", "220072000", "200215000", "200181000", "200047000", "210105800", "190035140", "18A132000", "200252000", "210069000", "200188000", "220101700", "21A087400", "190049000", "21B043000", "200067000", "210043000", "21A091000", "200240000", "21A099120", "220174000", "210107000", "18A056000", "220190000", "200102000", "21B042000", "190037110", "21A138000", "21B004400", "21A018000", "210105170", "21A029000", "200208000", "220183000", "210044000", "200266100", "200259120", "200140000", "180055500", "210128000", "190034700", "190034000", "21A033000", "210087000", "21B004500", "21B016430", "220028000", "220046400", "21A100005", "21B003000", "190032200", "18A148000", "220101140", "190034600", "18A131000", "180039000", "200169000", "21A095A00", "21A099170", "220091000", "220051100", "190032000", "210054000", "200120000", "220039000", "21B016340", "200175000", "200126000", "200159000", "200014000", "190037301", "200026000", "180042000", "190064000", "18A082000", "21A057000", "21A005000", "18A032200", "200246000", "210072000", "210023000", "220025000", "180055200", "18A073000", "21B016420", "220184000", "21A129400", "190006000", "180015101", "180028000", "180022000", "220050000", "190035110", "18A029000", "200235000", "220178100", "18A003000", "220189000", "21A120000", "220090100", "200256000", "210056000", "210114000", "21A0012A0", "2100922A0", "21B016500", "200041100", "180015170", "200113200", "220019100", "210040000", "21A019000", "21A086000", "180015600", "200259310", "200143000", "21A144000", "180017200", "190044000", "190034120", "18A080000", "18A128000", "200033000", "220104000", "190061000", "180015190", "180001000", "190077000", "200269100", "210071000", "210105190", "210105400", "180015240", "21A010000", "190034150", "220101130", "220101600", "21B003A00", "190035180", "210024000", "200259101", "21A146200", "21B016170", "180018000", "180015500", "190034140", "21B016600", "210032000", "200207000", "220163000", "190069000", "210123000", "200006000", "190037160", "210078000", "210059000", "180015120", "21A082000", "200136000", "210096000", "200107000", "21A042000", "190036600", "180017100", "18A113000", "180010000", "200259110", "190035210", "220179000", "190034110", "21A099270", "18A059000", "200069000", "210066000", "21A144100", "18A078000", "190034210", "210106000", "180055000", "220070000", "180002200", "220066000", "200266300", "18A023200", "200259300", "18A092B00", "22B182000", "200270100", "210127000", "21A0011A0", "21B028000", "200131100", "190074000", "190072000", "190040000", "200080000", "220004000", "21A100001", "190054100", "18A025000", "21B016800", "21B035000", "210039000", "190034280", "190035220", "21A099280", "210049000", "210125000", "200094000", "18A071000", "200259380", "200001000", "210030000", "220058000", "21A092100", "220101500", "180055100", "210105210", "21B033000", "21A090800", "200146000", "220144000", "18A064000", "200121000", "180008000", "18A138000", "190037310", "190024100", "180035000", "21A032000", "220008000", "220169000", "200201000", "200259210", "210010000", "21B016130", "220194000", "200123000", "200005000", "200036000", "190060000", "21A129300", "21A129700", "220009000", "180015800", "18A125000", "21A085000", "21A099220", "200195000", "200111000", "18A106000", "220046230", "190037130", "18A099000", "200209000", "190025000", "190037360", "210113000", "220067000", "210075000", "210081000", "210105120", "190034800", "220117000", "21B016400", "210118000", "21A070000", "200004000", "200012000", "21A0019A0", "220138000", "200217000", "200199000", "200028200", "21A0015A0", "190037290", "220064000", "21A021000", "220046160", "18A155000", "21B016330", "220122000", "210073000", "210022000", "200196000", "200125000", "210006100", "220055000", "190026000", "190013000", "22B185000", "190035290", "200083000", "200042000", "18A150000", "190034180", "190037150", "200259260", "220101400", "18A141000", "18A028000", "180023000", "200265000", "18A144000", "200259180", "210088000", "190034310", "180004000", "220046500", "200141000", "220036000", "200109000", "18A160000", "180048000", "200267100", "180015180", "210105600", "21A048000", "210091000", "21A090300", "180003000", "18A024200", "190058000", "190035190", "200266000", "220101300", "200263000", "18A152000", "200191000", "210001000", "210111001", "18A001000", "21B016210", "21B004700", "220116000", "200008000", "210126000", "200179000", "21A001200", "190034400", "220005000", "18A102000", "21A099160", "180047000", "220106000", "200259220", "21A103000", "21A130300", "21A129200", "220014000", "180015110", "200015000", "21A087800", "180030000", "21A131300", "190037180", "200153000", "200033A00", "180021000", "18A126000", "21A099600", "18A121000", "210105500", "190004000", "21B016250", "200173000", "190052A00", "200268100", "220101150", "190037270", "21A030000", "18A006000", "220046100", "210018000", "190021000", "18A103000", "190037100", "200246100", "21B016310", "190063000", "220081000", "220101110", "21B002100", "21A146300", "190035600", "21A099150", "190034130", "190071000", "200164000", "210062000", "210095100", "200259370", "220064100", "200073000", "220035000", "220046800", "180003100", "180055300", "200071000", "200167000", "210016000", "210013100", "210006000", "21A069000", "200220000", "200105100", "21A055000", "180059100", "190039000", "180051000", "18A052000", "200187000", "200045000", "220074000", "200278000", "200262100", "21A040000", "21A142000", "210105230", "190023000", "200117000", "18A095000", "190017000", "190036700", "200227000", "18A139000", "210083000", "190037800", "21A066000", "21B016390", "220191000", "200081000", "21A023000", "21B004000", "21A026000", "18A004000", "220046220", "210105150", "200259800", "210033000", "200101000", "220113000", "18A113B00", "200267400", "21B016380", "200243000", "180037001", "220095000", "18A036000", "220136000", "220119000", "200259400", "18A046000", "190035260", "21A099240", "210052000", "220042000", "200210000", "190043000", "220162000", "21A001800", "200113000", "18A060000", "190038000", "21A120A00", "200189000", "210013000", "200259320", "200022001", "18A018000", "200112000", "180015700", "200045100", "21A084000", "220049000", "190037340", "220068000", "18A142000", "200203000", "190034230", "180009000", "200019002", "220109000", "21A090600", "18A115000", "200264100", "200242100", "200264300", "21A073000", "200100000", "220046201", "180036000", "200133000", "21A100002", "18A054000", "21B016220", "220046150", "200273000", "210015000", "21A113000", "210068000", "18A108000", "190057200", "200212000", "21A129101", "220092000", "220099000", "180024000", "200074000", "18A114B00", "200255000", "210079100", "200053000", "220165000", "18A066000", "21A126000", "18A057000", "18A076B00", "21A099230", "190035100", "210125100", "220147000", "200043000", "21B022000", "220018000", "21A038000", "200126100", "21A008000", "21B029000", "200035000", "210048000", "200098000", "18A097000", "190037700", "210037000", "190054000", "180058000", "21A003000", "190035280", "21A087200", "200003300", "180020000", "210105900", "18A026000", "21A131200", "200116000", "200271100", "190034101", "190005000", "210115100", "18A032100", "18A089000", "200024000", "210091100", "18A156000", "18A011000", "21A090600", "220054000", "220111300", "21A015000", "220160000", "21A074000", "21A001600", "200259170", "18A061000", "21A122000", "21A014000", "200271300", "18A022100", "210080000", "21A044000", "190035101", "21A061000", "21A100C00", "220046240", "21A112000", "18A021000", "200194000", "200100100", "220093000", "180031100", "21A131100", "190037240", "200137000", "190035310", "210036000", "21A024000", "180015301", "18A107000", "18A087000", "210011000", "200163000", "21B016270", "21A121A00", "21A0018A0", "180015100", "190059000", "200096000", "200017000", "200267200", "210129000", "220137000", "200257000", "220069000", "21A076000", "180052000", "200162000", "190035150", "21A027000", "180015201", "190034160", "220141000", "180016000", "22B184000", "21A104000", "200245000", "21A090500", "210133000", "210115000", "21A064000", "18A114000", "21A090400", "220046250", "21A001500", "220111500", "220181000", "200041000", "21A036000", "21A094000", "21B037000", "210009100", "190035300", "200020000", "220076000", "220013000", "190047000", "200037000", "180017000", "210105140", "21B023000", "210131000", "220021B00", "190015000", "220192000", "180060100", "200251000", "180015300", "210055000", "21A123000", "21B002A00", "21A129130", "200009000", "21A143000", "220063000", "21A119A00", "21B024000", "180015310", "190018000", "180029000", "21B016290", "210098000", "190037350", "210003100", "18A136000", "21A043000", "200259600", "21A053000", "21A028A00", "200019100", "210092000", "180054000", "200277000", "190037260", "21A041000", "190034900", "200165000", "190016200", "18A122000", "21A060000", "210027000", "190034340", "210058000", "21B016370", "18A027000", "21A099250", "220098000", "220020000", "190035320", "220030000", "180026000", "18A081000", "200122000", "21B038000", "190035240", "220046900", "210093000", "200010000", "190031000", "200029000", "21A129500", "21A090700", "21A121000", "200003200", "220019000", "200192000", "18A154000", "200003000", "220107000", "18A118000", "200007000", "190037300", "220185000", "21A129120", "18A033000", "200110000", "180039300", "210092200", "190034220", "220046300", "21A132000", "190051000", "200259900", "18A075000", "220084000", "18A067000", "21B002200", "190044100", "200040000", "190035400", "220032000", "180022100", "200062000", "200271200", "220169100", "21A116000", "190046000", "18A116000", "21A045000", "200084000", "21A068000", "18A117000", "21A034000", "190037280", "180046000", "210051100", "200231000", "210132000", "220043000", "210131100", "220105000", "21B041000", "200263100", "210045000", "220187000", "200266400", "220024000", "190055000", "21A0016A0", "200269300", "200118100", "21B016160", "210105180", "21B016700", "200091000", "21B027000", "210105240", "220047000", "220111200", "21B025000", "18A098000", "200270300", "210061100", "220029000", "190010001", "200057000", "200022002", "220170000", "200276000", "18A022000", "220178200", "21A088200", "200154000", "210121000", "220046130", "21A141000", "220010000", "220110000", "200205000", "200056000", "200145000", "180005000", "190035130", "220124000", "220143000", "190020000", "21A072000", "200051000", "190011000", "200078000", "21A137100", "200259230", "21A099260", "200160000", "220131000", "200018100", "220001000", "200093000", "200054000", "200092000", "21A002000", "220046190", "200119000", "21A090800", "220061000", "21A071000", "200068000", "190034200", "200058000", "220149000", "21A031000", "21A025000", "210007000", "200184000", "190034190", "21B016101", "18A135000", "200259700", "210130000", "200088000", "220120000", "220193000", "190035270", "210105200", "190037201", "180015290", "200059000", "21B016260", "190037220", "220079000", "180015400", "21B034000", "21A067000", "220148000", "210105201", "21A001300", "190035340", "200076000", "200086000", "220145000", "220096000", "190057100", "21A117000", "190032400", "200216000", "21A124000", "21A087600", "200063000", "200261100", "18A077B00", "210057000", "21A065000", "220159000", "190034240", "200148000", "210092300", "210086000", "18A065000", "200022000", "220175000", "21A083000", "220046120", "200099000", "200249000", "200259301", "200266200", "210090000", "210089000", "210005000", "200253000", "18A074000", "200170000", "220188000", "210084000", "180015000", "21A017000", "21A130400", "210094000", "21A139000", "210132100", "21B016360", "21A135000", "21A130200", "220022A00", "190035700", "200150000", "220171000", "21A087300", "210009A00", "210010100", "200050000", "18A024000", "210100000", "21B004200", "21A075000", "18A112000", "190035500", "200259190", "21A099210", "180050000", "200139000", "200239000", "21B016401", "200127000", "190016100", "220046170", "180057000", "18A007000", "21A090000", "18A024100", "21A077000", "200085000", "190065000", "21A063000", "21B016150", "190033000", "220157000", "180005300", "210105300", "180002100", "200174000", "200182000", "18A091000", "210105250", "200019000", "200172000", "180045000", "180002000", "200105000", "220111400", "200135000", "18A072000", "21A129100", "21A099110", "200264200", "210041000", "18A124000", "21A145000", "190035120", "220017000", "190048000", "210023100", "210025100", "210031000", "21A020000", "190016300", "21A001900", "21A140000", "200044000", "210111000", "200028100", "220101000", "18A147000", "210119000", "180015150", "220046700", "21B001000", "18A023100", "220094000", "200083100", "220155000", "18A146000", "220115000", "210050000", "18A158000", "200176000", "220012000", "220178000", "180055400", "21B016201", "21A099180", "220164000", "220033000", "210061000", "210019000", "18A016000", "200095000", "220007000", "190034330", "220180000", "220177000", "18A130000", "190034500", "21B040000", "190007000", "190035800", "21A129900", "190001000", "200025001", "22B181000", "220156100", "210003000", "200229000", "190045000", "210133100", "21B002000", "200157000", "200070000", "200072100", "220086000", "220065000", "220161000", "220088000", "210038000", "21A131500", "190010000", "18A034000", "22B186000", "200063001", "200206000", "190037330", "200259201", "180034100", "220186000", "210063000", "21B016000", "21A089000", "200237000", "190037320", "220052000", "21A037000", "21A119000", "18A159000", "190028000", "21A099700", "200185000", "180039400", "200048000", "21A087700", "200013100", "21A099290", "18A068000", "210091200", "18A149000", "200244000", "190035201", "21B016900", "190002000", "200021000", "200247000", "200264400"]; }39:T748,subdivisions = { return { "210111001": "210111000", "200261100": "200261000", "180037001": "180037000", "190010001": "190010000", "200063001": "200063000", "200022001": "200022000", "200022002": "200022000", "200019002": "200019000", "200025001": "200025000", "200025002": "200025000", "200025003": "200025000", "210133100": "210133000", "210132100": "210132000", "21A100001": "21A100000", "21A100002": "21A100000", "21A100003": "21A100000", "21A100004": "21A100000", "21A100005": "21A100000", "21A100006": "21A100000", "21A100007": "21A100000", "220024000": "220023000", "21A028A00": "21A028000", "21A130600": "200271000", "21A130100": "200271000", "21A131600": "200271000", "21A131400": "200271000", "21A146100": "200271000", "21A146200": "200271000", "21A146400": "200271000", "21A130200": "200271000", "21A130300": "200271000", "21A131300": "200271000", "21A146300": "200271000", "21A131200": "200271000", "21A131100": "200271000", "21A130400": "200271000", "21A130500": "200271000", "21A131500": "200271000", "200267300": "200271000", "200269400": "200271000", "200270400": "200271000", "200268300": "200271000", "200269200": "200271000", "200271400": "200271000", "200268200": "200271000", "200270200": "200271000", "200268400": "200271000", "200269100": "200271000", "200266300": "200271000", "200270100": "200271000", "200267100": "200271000", "200268100": "200271000", "200267400": "200271000", "200271100": "200271000", "200271300": "200271000", "200267200": "200271000", "200271200": "200271000", "200266400": "200271000", "200269300": "200271000", "200270300": "200271000", "200266200": "200271000", } }3a:T623,dl = { var parcels = _.clone(filter.parcels); var data = []; _.forEach(parcels.features, d => { var row = {}; Object.assign(row, d.properties); Object.assign(row, d.properties.CommercialDetails); Object.assign(row, d.properties.ResidentialDetails); if(typeof d.properties.ResidentialDetailRows === 'undefined' && typeof d.properties.CommercialDetailRows !== 'undefined') console.log(d.properties.CommercialDetailRows[0].UseCode, d); //if(typeof d.properties.ResidentialDetailRows !== 'undefined' && d.properties.ResidentialDetailRows.length > 1) console.log(d); /*if(typeof d.properties.ResidentialDetailRows !== 'undefined' && typeof d.properties.CommercialDetailRows !== 'undefined' && d.properties.ResidentialDetailRows.length + d.properties.CommercialDetailRows.length > 1 && !(d.properties.ResidentialDetailRows.length == d.properties.CommercialDetailRows.length && d.properties.ResidentialDetailRows.length + d.properties.CommercialDetailRows.length == 2 && d.properties.ResidentialDetailRows[0].UseCode == d.properties.CommercialDetailRows[0].UseCode ) && getUseCode(d,true,true) != "Apartments" ){ console.log(d.properties.ResidentialDetailRows[0].UseCode, d.properties.CommercialDetailRows[0].UseCode, d); }*/ _.each(d.properties.Assessments, a => { var assRow = _.clone(row); Object.assign(assRow, a.properties) data.push(row); }); }) return data; return DOM.download(serialize(data), null, "Download CSV") }3b:[] 2e:{"id":"fd260dbf4e20f490","slug":"charlottesville-adu-data","title":"Charlottesville ADU Data","thumbnail":"2bbe2d6e0410eb94108ea8ab2cdd0df3ae45a2e3283d0450a7deba3afe87d8f0","access_level":"public","create_time":"$D2020-02-20T09:00:45.691Z","update_time":"$D2020-02-20T09:33:30.981Z","view_time":null,"first_public_time":"$D2020-02-20T09:12:03.299Z","has_unpublished_edits":null,"fork":{"id":"abc3f3ee6dbc4c29","slug":"charlottesville-assessment-data","title":"Charlottesville Assessment Data","owner":{"id":"80a152de5519610c","login":"rorystolzenberg","name":"Rory Stolzenberg"}},"stars":0,"starred":false,"owner":{"type":"team","id":"80a152de5519610c","login":"rorystolzenberg","name":"Rory Stolzenberg","avatar_url":"https://avatars-next.observableusercontent.com/c360e2fec7e4b4fd695b5d26154fb359993edd7a6e876054d694af6f7d0c3cc3","tier":"starter_2024"},"version":2724,"publish_version":2724,"role":null,"authored":false,"authors":[{"type":"individual","id":"14c316a4626aa091","login":"rorystolzenberg","name":"Rory Stolzenberg","avatar_url":"https://avatars-next.observableusercontent.com/c360e2fec7e4b4fd695b5d26154fb359993edd7a6e876054d694af6f7d0c3cc3","tier":null}],"members":[{"type":"individual","id":"14c316a4626aa091","login":"rorystolzenberg","name":"Rory Stolzenberg","avatar_url":"https://avatars-next.observableusercontent.com/c360e2fec7e4b4fd695b5d26154fb359993edd7a6e876054d694af6f7d0c3cc3","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Charlottesville ADU Data","cells":[{"id":0,"value":"md`# Charlottesville ADU Data\n## Home Type, Square Footage, and Value — 2010-2019`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1643,"value":"CACHE = false","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2235,"value":"EVEN_MORE_CACHE = false","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2452,"value":"GEOGRAPHY = \"Charlottesville\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2705,"value":"viewof WHICH_ADUS = select({\n title: \"Select ADUs\",\n description: \"Select all, conforming, non-conforming, or unknown.\",\n options: [\n { label: \"All ADUs\", value: \"all\" },\n { label: \"Non-conforming\", value: \"nonconforming\" },\n { label: \"Conforming\", value: \"conforming\" },\n { label: \"Unknown (PUD/Multi-zone)\", value: \"unknown\" }\n ],\n value: \"Assessment\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1710,"value":"md`# Assessment Map`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1714,"value":"md`### Map Options`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1546,"value":"viewof ASSESSMENT_TYPE = select({\n title: \"Assessment\",\n description: \"Select total, improvements, or land.\",\n options: [\n { label: \"Total\", value: \"TotalValue\" },\n { label: \"Improvements\", value: \"ImprovementValue\" },\n { label: \"Land\", value: \"LandValue\" }\n ],\n value: \"Assessment\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1466,"value":"ROTATE","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":525,"value":"viewof speed = slider({\n min: 1,\n max: 10,\n step: 1,\n value: 4,\n format: \"\",\n attributes: {style: \"padding-left: 100px\"},\n title: 'Speed',\n description:\n \"Set animation speed.\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1408,"value":"YEAR","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":552,"value":"viewof map_display = Generators.observe(next => {\n next(maps[YEAR.value][ASSESSMENT_TYPE]);\n \n const inputted = () => {\n var map = maps[YEAR.value][ASSESSMENT_TYPE];\n // if(typeof map === 'string' && map.indexOf(\"Loading\") !== -1){\n maps[YEAR.value][ASSESSMENT_TYPE] = createMap(YEAR.value, ASSESSMENT_TYPE)\n // }\n return next(maps[YEAR.value][ASSESSMENT_TYPE]);\n };\n YEAR.addEventListener(\"input\", inputted);\n YEAR.dispatchEvent(new CustomEvent(\"input\", { bubbles: true }));\n return () => YEAR.removeEventListener(\"input\", inputted);\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1723,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1703,"value":"md`# Scatterplot`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1718,"value":"md`### Scatterplot Options`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1343,"value":"viewof Y_AXIS = select({\n title: \"Y Axis: \",\n description: \"Pick a Y axis.\",\n options: [\n { label: \"Assessment\", value: \"Assessment\" },\n { label: \"Assessment/sqft\", value: \"AssessmentPsf\" },\n { label: \"Assessment — Land\", value: \"LandValue\" },\n { label: \"Square Feet\", value: \"Sqft\" },\n { label: \"Acreage\", value: \"Acreage\" }\n ],\n value: \"Assessment\"\n})\n/*html`\n\n`*/","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1373,"value":"viewof COLOR_KEY = select({\n title: \"Color Dimension: \",\n description: \"Pick a color dimension.\",\n options: [\n { label: \"Home Type\", value: \"UseCode\" },\n { label: \"Assessment\", value: \"Assessment\" },\n { label: \"Assessment/sqft\", value: \"AssessmentPsf\" },\n { label: \"Square Feet\", value: \"Sqft\" },\n { label: \"Acreage\", value: \"Acreage\" },\n ],\n value: \"UseCode\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1921,"value":"MAX_Y_SLIDER/* = slider({\n min: 125000,\n max: 1250000,\n step: 25000,\n value: 650000,\n format: \"\",\n title: 'Maximum Assessment',\n description:\n \"Max assessment y-axis value.\"\n})*/","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1262,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1908,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2655,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2679,"value":"all_zones_stripped = {\n var data = _.clone (filter.parcels.features);\n var zones = data.map(d=>d.properties.Zoning);\n zones = zones.map(zone_strip_historic)\n zones = _.uniq(zones)\n zones = zones.sort()\n return zones\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1749,"value":"md`---\n\n---\n\n---\n## Source`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1911,"value":"import {_, AXES, MAX_Y_SLIDER, ROTATE, BACKGROUND_COLOR, TEXT_COLOR, YEAR, LATEST_YEAR, ASSESSMENTS_URL, RESIDENTIAL_URL, COMMERCIAL_URL, ADU_PERMITTED_ZONES, ADU_PROHIBITED_ZONES, toggleRotate, map_rotate, map_display, map_yr_built, map_tooltip, usemap_tooltip, plot_tooltip, tooltip, tooltipString, zone_strip_historic, onMousemove, addLegendGradient, addMeanLine, addMedianLine, iterateResidences, iterateCommercial, iterateTaxYears, getAssessmentPsf, getSqft, getUseCode, getYearBuilt, parcels, assessments, residential_data, commercial_data}\nwith {DARK_MODE as DARK_MODE, CACHE as CACHE, EVEN_MORE_CACHE as EVEN_MORE_CACHE, PARCELS_URL as PARCELS_URL, filter as filter, Y_AXIS as Y_AXIS, sliderOptions as sliderOptions}\nfrom \"@rorystolzenberg/frys-spring-assessment-data\";","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1772,"value":"DARK_MODE = true;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1762,"value":"FILTER_CACHE_URL = \"https://gist.githubusercontent.com/RoryStolzenberg/c30bbee137a974fdc4e5f526cffcb8f9/raw/5d048237046d76f049197b94f9cdc0ed1400821b/frys%2520spring%2520parcels%2520assessments%2520residential.json\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":143,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2435,"value":"sliderOptions = {\n return {\n Acreage: {\n min: 0,\n max: 5,\n step: .05,\n value: 2\n },\n Sqft: {\n min: 1500,\n max: 10000,\n step: 50,\n value: 5100\n },\n Assessment: {\n min: 125000,\n max: 5000000,\n step: 25000,\n value: 650000,\n },\n LandValue: {\n min: 0,\n max: 1000000,\n step: 25000,\n value: 500000,\n },\n AssessmentPsf: {\n min: 250,\n max: 500,\n step: 25,\n value: 500,\n }\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2164,"value":"iterate = function(filter){\n iterateTaxYears(filter);\n iterateResidences(filter);\n iterateCommercial(filter);\n iterateBaseData(filter);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2537,"value":"iterateBaseData= function(filter){ \n const noneFound = [];\n var parcels = {};\n _.forEach(filter.parcels.features,function(d){\n if(typeof parcels[d.properties.ParcelNumber] === 'undefined'){\n parcels[d.properties.ParcelNumber] = [];\n }\n parcels[d.properties.ParcelNumber].push(d);\n });\n _.forEach(filter.base_data.features,function(d){\n var parc = parcels[d.properties.ParcelNumber];\n if(typeof parc === 'undefined'){\n if(noneFound.indexOf(d.properties.ParcelNumber) === -1)\n noneFound.push(d.properties.ParcelNumber)\n return;\n }\n for(var x in parc){\n //parc[x].properties[\"Assessment\"+d.properties.TaxYear] = d.properties.TotalValue;\n parc[x].properties.TaxType = d.properties.TaxType\n }\n });\n console.log(\"none found!\", noneFound);\n return filter.parcels.features\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"yrs = {\n var years = {\n \"2010\": [],\n \"2011\": [],\n \"2012\": [],\n \"2013\": [],\n \"2014\": [],\n \"2015\": [],\n \"2016\": [],\n \"2017\": [],\n \"2018\": [],\n \"2019\": [],\n }\n /*for(var x in years){\n var assessments = _.clone(filter.assessments)\n years[x] = assessments.features.filter(function(d){\n return d.properties.TaxYear == x;\n })\n }*/\n return years;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1513,"value":"missing = {\n var missing = _.clone(yrs);\n //for(var i in missing) missing[i] = [];\n return missing;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1510,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"maps = function(width){\n const maps = {}\n var types = [\"TotalValue\", \"ImprovementValue\", \"LandValue\"];\n for(var x in yrs){\n maps[x] = {};\n for(var y in types){\n maps[x][types[y]] = \"Loading \"+x+\" map...\";\n }\n }\n console.log(missing)\n return maps;\n}(width)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1618,"value":"map_rotate","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2359,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"md`## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"d3 = require(\"https://d3js.org/d3.v5.min.js\", \"d3-color\", \"d3-scale\", \"d3-scale-chromatic\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":602,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":65,"value":"turf = require('https://npmcdn.com/@turf/turf/turf.min.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1629,"value":"import {radio, select, slider} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1633,"value":"/*_ = require(\"underscore\")*/","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1639,"value":"async = require(\"async\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1813,"value":"d3_select = { \n return d3.selection.prototype.selectAppend = function(name) {\n var select = d3.selector(name),\n create = d3.creator(name);\n return this.select(function() {\n return select.apply(this, arguments)\n || this.appendChild(create.apply(this, arguments)); \n });\n };\n};","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1648,"value":"//PARCELS_URL = \"https://gist.githubusercontent.com/RoryStolzenberg/8fea9c5fc502828cde137474761a5ad7/raw/e6dbcaefcf005c66a20b25914635fddc072c7bc2/parcels.json\";\nPARCELS_URL = \"https://opendata.arcgis.com/datasets/0e9946c2a77d4fc6ad16d9968509c588_72.geojson\";","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2531,"value":"BASE_DATA_URL = \"https://opendata.arcgis.com/datasets/bc72d0590bf940ff952ab113f10a36a8_8.geojson\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1660,"value":"//ASSESSMENTS_URL = \"https://opendata.arcgis.com/datasets/b993cd4e2e1b4ba097fb58c90725f5da_2.geojson\"\n//ASSESSMENTS_URL = \"https://cors-anywhere.herokuapp.com/https://opendata.arcgis.com/datasets/b993cd4e2e1b4ba097fb58c90725f5da_2.geojson\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1661,"value":"//RESIDENTIAL_URL = \"https://opendata.arcgis.com/datasets/c7adfdab73104a01a485dec324adcafb_17.geojson\"\n//RESIDENTIAL_URL = \"https://cors-anywhere.herokuapp.com/https://opendata.arcgis.com/datasets/c7adfdab73104a01a485dec324adcafb_17.geojson\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2002,"value":"//COMMERCIAL_URL = \"https://opendata.arcgis.com/datasets/17fbd0c459d84c71aa37b436d5231c0b_19.geojson\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1647,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1664,"value":"//assessments = (EVEN_MORE_CACHE ? {type: \"FeatureCollection\", features: []} : d3.json(ASSESSMENTS_URL))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1669,"value":"//residential_data = (EVEN_MORE_CACHE ? {type: \"FeatureCollection\", features: []} : d3.json(RESIDENTIAL_URL))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2005,"value":"//commercial_data = (EVEN_MORE_CACHE ? {type: \"FeatureCollection\", features: []} : d3.json(COMMERCIAL_URL))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2529,"value":"base_data = (EVEN_MORE_CACHE ? {type: \"FeatureCollection\", features: []} : d3.json(BASE_DATA_URL))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1680,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":648,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":721,"value":"public_spaces = {\n return[\"190034000\", \"180039400\", \"200066000\", \"180038000\", \"210089000\", \"210087000\", \"190032000\", \"190032100\", \"190033000\", \"190080000\", \"190035390\", \"190035250\", \"190010100\", \"18A046000\", \"200278000\", \"21B001000\", \"21B016000\", \"21A129000\", \"200271000\"]\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":729,"value":"commercial = {\n return [\"21B004600\", \"21B004100\", \"21B004400\", \"21B004500\", \"21B003000\", \"21B003A00\", \"21B004700\", \"21B002100\", \"21B004000\", \"21B002A00\", \"21B002200\", \"21B004200\", \"21B002000\"]\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":732,"value":"vacant = {\n return [\"21A100002\", \"21A100003\", \"21A100004\", \"21A100005\", \"21A100006\", \"21A100007\", \"200121000\", \"200122000\", \"200125000\", \"200126000\", \"200129000\", \"200131100\", \"200131200\", \"200142000\", \"200143000\", \"200144000\", \"200145000\", \"200146000\", \"200147000\", \"200148000\", \"200196000\", \"200259260\", \"200259270\", \"200259280\", \"200259290\", \"200259301\", \"200259310\", \"200259320\", \"200259330\", \"200259340\", \"200259350\", \"200259370\", \"200259380\"];\n} ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2503,"value":"total_total = {\n var data = _.clone(filter.parcels.features);\n data = data.filter(d => d.properties.TaxType == \"Taxable\");\n var assessments = data.map(d=>d.properties.Assessment)\n return d3.format(\"$,\")(assessments.reduce((total, currentVal) => total+currentVal))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2474,"value":"sfd_total = {\n var data = _.clone(filter.parcels.features);\n data = data.filter(d=>[\"Single Family\", \"Single Family + ADU(s)\"].indexOf(getUseCode(d, true, true)) !== -1)\n data = data.filter(d => d.properties.TaxType == \"Taxable\");\n var assessments = data.map(d=>d.properties.Assessment)\n return d3.format(\"$,\")(assessments.reduce((total, currentVal) => total+currentVal))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2525,"value":"sfa_total = {\n var data = _.clone(filter.parcels.features);\n data = data.filter(d=>[\"Single Family Attached\"].indexOf(getUseCode(d, true, true)) !== -1)\n data = data.filter(d => d.properties.TaxType == \"Taxable\");\n var assessments = data.map(d=>d.properties.Assessment)\n return d3.format(\"$,\")(assessments.reduce((total, currentVal) => total+currentVal))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2483,"value":"non_sfd_res_plus_apts_total = {\n var data = _.clone(filter.parcels.features);\n data = data.filter(d=>[\"Single Family\", \"Single Family + ADU(s)\"].indexOf(getUseCode(d, true, true)) === -1 && (d.properties.Residential || getUseCode(d, true, true) == \"Apartments\"))\n data = data.filter(d => d.properties.TaxType == \"Taxable\");\n var assessments = data.map(d=>d.properties.Assessment)\n return d3.format(\"$,\")(assessments.reduce((total, currentVal) => total+currentVal))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2497,"value":"commercial_non_apt_total = {\n var data = _.clone(filter.parcels.features);\n data = data.filter(d=>d.properties.Commercial && getUseCode(d, true, true) != \"Apartments\")\n data = data.filter(d => d.properties.TaxType == \"Taxable\");\n var assessments = data.map(d=>d.properties.Assessment)\n return d3.format(\"$,\")(assessments.reduce((total, currentVal) => total+currentVal))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2557,"value":"commercial_total = {\n var data = _.clone(filter.parcels.features);\n data = data.filter(d=>d.properties.Commercial)\n data = data.filter(d => d.properties.TaxType == \"Taxable\");\n var assessments = data.map(d=>d.properties.Assessment)\n return d3.format(\"$,\")(assessments.reduce((total, currentVal) => total+currentVal))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2479,"value":"non_sfd_total = {\n var data = _.clone(filter.parcels.features);\n data = data.filter(d=>[\"Single Family\", \"Single Family + ADU(s)\"].indexOf(getUseCode(d, true, true)) === -1)\n data = data.filter(d => d.properties.TaxType == \"Taxable\");\n var assessments = data.map(d=>d.properties.Assessment)\n return d3.format(\"$,\")(assessments.reduce((total, currentVal) => total+currentVal))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2508,"value":"wtf_total = {\n var data = _.clone(filter.parcels.features);\n return data = data.filter(d=>[\"Single Family\", \"Single Family + ADU(s)\"].indexOf(getUseCode(d, true, true)) === -1 && ((d.properties.Residential && d.properties.Commercial)))\n data = data.filter(d => d.properties.TaxType == \"Taxable\");\n var assessments = data.map(d=>d.properties.Assessment)\n return d3.format(\"$,\")(assessments.reduce((total, currentVal) => total+currentVal))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2604,"value":"total_square_footage = {\n var data = _.clone(filter.parcels.features);\n return data.reduce((a,v) => { \n return (v.properties.TaxType == \"Taxable\" && v.properties.SquareFootageFinishedLiving ? a+v.properties.SquareFootageFinishedLiving : a) \n },0) \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2614,"value":"total_taxable = {\n var data = _.clone(filter.parcels.features);\n return data.reduce((a,v) => { \n return (v.properties.TaxType == \"Taxable\" && v.properties.SquareFootageFinishedLiving && v.properties.Assessments && v.properties.Assessments['2019'] ? a+v.properties.Assessments['2019'].ImprovementValue : a) \n },0) \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2617,"value":"total_taxable_psf = {\n var data = _.clone(filter.parcels.features);\n return data.reduce((a,v) => { \n return (v.properties.TaxType == \"Taxable\" && v.properties.SquareFootageFinishedLiving && v.properties.Assessments && v.properties.Assessments['2019'] ? a+(v.properties.Assessments['2019'].ImprovementValue/v.properties.SquareFootageFinishedLiving) : a) \n },0) \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2621,"value":"total_taxable_lotsf = {\n var data = _.clone(filter.parcels.features);\n return data.reduce((a,v) => { \n return (v.properties.TaxType == \"Taxable\" && v.properties.lot_sf && v.properties.Assessments['2019'].ImprovementValue ? a+(v.properties.Assessments['2019'].ImprovementValue/v.properties.lot_sf) : a) \n },0) \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2576,"value":"import {serialize} from \"@palewire/saving-csv\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2574,"value":"$3a","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2600,"value":"//DOM.download(serialize(dl), null, \"Download CSV\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3b","stdlib":"1"}} 2f:"$2e:body"