sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
86 119601 6 34 4357x Mission St 3 7 1 1         Permit Number 774415          
363 119608 6 34 299x Avalon Ave 4 7 1 1                    
595 119606 6 1 299x Avalon Ave 2 7 1 1                    
870 117001 3 54 1X Bernal Heights Blvd 1 7 1 2                    
1177 251471 3 137 2423 Market St 1 7 1 2                    
1493 103663 2 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
2196 119600 6 34 4357x Mission St 2 7 1 1         Permit Number 774415          
3723 253167 3 12 1X Brotherhood Way 1 7 1 2                    
5598 103666 2 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7681 103657 6 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7764 103662 2 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7809 119599 6 34 4357x Mission St 1 7 1 1         Permit Number 774415          
7810 119607 6 3 299x Avalon Ave 3 7 1 1                    
7834 119605 6 47 299x Avalon Ave 1 7 1 1                    
8128 87100 1 3 700 Connecticut St 1 7 1 3       3x3 Permit Number 50056          
8197 103668 6 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8408 103664 2 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
10665 103665 2 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11212 103658 6 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11415 103667 2 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12113 103660 6 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12440 100166 7 218 2340 Twin Peaks Blvd   7 1 1         Permit Number 769026          
12885 103661 6 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
15949 103659 6 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
16097 104813 6 60 1601X Portola Dr 5 7 1 1                    
16457 93053 1 105     7 1 1   04/28/2010 12:00:00 AM 36   Permit Number 53387          
19583 119914 3 3 400X Brotherhood Way 1 7 1 2       100x100            
86068 121227 3 116 4299x 17th St 3 7 1 2                    
162205 118464 2 3 501 Point Lobos Ave 1 7 1 1     22     5981239.04477 2112631.92257 37.779795477814105 -122.508535077879 (37.7797954778141, -122.508535077879)
92048 111996 6 17 501 Point Lobos Ave   7 1 1   07/08/2015 12:00:00 AM 3 3x3 Permit Number 775626 5981249.6 2112592.5 37.779687857228296 -122.508495636007 (37.7796878572283, -122.508495636007)
126841 106972 6 17 464 46TH AVE 3 7 1 1   08/07/2014 12:00:00 AM     Permit Number 773827 5981646.2 2112608.0 37.7797537818913 -122.507124798545 (37.7797537818913, -122.507124798545)
114664 102604 6 17 401 45th Ave 1 7 1 1   02/06/2013 12:00:00 AM     Permit Number 769720 5981859.7 2112893.4 37.7805499779863 -122.50640739196301 (37.7805499779863, -122.506407391963)
82109 105208 6 1 2694 47TH AVE   7 1 1           5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
102950 105540 6 1 2694 47TH AVE 1 7 1 1     12     5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
77277 118638 2 163 489 45th Ave 1 7 1 1     2 Width 9ft   5981883.80409 2112496.71277 37.779462211155 -122.506294581666 (37.779462211155, -122.506294581666)
90158 108211 6 19 524 45th Ave 2 7 1 1         Permit Number 773704 5981973.192319999 2112153.30127 37.778524566445206 -122.505959887315 (37.7785245664452, -122.505959887315)
143885 108210 6 19 524 45th Ave 1 7 1 1         Permit Number 773704 5981973.192319999 2112153.30127 37.778524566445206 -122.505959887315 (37.7785245664452, -122.505959887315)
92434 93037 1 17 1220 45th Ave 2 7 1 1   01/14/2010 12:00:00 AM     Permit Number 53146 5982155.6 2106783.3 37.7637908375908 -122.504930842514 (37.7637908375908, -122.504930842514)
98766 104736 6 48 1499X 44th Ave 1 7 1 1         Permit Number 770763 5982473.05016 2105245.16297 37.7595862228156 -122.50371897878901 (37.7595862228156, -122.503718978789)
62231 176114 2 47 10 Zoo Rd 1 7 1 1     24 Width 10ft   5982696.49512 2094384.4536 37.729778850703894 -122.502142508582 (37.7297788507039, -122.502142508582)
120572 113234 6 21 2023 43RD AVE 1 7 1 1     12 3x3   5982877.0 2101339.0 37.748884737458795 -122.50203289923901 (37.7488847374588, -122.502032899239)
79360 112811 6 17 2023 43rd Ave 1 7 1 1           5982877.4 2101339.2 37.748885310102104 -122.502031530859 (37.7488853101021, -122.502031530859)
89881 116068 3 154 4150X CLEMENT ST 2 7 1 2     3 3x3   5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
96458 116067 3 71 4150X CLEMENT ST 5 7 1 2   04/15/2016 12:00:00 AM 3 3x3 Permit Number 777818 5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
119142 116069 3 3 4150X CLEMENT ST 3 7 1 2       3x3   5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
119284 116071 3 84 4150X CLEMENT ST 1 7 1 2     8 3x3   5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
143181 116070 3 3 4150X CLEMENT ST 4 7 1 2       3x3   5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527)
142384 106198 6 539 2101 42ND AVE 1 7 1 1     18     5983206.1 2100796.8 37.74741533456479 -122.500854798087 (37.7474153345648, -122.500854798087)
3534 253482 6 19 2179 41st Ave 1 7 1 1       3x5   5983532.0 2100331.0 37.74615550514321 -122.49969345420799 (37.7461555051432, -122.499693454208)
1686 251474 2 110 151 32nd Ave 2 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
1694 251475 2 110 151 32nd Ave 3 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
1712 251473 2 110 151 32nd Ave 1 7 1 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
82542 108215 6 3 865 EL CAMINO DEL MAR 1 7 1 1           5985761.0 2114995.0 37.7865492821054 -122.49306599544501 (37.7865492821054, -122.493065995445)
86608 85093 6 17 100 32nd Ave 2 7 1 1   12/18/2009 12:00:00 AM     Permit Number 53112 5985781.7 2114962.8 37.786462080845396 -122.49299200677 (37.7864620808454, -122.49299200677)
144783 92909 6 17 100 32nd Ave 1 7 1 1   12/18/2009 12:00:00 AM 11   Permit Number 53112 5985781.7 2114962.8 37.786462080845396 -122.49299200677 (37.7864620808454, -122.49299200677)
87085 113937 6 3 800 EL CAMINO DEL MAR 1 7 1 1     35     5985966.0 2115003.0 37.7865832348262 -122.49235734524099 (37.7865832348262, -122.492357345241)
97466 102302 6 17 740X 31st Ave 1 7 1 1   01/14/2013 12:00:00 AM     Permit Number 769784 5986476.3 2110809.8 37.7750997269751 -122.490283282468 (37.7750997269751, -122.490283282468)
99818 105907 6 105 1837 30TH AVE 1 7 1 1     6     5986904.0 2102674.0 37.752786039312795 -122.488205804709 (37.7527860393128, -122.488205804709)
46258 113530 2 209 2598x 30TH AVE 3 7 1 1       3x3   5987135.0 2097625.0 37.7389363086492 -122.487036198648 (37.7389363086492, -122.487036198648)
87693 113529 2 209 2598x 30TH AVE 2 7 1 1       3x3   5987135.0 2097625.0 37.7389363086492 -122.487036198648 (37.7389363086492, -122.487036198648)
171679 113528 2 209 2598x 30TH AVE 1 7 1 1     0 3x3   5987135.0 2097625.0 37.7389363086492 -122.487036198648 (37.7389363086492, -122.487036198648)
94387 87294 1 104 2087 28th Ave   7 1 1   03/20/2008 12:00:00 AM     Permit Number 50307 5987541.6 2101099.3 37.7484995140672 -122.48588532379298 (37.7484995140672, -122.485885323793)
89354 111589 3 47 730X Lake Merced Blvd 5 7 1 10 4       Permit Number 774260 5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397)
92075 111588 3 47 730X Lake Merced Blvd 4 7 1 10 4   48     5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397)
94574 114097 6 306 221x VIDAL DR 1 7 1 1     14     5987664.0 2090556.0 37.7195574904968 -122.484688777519 (37.7195574904968, -122.484688777519)
88441 114094 6 55 239x VIDAL DR 1 7 1 1     24     5987668.0 2090475.0 37.7193353179991 -122.484669012602 (37.7193353179991, -122.484669012602)
113595 114068 6 62 8 HIGUERA AVE 1 7 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
86962 114103 6 62 5 ACEVEDO AVE 2 7 1 1     15     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
103750 114102 6 62 7 ACEVEDO AVE 1 7 1 1     18     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
2100 178279 2 3 900 Brotherhood Way 6 7 1 2     4 Width 0ft   5987917.15522 2088760.91322 37.714643374877895 -122.48368218070499 (37.7146433748779, -122.483682180705)
104403 114100 6 146 21x ACEVEDO AVE 1 7 1 1     10     5988027.0 2090598.0 37.7196939458216 -122.48343711113998 (37.7196939458216, -122.48343711114)
118949 114101 6 146 21x ACEVEDO AVE 2 7 1 1     7     5988027.0 2090598.0 37.7196939458216 -122.48343711113998 (37.7196939458216, -122.48343711114)
89406 114379 6 5 443X ARBALLO DR 1 7 1 1     36     5988110.0 2090275.0 37.718811899837206 -122.483126550771 (37.7188118998372, -122.483126550771)
144120 114104 6 85 400x ARBALLO DR 1 7 1 1     12 3x3   5988116.0 2090625.0 37.7197732605649 -122.48313145165001 (37.7197732605649, -122.48313145165)
97649 114386 2 3 429x ARBALLO DR 1 7 1 1     56     5988163.0 2090444.0 37.7192790152529 -122.482955732568 (37.7192790152529, -122.482955732568)
125203 114389 6 15 345x ARBALLO DR 1 7 1 1     8     5988176.0 2090635.0 37.7198042094326 -122.48292478788 (37.7198042094326, -122.48292478788)
137522 178302 2 3 999 Brotherhood Way 1 7 1 1     25 Width 0ft   5988216.16039 2088696.50814 37.7144839349573 -122.482643992533 (37.7144839349573, -122.482643992533)
18793 114373 7 62 805 GONZALEZ DR 1 7 1 1     18     5988302.0 2089566.0 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247)
24107 120282 2 237 129 24th Ave 12 7 1 1     10     5988304.19862 2115114.50046 37.787025803891204 -122.484276029631 (37.7870258038912, -122.484276029631)
136684 120271 2 116 129 24th Ave 1 7 1 1     16     5988306.39603 2115180.23903 37.7872064312039 -122.48427325023998 (37.7872064312039, -122.48427325024)
155040 120274 2 116 129 24th Ave 4 7 1 1     9     5988307.12698 2115148.43075 37.7871191372985 -122.484268387654 (37.7871191372985, -122.484268387654)
72927 120273 2 116 129 24th Ave 3 7 1 1     16     5988307.3728 2115160.02273 37.787150979882796 -122.484268387653 (37.7871509798828, -122.484268387653)
162555 120268 2 116 107 24th Ave 1 7 1 1     15     5988313.3781 2115206.48473 37.7872789009445 -122.48425101963899 (37.7872789009445, -122.484251019639)
40766 120272 2 116 129 24th Ave 2 7 1 1     13     5988314.622169999 2115170.4665900003 37.7871800778407 -122.48424407294901 (37.7871800778407, -122.484244072949)
62319 120275 2 116 129 24th Ave 5 7 1 1     11     5988318.18285 2115148.99603 37.78712133312521 -122.48423017871299 (37.7871213331252, -122.484230178713)
134244 120280 2 116 129 24th Ave 10 7 1 1     15     5988322.2380099995 2115131.91384 37.7870746664109 -122.48421489568199 (37.7870746664109, -122.484214895682)
57707 120269 2 116 107 24th Ave 2 7 1 1     15     5988324.11159 2115191.8605299997 37.78723937201521 -122.48421281158701 (37.7872393720152, -122.484212811587)
40443 120276 2 116 129 24th Ave 6 7 1 1     13     5988325.261 2115160.84311 37.787154273948204 -122.484206559328 (37.7871542739482, -122.484206559328)
168599 176157 2 47 999 Brotherhood Way 2 7 1 1     25 Width 0ft   5988327.5004199995 2088688.82584 37.714469318273004 -122.482258598878 (37.714469318273, -122.482258598878)
50596 120279 2 116 129 24th Ave 9 7 1 1     14     5988331.03377 2115139.5257599996 37.787096078694205 -122.484185023117 (37.7870960786942, -122.484185023117)
148033 120277 2 116 129 24th Ave 7 7 1 1     3     5988335.64695 2115158.2234400003 37.787147685785705 -122.484170434457 (37.7871476857857, -122.484170434457)
40236 120278 2 116 129 24th Ave 8 7 1 1     14     5988337.84774 2115148.37916 37.7871207843354 -122.48416209808799 (37.7871207843354, -122.484162098088)
73560 120270 2 116 107 24th Ave 3 7 1 1     11     5988338.64874 2115186.1535400003 37.7872245486486 -122.48416209809099 (37.7872245486486, -122.484162098091)
70268 120281 2 116 129 24th Ave 11 7 1 1     15     5988339.230269999 2115128.3543599998 37.7870658824376 -122.484155845816 (37.7870658824376, -122.484155845816)
82402 114388 6 16 361x ARBALLO DR 1 7 1 1     7     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
99779 114394 6 253 134x TAPIA DR 1 7 1 1     28     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
138436 114384 6 82 418X SERRANO DR 2 7 1 1     6     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
136271 178303 2 3 999 Brotherhood Way 3 7 1 1     19 Width 0ft   5988476.29436 2088682.632 37.7144609653694 -122.481743860201 (37.7144609653694, -122.481743860201)
81776 114391 6 82 23x PINTO AVE 2 7 1 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
93217 114390 6 82 23x PINTO AVE 1 7 1 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
144388 114393 6 253 118x TAPIA DR 1 7 1 1     36     5988638.0 2090878.0 37.72049829773871 -122.48134562114099 (37.7204982977387, -122.481345621141)
Powered by Datasette · Query took 18.599ms · Data source: data.sfgov.org