29:null 2a:["$","title",null,{"children":"Tenure & Draft Zoning - 10th & Page | Rory Stolzenberg | Observable"}] 2f:T81c,hood_table = { var pct_fmt = d3.format('.1%') var dlr_fmt = d3.format("$,.0f"); var hoods = {} var rows = []; var pct = owner_occ_med.length/sfds_medium.length rows.push({ "Neighborhood": "Total", "#": sfds_medium.length, "# Owner Occ.": owner_occ_med.length, "# Not Owner": non_owner_occ_med.length, "% Owner Occ.": pct_fmt(pct), "pct": pct, "Median Owner": dlr_fmt(d3.median(owner_occ_med.map(d=>d.properties.Assessment))) + " ("+owner_occ_med.length+")", "Median Non-Owner": dlr_fmt(d3.median(non_owner_occ_med.map(d=>d.properties.Assessment))) + " ("+non_owner_occ_med.length+")", }) var hoods_sorted = Object.keys(medium_by_hood).sort() hoods_sorted.forEach(hood => { var parcels = medium_by_hood[hood] var owner_occ = parcels.filter(is_owner_occupied) var non_owner_occ = parcels.filter(d=> !is_owner_occupied(d)) var pct = owner_occ.length/parcels.length rows.push({ "Neighborhood": hood, "#": parcels.length, "# Owner Occ.": owner_occ.length, "# Not Owner": non_owner_occ.length, "% Owner Occ.": pct_fmt(pct), "pct": pct, "Median Owner": dlr_fmt(d3.median(owner_occ.map(d=>d.properties.Assessment))) + " ("+owner_occ.length+")", "Median Non-Owner": dlr_fmt(d3.median(non_owner_occ.map(d=>d.properties.Assessment))) + " ("+non_owner_occ.length+")", }) }) rows.sort((first, sec) => sec.Neighborhood=="Total" ? -1 : (first.pct < sec.pct ? -1 : 1) ) return html`

R-B + R-C by Neighborhood

${ tabulate(rows, ["Neighborhood", "#", /*"# Owner Occ.", "# Not Owner",*/ "% Owner Occ.", "Median Owner", "Median Non-Owner"]) }

` }30:T475,deciles_table = { var percentiles = [10,20,30,40,50,60,70,80,90,95,99] var all = _.clone(sfds.map ( d=> d.properties.Assessment).sort((first, sec) => first > sec ? -1 : 1)) all = all.reverse() var r_a = _.clone(sfds_ra.map ( d=> d.properties.Assessment).sort((first, sec) => first > sec ? -1 : 1)) r_a = r_a.reverse() var med = _.clone(sfds_medium.map ( d=> d.properties.Assessment).sort((first, sec) => first > sec ? -1 : 1)) med = med.reverse() var fmt = d3.format("$,.0f"); var table = percentiles.map((d, i) => { return { "Percentile": d+"%", "All R-": fmt(d3.quantile(all, d/100)), "R-A": fmt(d3.quantile(r_a, d/100)), "R-B / R-C": fmt(d3.quantile(med, d/100))} }) return html`

Assessments by Zone (SFDs)

${ tabulate(table, ["Percentile", "All R-", "R-A", "R-B / R-C"]) }

` }31:T17a5,createMap = function(){ const height = 1 * width * 0.8; 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) let projection = d3.geoAlbers(); const path = d3.geoPath().projection( projection ) const graticule = d3.geoGraticule() var data = filter.parcels.features; data = data.filter(d=>{ return true && d.properties.Neighborhood == "10th & Page" && // (d.properties.DraftZoning == "R-B" || d.properties.DraftZoning == "R-C") && // (d.properties.DraftZoning !== "R-A") && // typeof d.properties.UseCode !== 'undefined' && // getUseCode(d, true, true).indexOf("Single Family") != -1 && // getUseCode(d, true, true) !== "Single Family Attached" && // getUseCode(d, true, true) !== "Condominium" && // !is_owner_occupied(d) true }) console.log("data to display", data.length, data) var opacityFunction = d => is_owner_occupied(d) ? "40%" : "100%" function fillColor(parcel) { // console.log(parcel) // return "#ff0000" switch(parcel.properties.DraftZoning){ case "R-A": return "#F1E3C0" case "R-B": return "#FEE33A" case "R-C": return "#E5BF22" case "RX-3": return "#F9A424" case "RX-5": return "#C67B29" case "CX-3": return "#BC7562" case "CX-5": return "#954B37" case "CX-8": return "#683527" case "NX-3": return "#BC62A1" case "NX-5": return "#A04484" case "NX-8": return "#81376A" case "NX-10": return "#642B52" case "DX": return "#471F3A" case "IX-5": return "#8BA4BB" case "IX-8": return "#6586A4" case "CV": return "#88C29C" case "CM": return "#58897B" default: return "#eee" } } projection .scale(1) .translate([0, 0]); const b = path.bounds(filter.parcels); const s = 0.95 / Math.max((b[1][0] - b[0][0]) / width, (b[1][1] - b[0][1]) / height); const t = [(width - s * (b[1][0] + b[0][0])) / 2, (height - s * (b[1][1] + b[0][1])) / 2]; projection .scale(s) .translate(t) svg.append("path") .datum(graticule) .attr("class", "graticule") .attr("d", path) var hoods = svg.append("g") .selectAll("path") .data(neighborhoods.features) .enter().append("path") .attr("d", path) .style('stroke', d=> "#444") var defaultStroke = (DARK_MODE ? BACKGROUND_COLOR : TEXT_COLOR); //var newBuildStroke = "#0055ff" var lots = svg.append("g") .selectAll("path") .data(data) .enter().append("path") .attr("d", path) .style('fill', fillColor) .style('fill-opacity', opacityFunction) // .style('stroke', defaultStroke) // .style('stroke-width', strokeWidth) .style('stroke', d => { // if(HIGHLIGHT_MULTIFAM == false) return defaultStroke; // if (d.properties.Commercial) return defaultStroke; // if (d.properties.Residential != true) return defaultStroke; // if (uncountable_res_uses.indexOf(getUseCode(d, true, true)) !== -1) return defaultStroke; // if (units_by_use(d, false) > 1 ) return "#ddd"; // if (["Condominium","Single Family Attached"].indexOf(getUseCode(d, true, true)) !== -1) return "#ddd"; return defaultStroke }) .style('stroke-width', strokeWidth/1.5) /*.style('stroke', d => { console.log(arguments) var built = getYearBuilt(d); return (built <= YEAR && built > YEAR-3 ? newBuildStroke : defaultStroke) }) .style('stroke-width', d => { var built = getYearBuilt(d); return (built <= YEAR && built > YEAR-3 ? Math.sqrt(d.properties.lot_sf)/200 : strokeWidth) })*/ .on("mouseover", d => { console.log('mouseover',d) var gpin = d.properties.GeoParcelIdentificationNumber; var coterm = data.filter(p => p.properties.GeoParcelIdentificationNumber == gpin) var html = "Draft Zoning: "+d.properties.DraftZoning+""; html += "

" for(var x in coterm){ html += tooltipString(coterm[x],LATEST_YEAR); html += "
" html += "Owner: "+coterm[x].properties.OwnerName html += "
" html += "Owner Address: "+coterm[x].properties.OwnerAddress 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+fontSize/3) .attr("text-anchor", "middle") .style("font-size", fontSize/4+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text("(highlighted)"); svg.append("text") .attr("x", width/5) .attr("y", height/6) .attr("text-anchor", "middle") .style("font-size", fontSize/3+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text("Renter-Occupied"); svg.append("text") .attr("x", width/5) .attr("y", height/6 - fontSize/2) .attr("text-anchor", "middle") .style("font-size", fontSize/3+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text("Feb 2023"); svg.append("text") .attr("x", width/5) .attr("y", height/6 - fontSize + fontSize/18) .attr("text-anchor", "middle") .style("font-size", fontSize/2+"px") .style("font-weight", "bold") .style("fill", TEXT_COLOR) .text("Draft Zoning"); 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:T68b,filter = { //if(CACHE) // return d3.json(FILTER_CACHE_URL); var results = { parcels: _.clone(parcels), assessments: _.clone(assessments), sales: _.clone(sales), residential_data: _.clone(residential_data), commercial_data: _.clone(commercial_data), base_data: _.clone(base_data), } iterate(results); iterate(results); // parcels.features.map(d=>{ // d.properties.Assessments["2023"] = {TotalValue: d.properties.Assessment} // if(typeof d.properties.Assessments["2022"] !== 'undefined'){ // d.properties.Assessments["2023"].TotalValueChange = (d.properties.Assessments["2023"].TotalValue-d.properties.Assessments["2022"].TotalValue)/d.properties.Assessments["2022"].TotalValue // } // }) parcels.features.forEach(d=> { d.properties.Neighborhood = find_neighborhood(d) d.properties.lot_sf = turf.area(d)*10.7639 var parcel_num = d.properties.ParcelNumber if(typeof zoning_remap[parcel_num] !== 'undefined'){ d.properties.DraftZoning = zoning_remap[parcel_num].DRAFT_ZONI d.properties.FLUM = zoning_remap[parcel_num].FLUM_Desig }else { if(typeof gpins[d.properties.GeoParcelIdentificationNumber] !== 'undefined'){ for(var x in gpins[d.properties.GeoParcelIdentificationNumber]){ parcel_num = gpins[d.properties.GeoParcelIdentificationNumber][x].ParcelNumber if(typeof zoning_remap[parcel_num] !== 'undefined'){ d.properties.DraftZoning = zoning_remap[parcel_num].DRAFT_ZONI d.properties.FLUM = zoning_remap[parcel_num].FLUM_Desig return } } } } }) return results; }33:[{"id":"c289092d7e4ada34c4a977cdab8fae29f06d6ec9afa49eefbcca627f0b34ae827bccbf8c362c984f24d82ba88b28283ba8cdad4af3557f3ffbbc4780230c0df1","href":"https://static.observableusercontent.com/files/c289092d7e4ada34c4a977cdab8fae29f06d6ec9afa49eefbcca627f0b34ae827bccbf8c362c984f24d82ba88b28283ba8cdad4af3557f3ffbbc4780230c0df1","name":"draft-zoning-2023-02.geojson","type":"application/geo+json","lastModified":1698852607737.453,"size":7608199}] 2d:{"id":"30748e9e66a92aff","slug":null,"title":"Tenure & Draft Zoning - 10th & Page","thumbnail":"3507e8c753a6d61c4714b78bce08d846bb2a276cca0777abbb5be7be65ae72e6","access_level":"public","create_time":"$D2023-11-01T15:30:07.737Z","update_time":"$D2023-11-01T15:32:43.886Z","view_time":null,"first_public_time":"$D2023-11-01T15:30:07.737Z","fork":{"id":"9510d980b490efcc","slug":"tenure-draft-zoning","title":"Tenure & Draft Zoning","owner":{"id":"80a152de5519610c","login":"rorystolzenberg","name":"Rory Stolzenberg"}},"stars":0,"starred":false,"owner":{"type":"team","id":"80a152de5519610c","login":"rorystolzenberg","name":"Rory Stolzenberg","avatar_url":"https://avatars-next.observableusercontent.com/c360e2fec7e4b4fd695b5d26154fb359993edd7a6e876054d694af6f7d0c3cc3","tier":"starter_2024"},"version":552,"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,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Tenure & Draft Zoning - 10th & Page","cells":[{"id":0,"value":"# Tenure & Draft Zoning - 10th & Page","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":93,"value":"map = createMap()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":308,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":287,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":51,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":486,"value":"# Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":74,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":4,"value":"import {neighborhoods, parcels, sales, assessments, residential_data, commercial_data, base_data, iterate, getUseCode, sf_get_percentile, sf_get_rank, sf_rank} from \"@rorystolzenberg/charlottesville-assessment-data\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":76,"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, tabulate} \nwith {DARK_MODE} from \"@rorystolzenberg/charlottesville-assessment-data\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":108,"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":243,"value":"turf = require('https://npmcdn.com/@turf/turf/turf.min.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":78,"value":"DARK_MODE = true","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":8,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":241,"value":"find_neighborhood = parcel => {\n for(var x in neighborhoods.features){\n if(turf.booleanIntersects(parcel,neighborhoods.features[x]))\n return neighborhoods.features[x].properties.NAME\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":141,"value":"is_owner_occupied = function(d){\n return d.properties.OwnerAddress.indexOf(d.properties.StreetNumber+\" \"+d.properties.StreetName) !== -1 ||\n d.properties.OwnerAddress == \"\" // if owner opted out of listing their address in GIS, assume it's owner-occ\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":145,"value":"owner_occ = filter.parcels.features.filter(is_owner_occupied)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":538,"value":"is_cville_owned = function(d){\n return d.properties.OwnerCityState.indexOf(\"CHARLOTTESVILLE\") !== -1 ||\n d.properties.OwnerCityState.indexOf(\"EARLYSVILLE\") !== -1 ||\n d.properties.OwnerCityState == \"\" // if owner opted out of listing their address in GIS, assume it's owner-occ\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":540,"value":"cville_owned = filter.parcels.features.filter(is_cville_owned)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":375,"value":"sfds = {\n var data = filter.parcels.features;\n return data.filter(d=>{\n var use = getUseCode(d, true, true)\n if (typeof use === 'undefined') return;\n return use.indexOf(\"Single Family\") != -1 &&\n use !== \"Single Family Attached\" &&\n true\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":253,"value":"sfds_medium = {\n var data = sfds;\n return data.filter(d => d.properties.DraftZoning == \"R-B\" || d.properties.DraftZoning == \"R-C\")\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":262,"value":"sfds_ra = {\n var data = sfds;\n return data.filter(d => d.properties.DraftZoning == \"R-A\")\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":189,"value":"non_owner_occ_med = {\n var data = sfds_medium;\n data = data.filter(d=>!is_owner_occupied(d))\n return data//.map(d=>d.properties.OwnerAddress +\" \"+ d.properties.StreetNumber+\" \"+d.properties.StreetName)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":201,"value":"owner_occ_med = {\n var data = sfds_medium;\n data = data.filter(is_owner_occupied)\n return data//.map(d=>d.properties.OwnerAddress +\" \"+ d.properties.StreetNumber+\" \"+d.properties.StreetName)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":203,"value":"owner_occ_ra = {\n var data = sfds_ra;\n data = data.filter(is_owner_occupied)\n return data//.map(d=>d.properties.OwnerAddress +\" \"+ d.properties.StreetNumber+\" \"+d.properties.StreetName)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":268,"value":"non_owner_occ_ra = {\n var data = sfds_ra;\n data = data.filter(d=>!is_owner_occupied(d))\n return data//.map(d=>d.properties.OwnerAddress +\" \"+ d.properties.StreetNumber+\" \"+d.properties.StreetName)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":276,"value":"deciles = ranked_list => {\n var data = _.clone(ranked_list)\n data = data.reverse()\n // return d3.quantile(data, .9713); // 1 mil\n // return d3.quantile(data, .9949); // 1 mil\n var fmt = d3.format(\"$,\");\n return {\n \"10th percentile\": fmt(d3.quantile(data, .1)),\n \"20th percentile\": fmt(d3.quantile(data, .2)),\n \"30th percentile\": fmt(d3.quantile(data, .3)),\n \"40th percentile\": fmt(d3.quantile(data, .4)),\n \"50th percentile\": fmt(d3.quantile(data, .5)),\n \"60th percentile\": fmt(d3.quantile(data, .6)),\n \"70th percentile\": fmt(d3.quantile(data, .7)),\n \"80th percentile\": fmt(d3.quantile(data, .8)),\n \"90th percentile\": fmt(d3.quantile(data, .9)),\n \"95th percentile\": fmt(d3.quantile(data, .95)),\n \"96th percentile\": fmt(d3.quantile(data, .96)),\n \"97th percentile\": fmt(d3.quantile(data, .97)),\n \"98th percentile\": fmt(d3.quantile(data, .98)),\n \"99th percentile\": fmt(d3.quantile(data, .99)),\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":281,"value":"test= deciles(sfds_ra.map ( d=> d.properties.Assessment).sort((first, sec) => first > sec ? -1 : 1))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":306,"value":"medium_by_hood = _.groupBy(sfds_medium, d=>d.properties.Neighborhood)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":284,"value":"test2= deciles(sfds_medium.map ( d=> d.properties.Assessment).sort((first, sec) => first > sec ? -1 : 1))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":13,"value":"draft_zoning_202302 = FileAttachment(\"draft-zoning-2023-02.geojson\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":18,"value":"zoning_remap = {\n // return _.filter(_.groupBy(draft_zoning_202302.features.map(d=>d.properties),\"ParcelNumb\"), d=> d.length >1)\n var data = _.clone(draft_zoning_202302.features)\n data = data.filter(d=> {\n return d.properties.ParcelNumb !== null && \n (d.properties.ParcelNumb != 200196000 || d.properties.DRAFT_ZONI != \"CV\") // for 306 camellia, use R-A instead of CV\n })\n var map = {}\n data.forEach(d=>{\n map[d.properties.ParcelNumb] = d.properties\n })\n return map\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":64,"value":"missing_draft_zone = {\n return filter.parcels.features.filter(d=>typeof d.properties.DraftZoning === 'undefined').map(d=>d.properties)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":32,"value":"gpins = {\n var coll = parcels.features.map(d=>{\n return {\n GPIN: d.properties.GeoParcelIdentificationNumber,\n ParcelNumber: d.properties.ParcelNumber\n }\n })\n return _.groupBy(coll, \"GPIN\")\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":514,"value":"zones = {\n var data = _.clone(draft_zoning_202302.features).map(d=>d.properties.DRAFT_ZONI);\n return _.uniq(data)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":518,"value":"count_by_zones = {\n var data = _.clone(draft_zoning_202302.features).sort()\n data = _.countBy(data, d=>d.properties.DRAFT_ZONI);\n var rows = [];\n _.forEach(data, (d, i)=> rows.push({\"Zone\": i, \"Count\": d}))\n return rows\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 2e:"$2d:body"