sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
65487 190963 2 34 1 Jack Balestreri Way 35 7 1 1     28     6012430.01623 2104809.07988 37.7601046718029 -122.400081553118 (37.7601046718029, -122.400081553118)
169789 190964 2 34 1 Jack Balestreri Way 36 7 1 1     16     6012433.13326 2104783.13919 37.760033618186895 -122.400068950945 (37.7600336181869, -122.400068950945)
172532 190962 2 34 1 Jack Balestreri Way 34 7 1 1     22     6012415.27524 2104795.5991 37.7600668346491 -122.400131588717 (37.7600668346491, -122.400131588717)
98767 87567 1 34 10 Corwin St 3 1 1 1       3x3 Permit Number 50392 6000837.0 2103986.0 37.757191497186604 -122.44011714333901 (37.7571914971866, -122.440117143339)
106208 87566 1 34 10 Corwin St 2 1 1 1       3x3 Permit Number 50392 6000837.0 2103986.0 37.757191497186604 -122.44011714333901 (37.7571914971866, -122.440117143339)
109405 87565 1 34 10 Corwin St 1 1 1 1       3x3 Permit Number 50392 6000837.0 2103986.0 37.757191497186604 -122.44011714333901 (37.7571914971866, -122.440117143339)
20766 19827 3 34 100 STAIRWAY25 11 1 1 2     6 10ST            
3979 19911 3 34 100 STAIRWAY35 7 1 1 2     12 120ST            
18259 19913 3 34 100 STAIRWAY35 9 1 1 2     6 120ST            
22429 19912 3 34 100 STAIRWAY35 8 1 1 2     6 120ST            
9528 19596 3 34 100 STAIRWAY4 19 1 1 2     6 60            
13170 19599 3 34 100 STAIRWAY4 22 1 1 2     12 60            
18324 19600 3 34 100 STAIRWAY4 23 1 1 2     12 60            
18501 19595 3 34 100 STAIRWAY4 18 1 1 2     6 60            
29216 19597 3 34 100 STAIRWAY4 20 1 1 2     6 60            
32799 19601 3 34 100 STAIRWAY4 24 1 1 2     12 60            
19940 19982 3 34 100 STAIRWAY46 2 1 1 2     12 40            
22156 19983 3 34 100 STAIRWAY46 3 1 1 2     12 40            
129690 223684 2 34 1101 San Jose Ave 11 7 1 1     14     6004763.09066 2096356.87709 37.7364664154027 -122.425996119524 (37.7364664154027, -122.425996119524)
85381 8346 3 34 1300 Geary Blvd 12 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
85535 8337 3 34 1300 Geary Blvd 3 11 1 2     18 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
89661 8345 3 34 1300 Geary Blvd 11 11 1 2     18 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
93100 8335 3 34 1300 Geary Blvd 1 11 1 2     18 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
94093 8343 3 34 1300 Geary Blvd 9 11 1 2     18 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
98102 8336 3 34 1300 Geary Blvd 2 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
107311 8352 3 34 1300 Geary Blvd 18 11 1 2     12 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
108127 8347 3 34 1300 Geary Blvd 13 11 1 2     18 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
115465 8338 3 34 1300 Geary Blvd 4 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
126424 8350 3 34 1300 Geary Blvd 16 11 1 2     18 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
37485 223685 2 34 1300 San Jose Ave 76 9 1 1     33     6003566.98749 2095725.2727299999 37.734664501356605 -122.43008650958099 (37.7346645013566, -122.430086509581)
45402 223688 2 34 1300 San Jose Ave 79 9 1 1     33     6003610.6352699995 2095763.96292 37.734773207799705 -122.42993836337901 (37.7347732077997, -122.429938363379)
61223 223687 2 34 1300 San Jose Ave 78 9 1 1     30     6003595.322819999 2095749.76231 37.7347333489588 -122.429990291123 (37.7347333489588, -122.429990291123)
152556 223686 2 34 1300 San Jose Ave 77 9 1 1     33     6003580.53373 2095739.5097599998 37.734704360212 -122.430040690922 (37.734704360212, -122.430040690922)
81695 19437 3 34 1300X Sloat Blvd 6 11 1 2     6 20   5987408.732224501 2095946.646093 37.734343945736896 -122.485966609595 (37.7343439457369, -122.485966609595)
99788 19438 3 34 1302X Sloat Blvd 1 11 1 2     6 20   5987401.6755259 2095951.2124586997 37.73435607254571 -122.485991341651 (37.7343560725457, -122.485991341651)
168385 186505 2 34 1400 Lower Great Hwy 5 19 1 1     2 Width 0ft   5980903.7154 2105004.5327 37.7588331246947 -122.509128554095 (37.7588331246947, -122.509128554095)
155381 187544 2 34 1400 Somerset St 4 17 1 1     16     6011380.55027 2088229.60878 37.714522389959996 -122.40254530072201 (37.71452238996, -122.402545300722)
81172 19449 3 34 1400X Sloat Blvd 6 11 1 2     6 20   5986974.910261401 2095954.0242956001 37.734338913390395 -122.48746699486 (37.7343389133904, -122.48746699486)
116709 19448 3 34 1400X Sloat Blvd 5 11 1 2     6 20   5986974.910261401 2095954.0242956001 37.734338913390395 -122.48746699486 (37.7343389133904, -122.48746699486)
63445 223691 2 34 1407 Guerrero St 1 1 1 1     18 Width 3ft   6005889.20889 2100701.5416599996 37.7484594630387 -122.422411257281 (37.7484594630387, -122.422411257281)
81389 120633 3 34 1500 Geary Blvd 10 11 1 2           6004538.0 2114050.0 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681)
99133 8403 3 34 1500 Geary Blvd 14 11 1 2     18 8   6004544.7148816 2114057.9755695 37.785057082792605 -122.428012143853 (37.7850570827926, -122.428012143853)
104755 120630 3 34 1500 Geary Blvd 7 11 1 2           6004538.0 2114050.0 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681)
107932 120635 3 34 1500 Geary Blvd 12 11 1 2           6004538.0 2114050.0 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681)
111082 120632 3 34 1500 Geary Blvd 9 11 1 2           6004538.0 2114050.0 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681)
124449 120631 3 34 1500 Geary Blvd 8 11 1 2           6004538.0 2114050.0 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681)
144803 8402 3 34 1500 Geary Blvd 13 11 1 2     18 8   6004544.7148816 2114057.9755695 37.785057082792605 -122.428012143853 (37.7850570827926, -122.428012143853)
146159 120634 3 34 1500 Geary Blvd 11 11 1 2           6004538.0 2114050.0 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681)
113817 19450 3 34 1500X Sloat Blvd 1 11 1 2     6 20   5986548.454435701 2095908.9031645001 37.7341901424899 -122.48893805509199 (37.7341901424899, -122.488938055092)
64057 190961 2 34 151 Wisconsin St 7 2 1 1     8     6012606.72224 2106809.23912 37.7656065163403 -122.399610842559 (37.7656065163403, -122.399610842559)
51245 8477 3 34 1900 Geary Blvd 14 11 1 2     24 8   6002632.592264799 2113803.8302726 37.7842509000301 -122.434609297971 (37.7842509000301, -122.434609297971)
126734 19483 3 34 1900X Sloat Blvd 10 11 1 2     12 20   5984946.1404685 2095883.2432036998 37.734026040705 -122.49447578991699 (37.734026040705, -122.494475789917)
78932 19395 3 34 200X Sloat Blvd 4 11 1 2     12 20   5990818.433168401 2096048.8602468998 37.7348227139519 -122.47418574326099 (37.7348227139519, -122.474185743261)
89785 19396 3 34 200X Sloat Blvd 5 11 1 2     12 20   5990818.433168401 2096048.8602468998 37.7348227139519 -122.47418574326099 (37.7348227139519, -122.474185743261)
87703 8538 3 34 2100 Geary Blvd 9 11 1 2     12 6   6001688.6684406 2113658.1430724 37.7837972495813 -122.43786449651002 (37.7837972495813, -122.43786449651)
86660 19484 3 34 2100X Sloat Blvd 1 11 1 2     3 20M   5984311.7495235 2095837.0474516002 37.7338620509701 -122.496665634298 (37.7338620509701, -122.496665634298)
128815 19488 3 34 2100X Sloat Blvd 5 11 1 2     3 20M   5984311.7495235 2095837.0474516002 37.7338620509701 -122.496665634298 (37.7338620509701, -122.496665634298)
23707 250588 2 34 2201 Golden Gate Ave 13 9 1 1     49     5997756.4661 2111264.0896400004 37.7769994185268 -122.45129565939399 (37.7769994185268, -122.451295659394)
24475 250585 2 34 2201 Golden Gate Ave 10 9 1 1     16 Width 8ft   5997613.33684 2111244.7016 37.7769379876264 -122.451789386298 (37.7769379876264, -122.451789386298)
25484 250584 2 34 2201 Golden Gate Ave 9 9 1 1     13     5997564.36038 2111236.37019 37.7769123065995 -122.451958208801 (37.7769123065995, -122.451958208801)
26036 250579 2 34 2201 Golden Gate Ave 4 9 1 1     13 Width 8ft   5997478.12296 2111225.14885 37.7768765558548 -122.452255718936 (37.7768765558548, -122.452255718936)
30950 250591 2 34 2201 Golden Gate Ave 16 9 1 1     25 Width 7ft   5998359.83298 2111349.05645 37.7772672447332 -122.44921455891199 (37.7772672447332, -122.449214558912)
33389 250592 2 34 2201 Golden Gate Ave 17 9 1 1     23 Width 7ft   5998381.460969999 2111351.09812 37.7772740876697 -122.44913988818999 (37.7772740876697, -122.44913988819)
36196 250612 2 34 2201 Golden Gate Ave 37 9 1 1     32 Width 7ft   5998863.03763 2111421.5701099997 37.7774951176523 -122.447479040039 (37.7774951176523, -122.447479040039)
50865 250599 2 34 2201 Golden Gate Ave 24 9 1 1     9 Width 10ft   5998631.4294 2111385.5677400003 37.7773830261474 -122.44827765331499 (37.7773830261474, -122.448277653315)
52572 250594 2 34 2201 Golden Gate Ave 19 9 1 1     11 Width 7ft   5998426.00628 2111357.0235599997 37.7772929050689 -122.448986219244 (37.7772929050689, -122.448986219244)
52831 250589 2 34 2201 Golden Gate Ave 14 9 1 1     12     5997875.419290001 2111281.04875 37.7770527941865 -122.450885388659 (37.7770527941865, -122.450885388659)
55672 250580 2 34 2201 Golden Gate Ave 5 9 1 1     19 Width 8ft   5997493.10232 2111228.13721 37.7768856192175 -122.45220411672399 (37.7768856192175, -122.452204116724)
60845 250576 2 34 2201 Golden Gate Ave 1 9 1 1     30 Width 8ft   5997348.720930001 2111207.04633 37.7768194372103 -122.452702050664 (37.7768194372103, -122.452702050664)
62280 250596 2 34 2201 Golden Gate Ave 21 9 1 1     23 Width 10ft   5998572.26922 2111378.3859099997 37.7773599243436 -122.44848178950899 (37.7773599243436, -122.448481789509)
65004 250587 2 34 2201 Golden Gate Ave 12 9 1 1     8 Width 8ft   5997646.23108 2111248.80698 37.776951143824 -122.451675891826 (37.776951143824, -122.451675891826)
67845 249598 2 34 2201 Golden Gate Ave 38 9 1 1     18 Width 7ft   5998888.01684 2111424.33867 37.7775041468442 -122.447392828322 (37.7775041468442, -122.447392828322)
70548 250586 2 34 2201 Golden Gate Ave 11 9 1 1     16 Width 8ft   5997628.86615 2111246.4251 37.7769436093046 -122.451735790285 (37.7769436093046, -122.451735790285)
71537 250581 2 34 2201 Golden Gate Ave 6 9 1 1     30     5997509.5198800005 2111229.44513 37.776890150891795 -122.45214741807699 (37.7768901508918, -122.452147418077)
131820 250590 2 34 2201 Golden Gate Ave 15 9 1 1     52     5998102.22715 2111312.63197 37.7771524948281 -122.45010307019501 (37.7771524948281, -122.450103070195)
137941 250595 2 34 2201 Golden Gate Ave 20 9 1 1     39     5998510.6665900005 2111373.95167 37.777344226694495 -122.44869457271099 (37.7773442266945, -122.448694572711)
162932 250593 2 34 2201 Golden Gate Ave 18 9 1 1     26 Width 7ft   5998409.0493 2111353.9501099996 37.7772834963756 -122.44904465719499 (37.7772834963756, -122.449044657195)
169298 250577 2 34 2201 Golden Gate Ave 2 9 1 1     21 Width 8ft   5997444.6396 2111219.7245400003 37.776859743909895 -122.452371155927 (37.7768597439099, -122.452371155927)
176192 250598 2 34 2201 Golden Gate Ave 23 9 1 1     26 Width 10ft   5998612.86839 2111383.01591 37.7773749583343 -122.448341677839 (37.7773749583343, -122.448341677839)
177444 250578 2 34 2201 Golden Gate Ave 3 9 1 1     20 Width 8ft   5997460.213380001 2111222.95498 37.7768695060652 -122.452317514945 (37.7768695060652, -122.452317514945)
185277 249599 2 34 2201 Golden Gate Ave 39 9 1 1     26 Width 7ft   5998912.4282 2111428.40333 37.7775167022821 -122.447308674267 (37.7775167022821, -122.447308674267)
109070 21145 3 34 2292X Sunset Blvd 14 1 1 2     3 60   5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
142 251241 2 34 2305 Golden Gate Ave 1 1 1 1           5998495.0 2111363.0 37.777313260379 -122.44874797929701 (37.777313260379, -122.448747979297)
77855 8604 3 34 2400 Geary Blvd 4 11 1 2     36 6   6000257.3380802 2113384.6945808 37.7829649350443 -122.442796706973 (37.7829649350443, -122.442796706973)
171 251242 2 34 2449 Golden Gate Ave 1 5 1 1           5997716.0 2111278.0 37.7770352956542 -122.451436646998 (37.7770352956542, -122.451436646998)
7550 8618 3 34 2600 Geary Blvd 6 11 1 2     12 20   5999321.4797 2113227.3319 37.7824794612004 -122.44602305626199 (37.7824794612004, -122.446023056262)
8434 8615 3 34 2600 Geary Blvd 3 11 1 2     18 20   5999346.5229 2113229.024 37.7824855372935 -122.445936539759 (37.7824855372935, -122.445936539759)
28426 176095 2 34 271 Leland Ave 4 9 1 1     8 Width 3ft   6009495.210659999 2087687.1377700001 37.7129274396128 -122.409023568 (37.7129274396128, -122.409023568)
30005 223689 2 34 278 Upper Ter 1 10 1 1     24 Width 4ft   5999412.71789 2106090.89076 37.7628898173431 -122.445194172985 (37.7628898173431, -122.445194172985)
78151 8655 3 34 2800 Geary Blvd 7 11 1 2     18 M6   5998424.6782121 2113209.2212936003 37.782378482790605 -122.449124279941 (37.7823784827906, -122.449124279941)
109002 8656 3 34 2800 Geary Blvd 8 11 1 2     24 M6   5998424.6782121 2113209.2212936003 37.782378482790605 -122.449124279941 (37.7823784827906, -122.449124279941)
121372 8654 3 34 2800 Geary Blvd 6 11 1 2     18 M6   5998424.6782121 2113209.2212936003 37.782378482790605 -122.449124279941 (37.7823784827906, -122.449124279941)
363 119608 6 34 299x Avalon Ave 4 7 1 1                    
96041 19397 3 34 300X Sloat Blvd 1 11 1 2     6 20   5990549.2944821995 2096013.3169503002 37.7347095261344 -122.475113645462 (37.7347095261344, -122.475113645462)
108713 19398 3 34 300X Sloat Blvd 2 11 1 2     6 20   5990549.2944821995 2096013.3169503002 37.7347095261344 -122.475113645462 (37.7347095261344, -122.475113645462)
118725 101468 6 34 301 Hazelwood Ave 3 7 1 1           5996219.7 2095283.8 37.733033461480495 -122.45545652663701 (37.7330334614805, -122.455456526637)
124304 101467 6 34 301 Hazelwood Ave 2 7 1 1           5996219.7 2095283.8 37.733033461480495 -122.45545652663701 (37.7330334614805, -122.455456526637)
161739 223690 2 34 3287 21st St 1 1 1 1     6 Width 3ft   6006386.04454 2103750.12413 37.756858184863404 -122.420909618783 (37.7568581848634, -122.420909618783)
28408 19403 3 34 400X Sloat Blvd 3 11 1 2     6 20   5990261.3597061 2096050.1007313998 37.7347938328013 -122.47611180943998 (37.7347938328013, -122.47611180944)
127853 19402 3 34 400X Sloat Blvd 2 11 1 2     6 20   5990261.3597061 2096050.1007313998 37.7347938328013 -122.47611180943998 (37.7347938328013, -122.47611180944)
80866 30068 3 34 410X Brotherhood Way 2 11 1 2     25 M   5993748.152574 2087576.478532 37.7117288925291 -122.463442127126 (37.7117288925291, -122.463442127126)
Powered by Datasette · Query took 2.99ms · Data source: data.sfgov.org