Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28806 | 28806 | 217820 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1x Junipero Serra Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5991627.31768 | 2095659.9754599999 | 37.733801760145504 | -122.471360849935 | (37.7338017601455, -122.471360849935) | ||||
34333 | 34333 | 217817 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1x Junipero Serra Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 5991627.99201 | 2095776.79312 | 37.7341225510202 | -122.47136702736 | (37.7341225510202, -122.47136702736) | ||||
135366 | 135366 | 217818 | DPW Maintained 3 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 1x Junipero Serra Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | 5991630.64581 | 2095733.14753 | 37.7340028647425 | -122.471354673377 | (37.7340028647425, -122.471354673377) | ||||
59175 | 59175 | 217814 | DPW Maintained 3 | Eucalyptus camaldulensis :: River Red Gum 340 | 1x Junipero Serra Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 39 | 5991642.1645 | 2095884.13354 | 37.734418100595995 | -122.47132584741001 | (37.734418100596, -122.47132584741) | ||||
24947 | 24947 | 206807 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 11x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5991689.221530001 | 2095992.9314700002 | 37.734719554257296 | -122.471171081279 | (37.7347195542573, -122.471171081279) | ||||
42114 | 42114 | 212121 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2101x Monterey Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | Width 10ft | 5991706.53339 | 2095446.31972 | 37.7332196973367 | -122.47107142020398 | (37.7332196973367, -122.471071420204) | |||
75936 | 75936 | 212120 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2101x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | Width 10ft | 5991781.48453 | 2095442.7217400002 | 37.7332141530016 | -122.47081203417 | (37.7332141530016, -122.47081203417) | |||
158032 | 158032 | 206808 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 11x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 5991782.03455 | 2095997.5477200001 | 37.734737597362205 | -122.470850534124 | (37.7347375973622, -122.470850534124) | ||||
122322 | 122322 | 105909 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1864X 14TH AVE | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 14 | 5991829.0 | 2102804.0 | 37.7534290869332 | -122.47118388851999 | (37.7534290869332, -122.47118388852) | ||||
136852 | 136852 | 212119 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2101x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 10ft | 5991843.73604 | 2095437.8769099999 | 37.7332044502098 | -122.47059646305 | (37.7332044502098, -122.47059646305) | |||
159138 | 159138 | 212118 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2001x Monterey Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | Width 10ft | 5991962.73959 | 2095431.83723 | 37.733194747433295 | -122.470184599654 | (37.7331947474333, -122.470184599654) | |||
157149 | 157149 | 212117 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2001x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 5992028.07396 | 2095428.94715 | 37.7331905889564 | -122.469958512768 | (37.7331905889564, -122.469958512768) | |||
185624 | 185624 | 212116 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2001x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 5992083.71687 | 2095423.23256 | 37.7331781144806 | -122.469765726035 | (37.7331781144806, -122.469765726035) | |||
157374 | 157374 | 122908 | DPW Maintained 3 | Prunus lusitanica :: Portugese Cherry Laurel 430 | 2x 12th Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5992093.66064 | 2114888.38015 | 37.7866248560676 | -122.471148981632 | (37.7866248560676, -122.471148981632) | ||||
40805 | 40805 | 122909 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2x 12th Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5992095.78801 | 2114872.2732700002 | 37.7865807540814 | -122.471140447624 | (37.7865807540814, -122.471140447624) | ||||
182257 | 182257 | 212115 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1902x Monterey Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 5992194.67664 | 2095416.97281 | 37.7331673397011 | -122.46938165614401 | (37.7331673397011, -122.469381656144) | |||
26820 | 26820 | 212114 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1902x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | Width 10ft | 5992265.63325 | 2095412.1953200002 | 37.7331583221951 | -122.46913599464399 | (37.7331583221951, -122.469135994644) | |||
156264 | 156264 | 212113 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1902x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 5992332.7127 | 2095408.39507 | 37.7331517634298 | -122.46890380855899 | (37.7331517634298, -122.468903808559) | |||
3208 | 3208 | 253368 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 236 Moncada Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x10 | 5992398.0 | 2093455.0 | 37.7277919980392 | -122.468536018982 | (37.7277919980392, -122.468536018982) | ||||
66298 | 66298 | 212112 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1802x Monterey Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 10ft | 5992444.9445 | 2095398.86833 | 37.7331320889801 | -122.468515103605 | (37.7331320889801, -122.468515103605) | |||
29486 | 29486 | 212111 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1802x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 5992507.56631 | 2095396.9538900002 | 37.7331304494932 | -122.46829846591801 | (37.7331304494932, -122.468298465918) | |||
68230 | 68230 | 212110 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1802x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 5992575.24541 | 2095393.14196 | 37.733123891637504 | -122.468064206012 | (37.7331238916375, -122.468064206012) | |||
160424 | 160424 | 212109 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1701x Monterey Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | Width 10ft | 5992703.672809999 | 2095383.87275 | 37.7331058566417 | -122.467619528126 | (37.7331058566417, -122.467619528126) | |||
70013 | 70013 | 212108 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1701x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 10ft | 5992762.96057 | 2095380.2374200001 | 37.7330992978931 | -122.46741429204201 | (37.7330992978931, -122.467414292042) | |||
33017 | 33017 | 218260 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x Portola Dr | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5992795.95946 | 2097207.23373 | 37.738117677685 | -122.46743301504 | (37.738117677685, -122.46743301504) | ||||
41943 | 41943 | 218261 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x Portola Dr | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5992797.06764 | 2097201.3875599997 | 37.738101689549296 | -122.467428758544 | (37.7381016895493, -122.467428758544) | ||||
188991 | 188991 | 218259 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 5992809.1507 | 2097219.8287299997 | 37.7381530219397 | -122.46738832232 | (37.7381530219397, -122.46738832232) | ||||
71855 | 71855 | 218257 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5992819.23319 | 2097230.95625 | 37.738184157378704 | -122.467354271301 | (37.7381841573787, -122.467354271301) | ||||
135213 | 135213 | 218258 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5992819.36042 | 2097222.3722200003 | 37.7381605951349 | -122.467353207399 | (37.7381605951349, -122.467353207399) | ||||
70498 | 70498 | 212107 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1701x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 10ft | 5992822.82885 | 2095375.69454 | 37.7330902803915 | -122.46720698303601 | (37.7330902803915, -122.467206983036) | |||
60241 | 60241 | 218256 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5992828.86641 | 2097235.35096 | 37.7381967802678 | -122.46732128416599 | (37.7381967802678, -122.467321284166) | ||||
176894 | 176894 | 218255 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 5992834.72812 | 2097242.26115 | 37.7382160923013 | -122.467301519773 | (37.7382160923013, -122.467301519773) | ||||
160258 | 160258 | 124147 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4500x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 5992867.120709999 | 2112765.78915 | 37.780841509198105 | -122.468318544662 | (37.7808415091981, -122.468318544662) | ||||
188895 | 188895 | 212106 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1602x Monterey Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | Width 10ft | 5993007.603759999 | 2095365.5409099997 | 37.733073065562 | -122.466567434662 | (37.733073065562, -122.466567434662) | |||
152002 | 152002 | 212105 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1602x Monterey Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 10ft | 5993074.71475 | 2095363.2347400002 | 37.7330706059279 | -122.466335248575 | (37.7330706059279, -122.466335248575) | |||
157513 | 157513 | 212104 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1602x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 10ft | 5993129.9763400005 | 2095367.74637 | 37.733086182185 | -122.46614452395201 | (37.733086182185, -122.466144523952) | |||
71118 | 71118 | 212103 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1602x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | Width 10ft | 5993196.79522 | 2095380.0761799999 | 37.7331238916354 | -122.46591441082899 | (37.7331238916354, -122.465914410829) | |||
162038 | 162038 | 211594 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 5993241.397369999 | 2096024.08182 | 37.7348947439874 | -122.465806985911 | (37.7348947439874, -122.465806985911) | ||||
73062 | 73062 | 211603 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 5993248.1121 | 2096070.25185 | 37.7350219027308 | -122.465787124396 | (37.7350219027308, -122.465787124396) | ||||
65745 | 65745 | 211595 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5993265.55195 | 2096027.93285 | 37.7349067112733 | -122.465723755468 | (37.7349067112733, -122.465723755468) | ||||
57950 | 57950 | 211602 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 5993273.01858 | 2096070.8179900001 | 37.7350248938828 | -122.46570105566201 | (37.7350248938828, -122.465701055662) | ||||
66680 | 66680 | 211596 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 5993283.92452 | 2096029.9988 | 37.734913443609 | -122.465660385625 | (37.734913443609, -122.465660385625) | ||||
150515 | 150515 | 211601 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 5993297.40661 | 2096072.7575700001 | 37.7350316261928 | -122.465616879121 | (37.7350316261928, -122.465616879121) | ||||
47467 | 47467 | 211597 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5993315.91751 | 2096029.3267299999 | 37.734913443583004 | -122.46554972673701 | (37.734913443583, -122.465549726737) | ||||
27995 | 27995 | 211600 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 5993318.7926 | 2096075.03242 | 37.7350391058631 | -122.465543105951 | (37.7350391058631, -122.465543105951) | ||||
160297 | 160297 | 211599 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5993337.92227 | 2096074.08591 | 37.7350376103014 | -122.46547689966499 | (37.7350376103014, -122.465476899665) | ||||
149583 | 149583 | 211598 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 5993342.23689 | 2096032.04298 | 37.7349224197171 | -122.46545892941002 | (37.7349224197171, -122.46545892941) | ||||
89696 | 89696 | 111418 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200x SAN MARCOS AVE | 3 | Median : Yard 3 | Tree 1 | Private 1 | 5 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
95953 | 95953 | 111416 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 200x SAN MARCOS AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 24 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
98788 | 98788 | 111423 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 8 | Median : Yard 3 | Tree 1 | Private 1 | 50 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
99310 | 99310 | 111417 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 200x SAN MARCOS AVE | 2 | Median : Yard 3 | Tree 1 | Private 1 | 24 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
103516 | 103516 | 111419 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200x SAN MARCOS AVE | 4 | Median : Yard 3 | Tree 1 | Private 1 | 10 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
103771 | 103771 | 111426 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200x SAN MARCOS AVE | 11 | Median : Yard 3 | Tree 1 | Private 1 | 6 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
111907 | 111907 | 111427 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200x SAN MARCOS AVE | 12 | Median : Yard 3 | Tree 1 | Private 1 | 20 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
112509 | 112509 | 111420 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200x SAN MARCOS AVE | 5 | Median : Yard 3 | Tree 1 | Private 1 | 15 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
121585 | 121585 | 111422 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 7 | Median : Yard 3 | Tree 1 | Private 1 | 48 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
142054 | 142054 | 111424 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 9 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
143022 | 143022 | 111421 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200x SAN MARCOS AVE | 6 | Median : Yard 3 | Tree 1 | Private 1 | 46 | 5993395.0 | 2100395.0 | 37.746905045660796 | -122.465593373526 | (37.7469050456608, -122.465593373526) | ||||
24045 | 24045 | 211638 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5993404.24438 | 2096035.5287900001 | 37.7349355669295 | -122.465244802603 | (37.7349355669295, -122.465244802603) | ||||
63302 | 63302 | 211637 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993407.09448 | 2096071.29538 | 37.7350339374534 | -122.465237545992 | (37.7350339374534, -122.465237545992) | ||||
166324 | 166324 | 211639 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993426.13357 | 2096035.66615 | 37.7349372063681 | -122.46516913456199 | (37.7349372063681, -122.465169134562) | ||||
58657 | 58657 | 211636 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 5993435.6641 | 2096075.47209 | 37.73504705316721 | -122.465139074704 | (37.7350470531672, -122.465139074704) | ||||
172734 | 172734 | 211640 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5993453.729169999 | 2096036.2807900002 | 37.734940485300896 | -122.465073772263 | (37.7349404853009, -122.465073772263) | ||||
63223 | 63223 | 211635 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 5993454.5439 | 2096075.0755900003 | 37.735047053161004 | -122.46507377223699 | (37.735047053161, -122.465073772237) | ||||
158762 | 158762 | 211634 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5993470.414340001 | 2096074.14522 | 37.7350454137208 | -122.465018835356 | (37.7350454137208, -122.465018835356) | ||||
153106 | 153106 | 211641 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5993480.406880001 | 2096036.0192599997 | 37.7349413054856 | -122.464981519787 | (37.7349413054856, -122.464981519787) | ||||
66534 | 66534 | 211642 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 5993503.77568 | 2096035.22982 | 37.734940485303895 | -122.464900668957 | (37.7349404853039, -122.464900668957) | ||||
167137 | 167137 | 206811 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 66x Santa Monica Way | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 5993507.09013 | 2097468.08947 | 37.738874951811795 | -122.464993240656 | (37.7388749518118, -122.464993240656) | ||||
32165 | 32165 | 211633 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993517.47022 | 2096073.45578 | 37.7350462338855 | -122.464856097643 | (37.7350462338855, -122.464856097643) | ||||
133633 | 133633 | 211643 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 5993526.28926 | 2096036.5483400002 | 37.734945403693295 | -122.464822927933 | (37.7349454036933, -122.464822927933) | ||||
172018 | 172018 | 211632 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 5993530.98701 | 2096074.66452 | 37.7350503321086 | -122.464809453402 | (37.7350503321086, -122.464809453402) | ||||
67634 | 67634 | 206814 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5993540.83818 | 2100833.0540400003 | 37.748116241270104 | -122.465120894018 | (37.7481162412701, -122.465120894018) | ||||
43629 | 43629 | 211101 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 5993549.05492 | 2100852.54328 | 37.7481702275711 | -122.465093896362 | (37.7481702275711, -122.465093896362) | ||||
154753 | 154753 | 211644 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993552.38645 | 2096037.19487 | 37.7349486835202 | -122.46473274841401 | (37.7349486835202, -122.464732748414) | ||||
24462 | 24462 | 211631 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 5993552.90123 | 2096075.99565 | 37.735055250506704 | -122.464733785358 | (37.7350552505067, -122.464733785358) | ||||
60954 | 60954 | 206815 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 5993562.9787 | 2100880.73772 | 37.7482484452101 | -122.465047796213 | (37.7482484452101, -122.465047796213) | ||||
55668 | 55668 | 213724 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 66x Santa Monica Way | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 5993565.41473 | 2097500.59466 | 37.738967565793295 | -122.46479394281 | (37.7389675657933, -122.46479394281) | ||||
82501 | 82501 | 111413 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 8 | Median : Yard 3 | Tree 1 | Private 1 | 42 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
96206 | 96206 | 111407 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 2 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
99590 | 99590 | 111406 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 40 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
103385 | 103385 | 111415 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 10 | Median : Yard 3 | Tree 1 | Private 1 | 48 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
106027 | 106027 | 111425 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200x SAN MARCOS AVE | 10 | Median : Yard 3 | Tree 1 | Private 1 | 16 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
106876 | 106876 | 111408 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 3 | Median : Yard 3 | Tree 1 | Private 1 | 15 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
109414 | 109414 | 111414 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 9 | Median : Yard 3 | Tree 1 | Private 1 | 42 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
121319 | 121319 | 111411 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 6 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
121346 | 121346 | 111410 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 5 | Median : Yard 3 | Tree 1 | Private 1 | 10 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
140697 | 140697 | 111409 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 4 | Median : Yard 3 | Tree 1 | Private 1 | 45 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
145014 | 145014 | 111412 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150x SAN MARCOS AVE | 7 | Median : Yard 3 | Tree 1 | Private 1 | 36 | 5993566.0 | 2100407.0 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | ||||
160700 | 160700 | 211630 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5993569.69584 | 2096076.2401 | 37.7350568899517 | -122.464675738601 | (37.7350568899517, -122.464675738601) | ||||
162635 | 162635 | 211645 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5993570.72936 | 2096039.7951900002 | 37.734956880860295 | -122.46466951978 | (37.7349568808603, -122.46466951978) | ||||
53815 | 53815 | 211102 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 43 | 5993572.08024 | 2100898.12462 | 37.7482967100214 | -122.465017586199 | (37.7482967100214, -122.465017586199) | ||||
48845 | 48845 | 206816 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5993579.5371900005 | 2100911.34414 | 37.7483334374322 | -122.46499276043001 | (37.7483334374322, -122.46499276043) | ||||
34680 | 34680 | 210208 | DPW Maintained 3 | Melaleuca styphelliodes :: Paperbark Tree 239 | 198x San Anselmo Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 5993586.63469 | 2096365.42652 | 37.7358519005501 | -122.464638167637 | (37.7358519005501, -122.464638167637) | ||||
132074 | 132074 | 206817 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2187x 09th Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 5993586.72405 | 2100922.72435 | 37.7483650989873 | -122.464968735031 | (37.7483650989873, -122.464968735031) | ||||
137893 | 137893 | 213723 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 66x Santa Monica Way | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5993589.39355 | 2097453.93432 | 37.738840830631396 | -122.46470764836 | (37.7388408306314, -122.46470764836) | ||||
151299 | 151299 | 210209 | DPW Maintained 3 | Melaleuca styphelliodes :: Paperbark Tree 239 | 198x San Anselmo Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993590.58402 | 2096363.3558 | 37.735846442546794 | -122.46462436303999 | (37.7358464425468, -122.46462436304) | ||||
159973 | 159973 | 213722 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 66x Santa Monica Way | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5993592.57964 | 2097450.02121 | 37.7388302698944 | -122.464696348358 | (37.7388302698944, -122.464696348358) | ||||
32328 | 32328 | 211103 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 5993592.96046 | 2100932.97127 | 37.7483935940092 | -122.464947913926 | (37.7483935940092, -122.464947913926) | ||||
63522 | 63522 | 210207 | DPW Maintained 3 | Melaleuca styphelliodes :: Paperbark Tree 239 | 198x San Anselmo Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5993593.33337 | 2096358.46993 | 37.735833185661605 | -122.46461450286101 | (37.7358331856616, -122.464614502861) | ||||
36932 | 36932 | 211104 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 5993600.40313 | 2100945.49901 | 37.7484284211296 | -122.464923087237 | (37.7484284211296, -122.464923087237) |
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");