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          
142 251241 2 34 2305 Golden Gate Ave 1 1 1 1           5998495.0 2111363.0 37.777313260379 -122.44874797929701 (37.777313260379, -122.448747979297)
171 251242 2 34 2449 Golden Gate Ave 1 5 1 1           5997716.0 2111278.0 37.7770352956542 -122.451436646998 (37.7770352956542, -122.451436646998)
363 119608 6 34 299x Avalon Ave 4 7 1 1                    
1387 250572 2 34 600 Parker Ave 9 9 1 1   05/15/2017 12:00:00 AM 3   Permit Number 779711 5997267.39343 2111112.94332 37.7765563945078 -122.45297659119 (37.7765563945078, -122.45297659119)
2196 119600 6 34 4357x Mission St 2 7 1 1         Permit Number 774415          
7809 119599 6 34 4357x Mission St 1 7 1 1         Permit Number 774415          
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)
23781 250570 2 34 600 Parker Ave 7 9 1 1     24     5997272.199569999 2111059.97973 37.7764112457195 -122.452956141515 (37.7764112457195, -122.452956141515)
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)
26054 119449 2 34 895 32nd Ave 3 9 1 1     24     5986012.77354 2109822.77383 37.77236255084971 -122.49181402136001 (37.7723625508497, -122.49181402136)
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)
46673 250567 2 34 600 Parker Ave 4 9 1 1     21     5997282.7959199995 2110980.7211 37.776194229407295 -122.452913763658 (37.7761942294073, -122.452913763658)
50298 250575 2 34 600 Parker Ave 12 9 1 1     43     5997256.45682 2111186.28266 37.776757138456794 -122.453019719107 (37.7767571384568, -122.453019719107)
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)
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)
64057 190961 2 34 151 Wisconsin St 7 2 1 1     8     6012606.72224 2106809.23912 37.7656065163403 -122.399610842559 (37.7656065163403, -122.399610842559)
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)
69246 250569 2 34 600 Parker Ave 6 9 1 1     31     5997276.1967400005 2111033.33857 37.7763383251004 -122.452940390794 (37.7763383251004, -122.452940390794)
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)
72328 250573 2 34 600 Parker Ave 10 9 1 1     9     5997263.272609999 2111141.17003 37.7766336615401 -122.45299288421002 (37.7766336615401, -122.45299288421)
73961 201525 2 34 740 Earl St 2 7 1 1     13     6020363.02265 2093708.60357 37.730064074283106 -122.371876721056 (37.7300640742831, -122.371876721056)
81389 120633 3 34 1500 Geary Blvd 10 11 1 2           6004538.0 2114050.0 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681)
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)
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)
124449 120631 3 34 1500 Geary Blvd 8 11 1 2           6004538.0 2114050.0 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681)
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)
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)
138493 102479 6 34 760 Victoria St 5 7 1 1           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167)
146159 120634 3 34 1500 Geary Blvd 11 11 1 2           6004538.0 2114050.0 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681)
146510 250568 2 34 600 Parker Ave 5 9 1 1     24     5997280.420030001 2111005.26169 37.7762614753232 -122.452923754242 (37.7762614753232, -122.452923754242)
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)
155381 187544 2 34 1400 Somerset St 4 17 1 1     16     6011380.55027 2088229.60878 37.714522389959996 -122.40254530072201 (37.71452238996, -122.402545300722)
161181 250574 2 34 600 Parker Ave 11 9 1 1     33     5997258.88405 2111163.19525 37.77669388555061 -122.453009655693 (37.7766938855506, -122.453009655693)
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)
171210 119448 2 34 895 32nd Ave 2 9 1 1     11     5986011.64571 2109832.7311 37.7723898247803 -122.49181865574499 (37.7723898247803, -122.491818655745)
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)
174357 47273 1 34 600 Italy Ave 1 1 1 1 1 05/31/2003 12:00:00 AM 8   Permit Number 45219 6002244.66037 2088892.0690000001 37.715827083242296 -122.43416990473999 (37.7158270832423, -122.43416990474)
176048 250571 2 34 600 Parker Ave 8 9 1 1     11     5997270.54496 2111084.7365 37.7764791265377 -122.45296365267299 (37.7764791265377, -122.452963652673)
183600 250188 2 34 600 Parker Ave 1 9 1 1     30     5997295.794369999 2110912.47939 37.7760076003172 -122.45286387197201 (37.7760076003172, -122.452863871972)
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            
81205 2285 3 34 750X Brotherhood Way 19 11 1 2     45 14M   5991074.042616099 2088106.2478104 37.71302907778821 -122.47272309171998 (37.7130290777882, -122.47272309172)
87151 2280 3 34 750X Brotherhood Way 14 11 1 2     40 14M   5991074.042616099 2088106.2478104 37.71302907778821 -122.47272309171998 (37.7130290777882, -122.47272309172)
99987 2279 3 34 750X Brotherhood Way 13 11 1 2     40 14M   5991074.042616099 2088106.2478104 37.71302907778821 -122.47272309171998 (37.7130290777882, -122.47272309172)
144553 2278 3 34 750X Brotherhood Way 12 11 1 2     40 14M   5991074.042616099 2088106.2478104 37.71302907778821 -122.47272309171998 (37.7130290777882, -122.47272309172)
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)
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)
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)
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)
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)
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)
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)
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)
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)
108861 19405 3 34 500X Sloat Blvd 2 11 1 2     12 20   5989983.811155001 2096024.6780472 37.7347079305354 -122.47706952310101 (37.7347079305354, -122.477069523101)
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)
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)
119634 19404 3 34 500X Sloat Blvd 1 11 1 2     12 20   5989983.811155001 2096024.6780472 37.7347079305354 -122.47706952310101 (37.7347079305354, -122.477069523101)
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)
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)
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)
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)
127868 110833 2 34 533 PARNASSUS AVE 6 1 1 1   11/22/2016 12:00:00 AM 3 3x3   5995513.0 2106277.0 37.7631774598891 -122.458695326495 (37.7631774598891, -122.458695326495)
152682 64515 2 34 720 Baker St 1 1 1 1 1 07/21/1988 12:00:00 AM 6 3x3 Permit Number 25396 6000553.55593738 2111421.0223091 37.7775900754915 -122.44163095230499 (37.7775900754915, -122.441630952305)
19940 19982 3 34 100 STAIRWAY46 2 1 1 2     12 40            
22156 19983 3 34 100 STAIRWAY46 3 1 1 2     12 40            
10201 173901 2 34 4201x Lincoln Blvd 1 5 1 1       5x5            
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)
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)
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)
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)
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            
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)
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)
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)
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)
Powered by Datasette · Query took 3.321ms · Data source: data.sfgov.org