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                    
2196 119600 6 34 4357x Mission St 2 7 1 1         Permit Number 774415          
3979 19911 3 34 100 STAIRWAY35 7 1 1 2     12 120ST            
7809 119599 6 34 4357x Mission St 1 7 1 1         Permit Number 774415          
9528 19596 3 34 100 STAIRWAY4 19 1 1 2     6 60            
10201 173901 2 34 4201x Lincoln Blvd 1 5 1 1       5x5            
13170 19599 3 34 100 STAIRWAY4 22 1 1 2     12 60            
18259 19913 3 34 100 STAIRWAY35 9 1 1 2     6 120ST            
18324 19600 3 34 100 STAIRWAY4 23 1 1 2     12 60            
18501 19595 3 34 100 STAIRWAY4 18 1 1 2     6 60            
19940 19982 3 34 100 STAIRWAY46 2 1 1 2     12 40            
20766 19827 3 34 100 STAIRWAY25 11 1 1 2     6 10ST            
22156 19983 3 34 100 STAIRWAY46 3 1 1 2     12 40            
22429 19912 3 34 100 STAIRWAY35 8 1 1 2     6 120ST            
29216 19597 3 34 100 STAIRWAY4 20 1 1 2     6 60            
32799 19601 3 34 100 STAIRWAY4 24 1 1 2     12 60            
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)
167519 118972 2 34 4400 Cabrillo St 3 9 1 1     8 Width 3ft   5981914.76561 2110344.52005 37.7735547445483 -122.50602785926 (37.7735547445483, -122.50602785926)
34381 118537 2 34 7915 Geary Blvd 1 9 1 1     16 Width 8ft   5982434.92947 2112334.2727 37.7790486288769 -122.504376000287 (37.7790486288769, -122.504376000287)
70868 118536 2 34 7915 Geary Blvd 4 9 1 1     15 Width 8ft   5982451.538919999 2112333.71263 37.7790480679712 -122.504318500947 (37.7790480679712, -122.504318500947)
26043 117889 2 34 526 43rd Ave 2 1 1 1     21 Width 4ft   5982568.684830001 2112177.2614700003 37.7786253881038 -122.50390166196699 (37.7786253881038, -122.503901661967)
46312 117931 2 34 593 42nd Ave 2 9 1 1     7 Width 4ft   5982837.98596 2111790.04502 37.777578036655996 -122.502941388113 (37.777578036656, -122.502941388113)
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)
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)
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)
171210 119448 2 34 895 32nd Ave 2 9 1 1     11     5986011.64571 2109832.7311 37.7723898247803 -122.49181865574499 (37.7723898247803, -122.491818655745)
26054 119449 2 34 895 32nd Ave 3 9 1 1     24     5986012.77354 2109822.77383 37.77236255084971 -122.49181402136001 (37.7723625508497, -122.49181402136)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
47001 122962 2 34 98 09th Ave 7 9 1 1     7 Width 5ft   5993057.14542 2114935.59748 37.786810183441204 -122.46781902207898 (37.7868101834412, -122.467819022079)
138493 102479 6 34 760 Victoria St 5 7 1 1           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167)
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)
87021 30067 3 34 410X Brotherhood Way 1 11 1 2     25 M   5993748.152574 2087576.478532 37.7117288925291 -122.463442127126 (37.7117288925291, -122.463442127126)
126778 30069 3 34 410X Brotherhood Way 3 11 1 2     25 M   5993748.152574 2087576.478532 37.7117288925291 -122.463442127126 (37.7117288925291, -122.463442127126)
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)
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)
50298 250575 2 34 600 Parker Ave 12 9 1 1     43     5997256.45682 2111186.28266 37.776757138456794 -122.453019719107 (37.7767571384568, -122.453019719107)
161181 250574 2 34 600 Parker Ave 11 9 1 1     33     5997258.88405 2111163.19525 37.77669388555061 -122.453009655693 (37.7766938855506, -122.453009655693)
72328 250573 2 34 600 Parker Ave 10 9 1 1     9     5997263.272609999 2111141.17003 37.7766336615401 -122.45299288421002 (37.7766336615401, -122.45299288421)
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)
176048 250571 2 34 600 Parker Ave 8 9 1 1     11     5997270.54496 2111084.7365 37.7764791265377 -122.45296365267299 (37.7764791265377, -122.452963652673)
23781 250570 2 34 600 Parker Ave 7 9 1 1     24     5997272.199569999 2111059.97973 37.7764112457195 -122.452956141515 (37.7764112457195, -122.452956141515)
69246 250569 2 34 600 Parker Ave 6 9 1 1     31     5997276.1967400005 2111033.33857 37.7763383251004 -122.452940390794 (37.7763383251004, -122.452940390794)
146510 250568 2 34 600 Parker Ave 5 9 1 1     24     5997280.420030001 2111005.26169 37.7762614753232 -122.452923754242 (37.7762614753232, -122.452923754242)
46673 250567 2 34 600 Parker Ave 4 9 1 1     21     5997282.7959199995 2110980.7211 37.776194229407295 -122.452913763658 (37.7761942294073, -122.452913763658)
153836 250190 2 34 600 Parker Ave 3 9 1 1     38 Width 10ft   5997282.93833 2110956.0047400002 37.7761263728801 -122.45291148657 (37.7761263728801, -122.45291148657)
34734 250189 2 34 600 Parker Ave 2 9 1 1     24 Width 10ft   5997288.42031 2110933.5142099997 37.7760649338881 -122.45289089928998 (37.7760649338881, -122.45289089929)
183600 250188 2 34 600 Parker Ave 1 9 1 1     30     5997295.794369999 2110912.47939 37.7760076003172 -122.45286387197201 (37.7760076003172, -122.452863871972)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
171 251242 2 34 2449 Golden Gate Ave 1 5 1 1           5997716.0 2111278.0 37.7770352956542 -122.451436646998 (37.7770352956542, -122.451436646998)
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)
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)
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)
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)
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)
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)
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)
142 251241 2 34 2305 Golden Gate Ave 1 1 1 1           5998495.0 2111363.0 37.777313260379 -122.44874797929701 (37.777313260379, -122.448747979297)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Powered by Datasette · Query took 2.782ms · Data source: data.sfgov.org