2b:null 2c:["$","title",null,{"children":"Austin Creative Space Survey Analysis (2017 - 2021) | Cody Rushing | Observable"}] 31:T45b,* 67% of respondents say that they need one of the core services we provide (black box theater, rehearsal space, and class space) to fully pursue their creative practice. Of that target demographic: * 69% report having affordability issues * Target demo needs: * 54% classroom space * 39% indoor performance space (black box theater) * 44% Rehearsal space < 1000 sq ft. * 35% Rehearsal space > 1000 sq ft. * Target demo discipline breakdown: * 40% Music * 38% Performing/theatre arts * 23% Dance/choreography * The top 3 negative actions that target demo has taken in response to space related issues: * 68% Used a space that was not ideal for your needs * 40% Paid for space you could not afford * 33% Considered permanently leaving Austin * This says that despite the difficulties facing Austin creatives, very few are leaving the market or creative spaces. In fact, they are more likely to consider leaving Austin entirely (33%) than to stop pursuing their creative practice (12%). This suggests that there would be great demand for a higher quality and/or more affordable creative space.32:T612,targetDemoMonthlyBudgetBreakdown = { const noneRegex = '^(null|not|Don|\\$0).*'; const question = 'What do you currently pay MONTHLY, on average, for the studio or workspace you rent or own outside of your home? Or if a business, how much do you currently pay monthly for your organizations primary space? Rent or mortgage, not including utilities.'; const breakdown = getBreakdownOfQuestion( targetDemo.filter(r => !new RegExp(noneRegex, 'i').test(r[question])), question ); const numericBreakdown = breakdown.filter(b => !new RegExp(noneRegex, 'i').test(b.answer)); const nonNumericBreakdown = breakdown.filter(b => new RegExp(noneRegex, 'i').test(b.answer)); function getNumberFromString(s){ return parseInt( s.replace(/\D/g, ''), 10 ); } return breakdown.map( b => { let min = 0; let max = 0; if(/^(up to|under)/i.test(b.answer)){ max = getNumberFromString(b.answer); } else if(/^over/i.test(b.answer)){ min = getNumberFromString(b.answer); max = min - (min%1000) + 1000; } else { const [rangeMin, rangeMax] = b.answer.split('-'); if(rangeMin){ min = getNumberFromString(rangeMin); } if(rangeMax){ max = getNumberFromString(rangeMax); } } return { ...b, min, max } } ) .sort( (a, b) => { const sort = a.max - b.max; if(!sort){ return a.min - b.min; } return sort; } ); } 33:T64b,function generateZipCodeKML(items, options={}){ const { bgColor='e1ca9e' } = options; const results = getZipCodeResults(items).sort((a, b) => b.points - a.points); const highScore = results[0].points; const opacityScale = d3.scaleLinear().domain([0, highScore]).range([50, 200]); const zipCodeComponents = results .filter(({zipCode}) => !!coordinatesByZipCode[zipCode]) .map( ({zipCode, points}) => { const styleId = `KMLStyle${zipCode}`; const color = `${decToHex(opacityScale(points))}${bgColor}`; return ` ${zipCode} - score ${points} 1 #${styleId} 0 1 clampToGround ${coordinatesByZipCode[zipCode]} `.trim(); } ); return ` Requested zip codes 1 ${zipCodeComponents.join('')} `.trim(); }34:T53ac,coordinatesByZipCode = { return { 78702: "-97.737174,30.259136,0.0 -97.737281,30.257522,0.0 -97.735994,30.250611,0.0 -97.734424,30.250209,0.0 -97.729782,30.248109,0.0 -97.723382,30.246509,0.0 -97.717863,30.248615,0.0 -97.715936,30.249823,0.0 -97.713506,30.250432,0.0 -97.705281,30.250609,0.0 -97.701878,30.250204,0.0 -97.699581,30.246909,0.0 -97.694981,30.245309,0.0 -97.69128,30.245176,0.0 -97.690289,30.24579,0.0 -97.69083,30.249042,0.0 -97.692486,30.250767,0.0 -97.69277,30.255154,0.0 -97.691142,30.258198,0.0 -97.693864,30.260094,0.0 -97.695509,30.26561,0.0 -97.694363,30.267432,0.0 -97.696272,30.268101,0.0 -97.697907,30.273556,0.0 -97.698437,30.274661,0.0 -97.703036,30.281153,0.0 -97.701423,30.281389,0.0 -97.701711,30.282911,0.0 -97.703945,30.282572,0.0 -97.709458,30.281705,0.0 -97.70966,30.282774,0.0 -97.711755,30.28244,0.0 -97.711537,30.281404,0.0 -97.728487,30.278568,0.0 -97.730048,30.278506,0.0 -97.732996,30.270465,0.0 -97.737174,30.259136,0.0", 78704: "-97.800945,30.245255,0.0 -97.802487,30.244692,0.0 -97.797907,30.23552,0.0 -97.796557,30.234042,0.0 -97.791955,30.231266,0.0 -97.792805,30.22991,0.0 -97.790875,30.228989,0.0 -97.790018,30.230353,0.0 -97.784649,30.227818,0.0 -97.783297,30.227527,0.0 -97.772504,30.227259,0.0 -97.769672,30.226185,0.0 -97.764171,30.22248,0.0 -97.762582,30.221978,0.0 -97.756901,30.219231,0.0 -97.75759,30.217861,0.0 -97.754124,30.216234,0.0 -97.753779,30.217205,0.0 -97.751287,30.216572,0.0 -97.750659,30.216499,0.0 -97.749349,30.216348,0.0 -97.743984,30.216203,0.0 -97.743908,30.21963,0.0 -97.747316,30.223186,0.0 -97.742316,30.231017,0.0 -97.741273,30.233771,0.0 -97.735467,30.243563,0.0 -97.735028,30.245863,0.0 -97.735994,30.250611,0.0 -97.737846,30.251523,0.0 -97.740982,30.254788,0.0 -97.742814,30.25971,0.0 -97.744236,30.261135,0.0 -97.749732,30.263589,0.0 -97.754495,30.264975,0.0 -97.755984,30.26542,0.0 -97.760657,30.267526,0.0 -97.765916,30.264673,0.0 -97.767547,30.264111,0.0 -97.771507,30.263601,0.0 -97.774827,30.263652,0.0 -97.778197,30.262841,0.0 -97.780728,30.262599,0.0 -97.784823,30.261096,0.0 -97.785507,30.260191,0.0 -97.7842,30.25935,0.0 -97.785172,30.25751,0.0 -97.789643,30.255655,0.0 -97.795716,30.253427,0.0 -97.795976,30.253022,0.0 -97.796776,30.248652,0.0 -97.796216,30.247716,0.0 -97.792168,30.247833,0.0 -97.789479,30.246395,0.0 -97.788899,30.245601,0.0 -97.788865,30.243431,0.0 -97.789805,30.242137,0.0 -97.792185,30.241836,0.0 -97.793191,30.24294,0.0 -97.797307,30.244891,0.0 -97.800945,30.245255,0.0", 78723: "-97.709755,30.309108,0.0 -97.712078,30.306192,0.0 -97.709211,30.302643,0.0 -97.708825,30.301005,0.0 -97.709743,30.298787,0.0 -97.708882,30.29785,0.0 -97.705699,30.298236,0.0 -97.70526,30.29739,0.0 -97.702811,30.296482,0.0 -97.702769,30.295629,0.0 -97.704432,30.295548,0.0 -97.705086,30.294169,0.0 -97.707114,30.294153,0.0 -97.706858,30.291434,0.0 -97.704127,30.289896,0.0 -97.698793,30.290118,0.0 -97.698568,30.289089,0.0 -97.701302,30.287537,0.0 -97.70537,30.289292,0.0 -97.707148,30.289196,0.0 -97.706293,30.286215,0.0 -97.703945,30.282572,0.0 -97.701711,30.282911,0.0 -97.682628,30.285862,0.0 -97.672506,30.286809,0.0 -97.665508,30.285658,0.0 -97.661278,30.301709,0.0 -97.660966,30.30459,0.0 -97.661151,30.306781,0.0 -97.663253,30.315884,0.0 -97.665117,30.318949,0.0 -97.66816,30.321622,0.0 -97.672615,30.324846,0.0 -97.673228,30.32572,0.0 -97.681561,30.322975,0.0 -97.682295,30.324255,0.0 -97.682928,30.322513,0.0 -97.684876,30.321856,0.0 -97.688888,30.321507,0.0 -97.689155,30.322128,0.0 -97.691992,30.321926,0.0 -97.694136,30.322951,0.0 -97.693545,30.323903,0.0 -97.695292,30.32433,0.0 -97.698006,30.3239,0.0 -97.698492,30.322215,0.0 -97.704984,30.322767,0.0 -97.701745,30.322129,0.0 -97.706858,30.322197,0.0 -97.7079,30.315224,0.0 -97.70943,30.311346,0.0 -97.710448,30.30959,0.0 -97.709755,30.309108,0.0", 78701: "-97.754453,30.270237,0.0 -97.755635,30.267642,0.0 -97.754154,30.266948,0.0 -97.754495,30.264975,0.0 -97.749732,30.263589,0.0 -97.744236,30.261135,0.0 -97.742814,30.25971,0.0 -97.740982,30.254788,0.0 -97.737846,30.251523,0.0 -97.735994,30.250611,0.0 -97.737281,30.257522,0.0 -97.737174,30.259136,0.0 -97.732996,30.270465,0.0 -97.730048,30.278506,0.0 -97.738107,30.280688,0.0 -97.739855,30.282429,0.0 -97.741017,30.28149,0.0 -97.749817,30.283939,0.0 -97.751814,30.283751,0.0 -97.75084,30.28212,0.0 -97.750432,30.28056,0.0 -97.75091,30.279995,0.0 -97.751111,30.278585,0.0 -97.750183,30.276808,0.0 -97.752085,30.274034,0.0 -97.751445,30.27349,0.0 -97.750586,30.270296,0.0 -97.751228,30.268531,0.0 -97.752301,30.269572,0.0 -97.754453,30.270237,0.0", 78722: "-97.72899,30.280654,0.0 -97.730048,30.278506,0.0 -97.728487,30.278568,0.0 -97.711537,30.281404,0.0 -97.711755,30.28244,0.0 -97.70966,30.282774,0.0 -97.709458,30.281705,0.0 -97.703945,30.282572,0.0 -97.706293,30.286215,0.0 -97.707148,30.289196,0.0 -97.70537,30.289292,0.0 -97.701302,30.287537,0.0 -97.698568,30.289089,0.0 -97.698793,30.290118,0.0 -97.704127,30.289896,0.0 -97.706858,30.291434,0.0 -97.707114,30.294153,0.0 -97.705086,30.294169,0.0 -97.704432,30.295548,0.0 -97.702769,30.295629,0.0 -97.702811,30.296482,0.0 -97.70526,30.29739,0.0 -97.705699,30.298236,0.0 -97.708882,30.29785,0.0 -97.709743,30.298787,0.0 -97.708825,30.301005,0.0 -97.709211,30.302643,0.0 -97.712078,30.306192,0.0 -97.709755,30.309108,0.0 -97.710448,30.30959,0.0 -97.719719,30.294945,0.0 -97.72013,30.294284,0.0 -97.727401,30.283078,0.0 -97.72899,30.280654,0.0", 78721: "-97.701423,30.281389,0.0 -97.703036,30.281153,0.0 -97.698437,30.274661,0.0 -97.697907,30.273556,0.0 -97.696272,30.268101,0.0 -97.694363,30.267432,0.0 -97.695509,30.26561,0.0 -97.693864,30.260094,0.0 -97.691142,30.258198,0.0 -97.69277,30.255154,0.0 -97.692486,30.250767,0.0 -97.69083,30.249042,0.0 -97.690289,30.24579,0.0 -97.689218,30.245195,0.0 -97.68484,30.245782,0.0 -97.684329,30.246241,0.0 -97.682667,30.247188,0.0 -97.679503,30.251874,0.0 -97.683868,30.250674,0.0 -97.68005,30.252781,0.0 -97.678078,30.254794,0.0 -97.672912,30.263342,0.0 -97.672478,30.264005,0.0 -97.670272,30.267882,0.0 -97.6669,30.28034,0.0 -97.666415,30.28261,0.0 -97.665508,30.285658,0.0 -97.672506,30.286809,0.0 -97.682628,30.285862,0.0 -97.701711,30.282911,0.0 -97.701423,30.281389,0.0", 78751: "-97.737643,30.303493,0.0 -97.733085,30.301291,0.0 -97.733548,30.30053,0.0 -97.723412,30.295638,0.0 -97.723143,30.296542,0.0 -97.720617,30.295383,0.0 -97.72013,30.294284,0.0 -97.719719,30.294945,0.0 -97.710448,30.30959,0.0 -97.70943,30.311346,0.0 -97.7079,30.315224,0.0 -97.706858,30.322197,0.0 -97.712756,30.320435,0.0 -97.712623,30.319902,0.0 -97.714211,30.31992,0.0 -97.719558,30.322422,0.0 -97.724557,30.323918,0.0 -97.726326,30.32596,0.0 -97.726624,30.3255,0.0 -97.728923,30.326587,0.0 -97.730731,30.324467,0.0 -97.728077,30.32322,0.0 -97.729393,30.321087,0.0 -97.731865,30.322262,0.0 -97.733537,30.319415,0.0 -97.731133,30.318265,0.0 -97.732176,30.316699,0.0 -97.735227,30.315635,0.0 -97.737571,30.313464,0.0 -97.732976,30.310843,0.0 -97.737643,30.303493,0.0", 78757: "-97.755013,30.336232,0.0 -97.751533,30.334584,0.0 -97.749749,30.334495,0.0 -97.745996,30.335788,0.0 -97.741908,30.335104,0.0 -97.741639,30.336253,0.0 -97.738506,30.335098,0.0 -97.736395,30.334126,0.0 -97.736757,30.333382,0.0 -97.731593,30.330871,0.0 -97.731118,30.331675,0.0 -97.729154,30.330335,0.0 -97.728183,30.32924,0.0 -97.725192,30.327804,0.0 -97.719122,30.337342,0.0 -97.720297,30.339729,0.0 -97.721646,30.347209,0.0 -97.714964,30.343974,0.0 -97.712787,30.347273,0.0 -97.714399,30.350802,0.0 -97.716875,30.360377,0.0 -97.719104,30.361066,0.0 -97.719225,30.362804,0.0 -97.717797,30.363135,0.0 -97.719538,30.368933,0.0 -97.720974,30.37034,0.0 -97.723914,30.372095,0.0 -97.726302,30.373232,0.0 -97.726376,30.37284,0.0 -97.730929,30.374718,0.0 -97.736362,30.378008,0.0 -97.739606,30.370436,0.0 -97.740845,30.367447,0.0 -97.742361,30.368137,0.0 -97.744438,30.361299,0.0 -97.743419,30.361301,0.0 -97.755013,30.336232,0.0", 78741: "-97.749349,30.216348,0.0 -97.749242,30.215221,0.0 -97.735728,30.214208,0.0 -97.73498,30.215336,0.0 -97.72046,30.213399,0.0 -97.712066,30.212387,0.0 -97.708522,30.212752,0.0 -97.690575,30.218332,0.0 -97.68955,30.216364,0.0 -97.687601,30.21558,0.0 -97.686434,30.215935,0.0 -97.685268,30.216932,0.0 -97.688233,30.21957,0.0 -97.683288,30.22229,0.0 -97.683012,30.222438,0.0 -97.680253,30.223321,0.0 -97.676611,30.222346,0.0 -97.679174,30.223987,0.0 -97.682442,30.229573,0.0 -97.682768,30.230924,0.0 -97.685482,30.237235,0.0 -97.688315,30.241219,0.0 -97.689532,30.241454,0.0 -97.69128,30.245176,0.0 -97.694981,30.245309,0.0 -97.699581,30.246909,0.0 -97.701878,30.250204,0.0 -97.705281,30.250609,0.0 -97.713506,30.250432,0.0 -97.715936,30.249823,0.0 -97.717863,30.248615,0.0 -97.723382,30.246509,0.0 -97.729782,30.248109,0.0 -97.734424,30.250209,0.0 -97.735994,30.250611,0.0 -97.735028,30.245863,0.0 -97.735467,30.243563,0.0 -97.741273,30.233771,0.0 -97.742316,30.231017,0.0 -97.747316,30.223186,0.0 -97.743908,30.21963,0.0 -97.743984,30.216203,0.0 -97.749349,30.216348,0.0", 78703: "-97.78598,30.297441,0.0 -97.785587,30.294253,0.0 -97.785261,30.29316,0.0 -97.78592,30.290922,0.0 -97.785336,30.286148,0.0 -97.784268,30.28431,0.0 -97.780348,30.2805,0.0 -97.776663,30.277539,0.0 -97.772562,30.274647,0.0 -97.771605,30.273636,0.0 -97.769682,30.27162,0.0 -97.768271,30.270666,0.0 -97.766711,30.269886,0.0 -97.760657,30.267526,0.0 -97.755984,30.26542,0.0 -97.754495,30.264975,0.0 -97.754154,30.266948,0.0 -97.755635,30.267642,0.0 -97.754453,30.270237,0.0 -97.752301,30.269572,0.0 -97.751228,30.268531,0.0 -97.750586,30.270296,0.0 -97.751445,30.27349,0.0 -97.752085,30.274034,0.0 -97.750183,30.276808,0.0 -97.751111,30.278585,0.0 -97.75091,30.279995,0.0 -97.751389,30.28249,0.0 -97.754481,30.284522,0.0 -97.753248,30.288795,0.0 -97.751232,30.291921,0.0 -97.7474,30.29272,0.0 -97.749574,30.297108,0.0 -97.750154,30.297655,0.0 -97.749049,30.298886,0.0 -97.747123,30.299602,0.0 -97.75009,30.302673,0.0 -97.749297,30.304149,0.0 -97.747634,30.305576,0.0 -97.748003,30.307218,0.0 -97.750742,30.307251,0.0 -97.754639,30.308569,0.0 -97.757808,30.309068,0.0 -97.756783,30.314842,0.0 -97.756178,30.319739,0.0 -97.757048,30.324072,0.0 -97.758336,30.325493,0.0 -97.762954,30.328107,0.0 -97.768601,30.321184,0.0 -97.763809,30.318779,0.0 -97.767355,30.313654,0.0 -97.76904,30.314529,0.0 -97.7716,30.313164,0.0 -97.773834,30.312598,0.0 -97.775884,30.313606,0.0 -97.777884,30.308306,0.0 -97.783891,30.300785,0.0 -97.78598,30.297441,0.0", 78705: "-97.753248,30.288795,0.0 -97.754481,30.284522,0.0 -97.751389,30.28249,0.0 -97.75091,30.279995,0.0 -97.750432,30.28056,0.0 -97.75084,30.28212,0.0 -97.751814,30.283751,0.0 -97.749817,30.283939,0.0 -97.741017,30.28149,0.0 -97.739855,30.282429,0.0 -97.738107,30.280688,0.0 -97.737628,30.281666,0.0 -97.735232,30.28172,0.0 -97.734989,30.284542,0.0 -97.73402,30.285288,0.0 -97.73402,30.286963,0.0 -97.737022,30.287349,0.0 -97.737218,30.285527,0.0 -97.738383,30.284896,0.0 -97.74181,30.285,0.0 -97.741354,30.289813,0.0 -97.74025,30.289755,0.0 -97.740477,30.287397,0.0 -97.73934,30.286659,0.0 -97.738927,30.291824,0.0 -97.736583,30.291654,0.0 -97.736025,30.293176,0.0 -97.734735,30.290956,0.0 -97.734688,30.289326,0.0 -97.733607,30.287574,0.0 -97.733695,30.285315,0.0 -97.732794,30.285231,0.0 -97.731893,30.286937,0.0 -97.730166,30.286803,0.0 -97.730973,30.283918,0.0 -97.727401,30.283078,0.0 -97.72013,30.294284,0.0 -97.720617,30.295383,0.0 -97.723143,30.296542,0.0 -97.723412,30.295638,0.0 -97.733548,30.30053,0.0 -97.733085,30.301291,0.0 -97.737643,30.303493,0.0 -97.732976,30.310843,0.0 -97.737571,30.313464,0.0 -97.74311,30.305195,0.0 -97.746378,30.306709,0.0 -97.748003,30.307218,0.0 -97.747634,30.305576,0.0 -97.749297,30.304149,0.0 -97.75009,30.302673,0.0 -97.747123,30.299602,0.0 -97.749049,30.298886,0.0 -97.750154,30.297655,0.0 -97.749574,30.297108,0.0 -97.7474,30.29272,0.0 -97.751232,30.291921,0.0 -97.753248,30.288795,0.0", 78745: "-97.844942,30.200414,0.0 -97.847041,30.196254,0.0 -97.843036,30.194306,0.0 -97.84235,30.195341,0.0 -97.83342,30.190957,0.0 -97.83099,30.189966,0.0 -97.828505,30.19093,0.0 -97.825351,30.190332,0.0 -97.815814,30.185695,0.0 -97.81206,30.185498,0.0 -97.799406,30.185783,0.0 -97.795187,30.185618,0.0 -97.792672,30.183876,0.0 -97.788993,30.182673,0.0 -97.786233,30.183275,0.0 -97.784864,30.182929,0.0 -97.781978,30.183397,0.0 -97.785277,30.172951,0.0 -97.789644,30.174311,0.0 -97.790959,30.16726,0.0 -97.786254,30.166975,0.0 -97.772336,30.188149,0.0 -97.75835,30.205699,0.0 -97.757853,30.20543,0.0 -97.750659,30.216499,0.0 -97.751287,30.216572,0.0 -97.753779,30.217205,0.0 -97.754124,30.216234,0.0 -97.75759,30.217861,0.0 -97.756901,30.219231,0.0 -97.762582,30.221978,0.0 -97.764171,30.22248,0.0 -97.769672,30.226185,0.0 -97.772504,30.227259,0.0 -97.783297,30.227527,0.0 -97.784649,30.227818,0.0 -97.790018,30.230353,0.0 -97.790875,30.228989,0.0 -97.792805,30.22991,0.0 -97.791955,30.231266,0.0 -97.796557,30.234042,0.0 -97.797235,30.233725,0.0 -97.800691,30.232747,0.0 -97.803516,30.232121,0.0 -97.804578,30.231321,0.0 -97.811542,30.23325,0.0 -97.818116,30.232895,0.0 -97.820854,30.233165,0.0 -97.823672,30.22915,0.0 -97.824441,30.229689,0.0 -97.828334,30.224873,0.0 -97.824875,30.222794,0.0 -97.832202,30.211002,0.0 -97.833557,30.209343,0.0 -97.839648,30.199552,0.0 -97.844942,30.200414,0.0", 78731: "-97.796826,30.349986,0.0 -97.794727,30.348935,0.0 -97.788582,30.344223,0.0 -97.787031,30.343229,0.0 -97.781326,30.333866,0.0 -97.781039,30.332416,0.0 -97.779747,30.330537,0.0 -97.776503,30.323838,0.0 -97.775661,30.31803,0.0 -97.775884,30.313606,0.0 -97.773834,30.312598,0.0 -97.7716,30.313164,0.0 -97.76904,30.314529,0.0 -97.767355,30.313654,0.0 -97.763809,30.318779,0.0 -97.768601,30.321184,0.0 -97.762954,30.328107,0.0 -97.758336,30.325493,0.0 -97.757048,30.324072,0.0 -97.756178,30.319739,0.0 -97.756783,30.314842,0.0 -97.757808,30.309068,0.0 -97.754639,30.308569,0.0 -97.750742,30.307251,0.0 -97.748003,30.307218,0.0 -97.748842,30.308964,0.0 -97.74865,30.312972,0.0 -97.749226,30.316024,0.0 -97.74926,30.320863,0.0 -97.745909,30.320057,0.0 -97.745158,30.321191,0.0 -97.745918,30.323274,0.0 -97.74577,30.324941,0.0 -97.74689,30.327143,0.0 -97.746898,30.329789,0.0 -97.746358,30.330421,0.0 -97.747405,30.331859,0.0 -97.748971,30.332932,0.0 -97.749749,30.334495,0.0 -97.751533,30.334584,0.0 -97.755013,30.336232,0.0 -97.743419,30.361301,0.0 -97.744438,30.361299,0.0 -97.746907,30.361834,0.0 -97.749907,30.364528,0.0 -97.75239,30.364859,0.0 -97.754386,30.367405,0.0 -97.755265,30.365739,0.0 -97.759347,30.368156,0.0 -97.757695,30.370538,0.0 -97.757223,30.371566,0.0 -97.757706,30.371931,0.0 -97.760555,30.370651,0.0 -97.761707,30.368934,0.0 -97.765573,30.370657,0.0 -97.767324,30.370215,0.0 -97.770708,30.373968,0.0 -97.772389,30.373281,0.0 -97.773802,30.373563,0.0 -97.77193,30.376377,0.0 -97.770072,30.377024,0.0 -97.767372,30.375918,0.0 -97.766687,30.377012,0.0 -97.766996,30.381187,0.0 -97.769,30.382521,0.0 -97.770518,30.382792,0.0 -97.770063,30.384576,0.0 -97.770918,30.388505,0.0 -97.77199,30.38998,0.0 -97.773591,30.390829,0.0 -97.774931,30.390387,0.0 -97.774152,30.389625,0.0 -97.773231,30.387091,0.0 -97.771517,30.385661,0.0 -97.771415,30.38276,0.0 -97.774172,30.381369,0.0 -97.778267,30.378058,0.0 -97.780156,30.378867,0.0 -97.781577,30.378805,0.0 -97.783687,30.377634,0.0 -97.784451,30.375454,0.0 -97.784672,30.372662,0.0 -97.788122,30.369781,0.0 -97.789877,30.367126,0.0 -97.790422,30.362451,0.0 -97.791352,30.359289,0.0 -97.791907,30.358063,0.0 -97.796826,30.349986,0.0", 78756: "-97.749749,30.334495,0.0 -97.748971,30.332932,0.0 -97.747405,30.331859,0.0 -97.746358,30.330421,0.0 -97.746898,30.329789,0.0 -97.74689,30.327143,0.0 -97.74577,30.324941,0.0 -97.745918,30.323274,0.0 -97.745158,30.321191,0.0 -97.745909,30.320057,0.0 -97.74926,30.320863,0.0 -97.749226,30.316024,0.0 -97.74865,30.312972,0.0 -97.748842,30.308964,0.0 -97.748003,30.307218,0.0 -97.746378,30.306709,0.0 -97.74311,30.305195,0.0 -97.737571,30.313464,0.0 -97.735227,30.315635,0.0 -97.732176,30.316699,0.0 -97.731133,30.318265,0.0 -97.733537,30.319415,0.0 -97.731865,30.322262,0.0 -97.729393,30.321087,0.0 -97.728077,30.32322,0.0 -97.730731,30.324467,0.0 -97.728923,30.326587,0.0 -97.726624,30.3255,0.0 -97.726326,30.32596,0.0 -97.726779,30.326254,0.0 -97.728183,30.32924,0.0 -97.729154,30.330335,0.0 -97.731118,30.331675,0.0 -97.731593,30.330871,0.0 -97.736757,30.333382,0.0 -97.736395,30.334126,0.0 -97.738506,30.335098,0.0 -97.741639,30.336253,0.0 -97.741908,30.335104,0.0 -97.745996,30.335788,0.0 -97.749749,30.334495,0.0", 78758: "-97.741128,30.371958,0.0 -97.739397,30.37144,0.0 -97.739606,30.370436,0.0 -97.736362,30.378008,0.0 -97.730929,30.374718,0.0 -97.726376,30.37284,0.0 -97.726302,30.373232,0.0 -97.723914,30.372095,0.0 -97.720974,30.37034,0.0 -97.719538,30.368933,0.0 -97.717797,30.363135,0.0 -97.719225,30.362804,0.0 -97.719104,30.361066,0.0 -97.716875,30.360377,0.0 -97.714399,30.350802,0.0 -97.712787,30.347273,0.0 -97.712439,30.347805,0.0 -97.710487,30.350057,0.0 -97.709153,30.35081,0.0 -97.705638,30.353351,0.0 -97.708929,30.355363,0.0 -97.705885,30.357507,0.0 -97.704359,30.357002,0.0 -97.702688,30.355497,0.0 -97.700108,30.357647,0.0 -97.701406,30.358298,0.0 -97.701448,30.359954,0.0 -97.701167,30.36186,0.0 -97.699749,30.362519,0.0 -97.698417,30.365993,0.0 -97.695582,30.370674,0.0 -97.694757,30.371069,0.0 -97.693009,30.370175,0.0 -97.687684,30.37954,0.0 -97.691649,30.381474,0.0 -97.690839,30.38263,0.0 -97.689848,30.382092,0.0 -97.689372,30.383243,0.0 -97.686375,30.38193,0.0 -97.684253,30.386056,0.0 -97.680523,30.395119,0.0 -97.681913,30.396483,0.0 -97.680599,30.396214,0.0 -97.680051,30.397286,0.0 -97.681744,30.398218,0.0 -97.68105,30.39956,0.0 -97.679397,30.399152,0.0 -97.679081,30.402818,0.0 -97.678166,30.407896,0.0 -97.681415,30.408947,0.0 -97.695756,30.415809,0.0 -97.696507,30.414907,0.0 -97.700013,30.415494,0.0 -97.701917,30.416916,0.0 -97.698581,30.415365,0.0 -97.697737,30.416664,0.0 -97.701558,30.418644,0.0 -97.70519,30.421035,0.0 -97.708211,30.4179,0.0 -97.710107,30.415412,0.0 -97.710078,30.411244,0.0 -97.711586,30.410131,0.0 -97.71599,30.40858,0.0 -97.715853,30.407816,0.0 -97.720924,30.406779,0.0 -97.723456,30.405472,0.0 -97.728046,30.40209,0.0 -97.727851,30.399697,0.0 -97.728683,30.396026,0.0 -97.729445,30.394768,0.0 -97.736176,30.378682,0.0 -97.737901,30.379756,0.0 -97.741128,30.371958,0.0", 78759: "-97.811782,30.407342,0.0 -97.812591,30.404113,0.0 -97.801418,30.399228,0.0 -97.794431,30.396172,0.0 -97.790274,30.39782,0.0 -97.784095,30.40101,0.0 -97.783412,30.399726,0.0 -97.781559,30.398001,0.0 -97.777571,30.396319,0.0 -97.779038,30.393376,0.0 -97.781397,30.393002,0.0 -97.778292,30.392428,0.0 -97.77793,30.391018,0.0 -97.774931,30.390387,0.0 -97.773591,30.390829,0.0 -97.77199,30.38998,0.0 -97.770918,30.388505,0.0 -97.770063,30.384576,0.0 -97.770518,30.382792,0.0 -97.769,30.382521,0.0 -97.766996,30.381187,0.0 -97.766687,30.377012,0.0 -97.767372,30.375918,0.0 -97.770072,30.377024,0.0 -97.77193,30.376377,0.0 -97.773802,30.373563,0.0 -97.772389,30.373281,0.0 -97.770708,30.373968,0.0 -97.767324,30.370215,0.0 -97.765573,30.370657,0.0 -97.761707,30.368934,0.0 -97.760555,30.370651,0.0 -97.757706,30.371931,0.0 -97.757223,30.371566,0.0 -97.757695,30.370538,0.0 -97.759347,30.368156,0.0 -97.755265,30.365739,0.0 -97.754386,30.367405,0.0 -97.75239,30.364859,0.0 -97.749907,30.364528,0.0 -97.746907,30.361834,0.0 -97.744438,30.361299,0.0 -97.742361,30.368137,0.0 -97.740845,30.367447,0.0 -97.739606,30.370436,0.0 -97.739397,30.37144,0.0 -97.741128,30.371958,0.0 -97.737901,30.379756,0.0 -97.736176,30.378682,0.0 -97.729445,30.394768,0.0 -97.728683,30.396026,0.0 -97.727851,30.399697,0.0 -97.728046,30.40209,0.0 -97.723456,30.405472,0.0 -97.720924,30.406779,0.0 -97.715853,30.407816,0.0 -97.71599,30.40858,0.0 -97.711586,30.410131,0.0 -97.710078,30.411244,0.0 -97.710107,30.415412,0.0 -97.708211,30.4179,0.0 -97.715695,30.421533,0.0 -97.722036,30.411632,0.0 -97.726257,30.411727,0.0 -97.728445,30.413351,0.0 -97.729335,30.416126,0.0 -97.731772,30.417838,0.0 -97.732405,30.417455,0.0 -97.73047,30.416304,0.0 -97.729868,30.415132,0.0 -97.731585,30.412504,0.0 -97.745193,30.419026,0.0 -97.747036,30.419032,0.0 -97.74807,30.422698,0.0 -97.748533,30.423266,0.0 -97.746835,30.426553,0.0 -97.748041,30.424815,0.0 -97.750053,30.425078,0.0 -97.753449,30.426801,0.0 -97.751937,30.429006,0.0 -97.754759,30.429674,0.0 -97.758098,30.430985,0.0 -97.758039,30.43291,0.0 -97.765323,30.432404,0.0 -97.765609,30.432407,0.0 -97.766056,30.432411,0.0 -97.769726,30.434202,0.0 -97.777022,30.432019,0.0 -97.777988,30.434275,0.0 -97.778917,30.433601,0.0 -97.778294,30.431626,0.0 -97.781999,30.429664,0.0 -97.784592,30.427204,0.0 -97.785146,30.425982,0.0 -97.78493,30.424134,0.0 -97.786055,30.422838,0.0 -97.788432,30.422495,0.0 -97.790875,30.423246,0.0 -97.793503,30.42263,0.0 -97.794549,30.421843,0.0 -97.793793,30.420068,0.0 -97.796641,30.41958,0.0 -97.802054,30.41774,0.0 -97.803176,30.417786,0.0 -97.805061,30.415098,0.0 -97.811782,30.407342,0.0" } }35:[{"id":"5ee109382d382e34309829a929da4fe9e36b39e1fb8208c04faffed2d65ed402c3ac3b28e62d55e31e8aace8debfbeb792813a9a08a03e5d8fcc430f4bde7cdf","href":"https://static.observableusercontent.com/files/5ee109382d382e34309829a929da4fe9e36b39e1fb8208c04faffed2d65ed402c3ac3b28e62d55e31e8aace8debfbeb792813a9a08a03e5d8fcc430f4bde7cdf","name":"austin-creative-space-survey-all-2022.csv","type":"text/csv","lastModified":1677381097632.146,"size":1474500}] 2f:{"id":"4f773387ea599f68","slug":null,"title":"Austin Creative Space Survey Analysis (2017 - 2021)","thumbnail":"c9d8464fad0dc2ee3c18138c937244e424b94b03142b22f57be059a15944f03c","access_level":"public","create_time":"$D2023-01-07T20:54:07.624Z","update_time":"$D2023-12-29T18:09:18.618Z","view_time":null,"first_public_time":"$D2023-01-07T20:54:07.624Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"da453ccea7f021b9","login":"codyrushing","name":"Cody Rushing","avatar_url":"https://avatars-next.observableusercontent.com/a91368ea312a72f98af3029732b0f7fc67b47b763116f25a9a9c046245cc0857","tier":"starter_2024"},"version":726,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"514f3026c16db8ac","login":"codyrushing","name":"Cody Rushing","avatar_url":"https://avatars-next.observableusercontent.com/a91368ea312a72f98af3029732b0f7fc67b47b763116f25a9a9c046245cc0857","tier":null}],"members":[{"type":"individual","id":"514f3026c16db8ac","login":"codyrushing","name":"Cody Rushing","avatar_url":"https://avatars-next.observableusercontent.com/a91368ea312a72f98af3029732b0f7fc67b47b763116f25a9a9c046245cc0857","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Austin Creative Space Survey Analysis (2017 - 2021)","cells":[{"id":0,"value":"# Austin Creative Space Survey Analysis (2017 - 2021)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"### Links\n* [CoA Creative Space Survey page](https://www.austintexas.gov/page/creative-space-survey)\n* [Creative Space Survey data portal page](https://data.austintexas.gov/Recreation-and-Culture/Strategic-Measure_Number-and-percentage-of-creativ/b2dc-bfe2)\n* [Austin Cultural Arts Funding Review (June 2022)](https://www.austintexas.gov/sites/default/files/files/EDD/CulturalArts/Cultural_Funding_Review_Final_Report.pdf)\n * [Appendix for above including more quantitative data](https://www.austintexas.gov/sites/default/files/files/EDD/CulturalArts/Appendix_Cultural_Funding_Review_Process.pdf)\n* [Cultural Arts - Core Funding Awards Through the Years](https://data.austintexas.gov/stories/s/Cultural-Funding-Awards/q9hf-a4mc/)\n* [ACA description of new city arts funding proposals](https://www.austincreativealliance.org/cityfunding)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":313,"value":"Possible stories:\n\n* Target demographic - respondents who need the core services our space provides\n* Affordability\n* Top requested space features.\n* Price and willingness to pay.\n* Zip code heatmap\n\nQuestions:\n\n* Should we distinguish between individuals and organizations? Is that even meaningful?\n\nNext steps:\n\n* Describe negative impact of space related issues on the community. This will come from the \"Space related issues have caused me to take the following\" questions\n* Do a breakdown of the \"How large would your ideal space be\" question.\n* Do a discipline breakdown of the target demo.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":352,"value":"## Takeaways","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":354,"value":"$31","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":283,"value":"## Filters","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":316,"value":"Responses with affordability issues","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":318,"value":"## Target demo","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":315,"value":"SELECT * FROM \"allResponsesClean\"\nWHERE (\n \"Classroom, teaching space is my/our ideal workspace to fully pursue creative practice\" IS NOT NULL\n OR\n \"Indoor Performance Space: Black Box/Flex Space (i.e. no fixed seats) is my/our ideal workspace to fully pursue creative practice\" IS NOT NULL\n OR\n \"Rehearsal Space, less than 1,000 sq. feet is my/our ideal workspace to fully pursue creative practice\" IS NOT NULL\n OR\n \"Rehearsal Space, more than 1,000 sq. feet is my/our ideal workspace to fully pursue creative practice\" IS NOT NULL\n)","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"targetDemo","database":"var:allResponsesClean"},{"id":327,"value":"targetDemoPercentage = targetDemo.length/allResponsesClean.length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":526,"value":"targetDemoIndividualArtists = targetDemo.filter(s => /^Individual/.test(s['Which of the following best describes the organization or business you are representing?']))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":529,"value":"targetDemoIndividualArtistsPercentage = targetDemoIndividualArtists.length / targetDemo.length","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":532,"value":"targetDemoNonProfits = targetDemo.filter(s => /(501|non\\-?profit)/i.test(s['Which of the following best describes the organization or business you are representing?']))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":537,"value":"targetDemoNonProfitsPercentage = targetDemoNonProfits.length / targetDemo.length","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":539,"value":"#### Target demo monthly budget","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":542,"value":"function getBreakdownOfQuestion(respondents, question){\n const resultsObj = respondents.reduce(\n (acc, v) => {\n const answer = v[question];\n acc[answer] = (acc[answer] || 0);\n acc[answer] += 1;\n return acc;\n },\n {}\n );\n\n return Object.entries(resultsObj)\n .map(\n ([answer, count]) => ({\n answer,\n count,\n percent: count / respondents.length\n })\n )\n .sort(\n (a, b) => b.count - a.count \n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":609,"value":"targetDemoWithNoMonthlyBudget = {\n const noneRegex = '^(null|not|Don|\\\\$0).*';\n const question = 'What do you currently pay MONTHLY, on average, for the studio or workspace you rent or own outside of your home? Or if a business, how much do you currently pay monthly for your organizations primary space? Rent or mortgage, not including utilities.';\n return targetDemo.filter(r => new RegExp(noneRegex, 'i').test(r[question]));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":549,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":691,"value":"function sumPercent(breakdowns){\n return breakdowns.reduce(\n (acc, b) => acc += b.percent,\n 0\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":713,"value":"sub300 = sumPercent(targetDemoMonthlyBudgetBreakdown.slice(0,2))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":703,"value":"sub500 = sumPercent(targetDemoMonthlyBudgetBreakdown.slice(0,3))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":705,"value":"sub500_1000 = sumPercent(targetDemoMonthlyBudgetBreakdown.slice(3,6));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":715,"value":"sub1000_2000 = sumPercent(targetDemoMonthlyBudgetBreakdown.slice(6,9));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":717,"value":"sub2000_5000 = sumPercent(targetDemoMonthlyBudgetBreakdown.slice(9,12));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":719,"value":"sub5000plus = sumPercent(targetDemoMonthlyBudgetBreakdown.slice(12,13));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":721,"value":"budget1000Plus = sumPercent(targetDemoMonthlyBudgetBreakdown.slice(6,13));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":473,"value":"#### Target demo w/ affordability issues","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":361,"value":"SELECT * from \"targetDemo\"\nWHERE (\n \"Current space concerns: Our current space is too expensive\" IS NOT NULL \n OR \n \"In your opinion, do you have access to affordable creative space? (1 = Yes; 0= No)\" != 1\n OR\n \"Current space concerns: We expect a rent increase we cannot afford\" IS NOT NULL\n)","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"targetDemoAffordability","database":"var:targetDemo"},{"id":370,"value":"targetDemoWithAffordabilityPercentage = targetDemoAffordability.length/targetDemo.length","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":483,"value":"targetDemoDisciplines = {\n const schema = targetDemo[0];\n const disciplineKeys = Object.keys(schema).filter(k => /main area of artistic activity or creative industry$/.test(k))\n const resultsObj = targetDemo.reduce(\n (acc, v) => {\n for(const k of disciplineKeys){\n if(v[k]){\n acc[k] = (acc[k] || 0);\n acc[k] += 1;\n }\n }\n return acc;\n },\n {}\n );\n\n return Object.entries(resultsObj)\n .map(\n ([k, count]) => ({\n name: k.split(' is my/our')[0],\n count,\n percent: count / targetDemo.length\n })\n )\n .sort(\n (a, b) => b.count - a.count \n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":504,"value":"targetDemoNegativeActions = {\n const schema = targetDemo[0];\n const prefix = 'Space-related issues caused you to take the following action: ';\n const negativeActionsKeys = Object.keys(schema).filter(k => k.startsWith(prefix));\n const resultsObj = targetDemo.reduce(\n (acc, v) => {\n for(const k of negativeActionsKeys){\n if(v[k]){\n acc[k] = (acc[k] || 0);\n acc[k] += 1;\n }\n }\n return acc;\n },\n {}\n );\n\n return Object.entries(resultsObj)\n .map(\n ([k, count]) => ({\n name: k.split(prefix)[1],\n count,\n percent: count / targetDemo.length\n })\n )\n .sort(\n (a, b) => b.count - a.count \n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":172,"value":"## Constants","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":122,"value":"idealSpaceFeatureKeys = d3.range(29, 68)\n .map(i => `which_of_the_following_would_${i}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":381,"value":"zipCodeQuestions = ['1st Choice of Preferred ZIP Code', '2nd Choice of Preferred ZIP Code', '3rd Choice of Preferred ZIP Code']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":340,"value":"idealSpaceSuffix = \"my/our ideal workspace to fully pursue creative practice\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":225,"value":"idealSpaceFeatures = Object.keys(austinCreativeSpaceSurveyAll2022Raw[0]).filter(k => k.endsWith(idealSpaceSuffix))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":476,"value":"sizeRelatedQuestions = ['What is the minimum square footage necessary for your studio, creative work, or rehearsal space? If you share your space with multiple artists, please specify the size of the area YOU use.(Measured as Length times Width. For example: 10-foot by 20-foot sp']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":386,"value":"## Functions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":388,"value":"function getZipCodeResults(responses){\n const zipCodeMap = new Map();\n for(const response of responses){\n for(const [index, question] of zipCodeQuestions.entries()){\n const questionScore = zipCodeQuestions.length - index;\n // const prevQuestion = zipCodeQuestions[index-1];\n // const prevAnswer = prevQuestion ? responses[prevQuestion] : null;\n const zipCode = response[question];\n if(zipCode){\n let item = zipCodeMap.get(zipCode);\n if(!item){\n item = {\n points: 0,\n zipCode,\n }\n zipCodeMap.set(zipCode, item);\n }\n item.points += questionScore;\n }\n }\n }\n return Array.from(zipCodeMap.values()).sort((a, b) => b.points - a.points);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":414,"value":"getZipCodeResults(targetDemo)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":396,"value":"function decToHex(num){\n return (parseInt(num)).toString(16).padStart(2, \"0\")\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":432,"value":"requestedZipCodesKML = generateZipCodeKML(targetDemo, { bgColor: \"38b771\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":154,"value":"## Dependencies","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":159,"value":"The table below is a file upload of the CSV data that is currently being pulled from the [CoA data portal](https://data.austintexas.gov/Recreation-and-Culture/Strategic-Measure_Number-and-percentage-of-creativ/b2dc-bfe2).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":152,"value":"SELECT * FROM \"austin-creative-space-survey-all-2022\"","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"austinCreativeSpaceSurveyAll2022Raw","database":"austin-creative-space-survey-all-2022.csv"},{"id":222,"value":"allResponsesClean = austinCreativeSpaceSurveyAll2022Raw\n.filter(\n // filter for responses which have selected at least one ideal space feature\n row => idealSpaceFeatures.some(k => !!row[k])\n)\n.map(\n row => {\n // TODO, fix misaligned csv data surrounding the ideal space features responses\n const idealSpaceResponses = _.pick(row, idealSpaceFeatures);\n const corrections = {};\n for(const [k, v] of Object.entries(idealSpaceResponses)){\n if(typeof v === 'string' && !k.startsWith(v)){\n const correctFeatureKey = idealSpaceFeatures.find(k => k.startsWith(v));\n // find answer to original question\n row[k] = Object.values(idealSpaceResponses).find(\n answer => typeof answer === 'string' && k.startsWith(answer)\n );\n // move this answer to the correct question\n if(correctFeatureKey){\n row[correctFeatureKey] = v;\n }\n }\n }\n return row\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":423,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":241,"value":"_ = import(\"https://cdn.skypack.dev/lodash@4.17.15\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":110,"value":"d3 = import(\"https://cdn.skypack.dev/d3@7.8.0\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 30:"$2f:body"