Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13382 | 13382 | 39972 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
13458 | 13458 | 24144 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6016701.61434 | 2095161.25681 | 37.7338509755474 | -122.38463593799999 | (37.7338509755474, -122.384635938) | |||
13460 | 13460 | 6707 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017570.5024 | 2096779.6090000002 | 37.7383426628708 | -122.381744418894 | (37.7383426628708, -122.381744418894) | |||
13466 | 13466 | 104640 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 112 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x2.5 | 6009509.89326 | 2111697.52669 | 37.778855505921605 | -122.410667371323 | (37.7788555059216, -122.410667371323) | |||
13509 | 13509 | 106317 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1133 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 4x4 | 6012240.80146 | 2103138.9754 | 37.7555083807236 | -122.400618637234 | (37.7555083807236, -122.400618637234) | |||
13612 | 13612 | 3695 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6017120.58643 | 2098873.01635 | 37.7440658827378 | -122.383445712243 | (37.7440658827378, -122.383445712243) | |||
13675 | 13675 | 18550 | Landmark tree 9 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700X Quesada Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014656.2717 | 2095062.2920900001 | 37.733465912826 | -122.391700443637 | (37.733465912826, -122.391700443637) | |||
13683 | 13683 | 1710 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 5 Bass Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016578.92227 | 2095125.73941 | 37.73374666585679 | -122.385057651709 | (37.7337466658568, -122.385057651709) | |||
13761 | 13761 | 6553 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1275 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x8 | 6017462.04156 | 2097126.1556099998 | 37.7392882208803 | -122.382143528109 | (37.7392882208803, -122.382143528109) | |||
13841 | 13841 | 3685 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout 5 | Tree 1 | Port 9 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767871999 | (37.744924332395, -122.38470767872) | |||
13870 | 13870 | 24143 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016705.2095099995 | 2095147.06572 | 37.7338122084672 | -122.38462252011999 | (37.7338122084672, -122.38462252012) | |||
13955 | 13955 | 97226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.1276900002 | 37.7332433315076 | -122.38482148523899 | (37.7332433315076, -122.384821485239) | ||
13964 | 13964 | 24120 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6016647.77235 | 2095170.8389599998 | 37.7338743084492 | -122.384822755067 | (37.7338743084492, -122.384822755067) | |||
14006 | 14006 | 6423 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100X Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6018250.03314 | 2096623.41897 | 37.7379512950012 | -122.37938406274901 | (37.7379512950012, -122.379384062749) | |||
14058 | 14058 | 6836 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1475 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2015 12:00:00 AM | 3 | 3X3 | 6016046.71071 | 2097829.88517 | 37.7411422488076 | -122.387086226361 | (37.7411422488076, -122.387086226361) | ||
14068 | 14068 | 30309 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 228 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 8 | |||||||||
14082 | 14082 | 6598 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016617.02929 | 2097872.2499700002 | 37.741290138730506 | -122.385117202121 | (37.7412901387305, -122.385117202121) | |||
14116 | 14116 | 24108 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016610.88324 | 2095264.1891400001 | 37.7341285890533 | -122.384956794538 | (37.7341285890533, -122.384956794538) | |||
14140 | 14140 | 6797 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1375 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 6016896.75135 | 2097199.75019 | 37.7394590596789 | -122.384103192232 | (37.7394590596789, -122.384103192232) | |||
14161 | 14161 | 24226 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 60 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6017135.66368 | 2094974.09134 | 37.7333610509772 | -122.38312226117901 | (37.7333610509772, -122.383122261179) | |||
14181 | 14181 | 24141 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6016711.43718 | 2095116.50195 | 37.733728630852795 | -122.38459886076001 | (37.7337286308528, -122.38459886076) | |||
14364 | 14364 | 6420 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100X Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/29/1990 12:00:00 AM | 12 | 3x3 | 6018302.7051 | 2096585.42337 | 37.7378498712671 | -122.379199309611 | (37.7378498712671, -122.379199309611) | ||
14399 | 14399 | 6795 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1375 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016906.375469999 | 2097191.59326 | 37.7394371944809 | -122.384069348045 | (37.7394371944809, -122.384069348045) | |||
14568 | 14568 | 8258 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1555 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2004 12:00:00 AM | 30 | 3x3 | 6015878.41647 | 2097607.57172 | 37.7405225008163 | -122.387652625679 | (37.7405225008163, -122.387652625679) | ||
14724 | 14724 | 28654 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1275 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2004 12:00:00 AM | 3 | 6x3 | 6017442.42343 | 2097139.5251799999 | 37.739323847514 | -122.38221228939 | (37.739323847514, -122.38221228939) | ||
14728 | 14728 | 6594 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 12 | 3X3 | 6016699.98802 | 2097810.08527 | 37.741124035759796 | -122.384826027706 | (37.7411240357598, -122.384826027706) | ||
14779 | 14779 | 6775 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1355 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2016 12:00:00 AM | 12 | 3x3 | 6017039.80382 | 2097089.47454 | 37.7391641728912 | -122.383600899281 | (37.7391641728912, -122.383600899281) | ||
14857 | 14857 | 6772 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1353 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2016 12:00:00 AM | 12 | 3x3 | 6017054.96873 | 2097078.5407099999 | 37.739134988985796 | -122.38354770437401 | (37.7391349889858, -122.383547704374) | ||
14947 | 14947 | 24225 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 58 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6017167.401959999 | 2094982.30239 | 37.7333853506538 | -122.38301310328698 | (37.7333853506538, -122.383013103287) | ||
15245 | 15245 | 11544 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Jennings St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6018840.43674 | 2097157.24182 | 37.7394496095988 | -122.37737975539 | (37.7394496095988, -122.37737975539) | ||
15286 | 15286 | 8276 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6015781.61274 | 2097763.57245 | 37.740945484337395 | -122.387998221651 | (37.7409454843374, -122.387998221651) | |||
15352 | 15352 | 97230 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 15x200 | 6016626.81073 | 2094919.21722 | 37.7331822459561 | -122.38487770274999 | (37.7331822459561, -122.38487770275) | |||
15459 | 15459 | 6794 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1375 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6016884.458330001 | 2097207.3634599997 | 37.7394792845271 | -122.38414622657 | (37.7394792845271, -122.38414622657) | ||
15525 | 15525 | 3745 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900 Carolina St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 18 | 6012461.71984 | 2103674.63492 | 37.7569915030708 | -122.39989224135799 | (37.7569915030708, -122.399892241358) | |||
15553 | 15553 | 20453 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 495X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
15650 | 15650 | 24228 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 62 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6017105.8284599995 | 2094967.47212 | 37.7333412272151 | -122.383224950289 | (37.7333412272151, -122.383224950289) | |||
15842 | 15842 | 97227 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 15x200 | 6016638.64484 | 2094938.128 | 37.733234825728296 | -122.384838105605 | (37.7332348257283, -122.384838105605) | |||
15924 | 15924 | 122795 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 241 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014055.37556 | 2105891.1297 | 37.7631662338691 | -122.39453593861 | (37.7631662338691, -122.39453593861) | |||
15970 | 15970 | 104641 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 112 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x2.5 | 6009525.15876 | 2111682.0778200002 | 37.7788139428406 | -122.410613470452 | (37.7788139428406, -122.410613470452) | |||
15979 | 15979 | 6431 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100X Evans Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6018097.17297 | 2096735.7519999999 | 37.738251307945596 | -122.379920384224 | (37.7382513079456, -122.379920384224) | |||
16079 | 16079 | 19828 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY25 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
16094 | 16094 | 20027 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
16107 | 16107 | 97223 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016661.55982 | 2094959.63165 | 37.733295137843 | -122.384760378985 | (37.733295137843, -122.384760378985) | ||
16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
16182 | 16182 | 6428 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100X Evans Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/29/1990 12:00:00 AM | 6 | 3x3 | 6018145.74781 | 2096700.42192 | 37.7381569780515 | -122.379749980697 | (37.7381569780515, -122.379749980697) | ||
16240 | 16240 | 97228 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15x200 | 6016642.6726 | 2094934.5266099998 | 37.733225159799204 | -122.384823929606 | (37.7332251597992, -122.384823929606) | |||
16247 | 16247 | 8259 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1555 Galvez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2004 12:00:00 AM | 20 | 3x3 | 6015926.8812 | 2097574.6055 | 37.740434666717604 | -122.387482752719 | (37.7404346667176, -122.387482752719) | ||
16309 | 16309 | 6731 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6017098.09908 | 2097131.4743700002 | 37.7392827179327 | -122.38340226151699 | (37.7392827179327, -122.383402261517) | ||
16323 | 16323 | 6708 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6017556.67213 | 2096791.48157 | 37.738374498884795 | -122.38179306321899 | (37.7383744988848, -122.381793063219) | |||
16363 | 16363 | 6635 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1499 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2016 08:50:00 AM | 3 | 3X3 | 6016265.445719999 | 2098016.2601900003 | 37.741666106596796 | -122.38634290341801 | (37.7416661065968, -122.386342903418) | ||
16369 | 16369 | 6732 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x3 | 6017081.22678 | 2097144.85805 | 37.7393185343335 | -122.383461530425 | (37.7393185343335, -122.383461530425) | |||
16402 | 16402 | 97222 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301X Newcomb Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15x200 | 6016676.72369 | 2094975.37763 | 37.733339211818105 | -122.38470904929702 | (37.7333392118181, -122.384709049297) | |||
16515 | 16515 | 6599 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Evans Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016599.42357 | 2097883.1094299997 | 37.7413189826895 | -122.38517883355 | (37.7413189826895, -122.38517883355) | |||
16537 | 16537 | 24220 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 52 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017233.65569 | 2094997.2718200001 | 37.7334301143948 | -122.38278508468001 | (37.7334301143948, -122.38278508468) | |||
16543 | 16543 | 15277 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1563X Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.560819999 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | |
16621 | 16621 | 6600 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Evans Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 18 | 3X3 | 6016583.15277 | 2097897.02108 | 37.741356281158204 | -122.385236061921 | (37.7413562811582, -122.385236061921) | ||
16697 | 16697 | 6429 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1100X Evans Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6018128.86285 | 2096712.12629 | 37.738188184545706 | -122.37980917407499 | (37.7381881845457, -122.379809174075) | |||
16744 | 16744 | 6812 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016477.270719999 | 2097595.73141 | 37.740523142935096 | -122.385581175844 | (37.7405231429351, -122.385581175844) | ||
16846 | 16846 | 20022 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 STAIRWAY48 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10ST | ||||||||
16919 | 16919 | 10368 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1190 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6000449.8535 | 2108924.1608 | 37.770728415806495 | -122.441810447284 | (37.7707284158065, -122.441810447284) | |||
16932 | 16932 | 5429 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 465 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 6004961.54975 | 2105631.51156 | 37.7619436334085 | -122.42596997713001 | (37.7619436334085, -122.42596997713) | |||
17143 | 17143 | 10434 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1457 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999128.9575 | 2108690.2041 | 37.7700106766776 | -122.44636259863998 | (37.7700106766776, -122.44636259864) | |||
17176 | 17176 | 5399 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 347 Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6004915.02967 | 2106451.3331299997 | 37.764192039253004 | -122.426189239948 | (37.764192039253, -122.426189239948) | |||
17186 | 17186 | 1368 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 33 Amethyst Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | Permit Number 776000 | 5999092.87122 | 2100014.72745 | 37.746187905058896 | -122.445863385507 | (37.7461879050589, -122.445863385507) | ||
17243 | 17243 | 9406 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 479 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6001730.266559999 | 2097665.12438 | 37.7398866873164 | -122.436575468878 | (37.7398866873164, -122.436575468878) | |||
17264 | 17264 | 6948 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 583 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6004650.95912 | 2110501.8456200003 | 37.77529883829679 | -122.42739115328399 | (37.7752988382968, -122.427391153284) | |||
17349 | 17349 | 10372 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1216 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6000283.8166 | 2108900.9156 | 37.7706551281266 | -122.442383101019 | (37.7706551281266, -122.442383101019) | |||
17350 | 17350 | 4171 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3795 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005278.26135 | 2100471.01085 | 37.7477919952017 | -122.42450750861099 | (37.7477919952017, -122.424507508611) | |||
17430 | 17430 | 5647 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005148.44163 | 2100733.93457 | 37.7485065911205 | -122.42497512280899 | (37.7485065911205, -122.424975122809) | |||
17458 | 17458 | 10319 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 739 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6002579.70252 | 2109173.84871 | 37.7715351260824 | -122.434461126791 | (37.7715351260824, -122.434461126791) | |||
17534 | 17534 | 5492 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 719 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 8 | 6005040.753830001 | 2104151.1903 | 37.7578834965409 | -122.425590680889 | (37.7578834965409, -122.425590680889) | |||
17561 | 17561 | 22565 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 231 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6001358.74635 | 2097645.7360799997 | 37.7398123322633 | -122.437858639569 | (37.7398123322633, -122.437858639569) | |||
17718 | 17718 | 7052 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1377 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6000944.252669999 | 2109982.65619 | 37.7736629373134 | -122.440176232956 | (37.7736629373134, -122.440176232956) | |||
17865 | 17865 | 99661 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1365 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.46532315146601 | (37.7394617231066, -122.465323151466) | |||||
17884 | 17884 | 16529 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1420X Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.741239457182104 | -122.38500415558701 | (37.7412394571821, -122.385004155587) | |||
17892 | 17892 | 6864 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 131 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006755.38635 | 2110787.16515 | 37.7762010525614 | -122.420131694419 | (37.7762010525614, -122.420131694419) | |||
17936 | 17936 | 10282 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 359 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6004422.78828 | 2109427.83457 | 37.772336958917606 | -122.428103893873 | (37.7723369589176, -122.428103893873) | |||
17952 | 17952 | 22564 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 225 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6001403.30325 | 2097649.91071 | 37.7398263284251 | -122.437704879797 | (37.7398263284251, -122.437704879797) | |||
17953 | 17953 | 5410 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 400 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X6 | 6004853.94973 | 2105972.8018799997 | 37.762874653875606 | -122.426366424394 | (37.7628746538756, -122.426366424394) | |||
17963 | 17963 | 9405 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 473 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6001706.5922 | 2097649.68492 | 37.7398429487944 | -122.43665621990499 | (37.7398429487944, -122.436656219905) | |||
17967 | 17967 | 10306 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 618- 620 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 33 | 7x5 | 6003056.4779 | 2109285.6248 | 37.771869088105795 | -122.432819922419 | (37.7718690881058, -122.432819922419) | |||
18058 | 18058 | 6968 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 731 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003908.8718 | 2110395.3427 | 37.7749644092731 | -122.429950604798 | (37.7749644092731, -122.429950604798) | |||
18111 | 18111 | 4885 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 639X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 4X4 | 6005014.011 | 2104638.98178 | 37.7592213459953 | -122.42571788726299 | (37.7592213459953, -122.425717887263) | |||
18151 | 18151 | 124716 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2195 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
18154 | 18154 | 111228 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1113 SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001842.0 | 2112262.0 | 37.779972512780105 | -122.4372340286 | (37.7799725127801, -122.4372340286) | ||||
18193 | 18193 | 39379 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1354 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40920 | 6007143.93712268 | 2107602.08417603 | 37.7674774616365 | -122.41856167807501 | (37.7674774616365, -122.418561678075) | |||
18211 | 18211 | 11709 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 700X Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.83406 | 2092750.4086799999 | 37.7257930014245 | -122.472332875878 | (37.7257930014245, -122.472332875878) | ||
18289 | 18289 | 5540 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 900X Dolores St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005033.64005 | 2102782.9896400003 | 37.7541263358861 | -122.425517912248 | (37.7541263358861, -122.425517912248) | |||
18400 | 18400 | 18871 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2269 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003913.28197 | 2115924.59754 | 37.7901466122144 | -122.430329924961 | (37.7901466122144, -122.430329924961) | |||
18464 | 18464 | 5398 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 347 Dolores St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004916.74294 | 2106419.98328 | 37.7641060568743 | -122.426181082194 | (37.7641060568743, -122.426181082194) | |||
18488 | 18488 | 98514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1209 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995023.6 | 2091955.9 | 37.7238271478872 | -122.45935081328001 | (37.7238271478872, -122.45935081328) | ||||
18513 | 18513 | 5608 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1148 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6005093.57807 | 2101711.52687 | 37.7511877345454 | -122.425234393764 | (37.7511877345454, -122.425234393764) | |||
18522 | 18522 | 7034 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1235 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6001440.3818 | 2110052.83399 | 37.7738838611848 | -122.438465078521 | (37.7738838611848, -122.438465078521) | |||
18605 | 18605 | 10373 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1234 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 9x5 | 6000208.6256 | 2108891.1906 | 37.770624139779 | -122.44264248857 | (37.770624139779, -122.44264248857) | |||
18728 | 18728 | 5682 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1484 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6 | 6005200.94841 | 2099724.207 | 37.7457370767019 | -122.42472173431801 | (37.7457370767019, -122.424721734318) | |||
18859 | 18859 | 10484 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1668 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5998167.2674 | 2108607.159 | 37.7697276834376 | -122.449683068712 | (37.7697276834376, -122.449683068712) | |||
18860 | 18860 | 10473 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1632 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 5998321.0771 | 2108628.9487 | 37.7697963108216 | -122.449152617838 | (37.7697963108216, -122.449152617838) | |||
18871 | 18871 | 6952 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 607 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6004430.417 | 2110467.1585 | 37.775191120285605 | -122.42815158682501 | (37.7751911202856, -122.428151586825) | |||
18892 | 18892 | 116488 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2149 LYON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999319.0 | 2116238.0 | 37.7907458271484 | -122.446248274058 | (37.7907458271484, -122.446248274058) | |||||
18902 | 18902 | 2171 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 980X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6001393.407000001 | 2109056.2142 | 37.771144720167705 | -122.43855614944799 | (37.7711447201677, -122.438556149448) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");