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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 73248 | 73248 | 54766 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 192 Nueva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1972 12:00:00 AM | 7 | Permit Number 10615 | 6012860.29811 | 2087055.87455 | 37.7113820491125 | -122.39734840011101 | (37.7113820491125, -122.397348400111) | ||
| 30579 | 30579 | 175758 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Tocoloma Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012839.87945 | 2087571.5634599999 | 37.7127968922232 | -122.397455115464 | (37.7127968922232, -122.397455115464) | ||||
| 177203 | 177203 | 175759 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Tocoloma Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012872.74847 | 2087577.73375 | 37.7128156646891 | -122.397341941199 | (37.7128156646891, -122.397341941199) | ||||
| 110263 | 110263 | 52957 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 227 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48944 | 5992946.65383726 | 2088708.6513983002 | 37.714791356792 | -122.46629453065701 | (37.714791356792, -122.466294530657) | ||
| 165896 | 165896 | 84186 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 467 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50687 | 6010581.884869999 | 2088390.3432099998 | 37.7149191133084 | -122.40531713630101 | (37.7149191133084, -122.405317136301) | |
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 154732 | 154732 | 204656 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5993464.3561 | 2089166.2811200002 | 37.716077755750206 | -122.464538359982 | (37.7160777557502, -122.464538359982) | |||
| 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) | ||||
| 97932 | 97932 | 175756 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 837 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000844.62416 | 2089035.80235 | 37.7161421822999 | -122.439019362161 | (37.7161421822999, -122.439019362161) | |||
| 175761 | 175761 | 204654 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 222 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992216.41936 | 2089361.24223 | 37.7165410523041 | -122.46886596240299 | (37.7165410523041, -122.468865962403) | |||
| 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) | ||||
| 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) | ||||
| 134307 | 134307 | 204647 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 64 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996124.76777 | 2089322.40375 | 37.716659439069794 | -122.455354045254 | (37.7166594390698, -122.455354045254) | |||
| 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) | ||||
| 110193 | 110193 | 41345 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 733 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2000 12:00:00 AM | Permit Number 41999 | 5995888.07123287 | 2089420.5370121002 | 37.716915305937796 | -122.4561792734 | (37.7169153059378, -122.4561792734) | |||
| 112096 | 112096 | 51290 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 738 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | Permit Number 47662 | 5995079.16819472 | 2089446.39884805 | 37.716939850408394 | -122.458977110473 | (37.7169398504084, -122.458977110473) | |||
| 82665 | 82665 | 39219 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 347 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1998 12:00:00 AM | Permit Number 40862 | 5993215.94072133 | 2089494.769314 | 37.7169653816902 | -122.465420843024 | (37.7169653816902, -122.465420843024) | |||
| 32795 | 32795 | 204648 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 733 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5995892.41562 | 2089491.7886299998 | 37.71711119551271 | -122.456169405709 | (37.7171111955127, -122.456169405709) | |||
| 34559 | 34559 | 175753 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 755 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6000826.82092 | 2089512.30625 | 37.7174495420436 | -122.439115030257 | (37.7174495420436, -122.439115030257) | ||||
| 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) | ||||
| 43337 | 43337 | 204651 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 27 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997399.75585 | 2089775.82239 | 37.7179774953307 | -122.45097974552401 | (37.7179774953307, -122.450979745524) | |||
| 117199 | 117199 | 51289 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 875 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | Permit Number 47661 | 5995029.72941729 | 2089837.87433116 | 37.718011907210204 | -122.45917632673999 | (37.7180119072102, -122.45917632674) | |||
| 92664 | 92664 | 39671 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 99326 | 99326 | 39673 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 112900 | 112900 | 39672 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 127185 | 127185 | 39670 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 50558 | 50558 | 70268 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 656 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 11 | 6002561.31186 | 2089826.6998700001 | 37.71841134000321 | -122.43314215230801 | (37.7184113400032, -122.433142152308) | ||
| 35496 | 35496 | 204653 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 131 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991405.61668 | 2090064.78105 | 37.718425920692795 | -122.47171971360599 | (37.7184259206928, -122.471719713606) | |||
| 82360 | 82360 | 39674 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 510 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41060 | 5994056.62807806 | 2090013.39911729 | 37.718437864492394 | -122.462552614145 | (37.7184378644924, -122.462552614145) | ||
| 67938 | 67938 | 204649 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 508 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994044.084530001 | 2090032.62859 | 37.7184899416364 | -122.46259736577 | (37.7184899416364, -122.46259736577) | |||
| 50710 | 50710 | 72270 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 619 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 5 | 6002965.14713 | 2089877.08907 | 37.7185725974338 | -122.431749858784 | (37.7185725974338, -122.431749858784) | ||
| 153820 | 153820 | 108373 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 637 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 773812 | 6002662.58132 | 2089906.96275 | 37.718637468222 | -122.432797836946 | (37.718637468222, -122.432797836946) | |
| 182698 | 182698 | 108374 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 637 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 773812 | 6002670.30203 | 2089919.45736 | 37.718672213540295 | -122.432772041698 | (37.7186722135403, -122.432772041698) | |
| 28372 | 28372 | 204655 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 452 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993265.60688 | 2090192.2995 | 37.7188834957636 | -122.46529981143298 | (37.7188834957636, -122.465299811433) | |||
| 120200 | 120200 | 47376 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 454 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45293 | 5993277.02762299 | 2090193.33113846 | 37.718886987019 | -122.46526040964899 | (37.718886987019, -122.465260409649) | ||
| 4201 | 4201 | 252891 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:13:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4203 | 4203 | 252894 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:10:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4213 | 4213 | 252892 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:08:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4246 | 4246 | 252893 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:25:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4212 | 4212 | 204652 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:45:00 PM | 3 | Width 3ft | 5997137.29551 | 2090290.56774 | 37.719375836806705 | -122.45192406695601 | (37.7193758368067, -122.451924066956) | ||
| 106583 | 106583 | 46402 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44632 | 5997151.20329152 | 2090327.07955038 | 37.7194768863059 | -122.451878625824 | (37.7194768863059, -122.451878625824) | ||
| 11500 | 11500 | 66889 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 562 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1991 12:00:00 AM | 8 | 3x3 | Permit Number 30203 | 6003132.96801 | 2090225.04515 | 37.7195375196183 | -122.43119459394899 | (37.7195375196183, -122.431194593949) | |
| 4291 | 4291 | 252895 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 790x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:29:00 PM | 3 | 3x3 | 5997282.0 | 2090432.0 | 37.719772464034904 | -122.45143407539 | (37.7197724640349, -122.45143407539) | ||
| 86680 | 86680 | 39663 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.719932478931796 | -122.46264932396299 | (37.7199324789318, -122.462649323963) | ||
| 90504 | 90504 | 39664 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.719932478931796 | -122.46264932396299 | (37.7199324789318, -122.462649323963) | ||
| 4156 | 4156 | 213178 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 629 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 08:23:00 AM | 3 | Width 3ft | Permit Number 20774 | 5994856.22066 | 2090552.89382 | 37.7199652039099 | -122.45982783161502 | (37.7199652039099, -122.459827831615) | |
| 181555 | 181555 | 204650 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 254 Howth St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 5997292.004269999 | 2090577.4247599998 | 37.720172339354704 | -122.451409977591 | (37.7201723393547, -122.451409977591) | |||
| 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) | |||
| 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) | |
| 136971 | 136971 | 175757 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Vienna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003296.85898 | 2090487.74665 | 37.7202681261541 | -122.43064681870199 | (37.7202681261541, -122.430646818702) | |||
| 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) | |||
| 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) | ||
| 38894 | 38894 | 50846 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | 5 | Permit Number 47372 | 6003324.61709 | 2090530.54695 | 37.720387218868495 | -122.430553920527 | (37.7203872188685, -122.430553920527) | ||
| 85541 | 85541 | 30142 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 410X Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
| 107581 | 107581 | 39652 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 141 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41045 | 5994132.92951736 | 2090837.78725757 | 37.7207058303918 | -122.462348633516 | (37.7207058303918, -122.462348633516) | ||
| 139952 | 139952 | 39653 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 150 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41046 | 5994186.17432148 | 2090915.05015887 | 37.7209210416097 | -122.462170184545 | (37.7209210416097, -122.462170184545) | ||
| 80689 | 80689 | 106706 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 199X BRIGHTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5996224.0 | 2090880.0 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | |||
| 65031 | 65031 | 204644 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 150 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994179.89282 | 2090937.7889 | 37.7209831150476 | -122.46219354590099 | (37.7209831150476, -122.462193545901) | |||
| 121726 | 121726 | 106704 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 179 BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5996189.7 | 2091071.1 | 37.7214646729593 | -122.45525590980199 | (37.7214646729593, -122.455255909802) | |||
| 177655 | 177655 | 175760 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 885 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011559.50494 | 2090784.62511 | 37.72154793606661 | -122.402106275984 | (37.7215479360666, -122.402106275984) | |||
| 187374 | 187374 | 36805 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 10 | Permit Number 39531 | 6014737.8573 | 2091203.2549 | 37.7228743001584 | -122.39114872971001 | (37.7228743001584, -122.39114872971) | |
| 187540 | 187540 | 36806 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 4 | Permit Number 39531 | 6014725.6758 | 2091211.782 | 37.722897037873395 | -122.391191434704 | (37.7228970378734, -122.391191434704) | |
| 65839 | 65839 | 36807 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 8 | Permit Number 39531 | 6014713.4944 | 2091220.9181 | 37.722921447771604 | -122.39123418192699 | (37.7229214477716, -122.391234181927) | |
| 90190 | 90190 | 59352 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 469 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1980 12:00:00 AM | 11 | 4x4 | Permit Number 18701 | 5994737.99829015 | 2091686.56057322 | 37.7230711817022 | -122.460318578759 | (37.7230711817022, -122.460318578759) | |
| 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) | |||
| 137468 | 137468 | 175776 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 281 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004111.17595 | 2091728.8824200002 | 37.723722111883504 | -122.427920387213 | (37.7237221118835, -122.427920387213) | |||
| 175753 | 175753 | 204641 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995679.43604 | 2091904.4278 | 37.7237235031239 | -122.45707998907601 | (37.7237235031239, -122.457079989076) | |||
| 52367 | 52367 | 175777 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 281 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004127.09808 | 2091752.9850700002 | 37.7237891931904 | -122.42786706372601 | (37.7237891931904, -122.427867063726) | |||
| 137701 | 137701 | 175778 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 281 Vienna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004138.179280001 | 2091770.31166 | 37.7238373950554 | -122.427829991858 | (37.7238373950554, -122.427829991858) | |||
| 54861 | 54861 | 204642 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Granada Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5995680.91746 | 2091957.8181099999 | 37.7238701852543 | -122.457078728228 | (37.7238701852543, -122.457078728228) | |||
| 38724 | 38724 | 204643 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995381.41136 | 2092014.7979700002 | 37.7240094335681 | -122.458118187113 | (37.7240094335681, -122.458118187113) | |||
| 107537 | 107537 | 39654 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 326 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41047 | 5994205.8673586 | 2092067.47591786 | 37.7240864587641 | -122.46218564714898 | (37.7240864587641, -122.462185647149) | ||
| 148447 | 148447 | 175761 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Woolsey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011060.579 | 2091989.46007 | 37.72482830406621 | -122.403915678669 | (37.7248283040662, -122.403915678669) | |||
| 183090 | 183090 | 47228 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45171 | 6011142.396240001 | 2091994.05057 | 37.724845479317004 | -122.403633167442 | (37.724845479317, -122.403633167442) | |
| 50129 | 50129 | 175762 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Woolsey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011080.3120099995 | 2091995.56752 | 37.7248461762995 | -122.403847893187 | (37.7248461762995, -122.403847893187) | |||
| 133233 | 133233 | 175763 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Woolsey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011100.65099 | 2092002.25417 | 37.724865672709605 | -122.40377805363 | (37.7248656727096, -122.40377805363) | |||
| 79362 | 79362 | 47227 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600 Girard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | ||
| 93761 | 93761 | 47226 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | ||
| 114176 | 114176 | 47229 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 600 Girard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45171 | 6011131.84499471 | 2092020.43251585 | 37.7249173292839 | -122.403671497463 | (37.7249173292839, -122.403671497463) | ||
| 71277 | 71277 | 175764 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 325 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010619.0390099995 | 2092334.0476400002 | 37.7257497917057 | -122.40546629512698 | (37.7257497917057, -122.405466295127) | |||
| 4849 | 4849 | 253684 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 767 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009074.0 | 2092682.0 | 37.7266186845557 | -122.410831962563 | (37.7266186845557, -122.410831962563) | ||||
| 74603 | 74603 | 66582 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 425 Peru Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1991 12:00:00 AM | 16 | Permit Number 29772 | 6004685.90241 | 2092879.2867599998 | 37.7269133660376 | -122.426015508917 | (37.7269133660376, -122.426015508917) | |
| 130006 | 130006 | 204640 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 25 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998733.11218 | 2093060.00406 | 37.7270713418516 | -122.446607092452 | (37.7270713418516, -122.446607092452) | |||
| 91385 | 91385 | 102872 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 173 Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.44773810752899 | (37.7272185530423, -122.447738107529) | ||||
| 138626 | 138626 | 102585 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 173 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 03/07/2013 12:00:00 AM | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.44773810752899 | (37.7272185530423, -122.447738107529) | |||
| 144474 | 144474 | 102871 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 173 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 769914 | 5998407.2 | 2093120.4 | 37.7272185530423 | -122.44773810752899 | (37.7272185530423, -122.447738107529) | ||||
| 35293 | 35293 | 204639 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 185 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998393.85271 | 2093179.60638 | 37.7273803570158 | -122.44778850934401 | (37.7273803570158, -122.447788509344) | ||||
| 157176 | 157176 | 175775 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 17 Paulding St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000241.49713 | 2093189.3269599997 | 37.7275124782167 | -122.44140191715799 | (37.7275124782167, -122.441401917158) | |||
| 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) | |||
| 142456 | 142456 | 51756 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1350 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2005 12:00:00 AM | Permit Number 48024 | 6016094.75384316 | 2092981.324561 | 37.727831736096796 | -122.386582102799 | (37.7278317360968, -122.386582102799) | |||
| 179570 | 179570 | 47485 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 165 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | 7 | Permit Number 45478 | 6001374.27527 | 2093423.0179299999 | 37.7282186079017 | -122.43750263124399 | (37.7282186079017, -122.437502631244) | |
| 174106 | 174106 | 47486 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 165 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | 10 | Permit Number 45383 | 6001387.26681 | 2093436.23595 | 37.7282556401779 | -122.437458665212 | (37.7282556401779, -122.437458665212) | ||
| 79995 | 79995 | 109185 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 198x JUDSON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998796.0 | 2093546.0 | 37.7284093651166 | -122.446424638984 | (37.7284093651166, -122.446424638984) | ||||
| 88418 | 88418 | 109186 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 198x JUDSON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998796.0 | 2093546.0 | 37.7284093651166 | -122.446424638984 | (37.7284093651166, -122.446424638984) |
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");