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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15790 | 15790 | 87061 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | unknown : Yard 19 | Tree 1 | Private 1 | 3x3 | Permit Number 50003 | ||||||||||
| 27191 | 27191 | 186631 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 7 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980860.0426 | 2105683.7293 | 37.7606954284135 | -122.50933003298901 | (37.7606954284135, -122.509330032989) | |||
| 73687 | 73687 | 186630 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980860.7453 | 2105672.8381 | 37.7606655657469 | -122.50932679385099 | (37.7606655657469, -122.509326793851) | |||
| 155462 | 155462 | 186632 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 8 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980861.0966 | 2105687.2426 | 37.7607051370684 | -122.509326648666 | (37.7607051370684, -122.509326648666) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 174389 | 174389 | 186633 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 9 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980876.555 | 2105686.5399 | 37.760704119089 | -122.509273133786 | (37.760704119089, -122.509273133786) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 153024 | 153024 | 186626 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1300 Lower Great Hwy | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5980879.19 | 2105650.5288 | 37.7606053983358 | -122.509261346313 | (37.7606053983358, -122.509261346313) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 167264 | 167264 | 186490 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1400 Lower Great Hwy | 36 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5980883.265 | 2105397.7493 | 37.7599115788226 | -122.509228480711 | (37.7599115788226, -122.509228480711) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 166154 | 166154 | 186488 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Lower Great Hwy | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5980888.4423 | 2105382.2174 | 37.7598692379346 | -122.50920942183998 | (37.7598692379346, -122.50920942184) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 29234 | 29234 | 186513 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980894.1374 | 2105147.1675 | 37.759224194224 | -122.509172270667 | (37.759224194224, -122.509172270667) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 182655 | 182655 | 186512 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980899.8324 | 2105147.1675 | 37.7592245299801 | -122.509152574968 | (37.7592245299801, -122.509152574968) | |||
| 50995 | 50995 | 186509 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 10 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5980901.3856 | 2105130.6001 | 37.759179132228 | -122.509145973072 | (37.759179132228, -122.509145973072) | |||
| 66913 | 66913 | 186510 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1400 Lower Great Hwy | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980902.4211 | 2105136.8129 | 37.759196251841395 | -122.509142853237 | (37.7591962518414, -122.509142853237) | |||
| 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) | |||
| 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) | |||
| 134829 | 134829 | 186518 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1400 Lower Great Hwy | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980903.7154 | 2105000.9085 | 37.758823173681606 | -122.50912828496901 | (37.7588231736816, -122.509128284969) | |||
| 168385 | 168385 | 186505 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1400 Lower Great Hwy | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980903.7154 | 2105004.5327 | 37.7588331246947 | -122.509128554095 | (37.7588331246947, -122.509128554095) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 146760 | 146760 | 186517 | Undocumented 2 | Pinus halepensis :: Allepo Pine 164 | 1400 Lower Great Hwy | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 5980906.8218 | 2104997.2844 | 37.7588134060814 | -122.509117272676 | (37.7588134060814, -122.509117272676) | |||
| 131395 | 131395 | 183037 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 2523 43rd Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5983009.062000001 | 2097931.9719 | 37.7395377337872 | -122.50132425344299 | (37.7395377337872, -122.501324253443) | |||
| 24598 | 24598 | 186532 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984706.503 | 2104907.5647 | 37.7587903384946 | -122.49596979583599 | (37.7587903384946, -122.495969795836) | |||
| 48440 | 48440 | 186534 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984706.503 | 2104895.4217 | 37.758756997201 | -122.49596890002701 | (37.758756997201, -122.495968900027) | |||
| 187425 | 187425 | 186568 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 39 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984708.7013 | 2104680.5118 | 37.7581670432315 | -122.495945443345 | (37.7581670432315, -122.495945443345) | |||
| 47539 | 47539 | 186530 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984710.6902 | 2104914.2643 | 37.7588089789692 | -122.495955809021 | (37.7588089789692, -122.495955809021) | |||
| 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) | |||
| 178921 | 178921 | 186554 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5984714.9821 | 2104746.2514 | 37.7583479137241 | -122.495928571528 | (37.7583479137241, -122.495928571528) | |||
| 59949 | 59949 | 186544 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984717.8085 | 2104869.8796 | 37.7586875278599 | -122.495927916751 | (37.7586875278599, -122.495927916751) | |||
| 180584 | 180584 | 186563 | Undocumented 2 | Araucaria araucana :: Monkey puzzle 154 | 1501 Sunset Blvd | 34 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984717.9132 | 2104705.2165 | 37.7582354149831 | -122.495915407531 | (37.7582354149831, -122.495915407531) | |||
| 172749 | 172749 | 186574 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 45 | unknown : Yard 19 | Tree 1 | Private 1 | 46 | Width 0ft | 5984720.0068 | 2104642.8266 | 37.7580642323025 | -122.495903564638 | (37.7580642323025, -122.495903564638) | |||
| 162494 | 162494 | 186583 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1501 Sunset Blvd | 54 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 5984720.8443 | 2104581.693 | 37.757896425499794 | -122.49589615853 | (37.7578964254998, -122.49589615853) | |||
| 150075 | 150075 | 186582 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1501 Sunset Blvd | 53 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5984722.9379 | 2104579.1806 | 37.757889649764294 | -122.495888732757 | (37.7578896497643, -122.495888732757) | |||
| 172365 | 172365 | 186543 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 14 | unknown : Yard 19 | Tree 1 | Private 1 | 21 | Width 0ft | 5984724.0894 | 2104873.2294 | 37.7586970933352 | -122.495906441969 | (37.7586970933352, -122.495906441969) | |||
| 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) | |||
| 182562 | 182562 | 186564 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1501 Sunset Blvd | 35 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984731.3124 | 2104697.6794 | 37.7582155049555 | -122.49586851196199 | (37.7582155049555, -122.495868511962) | |||
| 62916 | 62916 | 186533 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984732.4639 | 2104901.2839 | 37.7587746136444 | -122.495879549084 | (37.7587746136444, -122.495879549084) | |||
| 132337 | 132337 | 186535 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 6 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984732.8826 | 2104894.5843 | 37.7587562429314 | -122.495877606831 | (37.7587562429314, -122.495877606831) | |||
| 48044 | 48044 | 186542 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984733.3013 | 2104876.5792 | 37.7587068304654 | -122.495874830593 | (37.7587068304654, -122.495874830593) | |||
| 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) | |||
| 55505 | 55505 | 186565 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1501 Sunset Blvd | 36 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984733.8247 | 2104692.236 | 37.7582007060302 | -122.49585942192302 | (37.7582007060302, -122.495859421923) | |||
| 136486 | 136486 | 186550 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 42 | Width 0ft | 5984736.7558 | 2104791.4736 | 37.7584733565115 | -122.49585660551 | (37.7584733565115, -122.49585660551) | |||
| 47580 | 47580 | 186579 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1501 Sunset Blvd | 50 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984739.2681 | 2104595.0921 | 37.7579342947119 | -122.495833430643 | (37.7579342947119, -122.495833430643) | |||
| 34443 | 34443 | 186561 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 85 | Width 0ft | 5984740.943 | 2104715.6846 | 37.758265506246296 | -122.495836533834 | (37.7582655062463, -122.495836533834) | |||
| 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) | |||
| 146842 | 146842 | 186566 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1501 Sunset Blvd | 37 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5984742.1992 | 2104682.6054 | 37.7581747535408 | -122.49582974929 | (37.7581747535408, -122.49582974929) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 169801 | 169801 | 186556 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 27 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984748.0613 | 2104746.2514 | 37.7583498510528 | -122.495814170782 | (37.7583498510528, -122.495814170782) | |||
| 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) | |||
| 34988 | 34988 | 186555 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 26 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5984748.8988 | 2104750.8574 | 37.7583625468943 | -122.495811614145 | (37.7583625468943, -122.495811614145) | |||
| 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) | |||
| 53419 | 53419 | 186531 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1501 Sunset Blvd | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 5984751.3064 | 2104919.289 | 37.7588251541556 | -122.49581571217699 | (37.7588251541556, -122.495815712177) | |||
| 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) | |||
| 137799 | 137799 | 186560 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1501 Sunset Blvd | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5984754.3422 | 2104716.1033 | 37.7582674405997 | -122.495790225123 | (37.7582674405997, -122.495790225123) | |||
| 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) | |||
| 147307 | 147307 | 186567 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 38 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984755.1796 | 2104685.1177 | 37.7581824118079 | -122.49578504343799 | (37.7581824118079, -122.495785043438) | |||
| 174920 | 174920 | 186558 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1501 Sunset Blvd | 29 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5984755.5984 | 2104741.6454 | 37.7583376456641 | -122.495787764797 | (37.7583376456641, -122.495787764797) | |||
| 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) | |||
| 34689 | 34689 | 186540 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984760.5184 | 2104876.1604 | 37.7587072745291 | -122.49578067192199 | (37.7587072745291, -122.495780671922) | |||
| 64027 | 64027 | 186552 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984760.623 | 2104776.3995 | 37.758433365006105 | -122.49577295137699 | (37.7584333650061, -122.495772951377) | |||
| 179756 | 179756 | 186570 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1501 Sunset Blvd | 41 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5984760.623 | 2104719.4531 | 37.7582770060448 | -122.495768750789 | (37.7582770060448, -122.495768750789) | |||
| 174794 | 174794 | 186572 | Undocumented 2 | Araucaria araucana :: Monkey puzzle 154 | 1501 Sunset Blvd | 43 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984761.0418 | 2104653.2947 | 37.7580953780168 | -122.495762422342 | (37.7580953780168, -122.495762422342) | |||
| 39570 | 39570 | 186559 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 30 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984761.8792 | 2104726.5714 | 37.7582966244824 | -122.495764931436 | (37.7582966244824, -122.495764931436) | |||
| 178107 | 178107 | 186569 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 40 | unknown : Yard 19 | Tree 1 | Private 1 | 26 | Width 0ft | 5984763.5541 | 2104672.9747 | 37.7581495609485 | -122.49575518551701 | (37.7581495609485, -122.495755185517) | |||
| 150480 | 150480 | 186577 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 48 | unknown : Yard 19 | Tree 1 | Private 1 | 29 | Width 0ft | 5984764.3916 | 2104600.9543 | 37.75795186201471 | -122.495746976697 | (37.7579518620147, -122.495746976697) | |||
| 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) | |||
| 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) |
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");