Street_Tree_List

Data source: data.sfgov.org

3,530 rows where qSpecies = 60 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
125626 125626 49691 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 450 Stanyan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/21/2003 12:00:00 AM   tx5 Permit Number 46512 5996840.32777146 2110125.42661407 37.7738204478349 -122.45438257610901 (37.7738204478349, -122.454382576109)
2611 2611 248770 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1 Cuesta Ct 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 8ft   5999726.1375 2101744.56242 37.7509737525388 -122.44379789365499 (37.7509737525388, -122.443797893655)
2614 2614 248773 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1 Cuesta Ct 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 8ft   5999776.82694 2101824.96428 37.751197407653706 -122.44362838043999 (37.7511974076537, -122.44362838044)
2625 2625 248771 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1 Cuesta Ct 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 8ft   5999742.36883 2101773.9828 37.751055459558394 -122.4437438777 (37.7510554595584, -122.4437438777)
2626 2626 248769 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1 Cuesta Ct 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 8ft   5999705.100819999 2101709.8291 37.7508771833507 -122.443868145114 (37.7508771833507, -122.443868145114)
2629 2629 248772 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1 Cuesta Ct 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 8ft   5999759.8487 2101799.49731 37.7511265131926 -122.443685263491 (37.7511265131926, -122.443685263491)
25072 25072 126288 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2500x Van Ness Ave 7 Median : Yard 3 Tree 1 DPW 2     27 Width 8ft   6005772.33142 2119211.18315 37.7992758747311 -122.424131583019 (37.7992758747311, -122.424131583019)
26209 26209 212049 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 11 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 8ft   5992308.89069 2096641.7463200002 37.736536860193404 -122.469075896562 (37.7365368601934, -122.469075896562)
28401 28401 212048 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 11 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 8ft   5992319.55717 2096621.0874299998 37.7364807523878 -122.469037515296 (37.7364807523878, -122.469037515296)
28487 28487 212010 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 302 San Fernando Way 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 8ft   5992076.0582 2094714.7951200001 37.7312324797943 -122.46974064571998 (37.7312324797943, -122.46974064572)
28708 28708 212033 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 77 San Leandro Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     42 Width 8ft   5992382.09631 2096171.88188 37.7352509600559 -122.468788615307 (37.7352509600559, -122.468788615307)
31258 31258 118000 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 7 Shore View Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   5984651.74201 2112846.53753 37.7805852938125 -122.49674508055 (37.7805852938125, -122.49674508055)
31686 31686 189484 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 10 Garlington Ct 1 : 4 Tree 1 Private 1     17 Width 8ft   6016756.63544 2094656.7103 37.732468633912795 -122.38441058228399 (37.7324686339128, -122.384410582284)
32948 32948 212023 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 60 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 8ft   5992352.18308 2096253.2392099998 37.7354726186689 -122.46889795397699 (37.7354726186689, -122.468897953977)
35345 35345 212007 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 302 San Fernando Way 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 8ft   5992022.6744800005 2094535.4646599998 37.7307369974034 -122.469912149146 (37.7307369974034, -122.469912149146)
36702 36702 212005 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 302 San Fernando Way 15 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     49 Width 8ft   5991983.8699 2094464.4262700002 37.73053970054001 -122.470041130814 (37.73053970054, -122.470041130814)
37267 37267 212009 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 302 San Fernando Way 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 8ft   5992050.07919 2094590.8204299998 37.730890574625896 -122.469821436321 (37.7308905746259, -122.469821436321)
39555 39555 212032 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 77 San Leandro Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   5992384.20886 2096144.3676099998 37.7351755348194 -122.46877931001998 (37.7351755348194, -122.46877931002)
42507 42507 118050 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 451 36th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 8ft   5984672.88957 2112829.17852 37.7805388700497 -122.496670640749 (37.7805388700497, -122.496670640749)
43012 43012 212034 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 75 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 8ft   5992381.096530001 2096188.3178599998 37.7352960313735 -122.468793267506 (37.7352960313735, -122.468793267506)
43190 43190 122146 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 31 15th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 8ft   5991133.9927199995 2114818.51521 37.7863774717716 -122.47446406594999 (37.7863774717716, -122.47446406595)
44074 44074 212044 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 29 San Leandro Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 8ft   5992357.053169999 2096532.5298400002 37.7362397619376 -122.468901434378 (37.7362397619376, -122.468901434378)
46573 46573 212020 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 52 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38 Width 8ft   5992351.56186 2096319.4479099999 37.7356543752416 -122.468904918344 (37.7356543752416, -122.468904918344)
51230 51230 212026 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 78 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 8ft   5992350.77465 2096170.19612 37.7352445218171 -122.468896782157 (37.7352445218171, -122.468896782157)
52822 52822 212008 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 302 San Fernando Way 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 8ft   5992037.66207 2094565.76948 37.730821073223 -122.469862540745 (37.730821073223, -122.469862540745)
53113 53113 212043 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 29 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     46 Width 8ft   5992369.57859 2096472.3022900003 37.736075115876105 -122.46885374781701 (37.7360751158761, -122.468853747817)
61762 61762 212040 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 51 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 8ft   5992378.18286 2096369.61273 37.7357936532423 -122.468816529385 (37.7357936532423, -122.468816529385)
63740 63740 122144 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 25 15th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 8ft   5991132.251759999 2114855.8727599997 37.7864799443229 -122.47447281643299 (37.7864799443229, -122.474472816433)
66155 66155 212013 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 10 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38 Width 8ft   5992290.98987 2096599.94632 37.7364210535804 -122.469134745476 (37.7364210535804, -122.469134745476)
66859 66859 212029 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 80 San Leandro Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 8ft   5992352.59251 2096080.7130000002 37.73499892864879 -122.46888398751699 (37.7349989286488, -122.468883987517)
69789 69789 212037 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 67 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 8ft   5992377.43562 2096270.13456 37.735520467997105 -122.468811876269 (37.7355204679971, -122.468811876269)
70769 70769 212047 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 15 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 8ft   5992333.0246 2096589.6494599998 37.7363952097605 -122.468988665905 (37.7363952097605, -122.468988665905)
72722 72722 126165 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 596 Spruce St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 8ft   5997159.12114 2113887.69242 37.7841689209008 -122.453551530484 (37.7841689209008, -122.453551530484)
76113 76113 212017 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 30 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 8ft   5992334.74315 2096477.46746 37.7360872854934 -122.46897456272801 (37.7360872854934, -122.468974562728)
130028 130028 212006 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 302 San Fernando Way 14 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 8ft   5992010.735830001 2094513.66947 37.7306764631302 -122.46995183623501 (37.7306764631302, -122.469951836235)
133229 133229 212025 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 70 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     37 Width 8ft   5992351.0303 2096198.33037 37.7353217861765 -122.468897945005 (37.7353217861765, -122.468897945005)
133744 133744 212027 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 80 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 8ft   5992353.19315 2096125.2552599998 37.7351212652219 -122.46888515124701 (37.7351212652219, -122.468885151247)
134097 134097 189485 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 10x Garlington Ct 2 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6016768.7449900005 2094679.8943900003 37.7325329624249 -122.384370330438 (37.7325329624249, -122.384370330438)
135601 135601 212011 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 302 San Fernando Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 8ft   5992086.28317 2094888.90865 37.731711143057396 -122.469717967521 (37.7317111430574, -122.469717967521)
136307 136307 122145 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 31 15th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 8ft   5991133.61704 2114833.40571 37.78641833516821 -122.47446645276199 (37.7864183351682, -122.474466452762)
137084 137084 212042 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 45 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 8ft   5992376.21526 2096435.9834 37.73597577675471 -122.468828160298 (37.7359757767547, -122.468828160298)
138123 138123 212046 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 15 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 8ft   5992343.2495099995 2096563.97487 37.736325304562 -122.468951446557 (37.736325304562, -122.468951446557)
144328 144328 212035 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 75 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 8ft   5992380.42085 2096220.1571 37.7353834149009 -122.46879791969101 (37.7353834149009, -122.468797919691)
148255 148255 212028 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 80 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 8ft   5992353.6876300005 2096100.78997 37.7350541182422 -122.46888166187901 (37.7350541182422, -122.468881661879)
150736 150736 118051 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 451 36th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 8ft   5984674.55731 2112758.40863 37.7803446541387 -122.496659647186 (37.7803446541387, -122.496659647186)
150970 150970 212030 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 77 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 8ft   5992387.21326 2096079.3144200002 37.7349970886451 -122.46876419063601 (37.7349970886451, -122.468764190636)
151912 151912 212019 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 50 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 8ft   5992346.156330001 2096368.90738 37.7357898662136 -122.468927205336 (37.7357898662136, -122.468927205336)
160530 160530 212022 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 60 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 8ft   5992349.4592 2096276.9663099998 37.7355376099545 -122.46890909748998 (37.7355376099545, -122.46890909749)
163197 163197 212031 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 77 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 8ft   5992386.208430001 2096111.49565 37.7350853921813 -122.468770005625 (37.7350853921813, -122.468770005625)
163700 163700 212041 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 51 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     44 Width 8ft   5992377.58469 2096405.1347599998 37.7358911532558 -122.468821181556 (37.7358911532558, -122.468821181556)
165004 165004 212021 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 52 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 8ft   5992352.2635699995 2096295.36213 37.7355882822803 -122.468900740075 (37.7355882822803, -122.468900740075)
166905 166905 212015 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 12 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   5992309.190909999 2096565.06167 37.7363263207866 -122.469069279331 (37.7363263207866, -122.469069279331)
168616 168616 212045 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 29 San Leandro Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 8ft   5992349.33529 2096549.44226 37.7362857532843 -122.46892934841699 (37.7362857532843, -122.468929348417)
172548 172548 212039 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 55 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 8ft   5992379.72844 2096347.1353900002 37.735732025404296 -122.468809550633 (37.7357320254043, -122.468809550633)
172767 172767 212012 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 10 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 8ft   5992283.163930001 2096610.9428400001 37.736450795054104 -122.46916260289801 (37.7364507950541, -122.469162602898)
176714 176714 212038 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 55 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     34 Width 8ft   5992379.77403 2096317.3198 37.735650161915295 -122.468807224067 (37.7356501619153, -122.468807224067)
178338 178338 212036 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 75 San Leandro Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     22 Width 8ft   5992377.6148 2096246.68077 37.735456080129104 -122.46880955063101 (37.7354560801291, -122.468809550631)
178866 178866 212018 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 30 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     33 Width 8ft   5992340.64621 2096451.66731 37.736016785829 -122.468952276653 (37.736016785829, -122.468952276653)
183177 183177 123548 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 61 05th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     34 Width 8ft   5994235.7315 2115185.59254 37.787564586392605 -122.463759573058 (37.7875645863926, -122.463759573058)
183980 183980 212024 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 70 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 8ft   5992351.29301 2096226.79986 37.735399971427604 -122.468899107835 (37.7353999714276, -122.468899107835)
184196 184196 212014 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 12 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     43 Width 8ft   5992297.48126 2096582.96013 37.736374788861205 -122.469111066343 (37.7363747888612, -122.469111066343)
186223 186223 212016 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 20 San Leandro Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 8ft   5992330.06493 2096504.04396 37.736159987583605 -122.468992670593 (37.7361599875836, -122.468992670593)
186556 186556 248661 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 76 Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 8ft   6005366.58408 2103276.4881700003 37.7555001744107 -122.42440160805401 (37.7555001744107, -122.424401608054)
24033 24033 189426 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 553 Arkansas St 1 : 4 Tree 1 Private 1     23 Width 7ft   6013011.23422 2104452.4501799997 37.759157834075204 -122.398046364864 (37.7591578340752, -122.398046364864)
32637 32637 123853 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 300 Lake St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 7ft   5994558.56386 2114921.26273 37.786857406167 -122.462623463806 (37.786857406167, -122.462623463806)
38674 38674 217832 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2 Cranleigh Dr 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 7ft   5991396.48191 2095769.3933599999 37.7340888381105 -122.472166883492 (37.7340888381105, -122.472166883492)
40650 40650 189425 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 736 Arkansas St 1 Front Yard : Yard 7 Tree 1 Private 1     13 Width 7ft   6012997.735719999 2103581.94425 37.756766863219106 -122.39803198109301 (37.7567668632191, -122.398031981093)
69339 69339 189427 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 535 Arkansas St 1 : 4 Tree 1 Private 1     22 Width 7ft   6013008.4924 2104530.05608 37.759370770158604 -122.39806129180401 (37.7593707701586, -122.398061291804)
131540 131540 248659 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 123 Liberty St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 7ft   6005370.9582 2103985.00212 37.757445835183 -122.42443687405898 (37.757445835183, -122.424436874059)
146409 146409 248641 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 69 Fair Oaks St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     36 Width 7ft   6005403.80316 2103339.90036 37.7556763911732 -122.424277402685 (37.7556763911732, -122.424277402685)
149000 149000 248660 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 121 Liberty St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 7ft   6005401.8239400005 2103987.7242 37.757455052333704 -122.42433032151001 (37.7574550523337, -122.42433032151)
165664 165664 217833 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2 Cranleigh Dr 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     50 Width 7ft   5991415.837069999 2095795.00823 37.734160290163295 -122.47210183374399 (37.7341602901633, -122.472101833744)
167629 167629 126168 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 430 Euclid Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 7ft   5997192.90233 2113882.62114 37.7841569329389 -122.45343429398199 (37.7841569329389, -122.453434293982)
169480 169480 124261 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 208 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 7ft   5994836.24249 2114926.31316 37.7868872610461 -122.461663133326 (37.7868872610461, -122.461663133326)
176654 176654 248640 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 69 Fair Oaks St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     31 Width 7ft   6005405.03328 2103323.5928700003 37.7556316840678 -122.424271988762 (37.7556316840678, -122.424271988762)
9558 9558 122158 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 515 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 6ft   5991239.57046 2111867.63351 37.7782812827035 -122.47388343446801 (37.7782812827035, -122.473883434468)
23531 23531 212068 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 65 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 6ft   5994349.34377 2097659.88165 37.7394500943456 -122.46209504585501 (37.7394500943456, -122.462095045855)
23536 23536 124041 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 825 Lake St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 6ft   5992887.39709 2114800.97407 37.7864307413426 -122.468396508561 (37.7864307413426, -122.468396508561)
24416 24416 212061 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 21 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5994643.85383 2097859.63633 37.740015523303704 -122.461091241468 (37.7400155233037, -122.461091241468)
25739 25739 212063 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 39 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5994526.15715 2097790.3563900003 37.7398185241173 -122.461493163775 (37.7398185241173, -122.461493163775)
25850 25850 248781 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 784 Duncan St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   6001437.23624 2099723.01207 37.745520506460096 -122.43773599094 (37.7455205064601, -122.43773599094)
27171 27171 211993 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 163 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 6ft   5992397.64836 2095631.03278 37.7337668223846 -122.468695504899 (37.7337668223846, -122.468695504899)
27236 27236 124003 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 109 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 6ft   5993937.22707 2114789.14348 37.7864588399995 -122.464763530218 (37.7864588399995, -122.464763530218)
30255 30255 212081 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 143 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   5994296.308209999 2096965.44252 37.737540283266796 -122.462228067287 (37.7375402832668, -122.462228067287)
32333 32333 212083 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 147 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 6ft   5994302.639880001 2096897.5947599998 37.7373543547061 -122.462201256705 (37.7373543547061, -122.462201256705)
33488 33488 248695 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 601 Belvedere St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 6ft   5998641.80195 2105640.75705 37.7616098293386 -122.447828084004 (37.7616098293386, -122.447828084004)
37009 37009 212053 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 15 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 6ft   5994087.049869999 2097764.2191 37.7397214737582 -122.463009504383 (37.7397214737582, -122.463009504383)
37133 37133 212073 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 97 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 6ft   5994261.112380001 2097463.04726 37.7389045557057 -122.46238583625 (37.7389045557057, -122.46238583625)
37697 37697 189470 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 155 Brannan St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 6ft   6015742.102999999 2113440.86493 37.7839897669485 -122.389229269432 (37.7839897669485, -122.389229269432)
37811 37811 126171 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2901 Divisadero St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 6ft   6000513.1495 2118370.5778099997 37.7966694514978 -122.44226974674801 (37.7966694514978, -122.442269746748)
39654 39654 189416 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 1106 Wisconsin St 5 : 4 Tree 1 Private 1     23 Width 6ft   6012793.60681 2102247.59908 37.753091670356206 -122.3986443034 (37.7530916703562, -122.3986443034)
41238 41238 212072 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 93 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5994265.100769999 2097482.56478 37.73895837563 -122.462373461579 (37.73895837563, -122.462373461579)
42282 42282 189469 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 155 Brannan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 6ft   6015634.74697 2113335.0226 37.783693195724204 -122.38959329069799 (37.7836931957242, -122.389593290698)
44553 44553 212084 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 141 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   5994307.65678 2096866.6023 37.7372695459555 -122.462181664062 (37.7372695459555, -122.462181664062)
45672 45672 126172 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 2901 Divisadero St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6000514.61681 2118336.13924 37.7965749759056 -122.44226219603901 (37.7965749759056, -122.442262196039)
48011 48011 246507 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 245 Duncan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 Width 6ft   6004907.84444 2099865.8995 37.746109573211704 -122.42574532919399 (37.7461095732117, -122.425745329194)
48506 48506 212001 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 115 San Leandro Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 6ft   5992392.76715 2095885.63472 37.7344656135867 -122.468730900434 (37.7344656135867, -122.468730900434)
48843 48843 212065 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 49 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5994471.608469999 2097757.10543 37.7397240853877 -122.461679358529 (37.7397240853877, -122.461679358529)
49262 49262 212077 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 115 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5994269.5256900005 2097215.23387 37.7382246061744 -122.46233877833099 (37.7382246061744, -122.462338778331)
51690 51690 251039 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 5400x Geary Blvd 1 Median : Cutout 11 Tree 1 DPW 2     2 Width 6ft   5990159.2899 2112663.7273 37.780404505362 -122.47767868930201 (37.780404505362, -122.477678689302)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 1266.743ms · Data source: data.sfgov.org