Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16194 | 16194 | 85759 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1180 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009784.0631 | 2110452.1961 | 37.775451488302394 | -122.409630984869 | (37.7754514883024, -122.409630984869) | ||
| 16213 | 16213 | 35285 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | Permit Number 38758 | |||||||||
| 16268 | 16268 | 13318 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 11 Mabrey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/09/1992 12:00:00 AM | 12 | 3X3 | 6016491.98013 | 2095896.26802 | 37.735857573458794 | -122.38541191625099 | (37.7358575734588, -122.385411916251) | ||
| 16322 | 16322 | 42042 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16349 | 16349 | 22459 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 6150 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6013537.9663 | 2091442.0718 | 37.723463383403704 | -122.395313253548 | (37.7234633834037, -122.395313253548) | |||
| 16362 | 16362 | 22376 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5538 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014077.5103 | 2092853.4647 | 37.7273687774645 | -122.39354686543601 | (37.7273687774645, -122.393546865436) | |||
| 16403 | 16403 | 3726 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 401X Cargo Way | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016987.22702 | 2098921.28419 | 37.744191044988 | -122.38391020401899 | (37.744191044988, -122.383910204019) | |||
| 16500 | 16500 | 42041 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Jersey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42361 | 6005111.36941388 | 2101648.34848969 | 37.7510152664316 | -122.425168374318 | (37.7510152664316, -122.425168374318) | ||
| 16532 | 16532 | 22198 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 4049 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6015622.4674 | 2097608.2349 | 37.740510141063204 | -122.38853765218501 | (37.7405101410632, -122.388537652185) | |||
| 16594 | 16594 | 22437 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6025 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6013597.3212 | 2091386.3105 | 37.7233135750036 | -122.39510416905 | (37.7233135750036, -122.39510416905) | |||
| 16706 | 16706 | 102011 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 469 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6014033.25215 | 2112677.25893 | 37.7817981973592 | -122.395087809375 | (37.7817981973592, -122.395087809375) | |||
| 16775 | 16775 | 110930 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2 Connecticut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6013101.5791 | 2106846.11839 | 37.7657353505351 | -122.397901817734 | (37.7657353505351, -122.397901817734) | ||||
| 16824 | 16824 | 22511 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 6424 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6013025.9659 | 2090108.3639200001 | 37.719772801157 | -122.396989691115 | (37.719772801157, -122.396989691115) | |||
| 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 | ||||||||
| 17053 | 17053 | 10375 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1296 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2007 12:00:00 AM | 12 | 3X3 | 6000028.8313 | 2108866.5222 | 37.7705461558325 | -122.443262625265 | (37.7705461558325, -122.443262625265) | ||
| 17159 | 17159 | 18616 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 715 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5992096.2291 | 2088496.6198 | 37.7141600639726 | -122.46921850171199 | (37.7141600639726, -122.469218501712) | |||
| 17161 | 17161 | 26495 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2700 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2007 12:00:00 AM | 6 | 3x3 | 6008885.38363 | 2102897.90727 | 37.754658753403504 | -122.412205713815 | (37.7546587534035, -122.412205713815) | ||
| 17167 | 17167 | 2165 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 119X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/1997 12:00:00 AM | 12 | 3X27 | 5993658.6263 | 2088481.9826 | 37.714210032770296 | -122.46381723495199 | (37.7142100327703, -122.463817234952) | ||
| 17218 | 17218 | 26701 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1055 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2002 12:00:00 AM | 3 | 3X3 | 6004445.56166 | 2102766.22763 | 37.754047066024704 | -122.427550437605 | (37.7540470660247, -122.427550437605) | ||
| 17238 | 17238 | 27425 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1296 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1999 12:00:00 AM | 12 | 3X3 | 6000045.435 | 2108867.471 | 37.7705497077728 | -122.44320526125601 | (37.7705497077728, -122.443205261256) | ||
| 17312 | 17312 | 29983 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1622X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005924.09258 | 2099580.5471799998 | 37.7453834354083 | -122.42221099896001 | (37.7453834354083, -122.42221099896) | ||
| 17331 | 17331 | 26496 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2700 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1999 12:00:00 AM | 6 | 3x3 | 6008886.0848199995 | 2102878.04826 | 37.7546042643838 | -122.412201885424 | (37.7546042643838, -122.412201885424) | ||
| 17502 | 17502 | 18578 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 114 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5993641.4878 | 2088544.8235 | 37.7143815912468 | -122.463881030417 | (37.7143815912468, -122.463881030417) | |||
| 17690 | 17690 | 18609 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 601 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5992399.8764 | 2088496.7733 | 37.714178026974395 | -122.468168999945 | (37.7141780269744, -122.468168999945) | |||
| 17855 | 17855 | 18594 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 400 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5992917.5472 | 2088553.0754 | 37.7143625030062 | -122.466383834117 | (37.7143625030062, -122.466383834117) | |||
| 17955 | 17955 | 10276 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 215X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004948.0554599995 | 2109498.71961 | 37.7725612966014 | -122.42629199289699 | (37.7725612966014, -122.426291992897) | |||
| 17981 | 17981 | 17200 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 200X Olive St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6006498.358440001 | 2113758.48472 | 37.7843450883742 | -122.421231867498 | (37.7843450883742, -122.421231867498) | |||
| 18005 | 18005 | 29702 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005878.4786 | 2100373.84581 | 37.747559079794996 | -122.42242508166099 | (37.747559079795, -122.422425081661) | |||
| 18147 | 18147 | 56051 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 49 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1973 12:00:00 AM | 36 | Permit Number 12140 | 6003182.54972715 | 2108023.57751638 | 37.768410964941104 | -122.43229368198 | (37.7684109649411, -122.43229368198) | ||
| 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) | ||
| 18405 | 18405 | 11168 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6006944.2763295 | 2121452.6056321 | 37.8054963520093 | -122.420235406119 | (37.8054963520093, -122.420235406119) | |||
| 18414 | 18414 | 18611 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 618 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992335.2804 | 2088560.1418 | 37.714348290692705 | -122.468396874173 | (37.7143482906927, -122.468396874173) | |||
| 18440 | 18440 | 24552 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 400 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2002 12:00:00 AM | 18 | 3X3 | 6007194.9047 | 2097268.97601 | 37.739107975142495 | -122.41765291735202 | (37.7391079751425, -122.417652917352) | ||
| 18458 | 18458 | 17241 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 17X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5993905.3882 | 2088478.8088 | 37.714215535169004 | -122.46296410647699 | (37.714215535169, -122.462964106477) | |||
| 18586 | 18586 | 18605 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 533 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992541.0363 | 2088494.6252 | 37.714180280350796 | -122.467680944889 | (37.7141802803508, -122.467680944889) | |||
| 18674 | 18674 | 29222 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1902X 41st Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5983534.517682901 | 2102185.1808128003 | 37.7512467209802 | -122.499821775189 | (37.7512467209802, -122.499821775189) | |||
| 18726 | 18726 | 4427 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1153-1157 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2011 12:00:00 AM | 3 | 3x3 | 6004477.3384 | 2102149.60518 | 37.752355762318395 | -122.427396622076 | (37.7523557623184, -122.427396622076) | ||
| 18794 | 18794 | 46753 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 378 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/2002 12:00:00 AM | Permit Number 44855 | 5993270.29922187 | 2089695.37971007 | 37.717519344442294 | -122.465247516931 | (37.7175193444423, -122.465247516931) | ||
| 18831 | 18831 | 4449 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1365 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6004544.3142800005 | 2100922.31022 | 37.748989683529 | -122.427077601077 | (37.748989683529, -122.427077601077) | |||
| 18903 | 18903 | 18615 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 701 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992139.1908 | 2088496.6198 | 37.714162546412894 | -122.46907001084699 | (37.7141625464129, -122.469070010847) | |||
| 18915 | 18915 | 45453 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 191 Corona St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.725218936298496 | -122.46636405150299 | (37.7252189362985, -122.466364051503) | ||
| 19265 | 19265 | 29699 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005882.22155 | 2100316.32182 | 37.747401343192 | -122.42240805210399 | (37.747401343192, -122.422408052104) | |||
| 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) | ||
| 19497 | 19497 | 39128 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 755 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40809 | 6007359.12700155 | 2102919.00118427 | 37.7546309134503 | -122.41748542832899 | (37.7546309134503, -122.417485428329) | ||
| 19548 | 19548 | 4335 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 858 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2002 12:00:00 AM | 6 | 3X3 | 6001687.38643 | 2095877.23382 | 37.734975118199394 | -122.436595789974 | (37.7349751181994, -122.436595789974) | ||
| 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) | ||
| 19586 | 19586 | 29705 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1488X Guerrero St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005872.46136 | 2100440.5238200002 | 37.747741822942 | -122.422450626014 | (37.747741822942, -122.422450626014) | |||
| 19601 | 19601 | 64294 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 369 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1988 12:00:00 AM | 11 | Permit Number 25100 | 6004186.81103281 | 2098943.74928531 | 37.743536789999396 | -122.428172863442 | (37.7435367899994, -122.428172863442) | |
| 19669 | 19669 | 4443 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1337 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/1999 12:00:00 AM | 8 | 3X3 | 6004533.29635 | 2101118.5652900003 | 37.7495279313912 | -122.427129678106 | (37.7495279313912, -122.427129678106) | ||
| 19896 | 19896 | 26494 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2700 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2007 12:00:00 AM | 6 | 3x3 | 6008885.74395 | 2102915.53934 | 37.7547071873106 | -122.412205713825 | (37.7547071873106, -122.412205713825) | ||
| 19951 | 19951 | 4423 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1145 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004475.83751 | 2102212.10827 | 37.7525272963192 | -122.42740626460301 | (37.7525272963192, -122.427406264603) | |||
| 20014 | 20014 | 10374 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1292 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/21/2001 12:00:00 AM | 6 | 3X3 | 6000060.6155 | 2108870.7918 | 37.7705596914501 | -122.44315299047199 | (37.7705596914501, -122.443152990472) | ||
| 20047 | 20047 | 4438 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1307 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004526.51906 | 2101259.5658 | 37.749914702805206 | -122.42716315625401 | (37.7499147028052, -122.427163156254) | |||
| 20302 | 20302 | 18587 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 301 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993176.8455 | 2088486.1085 | 37.7141935864691 | -122.4654827422 | (37.7141935864691, -122.4654827422) | ||
| 20311 | 20311 | 29991 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 681X San Jose Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005873.40419 | 2099356.34635 | 37.744764971617705 | -122.422370344434 | (37.7447649716177, -122.422370344434) | ||
| 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) | ||
| 20536 | 20536 | 18595 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 400 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5992880.7313 | 2088552.7580000001 | 37.7143595070954 | -122.466511060282 | (37.7143595070954, -122.466511060282) | |||
| 20539 | 20539 | 16601 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 69 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/2015 12:00:00 AM | 12 | 3X3 | 6002869.93899 | 2107888.116 | 37.7680212904788 | -122.43336529207 | (37.7680212904788, -122.43336529207) | ||
| 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) | ||
| 20963 | 20963 | 10267 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 229X Haight St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x5 | 6004928.575180001 | 2109497.01592 | 37.7725555175436 | -122.4263592559 | (37.7725555175436, -122.4263592559) | |||
| 21165 | 21165 | 30006 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 795X San Jose Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005619.53854 | 2098557.61175 | 37.742557503841205 | -122.42319139937099 | (37.7425575038412, -122.423191399371) | ||
| 21199 | 21199 | 97237 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) | |||
| 21296 | 21296 | 28819 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1317 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2005 12:00:00 AM | 3 | 3X3 | 6004529.7064 | 2101205.40526 | 37.7497661707831 | -122.427148276966 | (37.7497661707831, -122.427148276966) | ||
| 21348 | 21348 | 26497 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2700 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2007 12:00:00 AM | 6 | 3x3 | 6008887.42951 | 2102862.58596 | 37.754561883845795 | -122.412196142362 | (37.7545618838458, -122.412196142362) | ||
| 21478 | 21478 | 10278 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 215X Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/1996 12:00:00 AM | 6 | 6X6 | 6005000.61509 | 2109505.63565 | 37.7725832571536 | -122.42611067607099 | (37.7725832571536, -122.426110676071) | ||
| 21515 | 21515 | 18601 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 509 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5992650.5887 | 2088494.9319999998 | 37.7141874476643 | -122.467302314998 | (37.7141874476643, -122.467302314998) | |||
| 21580 | 21580 | 18574 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 24 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5993864.1289 | 2088541.8084 | 37.7143861403954 | -122.463111281888 | (37.7143861403954, -122.463111281888) | |||
| 21751 | 21751 | 23680 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 322 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1996 12:00:00 AM | 6 | 3X3 | 6006869.809669999 | 2098126.1241900004 | 37.741443214134 | -122.418837724678 | (37.741443214134, -122.418837724678) | ||
| 22105 | 22105 | 18599 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 449 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/1996 12:00:00 AM | 12 | 3X3 | 5992745.528 | 2088491.5039 | 37.714183515181105 | -122.46697392177099 | (37.7141835151811, -122.466973921771) | ||
| 22243 | 22243 | 18613 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 645 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992222.8127 | 2088500.1488 | 37.7141770675516 | -122.46878124052799 | (37.7141770675516, -122.468781240528) | |||
| 22295 | 22295 | 41955 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2636 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 5 | Permit Number 42312 | 5995181.79826 | 2110315.10722 | 37.7742460062216 | -122.460133402127 | (37.7742460062216, -122.460133402127) | |
| 22302 | 22302 | 232948 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 347 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2017 12:00:00 AM | 3 | Width 3ft | 6004812.4927199995 | 2101688.42216 | 37.7511084107379 | -122.426204773027 | (37.7511084107379, -122.426204773027) | ||
| 22374 | 22374 | 9065 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5537 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989786.9858 | 2112602.3503 | 37.7802143684845 | -122.478962158407 | (37.7802143684845, -122.478962158407) | |||
| 22407 | 22407 | 17212 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 231 Olive St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6006210.05924 | 2113680.59084 | 37.7841149534825 | -122.42222374773998 | (37.7841149534825, -122.42222374774) | |||
| 22436 | 22436 | 9115 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5757 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5989122.1167 | 2112578.7748 | 37.7801110053489 | -122.48126049209499 | (37.7801110053489, -122.481260492095) | |||
| 22442 | 22442 | 9062 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5525 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5989837.7609 | 2112604.3144 | 37.7802227097378 | -122.478786649669 | (37.7802227097378, -122.478786649669) | |||
| 22453 | 22453 | 9128 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5840 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5988869.9475 | 2112669.6418 | 37.7803458369415 | -122.482139508426 | (37.7803458369415, -122.482139508426) | |||
| 22458 | 22458 | 9163 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6001 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5988313.9515 | 2112548.4697 | 37.7799807782466 | -122.484054045264 | (37.7799807782466, -122.484054045264) | |||
| 22459 | 22459 | 17761 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1700 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005743.27618 | 2115564.2628599997 | 37.789260709663 | -122.42397264671999 | (37.789260709663, -122.42397264672) | |||
| 22460 | 22460 | 17213 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 231 Olive St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6006226.51389 | 2113682.47873 | 37.78412106528079 | -122.42216695464701 | (37.7841210652808, -122.422166954647) | |||
| 22480 | 22480 | 17781 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1791 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005398.00422 | 2115462.48899 | 37.7889617651253 | -122.42516000273999 | (37.7889617651253, -122.42516000274) | |||
| 22522 | 22522 | 17775 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1762 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005528.7564900005 | 2115532.2293599998 | 37.789160640286 | -122.424712580148 | (37.789160640286, -122.424712580148) | |||
| 22523 | 22523 | 9112 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5731 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5989195.2404 | 2112580.9255 | 37.7801211615255 | -122.481007684457 | (37.7801211615255, -122.481007684457) | |||
| 22543 | 22543 | 17771 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1743 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 3 | 3x3 | 6005575.36336 | 2115490.23781 | 37.7890479741354 | -122.424548337833 | (37.7890479741354, -122.424548337833) | ||
| 22565 | 22565 | 9029 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5351 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5990343.7121 | 2112622.3264 | 37.780301530706296 | -122.47703766733 | (37.7803015307063, -122.47703766733) | |||
| 22568 | 22568 | 17777 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1770 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6005493.72272 | 2115526.88149 | 37.78914397766071 | -122.424833412132 | (37.7891439776607, -122.424833412132) | |||
| 22578 | 22578 | 17770 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1739 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2000 12:00:00 AM | 8 | 3x3 | 6005615.05829 | 2115496.7522400003 | 37.789068102766 | -122.42441146191999 | (37.789068102766, -122.42441146192) | ||
| 22613 | 22613 | 9164 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6001 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5988336.7568 | 2112550.1465 | 37.779986709952794 | -122.48397527547199 | (37.7799867099528, -122.483975275472) | |||
| 22627 | 22627 | 17769 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1739 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6005596.16237 | 2115493.24585 | 37.789057408033294 | -122.42447658992901 | (37.7890574080333, -122.424476589929) | |||
| 22658 | 22658 | 17773 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1749 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005553.02786 | 2115487.44284 | 37.7890390384567 | -122.42462541694401 | (37.7890390384567, -122.424625416944) | |||
| 22665 | 22665 | 9165 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6001 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5988358.8914 | 2112549.8112 | 37.779987077901204 | -122.48389867831101 | (37.7799870779012, -122.483898678311) | |||
| 22686 | 22686 | 9063 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5529 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5989797.972999999 | 2112602.4325 | 37.7802152322039 | -122.478924155076 | (37.7802152322039, -122.478924155076) | |||
| 22688 | 22688 | 17767 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1725 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2000 12:00:00 AM | 4 | 3x3 | 6005655.45235 | 2115499.57318 | 37.7890781293118 | -122.424271904233 | (37.7890781293118, -122.424271904233) | ||
| 22692 | 22692 | 17766 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1719 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6005681.4896 | 2115505.61033 | 37.789096175988895 | -122.424182248117 | (37.7890961759889, -122.424182248117) | |||
| 22703 | 22703 | 17768 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1731 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2000 12:00:00 AM | 5 | 3x3 | 6005639.06035 | 2115498.93652 | 37.7890754556083 | -122.424328573211 | (37.7890754556083, -122.424328573211) | ||
| 22722 | 22722 | 9130 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5843 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988875.3243 | 2112569.0967 | 37.780070081021705 | -122.48211353976002 | (37.7800700810217, -122.48211353976) | |||
| 22739 | 22739 | 9114 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 5757 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5989097.9213 | 2112579.3125 | 37.780111075033396 | -122.48134423338301 | (37.7801110750334, -122.481344233383) | ||
| 22740 | 22740 | 9192 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6138 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 5987910.6661 | 2112635.8342 | 37.780197169187296 | -122.485455585501 | (37.7801971691873, -122.485455585501) | |||
| 22752 | 22752 | 9190 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 6128 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 5987955.2707 | 2112636.8403 | 37.7802025302416 | -122.48530135353799 | (37.7802025302416, -122.485301353538) | |||
| 22758 | 22758 | 8985 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 5133 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5991037.8127 | 2112647.8841 | 37.78041194791 | -122.474638342176 | (37.78041194791, -122.474638342176) |
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");