Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save rogerfischer/3bfcce08c98afbd6afa93ef3bd226938 to your computer and use it in GitHub Desktop.
Save rogerfischer/3bfcce08c98afbd6afa93ef3bd226938 to your computer and use it in GitHub Desktop.
Prop F with SF Precincts
id pct_2012 precinct_names neighborhood yes_percentage
84006075PCT1101 1101 Pct 1101 EXCELSIOR 0.53
84006075PCT1102 1102 Pct 1102/1103 EXCELSIOR 0.48
84006075PCT1103 1103 NA EXCELSIOR NA
84006075PCT1104 1104 Pct 1104/1105 EXCELSIOR 0.5
84006075PCT1105 1105 NA EXCELSIOR NA
84006075PCT1106 1106 Pct 1106/1107 INGLESIDE 0.43
84006075PCT1107 1107 NA INGLESIDE NA
84006075PCT1108 1108 NA INGLESIDE NA
84006075PCT1109 1109 Pct 1109/1108 INGLESIDE 0.48
84006075PCT1111 1111 Pct 1111 INGLESIDE 0.39
84006075PCT1112 1112 Pct 1112 INGLESIDE 0.48
84006075PCT1113 1113 NA EXCELSIOR NA
84006075PCT1114 1114 Pct 1114/1113 EXCELSIOR 0.54
84006075PCT1115 1115 Pct 1115/1116 INGLESIDE 0.42
84006075PCT1116 1116 NA INGLESIDE NA
84006075PCT1117 1117 Pct 1117 INGLESIDE 0.36
84006075PCT1118 1118 Pct 1118/1124 INGLESIDE 0.51
84006075PCT1119 1119 Pct 1119 INGLESIDE 0.59
84006075PCT1121 1121 NA EXCELSIOR NA
84006075PCT1122 1122 Pct 1122 EXCELSIOR 0.45
84006075PCT1123 1123 Pct 1123/1125 INGLESIDE 0.42
84006075PCT1124 1124 NA INGLESIDE NA
84006075PCT1125 1125 NA EXCELSIOR NA
84006075PCT1126 1126 Pct 1126/1121 EXCELSIOR 0.45
84006075PCT1127 1127 NA EXCELSIOR NA
84006075PCT1128 1128 Pct 1128/1127 EXCELSIOR 0.47
84006075PCT1129 1129 Pct 1129/1131 EXCELSIOR 0.47
84006075PCT1131 1131 NA EXCELSIOR NA
84006075PCT1132 1132 Pct 1132 EXCELSIOR 0.47
84006075PCT1133 1133 NA EXCELSIOR NA
84006075PCT1134 1134 Pct 1134 EXCELSIOR 0.56
84006075PCT1135 1135 Pct 1135/1133 EXCELSIOR 0.39
84006075PCT1136 1136 Pct 1136 EXCELSIOR 0.29
84006075PCT1141 1141 Pct 1141/1142 EXCELSIOR 0.53
84006075PCT1142 1142 NA EXCELSIOR NA
84006075PCT1143 1143 NA EXCELSIOR NA
84006075PCT1144 1144 Pct 1144/1143 EXCELSIOR 0.53
84006075PCT1145 1145 NA EXCELSIOR NA
84006075PCT1146 1146 Pct 1146/1147 EXCELSIOR 0.51
84006075PCT1147 1147 NA EXCELSIOR NA
84006075PCT1148 1148 Pct 1148 EXCELSIOR 0.52
84006075PCT1149 1149 Pct 1149/1145 EXCELSIOR 0.53
84006075PCT1151 1151 NA VISITA VLY NA
84006075PCT1152 1152 NA EXCELSIOR NA
84006075PCT1153 1153 Pct 1153/1152 EXCELSIOR 0.46
84006075PCT1154 1154 NA EXCELSIOR NA
84006075PCT7001 7001 Pct 7001 MISSION 0.45
84006075PCT7002 7002 Pct 7002 POTRERO HILL 0.51
84006075PCT7003 7003 Pct 7003/7004 POTRERO HILL 0.49
84006075PCT7004 7004 NA POTRERO HILL NA
84006075PCT7005 7005 Pct 7005 POTRERO HILL 0.51
84006075PCT7006 7006 Pct 7006 POTRERO HILL 0.68
84006075PCT7007 7007 Pct 7007/7008 POTRERO HILL 0.46
84006075PCT7008 7008 NA POTRERO HILL NA
84006075PCT7009 7009 NA BAYVW/HTRSPT NA
84006075PCT7011 7011 Pct 7011/7009 POTRERO HILL 0.47
84006075PCT7012 7012 Pct 7012 POTRERO HILL 0.44
84006075PCT7013 7013 Pct 7013/7014 POTRERO HILL 0.44
84006075PCT7014 7014 NA POTRERO HILL NA
84006075PCT7015 7015 Pct 7015 MB BAYVW/HTRSPT NA
84006075PCT7016 7016 Pct 7016/7019 BAYVW/HTRSPT 0.46
84006075PCT7017 7017 NA BAYVW/HTRSPT NA
84006075PCT7018 7018 Pct 7018/7026 BAYVW/HTRSPT 0.47
84006075PCT7019 7019 NA BAYVW/HTRSPT NA
84006075PCT7021 7021 Pct 7021/7027 BAYVW/HTRSPT 0.42
84006075PCT7022 7022 Pct 7022 BAYVW/HTRSPT 0.41
84006075PCT7023 7023 Pct 7023/7017 BAYVW/HTRSPT 0.34
84006075PCT7024 7024 Pct 7024 BAYVW/HTRSPT 0.17
84006075PCT7025 7025 Pct 7025 BAYVW/HTRSPT 0.38
84006075PCT7026 7026 NA BAYVW/HTRSPT NA
84006075PCT7027 7027 NA BAYVW/HTRSPT NA
84006075PCT7028 7028 Pct 7028/7033 BAYVW/HTRSPT 0.4
84006075PCT7029 7029 Pct 7029 BAYVW/HTRSPT 0.35
84006075PCT7030 7030 Pct 7030/7031 BAYVW/HTRSPT 0.41
84006075PCT7031 7031 NA BAYVW/HTRSPT NA
84006075PCT7032 7032 Pct 7032 BAYVW/HTRSPT 0.4
84006075PCT7033 7033 NA BAYVW/HTRSPT NA
84006075PCT7034 7034 Pct 7034 BAYVW/HTRSPT 0.33
84006075PCT7035 7035 Pct 7035 BAYVW/HTRSPT 0.37
84006075PCT7036 7036 NA VISITA VLY NA
84006075PCT7037 7037 Pct 7037 VISITA VLY 0.26
84006075PCT7038 7038 Pct 7038 VISITA VLY 0.39
84006075PCT7039 7039 Pct 7039 VISITA VLY 0.46
84006075PCT7041 7041 Pct 7041 MB PORTOLA NA
84006075PCT7042 7042 NA VISITA VLY NA
84006075PCT7043 7043 Pct 7043 BAYVW/HTRSPT 0.43
84006075PCT7044 7044 NA BAYVW/HTRSPT NA
84006075PCT7045 7045 Pct 7045 VISITA VLY 0.48
84006075PCT7046 7046 Pct 7046/7042 VISITA VLY 0.52
84006075PCT7047 7047 Pct 7047 VISITA VLY 0.41
84006075PCT7048 7048 Pct 7048/7036 VISITA VLY 0.34
84006075PCT7049 7049 Pct 7049/7051 VISITA VLY 0.31
84006075PCT7051 7051 NA VISITA VLY NA
84006075PCT7052 7052 Pct 7052/7053 BAYVW/HTRSPT 0.4
84006075PCT7053 7053 NA BAYVW/HTRSPT NA
84006075PCT7054 7054 Pct 7054/7044 BAYVW/HTRSPT 0.35
84006075PCT7101 7101 Pct 7101 MB HAIGHT ASH 1
84006075PCT7201 7201 Pct 7201 MAR/PAC HTS 0.44
84006075PCT7202 7202 Pct 7202 MAR/PAC HTS 0.44
84006075PCT7203 7203 Pct 7203 MAR/PAC HTS 0.44
84006075PCT7204 7204 NA MAR/PAC HTS NA
84006075PCT7205 7205 Pct 7205/7204 MAR/PAC HTS 0.46
84006075PCT7206 7206 Pct 7206 MAR/PAC HTS 0.39
84006075PCT7207 7207 Pct 7207 MAR/PAC HTS 0.47
84006075PCT7208 7208 Pct 7208/7209 MAR/PAC HTS 0.5
84006075PCT7209 7209 NA MAR/PAC HTS NA
84006075PCT7301 7301 Pct 7301/7304 N EMBRCDRO 0.49
84006075PCT7302 7302 Pct 7302 N EMBRCDRO 0.53
84006075PCT7303 7303 Pct 7303/7306 CHINA 0.46
84006075PCT7304 7304 NA N EMBRCDRO NA
84006075PCT7305 7305 Pct 7305/7307 N EMBRCDRO 0.46
84006075PCT7306 7306 NA CHINA NA
84006075PCT7307 7307 NA N EMBRCDRO NA
84006075PCT7308 7308 Pct 7308 N EMBRCDRO 0.48
84006075PCT7309 7309 Pct 7309 CHINA 0.51
84006075PCT7311 7311 NA CHINA NA
84006075PCT7312 7312 Pct 7312 CHINA 0.39
84006075PCT7313 7313 Pct 7313/7314 CHINA 0.53
84006075PCT7314 7314 NA CHINA NA
84006075PCT7315 7315 Pct 7315/7316 CHINA 0.62
84006075PCT7316 7316 NA CHINA NA
84006075PCT7317 7317 Pct 7317 N EMBRCDRO 0.6
84006075PCT7318 7318 Pct 7318/7311 CHINA 0.51
84006075PCT7319 7319 Pct 7319/7324 CHINA 0.5
84006075PCT7321 7321 Pct 7321 CHINA 0.41
84006075PCT7322 7322 Pct 7322 CHINA 0.45
84006075PCT7323 7323 Pct 7323 CHINA 0.51
84006075PCT7324 7324 NA CHINA NA
84006075PCT7325 7325 Pct 7325 CHINA 0.45
84006075PCT7326 7326 Pct 7326 CHINA 0.57
84006075PCT7327 7327 NA CHINA NA
84006075PCT7328 7328 NA CVC CTR/DWTN NA
84006075PCT7329 7329 Pct 7329/7328 CVC CTR/DWTN 0.45
84006075PCT7331 7331 Pct 7331 N EMBRCDRO 0.52
84006075PCT7332 7332 Pct 7332/7334 CVC CTR/DWTN 0.64
84006075PCT7333 7333 Pct 7333 CHINA 0.52
84006075PCT7334 7334 NA CVC CTR/DWTN NA
84006075PCT7335 7335 NA CVC CTR/DWTN NA
84006075PCT7336 7336 Pct 7336/7345 CVC CTR/DWTN 0.56
84006075PCT7337 7337 Pct 7337 CVC CTR/DWTN 0.45
84006075PCT7338 7338 Pct 7338/7327 CVC CTR/DWTN 0.49
84006075PCT7339 7339 Pct 7339/7341 CVC CTR/DWTN 0.61
84006075PCT7341 7341 NA CVC CTR/DWTN NA
84006075PCT7342 7342 Pct 7342/7335 CVC CTR/DWTN 0.6
84006075PCT7343 7343 Pct 7343/7344 CVC CTR/DWTN 0.59
84006075PCT7344 7344 NA CVC CTR/DWTN NA
84006075PCT7345 7345 NA CVC CTR/DWTN NA
84006075PCT7346 7346 Pct 7346/7347 CVC CTR/DWTN 0.66
84006075PCT7347 7347 NA CVC CTR/DWTN NA
84006075PCT7348 7348 Pct 7348 CVC CTR/DWTN 0.51
84006075PCT7349 7349 Pct 7349 CVC CTR/DWTN 0.57
84006075PCT7501 7501 Pct 7501/7504 MAR/PAC HTS 0.31
84006075PCT7502 7502 NA MAR/PAC HTS NA
84006075PCT7503 7503 Pct 7503/7502 MAR/PAC HTS 0.56
84006075PCT7504 7504 NA WST ADDITION NA
84006075PCT7505 7505 Pct 7505 WST ADDITION 0.38
84006075PCT7506 7506 NA WST ADDITION NA
84006075PCT7507 7507 Pct 7507/7506 WST ADDITION 0.49
84006075PCT7508 7508 Pct 7508 WST ADDITION 0.54
84006075PCT7509 7509 Pct 7509/7511 MAR/PAC HTS 0.54
84006075PCT7511 7511 NA WST ADDITION NA
84006075PCT7512 7512 NA WST ADDITION NA
84006075PCT7513 7513 Pct 7513/7512 WST ADDITION 0.51
84006075PCT7514 7514 NA WST ADDITION NA
84006075PCT7515 7515 Pct 7515/7514 WST ADDITION 0.48
84006075PCT7516 7516 Pct 7516 WST ADDITION 0.43
84006075PCT7517 7517 NA HAIGHT ASH NA
84006075PCT7518 7518 Pct 7518/7517 HAIGHT ASH 0.59
84006075PCT7519 7519 NA HAIGHT ASH NA
84006075PCT7521 7521 Pct 7521/7519 HAIGHT ASH 0.54
84006075PCT7522 7522 NA WST ADDITION NA
84006075PCT7523 7523 Pct 7523/7522 WST ADDITION 0.67
84006075PCT7524 7524 Pct 7524 WST ADDITION 0.47
84006075PCT7525 7525 Pct 7525/7526 WST ADDITION 0.62
84006075PCT7526 7526 NA WST ADDITION NA
84006075PCT7527 7527 Pct 7527/7528 NA 0.47
84006075PCT7528 7528 NA WST ADDITION NA
84006075PCT7529 7529 Pct 7529/7531 WST ADDITION 0.6
84006075PCT7531 7531 NA WST ADDITION NA
84006075PCT7532 7532 Pct 7532/7545 WST ADDITION 0.54
84006075PCT7533 7533 Pct 7533/7534 HAIGHT ASH 0.61
84006075PCT7534 7534 NA HAIGHT ASH NA
84006075PCT7535 7535 NA HAIGHT ASH NA
84006075PCT7536 7536 Pct 7536/7537 HAIGHT ASH 0.54
84006075PCT7537 7537 NA HAIGHT ASH NA
84006075PCT7538 7538 NA HAIGHT ASH NA
84006075PCT7539 7539 Pct 7539/7538 WST ADDITION 0.59
84006075PCT7541 7541 NA WST ADDITION NA
84006075PCT7542 7542 Pct 7542/7541 WST ADDITION 0.63
84006075PCT7543 7543 Pct 7543/7544 WST ADDITION 0.56
84006075PCT7544 7544 NA WST ADDITION NA
84006075PCT7545 7545 NA WST ADDITION NA
84006075PCT7546 7546 Pct 7546/7547 HAIGHT ASH 0.58
84006075PCT7547 7547 NA HAIGHT ASH NA
84006075PCT7548 7548 Pct 7548/7535 HAIGHT ASH 0.55
84006075PCT7549 7549 NA INNER SUNSET NA
84006075PCT7551 7551 NA HAIGHT ASH NA
84006075PCT7552 7552 Pct 7552 HAIGHT ASH 0.48
84006075PCT7553 7553 Pct 7553 MB INNER SUNSET 1
84006075PCT7554 7554 Pct 7554/7549 INNER SUNSET 0.51
84006075PCT7555 7555 Pct 7555/7551 HAIGHT ASH 0.52
84006075PCT7556 7556 Pct 7556/7557 HAIGHT ASH 0.45
84006075PCT7557 7557 NA HAIGHT ASH NA
84006075PCT7601 7601 Pct 7601 CVC CTR/DWTN 0.69
84006075PCT7602 7602 NA CVC CTR/DWTN NA
84006075PCT7603 7603 NA CVC CTR/DWTN NA
84006075PCT7604 7604 Pct 7604/7603 CVC CTR/DWTN 0.63
84006075PCT7605 7605 Pct 7605/7611 CVC CTR/DWTN 0.57
84006075PCT7606 7606 NA CVC CTR/DWTN NA
84006075PCT7607 7607 Pct 7607/7602 CVC CTR/DWTN 0.66
84006075PCT7608 7608 Pct 7608/7609 CVC CTR/DWTN 0.47
84006075PCT7609 7609 NA CVC CTR/DWTN NA
84006075PCT7611 7611 NA CVC CTR/DWTN NA
84006075PCT7612 7612 Pct 7612/7606 CVC CTR/DWTN 0.53
84006075PCT7613 7613 Pct 7613/7614 CVC CTR/DWTN 0.67
84006075PCT7614 7614 NA CVC CTR/DWTN NA
84006075PCT7615 7615 Pct 7615/7617 CVC CTR/DWTN 0.56
84006075PCT7616 7616 Pct 7616 CVC CTR/DWTN 0.43
84006075PCT7617 7617 NA CVC CTR/DWTN NA
84006075PCT7618 7618 Pct 7618 MISSION 0.66
84006075PCT7619 7619 Pct 7619 SOMA 0.36
84006075PCT7621 7621 Pct 7621 SOMA 0.63
84006075PCT7622 7622 Pct 7622/7624 SOMA 0.57
84006075PCT7623 7623 Pct 7623/7629 SOMA 0.52
84006075PCT7624 7624 NA SOMA NA
84006075PCT7625 7625 Pct 7625 SOMA 0.39
84006075PCT7626 7626 Pct 7626 SOMA 0.38
84006075PCT7627 7627 Pct 7627 SOMA 0.4
84006075PCT7628 7628 Pct 7628 MISSION 0.65
84006075PCT7629 7629 NA SOMA NA
84006075PCT7631 7631 NA SOMA NA
84006075PCT7632 7632 Pct 7632 SOMA 0.54
84006075PCT7633 7633 Pct 7633/7631 SOMA 0.41
84006075PCT7634 7634 Pct 7634 SOMA 0.4
84006075PCT7635 7635 NA SOMA NA
84006075PCT7636 7636 Pct 7636/7635 SOMA 0.46
84006075PCT7637 7637 Pct 7637 SOMA 0.41
84006075PCT7638 7638 Pct 7638 SOMA 0.3
84006075PCT7639 7639 NA SOMA NA
84006075PCT7641 7641 Pct 7641/7639 SOMA 0.34
84006075PCT7642 7642 Pct 7642 SOMA 0.47
84006075PCT7643 7643 Pct 7643 POTRERO HILL 0.38
84006075PCT7644 7644 Pct 7644 POTRERO HILL 0.38
84006075PCT7645 7645 Pct 7645 POTRERO HILL 0.59
84006075PCT7646 7646 Pct 7646 POTRERO HILL 0.44
84006075PCT7647 7647 Pct 7647 SOMA 0.55
84006075PCT7648 7648 Pct 7648 MB SOMA NA
84006075PCT7701 7701 Pct 7701 W TWIN PKS 0.49
84006075PCT7702 7702 NA W TWIN PKS NA
84006075PCT7703 7703 Pct 7703 MB W TWIN PKS NA
84006075PCT7704 7704 Pct 7704/7702 W TWIN PKS 0.42
84006075PCT7705 7705 Pct 7705 W TWIN PKS 0.39
84006075PCT7706 7706 Pct 7706 W TWIN PKS 0.51
84006075PCT7707 7707 Pct 7707 W TWIN PKS 0.49
84006075PCT7708 7708 Pct 7708 W TWIN PKS 0.5
84006075PCT7709 7709 Pct 7709/7711 W TWIN PKS 0.58
84006075PCT7711 7711 NA W TWIN PKS NA
84006075PCT7712 7712 Pct 7712 W TWIN PKS 0.57
84006075PCT7801 7801 Pct 7801 UPRMKT/EURKA 0.47
84006075PCT7802 7802 Pct 7802 UPRMKT/EURKA 0.47
84006075PCT7803 7803 NA UPRMKT/EURKA NA
84006075PCT7804 7804 Pct 7804 UPRMKT/EURKA 0.5
84006075PCT7805 7805 NA UPRMKT/EURKA NA
84006075PCT7806 7806 Pct 7806/7805 UPRMKT/EURKA 0.57
84006075PCT7807 7807 NA UPRMKT/EURKA NA
84006075PCT7808 7808 Pct 7808/7807 UPRMKT/EURKA 0.54
84006075PCT7809 7809 Pct 7809 UPRMKT/EURKA 0.58
84006075PCT7811 7811 NA MISSION NA
84006075PCT7812 7812 Pct 7812/7811 MISSION 0.59
84006075PCT7813 7813 NA UPRMKT/EURKA NA
84006075PCT7814 7814 Pct 7814/7813 MISSION 0.64
84006075PCT7815 7815 Pct 7815 UPRMKT/EURKA 0.57
84006075PCT7816 7816 Pct 7816/7803 UPRMKT/EURKA 0.49
84006075PCT7817 7817 NA UPRMKT/EURKA NA
84006075PCT7818 7818 Pct 7818/7817 UPRMKT/EURKA 0.58
84006075PCT7819 7819 Pct 7819 MISSION 0.58
84006075PCT7821 7821 NA UPRMKT/EURKA NA
84006075PCT7822 7822 Pct 7822/7821 UPRMKT/EURKA 0.53
84006075PCT7823 7823 Pct 7823 UPRMKT/EURKA 0.52
84006075PCT7824 7824 Pct 7824/7825 UPRMKT/EURKA 0.49
84006075PCT7825 7825 NA UPRMKT/EURKA NA
84006075PCT7826 7826 NA MISSION NA
84006075PCT7827 7827 Pct 7827/7826 MISSION 0.59
84006075PCT7828 7828 Pct 7828 UPRMKT/EURKA 0.48
84006075PCT7829 7829 NA UPRMKT/EURKA NA
84006075PCT7831 7831 Pct 7831 UPRMKT/EURKA 0.45
84006075PCT7832 7832 Pct 7832 UPRMKT/EURKA 0.53
84006075PCT7833 7833 Pct 7833 MISSION 0.51
84006075PCT7834 7834 Pct 7834/7843 MISSION 0.63
84006075PCT7835 7835 Pct 7835 NOE VALLEY 0.59
84006075PCT7836 7836 Pct 7836 NOE VALLEY 0.53
84006075PCT7837 7837 Pct 7837/7829 NOE VALLEY 0.43
84006075PCT7838 7838 Pct 7838 NOE VALLEY 0.49
84006075PCT7839 7839 Pct 7839 NOE VALLEY 0.46
84006075PCT7841 7841 Pct 7841/7848 NOE VALLEY 0.48
84006075PCT7842 7842 Pct 7842/7849 MISSION 0.55
84006075PCT7843 7843 NA MISSION NA
84006075PCT7844 7844 Pct 7844/7858 MISSION 0.59
84006075PCT7845 7845 Pct 7845 NOE VALLEY 0.38
84006075PCT7846 7846 NA NOE VALLEY NA
84006075PCT7847 7847 Pct 7847/7846 NOE VALLEY 0.5
84006075PCT7848 7848 NA NOE VALLEY NA
84006075PCT7849 7849 NA NOE VALLEY NA
84006075PCT7851 7851 NA DIAMD HTS NA
84006075PCT7852 7852 Pct 7852/7851 DIAMD HTS 0.36
84006075PCT7853 7853 NA DIAMD HTS NA
84006075PCT7854 7854 NA NOE VALLEY NA
84006075PCT7855 7855 Pct 7855/7854 NOE VALLEY 0.43
84006075PCT7856 7856 Pct 7856/7857 NOE VALLEY 0.53
84006075PCT7857 7857 NA NOE VALLEY NA
84006075PCT7858 7858 NA MISSION NA
84006075PCT7859 7859 Pct 7859/7853 DIAMD HTS 0.42
84006075PCT7861 7861 Pct 7861/7862 DIAMD HTS 0.48
84006075PCT7862 7862 NA NOE VALLEY NA
84006075PCT7863 7863 Pct 7863 NOE VALLEY 0.53
84006075PCT7864 7864 Pct 7864/7869 NOE VALLEY 0.45
84006075PCT7865 7865 Pct 7865/7873 NOE VALLEY 0.54
84006075PCT7866 7866 Pct 7866 DIAMD HTS 0.37
84006075PCT7867 7867 Pct 7867/7868 DIAMD HTS 0.43
84006075PCT7868 7868 NA DIAMD HTS NA
84006075PCT7869 7869 NA S BERNAL HTS NA
84006075PCT7871 7871 Pct 7871 DIAMD HTS 0.4
84006075PCT7872 7872 Pct 7872 S BERNAL HTS 0.47
84006075PCT7873 7873 NA S BERNAL HTS NA
84006075PCT7874 7874 Pct 7874 S BERNAL HTS 0.44
84006075PCT7875 7875 Pct 7875 S BERNAL HTS 0.52
84006075PCT7901 7901 NA MISSION NA
84006075PCT7902 7902 Pct 7902/7901 MISSION 0.65
84006075PCT7903 7903 Pct 7903 MISSION 0.58
84006075PCT7904 7904 Pct 7904 MISSION 0.61
84006075PCT7905 7905 Pct 7905 MISSION 0.57
84006075PCT7906 7906 Pct 7906 MISSION 0.64
84006075PCT7907 7907 Pct 7907/7908 MISSION 0.61
84006075PCT7908 7908 NA MISSION NA
84006075PCT7909 7909 Pct 7909/7911 MISSION 0.62
84006075PCT7911 7911 NA MISSION NA
84006075PCT7912 7912 Pct 7912 MISSION 0.6
84006075PCT7913 7913 Pct 7913 MISSION 0.63
84006075PCT7914 7914 NA MISSION NA
84006075PCT7915 7915 Pct 7915/7914 MISSION 0.61
84006075PCT7916 7916 Pct 7916 MISSION 0.64
84006075PCT7917 7917 Pct 7917/7918 MISSION 0.55
84006075PCT7918 7918 NA MISSION NA
84006075PCT7919 7919 Pct 7919 MISSION 0.61
84006075PCT7921 7921 NA MISSION NA
84006075PCT7922 7922 Pct 7922/7921 MISSION 0.63
84006075PCT7923 7923 NA MISSION NA
84006075PCT7924 7924 Pct 7924/7923 MISSION 0.6
84006075PCT7925 7925 Pct 7925 N BERNAL HTS 0.65
84006075PCT7926 7926 Pct 7926 N BERNAL HTS 0.57
84006075PCT7927 7927 Pct 7927/7928 N BERNAL HTS 0.53
84006075PCT7928 7928 NA N BERNAL HTS NA
84006075PCT7929 7929 NA N BERNAL HTS NA
84006075PCT7931 7931 Pct 7931 N BERNAL HTS 0.5
84006075PCT7932 7932 Pct 7932 N BERNAL HTS 0.47
84006075PCT7933 7933 Pct 7933 MB BAYVW/HTRSPT NA
84006075PCT7934 7934 Pct 7934 N BERNAL HTS 0.58
84006075PCT7935 7935 Pct 7935/7929 N BERNAL HTS 0.52
84006075PCT7936 7936 Pct 7936 N BERNAL HTS 0.59
84006075PCT7937 7937 Pct 7937 N BERNAL HTS 0.58
84006075PCT7938 7938 NA S BERNAL HTS NA
84006075PCT7939 7939 Pct 7939/7941 S BERNAL HTS 0.47
84006075PCT7941 7941 NA S BERNAL HTS NA
84006075PCT7942 7942 Pct 7942 S BERNAL HTS 0.52
84006075PCT7943 7943 Pct 7943 S BERNAL HTS 0.46
84006075PCT7944 7944 Pct 7944/7938 S BERNAL HTS 0.57
84006075PCT7945 7945 Pct 7945 S BERNAL HTS 0.6
84006075PCT7946 7946 Pct 7946/7948 PORTOLA 0.46
84006075PCT7947 7947 Pct 7947 PORTOLA 0.44
84006075PCT7948 7948 NA PORTOLA NA
84006075PCT7949 7949 NA PORTOLA NA
84006075PCT7951 7951 NA PORTOLA NA
84006075PCT7952 7952 Pct 7952/7951 PORTOLA 0.49
84006075PCT7953 7953 Pct 7953/7949 PORTOLA 0.52
84006075PCT7954 7954 NA VISITA VLY NA
84006075PCT7955 7955 Pct 7955 PORTOLA 0.4
84006075PCT7956 7956 Pct 7956 PORTOLA 0.38
84006075PCT7957 7957 Pct 7957 PORTOLA 0.42
84006075PCT7958 7958 Pct 7958 MB PORTOLA 0
84006075PCT9001 9001 Pct 9001 MB VISITA VLY 0.5
84006075PCT9101 9101 Pct 9101 RICHMOND 0.55
84006075PCT9102 9102 Pct 9102 RICHMOND 0.49
84006075PCT9103 9103 Pct 9103/9104 RICHMOND 0.55
84006075PCT9104 9104 NA RICHMOND NA
84006075PCT9105 9105 NA SECLF/PREHTS NA
84006075PCT9106 9106 NA SECLF/PREHTS NA
84006075PCT9107 9107 Pct 9107/9105 RICHMOND 0.56
84006075PCT9108 9108 Pct 9108/9111 RICHMOND 0.55
84006075PCT9109 9109 Pct 9109/9106 RICHMOND 0.49
84006075PCT9111 9111 NA RICHMOND NA
84006075PCT9112 9112 NA RICHMOND NA
84006075PCT9113 9113 Pct 9113 SECLF/PREHTS 0.48
84006075PCT9114 9114 Pct 9114/9112 RICHMOND 0.56
84006075PCT9115 9115 NA RICHMOND NA
84006075PCT9116 9116 Pct 9116/9115 RICHMOND 0.53
84006075PCT9117 9117 Pct 9117/9118 RICHMOND 0.44
84006075PCT9118 9118 NA RICHMOND NA
84006075PCT9119 9119 NA RICHMOND NA
84006075PCT9121 9121 Pct 9121/9119 RICHMOND 0.51
84006075PCT9122 9122 Pct 9122/9139 RICHMOND 0.5
84006075PCT9123 9123 Pct 9123/9124 RICHMOND 0.56
84006075PCT9124 9124 NA RICHMOND NA
84006075PCT9125 9125 Pct 9125 RICHMOND 0.56
84006075PCT9126 9126 Pct 9126/9144 RICHMOND 0.52
84006075PCT9127 9127 Pct 9127 RICHMOND 0.45
84006075PCT9128 9128 Pct 9128/9129 RICHMOND 0.5
84006075PCT9129 9129 NA RICHMOND NA
84006075PCT9131 9131 Pct 9131/9132 RICHMOND 0.53
84006075PCT9132 9132 NA RICHMOND NA
84006075PCT9133 9133 Pct 9133 RICHMOND 0.47
84006075PCT9134 9134 Pct 9134 LRL HTS/ANZA 0.46
84006075PCT9135 9135 Pct 9135 RICHMOND 0.41
84006075PCT9136 9136 Pct 9136 RICHMOND 0.56
84006075PCT9137 9137 Pct 9137/9138 RICHMOND 0.5
84006075PCT9138 9138 NA RICHMOND NA
84006075PCT9139 9139 NA RICHMOND NA
84006075PCT9141 9141 Pct 9141 RICHMOND 0.53
84006075PCT9142 9142 Pct 9142/9143 RICHMOND 0.55
84006075PCT9143 9143 NA RICHMOND NA
84006075PCT9144 9144 NA RICHMOND NA
84006075PCT9145 9145 NA RICHMOND NA
84006075PCT9146 9146 Pct 9146/9145 RICHMOND 0.55
84006075PCT9147 9147 NA RICHMOND NA
84006075PCT9148 9148 Pct 9148/9147 RICHMOND 0.48
84006075PCT9149 9149 NA LRL HTS/ANZA NA
84006075PCT9151 9151 Pct 9151 LRL HTS/ANZA 0.4
84006075PCT9152 9152 Pct 9152/9149 LRL HTS/ANZA 0.54
84006075PCT9201 9201 Pct 9201 MAR/PAC HTS 0.61
84006075PCT9202 9202 Pct 9202 MAR/PAC HTS 0.39
84006075PCT9203 9203 NA MAR/PAC HTS NA
84006075PCT9204 9204 NA MAR/PAC HTS NA
84006075PCT9205 9205 Pct 9205/9213 MAR/PAC HTS 0.51
84006075PCT9206 9206 Pct 9206/9203 MAR/PAC HTS 0.34
84006075PCT9207 9207 NA MAR/PAC HTS NA
84006075PCT9208 9208 Pct 9208 MAR/PAC HTS 0.34
84006075PCT9209 9209 Pct 9209/9204 MAR/PAC HTS 0.35
84006075PCT9211 9211 Pct 9211/9207 MAR/PAC HTS 0.36
84006075PCT9212 9212 Pct 9212 MAR/PAC HTS 0.42
84006075PCT9213 9213 NA MAR/PAC HTS NA
84006075PCT9214 9214 Pct 9214 MAR/PAC HTS 0.47
84006075PCT9215 9215 Pct 9215 MAR/PAC HTS 0.35
84006075PCT9216 9216 NA MAR/PAC HTS NA
84006075PCT9217 9217 NA MAR/PAC HTS NA
84006075PCT9218 9218 NA MAR/PAC HTS NA
84006075PCT9219 9219 Pct 9219/9218 MAR/PAC HTS 0.43
84006075PCT9221 9221 Pct 9221 MAR/PAC HTS 0.4
84006075PCT9222 9222 Pct 9222/9216 MAR/PAC HTS 0.33
84006075PCT9223 9223 Pct 9223/9217 MAR/PAC HTS 0.5
84006075PCT9224 9224 Pct 9224 MAR/PAC HTS 0.34
84006075PCT9225 9225 Pct 9225/9226 MAR/PAC HTS 0.41
84006075PCT9226 9226 NA MAR/PAC HTS NA
84006075PCT9227 9227 Pct 9227/9228 SECLF/PREHTS 0.48
84006075PCT9228 9228 NA SECLF/PREHTS NA
84006075PCT9229 9229 Pct 9229 SECLF/PREHTS 0.39
84006075PCT9231 9231 Pct 9231 SECLF/PREHTS 0.5
84006075PCT9232 9232 Pct 9232/9233 SECLF/PREHTS 0.39
84006075PCT9233 9233 NA SECLF/PREHTS NA
84006075PCT9234 9234 Pct 9234/9235 SECLF/PREHTS 0.38
84006075PCT9235 9235 NA SECLF/PREHTS NA
84006075PCT9236 9236 NA MAR/PAC HTS NA
84006075PCT9237 9237 NA MAR/PAC HTS NA
84006075PCT9238 9238 Pct 9238/9246 MAR/PAC HTS 0.39
84006075PCT9239 9239 Pct 9239 MAR/PAC HTS 0.42
84006075PCT9241 9241 Pct 9241 MAR/PAC HTS 0.48
84006075PCT9242 9242 Pct 9242/9248 MAR/PAC HTS 0.41
84006075PCT9243 9243 Pct 9243/9236 MAR/PAC HTS 0.42
84006075PCT9244 9244 Pct 9244/9237 MAR/PAC HTS 0.44
84006075PCT9245 9245 Pct 9245/9247 MAR/PAC HTS 0.46
84006075PCT9246 9246 NA MAR/PAC HTS NA
84006075PCT9247 9247 NA MAR/PAC HTS NA
84006075PCT9248 9248 NA MAR/PAC HTS NA
84006075PCT9249 9249 NA LRL HTS/ANZA NA
84006075PCT9251 9251 Pct 9251/9249 LRL HTS/ANZA 0.44
84006075PCT9252 9252 Pct 9252 LRL HTS/ANZA 0.43
84006075PCT9253 9253 Pct 9253 LRL HTS/ANZA 0.35
84006075PCT9254 9254 NA WST ADDITION NA
84006075PCT9255 9255 Pct 9255 LRL HTS/ANZA 0.45
84006075PCT9256 9256 Pct 9256/9254 WST ADDITION 0.49
84006075PCT9257 9257 Pct 9257 MB WST ADDITION 0.5
84006075PCT9258 9258 Pct 9258 LRL HTS/ANZA 0.46
84006075PCT9401 9401 Pct 9401/9411 SUNSET 0.6
84006075PCT9402 9402 Pct 9402/9403 SUNSET 0.5
84006075PCT9403 9403 NA SUNSET NA
84006075PCT9404 9404 Pct 9404 SUNSET 0.58
84006075PCT9405 9405 Pct 9405 SUNSET 0.47
84006075PCT9406 9406 Pct 9406 SUNSET 0.45
84006075PCT9407 9407 Pct 9407 SUNSET 0.45
84006075PCT9408 9408 Pct 9408 SUNSET 0.57
84006075PCT9409 9409 Pct 9409 INNER SUNSET 0.62
84006075PCT9411 9411 NA SUNSET NA
84006075PCT9412 9412 NA SUNSET NA
84006075PCT9413 9413 Pct 9413 SUNSET 0.52
84006075PCT9414 9414 NA SUNSET NA
84006075PCT9415 9415 NA SUNSET NA
84006075PCT9416 9416 Pct 9416/9412 SUNSET 0.49
84006075PCT9417 9417 NA SUNSET NA
84006075PCT9418 9418 Pct 9418/9417 SUNSET 0.47
84006075PCT9419 9419 Pct 9419/9414 SUNSET 0.57
84006075PCT9421 9421 Pct 9421/9415 SUNSET 0.55
84006075PCT9422 9422 Pct 9422/9428 SUNSET 0.47
84006075PCT9423 9423 Pct 9423/9434 SUNSET 0.44
84006075PCT9424 9424 Pct 9424/9425 SUNSET 0.42
84006075PCT9425 9425 NA SUNSET NA
84006075PCT9426 9426 Pct 9426 SUNSET 0.47
84006075PCT9427 9427 Pct 9427 SUNSET 0.52
84006075PCT9428 9428 NA SUNSET NA
84006075PCT9429 9429 Pct 9429/9431 SUNSET 0.51
84006075PCT9431 9431 NA SUNSET NA
84006075PCT9432 9432 Pct 9432 SUNSET 0.45
84006075PCT9433 9433 Pct 9433 SUNSET 0.43
84006075PCT9434 9434 NA SUNSET NA
84006075PCT9435 9435 NA SUNSET NA
84006075PCT9436 9436 Pct 9436 SUNSET 0.37
84006075PCT9437 9437 Pct 9437/9445 SUNSET 0.45
84006075PCT9438 9438 NA SUNSET NA
84006075PCT9439 9439 Pct 9439/9438 SUNSET 0.51
84006075PCT9441 9441 NA SUNSET NA
84006075PCT9442 9442 Pct 9442/9435 SUNSET 0.51
84006075PCT9443 9443 Pct 9443/9441 SUNSET 0.47
84006075PCT9444 9444 NA SUNSET NA
84006075PCT9445 9445 NA SUNSET NA
84006075PCT9446 9446 NA SUNSET NA
84006075PCT9447 9447 Pct 9447/9448 SUNSET 0.57
84006075PCT9448 9448 NA SUNSET NA
84006075PCT9449 9449 Pct 9449/9444 SUNSET 0.48
84006075PCT9451 9451 Pct 9451 SUNSET 0.61
84006075PCT9452 9452 Pct 9452/9446 SUNSET 0.51
84006075PCT9453 9453 Pct 9453 SUNSET 0.58
84006075PCT9501 9501 Pct 9501 MB WST ADDITION NA
84006075PCT9502 9502 Pct 9502 MB LRL HTS/ANZA 1
84006075PCT9503 9503 Pct 9503/9504 WST ADDITION 0.44
84006075PCT9504 9504 NA WST ADDITION NA
84006075PCT9505 9505 Pct 9505/9506 WST ADDITION 0.52
84006075PCT9506 9506 NA WST ADDITION NA
84006075PCT9507 9507 Pct 9507/9509 LRL HTS/ANZA 0.59
84006075PCT9508 9508 NA WST ADDITION NA
84006075PCT9509 9509 NA LRL HTS/ANZA NA
84006075PCT9511 9511 Pct 9511 WST ADDITION 0.59
84006075PCT9512 9512 Pct 9512 WST ADDITION 0.59
84006075PCT9513 9513 Pct 9513/9508 WST ADDITION 0.59
84006075PCT9514 9514 NA NA NA
84006075PCT9515 9515 NA INNER SUNSET NA
84006075PCT9516 9516 Pct 9516/9515 INNER SUNSET 0.55
84006075PCT9517 9517 NA INNER SUNSET NA
84006075PCT9518 9518 Pct 9518/9517 INNER SUNSET 0.52
84006075PCT9519 9519 NA INNER SUNSET NA
84006075PCT9521 9521 Pct 9521/9519 INNER SUNSET 0.55
84006075PCT9522 9522 Pct 9522/9514 INNER SUNSET 0.54
84006075PCT9701 9701 NA INNER SUNSET NA
84006075PCT9702 9702 Pct 9702/9701 INNER SUNSET 0.55
84006075PCT9703 9703 Pct 9703 W TWIN PKS 0.41
84006075PCT9704 9704 Pct 9704/9705 W TWIN PKS 0.46
84006075PCT9705 9705 NA W TWIN PKS NA
84006075PCT9706 9706 Pct 9706 MB W TWIN PKS NA
84006075PCT9707 9707 NA W TWIN PKS NA
84006075PCT9708 9708 Pct 9708/9707 W TWIN PKS 0.46
84006075PCT9709 9709 NA W TWIN PKS NA
84006075PCT9711 9711 Pct 9711 W TWIN PKS 0.34
84006075PCT9712 9712 Pct 9712 W TWIN PKS 0.52
84006075PCT9713 9713 Pct 9713/9709 W TWIN PKS 0.48
84006075PCT9714 9714 Pct 9714 W TWIN PKS 0.47
84006075PCT9715 9715 Pct 9715 W TWIN PKS 0.41
84006075PCT9716 9716 Pct 9716/9717 W TWIN PKS 0.46
84006075PCT9717 9717 NA W TWIN PKS NA
84006075PCT9718 9718 Pct 9718 W TWIN PKS 0.45
84006075PCT9719 9719 NA W TWIN PKS NA
84006075PCT9721 9721 Pct 9721/9719 W TWIN PKS 0.38
84006075PCT9722 9722 Pct 9722 W TWIN PKS 0.38
84006075PCT9723 9723 Pct 9723 LAKE MERCED 0.42
84006075PCT9724 9724 NA LAKE MERCED NA
84006075PCT9725 9725 Pct 9725/9724 LAKE MERCED 0.44
84006075PCT9726 9726 Pct 9726 LAKE MERCED 0.48
84006075PCT9727 9727 Pct 9727/9742 W TWIN PKS 0.48
84006075PCT9728 9728 Pct 9728/9748 W TWIN PKS 0.41
84006075PCT9729 9729 Pct 9729/9734 W TWIN PKS 0.42
84006075PCT9731 9731 Pct 9731/9735 W TWIN PKS 0.42
84006075PCT9732 9732 Pct 9732 MB W TWIN PKS 0
84006075PCT9733 9733 Pct 9733 MB W TWIN PKS 0
84006075PCT9734 9734 NA W TWIN PKS NA
84006075PCT9735 9735 NA W TWIN PKS NA
84006075PCT9736 9736 NA W TWIN PKS NA
84006075PCT9737 9737 Pct 9737/9736 W TWIN PKS 0.47
84006075PCT9738 9738 Pct 9738 LAKE MERCED 0.51
84006075PCT9739 9739 NA LAKE MERCED NA
84006075PCT9741 9741 Pct 9741 LAKE MERCED 0.4
84006075PCT9742 9742 NA W TWIN PKS NA
84006075PCT9743 9743 NA LAKE MERCED NA
84006075PCT9744 9744 Pct 9744/9739 LAKE MERCED 0.49
84006075PCT9745 9745 Pct 9745/9743 LAKE MERCED 0.55
84006075PCT9746 9746 Pct 9746 W TWIN PKS 0.39
84006075PCT9747 9747 Pct 9747 W TWIN PKS 0.54
84006075PCT9748 9748 NA W TWIN PKS NA
84006075PCT9749 9749 Pct 9749 INGLESIDE 0.38
84006075PCT9751 9751 Pct 9751 W TWIN PKS 0.42
84006075PCT9752 9752 Pct 9752/9753 W TWIN PKS 0.39
84006075PCT9753 9753 NA W TWIN PKS NA
84006075PCT9754 9754 NA W TWIN PKS NA
84006075PCT9755 9755 Pct 9755/9754 W TWIN PKS 0.43
84006075PCT9756 9756 Pct 9756 EXCELSIOR 0.44
84006075PCT9801 9801 Pct 9801 EXCELSIOR 0.4
84006075PCT9900 9900 NA NA NA
84006075PCT9901 9901 NA EXCELSIOR NA
84006075PCT9902 9902 NA EXCELSIOR NA
84006075PCTGGP2 Golden Gate Park NA NA NA
84006075PCTGGP1 Golden Gate Park NA NA NA
<!DOCTYPE html>
<meta charset="utf-8">
<head>
<title>San Francisco Precincts / Prop F</title>
<style>
body {
height: 100%;
margin: 0;
padding: 0;
font-family: 'Lato', sans-serif;
color: #272a2f;
}
#mapcanvas {
width: 960px;
height: 600px;
margin: 10px 10px 10px 10px;
/*padding: 5px 5px 5px 5px;*/
border: 0.2px solid #555;
}
.precinct {
fill: #f6f6f6;
/*fill: #eee;*/
}
.precinct-boundary {
fill: none;
stroke: #fff;
stroke-width: none;
}
</style>
<link href='https://fonts.googleapis.com/css?family=Varela+Round' rel='stylesheet' type='text/css'>
<link href='https://fonts.googleapis.com/css?family=Lato' rel='stylesheet' type='text/css'>
</head>
<body>
<div id="mapcanvas" ></div>
<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.5/d3.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/topojson/1.6.19/topojson.min.js"></script>
<script src="https://d3js.org/queue.v1.min.js"></script>
<script>
var width = 960,
height = 600;
// PROJECTION
// SF_DOE_Precincts_20120702.prj
// You can also center the map on: -122.51494800050519,37.70813100002812 like in the TopoJSON
/*var projection = d3.geo.conicConformal()
.rotate([0, 0, 0])
.center([-122.433701, 37.767683])
.scale(235000)
.parallels([37.06666666666667, 38.43333333333333])
.translate([width / 2, height / 2])
.precision(.1);*/
// MERCATOR
var projection = d3.geo.mercator()
.center([-122.433701, 37.767683])
.scale(211000)
.translate([width / 2, 310]);
var path = d3.geo.path()
.projection(projection);
var svg = d3.select("#mapcanvas").append("svg")
.attr("width", width)
.attr("height", height);
// Title inside the Map
svg.append("text")
.attr("x", "50")
.attr("y", "29")
.attr("text-anchor", "start")
.style("font-size", "16px")
.style("text-decoration", "none")
.text("Prop F, Election Day, November 3, 2015");
var linear = d3.scale.linear()
.domain([0, 0.5, 1])
.range(["red", "white", "green"]);
// Linear 2
// Excluding outliers (but please check the data first)
var linear2 = d3.scale.linear()
.domain([0.25, 0.5, 0.75])
.range(["red", "white", "green"]);
var threshold = d3.scale.threshold()
.domain([0, 0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, 0.9, 1])
.range(["#8e0152", "#c51b7d", "#de77ae", "#f1b6da", "#fde0ef", "#f7f7f7", "#e6f5d0", "#b8e186", "#7fbc41", "#4d9221", "#276419"]);
queue()
.defer(d3.json, 'san_francisco_precinct_20120702.topojson')
.defer(d3.csv, 'DATA_prop_f_election_day_yes_percentage_20151103_20151119.csv') // REPLACE REF WITH DATA
.await(ready);
function ready(error, MAP, DATA) { // REPLACE REF WITH DATA
if (error) throw error;
console.log(MAP) // CHECK YOUR MAP
console.log(DATA) // CHECK YOUR DATA
var precincts = topojson.feature(MAP, MAP.objects.precinct);
var pctname = {};
DATA.forEach(function(d) { pctname[d.id] = d.precinct_names})
var nh = {};
DATA.forEach(function(d) { nh[d.id] = d.neighborhood})
var yesp = {};
DATA.forEach(function(d) { yesp[d.id] = +d.yes_percentage; });
svg.append("g")
.attr("class", "precinct")
.selectAll("path")
.data(precincts.features)
.enter()
.append("path")
.attr("d", path)
.style("fill", function(d) { return linear(yesp[d.id]); }) // yes percentage
.append('svg:title').text(function(d) {
// return ("GeoID: " + d.id); });
return (nh[d.id] + ", " + pctname[d.id] +": " + (yesp[d.id]*100) + "% Yes"); });
//Borders
svg.append("path")
.datum(topojson.mesh(MAP, MAP.objects.precinct, function(a, b) { return a !== b; }))
.attr("class", "precinct-boundary")
.attr("d", path);
};
</script>
</body>
</html>
Display the source blob
Display the rendered blob
Raw
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment