Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▲ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13487 | 13487 | 108687 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1076 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2014 12:00:00 AM | 3 | Permit Number 773107 | 6012169.21632 | 2103384.1046599997 | 37.756177459246295 | -122.400883423742 | (37.7561774592463, -122.400883423742) | |
| 19496 | 19496 | 34866 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 579 Miramar Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | FUF 1 | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | ||
| 115036 | 115036 | 114984 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 742 Myra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | Permit Number 776077 | 5997484.7 | 2098018.8 | 37.7406156184733 | -122.451280290868 | (37.7406156184733, -122.451280290868) | |||
| 81356 | 81356 | 39618 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 172 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41018 | 5997530.61215046 | 2106784.14607791 | 37.7646857112231 | -122.45175370217501 | (37.7646857112231, -122.451753702175) | ||
| 97810 | 97810 | 39633 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1122 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41028 | 5997349.94347033 | 2106507.7642786 | 37.7639164882009 | -122.45235863889499 | (37.7639164882009, -122.452358638895) | ||
| 109582 | 109582 | 39619 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 172 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41018 | 5997530.61215046 | 2106784.14607791 | 37.7646857112231 | -122.45175370217501 | (37.7646857112231, -122.451753702175) | ||
| 122631 | 122631 | 39621 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 182 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41020 | 5997442.59216628 | 2106771.88048484 | 37.7646469915575 | -122.452057253483 | (37.7646469915575, -122.452057253483) | ||
| 124795 | 124795 | 39620 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 176 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41019 | 5997495.40415115 | 2106779.2398399 | 37.764670223448206 | -122.45187512275601 | (37.7646702234482, -122.451875122756) | ||
| 145133 | 145133 | 39638 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 555 Arch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41032 | 5992713.01716207 | 2090887.82450944 | 37.7207613551784 | -122.46726042451 | (37.7207613551784, -122.46726042451) | ||
| 44068 | 44068 | 68959 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1802 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32948 | 5989942.73777 | 2111303.8332599998 | 37.7766580439621 | -122.47832837215799 | (37.7766580439621, -122.478328372158) | ||
| 95931 | 95931 | 68899 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4400 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6x6 | Permit Number 32872 | 6001420.14325733 | 2104691.52750308 | 37.7591618858697 | -122.438150951669 | (37.7591618858697, -122.438150951669) | |
| 114811 | 114811 | 68903 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4427 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | Permit Number 32876 | 6001346.92475153 | 2104635.29348212 | 37.7590033165136 | -122.438400146932 | (37.7590033165136, -122.438400146932) | ||
| 168816 | 168816 | 95128 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 242 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54055 | 6002055.39922 | 2094202.25805 | 37.7303969250626 | -122.43520367542801 | (37.7303969250626, -122.435203675428) |
| 98278 | 98278 | 52498 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 373 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48607 | 6007154.65178245 | 2096037.38640136 | 37.7357240368215 | -122.417704822788 | (37.7357240368215, -122.417704822788) | ||
| 3486 | 3486 | 39483 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 6472 | 6472 | 39482 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 13680 | 13680 | 39555 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 15 | Permit Number 40979 | 6013094.503190001 | 2106943.24687 | 37.766001649682 | -122.397933106026 | (37.766001649682, -122.397933106026) | ||
| 14104 | 14104 | 39557 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40979 | 6013095.63903 | 2106895.18187 | 37.7658697371335 | -122.39792580534599 | (37.7658697371335, -122.397925805346) | ||
| 14684 | 14684 | 39553 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013090.35036 | 2107006.086 | 37.7661739606766 | -122.39795187847601 | (37.7661739606766, -122.397951878476) | ||
| 15266 | 15266 | 39554 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013090.01553 | 2106989.57845 | 37.7661286159676 | -122.397951878486 | (37.7661286159676, -122.397951878486) | ||
| 15269 | 15269 | 39556 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013089.54039 | 2107025.61956 | 37.7662275503778 | -122.397956050431 | (37.7662275503778, -122.397956050431) | ||
| 16886 | 16886 | 39481 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 0 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | Permit Number 40941 | ||||||||
| 123051 | 123051 | 39489 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3893 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40947 | 6003866.46207522 | 2101853.99403023 | 37.751509514928706 | -122.42948805151501 | (37.7515095149287, -122.429488051515) | ||
| 96528 | 96528 | 68858 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 270 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1993 12:00:00 AM | 7x5 | Permit Number 32821 | 5999625.60484237 | 2094393.46674957 | 37.730783660166395 | -122.443617519141 | (37.7307836601664, -122.443617519141) | |
| 124042 | 124042 | 49701 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3224@ PRECITA Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | Permit Number 46520 | 6008982.54318387 | 2099905.81339366 | 37.7464485829446 | -122.411658311185 | (37.7464485829446, -122.411658311185) | ||
| 142305 | 142305 | 52025 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1260 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/25/2005 12:00:00 AM | Permit Number 48240 | 5995504.32582214 | 2106976.03067238 | 37.765096319079106 | -122.45877593821999 | (37.7650963190791, -122.45877593822) | ||
| 118799 | 118799 | 17789 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1825 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/25/2004 12:00:00 AM | 3 | 3x3 | 6005197.610669999 | 2115437.17336 | 37.7888809321851 | -122.42585153543699 | (37.7888809321851, -122.425851535437) | ||
| 39071 | 39071 | 114959 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 517 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | 1 | Permit Number 776031 | 6002108.88292 | 2086505.1138400002 | 37.7092653220046 | -122.43446864782801 | (37.7092653220046, -122.434468647828) | ||
| 10913 | 10913 | 54811 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 179 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774552 | 6009584.74153 | 2095040.5771599999 | 37.7331234617736 | -122.409232703537 | (37.7331234617736, -122.409232703537) | |
| 12388 | 12388 | 108548 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 231 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773712 | 6001628.81735 | 2093873.1155299998 | 37.7294689416254 | -122.436654875418 | (37.7294689416254, -122.436654875418) |
| 85464 | 85464 | 114955 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 50 Circular Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/23/2015 12:00:00 AM | Permit Number 776076 | 6001248.1 | 2094471.5 | 37.7310903246371 | -122.43801389501199 | (37.7310903246371, -122.438013895012) | |||
| 86801 | 86801 | 108496 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1331 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773640 | 5992376.99621 | 2106387.92207 | 37.7633012798944 | -122.469549692534 | (37.7633012798944, -122.469549692534) |
| 19552 | 19552 | 50938 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4752 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | Permit Number 48543 | 5998450.03825367 | 2105698.06494287 | 37.7617562199837 | -122.44849544098601 | (37.7617562199837, -122.448495440986) | ||
| 41012 | 41012 | 52441 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2231 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 7 | Permit Number 48552 | 6002319.04609 | 2115938.04243 | 37.7900930969695 | -122.43584681030501 | (37.7900930969695, -122.435846810305) | |
| 174564 | 174564 | 101713 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3337 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769456 | 5998828.122819999 | 2115578.65478 | 37.788907393020295 | -122.447899187116 | (37.7889073930203, -122.447899187116) | |
| 96606 | 96606 | 39362 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2433 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | Permit Number 40917 | 6008235.29946712 | 2104260.15851816 | 37.7583626864034 | -122.41455027836001 | (37.7583626864034, -122.41455027836) | ||
| 25529 | 25529 | 81905 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2999 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50026 | 5999847.61488 | 2116692.12916 | 37.7920229215711 | -122.44445195079099 | (37.7920229215711, -122.444451950791) | |
| 116620 | 116620 | 81904 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2266X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50026 | 5999807.10049019 | 2116693.18861925 | 37.7920235188379 | -122.444592206646 | (37.7920235188379, -122.444592206646) | |
| 143663 | 143663 | 82026 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4657 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50028 | 6000147.95764033 | 2105151.97717561 | 37.7603537323491 | -122.442583825347 | (37.7603537323491, -122.442583825347) | ||
| 113085 | 113085 | 65849 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 66 Rico Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50013 | 6001352.95008446 | 2121456.09779386 | 37.8051893002679 | -122.439585161616 | (37.8051893002679, -122.439585161616) | ||
| 133373 | 133373 | 65502 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 144 Venus St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/1989 12:00:00 AM | 11 | Permit Number 28386 | 6012831.84072 | 2094190.0605799998 | 37.7309695018215 | -122.39794689535401 | (37.7309695018215, -122.397946895354) | ||
| 20314 | 20314 | 27406 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1292 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2002 12:00:00 AM | 4 | 3X3 | 6000077.2192 | 2108872.6893 | 37.7705658482285 | -122.443095694592 | (37.7705658482285, -122.443095694592) | ||
| 162346 | 162346 | 66920 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 131 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1991 12:00:00 AM | 8 | Permit Number 30241 | 5988955.05994 | 2114464.3724 | 37.785278611879995 | -122.481976578748 | (37.78527861188, -122.481976578748) | ||
| 3623 | 3623 | 101130 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1477 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3x3 | Permit Number 769344 | 6000788.3 | 2110635.6 | 37.775446876390205 | -122.44076254186001 | (37.7754468763902, -122.44076254186) | ||
| 8058 | 8058 | 13044 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 532 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/2015 07:51:00 AM | 3 | 3X3 | 6009787.8556 | 2120566.4846 | 37.803223100103295 | -122.41033216474399 | (37.8032231001033, -122.410332164744) | ||
| 121506 | 121506 | 13038 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 502X Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/2015 07:48:00 AM | 3 | 3X3 | 6009911.875659999 | 2120580.1218 | 37.8032674957906 | -122.409903950928 | (37.8032674957906, -122.409903950928) | ||
| 104627 | 104627 | 13037 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 502X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/2015 07:44:00 AM | 3 | 3X3 | 6009888.84846 | 2120577.4578400003 | 37.8032588906613 | -122.409983449475 | (37.8032588906613, -122.409983449475) | ||
| 51255 | 51255 | 20259 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 500X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/2015 07:41:00 AM | 3 | 3X3 | 6009947.7744 | 2120592.07204 | 37.803302320019704 | -122.40978056566001 | (37.8033023200197, -122.40978056566) | ||
| 144052 | 144052 | 92882 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 111 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2009 12:00:00 AM | 3x3 | Permit Number 53099 | 6003570.3 | 2105037.0 | 37.7602325218092 | -122.43073933641399 | (37.7602325218092, -122.430739336414) | ||
| 58187 | 58187 | 74854 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2345 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5986677.9867 | 2102297.122 | 37.751738046008704 | -122.48895968631001 | (37.7517380460087, -122.48895968631) | ||
| 130987 | 130987 | 74552 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2345 Ortega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5986706.7381 | 2102298.6623 | 37.7517439532499 | -122.488860374683 | (37.7517439532499, -122.488860374683) | ||
| 151366 | 151366 | 74991 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2345 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5986666.6916 | 2102296.6086 | 37.751735977121704 | -122.488998708008 | (37.7517359771217, -122.488998708008) | ||
| 167162 | 167162 | 74706 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2345 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5986691.3356 | 2102298.6623 | 37.7517430543366 | -122.488913637871 | (37.7517430543366, -122.488913637871) | ||
| 162549 | 162549 | 113075 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3456 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775955 | 5999259.12859 | 2120682.68554 | 37.8029463281663 | -122.446775374497 | (37.8029463281663, -122.446775374497) | |
| 110566 | 110566 | 114803 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 273 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | Permit Number 772863 | 5990214.8 | 2113578.4 | 37.7829191632935 | -122.477553529871 | (37.7829191632935, -122.477553529871) | |||
| 70987 | 70987 | 55605 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 659 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 11 | 3x3 | Permit Number 49999 | 5982556.92934 | 2111261.39213 | 37.7761099876625 | -122.50387447717699 | (37.7761099876625, -122.503874477177) | |
| 104520 | 104520 | 22588 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 801 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/1990 12:00:00 AM | 12 | 4x4 | 6006166.11327 | 2112793.0062543997 | 37.781675384913605 | -122.422312701127 | (37.7816753849136, -122.422312701127) | ||
| 103704 | 103704 | 65472 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 62 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/1989 12:00:00 AM | Permit Number 28353 | 5995650.86801959 | 2090309.77846046 | 37.7193433342313 | -122.457063450459 | (37.7193433342313, -122.457063450459) | ||
| 123706 | 123706 | 112614 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1799x 22ND ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 12/09/2015 12:00:00 AM | 3 | Permit Number 776524 | 6012792.0 | 2103743.0 | 37.7571976263526 | -122.398754797925 | (37.7571976263526, -122.398754797925) | ||
| 148371 | 148371 | 46655 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 256 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53991 | 5990273.1737 | 2113691.27855 | 37.7832324834896 | -122.477359835562 | (37.7832324834896, -122.477359835562) |
| 89485 | 89485 | 64318 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 280 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53056 | 6003354.59476883 | 2100996.37068706 | 37.749125688061 | -122.431196941136 | (37.749125688061, -122.431196941136) | |
| 5990 | 5990 | 17787 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1805 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/1997 12:00:00 AM | 8 | 3x3 | 6005226.8193 | 2115439.913 | 37.788890105137604 | -122.425750672593 | (37.7888901051376, -122.425750672593) | ||
| 50041 | 50041 | 65382 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1709 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 9 | Permit Number 28221 | 6000542.2902 | 2114603.4223 | 37.786327487826206 | -122.44189839388599 | (37.7863274878262, -122.441898393886) | |
| 180333 | 180333 | 71265 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1707 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 7 | 6000547.9611 | 2114579.8664 | 37.7862631325586 | -122.441877082784 | (37.7862631325586, -122.441877082784) | ||
| 185038 | 185038 | 73548 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1707 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1989 12:00:00 AM | 7 | 6000544.9075 | 2114594.6979 | 37.7863036820207 | -122.441888712315 | (37.7863036820207, -122.441888712315) | ||
| 83865 | 83865 | 50612 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 231 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/2003 12:00:00 AM | Permit Number 47210 | 6006872.46746704 | 2096756.42071917 | 37.7376824626662 | -122.418731421871 | (37.7376824626662, -122.418731421871) | ||
| 8848 | 8848 | 18064 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2902 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/1997 12:00:00 AM | 12 | 3X3 | 6000013.6639 | 2114768.6486 | 37.7867510196451 | -122.44373917398 | (37.7867510196451, -122.44373917398) | ||
| 82339 | 82339 | 97989 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 876 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2011 12:00:00 AM | 3x3 | Permit Number 768167 | 6000897.0 | 2099683.0 | 37.7453799097395 | -122.439601171278 | (37.7453799097395, -122.439601171278) | ||
| 93971 | 93971 | 41269 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 44 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1999 12:00:00 AM | Permit Number 47888 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091001 | (37.7726810295415, -122.42136607091) | ||
| 93446 | 93446 | 90487 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 132 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768480 | 5988054.90697 | 2115089.09077 | 37.786941517761505 | -122.485136647101 | (37.7869415177615, -122.485136647101) | |
| 28481 | 28481 | 48583 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1172 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | 6 | Permit Number 45898 | 6008021.61269 | 2118241.60717 | 37.7967404007911 | -122.41627955815599 | (37.7967404007911, -122.416279558156) | |
| 80347 | 80347 | 47544 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 42 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45411 | 6004848.5926145 | 2101664.35736028 | 37.751044374772206 | -122.42607822279 | (37.7510443747722, -122.42607822279) | ||
| 94552 | 94552 | 47547 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 42 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45411 | 6004848.5926145 | 2101664.35736028 | 37.751044374772206 | -122.42607822279 | (37.7510443747722, -122.42607822279) | ||
| 104420 | 104420 | 47545 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 42 Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | Permit Number 45411 | 6004848.5926145 | 2101664.35736028 | 37.751044374772206 | -122.42607822279 | (37.7510443747722, -122.42607822279) | ||
| 103811 | 103811 | 55519 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4228 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | Permit Number 769010 | 6001686.84749041 | 2102367.04209993 | 37.7527945740635 | -122.437062140592 | (37.7527945740635, -122.437062140592) | |||
| 32796 | 32796 | 114752 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1633 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777131 | 6006558.502230001 | 2092052.0855400001 | 37.7247477068349 | -122.41948329761101 | (37.7247477068349, -122.419483297611) | ||
| 68313 | 68313 | 114759 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1655 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/2015 12:00:00 AM | 2 | Permit Number 777139 | 6003927.970290001 | 2120048.85434 | 37.801471595584296 | -122.43057351497299 | (37.8014715955843, -122.430573514973) | ||
| 96618 | 96618 | 4540 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 66 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1997 12:00:00 AM | 3 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | ||
| 117087 | 117087 | 67723 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1992 12:00:00 AM | Permit Number 31341 | 5995779.67382666 | 2107036.95964594 | 37.765279436903704 | -122.457827992335 | (37.7652794369037, -122.457827992335) | ||
| 3422 | 3422 | 17740 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1347 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 12/04/1982 12:00:00 AM | 6 | 3X3 | 6002203.7996 | 2113272.0173 | 37.7827663252153 | -122.436054698673 | (37.7827663252153, -122.436054698673) | ||
| 18149 | 18149 | 60477 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1343 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | Permit Number 20072 | 6002221.27409585 | 2113110.91985101 | 37.7823249851452 | -122.435982713361 | (37.7823249851452, -122.435982713361) | ||
| 79738 | 79738 | 60478 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1347 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1982 12:00:00 AM | Permit Number 20073 | 6002219.48599286 | 2113123.74035536 | 37.7823600854243 | -122.43598981706002 | (37.7823600854243, -122.43598981706) | ||
| 51960 | 51960 | 83691 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 201 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 8 | 6004196.42852 | 2092337.1873 | 37.725397205294705 | -122.427669003321 | (37.7253972052947, -122.427669003321) | ||
| 173811 | 173811 | 83658 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 735 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 1 | 6001863.16562 | 2089646.8314200002 | 37.717877833364 | -122.435542488698 | (37.717877833364, -122.435542488698) | ||
| 86468 | 86468 | 9169 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 6037 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/1998 12:00:00 AM | 9 | 3X3 | 5988226.75232 | 2112484.2258099997 | 37.7797993055455 | -122.484350989435 | (37.7797993055455, -122.484350989435) | ||
| 20751 | 20751 | 18600 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 500 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1992 12:00:00 AM | 6 | 3X3 | 5992650.7421 | 2088555.8456 | 37.7143547106063 | -122.467306211311 | (37.7143547106063, -122.467306211311) | ||
| 126497 | 126497 | 53524 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 226 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1969 12:00:00 AM | 3 | 3x3 | Permit Number 6436 | 5994753.48246338 | 2088426.05628518 | 37.714119504092295 | -122.460028964628 | (37.7141195040923, -122.460028964628) | |
| 94550 | 94550 | 94909 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 238 Olive St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2010 12:00:00 AM | 3x3 | Permit Number 53967 | 6006333.4 | 2113725.5 | 37.7842452193163 | -122.421800223368 | (37.7842452193163, -122.421800223368) | ||
| 113380 | 113380 | 94910 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 238 Olive St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2010 12:00:00 AM | 3x3 | Permit Number 53967 | 6006333.4 | 2113725.5 | 37.7842452193163 | -122.421800223368 | (37.7842452193163, -122.421800223368) | ||
| 166854 | 166854 | 94907 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 180 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53965 | 6010470.49633 | 2110410.47188 | 37.7753753643152 | -122.40725349625099 | (37.7753753643152, -122.407253496251) | |
| 48675 | 48675 | 30331 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 146 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 2 | Permit Number 773837 | 6007384.6010300005 | 2098241.57686 | 37.741789194105 | -122.417065928069 | (37.741789194105, -122.417065928069) | ||
| 108512 | 108512 | 68815 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 220 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32761 | 6002012.12143294 | 2096181.36814655 | 37.7358286494514 | -122.435494817775 | (37.7358286494514, -122.435494817775) | ||
| 81550 | 81550 | 52262 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 146 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | 6x10 | Permit Number 48427 | 6005571.5262701 | 2100241.30714404 | 37.7471778384958 | -122.423477084213 | (37.7471778384958, -122.423477084213) | |
| 111001 | 111001 | 52267 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 153 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48432 | 6005553.20536012 | 2099897.88813546 | 37.7462338542894 | -122.423516025282 | (37.7462338542894, -122.423516025282) | ||
| 141553 | 141553 | 52275 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1552DUNCAN Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48437 | 6005878.21118705 | 2099920.68685133 | 37.746314793517996 | -122.42239381306901 | (37.746314793518, -122.422393813069) | ||
| 167103 | 167103 | 41206 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3720 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 8 | Permit Number 41913 | 5999654.61261 | 2121348.57822 | 37.804797274147504 | -122.445454709292 | (37.8047972741475, -122.445454709292) | |
| 113021 | 113021 | 53195 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2924 GREENWICH Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2006 12:00:00 AM | Permit Number 49132 | 5999518.71165938 | 2118855.65507802 | 37.7979446178665 | -122.445745615705 | (37.7979446178665, -122.445745615705) | |||
| 123007 | 123007 | 53196 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2924 GREENWICH Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2006 12:00:00 AM | Permit Number 49132 | 5999518.71165938 | 2118855.65507802 | 37.7979446178665 | -122.445745615705 | (37.7979446178665, -122.445745615705) | |||
| 86415 | 86415 | 33579 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 169 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1996 12:00:00 AM | Permit Number 37687 | 6007131.89501253 | 2098033.82997093 | 37.7412045483591 | -122.417924980998 | (37.7412045483591, -122.417924980998) | |||
| 89047 | 89047 | 49009 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2031REVISED Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2003 12:00:00 AM | Permit Number 47203 | 6004221.06826057 | 2115296.78098336 | 37.7884402156292 | -122.429220223223 | (37.7884402156292, -122.429220223223) |
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");