sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4723 253676 1 54 2975 Van Ness Ave 6 5 2 1   10/24/2017 12:00:00 AM 3 3.2x3.75   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
4726 253675 1 54 2975 Van Ness Ave 1 5 2 1   10/24/2017 12:00:00 AM 3 3.2x14.2   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
110212 110320 7 54 9 Imperial Aly   13 2 1           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274)
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)
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)
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)
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)
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)
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)
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)
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)
92559 92776 1 4 2701 Pacific Ave   5 2 1   10/15/2009 12:00:00 AM     Permit Number 52996 6001178.5 2116864.5 37.7925720539586 -122.43985945141 (37.7925720539586, -122.43985945141)
109480 92778 1 4 2701 Pacific Ave   5 2 1   10/15/2009 12:00:00 AM     Permit Number 52996 6001178.5 2116864.5 37.7925720539586 -122.43985945141 (37.7925720539586, -122.43985945141)
113495 92775 1 17 2701 Pacific Ave   1 2 1   10/15/2009 12:00:00 AM     Permit Number 52996 6001178.5 2116864.5 37.7925720539586 -122.43985945141 (37.7925720539586, -122.43985945141)
140567 94962 1 17 3098@Lyon Pacific Ave   5 2 1   10/25/2010 12:00:00 AM       5999362.0 2116697.3 37.7920093994348 -122.44613254842899 (37.7920093994348, -122.446132548429)
94304 94961 1 17 3098 PACIFIC AVE 1 5 2 1   10/25/2010 12:00:00 AM       5999362.0 2116697.0 37.792008575714 -122.446132526841 (37.792008575714, -122.446132526841)
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)
1666 251642 2 98 2253 Broderick St 4 1 2 1       3x3   6000298.51737 2116393.24113 37.7912279703404 -122.442870356286 (37.7912279703404, -122.442870356286)
82677 99536 1 17 188 Spear St 4 1 2 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
129064 99535 1 17 188 Spear St 3 1 2 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
138642 99534 1 17 188 Spear St 2 1 2 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
145017 99533 1 17 188 Spear St 1 1 2 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
86544 99529 1 17 120 Howard St 3 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
87791 99527 1 17 120 Howard St 1 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
114228 99531 1 17 120 Howard St 5 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
124767 99530 1 17 120 Howard St 4 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
138994 99532 1 17 120 Howard St 6 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
145403 99528 1 17 120 Howard St 2 1 2 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
98437 113995 1 54 3221 Washington St 1 1 2 1   10/27/2015 12:00:00 AM   39x3   5999265.7 2115942.6 37.789931692456996 -122.44641142836599 (37.789931692457, -122.446411428366)
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)
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)
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)
83840 107144 2 54 360 Spear St 1 1 2 1           6015708.0 2115219.0 37.7888702311939 -122.38947147438 (37.7888702311939, -122.38947147438)
110489 109322 2 64 191 24TH AVE 1 1 2 1       3x3   5988309.1 2114757.6 37.7860461422813 -122.484232887865 (37.7860461422813, -122.484232887865)
88689 109762 1 54 1801 Scott St 1 5 2 1       1.5x6.5   6001511.7 2114646.3 37.786500410729104 -122.43854756475099 (37.7865004107291, -122.438547564751)
97786 109767 1 54 1801 Scott St 2 5 2 1       11.75x1.5+3.6x3.6   6001511.7 2114646.3 37.786500410729104 -122.43854756475099 (37.7865004107291, -122.438547564751)
20483 109769 1 54 2502X Bush St 2 5 2 1       1.5x12.75   6001313.62368 2114572.17699 37.786285618589204 -122.43922754338101 (37.7862856185892, -122.439227543381)
106864 109768 1 54 2502X Bush St 1 5 2 1       1.5x13   6001313.62368 2114572.17699 37.786285618589204 -122.43922754338101 (37.7862856185892, -122.439227543381)
104353 98250 1 17 650 Eddy St   1 2 1         Sidewalk landscaping permit adjacent to building. 6007271.2 2113371.6 37.783326336649 -122.41853065554 (37.783326336649, -122.41853065554)
102661 117259 1 54 670 Eddy St 1 5 2 1       3x3   6007197.5 2113350.2 37.7832634280904 -122.418784110751 (37.7832634280904, -122.418784110751)
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)
85779 110615 1 134 200 McAllister St 3 1 2 1   12/31/2015 12:00:00 AM 3 13.2x7.8 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338)
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)
143386 110614 1 134 200 McAllister St 2 1 2 1   12/31/2015 12:00:00 AM 3 21.4x7.8 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338)
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)
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)
3660 253516 1 54 559 24th Ave 1 5 2 1   09/15/2017 12:00:00 AM 3 2x2   5988392.0 2112177.0 37.778965370493495 -122.483756799769 (37.7789653704935, -122.483756799769)
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)
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)
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)
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)
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)
41228 117919 2 284 727 41st Ave 2 1 2 1     3 Width 3ft   5983193.78874 2110818.2250200002 37.774930606826 -122.501638652158 (37.774930606826, -122.501638652158)
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)
105108 104859 1 54 650 Fillmore St   1 2 1           6003597.7 2110555.4 37.775386259915 -122.43103844044701 (37.775386259915, -122.431038440447)
88984 109756 1 54 601 Steiner St 3 5 2 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
118010 109755 1 54 601 Steiner St 2 5 2 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
121197 109754 1 54 601 Steiner St 1 5 2 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
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)
91008 120156 6 43 758 10th Ave 1 1 2 1     10     5992930.0 2110298.0 37.77406925887279 -122.467921468059 (37.7740692588728, -122.467921468059)
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)
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)
79432 106576 5 64 507 STEINER ST 1 7 2 1           6003113.3 2110111.6 37.7741402349502 -122.432682383122 (37.7741402349502, -122.432682383122)
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)
102839 102414 2 60 1301 Page St 2 1 2 1           6000345.0 2109213.0 37.77151552050871 -122.44219387377399 (37.7715155205087, -122.442193873774)
81443 100355 1 18 591 Waller St   1 2 1   12/30/2014 12:00:00 AM 3 27x6 Permit Number 769031 6002899.6 2108847.2 37.770656382716396 -122.43333123962 (37.7706563827164, -122.43333123962)
114285 96183 1 17 330 South Van Ness Ave   8 2 1           6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
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)
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)
86307 93162 1 17 201 Upper Ter 3 5 2 1   12/22/2009 12:00:00 AM   3x3   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
128554 93164 1 98 201 Upper Ter 2 5 2 1   12/22/2009 12:00:00 AM   1x2   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
143329 93161 1 17 201 Upper Ter 2 5 2 1   12/22/2009 12:00:00 AM   1x1   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
143915 93160 1 17 201 Upper Ter 1 5 2 1   12/22/2009 12:00:00 AM   1x1   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
Powered by Datasette · Query took 4.056ms · Data source: data.sfgov.org