Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16457 | 16457 | 93053 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 36 | Permit Number 53387 | |||||||||
| 81688 | 81688 | 93931 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.5528400003 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | |||||
| 99064 | 99064 | 93932 | Significant Tree 6 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5990375.96797 | 2090932.5528400003 | 37.7207489795508 | -122.475342064841 | (37.7207489795508, -122.475342064841) | |||||
| 11662 | 11662 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 0 Diaz Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.8197400002 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | ||
| 43642 | 43642 | 234528 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 46 | 6002924.2654 | 2095295.03485 | 37.733446743766606 | -122.432277899312 | (37.7334467437666, -122.432277899312) | ||||
| 44844 | 44844 | 234526 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 6002889.3394 | 2095280.36515 | 37.733404483718296 | -122.43239760087299 | (37.7334044837183, -122.432397600873) | ||||
| 52437 | 52437 | 232289 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 0 San Jose Av Off Ramp | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 9ft | 6002953.30911 | 2095259.2744599998 | 37.7333502006365 | -122.43217493415301 | (37.7333502006365, -122.432174934153) | |||
| 157797 | 157797 | 234527 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 39 | 6002909.37025 | 2095287.3929700002 | 37.733424916326605 | -122.432328850416 | (37.7334249163266, -122.432328850416) | ||||
| 167027 | 167027 | 234529 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6002999.6248699995 | 2095331.3906599998 | 37.7335508412 | -122.432019955754 | (37.7335508412, -122.432019955754) | ||||
| 172904 | 172904 | 234530 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6003016.336130001 | 2095337.77177 | 37.7335693096769 | -122.431962635665 | (37.7335693096769, -122.431962635665) | ||||
| 70098 | 70098 | 124266 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1 03rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5994874.78871 | 2115033.3872700003 | 37.7871834762672 | -122.461537538969 | (37.7871834762672, -122.461537538969) | ||||
| 3733 | 3733 | 175357 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5992890.63105 | 2087809.5806900002 | 37.7123194916216 | -122.466422861444 | (37.7123194916216, -122.466422861444) | |||
| 3738 | 3738 | 175361 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5993097.02114 | 2087813.9243700001 | 37.7123433254574 | -122.465709836634 | (37.7123433254574, -122.465709836634) | |||
| 3740 | 3740 | 175359 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 5ft | 5993023.53483 | 2087808.23472 | 37.7123234639353 | -122.465963412176 | (37.7123234639353, -122.465963412176) | |||
| 3747 | 3747 | 175360 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 5ft | 5993054.1062900005 | 2087811.2090200002 | 37.7123333942521 | -122.46585796488002 | (37.7123333942521, -122.46585796488) | |||
| 3748 | 3748 | 175358 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 5ft | 5992915.27224 | 2087806.8926400002 | 37.7123135327144 | -122.466337499576 | (37.7123135327144, -122.466337499576) | |||
| 139692 | 139692 | 99826 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Cascade Walk | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992183.1 | 2103187.3 | 37.7545020044945 | -122.469987253468 | (37.7545020044945, -122.469987253468) | |||||
| 85229 | 85229 | 107718 | Significant Tree 6 | Tree(s) :: 17 | 1 DOUGLASS ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6001037.5 | 2106279.2 | 37.763499475963705 | -122.439588129958 | (37.7634994759637, -122.439588129958) | ||||
| 106519 | 106519 | 105769 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2014 12:00:00 AM | Permit Number 772589 | 5990111.8 | 2090190.8 | 37.718696994740704 | -122.476201051717 | (37.7186969947407, -122.476201051717) | |||
| 26819 | 26819 | 202073 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1 Gould St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012686.9776800005 | 2090655.72307 | 37.721256863288396 | -122.398199843161 | (37.7212568632884, -122.398199843161) | ||||
| 31668 | 31668 | 202074 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6012682.24985 | 2090663.29707 | 37.721277396617204 | -122.39821671715099 | (37.7212773966172, -122.398216717151) | ||||
| 35442 | 35442 | 202076 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6012694.00092 | 2090696.52405 | 37.7213692857431 | -122.398178426718 | (37.7213692857431, -122.398178426718) | ||||
| 48709 | 48709 | 202079 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6012746.01501 | 2090845.03433 | 37.721779962062996 | -122.398009040306 | (37.721779962063, -122.398009040306) | ||||
| 60281 | 60281 | 202078 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Gould St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6012742.601 | 2090834.0731400002 | 37.721749674703496 | -122.398020073164 | (37.7217496747035, -122.398020073164) | ||||
| 133882 | 133882 | 202077 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6012700.16365 | 2090713.41208 | 37.721416000129 | -122.398158307957 | (37.721416000129, -122.398158307957) | ||||
| 169656 | 169656 | 202075 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6012687.555919999 | 2090674.9679400001 | 37.7213097380253 | -122.398199193847 | (37.7213097380253, -122.398199193847) | ||||
| 27043 | 27043 | 194682 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6012380.91774 | 2104784.0825900002 | 37.760033297111704 | -122.400249606728 | (37.7600332971117, -122.400249606728) | ||||
| 31877 | 31877 | 194684 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6012406.88691 | 2104790.52602 | 37.7600524373766 | -122.40016024382099 | (37.7600524373766, -122.400160243821) | ||||
| 32780 | 32780 | 196567 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1 Jack Balestreri Way | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6012442.35809 | 2104735.38747 | 37.7599030168327 | -122.40003369300399 | (37.7599030168327, -122.400033693004) | ||||
| 34763 | 34763 | 196288 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012383.755890001 | 2104753.48944 | 37.7599494533344 | -122.40023764215799 | (37.7599494533344, -122.400237642158) | ||||
| 35147 | 35147 | 196292 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012388.17486 | 2104794.0427599996 | 37.760061050199596 | -122.400225207229 | (37.7600610501996, -122.400225207229) | ||||
| 40395 | 40395 | 188432 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1 Jack Balestreri Way | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6012439.74697 | 2104738.60671 | 37.7599117105733 | -122.400042949735 | (37.7599117105733, -122.400042949735) | ||||
| 40855 | 40855 | 188433 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1 Jack Balestreri Way | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6012415.19625 | 2104737.50493 | 37.7599073164779 | -122.400127781893 | (37.7599073164779, -122.400127781893) | ||||
| 45385 | 45385 | 196287 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012398.9699099995 | 2104759.28758 | 37.7599662220764 | -122.400185431124 | (37.7599662220764, -122.400185431124) | ||||
| 46448 | 46448 | 196295 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012406.535130001 | 2104796.6998799997 | 37.760069369818396 | -122.400161894071 | (37.7600693698184, -122.400161894071) | ||||
| 53555 | 53555 | 196289 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012382.84954 | 2104763.06022 | 37.7599756820445 | -122.400241449008 | (37.7599756820445, -122.400241449008) | ||||
| 56843 | 56843 | 194686 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 44 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012432.36762 | 2104808.71902 | 37.760103812064706 | -122.40007339538799 | (37.7601038120647, -122.400073395388) | ||||
| 57311 | 57311 | 197586 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | Width 10ft | 6012374.628719999 | 2104733.59825 | 37.7598943275787 | -122.400267811735 | (37.7598943275787, -122.400267811735) | |||
| 60624 | 60624 | 193464 | Undocumented 2 | Malus floribunda :: Showy Crab Apple: Japanese Crabapple 315 | 1 Jack Balestreri Way | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012381.254290001 | 2104808.9270099998 | 37.760101533168395 | -122.400250187717 | (37.7601015331684, -122.400250187717) | ||||
| 61779 | 61779 | 197591 | Undocumented 2 | Sequoiadendron giganteum :: Sierra Redwood 212 | 1 Jack Balestreri Way | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | 6012389.53926 | 2104790.4846200002 | 37.7600513564119 | -122.400220238489 | (37.7600513564119, -122.400220238489) | ||||
| 65487 | 65487 | 190963 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1 Jack Balestreri Way | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6012430.01623 | 2104809.07988 | 37.7601046718029 | -122.400081553118 | (37.7601046718029, -122.400081553118) | ||||
| 69480 | 69480 | 196293 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012394.755369999 | 2104793.13157 | 37.760058915200894 | -122.40020238425899 | (37.7600589152009, -122.400202384259) | ||||
| 70294 | 70294 | 198718 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6012424.057019999 | 2104786.65184 | 37.7600427570935 | -122.40010058818899 | (37.7600427570935, -122.400100588189) | ||||
| 72281 | 72281 | 196286 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6012387.37414 | 2104738.06992 | 37.7599073164914 | -122.40022404532301 | (37.7599073164914, -122.400224045323) | ||||
| 73120 | 73120 | 194685 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012432.71198 | 2104802.44836 | 37.7600866134166 | -122.40007176402099 | (37.7600866134166, -122.400071764021) | ||||
| 75827 | 75827 | 198713 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012404.84739 | 2104738.96788 | 37.759910756386 | -122.400163676537 | (37.759910756386, -122.400163676537) | ||||
| 127276 | 127276 | 189776 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Jack Balestreri Way | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012433.20724 | 2104795.86153 | 37.760068555049 | -122.400069588557 | (37.760068555049, -122.400069588557) | ||||
| 132745 | 132745 | 196291 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012380.38083 | 2104793.15065 | 37.7600581660633 | -122.40025210055401 | (37.7600581660633, -122.400252100554) | ||||
| 132969 | 132969 | 197480 | Undocumented 2 | Schefflera species :: Umbrella tree 386 | 1 Jack Balestreri Way | 31 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012406.70944 | 2104799.68799 | 37.7600775842279 | -122.40016150107401 | (37.7600775842279, -122.400161501074) | ||||
| 136559 | 136559 | 198717 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6012427.078840001 | 2104786.19155 | 37.760041661724294 | -122.40009010477199 | (37.7600416617243, -122.400090104772) | ||||
| 137764 | 137764 | 198711 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6012390.58934 | 2104733.77688 | 37.7598957080306 | -122.400212623923 | (37.7598957080306, -122.400212623923) | ||||
| 148136 | 148136 | 194683 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012398.62743 | 2104785.66422 | 37.7600386274099 | -122.400188468119 | (37.7600386274099, -122.400188468119) | ||||
| 150800 | 150800 | 194681 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012405.53198 | 2104761.19385 | 37.759971822165 | -122.400162869837 | (37.759971822165, -122.400162869837) | ||||
| 151012 | 151012 | 196294 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012397.7351 | 2104775.9114900003 | 37.7600117988112 | -122.400190869313 | (37.7600117988112, -122.400190869313) | ||||
| 155266 | 155266 | 188002 | Undocumented 2 | Araucaria columnaris :: Coral reef araucaria 185 | 1 Jack Balestreri Way | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012414.55011 | 2104744.40828 | 37.759926235526294 | -122.40013050142001 | (37.7599262355263, -122.40013050142) | ||||
| 157277 | 157277 | 197589 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012441.30894 | 2104748.70907 | 37.7599395365119 | -122.40003825707 | (37.7599395365119, -122.40003825707) | ||||
| 169778 | 169778 | 197588 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6012433.89716 | 2104751.224 | 37.7599460287107 | -122.400064067605 | (37.7599460287107, -122.400064067605) | ||||
| 169789 | 169789 | 190964 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1 Jack Balestreri Way | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6012433.13326 | 2104783.13919 | 37.760033618186895 | -122.400068950945 | (37.7600336181869, -122.400068950945) | ||||
| 171959 | 171959 | 198715 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012393.75722 | 2104758.14097 | 37.7599627830829 | -122.40020337888001 | (37.7599627830829, -122.40020337888) | ||||
| 172532 | 172532 | 190962 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 1 Jack Balestreri Way | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6012415.27524 | 2104795.5991 | 37.7600668346491 | -122.400131588717 | (37.7600668346491, -122.400131588717) | ||||
| 174122 | 174122 | 196290 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Jack Balestreri Way | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6012385.57921 | 2104781.3261 | 37.760025988325296 | -122.400233291241 | (37.7600259883253, -122.400233291241) | ||||
| 174485 | 174485 | 190618 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 1 Jack Balestreri Way | 32 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6012380.89762 | 2104806.31927 | 37.7600943530021 | -122.40025123812 | (37.7600943530021, -122.40025123812) | ||||
| 174597 | 174597 | 197587 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012433.76366 | 2104761.3607799998 | 37.7599738546281 | -122.400065241211 | (37.7599738546281, -122.400065241211) | ||||
| 177012 | 177012 | 198712 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012409.2868 | 2104740.75677 | 37.7599159158162 | -122.400148448317 | (37.7599159158162, -122.400148448317) | ||||
| 180588 | 180588 | 188594 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Jack Balestreri Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6012410.71719 | 2104764.5597 | 37.7599813531633 | -122.400145172978 | (37.7599813531633, -122.400145172978) | ||||
| 183330 | 183330 | 198714 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6012392.10432 | 2104746.43 | 37.7599305351797 | -122.40020827299 | (37.7599305351797, -122.40020827299) | ||||
| 186305 | 186305 | 198719 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012426.60188 | 2104780.3365 | 37.760025558456 | -122.40009134316001 | (37.760025558456, -122.40009134316) | ||||
| 188787 | 188787 | 198716 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012435.45526 | 2104782.66199 | 37.760032437365105 | -122.40006088669901 | (37.7600324373651, -122.400060886699) | ||||
| 112832 | 112832 | 108978 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 MIGUEL ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 44 | 6003334.2 | 2097391.9 | 37.739227491928894 | -122.431010244874 | (37.7392274919289, -122.431010244874) | ||||
| 52897 | 52897 | 132364 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1 Maple St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5996506.6886 | 2116107.7681400003 | 37.7902272326358 | -122.455969252601 | (37.7902272326358, -122.455969252601) | ||||
| 57300 | 57300 | 132363 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1 Maple St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 5996514.49254 | 2116105.13934 | 37.7902204625654 | -122.455942061589 | (37.7902204625654, -122.455942061589) | ||||
| 79120 | 79120 | 107551 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 81584 | 81584 | 107564 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 83430 | 83430 | 107562 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 103606 | 103606 | 107561 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 12 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 108428 | 108428 | 107553 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 120274 | 120274 | 107563 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 128143 | 128143 | 107552 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 78391 | 78391 | 108038 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 Twin Peaks Blvd | Front Yard : Yard 7 | Tree 1 | Private 1 | 5998985.485719999 | 2105240.3128 | 37.760529947122706 | -122.446610614338 | (37.7605299471227, -122.446610614338) | ||||||
| 141601 | 141601 | 108981 | Permitted Site 1 | Eucalyptus odorata :: Peppermint Box 507 | 10 ARBOR ST | Front Yard : Yard 7 | Tree 1 | Private 1 | 03/02/2015 12:00:00 AM | 3 | Permit Number 774690 | 6002183.8 | 2097008.7 | 37.7381100606509 | -122.434960408352 | (37.7381100606509, -122.434960408352) | |||
| 168699 | 168699 | 247958 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 10 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010403.29697 | 2098902.73698 | 37.7437739492996 | -122.406674804102 | (37.7437739492996, -122.406674804102) | ||||
| 121718 | 121718 | 107408 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 10 PEMBERTON PL | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 5998956.5 | 2104566.5 | 37.7586781689727 | -122.446662380642 | (37.7586781689727, -122.446662380642) | ||||
| 138601 | 138601 | 107824 | Significant Tree 6 | Tree(s) :: 17 | 10 STARR KING WAY | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 774657 | 6005969.0 | 2114025.0 | 37.785047016194206 | -122.42308221548599 | (37.7850470161942, -122.423082215486) | ||
| 62231 | 62231 | 176114 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Zoo Rd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 10ft | 5982696.49512 | 2094384.4536 | 37.729778850703894 | -122.502142508582 | (37.7297788507039, -122.502142508582) | |||
| 86608 | 86608 | 85093 | Significant Tree 6 | Tree(s) :: 17 | 100 32nd Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/18/2009 12:00:00 AM | Permit Number 53112 | 5985781.7 | 2114962.8 | 37.786462080845396 | -122.49299200677 | (37.7864620808454, -122.49299200677) | |||
| 144783 | 144783 | 92909 | Significant Tree 6 | Tree(s) :: 17 | 100 32nd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/18/2009 12:00:00 AM | 11 | Permit Number 53112 | 5985781.7 | 2114962.8 | 37.786462080845396 | -122.49299200677 | (37.7864620808454, -122.49299200677) | ||
| 118579 | 118579 | 108625 | Property Tree 7 | Persea americana :: Avocado 113 | 100 GENEBERN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004991.8 | 2095242.4 | 37.7334192343039 | -122.42512609869301 | (37.7334192343039, -122.425126098693) | ||||
| 50757 | 50757 | 191735 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6010009.096969999 | 2107534.42743 | 37.7674525780981 | -122.408646656734 | (37.7674525780981, -122.408646656734) | ||||
| 70209 | 70209 | 191734 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6009976.801940001 | 2107534.39117 | 37.767450669731105 | -122.40875835881201 | (37.7674506697311, -122.408758358812) | ||||
| 134906 | 134906 | 191730 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009966.3806300005 | 2107638.17528 | 37.767735053365705 | -122.40880172773399 | (37.7677350533657, -122.408801727734) | ||||
| 158665 | 158665 | 191729 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009963.10998 | 2107668.13664 | 37.7678171371844 | -122.408815154618 | (37.7678171371844, -122.408815154618) | ||||
| 159705 | 159705 | 191732 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6009982.19315 | 2107558.06249 | 37.7675159677065 | -122.408741381426 | (37.7675159677065, -122.408741381426) | ||||
| 164405 | 164405 | 191733 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009990.5053900005 | 2107548.56259 | 37.7674903487254 | -122.408711960091 | (37.7674903487254, -122.408711960091) | ||||
| 166693 | 166693 | 194049 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 Hampshire St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009981.034030001 | 2107543.0973799997 | 37.76747481202629 | -122.40874433479999 | (37.7674748120263, -122.4087443348) | ||||
| 185592 | 185592 | 191731 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 100 Hampshire St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6009975.967759999 | 2107617.96239 | 37.76768009039721 | -122.408767140702 | (37.7676800903972, -122.408767140702) | ||||
| 24281 | 24281 | 223831 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006175.86532 | 2097493.16654 | 37.7396661564679 | -122.421192213677 | (37.7396661564679, -122.421192213677) | ||||
| 32781 | 32781 | 223827 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006190.11427 | 2097485.70732 | 37.7396464784009 | -122.421142417311 | (37.7396464784009, -122.421142417311) | ||||
| 45687 | 45687 | 223828 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006183.12873 | 2097474.29354 | 37.739614744910604 | -122.421165760098 | (37.7396147449106, -122.421165760098) | ||||
| 166024 | 166024 | 223832 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006182.73872 | 2097507.8972099996 | 37.7397069910787 | -122.421169494081 | (37.7397069910787, -122.421169494081) | ||||
| 182434 | 182434 | 223829 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006166.57618 | 2097475.4122599997 | 37.739616883505995 | -122.421223071201 | (37.739616883506, -122.421223071201) |
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");