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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3320 | 3320 | 56733 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1583 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Permit Number 780681 | 6015469.0433 | 2095825.5988 | 37.7356068823061 | -122.388943710821 | (37.7356068823061, -122.388943710821) | |||
| 10695 | 10695 | 27041 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 708 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1999 12:00:00 AM | 7 | 6006055.4905900005 | 2093548.93813 | 37.728829392352 | -122.42132839800199 | (37.728829392352, -122.421328398002) | |||
| 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) | |||
| 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) | ||||
| 26719 | 26719 | 44280 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1588 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014158.826330001 | 2095418.03078 | 37.734415072582 | -122.393445153596 | (37.734415072582, -122.393445153596) | ||
| 27183 | 27183 | 48442 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2399 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | |||
| 29332 | 29332 | 61172 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 346 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 11 | Permit Number 27084 | 5989366.0565 | 2113024.18126 | 37.781348145965296 | -122.480449215491 | (37.7813481459653, -122.480449215491) | |
| 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) | ||||
| 32793 | 32793 | 67326 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 714 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 12 | Permit Number 30809 | 5993329.61616 | 2111427.9815700003 | 37.7771949529998 | -122.466621290245 | (37.7771949529998, -122.466621290245) | |
| 34144 | 34144 | 71268 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1733 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 13 | 5999451.8492 | 2110818.1122 | 37.775871807627 | -122.445398751236 | (37.775871807627, -122.445398751236) | ||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 36392 | 36392 | 44281 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1588 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2001 12:00:00 AM | 7 | Permit Number 43704 | 6014169.386469999 | 2095432.395 | 37.734455100518 | -122.393409648353 | (37.734455100518, -122.393409648353) | ||
| 37729 | 37729 | 247042 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6002114.968169999 | 2099165.77298 | 37.7440289718731 | -122.43535264990601 | (37.7440289718731, -122.435352649906) | ||||
| 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) | ||
| 39548 | 39548 | 72980 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1730 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1999 12:00:00 AM | 7 | 5987835.4413 | 2103488.2738 | 37.7550761133303 | -122.48504448823499 | (37.7550761133303, -122.485044488235) | ||
| 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) | |
| 40373 | 40373 | 37238 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | 11 | Permit Number 770085 | 5987346.2909 | 2103736.5081 | 37.755729192821704 | -122.48675431687 | (37.7557291928217, -122.48675431687) | ||
| 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) | ||||
| 41975 | 41975 | 65113 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 363 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 10 | Permit Number 27082 | 5989323.435380001 | 2112903.08855 | 37.781013182321104 | -122.480587794991 | (37.7810131823211, -122.480587794991) | |
| 42881 | 42881 | 78349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5986607.90066 | 2110854.65361 | 37.7752305672016 | -122.489831352395 | (37.7752305672016, -122.489831352395) | ||
| 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) | ||||
| 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) | ||
| 45847 | 45847 | 43213 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 361 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 3 | Permit Number 43004 | 6008709.78977 | 2094511.79844 | 37.7316224914874 | -122.41222029725 | (37.7316224914874, -122.41222029725) | |
| 46438 | 46438 | 38557 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1511 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 12 | Permit Number 40522 | 6015824.3664 | 2095556.8722 | 37.7348887022439 | -122.38769646850001 | (37.7348887022439, -122.3876964685) | |
| 46843 | 46843 | 54597 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 630 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 19 | Permit Number 10420 | 6014092.76415 | 2104176.14538 | 37.7584593387525 | -122.394286543097 | (37.7584593387525, -122.394286543097) | ||
| 47820 | 47820 | 70445 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2471 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 5 | 5982997.1409 | 2098317.8833 | 37.740596640895795 | -122.501394010052 | (37.7405966408958, -122.501394010052) | ||
| 50086 | 50086 | 113271 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1321 Revere Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 774420 | 6016529.9 | 2093260.0 | 37.7286210040554 | -122.38509718743299 | (37.7286210040554, -122.385097187433) | ||||
| 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) | ||
| 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) | ||
| 51501 | 51501 | 44809 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1371 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 3 | Permit Number 43903 | 5986466.0604 | 2105911.3769 | 37.7616494289947 | -122.48995834721501 | (37.7616494289947, -122.489958347215) | |
| 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) | ||||
| 60387 | 60387 | 35218 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 896 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1998 12:00:00 AM | 5 | Permit Number 40401 | 6011658.1335 | 2112244.4696 | 37.780477493902204 | -122.403274202035 | (37.7804774939022, -122.403274202035) | ||
| 61588 | 61588 | 56137 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 767 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 23 | Permit Number 12241 | 6012457.22858 | 2104373.65416 | 37.7589106059655 | -122.399956860327 | (37.7589106059655, -122.399956860327) | ||
| 64059 | 64059 | 52490 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48600 | 6008167.536314401 | 2096496.40585448 | 37.7370413503065 | -122.414235342537 | (37.7370413503065, -122.414235342537) | ||
| 64789 | 64789 | 56717 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1526 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6015787.6443 | 2095659.5423 | 37.735168579406704 | -122.387830592307 | (37.7351685794067, -122.387830592307) | ||||
| 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) | |
| 67038 | 67038 | 69446 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 443 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 10 | Permit Number 33556 | 5985911.814680001 | 2112907.20872 | 37.7808256288006 | -122.492390419974 | (37.7808256288006, -122.492390419974) | |
| 67302 | 67302 | 32207 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1760 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 9 | Permit Number 35529 | 6009303.23325 | 2099186.73635 | 37.7444921398121 | -122.41049862882 | (37.7444921398121, -122.41049862882) | |
| 67811 | 67811 | 42713 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1740 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 8 | Permit Number 42726 | 6014522.39227 | 2095210.25322 | 37.7338647513416 | -122.392173650716 | (37.7338647513416, -122.392173650716) | |
| 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) | ||
| 70052 | 70052 | 47793 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2578 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2002 12:00:00 AM | 3 | Permit Number 45565 | 5987410.8144 | 2097738.044 | 37.7392627758453 | -122.48609086811899 | (37.7392627758453, -122.486090868119) | |
| 72162 | 72162 | 38103 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1339 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 6 | Permit Number 40274 | 5987697.8486 | 2106168.016 | 37.7624259403231 | -122.48571698139601 | (37.7624259403231, -122.485716981396) | |
| 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) | |
| 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) | ||
| 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) | |
| 75181 | 75181 | 66828 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 154 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1992 12:00:00 AM | 5 | Permit Number 30314 | 5996849.4776 | 2111929.315 | 37.7787739785332 | -122.454481262068 | (37.7787739785332, -122.454481262068) | |
| 75444 | 75444 | 43894 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 716 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2000 12:00:00 AM | 6 | Permit Number 43499 | 6009202.88564 | 2110443.77487 | 37.7753957816152 | -122.41164082808399 | (37.7753957816152, -122.411640828084) | ||
| 75941 | 75941 | 73418 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2483 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 3 | 5983001.5767 | 2098246.6338 | 37.740401269768796 | -122.50137340388001 | (37.7404012697688, -122.50137340388) | ||
| 76460 | 76460 | 65960 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2514 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | 11 | Permit Number 28982 | 5988016.2527 | 2098169.589 | 37.740482951266706 | -122.48402919603399 | (37.7404829512667, -122.484029196034) | |
| 76976 | 76976 | 43212 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 357 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 6 | Permit Number 43003 | 6008732.269730001 | 2094519.16075 | 37.7316439681866 | -122.412143099436 | (37.7316439681866, -122.412143099436) | |
| 78132 | 78132 | 34342 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 12661268 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38099 | 6010039.0 | 2101826.0 | 37.7517801982502 | -122.408140586549 | (37.7517801982502, -122.408140586549) | ||
| 78376 | 78376 | 36468 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1469 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39366 | 5995883.06149021 | 2093810.4895036 | 37.728968784247705 | -122.456513863949 | (37.7289687842477, -122.456513863949) | ||
| 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) | |||||
| 79164 | 79164 | 48439 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2399 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | |||
| 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) | ||
| 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) | ||
| 79873 | 79873 | 45707 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 188 Graystone Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44380 | 5999327.035480901 | 2103995.03426473 | 37.757130224218294 | -122.44533981581499 | (37.7571302242183, -122.445339815815) | |||
| 80412 | 80412 | 99239 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | ||||
| 80441 | 80441 | 38322 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1303 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40379 | 6006986.09982569 | 2107885.23558278 | 37.7682460414156 | -122.419127704144 | (37.7682460414156, -122.419127704144) | ||
| 80681 | 80681 | 110721 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1898X 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | |||||
| 80878 | 80878 | 108581 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1X GARDENSIDE DR | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5999463.0 | 2102872.0 | 37.7540544083949 | -122.44478887768 | (37.7540544083949, -122.44478887768) | |||||
| 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) | |||||
| 82171 | 82171 | 46798 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 151 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44888 | 5994310.21524684 | 2095607.50798883 | 37.7338125312017 | -122.46208153607701 | (37.7338125312017, -122.462081536077) | ||
| 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) | ||
| 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) | |||
| 82749 | 82749 | 46346 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2002 12:00:00 AM | Permit Number 44592 | 6005461.4442402 | 2101476.38644964 | 37.7505628685682 | -122.423945552398 | (37.7505628685682, -122.423945552398) | ||
| 83355 | 83355 | 40737 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 163 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1999 12:00:00 AM | Permit Number 41716 | 6009144.8463962 | 2096601.1649491 | 37.737383844528 | -122.410863725513 | (37.737383844528, -122.410863725513) | ||
| 84181 | 84181 | 100793 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Recently planted by FUF. | 6008363.0 | 2103862.0 | 37.757276607365604 | -122.414080464335 | (37.7572766073656, -122.414080464335) | ||||
| 84469 | 84469 | 33577 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 190 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37685 | 6007025.08907683 | 2097945.62097714 | 37.740956334538204 | -122.418288026055 | (37.7409563345382, -122.418288026055) | |||
| 84601 | 84601 | 49808 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1546ARKANSAS 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | Permit Number 46602 | 6013062.18652198 | 2105692.25425348 | 37.7625649012206 | -122.397957118424 | (37.7625649012206, -122.397957118424) | ||
| 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) | ||
| 89747 | 89747 | 39705 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 El Verano Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | ||
| 90159 | 90159 | 104807 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2069 GREEN ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003141.4 | 2118171.7 | 37.796272826569705 | -122.433161198258 | (37.7962728265697, -122.433161198258) | ||||||
| 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) | ||
| 90738 | 90738 | 48736 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1633 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2002 12:00:00 AM | Permit Number 46017 | 6015017.13579754 | 2095815.21126112 | 37.7355533009373 | -122.39050541553001 | (37.7355533009373, -122.39050541553) | ||
| 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) | ||||
| 91549 | 91549 | 42943 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2517 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42837 | 6008896.604309599 | 2103802.00203994 | 37.7571418228984 | -122.412230804785 | (37.7571418228984, -122.412230804785) | ||
| 91837 | 91837 | 38107 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1295 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | ||
| 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) | ||
| 93468 | 93468 | 43897 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 714 Tehama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2000 12:00:00 AM | Permit Number 43499 | 6009277.55531704 | 2110532.12490079 | 37.7756425583487 | -122.41138877012399 | (37.7756425583487, -122.411388770124) | |||
| 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) | ||
| 95289 | 95289 | 37234 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 95376 | 95376 | 45782 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 243 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2001 12:00:00 AM | Permit Number 44422 | 5992531.14944144 | 2097322.97472388 | 37.738420181663706 | -122.46835700549299 | (37.7384201816637, -122.468357005493) | |||
| 95392 | 95392 | 37236 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200X Moraga St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 03/26/2013 12:00:00 AM | Permit Number 770085 | 5987459.55498562 | 2104367.82715752 | 37.757469225946295 | -122.48640896705601 | (37.7574692259463, -122.486408967056) | |||
| 95766 | 95766 | 39704 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 El Verano Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | ||
| 95796 | 95796 | 32334 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 150 Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | Permit Number 36897 | 6000779.60429895 | 2103438.99609434 | 37.7556862897816 | -122.440276412657 | (37.7556862897816, -122.440276412657) | |||
| 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) | ||
| 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) | ||
| 98316 | 98316 | 41261 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 136 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41948 | 6003783.84120513 | 2096452.6287084 | 37.73667393521 | -122.429388624637 | (37.73667393521, -122.429388624637) | |||
| 98635 | 98635 | 32867 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 593 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37213 | 6001338.28217306 | 2101417.26764603 | 37.7501669020767 | -122.438199507309 | (37.7501669020767, -122.438199507309) | ||
| 98960 | 98960 | 33524 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37634 | 6007216.6223638 | 2097938.08467402 | 37.740946421126 | -122.417625238841 | (37.740946421126, -122.417625238841) | |||
| 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) | ||
| 100338 | 100338 | 33375 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | Permit Number 37501 | 5992405.97715527 | 2095379.41663179 | 37.7330764284901 | -122.46864840809799 | (37.7330764284901, -122.468648408098) | |||
| 100533 | 100533 | 63555 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2979 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/2012 12:00:00 AM | Permit Number 768997 | 6008364.95764339 | 2103853.79348965 | 37.7572541841117 | -122.414073113457 | (37.7572541841117, -122.414073113457) | ||
| 100585 | 100585 | 52491 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2005 12:00:00 AM | Permit Number 48600 | 6008167.536314401 | 2096496.40585448 | 37.7370413503065 | -122.414235342537 | (37.7370413503065, -122.414235342537) | |||
| 101221 | 101221 | 33575 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 166 Bonview St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37683 | 6007091.70402672 | 2098068.82881396 | 37.7412983853712 | -122.418066427995 | (37.7412983853712, -122.418066427995) |
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");