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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 117009 | 117009 | 112004 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 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) | |||||
| 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) | ||||
| 120079 | 120079 | 186675 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401 Sunset Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984701.897000001 | 2105453.5805 | 37.760289275720204 | -122.496026006908 | (37.7602892757202, -122.496026006908) | |||
| 120273 | 120273 | 113891 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x STORRIE ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 12 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | ||||
| 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) | |||||
| 121140 | 121140 | 112006 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 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) | ||||
| 122028 | 122028 | 186674 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984709.4341 | 2105459.8614 | 37.760306962768205 | -122.49600040337201 | (37.7603069627682, -122.496000403372) | |||
| 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) | |||
| 125466 | 125466 | 110020 | Myoporum laetum :: Myoporum 1 | 1490X Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9x9 | 6001386.81709 | 2099547.0285 | 37.745034430207795 | -122.437897729467 | (37.7450344302078, -122.437897729467) | |||||
| 127458 | 127458 | 112008 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Red Rock Way | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | |||||
| 129592 | 129592 | 186830 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1200 Sunset Blvd | 93 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984826.8059 | 2106580.9981 | 37.7633921640535 | -122.49567717299999 | (37.7633921640535, -122.495677173) | |||
| 130581 | 130581 | 187395 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2100 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985039.3656 | 2100676.2331 | 37.7471917561772 | -122.494506696584 | (37.7471917561772, -122.494506696584) | |||
| 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) | ||||
| 131528 | 131528 | 186676 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984702.3158 | 2105448.5558 | 37.76027550382771 | -122.496024187798 | (37.7602755038277, -122.496024187798) | |||
| 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) | ||||
| 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) | |||
| 133386 | 133386 | 181383 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1500 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984896.421 | 2104481.2352 | 37.757630877743395 | -122.495281541299 | (37.7576308777434, -122.495281541299) | |||
| 133947 | 133947 | 210553 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 6 Locksley Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 5994306.7966 | 2105015.90747 | 37.75964542581129 | -122.462775658193 | (37.7596454258113, -122.462775658193) | |||
| 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) | ||||
| 135456 | 135456 | 131715 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3250 Pacific Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998491.43186 | 2116566.313 | 37.791599990194705 | -122.449135267491 | (37.7915999901947, -122.449135267491) | |||
| 136891 | 136891 | 187355 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2200 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985062.7652 | 2099776.5974 | 37.744722970464395 | -122.494359480034 | (37.7447229704644, -122.494359480034) | |||
| 136974 | 136974 | 185882 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2000 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985026.8493 | 2101115.2901 | 37.7483965544335 | -122.494582338742 | (37.7483965544335, -122.494582338742) | |||
| 137429 | 137429 | 187354 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2200 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985070.2132 | 2099768.1337 | 37.7447001673089 | -122.49433310291401 | (37.7447001673089, -122.494333102914) | |||
| 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) | |||||
| 141460 | 141460 | 110877 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 INDIANA ST | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 146470 | 146470 | 185630 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2100 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985046.8517 | 2100330.1165 | 37.74624185231129 | -122.494455300367 | (37.7462418523113, -122.494455300367) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 150167 | 150167 | 210559 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 140 Hernandez Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 3ft | 5995558.80371 | 2099639.21584 | 37.744954417407705 | -122.45805649901699 | (37.7449544174077, -122.458056499017) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 152167 | 152167 | 184536 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1918 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5981680.2279 | 2102012.5409 | 37.7506637118715 | -122.50622120268801 | (37.7506637118715, -122.506221202688) | |||
| 154803 | 154803 | 184534 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1906 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5981676.8437 | 2102069.7342 | 37.7508205493518 | -122.506237145813 | (37.7508205493518, -122.506237145813) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 161967 | 161967 | 186844 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2034 Lower Great Hwy | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5981219.1453 | 2101186.094 | 37.7483673667876 | -122.507754314909 | (37.7483673667876, -122.507754314909) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 173881 | 173881 | 232322 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1430 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 6ft | 6001368.29061 | 2099487.1068599997 | 37.7448688460173 | -122.437957499335 | (37.7448688460173, -122.437957499335) | |||
| 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) | |||
| 177097 | 177097 | 181430 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1500 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984894.5136 | 2104851.8242 | 37.7586483004402 | -122.495315467353 | (37.7586483004402, -122.495315467353) | |||
| 179465 | 179465 | 118837 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 600 46th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5981666.867000001 | 2111590.99028 | 37.776962590483606 | -122.506977842076 | (37.7769625904836, -122.506977842076) | |||
| 179582 | 179582 | 131713 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3250 Pacific Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998501.34187 | 2116568.43338 | 37.791606378991 | -122.449101131933 | (37.791606378991, -122.449101131933) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 181337 | 181337 | 186724 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984849.7405 | 2106204.9407 | 37.762360958924106 | -122.49557011228998 | (37.7623609589241, -122.49557011229) | |||
| 181863 | 181863 | 131761 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 24 Priest St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6008326.19973 | 2117161.77492 | 37.7937925706325 | -122.415149139144 | (37.7937925706325, -122.415149139144) | |||
| 182075 | 182075 | 186798 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1200 Sunset Blvd | 76 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984847.2394 | 2106906.9776 | 37.7642884087703 | -122.495630546663 | (37.7642884087703, -122.495630546663) | |||
| 182170 | 182170 | 185694 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2101 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984861.0881 | 2100529.8889 | 37.7467794993444 | -122.495112367353 | (37.7467794993444, -122.495112367353) | |||
| 184453 | 184453 | 131714 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3250 Pacific Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998496.90584 | 2116567.36238 | 37.791603184595104 | -122.44911640329398 | (37.7916031845951, -122.449116403294) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 188122 | 188122 | 184539 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1939 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 0ft | 5981627.7505 | 2101868.0843 | 37.7502639852004 | -122.50639195948 | (37.7502639852004, -122.50639195948) | |||
| 189002 | 189002 | 186741 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1200 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984866.449 | 2106632.432 | 37.7635357085517 | -122.495543856208 | (37.7635357085517, -122.495543856208) | |||
| 3811 | 3811 | 177743 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401 Ocean Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 37 | 5998700.41574 | 2091522.98281 | 37.722849171448395 | -122.446609585371 | (37.7228491714484, -122.446609585371) | ||||
| 11273 | 11273 | 102842 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 23443 | 23443 | 248249 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 Lundy's Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6006859.99776 | 2099020.88579 | 37.743899476678706 | -122.418935096973 | (37.7438994766787, -122.418935096973) | |||
| 23916 | 23916 | 177744 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 65 Ocean Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001008.85116 | 2091721.5574 | 37.7235260030036 | -122.438644049011 | (37.7235260030036, -122.438644049011) | ||||
| 24994 | 24994 | 213252 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 239 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 5991927.67162 | 2090111.22138 | 37.718583625819896 | -122.46991858290001 | (37.7185836258199, -122.4699185829) | |||
| 28866 | 28866 | 185063 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20 Crestlake Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 0ft | 5989067.2897 | 2096124.6086 | 37.7349290995059 | -122.48024552557101 | (37.7349290995059, -122.480245525571) | |||
| 29896 | 29896 | 186986 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2501 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984962.5627 | 2098118.8813 | 37.74016546549171 | -122.494583771373 | (37.7401654654917, -122.494583771373) | |||
| 30410 | 30410 | 185377 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3001 Vicente St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5983769.731000001 | 2097427.474 | 37.7381971614622 | -122.49865697347401 | (37.7381971614622, -122.498656973474) | |||
| 30759 | 30759 | 131596 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2350 Hyde St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 6007094.878819999 | 2120403.74203 | 37.80262492397 | -122.419639759879 | (37.80262492397, -122.419639759879) | |||
| 31051 | 31051 | 186988 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2501 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984944.4036 | 2098106.7752 | 37.7401311625536 | -122.494645664988 | (37.7401311625536, -122.494645664988) | |||
| 31478 | 31478 | 185373 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983730.9017 | 2096817.0859 | 37.7365189235088 | -122.498746144318 | (37.7365189235088, -122.498746144318) | |||
| 32081 | 32081 | 210426 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 155 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5995475.97759 | 2095557.3556400002 | 37.73374187518571 | -122.458047544471 | (37.7337418751857, -122.458047544471) | |||
| 33392 | 33392 | 187108 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985154.9931 | 2097244.7147 | 37.7377764992933 | -122.493854030446 | (37.7377764992933, -122.493854030446) | |||
| 35784 | 35784 | 232261 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 104 Everson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6003166.708269999 | 2097064.6956599997 | 37.738319571887494 | -122.431566002265 | (37.7383195718875, -122.431566002265) | |||
| 36498 | 36498 | 131280 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5 Locust St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 5997468.25755 | 2116167.34443 | 37.790445955853 | -122.452646614646 | (37.790445955853, -122.452646614646) | |||
| 37050 | 37050 | 232558 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 665 Elizabeth St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6002164.87583 | 2102045.53482 | 37.7519389517211 | -122.435386037248 | (37.7519389517211, -122.435386037248) | |||
| 37259 | 37259 | 177749 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 65 Ocean Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6001147.04243 | 2091731.7631 | 37.7235618859526 | -122.43816707826201 | (37.7235618859526, -122.438167078262) | ||||
| 37439 | 37439 | 210441 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 62 Paradise Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6000989.00514 | 2096059.11065 | 37.735434797677705 | -122.439023365936 | (37.7354347976777, -122.439023365936) | |||
| 37866 | 37866 | 232257 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 339 Addison St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 6002207.399780001 | 2097695.06834 | 37.739996008897705 | -122.43492788481501 | (37.7399960088977, -122.434927884815) | |||
| 38607 | 38607 | 119972 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 634 28th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5987253.43236 | 2111593.9712799997 | 37.7772981958937 | -122.487652666537 | (37.7772981958937, -122.487652666537) | |||
| 39880 | 39880 | 186983 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2501 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984941.3771 | 2098124.5981 | 37.740179922295496 | -122.494657442871 | (37.7401799222955, -122.494657442871) | |||
| 43214 | 43214 | 213134 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 530 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5997220.3623 | 2094134.58206 | 37.729935351616 | -122.45191411145599 | (37.729935351616, -122.451914111456) | ||||
| 43936 | 43936 | 185367 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Wawona St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5983890.4172 | 2096823.9573 | 37.7365471449614 | -122.49819514730301 | (37.7365471449614, -122.498195147303) | |||
| 45636 | 45636 | 232263 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 122 Everson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6002994.96825 | 2097111.7756700001 | 37.7384391070712 | -122.43216315573099 | (37.7384391070712, -122.432163155731) | |||
| 46355 | 46355 | 210451 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 801 Ocean Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 4ft | 5998008.5461800005 | 2091535.2933 | 37.722843428355 | -122.449002108475 | (37.722843428355, -122.449002108475) | |||
| 46794 | 46794 | 131391 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2401 Broadway | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6002044.60468 | 2117339.0639400003 | 37.793924346483294 | -122.43689669324199 | (37.7939243464833, -122.436896693242) |
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");