sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
103907 106639 5 64 1321X CLAYTON ST 1 13 2 1           5998910.0 2105100.0 37.7601403710114 -122.44686158716699 (37.7601403710114, -122.446861587167)
99533 100242 5 17 76 Linda St   10 2 1           6005815.0 2105046.0 37.76038415245 -122.422976606568 (37.76038415245, -122.422976606568)
123904 106641 5 64 1323X CLAYTON ST 1 13 2 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
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)
122339 104861 1 54 3458A 18th St   5 2 1           6006508.0 2105569.9 37.7618617394874 -122.42061702780899 (37.7618617394874, -122.420617027809)
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)
92708 85104 1 19 1403 11th Ave 1 5 2 1     9 2x2 Tree 1 5992673.9 2105865.8 37.7618848250494 -122.46848481907499 (37.7618848250494, -122.468484819075)
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)
3598 225282 2 108 101 Rivoli St 2 1 2 1     6 Width 3ft   5998123.1152 2105954.07554 37.762440462975 -122.44964458054 (37.762440462975, -122.44964458054)
81163 104152 1 54 525X Church St 2 5 2 4 4     2x68   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
81722 104155 1 54 525X Church St 3 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
92935 104156 1 54 525X Church St 4 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
95495 104151 1 54 525X Church St 1 5 2 4 4     2x58   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
95556 104158 1 54 525X Church St 6 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
96077 104157 1 54 525X Church St 5 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
113603 104154 1 54 525X Church St 2 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
141475 104153 1 54 525X Church St 1 1 2 4 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
90472 120871 2 98 1387 08th Ave 1 10 2 1           5993606.0 2106068.0 37.762493810072606 -122.465275766733 (37.7624938100726, -122.465275766733)
143940 106932 2 98 358 SHOTWELL ST 1 1 2 1       8x10   6007793.2 2105846.4 37.7626932925098 -122.416191600332 (37.7626932925098, -122.416191600332)
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)
24006 191506 2 284 725 18th St 1 9 2 1     12 Width 2ft   6015277.21856 2105757.38147 37.7628668405556 -122.390300611982 (37.7628668405556, -122.390300611982)
34525 191507 2 284 725 18th St 3 9 2 1     6 Width 2ft   6015301.62259 2105759.06622 37.7628728201497 -122.39021632394699 (37.7628728201497, -122.390216323947)
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)
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)
496 245474 2 26 275 Grattan St 1 1 2 1     19 Width 4ft   5997377.53226 2106405.56262 37.7636374489232 -122.452255843041 (37.7636374489232, -122.452255843041)
452 221749 2 26 275 Grattan St 3 1 2 1     24 Width 4ft   5997432.91763 2106413.5715 37.763662611962 -122.452064861225 (37.763662611962, -122.452064861225)
458 221750 2 26 275 Grattan St 2 1 2 1     11 Width 4ft   5997409.41415 2106414.31665 37.7636633116224 -122.45214620578699 (37.7636633116224, -122.452146205787)
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)
144925 93163 1 98 201 Upper Ter 1 5 2 1   12/22/2009 12:00:00 AM   1x15   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
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)
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)
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)
102839 102414 2 60 1301 Page St 2 1 2 1           6000345.0 2109213.0 37.77151552050871 -122.44219387377399 (37.7715155205087, -122.442193873774)
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)
91008 120156 6 43 758 10th Ave 1 1 2 1     10     5992930.0 2110298.0 37.77406925887279 -122.467921468059 (37.7740692588728, -122.467921468059)
79432 106576 5 64 507 STEINER ST 1 7 2 1           6003113.3 2110111.6 37.7741402349502 -122.432682383122 (37.7741402349502, -122.432682383122)
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)
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)
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)
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)
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)
105108 104859 1 54 650 Fillmore St   1 2 1           6003597.7 2110555.4 37.775386259915 -122.43103844044701 (37.775386259915, -122.431038440447)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
102661 117259 1 54 670 Eddy St 1 5 2 1       3x3   6007197.5 2113350.2 37.7832634280904 -122.418784110751 (37.7832634280904, -122.418784110751)
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)
110489 109322 2 64 191 24TH AVE 1 1 2 1       3x3   5988309.1 2114757.6 37.7860461422813 -122.484232887865 (37.7860461422813, -122.484232887865)
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)
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)
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)
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)
83840 107144 2 54 360 Spear St 1 1 2 1           6015708.0 2115219.0 37.7888702311939 -122.38947147438 (37.7888702311939, -122.38947147438)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Powered by Datasette · Query took 4.747ms · Data source: data.sfgov.org