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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114447 | 114447 | 52659 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 501@ SCOTT Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 8 | Permit Number 48739 | 6000536.81736 | 2121641.57816 | 37.8056520959413 | -122.44242280508999 | (37.8056520959413, -122.44242280509) | ||
| 53683 | 53683 | 125881 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2101 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001760.22052 | 2119747.88013 | 37.8005221579273 | -122.438053316704 | (37.8005221579273, -122.438053316704) | |||
| 5901 | 5901 | 13142 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1799 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 70 | 3X3 | 6003833.3629 | 2119660.0062 | 37.8003985594643 | -122.43087313241999 | (37.8003985594643, -122.43087313242) | ||
| 172086 | 172086 | 125890 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 8 Sharp Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007493.35542 | 2119123.01732 | 37.799130814105794 | -122.41816997447799 | (37.7991308141058, -122.418169974478) | |||
| 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) | ||||||
| 7463 | 7463 | 52815 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2760 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773616 | 6000112.35725 | 2118047.78661 | 37.7957603016641 | -122.44363337348999 | (37.7957603016641, -122.44363337349) | |
| 29847 | 29847 | 125882 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2100 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6005138.856380001 | 2116964.61432 | 37.7930715805281 | -122.42616360296302 | (37.7930715805281, -122.426163602963) | |||
| 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) | |
| 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) | |||
| 54695 | 54695 | 52371 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.78967044259821 | -122.41321087889901 | (37.7896704425982, -122.413210878899) |
| 160140 | 160140 | 113225 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 970JONES Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | 6008828.65356 | 2115644.6839900003 | 37.7896552332384 | -122.413303262628 | (37.7896552332384, -122.413303262628) | ||
| 5538 | 5538 | 27609 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2695 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2000 12:00:00 AM | 3 | 3x3 | 6001941.56922 | 2115683.47507 | 37.7893726707572 | -122.437134613375 | (37.7893726707572, -122.437134613375) | ||
| 135943 | 135943 | 96017 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767661 | 6008768.28006 | 2115323.27409 | 37.7887693299764 | -122.413489408823 | (37.7887693299764, -122.413489408823) |
| 131619 | 131619 | 96016 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767661 | 6008769.14714 | 2115306.341 | 37.788722884506996 | -122.41348521078999 | (37.788722884507, -122.41348521079) |
| 19179 | 19179 | 96019 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 91224 | 91224 | 96020 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 125086 | 125086 | 96018 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 5700 | 5700 | 107235 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008834.66692 | 2115296.44284 | 37.788699385205796 | -122.413257820814 | (37.7886993852058, -122.413257820814) | |||
| 40087 | 40087 | 125883 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008823.04151 | 2115295.3212900003 | 37.7886956530184 | -122.413297963833 | (37.7886956530184, -122.413297963833) | |||
| 32397 | 32397 | 125884 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008808.31826 | 2115292.9035099996 | 37.7886881877568 | -122.413348733254 | (37.7886881877568, -122.413348733254) | |||
| 126232 | 126232 | 45238 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 871 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2001 12:00:00 AM | Permit Number 44088 | 6008421.36689101 | 2115188.65226849 | 37.7883802062735 | -122.414680152021 | (37.7883802062735, -122.414680152021) | |||
| 22702 | 22702 | 21528 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1300 Sutter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2007 12:00:00 AM | 3 | 4X4 | 6006219.829580001 | 2114935.40618 | 37.787560918141295 | -122.422279128893 | (37.7875609181413, -122.422279128893) | ||
| 110296 | 110296 | 84731 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 72 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2007 12:00:00 AM | Permit No. 49232 | 6013473.0 | 2114579.0 | 37.7869887683946 | -122.397159425184 | (37.7869887683946, -122.397159425184) | |||
| 98722 | 98722 | 48359 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1400X Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | 7 | 3x3 | Permit Number 45770 | 6005451.0 | 2114476.0 | 37.78625610570921 | -122.424906431455 | (37.7862561057092, -122.424906431455) | |
| 173464 | 173464 | 34932 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2770 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/1997 12:00:00 AM | 5 | Permit Number 38524 | 6000272.2691 | 2114453.3621 | 37.785900071213604 | -122.442821815392 | (37.7859000712136, -122.442821815392) | ||
| 57424 | 57424 | 125888 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 575 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008045.66737 | 2113749.49498 | 37.784407514645096 | -122.415878065725 | (37.7844075146451, -122.415878065725) | |||
| 100719 | 100719 | 114307 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 595 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008020.0 | 2113749.0 | 37.7844047125189 | -122.415966831143 | (37.7844047125189, -122.415966831143) | ||||
| 166001 | 166001 | 48441 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2399 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2002 12:00:00 AM | 5 | Permit Number 45814 | 6000736.2676 | 2113774.3561 | 37.784062137114 | -122.44116777895901 | (37.784062137114, -122.441167778959) | ||
| 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) | |||
| 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) | |||
| 111947 | 111947 | 48438 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2399 Post St | 5 | 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) | |||
| 122246 | 122246 | 48437 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2399 Post St | 6 | 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) | |||
| 144559 | 144559 | 48440 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2399 Post St | 3 | 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) | |||
| 162660 | 162660 | 139384 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1492 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000711.3822 | 2113738.0773 | 37.7839611073263 | -122.441251269333 | (37.7839611073263, -122.441251269333) | |||
| 173337 | 173337 | 139383 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000714.3804 | 2113723.086 | 37.7839201158586 | -122.441239820711 | (37.7839201158586, -122.441239820711) | |||
| 180340 | 180340 | 139382 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1480 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000715.5797 | 2113708.6945 | 37.7838806688155 | -122.441234638662 | (37.7838806688155, -122.441234638662) | |||
| 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) | |||
| 187433 | 187433 | 139381 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1470 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000719.1776 | 2113696.7015 | 37.7838479440673 | -122.44122133052299 | (37.7838479440673, -122.441221330523) | |||
| 154491 | 154491 | 139380 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1460 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000719.7772 | 2113684.7085 | 37.7838150485268 | -122.441218395368 | (37.7838150485268, -122.441218395368) | |||
| 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) | |||
| 124221 | 124221 | 44343 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 233 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2001 12:00:00 AM | Permit Number 43727 | 5991164.04904901 | 2113857.0036857 | 37.7837391697575 | -122.47428989169201 | (37.7837391697575, -122.474289891692) | |||
| 27384 | 27384 | 39767 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 476 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 3 | 2x2 | Permit Number 42916 | 6008173.90648 | 2113469.9166 | 37.7836470686025 | -122.41541460189899 | (37.7836470686025, -122.415414601899) |
| 63601 | 63601 | 125885 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 476 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008153.2935 | 2113467.57124 | 37.7836394702246 | -122.415485749065 | (37.7836394702246, -122.415485749065) | |||
| 107624 | 107624 | 24238 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 200X Willow St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1999 12:00:00 AM | 6 | 4X4 | 6006547.3507 | 2113418.3192 | 37.7834138390239 | -122.421038210119 | (37.7834138390239, -122.421038210119) | ||
| 148883 | 148883 | 43665 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 241 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 3 | Permit Number 43308 | 5992118.30424 | 2113674.27096 | 37.7832926725519 | -122.47097524296001 | (37.7832926725519, -122.47097524296) | |
| 4444 | 4444 | 24256 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 203 Willow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2014 12:00:00 AM | 3 | 2x3 | 6006439.8092 | 2113362.67149 | 37.783254981274204 | -122.421406308981 | (37.7832549812742, -122.421406308981) | ||
| 47450 | 47450 | 125886 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 260 Willow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006255.845480001 | 2113363.12878 | 37.7832458630397 | -122.42204278345699 | (37.7832458630397, -122.422042783457) | |||
| 46851 | 46851 | 125887 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 277 Willow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006289.37196 | 2113344.7288599997 | 37.7831972322057 | -122.42192548758301 | (37.7831972322057, -122.421925487583) | |||
| 181394 | 181394 | 125880 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Emerson St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5998726.98974 | 2113474.62388 | 37.783124495049 | -122.448097535281 | (37.783124495049, -122.448097535281) | |||
| 93893 | 93893 | 24248 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 265X Willow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/1990 12:00:00 AM | 3 | 4x4 | 6006141.132777 | 2113311.4044124 | 37.783097370149 | -122.422435967678 | (37.783097370149, -122.422435967678) | ||
| 135094 | 135094 | 125879 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Emerson St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5998729.9299099995 | 2113444.41319 | 37.7830417124478 | -122.448085187582 | (37.7830417124478, -122.448085187582) | |||
| 7114 | 7114 | 45767 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997811.6954 | 2113198.143 | 37.782312986330794 | -122.45124412099399 | (37.7823129863308, -122.451244120994) |
| 7399 | 7399 | 45765 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997815.0796 | 2113173.4382 | 37.782245347199996 | -122.451230630986 | (37.7822453472, -122.451230630986) | |
| 179896 | 179896 | 56330 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2526 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/1973 12:00:00 AM | 8 | Permit Number 12466 | 5987579.5629 | 2113304.9613200002 | 37.7820151066388 | -122.48665015476801 | (37.7820151066388, -122.486650154768) | ||
| 102550 | 102550 | 22595 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1992 12:00:00 AM | 6 | 4x4 | 6006111.721580001 | 2112834.13473 | 37.7817852453704 | -122.42250379427601 | (37.7817852453704, -122.422503794276) | ||
| 175592 | 175592 | 125889 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006091.49195 | 2112832.09387 | 37.781778500422 | -122.42257363436501 | (37.781778500422, -122.422573634365) | |||
| 131805 | 131805 | 71996 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 340 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1989 12:00:00 AM | 7 | 5989363.9833 | 2113075.9914599997 | 37.7814902817874 | -122.48046018125 | (37.7814902817874, -122.48046018125) | ||
| 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) | |
| 178155 | 178155 | 71997 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 362 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1989 12:00:00 AM | 6 | 5989369.28583 | 2112922.15861 | 37.7810682079879 | -122.48043057365 | (37.7810682079879, -122.48043057365) | ||
| 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) | |
| 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) | |
| 131758 | 131758 | 63193 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 435 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 12 | Permit Number 23733 | 5984052.79771 | 2112895.3666 | 37.78068425281221 | -122.498820690126 | (37.7806842528122, -122.498820690126) | |
| 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) | ||
| 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) | ||
| 169372 | 169372 | 35219 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 896 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1998 12:00:00 AM | 7 | Permit Number 38722 | 6011641.6488 | 2112229.3585 | 37.7804350816614 | -122.403330167353 | (37.7804350816614, -122.403330167353) | ||
| 111008 | 111008 | 116626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 5732X GEARY BLVD | 7 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5989254.0 | 2112678.0 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | |||
| 5851 | 5851 | 9507 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 935 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005077.1287 | 2112297.1038 | 37.7802522713917 | -122.42604476220501 | (37.7802522713917, -122.426044762205) | |||
| 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) | |||||
| 125272 | 125272 | 110420 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 419X 18TH AVE | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | |||
| 5163 | 5163 | 12318 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 999 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1997 12:00:00 AM | 6 | 4X4 | 6004783.3056 | 2112237.6551 | 37.7800724294036 | -122.427056996678 | (37.7800724294036, -122.427056996678) | ||
| 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) | ||||
| 83292 | 83292 | 56149 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 426 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 18 | 4x4 | Permit Number 12256 | 5990938.77862 | 2112472.88916 | 37.7799257212488 | -122.474968166346 | (37.7799257212488, -122.474968166346) | |
| 91494 | 91494 | 26491 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 912X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1998 12:00:00 AM | 6 | 4X4 | 6004848.1679 | 2112085.98552 | 37.7796596496687 | -122.426821804086 | (37.7796596496687, -122.426821804086) | ||
| 135324 | 135324 | 139823 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 903 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004856.1173 | 2112030.4835 | 37.7795077042444 | -122.42679034995899 | (37.7795077042444, -122.426790349959) | |||
| 113808 | 113808 | 89718 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1655 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5993507.69164 | 2112056.80986 | 37.778931820846296 | -122.46605098131501 | (37.7789318208463, -122.466050981315) | ||
| 154132 | 154132 | 123824 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1665 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993487.5757 | 2112056.30859 | 37.7789292839599 | -122.466120533372 | (37.7789292839599, -122.466120533372) | |||
| 179630 | 179630 | 141961 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 861 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004842.0409 | 2111803.9569 | 37.7788849220533 | -122.426822909349 | (37.7788849220533, -122.426822909349) | |||
| 115008 | 115008 | 12297 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 861 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2004 12:00:00 AM | 3 | 4X4 | 6004837.02716 | 2111802.36626 | 37.778880271067294 | -122.426840140564 | (37.7788802710673, -122.426840140564) | ||
| 168361 | 168361 | 123817 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1925 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992665.27685 | 2112027.3966200002 | 37.7788024241016 | -122.468963063439 | (37.7788024241016, -122.468963063439) | |||
| 161465 | 161465 | 30509 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1925 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 12 | Permit Number 34522 | 5992647.92392 | 2112025.91365 | 37.7787973496586 | -122.46902298556002 | (37.7787973496586, -122.46902298556) | ||
| 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) | |
| 122560 | 122560 | 12293 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 841X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2002 12:00:00 AM | 3 | 4X4 | 6004846.05575 | 2111737.27176 | 37.7787020480516 | -122.42680427007099 | (37.7787020480516, -122.426804270071) | ||
| 30793 | 30793 | 141963 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 841 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004850.8791 | 2111736.5633 | 37.7787003755045 | -122.42678753375401 | (37.7787003755045, -122.426787533754) | |||
| 146218 | 146218 | 12283 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 803X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | ||
| 175309 | 175309 | 141965 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 803 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004856.9254 | 2111690.3911 | 37.7785739398403 | -122.426763328248 | (37.7785739398403, -122.426763328248) | |||
| 117131 | 117131 | 31678 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 568 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35184 | 5984441.54106734 | 2111980.46046246 | 37.7781949786835 | -122.497408297818 | (37.7781949786835, -122.497408297818) | |||
| 158243 | 158243 | 119916 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3801 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5986867.2095099995 | 2111818.56024 | 37.777892319492295 | -122.489005232889 | (37.7778923194923, -122.489005232889) | |||
| 123294 | 123294 | 112175 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 607 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5986883.70014 | 2111802.41515 | 37.7778489521099 | -122.488946999613 | (37.7778489521099, -122.488946999613) | |||
| 176616 | 176616 | 112176 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 607 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 5986882.73557 | 2111785.73395 | 37.7778030939685 | -122.48894910976601 | (37.7778030939685, -122.488949109766) | |||
| 4793 | 4793 | 12272 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 700X Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1997 12:00:00 AM | 3 | 3X3 | 6004950.3992 | 2111308.9655 | 37.7775319231116 | -122.426412801229 | (37.7775319231116, -122.426412801229) | ||
| 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) | |
| 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) | |||
| 8678 | 8678 | 26493 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 519 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004978.6865 | 2110816.0585 | 37.776180120030205 | -122.42627984394699 | (37.7761801200302, -122.426279843947) | |||
| 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) | |||
| 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) |
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");