Street_Tree_List

Data source: data.sfgov.org

446 rows where qSpecies = 103

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
656 23200 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 520X Van Ness Ave 2 Median : Cutout 11 Tree 1 DPW 2     30 9   6006725.22564 2112390.29825 37.7806011691535 -122.420349841196 (37.7806011691535, -122.420349841196)
684 24323 Permitted Site 1 Eucalyptus globulus :: Blue Gum 103 600X Golden Gate Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6006332.380890001 2112512.31586 37.7809140549901 -122.42171754994101 (37.7809140549901, -122.421717549941)
692 176334 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 287 Hester Ave 7 Side Yard : Yard 17 Tree 1 Private 1     34     6012223.87562 2087782.5469900002 37.713341893097 -122.399599040764 (37.713341893097, -122.399599040764)
701 176335 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 287 Hester Ave 5 Side Yard : Yard 17 Tree 1 Private 1     17     6012233.93602 2087774.2056900002 37.7133195503322 -122.399563683027 (37.7133195503322, -122.399563683027)
887 251303 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1 Cashmere St 2 Back Yard : Yard 13 Tree 1 Health Dept 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
896 251302 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1 Cashmere St 1 Back Yard : Yard 13 Tree 1 Health Dept 8       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
966 251417 Private 5 Eucalyptus globulus :: Blue Gum 103 418 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 MTA 6       3x3   5990003.0 2112517.0 37.779992561868504 -122.478208632121 (37.7799925618685, -122.478208632121)
1070 19942 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY38 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
2603 253136 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 3059 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x5   5999298.0 2114593.0 37.786227889505604 -122.446202552789 (37.7862278895056, -122.446202552789)
3693 252877 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1400 Baker St 2 Front Yard : Yard 7 Tree 1 Private 1       3x3   6000422.0 2113928.0 37.7844660975886 -122.442266061376 (37.7844660975886, -122.442266061376)
3843 253568 Significant Tree 6 Eucalyptus globulus :: Blue Gum 103 301X Sargent St 1 Front Yard : Cutout 8 Tree 1 Private 1       3x3   5993018.0 2089140.0 37.7159798527116 -122.46607925705901 (37.7159798527116, -122.466079257059)
3850 207785 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 290 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   09/28/2017 12:00:00 AM 3 Width 10ft   5993081.87997 2096205.8056700001 37.7353845093885 -122.46637169180299 (37.7353845093885, -122.466371691803)
3884 20320 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 101X Sunset Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
5068 253206 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 2253 09th Ave 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5993186.0 2100608.0 37.7474778324271 -122.466331547971 (37.7474778324271, -122.466331547971)
6027 20016 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY48 0 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
6772 20314 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 101X Sunset Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
6891 7808 Permitted Site 1 Eucalyptus globulus :: Blue Gum 103 700X Franklin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6006239.03041 2112534.82936 37.7809706070447 -122.422042095466 (37.7809706070447, -122.422042095466)
7805 19939 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY38 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
7960 23202 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 520X Van Ness Ave 4 Median : Cutout 11 Tree 1 DPW 2     24 9   6006708.88776 2112470.99571 37.7808218241176 -122.420412091366 (37.7808218241176, -122.420412091366)
8002 19938 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY38 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
8496 20017 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY48 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
8841 23183 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 520X Van Ness Ave 3 Median : Cutout 11 Tree 1 DPW 2   06/09/2005 12:00:00 AM 6 3X3   6006719.9876 2112427.32903 37.780702551515496 -122.42037059124901 (37.7807025515155, -122.420370591249)
9488 17957 Permitted Site 1 Eucalyptus globulus :: Blue Gum 103 2500 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 3x3   6001928.8852 2115030.4127 37.7875788082428 -122.437131721785 (37.7875788082428, -122.437131721785)
9734 173682 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 450x Raymond Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375)
9739 173683 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 450x Raymond Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375)
10119 173856 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 118 Saint Mary's Ave 2 Sidewalk: Property side : Yard 9 Tree 1 DPW 2       Width 3ft   6003956.18287 2095944.61673 37.735288805319904 -122.42875656067 (37.7352888053199, -122.42875656067)
12003 20316 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 101X Sunset Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
12342 24268 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 350X Winding Way 6 Median : Cutout 11 Tree 1 DPW 2     12 8   6001111.916180001 2086587.12369 37.7094338594537 -122.437920185566 (37.7094338594537, -122.437920185566)
12367 24267 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 350X Winding Way 5 Median : Cutout 11 Tree 1 DPW 2     12 8   6001124.44895 2086586.86413 37.7094338594468 -122.43787685174401 (37.7094338594468, -122.437876851744)
14348 19941 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY38 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
14547 19940 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100 STAIRWAY38 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 10ST            
16276 20315 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 101X Sunset Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
17047 20318 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 101X Sunset Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
17109 20319 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 101X Sunset Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
18271 28138 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 418 Eugenia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     90 4X5   6006975.957669999 2097881.62293 37.7407778444163 -122.41845336792801 (37.7407778444163, -122.418453367928)
18477 4843 Permitted Site 1 Eucalyptus globulus :: Blue Gum 103 146 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     70 3X3   6006528.82493 2097534.91084 37.739800668952604 -122.419974789699 (37.7398006689526, -122.419974789699)
19068 26911 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 10 Caine Ave 7 Median : Cutout 11 Tree 1 DPW 2     18 10   5997609.86555 2089654.4499099997 37.7176562610968 -122.450244747607 (37.7176562610968, -122.450244747607)
19139 29600 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 900X Junipero Serra Blvd 9 Median : Cutout 11 Tree 1 DPW 2   03/30/2006 12:00:00 AM 3 3X3   5991176.92289 2091079.14193 37.7211978713578 -122.472584119478 (37.7211978713578, -122.472584119478)
20364 4837 Permitted Site 1 Eucalyptus globulus :: Blue Gum 103 127 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3X3   6006404.24922 2097646.68025 37.7401005434118 -122.420413452032 (37.7401005434118, -122.420413452032)
20653 2618 Landmark tree 9 Eucalyptus globulus :: Blue Gum 103 1661X Octavia St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 10X10   6004876.92395 2115038.87855 37.787769186678204 -122.42693268975599 (37.7877691866782, -122.426932689756)
22892 251144 Significant Tree 6 Eucalyptus globulus :: Blue Gum 103 200X Clarendon Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5996559.0 2104265.0 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022)
22896 251145 Significant Tree 6 Eucalyptus globulus :: Blue Gum 103 200X Clarendon Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1       3x3   5996559.0 2104265.0 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022)
23367 208982 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 320 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     45 Width 3ft   5993096.565780001 2095876.3159599998 37.7344806601409 -122.46629697974501 (37.7344806601409, -122.466296979745)
23922 208951 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 440 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     40 Width 10ft   5993021.57409 2096009.5815299999 37.734842246953896 -122.46656593187099 (37.7348422469539, -122.466565931871)
24218 208954 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 600 Saint Francis Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 8ft   5993495.97502 2095994.9515900002 37.7348294415148 -122.464924714122 (37.7348294415148, -122.464924714122)
24579 247929 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1099 Esmeralda Ave 2 Side Yard : Yard 17 Tree 1 Private 1     37     6010384.7561099995 2098766.60945 37.743399135274295 -122.40672932282301 (37.7433991352743, -122.406729322823)
24602 208981 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 310 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     43 Width 3ft   5993092.40274 2095921.0497 37.7346032476459 -122.466314622626 (37.7346032476459, -122.466314622626)
25657 208945 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 234 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     40 Width 10ft   5992554.30272 2095990.82137 37.73476376044329 -122.46818007286001 (37.7347637604433, -122.46818007286)
25962 209036 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 427 Baden St 2 Front Yard : Yard 7 Tree 1 Private 1     41     6000750.14831 2095370.65935 37.7335308771479 -122.439799837889 (37.7335308771479, -122.439799837889)
25982 247919 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1098 Esmeralda Ave 4 Side Yard : Yard 17 Tree 1 Private 1     22     6010242.48982 2098715.3752200003 37.743250496220895 -122.40721763491001 (37.7432504962209, -122.40721763491)
26365 208940 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     37 Width 10ft   5992201.32921 2095978.5342700002 37.7347096311457 -122.469399518468 (37.7347096311457, -122.469399518468)
26913 224258 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 355 Buena Vista Ave East 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 3ft   6001075.26018 2107893.8305599997 37.7679350014146 -122.439573286101 (37.7679350014146, -122.439573286101)
26944 224225 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1100 San Jose Ave 15 Front Yard : Yard 7 Tree 1 Private 1     32     6004862.254919999 2096710.90423 37.737444098063 -122.42567845649201 (37.737444098063, -122.425678456492)
26956 208920 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 135 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 10ft   5992288.77396 2096040.55395 37.734884974665 -122.46910170710301 (37.734884974665, -122.469101707103)
27200 209021 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 34 Martha Ave 1 Front Yard : Yard 7 Tree 1 Private 1     25     6000790.06178 2095561.6998400001 37.7340577017886 -122.43967553722 (37.7340577017886, -122.43967553722)
28258 208938 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 66 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 10ft   5991979.81471 2095977.19537 37.7346931510662 -122.470165265142 (37.7346931510662, -122.470165265142)
28512 176338 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100x Mansell St 6 Median : Cutout 11 Tree 1 DPW 2     5 Width 0ft   6011479.2515 2090641.1055 37.721149380822 -122.402373605767 (37.721149380822, -122.402373605767)
28820 209004 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 156 Kensington Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 3ft   5994803.6888 2098556.09355 37.7419370183784 -122.460589057359 (37.7419370183784, -122.460589057359)
28853 209017 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 33 Martha Ave 1 : Yard 23 Tree 1 Private 1     25     6000774.79116 2095519.5815700002 37.7339411856303 -122.43972531378401 (37.7339411856303, -122.439725313784)
29038 208963 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 90 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 6ft   5993939.166669999 2096822.57013 37.7371274206966 -122.463452499655 (37.7371274206966, -122.463452499655)
29186 209002 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 115 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     36 Width 4ft   5994119.61861 2096725.9639 37.736872559114104 -122.462821593742 (37.7368725591141, -122.462821593742)
29388 207794 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 213 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 10ft   5993149.25155 2096563.99491 37.736371894833 -122.46616478658999 (37.736371894833, -122.46616478659)
30032 247924 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1098 Esmeralda Ave 9 Side Yard : Yard 17 Tree 1 Private 1     23     6010297.695230001 2098727.78354 37.7432876562154 -122.40702762254499 (37.7432876562154, -122.407027622545)
30144 209022 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 34 Martha Ave 2 Front Yard : Yard 7 Tree 1 Private 1     33     6000785.93499 2095562.5681900003 37.7340598511869 -122.43968986701401 (37.7340598511869, -122.439689867014)
30634 207776 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 110 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 10ft   5993235.98614 2096867.2882599998 37.7372096663776 -122.46588694193001 (37.7372096663776, -122.46588694193)
30943 208922 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 201 Saint Francis Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 10ft   5992403.02946 2096048.0013299999 37.7349120244605 -122.46870723116899 (37.7349120244605, -122.468707231169)
31541 247930 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1099 Esmeralda Ave 3 Side Yard : Yard 17 Tree 1 Private 1     18     6010384.98383 2098777.78466 37.7434298327179 -122.406729322818 (37.7434298327179, -122.406729322818)
32381 207778 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 124 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     17 Width 10ft   5993200.08857 2096786.31561 37.7369852648432 -122.46600517310699 (37.7369852648432, -122.466005173107)
32543 176345 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 450 Raymond Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     34     6008420.88631 2088405.51015 37.7148397004654 -122.412787554496 (37.7148397004654, -122.412787554496)
32753 224251 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 177 Powhattan Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 3ft   6008204.54136 2098121.72815 37.741506207147005 -122.414222358085 (37.741506207147, -122.414222358085)
33426 224248 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 512 Clipper St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 Width 5ft   6001839.26935 2100907.02963 37.7487943903519 -122.43643055213998 (37.7487943903519, -122.43643055214)
33664 207789 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 275 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 10ft   5993131.90761 2096210.54353 37.735400404893 -122.46619907325199 (37.735400404893, -122.466199073252)
33873 208955 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 630 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 8ft   5993530.979180001 2095998.56422 37.7348413791301 -122.464803955838 (37.7348413791301, -122.464803955838)
34400 207800 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Santa Clara Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     42 Width 10ft   5993292.571380001 2096874.95335 37.737233976861205 -122.465691859205 (37.7372339768612, -122.465691859205)
34595 209040 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 419 Baden St 5 Front Yard : Yard 7 Tree 1 Private 1     1     6000753.71672 2095344.13435 37.7334582487793 -122.43978559983 (37.7334582487793, -122.43978559983)
35228 209038 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 419 Baden St 3 Front Yard : Yard 7 Tree 1 Private 1     6     6000746.779019999 2095349.3205099998 37.7334720938659 -122.439809957065 (37.7334720938659, -122.439809957065)
35692 209045 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 300 Melrose Ave 3 Side Yard : Yard 17 Tree 1 Private 1     88     5998032.3562900005 2095523.6559099997 37.733795893852296 -122.44920699922599 (37.7337958938523, -122.449206999226)
35751 224259 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 355 Buena Vista Ave East 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 3ft   6001093.91519 2107903.0746400002 37.767961445086605 -122.43950942341999 (37.7679614450866, -122.43950942342)
36584 208984 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 354 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38 Width 3ft   5993109.71634 2095669.50335 37.7339135629453 -122.466236489538 (37.7339135629453, -122.466236489538)
36668 209041 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 419 Baden St 6 Front Yard : Yard 7 Tree 1 Private 1     1     6000751.4342 2095340.2355900002 37.7334474137664 -122.43979321169901 (37.7334474137664, -122.439793211699)
36761 208976 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 100 Yerba Buena Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 6ft   5994151.01662 2096664.6627200001 37.7367060496466 -122.462708592139 (37.7367060496466, -122.462708592139)
36877 138087 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1611 Octavia St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 Width 0ft   6004894.5944 2114873.9606 37.7873173623789 -122.426859803648 (37.7873173623789, -122.426859803648)
36905 224255 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 388 Corbett Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   5999122.55283 2104753.1321799997 37.7592000986313 -122.446101520571 (37.7592000986313, -122.446101520571)
36907 208993 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 31 Yerba Buena Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 4ft   5993535.26127 2097150.77507 37.7380053101076 -122.46487280074899 (37.7380053101076, -122.464872800749)
37470 176346 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 40 Teddy Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     6011228.44814 2087808.7969 37.7133584325151 -122.40304144861 (37.7133584325151, -122.40304144861)
38393 176339 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 100x Mansell St 7 Median : Cutout 11 Tree 1 DPW 2     26 Width 0ft   6011461.59774 2090655.36204 37.7211875408569 -122.402435631998 (37.7211875408569, -122.402435631998)
39683 191728 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1790 23rd St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21     6013472.8835 2102915.30193 37.754962860065 -122.39634201017999 (37.754962860065, -122.39634201018)
40168 208995 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 21 Yerba Buena Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     35 Width 4ft   5993486.0432 2097190.73028 37.7381121792369 -122.465045871672 (37.7381121792369, -122.465045871672)
40215 207788 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 285 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     19 Width 10ft   5993135.10109 2096167.2284099997 37.7352816566244 -122.46618488553001 (37.7352816566244, -122.46618488553)
40777 207799 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 101 Santa Clara Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 10ft   5993278.012180001 2096833.03373 37.7371180362587 -122.465739151856 (37.7371180362587, -122.465739151856)
41213 224227 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1100 San Jose Ave 17 Front Yard : Yard 7 Tree 1 Private 1     12     6004843.36157 2096707.31423 37.7374331731056 -122.425743524245 (37.7374331731056, -122.425743524245)
41245 138027 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1631 Octavia St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     39 Width 0ft   6004885.3328 2114935.3188 37.7874853129815 -122.426896218405 (37.7874853129815, -122.426896218405)
41325 224244 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1100 San Jose Ave 38 Front Yard : Yard 7 Tree 1 Private 1     23     6004777.47133 2096641.4622900002 37.73724863492671 -122.425966651467 (37.7372486349267, -122.425966651467)
41418 207775 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 110 Santa Clara Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 10ft   5993244.34274 2096906.29835 37.737317260394 -122.465860883191 (37.737317260394, -122.465860883191)
41832 208941 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 130 Saint Francis Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30 Width 10ft   5992287.573419999 2095984.60456 37.734731282309106 -122.469101787134 (37.7347312823091, -122.469101787134)
42046 209030 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 36 Martha Ave 7 Front Yard : Yard 7 Tree 1 Private 1     5     6000755.13076 2095576.9220900002 37.7340975102859 -122.439797395328 (37.7340975102859, -122.439797395328)
42995 52091 Permitted Site 1 Eucalyptus globulus :: Blue Gum 103 300 Dorantes Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/24/2005 12:00:00 AM     Permit Number 48287 5993176.51233561 2099718.04340733 37.745033690620396 -122.46629968747601 (37.7450336906204, -122.466299687476)
43077 191722 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1100 25th St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     6014479.640380001 2101959.5389 37.752394509601494 -122.392793471535 (37.7523945096015, -122.392793471535)
43267 121204 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 44 MacOndray Ln 1 Unaccepted Street : Cutout 20 Tree 1 Private 1     52     6008473.20212 2119153.5676 37.799269800719294 -122.41478152415002 (37.7992698007193, -122.41478152415)
43329 111546 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 900x BOSWORTH ST 24 Front Yard : Yard 7 Tree 1 DPW 2     15     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)

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 98.082ms · Data source: data.sfgov.org