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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 91286 | 91286 | 94498 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1600X Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/30/2015 12:00:00 AM | 7x7 | 5998899.3 | 2109049.0 | 37.770982719767794 | -122.44718280302601 | (37.7709827197678, -122.447182803026) | |||
| 9808 | 9808 | 121557 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 421 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779269 | 6003622.0 | 2102696.0 | 37.7538076209017 | -122.430393500907 | (37.7538076209017, -122.430393500907) | |
| 184980 | 184980 | 61774 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2574 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/1984 12:00:00 AM | 17 | Permit Number 21793 | 5983996.4567 | 2097655.6872 | 37.7388370676495 | -122.497889927941 | (37.7388370676495, -122.497889927941) | ||
| 48592 | 48592 | 63207 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3633 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | 14 | Permit Number 23749 | 5984209.30853 | 2113126.2552799997 | 37.7813273844972 | -122.498296310267 | (37.7813273844972, -122.498296310267) | |
| 77956 | 77956 | 45719 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 227 Sargent St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | Permit Number 44389 | 5993425.80357844 | 2089157.89359185 | 37.7160525030782 | -122.464671006022 | (37.7160525030782, -122.464671006022) | |||
| 159477 | 159477 | 79477 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3518 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/08/2001 12:00:00 AM | 4 | 5982515.1145 | 2100854.6307 | 37.7475335277544 | -122.503248420372 | (37.7475335277544, -122.503248420372) | ||
| 109527 | 109527 | 41271 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 229 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41954 | 5994679.37055115 | 2091871.07942789 | 37.723574453453494 | -122.460534605902 | (37.7235744534535, -122.460534605902) | |||
| 10039 | 10039 | 106657 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 706 20TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 10 | 3x3 | 5989753.9107099995 | 2110247.9151 | 37.773747820615704 | -122.47890432357 | (37.7737478206157, -122.47890432357) | ||
| 127923 | 127923 | 81254 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 706 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | 5989768.37779 | 2110442.38687 | 37.7742826266156 | -122.478868506685 | (37.7742826266156, -122.478868506685) | |
| 105114 | 105114 | 113094 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 5725 DIAMOND HEIGHTS BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2015 12:00:00 AM | 3x3 | Permit Number 776952 | 6000738.0 | 2097078.0 | 37.7382181444182 | -122.43996421610001 | (37.7382181444182, -122.4399642161) | ||
| 83799 | 83799 | 108198 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 808 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2014 12:00:00 AM | 3 | 2x2 | Permit Number 774168 | 5999486.009 | 2095579.2645400001 | 37.7340316201973 | -122.444185299389 | (37.7340316201973, -122.444185299389) | |
| 144391 | 144391 | 25557 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 50X Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2000 12:00:00 AM | 3 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | ||
| 189120 | 189120 | 98169 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2941 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 19 | 3x3 | Permit Number 775039 | 6000613.54695 | 2116154.22533 | 37.7905896504327 | -122.44176320452299 | (37.7905896504327, -122.441763204523) | |
| 181372 | 181372 | 66297 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2054 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1990 12:00:00 AM | 14 | Permit Number 29408 | 5986536.6056 | 2097051.3953 | 37.7373264330852 | -122.489062983875 | (37.7373264330852, -122.489062983875) | ||
| 5802 | 5802 | 122541 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2233 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779046 | 6001437.2497 | 2113869.2014 | 37.7843624618515 | -122.438749438347 | (37.7843624618515, -122.438749438347) | |
| 60911 | 60911 | 121797 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779075 | 6004274.0 | 2096577.0 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | |
| 104006 | 104006 | 121798 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Miguel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6004274.0 | 2096577.0 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | ||
| 109843 | 109843 | 121799 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Miguel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779075 | 6004274.0 | 2096577.0 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | |
| 125251 | 125251 | 121800 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Miguel St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 3x3 | 6004274.0 | 2096577.0 | 37.7370431692485 | -122.427702791955 | (37.7370431692485, -122.427702791955) | ||
| 129899 | 129899 | 97406 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1642 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2011 12:00:00 AM | 0 | 3x3 | Permit Number 768387 | 5981634.3 | 2103894.4 | 37.755828061107394 | -122.506519568736 | (37.7558280611074, -122.506519568736) | |
| 117971 | 117971 | 112810 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 666 47TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2015 12:00:00 AM | 3x3 | Permit Number 776751 | 5981389.0 | 2111175.0 | 37.7758040356864 | -122.507908173068 | (37.7758040356864, -122.507908173068) | ||
| 118854 | 118854 | 112809 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 666 47TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2015 12:00:00 AM | 3x3 | Permit Number 776751 | 5981389.0 | 2111175.0 | 37.7758040356864 | -122.507908173068 | (37.7758040356864, -122.507908173068) | ||
| 174982 | 174982 | 52214 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2001 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2005 12:00:00 AM | 17 | Permit Number 48397 | 6003318.2213 | 2118578.20562 | 37.797399014802 | -122.432578411388 | (37.797399014802, -122.432578411388) | ||
| 13181 | 13181 | 117441 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1204 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778732 | 5989885.5669 | 2107139.7037 | 37.765221164359495 | -122.47822160390498 | (37.7652211643595, -122.478221603905) | |
| 157284 | 157284 | 113297 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 162 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2015 12:00:00 AM | 25 | 3x3 | Permit Number 776713 | 5991196.72746 | 2114338.44012 | 37.7850629536775 | -122.47421197891501 | (37.7850629536775, -122.474211978915) | |
| 92242 | 92242 | 33912 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 665 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 37882 | 6002076.88418057 | 2102621.6953038997 | 37.753515953271496 | -122.435731542402 | (37.7535159532715, -122.435731542402) | ||
| 96955 | 96955 | 41426 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3901 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2002 12:00:00 AM | Permit Number 42033 | 6003639.60917921 | 2104762.31302618 | 37.759482223502395 | -122.430480029002 | (37.7594822235024, -122.430480029002) | ||
| 79226 | 79226 | 55388 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1377 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1972 12:00:00 AM | 3x3 | Permit Number 11325 | 5993310.46042535 | 2106120.10977525 | 37.762619842052494 | -122.466301708727 | (37.7626198420525, -122.466301708727) | ||
| 141356 | 141356 | 86901 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 370 Santa Ana Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49847 | 5992482.1 | 2094336.7 | 37.73021778542579 | -122.468309402689 | (37.7302177854258, -122.468309402689) | |||
| 107168 | 107168 | 1459 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 170 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | 3X3 | 5995550.04473 | 2115004.5648 | 37.7871431812831 | -122.45919922698299 | (37.7871431812831, -122.459199226983) | ||
| 71595 | 71595 | 57562 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1717 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1976 12:00:00 AM | 20 | Permit Number 16429 | 6000855.1553 | 2111361.653 | 37.777444241367 | -122.440583361864 | (37.777444241367, -122.440583361864) | ||
| 77895 | 77895 | 105191 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 3 | Permit Number 778982 | 5981635.0538800005 | 2111041.25056 | 37.77545129327579 | -122.507047101274 | (37.7754512932758, -122.507047101274) | |
| 121287 | 121287 | 105189 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 3 | Permit Number 778982 | 5981634.44946 | 2111075.87113 | 37.7755463155962 | -122.50705176084101 | (37.7755463155962, -122.507051760841) | |
| 127652 | 127652 | 105190 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2016 12:00:00 AM | 3 | 3 | Permit Number 778982 | 5981635.135559999 | 2111057.61363 | 37.7754962262709 | -122.50704803283101 | (37.7754962262709, -122.507048032831) | |
| 74023 | 74023 | 76347 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 15 | 6013052.749419999 | 2119171.30409 | 37.7995747464454 | -122.398935843819 | (37.7995747464454, -122.398935843819) | ||
| 148556 | 148556 | 53965 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 17 | Permit Number 9680 | 6013049.6563099995 | 2119205.04164 | 37.799667209323 | -122.39894891638001 | (37.799667209323, -122.39894891638) | |
| 160901 | 160901 | 76366 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 7 | 6013050.90203 | 2119190.90632 | 37.7996284665342 | -122.398943613057 | (37.7996284665342, -122.398943613057) | ||
| 70080 | 70080 | 44059 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 257 Santos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | 6 | 3x3 | Permit Number 43586 | 6006396.21431 | 2086366.5390599999 | 37.7091272643882 | -122.419641098064 | (37.7091272643882, -122.419641098064) | |
| 52722 | 52722 | 58056 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1957 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1977 12:00:00 AM | 5 | Permit Number 17025 | 6002479.0246 | 2119847.84274 | 37.8008374809215 | -122.435573122311 | (37.8008374809215, -122.435573122311) | ||
| 151251 | 151251 | 58055 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1951 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1977 12:00:00 AM | 6 | Permit Number 17024 | 6002508.23206 | 2119853.3281 | 37.8008542011299 | -122.435472445005 | (37.8008542011299, -122.435472445005) | ||
| 11098 | 11098 | 64696 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1055 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1988 12:00:00 AM | 6 | 3x3 | Permit Number 25639 | 5989879.8498 | 2099000.4177 | 37.742872512219 | -122.47764638889299 | (37.742872512219, -122.477646388893) | |
| 158794 | 158794 | 97321 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1055 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1988 12:00:00 AM | 9 | 3x3 | 5989897.1093 | 2098999.7408 | 37.7428716552125 | -122.477586661544 | (37.7428716552125, -122.477586661544) | ||
| 167704 | 167704 | 55221 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2301 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/1972 12:00:00 AM | 12 | Permit Number 11139 | 5986369.9081 | 2099546.7997 | 37.744168417752206 | -122.489822796734 | (37.7441684177522, -122.489822796734) | ||
| 104451 | 104451 | 44044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 15 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2000 12:00:00 AM | 3x3 | Permit Number 52166 | 6007300.39530105 | 2099500.4637239 | 37.7452410789231 | -122.417446281159 | (37.7452410789231, -122.417446281159) | ||
| 109409 | 109409 | 32427 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1901 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1996 12:00:00 AM | Permit Number 36954 | 6003387.68416895 | 2115217.90617727 | 37.7881764318356 | -122.432097963893 | (37.7881764318356, -122.432097963893) | |||
| 143090 | 143090 | 32410 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 557 Congo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36944 | 6000089.06506058 | 2095518.18439448 | 37.7338982944093 | -122.44209597109501 | (37.7338982944093, -122.442095971095) | |||
| 127843 | 127843 | 97325 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1123 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 15 | 3x3 | 5989733.4 | 2098972.0 | 37.7427859847726 | -122.478150688587 | (37.7427859847726, -122.478150688587) | ||
| 6568 | 6568 | 92750 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2049 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/02/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52971 | 5998090.3691 | 2110284.0117 | 37.774327490890705 | -122.450069934151 | (37.7743274908907, -122.450069934151) |
| 1465 | 1465 | 210473 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 855 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2016 12:00:00 AM | 14 | Width 3ft | Permit Number 41828 | 5993066.85825 | 2107284.5743400003 | 37.765803096458995 | -122.46722890580901 | (37.765803096459, -122.467228905809) | |
| 125247 | 125247 | 41048 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 855 LINCOLN WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 41828 | 5993076.0 | 2107259.0 | 37.7657334037891 | -122.46719542706002 | (37.7657334037891, -122.46719542706) | |
| 127812 | 127812 | 40861 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 196 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | Permit Number 41784 | 5994083.13181366 | 2093531.57356405 | 37.728099447432896 | -122.462716082104 | (37.7280994474329, -122.462716082104) | |||
| 143205 | 143205 | 117682 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7800 Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2016 12:00:00 AM | 3 | Width 3ft | Permit Number 778742 | 5982589.466109999 | 2112438.09785 | 37.779342790231794 | -122.503849096172 | (37.7793427902318, -122.503849096172) | |
| 141137 | 141137 | 101256 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1049 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 3x3 | 5992548.0 | 2106581.0 | 37.763841302397104 | -122.46897230376699 | (37.7638413023971, -122.468972303767) | |||
| 53078 | 53078 | 43995 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 141 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | 6 | Permit Number 43551 | 6009986.76566 | 2107516.11876 | 37.767401055952604 | -122.408722606278 | (37.7674010559526, -122.408722606278) | ||
| 119890 | 119890 | 43991 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 141 Hampshire St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | Permit Number 43551 | 6009974.46243584 | 2107504.86062599 | 37.767369454596 | -122.408764367283 | (37.767369454596, -122.408764367283) | |||
| 5601 | 5601 | 116211 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3801 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996580.5135 | 2114939.45555 | 37.7870235965959 | -122.455629343026 | (37.7870235965959, -122.455629343026) | |
| 7159 | 7159 | 116209 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3801 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996627.1701 | 2114945.18052 | 37.787041993130295 | -122.455468336508 | (37.7870419931303, -122.455468336508) | |
| 7502 | 7502 | 116210 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3801 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996604.94532 | 2114941.4574599997 | 37.787030495305 | -122.455544959643 | (37.787030495305, -122.455544959643) | |
| 93028 | 93028 | 115827 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 60X CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777531 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | |
| 140493 | 140493 | 115828 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 65 CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | ||
| 65099 | 65099 | 62101 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4224 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1985 12:00:00 AM | 4 | Permit Number 22194 | 5981140.9456 | 2104205.2821 | 37.756652594222004 | -122.508248791959 | (37.756652594222, -122.508248791959) | ||
| 98366 | 98366 | 120122 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1426X Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776978 | 6001386.0 | 2099547.0 | 37.7450343054892 | -122.437900552772 | (37.7450343054892, -122.437900552772) | |
| 105616 | 105616 | 120120 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 28th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776978 | 6001710.0 | 2099417.0 | 37.744695775282004 | -122.436770916391 | (37.744695775282, -122.436770916391) | |
| 109051 | 109051 | 33491 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 29 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2007 12:00:00 AM | Permit Number 49655 | 6006996.29665496 | 2099574.0262700003 | 37.7454259501675 | -122.418503020578 | (37.7454259501675, -122.418503020578) | |||
| 92083 | 92083 | 38475 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 162 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1998 12:00:00 AM | Permit Number 40476 | 5999822.84916102 | 2087316.82231241 | 37.7113640595721 | -122.44242775396002 | (37.7113640595721, -122.44242775396) | ||
| 101180 | 101180 | 117525 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 329 SANTA ANA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2016 12:00:00 AM | 3 | 2x3 | 5992655.0 | 2094678.0 | 37.7311648953586 | -122.467736482345 | (37.7311648953586, -122.467736482345) | ||
| 79255 | 79255 | 57585 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 297 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | 3x3 | Permit Number 16453 | 6013500.41645948 | 2105713.4077908 | 37.762647381026504 | -122.39644291208 | (37.7626473810265, -122.39644291208) | ||
| 74676 | 74676 | 34232 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 378 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2005 12:00:00 AM | 6 | Permit Number 48201 | 5986869.968169999 | 2113396.40571 | 37.7822247950158 | -122.48911172009899 | (37.7822247950158, -122.489111720099) | ||
| 95978 | 95978 | 38435 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 950 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1998 12:00:00 AM | Permit Number 40462 | 6003103.32448359 | 2102701.71275072 | 37.7537939125694 | -122.43218760661101 | (37.7537939125694, -122.432187606611) | |||
| 1011 | 1011 | 232310 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1018 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2016 12:00:00 AM | 26 | Width 3ft | Permit Number 17854 | 5997696.0 | 2107004.0 | 37.7652988449505 | -122.451197528579 | (37.7652988449505, -122.451197528579) | |
| 87521 | 87521 | 58634 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1018 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2016 12:00:00 AM | 3 | 4x4 | Permit Number 17854 | 5997674.48741574 | 2107055.11858465 | 37.765437971850794 | -122.45127562216999 | (37.7654379718508, -122.45127562217) | |
| 110601 | 110601 | 61062 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2031 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1983 12:00:00 AM | 15 | 3x3 | Permit Number 20894 | 6003791.73087977 | 2114891.68292751 | 37.7873036043324 | -122.430676743416 | (37.7873036043324, -122.430676743416) | |
| 11465 | 11465 | 107858 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2908 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778432 | 5981789.5382 | 2096536.8762 | 37.735635490547 | -122.505437384685 | (37.735635490547, -122.505437384685) | |
| 119856 | 119856 | 85365 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 66 Clarendon Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/17/2007 12:00:00 AM | Permit Number 49641 | 5997837.8 | 2104660.2 | 37.758871479144396 | -122.45053809231199 | (37.7588714791444, -122.450538092312) | |||
| 8885 | 8885 | 53229 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1435 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2016 12:00:00 AM | 3 | 3x3 | Permit Number 6112 | 6007249.74611 | 2117746.2070299997 | 37.795336722764795 | -122.41891524533999 | (37.7953367227648, -122.41891524534) | |
| 145224 | 145224 | 112424 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1256 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2015 12:00:00 AM | 3x3 | 6000541.0 | 2109299.0 | 37.771762823259394 | -122.441522073459 | (37.7717628232594, -122.441522073459) | |||
| 98934 | 98934 | 119253 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 465 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2016 12:00:00 AM | 3 | 3x3 | 6003365.0 | 2102681.0 | 37.7537518732502 | -122.431281194819 | (37.7537518732502, -122.431281194819) | ||
| 160490 | 160490 | 43880 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1828 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 9 | Permit Number 43493 | 6001514.0134 | 2112541.0633 | 37.7807200997255 | -122.43838867760799 | (37.7807200997255, -122.438388677608) | ||
| 55465 | 55465 | 75612 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013522.58771 | 2104188.6871599997 | 37.7584620654811 | -122.396259360694 | (37.7584620654811, -122.396259360694) | ||
| 168440 | 168440 | 75548 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013526.462719999 | 2104188.60864 | 37.758462065501796 | -122.39624595358102 | (37.7584620655018, -122.396245953581) | ||
| 12762 | 12762 | 116742 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1638 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 6x3 | Permit Number 778698 | 5983780.8141 | 2103988.0199 | 37.756211265636296 | -122.499103262084 | (37.7562112656363, -122.499103262084) | |
| 114587 | 114587 | 100397 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 204 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2014 12:00:00 AM | 14 | 3x3 | Permit Number 773162 | 5993575.2 | 2104649.1 | 37.7585961040831 | -122.46527922129101 | (37.7585961040831, -122.465279221291) | |
| 32416 | 32416 | 111290 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 285 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776047 | 5990541.73439 | 2113523.7121099997 | 37.7827879717093 | -122.476418488313 | (37.7827879717093, -122.476418488313) | |
| 177905 | 177905 | 43789 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 121 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 10 | Permit Number 43419 | 5988953.60454 | 2114542.0898700003 | 37.7854919174236 | -122.481987309149 | (37.7854919174236, -122.481987309149) | |
| 10231 | 10231 | 56289 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 26 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1973 12:00:00 AM | 3 | 7x6 | Permit Number 12417 | 5998468.52120725 | 2106293.91375272 | 37.76339332794971 | -122.448474428781 | (37.7633933279497, -122.448474428781) | |
| 140399 | 140399 | 44756 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 256 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2015 12:00:00 AM | 3 | Permit Number 43869 | 6014282.34232981 | 2105939.88092695 | 37.7633127092766 | -122.39375434301 | (37.7633127092766, -122.39375434301) | ||
| 158901 | 158901 | 51084 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1358 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2004 12:00:00 AM | 5 | Permit Number 47542 | 5981543.7588 | 2105841.1993 | 37.7611680849155 | -122.50697708881701 | (37.7611680849155, -122.506977088817) | ||
| 1 | 1 | 141565 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 501X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1988 12:00:00 AM | 21 | Width 0ft | Permit Number 25401 | 6000609.0 | 2110829.0 | 37.7759676911831 | -122.441396661871 | (37.7759676911831, -122.441396661871) | |
| 81854 | 81854 | 64519 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 505 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1988 12:00:00 AM | Permit Number 25401 | 6000604.42582894 | 2110679.50515746 | 37.7755569556145 | -122.44140175558 | (37.7755569556145, -122.44140175558) | |||
| 78140 | 78140 | 108270 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3198 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778418 | 5993567.71806 | 2110075.4730599998 | 37.7734950644816 | -122.46569933848 | (37.7734950644816, -122.46569933848) | |
| 88289 | 88289 | 61437 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 788 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2016 12:00:00 AM | 3 | Permit Number 778418 | 5993530.07441 | 2110197.53457 | 37.7738280413865 | -122.46583842282101 | (37.7738280413865, -122.465838422821) | ||
| 118298 | 118298 | 108269 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3198 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778418 | 5993591.00461 | 2110079.42725 | 37.7735072647955 | -122.46561907488599 | (37.7735072647955, -122.465619074886) | |
| 35388 | 35388 | 53227 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1419 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1969 12:00:00 AM | 13 | 3x3 | Permit Number 6110 | 6007265.78904 | 2117749.89162 | 37.795347743065 | -122.41885999550301 | (37.795347743065, -122.418859995503) | |
| 100877 | 100877 | 34518 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 201 Stillings Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38229 | 5999437.15230869 | 2095745.6775321 | 37.7344857636851 | -122.44436616674601 | (37.7344857636851, -122.444366166746) | |||
| 129072 | 129072 | 34519 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 201 Stillings Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38229 | 5999437.15230869 | 2095745.6775321 | 37.7344857636851 | -122.44436616674601 | (37.7344857636851, -122.444366166746) | |||
| 103613 | 103613 | 34289 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2715 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38080 | 5987074.67438797 | 2114433.79174181 | 37.7850851064396 | -122.488479804204 | (37.7850851064396, -122.488479804204) | ||
| 110464 | 110464 | 51814 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 266 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2005 12:00:00 AM | Permit Number 48060 | 5994901.32061156 | 2096492.00794019 | 37.736275166275796 | -122.460101979176 | (37.7362751662758, -122.460101979176) | |||
| 78222 | 78222 | 38067 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1654X SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 8x5 | Permit Number 40258 | 6001625.0 | 2114095.0 | 37.7849931264589 | -122.43811606926701 | (37.7849931264589, -122.438116069267) | |
| 67490 | 67490 | 51036 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2614 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 3 | Permit Number 47511 | 5981836.5788 | 2097266.1752 | 37.7376407136614 | -122.50532878706001 | (37.7376407136614, -122.50532878706) | ||
| 83540 | 83540 | 111656 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) |
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");