sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
119 251215 3 43 175X Otis St 11 1 1 2       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.42011195674299 (37.7705111956623, -122.420111956743)
746 251371 3 43 390 06th St 3 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
786 251369 3 43 390 06th St 1 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
1766 251688 2 43 925 Sutter St 1 1 1 1       3x3   6008132.0 2115128.0 37.788197407905 -122.415677021756 (37.788197407905, -122.415677021756)
2824 124729 2 43 198X Division St 3 1 1 1       3x3   6010680.0 2108566.0 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104)
3917 253597 3 43 269 Potrero Ave 1 1 1 2       3x3   6010453.0 2107072.0 37.7662077096315 -122.407078650031 (37.7662077096315, -122.407078650031)
4449 59787 1 43 1755 Filbert St 1 1 1 1 1 05/18/2002 12:00:00 AM     Permit Number 19237 6004552.42886001 2119092.68520918 37.7988815571833 -122.428344419585 (37.7988815571833, -122.428344419585)
4532 253201 3 43 800 Oak St 3 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4536 253202 3 43 800 Oak St 4 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4541 253199 3 43 800 Oak St 1 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4545 253200 3 43 800 Oak St 2 5 1 2 3     6x6   6003064.0 2109976.0 37.77376511482 -122.43284323125299 (37.77376511482, -122.432843231253)
4548 253634 3 43 830 Oak St 1 5 3 2           6003018.63904 2109969.70237 37.7737452502421 -122.43299969185101 (37.7737452502421, -122.432999691851)
4562 253642 3 43 427 Columbus Ave 2 1 1 2       3x3   6010361.39347 2118971.94152 37.7988770104459 -122.40823488063499 (37.7988770104459, -122.408234880635)
4854 253694 2 43 536 Octavia St 2 1 1 1       3x3   6005450.0 2111168.0 37.7771730951376 -122.42467448311199 (37.7771730951376, -122.424674483112)
4859 253693 2 43 536 Octavia St 1 1 1 1       3x3   6005450.0 2111168.0 37.7771730951376 -122.42467448311199 (37.7771730951376, -122.424674483112)
5108 124732 2 43 198X Division St 6 1 1 1       3x3   6010680.0 2108566.0 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104)
5755 124730 2 43 198X Division St 4 1 1 1       3x3   6010680.0 2108566.0 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104)
6653 124728 2 43 198X Division St 2 1 1 1       3x3   6010680.0 2108566.0 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104)
6680 112268 2 43 1X Geary St 2 1 1 1                    
6704 112269 2 43 1X Geary St 3 1 1 1                    
7811 124731 2 43 198X Division St 5 1 1 1       3x3   6010680.0 2108566.0 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104)
7941 124727 2 43 198X Division St 1 1 1 1       3x3   6010680.0 2108566.0 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104)
9032 173593 1 43 75 Howard St 3 1 1 1       3x3   6015060.0 2116254.0 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413)
9033 173592 1 43 75 Howard St 2 1 1 1       3x3   6015060.0 2116254.0 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413)
9040 173594 1 43 75 Howard St 4 1 1 1       3x3   6015060.0 2116254.0 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413)
9043 173595 1 43 75 Howard St 5 1 1 1       3x3   6015060.0 2116254.0 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413)
9044 55522 1 43 484 Sanchez St 1 1 1 1   12/06/1972 12:00:00 AM     Permit Number 11483 6003594.27279224 2105459.16759406 37.7613930510814 -122.430686551957 (37.7613930510814, -122.430686551957)
9046 44757 1 43 480 Sanchez St 1 1 1 1         Permit Number 43870 6003593.00847933 2105481.98628904 37.7614556341181 -122.430692553071 (37.7614556341181, -122.430692553071)
9701 173642 2 43 657 Howard St 3 1 1 1       3x3   6012793.0 2114089.0 37.78560546361629 -122.39947767317301 (37.7856054636163, -122.399477673173)
9862 173716 6 43 1652 Fell St 1 8 1 1           5999516.0 2109850.0 37.7732172801378 -122.445107222354 (37.7732172801378, -122.445107222354)
9990 173774 2 43 2239 15th St 1 1 1 1       3x3   6002625.0 2107043.0 37.7656869095489 -122.434152085943 (37.7656869095489, -122.434152085943)
9993 173772 2 43 2235 15th St 1 1 1 1       3x3   6002649.0 2107045.0 37.7656937631635 -122.434069218237 (37.7656937631635, -122.434069218237)
10016 173777 2 43 89 Eureka St 2 1 1 1       3x3   6001439.0 2105287.0 37.760797980712205 -122.438128392537 (37.7607979807122, -122.438128392537)
10023 173776 2 43 89 Eureka St 1 1 1 1       3x3   6001439.0 2105287.0 37.760797980712205 -122.438128392537 (37.7607979807122, -122.438128392537)
10025 173773 2 43 2235 15th St 2 1 1 1       3x3   6002649.0 2107045.0 37.7656937631635 -122.434069218237 (37.7656937631635, -122.434069218237)
10044 120656 2 43 160 Folsom St 2 1 1 1       3x3 Permit Number 778623 6015082.0 2115536.0 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384)
10045 120661 2 43 299X Main St 1 1 1 1       3x3 Permit Number 778623 6015082.0 2115536.0 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384)
10058 120660 2 43 126 Folsom St 1 1 1 1       3x3 Permit Number 778623 6015082.0 2115536.0 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384)
10065 120663 2 43 299X Main St 3 1 1 1       3x3 Permit Number 778623 6015082.0 2115536.0 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384)
10066 120655 2 43 160 Folsom St 1 1 1 1       3x3 Permit Number 778623 6015082.0 2115536.0 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384)
10073 120662 2 43 299X Main St 2 1 1 1       3x3 Permit Number 778623 6015082.0 2115536.0 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384)
10130 173876 2 43 250 Raymond Ave 1 1 1 1       3x3   6009764.0 2087931.0 37.7136120890563 -122.408111727364 (37.7136120890563, -122.408111727364)
10165 173892 2 43 24 Prospect Ave 2 1 1 1       3x3   6007185.0 2099410.0 37.7449861923813 -122.417838888286 (37.7449861923813, -122.417838888286)
10172 173891 2 43 24 Prospect Ave 1 1 1 1       3x3   6007185.0 2099410.0 37.7449861923813 -122.417838888286 (37.7449861923813, -122.417838888286)
10207 58902 1 43 15 Jersey St 1 1 1 1   03/03/1980 12:00:00 AM     Permit Number 18176 6005036.25199829 2101622.63318287 37.7509404143338 -122.425426308198 (37.7509404143338, -122.425426308198)
10210 173906 3 43 2510 Van Ness Ave 2 1 1 2           6005854.79213 2118988.3638299997 37.7986687249765 -122.423830387644 (37.7986687249765, -122.423830387644)
10252 173934 1 43 614 Alabama St 4 1 1 1       9x9   6008960.61704517 2105361.82717089 37.7614283394777 -122.41211965835899 (37.7614283394777, -122.412119658359)
10260 45427 1 43 614 Alabama St 3 1 1 1   07/12/2001 12:00:00 AM   9x9 Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.41211965835899 (37.7614283394777, -122.412119658359)
10266 45428 1 43 614 Alabama St 1 1 1 1   07/12/2001 12:00:00 AM     Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.41211965835899 (37.7614283394777, -122.412119658359)
10267 45426 1 43 614 Alabama St 2 1 1 1   07/12/2001 12:00:00 AM   9x9 Permit Number 44218 6008960.61704517 2105361.82717089 37.7614283394777 -122.41211965835899 (37.7614283394777, -122.412119658359)
10998 112267 2 43 1X Geary St 1 1 1 1                    
11026 173949 2 43 1306 Clayton St 1 1 1 1       3x3   5999102.0 2105133.0 37.760241947595404 -122.446199926833 (37.7602419475954, -122.446199926833)
12922 173948 2 43 1300 Clayton St 1 1 1 1       3x3   5999106.0 2105162.0 37.7603218028196 -122.446188178838 (37.7603218028196, -122.446188178838)
13244 113373 2 43 88 HOWARD ST 4 1 1 1   09/22/2015 12:00:00 AM   3x3   6014757.0 2116474.0 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575)
18014 113224 2 43 4244 23RD ST 1 1 1 1       3x3   6001623.0 2102374.0 37.752810049427794 -122.437283434624 (37.7528100494278, -122.437283434624)
18363 94569 1 43 100@ Cole Carl St 1 1 1 1       3x3   5998051.0 2107197.0 37.765849093366796 -122.449983584058 (37.7658490933668, -122.449983584058)
18683 108105 2 43 2390X Green St 7 5 1 1           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269)
19501 117186 2 43 201x GREENWICH ST 3 1 1 1       6x6   6011833.0 2120374.0 37.80280901508429 -122.40324129087 (37.8028090150843, -122.40324129087)
19551 55849 1 43 2801X Washington St 2 1 1 1 1 09/13/2003 12:00:00 AM     Permit Number 46336 6001333.31634171 2116022.21010841 37.7902681559585 -122.439263383199 (37.7902681559585, -122.439263383199)
19751 96542 1 43 100 Pine St 3 1 1 1         Permit Number 767720 6013094.0 2116579.0 37.7924591936564 -122.398611089295 (37.7924591936564, -122.398611089295)
20082 111807 2 43 50X COLUMBIA SQUARE ST 4 1 1 3       3x3   6010857.0 2110997.0 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357)
20651 115057 2 43 499X BRANNAN ST 3 1 1 1       3x3   6013762.0 2111312.0 37.7780344196247 -122.39593052209601 (37.7780344196247, -122.395930522096)
20843 111792 2 43 55X SHERMAN ST 9 1 1 3       3x3   6010857.0 2110997.0 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357)
27184 117402 2 43 75x BEACH ST 5 1 1 1       3x3   6009846.0 2122112.0 37.80746995952921 -122.410240137563 (37.8074699595292, -122.410240137563)
28450 104230 2 43 409 Walnut St 1 1 1 1       14x8   5998587.6 2115205.6 37.787869332154 -122.44870447955601 (37.787869332154, -122.448704479556)
37389 95036 3 43 3224 Pierce St 7 1 1 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
42747 115058 2 43 499X BRANNAN ST 4 1 1 1       3x3   6013762.0 2111312.0 37.7780344196247 -122.39593052209601 (37.7780344196247, -122.395930522096)
43174 117400 2 43 75x BEACH ST 3 1 1 1       3x3   6009846.0 2122112.0 37.80746995952921 -122.410240137563 (37.8074699595292, -122.410240137563)
49233 85313 6 43 610 Brannan St 1 12 1 1         Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.39955535858401 (37.7766267904106, -122.399555358584)
49591 110708 2 43 2999X Turk St 14 1 1 1       3x3   5996638.0 2111487.0 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531)
51254 120965 2 43 1145x Noe St 2 1 1 1       3x3   6003243.0 2101623.0 37.7508399403415 -122.43162756863 (37.7508399403415, -122.43162756863)
51311 110985 1 43 245x North Point St 4 1 1 1           6009556.06624176 2121873.83782792 37.806799769840296 -122.41122668881 (37.8067997698403, -122.41122668881)
58966 110983 1 43 245x North Point St 2 1 1 1           6009556.06624176 2121873.83782792 37.806799769840296 -122.41122668881 (37.8067997698403, -122.41122668881)
65719 99967 2 43 2270 Folsom St 9 1 1 1           6007986.9 2105322.2 37.761264849910205 -122.415484545241 (37.7612648499102, -122.415484545241)
66011 108152 2 43 2232 Webster St 4 1 1 1           6003295.44003 2116396.66877 37.791407783491294 -122.432501340527 (37.7914077834913, -122.432501340527)
72158 116028 2 43 1500 PACIFIC AVE 1 1 1 1       3x3   6006937.0 2117734.0 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467)
72207 101715 2 43 560 Wisconsin St 1 1 1 1           6012536.0 2104936.0 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341)
77331 106090 1 43 615 Front St 2 1 1 1           6012797.6 2118350.4 37.7973065196251 -122.399761086072 (37.7973065196251, -122.399761086072)
77413 94294 3 43 1150X Fillmore St 1 1 1 2 7         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156)
77420 110696 2 43 2999X Turk St 2 1 1 1       3x3   5996638.0 2111487.0 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531)
77535 111597 2 43 398X BRYANT ST 8 1 1 1       3x3   6014483.0 2113360.0 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281)
77880 93215 1 43 499 Jackson St   1 1 1   02/25/2010 12:00:00 AM   3x3 Permit Number 53209 6011715.0 2118034.0 37.7963773511427 -122.403484907832 (37.7963773511427, -122.403484907832)
78160 44063 1 43 2700 Pierce St 2 1 1 1   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.43831930796699 (37.7948463022786, -122.438319307967)
78196 122714 2 43 855x Kearny St 3 1 1 1       3x3   6011188.0 2117923.0 37.7960431220576 -122.40530062831999 (37.7960431220576, -122.40530062832)
78296 93145 2 43 1152 Clement St 3 1 1 1           5991985.0 2113459.0 37.7826938870859 -122.47142072749399 (37.7826938870859, -122.471420727494)
78377 48697 1 43 405 Howard St 9 1 1 1   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931)
78415 116510 1 43 1500x Waller St 4 1 1 1       3x3   5998488.0 2108327.0 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995)
78427 111811 2 43 50X COLUMBIA SQUARE ST 8 1 1 3       3x3   6010857.0 2110997.0 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357)
78448 102504 1 43 290X Hermann St 2 1 1 1       6x6   6003881.1 2108703.5 37.7703174504719 -122.429925966233 (37.7703174504719, -122.429925966233)
78462 108945 1 43 105 Richland Ave 4 1 1 1           6005294.9 2096235.5 37.7361631827636 -122.424148798432 (37.7361631827636, -122.424148798432)
78813 111595 2 43 398X BRYANT ST 6 1 1 1       3x3   6014483.0 2113360.0 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281)
78842 120144 2 43 1X Hyde St 1 1 1 1       3x3   6008026.0 2111839.0 37.77916064960021 -122.41581078056299 (37.7791606496002, -122.415810780563)
78845 49235 1 43 500 Howard St 8 1 1 1   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.39615519799999 (37.7885414925604, -122.396155198)
78954 113001 2 43 700x STANYAN ST 2 1 1 1       3x3   5997124.0 2108268.0 37.768736698354004 -122.453267191941 (37.768736698354, -122.453267191941)
79069 44125 1 43 431 Jackson St 1 1 1 1         Permit Number 43629 6012046.82946857 2118068.4414971 37.796490448112 -122.40233912369301 (37.796490448112, -122.402339123693)
79132 109603 2 43 602 SHOTWELL ST 3 1 1 1       3x3   6007851.6 2104381.9 37.758675396701 -122.41588590510901 (37.758675396701, -122.415885905109)
79284 97611 1 43 349 10th St 3 1 1 1       3x3   6009106.7 2109348.6 37.7723832922197 -122.41189615048799 (37.7723832922197, -122.411896150488)
79385 110987 1 43 245x North Point St 6 1 1 1           6009556.06624176 2121873.83782792 37.806799769840296 -122.41122668881 (37.8067997698403, -122.41122668881)
79426 116125 2 43 2500X Keith St 1 1 1 3           6014198.52795 2092093.45262 37.7252886606488 -122.39307534923799 (37.7252886606488, -122.393075349238)
79481 49286 1 43 2X Spear St 14 1 1 1   02/07/2003 12:00:00 AM     Permit Number 46305 6014371.0 2116872.0 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763)
79596 117399 2 43 75x BEACH ST 2 1 1 1       3x3   6009846.0 2122112.0 37.80746995952921 -122.410240137563 (37.8074699595292, -122.410240137563)
Powered by Datasette · Query took 15.194ms · Data source: data.sfgov.org