2a:null 2b:["$","title",null,{"children":"Fry's Spring Assessment Data | Rory Stolzenberg | Observable"}] 30:T1760,plot = { var residentialUses = ["Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion", "Single Family Attached", "Duplex", "Triplex", "Quadplex", "Three-Level Split", "Four-Level Split", "Condominium", "Apartments"]; var data = _.clone(filter.parcels.features); data = data.filter(function(d){ if(typeof d.properties.YearBuilt !== 'undefined' && d.properties.YearBuilt == "20018"){ console.log('wtf',d) d.properties.YearBuilt = 2018 d.properties.ResidentialDetails.YearBuilt = 2018 } console.log(d.properties.YearBuilt, d.properties.Assessment,d.properties.StreetNumber + " " + d.properties.StreetName,d) return d.properties.Residential === true && //d.properties.StreetName.indexOf("CHRISTA") !== -1 public_spaces.indexOf(d.properties.ParcelNumber) === -1 && commercial.indexOf(d.properties.ParcelNumber) === -1 && d.properties.UseCode != "Vacant Land" && d.properties.Assessments[LATEST_YEAR] && d.properties.Assessments[LATEST_YEAR].ImprovementValue != 0 && d.properties.ResidentialDetails.YearBuilt != "0" && true &&//getYearBuilt(d) >= 2010 && true &&//["Single Family", "Single Family + ADU(s)"].indexOf(getUseCode(d,true,true)) !== -1; true//["Single Family Attached"].indexOf(getUseCode(d,true,true)) !== -1; }); var axes = AXES(data) //axes[Y_AXIS].dotSize = "3" //axes[Y_AXIS].legendOffsetX = 0 if(COLOR_KEY == 'UseCode'){ data = _.sortBy(data, d => axes[COLOR_KEY].sortNum(d)) } 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([2012,2015]); var ydomain = y.domain(d3.extent(data, getY)); if(axes[Y_AXIS].nice) ydomain.nice(); // x-axis svg.append("g") .attr("class", "x axis") .attr("transform", "translate(0," + height + ")") .style("font-size", ".8em") .style("font-weight", "bold") .call(xAxis) .append("text") .attr("class", "label") .attr("x", wi) .attr("y", -6) .style("fill", TEXT_COLOR) .style("text-anchor", "end") .text("Year Built"); // y-axis svg.append("g") .attr("class", "y axis") .style("font-size", ".8em") .style("font-weight", "bold") .call(yAxis) .append("text") .attr("class", "label") .attr("transform", "rotate(-90)") .attr("y", 6) .attr("dy", ".71em") .style("fill", TEXT_COLOR) .style("text-anchor", "end") .text(axes[Y_AXIS].name); addMedianLine(svg, data, x, y, getX, axes[Y_AXIS].fn, axes[Y_AXIS].format, wi, height) addMeanLine(svg, data, x, y, getX, axes[Y_AXIS].fn, axes[Y_AXIS].format, wi, height) // draw dots svg.selectAll(".dot") .data(data) .enter().append("circle") .attr("class", "dot") .attr("r", axes[Y_AXIS].dotSize) .attr("cx", function(d) { return x(getX(d)); }) .attr("cy", function(d) { return y(getY(d)); }) .style("fill", axes[COLOR_KEY].fillColor) .style('stroke', "#888") .style('stroke-width', ".2px") .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"); }) if(axes[COLOR_KEY].legend){ axes[COLOR_KEY].legend(svg, axes[COLOR_KEY], { width: wi, legendOffsetX: axes[Y_AXIS].legendOffsetX, legendOffsetY: height/10, median: d3.median(data, axes[COLOR_KEY].fn) }); }else{ 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 "+GEOGRAPHY); return svgWrapper.node(); }31:T119a,use_map = { var COLOR_KEY = 'UseCode'; var data = _.clone(filter.parcels.features); data = data.filter(function(d){ return /*d.properties.Residential ===*/ true && public_spaces.indexOf(d.properties.ParcelNumber) === -1 && commercial.indexOf(d.properties.ParcelNumber) === -1 && // d.properties.StreetName.indexOf("STRIBLING") !== -1 && // (d.properties.StreetName.indexOf("HUNTLEY") !== -1 || d.properties.StreetName.indexOf("MORGAN") !== -1) && //vacant.indexOf(d.properties.ParcelNumber) !== -1 && d.properties.UseCode !== "Vacant Land" && d.properties.UseCode != "Church" ; }); var units = data.reduce((acc, d) => { if(d.properties.UseCode == "Single Family") return acc+1; if(d.properties.UseCode == "Single Family Attached") return acc+1; if(d.properties.UseCode == "Single Family-1 Conversion") return acc+2; if(d.properties.UseCode == "Duplex") return acc+2; if(d.properties.UseCode == "Single Family-2 Conversion") return acc+3; console.log('known',d.properties.StreetNumber,d.properties.StreetName,d.properties.UseCode, d) if(d.properties.StreetNumber == "214") return acc+6; if(d.properties.StreetNumber == "207") return acc+10; console.log('other',d.properties.UseCode, d) return acc }, 0) console.log('unit count',units,data); console.log(data.map(d=>parseInt(d.properties.YearBuilt)).reduce((acc, d)=>acc+d,0)/units) console.log(_.countBy(data,d => d.properties.YearBuilt)) var axes = AXES(data) data = _.sortBy(data, d => axes[COLOR_KEY].sortNum(d)) const height = 1 * width; console.log(width,height); const svg = d3.select(DOM.svg(width, height)) .style("font-family", "Arial") .style("fill", BACKGROUND_COLOR); let projection = d3.geoAlbers(); const path = d3.geoPath().projection( projection ) const graticule = d3.geoGraticule() projection .scale(1) .translate([0, 0]); const b = path.bounds(filter.parcels); const s = 0.95 / Math.max((b[1][0] - b[0][0]) / width, (b[1][1] - b[0][1]) / height); const t = [(width - s * (b[1][0] + b[0][0])) / 2, (height - s * (b[1][1] + b[0][1])) / 2]; projection .scale(s) .translate(t) svg.append("path") .datum(graticule) .attr("class", "graticule") .attr("d", path); var lots = svg.append("g") .selectAll("path") .data(data) .enter().append("path") .attr("d", path) .style('fill', axes[COLOR_KEY].fillColor) //.style('stroke', TEXT_COLOR) //.style('stroke-width', ".2px") .on("mouseover", d => { usemap_tooltip.style("visibility", "visible").html(tooltipString(d,LATEST_YEAR))}) .on("mousemove", onMousemove(usemap_tooltip)) .on("mouseout", d => usemap_tooltip.style("visibility", "hidden")); var fontSize = Math.floor(height/60); var legend = svg.selectAll(".legend") .data(axes[COLOR_KEY].color.domain()) .enter().append("g") .attr("class", "legend") .attr("transform", function(d, i) { return "translate(" + axes[COLOR_KEY].legendOffsetX + "," + (i * height/44 + height/4) + ")"; }); 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", height/10) .attr("text-anchor", "middle") .style("font-size", fontSize*2+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text(GEOGRAPHY); svg.append("text") .attr("x", width/5) .attr("y", height/10 + fontSize*2.2) .attr("text-anchor", "middle") .style("font-size", fontSize*2+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text("residential properties"); svg.append("text") .attr("x", width/5) .attr("y", height/10 + fontSize*2.2*2) .attr("text-anchor", "middle") .style("font-size", fontSize*2+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text("by home type"); svg.call(d3.zoom() .extent([[0, 0], [width, height]]) .scaleExtent([1, 8]) .on("zoom", function() { lots.attr("transform", d3.event.transform); })); return svg.node(); }32:T1518,AXES = function(data){ var AXES = { 'UseCode': { color: d3.scaleOrdinal(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["2019"] === 'undefined' ? null : d.properties.Assessments["2019"].LandValue)).reverse()), dotSize: 2, fillColor: function(d) { return AXES['LandValue'].color((typeof d.properties.Assessments["2019"] === 'undefined' ? null : d.properties.Assessments["2019"].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["2019"].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; };33:Ted4,addLegendGradient = function(svg, axis, options){ // options: {wi, legendOffsetX, legendOffsetY, color, reverse, median, domain} var wi = (typeof options.wi === 'undefined' ? width : options.wi); var legendOffsetX = (typeof options.legendOffsetX === 'undefined' ? 0 : options.legendOffsetX); var legendOffsetY = (typeof options.legendOffsetY === 'undefined' ? 0 : options.legendOffsetY); var color = (typeof options.color === 'undefined' ? axis.color : options.color); var reverse = (typeof options.reverse === 'undefined' ? false : options.reverse); var domain = (typeof options.domain === 'undefined' ? axis.domain : options.domain); var median = options.median; var legendWidth = wi/4 var legendHeight = Math.ceil(wi/40) var fontSize = Math.round(wi/100) var colorScale = d3.scaleLinear() .range([-legendWidth/2, legendWidth/2]) .domain(domain); //.domain([ d3.min(data, AXES['Assessment'].fn), d3.max(data, AXES['Assessment'].fn)]); var xAxis = d3.axisBottom(colorScale) .tickValues(colorScale.ticks(5)).tickFormat(axis.legendFormat).tickSize(-legendHeight) var xAxisTop = d3.axisTop(colorScale) .tickValues(colorScale.domain()).tickFormat(axis.legendFormat).tickSize(legendHeight) var xAxisMedian = d3.axisTop(colorScale) .tickValues([options.median]).tickFormat(axis.legendFormat).tickSize(legendHeight) //console.log(xAxis); var now = new Date().getTime(); d3_select; var defs = svg.selectAppend("defs") var linearGradient = defs.selectAppend("linearGradient") .attr("id", "linear-gradient-"+now); var legendsvg = svg.append("g") .attr("width", legendWidth) .attr("transform", function(d, i) { return "translate(" + (wi - legendWidth + legendOffsetX) + ",0)"; }); var ticks = colorScale.ticks().sort((a,b)=>a-b); var offset = 0; var offsetMultiplier = 1; console.log('ticks1', ticks) if(reverse){ ticks = ticks.reverse(); offset = 100 offsetMultiplier = -1 } var tickData = ticks.map((t, i, n) => ({ offset: `${offset+100*(i/(n.length-1))*offsetMultiplier}%`, color: color(t), })) tickData = (reverse ? tickData.reverse() : tickData) linearGradient.selectAll("stop") .data(tickData) .enter().append("stop") .attr("offset", d => d.offset) .attr("stop-color", d => d.color); legendsvg.append("rect") .attr("x", -legendWidth/2) .attr("y", legendOffsetY) .attr("width", legendWidth) .attr("height", legendHeight) .style("fill", `url(#linear-gradient-${now})`) legendsvg.append("g") .attr("class", "axis") .attr("transform", "translate(0," + (legendHeight + legendOffsetY) + ")") .call(xAxis) .style("color", BACKGROUND_COLOR) .selectAll("text") .style("font-size", fontSize+"px") .style("color", TEXT_COLOR) legendsvg.append("g") .attr("class", "axis") .attr("transform", "translate(0," + (legendHeight + legendOffsetY) + ")") .call(xAxisTop) .style("color", BACKGROUND_COLOR) .selectAll("text") .style("font-size", fontSize+"px") //.attr("dy", ".5em") .style("color", TEXT_COLOR) if(median){ var medianAxis = legendsvg.append("g") .attr("class", "axis") .attr("transform", "translate(0," + (legendHeight + legendOffsetY) + ")") .call(xAxisMedian) .style("color", BACKGROUND_COLOR) .style("opacity", .5) .style("stroke-dasharray", "5,2") medianAxis.selectAll("text") .style("font-size", fontSize+"px") //.attr("dy", ".5em") .style("color", TEXT_COLOR) medianAxis.selectAll('.tick').append("text") .text('Median:') .style("font-size", fontSize+"px") .style("fill", TEXT_COLOR) .attr("transform", "translate(0," + (-legendHeight-fontSize) + ")") .attr("dy", "-.5em") } }34:T6a2,iterateTaxYears = function(filter){ const noneFound = []; var parcels = {}; var assTypes = ["ImprovementValue","LandValue","TotalValue"]; _.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.assessments.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["Assessments"] === 'undefined'){ parc[x].properties["Assessments"] = {}; } parc[x].properties["Assessments"][d.properties.TaxYear] = { ImprovementValue: d.properties.ImprovementValue, LandValue: d.properties.LandValue, TotalValue: d.properties.TotalValue }; if(typeof parc[x].properties["Assessments"][d.properties.TaxYear-1] !== 'undefined'){ for(var type in assTypes){ parc[x].properties["Assessments"][d.properties.TaxYear][assTypes[type]+"Change"] = (parc[x].properties["Assessments"][d.properties.TaxYear][assTypes[type]] -parc[x].properties["Assessments"][d.properties.TaxYear-1][assTypes[type]] ) / parc[x].properties["Assessments"][d.properties.TaxYear-1][assTypes[type]] } } } }); console.log("none found!", noneFound); return filter.parcels.features }35:T9e1,iterateResidences = function(filter){ if(typeof filter.residential_data === 'undefined') filter.residential_data = filter.residences; if(filter.residential_data.features.length == 0) return filter.parcels.features; _.forEach(filter.parcels.features,function(d){ delete d.properties.SquareFootageFinishedLiving; }) const noneFound = []; var parcels = {}; _.forEach(filter.parcels.features,function(d){ if(d.properties.ParcelNumber == "200022000"){ console.log("200022000",d, parcels[d.properties.ParcelNumber]) } if(typeof parcels[d.properties.ParcelNumber] === 'undefined'){ parcels[d.properties.ParcelNumber] = []; } parcels[d.properties.ParcelNumber].push(d); }); _.forEach(filter.residential_data.features,function(d){ if(d.properties.ParcelNumber == "200022000"){ console.log("200022000b",d, parcels[d.properties.ParcelNumber]) } 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){ var newSqft = getSqft(d); var oldSqft = getSqft(parc[x]); var assign = (!oldSqft ? newSqft : oldSqft + newSqft); if(typeof parc[x].properties.ResidentialDetailRows === 'undefined') parc[x].properties.ResidentialDetailRows = []; parc[x].properties.ResidentialDetailRows.push(d.properties) if(typeof oldSqft !== 'undefined' && parc[x].properties.UseCode == "Single Family" && newSqft == oldSqft){ continue; } //if(d.properties.RecordID_Int == 2737) console.log('2737',d); //if(d.properties.RecordID_Int == 2737) continue; //fix parcel 200022001 if(typeof oldSqft !== 'undefined'){ //console.log("Adding square footage: ", d.properties.ParcelNumber, parc[x].properties.UseCode, ' sqft old:', oldSqft, ' add', newSqft,' new: ',assign); } if(d.properties.YearBuilt === "20018") d.properties.YearBuilt = "2018"; //fix parcel 18A102000 parc[x].properties.SquareFootageFinishedLiving = assign; parc[x].properties.YearBuilt = d.properties.YearBuilt; parc[x].properties.Residential = true; parc[x].properties.ResidentialDetails = d.properties parc[x].properties.UseCode = d.properties.UseCode; } }); console.log("none found!", noneFound); return filter.parcels.features }36:T5c0,iterateCommercial = function(filter){ if(typeof filter.commercial_data === 'undefined') filter.commercial_data = commercial_data; if(filter.commercial_data.features.length == 0) return filter.parcels.features; /*_.forEach(filter.parcels.features,function(d){ delete d.properties.SquareFootageFinishedLiving; })*/ 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.commercial_data.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){ if(typeof parc[x].properties.CommercialDetailRows === 'undefined') parc[x].properties.CommercialDetailRows = []; parc[x].properties.CommercialDetailRows.push(d.properties); parc[x].properties.YearBuilt = d.properties.YearBuilt; parc[x].properties.Commercial = true; parc[x].properties.CommercialDetails = d.properties; parc[x].properties.UseCode = d.properties.UseCode; } }); console.log("none found!", noneFound); return filter.parcels.features }37:T1d23,createMap = function(YEAR, ASSESSMENT_TYPE){ const height = 1 * width; var fontSize = Math.floor(height/12); var strokeWidth = Math.round(width/150)/10; //console.log(width,height); const svg = d3.select(DOM.svg(width, height)) .style("font-family", "Arial") .style("fill", BACKGROUND_COLOR) .on("click", toggleRotate); let projection = d3.geoAlbers(); const path = d3.geoPath().projection( projection ) const graticule = d3.geoGraticule() var green = true; var data = filter.parcels.features; /*data.sort((a, b) => { //sort closest to this year last var yrA = getYearBuilt(a); var yrB = getYearBuilt(b); if(typeof yrA === 'undefined') return -1; if(typeof yrB === 'undefined') return 1; return Math.abs(yrB - YEAR) - Math.abs(yrA - YEAR); });*/ var axis = AXES(data)["Assessment"]; //console.log(axis); var residentialParcels = data.filter(function(d){ return d.properties.Residential === true && public_spaces.indexOf(d.properties.ParcelNumber) === -1 && commercial.indexOf(d.properties.ParcelNumber) === -1 && d.properties.Assessments[YEAR] && d.properties.Assessments[YEAR].ImprovementValue && getUseCode(d) != "Vacant Land"; }); var residentialParcels2019 = 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["2019"] && d.properties.Assessments["2019"].ImprovementValue && getUseCode(d) != "Vacant Land"; }); var vals = []; var fn = d => parseInt(d.properties.Assessments["2019"][ASSESSMENT_TYPE]); //use 2019 so scale stays across years residentialParcels2019.forEach(d => vals.push(fn(d))) vals = _.uniq(vals).sort((a, b) => a-b); //console.log(vals); var start = vals[0] var end = d3.quantile(vals, .9) //top 10% is red var domain = [start, end];//[ d3.min(residentialParcels, fn), d3.max(residentialParcels, fn)] //_.clone(axis.domain); //console.log('domain', domain); function fillColor(parcel) { // Reported LotSquareFeet turns out not to be very accurate. Lots of missing data // Instead, calculate based on the parcel geometry // const sqft = parcel.properties.LotSquareFeet const sqft = turf.area(parcel)*9.322 // eyeballed conversion from LotSquareFeet to this parcel.properties.lot_sf = sqft; //console.log(parcel.properties.Assessment) if(parcel.properties.ParcelNumber == "200247000"){console.log("200247000",parcel)}; if(public_spaces.indexOf(parcel.properties.ParcelNumber) !== -1) return "#17410d"; if(commercial.indexOf(parcel.properties.ParcelNumber) !== -1) return "#987654"; if(vacant.indexOf(parcel.properties.ParcelNumber) !== -1) return "#aaa"; if(typeof parcel.properties.Assessments === 'undefined'){// three parcels too small to see, probably mistakes return "#000"; } var ignore = ["180060100"]; if(ignore.indexOf(parcel.properties.ParcelNumber) !== -1) return; var assessment = parcel.properties.Assessments[YEAR] if(typeof assessment === 'undefined'){ //console.log(parcel.properties) if(typeof subdivisions[parcel.properties.ParcelNumber] === 'undefined'){ //console.log("No assessment available!", YEAR, parcel.properties.ParcelNumber,parcel.properties); if(ASSESSMENT_TYPE == "TotalValue") missing[YEAR].push(parcel.properties.ParcelNumber) return "#333"; } var replacementParcelNum = subdivisions[parcel.properties.ParcelNumber] var replacementParcel = _.find(data, function(d){ return d.properties.ParcelNumber == replacementParcelNum; }) //console.log(replacementParcelNum, replacementParcel) if(typeof replacementParcel.properties.Assessments === 'undefined'){ //console.log("No assessment!", YEAR, replacementParcel.properties.ParcelNumber,replacementParcel.properties); if(ASSESSMENT_TYPE == "TotalValue") missing[YEAR].push(replacementParcel.properties.ParcelNumber) return "#333"; } assessment = replacementParcel.properties.Assessments[YEAR]; } if(assessment.ImprovementValue == 0) return "#aaa"; assessment = assessment[ASSESSMENT_TYPE] var hi = domain[1] var lo = domain[0] if(assessment > hi) assessment = hi //else if(assessment < lo) //return "#cccccc" assessment = (green ? 1 : 0) + (green ? -1 : 1) * (assessment - lo)/(hi - lo) return (green ? d3.interpolateRdYlGn : d3.interpolateYlOrRd)(assessment) } projection .scale(1) .translate([0, 0]); const b = path.bounds(filter.parcels); const s = 0.95 / Math.max((b[1][0] - b[0][0]) / width, (b[1][1] - b[0][1]) / height); const t = [(width - s * (b[1][0] + b[0][0])) / 2, (height - s * (b[1][1] + b[0][1])) / 2]; projection .scale(s) .translate(t) svg.append("path") .datum(graticule) .attr("class", "graticule") .attr("d", path) var defaultStroke = (DARK_MODE ? BACKGROUND_COLOR : TEXT_COLOR); //var newBuildStroke = "#0055ff" var lots = svg.append("g") .selectAll("path") .data(data) .enter().append("path") .attr("d", path) .style('fill', fillColor) .style('stroke', defaultStroke) .style('stroke-width', strokeWidth) /*.style('stroke', d => { console.log(arguments) var built = getYearBuilt(d); return (built <= YEAR && built > YEAR-3 ? newBuildStroke : defaultStroke) }) .style('stroke-width', d => { var built = getYearBuilt(d); return (built <= YEAR && built > YEAR-3 ? Math.sqrt(d.properties.lot_sf)/200 : strokeWidth) })*/ .on("mouseover", d => { map_tooltip.style("visibility", "visible").html(tooltipString(d,YEAR))}) .on("mousemove", onMousemove(map_tooltip)) .on("mouseout", d => map_tooltip.style("visibility", "hidden")); svg.append("text") .attr("x", width/5) .attr("y", height/6) .attr("text-anchor", "middle") .style("font-size", fontSize+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text(YEAR); svg.append("text") .attr("x", width/5) .attr("y", height/6 - fontSize + fontSize/18) .attr("text-anchor", "middle") .style("font-size", fontSize/3+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text(ASSESSMENT_TYPE.replace("Value"," Value")); svg.append("text") .attr("x", width/5) .attr("y", height/6 - fontSize - fontSize/3) .attr("text-anchor", "middle") .style("font-size", fontSize/3+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text(GEOGRAPHY + " Assessments: "); var legendOptions = { wi: width, legendOffsetX: 0, legendOffsetY: height/3, color: d3.scaleSequential((green ? d3.interpolateRdYlGn : d3.interpolateYlOrRd)).domain((green ? domain.reverse() : domain)), domain : (green ? domain.reverse() : domain), reverse: green, median: d3.median(residentialParcels,d => (d.properties.Assessments[YEAR] ? d.properties.Assessments[YEAR][ASSESSMENT_TYPE] : null))} addLegendGradient(svg, axis, legendOptions) svg.call(d3.zoom() .extent([[0, 0], [width, height]]) .scaleExtent([1, 8]) .on("zoom", function() { lots.attr("transform", d3.event.transform); })); return svg.node(); }38:T6e6,tooltipString = function(d, year){ //console.log(getYearBuilt(d)); var format = d3.format("$,"); if(typeof d.properties.Assessments[year] === 'undefined'){ return `${d.properties.StreetNumber} ${d.properties.StreetName}
No data found ☹️` } var yr = getYearBuilt(d); var validChange = pct => typeof pct !== 'undefined' && !isNaN(pct) return ` ${d.properties.StreetNumber} ${d.properties.StreetName}
${(typeof d.properties.OwnerName === 'undefined' || true ? "" : d.properties.OwnerName + "
")} ${getUseCode(d)} ${(getSqft(d) ? "("+d3.format(",")(getSqft(d))+"sf)" : "")}
Total: ${format(d.properties.Assessments[year].TotalValue)} ${validChange(d.properties.Assessments[year].TotalValueChange) ? '('+d3.format("+,.1%")(d.properties.Assessments[year].TotalValueChange)+')' : '' }
Improvements: ${format(d.properties.Assessments[year].ImprovementValue)} ${validChange(d.properties.Assessments[year].ImprovementValueChange) ? '('+d3.format("+,.1%")(d.properties.Assessments[year].ImprovementValueChange)+')' : '' }
Land: ${format(d.properties.Assessments[year].LandValue)} ${validChange(d.properties.Assessments[year].LandValueChange) ? '('+d3.format("+,.1%")(d.properties.Assessments[year].LandValueChange)+')' : '' }
${(yr ? "Year Built: "+getYearBuilt(d) : "")}
Zoning: ${d.properties.Zoning}
Old Zoning: ${d.properties.LegacyZoning}
Lot Size: ${d3.format(".2f")(d.properties.lot_sf/43560)} acres ${typeof d.properties.LastSaleDate !== 'undefined' ? "
Last Sale: "+d3.format("$,")(d.properties.LastSale) +" ("+(new Date(d.properties.LastSaleDate).toLocaleDateString())+")" : ""} `; };39:T513,getUseCode = function(d, squash, adusquash) { var code = d.properties.UseCode; /*if(d.properties.Residential){ code = d.properties.UseCode; }else if(d.properties.Commercial){ code = "Commercial"; }*/ if(d.properties.ParcelNumber == "40C016000") code = "Quadplex"; //fix "Three-Level Split" if(d.properties.ParcelNumber == "400009000") code = "Single Family"; //fix "Four-Level Split" if(squash && adusquash){ switch(code){ case "Single Family-1 Conversion": code = "Single Family + ADU(s)" break; case "Single Family-2 Conversion": code = "Single Family + ADU(s)" break; case "Single Family-3 Conversion": code = "Single Family + ADU(s)" break; case "Apartments 1-10 units": code = "Apartments" break; case "Apartments 11-20 Units": code = "Apartments" break; case "Apartments over 20 units": code = "Apartments" break; } }else if(squash){ switch(code){ case "Apartments 1-10 units": code = "Apartments" break; case "Apartments 11-20 Units": code = "Apartments" break; case "Apartments over 20 units": code = "Apartments" break; } } return code; }3a:T1339,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); 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(); } 3b:T1798,viewof streetsTable = { var streets = {}; _.each(filter.parcels.features, d =>{ if(getUseCode(d, true) == "Vacant Land") return; if(getUseCode(d, true) == "Condo Common Area") return; if(["Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion", "Single Family Attached", "Duplex", "Triplex", "Condominium", "Apartments"].indexOf(getUseCode(d, true)) == -1) console.log(getUseCode(d, true)); if(d.properties.Commercial && getUseCode(d, true) != "Apartments") return; var street = d.properties.StreetName.toLowerCase(); if(Object.keys(streets).indexOf(street) == -1){ streets[street] = []; } streets[street].push(getUseCode(d, true)); }) var i = 0; var all = []; var sfdsonly = []; //var sfds1adu = []; //var sfds2adu = []; var sfds3adu = []; var sfa = []; var duplexes = []; var sfasduplexes = []; var triplexes = []; var condos = []; var apts = []; var more = []; for(var key in streets){ all.push(key); if(_.without(streets[key], "Single Family").length == 0){ sfdsonly.push(key); continue; } /*if(_.without(streets[key], "Single Family", "Single Family-1 Conversion").length == 0){ sfds1adu.push(key); } if(_.without(streets[key], "Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion").length == 0){ sfds2adu.push(key); }*/ if(_.without(streets[key], "Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion").length == 0){ sfds3adu.push(key); continue; } if(_.without(streets[key], "Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion", "Single Family Attached").length == 0){ sfa.push(key); continue; } if(_.without(streets[key], "Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion", "Duplex").length == 0){ duplexes.push(key); continue; } if(_.without(streets[key], "Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion", "Single Family Attached", "Duplex").length == 0){ sfasduplexes.push(key); continue; } if(_.without(streets[key], "Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion", "Single Family Attached", "Duplex", "Triplex").length == 0){ triplexes.push(key); continue; } if(_.without(streets[key], "Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion", "Single Family Attached", "Duplex", "Triplex", "Condominium").length == 0){ condos.push(key); continue; } if(_.without(streets[key], "Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion", "Single Family Attached", "Duplex", "Triplex", "Condominium", "Apartments").length == 0){ apts.push(key); continue; } if(_.without(streets[key], "Single Family", "Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion", "Single Family Attached", "Duplex", "Triplex", "Condominium", "Apartments").length > 0){ more.push(key); console.log("more",more) continue; } i++; } var rows = []; var types = { //all: {name: "Street", streets: all.sort()}, sfdsonly: {name: "SFDs only", streets: sfdsonly.sort()}, //sfds1adu: {name: "SFDs and 1 ADU", streets: sfds1adu.sort()}, //sfds2adu: {name: "SFDs and 1 or 2 ADUs", streets: sfds2adu.sort()}, sfds3adu: {name: "ADUs", streets: sfds3adu.sort()}, sfa: {name: "Single Family Attached", streets: sfa.sort()}, duplexes: {name: "Duplexes", streets: duplexes.sort()}, sfasduplexes: {name: "Single Family Attached
+ Duplexes", streets: sfasduplexes.sort()}, triplexes: {name: "Triplexes", streets: triplexes.sort()}, condos: {name: "Condos", streets: condos.sort()}, apts: {name: "Apts", streets: apts.sort()}, //more: {name: "Greater than duplexes", streets: more.sort()}, } console.log(types) for(var x in types){ for(var y in types[x].streets){ if(y >= rows.length) rows.push({}); rows[y][x] = types[x].streets[y]; } } console.log(rows) var nonSFDTypes = ["Single Family-1 Conversion", "Single Family-2 Conversion", "Single Family-3 Conversion", "Single Family Attached", "Duplex", "Triplex", "Condominium"]; console.log(streets); return html` ${rows.map(function(row, index){ return `` })}

# (Total: ${Object.keys(streets).length})	${types.sfdsonly.name} (${types.sfdsonly.streets.length})	${types.sfds3adu.name} (${types.sfds3adu.streets.length})	${types.sfa.name} (${types.sfa.streets.length})	${types.duplexes.name} (${types.duplexes.streets.length})	${types.sfasduplexes.name} (${types.sfasduplexes.streets.length})	${types.triplexes.name} (${types.triplexes.streets.length})	${types.condos.name} (${types.condos.streets.length})	${types.apts.name} (${types.apts.streets.length})
${index+1}	${row.sfdsonly ? row.sfdsonly : ''}	${row.sfds3adu ? row.sfds3adu : ''}	${row.sfa ? row.sfa : ''}	${row.duplexes ? row.duplexes : ''}	${row.sfasduplexes ? row.sfasduplexes : ''}	${row.triplexes ? row.triplexes : ''}	${row.condos ? row.condos : ''}	${row.apts ? row.apts : ''}

` }3c:T7b4,//parcels = d3.json("https://opendata.arcgis.com/datasets/0e9946c2a77d4fc6ad16d9968509c588_72.geojson") parcels = (CACHE ? (EVEN_MORE_CACHE ? {type: "FeatureCollection", features: []} : d3jsonWithRetry(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); }) );3d: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"]; }3e: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", } }3f:Tb53,export_filter = { /*var clone = { parcels : { type: "FeatureCollection", features: _.clone(filter.parcels.features) }, assessments: {type: "FeatureCollection", features: []}, residential_data: {type: "FeatureCollection", features: []}, commercial_data: {type: "FeatureCollection", features: []}, } for(var x in clone.parcels.features){ delete clone.parcels.features[x].properties.FileType; delete clone.parcels.features[x].properties.GeoParcelIdentificationNumber; delete clone.parcels.features[x].properties.IsMultiParcelPolygon; delete clone.parcels.features[x].properties.Label; delete clone.parcels.features[x].properties.LegalDescription; delete clone.parcels.features[x].properties.LotSquareFeet; delete clone.parcels.features[x].properties.MapPage; delete clone.parcels.features[x].properties.ModifiedDate; delete clone.parcels.features[x].properties.OBJECTID; delete clone.parcels.features[x].properties.OwnerAddress; delete clone.parcels.features[x].properties.OwnerCityState; delete clone.parcels.features[x].properties.OwnerName; delete clone.parcels.features[x].properties.OwnerZipCode; delete clone.parcels.features[x].properties.Residence; delete clone.parcels.features[x].properties.TaxYear; delete clone.parcels.features[x].properties.Text; if(typeof clone.parcels.features[x].properties.ResidentialDetails !== 'undefined'){ delete clone.parcels.features[x].properties.ResidentialDetails.Basement; delete clone.parcels.features[x].properties.ResidentialDetails.BasementGarage; delete clone.parcels.features[x].properties.ResidentialDetails.BasementType; delete clone.parcels.features[x].properties.ResidentialDetails.Basement; delete clone.parcels.features[x].properties.ResidentialDetails.ExternalWalls; delete clone.parcels.features[x].properties.ResidentialDetails.FinishedBasement; delete clone.parcels.features[x].properties.ResidentialDetails.Fireplace; delete clone.parcels.features[x].properties.ResidentialDetails.Flooring; delete clone.parcels.features[x].properties.ResidentialDetails.FullBathrooms; delete clone.parcels.features[x].properties.ResidentialDetails.Grade; delete clone.parcels.features[x].properties.ResidentialDetails.HalfBathrooms; delete clone.parcels.features[x].properties.ResidentialDetails.Heating; delete clone.parcels.features[x].properties.ResidentialDetails.NumberOfStories; delete clone.parcels.features[x].properties.ResidentialDetails.RecordID_Int; delete clone.parcels.features[x].properties.ResidentialDetails.Roof; delete clone.parcels.features[x].properties.ResidentialDetails.Style; delete clone.parcels.features[x].properties.ResidentialDetails.TotalRooms; } } //console.log(clone) console.log(JSON.stringify(clone))*/ }40:[] 2e:{"id":"ae6c3a0e19835e3a","slug":"frys-spring-assessment-data","title":"Fry's Spring Assessment Data","thumbnail":"c20aaa3ead46c6efc2083ce86d99d2c07e994a879775a7e5bc05bf670c72e00e","access_level":"public","create_time":"$D2019-04-08T16:12:39.604Z","update_time":"$D2026-03-02T20:56:36.671Z","view_time":null,"first_public_time":"$D2019-04-20T18:02:27.892Z","has_unpublished_edits":null,"fork":{"id":"df58b9b19afab396","slug":"charlottesville-city-assessment-data/2","title":"Charlottesville City Assessment Data","owner":{"id":"80ffc3df21218af5","login":"meekohi","name":"Michael Holroyd"}},"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":3885,"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":4,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Fry's Spring Assessment Data","cells":[{"id":0,"value":"md`# ${GEOGRAPHY} Assessment Data\n## Home Type, Square Footage, and Value — 2010-2019`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1643,"value":"CACHE = false","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2412,"value":"EVEN_MORE_CACHE = false","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2760,"value":"GEOGRAPHY = \"Fry's Spring\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1710,"value":"md`# Assessment Map`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1714,"value":"md`### Map Options`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1546,"value":"viewof ASSESSMENT_TYPE = select({\n title: \"Assessment\",\n description: \"Select total, improvements, or land.\",\n options: [\n { label: \"Total\", value: \"TotalValue\" },\n { label: \"Improvements\", value: \"ImprovementValue\" },\n { label: \"Land\", value: \"LandValue\" }\n ],\n value: \"Assessment\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1466,"value":"ROTATE = radio({\n title: 'Animate?',\n description: '',\n options: [\n { label: 'On', value: 1 },\n { label: 'Off', value: 0 },\n ],\n value: 0\n})","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 = slider({\n min: 2010,\n max: LATEST_YEAR,\n step: 1,\n value: LATEST_YEAR,\n format: \"\",\n title: 'Year',\n description:\n \"Select a map year to display.\"\n})","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 = {\n return 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}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1373,"value":"viewof COLOR_KEY = select({\n title: \"Color Dimension: \",\n description: \"Pick a color dimension.\",\n options: [\n { label: \"Home Type\", value: \"UseCode\" },\n { label: \"Assessment\", value: \"Assessment\" },\n { label: \"Assessment/sqft\", value: \"AssessmentPsf\" },\n { label: \"Square Feet\", value: \"Sqft\" },\n { label: \"Acreage\", value: \"Acreage\" },\n ],\n value: \"UseCode\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1921,"value":"MAX_Y_SLIDER = {\n return slider(Object.assign(sliderOptions[Y_AXIS], {\n format: \"\",\n title: 'Maximum '+Y_AXIS,\n description:\n \"Max y-axis value.\"\n }))\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":2065,"value":"md`## Use Map`","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":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":3711,"value":"LATEST_YEAR = \"2026\" //new Date()).getFullYear()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1911,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2921,"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":1479,"value":"TEXT_COLOR = (DARK_MODE ? \"#e0e0e0\" : \"#000\");","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1769,"value":"BACKGROUND_COLOR = (DARK_MODE ? \"#0f0f0f\" : \"#fff\");","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1762,"value":"FILTER_CACHE_URL = \n\"https://gist.githubusercontent.com/RoryStolzenberg/f627c33ea355d01cc3b29113989c101d/raw/cef3ae4500891f77c5de011836d43978295e043a/frys%2520spring%2520parcels%25202019-04-29.json\"\n//\"https://gist.githubusercontent.com/RoryStolzenberg/4f5efe7ceb972e463f29f0585d2db983/raw/aaf08ce4c61de14b0e66520f150e06cc0a298e93/frys%2520spring%2520parcels%25202019-04-25.json\"\n//\"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(EVEN_MORE_CACHE)\n return d3jsonWithRetry(FILTER_CACHE_URL);\n \n var results = {\n parcels: _.clone(parcels),\n assessments: _.clone(assessments),\n residential_data: _.clone(residential_data),\n commercial_data: _.clone(commercial_data),\n }\n results.parcels.features = results.parcels.features.filter(function(d){\n return frysspring.indexOf(d.properties.ParcelNumber) !== -1;\n });\n results.assessments.features = results.assessments.features.filter(function(d){\n return frysspring.indexOf(d.properties.ParcelNumber) !== -1;\n });\n results.residential_data.features = results.residential_data.features.filter(function(d){\n return frysspring.indexOf(d.properties.ParcelNumber) !== -1;\n });\n return results;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"yrs = {\n var years = {\n \"2000\": [],\n \"2001\": [],\n \"2002\": [],\n \"2003\": [],\n \"2004\": [],\n \"2005\": [],\n \"2006\": [],\n \"2007\": [],\n \"2008\": [],\n \"2009\": [],\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":2687,"value":"iterate = {\n iterateTaxYears(filter);\n iterateResidences(filter);\n iterateCommercial(filter);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":254,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":600,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2011,"value":"$36","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":3549,"value":"test = {\n var YEAR = 2019\n var data = filter.parcels.features;\n var residentialParcels = data.filter(function(d){\n return d.properties.Residential === true && \n public_spaces.indexOf(d.properties.ParcelNumber) === -1 && \n commercial.indexOf(d.properties.ParcelNumber) === -1 && \n d.properties.Assessments[YEAR] && \n d.properties.Assessments[YEAR].ImprovementValue && \n getUseCode(d) != \"Vacant Land\";\n });\n return d3.median(residentialParcels,d => (d.properties.Assessments[YEAR] ? d.properties.Assessments[YEAR][ASSESSMENT_TYPE] : null))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1510,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2835,"value":"addMeanLine = function(svg, data, x, y, getX, getY, format, wi, height){\n var mean = d3.mean(data, getY);\n var mean_line = d3.line()\n .x(d => x(d))\n .y(d => y(mean));\n \n //draw mean line\n svg.append(\"path\").datum(d3.range(d3.min(data, getX), d3.max(data, getX))).attr(\"d\", mean_line)\n .style(\"stroke\", TEXT_COLOR)\n .style(\"stroke-dasharray\", 4)\n .style(\"stroke-opacity\", .4)\n .style(\"stroke-width\", height/600)\n //mean line label\n svg.append(\"text\")\n .attr(\"x\", (wi / 200)) \n .attr(\"y\", y(mean) - height/200)\n .style(\"font-size\", \"12px\")\n .style(\"font-weight\", \"bold\")\n .style(\"fill\", TEXT_COLOR)\n .style(\"opacity\", .4)\n .text(\"Mean: \"+format(mean));\n return svg\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2827,"value":"addMedianLine = function(svg, data, x, y, getX, getY, format, wi, height){\n var median = d3.median(data, getY);\n var median_line = d3.line()\n .x(d => x(d))\n .y(d => y(median));\n \n var fontSize = 12;\n //draw median line\n svg.append(\"path\").datum(d3.range(d3.min(data, getX), d3.max(data, getX))).attr(\"d\", median_line)\n .style(\"stroke\", TEXT_COLOR)\n .style(\"stroke-dasharray\", 4)\n .style(\"stroke-opacity\", .4)\n .style(\"stroke-width\", height/600)\n //median line label\n svg.append(\"text\")\n .attr(\"x\", (wi / 200)) \n .attr(\"y\", y(median) + fontSize)\n .style(\"font-size\", fontSize+\"px\")\n .style(\"font-weight\", \"bold\")\n .style(\"fill\", TEXT_COLOR)\n .style(\"opacity\", .4)\n .text(\"Median: \"+format(median));\n return svg\n}","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]] = map_loading_text(y);\n }\n }\n return maps;\n}(width)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3756,"value":"map_loading_text = yr => \"Loading \"+yr+\" map...\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1618,"value":"map_rotate = {\n let i = Object.keys(maps)[0];\n while (true) {\n var convertedSpeed = 4000/speed;\n i = YEAR.input.value;\n if(ROTATE.input.value == 1){\n i++;\n var keys = Object.keys(maps)\n if(i > keys[keys.length - 1]){\n i = keys[0];\n }else if(i == keys[keys.length - 1]){\n convertedSpeed *= 5;\n }\n YEAR.input.value = i;\n YEAR.dispatchEvent(new CustomEvent(\"input\", { bubbles: true }));\n }\n yield Promises.delay(convertedSpeed, i);\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2714,"value":"MAX_Y = Generators.observe(next => {\n next(MAX_Y_SLIDER.value);\n \n const inputted = () => {\n return next(MAX_Y_SLIDER.value);\n };\n MAX_Y_SLIDER.addEventListener(\"input\", inputted);\n return () => MAX_Y_SLIDER.removeEventListener(\"input\", inputted);\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3392,"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: 1250000,\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":2448,"value":"toggleRotate = function(){\n ROTATE.input.value = (ROTATE.input.value == 1 ? 0 : 1)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1837,"value":"map_tooltip = tooltip('map')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1971,"value":"usemap_tooltip = tooltip('usemap')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1841,"value":"plot_tooltip = tooltip('plot')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3717,"value":"zone_strip_historic_map = {\n return {\n \"R-1UH\": \"R-1U\",\n \"R-1H\": \"R-1\",\n \"B-1H\": \"B-1\",\n \"UHDH\": \"UHD\",\n \"UMDH\": \"UMD\",\n \"R-2C\": \"R-2\",\n \"DNH\": \"DN\",\n \"R-1SC\": \"R-1S\",\n \"WSH\": \"WS\",\n \"R-1SH\": \"R-1S\",\n \"R-3H\": \"R-3\",\n \"R-1C\": \"R-1\",\n \"MLTPC\": \"MLTP\",\n \"R-2UH\": \"R-2U\",\n \"R-1SUH\": \"R-1SU\",\n \"DNC\": \"DN\",\n \"CDH\": \"CD\",\n \"B-3H\": \"B-3\",\n \"HS\": \"HS\",\n \"DH\": \"D\",\n \"SSH\": \"SS\",\n \"WMEH\": \"WME\",\n \"R-2H\": \"R-2\",\n \"CCH\": \"CC\",\n \"WMWH\": \"WMW\",\n \"B-1C\": \"B-1\",\n \"CHH\": \"CH\",\n \"R-1SHC\": \"R-1S\",\n \"PUDH\": \"PUD\",\n \"WMSH\": \"WMS\",\n \"HSC\": \"HS\",\n \"MLTPH\": \"MLTP\",\n \"WSDH\": \"WSD\",\n \"B-2H\": \"B-2\",\n \"MRH\": \"MR\",\n \"ICH\": \"IC\",\n \"WMNH\": \"WMN\",\n \"DEH\": \"DE\",\n \"NCCH\": \"NCC\"\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3722,"value":"zone_strip_historic = zone => zone in zone_strip_historic_map ? zone_strip_historic_map[zone] : zone","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3718,"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":3739,"value":"ADU_PROHIBITED_ZONES = [\"CC\", \"CD\", \"D\", \"DE\", \"DN\", \"ES\", \"HS\", \"HW\", \"IC\", \"M-I\", \"NCC\", \"R-1SU\", \"R-1U\", \"R-2U\", \"SS\", \"URB\", \"WME\", \"WMW\", \"WSD\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3743,"value":"ADU_PERMITTED_ZONES = [\"B-1\",\"B-2\",\"B-3\",\"CH\",\"MHP\",\"MR\",\"R-1\",\"R-1S\",\"R-2\",\"R-3\",\"UHD\",\"UMD\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1898,"value":"tooltip = function(name){\n d3_select;\n return d3.select(\"body\")\n .selectAppend(\"div\"+name+\"tooltip\")\n .style(\"position\", \"absolute\")\n .style(\"font-family\", \"'Open Sans', sans-serif\")//font\n .style(\"font-size\", \"12px\")\n .style(\"z-index\", \"1000\")\n .style(\"visibility\", \"hidden\")\n .style(\"background-color\", TEXT_COLOR)//set the background color\n .style(\"color\", BACKGROUND_COLOR)\n .style(\"padding\", \"5px\")//set the padding (all sides)\n .style(\"opacity\", \".9\"); //set the opacity\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1886,"value":"onMousemove = 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 tooltip.style(\"top\", (d3.event.pageY -10)+\"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":1833,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1066,"value":"getYearBuilt = function(d) { \n if(!d.properties.YearBuilt || parseInt(d.properties.YearBuilt) < 1800){\n //console.log(d.properties.YearBuilt,d);\n return;\n }\n return parseInt(d.properties.YearBuilt);\n};","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1074,"value":"getSqft = function(d) {\n //return d.properties.Assessment;\n if(!d.properties.SquareFootageFinishedLiving || d.properties.SquareFootageFinishedLiving == \"\"){\n return;\n }\n return parseInt(d.properties.SquareFootageFinishedLiving);\n};","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1175,"value":"getAssessmentPsf = function(d) {\n var sqft = getSqft(d)\n if(typeof sqft === 'undefined')\n return;\n if(d.properties.Assessment / sqft > 1000)\n console.log('high AssessmentPsf (>1000):', d, d.properties.Assessment / parseInt(d.properties.SquareFootageFinishedLiving));\n return d.properties.Assessment / sqft;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2038,"value":"$39","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":2345,"value":"md`### Year Built`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":602,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2341,"value":"md`### Residential Streets by Home Types`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2091,"value":"$3b","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, button} from \"@jashkenas/inputs\"","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":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":3866,"value":"d3jsonWithRetry = async function(url, retries = 3, delay = 1000) {\n for (let i = 0; i < retries; i++) {\n try { return await d3.json(url); }\n catch (e) {\n if (i === retries - 1) throw e;\n await new Promise(r => setTimeout(r, delay * Math.pow(2, i)));\n }\n }\n}\n","pinned":true,"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":1660,"value":"ASSESSMENTS_URL = \"https://opendata.arcgis.com/datasets/b993cd4e2e1b4ba097fb58c90725f5da_2.geojson\"\n//ASSESSMENTS_URL = \"https://cors-anywhere.herokuapp.com/https://opendata.arcgis.com/datasets/b993cd4e2e1b4ba097fb58c90725f5da_2.geojson\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1661,"value":"RESIDENTIAL_URL = \"https://opendata.arcgis.com/datasets/c7adfdab73104a01a485dec324adcafb_17.geojson\"\n//RESIDENTIAL_URL = \"https://cors-anywhere.herokuapp.com/https://opendata.arcgis.com/datasets/c7adfdab73104a01a485dec324adcafb_17.geojson\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2002,"value":"COMMERCIAL_URL = \"https://opendata.arcgis.com/datasets/17fbd0c459d84c71aa37b436d5231c0b_19.geojson\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1647,"value":"$3c","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: []} : d3jsonWithRetry(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: []} : d3jsonWithRetry(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: []} : d3jsonWithRetry(COMMERCIAL_URL))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1680,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":648,"value":"$3e","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":2308,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3654,"value":"test123 = {\n return filter.parcels.features.filter(d=> d.properties.ParcelNumber == \"200022000\") \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W40","stdlib":"1"}} 2f:"$2e:body"