sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
141674 104634 1 54 217 Montcalm St   7 2 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
142588 104374 2 17 22 GARDENSIDE DR 1 3 2 1       50x50   5999468.0 2101996.0 37.7516494117124 -122.444708626009 (37.7516494117124, -122.444708626009)
143940 106932 2 98 358 SHOTWELL ST 1 1 2 1       8x10   6007793.2 2105846.4 37.7626932925098 -122.416191600332 (37.7626932925098, -122.416191600332)
145017 99533 1 17 188 Spear St 1 1 2 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
145403 99528 1 17 120 Howard St 2 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
145716 98878 7 17 11 Panorama Dr   13 2 1           5998029.0 2100213.0 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849)
152708 117679 2 106 7800 Geary Blvd 2 1 2 1     19 Width 3ft   5982700.570040001 2112440.0728599997 37.7793547453385 -122.50346489390199 (37.7793547453385, -122.503464893902)
172552 140265 2 98 2100X Grove St 3 1 2 1     0 Width 0ft   5997671.17 2110272.3417 37.7742714515841 -122.45151917218 (37.7742714515841, -122.45151917218)
178249 227519 2 284 375 Alabama St 1 4 2 1     8 Width 3ft   6008967.54586 2106408.18704 37.7643017925286 -122.41216964832199 (37.7643017925286, -122.412169648322)
114314 108701 1 12 478 30th St   1 2 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774626 6003507.49152 2098366.3309400002 37.7419128730633 -122.43048058961 (37.7419128730633, -122.43048058961)
82393 108910 1 7 129 Ellert St 1 1 2 1 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 773054 6007361.2 2097016.9 37.7384251864379 -122.417060086005 (37.7384251864379, -122.417060086005)
81307 20137 1 82 898 Steiner St 1 1 2 1   01/11/2011 12:00:00 AM 3 8x4 Permit Number 54088 6003009.7075288 2111327.5412022998 37.777473032235704 -122.433127623561 (37.7774730322357, -122.433127623561)
102823 20136 1 82 890 Steiner St 1 1 2 1   01/11/2011 12:00:00 AM 3 8x4 Permit Number 54087 6003007.0 2111306.0 37.777413731872 -122.43313545029301 (37.777413731872, -122.433135450293)
140914 114321 1 12 2118 47th Ave 1 8 2 1   01/14/2016 12:00:00 AM   5x16 Permit Number 777356 5981743.9 2100646.6 37.7469169691931 -122.505899765145 (37.7469169691931, -122.505899765145)
128347 104667 1 18 172 Clipper St 1 1 2 1 1 01/19/2016 12:00:00 AM   6x12 Permit Number 777366 6003998.6 2101043.1 37.749290469922705 -122.42897329466999 (37.7492904699227, -122.42897329467)
99206 115258 1 54 2150 Jackson St   24 2 1   01/21/2016 12:00:00 AM   6x12   6003858.0 2116995.5 37.7930839063862 -122.430597643601 (37.7930839063862, -122.430597643601)
114892 115259 1 54 2130 Jackson St   1 2 1   01/21/2016 12:00:00 AM   6x12   6003918.8 2117004.0 37.7931106894063 -122.43038787884501 (37.7931106894063, -122.430387878845)
101450 109486 2 88 1314 POLK ST 1 10 2 2   01/23/2016 04:50:00 AM 3 3x3   6006825.7 2115468.8 37.7890596427133 -122.420220804515 (37.7890596427133, -122.420220804515)
10092 173852 1 54 450 Toland St 7 1 2 1   01/27/2017 12:00:00 AM 3 8.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10093 173849 1 54 450 Toland St 4 1 2 1   01/27/2017 12:00:00 AM 3 17.6x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10096 173850 1 54 450 Toland St 5 1 2 1   01/27/2017 12:00:00 AM 3 13.9x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10097 173851 1 54 450 Toland St 6 1 2 1   01/27/2017 12:00:00 AM 3 27.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10098 173848 1 54 450 Toland St 3 1 2 1   01/27/2017 12:00:00 AM 3 19.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10101 173846 1 54 450 Toland St 1 1 2 1   01/27/2017 12:00:00 AM 3 15x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10104 173847 1 54 450 Toland St 2 1 2 1   01/27/2017 12:00:00 AM 3 11.85x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10106 173853 1 54 450 Toland St 8 1 2 1   01/27/2017 12:00:00 AM 3 26.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
96749 93115 1 75 397 San Jose Ave 1 21 2 1   02/02/2009 12:00:00 AM   26x6 Permit Number 53167 6006259.6 2100887.6 37.7489912240508 -122.42114365927 (37.7489912240508, -122.42114365927)
123584 109253 1 88 1355 46th Ave 1 1 2 1 1 02/05/2015 12:00:00 AM 3 3x3 Permit Number 773041 5981790.7 2105864.5 37.7612466017789 -122.50612476738199 (37.7612466017789, -122.506124767382)
42994 109343 1 54 3211 Baker St 2 9 2 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
83041 109366 1 54 1205 Filbert St 3 5 2 1 1 02/11/2015 12:00:00 AM 3 3.125x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
84402 109353 5 253 2505 Pacific Ave 6 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
91154 109365 1 54 1205 Filbert St 2 1 2 1 1 02/11/2015 12:00:00 AM 3 4.5x16   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
97307 109345 1 54 3211 Baker St 4 9 2 1   02/11/2015 12:00:00 AM 3 8.75x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
99464 109344 1 54 3211 Baker St 3 9 2 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
101115 109364 1 54 1205 Filbert St 1 1 2 1 1 02/11/2015 12:00:00 AM 3 4.5x6   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
104832 109350 5 253 2505 Pacific Ave 3 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
113379 109349 5 253 2505 Pacific Ave 2 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
116207 109368 1 54 1205 Filbert St 5 1 2 1 1 02/11/2015 12:00:00 AM 3 3x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
122284 109352 5 253 2505 Pacific Ave 5 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
124298 109367 1 54 1205 Filbert St 4 1 2 1 1 02/11/2015 12:00:00 AM 3 4.5x6.5   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
125736 109351 5 253 2505 Pacific Ave 4 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
125946 109370 1 54 2061 Hyde St 2 1 2 1 1 02/11/2015 12:00:00 AM 3 13x6   6007159.6 2119443.7 37.799992536546505 -122.41934764587201 (37.7999925365465, -122.419347645872)
128427 109369 1 54 2061 Hyde St 1 1 2 1 1 02/11/2015 12:00:00 AM 3 5x6   6007159.6 2119443.7 37.799992536546505 -122.41934764587201 (37.7999925365465, -122.419347645872)
139898 109348 5 253 2505 Pacific Ave 1 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
140543 109342 1 54 3211 Baker St 1 9 2 1   02/11/2015 12:00:00 AM 3 1x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
81298 104856 1 54 739 27th St   1 2 1   02/12/2015 12:00:00 AM 3     6001722.3 2099959.7 37.746186600460604 -122.43676722664301 (37.7461866004606, -122.436767226643)
79071 95369   17 27 Hartford St   8 2 1   02/18/2011 12:00:00 AM       6002651.0 2105744.0 37.7621216467866 -122.433969295968 (37.7621216467866, -122.433969295968)
145744 109499 1 7 99 Surrey St 1 1 2 1 1 02/19/2015 12:00:00 AM 3 3x3 Permit Number 774984 6002392.9 2096233.9 37.7359945088656 -122.43418207236999 (37.7359945088656, -122.43418207237)
101235 109535 1 54 1234 Filbert St 3 5 2 1 1 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
112218 109536 1 54 1234 Filbert St 4 5 2 1 1 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
126302 109534 1 54 1234 Filbert St 2 5 2 1 1 02/23/2015 12:00:00 AM 3 1.5x2.6   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
85124 85121 1 19 1403 11th Ave 2 5 2 1   02/27/2007 12:00:00 AM 7 2x2 Tree 2. Permit Number 49495. 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
80534 96292 1 17 1294 Union St   6 2 1   03/21/2011 12:00:00 AM       6006773.0 2119090.0 37.7989995844362 -122.420660308797 (37.7989995844362, -122.420660308797)
100936 96291 1 17 1294 Union St   6 2 1   03/21/2011 12:00:00 AM       6006773.0 2119090.0 37.7989995844362 -122.420660308797 (37.7989995844362, -122.420660308797)
96541 110246 1 54 1706 28th Ave 1 1 2 1   04/01/2015 12:00:00 AM 3 1.5x12   5987540.7 2103643.4 37.755484875136204 -122.486075162345 (37.7554848751362, -122.486075162345)
138475 96182 1 17 330 South Van Ness Ave   8 2 1   04/04/2011 12:00:00 AM     Permit Number 767813 6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
127072 99201 1 17 4016 26th St   1 2 2 1 04/12/2012 12:00:00 AM   6x10.5 Permit Number 768835 6003752.7 2100736.7 37.7484352450997 -122.429801769855 (37.7484352450997, -122.429801769855)
963 251419 2 50 39 Jones St 2 1 2 1   04/14/2015 12:00:00 AM   3x3   6009068.0 2112723.0 37.781646426577 -122.412268559085 (37.781646426577, -122.412268559085)
970 251418 2 50 39 Jones St 1 1 2 1   04/14/2015 12:00:00 AM   3x3   6009068.0 2112723.0 37.781646426577 -122.412268559085 (37.781646426577, -122.412268559085)
10638 96234 1 17     1 2 1   04/15/2011 12:00:00 AM     Permit Number 767856          
87250 93936 1 17 230 Seacliff Ave   21 2 1   04/26/2010 12:00:00 AM   37x6   5987086.7 2115743.7 37.7886824393648 -122.488534508212 (37.7886824393648, -122.488534508212)
101338 110613 1 134 200 McAllister St 1 1 2 1   04/27/2015 12:00:00 AM 3 12.8x7.8 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338)
79393 106516 1 17 366 Hill St   1 2 1   05/07/2014 12:00:00 AM   3X3 Permit Number 772751 6003996.2 2103381.7 37.755711581068795 -122.42914832014 (37.7557115810688, -122.42914832014)
1389 251532 1 54 2100X 20th St 4 1 2 1   05/15/2017 12:00:00 AM 3 4x11            
1391 251531 1 54 2100X 20th St 2 1 2 1   05/15/2017 12:00:00 AM 3 4x11            
89308 103623 1 241 333 El Camino Del Mar 1 5 2 1   06/04/2013 12:00:00 AM   13x2 Permit Number 770205 5987603.5 2115303.5 37.787503918723395 -122.48671414227199 (37.7875039187234, -122.486714142272)
1800 251700 1 54 1560 Sanchez St 1 1 2 1   06/05/2017 12:00:00 AM 3 410x11 Permit Number 780193 6003924.0 2099150.0 37.7440882334859 -122.429096301435 (37.7440882334859, -122.429096301435)
143440 117372 1 54 1533 McAllister St 5 5 2 1   06/08/2016 12:00:00 AM 3 1x2.75   6001806.7 2111472.8 37.777803561930206 -122.437299621265 (37.7778035619302, -122.437299621265)
101836 92072 1 168 3001 Pacific Ave   5 2 1   06/18/2009 12:00:00 AM     Permit Number 52188 5999733.7 2116663.4 37.791937538515604 -122.444844029888 (37.7919375385156, -122.444844029888)
116050 111759 1 54 1235 47th Ave 2 2 2 1   06/23/2015 12:00:00 AM 3 6x4   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143)
145543 111758 1 54 1235 47th Ave 1 1 2 1   06/23/2015 12:00:00 AM 3 6x6   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143)
105398 117608 1 54 450 Hayes St 1 1 2 1   06/29/2016 12:00:00 AM 3     6005708.4 2111040.6 37.776837876057 -122.423771533631 (37.776837876057, -122.423771533631)
84066 83339 1 51 2233 28th Ave 1 1 2 1   07/01/2009 12:00:00 AM   3x3 Permit Number 52332 5987590.2167451 2100087.03718588 37.7457229434205 -122.485642930331 (37.7457229434205, -122.485642930331)
84751 82096 1 18 1363 Francisco St 1 1 2 1   07/01/2009 12:00:00 AM   3x3 Permit Number 52338 6004802.97001971 2120513.88344233 37.802797975517294 -122.42757877147899 (37.8027979755173, -122.427578771479)
97501 82889 1 37 1423 Francisco St 1 1 2 1   07/01/2009 12:00:00 AM   3x3 Permit Number 52339 6004509.13864627 2120473.3950974997 37.8026701808582 -122.42859269053001 (37.8026701808582, -122.42859269053)
99500 83367 1 37 3124-3128 Laguna St 1 1 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52345 6003823.24826281 2119450.20874415 37.7998219368855 -122.43089315213301 (37.7998219368855, -122.430893152133)
102817 80937 1 37 3124-3128 Laguna St 2 1 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52345 6003823.24826281 2119450.20874415 37.7998219368855 -122.43089315213301 (37.7998219368855, -122.430893152133)
127755 83007 1 457 1058 De Haro St 1 11 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52381 6012170.46860809 2103464.70975517 37.7563988530014 -122.40088475581499 (37.7563988530014, -122.400884755815)
128027 82995 1 12 1412 Quesada Ave 1 1 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52364 6016260.71862294 2093905.81391215 37.730379387125204 -122.38607277339099 (37.7303793871252, -122.386072773391)
96456 5412 1 17 414 Dolores St 1 1 2 1   07/07/2008 12:00:00 AM   3x3   6004849.3785887 2105949.0211321 37.7628090992038 -122.426380541105 (37.7628090992038, -122.426380541105)
80289 79468 1 11 606 Webster St 1 1 2 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52423 6004042.90191121 2110875.50885644 37.7762904169609 -122.42952121696301 (37.7762904169609, -122.429521216963)
107139 82886 1 134 761 Clementina St 1 1 2 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52437 6009240.34446046 2110165.45314704 37.7746336766823 -122.41149158097299 (37.7746336766823, -122.411491580973)
107768 82751 1 147 52 Sheridan St 1 1 2 1   07/07/2009 12:00:00 AM 3 3x3 Permit Number 52446 6009256.89976445 2109417.42292722 37.772580689338 -122.41138145626002 (37.772580689338, -122.41138145626)
107476 82512 1 12 52 Tulane St 1 1 2 1   07/08/2009 12:00:00 AM   3x3 Permit Number 52482 6007264.0 2093867.0 37.7297707824944 -122.41717301728399 (37.7297707824944, -122.417173017284)
2270 253008 1 54 1201 Tennessee St 1 1 2 1   07/10/2017 12:00:00 AM 3 11x477   6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
91444 107078 2 17 92 Homestead St   5 2 1   07/25/2014 12:00:00 AM   3x3.5 Permit Number 773562 6000948.33481 2101213.46128 37.7495851129185 -122.439533357227 (37.7495851129185, -122.439533357227)
97405 85294 1 86 2255 Mariposa St   5 2 1   07/27/2007 12:00:00 AM   2x50 Permit Number 49675 6010752.0 2105977.0 37.7632178155038 -122.40596731591499 (37.7632178155038, -122.405967315915)
99380 119616 5 54 400 Grove St 1 1 2 1   07/28/2016 12:00:00 AM 3     6005873.6969099995 2111410.5639299997 37.777863036884796 -122.42322602570499 (37.7778630368848, -122.423226025705)
92510 88654 1 461 94 Danton St   5 2 1   08/05/2008 12:00:00 AM     Permit Number 51634 6002844.0 2094598.0 37.7315282931893 -122.43250562955099 (37.7315282931893, -122.432505629551)
120372 88656 1 461 94 Danton St   5 2 1   08/05/2008 12:00:00 AM     Permit Number 51634 6002844.0 2094598.0 37.7315282931893 -122.43250562955099 (37.7315282931893, -122.432505629551)
49594 112605 1 54 1534 Hayes St 1 1 2 1   08/10/2015 12:00:00 AM   5.6x12   6000465.0 2110329.2 37.7745871625182 -122.441858914128 (37.7745871625182, -122.441858914128)
118241 4313 3 98 727 Chenery St 1 1 2 2   08/17/2013 12:00:00 AM   3X3   6002321.2517800005 2095689.19659 37.7344948117373 -122.434390856497 (37.7344948117373, -122.434390856497)
3170 208471 1 141 1175 Kirkham St 1 1 2 1   08/23/2017 12:00:00 AM 3 Width 2ft Permit Number 780657 5991201.16474 2105172.16858 37.7598951180952 -122.473527781682 (37.7598951180952, -122.473527781682)
3287 253411 1 11 1321 Mission St 3 1 2 1   08/30/2017 12:00:00 AM 3 4x12 Permit Number 775218 6008256.52806819 2110680.03106396 37.775991353803896 -122.414931236288 (37.7759913538039, -122.414931236288)
3292 253409 1 11 1321 Mission St 1 1 2 1   08/30/2017 12:00:00 AM 3 4x12 Permit Number 775218 6008256.52806819 2110680.03106396 37.775991353803896 -122.414931236288 (37.7759913538039, -122.414931236288)
3295 253410 1 11 1321 Mission St 2 1 2 1   08/30/2017 12:00:00 AM 3 4x12 Permit Number 775218 6008256.52806819 2110680.03106396 37.775991353803896 -122.414931236288 (37.7759913538039, -122.414931236288)
3305 253412 1 11 1321 Mission St 4 1 2 1   08/30/2017 12:00:00 AM 3 4x12 Permit Number 775218 6008256.52806819 2110680.03106396 37.775991353803896 -122.414931236288 (37.7759913538039, -122.414931236288)
139298 92611 1 98 3856 23rd St   6 2 1   08/31/2009 12:00:00 AM     Permit Number 52924 6004067.0 2102488.0 37.753261698893496 -122.428839761175 (37.7532616988935, -122.428839761175)
3639 253517 1 54 559 24th Ave 2 5 2 1   09/15/2017 12:00:00 AM 3 2x4.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3643 253515 1 54 559 24th Ave 1 1 2 1   09/15/2017 12:00:00 AM 3 7x9.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3650 253518 1 54 559 24th Ave 3 5 2 1   09/15/2017 12:00:00 AM 3 2x1   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
Powered by Datasette · Query took 3.578ms · Data source: data.sfgov.org