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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36763 | 36763 | 194034 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 18 | : Yard 23 | Tree 1 | Private 1 | 25 | 6017329.2954 | 2102592.85695 | 37.754291333594395 | -122.382982871671 | (37.7542913335944, -122.382982871671) | ||||
| 158947 | 158947 | 194032 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 25th St | 9 | : Yard 23 | Tree 1 | Private 1 | 4 | 6015018.29801 | 2102168.6663599997 | 37.7529986327902 | -122.39094530450599 | (37.7529986327902, -122.390945304506) | ||||
| 162377 | 162377 | 194033 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 9 | : Yard 23 | Tree 1 | Private 1 | 18 | 6017162.02159 | 2102667.2446 | 37.7544863425722 | -122.383566530788 | (37.7544863425722, -122.383566530788) | ||||
| 23747 | 23747 | 186497 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980894.6551 | 2105244.501 | 37.7594914745751 | -122.509177708249 | (37.7594914745751, -122.509177708249) | |||
| 24948 | 24948 | 186573 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 Sunset Blvd | 44 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5984743.4554 | 2104652.876 | 37.758093198452 | -122.49582321186399 | (37.758093198452, -122.495823211864) | |||
| 26814 | 26814 | 185398 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2300 Sunset Blvd | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985116.1317 | 2099019.9363 | 37.7426485067542 | -122.49411919382099 | (37.7426485067542, -122.494119193821) | |||
| 27012 | 27012 | 186514 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980897.7615 | 2105153.3803 | 37.759241466452295 | -122.509160198369 | (37.7592414664523, -122.509160198369) | |||
| 30380 | 30380 | 186493 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980884.8182 | 2105286.9549 | 37.7596074608269 | -122.509214881201 | (37.7596074608269, -122.509214881201) | |||
| 30894 | 30894 | 200231 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1079 Ingerson Ave | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 6013732.1076 | 2090145.865 | 37.719915054156296 | -122.39455141525299 | (37.7199150541563, -122.394551415253) | |||
| 35785 | 35785 | 138256 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5999357.6908 | 2113236.4692 | 37.7825066175753 | -122.44589843946899 | (37.7825066175753, -122.445898439469) | |||
| 44552 | 44552 | 185455 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2400 Sunset Blvd | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985131.0337 | 2098285.2977 | 37.7406322591341 | -122.494013537118 | (37.7406322591341, -122.494013537118) | |||
| 46197 | 46197 | 186496 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 16 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980891.5487 | 2105237.2527 | 37.7594713896823 | -122.509187913256 | (37.7594713896823, -122.509187913256) | |||
| 47007 | 47007 | 186501 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 29 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980893.6197 | 2105317.501 | 37.7596918505514 | -122.50918671014799 | (37.7596918505514, -122.509186710148) | |||
| 49038 | 49038 | 186494 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980884.3005 | 2105262.6215 | 37.7595406177816 | -122.50921486458799 | (37.7595406177816, -122.509214864588) | |||
| 49295 | 49295 | 186515 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980905.2686 | 2104984.8589 | 37.7587791976552 | -122.509121721574 | (37.7587791976552, -122.509121721574) | |||
| 49608 | 49608 | 186504 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980883.7828 | 2105343.3876 | 37.7597623477539 | -122.50922265288601 | (37.7597623477539, -122.509222652886) | |||
| 51431 | 51431 | 186843 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 33 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5980882.2296 | 2105351.6713 | 37.759785000838704 | -122.509228639712 | (37.7597850008387, -122.509228639712) | |||
| 52894 | 52894 | 186485 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 5980894.6551 | 2105298.8627 | 37.7596407361809 | -122.50918174518299 | (37.7596407361809, -122.509181745183) | |||
| 53561 | 53561 | 138259 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 27 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5999063.9407 | 2113176.2302 | 37.782324439437204 | -122.44691034713499 | (37.7823244394372, -122.446910347135) | |||
| 58408 | 58408 | 186491 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5980895.1728 | 2105273.4939 | 37.759571111269004 | -122.509178070846 | (37.759571111269, -122.509178070846) | |||
| 58818 | 58818 | 186492 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 22 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980885.336 | 2105278.6712 | 37.759584746696 | -122.509212475259 | (37.759584746696, -122.509212475259) | |||
| 61319 | 61319 | 186489 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 35 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980878.6055 | 2105387.9124 | 37.759884294807 | -122.509243864844 | (37.759884294807, -122.509243864844) | |||
| 63349 | 63349 | 186499 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 27 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5980882.7473 | 2105311.2882 | 37.7596741509783 | -122.50922385032601 | (37.7596741509783, -122.509223850326) | |||
| 65556 | 65556 | 186486 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 26 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980884.8182 | 2105306.6287 | 37.759661479426796 | -122.509216342217 | (37.7596614794268, -122.509216342217) | |||
| 67056 | 67056 | 138263 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 17 | Width 0ft | 5999038.5591 | 2113167.7696 | 37.7822997587534 | -122.44699754685101 | (37.7822997587534, -122.446997546851) | |||
| 69172 | 69172 | 186627 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980877.609 | 2105668.6222 | 37.760654984387706 | -122.509268157881 | (37.7606549843877, -122.509268157881) | |||
| 69350 | 69350 | 186498 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980888.4423 | 2105252.2669 | 37.7595124312164 | -122.5091997715 | (37.7595124312164, -122.5091997715) | |||
| 70661 | 70661 | 186503 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980885.336 | 2105334.0684 | 37.759736851483396 | -122.50921658916701 | (37.7597368514834, -122.509216589167) | |||
| 129570 | 129570 | 186495 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980891.5487 | 2105262.6215 | 37.7595410451172 | -122.509189797166 | (37.7595410451172, -122.509189797166) | |||
| 131767 | 131767 | 186507 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980898.797 | 2105106.7845 | 37.759113588816 | -122.509153157003 | (37.759113588816, -122.509153157003) | |||
| 133309 | 133309 | 186628 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980874.0957 | 2105652.4611 | 37.760610403518 | -122.509279108369 | (37.760610403518, -122.509279108369) | |||
| 138059 | 138059 | 200229 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1079 Ingerson Ave | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 6013701.2545 | 2090170.6816 | 37.719981480300795 | -122.39465980145201 | (37.7199814803008, -122.394659801452) | |||
| 147843 | 147843 | 186500 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 28 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980882.7473 | 2105316.9833 | 37.7596897880858 | -122.509224273257 | (37.7596897880858, -122.509224273257) | |||
| 148409 | 148409 | 186553 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 Sunset Blvd | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | Width 0ft | 5984733.406 | 2104758.3944 | 37.7583823340555 | -122.495865750271 | (37.7583823340555, -122.495865750271) | |||
| 150810 | 150810 | 186483 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 38 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980878.6055 | 2105409.1394 | 37.7599425780444 | -122.509245441233 | (37.7599425780444, -122.509245441233) | |||
| 157531 | 157531 | 186484 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980883.7828 | 2105293.6854 | 37.7596258798004 | -122.50921896188801 | (37.7596258798004, -122.509218961888) | |||
| 158735 | 158735 | 186635 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980866.0152 | 2105705.863 | 37.7607565533288 | -122.50931102062 | (37.7607565533288, -122.50931102062) | |||
| 167996 | 167996 | 186482 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 37 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980889.9955 | 2105407.5862 | 37.7599389849374 | -122.50920593411199 | (37.7599389849374, -122.509205934112) | |||
| 170571 | 170571 | 186629 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980862.5019 | 2105665.4602 | 37.7606454117292 | -122.50932017074 | (37.7606454117292, -122.50932017074) | |||
| 174165 | 174165 | 186511 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980895.6906 | 2105140.9548 | 37.7592072275053 | -122.509166437696 | (37.7592072275053, -122.509166437696) | |||
| 176494 | 176494 | 186562 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 Sunset Blvd | 33 | unknown : Yard 19 | Tree 1 | Private 1 | 10 | Width 0ft | 5984757.692000001 | 2104711.0786 | 37.758253840349205 | -122.495778269581 | (37.7582538403492, -122.495778269581) | |||
| 178803 | 178803 | 186506 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5980906.3041 | 2105016.4405 | 37.7588659727132 | -122.50912048557801 | (37.7588659727132, -122.509120485578) | |||
| 181911 | 181911 | 186516 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980905.2686 | 2104991.5894 | 37.758797677676704 | -122.509122221366 | (37.7587976776767, -122.509122221366) | |||
| 182255 | 182255 | 186502 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 30 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980892.5842 | 2105334.0684 | 37.7597372788194 | -122.509191521679 | (37.7597372788194, -122.509191521679) | |||
| 26378 | 26378 | 118551 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 8140 Geary Blvd | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 5981667.59483 | 2112398.2493 | 37.7791791285325 | -122.50703522193999 | (37.7791791285325, -122.50703522194) | ||||
| 29143 | 29143 | 248220 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007112.652530001 | 2099342.90806 | 37.7447979012027 | -122.41808429785499 | (37.7447979012027, -122.418084297855) | ||||
| 30481 | 30481 | 247913 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Franconia St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009968.0552900005 | 2098803.93583 | 37.743478301698296 | -122.40817280665001 | (37.7434783016983, -122.40817280665) | ||||
| 35294 | 35294 | 177823 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009246.7312 | 2086449.12039 | 37.7095141743011 | -122.409795064007 | (37.7095141743011, -122.409795064007) | |||
| 40576 | 40576 | 177849 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 104 Woolsey St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6011561.92381 | 2092191.20992 | 37.7254102643617 | -122.40219675676799 | (37.7254102643617, -122.402196756768) | ||||
| 45261 | 45261 | 177822 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | Width 3ft | 6009243.51838 | 2086439.4286099998 | 37.7094873825954 | -122.40980548443899 | (37.7094873825954, -122.409805484439) | |||
| 48879 | 48879 | 177820 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009221.96633 | 2086380.57337 | 37.7093245702546 | -122.409875820418 | (37.7093245702546, -122.409875820418) | |||
| 52499 | 52499 | 248193 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 216 Esmeralda Ave | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6007342.31013 | 2098763.52222 | 37.74321996062879 | -122.417249134357 | (37.7432199606288, -122.417249134357) | ||||
| 52509 | 52509 | 177834 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6005075.62014 | 2092583.76802 | 37.7261239546294 | -122.424647248878 | (37.7261239546294, -122.424647248878) | ||||
| 56892 | 56892 | 248221 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6007127.43713 | 2099336.46972 | 37.744781055094705 | -122.418032719051 | (37.7447810550947, -122.418032719051) | ||||
| 65111 | 65111 | 248192 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 216 Esmeralda Ave | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6007348.90224 | 2098760.26711 | 37.7432113936915 | -122.41722610990101 | (37.7432113936915, -122.417226109901) | ||||
| 65623 | 65623 | 177843 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 51 | 6005078.05129 | 2092608.48476 | 37.726191958666796 | -122.424640601997 | (37.7261919586668, -122.424640601997) | ||||
| 70150 | 70150 | 248180 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 218 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007468.18996 | 2098662.76578 | 37.7429503870626 | -122.416806737143 | (37.7429503870626, -122.416806737143) | ||||
| 119320 | 119320 | 177821 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 3ft | 6009239.86768 | 2086426.74333 | 37.7094523468075 | -122.40981720709101 | (37.7094523468075, -122.409817207091) | |||
| 130946 | 130946 | 177832 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6005040.015980001 | 2092604.7564 | 37.7261795732245 | -122.424771822965 | (37.7261795732245, -122.424771822965) | ||||
| 134143 | 134143 | 247904 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 582 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009836.26109 | 2098719.48806 | 37.743239046039 | -122.408622563902 | (37.743239046039, -122.408622563902) | ||||
| 153822 | 153822 | 177840 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 655 Peru Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6005146.609019999 | 2092568.42927 | 37.7260858467747 | -122.424400753697 | (37.7260858467747, -122.424400753697) | ||||
| 154289 | 154289 | 177842 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6005092.77094 | 2092617.82642 | 37.726218440119 | -122.42459038114599 | (37.726218440119, -122.424590381146) | ||||
| 164474 | 164474 | 177818 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009189.876619999 | 2086285.53025 | 37.7090618027185 | -122.409980023068 | (37.7090618027185, -122.409980023068) | |||
| 165962 | 165962 | 210573 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300 Melrose Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 5998016.4865 | 2095547.09873 | 37.7338593545253 | -122.449263553965 | (37.7338593545253, -122.449263553965) | ||||
| 168100 | 168100 | 177841 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6005100.14116 | 2092616.6598200002 | 37.726215653124704 | -122.424564819721 | (37.7262156531247, -122.424564819721) | ||||
| 168635 | 168635 | 177817 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009184.18934 | 2086265.3806200002 | 37.7090061571804 | -122.409998257729 | (37.7090061571804, -122.409998257729) | |||
| 172858 | 172858 | 187572 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 73 Bishop St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010864.17104 | 2089487.4487 | 37.7179473203875 | -122.404418609237 | (37.7179473203875, -122.404418609237) | ||||
| 175058 | 175058 | 177833 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6005045.58694 | 2092601.1582099998 | 37.726170008036 | -122.42475230858601 | (37.726170008036, -122.424752308586) | ||||
| 182180 | 182180 | 210572 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300 Melrose Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998021.954 | 2095543.6754599998 | 37.7338502677764 | -122.449244404708 | (37.7338502677764, -122.449244404708) | ||||
| 182795 | 182795 | 177819 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009193.28856 | 2086304.97531 | 37.709115386123 | -122.40996960262501 | (37.709115386123, -122.409969602625) | |||
| 188202 | 188202 | 248243 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 296 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6006794.0541900005 | 2099005.53684 | 37.743853618456995 | -122.41916202653299 | (37.743853618457, -122.419162026533) | ||||
| 189026 | 189026 | 248177 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 218 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007380.96811 | 2098703.14115 | 37.743056342490796 | -122.417111187331 | (37.7430563424908, -122.417111187331) | ||||
| 11349 | 11349 | 104508 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 80 Dichiera Ct | 1 | Sidewalk: Curb side : Hanging Pot 15 | Tree 1 | Private 1 | 14 | 5998566.299869999 | 2087993.98473 | 37.7131516918716 | -122.446819386407 | (37.7131516918716, -122.446819386407) | ||||
| 5081 | 5081 | 253792 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5085 | 5085 | 253795 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5092 | 5092 | 253791 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5097 | 5097 | 253793 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5099 | 5099 | 253794 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 76347 | 76347 | 111157 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201x EUGENIA AVE | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006591.0 | 2098138.0 | 37.7414601197382 | -122.419802596536 | (37.7414601197382, -122.419802596536) | ||||
| 79542 | 79542 | 115664 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 601x PERU AVE | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6005068.0 | 2092670.0 | 37.726360298316294 | -122.42467972288401 | (37.7263602983163, -122.424679722884) | ||||
| 82433 | 82433 | 111159 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201x EUGENIA AVE | 6 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006591.0 | 2098138.0 | 37.7414601197382 | -122.419802596536 | (37.7414601197382, -122.419802596536) | ||||
| 87282 | 87282 | 111156 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201x EUGENIA AVE | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006591.0 | 2098138.0 | 37.7414601197382 | -122.419802596536 | (37.7414601197382, -122.419802596536) | ||||
| 93493 | 93493 | 121630 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 96x Valmar Ter | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 12 | 3x3 | 6005224.0 | 2092573.0 | 37.726102766942205 | -122.42413354236 | (37.7261027669422, -122.42413354236) | |||
| 96239 | 96239 | 115665 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 601x PERU AVE | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6005068.0 | 2092670.0 | 37.726360298316294 | -122.42467972288401 | (37.7263602983163, -122.424679722884) | ||||
| 97479 | 97479 | 111154 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201x EUGENIA AVE | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006591.0 | 2098138.0 | 37.7414601197382 | -122.419802596536 | (37.7414601197382, -122.419802596536) | ||||
| 100068 | 100068 | 111158 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201x EUGENIA AVE | 5 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006591.0 | 2098138.0 | 37.7414601197382 | -122.419802596536 | (37.7414601197382, -122.419802596536) | ||||
| 114760 | 114760 | 111155 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201x EUGENIA AVE | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006591.0 | 2098138.0 | 37.7414601197382 | -122.419802596536 | (37.7414601197382, -122.419802596536) | ||||
| 124140 | 124140 | 115663 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 601x PERU AVE | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6005068.0 | 2092670.0 | 37.726360298316294 | -122.42467972288401 | (37.7263602983163, -122.424679722884) | ||||
| 139585 | 139585 | 115666 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 601x PERU AVE | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6005068.0 | 2092670.0 | 37.726360298316294 | -122.42467972288401 | (37.7263602983163, -122.424679722884) | ||||
| 883 | 883 | 251306 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 885 | 885 | 251305 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 13301 | 13301 | 187651 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 175 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998689.0 | 2104063.0 | 37.7572803991188 | -122.447551270828 | (37.7572803991188, -122.447551270828) | |||||
| 27599 | 27599 | 232417 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 173 Everson St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6002718.41885 | 2097663.27226 | 37.7399377058635 | -122.433158722322 | (37.7399377058635, -122.433158722322) | ||||
| 29851 | 29851 | 210532 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 47 Ralston St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 5992170.38695 | 2088246.7586700001 | 37.7134782905637 | -122.46894401367099 | (37.7134782905637, -122.468944013671) | ||||
| 38627 | 38627 | 210531 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 47 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992169.14182 | 2088256.46113 | 37.7135048592377 | -122.46894902289 | (37.7135048592377, -122.46894902289) | ||||
| 828 | 828 | 8634 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999136.363 | 2113194.1665 | 37.7823778250539 | -122.44666108993299 | (37.7823778250539, -122.446661089933) | |||
| 4979 | 4979 | 8629 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999229.0905 | 2113208.3802 | 37.78242214856029 | -122.44634131765899 | (37.7824221485603, -122.446341317659) | |||
| 5433 | 5433 | 8620 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999320.4644 | 2113220.5634 | 37.7824608186771 | -122.446026081758 | (37.7824608186771, -122.446026081758) | |||
| 5798 | 5798 | 8630 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999216.9073 | 2113207.365 | 37.7824186652585 | -122.44638339297501 | (37.7824186652585, -122.446383392975) |
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");