2c:null 2d:["$","title",null,{"children":"San Francisco Real Estate Report - Jan 2026 | Maxime Tiran | Observable"}] 32:T7d2,Plot.plot({ width: 1000, height: 500, color: {legend: true}, marginRight: 100, marginLeft: 70, style: { fontSize: "16px", color: "gray" }, y : { //axis: "right", label: null, tickFormat: d3.format("$~s") }, marks: [ //Plot.ruleY([0]), Plot.ruleX(filteredData, Plot.pointerX({x: "Date", py: "Value", stroke: "red"})), //Plot.dot(filteredData, Plot.pointerX({x: "Date", y: "Value", stroke: "Unit Type"})), // ✅ Single pointerX text showing all series at hovered X Plot.text( filteredData, Plot.pointerX({ px: "Date", frameAnchor: "top-left", fontVariant: "tabular-nums", fontSize: 20, fill: "black", text: (d) => { const allAtX = filteredData .filter(r => +r.Date === +d.Date) .sort((a, b) => b.Value - a.Value) .map(r => `${r["Unit Type"]}: ${fmtValue()(r.Value)}`) const maAtX = maData .filter(r => +r.Date === +d.Date) .sort((a, b) => b.Value - a.Value) .map(r => `${r["Unit Type"]} (12m avg): ${fmtValue()(r.Value)}`) return [...allAtX, "", ...maAtX].join("\n") }, dy: 50, dx: 15, }) ), Plot.text( filteredData, Plot.pointerX({ px: "Date", frameAnchor: "top-left", fontVariant: "tabular-nums", fontSize: 60, fontWeight: 1000, fill: "black", text: d => d3.timeFormat("%b %Y")(d.Date), dx: 15, }) ), Plot.lineY(filteredData, { x: "Date", y: "Value", z: "Unit Type", stroke: "Unit Type", strokeOpacity: 0.3 }), Plot.lineY(filteredData, movingAvgData), Plot.text( filteredData, Plot.selectLast( Plot.windowY(12, { x: "Date", y: "Value", z: "Unit Type", text: d => d["Unit Type"], dx: 10, textAnchor: "start", fontSize: 20, }) ) ) ] })33:T6eb,mymap = { const container = yield htl.html`

`; const map = L.map(container).setView([37.76, -122.44], 13); L.tileLayer("https://tiles.stadiamaps.com/tiles/alidade_smooth/{z}/{x}/{y}{r}.png", { attribution: "© OpenStreetMap contributors" }).addTo(map); data3.forEach(d => { L.circleMarker([d.Latitude, d.Longitude], { radius: 2, // size in pixels color: linearColor.apply(Number(d["Selling Price"].substring(1).replaceAll(',',''))),//'#3388ff', fillColor: '#3388ff', fillOpacity: 0.8 } //{ icon: getIcon(d["LAND USE"]) } ) .bindPopup( `${showAttribute(d,"Address")} ${showAttribute(d,"Selling Price")} ${showAttribute(d,"Architectural Style")} Selling agent: ${showAttribute(d,"Listing Agent Name")} ${showAttribute(d,"Listing Office Name / ID")} ${showAttribute(d,"Property Subtype 1 Display")} Beds: ${showAttribute(d,"Bedrooms")} Baths: ${showAttribute(d,"Full Bathrooms")} Sold: ${showAttribute(d,"Selling Date")}` // `${showAttribute(d,"SITUS STREET ADDRESS")} // ${showAttribute(d,"LMS-SALE PRICE")} // ${showAttribute(d,"LAND USE")} // Beds: ${showAttribute(d,"NUMBER OF BEDROOMS")} // Baths: ${showAttribute(d,"NUMBER OF BATHS")} // Stories: ${showAttribute(d,"STORIES NO.")} // Year built: ${showAttribute(d,"YEAR BUILT")} // Sq. Ft.: ${showAttribute(d,"LIVING AREA")} // Lot size: ${showAttribute(d,"LOT AREA")}` ) .addTo(map); }); }34:[{"id":"b05d6e1772a14e8feb1f62e1092935c43873583e354045c31f38d56759416a9abe1b8ceb6342a6c40e590b0e4293b8d037cb4ca7c2dbc1b72a8cdbbd1ff65ead","href":"https://static.observableusercontent.com/files/b05d6e1772a14e8feb1f62e1092935c43873583e354045c31f38d56759416a9abe1b8ceb6342a6c40e590b0e4293b8d037cb4ca7c2dbc1b72a8cdbbd1ff65ead","name":"TIC.png","type":"image/png","lastModified":1771470762628.6,"size":48625},{"id":"5d77f385efbc9ddea70e1b7fbdd6e38833450d0fdf5941d716db0d5047fac1322494fda3342e36651770d29ec234ea91e7516299d832faacd52a5d30558d7359","href":"https://static.observableusercontent.com/files/5d77f385efbc9ddea70e1b7fbdd6e38833450d0fdf5941d716db0d5047fac1322494fda3342e36651770d29ec234ea91e7516299d832faacd52a5d30558d7359","name":"SFR.png","type":"image/png","lastModified":1771470762617.463,"size":60738},{"id":"8c8c66de46ebdea552763f5ea50b81dabe00394f451e5bb0c87d74213c8f25f9c40508c185ad44d713048623e429643e735d2970129bc14d729ce9036e5621b6","href":"https://static.observableusercontent.com/files/8c8c66de46ebdea552763f5ea50b81dabe00394f451e5bb0c87d74213c8f25f9c40508c185ad44d713048623e429643e735d2970129bc14d729ce9036e5621b6","name":"CONDO.png","type":"image/png","lastModified":1771470762564.174,"size":52387}] 30:{"id":"a0c2e385c594f971","slug":"san-francisco-real-estate-report","title":"San Francisco Real Estate Report - Jan 2026","thumbnail":"aff3c23517a3fc393e6c164ad667362a258f15279ceffee3de493821a2a56b4f","access_level":"public","create_time":"$D2026-02-17T21:49:54.806Z","update_time":"$D2026-03-01T21:01:46.854Z","view_time":null,"first_public_time":"$D2026-02-18T22:25:12.710Z","has_unpublished_edits":null,"fork":{"id":"21d1b3d3e49e8f08","slug":"google-sheets-starter","title":"Google Sheets Starter","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":1,"starred":false,"owner":{"type":"team","id":"9a863e6e8fd9162a","login":"maxime-tiran","name":"Maxime Tiran","avatar_url":"https://avatars-next.observableusercontent.com/3bb6ce53630c8461b072ef094350bc521ff28b5197fc428ae1d28697d4c3597e","tier":"starter_2024","bio":""},"version":1010,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b1a105d58de87cb6","login":"maxime-tiran","name":"Maxime Tiran","avatar_url":"https://avatars-next.observableusercontent.com/d9dcc253effa99894cc1f98ba875f02b20f0fcb50eb8a9ead253ac469fd1c9f6","tier":null,"bio":""}],"members":[{"type":"team","id":"9a863e6e8fd9162a","login":"maxime-tiran","name":"Maxime Tiran","avatar_url":"https://avatars-next.observableusercontent.com/3bb6ce53630c8461b072ef094350bc521ff28b5197fc428ae1d28697d4c3597e","tier":"starter_2024","role":"editor"},{"type":"individual","id":"b1a105d58de87cb6","login":"maxime-tiran","name":"Maxime Tiran","avatar_url":"https://avatars-next.observableusercontent.com/d9dcc253effa99894cc1f98ba875f02b20f0fcb50eb8a9ead253ac469fd1c9f6","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"San Francisco Real Estate Report - Jan 2026","cells":[{"id":0,"value":"# San Francisco Real Estate Report - ${d3.utcFormat(\"%b %Y\")(d3.max(data.map(d=>d.Date)))}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":288,"value":"viewof selectedMetric = Inputs.select([...new Set(data.map(d => d.Metric))], {value: \"Median Sales Price\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":496,"value":"Plot.plot({\n width: 1000,\n height: 150,\n y: { axis: null, domain: [-1, 1] }, // explicit domain to control spacing\n x: { ticks: 0, label: null },\n fx: { label: null },\n marks: [\n Plot.axisFx({ fontSize: 24 }),\n Plot.text(yoy, {\n fx: \"Unit Type\",\n x: 0,\n y: 0.3,\n text: d => fmtValue()(d.Value),\n fontSize: 50,\n fontWeight: \"bold\",\n fontFamily: \"Source Serif Pro\",\n }),\n Plot.text(yoy, {\n fx: \"Unit Type\",\n x: 0,\n y: -1,\n text: d => d.pct != null ? `${d.pct >= 0 ? \"▲\" : \"▼\"} ${d3.format(\"+.1f\")(d.pct)}% YoY` : \"N/A\",\n fontSize: 20,\n fill: d => d.pct >= 0 ? \"green\" : \"red\"\n }),\n Plot.image(yoy, {\n fx: \"Unit Type\",\n x: 0,\n dx: -135,\n y: 0,\n width: 100,\n height: 100,\n src: d => unitTypeIcons[d[\"Unit Type\"]]\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":785,"value":"## Units sold in the past year","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":799,"value":"Plot.plot({\n width: 1000,\n height: 200,\n style: { fontSize: \"16px\" },\n y: {label:null},\n x: {\n tickFormat: d3.format(\"$~s\"),\n label:null\n },\n fx: {label: null},\n marks: [\n Plot.axisFx({ fontSize: 24 }),\n Plot.rectY(unitsSold, Plot.binX({\n y: \"count\",\n title: (values, {x1, x2}) => `${d3.format(\"$~s\")(x1)} - ${d3.format(\"$~s\")(x2)}: ${values.length} sales`\n }, \n {\n x: \"salePrice\", \n fx: \"unitType\",\n fill: \"unitType\",\n thresholds:d3.range(0, 5000000 + 100000, 100000),\n tip: true\n })),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":431,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":803,"value":"unitsSold = data3.filter(d => [\"Tenancy in Common\",\"Condominium\",\"Single Family Residence\"].includes(d[\"Property Subtype 1 Display\"])).map(d => ({\n unitType: d[\"Property Subtype 1 Display\"],//unitTypeLabelMap.get(d[\"Property Subtype\"]),\n //[\"Multi Family Dwelling\",\"Duplex\"].includes(d[\"LAND USE\"]) ? \"TIC\" : d[\"LAND USE\"],\n salePrice: parseInt(d[\"Selling Price\"].substring(1).replaceAll(',',''))\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":985,"value":"unitTypeLabelMap = new Map([\n [\"CNDO\",\"Condo\"],\n [\"COOP\",\"Co-op\"],\n [\"HSL1\",\"Single-Family Residence\"],\n [\"TCLA\",\"TIC\"],\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":755,"value":"unitTypeIcons = ({\n \"Condo\": await FileAttachment(\"CONDO.png\").url(),\n \"SFR\": await FileAttachment(\"SFR.png\").url(),\n \"TIC\": await FileAttachment(\"TIC.png\").url()\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":713,"value":"function showAttribute(d, name){\n return d[name] === '' ? '-
' : `${d[name]}
`\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":624,"value":"color = Plot.scale({\n color: {\n domain: [\"Duplex\",\"Multi Family Dwelling\",\"SFR\",\"Condominium\",\n \"CNDO\",\"TCLA\",\"COOP\",\"HSL1\"],\n range: [\"green\",\"red\",\"orange\",\"blue\"]\n }\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":967,"value":"linearColor = Plot.scale({\n color: {\n scheme: \"YlOrRd\", \n type:\"linear\", \n domain: [0,6000000]//d3.extent(data2.map(d=>Number(d[\"Search Price Display\"].replaceAll(',',''))))\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":637,"value":"function getIcon(cat) { return new L.Icon({\n iconUrl: `https://raw.githubusercontent.com/pointhi/leaflet-color-markers/master/img/marker-icon-2x-${color.apply(cat)}.png`,\n iconSize: [12, 20], // the size you want\n iconAnchor: [6, 20]\n })};","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":535,"value":"html`\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":379,"value":"movingAvgData = Plot.windowY(12, {\n x: \"Date\",\n y: \"Value\",\n stroke: \"Unit Type\",\n strokeWidth : 4\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":740,"value":"maData = d3.groups(filteredData, d => d[\"Unit Type\"]).flatMap(([unitType, values]) => {\n const sorted = values.sort((a, b) => a.Date - b.Date)\n return sorted.map((d, i) => {\n const window = sorted.slice(Math.max(0, i - 11), i + 1)\n const avg = d3.mean(window, w => w.Value)\n return { Date: d.Date, Value: avg, \"Unit Type\": unitType }\n })\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":375,"value":"filteredData = data.filter(d => d.Metric === selectedMetric)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":332,"value":"function fmtValue() {\n return [\"Median Sales Price\",\"Median Price / sqft\"].includes(selectedMetric) ? d3.format(\"$.4s\") : d3.format(\".1~f\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":591,"value":"yoy = { const sorted = [...filteredData].sort((a, b) => d3.ascending(a.Date, b.Date))\n\n const latest = d3.rollup(sorted.slice(-3), v => d3.sum(v, d => d.Value), d => d[\"Unit Type\"])\n const prevYear = d3.rollup(sorted.slice(-13*3, -12*3), v => d3.sum(v, d => d.Value), d => d[\"Unit Type\"])\n\n const yoy = [...latest.entries()].map(([unit, value]) => {\n const prev = prevYear.get(unit)\n const pct = prev ? ((value - prev) / prev) * 100 : null\n return { \"Unit Type\": unit, Value: value, pct }\n })\n return yoy;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":701,"value":"data1 = d3.csv(\"https://docs.google.com/spreadsheets/d/e/2PACX-1vRarQ8NKJD7-n_UzueZ0R-ws3UpAs81SDeAPJO809J-VKKzFStKpvc9glDJ7hf8FMV0k-jdsBS8bggd/pub?gid=1905911027&single=true&output=csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":676,"value":"data = d3.csv(\"https://docs.google.com/spreadsheets/d/e/2PACX-1vQILNhpiPzPNIrXmYfZY3LtJVaAJDnYH-3d9J7pxW1ymi8HOPIyp-spt2iQuhfQqQ/pub?gid=1272112465&single=true&output=csv\",\nd => {\n d.Date = new Date(d.Date);\n d.Value = +d.Value;\n return d;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":939,"value":"data2 = d3.csv(\"https://docs.google.com/spreadsheets/d/e/2PACX-1vRarQ8NKJD7-n_UzueZ0R-ws3UpAs81SDeAPJO809J-VKKzFStKpvc9glDJ7hf8FMV0k-jdsBS8bggd/pub?gid=659009566&single=true&output=csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":992,"value":"data3 = d3.csv(\"https://docs.google.com/spreadsheets/d/e/2PACX-1vRarQ8NKJD7-n_UzueZ0R-ws3UpAs81SDeAPJO809J-VKKzFStKpvc9glDJ7hf8FMV0k-jdsBS8bggd/pub?gid=1481257774&single=true&output=csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1"}} 31:"$30:body"