Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 176194 | 176194 | 187582 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 747 University St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6008739.08909 | 2090759.6184900003 | 37.7213214463175 | -122.41185395930799 | (37.7213214463175, -122.411853959308) | ||||
| 108210 | 108210 | 122590 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 100 MacOndray Ln | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6008161.0 | 2119143.0 | 37.7992232381339 | -122.415861106147 | (37.7992232381339, -122.415861106147) | |||||
| 47731 | 47731 | 227663 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6 Unnamed 011 | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 10ft | 6002739.4908 | 2096074.90228 | 37.735577602816896 | -122.432972414242 | (37.7355776028169, -122.432972414242) | |||
| 162970 | 162970 | 246778 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 392 Franconia St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 6009934.469769999 | 2098852.71045 | 37.7436103455484 | -122.408292376913 | (37.7436103455484, -122.408292376913) | ||||
| 188401 | 188401 | 207079 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 59 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | 5992173.18035 | 2088300.4585900002 | 37.7136258989769 | -122.46893826428699 | (37.7136258989769, -122.468938264287) | ||||
| 45037 | 45037 | 129425 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003239.07369 | 2117504.42466 | 37.794446200597 | -122.432775535577 | (37.794446200597, -122.432775535577) | |||
| 54446 | 54446 | 129451 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1147 Filbert St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6007395.89235 | 2119499.90916 | 37.80016017810029 | -122.418533970572 | (37.8001601781003, -122.418533970572) | |||
| 55147 | 55147 | 246315 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006857.4528 | 2108984.4305 | 37.7712569245067 | -122.419650681714 | (37.7712569245067, -122.419650681714) | |||
| 56470 | 56470 | 129438 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010041.47641 | 2115755.35321 | 37.790027121797294 | -122.409114812309 | (37.7900271217973, -122.409114812309) | |||
| 65596 | 65596 | 129426 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003248.10705 | 2117506.03033 | 37.7944511216749 | -122.432744393832 | (37.7944511216749, -122.432744393832) | |||
| 132516 | 132516 | 246316 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006848.8767 | 2108962.1326 | 37.7711952166815 | -122.41967876451 | (37.7711952166815, -122.41967876451) | |||
| 146728 | 146728 | 246318 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6006836.8702 | 2108926.9706 | 37.7710979938489 | -122.419717800254 | (37.7710979938489, -122.419717800254) | |||
| 151998 | 151998 | 129437 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010035.0094 | 2115756.1647799998 | 37.790028987884895 | -122.409137245009 | (37.7900289878849, -122.409137245009) | |||
| 162927 | 162927 | 246317 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006842.0158 | 2108939.8347 | 37.771133605468705 | -122.419700914309 | (37.7711336054687, -122.419700914309) | |||
| 163894 | 163894 | 129427 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003257.40294 | 2117505.83832 | 37.794451121666604 | -122.43271221522 | (37.7944511216666, -122.43271221522) | |||
| 171961 | 171961 | 129439 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010043.54378 | 2115756.3306400003 | 37.7900299214 | -122.409107728349 | (37.7900299214, -122.409107728349) | |||
| 173661 | 173661 | 191249 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2300 18th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 10ft | 6010915.57021 | 2105542.63703 | 37.7620342994705 | -122.405370986778 | (37.7620342994705, -122.405370986778) | |||
| 182481 | 182481 | 129436 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010030.57511 | 2115756.25526 | 37.7900289879055 | -122.409152593735 | (37.7900289879055, -122.409152593735) | |||
| 187192 | 187192 | 246314 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6006868.6018 | 2109014.4469 | 37.7713399704187 | -122.419614246796 | (37.7713399704187, -122.419614246796) | |||
| 22918 | 22918 | 191269 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6015147.69888 | 2113724.07494 | 37.7847344271845 | -122.391305511737 | (37.7847344271845, -122.391305511737) | ||||
| 28130 | 28130 | 191253 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 654 Minnesota St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6015148.44265 | 2105367.15882 | 37.7617882296504 | -122.39071873558599 | (37.7617882296504, -122.390718735586) | |||
| 35185 | 35185 | 129454 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007720.06236 | 2120575.53372 | 37.8031318169374 | -122.41748848713002 | (37.8031318169374, -122.41748848713) | |||
| 36009 | 36009 | 186909 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2700 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985192.0104 | 2096702.7177 | 37.7362904860675 | -122.49368611859501 | (37.7362904860675, -122.493686118595) | |||
| 36838 | 36838 | 191250 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 654 Minnesota St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6015147.38841 | 2105382.23529 | 37.7618295678896 | -122.390723435432 | (37.7618295678896, -122.390723435432) | |||
| 43531 | 43531 | 191264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 801 Arkansas St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013055.03201 | 2103799.19748 | 37.7573665842245 | -122.39784906707399 | (37.7573665842245, -122.397849067074) | ||||
| 46474 | 46474 | 129453 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6007720.64474 | 2120576.4205400003 | 37.8031342846895 | -122.417486534671 | (37.8031342846895, -122.417486534671) | |||
| 49285 | 49285 | 129456 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6007719.74229 | 2120576.43903 | 37.803134284681 | -122.41748965894199 | (37.803134284681, -122.417489658942) | |||
| 51023 | 51023 | 185052 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2715 41st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983668.1125 | 2096649.8142 | 37.7360559577629 | -122.498950875232 | (37.7360559577629, -122.498950875232) | |||
| 56239 | 56239 | 191252 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 654 Minnesota St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6015147.22099 | 2105373.94992 | 37.761806808764796 | -122.390723435452 | (37.7618068087648, -122.390723435452) | |||
| 57630 | 57630 | 191251 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 654 Minnesota St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6015148.84129 | 2105378.48456 | 37.7618193498029 | -122.39071814833599 | (37.7618193498029, -122.390718148336) | |||
| 61708 | 61708 | 227660 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 195 Beacon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6003113.10037 | 2097586.0775 | 37.73974812787179 | -122.43178856828101 | (37.7397481278718, -122.431788568281) | |||
| 62772 | 62772 | 185051 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2715 41st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983667.0512 | 2096660.9577 | 37.736086492552 | -122.49895536756901 | (37.736086492552, -122.498955367569) | |||
| 62886 | 62886 | 227610 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 400 Prospect Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6006250.04952 | 2097648.9456700003 | 37.7400980729811 | -122.420946773391 | (37.7400980729811, -122.420946773391) | ||||
| 65391 | 65391 | 129455 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007721.09596 | 2120576.41129 | 37.8031342846798 | -122.41748497255199 | (37.8031342846798, -122.417484972552) | |||
| 66851 | 66851 | 191268 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6015150.51675 | 2113731.33336 | 37.7847545135408 | -122.391296270324 | (37.7847545135408, -122.391296270324) | ||||
| 71134 | 71134 | 187130 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2600 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985156.874 | 2097417.7557 | 37.73825173359629 | -122.49386027578899 | (37.7382517335963, -122.493860275789) | |||
| 74356 | 74356 | 186817 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1200 Sunset Blvd | 110 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984826.8059 | 2106810.865 | 37.7640233139964 | -122.49569412937599 | (37.7640233139964, -122.495694129376) | |||
| 76720 | 76720 | 129452 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 855 Chestnut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6007720.96455 | 2120575.51523 | 37.803131816931206 | -122.41748536375799 | (37.8031318169312, -122.417485363758) | |||
| 105637 | 105637 | 96626 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 144733 | 144733 | 96627 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.775985700966395 | -122.50890252539 | (37.7759857009664, -122.50890252539) | |||
| 154095 | 154095 | 248214 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 67 Fair Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 6ft | 6006956.2223 | 2099478.83098 | 37.7451623091856 | -122.41863484214 | (37.7451623091856, -122.41863484214) | |||
| 155770 | 155770 | 191267 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6015157.461180001 | 2113744.4936599997 | 37.7847910341296 | -122.391273164948 | (37.7847910341296, -122.391273164948) | ||||
| 155958 | 155958 | 227621 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1335 Douglass St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6001398.3282 | 2099807.1524799997 | 37.7457493236871 | -122.43787655407499 | (37.7457493236871, -122.437876554075) | |||
| 157008 | 157008 | 187077 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2600 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985155.4633 | 2096938.6014 | 37.736936021545 | -122.493829852855 | (37.736936021545, -122.493829852855) | |||
| 159621 | 159621 | 186908 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2700 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985188.8014 | 2096694.9245 | 37.736268900285 | -122.493696639188 | (37.736268900285, -122.493696639188) | |||
| 160010 | 160010 | 176926 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200 Morse St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 6000586.22066 | 2087873.8924099999 | 37.712937131606395 | -122.439829268227 | (37.7129371316064, -122.439829268227) | |||
| 161451 | 161451 | 227601 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1100 San Jose Ave | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6004769.19859 | 2096667.0685 | 37.7373184762576 | -122.425997076417 | (37.7373184762576, -122.425997076417) | ||||
| 162520 | 162520 | 227662 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 32 Harry St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6003182.99622 | 2097643.55659 | 37.7399099141156 | -122.43155100069099 | (37.7399099141156, -122.431551000691) | |||
| 166791 | 166791 | 191265 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2100 Thomas Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6012134.75084 | 2095927.2478099999 | 37.735700607590296 | -122.400478845738 | (37.7357006075903, -122.400478845738) | ||||
| 168581 | 168581 | 227609 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 400 Prospect Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6006260.1728300005 | 2097644.39448 | 37.740086147061 | -122.420911448013 | (37.740086147061, -122.420911448013) | ||||
| 168888 | 168888 | 176927 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200 Morse St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 10ft | 6000575.21017 | 2087869.90013 | 37.7129255429455 | -122.43986703794201 | (37.7129255429455, -122.439867037942) | |||
| 182154 | 182154 | 207098 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 144 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6000468.8354 | 2095254.59465 | 37.733196173744105 | -122.440764091915 | (37.7331961737441, -122.440764091915) | ||||
| 187273 | 187273 | 176963 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 83 Badger St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 6002428.97482 | 2094295.2581 | 37.7306734890866 | -122.43391881851299 | (37.7306734890866, -122.433918818513) | |||
| 103688 | 103688 | 92051 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 140608 | 140608 | 92050 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 26504 | 26504 | 227603 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004504.07862 | 2096101.1879099999 | 37.735749708773795 | -122.42687342978998 | (37.7357497087738, -122.42687342979) | ||||
| 44798 | 44798 | 227608 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 73 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004572.06439 | 2096162.43718 | 37.7359217292935 | -122.426642736581 | (37.7359217292935, -122.426642736581) | ||||
| 54300 | 54300 | 227606 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 60 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6004509.90475 | 2096122.13365 | 37.7358075504724 | -122.426854777822 | (37.7358075504724, -122.426854777822) | ||||
| 69112 | 69112 | 187585 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 748 University St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6008708.47344 | 2090752.4419999998 | 37.7213000235466 | -122.411959282496 | (37.7213000235466, -122.411959282496) | ||||
| 95709 | 95709 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Laguna St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004211.7 | 2116183.0 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | |||||
| 107985 | 107985 | 92049 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Yard 7 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 148811 | 148811 | 247957 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 8 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | 6010434.9927199995 | 2098878.7541 | 37.743709870826 | -122.40656351750602 | (37.743709870826, -122.406563517506) | ||||
| 165842 | 165842 | 227605 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004504.61589 | 2096121.06345 | 37.735804312902204 | -122.426872987299 | (37.7358043129022, -122.426872987299) | ||||
| 166757 | 166757 | 227604 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004502.9106 | 2096117.99556 | 37.7357957927473 | -122.426878664735 | (37.7357957927473, -122.426878664735) | ||||
| 184269 | 184269 | 227602 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 54 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004494.61967 | 2096104.27773 | 37.735757657887994 | -122.426906353066 | (37.735757657888, -122.426906353066) | ||||
| 184382 | 184382 | 227607 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1201 San Jose Ave | 61 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6004513.177130001 | 2096122.0643 | 37.735807545078295 | -122.426843458979 | (37.7358075450783, -122.426843458979) | ||||
| 95348 | 95348 | 97442 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1900@Gough Pacific Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6004943.9 | 2117474.7 | 37.794461125583794 | -122.42687450783701 | (37.7944611255838, -122.426874507837) | |||||
| 26163 | 26163 | 247176 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 111 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6001288.35672 | 2108578.65763 | 37.7698274924813 | -122.438885293015 | (37.7698274924813, -122.438885293015) | |||
| 56432 | 56432 | 227632 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 71 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997905.871119999 | 2104612.50701 | 37.758744422044295 | -122.450299233916 | (37.7587444220443, -122.450299233916) | |||
| 56561 | 56561 | 191262 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6012676.19431 | 2104276.36771 | 37.7586556841436 | -122.399192740559 | (37.7586556841436, -122.399192740559) | |||
| 58867 | 58867 | 247173 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 141 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6001348.76723 | 2108505.96887 | 37.7696313440465 | -122.438671125768 | (37.7696313440465, -122.438671125768) | |||
| 76698 | 76698 | 227631 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 75 Clarendon Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997896.0946 | 2104612.71078 | 37.758744422037395 | -122.450333060142 | (37.7587444220374, -122.450333060142) | |||
| 131733 | 131733 | 191263 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 728 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012693.0382199995 | 2104091.70249 | 37.7581495726586 | -122.399121524154 | (37.7581495726586, -122.399121524154) | |||
| 136118 | 136118 | 250773 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 259 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5985865.92055 | 2114194.89594 | 37.7843585636424 | -122.492644052605 | (37.7843585636424, -122.492644052605) | |||
| 156796 | 156796 | 191266 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1721 Revere Ave | 1 | : 4 | Tree 1 | Private 1 | 25 | Width 9ft | 6014437.69224 | 2094855.17275 | 37.7328850694924 | -122.39244165855499 | (37.7328850694924, -122.392441658555) | |||
| 156929 | 156929 | 217749 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 445 West Portal Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991783.05973 | 2096405.3403 | 37.7358573522267 | -122.470876685538 | (37.7358573522267, -122.470876685538) | |||
| 159965 | 159965 | 176962 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 121 Saint Charles Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 5992069.06615 | 2087619.0428799998 | 37.71174887986621 | -122.46924855110301 | (37.7117488798662, -122.469248551103) | |||
| 174454 | 174454 | 227588 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 435 Oak St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004887.16184 | 2110182.76224 | 37.77443606920671 | -122.42655134748001 | (37.7744360692067, -122.42655134748) | |||
| 177184 | 177184 | 191261 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 690 Wisconsin St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6012675.54577 | 2104288.99957 | 37.7586903323146 | -122.399195870217 | (37.7586903323146, -122.399195870217) | |||
| 60646 | 60646 | 191259 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 900x Carolina St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6012470.08805 | 2103421.28043 | 37.7562963136528 | -122.39984551077299 | (37.7562963136528, -122.399845510773) | ||||
| 23452 | 23452 | 207071 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5993749.481269999 | 2102344.6615 | 37.752278758765605 | -122.464509159894 | (37.7522787587656, -122.464509159894) | |||
| 31453 | 31453 | 207072 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 245 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994440.698340001 | 2100406.16627 | 37.7469959638947 | -122.46197828057899 | (37.7469959638947, -122.461978280579) | |||
| 33222 | 33222 | 207070 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5993749.21516 | 2102356.41341 | 37.752311011160295 | -122.464510933358 | (37.7523110111603, -122.464510933358) | |||
| 34497 | 34497 | 191363 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 955 Key Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013550.52728 | 2089583.75311 | 37.7183615103672 | -122.395139727222 | (37.7183615103672, -122.395139727222) | ||||
| 42271 | 42271 | 207076 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994497.66006 | 2100431.13069 | 37.7470677891411 | -122.461783123205 | (37.7470677891411, -122.461783123205) | |||
| 45787 | 45787 | 207074 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994502.2451599995 | 2100385.66213 | 37.7469432078786 | -122.46176397213301 | (37.7469432078786, -122.461763972133) | |||
| 46195 | 46195 | 207077 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994500.88494 | 2100452.87217 | 37.74712767141 | -122.461773548104 | (37.74712767141, -122.461773548104) | |||
| 47675 | 47675 | 176920 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 671 London St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6001061.12784 | 2089906.70665 | 37.718545806627205 | -122.43833338090299 | (37.7185458066272, -122.438333380903) | ||||
| 56287 | 56287 | 227611 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 66 Balmy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6008811.16325 | 2101739.4503099998 | 37.751473726132005 | -122.412380510571 | (37.751473726132, -122.412380510571) | |||
| 62217 | 62217 | 250619 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987113.722030001 | 2115192.60557 | 37.7871708695801 | -122.48840049988002 | (37.7871708695801, -122.48840049988) | |||
| 130451 | 130451 | 176925 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 17 Curtis St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 6000534.5551 | 2088493.30994 | 37.7146349724878 | -122.440052229032 | (37.7146349724878, -122.440052229032) | |||
| 133413 | 133413 | 250533 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 69 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5987683.92995 | 2115503.12844 | 37.7880567296852 | -122.48645053678601 | (37.7880567296852, -122.486450536786) | |||
| 136250 | 136250 | 250532 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 79 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5987685.24066 | 2115481.63254 | 37.787997784513294 | -122.486444423174 | (37.7879977845133, -122.486444423174) | |||
| 154559 | 154559 | 250620 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 114 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987116.07946 | 2115204.5954 | 37.7872039277514 | -122.48839322528099 | (37.7872039277514, -122.488393225281) | |||
| 163085 | 163085 | 183580 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2614 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988349.2799 | 2097484.0905 | 37.7386201346216 | -122.482827506776 | (37.7386201346216, -122.482827506776) | |||
| 168398 | 168398 | 129401 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 5 Dicha Aly | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5998309.94171 | 2113772.92465 | 37.7839197016653 | -122.449561847418 | (37.7839197016653, -122.449561847418) | |||
| 171953 | 171953 | 207069 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 6ft | 5993748.4844 | 2102370.47272 | 37.752349572298606 | -122.46451448116999 | (37.7523495722986, -122.46451448117) | |||
| 175597 | 175597 | 207073 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5994505.45248 | 2100370.5542599997 | 37.746901910105 | -122.46175178633601 | (37.746901910105, -122.461751786336) | |||
| 175752 | 175752 | 183581 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2614 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988348.717 | 2097504.9177 | 37.738677287922 | -122.48283097892299 | (37.738677287922, -122.482830978923) | |||
| 176799 | 176799 | 182968 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2501 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5990431.4773 | 2098333.0499 | 37.7410720891089 | -122.475690312642 | (37.7410720891089, -122.475690312642) |
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");