Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48697 | 48697 | 177826 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 89 Belle Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5991639.3875 | 2086487.5926299999 | 37.708617351468895 | -122.47065126593999 | (37.7086173514689, -122.47065126594) | |||
| 42963 | 42963 | 113115 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 81845 | 81845 | 113126 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 82974 | 82974 | 113119 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 88545 | 88545 | 113118 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 94966 | 94966 | 113130 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 95231 | 95231 | 113127 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 100041 | 100041 | 113128 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 109788 | 109788 | 113131 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 109839 | 109839 | 113123 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 120329 | 120329 | 113129 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 138402 | 138402 | 113117 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 27203 | 27203 | 210530 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 717 Sargent St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 5992156.75064 | 2089178.54268 | 37.7160359561589 | -122.46905891645399 | (37.7160359561589, -122.469058916454) | |||
| 27011 | 27011 | 210522 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5995082.26055 | 2089674.2189 | 37.717565568077504 | -122.45898290776 | (37.7175655680775, -122.45898290776) | |||
| 59099 | 59099 | 210525 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 489 Vernon St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5992458.06658 | 2091088.62387 | 37.7212979802935 | -122.46815630197901 | (37.7212979802935, -122.468156301979) | |||
| 107866 | 107866 | 112769 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1X HOWTH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998027.0 | 2091524.0 | 37.722813474972206 | -122.44893750468901 | (37.7228134749722, -122.448937504689) | ||||
| 111205 | 111205 | 112771 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1X HOWTH ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998027.0 | 2091524.0 | 37.722813474972206 | -122.44893750468901 | (37.7228134749722, -122.448937504689) | ||||
| 111811 | 111811 | 112770 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1X HOWTH ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998027.0 | 2091524.0 | 37.722813474972206 | -122.44893750468901 | (37.7228134749722, -122.448937504689) | ||||
| 112482 | 112482 | 112773 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1X HOWTH ST | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998027.0 | 2091524.0 | 37.722813474972206 | -122.44893750468901 | (37.7228134749722, -122.448937504689) | ||||
| 115212 | 115212 | 112774 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1X HOWTH ST | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998027.0 | 2091524.0 | 37.722813474972206 | -122.44893750468901 | (37.7228134749722, -122.448937504689) | ||||
| 121815 | 121815 | 112772 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1X HOWTH ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998027.0 | 2091524.0 | 37.722813474972206 | -122.44893750468901 | (37.7228134749722, -122.448937504689) | ||||
| 117949 | 117949 | 98373 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 701@ de Soto Urbano Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993201.0 | 2091808.0 | 37.7233160913053 | -122.46564044909799 | (37.7233160913053, -122.465640449098) | |||||
| 99055 | 99055 | 98374 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 106 De Soto St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993231.0 | 2091825.0 | 37.7233644995117 | -122.465537980019 | (37.7233644995117, -122.465537980019) | |||||
| 105502 | 105502 | 98375 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 106 De Soto St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993231.0 | 2091825.0 | 37.7233644995117 | -122.465537980019 | (37.7233644995117, -122.465537980019) | |||||
| 123490 | 123490 | 194051 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1598 Bay Shore Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 5ft | 6011883.611959999 | 2091657.73213 | 37.7239633945918 | -122.401047236139 | (37.7239633945918, -122.401047236139) | |||
| 74822 | 74822 | 194102 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1000 Oakdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018083.18788 | 2093260.00153 | 37.7287068084484 | -122.379727324058 | (37.7287068084484, -122.379727324058) | ||||
| 162072 | 162072 | 210516 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 212 Staples Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 5998671.88838 | 2093815.67028 | 37.7291427269309 | -122.44687309392401 | (37.7291427269309, -122.446873093924) | ||||
| 159389 | 159389 | 210517 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 212 Staples Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5998717.163269999 | 2093815.2255099998 | 37.7291440921051 | -122.44671654353998 | (37.7291440921051, -122.44671654354) | ||||
| 135025 | 135025 | 210515 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 443 Gennessee St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997431.02942 | 2094954.3994200001 | 37.732198438912604 | -122.451244915116 | (37.7321984389126, -122.451244915116) | ||||
| 54380 | 54380 | 194099 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 84 Whitney Young Cir | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | 6016735.93504 | 2095074.45923 | 37.733614544669706 | -122.384511236201 | (37.7336145446697, -122.384511236201) | ||||
| 54080 | 54080 | 194100 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 84 Whitney Young Cir | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6016729.78084 | 2095080.8399099999 | 37.7336317244204 | -122.384532957547 | (37.7336317244204, -122.384532957547) | ||||
| 62308 | 62308 | 194101 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 84 Whitney Young Cir | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6016735.28252 | 2095083.6486799999 | 37.733639740984394 | -122.384514132028 | (37.7336397409844, -122.384514132028) | ||||
| 168081 | 168081 | 185107 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2801 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5985026.6173 | 2095934.5241 | 37.73417155402829 | -122.49420133916 | (37.7341715540283, -122.49420133916) | |||
| 63057 | 63057 | 185078 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2801 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985022.8488 | 2096075.8434 | 37.7345593586675 | -122.494224780664 | (37.7345593586675, -122.494224780664) | |||
| 43346 | 43346 | 232404 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3121 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6002909.521240001 | 2095730.50553 | 37.734641610919105 | -122.432359965134 | (37.7346416109191, -122.432359965134) | |||
| 154952 | 154952 | 232405 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3121 Castro St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6002909.5481 | 2095741.7320400001 | 37.734672437875 | -122.432360673818 | (37.734672437875, -122.432360673818) | |||
| 150906 | 150906 | 184983 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2701 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5985011.3339 | 2096668.7562 | 37.7361866651853 | -122.49430828045601 | (37.7361866651853, -122.494308280456) | |||
| 163978 | 163978 | 232291 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1100 San Jose Ave | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 9ft | 6004778.102000001 | 2096680.6709599998 | 37.737356328728104 | -122.42596726120001 | (37.7373563287281, -122.4259672612) | |||
| 27451 | 27451 | 232290 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1100 San Jose Ave | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 9ft | 6004782.10663 | 2096684.4357 | 37.737366892177704 | -122.425953683239 | (37.7373668921777, -122.425953683239) | |||
| 186324 | 186324 | 194062 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 570 Barneveld Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6010992.45281 | 2097208.4358099997 | 37.7391547075314 | -122.404518390821 | (37.7391547075314, -122.404518390821) | ||||
| 59204 | 59204 | 194061 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 570 Barneveld Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6010992.7511 | 2097246.2982 | 37.7392586862341 | -122.404520023974 | (37.7392586862341, -122.404520023974) | ||||
| 161375 | 161375 | 194060 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 570 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6010992.958459999 | 2097279.69333 | 37.73935039371229 | -122.404521657152 | (37.7393503937123, -122.404521657152) | |||
| 72228 | 72228 | 232418 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 43 Harry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6003164.03181 | 2097617.79512 | 37.7398381041414 | -122.43161473293999 | (37.7398381041414, -122.43161473294) | |||
| 43398 | 43398 | 194079 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 495 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6011076.69396 | 2097479.74807 | 37.7399043805938 | -122.404246211905 | (37.7399043805938, -122.404246211905) | ||||
| 152113 | 152113 | 194080 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 495 Barneveld Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6011079.10015 | 2097495.1748 | 37.739946873549 | -122.404238977744 | (37.739946873549, -122.404238977744) | ||||
| 71815 | 71815 | 232416 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 73 Digby St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 6002653.7216300005 | 2097679.65766 | 37.7399790261155 | -122.433383588775 | (37.7399790261155, -122.433383588775) | |||
| 157512 | 157512 | 232412 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 339 Addison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6002143.31914 | 2097691.88801 | 37.7399836378403 | -122.435149221483 | (37.7399836378403, -122.435149221483) | |||
| 53432 | 53432 | 232411 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 339 Addison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6002139.48015 | 2097692.63491 | 37.73998547065629 | -122.43516254851299 | (37.7399854706563, -122.435162548513) | |||
| 70448 | 70448 | 232414 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 297 Addison St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6002492.620630001 | 2097686.70985 | 37.739989248705605 | -122.433941112706 | (37.7399892487056, -122.433941112706) | ||||
| 185068 | 185068 | 194059 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 540 Barneveld Ave | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6011016.84858 | 2097513.47253 | 37.7399936365049 | -122.404455506617 | (37.7399936365049, -122.404455506617) | |||
| 55881 | 55881 | 194081 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 495 Barneveld Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6011081.84717 | 2097512.6776799997 | 37.739995086212204 | -122.404230711204 | (37.7399950862122, -122.404230711204) | ||||
| 26950 | 26950 | 232415 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 297 Addison St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6002483.65032 | 2097689.74607 | 37.7399970763969 | -122.43397234527201 | (37.7399970763969, -122.433972345272) | |||
| 63737 | 63737 | 232410 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 395 Addison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6001971.32528 | 2097704.62819 | 37.7400088512382 | -122.43574481549601 | (37.7400088512382, -122.435744815496) | ||||
| 56910 | 56910 | 232413 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 297 Addison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 2ft | 6002454.82765 | 2097697.74661 | 37.7400174082831 | -122.434072573816 | (37.7400174082831, -122.434072573816) | |||
| 151495 | 151495 | 194058 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 540 Barneveld Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6011019.935319999 | 2097525.87575 | 37.7400278655929 | -122.40444570672199 | (37.7400278655929, -122.404445706722) | |||
| 167388 | 167388 | 194082 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 495 Barneveld Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 6011088.380890001 | 2097569.3881900003 | 37.7401511662306 | -122.404212110497 | (37.7401511662306, -122.404212110497) | |||
| 35930 | 35930 | 194083 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 495 Barneveld Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 9ft | 6011094.10915 | 2097586.53301 | 37.74019856231661 | -122.40419351074199 | (37.7401985623166, -122.404193510742) | |||
| 158431 | 158431 | 194084 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 465 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6011118.05101 | 2097667.49352 | 37.740422200320204 | -122.404116425355 | (37.7404222003202, -122.404116425355) | ||||
| 58935 | 58935 | 194057 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 540 Barneveld Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6011060.3522 | 2097689.69599 | 37.740479939488395 | -122.404317488554 | (37.7404799394884, -122.404317488554) | |||
| 68767 | 68767 | 194085 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 455 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6011132.21966 | 2097711.64553 | 37.7405442239471 | -122.404070541922 | (37.7405442239471, -122.404070541922) | ||||
| 40532 | 40532 | 194056 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 540 Barneveld Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6011070.90937 | 2097720.99852 | 37.740566479465706 | -122.404283188421 | (37.7405664794657, -122.404283188421) | |||
| 57213 | 57213 | 194086 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 455 Barneveld Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6011140.069490001 | 2097730.23514 | 37.7405957056291 | -122.40404470801901 | (37.7405957056291, -122.404044708019) | ||||
| 162140 | 162140 | 194055 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 540 Barneveld Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6011079.14067 | 2097742.4698 | 37.740625894958704 | -122.404256238443 | (37.7406258949587, -122.404256238443) | |||
| 74293 | 74293 | 210566 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 739 Ulloa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5993848.55082 | 2098110.04723 | 37.7406572903047 | -122.463859221646 | (37.7406572903047, -122.463859221646) | |||
| 64199 | 64199 | 194087 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 425 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6011153.61145 | 2097764.18431 | 37.7406896793961 | -122.40400027339899 | (37.7406896793961, -122.404000273399) | ||||
| 61551 | 61551 | 194088 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 425 Barneveld Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6011172.247769999 | 2097813.5052 | 37.7408261452168 | -122.40393930564801 | (37.7408261452168, -122.403939305648) | ||||
| 32406 | 32406 | 194091 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Apparel Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6011263.07589 | 2097812.25269 | 37.7408277801759 | -122.403625166174 | (37.7408277801759, -122.403625166174) | ||||
| 180143 | 180143 | 194090 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Apparel Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6011245.93679 | 2097821.82718 | 37.740853112271 | -122.403685100604 | (37.740853112271, -122.403685100604) | ||||
| 49273 | 49273 | 194089 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Apparel Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6011234.191000001 | 2097831.41118 | 37.740878771736 | -122.403726387581 | (37.740878771736, -122.403726387581) | ||||
| 174939 | 174939 | 194054 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 540 Barneveld Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6011124.462719999 | 2097851.3870099997 | 37.7409274907204 | -122.40410719471599 | (37.7409274907204, -122.404107194716) | |||
| 23867 | 23867 | 232408 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 387 Beacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 6002395.6787 | 2098158.1545599997 | 37.7412782244979 | -122.43430999392099 | (37.7412782244979, -122.434309993921) | |||
| 35126 | 35126 | 232407 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 387 Beacon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 6002378.24615 | 2098178.9986799997 | 37.7413344681098 | -122.434371759352 | (37.7413344681098, -122.434371759352) | |||
| 119719 | 119719 | 85507 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1 Nebraska St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 133296 | 133296 | 232406 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 391 Beacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6002373.90725 | 2098189.51858 | 37.7413631070215 | -122.43438751368099 | (37.7413631070215, -122.434387513681) | |||
| 70190 | 70190 | 232359 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 460 Beacon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6002296.736959999 | 2098462.96978 | 37.7421095596165 | -122.43467389018998 | (37.7421095596165, -122.43467389019) | ||||
| 148347 | 148347 | 194063 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Flower St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 4ft | 6010838.1657 | 2098339.02807 | 37.7422504473898 | -122.40513143798599 | (37.7422504473898, -122.405131437986) | |||
| 180202 | 180202 | 232328 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1801 Diamond St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6002075.48932 | 2098744.22684 | 37.742869262806295 | -122.435459009147 | (37.7428692628063, -122.435459009147) | |||
| 160197 | 160197 | 232329 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1801 Diamond St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 6002075.1191 | 2098772.01072 | 37.7429455298129 | -122.435462276374 | (37.7429455298129, -122.435462276374) | |||
| 106681 | 106681 | 97654 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2331 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5981707.8 | 2099208.6 | 37.7429664967596 | -122.505917998204 | (37.7429664967596, -122.505917998204) | |||||
| 24344 | 24344 | 232330 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1801 Diamond St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6002073.993430001 | 2098798.17814 | 37.743017315492295 | -122.435468040134 | (37.7430173154923, -122.435468040134) | |||
| 156154 | 156154 | 232331 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1801 Diamond St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6002072.189119999 | 2098811.70513 | 37.7430543549658 | -122.43547524639999 | (37.7430543549658, -122.4354752464) | |||
| 159667 | 159667 | 232337 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 691 29th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6002080.83526 | 2098827.25693 | 37.743097547618 | -122.43544646269501 | (37.743097547618, -122.435446462695) | ||||
| 39656 | 39656 | 232338 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 691 29th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6002085.619519999 | 2098828.73569 | 37.743101879661396 | -122.43543002579399 | (37.7431018796614, -122.435430025794) | ||||
| 130847 | 130847 | 232339 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 691 29th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6002094.37196 | 2098830.5273700003 | 37.7431072962705 | -122.435399890387 | (37.7431072962705, -122.435399890387) | ||||
| 180900 | 180900 | 232341 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 689 29th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6002137.6004 | 2098831.04756 | 37.7431111795389 | -122.435250455448 | (37.7431111795389, -122.435250455448) | ||||
| 46568 | 46568 | 232340 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 691 29th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6002112.62766 | 2098832.12217 | 37.7431127119846 | -122.435336881217 | (37.7431127119846, -122.435336881217) | ||||
| 187019 | 187019 | 232344 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 685 29th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6002211.07877 | 2098832.45348 | 37.7431192122771 | -122.434996487813 | (37.7431192122771, -122.434996487813) | ||||
| 172806 | 172806 | 232342 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 687 29th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6002180.92651 | 2098835.3599099996 | 37.74312548054821 | -122.435100953944 | (37.7431254805482, -122.435100953944) | ||||
| 53426 | 53426 | 232343 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 685 29th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6002200.5465400005 | 2098838.1570900003 | 37.7431342750257 | -122.43503331323099 | (37.7431342750257, -122.435033313231) | ||||
| 149768 | 149768 | 232345 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 685 29th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6002209.7238 | 2098837.9673099997 | 37.743134275029 | -122.435001567189 | (37.743134275029, -122.435001567189) | ||||
| 64017 | 64017 | 232346 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 685 29th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6002224.42255 | 2098838.39473 | 37.7431362832177 | -122.434950773465 | (37.7431362832177, -122.434950773465) | ||||
| 186750 | 186750 | 232347 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 683 29th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6002236.903630001 | 2098838.13664 | 37.743136283220004 | -122.434907598826 | (37.74313628322, -122.434907598826) | ||||
| 132239 | 132239 | 232348 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 683 29th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6002262.62266 | 2098838.70205 | 37.743139295941894 | -122.43481870982599 | (37.7431392959419, -122.434818709826) | ||||
| 149963 | 149963 | 187179 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2301 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984914.0932 | 2099227.6174 | 37.7432069184805 | -122.494833083055 | (37.7432069184805, -122.494833083055) | |||
| 160287 | 160287 | 248281 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 105 Lundy's Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 6006851.95643 | 2098931.00797 | 37.7436522395523 | -122.418956528726 | (37.7436522395523, -122.418956528726) | |||
| 171452 | 171452 | 187152 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2301 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984930.5747 | 2099438.914 | 37.7437880464665 | -122.494791670453 | (37.7437880464665, -122.494791670453) | |||
| 53387 | 53387 | 232323 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 689 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 6001401.88129 | 2099374.4805 | 37.7445615107998 | -122.43783328409599 | (37.7445615107998, -122.437833284096) | |||
| 54124 | 54124 | 232324 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 689 28th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 6001424.417119999 | 2099374.2637099996 | 37.7445621969905 | -122.437755344346 | (37.7445621969905, -122.437755344346) | |||
| 66158 | 66158 | 232325 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 689 28th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 8ft | 6001461.4288099995 | 2099378.40597 | 37.7445756751258 | -122.43762766218599 | (37.7445756751258, -122.437627662186) | |||
| 68612 | 68612 | 232326 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 683 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6001524.1187 | 2099381.75589 | 37.744588437417 | -122.43741113332199 | (37.744588437417, -122.437411133322) |
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");