Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 39317 | 39317 | 186508 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Lower Great Hwy | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980903.4565 | 2105112.4796 | 37.759129500629896 | -122.50913746543199 | (37.7591295006299, -122.509137465432) | |||
| 52895 | 52895 | 186634 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1300 Lower Great Hwy | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980874.0957 | 2105690.7559 | 37.7607155500113 | -122.509281952349 | (37.7607155500113, -122.509281952349) | |||
| 155117 | 155117 | 186636 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1300 Lower Great Hwy | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980864.6099 | 2105729.0507 | 37.7608201372164 | -122.509317602916 | (37.7608201372164, -122.509317602916) | |||
| 180173 | 180173 | 186625 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1300 Lower Great Hwy | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980868.2988 | 2105582.371 | 37.76041761449721 | -122.50929395155 | (37.7604176144972, -122.50929395155) | |||
| 182401 | 182401 | 186519 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Lower Great Hwy | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980902.9388 | 2105057.6001 | 37.758978786758 | -122.509135180581 | (37.758978786758, -122.509135180581) | |||
| 27414 | 27414 | 186546 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5984749.2128 | 2104853.9681 | 37.758645678551105 | -122.495818134238 | (37.7586456785511, -122.495818134238) | |||
| 30516 | 30516 | 185495 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 48 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985112.4406 | 2098617.3174 | 37.74154280788321 | -122.494102288748 | (37.7415428078832, -122.494102288748) | |||
| 34066 | 34066 | 185473 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | Width 0ft | 5985104.4721 | 2098432.7145 | 37.741035471775206 | -122.494116238038 | (37.7410354717752, -122.494116238038) | |||
| 35563 | 35563 | 186575 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 46 | unknown : Yard 19 | Tree 1 | Private 1 | 30 | Width 0ft | 5984766.4852 | 2104638.2207 | 37.75805430778821 | -122.49574248511298 | (37.7580543077882, -122.495742485113) | |||
| 38464 | 38464 | 185405 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 23 | Width 0ft | 5985107.634 | 2099090.4168 | 37.7428415299236 | -122.494153769583 | (37.7428415299236, -122.494153769583) | |||
| 39945 | 39945 | 181359 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 22 | Width 0ft | 5985110.4485 | 2098473.2209 | 37.741147041149 | -122.494098558838 | (37.741147041149, -122.494098558838) | |||
| 41710 | 41710 | 185491 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 44 | unknown : Yard 19 | Tree 1 | Private 1 | 11 | Width 0ft | 5985120.4091 | 2098579.4672 | 37.7414393477039 | -122.494071947824 | (37.7414393477039, -122.494071947824) | |||
| 45919 | 45919 | 185477 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 29 | unknown : Yard 19 | Tree 1 | Private 1 | 38 | Width 0ft | 5985132.3618 | 2098455.9558 | 37.741100918055295 | -122.494021519499 | (37.7411009180553, -122.494021519499) | |||
| 52764 | 52764 | 185481 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 26 | Width 0ft | 5985135.017999999 | 2098495.7982 | 37.741210469977105 | -122.49401527111799 | (37.7412104699771, -122.494015271118) | |||
| 57913 | 57913 | 185415 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 16 | Width 0ft | 5985091.6384 | 2099216.8819 | 37.743187832897 | -122.494218396427 | (37.743187832897, -122.494218396427) | |||
| 58500 | 58500 | 186538 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 29 | Width 0ft | 5984747.9566 | 2104882.4413 | 37.7587237844572 | -122.495824579043 | (37.7587237844572, -122.495824579043) | |||
| 60510 | 60510 | 181353 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 34 | Width 0ft | 5985103.1353 | 2099041.4304 | 37.7427067632535 | -122.49416571483 | (37.7427067632535, -122.49416571483) | |||
| 61772 | 61772 | 185468 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985131.0337 | 2098396.1923 | 37.7409367458634 | -122.494021708019 | (37.7409367458634, -122.494021708019) | |||
| 64302 | 64302 | 181358 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 11 | Width 0ft | 5985132.3618 | 2098384.2396 | 37.7409040046765 | -122.49401623531 | (37.7409040046765, -122.49401623531) | |||
| 65848 | 65848 | 186549 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | Width 0ft | 5984751.8298 | 2104797.3357 | 37.7584903350171 | -122.495804906083 | (37.7584903350171, -122.495804906083) | |||
| 66024 | 66024 | 87113 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 67760 | 67760 | 186557 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 28 | unknown : Yard 19 | Tree 1 | Private 1 | 36 | Width 0ft | 5984754.7609 | 2104747.5076 | 37.758353692586 | -122.49579109362101 | (37.758353692586, -122.495791093621) | |||
| 72947 | 72947 | 186547 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 49 | Width 0ft | 5984724.5081 | 2104844.7562 | 37.7586189383832 | -122.495902893491 | (37.7586189383832, -122.495902893491) | |||
| 78014 | 78014 | 107210 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 603 PERALTA AVE | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 30 | 6009839.9 | 2098688.7 | 37.7431547125392 | -122.40860781001498 | (37.7431547125392, -122.408607810015) | ||||
| 85853 | 85853 | 114950 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1X WOODACRE DR | 2 | unknown : Yard 19 | Tree 1 | DPW 2 | 30x100 | 5991187.0 | 2095315.0 | 37.732829063550795 | -122.47285799850201 | (37.7328290635508, -122.472857998502) | ||||
| 89237 | 89237 | 87112 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 98700 | 98700 | 105140 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 125X ESMERALDA AVE | 1 | unknown : Yard 19 | Tree 1 | DPW 2 | 12 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
| 109114 | 109114 | 105137 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 175X ESMERALDA AVE | 3 | unknown : Yard 19 | Tree 1 | DPW 2 | 18 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
| 111345 | 111345 | 114949 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1X WOODACRE DR | 1 | unknown : Yard 19 | Tree 1 | DPW 2 | 30 | 30x100 | 5991187.0 | 2095315.0 | 37.732829063550795 | -122.47285799850201 | (37.7328290635508, -122.472857998502) | |||
| 116169 | 116169 | 87111 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 117494 | 117494 | 107817 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 501X BROTHERHOOD WAY | unknown : Yard 19 | Tree 1 | DPW 2 | 5991892.0 | 2087849.0 | 37.712370053151204 | -122.469877266524 | (37.7123700531512, -122.469877266524) | ||||||
| 131653 | 131653 | 185498 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 52 | unknown : Yard 19 | Tree 1 | Private 1 | 33 | Width 0ft | 5985102.48 | 2098665.7923 | 37.74167532404589 | -122.494140300571 | (37.7416753240459, -122.494140300571) | |||
| 132393 | 132393 | 185426 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 42 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5985086.6398 | 2099317.3541 | 37.7434634098799 | -122.49424308404801 | (37.7434634098799, -122.494243084048) | |||
| 133868 | 133868 | 185475 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 27 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5985123.7293 | 2098442.675 | 37.7410639474436 | -122.494050388555 | (37.7410639474436, -122.494050388555) | |||
| 135953 | 135953 | 185480 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 33 | unknown : Yard 19 | Tree 1 | Private 1 | 16 | Width 0ft | 5985125.7214 | 2098482.5174 | 37.7411734605092 | -122.49404643640601 | (37.7411734605092, -122.494046436406) | |||
| 137933 | 137933 | 185406 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5985111.1331 | 2099102.9134 | 37.742876046964604 | -122.494142591708 | (37.7428760469646, -122.494142591708) | |||
| 139638 | 139638 | 105139 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 175X ESMERALDA AVE | 4 | unknown : Yard 19 | Tree 1 | DPW 2 | 25 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
| 141981 | 141981 | 87114 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 143327 | 143327 | 87115 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 143716 | 143716 | 105138 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 175X ESMERALDA AVE | 4 | unknown : Yard 19 | Tree 1 | DPW 2 | 25 | 6007213.0 | 2098808.0 | 37.7433348108676 | -122.41769940776301 | (37.7433348108676, -122.417699407763) | ||||
| 147019 | 147019 | 186536 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 23 | Width 0ft | 5984741.2571 | 2104889.1409 | 37.758741787333705 | -122.495848242848 | (37.7587417873337, -122.495848242848) | |||
| 149629 | 149629 | 181352 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985091.6384 | 2099018.9366 | 37.7426443285892 | -122.494203809651 | (37.7426443285892, -122.494203809651) | |||
| 157600 | 157600 | 186576 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 47 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984768.5788 | 2104614.3534 | 37.7579888974289 | -122.495733484153 | (37.7579888974289, -122.495733484153) | |||
| 161360 | 161360 | 185461 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985111.1125 | 2098351.0376 | 37.7408115975576 | -122.494087259969 | (37.7408115975576, -122.494087259969) | |||
| 162312 | 162312 | 185412 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2300 Sunset Blvd | 28 | unknown : Yard 19 | Tree 1 | Private 1 | 47 | Width 0ft | 5985078.1422 | 2099185.3906 | 37.7431005765205 | -122.494262741341 | (37.7431005765205, -122.494262741341) | |||
| 162935 | 162935 | 185479 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 17 | Width 0ft | 5985115.7608 | 2098477.2051 | 37.741158291534504 | -122.494080484656 | (37.7411582915345, -122.494080484656) | |||
| 166847 | 166847 | 185467 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985112.4406 | 2098402.8327 | 37.740953890671896 | -122.49408648444799 | (37.7409538906719, -122.494086484448) | |||
| 180431 | 180431 | 185459 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 28 | Width 0ft | 5985114.4327 | 2098335.7647 | 37.7407698565631 | -122.494074654765 | (37.7407698565631, -122.494074654765) | |||
| 182172 | 182172 | 185464 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 16 | unknown : Yard 19 | Tree 1 | Private 1 | 46 | Width 0ft | 5985103.8081 | 2098378.9273 | 37.740887747752105 | -122.494114570537 | (37.7408877477521, -122.494114570537) | |||
| 182857 | 182857 | 181357 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 25 | Width 0ft | 5985137.6741 | 2098360.3342 | 37.740838677714294 | -122.49399610623999 | (37.7408386777143, -122.49399610624) | |||
| 183109 | 183109 | 186548 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 11 | Width 0ft | 5984713.0979 | 2104804.2446 | 37.7585070365446 | -122.49593936599 | (37.7585070365446, -122.49593936599) | |||
| 185290 | 185290 | 185463 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2400 Sunset Blvd | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5985112.4406 | 2098384.9036 | 37.740904662190104 | -122.494085163354 | (37.7409046621901, -122.494085163354) | |||
| 32088 | 32088 | 186539 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984748.3754 | 2104879.0915 | 37.7587146113666 | -122.49582288356001 | (37.7587146113666, -122.49582288356) | |||
| 41370 | 41370 | 186537 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 14 | Width 0ft | 5984743.3507 | 2104891.2345 | 37.7587476583889 | -122.49584115676501 | (37.7587476583889, -122.495841156765) | |||
| 51500 | 51500 | 185486 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Sunset Blvd | 39 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985131.6978 | 2098522.3598 | 37.7412832067047 | -122.494028708144 | (37.7412832067047, -122.494028708144) | |||
| 55634 | 55634 | 185460 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2400 Sunset Blvd | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5985122.4012 | 2098351.0376 | 37.7408122581003 | -122.49404822844801 | (37.7408122581003, -122.494048228448) | |||
| 130262 | 130262 | 200159 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1043 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 6013947.408 | 2089985.5634 | 37.719486864857004 | -122.39379597620301 | (37.719486864857, -122.393795976203) | |||
| 150157 | 150157 | 186541 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1501 Sunset Blvd | 12 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5984745.863 | 2104876.5792 | 37.7587075661518 | -122.49583138713601 | (37.7587075661518, -122.495831387136) | |||
| 156135 | 156135 | 200237 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 919 Ingerson Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 6014571.1757 | 2089512.0366 | 37.7182212977035 | -122.39160673351002 | (37.7182212977035, -122.39160673351) |
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");