2a:null 2b:["$","title",null,{"children":"Charlottesville Assessment Data | Rory Stolzenberg | Observable"}] 30:T1955,plot = { var residentialUses = ["Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion", "Single Family + ADU(s)", "Single Family Attached", "Duplex", "Triplex", "Quadplex", "Three-Level Split", "Four-Level Split", "Condominium", "Apartments 1-10 units"]; var data = _.clone(filter.parcels.features); data = data.filter(function(d){ var sqft = getSqft(d); var acreage = turf.area(d)/4046.86; if(d.properties.YearBuilt == 2109) return false 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 && getYearBuilt(d) >= 1900 && //acreage < .4 && acreage > .3 && // ["Single Family", "Single Family + ADU(s)", "Condominium", "Duplex"].indexOf(getUseCode(d,true, true)) === -1 && true; }); 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) axes[Y_AXIS].dotSize = 1 // 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:T29d5,use_map = { var COLOR_KEY = 'UseCode'; var data = _.clone(filter.parcels.features); // data = data.filter(function(d){ // return typeof d.properties.Assessments !== 'undefined' && typeof d.properties.Assessments["2024"] !== 'undefined' && d.properties.Assessments["2024"].ImprovementValue < 20000 // }) data = data.filter(function(d){ if (typeof d.properties.UseCode === 'undefined') return false; // return getUseCode(d, true).indexOf("Vacant") !== -1 || getUseCode(d, true).indexOf("Parking Lot") !== -1; // return getUseCode(d, true).indexOf("Apartments") !== -1; return public_spaces.indexOf(d.properties.ParcelNumber) === -1 && commercial.indexOf(d.properties.ParcelNumber) === -1 && typeof getUseCode(d, true) !== 'undefined' && (d.properties.Residential === true || (d.properties.Commercial === true && ( getUseCode(d, true).indexOf("Apartments") !== -1 || getUseCode(d, true).indexOf("Res Units") !== -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.UseCode.indexOf("Cemetery") === -1 && // ( // d.properties.StreetName.indexOf("OBSERVATORY") !== -1 || // d.properties.StreetName.indexOf("WASHINGTON") !== -1 || // d.properties.StreetName.indexOf("HARMON") !== -1 || // d.properties.StreetName.indexOf("DUNOVA") !== -1 || // d.properties.StreetName.indexOf("CHELSEA") !== -1 || // d.properties.StreetName.indexOf("MONTEBELLO") !== -1 || // d.properties.StreetName.indexOf("SHAMROCK") !== -1 || // d.properties.StreetName.indexOf("STADIUM") !== -1 // ) && // d.properties.Neighborhood == "Jefferson Park Avenue" && // ['160024000', '160019000', '160021000', '160020000', '160027000', '160026000', '160018100', '160018000', '160017000', '160030000', '160031000', '160032000', '160042000', '160041000', '160043300', '160040000', '160040200', '160040100', '160039000', '170111000', '170110000', '170109000', '170094000', '170108000', '170095000', '170107000', '170105000', '170096000', '170106000', '170097000', '170098000', '170099000', '160017001', '160017002', '160022000', '160023000', '160025100', '160025000', '160028000', '160029000', '160043100', '160043600', '160044000', '160045000', '160070000', '160046000', '160071000', '160047000', '160072000', '160069000', '160048000', '160074000', '160066000', '160075000', '160050000', '160066100', '160076000', '160064000', '170113000', '170112000', '160065100', '160064100', '160043000', '160043200', '160043500', '160043400', '160073000', '160067000', '160079000', '160065000', '160077000', '160082000', '160078000', '170114000', '160083000', '160081000', '170115000', '160086000', '160084000', '170116000', '160085000'].indexOf(d.properties.ParcelNumber) !== -1 && // d.properties.OwnerName.indexOf("LLC") !== -1 && // d.properties.OwnerName.indexOf("SILK PURSE") === -1 && // d.properties.OwnerName.indexOf("DOGWOOD PROP") === -1 && // (new Date(d.properties.LastSaleDate).getTime() > new Date(new Date().setFullYear(new Date().getFullYear() - 5))) && // d.properties.lot_sf < 8125*2 && // // d.properties.lot_sf > 12000 && // getUseCode(d, true, true).indexOf("Single Family") != -1 && // getUseCode(d, true, true) !== "Single Family Attached" && // d.properties.Zoning.indexOf("R-1") !== -1 && // d.properties.Zoning.indexOf("R-1S") == -1 && // d.properties.UseCode.indexOf("Apartments") !== -1 && // d.properties.UseCode.indexOf("Mixed Retail") !== -1 && // d.properties.Zoning.indexOf("R-1") !== -1 && // getUseCode(d, true, true).indexOf("ADU") !== -1 && // getUseCode(d) !== "Single Family" && // getUseCode(d) !== "Single Family-1 Conversion" && // (d.properties.Zoning.indexOf("U") !== -1 || d.properties.UseCode.indexOf("1 Con") === -1) && // d.properties.YearBuilt == 2020 && // d.properties.YearBuilt > 2010 && // d.properties.YearBuilt == 2019 && // d.properties.SquareFootageFinishedLiving < 1400 && d.properties.SquareFootageFinishedLiving > 1200 && // d.properties.YearBuilt > 2000 && // d.properties.lot_sf > 10000 && d.properties.lot_sf < 16000 && // (typeof d.properties.Assessments['2010'] !== "undefined" && // d.properties.Assessments['2020']['ImprovementValue']/d.properties.Assessments['2010']['ImprovementValue'] >= 2.5) && // d.properties.Zoning.indexOf("R-1") !== -1 && // d.properties.Assessments['2020']['ImprovementValue'] > 300000 && // d.properties.Assessments['2020']['TotalValue'] > 400000 && // d.properties.UseCode.indexOf("Single") !== -1 && // d.properties.UseCode.indexOf("Condo") !== -1 && // d.properties.UseCode.indexOf("Mortuary") !== -1 && true//d.properties.ResidentialDetails.YearBuilt != "0"; }); console.log(data) 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 * 0.8; 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]; console.log("b",b) projection .scale(s) .translate(t) svg.append("path") .datum(graticule) .attr("class", "graticule") .attr("d", path); var hoods = svg.append("g") .selectAll("path") .data(neighborhoods.features) .enter().append("path") .attr("d", path) .style('stroke', d=> "#444") // var colors = ["Single Family", "Single Family Attached", "Duplex", "Apartments 1-10 units", "Apartments 11-20 Units", "Apartments over 20 units"] var colors = ["Single Family", "Duplex", "Apartments 1-10 units"] _.each(colors, d => axes[COLOR_KEY].color(d)) var lots = svg.append("g") .selectAll("path") .data(data) .enter().append("path") .attr("d", path) .style('fill', function(d){ // if (getUseCode(d) == "Single Family") // return "#fcfcb4"; // if (d.properties.Zoning.indexOf("U") === -1 && getUseCode(d).indexOf("1 Con") !== -1) // return "#fcfcb4"; // if (getUseCode(d) == "Rectory") // return "#fcfcb4"; // if (getUseCode(d) == "Quadplex") // return "#97DF89"; var code = getUseCode(d,false); 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); console.log("domain", axes[COLOR_KEY].color.domain()) console.log(d3.schemeCategory10); 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("Residential Parcels by Use"); svg.call(d3.zoom() .extent([[0, 0], [width, height]]) .scaleExtent([1, 8]) .on("zoom", function() { hoods.attr("transform", d3.event.transform); lots.attr("transform", d3.event.transform); })); 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:T157d,AXES = function(data){ var AXES = { 'UseCode': { color: d3.scaleOrdinal(["#fcfcb4"].concat(d3.schemeCategory10)), fillColor: function(d) { if(typeof d.properties.UseCode === 'undefined'){console.log('no use code',d); return "#0000ff";} if(vacant.indexOf(d.ParcelNumber) !== -1 || d.properties.UseCode.indexOf("Vacant") !== -1){ return "#cccccc"; } return AXES['UseCode'].color(AXES['UseCode'].fn(d)); }, legendFormat: function(d){return d}, legendOffsetX: -width/8, sortNum: function(d){ switch(getUseCode(d, true, false)){ 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 + ADU(s)" : return 1.4; //case "Single Family Attached" : return 2; case "Duplex" : return 2.1; case "Triplex" : return 3; case "Single Family Attached" : return 3.5; case "Quadplex" : return 4; case "Apartments" : return 5; case "Condominium" : return 6; default: return 7 /*case "Single Family" : return 2; case "Single Family-1 Conversion" : return 8; case "Single Family-2 Conversion" : return 9; case "Single Family-3 Conversion" : return 10; case "Single Family Attached" : return 5; case "Duplex" : return 1; case "Triplex" : return 3; case "Quadplex" : return 6; case "Apartments" : return 7; case "Condominium" : return 4; default: return 11*/ } }, name: "Home Type", fn: function(d) { return getUseCode(d, true, true) }, }, 'Assessment': { color: d3.scaleSequential(d3.interpolateRdYlGn).domain([124800, 450000].reverse()), domain: [124800, 450000], dotSize: 2, fillColor: function(d) { return AXES['Assessment'].color(AXES['Assessment'].fn(d)); }, format: d3.format("$,d"), legendFormat: d3.format("$0.3s"), legendOffsetX: -Math.round(width/8), legend: addLegendGradient, tickFormat: d3.format("$0.3s"), name: "Assessments", fn: d => d.properties.Assessment, }, 'AssessmentPsf': { color: d3.scaleSequential(d3.interpolateRdYlGn).domain(d3.extent(data, getAssessmentPsf).reverse()), dotSize: 2, fillColor: function(d) {return AXES['AssessmentPsf'].color(getAssessmentPsf(d)); }, legendFormat: d3.format("$.0f"), legendOffsetX: -Math.round(width/50), tickFormat: d3.format("$.0f"), name: "Assessment per Sq Ft", nice: true, fn: getAssessmentPsf, }, 'LandValue': { color: d3.scaleSequential(d3.interpolateRdYlGn).domain(d3.extent(data, d => (typeof d.properties.Assessments === 'undefined' || typeof d.properties.Assessments[CURRENT_YEAR] === 'undefined' ? null : d.properties.Assessments[CURRENT_YEAR].LandValue)).reverse()), dotSize: 2, fillColor: function(d) { return AXES['LandValue'].color((typeof d.properties.Assessments[CURRENT_YEAR] === 'undefined' ? null : d.properties.Assessments[CURRENT_YEAR].LandValue)); }, format: d3.format("$,d"), legendFormat: d3.format("$0.3s"), legendOffsetX: -Math.round(width/8), legend: addLegendGradient, tickFormat: d3.format("$0.3s"), name: "Land Value", fn: d => (d.properties.Assessments ? d.properties.Assessments[CURRENT_YEAR].LandValue : null), }, 'Sqft': { color: d3.scaleSequential(d3.interpolateRdYlGn).domain(d3.extent([600,2200]).reverse()), //color: d3.scaleSequential(d3.interpolateRdYlGn).domain(d3.extent(data, getSqft).reverse()), dotSize: 2, fillColor: function(d) {return AXES['Sqft'].color(getSqft(d)); }, legendFormat: d3.format(",d"), legendOffsetX: -120, tickFormat: d3.format(","), name: "Square Ft", fn: getSqft, }, 'SqftLand': { color: d3.scaleSequential(d3.interpolateRdYlGn).domain(d3.extent(data, d => turf.area(d)*10.7639).reverse()), //color: d3.scaleSequential(d3.interpolateRdYlGn).domain(d3.extent(data, getSqft).reverse()), dotSize: 2, fillColor: function(d) {return AXES['Sqft'].color(AXES['Acreage'].fn(d)); }, format: d3.format(",d"), legendFormat: d3.format(","), legendOffsetX: -120, tickFormat: d3.format(",d"), name: "Lot Sq Ft", fn: d => turf.area(d)*10.7639, }, 'Acreage': { color: d3.scaleSequential(d3.interpolateRdYlGn).domain(d3.extent(data, d => turf.area(d)/4046.86).reverse()), //color: d3.scaleSequential(d3.interpolateRdYlGn).domain(d3.extent(data, getSqft).reverse()), dotSize: 2, fillColor: function(d) {return AXES['Sqft'].color(AXES['SqftLand'].fn(d)); }, legendFormat: d3.format("0.3f"), legendOffsetX: -120, tickFormat: d3.format(","), name: "Acreage", fn: d => turf.area(d)/4046.86, }, }; for(const x in AXES){ if(typeof AXES[x].format == 'undefined') AXES[x].format = AXES[x].legendFormat; if(typeof AXES[x].sortNum == 'undefined') AXES[x].sortNum = AXES[x].fn; if(typeof AXES[x].fnLimited == 'undefined'){ AXES[x].fnLimited = d => { if(Y_AXIS == x && AXES[x].fn(d) > MAX_Y) return MAX_Y; return AXES[x].fn(d); }; } } return AXES; };34:T612,iterateSales = function(filter){ const noneFound = []; var parcels = {}; _.forEach(filter.parcels.features,function(d){ if(typeof parcels[d.properties.ParcelNumber] === 'undefined'){ parcels[d.properties.ParcelNumber] = []; } parcels[d.properties.ParcelNumber].push(d); }); _.forEach(filter.sales.features,function(d){ var parc = parcels[d.properties.ParcelNumber]; if(typeof parc === 'undefined'){ if(noneFound.indexOf(d.properties.ParcelNumber) === -1) noneFound.push(d.properties.ParcelNumber) return; } for(var x in parc){ //parc[x].properties["Assessment"+d.properties.TaxYear] = d.properties.TotalValue; if(typeof parc[x].properties["Sales"] === 'undefined'){ parc[x].properties["Sales"] = []; } parc[x].properties["Sales"].push(d.properties); if(d.properties.SaleAmount != 0){ if(typeof parc[x].properties["LastSale"] === 'undefined'){ parc[x].properties["LastSale"] = d.properties.SaleAmount; parc[x].properties["LastSaleDate"] = d.properties.SaleDate; }else{ var thisSale = new Date(d.properties.SaleDate); var oldLast = new Date(parc[x].properties["LastSaleDate"]); if(thisSale.getTime() > oldLast.getTime()){ parc[x].properties["LastSale"] = d.properties.SaleAmount; parc[x].properties["LastSaleDate"] = d.properties.SaleDate; } } } } }); console.log("none found!", noneFound); return filter.parcels.features }35:T5a8,units_by_use = (d, count_adus) => { // return 1 count_adus = typeof count_adus === 'undefined' ? false : count_adus; if(!count_adus && d.properties.UseCode.indexOf("Conversion") !== -1) return 1; if(d.properties.UseCode == "Single Family") return 1; if(d.properties.UseCode == "Single Family Attached") return 1; if(d.properties.UseCode == "Condominium") return 1; if(d.properties.UseCode == "Single Family-1 Conversion") return 2; if(d.properties.UseCode == "Duplex") return 2; if(d.properties.UseCode == "Triplex") return 3; if(d.properties.UseCode == "Single Family-2 Conversion") return 3; if(d.properties.UseCode == "Single Family-3 Conversion") return 4; if(d.properties.UseCode == "Quadplex") return 4; if(d.properties.ParcelNumber == "40C016000" && d.properties.UseCode == "Three-Level Split") return 4; // 1919 Swanson - per master address table if(d.properties.ParcelNumber == "400009000" && d.properties.UseCode == "Four-Level Split") return 1; // 1412 Meadowbrook - per master address table if(getUseCode(d, true, true) == "Apartments"){ console.log('Unknown apartment count for UseCode:', d.properties.UseCode, d.properties) return 0 } // if(d.properties.StreetNumber == "214") // return 6; // if(d.properties.StreetNumber == "207") // return 10; console.log('Unknown unit count for UseCode:',d.properties.UseCode, d) return 0 };36:T3a83,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") .attr("fill", BACKGROUND_COLOR) .on("click", toggleRotate); let projection = d3.geoAlbers(); const path = d3.geoPath().projection( projection ) const graticule = d3.geoGraticule() var green = true; var HIGHLIGHT_MULTIFAM = false; var data = filter.parcels.features; data = data.filter(d=> typeof d.properties.Assessments !== 'undefined') // data = data.filter(d=> { // return typeof d.properties.Neighborhood !== 'undefined' && // ["Starr Hill","Belmont","Ridge Street","Fry's Spring","10th & Page","Venable","Fifeville"].indexOf(d.properties.Neighborhood) !== -1 && // (["Fifeville"].indexOf(d.properties.Neighborhood) !== -1 || // d.properties.StreetName =="VALLEY RD EXT" // ) // }) // data = data.filter(d=> d.properties.Assessment < 350000) // data = data.filter(d=> d.properties.Residential && d.properties.UseCode.indexOf("Condo") == -1 && d.properties.UseCode !== "Vacant Land" && [4227,1789,10115,10171,15066,4828,4899].indexOf(d.properties.GeoParcelIdentificationNumber) == -1) //data = data.filter(d=> d.properties.Assessment > 900000) // data = data.filter(d=> d.properties.Assessment < 1100000) // data = data.filter(d=> d.properties.YearBuilt > 2010) /*data = data.filter(d => { var use = getUseCode(d, true, true) return true && // use !== "Single Family" && // use !== "Single Family + ADU(s)" && use !== "Condominium" && d.properties.Residential && uncountable_res_uses.indexOf(getUseCode(d, true, true)) === -1 && true; })*/ // if(HIGHLIGHT_MULTIFAM == 1){ // sort by use if we're putting stroke on multi-units, so they can rise to top // var is_multi = d => { // if(typeof d.properties.UseCode === 'undefined') return false; // if(d.properties.Residential != true || getUseCode(d,true,true) == "Apartments") return false; // if(nonres_uses.indexOf(getUseCode(d, true, true)) !== -1) return false; // return units_by_use(d) > 1 || ["Condominium","Single Family Attached"].indexOf(getUseCode(d, true, true)) !== -1; // } // var multi = data.filter(is_multi); // var nonmulti = data.filter(d => !is_multi(d)); // console.log('data recombination', data,multi,nonmulti) // data = nonmulti.concat(multi) // console.log(data) // console.log(data.map(getUseCode)) // } console.log('all uses', _.uniq(data.map(getUseCode))) /*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 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 && uncountable_res_uses.indexOf(getUseCode(d, true, true)) === -1 && true; }); console.log('residentialParcels parcel count:', residentialParcels.length, // "unit count:", // residentialParcels.reduce((acc, d) => acc+units_by_use(d),0), // "count w adus:", // residentialParcels.reduce((acc, d) => acc+units_by_use(d,true), 0) ) var scaleParcels = 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 && uncountable_res_uses.indexOf(getUseCode(d, true, true)) === -1 && // ["Single Family", "Single Family + ADU(s)"].indexOf(getUseCode(d,true, true)) !== -1 && true; }); console.log('scaleParcels unit count', scaleParcels.length, scaleParcels.reduce((acc, d) => acc+units_by_use(d), 0)) // scaleParcels = scaleParcels.filter(d => ) var scalevals = []; scalevals = scaleParcels.map(d => { //use LATEST_YEAR so scale stays across years var ass = parseInt(d.properties.Assessments[LATEST_YEAR][ASSESSMENT_TYPE]); var units = units_by_use(d, false); return ass / units; }) // scaleParcels.forEach(d => scalevals.push(fn(d))) // console.log('scaleParcels', scaleParcels.filter(d=> { // return fn(d) <= 65000//71000 // return getUseCode(d).indexOf("Single") === -1 && // getUseCode(d).indexOf("Condo") === -1 && // getUseCode(d).indexOf("Duplex") === -1 // }).map(d=> tooltipString(d, YEAR))) scalevals = scalevals.sort((a, b) => a-b); console.log('scalevals',scalevals); console.log('scalevals median:', d3.median(scalevals), 'std:', d3.deviation(scalevals)) console.log('scalevals low:', scalevals[0], 'high:', scalevals[scalevals.length-1]) var start = d3.quantile(scalevals, .05) //scalevals[0]; var end = d3.quantile(scalevals, .8)//(d3.median(scalevals) - start) + d3.median(scalevals);//d3.quantile(scalevals, .90) //top 10% is red var domain = [start, end];//[ d3.min(residentialParcels, fn), d3.max(residentialParcels, fn)] //_.clone(axis.domain); //console.log('domain', domain); // data = data.filter(d => { // var use = getUseCode(d, true, true) // return true && // typeof use !== 'undefined' && // d.properties.lot_sf < 8125*2 && // // d.properties.lot_sf > 12000 && // use.indexOf("Single Family") != -1 && // use !== "Single Family Attached" && // d.properties.Zoning.indexOf("R-1") !== -1 && // d.properties.Zoning.indexOf("R-1S") == -1 && // true; // }) var opacityFunction = (d) => { // var use = getUseCode(d, true, true) // var lot_sf = (d.properties.LotSquareFeet > 100 ? d.properties.LotSquareFeet : d.properties.lot_sf) // if (true && // typeof use !== 'undefined' && // // d.properties.lot_sf < 8125*2 && // // d.properties.lot_sf > 6000*2 && // // d.properties.lot_sf > 6000 && // // d.properties.lot_sf > 6000 && // // d.properties.lot_sf < 8125 && // lot_sf > 6000*2 && // // d.properties.lot_sf > 6000*2 && // is_r1_sfd(d) && // // d.properties.Zoning.indexOf("R-1") !== -1 && // // d.properties.Zoning.indexOf("R-1S") == -1 && // d.properties.Zoning.indexOf("R-1S") !== -1 && // true) { return "100%"; // } // return "12%"; } 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) || (parcel.properties.Residential && nonres_uses.indexOf(getUseCode(parcel, true, true)) !== -1) ){ var hi = 3000000 var lo = 200000 if(assessment > hi) assessment = hi else if(assessment < lo) assessment = lo //return "#cccccc" assessment = (assessment - lo)/(hi - lo) return d3.interpolatePuBu(assessment) }else if(parcel.properties.Residential){ var units = 1; if(uncountable_res_uses.indexOf(getUseCode(parcel, true, true)) === -1){ units = units_by_use(parcel, false) } assessment = assessment / units // var hi = 600000 // var lo = 100000 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) }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 hoods = svg.append("g") .selectAll("path") .data(neighborhoods.features) .enter().append("path") .attr("d", path) .style('stroke', d=> "#444") var defaultStroke = (DARK_MODE ? BACKGROUND_COLOR : TEXT_COLOR); //var newBuildStroke = "#0055ff" var lots = svg.append("g") .selectAll("path") .data(data) .enter().append("path") .attr("d", path) .style('fill', fillColor) .style('fill-opacity', opacityFunction) // .style('stroke', defaultStroke) // .style('stroke-width', strokeWidth) .style('stroke', d => { if(HIGHLIGHT_MULTIFAM == false) return defaultStroke; if (d.properties.Commercial) return defaultStroke; if (d.properties.Residential != true) return defaultStroke; if (uncountable_res_uses.indexOf(getUseCode(d, true, true)) !== -1) return defaultStroke; if (units_by_use(d, false) > 1 ) return "#ddd"; if (["Condominium","Single Family Attached"].indexOf(getUseCode(d, true, true)) !== -1) return "#ddd"; return defaultStroke }) .style('stroke-width', strokeWidth/1.5) /*.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 => { var gpin = d.properties.GeoParcelIdentificationNumber; var coterm = data.filter(p => p.properties.GeoParcelIdentificationNumber == gpin) var html = ""; for(var x in coterm){ html += tooltipString(coterm[x],YEAR); html += "
" } map_tooltip.style("visibility", "visible").html(html) return true; }) .on("mousemove", onMousemoveTooltip(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 + " Assessments: "); 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 => { //use LATEST_YEAR so scale stays across years var ass = parseInt(d.properties.Assessments[YEAR][ASSESSMENT_TYPE]); var units = units_by_use(d, false); return ass / units; }) // d => (d.properties.Assessments[YEAR] ? d.properties.Assessments[YEAR][ASSESSMENT_TYPE] : null) } addLegendGradient(svg, axis, legendOptions) svg.call(d3.zoom() .extent([[0, 0], [width, height]]) .scaleExtent([1, 8]) .on("zoom", function() { hoods.attr("transform", d3.event.transform); lots.attr("transform", d3.event.transform); })); return svg.node(); }37:T494,viewof replaced = { var data = filter.parcels.features//.filter(d => getYearBuilt(d) > 1999) var fmt = d3.format("$,.0f"); 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"); replaced = replaced.reverse() console.log(replaced) return tabulate(replaced, ["YearBuilt", "Before", "After", "ImprovementsBefore", "ImprovementsAfter", "UseCode", "ParcelNumber"]); }38: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(); }*/ 39: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); }) );*/3a: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"]; }3b: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", } }3c: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") }3d:T498,sfd_sort_lot_size = { var data = _.clone(filter.parcels.features) var units = data.filter(d => { if (typeof d.properties.UseCode === "undefined") console.log('wtf',d) if (d.properties.TaxType == "Exempt") return false if (d.properties.StreetName == "MIDLAND ST") return false if (d.properties.StreetName == "RIVES ST") return false return d.properties.Residential && d.properties.UseCode.indexOf("Single") !== -1 && d.properties.UseCode.indexOf("Attached") === -1 }) var sorted = units.sort((a, b)=> { return a.properties.lot_sf < b.properties.lot_sf ? -1 : 1 }) sorted.map((d, i) => { // if(d.properties.OwnerName.indexOf("SOLLA") !== -1) // console.log(d, i) if(d.properties.StreetName.indexOf("OAK") !== -1 && d.properties.StreetNumber == 306) console.log(d, i) }) // return sorted //_.groupBy(units, d => d.properties.UseCode) var table = units.map((d, i) => { return {"ParcelNumber": d.properties.ParcelNumber, "Assessment": d3.format("$,")(d.properties.Assessment), "SqFt": d.properties.lot_sf} }) table = table.slice(0,10) return tabulate(table, ["ParcelNumber", "Assessment", "SqFt"]); }3e:T422,sfd_sort_sf_size = { var data = _.clone(filter.parcels.features) var units = data.filter(d => { if (typeof d.properties.UseCode === "undefined") console.log('wtf',d) if (d.properties.TaxType == "Exempt") return false return d.properties.Residential && d.properties.UseCode.indexOf("Single") !== -1 && d.properties.UseCode.indexOf("Attached") === -1 }) var sorted = units.sort((a, b)=> { return a.properties.SquareFootageFinishedLiving < b.properties.SquareFootageFinishedLiving ? 1 : -1 }) sorted.map((d, i) => { // if(d.properties.OwnerName.indexOf("SOLLA") !== -1) // console.log(d, i) if(d.properties.StreetName.indexOf("OAK") !== -1 && d.properties.StreetNumber == 306) console.log(d, i) }) return sorted //_.groupBy(units, d => d.properties.UseCode) var table = units.map((d, i) => { return {"Unit": d.properties.Unit, "Assessment": d3.format("$,")(d.properties.Assessment), "SqFt": d.properties.SquareFootageFinishedLiving} }) return tabulate(table, ["Unit", "Assessment", "SqFt"]); }3f:T50d,new2020 = { var data = _.clone(filter.parcels.features) var newUnits = data.filter(d=> { return getYearBuilt(d) == 2020 && typeof getUseCode(d, true) !== 'undefined' && (d.properties.Residential === true || (d.properties.Commercial === true && ( getUseCode(d, true).indexOf("Apartments") !== -1 || getUseCode(d, true).indexOf("Res Units") !== -1 ) ) ) }) newUnits = newUnits.map(d=> d.properties) newUnits = newUnits.sort((first, sec) => first.LastSale > sec.LastSale ? -1 : 1) function toUpper(str) { return str.toLowerCase().split(' ').map(word => word[0].toUpperCase() + word.substr(1)).join(' '); } newUnits = newUnits.map((d, i) => { var parcel = _.clone(d); parcel.Address = d.StreetNumber + " " + toUpper(d.StreetName) parcel.Assessment = d3.format("$,")(d.Assessment) parcel.LastSale = d3.format("$,")(d.LastSale) parcel.LastSaleDate = (new Date(d.LastSaleDate)).toLocaleDateString() parcel.SqFt = typeof d.SquareFootageFinishedLiving === 'undefined' ? "-" : d3.format(",")(d.SquareFootageFinishedLiving) return parcel }) // return newUnits.length return tabulate(newUnits, ["Address", "UseCode", "Assessment", "LastSale", "LastSaleDate", "SqFt"]); }40:T50b,newbuilds = { var addrs = _.groupBy(newbuildpermits,"ParcelNumber") for(var parc in addrs){ var parcel = _.find(filter.parcels.features, d => d.properties.ParcelNumber == parc) addrs[parc].parcel = parcel addrs[parc].YearBuilt = parcel.properties.YearBuilt addrs[parc].ParcelNumber = parcel.properties.ParcelNumber addrs[parc].StreetAddress = parcel.properties.StreetNumber + " " + parcel.properties.StreetName } addrs = Object.values(addrs) addrs = addrs.filter(d => (d.parcel.properties.Assessments["2021"].ImprovementValue !== 0 && d.YearBuilt > 2000) || ["360040000","570157007","600229000"].indexOf(d.parcel.properties.ParcelNumber) !== -1 ) // addrs = addrs.filter(d => (d.parcel.properties.Assessments["2021"].ImprovementValue !== 0 && d.YearBuilt > 2000) || [].indexOf(d.parcel.properties.ParcelNumber !== -1) ) // return addrs.filter(d => { // console.log(d) // return d.YearBuilt > 2000 // return (d.YearBuilt == "" || d.YearBuilt == null || typeof d.YearBuilt === 'undefined' || d.YearBuilt < 2000) // }) var real = []; for(var parc in addrs){ var permit = addrs[parc][0]; permit.YearBuilt = addrs[parc].YearBuilt real.push(permit) } return real return addrs return Object.keys(addrs).length }41:Tfd5,r1_lot_now_table = { var results = [] var metrics = ["SF", "Count"] var num_fmt = d3.format(',d') var pct_fmt = d3.format('.0%') var names = { "Total":"Total", "Below":"Nonconforming (under 8125sf)", "InRange":"Conforming, not subdividable", "Above":"Conforming, subdividable", } var data = _.clone(r1_lot_sizes_now_r1l) var r1data = data["R-1"]; var totalData = data["Total"]; results.push({ "Status": "R-1 (R-1S + R-1)", "# Parcels": num_fmt(totalData["Total"].Count), "% All R-1": totalData["Total"].PercentOfTotal, "Acres": totalData["Total"].Acres, "Median Assessment": totalData["Total"].MedianAssessment, }) var fields = ["Total","Below","InRange","Above",] fields.forEach(d=>{ results.push({ "Status": (names[d] == "Total" ? "R-1L" : names[d]), "# Parcels": num_fmt(r1data[d].Count), "%": r1data[d].Percent, " ": " ", " ": " ", "% All R-1": r1data[d].PercentOfTotal, "% of Zone Land": r1data[d].PercentLand, "Acres": r1data[d].Acres, "Median Assessment": r1data[d].MedianAssessment, }) }) // results.push({ // "Status": "Total R-1S", // "# Parcels": num_fmt(r1sdata["Total"].Count), // "% All R-1": r1sdata["Total"].PercentOfTotal, // "Acres": r1sdata["Total"].Acres, // "Median Assessment": r1sdata["Total"].MedianAssessment, // }) var names = { "Total":"Total", "Below":"Nonconforming (under 6000sf)", "InRange":"Conforming in R-1S only", "Above":"Conforming in R-1S or R-1L", } // var data = _.clone(r1_lot_sizes_now_r1s) var r1sdata = _.clone(r1_lot_sizes_now_r1s)["R-1S"]; fields.forEach(d=>{ results.push({ "Status": (names[d] == "Total" ? "R-1S" : names[d]), "# Parcels": num_fmt(r1sdata[d].Count), "%": r1sdata[d].Percent, " ": " ", " ": " ", "% All R-1": r1sdata[d].PercentOfTotal, "% of Zone Land": r1sdata[d].PercentLand, "Acres": r1sdata[d].Acres, "Median Assessment": r1sdata[d].MedianAssessment, }) }) return html`

${tabulate(results, Object.keys(results[results.length-3]))}

` }42:Teca,r1_lot_table = { var results = [] var metrics = ["SF", "Count"] var num_fmt = d3.format(',d') var pct_fmt = d3.format('.0%') var names = { "Total":"R-1L", "InRange":"Newly subdividable",// (over 12,000sf, under 16,250sf)", "Above":"Able to subdivide already",// (over 16,250sf)", "Below":"Too small to subdivide",// (under 12,000sf)", } var data = _.clone(r1_lot_sizes) var r1sdata = data["R-1S"]; var r1data = data["R-1"]; var totalData = data["Total"]; results.push({ "Status": "R-1 (R-1S + R-1)", "# Parcels": num_fmt(totalData["Total"].Count), // "% All R-1": totalData["Total"].PercentOfTotal, "Acres": totalData["Total"].Acres, "Median Value": totalData["Total"].MedianAssessment, }) // var fields = ["Total","InRange","Above","Below",] var fields = ["Total","Below","InRange","Above",] fields.forEach(d=>{ results.push({ "Status": names[d], "# Parcels": num_fmt(r1data[d].Count), // "% All R-1": r1data[d].PercentOfTotal, "% R-1L": r1data[d].Percent, " ": " ", // " ": " ", "% R-1L Land": r1data[d].PercentLand, "Acres": r1data[d].Acres, "Median Value": r1data[d].MedianAssessment, }) }) results.push({ "Status": "R-1S", "# Parcels": num_fmt(r1sdata["Total"].Count), // "% All R-1": r1sdata["Total"].PercentOfTotal, "Acres": r1sdata["Total"].Acres, "Median Value": r1sdata["Total"].MedianAssessment, }) // results.push({ // "Status": "Total R-1S", // "# Parcels": num_fmt(r1sdata["Total"].Count), // "% All R-1": r1sdata["Total"].PercentOfTotal, // "Acres": r1sdata["Total"].Acres, // "MedianAssessment": r1sdata["Total"].MedianAssessment, // }) // fields.forEach(d=>{ // results.push({ // "Status": names[d] + " R-1S", // "# Parcels": num_fmt(r1sdata[d].Count), // "% All R-1": r1sdata[d].PercentOfTotal, // "% of Zone": r1sdata[d].Percent, // " ": " ", // "% of Zone Land": r1sdata[d].PercentLand, // "Acres": r1sdata[d].Acres, // "MedianAssessment": r1sdata[d].MedianAssessment, // }) // }) return html`

${tabulate(results, Object.keys(results[results.length-3]))}

` }43:Te49,r1_lot_sizes_see = (cutoff_high,cutoff_low) => { var data = _.clone(r1_parcels) var results = {Total: {}} // var cutoff_high = 8125 //8125*2 // var cutoff_low = 8125 //6000*2 var zone_strip_university = z => (z[z.length-1] == "U" ? z.slice(0, z.length-1) : z) var zones = _.unique(data.map(d=>d.properties.Zoning).map(zone_strip_historic).map(zone_strip_university)) zones.sort() var fields = ["Total","InRange","Above","Below",] var metrics = ["SF", "Count"] zones.forEach(d => { var res = {} fields.forEach(f => res[f] = {SqFt: "", Count: 0, SFs: [], Parcels: [], Assessments: [], SF: 0, DivsHigh: 0, DivsLow: 0,}) results[d] = res }) fields.forEach(f => results["Total"][f] = {SqFt: "", Count: 0, SFs: [], Parcels: [], Assessments: [], SF: 0, DivsHigh: 0, DivsLow: 0,}) // return results // return data.filter(is_uva_parcel) data = data.filter(d=> { var use_code = getUseCode(d, true, true) return is_r1_sfd(d) && // d.properties.lot_sf > 43560 && true; }); // return data.sort((a,b)=>b.properties.lot_sf- a.properties.lot_sf).map(d=>d.properties.OwnerName)//.map(d=>d.properties.lot_sf/43560) data.forEach(d=> { var lot_sf = (d.properties.LotSquareFeet > 100 ? d.properties.LotSquareFeet : d.properties.lot_sf) var zone = zone_strip_historic(d.properties.Zoning); zone = zone_strip_university(zone) var aboveOrBelow = (lot_sf > cutoff_low ? (lot_sf < cutoff_high ? "InRange" : "Above") : "Below") var divsLow = Math.floor(lot_sf / (cutoff_low/2) - 1) results[zone][aboveOrBelow].DivsLow += divsLow < 0 ? 0 : divsLow var divsHigh = Math.floor(lot_sf / (cutoff_high/2) - 1) results[zone][aboveOrBelow].DivsHigh += divsHigh < 0 ? 0 : divsHigh results[zone][aboveOrBelow].Parcels.push(d) results[zone][aboveOrBelow].Assessments.push(d.properties.Assessment) results["Total"][aboveOrBelow].Assessments.push(d.properties.Assessment) if(lot_sf !== 'number'){ console.log("NaN lot size? ",d.properties) } var sf_details = { used: lot_sf, lot_sf:d.properties.lot_sf, LotSquareFeet:d.properties.LotSquareFeet, } results[zone][aboveOrBelow].SF += lot_sf results["Total"][aboveOrBelow].SF += lot_sf results[zone][aboveOrBelow].SFs.push(sf_details) results["Total"][aboveOrBelow].SFs.push(sf_details) results[zone][aboveOrBelow].Count++ results["Total"][aboveOrBelow].Count++ results[zone]["Total"].SF += lot_sf results[zone]["Total"].SFs.push(sf_details) results[zone]["Total"].Count++ results[zone]["Total"].Assessments.push(d.properties.Assessment) results["Total"]["Total"].SF += lot_sf results["Total"]["Total"].Count++ results["Total"]["Total"].Assessments.push(d.properties.Assessment) }) var sf_fmt = d3.format(',d') var pct_fmt = d3.format('.0%') var ass_fmt = d3.format('$,d') Object.keys(results).forEach(z => { fields.forEach(d => { results[z][d].Percent = pct_fmt(results[z][d].Count / results[z]["Total"].Count) results[z][d].PercentOfTotal = pct_fmt(results[z][d].Count / (results["Total"]["Total"].Count)) results[z][d].PercentLand = pct_fmt(results[z][d].SF / results[z]["Total"].SF) results[z][d].PercentLandOfTotal = pct_fmt(results[z][d].SF / results["Total"]["Total"].SF) results[z][d].SqFt = sf_fmt(results[z][d].SF) results[z][d].Acres = sf_fmt(results[z][d].SF/43560) results[z][d].MedianAssessment = ass_fmt(d3.median(results[z][d].Assessments.sort((a,b) => a-b))) }) }) return results return // .length }44:Tc72,lot_sizes_deciles = { var data = _.clone(filter.parcels.features) var results = {Total: {}} // var cutoff_high = 8125 //8125*2 // var cutoff_low = 8125 //6000*2 var zone_strip_university = z => (z[z.length-1] == "U" ? z.slice(0, z.length-1) : z) var zones = _.unique(data.map(d=>d.properties.Zoning).map(zone_strip_historic).map(zone_strip_university)) zones.sort() // return data.filter(is_uva_parcel) var all_sfds = data.filter(d=> { var use_code = getUseCode(d, true, true) var lot_sf = (d.properties.LotSquareFeet > 100 ? d.properties.LotSquareFeet : d.properties.lot_sf) d.properties.better_sf = lot_sf return true && // d.properties.Zoning.indexOf("R-1") !== -1 && typeof use_code !== 'undefined' && use_code.indexOf("Single Family") !== -1 && use_code != "Single Family Attached" && // !is_uva_parcel(d) && // d.properties.OwnerName.indexOf("CITY OF CHARLOTTESVILLE") == -1 && ["120002L00","120003000"].indexOf(d.properties.ParcelNumber) == -1 && //broken wesley methodist parcels d.properties.TaxType != "Exempt" && true; }) var all_r1 = data.filter(d=> { var use_code = getUseCode(d, true, true) return is_r1_sfd(d) && // d.properties.lot_sf > 43560 && true; }) var r1s = all_r1.filter(d=> { // var use_code = getUseCode(d, true, true) return d.properties.Zoning.indexOf("R-1S") !== -1 && // d.properties.lot_sf > 43560 && true; }) var r1l = all_r1.filter(d=> { // var use_code = getUseCode(d, true, true) return d.properties.Zoning.indexOf("R-1S") === -1 && // d.properties.lot_sf > 43560 && true; }) // var wrong_sfds = all_sfds.filter(d=>d.properties.better_sf != d.properties.lot_sf) // wrong_sfds.sort((a,b) => a.properties.better_sf-b.properties.better_sf); // return wrong_sfds[Math.round(wrong_sfds.length/2)] all_sfds = all_sfds.map(d=>d.properties.better_sf).sort((a,b) => a-b); all_r1 = all_r1.map(d=>d.properties.better_sf).sort((a,b) => a-b); r1s = r1s.map(d=>d.properties.better_sf).sort((a,b) => a-b); r1l = r1l.map(d=>d.properties.better_sf).sort((a,b) => a-b); var deciles = [.1,.2,.3,.4,.5,.6,.7,.8,.9] var results = []; var fmt = d3.format(",d") for(var d in deciles){ results.push({ "Decile": deciles[d]*100+"%", "All SFDs": fmt(d3.quantile(all_sfds, deciles[d])), "All R-1": fmt(d3.quantile(all_r1, deciles[d])), "R-1S Small-Lot": fmt(d3.quantile(r1s, deciles[d])), "R-1 Large-Lot": fmt(d3.quantile(r1l, deciles[d])), }) } return html`

${tabulate(results, Object.keys(results[results.length-3]))}

` // return tabulate(results, Object.keys(results[results.length-1])) // return results; } 45:T18be,all_residential_parcels = { var data = _.clone(filter.parcels.features); data = data.filter(function(d){ if (typeof d.properties.UseCode === 'undefined') return false; // return getUseCode(d, true).indexOf("Vacant") !== -1 || getUseCode(d, true).indexOf("Parking Lot") !== -1; // return getUseCode(d, true).indexOf("Apartments") !== -1; return public_spaces.indexOf(d.properties.ParcelNumber) === -1 && commercial.indexOf(d.properties.ParcelNumber) === -1 && typeof getUseCode(d, true) !== 'undefined' && (d.properties.Residential === true || (d.properties.Commercial === true && ( getUseCode(d, true).indexOf("Apartments") !== -1 || getUseCode(d, true).indexOf("Res Units") !== -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.UseCode.indexOf("Cemetery") === -1 && // d.properties.UseCode.indexOf("Common") === -1 && // d.properties.UseCode.indexOf("Condo") === -1 && // ( // d.properties.UseCode.indexOf("Single") !== -1 || // d.properties.UseCode.indexOf("Single") !== -1 // // d.properties.UseCode.indexOf("plex") !== -1 && // )&& // d.properties.UseCode.indexOf("ttach") === -1 && d.properties.ParkingPermitArea !== null && // ( // d.properties.StreetName.indexOf("OBSERVATORY") !== -1 || // d.properties.StreetName.indexOf("WASHINGTON") !== -1 || // d.properties.StreetName.indexOf("HARMON") !== -1 || // d.properties.StreetName.indexOf("DUNOVA") !== -1 || // d.properties.StreetName.indexOf("CHELSEA") !== -1 || // d.properties.StreetName.indexOf("MONTEBELLO") !== -1 || // d.properties.StreetName.indexOf("SHAMROCK") !== -1 || // d.properties.StreetName.indexOf("STADIUM") !== -1 // ) && // d.properties.Neighborhood == "Jefferson Park Avenue" && // ['160024000', '160019000', '160021000', '160020000', '160027000', '160026000', '160018100', '160018000', '160017000', '160030000', '160031000', '160032000', '160042000', '160041000', '160043300', '160040000', '160040200', '160040100', '160039000', '170111000', '170110000', '170109000', '170094000', '170108000', '170095000', '170107000', '170105000', '170096000', '170106000', '170097000', '170098000', '170099000', '160017001', '160017002', '160022000', '160023000', '160025100', '160025000', '160028000', '160029000', '160043100', '160043600', '160044000', '160045000', '160070000', '160046000', '160071000', '160047000', '160072000', '160069000', '160048000', '160074000', '160066000', '160075000', '160050000', '160066100', '160076000', '160064000', '170113000', '170112000', '160065100', '160064100', '160043000', '160043200', '160043500', '160043400', '160073000', '160067000', '160079000', '160065000', '160077000', '160082000', '160078000', '170114000', '160083000', '160081000', '170115000', '160086000', '160084000', '170116000', '160085000'].indexOf(d.properties.ParcelNumber) !== -1 && // d.properties.OwnerName.indexOf("LLC") !== -1 && // d.properties.OwnerName.indexOf("SILK PURSE") === -1 && // d.properties.OwnerName.indexOf("DOGWOOD PROP") === -1 && // (new Date(d.properties.LastSaleDate).getTime() > new Date(new Date().setFullYear(new Date().getFullYear() - 5))) && // d.properties.lot_sf < 8125*2 && // // d.properties.lot_sf > 12000 && // getUseCode(d, true, true).indexOf("Single Family") != -1 && // getUseCode(d, true, true) !== "Single Family Attached" && // d.properties.Zoning.indexOf("R-1") !== -1 && // d.properties.Zoning.indexOf("R-1S") == -1 && // d.properties.UseCode.indexOf("Apartments") !== -1 && // d.properties.UseCode.indexOf("Mixed Retail") !== -1 && // d.properties.Zoning.indexOf("R-1") !== -1 && // getUseCode(d, true, true).indexOf("ADU") !== -1 && // getUseCode(d) !== "Single Family" && // getUseCode(d) !== "Single Family-1 Conversion" && // (d.properties.Zoning.indexOf("U") !== -1 || d.properties.UseCode.indexOf("1 Con") === -1) && // d.properties.YearBuilt == 2020 && // d.properties.YearBuilt > 2010 && // d.properties.YearBuilt == 2019 && // d.properties.SquareFootageFinishedLiving < 1400 && d.properties.SquareFootageFinishedLiving > 1200 && // d.properties.YearBuilt > 2000 && // d.properties.lot_sf > 10000 && d.properties.lot_sf < 16000 && // (typeof d.properties.Assessments['2010'] !== "undefined" && // d.properties.Assessments['2020']['ImprovementValue']/d.properties.Assessments['2010']['ImprovementValue'] >= 2.5) && // d.properties.Zoning.indexOf("R-1") !== -1 && // d.properties.Assessments['2020']['ImprovementValue'] > 300000 && // d.properties.Assessments['2020']['TotalValue'] > 400000 && // d.properties.UseCode.indexOf("Single") !== -1 && // d.properties.UseCode.indexOf("Condo") !== -1 && // d.properties.UseCode.indexOf("Mortuary") !== -1 && true//d.properties.ResidentialDetails.YearBuilt != "0"; }); return data }46:[{"id":"81fb39ebdb85ca4b75b79363f6396c16b0bb2d6a3978a303381b5379e625b0383c70c97db5aeff5f5fdbcdb71d09766550d865f9aca32aca2afa44a6431fe886","href":"https://static.observableusercontent.com/files/81fb39ebdb85ca4b75b79363f6396c16b0bb2d6a3978a303381b5379e625b0383c70c97db5aeff5f5fdbcdb71d09766550d865f9aca32aca2afa44a6431fe886","name":"permits@2.csv","type":"text/csv","lastModified":1616348444402.551,"size":715766}] 2e:{"id":"abc3f3ee6dbc4c29","slug":"charlottesville-assessment-data","title":"Charlottesville Assessment Data","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2019-04-20T09:22:24.940Z","update_time":"$D2026-03-02T20:56:00.430Z","view_time":null,"first_public_time":"$D2019-04-20T18:00:54.587Z","has_unpublished_edits":null,"fork":{"id":"ae6c3a0e19835e3a","slug":"frys-spring-assessment-data","title":"Fry's Spring 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":5760,"publish_version":null,"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":5,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Charlottesville Assessment Data","cells":[{"id":0,"value":"md`# Charlottesville Assessment Data\n## Home Type, Square Footage, and Value — 2010-2024`","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":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":"`### 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 { label: \"Lot Sq Ft\", value: \"SqftLand\" },\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 { label: \"Lot Sq Ft\", value: \"SqftLand\" },\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 {_, MAX_Y, 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, d3jsonWithRetry}\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":2727,"value":"import {zone_strip_historic_map}\nfrom \"@rorystolzenberg/frys-spring-assessment-data\";","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3302,"value":"$33","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":"filter = {\n //if(CACHE)\n // return d3.json(FILTER_CACHE_URL);\n \n var results = {\n parcels: _.clone(parcels),\n assessments: _.clone(assessments),\n sales: _.clone(sales),\n residential_data: _.clone(residential_data),\n commercial_data: _.clone(commercial_data),\n base_data: _.clone(base_data),\n }\n iterate(results);\n \n return results;\n}","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 SqftLand: {\n min: 8000,\n max: 500000,\n step: 2000,\n value: 90000\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":3708,"value":"onMousemoveTooltip = function(tooltip){\n return d => {\n var left = d3.event.pageX +10;\n var width = tooltip.node().getBoundingClientRect().width;\n var new_right = left + width;\n if(new_right > d3.select('body').node().getBoundingClientRect().width){\n left = d3.event.pageX - 10 - width;\n }\n var top = (d3.event.pageY -10);\n var height = tooltip.node().getBoundingClientRect().height;\n top = top - height/2\n var new_bottom = top;\n if(new_bottom > d3.select('body').node().getBoundingClientRect().height){\n top = d3.event.pageY + 10 - height;\n }\n console.log(\"height\",tooltip, tooltip.node().getBoundingClientRect().height)\n tooltip.style(\"top\", top +\"px\").style(\"left\",left+\"px\")\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 iterateSales(filter);\n iterateNeighborhoods(filter);\n // iterateParkingPermitAreas(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":3030,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5524,"value":"iterateNeighborhoods = function(filter){\n filter.parcels.features.forEach(d=> {\n d.properties.Neighborhood = find_neighborhood(d)\n })\n return filter\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5522,"value":"find_neighborhood = parcel => {\n for(var x in neighborhoods.features){\n if(turf.booleanIntersects(parcel,neighborhoods.features[x]))\n return neighborhoods.features[x].properties.NAME\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5693,"value":"// iterateParkingPermitAreas = function(filter){\n// filter.parcels.features.forEach(d=> {\n// d.properties.ParkingPermitArea = find_parking_permit_area(d)\n// })\n// return filter\n// }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5697,"value":"// find_parking_permit_area = parcel => {\n// for(var x in parking_permit_areas.features){\n// if(turf.booleanIntersects(parcel,parking_permit_areas.features[x]))\n// return parking_permit_areas.features[x].properties.Name\n// }\n// return null\n// }","pinned":true,"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 \"2020\": [],\n \"2021\": [],\n \"2022\": [],\n \"2023\": [],\n \"2024\": [],\n \"2025\": [],\n \"2026\": [],\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":3507,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3543,"value":"nonres_uses = [\n \"Vacant Land\",\n \"Parking Lot\",\n \"City Club\",\n \"Multipurpose Bldg (College)\",\n \"Fire Station (staff)\",\n \"Office\",\n \"Clubhouse\",\n \"Elementary Sch (Entire)\",\n \"Church\",\n \"Office Building\",\n \"Hotel\",\n \"Medical Office\",\n \"Parking Structure\",\n \"Hospital\",\n \"Mixed Retail w/Res Units\",\n \"Retail Store\",\n \"Bank\",\n \"Classroom (Elem/2nd Sch)\",\n \"Commercial\",\n \"Service Repair Garage\",\n \"Condominium Commercial\",\n \"Industrial Light Manufacturing\",\n \"Restaurant\",\n \"Market\",\n \"Common Area\",\n \"Condo Common Area\",\n \"Cemetery\",\n \"Warehouse Showroom Store\",\n \"Vacant Industrial (M1,M3,PMD)\",\n];","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3541,"value":"uncountable_res_uses = nonres_uses.concat([\n \"Apartments\",\n \"Rectory\",\n \"Rooming House\",\n \"Fraternity\\\\Sorority House\",\n \"Mixed Retail w/Res Units\",\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5454,"value":"CURRENT_YEAR = \"2026\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1510,"value":"$36","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":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2762,"value":"tabulate = function(data, columns) {\n const div = d3.select(html`

`);\n var table = div.append('table')\n var thead = table.append('thead')\n var\ttbody = table.append('tbody');\n\n // append the header row\n thead.append('tr')\n .selectAll('th')\n .data(columns).enter()\n .append('th')\n .style('text-align', 'center')\n .text(function (column) { return column; });\n\n // create a row for each object in the data\n var rows = tbody.selectAll('tr')\n .data(data)\n .enter()\n .append('tr');\n\n // create a cell in each row for each column\n var cells = rows.selectAll('td')\n .data(function (row) {\n return columns.map(function (column) {\n return {column: column, value: row[column]};\n });\n })\n .enter()\n .append('td')\n .text(function (d) { return d.value; });\n\n return div.node();\n}","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":"$38","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, text} 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":2882,"value":"NEIGHBORHOODS_URL = \"https://opendata.arcgis.com/datasets/c371ad0b81024822bad1147ff6bb24c4_50.geojson\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5688,"value":"// PARKING_PERMIT_AREA_URL = \"https://opendata.arcgis.com/datasets/fc3f283eb0124c9dad792f5fbe674397_37.geojson\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3019,"value":"SALES_URL = \"https://opendata.arcgis.com/datasets/489adf140c174534a544136dc3e4cb90_3.geojson\"","pinned":true,"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":3020,"value":"sales = (EVEN_MORE_CACHE ? {type: \"FeatureCollection\", features: []} : d3jsonWithRetry(SALES_URL))","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":1647,"value":"$39","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":2884,"value":"neighborhoods = d3jsonWithRetry(NEIGHBORHOODS_URL)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5691,"value":"// parking_permit_areas = d3.json(PARKING_PERMIT_AREA_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: []} : d3jsonWithRetry(BASE_DATA_URL))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1680,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":648,"value":"$3b","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":false,"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":false,"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":false,"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":false,"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":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2574,"value":"$3c","pinned":false,"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"},{"id":2729,"value":"zone_counts = {\n var parcels = _.clone(base_data.features)\n var geoparcels = Object.values(_.groupBy(parcels, d => d.properties.GPIN)).map(d => d[0].properties)\n // var groupedByZone = _.groupBy(geoparcels, d => d.Zone);\n var groupedByZone = _.groupBy(geoparcels, d => zone_strip_historic(d.Zone));\n groupedByZone = _.map(groupedByZone, (d, i) => {\n var historic = Object.keys(zone_strip_historic_map).includes(i)\n return {\"Zone\": i, \"Count\": d.length/*, \"Historic\": historic*/}\n })\n groupedByZone = _.sortBy(groupedByZone, \"Zone\")\n return groupedByZone\n // .filter(d=>d.Zone.indexOf(\"R-1\") !== -1)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2766,"value":"zone_total_table = { \n return tabulate(zone_counts, Object.keys(zone_counts[0]));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2755,"value":"historic = {\n var results = {\n \"not\": 0,\n \"historic\": 0,\n }\n zone_counts.forEach(d => {\n var key = d[\"Historic\"] ? \"historic\" : \"not\"\n results[key] += d[\"Count\"];\n })\n return results\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2795,"value":"duplex_counts = {\n var parcels = _.clone(filter.parcels.features)\n parcels = parcels.filter(d=> {\n var use = getUseCode(d)\n // console.log(d, d.properties.Zoning )\n return use == \"Duplex\"// || use == \"Single Family Attached\"\n })\n return parcels.length;\n // return parcels\n // return parcels\n var groupedByZone = _.groupBy(parcels, d => zone_strip_historic(d.properties.Zoning));\n // return groupedByZone\n groupedByZone = _.map(groupedByZone, (d, i) => {\n var historic = Object.keys(zone_strip_historic_map).includes(i)\n return {\"Zoning\": i, \"Count\": d.length, \"Historic\": historic}\n })\n groupedByZone = _.sortBy(groupedByZone, \"Zoning\")\n return groupedByZone\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2804,"value":"duplex_zone_total_table = { \n return tabulate(duplex_counts, [\"Zoning\", \"Count\"]);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2841,"value":"sfds = {\n var parcels = _.clone(filter.parcels.features)\n // return parcels\n parcels = parcels.filter(d=> typeof d.properties.UseCode !== 'undefined' && d.properties.UseCode.indexOf(\"Single Family\") !== -1 && d.properties.UseCode.indexOf(\"Attach\") === -1 && d.properties.Zoning.indexOf(\"R-1S\") !== -1)\n return parcels\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2849,"value":"sfd_lot_sf = {\n var lot_sizes = sfds.map(d => d.properties.lot_sf)\n return d3.median(lot_sizes)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2857,"value":"cedars_court = {\n var data = _.clone(filter.parcels.features)\n var units = data.filter(d => d.properties.StreetNumber == 1243 && d.properties.StreetName == \"CEDARS CT\")\n return units;\n var table = units.map((d, i) => {\n return {\"Unit\": d.properties.Unit, \"Assessment\": d3.format(\"$,\")(d.properties.Assessment), \"SqFt\": d.properties.SquareFootageFinishedLiving}\n })\n return tabulate(table, [\"Unit\", \"Assessment\", \"SqFt\"]);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2869,"value":"r1millions = {\n var data = _.clone(filter.parcels.features)\n var units = data.filter(d => d.properties.Zoning.indexOf(\"R-1\") !== -1 && d.properties.Assessment > 1000000 && d.properties.UseCode.indexOf(\"Single\") !== -1)\n return units.map(d=> {\n var properties = _.clone(d.properties)\n delete properties.Assessments\n delete properties.ResidentialDetailRows\n delete properties.ResidentialDetails\n return properties\n })\n //_.groupBy(units, d => d.properties.UseCode)\n var table = units.map((d, i) => {\n return {\"Unit\": d.properties.Unit, \"Assessment\": d3.format(\"$,\")(d.properties.Assessment), \"SqFt\": d.properties.SquareFootageFinishedLiving}\n })\n return tabulate(table, [\"Unit\", \"Assessment\", \"SqFt\"]);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2915,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2932,"value":"purplepeopleeater = {\n var data = _.clone(filter.parcels.features)\n var units = data.filter(d => d.properties.StreetNumber == 215 && d.properties.StreetName == \"5TH ST SW\")\n \n var table = units.map((d, i) => {\n return {\"Unit\": d.properties.Unit, \"Assessment\": d3.format(\"$,\")(d.properties.Assessment), \"SqFt\": d.properties.SquareFootageFinishedLiving}\n })\n return tabulate(table, [\"Unit\", \"Assessment\", \"SqFt\"]);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2948,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2951,"value":"walker_sq = {\n var data = _.clone(filter.parcels.features)\n var units = data.filter(d => d.properties.StreetName == \"WALKER SQ\")\n return units;\n \n var table = units.map((d, i) => {\n return {\"Unit\": d.properties.Unit, \"UseCode\": d.properties.UseCode, \"Assessment\": d3.format(\"$,\")(d.properties.Assessment), \"SqFt\": d.properties.SquareFootageFinishedLiving}\n })\n return tabulate(table, [\"Unit\", \"UseCode\", \"Assessment\", \"SqFt\"]);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2980,"value":"downloadable = {\n var data = _.clone(filter.parcels.features)\n data = data.map(d=>d.properties)\n data = data.map(d=>{\n // delete d.Assessments\n // delete d.ResidentialDetails\n // delete d.ResidentialDetailRows\n // delete d.CommercialDetails\n // delete d.CommercialDetailRows\n return d\n })\n return data;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2987,"value":"kenil = {\n var data = _.clone(filter.parcels.features)\n return data.filter(d=> d.properties.StreetNumber == 1725)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3002,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3110,"value":"vacant_parcels = {\n var data = _.clone(filter.parcels.features);\n data = data.filter(d => typeof d.properties.UseCode !== 'undefined')\n data = data.filter(d => getUseCode(d, true).indexOf(\"Vacant\") !== -1 || getUseCode(d, true).indexOf(\"Parking Lot\") !== -1)\n return data.reduce((acc, cur) => {return acc + cur.properties.lot_sf},0)\n return data;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3137,"value":"commldetails = {\n var data = _.clone(filter.parcels.features);\n data = data.filter(d => typeof d.properties.CommercialDetailRows !== 'undefined' && typeof d.properties.ResidentialDetailRows !== 'undefined' && d.properties.CommercialDetailRows.length > 0 && d.properties.ResidentialDetailRows.length > 0)\n return data;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3169,"value":"gleason = {\n var data = _.clone(filter.parcels.features)\n var units = data.filter(d => d.properties.StreetNumber == 200 && d.properties.StreetName == \"GARRETT ST\")\n \n var table = units.map((d, i) => {\n var sales = d.properties.Sales.reduce((acc, cur) => acc + \"\\n\\n\" + (new Date(cur.SaleDate)).toLocaleDateString(),\"\")\n return {\"Unit\": d.properties.Unit, \"Assessment\": d3.format(\"$,\")(d.properties.Assessment), \"SqFt\": d.properties.SquareFootageFinishedLiving, \"Sales\": sales}\n })\n return tabulate(table, [\"Unit\", \"Assessment\", \"SqFt\", \"Sales\"]);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3178,"value":"newbuildpermits = d3.csvParse(await FileAttachment(\"permits@2.csv\").text()).filter(d => d.SubType.indexOf(\"C10\") == 0)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3180,"value":"$40","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3288,"value":"use_codes = {\n var data = _.clone(filter.parcels.features)\n var uses = data.map(d => d.properties.UseCode)\n return _.uniq(uses).sort()\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3890,"value":"suffixes = {\n var data = _.clone(filter.parcels.features)\n var sts = _.uniq(data.map(d=>d.properties.StreetName))\n var suffixes = sts.map(d=>{\n var n = d.split(\" \");\n return n[n.length - 1];\n })\n return _.uniq(suffixes).join(\"|\")\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3292,"value":"r1_parcels = {\n var data = _.clone(filter.parcels.features)\n var r1 = data.filter(d => d.properties.Zoning.indexOf(\"R-1\") !== -1)\n return r1\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4533,"value":"is_r1_sfd = d => {\n var use_code = getUseCode(d, true, true)\n return true &&\n d.properties.Zoning.indexOf(\"R-1\") !== -1 &&\n typeof use_code !== 'undefined' &&\n use_code.indexOf(\"Single Family\") !== -1 && \n use_code != \"Single Family Attached\" &&\n // !is_uva_parcel(d) &&\n // d.properties.OwnerName.indexOf(\"CITY OF CHARLOTTESVILLE\") == -1 &&\n [\"120002L00\",\"120003000\"].indexOf(d.properties.ParcelNumber) == -1 && //broken wesley methodist parcels\n d.properties.TaxType != \"Exempt\" &&\n true;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5039,"value":"$41","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5035,"value":"r1_lot_sizes_now_r1l = {\n return r1_lot_sizes_see(8125*2, 8125)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5108,"value":"r1_lot_sizes_now_r1s = {\n return r1_lot_sizes_see(8125, 6000)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4614,"value":"$42","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5026,"value":"r1_lot_sizes = {\n return r1_lot_sizes_see(8125*2,6000*2)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4225,"value":"$43","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5245,"value":"$44","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3328,"value":"sf_rank = {\n var data = _.clone(filter.parcels.features)\n var houses = data.filter(d => {\n var uc = getUseCode(d, true, true)\n return typeof d.properties.UseCode !== 'undefined' && \n [\"Single Family\", \"Single Family + ADU(s)\", \"Single Family Attached\"].indexOf(uc) !== -1 \n })\n // return houses.filter ( d=> d.properties.UseCode !== \"Single Family\").map ( d=> d.properties.UseCode)\n \n // return _.uniq(sfds.map ( d=> getUseCode(d, true, true)))\n return houses.map ( d=> d.properties.Assessment).sort((first, sec) => first > sec ? -1 : 1)\n \n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3850,"value":"sfd_rank = {\n var data = _.clone(filter.parcels.features)\n var houses = data.filter(d => {\n var uc = getUseCode(d, true, true)\n return typeof d.properties.UseCode !== 'undefined' && \n [\"Single Family\", \"Single Family + ADU(s)\"].indexOf(uc) !== -1 \n })\n // return houses.filter ( d=> d.properties.UseCode !== \"Single Family\").map ( d=> d.properties.UseCode)\n \n // return _.uniq(sfds.map ( d=> getUseCode(d, true, true)))\n return houses.map ( d=> d.properties.Assessment).sort((first, sec) => first > sec ? -1 : 1)\n \n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5474,"value":"sfd_rank_by_year = {\n var data = _.clone(filter.parcels.features)\n var years = Object.keys(yrs)\n var rankyrs = {};\n years.forEach(y => {\n var houses = data.filter(d => {\n var uc = getUseCode(d, true, true)\n return typeof d.properties.UseCode !== 'undefined' && \n typeof d.properties.Assessments !== 'undefined' &&\n typeof d.properties.Assessments[y] !== 'undefined' &&\n d.properties.Assessments[y].ImprovementValue > 10000 &&\n [\"Single Family\", \"Single Family + ADU(s)\"].indexOf(uc) !== -1 \n })\n // return houses.filter ( d=> d.properties.UseCode !== \"Single Family\").map ( d=> d.properties.UseCode)\n \n // return _.uniq(sfds.map ( d=> getUseCode(d, true, true)))\n rankyrs[y] = houses.map ( d=> d.properties.Assessments[y].TotalValue).sort((first, sec) => first > sec ? 1 : -1)\n })\n return rankyrs\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4197,"value":"sfd_rank.reduce((a,b) => a + b, 0) / sfd_rank.length;","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3856,"value":"sfa_rank = {\n var data = _.clone(filter.parcels.features)\n var houses = data.filter(d => {\n var uc = getUseCode(d, true, true)\n return typeof d.properties.UseCode !== 'undefined' && \n [\"Single Family Attached\"].indexOf(uc) !== -1 \n })\n // return houses.filter ( d=> d.properties.UseCode !== \"Single Family\").map ( d=> d.properties.UseCode)\n \n // return _.uniq(houses.map ( d=> getUseCode(d, true, true)))\n return houses.map ( d=> d.properties.Assessment).sort((first, sec) => first > sec ? -1 : 1)\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3868,"value":"sf_decile_table = {\n var percentiles = [10,20,30,40,50,60,70,80,90,95,96,97,98,99,99.9]\n \n var sfs = _.clone(sf_rank)\n sfs = sfs.reverse()\n var sfds = _.clone(sfd_rank)\n sfds = sfds.reverse()\n var sfas = _.clone(sfa_rank)\n sfas = sfas.reverse()\n \n var fmt = d3.format(\"$,.0f\");\n \n var table = percentiles.map((d, i) => {\n return {\n \"Percentile\": d+\"%\",\n \"All Single-Family\": fmt(d3.quantile(sfs, d/100)),\n \"Single-Family Detached\": fmt(d3.quantile(sfds, d/100)),\n \"Single-Family Attached\": fmt(d3.quantile(sfas, d/100))}\n })\n \n return tabulate(table, [\"Percentile\", \"All Single-Family\", \"Single-Family Detached\", \"Single-Family Attached\"]);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5477,"value":"sfd_comparison_table = {\n var fmt = d3.format(\"$,.0f\");\n var percentiles = [10,20,30,40,50,60,70,80,90,99]\n var years = Object.keys(sfd_rank_by_year)\n \n var columns = [\"Percentile\"]\n years.forEach(y => {\n columns.push(`Single-Family Detached ${y}`)\n })\n var table = percentiles.map((d, i) => {\n var row = {\"Percentile\": d+\"%\",}\n years.forEach(y => {\n row[`Single-Family Detached ${y}`] = fmt(d3.quantile(sfd_rank_by_year[y], d/100))\n })\n return row\n })\n return tabulate(table, columns);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3338,"value":"sf_deciles = {\n var data = _.clone(sf_rank)\n data = data.reverse()\n // return d3.quantile(data, .9713); // 1 mil\n // return d3.quantile(data, .9949); // 1 mil\n var fmt = d3.format(\"$,\");\n return {\n \"10th percentile\": fmt(d3.quantile(data, .1)),\n \"20th percentile\": fmt(d3.quantile(data, .2)),\n \"30th percentile\": fmt(d3.quantile(data, .3)),\n \"40th percentile\": fmt(d3.quantile(data, .4)),\n \"50th percentile\": fmt(d3.quantile(data, .5)),\n \"60th percentile\": fmt(d3.quantile(data, .6)),\n \"70th percentile\": fmt(d3.quantile(data, .7)),\n \"80th percentile\": fmt(d3.quantile(data, .8)),\n \"90th percentile\": fmt(d3.quantile(data, .9)),\n \"95th percentile\": fmt(d3.quantile(data, .95)),\n \"96th percentile\": fmt(d3.quantile(data, .96)),\n \"97th percentile\": fmt(d3.quantile(data, .97)),\n \"98th percentile\": fmt(d3.quantile(data, .98)),\n \"99th percentile\": fmt(d3.quantile(data, .99)),\n }\n \n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3862,"value":"sfa_deciles = {\n var data = _.clone(sfa_rank)\n data = data.reverse()\n // return d3.quantile(data, .9713); // 1 mil\n // return d3.quantile(data, .9949); // 1 mil\n var fmt = d3.format(\"$,\");\n return {\n \"10th percentile\": fmt(d3.quantile(data, .1)),\n \"20th percentile\": fmt(d3.quantile(data, .2)),\n \"30th percentile\": fmt(d3.quantile(data, .3)),\n \"40th percentile\": fmt(d3.quantile(data, .4)),\n \"50th percentile\": fmt(d3.quantile(data, .5)),\n \"60th percentile\": fmt(d3.quantile(data, .6)),\n \"70th percentile\": fmt(d3.quantile(data, .7)),\n \"80th percentile\": fmt(d3.quantile(data, .8)),\n \"90th percentile\": fmt(d3.quantile(data, .9)),\n \"95th percentile\": fmt(d3.quantile(data, .95)),\n \"96th percentile\": fmt(d3.quantile(data, .96)),\n \"97th percentile\": fmt(d3.quantile(data, .97)),\n \"98th percentile\": fmt(d3.quantile(data, .98)),\n \"99th percentile\": fmt(d3.quantile(data, .99)),\n }\n \n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3863,"value":"sfd_deciles = {\n var data = _.clone(sfd_rank)\n data = data.reverse()\n // return d3.quantile(data, .9713); // 1 mil\n // return d3.quantile(data, .9949); // 1 mil\n var fmt = d3.format(\"$,\");\n return {\n \"10th percentile\": fmt(d3.quantile(data, .1)),\n \"20th percentile\": fmt(d3.quantile(data, .2)),\n \"30th percentile\": fmt(d3.quantile(data, .3)),\n \"40th percentile\": fmt(d3.quantile(data, .4)),\n \"50th percentile\": fmt(d3.quantile(data, .5)),\n \"60th percentile\": fmt(d3.quantile(data, .6)),\n \"70th percentile\": fmt(d3.quantile(data, .7)),\n \"80th percentile\": fmt(d3.quantile(data, .8)),\n \"90th percentile\": fmt(d3.quantile(data, .9)),\n \"95th percentile\": fmt(d3.quantile(data, .95)),\n \"96th percentile\": fmt(d3.quantile(data, .96)),\n \"97th percentile\": fmt(d3.quantile(data, .97)),\n \"98th percentile\": fmt(d3.quantile(data, .98)),\n \"99th percentile\": fmt(d3.quantile(data, .99)),\n }\n \n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4086,"value":"closest = function(counts, goal){\n return counts.reduce(function(prev, curr) {\n return (Math.abs(curr - goal) < Math.abs(prev - goal) ? curr : prev);\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3364,"value":"sf_get_percentile = function(num){\n var fmt = d3.format(\".2%\");\n var rank = sf_get_rank(num)\n if(rank == null)\n return null\n return fmt((sf_rank.length - rank) / sf_rank.length)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4205,"value":"sfd_get_percentile = function(num){\n var fmt = d3.format(\".2%\");\n var rank = sfd_get_rank(num)\n if(rank == null)\n return null\n return fmt((sfd_rank.length - rank) / sfd_rank.length)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4207,"value":"sfd_get_rank = function(num){\n var rank = sfd_rank.indexOf(num)+1\n if(rank == 0){\n rank = sfd_rank.indexOf(closest(sfd_rank,num))+1\n return rank;\n }\n return rank\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3422,"value":"sf_get_rank = function(num){\n var rank = sf_rank.indexOf(num)+1\n if(rank == 0){\n rank = sf_rank.indexOf(closest(sf_rank,num))+1\n return rank;\n }\n return rank\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3392,"value":"viewof sf_picker = text({placeholder: \"$350,000\", value: sf_deciles[\"50th percentile\"], description: \"Enter Home Value to find Percentile\", submit: \"Go\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3399,"value":"sf_percentile_result = {\n var value = sf_picker.replace(\"$\",\"\").replaceAll(\",\",\"\")\n // return parseInt(value)\n return sf_get_percentile(parseInt(value))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3434,"value":"sf_rank_result = {\n var value = sf_picker.replace(\"$\",\"\").replaceAll(\",\",\"\")\n // return parseInt(value)\n return sf_get_rank(parseInt(value))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4211,"value":"viewof sfd_picker = text({placeholder: \"$350,000\", value: sfd_deciles[\"50th percentile\"], description: \"Enter SFD Home Value to find Percentile\", submit: \"Go\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4216,"value":"sfd_percentile_result = {\n var value = sfd_picker.replace(\"$\",\"\").replaceAll(\",\",\"\")\n // return parseInt(value)\n return sfd_get_percentile(parseInt(value))\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3917,"value":"sf_age_rank = {\n var data = _.clone(filter.parcels.features)\n var houses = data.filter(d => {\n var uc = getUseCode(d, true, true)\n return typeof d.properties.UseCode !== 'undefined' && typeof d.properties.YearBuilt !== 'undefined' && d.properties.YearBuilt !== null && d.properties.YearBuilt != 0 &&\n [\"Single Family\", \"Single Family + ADU(s)\", \"Single Family Attached\"].indexOf(uc) !== -1 \n })\n // return houses.filter ( d=> d.properties.UseCode !== \"Single Family\").map ( d=> d.properties.UseCode)\n \n // return _.uniq(sfds.map ( d=> getUseCode(d, true, true)))\n return houses.map ( d=> { if(d.properties.YearBuilt == \"2109\") return 2019; return parseInt(d.properties.YearBuilt)}).sort((first, sec) => first > sec ? -1 : 1)\n \n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3924,"value":"sfd_age_rank = {\n var data = _.clone(filter.parcels.features)\n var houses = data.filter(d => {\n var uc = getUseCode(d, true, true)\n return typeof d.properties.UseCode !== 'undefined' && typeof d.properties.YearBuilt !== 'undefined' && d.properties.YearBuilt !== null && d.properties.YearBuilt != 0 &&\n [\"Single Family\", \"Single Family + ADU(s)\"].indexOf(uc) !== -1 \n })\n // return houses.filter ( d=> d.properties.UseCode !== \"Single Family\").map ( d=> d.properties.UseCode)\n \n // return _.uniq(sfds.map ( d=> getUseCode(d, true, true)))\n return houses.map ( d=> { if(d.properties.YearBuilt == \"2109\") return 2019; return parseInt(d.properties.YearBuilt)}).sort((first, sec) => first > sec ? -1 : 1)\n \n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3928,"value":"sfa_age_rank = {\n var data = _.clone(filter.parcels.features)\n var houses = data.filter(d => {\n var uc = getUseCode(d, true, true)\n return typeof d.properties.UseCode !== 'undefined' && typeof d.properties.YearBuilt !== 'undefined' && d.properties.YearBuilt !== null && d.properties.YearBuilt != 0 &&\n [\"Single Family Attached\"].indexOf(uc) !== -1 \n })\n // return houses.filter ( d=> d.properties.UseCode !== \"Single Family\").map ( d=> d.properties.UseCode)\n \n // return _.uniq(houses.map ( d=> getUseCode(d, true, true)))\n return houses.map ( d=> { if(d.properties.YearBuilt == \"2109\") return 2019; return parseInt(d.properties.YearBuilt)}).sort((first, sec) => first > sec ? -1 : 1)\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3933,"value":"sf_age_decile_table = {\n var percentiles = [10,20,30,40,50,60,70,80,90,95,96,97,98,99,99.9]\n \n var sfs = _.clone(sf_age_rank)\n // return sfs;\n sfs = sfs.reverse()\n // return sfs;//d3.quantile(sfs, .6)\n var sfds = _.clone(sfd_age_rank)\n sfds = sfds.reverse()\n var sfas = _.clone(sfa_age_rank)\n sfas = sfas.reverse()\n var dups = _.clone(duplex_age_rank)\n dups = dups.reverse()\n \n var fmt = d3.format(\".0f\");\n \n var table = percentiles.map((d, i) => {\n return {\n \"Percentile\": d+\"%\",\n \"All Single-Family\": fmt(d3.quantile(sfs, d/100)),\n \"Single-Family Detached\": fmt(d3.quantile(sfds, d/100)),\n \"Single-Family Attached\": fmt(d3.quantile(sfas, d/100)),\n \"Duplexes\": fmt(d3.quantile(dups, d/100))}\n })\n \n return tabulate(table, [\"Percentile\", \"All Single-Family\", \"Single-Family Detached\", \"Single-Family Attached\", \"Duplexes\"]);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3977,"value":"duplex_age_rank = {\n var data = _.clone(filter.parcels.features)\n var houses = data.filter(d => {\n var uc = getUseCode(d, true, true)\n return typeof d.properties.UseCode !== 'undefined' && typeof d.properties.YearBuilt !== 'undefined' && d.properties.YearBuilt !== null && d.properties.YearBuilt != 0 &&\n [\"Duplex\"].indexOf(uc) !== -1 \n })\n // return houses.filter ( d=> d.properties.UseCode !== \"Single Family\").map ( d=> d.properties.UseCode)\n \n // return _.uniq(houses.map ( d=> getUseCode(d, true, true)))\n return houses.map ( d=> { if(d.properties.YearBuilt == \"2109\") return 2019; return parseInt(d.properties.YearBuilt)}).sort((first, sec) => first > sec ? -1 : 1)\n\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3983,"value":"lot_size_rank = {\n var data = _.clone(filter.parcels.features)\n var parcels = data.filter(d=>typeof d.properties.OwnerName !== 'undefined' && d.properties.OwnerName.indexOf(\"OF CHARLOTTESVI\") == -1 && d.properties.OwnerName.indexOf(\"OF ALBEMARLE\") == -1 && d.properties.OwnerName.indexOf(\"CEMETERY\") == -1 && d.properties.OwnerName.indexOf(\"UNIVERSITY OF\") == -1 && d.properties.OwnerName.indexOf(\"RECTOR & VISITORS\") == -1).map ( d=> {return {Address: d.properties.StreetNumber+\" \"+d.properties.StreetName,Acres: (d.properties.lot_sf/43560).toFixed(2), OwnerName:d.properties.OwnerName}}).sort((first, sec) => first.Acres > sec.Acres ? -1 : 1).slice(0,100)\n return tabulate(parcels, ['OwnerName','Address', 'Acres'])\n\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3991,"value":"mhp = {\n var data = _.clone(filter.parcels.features)\n return _.uniq(data.map(d=>d.properties.Zoning)).sort()\n\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4010,"value":"stories = {\n var data = _.clone(filter.parcels.features)\n return data.filter(d=>d.properties.Residential).length\n var over25 = data.filter(d=>d.properties.Residential && d.properties.ResidentialDetails.NumberOfStories > 2.5).map(d=>{return {Address:d.properties.StreetNumber+\" \"+d.properties.StreetName, Stories:d.properties.ResidentialDetails.NumberOfStories}}).sort((a,b)=>b.Stories - a.Stories)\n return tabulate(over25, ['Address','Stories'])\n return _.uniq(data.map(d=>d.properties.Zoning)).sort()\n\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5404,"value":"CITY_TAX_RATE = 0.0098","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4342,"value":"uva_parcels = {\n var data = _.clone(filter.parcels.features)\n // return data.filter(d=> d.properties.OwnerName.indexOf(\"RECTOR\") !== -1).map(d=>{return {OwnerName: d.properties.OwnerName, Assessment: d.properties.Assessment, Address: d.properties.StreetNumber +\" \"+ d.properties.StreetName, ParcelNumber: d.properties.ParcelNumber}})\n return data.filter(is_uva_parcel)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4363,"value":"is_uva_parcel = d => {\n return d.properties.OwnerName.indexOf(\"RECTOR\") !== -1 //&& \n // [\"100060000\",\"100116000\",\"100083000\",\"100088000\",\"100091000\",\"110131000\",\"100081100\"]\n // .indexOf(d.properties.ParcelNumber) === -1 //hospital\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4099,"value":"uva_parcels_ass = {\n var data = _.clone(uva_parcels)\n var total_ass = data\n //.sort((first, sec) => first > sec ? -1 : 1)\n .map(d=>d.properties.Assessments[\"2024\"].TotalValue).sort((first, sec) => first > sec ? -1 : 1).reduce((acc, cur) => acc+cur,0)\n // return d3.format('$,')(total_ass*.0096)\n return d3.format('$,')(total_ass)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5400,"value":"uva_parcels_taxes = {\n var ass_int = parseFloat(uva_parcels_ass.replace(/\\$|,/g, ''))\n // return ass_int\n // return ass_int*CITY_TAX_RATE\n return d3.format('$,.2f')(ass_int*CITY_TAX_RATE)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5365,"value":"uva_parcels_acre = {\n var data = _.clone(uva_parcels)\n var total_sf = data\n //.sort((first, sec) => first > sec ? -1 : 1)\n .map(d=>d.properties.lot_sf).sort((first, sec) => first > sec ? -1 : 1).reduce((acc, cur) => acc+cur,0)\n // return d3.format('$,')(total_ass*.0095)\n return d3.format(',.1f')(total_sf/43560)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5378,"value":"is_uva_foundation_parcel = d => {\n return d.properties.OwnerName == \"UNIVERSITY OF VIRGINIA FOUNDATION\"\n // return d.properties.OwnerAddress.indexOf(\"1 BOAR\") !== -1 || d.properties.OwnerAddress.indexOf(\"PO BOX 400218\") !== -1 || d.properties.OwnerAddress.indexOf(\"P O BOX 400218\") !== -1\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5381,"value":"uva_foundation_parcels = {\n var data = _.clone(filter.parcels.features)\n // return data.filter(d=> d.properties.OwnerName.indexOf(\"RECTOR\") !== -1).map(d=>{return {OwnerName: d.properties.OwnerName, Assessment: d.properties.Assessment, Address: d.properties.StreetNumber +\" \"+ d.properties.StreetName, ParcelNumber: d.properties.ParcelNumber}})\n return data.filter(is_uva_foundation_parcel)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5427,"value":"uva_foundation_parcels_ass = {\n var data = _.clone(uva_foundation_parcels)\n var total_ass = data\n //.sort((first, sec) => first > sec ? -1 : 1)\n .map(d=>d.properties.Assessments[\"2023\"].TotalValue).sort((first, sec) => first > sec ? -1 : 1).reduce((acc, cur) => acc+cur,0)\n // return d3.format('$,')(total_ass*.0096)\n return d3.format('$,')(total_ass)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5429,"value":"uva_foundation_taxes = {\n var ass_int = parseFloat(uva_foundation_parcels_ass.replace(/\\$|,/g, ''))\n // return ass_int\n // return ass_int*CITY_TAX_RATE\n return d3.format('$,.2f')(ass_int*CITY_TAX_RATE)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5739,"value":"govt_parcels = {\n var data = _.clone(filter.parcels.features)\n return data.filter(is_govt_parcel).map(d=>d.properties.ParcelNumber)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5737,"value":"is_govt_parcel = d => {\n // return d.properties.ParcelNumber == \"41C002000\";\n var owner = d.properties.OwnerName.replace(\" \",\" \");\n return owner.indexOf(\"RECTOR\") !== -1 ||\n owner.indexOf(\"CITY OF CHARLOTTESVILLE\") !== -1 ||\n owner.indexOf(\"UNITED STATES OF AMERICA\") !== -1 \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5443,"value":"dogwood_ass = {\n var data = _.clone(filter.parcels.features)\n data = data.filter(d=> d.properties.OwnerName.indexOf(\"DOGWOOD PROP\") !== -1)\n // return data.map(d=>d.properties.OwnerName)\n var total_ass = data\n //.sort((first, sec) => first > sec ? -1 : 1)\n .map(d=>d.properties.Assessments[\"2023\"].TotalValue).sort((first, sec) => first > sec ? -1 : 1).reduce((acc, cur) => acc+cur,0)\n // return d3.format('$,')(total_ass*.0096)\n return d3.format('$,')(total_ass)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5611,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5623,"value":"resi_uses = _.uniq(all_residential_parcels.map(d=>d.properties.UseCode))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5628,"value":"all_uses = _.uniq(filter.parcels.features.map(d=>d.properties.UseCode))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5615,"value":"all_resi_land_total = all_residential_parcels.reduce((acc, cur) => acc + cur.properties.Assessments[\"2024\"].LandValue, 0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5617,"value":"all_resi_sf_total = {\n var geoparcels = _.groupBy(all_residential_parcels, d => d.properties.GeoParcelIdentificationNumber)\n // var geoparcels = []\n var data = Object.values(geoparcels).map(d=>d[0])\n // return data\n // return data.filter(d=>typeof d.properties.lot_sf === 'undefined')\n return data.reduce((acc, cur) => acc + cur.properties.lot_sf, 0)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5673,"value":"all_resi_sf_total_acres = all_resi_sf_total/43560","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5643,"value":"all_resi_sf_total_dupe_condos = all_residential_parcels.reduce((acc, cur) => acc + cur.properties.lot_sf, 0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5620,"value":"resi_avg_land_val = all_resi_land_total/all_resi_sf_total","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W46","stdlib":"1"}} 2f:"$2e:body"