trees
3,965 rows where qSpecies_id = 70 sorted by qCaretaker_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29531 | 11850 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1401X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3 | 5991539.129622 | 2088082.4465587 | 37.7129906371476 | -122.471113878415 | (37.7129906371476, -122.471113878415) | 9 | 8 | 6 | 64 | 24 | |||
29769 | 200551 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 27 | Median : Cutout | Tree | DPW 1 | 15 | Width 0ft | 6016216.4893 | 2095621.6927 | 37.735088399287 | -122.38634526793 | (37.735088399287, -122.38634526793) | 10 | 3 | 8 | 58 | 1 | |||
30379 | 776 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3 | 5984705.3515 | 2104090.9487 | 37.7565480706746 | -122.495913536759 | (37.7565480706746, -122.495913536759) | 1 | 8 | 3 | 56 | 35 | |||
30838 | 188697 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 13 | : | Tree | DPW 1 | 15 | Width 3ft | 6017236.81305 | 2097292.98379 | 37.7397338556296 | -122.38293388291 | (37.7397338556296, -122.38293388291) | 10 | 3 | 8 | 58 | 1 | |||
31001 | 7099 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2014 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5997756.52197 | 2109651.70129 | 37.7725722204698 | -122.451179157902 | (37.7725722204698, -122.451179157902) | 15 | 5 | 11 | 29492 | 16 | |||
31144 | 187736 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301x Cashmere St | 2 | Median : Yard | Tree | DPW 1 | 15 | 6016350.44721 | 2096194.42304 | 37.7366684157019 | -122.385922032401 | (37.7366684157019, -122.385922032401) | 10 | 3 | 8 | 58 | 1 | ||||
31259 | 187699 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Executive Park Blvd | 8 | Median : Yard | Tree | DPW 1 | 24 | Width 8ft | 6014113.89856 | 2087000.13929 | 37.7112987269205 | -122.393011704639 | (37.7112987269205, -122.393011704639) | 10 | 3 | 8 | 58 | 1 | |||
31394 | 21123 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2203X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5985013.3358538 | 2100217.4790898 | 37.745930619038 | -122.494562890162 | (37.745930619038, -122.494562890162) | 1 | 8 | 3 | 29491 | 35 | |||
31574 | 125219 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2269 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | Width 4ft | 6003923.5815 | 2115960.33762 | 37.7902453288032 | -122.430296840347 | (37.7902453288032, -122.430296840347) | 13 | 9 | 1 | 29490 | 27 | |||
31604 | 7098 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2006 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5997799.556 | 2109595.5069 | 37.7724203889623 | -122.451026246506 | (37.7724203889623, -122.451026246506) | 15 | 5 | 11 | 29492 | 16 | |||
31758 | 6976 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 745X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003866.69137 | 2110390.66671 | 37.774949181297 | -122.430096182274 | (37.774949181297, -122.430096182274) | 7 | 9 | 11 | 29492 | 10 | |||
32143 | 5498 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 751 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/1995 12:00:00 AM | 24 | 5 | 6005034.1575842 | 2103994.6658118 | 37.7574533443492 | -122.425602353582 | (37.7574533443492, -122.425602353582) | 2 | 4 | 5 | 28859 | 19 | ||
32259 | 22143 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | |||
32301 | 5647 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005148.44163 | 2100733.93457 | 37.7485065911205 | -122.424975122809 | (37.7485065911205, -122.424975122809) | 2 | 4 | 5 | 63 | 22 | |||
32513 | 187739 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 301x Cashmere St | 18 | Median : Yard | Tree | DPW 1 | 26 | 6016069.71075 | 2096081.97327 | 37.736344111196 | -122.386884828594 | (37.736344111196, -122.386884828594) | 10 | 3 | 8 | 58 | 1 | ||||
32807 | 175020 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500x Mansell St | 11 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6010396.84323 | 2090323.76583 | 37.7202175482911 | -122.406092851014 | (37.7202175482911, -122.406092851014) | 10 | 3 | 8 | 309 | 28 | |||
32815 | 253627 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 5991061 | 2093828 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | 9 | 8 | 4 | 64 | 40 | ||||
33047 | 22138 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016046.66974 | 2099009.45744 | 37.7443811102106 | -122.387168624728 | (37.7443811102106, -122.387168624728) | 10 | 3 | 8 | 58 | 1 | |||
33120 | 12727 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 5990457.1993 | 2114785.86556 | 37.7862485896694 | -122.476803188002 | (37.7862485896694, -122.476803188002) | 11 | 6 | 1 | 55 | 33 | |||
33190 | 7922 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1295X Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 4x6 | 6005919.56037 | 2114492.67616 | 37.786328349346 | -122.423286518029 | (37.786328349346, -122.423286518029) | 13 | 9 | 1 | 28858 | 41 | |||
33296 | 24143 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016705.20951 | 2095147.06572 | 37.7338122084672 | -122.38462252012 | (37.7338122084672, -122.38462252012) | 10 | 3 | 8 | 58 | 1 | |||
33615 | 188702 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Evans Ave | 2 | : | Tree | DPW 1 | 17 | Width 4ft | 6015994.71985 | 2098219.31717 | 37.7422086702947 | -122.387293152263 | (37.7422086702947, -122.387293152263) | 10 | 3 | 8 | 58 | 1 | |||
34145 | 23560 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2909 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005511.81289 | 2120357.28421 | 37.8024080624664 | -122.425114661564 | (37.8024080624664, -122.425114661564) | 13 | 9 | 1 | 28858 | 17 | |||
34524 | 9420 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4X4 | 6005985.41292 | 2112474.48884 | 37.7807906194317 | -122.422915195091 | (37.7807906194317, -122.422915195091) | 7 | 9 | 11 | 28852 | 41 | |||
34893 | 200562 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 38 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016315.2256 | 2095489.7997 | 37.7347317124513 | -122.385994706933 | (37.7347317124513, -122.385994706933) | 10 | 3 | 8 | 58 | 1 | |||
35242 | 24203 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
35467 | 24214 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
35953 | 7062 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1550 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000002.1366 | 2109905.8257 | 37.773398298516 | -122.44342962722 | (37.773398298516, -122.44342962722) | 15 | 5 | 11 | 29492 | 16 | |||
36349 | 7041 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1292 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6001235.79159 | 2110088.97469 | 37.7739714548649 | -122.439175378897 | (37.7739714548649, -122.439175378897) | 15 | 5 | 11 | 29492 | 10 | |||
37307 | 1710 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 5 Bass Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016578.92227 | 2095125.73941 | 37.7337466658568 | -122.385057651709 | (37.7337466658568, -122.385057651709) | 10 | 3 | 8 | 58 | 1 | |||
37448 | 10372 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1216 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6000283.8166 | 2108900.9156 | 37.7706551281266 | -122.442383101019 | (37.7706551281266, -122.442383101019) | 15 | 5 | 11 | 29492 | 9 | |||
37495 | 18550 | Landmark tree 11 | Acacia melanoxylon :: Blackwood Acacia 70 | 1700X Quesada Ave | 5 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014656.2717 | 2095062.29209 | 37.733465912826 | -122.391700443637 | (37.733465912826, -122.391700443637) | 10 | 3 | 8 | 58 | 1 | |||
38210 | 9930 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2336 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3X3 | 6005037.50257 | 2117672.21432 | 37.7950087418189 | -122.426564702407 | (37.7950087418189, -122.426564702407) | 13 | 9 | 1 | 28858 | 27 | |||
38337 | 7026 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1138 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3x3 | 6001973.7961 | 2110177.6605 | 37.7742569308448 | -122.436628850709 | (37.7742569308448, -122.436628850709) | 15 | 5 | 11 | 29492 | 10 | |||
38350 | 24195 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
38640 | 20923 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1903X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984941.4072484 | 2102249.5254402 | 37.7515058528251 | -122.494961411572 | (37.7515058528251, -122.494961411572) | 1 | 8 | 3 | 29491 | 35 | |||
38820 | 16539 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420X Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016303.7553 | 2098109.62008 | 37.7419245742859 | -122.38621694766 | (37.7419245742859, -122.38621694766) | 10 | 3 | 8 | 58 | 1 | |||
38846 | 17708 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1195X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002295.810192 | 2112602.928985 | 37.7809344045898 | -122.435688496636 | (37.7809344045898, -122.435688496636) | 15 | 5 | 11 | 29490 | 41 | |||
38953 | 3694 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400X Cargo Way | 1 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6017199.673909 | 2098835.752969 | 37.7439679357533 | -122.383169649574 | (37.7439679357533, -122.383169649574) | 10 | 3 | 8 | 58 | 1 | |||
39400 | 97226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 6 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016643.51258 | 2094941.12769 | 37.7332433315076 | -122.384821485239 | (37.7332433315076, -122.384821485239) | 10 | 3 | 8 | 58 | 1 | ||
39608 | 24202 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x5 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
39710 | 22631 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1188 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004326.62137 | 2112603.43226 | 37.7810509280597 | -122.42866295582 | (37.7810509280597, -122.42866295582) | 7 | 9 | 11 | 29490 | 41 | |||
39780 | 200548 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 24 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016205.9984 | 2095634.3174 | 37.7351224834655 | -122.386382419007 | (37.7351224834655, -122.386382419007) | 10 | 3 | 8 | 58 | 1 | |||
40170 | 24108 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101X Whitney Young Cir | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016610.88324 | 2095264.18914 | 37.7341285890533 | -122.384956794538 | (37.7341285890533, -122.384956794538) | 10 | 3 | 8 | 58 | 1 | |||
40300 | 6598 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016617.02929 | 2097872.24997 | 37.7412901387305 | -122.385117202121 | (37.7412901387305, -122.385117202121) | 10 | 3 | 8 | 58 | 1 | |||
40334 | 22136 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016035.60199 | 2098975.53182 | 37.7442873445309 | -122.387204529113 | (37.7442873445309, -122.387204529113) | 10 | 3 | 8 | 58 | 1 | |||
40440 | 9405 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 473 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6001706.5922 | 2097649.68492 | 37.7398429487944 | -122.436656219905 | (37.7398429487944, -122.436656219905) | 2 | 7 | 5 | 63 | 7 | |||
40581 | 6463 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017761.74901 | 2097023.16401 | 37.7390219747502 | -122.381100103845 | (37.7390219747502, -122.381100103845) | 10 | 3 | 8 | 58 | 1 | |||
40653 | 6493 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 12 | 3x3 | 6017084.24401 | 2097528.90701 | 37.7403732221604 | -122.38347782646 | (37.7403732221604, -122.38347782646) | 10 | 3 | 8 | 58 | 1 | ||
40729 | 7105 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2130 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 5997237.8283 | 2109516.8856 | 37.7721723399981 | -122.452963630149 | (37.7721723399981, -122.452963630149) | 15 | 5 | 11 | 29492 | 16 | |||
40809 | 21052 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2103X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5984987.6230273 | 2100889.8482373 | 37.7477752566644 | -122.494701361992 | (37.7477752566644, -122.494701361992) | 1 | 8 | 3 | 29491 | 35 | ||||
40929 | 10306 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 618- 620 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 33 | 7x5 | 6003056.4779 | 2109285.6248 | 37.7718690881058 | -122.432819922419 | (37.7718690881058, -122.432819922419) | 15 | 5 | 11 | 29492 | 9 | |||
41459 | 6968 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 731 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003908.8718 | 2110395.3427 | 37.7749644092731 | -122.429950604798 | (37.7749644092731, -122.429950604798) | 7 | 9 | 11 | 29492 | 10 | |||
41980 | 22564 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 225 Topaz Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 3X3 | 6001403.30325 | 2097649.91071 | 37.7398263284251 | -122.437704879797 | (37.7398263284251, -122.437704879797) | 2 | 7 | 5 | 63 | 7 | |||
42073 | 10282 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 359 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6004422.78828 | 2109427.83457 | 37.7723369589176 | -122.428103893873 | (37.7723369589176, -122.428103893873) | 7 | 9 | 11 | 28852 | 10 | |||
42304 | 6160 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000X Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006064.53658 | 2113525.24895 | 37.7836802135181 | -122.422716161482 | (37.7836802135181, -122.422716161482) | 7 | 9 | 11 | 28858 | 41 | |||
42571 | 142090 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 600 DIVISADERO ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 6x6 | 6001662.0087 | 2110531.9644 | 37.7752120374121 | -122.437732758226 | (37.7752120374121, -122.437732758226) | 15 | 5 | 11 | 29492 | 10 | |||
42670 | 23505 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2600 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 5x5 | 6005801.9507 | 2119345.52815 | 37.7996464242096 | -122.424038648866 | (37.7996464242096, -122.424038648866) | 13 | 9 | 1 | 28858 | 32 | |||
42712 | 18104 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3047 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5999356.199 | 2114621.5583 | 37.786309626644 | -122.446003255008 | (37.786309626644, -122.446003255008) | 15 | 6 | 1 | 29490 | 31 | |||
42718 | 6479 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Evans Ave | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017436.11701 | 2097265.30001 | 37.7396688516514 | -122.382242842132 | (37.7396688516514, -122.382242842132) | 10 | 3 | 8 | 58 | 1 | |||
43206 | 187735 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 299x Cashmere St | 23 | Median : Yard | Tree | DPW 1 | 21 | 6016637.03713 | 2096003.63788 | 37.7361604138763 | -122.384917870088 | (37.7361604138763, -122.384917870088) | 10 | 3 | 8 | 58 | 1 | ||||
43411 | 6580 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1337 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017048.7081546 | 2097427.5062586 | 37.7400928320588 | -122.383593638958 | (37.7400928320588, -122.383593638958) | 10 | 3 | 8 | 58 | 1 | |||
43462 | 24278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 350X Winding Way | 16 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6000808.42529 | 2086790.57674 | 37.709975233345 | -122.438983668972 | (37.709975233345, -122.438983668972) | 9 | 7 | 6 | 28861 | 5 | |||
43641 | 200538 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 14 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016175.1953 | 2095654.7768 | 37.7351769557335 | -122.386490343499 | (37.7351769557335, -122.386490343499) | 10 | 3 | 8 | 58 | 1 | |||
43886 | 26538 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6008873.5963 | 2121134.1535 | 37.8047304843802 | -122.413536170716 | (37.8047304843802, -122.413536170716) | 3 | 1 | 10 | 308 | 23 | |||
44010 | 8228 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500X Galvez Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6016396.247314 | 2097296.3974116 | 37.7396967491289 | -122.385840466933 | (37.7396967491289, -122.385840466933) | 10 | 3 | 8 | 58 | 1 | |||
44202 | 7104 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2100 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 5997303.9815 | 2109524.8914 | 37.7721981126985 | -122.452735379757 | (37.7721981126985, -122.452735379757) | 15 | 5 | 11 | 29492 | 16 | |||
44638 | 173859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 118 Saint Mary's Ave | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.7352888053199 | -122.42875656067 | (37.7352888053199, -122.42875656067) | 2 | 7 | 5 | 63 | 7 | ||||
44801 | 25393 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1051 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6001007.68114 | 2088741.24323 | 37.7153426652198 | -122.438434668834 | (37.7153426652198, -122.438434668834) | 9 | 7 | 6 | 28861 | 5 | |||
45352 | 29770 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 6x6 | 6008266.3741 | 2121051.4386 | 37.8044692557294 | -122.415631670711 | (37.8044692557294, -122.415631670711) | 5 | 1 | 10 | 308 | 23 | |||
45428 | 443 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700x 23rd Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | 5988815.98803 | 2110428.99683 | 37.7741905124987 | -122.482161976658 | (37.7741905124987, -122.482161976658) | 11 | 6 | 2 | 55 | 26 | ||||
45493 | 200568 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 40 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6016324.0126 | 2095472.2809 | 37.7346840956345 | -122.385963106208 | (37.7346840956345, -122.385963106208) | 10 | 3 | 8 | 58 | 1 | |||
45582 | 7052 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1377 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000944.25267 | 2109982.65619 | 37.7736629373134 | -122.440176232956 | (37.7736629373134, -122.440176232956) | 15 | 5 | 11 | 29492 | 10 | |||
45634 | 4885 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 639X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 4X4 | 6005014.011 | 2104638.98178 | 37.7592213459953 | -122.425717887263 | (37.7592213459953, -122.425717887263) | 2 | 4 | 5 | 28859 | 19 | |||
45839 | 13066 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 604 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2X2 | 6009404.55183 | 2120549.65161 | 37.803155386878 | -122.4116574143 | (37.803155386878, -122.4116574143) | 3 | 1 | 10 | 308 | 23 | |||
45882 | 10255 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 140 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005448.27784 | 2109623.58668 | 37.7729324136912 | -122.424570554491 | (37.7729324136912, -122.424570554491) | 7 | 9 | 11 | 28852 | 10 | |||
46007 | 6753 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1215 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | |||
46415 | 220273 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 500x 27th St | 16 | Median : Cutout | Tree | DPW 1 | 23 | Width 4ft | 6002878.6956 | 2100066.19718 | 37.7465446697031 | -122.432776165093 | (37.7465446697031, -122.432776165093) | 2 | 7 | 5 | 63 | 22 | |||
46630 | 6864 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 131 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006755.38635 | 2110787.16515 | 37.7762010525614 | -122.420131694419 | (37.7762010525614, -122.420131694419) | 7 | 9 | 11 | 28852 | 10 | |||
47002 | 17859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2121 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003647.2236 | 2115215.6899 | 37.7881850576658 | -122.431199843789 | (37.7881850576658, -122.431199843789) | 13 | 9 | 11 | 29490 | 27 | |||
47175 | 24120 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6016647.77235 | 2095170.83896 | 37.7338743084492 | -122.384822755067 | (37.7338743084492, -122.384822755067) | 10 | 3 | 8 | 58 | 1 | |||
47583 | 23589 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3251X Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.425855144407 | (37.8066799978444, -122.425855144407) | 13 | 1 | 1 | 28858 | 17 | |||
47669 | 200540 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 16 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6016179.8101 | 2095650.1621 | 37.7351645401576 | -122.386474066655 | (37.7351645401576, -122.386474066655) | 10 | 3 | 8 | 58 | 1 | |||
47829 | 6263 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1338X Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004383.57489 | 2113288.83653 | 37.7829361010006 | -122.428514794701 | (37.7829361010006, -122.428514794701) | 7 | 9 | 11 | 29490 | 41 | |||
48195 | 24226 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6017135.66368 | 2094974.09134 | 37.7333610509772 | -122.383122261179 | (37.7333610509772, -122.383122261179) | 10 | 3 | 8 | 58 | 1 | |||
48296 | 11709 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700X Junipero Serra Blvd | 26 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.83406 | 2092750.40868 | 37.7257930014245 | -122.472332875878 | (37.7257930014245, -122.472332875878) | 9 | 8 | 4 | 64 | 40 | ||
48525 | 188644 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150x Cargo Way | 4 | Median : Yard | Tree | DPW 1 | 27 | 6018318.49597 | 2097930.97465 | 37.7415453582258 | -122.379238145042 | (37.7415453582258, -122.379238145042) | 10 | 3 | 8 | 58 | 1 | ||||
48793 | 294 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3451X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X2 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | 1 | 8 | 4 | 64 | 14 | |||
49272 | 6597 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016636.56192 | 2097857.72926 | 37.7412513482773 | -122.385048653076 | (37.7412513482773, -122.385048653076) | 10 | 3 | 8 | 58 | 1 | |||
49610 | 6423 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1100X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6018250.03314 | 2096623.41897 | 37.7379512950012 | -122.379384062749 | (37.7379512950012, -122.379384062749) | 10 | 3 | 8 | 58 | 1 | |||
49876 | 6909 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 333 Fell St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005907.98637 | 2110675.1082 | 37.7758455889488 | -122.423055118828 | (37.7758455889488, -122.423055118828) | 7 | 9 | 11 | 28852 | 10 | |||
49929 | 448 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 700x 23rd Ave | 8 | Median : Cutout | Tree | DPW 1 | 3 | 5988818.05287 | 2110350.21953 | 37.7739743319878 | -122.482149061597 | (37.7739743319878, -122.482149061597) | 11 | 6 | 2 | 55 | 26 | ||||
49985 | 22122 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/1992 12:00:00 AM | 12 | 3X3 | 6015918.06732 | 2098587.02802 | 37.743214083448 | -122.387583843416 | (37.743214083448, -122.387583843416) | 10 | 3 | 8 | 58 | 1 | ||
50248 | 6155 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1000X Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005964.03505 | 2113507.44339 | 37.7836256530431 | -122.423062593089 | (37.7836256530431, -122.423062593089) | 7 | 9 | 11 | 28858 | 41 | |||
51108 | 5225 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1034 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001461.1836 | 2111997.0255 | 37.779223304768 | -122.438532449677 | (37.779223304768, -122.438532449677) | 15 | 5 | 11 | 29490 | 41 | |||
51248 | 188655 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 300x Cargo Way | 5 | Median : Yard | Tree | DPW 1 | 22 | 6017659.9469 | 2098420.67777 | 37.7428536469791 | -122.381549254301 | (37.7428536469791, -122.381549254301) | 10 | 3 | 8 | 58 | 1 | ||||
51441 | 17864 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2121 Pine St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003749.9172 | 2115228.4651 | 37.7882259541053 | -122.430845453567 | (37.7882259541053, -122.430845453567) | 13 | 9 | 11 | 29490 | 27 | |||
51613 | 200518 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 1 | Median : Cutout | Tree | DPW 1 | 18 | Width 0ft | 6016087.5147 | 2095748.7503 | 37.7354301338826 | -122.386800041299 | (37.7354301338826, -122.386800041299) | 10 | 3 | 8 | 58 | 1 | |||
51614 | 111552 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900x BOSWORTH ST | 30 | Front Yard : Yard | Tree | DPW 1 | 6 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | ||||
53120 | 3431 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 7050X California St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5985752.92206 | 2113916.9124 | 37.7835886933669 | -122.493014498456 | (37.7835886933669, -122.493014498456) | 11 | 6 | 1 | 55 | 33 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );