Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31653 | 31653 | 175608 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 466 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012381.21088 | 2086413.92424 | 37.709592695022295 | -122.398959231579 | (37.7095926950223, -122.398959231579) | |||
| 11289 | 11289 | 24269 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001399.20674 | 2086458.92155 | 37.7090981776115 | -122.43691809171999 | (37.7090981776115, -122.43691809172) | |||
| 13019 | 13019 | 24270 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001396.0736 | 2086458.9864 | 37.709098177596005 | -122.436928924942 | (37.709098177596, -122.436928924942) | |||
| 10927 | 10927 | 24271 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001388.30533 | 2086462.2685599998 | 37.70910674815379 | -122.436956008017 | (37.7091067481538, -122.436956008017) | |||
| 11032 | 11032 | 24272 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001382.61488 | 2086464.9875900003 | 37.7091138905754 | -122.43697586956301 | (37.7091138905754, -122.436975869563) | |||
| 170302 | 170302 | 71651 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 177 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994505.19973 | 2086471.6739 | 37.7087389470079 | -122.46074556997101 | (37.7087389470079, -122.460745569971) | ||
| 137396 | 137396 | 175750 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 348 Naylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6002816.75765 | 2086477.59625 | 37.7092299219895 | -122.43202015901899 | (37.7092299219895, -122.432020159019) | |||
| 169725 | 169725 | 175749 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 348 Naylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6002804.80085 | 2086492.5452299998 | 37.7092702907661 | -122.432062550353 | (37.7092702907661, -122.432062550353) | |||
| 166516 | 166516 | 69438 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Santa Cruz Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1994 12:00:00 AM | 6 | Permit Number 33545 | 5993088.80201 | 2086544.97974 | 37.7088586314964 | -122.465646111595 | (37.7088586314964, -122.465646111595) | ||
| 158955 | 158955 | 175734 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 327 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002802.82744 | 2086547.25146 | 37.709420390321604 | -122.432073274757 | (37.7094203903216, -122.432073274757) | |||
| 27069 | 27069 | 175748 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 66 Baltimore Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002940.94851 | 2086563.0179 | 37.7094715113586 | -122.43159703068501 | (37.7094715113586, -122.431597030685) | |||
| 34836 | 34836 | 175735 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 327 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002788.22143 | 2086564.9821400002 | 37.7094682468215 | -122.43212502085 | (37.7094682468215, -122.43212502085) | |||
| 30222 | 30222 | 175747 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 58 Baltimore Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6002963.82508 | 2086583.0162 | 37.709527718998 | -122.431519392204 | (37.709527718998, -122.431519392204) | |||
| 178733 | 178733 | 175736 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 315 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002759.3959 | 2086598.756 | 37.7095593481574 | -122.43222705702699 | (37.7095593481574, -122.432227057027) | |||
| 67037 | 67037 | 175746 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 52 Baltimore Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6002987.27121 | 2086606.3933299999 | 37.7095932364015 | -122.43144002615401 | (37.7095932364015, -122.431440026154) | |||
| 73651 | 73651 | 175737 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 315 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002750.42911 | 2086613.8505900002 | 37.709600286206204 | -122.43225912506901 | (37.7096002862062, -122.432259125069) | |||
| 150121 | 150121 | 175745 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 52 Baltimore Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6003007.00361 | 2086627.02122 | 37.7096509944604 | -122.431373299139 | (37.7096509944604, -122.431373299139) | |||
| 43099 | 43099 | 175738 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 315 Naylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002741.21238 | 2086627.0601700002 | 37.7096360342462 | -122.432291922446 | (37.7096360342462, -122.432291922446) | |||
| 74650 | 74650 | 175744 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 46 Baltimore Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6003028.75595 | 2086646.47615 | 37.709705646261796 | -122.431299507078 | (37.7097056462618, -122.431299507078) | |||
| 45360 | 45360 | 175612 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 423 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012227.11334 | 2086656.2616400002 | 37.710249517571896 | -122.399508825282 | (37.7102495175719, -122.399508825282) | |||
| 62750 | 62750 | 175647 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 199 Shakespeare St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 5993520.37631 | 2086668.28967 | 37.7092220951912 | -122.464163488366 | (37.7092220951912, -122.464163488366) | |||
| 73017 | 73017 | 175613 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 423 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012234.29342 | 2086673.78527 | 37.71029803420561 | -122.399485238767 | (37.7102980342056, -122.399485238767) | |||
| 175458 | 175458 | 31001 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 285 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34778 | 6002746.71825 | 2086679.2341 | 37.709779604712 | -122.43227661689899 | (37.709779604712, -122.432276616899) | |
| 84745 | 84745 | 31004 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 285 Chicago Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34778 | 6002766.74364375 | 2086692.10708835 | 37.7098160865806 | -122.432208324272 | (37.7098160865806, -122.432208324272) | ||
| 99162 | 99162 | 31003 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 285 Chicago Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34778 | 6002766.74364375 | 2086692.10708835 | 37.7098160865806 | -122.432208324272 | (37.7098160865806, -122.432208324272) | ||
| 113292 | 113292 | 31002 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 285 Chicago Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34778 | 6002766.74364375 | 2086692.10708835 | 37.7098160865806 | -122.432208324272 | (37.7098160865806, -122.432208324272) | ||
| 186574 | 186574 | 59349 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/1980 12:00:00 AM | 10 | Permit Number 18697 | 6002772.3177 | 2086703.6942599998 | 37.7098482184782 | -122.43218988627399 | (37.7098482184782, -122.432189886274) | ||
| 184257 | 184257 | 175743 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 262 Chicago Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6002717.2522 | 2086712.6010099999 | 37.7098695521959 | -122.43238083839701 | (37.7098695521959, -122.432380838397) | |||
| 132995 | 132995 | 175742 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 262 Chicago Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6002727.11736 | 2086720.5871400002 | 37.709892039762295 | -122.43234731259399 | (37.7098920397623, -122.432347312594) | |||
| 36617 | 36617 | 175739 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 Chicago Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6002794.41849 | 2086722.1369599998 | 37.709900111181604 | -122.432114818072 | (37.7099001111816, -122.432114818072) | |||
| 28772 | 28772 | 175741 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 262 Chicago Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6002753.09913 | 2086743.14922 | 37.709955463542 | -122.432259125067 | (37.709955463542, -122.432259125067) | |||
| 167207 | 167207 | 175740 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 262 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6002767.48185 | 2086755.4515900002 | 37.709990058672794 | -122.432210293693 | (37.7099900586728, -122.432210293693) | |||
| 160753 | 160753 | 57934 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 591 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 6 | Permit Number 16893 | 5998966.09872 | 2086766.06528 | 37.7098029340355 | -122.44534931682301 | (37.7098029340355, -122.445349316823) | ||
| 168059 | 168059 | 175588 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 591 Brunswick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5998981.8077 | 2086772.94827 | 37.7098227299032 | -122.445295518467 | (37.7098227299032, -122.445295518467) | |||
| 169383 | 169383 | 175589 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 591 Brunswick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5999000.7580699995 | 2086779.04267 | 37.7098405454782 | -122.44523046062 | (37.7098405454782, -122.44523046062) | |||
| 102786 | 102786 | 69410 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1033 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33515 | 6001287.00169166 | 2086793.18756043 | 37.7100096203988 | -122.43732980748699 | (37.7100096203988, -122.437329807487) | ||
| 166358 | 166358 | 175641 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 De Long St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 10ft | 5993718.84188 | 2086795.50483 | 37.709582834847005 | -122.463486791709 | (37.709582834847, -122.463486791709) | |||
| 54344 | 54344 | 175642 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 De Long St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 10ft | 5993719.3869 | 2086798.3884400001 | 37.709590783961 | -122.463485117168 | (37.709590783961, -122.463485117168) | |||
| 85192 | 85192 | 175643 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 De Long St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 10ft | 5993719.91168 | 2086800.3072400002 | 37.7095960827685 | -122.463483442609 | (37.7095960827685, -122.463483442609) | |||
| 162718 | 162718 | 175644 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 De Long St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 10ft | 5993719.95216 | 2086802.2365299999 | 37.7096013824754 | -122.463483442623 | (37.7096013824754, -122.463483442623) | |||
| 37841 | 37841 | 175646 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 De Long St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 5993722.898680001 | 2086804.1045099997 | 37.7096066812751 | -122.46347339448799 | (37.7096066812751, -122.463473394488) | |||
| 52770 | 52770 | 175645 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 275 De Long St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 5993719.51846 | 2086804.6578900001 | 37.7096080059695 | -122.46348511715799 | (37.7096080059695, -122.463485117158) | |||
| 40107 | 40107 | 175639 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 28 De Long St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5995095.5192 | 2086815.4100099998 | 37.709716713323495 | -122.458730228841 | (37.7097167133235, -122.458730228841) | |||
| 61917 | 61917 | 175640 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 28 De Long St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5995084.70237 | 2086816.61805 | 37.7097194085931 | -122.458767700893 | (37.7097194085931, -122.458767700893) | |||
| 155132 | 155132 | 175610 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 333 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012573.19218 | 2086887.1128200002 | 37.7109026735915 | -122.398328885071 | (37.7109026735915, -122.398328885071) | |||
| 116934 | 116934 | 44402 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1162 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 7 | Permit Number 43756 | 6001306.88514 | 2087104.5026099999 | 37.7108655531865 | -122.437283363033 | (37.7108655531865, -122.437283363033) | |
| 152728 | 152728 | 54765 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 179 Nueva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 9 | Permit Number 10614 | 6012917.58994 | 2087110.3835 | 37.7115349095784 | -122.39715420321899 | (37.7115349095784, -122.397154203219) | ||
| 154901 | 154901 | 175733 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1183 Munich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6001131.654490001 | 2087116.6540599999 | 37.710888955334 | -122.437889869445 | (37.710888955334, -122.437889869445) | |||
| 65781 | 65781 | 175630 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 75 South Hill Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6002944.13194 | 2087144.13507 | 37.7110673133896 | -122.43162748893101 | (37.7110673133896, -122.431627488931) | |||
| 55998 | 55998 | 31018 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 21 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 6 | Permit Number 43762 | 6002296.8403 | 2087180.6482 | 37.711130859472604 | -122.433867290956 | (37.7111308594726, -122.433867290956) | |
| 50411 | 50411 | 175609 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 166 Nueva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012906.3252 | 2087198.97417 | 37.7117775349824 | -122.39719934556801 | (37.7117775349824, -122.397199345568) | |||
| 12815 | 12815 | 1189 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3027 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1995 12:00:00 AM | 10 | 3X3 | 5996602.206590001 | 2087199.5988900003 | 37.710858092411605 | -122.45355059790701 | (37.7108580924116, -122.453550597907) | ||
| 48950 | 48950 | 175604 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 243 Curtis St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 2ft | 6000875.03048 | 2087235.17223 | 37.711199783509 | -122.43878530732201 | (37.711199783509, -122.438785307322) | |||
| 133144 | 133144 | 175605 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 243 Curtis St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 2ft | 6000870.76223 | 2087251.30173 | 37.7112438287074 | -122.438801214504 | (37.7112438287074, -122.438801214504) | |||
| 159808 | 159808 | 46208 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 297 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2002 12:00:00 AM | 12 | Permit Number 44524 | 6012148.34549 | 2087261.8954099999 | 37.711908076982 | -122.399823563722 | (37.711908076982, -122.399823563722) | ||
| 57926 | 57926 | 175606 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 243 Curtis St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 2ft | 6000866.493969999 | 2087267.4309 | 37.7112878729966 | -122.43881712171499 | (37.7112878729966, -122.438817121715) | |||
| 43897 | 43897 | 175611 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 297 Wheeler Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012151.441000001 | 2087271.29905 | 37.711934070079295 | -122.39981352459299 | (37.7119340700793, -122.399813524593) | |||
| 28589 | 28589 | 175638 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 116 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008956.41307 | 2087314.5262799999 | 37.7118741275743 | -122.41085953663601 | (37.7118741275743, -122.410859536636) | |||
| 54540 | 54540 | 175593 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 120 Farragut Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5997391.38544 | 2087332.13149 | 37.7112672047814 | -122.450832575961 | (37.7112672047814, -122.450832575961) | |||
| 154452 | 154452 | 175603 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 89 Florentine Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5999564.54554 | 2087573.5763400001 | 37.7120543220234 | -122.443338944435 | (37.7120543220234, -122.443338944435) | |||
| 148536 | 148536 | 205857 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 135 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995009.88085 | 2087611.2569099998 | 37.7118970000092 | -122.459083796406 | (37.7118970000092, -122.459083796406) | |||
| 76613 | 76613 | 175592 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 130 Moneta Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 5997447.90678 | 2087770.39122 | 37.7124738008959 | -122.450668802241 | (37.7124738008959, -122.450668802241) | |||
| 168415 | 168415 | 114958 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 66 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | 1 | Permit Number 775977 | 5999698.38088 | 2087820.43772 | 37.7127397789845 | -122.44289408849 | (37.7127397789845, -122.44289408849) | ||
| 66759 | 66759 | 78797 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 85 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 1 | 6001030.801469999 | 2087976.50512 | 37.713244179940794 | -122.43830000075899 | (37.7132441799408, -122.438300000759) | ||
| 175588 | 175588 | 175590 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Moneta Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5997972.2511 | 2088063.0023700001 | 37.7133072440178 | -122.448877579363 | (37.7133072440178, -122.448877579363) | |||
| 45523 | 45523 | 175591 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2 Moneta Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5997970.372380001 | 2088102.3991200002 | 37.713415311033 | -122.44888690892 | (37.713415311033, -122.44888690892) | |||
| 18251 | 18251 | 26063 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X3 | 5994596.9562 | 2088110.4909 | 37.713244032213105 | -122.46054712266199 | (37.7132440322131, -122.460547122662) | |||
| 19933 | 19933 | 26061 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 5994614.7294 | 2088111.1256 | 37.7132467974329 | -122.46048573878299 | (37.7132467974329, -122.460485738783) | |||
| 19828 | 19828 | 26060 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5994622.6639 | 2088111.4430000002 | 37.713248125396 | -122.46045833760701 | (37.713248125396, -122.460458337607) | |||
| 21714 | 21714 | 26062 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5994603.6211 | 2088111.4430000002 | 37.71324702988721 | -122.460524155594 | (37.7132470298872, -122.460524155594) | |||
| 173444 | 173444 | 204378 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 150 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992980.7825 | 2088221.2097099999 | 37.713454927976706 | -122.466141167706 | (37.7134549279767, -122.466141167706) | |||
| 179961 | 179961 | 204383 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 41 Ralston St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5992172.93339 | 2088222.9751099998 | 37.7134131337717 | -122.46893348261699 | (37.7134131337717, -122.468933482617) | ||||
| 154924 | 154924 | 204382 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 41 Ralston St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992173.48186 | 2088232.60675 | 37.7134396116198 | -122.46893228741999 | (37.7134396116198, -122.46893228742) | ||||
| 184062 | 184062 | 204381 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 47 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992175.93878 | 2088248.61457 | 37.7134837071825 | -122.46892495972901 | (37.7134837071825, -122.468924959729) | ||||
| 115078 | 115078 | 48569 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 150 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2002 12:00:00 AM | Permit Number 45988 | 5992993.59423207 | 2088277.32681995 | 37.7136097512741 | -122.46610096163299 | (37.7136097512741, -122.466100961633) | ||
| 65842 | 65842 | 31005 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 5 | Permit Number 34779 | 6000594.89127 | 2088305.62905 | 37.71412307747921 | -122.439830234972 | (37.7141230774792, -122.439830234972) | |
| 186026 | 186026 | 204380 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 64 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992207.49196 | 2088316.25633 | 37.713671258107 | -122.46882082092199 | (37.713671258107, -122.468820820922) | |||
| 176881 | 176881 | 175607 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2 Hester Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6012544.08177 | 2088322.31575 | 37.7148418345529 | -122.398530142577 | (37.7148418345529, -122.398530142577) | |||
| 32633 | 32633 | 204384 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 82 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5992474.1987 | 2088421.8955 | 37.7139767227086 | -122.46790667266 | (37.7139767227086, -122.46790667266) | |||
| 175338 | 175338 | 204385 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 82 Vernon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5992474.44485 | 2088433.59957 | 37.7140088734796 | -122.467906672658 | (37.7140088734796, -122.467906672658) | |||
| 60592 | 60592 | 175635 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 29 Tucker Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010977.990619999 | 2088484.1158599998 | 37.71519873230721 | -122.403954615717 | (37.7151987323072, -122.403954615717) | |||
| 166897 | 166897 | 175634 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 29 Tucker Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010973.25986 | 2088486.32565 | 37.7152045356343 | -122.40397112278099 | (37.7152045356343, -122.403971122781) | |||
| 69433 | 69433 | 65697 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 20 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/1990 12:00:00 AM | 12 | Permit Number 28626 | 6000103.70653 | 2088525.9220900002 | 37.714699980888795 | -122.44154375196501 | (37.7146999808888, -122.441543751965) | |
| 28988 | 28988 | 175585 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1711 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5998173.65271 | 2088704.87448 | 37.7150811936116 | -122.448227659988 | (37.7150811936116, -122.448227659988) | |||
| 171823 | 171823 | 205858 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4 Lobos St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 5996833.75095 | 2088711.6918099998 | 37.7150232206213 | -122.45285940144699 | (37.7150232206213, -122.452859401447) | |||
| 104180 | 104180 | 1126 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2500X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5998746.092019999 | 2088752.4800599997 | 37.7152446168065 | -122.446252494655 | (37.7152446168065, -122.446252494655) | |||
| 133918 | 133918 | 175594 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2522 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5998750.81028 | 2088752.88723 | 37.71524600426579 | -122.446236215627 | (37.7152460042658, -122.446236215627) | |||
| 37680 | 37680 | 175596 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 861 Lisbon St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6001043.54225 | 2088836.75005 | 37.715606945381 | -122.438317555522 | (37.715606945381, -122.438317555522) | |||
| 60168 | 60168 | 93570 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 920 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6001322.49897 | 2088870.0232799998 | 37.715714168855904 | -122.437355737785 | (37.7157141688559, -122.437355737785) | ||||
| 115122 | 115122 | 93571 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 920 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001349.0 | 2088904.0 | 37.7158089679017 | -122.43726656966801 | (37.7158089679017, -122.437266569668) | |||||
| 12255 | 12255 | 97766 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400X Amazon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6001498.9346199995 | 2088909.8627799999 | 37.71583358803421 | -122.436748746672 | (37.7158335880342, -122.436748746672) | |||
| 38773 | 38773 | 204360 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 160 Ralston St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5992214.92072 | 2088927.28507 | 37.7153494245261 | -122.46883958168002 | (37.7153494245261, -122.46883958168) | |||
| 10623 | 10623 | 97764 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400X Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6001442.97937 | 2088937.5583900001 | 37.715906453794 | -122.43694413518601 | (37.715906453794, -122.436944135186) | |||
| 118109 | 118109 | 175636 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1277 Brussels St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011793.2641900005 | 2088994.55488 | 37.7166458107269 | -122.401172506308 | (37.7166458107269, -122.401172506308) | |||
| 164826 | 164826 | 113756 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Amazon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6001223.92516 | 2089044.4895 | 37.7161876097347 | -122.437708941119 | (37.7161876097347, -122.437708941119) | |||
| 24048 | 24048 | 113755 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6001200.73843 | 2089055.6919999998 | 37.7162170508648 | -122.43778988730499 | (37.7162170508648, -122.437789887305) | |||
| 28182 | 28182 | 175586 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 158 Rome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5998844.18074 | 2089066.48098 | 37.7161123931481 | -122.44593602912799 | (37.7161123931481, -122.445936029128) | |||
| 50323 | 50323 | 55325 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1231 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 11 | Permit Number 11255 | 6011451.82111 | 2089071.0764400002 | 37.7168368689981 | -122.402358088854 | (37.7168368689981, -122.402358088854) | ||
| 160117 | 160117 | 121487 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 377 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6010852.01501 | 2089133.2163799999 | 37.7169739913337 | -122.40443570715799 | (37.7169739913337, -122.404435707158) | |||
| 130613 | 130613 | 204365 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 294 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992993.26737 | 2089135.1881799998 | 37.715965213688996 | -122.46616439446998 | (37.715965213689, -122.46616439447) |
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");