trees
1,069 rows where qSpecies_id = 93 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11580 | 247184 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 1 | : | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | 15 | 5 | 11 | 29492 | 9 | |
14684 | 246599 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 5 | : | Tree | Private 2 | 18 | Width 3ft | 6005448.39533 | 2109271.63735 | 37.7719660524162 | -122.42454510839 | (37.7719660524162, -122.42454510839) | 7 | 9 | 11 | 28852 | 10 | |||
18019 | 197518 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 407 09th St | 11 | : | Tree | Private 2 | 12 | Width 3ft | 6009751.84387 | 2109320.33027 | 37.772341843132 | -122.409662531815 | (37.772341843132, -122.409662531815) | 14 | 2 | 9 | 28853 | 34 | |||
19789 | 247187 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 4 | : | Tree | Private 2 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | 15 | 5 | 11 | 29492 | 9 | |||
54587 | 246597 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 3 | : | Tree | Private 2 | 16 | Width 3ft | 6005485.46938 | 2109277.24468 | 37.7719835424264 | -122.42441726525 | (37.7719835424264, -122.42441726525) | 7 | 9 | 11 | 28852 | 10 | |||
54725 | 246598 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 52 Waller St | 4 | : | Tree | Private 2 | 20 | Width 3ft | 6005467.40356 | 2109274.31341 | 37.7719744736758 | -122.424479547814 | (37.7719744736758, -122.424479547814) | 7 | 9 | 11 | 28852 | 10 | |||
65135 | 246583 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Waller St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6005277.33485 | 2109248.26095 | 37.7718922045878 | -122.425135156289 | (37.7718922045878, -122.425135156289) | 7 | 9 | 11 | 28852 | 10 | |||
67223 | 250321 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 247 27th Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5987414.73446 | 2114306.16368 | 37.7847545126541 | -122.487293940769 | (37.7847545126541, -122.487293940769) | 11 | 6 | 1 | 55 | 33 | |||
75678 | 197519 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1055 Natoma St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6007591.22918 | 2109427.92338 | 37.7725159572842 | -122.417143942455 | (37.7725159572842, -122.417143942455) | 8 | 2 | 9 | 28853 | 19 | |||
79502 | 179456 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 39 Melra Ct | 1 | : | Tree | Private 2 | 18 | Width 4ft | 6008986.48136 | 2086460.78308 | 37.7095316094729 | -122.410695358215 | (37.7095316094729, -122.410695358215) | 9 | 7 | 8 | 309 | 39 | |||
83546 | 246591 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 22 Waller St | 2 | : | Tree | Private 2 | 20 | Width 3ft | 6005592.78222 | 2109289.94448 | 37.7720244723693 | -122.424046964897 | (37.7720244723693, -122.424046964897) | 7 | 9 | 11 | 28852 | 10 | |||
84700 | 197537 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 266 Bridgeview Dr | 1 | : | Tree | Private 2 | 10 | Width 2ft | 6012934.68235 | 2095259.36475 | 37.7339113173389 | -122.397666323936 | (37.7339113173389, -122.397666323936) | 10 | 3 | 8 | 58 | 1 | |||
85114 | 247185 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 2 | : | Tree | Private 2 | 13 | Width 4ft | 6000997.16935 | 2108899.56704 | 37.7706920584128 | -122.439915513203 | (37.7706920584128, -122.439915513203) | 15 | 5 | 11 | 29492 | 9 | |||
98734 | 246592 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 22 Waller St | 3 | : | Tree | Private 2 | 20 | Width 3ft | 6005574.15853 | 2109287.40717 | 37.7720164540359 | -122.42411120528 | (37.7720164540359, -122.42411120528) | 7 | 9 | 11 | 28852 | 10 | |||
106107 | 197517 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 407 09th St | 10 | : | Tree | Private 2 | 9 | Width 3ft | 6009758.68055 | 2109312.44793 | 37.7723205831618 | -122.40963832656 | (37.7723205831618, -122.40963832656) | 14 | 2 | 9 | 28853 | 34 | |||
143552 | 197507 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1275 Harrison St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6009714.36956 | 2109423.21347 | 37.7726222364622 | -122.409799423029 | (37.7726222364622, -122.409799423029) | 14 | 2 | 9 | 28853 | 34 | |||
171268 | 246423 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 406 Duncan St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6003794.9997 | 2099851.12644 | 37.7460060612246 | -122.429592349221 | (37.7460060612246, -122.429592349221) | 2 | 7 | 5 | 63 | 22 | |||
177543 | 247186 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1 Buena Vista Ave East | 3 | : | Tree | Private 2 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.7707008151093 | -122.439956869431 | (37.7707008151093, -122.439956869431) | 15 | 5 | 11 | 29492 | 9 | ||
181408 | 197520 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 98 Lafayette St | 5 | : | Tree | Private 2 | 22 | Width 3ft | 6007717.24028 | 2109472.44967 | 37.7726453040621 | -122.416711211162 | (37.7726453040621, -122.416711211162) | 8 | 2 | 9 | 28853 | 19 | |||
187698 | 250320 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 255 27th Ave | 1 | : | Tree | Private 2 | 11 | Width 3ft | 5987417.56987 | 2114243.02711 | 37.7845813230239 | -122.487279492276 | (37.7845813230239, -122.487279492276) | 11 | 6 | 1 | 55 | 33 | |||
1613 | 112905 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500 Bancroft Ave | 1 | Front Yard : Yard | Tree | DPW 1 | 25 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||
12244 | 261985 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500x Bancroft Ave | Front Yard : Yard | Tree | Private 2 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||||
17604 | 261710 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3555 16th St | 1 | Front Yard : Yard | Tree | Public Library 12 | 8x8 | 6003221.95473 | 2106496.25325 | 37.7642195378276 | -122.432048304209 | (37.7642195378276, -122.432048304209) | 15 | 4 | 5 | 28862 | 3 | ||||
22628 | 101981 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
39481 | 101978 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6006502 | 2099737 | 37.7458455996049 | -122.420223786963 | (37.7458455996049, -122.420223786963) | 2 | 7 | 7 | 28859 | 2 | ||||
152685 | 101980 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
170620 | 101979 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
58886 | 807 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 600X 39th Ave | 5 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983808.20604 | 2111664.13118 | 37.7772892893219 | -122.499575815745 | (37.7772892893219, -122.499575815745) | 11 | 6 | 2 | 55 | 26 | |||
88591 | 239685 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1601x Alabama St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6009289.0171 | 2100045.3572 | 37.7468489265392 | -122.410608407252 | (37.7468489265392, -122.410608407252) | 2 | 7 | 7 | 28859 | 2 | |||
131494 | 24342 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 600X 39th Ave | 14 | Median : Cutout | Tree | DPW 1 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
158163 | 803 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 680X 39th Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983825.76498 | 2111129.60729 | 37.7758226717015 | -122.499475562851 | (37.7758226717015, -122.499475562851) | 11 | 6 | 2 | 55 | 26 | |||
162517 | 104734 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 5490x 03RD ST | 1 | Median : Cutout | Tree | DPW 1 | 40 | 9x9 | 6014203 | 2093127 | 37.7281268221954 | -122.393132175736 | (37.7281268221954, -122.393132175736) | 10 | 3 | 8 | 58 | 1 | |||
164587 | 117839 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 600x 39th Ave | 3 | Median : Cutout | Tree | DPW 1 | 15 | Width 6ft | 5983810.52385 | 2111649.02031 | 37.7772479352498 | -122.499566680778 | (37.7772479352498, -122.499566680778) | 11 | 6 | 2 | 55 | 26 | |||
177148 | 22364 | Landmark tree 11 | Schinus terebinthifolius :: Brazilian Pepper 93 | 5490X 03rd St | 1 | Median : Cutout | Tree | DPW 1 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | 10 | 3 | 8 | 58 | 1 | |||
178216 | 814 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 600X 39th Ave | 12 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | 11 | 6 | 2 | 55 | 26 | |||
192936 | 805 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 680X 39th Ave | 3 | Median : Cutout | Tree | DPW 1 | 6 | 6-HOA | 5983823.96426 | 2111160.91126 | 37.7759085177004 | -122.499484105844 | (37.7759085177004, -122.499484105844) | 11 | 6 | 2 | 55 | 26 | |||
13099 | 197577 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 299x Cashmere St | 5 | Median : Yard | Tree | DPW 1 | 33 | 6016820.77887 | 2095888.49241 | 37.735854408739 | -122.38427457691 | (37.735854408739, -122.38427457691) | 10 | 3 | 8 | 58 | 1 | ||||
123512 | 247576 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 350x Alemany Blvd | 1 | Median : Yard | Tree | DPW 1 | 25 | 6008435.75806 | 2095170.56175 | 37.733415932988 | -122.413214248635 | (37.733415932988, -122.413214248635) | 9 | 7 | 7 | 28859 | 2 | ||||
132594 | 247579 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 300x Alemany Blvd | 3 | Median : Yard | Tree | DPW 1 | 30 | 6008670.31016 | 2095309.15662 | 37.7338096498957 | -122.412413126286 | (37.7338096498957, -122.412413126286) | 9 | 7 | 7 | 28859 | 2 | ||||
146370 | 105020 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101X ORD ST | 1 | Median : Yard | Tree | DPW 1 | 12 | 6000863 | 2105739 | 37.7620062865301 | -122.440152928616 | (37.7620062865301, -122.440152928616) | 15 | 5 | 5 | 28862 | 3 | ||||
156854 | 197578 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 299x Cashmere St | 6 | Median : Yard | Tree | DPW 1 | 7 | 6016803.94707 | 2095896.67464 | 37.7358759448203 | -122.384333341329 | (37.7358759448203, -122.384333341329) | 10 | 3 | 8 | 58 | 1 | ||||
69528 | 253807 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2 Garfield St | 1 | Side Yard : Yard | Tree | Private 2 | 10x2 | Permit Number 780744 | 5993976 | 2090624 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | 9 | 8 | 6 | 64 | 24 | |||
335 | 102831 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Lansing St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6014531.5 | 2114230.8 | 37.7860915609161 | -122.393472847757 | (37.7860915609161, -122.393472847757) | 6 | 2 | 9 | 28855 | 6 | |||
883 | 240584 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 141 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000210.52128 | 2106191.60222 | 37.7632118519771 | -122.442442087458 | (37.7632118519771, -122.442442087458) | 15 | 5 | 5 | 28862 | 3 | |||
1337 | 27411 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 2198 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5996975.1116 | 2109480.4382 | 37.7720572057802 | -122.453869751853 | (37.7720572057802, -122.453869751853) | 15 | 5 | 11 | 29492 | 16 | ||
2386 | 19745 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 STAIRWAY15 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
3578 | 261993 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
3780 | 14742 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004772.182 | 2111961.3352 | 37.7793130940377 | -122.427075791541 | (37.7793130940377, -122.427075791541) | 7 | 9 | 11 | 29490 | 41 | |||
3871 | 260928 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 293 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5999961.28455 | 2099340.35663 | 37.7443857918882 | -122.442812113441 | (37.7443857918882, -122.442812113441) | 2 | 7 | 5 | 63 | 22 | |||||
4000 | 79751 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 15 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 5991685.90264393 | 2095891.27109779 | 37.7344402285305 | -122.471175151585 | (37.7344402285305, -122.471175151585) | 9 | 8 | 4 | 59 | 40 | ||||
4235 | 215001 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995907.45606 | 2090967.94562 | 37.7211652376617 | -122.45622408897 | (37.7211652376617, -122.45622408897) | 9 | 8 | 6 | 28861 | 24 | |||
4246 | 67958 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 719 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 11 | Permit Number 31678 | 5987220.95005 | 2111007.3016 | 37.7756854718616 | -122.48772192034 | (37.7756854718616, -122.48772192034) | 11 | 6 | 2 | 55 | 26 | |
4554 | 74167 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1801 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6000438.3175 | 2111300.5273 | 37.7772526604879 | -122.442020948646 | (37.7772526604879, -122.442020948646) | 15 | 5 | 11 | 29492 | 16 | |||
4683 | 62258 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 49 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | Permit Number 22384 | 6001321.62543581 | 2093848.87962555 | 37.7293849331116 | -122.437715130621 | (37.7293849331116, -122.437715130621) | 9 | 7 | 6 | 28861 | 25 | ||
5222 | 240527 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 201 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 5ft | 5997609 | 2105896 | 37.7622515762528 | -122.451418517771 | (37.7622515762528, -122.451418517771) | 15 | 5 | 11 | 29492 | 9 | |||
5632 | 75772 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3701 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5984063.00264 | 2111035.7891 | 37.7755789903575 | -122.498647978226 | (37.7755789903575, -122.498647978226) | 11 | 6 | 2 | 55 | 26 | |||
5678 | 214198 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 165 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994046.02682 | 2093769.86979 | 37.7287516135932 | -122.462861635163 | (37.7287516135932, -122.462861635163) | 9 | 8 | 4 | 59 | 40 | |||
6032 | 50628 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1198 Gilman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
6230 | 262036 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
6553 | 75600 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 38th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5984118.61972 | 2110981.94357 | 37.7754344077107 | -122.498451610106 | (37.7754344077107, -122.498451610106) | 11 | 6 | 2 | 55 | 26 | |||
6859 | 246229 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5999439.8115 | 2107740.3807 | 37.7674204502126 | -122.44521906453 | (37.7674204502126, -122.44521906453) | 15 | 5 | 11 | 29492 | 9 | |||
6864 | 214183 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 347 Santa Ana Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5992610.48002 | 2094547.79644 | 37.7308048179917 | -122.467880927762 | (37.7308048179917, -122.467880927762) | 9 | 8 | 4 | 59 | 40 | |||
6965 | 240534 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3250 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2020 12:00:00 AM | 3 | Width 3ft | 6006614.52941 | 2103803.76084 | 37.7570183352315 | -122.420123238094 | (37.7570183352315, -122.420123238094) | 2 | 4 | 7 | 28859 | 19 | ||
7076 | 215009 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 220 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 5992622.02484 | 2095272.12308 | 37.7327943054026 | -122.467893679258 | (37.7327943054026, -122.467893679258) | 9 | 8 | 4 | 59 | 40 | |||
7213 | 62827 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1835 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1986 12:00:00 AM | Permit Number 23192 | 6000500.63320764 | 2093420.59763273 | 37.7281622534397 | -122.44052266477 | (37.7281622534397, -122.44052266477) | 9 | 7 | 6 | 28861 | 25 | ||
7377 | 14771 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1000X McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | Office of Mayor 9 | 18 | 4x4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | 7 | 9 | 11 | 29490 | 41 | |||
7442 | 240565 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 131 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000404.48259 | 2104877.48466 | 37.7596146626978 | -122.441676928051 | (37.7596146626978, -122.441676928051) | 2 | 4 | 5 | 28862 | 3 | |||
7491 | 70152 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 231 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5993349.44748 | 2113931.04039 | 37.7840688184898 | -122.466734683653 | (37.7840688184898, -122.466734683653) | 11 | 6 | 2 | 54 | 11 | |||
7566 | 264756 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 176 Hahn St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
7605 | 240540 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 72 28th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6005500 | 2099675 | 37.7456188511036 | -122.423684158346 | (37.7456188511036, -122.423684158346) | 2 | 7 | 5 | 28859 | 22 | |||
7621 | 239705 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 4922 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 5997802.28625 | 2105653.55065 | 37.7615969375718 | -122.450732535394 | (37.7615969375718, -122.450732535394) | 15 | 5 | 11 | 29492 | 9 | |||
8180 | 197538 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 33 Guy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6014309.72341 | 2114400.37585 | 37.7865448523989 | -122.39425201814 | (37.7865448523989, -122.39425201814) | 6 | 2 | 9 | 28855 | 6 | |||
8307 | 141930 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1050 MCALLISTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004152.017 | 2111873.3634 | 37.7790364568014 | -122.429214926277 | (37.7790364568014, -122.429214926277) | 7 | 9 | 11 | 29490 | 41 | |||
8379 | 114770 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | 15 | 5 | 11 | 29492 | 9 | ||||
8923 | 81053 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 735 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6002545.69492 | 2089214.07107 | 37.7167283109449 | -122.433152384794 | (37.7167283109449, -122.433152384794) | 9 | 7 | 6 | 28861 | 5 | |||
9502 | 65156 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 832 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 27135 | 6001006.03746235 | 2102623.98500372 | 37.7534613558838 | -122.439434917257 | (37.7534613558838, -122.439434917257) | 2 | 4 | 5 | 28862 | 22 | ||
9615 | 70386 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1536 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6000423.3259 | 2110656.0694 | 37.7754822883832 | -122.442026539723 | (37.7754822883832, -122.442026539723) | 15 | 5 | 11 | 29492 | 16 | |||
10054 | 63509 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1805 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/1987 12:00:00 AM | 8 | 3x3 | Permit Number 24115 | 6000922.9965 | 2111712.7723 | 37.7784121888349 | -122.440373864948 | (37.7784121888349, -122.440373864948) | 15 | 5 | 11 | 29490 | 41 |
10308 | 141912 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 900 MCALLISTER ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6004447.1952 | 2111915.047 | 37.7791676154415 | -122.42819675688 | (37.7791676154415, -122.42819675688) | 7 | 9 | 11 | 29490 | 41 | |||
10659 | 136418 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 377 Drumm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6013527.00347 | 2118227.13229 | 37.797008690162 | -122.397228498003 | (37.797008690162, -122.397228498003) | 3 | 1 | 10 | 28860 | 6 | |||
10705 | 72398 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 791 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5990047.51543 | 2110000.36847 | 37.7730851702984 | -122.477870609559 | (37.7730851702984, -122.477870609559) | 11 | 6 | 2 | 55 | 26 | |||
11016 | 53933 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 144 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 17 | Permit Number 9647 | 5993062.86441 | 2114500.7791 | 37.7856166217584 | -122.467767599839 | (37.7856166217584, -122.467767599839) | 11 | 6 | 2 | 54 | 11 | ||
11203 | 239713 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 293 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x6 | 5999986 | 2099353 | 37.7444219165503 | -122.442727560507 | (37.7444219165503, -122.442727560507) | 2 | 7 | 5 | 63 | 22 | |||
11220 | 239703 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1048 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5998155.79673 | 2106630.88901 | 37.7643006917393 | -122.449580319477 | (37.7643006917393, -122.449580319477) | 15 | 5 | 11 | 29492 | 9 | |||
11285 | 239736 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1449 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003357 | 2099848 | 37.7459726666437 | -122.431106669912 | (37.7459726666437, -122.431106669912) | 2 | 7 | 5 | 63 | 22 | |||
11444 | 261994 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1557x Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014548 | 2092008 | 37.7250734320456 | -122.391861276019 | (37.7250734320456, -122.391861276019) | 10 | 3 | 8 | 58 | 1 | ||||
12227 | 33648 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 530 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37739 | 6004854.0578934 | 2110753.28886702 | 37.7760007246145 | -122.426706497307 | (37.7760007246145, -122.426706497307) | 7 | 9 | 11 | 28852 | 10 | |||
12797 | 62238 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 100 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | 21 | Permit Number 22364 | 6001428.6005 | 2093653.63751 | 37.7288549250112 | -122.437331333801 | (37.7288549250112, -122.437331333801) | 9 | 7 | 6 | 28861 | 25 | |
13044 | 197544 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 101 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6011744.68904 | 2107088.20402 | 37.766324401967 | -122.402612061007 | (37.766324401967, -122.402612061007) | 8 | 2 | 8 | 28853 | 20 | |||
13703 | 40148 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 580X Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642 | 2110547 | 37.7754223144781 | -122.427425362403 | (37.7754223144781, -122.427425362403) | 7 | 9 | 11 | 28852 | 10 | |
14424 | 46330 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 548 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2002 12:00:00 AM | 11 | Permit Number 44580 | 5996909.4172 | 2109622.8664 | 37.7724445099575 | -122.454107281383 | (37.7724445099575, -122.454107281383) | 15 | 5 | 11 | 29492 | 16 | ||
14668 | 75472 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 38th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5984118.82642 | 2110932.36992 | 37.7752983048778 | -122.498447232603 | (37.7752983048778, -122.498447232603) | 11 | 6 | 2 | 55 | 26 | |||
14741 | 33010 | Permitted Site 7 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3622 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42195 | 6005636.60974519 | 2102002.04320044 | 37.7520160884207 | -122.423377179853 | (37.7520160884207, -122.423377179853) | 2 | 4 | 5 | 28859 | 19 | ||
14944 | 75719 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3701 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5984076.35537 | 2111035.6681 | 37.7755794412237 | -122.498601779667 | (37.7755794412237, -122.498601779667) | 11 | 6 | 2 | 55 | 26 | |||
14953 | 239697 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 155 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5997911.0613 | 2106175.96002 | 37.763037567858 | -122.450393989214 | (37.763037567858, -122.450393989214) | 15 | 5 | 11 | 29492 | 9 | |||
15213 | 78534 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 240 Wayland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6010805.45879 | 2092437.25464 | 37.7260435984308 | -122.404829115572 | (37.7260435984308, -122.404829115572) | 10 | 3 | 7 | 309 | 28 | |||
15470 | 105248 | Undocumented 4 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1301 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x5 | 5998246 | 2105821 | 37.7620821004846 | -122.44920998149 | (37.7620821004846, -122.44920998149) | 15 | 5 | 11 | 29492 | 9 | |||
15630 | 75661 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 38th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5984119.5345 | 2111005.02849 | 37.7754978458904 | -122.498450151227 | (37.7754978458904, -122.498450151227) | 11 | 6 | 2 | 55 | 26 | |||
16140 | 75536 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 701 38th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5984118.85326 | 2110953.37322 | 37.7753559754601 | -122.498448691476 | (37.7753559754601, -122.498448691476) | 11 | 6 | 2 | 55 | 26 | |||
16168 | 4153 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3721-3721 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/31/1989 12:00:00 AM | 6 | 3X3 | 6005701.8016 | 2100493.99134 | 37.7478790037267 | -122.423044558975 | (37.7478790037267, -122.423044558975) | 2 | 4 | 5 | 28859 | 22 |
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) );