Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 595 | 595 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 299x Avalon Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 9912 | 9912 | 173731 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 484 Chenery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003566.0 | 2096120.0 | 37.7357482768139 | -122.43011807363199 | (37.7357482768139, -122.430118073632) | |||||
| 24447 | 24447 | 201523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 799 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 10ft | 6020371.96237 | 2093662.3098400002 | 37.729937451546704 | -122.371842613372 | (37.7299374515467, -122.371842613372) | |||
| 28873 | 28873 | 177837 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650 Peru Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | ||||
| 30242 | 30242 | 247859 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6009590.028030001 | 2098126.55062 | 37.741597175379894 | -122.409432139892 | (37.7415971753799, -122.409432139892) | ||||
| 37741 | 37741 | 177836 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650 Peru Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005089.4768199995 | 2092569.03703 | 37.7260842891429 | -122.424598299682 | (37.7260842891429, -122.424598299682) | ||||
| 38897 | 38897 | 177806 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 62 Tomaso Ct | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 8ft | 6009249.93875 | 2086480.54598 | 37.709600642326606 | -122.409786194885 | (37.7096006423266, -122.409786194885) | |||
| 44191 | 44191 | 194043 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1700 22nd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6012940.14961 | 2103802.44192 | 37.7573690942271 | -122.398246606115 | (37.7573690942271, -122.398246606115) | ||||
| 52437 | 52437 | 232289 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 0 San Jose Av Off Ramp | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 9ft | 6002953.30911 | 2095259.2744599998 | 37.7333502006365 | -122.43217493415301 | (37.7333502006365, -122.432174934153) | |||
| 60467 | 60467 | 247863 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6009595.21098 | 2098157.48801 | 37.7416824131186 | -122.409416401771 | (37.7416824131186, -122.409416401771) | ||||
| 62149 | 62149 | 232294 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200 Eugenia Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6006564.33926 | 2098135.6208099998 | 37.7414520850542 | -122.41989461157301 | (37.7414520850542, -122.419894611573) | ||||
| 67557 | 67557 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 690 Miramar Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995444.4 | 2093941.6 | 37.729303587844704 | -122.45803982404199 | (37.7293035878447, -122.458039824042) | |||||
| 69757 | 69757 | 247862 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6009589.386530001 | 2098133.6831900002 | 37.7416167239206 | -122.40943486124701 | (37.7416167239206, -122.409434861247) | ||||
| 73078 | 73078 | 247860 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6009586.93034 | 2098129.5986 | 37.7416053709039 | -122.40944306575899 | (37.7416053709039, -122.409443065759) | ||||
| 82109 | 82109 | 105208 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2694 47TH AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 5981878.3 | 2096771.8 | 37.736285749950206 | -122.50514791128201 | (37.7362857499502, -122.505147911282) | ||||||
| 92138 | 92138 | 101902 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1100 Ocean Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 102326 | 102326 | 104898 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 310 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 102950 | 102950 | 105540 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2694 47TH AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5981878.3 | 2096771.8 | 37.736285749950206 | -122.50514791128201 | (37.7362857499502, -122.505147911282) | ||||
| 106220 | 106220 | 102130 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 33 Topaz Way | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Permit Number 769641 | 6001571.9 | 2098568.0 | 37.7423567715609 | -122.437187662125 | (37.7423567715609, -122.437187662125) | |||
| 106634 | 106634 | 121195 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 255x Red Rock Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999917.0 | 2099808.0 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | |||
| 109657 | 109657 | 98303 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 6 Locksley Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994194.0 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | |||||
| 117957 | 117957 | 98300 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 6 Locksley Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994194.0 | 2104902.7 | 37.7593280901784 | -122.463157548093 | (37.7593280901784, -122.463157548093) | |||||
| 118620 | 118620 | 104908 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 500 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 131380 | 131380 | 194064 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1640 Davidson Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 6ft | 6014536.55143 | 2099742.5606 | 37.7463103162609 | -122.3924416073 | (37.7463103162609, -122.3924416073) | |||
| 135181 | 135181 | 232295 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200 Eugenia Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6006547.43699 | 2098127.1164599997 | 37.7414277817691 | -122.419952450553 | (37.7414277817691, -122.419952450553) | ||||
| 142656 | 142656 | 121196 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 255x Red Rock Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999917.0 | 2099808.0 | 37.7456673038035 | -122.442998816589 | (37.7456673038035, -122.442998816589) | |||
| 149889 | 149889 | 177838 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 652 Peru Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005106.92486 | 2092561.69197 | 37.7260651065947 | -122.42453746056101 | (37.7260651065947, -122.424537460561) | ||||
| 158989 | 158989 | 177835 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650 Peru Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6005084.25734 | 2092571.43545 | 37.7260905799026 | -122.42461651366301 | (37.7260905799026, -122.424616513663) | ||||
| 162173 | 162173 | 177805 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 62 Tomaso Ct | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 8ft | 6009236.846480001 | 2086428.13607 | 37.709456001673296 | -122.409827747151 | (37.7094560016733, -122.409827747151) | |||
| 166693 | 166693 | 194049 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 Hampshire St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009981.034030001 | 2107543.0973799997 | 37.76747481202629 | -122.40874433479999 | (37.7674748120263, -122.4087443348) | ||||
| 167980 | 167980 | 232292 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200 Eugenia Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | Width 10ft | 6006575.0369 | 2098117.47597 | 37.7414028660575 | -122.41985633551701 | (37.7414028660575, -122.419856335517) | |||
| 175127 | 175127 | 177839 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 652 Peru Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6005114.3651 | 2092558.89448 | 37.7260578454775 | -122.42451154118 | (37.7260578454775, -122.42451154118) | ||||
| 180452 | 180452 | 177816 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 60 Tomaso Ct | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 3ft | 6009147.33252 | 2086269.1354099999 | 37.7090144012735 | -122.41012590570601 | (37.7090144012735, -122.410125905706) | |||
| 182248 | 182248 | 232293 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200 Eugenia Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6006572.50895 | 2098130.46557 | 37.741438390175205 | -122.41986599782301 | (37.7414383901752, -122.419865997823) | ||||
| 184202 | 184202 | 177807 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 62 Tomaso Ct | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 8ft | 6009274.965480001 | 2086528.64182 | 37.7097341062031 | -122.409703090337 | (37.7097341062031, -122.409703090337) | |||
| 7743 | 7743 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1274 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | |||
| 35461 | 35461 | 193775 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1040 Minnesota St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6015239.9483 | 2103736.7361 | 37.7573165153716 | -122.39028833533199 | (37.7573165153716, -122.390288335332) | ||||
| 47525 | 47525 | 177649 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Tocoloma Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 5ft | 6012431.1901 | 2086436.64385 | 37.709657863481205 | -122.398788087022 | (37.7096578634812, -122.398788087022) | |||
| 47993 | 47993 | 105254 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 130 GONZALEZ DR | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 5990327.0 | 2090136.0 | 37.7185590045312 | -122.47545320091999 | (37.7185590045312, -122.47545320092) | |||||
| 54100 | 54100 | 231223 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 220 Coso Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6007580.66688 | 2099526.6685200003 | 37.7453287970792 | -122.416479002612 | (37.7453287970792, -122.416479002612) | ||||
| 58214 | 58214 | 249935 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 345 Filbert St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6011217.60626 | 2120022.59893 | 37.8018097658745 | -122.40534611785601 | (37.8018097658745, -122.405346117856) | |||
| 72791 | 72791 | 232774 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 23 Seward St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 3ft | 6001021.9889 | 2104218.53505 | 37.7578405116552 | -122.439494050427 | (37.7578405116552, -122.439494050427) | |||
| 77391 | 77391 | 92760 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 78407 | 78407 | 92764 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 78854 | 78854 | 101901 | Property Tree 7 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Ocean Ave | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 82826 | 82826 | 92763 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 83452 | 83452 | 92762 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 86127 | 86127 | 92761 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 96352 | 96352 | 92759 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 99263 | 99263 | 101435 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 105471 | 105471 | 101436 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 106295 | 106295 | 113380 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 63 Potomac St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4x4 | Permit Number 776311 | 6003081.0 | 2108682.5 | 37.7702144463181 | -122.432692008068 | (37.7702144463181, -122.432692008068) | |||
| 113684 | 113684 | 92767 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 116515 | 116515 | 92766 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 117761 | 117761 | 101439 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 123027 | 123027 | 101440 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 127045 | 127045 | 92765 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 128404 | 128404 | 101438 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 136773 | 136773 | 193819 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Tulare St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6015080.24684 | 2100323.5646599997 | 37.747935809394896 | -122.39060215016501 | (37.7479358093949, -122.390602150165) | ||||
| 140550 | 140550 | 116849 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 83 Panorama Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | |||
| 147478 | 147478 | 177648 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Tocoloma Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 6012427.630469999 | 2086427.74351 | 37.7096332265644 | -122.398799765591 | (37.7096332265644, -122.398799765591) | |||
| 150158 | 150158 | 193818 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Tulare St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015085.697980001 | 2100310.3734 | 37.7478998913736 | -122.390582378571 | (37.7478998913736, -122.390582378571) | ||||
| 153886 | 153886 | 177650 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Tocoloma Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 5ft | 6012434.26652 | 2086449.4800599997 | 37.7096932805964 | -122.39877835455201 | (37.7096932805964, -122.398778354552) | |||
| 154599 | 154599 | 177647 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 451 Tocoloma Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 5ft | 6012423.949469999 | 2086414.60679 | 37.7095969506192 | -122.398811566514 | (37.7095969506192, -122.398811566514) | |||
| 172642 | 172642 | 193817 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Tulare St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6015100.80126 | 2100307.8332 | 37.747893754394205 | -122.390529974205 | (37.7478937543942, -122.390529974205) | ||||
| 175732 | 175732 | 249934 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 345 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 6011220.75334 | 2120024.0866900003 | 37.8018140268525 | -122.40533533227101 | (37.8018140268525, -122.405335332271) | |||
| 177116 | 177116 | 193816 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 300 Tulare St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015118.62426 | 2100316.39595 | 37.74791825464221 | -122.390468940782 | (37.7479182546422, -122.390468940782) | ||||
| 179074 | 179074 | 201933 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 190 Boutwell St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 9ft | 6010622.819180001 | 2095611.5496200002 | 37.7347493344117 | -122.405683976059 | (37.7347493344117, -122.405683976059) | |||
| 78 | 78 | 251199 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3X3 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | ||||
| 93 | 93 | 251198 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | |||||
| 95 | 95 | 251197 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | Permit Number 779570 | 6002798.55883 | 2107703.57748 | 37.7675105430125 | -122.43359899801901 | (37.7675105430125, -122.433598998019) | ||
| 1272 | 1272 | 251489 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 31 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1282 | 1282 | 251482 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1283 | 1283 | 251493 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 35 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1286 | 1286 | 251492 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 34 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1288 | 1288 | 251487 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 29 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1290 | 1290 | 251486 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 28 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1295 | 1295 | 251491 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 33 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1298 | 1298 | 251490 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 32 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1299 | 1299 | 251494 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 36 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1310 | 1310 | 251480 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 51 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6010641.0 | 2100362.0 | 37.747794064611604 | -122.40595565659201 | (37.7477940646116, -122.405955656592) | ||||
| 1316 | 1316 | 251488 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 30 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1322 | 1322 | 251483 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1332 | 1332 | 251484 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 7 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1338 | 1338 | 251485 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 2100 | 2100 | 178279 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 4 | Width 0ft | 5987917.15522 | 2088760.91322 | 37.714643374877895 | -122.48368218070499 | (37.7146433748779, -122.483682180705) | |||
| 2859 | 2859 | 253251 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 2869 | 2869 | 253250 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 2874 | 2874 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 3034 | 3034 | 253070 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 132 Sagamore St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 0ft | Permit Number 780451 | 5995539.3842400005 | 2087458.9579900003 | 37.7115092483173 | -122.45724268539699 | (37.7115092483173, -122.457242685397) | |||
| 3138 | 3138 | 253254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 270 Castenada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 4553 | 4553 | 253637 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 701 Noe St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6003144.80454 | 2104133.37104 | 37.757727257313704 | -122.43214639144101 | (37.7577272573137, -122.432146391441) | ||||
| 7810 | 7810 | 119607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 299x Avalon Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 8128 | 8128 | 87100 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 700 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 50056 | ||||||||
| 9641 | 9641 | 114157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9643 | 9643 | 114152 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9644 | 9644 | 114150 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9647 | 9647 | 114149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9651 | 9651 | 114156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9656 | 9656 | 114151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) |
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");