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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 120383 | 120383 | 95412 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2815 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 1 | 3x3 | Planted by Glen Park Public Library; will become DPW maintained after it is established. | 6002467.0 | 2095594.0 | 37.734241695714005 | -122.43388015504499 | (37.734241695714, -122.433880155045) | |
| 101889 | 101889 | 95411 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 1 | 3x3 | Planted by Glen Park Library; will become DPW maintained. | 6002467.0 | 2095594.0 | 37.734241695714005 | -122.43388015504499 | (37.734241695714, -122.433880155045) | |
| 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) | |||
| 159023 | 159023 | 114552 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1121 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777071 | 6011681.54455 | 2103150.14548 | 37.7555078447183 | -122.402553516927 | (37.7555078447183, -122.402553516927) | ||
| 115590 | 115590 | 63711 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 168 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2015 12:00:00 AM | 3x3 | Permit Number 776230 | 6007522.60556555 | 2100213.34826998 | 37.747211000323794 | -122.41672840745399 | (37.7472110003238, -122.416728407454) | ||
| 145034 | 145034 | 47724 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 Sycamore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2015 12:00:00 AM | 3 | Permit Number 774851 | 6006351.18478147 | 2105818.87737664 | 37.7625365339004 | -122.421177070604 | (37.7625365339004, -122.421177070604) | ||
| 139865 | 139865 | 114669 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 176X Peralta Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774564 | 6009847.7 | 2100071.6 | 37.7469522901695 | -122.408678376857 | (37.7469522901695, -122.408678376857) | |||
| 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) | ||||
| 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) | |
| 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) | |
| 93454 | 93454 | 108730 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1822-1898X 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773105 | 6013006.0 | 2102886.0 | 37.7548564119513 | -122.39795458116001 | (37.7548564119513, -122.39795458116) |
| 97552 | 97552 | 108723 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 764 Arkansas St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773103 | 6013016.81056 | 2103494.00722 | 37.7565264696642 | -122.39795984425301 | (37.7565264696642, -122.397959844253) | |
| 118416 | 118416 | 5139 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2895 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | Permit Number 772999 | 6002420.62305 | 2095396.7614900002 | 37.7336974920456 | -122.43402640033001 | (37.7336974920456, -122.43402640033) | ||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 184805 | 184805 | 95843 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 30 Sheridan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767866 | 6009338.07268 | 2109475.65364 | 37.7727451297231 | -122.411104783558 | (37.7727451297231, -122.411104783558) |
| 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) | |
| 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) |
| 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) |
| 177360 | 177360 | 95997 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 56 Neptune St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767648 | 6013070.55126 | 2094035.71681 | 37.730558997287396 | -122.39711080912501 | (37.7305589972874, -122.397110809125) |
| 135995 | 135995 | 43888 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767585 | 6009068.61437 | 2110555.25783 | 37.775694354731606 | -122.412113186199 | (37.7756943547316, -122.412113186199) |
| 149504 | 149504 | 95866 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 32 Sheridan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767584 | 6009326.62305 | 2109462.37063 | 37.7727080155855 | -122.411143450809 | (37.7727080155855, -122.411143450809) |
| 104860 | 104860 | 95797 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 907 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767539 | 6008624.3 | 2103231.6 | 37.7555603448561 | -122.413132208673 | (37.7555603448561, -122.413132208673) | |
| 95994 | 95994 | 95534 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3725 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767323 | 6004904.0 | 2102501.0 | 37.7533447323081 | -122.425946167651 | (37.7533447323081, -122.425946167651) | |
| 144250 | 144250 | 53646 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4122 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1970 12:00:00 AM | 4x4 | Permit Number 6582 | 6002264.58930584 | 2105323.26782976 | 37.760944481879996 | -122.435275644763 | (37.76094448188, -122.435275644763) | ||
| 87901 | 87901 | 94146 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1715 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53554 | 5992756.7 | 2103771.7 | 37.7561397565087 | -122.468046118338 | (37.7561397565087, -122.468046118338) | ||
| 50384 | 50384 | 43896 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 716 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51474 | 6009227.05246 | 2110468.55015 | 37.7754651643179 | -122.411558979885 | (37.7754651643179, -122.411558979885) | |
| 36944 | 36944 | 88065 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51066 | 6012481.79699 | 2096085.11316 | 37.7361534207291 | -122.399290043599 | (37.7361534207291, -122.399290043599) | |
| 152869 | 152869 | 88064 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51066 | 6012497.5295 | 2096095.3068099997 | 37.7361822871662 | -122.399236364881 | (37.7361822871662, -122.399236364881) | |
| 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) | |
| 118829 | 118829 | 82438 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 34 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50574 | 6003937.17383095 | 2095914.17170256 | 37.7352041342879 | -122.42882011216999 | (37.7352041342879, -122.42882011217) | ||
| 142365 | 142365 | 84181 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 186 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2008 12:00:00 AM | 3x3 | Permit Number 50119 | 6004433.25452855 | 2097264.30389086 | 37.738939357085 | -122.42720111980199 | (37.738939357085, -122.427201119802) | ||
| 91508 | 91508 | 82031 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 471 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49837 | 5998319.05661716 | 2095227.73962292 | 37.7329997723608 | -122.448194494208 | (37.7329997723608, -122.448194494208) | ||
| 188719 | 188719 | 53084 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 737 8TH & 9TH Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2006 12:00:00 AM | 2 | Permit Number 49051 | 6009184.03674 | 2110393.9636 | 37.7752579542298 | -122.411702510768 | (37.7752579542298, -122.411702510768) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 101753 | 101753 | 52421 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3987 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2005 12:00:00 AM | Permit Number 48541 | 6003110.11516472 | 2104732.93493797 | 37.7593715494171 | -122.43230918120899 | (37.7593715494171, -122.432309181209) | |||
| 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) |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 45681 | 45681 | 49816 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2003 12:00:00 AM | 12 | 3x3 | Permit Number 46737 | 6012410.64537 | 2104168.1082 | 37.758343624767605 | -122.400103532548 | (37.7583436247676, -122.400103532548) |
| 74849 | 74849 | 49815 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2003 12:00:00 AM | 11 | 3x3 | Permit Number 46737 | 6012411.853019999 | 2104156.1373900003 | 37.7583108228906 | -122.40009851524599 | (37.7583108228906, -122.400098515246) | |
| 55954 | 55954 | 49814 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46606 | 6012411.85736 | 2104145.59448 | 37.758281874620295 | -122.400097759826 | (37.7582818746203, -122.400097759826) | |
| 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) | ||
| 145192 | 145192 | 33403 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 384 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2003 12:00:00 AM | Permit Number 46425 | 5992447.80765363 | 2094243.66151518 | 37.729960344135996 | -122.468421188533 | (37.729960344136, -122.468421188533) | ||
| 90810 | 90810 | 49467 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3624 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46393 | 6006125.2277224995 | 2104366.11259234 | 37.7585348409416 | -122.421855375902 | (37.7585348409416, -122.421855375902) |
| 157003 | 157003 | 49416 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 17643RD/PHELPS La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2003 12:00:00 AM | 9 | Permit Number 46362 | 6014695.16416 | 2096823.71289 | 37.7383045729921 | -122.39168909330401 | (37.7383045729921, -122.391689093304) | ||
| 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) | ||
| 103622 | 103622 | 48643 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1481 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45936 | 5993334.71771315 | 2105415.01360696 | 37.7606852319988 | -122.466166570005 | (37.7606852319988, -122.466166570005) | ||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 72258 | 72258 | 47216 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 4 | Permit Number 45167 | 6008173.05313 | 2093488.0369799999 | 37.728781330768896 | -122.41400351077299 | (37.7287813307689, -122.414003510773) | |
| 98121 | 98121 | 47220 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 115878 | 115878 | 47217 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 120251 | 120251 | 47218 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 124336 | 124336 | 47221 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 173434 | 173434 | 47219 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45167 | 6008176.9578 | 2093476.05572 | 37.7287486521041 | -122.413989164793 | (37.7287486521041, -122.413989164793) | |
| 115328 | 115328 | 33376 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45124 | 5992405.97715527 | 2095379.41663179 | 37.7330764284901 | -122.46864840809799 | (37.7330764284901, -122.468648408098) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 115519 | 115519 | 46180 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 321 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44508 | 5996626.00544099 | 2106611.60599874 | 37.7641601102413 | -122.45487001246599 | (37.7641601102413, -122.454870012466) | ||
| 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) | |||
| 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) | |||
| 140779 | 140779 | 45706 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 184 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) | |||
| 123083 | 123083 | 45279 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 615 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44121 | 6008007.34922264 | 2096035.79545566 | 37.735767615578204 | -122.414756594978 | (37.7357676155782, -122.414756594978) | ||
| 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) | |||
| 3796 | 3796 | 182316 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2726 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2001 12:00:00 AM | 3 | Width 0ft | Permit Number 43905 | 5986380.5744 | 2105064.6172 | 37.759319468361 | -122.490191716108 | (37.759319468361, -122.490191716108) | |
| 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) | |
| 136013 | 136013 | 44808 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1371 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | 4 | Permit Number 43903 | 5986465.0991 | 2105937.0115 | 37.7617197583894 | -122.489963557407 | (37.7617197583894, -122.489963557407) | |
| 124162 | 124162 | 44717 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1991 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | Permit Number 43839 | 5989704.86545465 | 2101822.42727681 | 37.7506108546658 | -122.47845774312599 | (37.7506108546658, -122.478457743126) | ||
| 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) |
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");