Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24183 | 24183 | 175768 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989578.68884 | 2089185.3656400002 | 37.7159053925979 | -122.47797031747801 | (37.7159053925979, -122.477970317478) | ||||
| 24841 | 24841 | 175769 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5989661.94364 | 2089233.64885 | 37.716042798215206 | -122.477686080452 | (37.7160427982152, -122.477686080452) | ||||
| 41434 | 41434 | 175767 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989494.93952 | 2089175.43765 | 37.7158732715029 | -122.478259065526 | (37.7158732715029, -122.478259065526) | ||||
| 44057 | 44057 | 175774 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5990113.97654 | 2089437.91841 | 37.7166298945381 | -122.47613856845 | (37.7166298945381, -122.47613856845) | ||||
| 44691 | 44691 | 175766 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989094.03032 | 2089506.27121 | 37.7167583770722 | -122.47966897135001 | (37.7167583770722, -122.47966897135) | ||||
| 59851 | 59851 | 175772 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989911.02174 | 2089222.5365 | 37.716026738112 | -122.47682434649201 | (37.716026738112, -122.476824346492) | ||||
| 154455 | 154455 | 175771 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5989791.935380001 | 2089208.15493 | 37.7159803412063 | -122.477234910356 | (37.7159803412063, -122.477234910356) | ||||
| 167088 | 167088 | 175765 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5988629.85447 | 2089774.3019599998 | 37.7174673468061 | -122.481292995899 | (37.7174673468061, -122.481292995899) | ||||
| 171701 | 171701 | 175770 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 5989758.80887 | 2089246.54995 | 37.7160838423675 | -122.477352214341 | (37.7160838423675, -122.477352214341) | ||||
| 180214 | 180214 | 175773 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5990089.9017900005 | 2089410.48117 | 37.716553162587296 | -122.476219779021 | (37.7165531625873, -122.476219779021) | ||||
| 168676 | 168676 | 185068 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989159.6219 | 2096046.6038 | 37.7347202832405 | -122.47992059791001 | (37.7347202832405, -122.47992059791) | |||
| 40 | 40 | 222540 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002573.08856 | 2099992.67614 | 37.74632546084511 | -122.433827665916 | (37.7463254608451, -122.433827665916) | |||
| 43 | 43 | 222539 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002564.39948 | 2099984.1142599997 | 37.7463014588556 | -122.433857099823 | (37.7463014588556, -122.433857099823) | |||
| 66 | 66 | 222538 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002556.19825 | 2099973.42317 | 37.746271638232 | -122.43388469462201 | (37.746271638232, -122.433884694622) | |||
| 131647 | 131647 | 175755 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 10 Ruth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6001686.67815 | 2091578.8653 | 37.7231727394058 | -122.43629071923401 | (37.7231727394058, -122.436290719234) | |||
| 54979 | 54979 | 221358 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100 Berkeley Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000996.09085 | 2097469.1732900003 | 37.73930690338871 | -122.439099895546 | (37.7393069033887, -122.439099895546) | |||
| 153123 | 153123 | 221357 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001001.40276 | 2097453.08562 | 37.739263032671204 | -122.439080376676 | (37.7392630326712, -122.439080376676) | |||
| 61227 | 61227 | 140862 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100 Jordan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5996243.3642 | 2113769.3144 | 37.783791348572706 | -122.456711139169 | (37.7837913485727, -122.456711139169) | |||
| 146237 | 146237 | 41633 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100 Jordan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42113 | 5996241.92564567 | 2113793.75965037 | 37.7838583861175 | -122.456717884501 | (37.7838583861175, -122.456717884501) | |||
| 78978 | 78978 | 87642 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1002X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004813.344433 | 2112300.6630169996 | 37.7802471321724 | -122.42695756751101 | (37.7802471321724, -122.426957567511) | |||||
| 107812 | 107812 | 87643 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1002X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6004813.344433 | 2112300.6630169996 | 37.7802471321724 | -122.42695756751101 | (37.7802471321724, -122.426957567511) | |||||
| 84820 | 84820 | 103510 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
| 92027 | 92027 | 103511 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
| 111092 | 111092 | 103509 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
| 121213 | 121213 | 103508 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
| 128766 | 128766 | 103507 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
| 7980 | 7980 | 12325 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1015 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 6 | 4X4 | 6004759.9403 | 2112401.4167 | 37.7805207570776 | -122.427149495677 | (37.7805207570776, -122.427149495677) | ||
| 72258 | 72258 | 47216 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 4 | Permit Number 45167 | 6008173.05313 | 2093488.0369799999 | 37.728781330768896 | -122.41400351077299 | (37.7287813307689, -122.414003510773) | |
| 98121 | 98121 | 47220 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 115878 | 115878 | 47217 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 120251 | 120251 | 47218 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 124336 | 124336 | 47221 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 173434 | 173434 | 47219 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45167 | 6008176.9578 | 2093476.05572 | 37.7287486521041 | -122.413989164793 | (37.7287486521041, -122.413989164793) | |
| 25248 | 25248 | 188298 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1022 Minna St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6007537.97287 | 2109701.89036 | 37.7732652094644 | -122.41734758044 | (37.7732652094644, -122.41734758044) | |||
| 54041 | 54041 | 188299 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1022 Minna St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007530.7890099995 | 2109693.3141 | 37.7732412569071 | -122.41737182255501 | (37.7732412569071, -122.417371822555) | |||
| 22257 | 22257 | 125 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1032 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1990 12:00:00 AM | 18 | 3X3 | 6002008.22654 | 2107658.0827 | 37.767340750994 | -122.436329391899 | (37.767340750994, -122.436329391899) | ||
| 136571 | 136571 | 175789 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1038 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007776.24891 | 2093611.0245700001 | 37.7290967338157 | -122.415383996168 | (37.7290967338157, -122.415383996168) | |||
| 97541 | 97541 | 30674 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1040 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2005 12:00:00 AM | Permit Number 34599 | 6007565.37727332 | 2109755.15641274 | 37.77341300719829 | -122.417256559972 | (37.7734130071983, -122.417256559972) | ||
| 127539 | 127539 | 30676 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1040 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34599 | 6007565.37727332 | 2109755.15641274 | 37.77341300719829 | -122.417256559972 | (37.7734130071983, -122.417256559972) |
| 115613 | 115613 | 27054 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1048X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6007856.910540001 | 2093638.04837 | 37.7291754686195 | -122.41510705369 | (37.7291754686195, -122.41510705369) | ||
| 134658 | 134658 | 221333 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 105 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010957.14091 | 2100465.72663 | 37.7480965515124 | -122.404869753242 | (37.7480965515124, -122.404869753242) | |||
| 79262 | 79262 | 37017 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39630 | 6008600.86286293 | 2102426.42877225 | 37.7533482108195 | -122.413156329636 | (37.7533482108195, -122.413156329636) | ||
| 182888 | 182888 | 221350 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008608.79456 | 2102405.13937 | 37.753290200197895 | -122.413127394812 | (37.7532902001979, -122.413127394812) | |||
| 27078 | 27078 | 188288 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010227.812000001 | 2110667.04277 | 37.7760662630739 | -122.40811110056299 | (37.7760662630739, -122.408111100563) | |||
| 68007 | 68007 | 188285 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010183.94442 | 2110713.51419 | 37.776191406445705 | -122.40826612929199 | (37.7761914064457, -122.408266129292) | |||
| 164398 | 164398 | 188287 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010207.19158 | 2110684.55446 | 37.776113191502496 | -122.408183667747 | (37.7761131915025, -122.408183667747) | |||
| 175531 | 175531 | 188286 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6010191.871780001 | 2110704.80693 | 37.776167942238295 | -122.408238092013 | (37.7761679422383, -122.408238092013) | |||
| 107908 | 107908 | 41599 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 11 Haight St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42106 | 6006168.11250893 | 2109650.54781373 | 37.7730470683498 | -122.42208247198299 | (37.7730470683498, -122.422082471983) | |||
| 54422 | 54422 | 204645 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994132.807630001 | 2090689.3393400002 | 37.7202982210683 | -122.462338293601 | (37.7202982210683, -122.462338293601) | |||
| 107272 | 107272 | 39648 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/2002 12:00:00 AM | Permit Number 41042 | 5994130.09830184 | 2090661.11089351 | 37.720220556524204 | -122.462345612464 | (37.7202205565242, -122.462345612464) | ||
| 145840 | 145840 | 39649 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1998 12:00:00 AM | 5 | 3x20 | Permit Number 41042 | 5994130.09830184 | 2090661.11089351 | 37.720220556524204 | -122.462345612464 | (37.7202205565242, -122.462345612464) | |
| 164499 | 164499 | 204646 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Ashton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994133.91606 | 2090657.47285 | 37.7202107871682 | -122.462332152117 | (37.7202107871682, -122.462332152117) | |||
| 51832 | 51832 | 222565 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Precita Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007123.52166 | 2100080.2988 | 37.7468232221335 | -122.418098981082 | (37.7468232221335, -122.418098981082) | |||
| 97590 | 97590 | 104767 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1111 CASTRO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | 6002562.6 | 2102271.3 | 37.7525814287469 | -122.434026788658 | (37.7525814287469, -122.434026788658) | |||
| 100229 | 100229 | 104766 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1111 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6002562.6 | 2102271.3 | 37.7525814287469 | -122.434026788658 | (37.7525814287469, -122.434026788658) | |||
| 90638 | 90638 | 111230 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1113 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001842.0 | 2112262.0 | 37.779972512780105 | -122.4372340286 | (37.7799725127801, -122.4372340286) | ||||
| 83690 | 83690 | 57741 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 112 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1976 12:00:00 AM | 10 | 3x3 | Permit Number 16659 | 6001762.0 | 2096689.0 | 37.7372082800729 | -122.436395904515 | (37.7372082800729, -122.436395904515) | |
| 159023 | 159023 | 114552 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1121 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777071 | 6011681.54455 | 2103150.14548 | 37.7555078447183 | -122.402553516927 | (37.7555078447183, -122.402553516927) | ||
| 11557 | 11557 | 27528 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/25/2002 12:00:00 AM | 3 | 6008310.55132 | 2093825.05625 | 37.729714434952506 | -122.413551995327 | (37.7297144349525, -122.413551995327) | |||
| 103711 | 103711 | 39650 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 114 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41043 | 5994182.55528924 | 2090689.21166175 | 37.7203007349832 | -122.462166324336 | (37.7203007349832, -122.462166324336) | ||
| 28171 | 28171 | 221347 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 115 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009327.08226 | 2096770.42354 | 37.7378588087266 | -122.41024559558001 | (37.7378588087266, -122.41024559558) | |||
| 65637 | 65637 | 222567 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 115 College Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004467.78746 | 2096013.76695 | 37.735507618486096 | -122.42699267809601 | (37.7355076184861, -122.426992678096) | |||
| 148647 | 148647 | 222566 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 115 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004480.72884 | 2096010.51075 | 37.73549940946629 | -122.426947702995 | (37.7354994094663, -122.426947702995) | |||
| 179938 | 179938 | 221344 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 116 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6008115.05984 | 2098024.5819 | 37.74123443831 | -122.414524882834 | (37.74123443831, -122.414524882834) | |||
| 45511 | 45511 | 221338 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 117 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005011.955130001 | 2099285.1526 | 37.7445208578632 | -122.425344007646 | (37.7445208578632, -122.425344007646) | |||
| 83301 | 83301 | 10882 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1175X Hudson Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
| 70295 | 70295 | 221361 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 118 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004573.07294 | 2095957.02532 | 37.7353577716318 | -122.426624626942 | (37.7353577716318, -122.426624626942) | |||
| 161247 | 161247 | 175781 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 119 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005510.38459 | 2093087.28862 | 37.7275310563876 | -122.423180067012 | (37.7275310563876, -122.423180067012) | |||
| 53944 | 53944 | 221365 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1190 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001927.1952 | 2100682.80135 | 37.748183708409 | -122.43611046183099 | (37.748183708409, -122.436110461831) | |||
| 81253 | 81253 | 56623 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1190 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001932.70639357 | 2100631.3679946 | 37.7480427977008 | -122.43608772434999 | (37.7480427977008, -122.43608772435) | |||||
| 63668 | 63668 | 175754 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 12 Farragut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997730.99268 | 2086963.4604 | 37.7102743532383 | -122.449632264321 | (37.7102743532383, -122.449632264321) | |||
| 45600 | 45600 | 57691 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 120 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/1976 12:00:00 AM | 8 | 3x3 | Permit Number 16595 | 6001759.0 | 2096663.0 | 37.7371367196384 | -122.436404416578 | (37.7371367196384, -122.436404416578) | |
| 85326 | 85326 | 106091 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1200 HUDSON AVE | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6017390.0 | 2095089.0 | 37.733690618402704 | -122.382250932174 | (37.7336906184027, -122.382250932174) | |||
| 12154 | 12154 | 26999 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1200 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6008714.80501 | 2094009.36438 | 37.7302431967539 | -122.41216746208401 | (37.7302431967539, -122.412167462084) | ||
| 52875 | 52875 | 186786 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1200 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984829.112000001 | 2106870.9818 | 37.7641885128796 | -122.495690587985 | (37.7641885128796, -122.495690587985) | |||
| 44455 | 44455 | 222555 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 121 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006651.1877 | 2098952.76416 | 37.743700669854796 | -122.419652282953 | (37.7437006698548, -122.419652282953) | |||
| 103715 | 103715 | 33501 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 121 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37595 | 6006663.30728315 | 2098959.97627538 | 37.7437211553943 | -122.41961088786002 | (37.7437211553943, -122.41961088786) | ||
| 72824 | 72824 | 221349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 121 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6007249.14169 | 2097018.19512 | 37.7384224381557 | -122.41744762190399 | (37.7384224381557, -122.417447621904) | |||
| 177509 | 177509 | 181743 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1219 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986121.7407 | 2106913.1555 | 37.7643799229814 | -122.491222922878 | (37.7643799229814, -122.491222922878) | |||
| 180337 | 180337 | 181742 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1219 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986119.9697 | 2106920.2395 | 37.7643992701936 | -122.491229569586 | (37.7643992701936, -122.491229569586) | |||
| 113716 | 113716 | 35090 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 122 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2003 12:00:00 AM | Permit Number 38632 | 5995399.98940883 | 2107075.75682232 | 37.7653641436682 | -122.459144031764 | (37.7653641436682, -122.459144031764) | ||
| 10673 | 10673 | 121353 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1221 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2016 12:00:00 AM | 3 | 3x3 | 5984567.3281 | 2106871.8527 | 37.76417557031971 | -122.496596073864 | (37.7641755703197, -122.496596073864) | ||
| 10976 | 10976 | 26998 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1223 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/1999 12:00:00 AM | 6 | 3X3 | 6008728.29906 | 2094063.8664 | 37.7303936047791 | -122.41212466153499 | (37.7303936047791, -122.412124661535) | ||
| 84733 | 84733 | 116949 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 123 WEST PORTAL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992936.0 | 2097647.0 | 37.7393332491746 | -122.46698079132099 | (37.7393332491746, -122.466980791321) | ||||
| 121155 | 121155 | 116948 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 123 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992936.0 | 2097647.0 | 37.7393332491746 | -122.46698079132099 | (37.7393332491746, -122.466980791321) | ||||
| 10667 | 10667 | 26997 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1231 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1999 12:00:00 AM | 6 | 3X3 | 6008770.22229 | 2094084.7874099999 | 37.7304534015961 | -122.41198120438801 | (37.7304534015961, -122.411981204388) | ||
| 35176 | 35176 | 43892 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 6 | Permit Number 43498 | 6009086.19652 | 2110571.7349400003 | 37.7757405834934 | -122.412053529658 | (37.7757405834934, -122.412053529658) | ||
| 44902 | 44902 | 43889 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 4 | Permit Number 43498 | 6009135.81805 | 2110617.1891 | 37.775868173909004 | -122.411885088422 | (37.775868173909, -122.411885088422) | ||
| 69711 | 69711 | 43893 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009099.28139 | 2110583.2527799997 | 37.7757729429148 | -122.41200907978201 | (37.7757729429148, -122.412009079782) | ||
| 135995 | 135995 | 43888 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767585 | 6009068.61437 | 2110555.25783 | 37.775694354731606 | -122.412113186199 | (37.7756943547316, -122.412113186199) |
| 170092 | 170092 | 43890 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009124.11279 | 2110606.98987 | 37.77583951252829 | -122.41192485917 | (37.7758395125283, -122.41192485917) | ||
| 181552 | 181552 | 43891 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009112.33188 | 2110593.08814 | 37.7758006806963 | -122.41196462987499 | (37.7758006806963, -122.411964629875) | ||
| 11300 | 11300 | 26996 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1239 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6008815.333330001 | 2094106.20179 | 37.730514731765396 | -122.41182676109399 | (37.7305147317654, -122.411826761094) | ||
| 153300 | 153300 | 33288 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1242 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/1996 12:00:00 AM | 7 | Permit Number 37449 | 6008832.98278 | 2116682.76958 | 37.7925058062477 | -122.41336172668699 | (37.7925058062477, -122.413361726687) | |
| 167932 | 167932 | 221364 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1243 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001375.81776 | 2100058.24789 | 37.7464374920934 | -122.437972374152 | (37.7464374920934, -122.437972374152) | |||
| 153717 | 153717 | 69152 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1245 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1994 12:00:00 AM | 5 | Permit Number 33187 | 5986742.1857 | 2106776.7875 | 37.764041727251396 | -122.48906697906 | (37.7640417272514, -122.48906697906) | |
| 10145 | 10145 | 173881 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1245 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996703.0 | 2107106.0 | 37.7655220059747 | -122.45463943175601 | (37.7655220059747, -122.454639431756) | ||||
| 134933 | 134933 | 181746 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1246 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989272.8487 | 2106849.4285 | 37.7643885611619 | -122.480319577317 | (37.7643885611619, -122.480319577317) | |||
| 153879 | 153879 | 181761 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1246 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989269.0192 | 2106863.9805 | 37.7644282944678 | -122.480333887539 | (37.7644282944678, -122.480333887539) | |||
| 40165 | 40165 | 32579 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1247 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 5 | Permit Number 37053 | 5985814.1748 | 2106726.0184 | 37.763848120851705 | -122.49227291177401 | (37.7638481208517, -122.492272911774) |
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");