2b:null 2c:["$","title",null,{"children":"Charlottesville Assessment Changes | Rory Stolzenberg | Observable"}] 31:T3b1c,createMap = function(YEAR, ASSESSMENT_TYPE){ const height = 1 * width; var fontSize = Math.floor(height/12); var strokeWidth = Math.round(width/200)/10; //console.log(width,height); console.log('bg',BACKGROUND_COLOR) const svg = d3.select(DOM.svg(width, height)) .style("font-family", "Arial") .attr("fill", BACKGROUND_COLOR) .on("click", toggleRotate); let projection = d3.geoAlbers(); const path = d3.geoPath().projection( projection ) const graticule = d3.geoGraticule() var green = true; var HIGHLIGHT_MULTIFAM = false; var data = filter.parcels.features; // data = data.filter(d=>typeof d.properties.Assessments["2021"] !== 'undefined' && d.properties.Assessments["2021"].TotalValue==284700) // data = data.filter(d=> { // return typeof d.properties.UseCode !== 'undefined' && // d.properties.UseCode.indexOf("Duplex") !== -1 && // d.properties.UseCode.indexOf("Single") !== -1 && // d.properties.Assessments["2022"].TotalValue >=375000 && // d.properties.Assessments["2021"].TotalValue < 375000 && // d.properties.Assessments["2021"].ImprovementValue > 10000 && // d.properties.Assessments["2022"].ImprovementValue/d.properties.Assessments["2021"].ImprovementValue <1.5 && // true // }) // console.log(_.countBy(data,d=>(new Date(d.properties.LastSaleDate)).getFullYear())) // console.log('total diff',data.reduce((acc,cur)=> acc+cur.properties.Assessments["2022"].TotalValue - cur.properties.Assessments["2021"].TotalValue,0)) // console.log('total land',data.reduce((acc,cur)=> acc+cur.properties.Assessments["2022"].LandValue,0)) // console.log('differences',data.map((cur)=> cur.properties.Assessments["2022"].TotalValue - cur.properties.Assessments["2021"].TotalValue,0).sort((a,b)=>b-a)) // console.log('differences',data.map(d=> { // return {ass: d.properties.Assessments["2022"].TotalValue - d.properties.Assessments["2021"].TotalValue, address: d.properties.StreetNumber+" "+d.properties.StreetName, parcel: d} // },0).sort((a,b)=>b.ass-a.ass)) // console.log(data) // console.log('total assessmnet',data.reduce((acc,cur)=> { // if(typeof cur.properties.Assessments ==='undefined') // return acc; // if(typeof cur.properties.Assessments["2024"] ==='undefined') // return acc; // return acc+cur.properties.Assessments["2024"].TotalValue // },0)) // data = data.filter(d=> d.properties.OwnerName.indexOf("RECTOR") !== -1 && ["100060000","100116000","100083000","100088000"].indexOf(d.properties.ParcelNumber) === -1) // data = data.filter(d => typeof d.properties.LastSaleDate !== 'undefined' && d.properties.LastSaleDate.indexOf("202") == 0) // data = data.filter(d => typeof d.properties.LastSaleDate === 'undefined' || d.properties.LastSaleDate.indexOf("202") == -1) //data = data.filter(d=> d.properties.Assessment > 900000) // data = data.filter(d=> d.properties.Assessment < 1100000) // data = data.filter(d=> d.properties.YearBuilt > 2010)" // data = data.filter(d=> d.properties.Assessments["2022"][ASSESSMENT_TYPE+"Change"] < 0) data = data.filter(d => { var use = getUseCode(d, true, true) return true && // use !== "Single Family" && // use !== "Single Family + ADU(s)" && typeof use !== 'undefined' && // use.indexOf("Single Family") !== -1 && // d.properties.Residential && // uncountable_res_uses.indexOf(getUseCode(d, true, true)) === -1 && true; }) // if(HIGHLIGHT_MULTIFAM == 1){ // sort by use if we're putting stroke on multi-units, so they can rise to top // var is_multi = d => { // if(typeof d.properties.UseCode === 'undefined') return false; // if(d.properties.Residential != true || getUseCode(d,true,true) == "Apartments") return false; // if(nonres_uses.indexOf(getUseCode(d, true, true)) !== -1) return false; // return units_by_use(d) > 1 || ["Condominium","Single Family Attached"].indexOf(getUseCode(d, true, true)) !== -1; // } // var multi = data.filter(is_multi); // var nonmulti = data.filter(d => !is_multi(d)); // console.log('data recombination', data,multi,nonmulti) // data = nonmulti.concat(multi) // console.log(data) // console.log(data.map(getUseCode)) // } console.log('all uses', _.uniq(data.map(getUseCode))) /*data.sort((a, b) => { //sort closest to this year last var yrA = getYearBuilt(a); var yrB = getYearBuilt(b); if(typeof yrA === 'undefined') return -1; if(typeof yrB === 'undefined') return 1; return Math.abs(yrB - YEAR) - Math.abs(yrA - YEAR); });*/ var axis = AXES(data)["Assessment"]; axis.legendFormat = d3.format("+,.1%") // axis.legendFormat = d3.format("$,r") //console.log(axis); var residentialParcels = data.filter(function(d){ if(typeof d.properties.Assessments[YEAR] === 'undefined'){ console.log(YEAR, "not found", 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 && !isNaN(d.properties.Assessments[YEAR][ASSESSMENT_TYPE+"Change"]) && uncountable_res_uses.indexOf(getUseCode(d, true, true)) === -1 && true; }); console.log('residentialParcels parcel count:', residentialParcels.length, // "unit count:", // residentialParcels.reduce((acc, d) => acc+units_by_use(d),0), // "count w adus:", // residentialParcels.reduce((acc, d) => acc+units_by_use(d,true), 0) ) var scaleParcels = data.filter(function(d){ return d.properties.Residential === true && public_spaces.indexOf(d.properties.ParcelNumber) === -1 && commercial.indexOf(d.properties.ParcelNumber) === -1 && d.properties.Assessments[YEAR] && // d.properties.Assessments[YEAR].ImprovementValue && !isNaN(d.properties.Assessments[YEAR][ASSESSMENT_TYPE+"Change"]) && uncountable_res_uses.indexOf(getUseCode(d, true, true)) === -1 && // ["Single Family", "Single Family + ADU(s)"].indexOf(getUseCode(d,true, true)) !== -1 && true; }); console.log('scaleParcels unit count', scaleParcels.length, scaleParcels.reduce((acc, d) => acc+units_by_use(d), 0)) // scaleParcels = scaleParcels.filter(d => ) var scalevals = []; scalevals = scaleParcels.map(d => { //use LATEST_YEAR so scale stays across years // return d.properties.Assessment - d.properties.LastSale return d.properties.Assessments[YEAR][ASSESSMENT_TYPE+"Change"]; }) // scaleParcels.forEach(d => scalevals.push(fn(d))) // console.log('scaleParcels', scaleParcels.filter(d=> { // return fn(d) <= 65000//71000 // return getUseCode(d).indexOf("Single") === -1 && // getUseCode(d).indexOf("Condo") === -1 && // getUseCode(d).indexOf("Duplex") === -1 // }).map(d=> tooltipString(d, YEAR))) scalevals = scalevals.sort((a, b) => a-b); console.log('scalevals',scalevals); console.log('scalevals median:', d3.median(scalevals), 'std:', d3.deviation(scalevals)) console.log('scalevals low:', scalevals[0], 'high:', scalevals[scalevals.length-1]) var start = d3.quantile(scalevals, .003) //scalevals[0]; var end = d3.quantile(scalevals, .95)//(d3.median(scalevals) - start) + d3.median(scalevals);//d3.quantile(scalevals, .90) //top 10% is red var domain = [start, end];//[ d3.min(residentialParcels, fn), d3.max(residentialParcels, fn)] //_.clone(axis.domain); console.log('domain', domain); 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 BACKGROUND_COLOR; } 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]; } console.log('missing', missing[YEAR]) // if(assessment.ImprovementValue == 0) // return "#aaa"; // assessment = parcel.properties.Assessment - parcel.properties.LastSale assessment = assessment[ASSESSMENT_TYPE+"Change"] if(isNaN(assessment)){ return BACKGROUND_COLOR } 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) var color = (green ? d3.interpolateRdBu : d3.interpolateYlOrRd)(assessment) if(parcel.properties.FileType == "E") return color.replace(")",",.2)") return color /*var hi = domain[1] var lo = domain[0] if(assessment > hi) assessment = hi //else if(assessment < lo) //return "#cccccc" assessment = (green ? 1 : 0) + (green ? -1 : 1) * (assessment - lo)/(hi - lo) return (green ? d3.interpolateRdYlGn : d3.interpolateYlOrRd)(assessment)*/ } projection .scale(1) .translate([0, 0]); const b = path.bounds(filter.parcels); const s = 0.95 / Math.max((b[1][0] - b[0][0]) / width, (b[1][1] - b[0][1]) / height); const t = [(width - s * (b[1][0] + b[0][0])) / 2, (height - s * (b[1][1] + b[0][1])) / 2]; projection .scale(s) .translate(t) svg.append("path") .datum(graticule) .attr("class", "graticule") .attr("d", path) // var hoods = svg.append("g") // .selectAll("path") // .data(neighborhoods.features) // .enter().append("path") // .attr("d", path) // .style('stroke', d=> "#444") var defaultStroke = (DARK_MODE ? BACKGROUND_COLOR : TEXT_COLOR); //var newBuildStroke = "#0055ff" var lots = svg.append("g") .selectAll("path") .data(data) .enter().append("path") .attr("d", path) .style('fill', fillColor) // .style('stroke', defaultStroke) // .style('stroke-width', strokeWidth) .style('stroke', d => { if(HIGHLIGHT_MULTIFAM == false) return defaultStroke; if (d.properties.Commercial) return defaultStroke; if (d.properties.Residential != true) return defaultStroke; if (uncountable_res_uses.indexOf(getUseCode(d, true, true)) !== -1) return defaultStroke; if (units_by_use(d, false) > 1 ) return "#ddd"; if (["Condominium","Single Family Attached"].indexOf(getUseCode(d, true, true)) !== -1) return "#ddd"; return defaultStroke }) .style('stroke-width', strokeWidth/1.5) /*.style('stroke', d => { console.log(arguments) var built = getYearBuilt(d); return (built <= YEAR && built > YEAR-3 ? newBuildStroke : defaultStroke) }) .style('stroke-width', d => { var built = getYearBuilt(d); return (built <= YEAR && built > YEAR-3 ? Math.sqrt(d.properties.lot_sf)/200 : strokeWidth) })*/ .on("mouseover", d => { var gpin = d.properties.GeoParcelIdentificationNumber; var coterm = data.filter(p => p.properties.GeoParcelIdentificationNumber == gpin) var html = ""; for(var x in coterm){ html += tooltipString(coterm[x],YEAR); html += "
" } map_tooltip.style("visibility", "visible").html(html) return true; }) .on("mousemove", onMousemoveTooltip(map_tooltip)) .on("mouseout", d => map_tooltip.style("visibility", "hidden")); svg.append("text") .attr("x", width/5) .attr("y", height/6) .attr("text-anchor", "middle") .style("font-size", fontSize+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text(YEAR); svg.append("text") .attr("x", width/5) .attr("y", height/6 - fontSize + fontSize/18) .attr("text-anchor", "middle") .style("font-size", fontSize/3+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text(ASSESSMENT_TYPE.replace("Value"," Value") + " Change"); svg.append("text") .attr("x", width/5) .attr("y", height/6 - fontSize - fontSize/3) .attr("text-anchor", "middle") .style("font-size", fontSize/3+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text(GEOGRAPHY + " Assessments: "); var legendOptions = { wi: width, legendOffsetX: width/20, legendOffsetY: height/10, color: d3.scaleSequential((green ? d3.interpolateRdBu : d3.interpolateYlOrRd)).domain((green ? domain.reverse() : domain)), domain : (green ? domain.reverse() : domain), reverse: green, median: d3.median(residentialParcels,d => { //use LATEST_YEAR so scale stays across years // var ass = d.properties.Assessment - d.properties.LastSale; var ass = parseInt(d.properties.Assessments[YEAR][ASSESSMENT_TYPE+"Change"]); // var units = units_by_use(d, false); // return ass / units; return ass; }) // d => (d.properties.Assessments[YEAR] ? d.properties.Assessments[YEAR][ASSESSMENT_TYPE] : null) } addLegendGradient(svg, axis, legendOptions) svg.call(d3.zoom() .extent([[0, 0], [width, height]]) .scaleExtent([1, 8]) .on("zoom", function() { // hoods.attr("transform", d3.event.transform); lots.attr("transform", d3.event.transform); })); return svg.node(); }32:[] 2f:{"id":"2b7f19fe1996f611","slug":"charlottesville-assessment-changes","title":"Charlottesville Assessment Changes","thumbnail":"d59eea21470a6019f89c1ddb204dac580f68ab8c438ca1eaa8ce8507528a211a","access_level":"public","create_time":"$D2022-02-16T22:45:16.907Z","update_time":"$D2026-03-03T15:04:44.422Z","view_time":null,"first_public_time":"$D2023-01-30T17:12:40.041Z","fork":false,"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":357,"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":true,"trashed":false,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Charlottesville Assessment Changes","cells":[{"id":0,"value":"# Charlottesville Assessment Changes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":123,"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"},{"id":45,"value":"map = createMap(\"2026\", ASSESSMENT_TYPE)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":21,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":12,"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"},{"id":10,"value":"turf = require('https://npmcdn.com/@turf/turf/turf.min.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":125,"value":"import {radio, select, slider, text} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":8,"value":"_ = require(\"underscore\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6,"value":"import {neighborhoods, parcels, sales, residential_data, commercial_data, base_data, iterate, getUseCode, sf_get_percentile, sf_get_rank, sf_rank, d3jsonWithRetry} with {assessments} from \"@rorystolzenberg/charlottesville-assessment-data\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":350,"value":"d3csvWithRetry = async function(url, retries = 8, delay = 1000) {\n for (let i = 0; i < retries; i++) {\n try { return await d3.csv(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":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":296,"value":"raw_assessments = d3csvWithRetry(\"https://opendata.arcgis.com/api/v3/datasets/b993cd4e2e1b4ba097fb58c90725f5da_2/downloads/data?format=csv&spatialRefId=4326&where=1%3D1\")//d3.csv(\"https://opendata.arcgis.com/datasets/b993cd4e2e1b4ba097fb58c90725f5da_2.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":288,"value":"assessments = {\n var asses = {\n type: \"FeatureCollection\",\n name: \"Real_Estate_(All_Assessments)\",\n features:[],\n }\n for(var x in raw_assessments){\n var ass = raw_assessments[x]\n ass.RecordID_Int = parseInt(ass.RecordID_Int)\n ass.LandValue = parseInt(ass.LandValue)\n ass.ImprovementValue = parseInt(ass.ImprovementValue)\n ass.TotalValue = parseInt(ass.TotalValue)\n asses.features.push({\n type: \"Feature\",\n properties: ass,\n geometry: null,\n })\n }\n return asses\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":23,"value":"import {addLegendGradient, BACKGROUND_COLOR, toggleRotate, AXES, public_spaces, commercial, uncountable_res_uses, LATEST_YEAR, units_by_use, vacant, subdivisions, missing, nonres_uses, TEXT_COLOR, tooltipString, map_tooltip, onMousemoveTooltip, GEOGRAPHY\n } with {DARK_MODE} from \"@rorystolzenberg/charlottesville-assessment-data\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":92,"value":"DARK_MODE=false","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":340,"value":"parcels2 = parcels","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":18,"value":"filter = {\n //if(CACHE)\n // return d3.json(FILTER_CACHE_URL);\n \n var results = {\n parcels: _.clone(parcels),\n assessments: _.clone(assessments),\n sales: _.clone(sales),\n residential_data: _.clone(residential_data),\n commercial_data: _.clone(commercial_data),\n base_data: _.clone(base_data),\n }\n iterate(results);\n iterate(results);\n\n // parcels.features.map(d=>{\n // if(typeof d.properties.Assessments === 'undefined') return\n // d.properties.Assessments[\"2025\"] = {TotalValue: d.properties.Assessment}\n // if(typeof d.properties.Assessments[\"2024\"] !== 'undefined'){\n // d.properties.Assessments[\"2025\"].TotalValueChange = (d.properties.Assessments[\"2025\"].TotalValue-d.properties.Assessments[\"2024\"].TotalValue)/d.properties.Assessments[\"2024\"].TotalValue\n // }\n // })\n \n return results;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":303,"value":"total = {\n var taxable = filter.parcels.features.filter(d=>d.properties.FileType != \"E\")\n var total2025 = taxable.reduce((acc, d) => {\n if(typeof d.properties.Assessments === 'undefined')\n return acc;\n if(typeof d.properties.Assessments[\"2025\"] === 'undefined')\n return acc;\n return acc+d.properties.Assessments[\"2025\"].TotalValue\n },0)\n // return total2025 * 0.0096\n var total2024 = taxable.reduce((acc, d) => {\n if(typeof d.properties.Assessments === 'undefined' || typeof d.properties.Assessments[\"2024\"] === 'undefined')\n return acc;\n return acc+d.properties.Assessments[\"2024\"].TotalValue\n },0)\n // return total2023 * 0.0096\n return d3.format(\"$,\")((total2025-total2024) * 0.0096)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 30:"$2f:body"