sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
92718 1321 3 143 4050X Alemany Blvd 7 1 1 2     75 TR   5991740.4279021 2087082.0100679002 37.710255321179204 -122.470345319704 (37.7102553211792, -122.470345319704)
78878 2044 3 143 700X Bosworth St 1 8 1 2     36   Permit Number 772999 6002154.6210393 2095431.8532492002 37.733778746199796 -122.43494855504801 (37.7337787461998, -122.434948555048)
112836 2272 3 143 750X Brotherhood Way 6 11 1 2     20 14M   5991074.042616099 2088106.2478104 37.71302907778821 -122.47272309171998 (37.7130290777882, -122.47272309172)
107203 2273 3 143 750X Brotherhood Way 7 11 1 2     35 14M   5991074.042616099 2088106.2478104 37.71302907778821 -122.47272309171998 (37.7130290777882, -122.47272309172)
143021 12967 3 143 99X Lippard Ave 1 1 1 2     30 3X3   6001957.7757889 2095598.483465 37.734225095766796 -122.43564102376301 (37.7342250957668, -122.435641023763)
112623 12968 3 143 99X Lippard Ave 2 1 1 2     36 4X4   6001957.7757889 2095598.483465 37.734225095766796 -122.43564102376301 (37.7342250957668, -122.435641023763)
34310 12969 3 143 99X Lippard Ave 3 1 1 2     36 3X4   6001957.7757889 2095598.483465 37.734225095766796 -122.43564102376301 (37.7342250957668, -122.435641023763)
106673 12970 3 143 99X Lippard Ave 4 1 1 2     36 5X4   6001957.7757889 2095598.483465 37.734225095766796 -122.43564102376301 (37.7342250957668, -122.435641023763)
117342 12974 3 143 84 Lippard Ave 3 1 1 2     24 3X3   6001901.0890899 2095580.5218873 37.734172557472604 -122.43583572272101 (37.7341725574726, -122.435835722721)
129462 13401 3 143 344 Marietta Dr 1 11 1 2     70 5   5999579.163416 2097433.156503 37.739127283554204 -122.443996396446 (37.7391272835542, -122.443996396446)
3445 16362 3 143 1306X Montgomery St 14 11 1 2     18 8   6011452.97865 2119928.00722 37.801563196957204 -122.40452495315901 (37.8015631969572, -122.404524953159)
82763 16363 3 143 1300X Montgomery St 16 11 1 2     12 8   6011500.916866099 2119743.0722499 37.8010580895294 -122.404346040012 (37.8010580895294, -122.404346040012)
119369 16364 3 143 1300X Montgomery St 17 11 1 2     12 8   6011500.916866099 2119743.0722499 37.8010580895294 -122.404346040012 (37.8010580895294, -122.404346040012)
86861 16368 3 143 1400X Montgomery St 1 11 1 2     26 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508)
69279 16369 3 143 1400X Montgomery St 2 11 1 2     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508)
110694 16370 3 143 1400X Montgomery St 3 11 1 2     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508)
80175 16371 3 143 1400X Montgomery St 4 11 1 2     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508)
99481 16372 3 143 1400X Montgomery St 5 11 1 2     12 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508)
128229 16373 3 143 1400X Montgomery St 6 11 1 2     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508)
112248 16374 3 143 1400X Montgomery St 7 11 1 2     12 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508)
114376 18112 3 143 1102X Portola Dr 1 11 1 2     24 10   5995262.3028257005 2098061.6496673 37.7406057719366 -122.458967536918 (37.7406057719366, -122.458967536918)
145419 18113 3 143 1102X PORTOLA DR 2 11 1 2     24 10   5995249.0 2098057.0 37.7405922403942 -122.45901319608299 (37.7405922403942, -122.459013196083)
16804 19778 3 143 100 STAIRWAY18 4 1 1 2     18 50ST            
6719 20066 3 143 100 STAIRWAY54 13 1 1 2     6 15ST            
9550 20300 3 143 50X Sunset Blvd 2 1 1 2     18 60            
7578 20324 3 143 101X Sunset Blvd 12 1 1 2     12 60            
8763 20326 3 143 101X Sunset Blvd 14 1 1 2     36 60            
7875 20330 3 143 101X Sunset Blvd 18 1 1 2     24 60            
7348 20335 3 143 101X Sunset Blvd 22 1 1 2     24 60            
16994 20336 3 143 101X Sunset Blvd 23 1 1 2     36 60            
6436 20340 3 143 101X Sunset Blvd 27 1 1 2     48 40            
13143 20345 3 143 101X Sunset Blvd 31 1 1 2     42 40            
9561 20346 3 143 101X Sunset Blvd 32 1 1 2     18 40            
5922 20397 3 143 262X Sunset Blvd 42 1 1 2     42 60            
10180 20460 3 143 495X Sunset Blvd 25 1 1 2     36 60            
96752 20511 1 143 1211X Sunset Blvd 7 1 1 3     24 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
128747 20512 1 143 1211X Sunset Blvd 8 1 1 3     24 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
82062 20767 3 143 1692X Sunset Blvd 21 1 1 2     24 60   5984807.486919099 2103677.7923597 37.755419639160706 -122.495529849669 (37.7554196391607, -122.495529849669)
96565 20978 3 143 2002X Sunset Blvd 18 1 1 2     12 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
22325 21131 3 143 2292X Sunset Blvd 4 11 1 2     0 60   5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
128359 21135 3 143 2292X Sunset Blvd 8 1 1 2     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
114196 21312 3 143 2501X Sunset Blvd 12 1 1 2     6 60   5985074.890734901 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189)
110317 22454 3 143 6155X 03rd St 3 1 1 2     24 40M   6013523.9988031 2091160.9249677 37.722690633869 -122.395341851189 (37.722690633869, -122.395341851189)
7603 23579 3 143 3100X Van Ness Ave 2 11 1 2     42 3x3   6005511.92719 2121098.1181099997 37.804442208310206 -122.425167011149 (37.8044422083102, -122.425167011149)
6953 23580 3 143 3100X Van Ness Ave 3 11 1 2     24 9   6005507.77084 2121129.71298 37.8045287248816 -122.42518364411501 (37.8045287248816, -122.425183644115)
83211 23673 3 143 319 Virginia Ave 2 11 1 2     12 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
128561 24283 3 143 300X Winding Way 21 11 1 2     6 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
97677 24742 3 143 50X Point Lobos Ave 2 1 1 2     12 12x12   5982568.6363699995 2112600.93828 37.779788677407105 -122.50393321801701 (37.7797886774071, -122.503933218017)
21066 30050 3 143 900X Junipero Serra Blvd 1 11 1 2     3 3X3   5991182.4145599995 2091161.54655 37.7214244519661 -122.472571141372 (37.7214244519661, -122.472571141372)
159704 38524 1 143 3031 Steiner St 3 1 1 1   09/15/1998 12:00:00 AM 4   Permit Number 40508 6001948.5977 2118592.4425 37.7973603403586 -122.43731867582599 (37.7973603403586, -122.437318675826)
152465 54486 1 143 535 39th Ave 1 1 1 1   07/11/1972 12:00:00 AM 8   Permit Number 10278 5983764.831730001 2112189.27219 37.7787286289905 -122.499764682948 (37.7787286289905, -122.499764682948)
112766 92207 1 143 300X Miramar Ave 1 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
100266 92210 1 143 300x Miramar Ave 4 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
138508 96480 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
97749 96481 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
109217 96482 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
86907 96483 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
81160 96570 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
113578 96571 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
58967 96572 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
93919 96976 2 143 390X Filbert St 1 3 1 3     28     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116)
120510 97485 2 143 500X Miramar Ave 1 11 1 1     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.45802268806801 (37.7258701708071, -122.458022688068)
90036 97489 2 143 500X Miramar Ave 5 11 1 1     30 15x280   5995423.2 2092691.6 37.7258701708071 -122.45802268806801 (37.7258701708071, -122.458022688068)
126256 97490 2 143 500X Miramar Ave 7 11 1 1     12 15x280   5995423.2 2092691.6 37.7258701708071 -122.45802268806801 (37.7258701708071, -122.458022688068)
75150 97534 6 143 203 Surrey St 1 7 1 1         Permit Number 768282 6002070.0 2096079.6 37.73555250464221 -122.435287431957 (37.7355525046422, -122.435287431957)
128311 98265 7 143 755 O'Farrell St   13 1 1         Backyard tree; not significant 6007700.0 2113968.3 37.784988860902295 -122.417089467607 (37.7849888609023, -122.417089467607)
107888 98601 2 143 301 Twin Peaks Blvd 1 5 1 1     24 3x3   5998661.2 2104103.7 37.757390562446 -122.447650343479 (37.757390562446, -122.447650343479)
87158 98835 3 143 1100X Portola Dr 1 7 1 2           5995262.0 2098056.7 37.7405921639667 -122.458968225676 (37.7405921639667, -122.458968225676)
97197 98836 3 143 1101X Portola Dr 6 9 1 2           5994967.957909999 2097979.30417 37.740362747150996 -122.459979297607 (37.740362747151, -122.459979297607)
6592 98837 3 143 1101X Portola Dr 9 9 1 2                    
14567 98839 3 143 1101X Portola Dr 4 9 1 2                    
128319 99451 2 143 400X Miramar Ave 1 11 1 1     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.45812076272101 (37.7250639553871, -122.458120762721)
145354 99455 2 143 400X Miramar Ave 5 11 1 1     30 15x280   5995388.7 2092398.7 37.7250639553871 -122.45812076272101 (37.7250639553871, -122.458120762721)
120095 99457 2 143 550X Miramar Ave 1 11 1 1     30 15x280   5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
142707 99458 2 143 550X Miramar Ave 3 11 1 1     30 15x280   5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
126291 99460 2 143 550X Miramar Ave 7 11 1 1     30 15x280   5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
112364 99472 2 143 600X Miramar Ave 5 11 1 1     30 15x280   5995435.2 2093399.0 37.727813210556704 -122.458032376835 (37.7278132105567, -122.458032376835)
80646 99473 2 143 600X Miramar Ave 2 11 1 1     30 15x280   5995435.2 2093399.0 37.727813210556704 -122.458032376835 (37.7278132105567, -122.458032376835)
99445 99474 2 143 650X Miramar Ave 5 11 1 1     30 15x280   5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
101015 99477 2 143 650X Miramar Ave 6 11 1 1     30 15x280   5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
114163 99486 2 143 700X Miramar Ave 3 11 1 1     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204)
88472 99487 2 143 700X Miramar Ave 4 11 1 1     30 15x280   5995446.3 2094052.9 37.7296092999141 -122.458041307204 (37.7296092999141, -122.458041307204)
145927 99774 2 143 4330 26th St 1 1 1 1       8x6   6001764.0 2100607.0 37.7479663028981 -122.436669359529 (37.7479663028981, -122.436669359529)
109239 100845 2 143 1 Estero Ave 3 9 1 1           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695)
120808 101027 3 143 1010X Portola Dr 1 7 1 2           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
140599 101028 3 143 1010X Portola Dr 2 7 1 2           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
129469 101030 3 143 1010X Portola Dr 4 3 1 2     40     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
129360 101032 3 143 1010X Portola Dr 6 7 1 2           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
111337 101035 3 143 1010X Portola Dr 9 7 1 2   09/03/2014 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
9596 102839 2 143 1101X Portola Dr 2 9 1 2                    
77640 105838 3 143 39X Bonview St 1 7 1 2     15     6007716.90579 2099172.4114099997 37.7443637468546 -122.415982827151 (37.7443637468546, -122.415982827151)
121646 107347 3 143 1126X PORTOLA DR 1 11 1 2     68     5994964.0 2098019.0 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341)
7555 107448 2 143 1111x Chestnut St 1 14 1 1     50     6006408.68895 2120404.8626200003 37.80258932431129 -122.42201440535801 (37.8025893243113, -122.422014405358)
26646 107449 2 143 1130x CHESTNUT ST 1 14 1 1     60     6006351.9 2120450.9 37.802712528214705 -122.42221419659701 (37.8027125282147, -122.422214196597)
8668 107450 2 143 1140x Chestnut St 1 14 1 1     60     6006380.05181 2120425.48408 37.802644330436394 -122.42211497023399 (37.8026443304364, -122.422114970234)
160604 107487 3 143 1306x Montgomery St 12 11 1 2     23     6011454.1798 2119912.99001 37.801522030487 -122.40451973891001 (37.801522030487, -122.40451973891)
37436 107492 3 143 1306x Montgomery St 21 11 1 2     26     6011443.89272 2119983.46704 37.80171496831821 -122.404560301033 (37.8017149683182, -122.404560301033)
102335 108605 2 143 1140x CHESTNUT ST 2 14 1 1           6006369.1 2120452.7 37.802718440704204 -122.42215480373899 (37.8027184407042, -122.422154803739)
81729 109625 2 143 312x FILBERT ST 1 14 1 1     14     6011362.9 2120079.8 37.801974948341 -122.40484736081001 (37.801974948341, -122.40484736081)
88665 109838 6 143 200x MONTCALM ST 1 1 1 1     30 3x3   6009924.0 2099647.0 37.745790704819704 -122.408384592716 (37.7457907048197, -122.408384592716)
114274 110143 3 143 1130X PORTOLA DR 3 2 1 2       3x3   5994964.0 2098019.0 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341)
Powered by Datasette · Query took 4.463ms · Data source: data.sfgov.org