sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
52138 177088 3 55 300x Winding Way 5 11 1 2     10 Width 0ft   6001504.621119999 2086478.58914 37.7091581713864 -122.436555171203 (37.7091581713864, -122.436555171203)
11054 1139 3 55 2627 Alemany Blvd 1 1 1 2     12 1X1   5998352.02606 2088442.52333 37.7143710331717 -122.447592253902 (37.7143710331717, -122.447592253902)
11402 1130 3 55 2554 Alemany Blvd 1 1 1 2     20 3X3   5998598.100380001 2088668.31183 37.7150050570134 -122.446757963627 (37.7150050570134, -122.446757963627)
20442 19325 3 55 212 Shields St 1 1 1 2     15 3X4   5993418.3820400005 2089852.67557 37.717959779598 -122.464747082736 (37.717959779598, -122.464747082736)
11106 25304 3 55 292 Ocean Ave 1 1 1 2     12 5x9   5999755.51283 2091622.1717 37.7231817335313 -122.44296946786501 (37.7231817335313, -122.442969467865)
13198 25303 3 55 286 Ocean Ave 3 1 1 2     18 5x9   5999775.2112 2091625.73202 37.7231926324273 -122.4429016302 (37.7231926324273, -122.4429016302)
12673 25310 3 55 197 Ocean Ave 1 1 1 2     12 3X3   6000354.040159999 2091646.91959 37.7232837922084 -122.440902255631 (37.7232837922084, -122.440902255631)
13006 25299 3 55 190 Ocean Ave 1 1 1 2     12 3x3   6000418.66631 2091706.69164 37.7234515931109 -122.44068314123001 (37.7234515931109, -122.44068314123)
11537 25293 3 55 144 Ocean Ave 1 1 1 2     12 2X2   6000659.82425 2091738.03378 37.7235513818789 -122.43985175036998 (37.7235513818789, -122.43985175037)
111795 25294 3 55 150 Ocean Ave 1 1 1 2     12 3X3   6000635.349880001 2091747.8935900002 37.7235770614816 -122.439937060329 (37.7235770614816, -122.439937060329)
10803 25289 3 55 136 Ocean Ave 1 1 1 2     6 3X3   6000745.99488 2091748.7856599998 37.72358580881671 -122.439554644937 (37.7235858088167, -122.439554644937)
103677 25292 3 55 136 Ocean Ave 4 1 1 2     12 3X3   6000743.1124599995 2091772.81119 37.7236516133979 -122.439566330441 (37.7236516133979, -122.439566330441)
99391 17145 3 55 1030 Oakdale Ave 4 1 1 2   12/31/1992 12:00:00 AM 6 3X3   6018053.0176703 2093253.3980264 37.7286870123052 -122.37983116682699 (37.7286870123052, -122.379831166827)
146083 17143 3 55 1030 Oakdale Ave 2 1 1 2   01/12/1999 12:00:00 AM 3 3X3   6018053.0176703 2093253.3980264 37.7286870123052 -122.37983116682699 (37.7286870123052, -122.379831166827)
15890 17142 3 55 1030 Oakdale Ave 1 1 1 2   12/31/1992 12:00:00 AM 3 3X3   6017965.0245 2093314.7049599998 37.7288504949441 -122.380139626367 (37.7288504949441, -122.380139626367)
14433 17144 3 55 1030 Oakdale Ave 3 1 1 2   04/30/1997 12:00:00 AM 3 3X3   6017899.57967 2093362.5240900002 37.728978186084 -122.38036919809099 (37.728978186084, -122.380369198091)
141287 1702 3 55 47 Baldwin Ct 1 1 1 2     12 3X3   6017785.2431167 2093593.9655411 37.7296073696477 -122.380780554369 (37.7296073696477, -122.380780554369)
123069 1691 3 55 23 Baldwin Ct 2 1 1 2     12 3X3   6017695.7876646 2093605.1145141998 37.7296330451049 -122.381090589205 (37.7296330451049, -122.381090589205)
18155 1705 3 55 70 Baldwin Ct 1 1 1 2     12 3X3   6017900.557664401 2093604.0676713001 37.729641471652 -122.380382597634 (37.729641471652, -122.380382597634)
16400 1687 3 55 15 Baldwin Ct 1 1 1 2   03/11/2006 12:00:00 AM 3 3X3   6017775.00772 2093610.25153 37.729651522897 -122.38081707126301 (37.729651522897, -122.380817071263)
85072 1696 3 55 34 Baldwin Ct 1 1 1 2     12 3X3   6017739.602575701 2093657.002741 37.72977793847971 -122.380942720777 (37.7297779384797, -122.380942720777)
2249 191500 3 55 1196 La Salle Ave 3 1 1 2     15 Width 3ft   6016876.9140800005 2094649.78681 37.732456273623704 -122.38399426453998 (37.7324562736237, -122.38399426454)
84373 12120 3 55 1325X La Salle Ave 3 1 1 2     12 3x3   6016848.207852599 2094661.9057693002 37.732487962838604 -122.38409435335 (37.7324879628386, -122.38409435335)
105819 12118 3 55 1325X La Salle Ave 1 1 1 2     6 3X3   6016848.207852599 2094661.9057693002 37.732487962838604 -122.38409435335 (37.7324879628386, -122.38409435335)
2255 191499 3 55 1196 La Salle Ave 1 1 1 2     12 Width 3ft   6016833.73477 2094673.4854599999 37.732518958184706 -122.38414519683998 (37.7325189581847, -122.38414519684)
78963 12206 3 55 1365X La Salle Ave 3 1 1 2     12 3X3   6016707.244956 2094751.5031778 37.7327261850679 -122.38458793904199 (37.7327261850679, -122.384587939042)
124800 12209 3 55 1365X La Salle Ave 6 1 1 2     12 3X3   6016707.244956 2094751.5031778 37.7327261850679 -122.38458793904199 (37.7327261850679, -122.384587939042)
129260 12204 3 55 1365X La Salle Ave 1 1 1 2     12 3X3   6016707.244956 2094751.5031778 37.7327261850679 -122.38458793904199 (37.7327261850679, -122.384587939042)
145506 12205 3 55 1365X La Salle Ave 2 1 1 2     12 3X3   6016707.244956 2094751.5031778 37.7327261850679 -122.38458793904199 (37.7327261850679, -122.384587939042)
2246 191498 3 55 1198 La Salle Ave 6 1 1 2     8 Width 4ft   6016692.24365 2094766.72457 37.732767150375295 -122.38464086270099 (37.7327671503753, -122.384640862701)
2259 191494 3 55 1198 La Salle Ave 1 1 1 2     11 Width 4ft   6016613.84098 2094824.1997599998 37.7329206295756 -122.384915925743 (37.7329206295756, -122.384915925743)
14202 12169 3 55 1425X La Salle Ave 1 1 1 2   12/16/1992 12:00:00 AM 3 3X3   6016491.2755 2094964.9733 37.7333003856228 -122.38534947643299 (37.7333003856228, -122.385349476433)
16816 12175 3 55 1413X La Salle Ave 1 1 1 2     6 3X3   6016419.0642 2095079.8835 37.733611910792796 -122.385607138859 (37.7336119107928, -122.385607138859)
16102 12179 3 55 1405X La Salle Ave 1 1 1 2     12 3X3   6016402.1103 2095116.3031 37.733710973632995 -122.385668291381 (37.733710973633, -122.385668291381)
16755 12181 3 55 1401X La Salle Ave 1 1 1 2     6 3X3   6016385.1563 2095160.2578 37.733830726311396 -122.385729969415 (37.7338307263114, -122.385729969415)
109337 12172 3 55 1419X La Salle Ave 1 1 1 2     9 3X3   6016344.6880818 2095251.8114423 37.7340798748876 -122.38587626093799 (37.7340798748876, -122.385876260938)
112287 12177 3 55 1409X La Salle Ave 2 1 1 2     12 3X3   6016344.6880818 2095251.8114423 37.7340798748876 -122.38587626093799 (37.7340798748876, -122.385876260938)
117602 12166 3 55 1439X La Salle Ave 3 1 1 2     18 3X3   6016344.6880818 2095251.8114423 37.7340798748876 -122.38587626093799 (37.7340798748876, -122.385876260938)
121121 12180 3 55 1403X La Salle Ave 1 1 1 2     12 3X3   6016344.6880818 2095251.8114423 37.7340798748876 -122.38587626093799 (37.7340798748876, -122.385876260938)
129338 12165 3 55 1439X La Salle Ave 2 1 1 2     12 3X3   6016344.6880818 2095251.8114423 37.7340798748876 -122.38587626093799 (37.7340798748876, -122.385876260938)
107274 12183 3 55 1445 La Salle Ave 2 1 1 2     6 3X3   6016331.060111799 2095306.4617143 37.7342291794135 -122.385927185653 (37.7342291794135, -122.385927185653)
16421 12185 3 55 1445 La Salle Ave 2 1 1 2     12 3X3   6016337.4341 2095323.5181 37.734276365571105 -122.385906337047 (37.7342763655711, -122.385906337047)
14865 12184 3 55 1445 La Salle Ave 1 1 1 2     12 3X3   6016331.1548 2095344.2396 37.734332915157296 -122.385929490724 (37.7343329151573, -122.385929490724)
14416 12182 3 55 1447 La Salle Ave 1 1 1 2     12 3X3   6016313.573 2095416.4509 37.734530219899895 -122.38599530928002 (37.7345302198999, -122.38599530928)
16320 12187 3 55 1455 La Salle Ave 2 1 1 2     12 3X3   6016297.2469 2095451.6147 37.7346258690942 -122.386054205025 (37.7346258690942, -122.386054205025)
15422 12186 3 55 1455 La Salle Ave 1 1 1 2     12 3X3   6016291.5956 2095467.9407 37.7346703842439 -122.38607488138001 (37.7346703842439, -122.38607488138)
14762 12188 3 55 1457 La Salle Ave 1 1 1 2     12 3X3   6016282.8047 2095488.6622 37.734726794786404 -122.386106718848 (37.7347267947864, -122.386106718848)
82904 12198 3 55 1485 La Salle Ave 2 1 1 2     6 3X3   6016165.701365701 2095622.0691082 37.7350866214264 -122.38652088789301 (37.7350866214264, -122.386520887893)
23120 12201 3 55 1485 La Salle Ave 1 1 1 2     7 3X3   6016149.0568 2095651.2946 37.7351659473192 -122.38658047187599 (37.7351659473192, -122.386580471876)
14180 12213 3 55 1503 La Salle Ave 1 1 1 2     12 3X3   6016014.681 2095761.1814 37.7354602343635 -122.387052723732 (37.7354602343635, -122.387052723732)
154902 191501 3 55 299x Cashmere St 2 3 1 2     27     6016915.88272 2095866.14342 37.735798300938704 -122.383944206463 (37.7357983009387, -122.383944206463)
47682 207809 3 55 200x Terrace Dr 30 3 1 2     16     5993795.90954 2096545.0474900003 37.736357157655604 -122.46392766184601 (37.7363571576556, -122.463927661846)
53966 191502 3 55 299x Cashmere St 29 3 1 2     7     6016510.31046 2096089.32701 37.736388688783705 -122.38536198946899 (37.7363886887837, -122.385361989469)
47442 11955 3 55 1469 Kirkwood Ave 1 1 1 2     12 3X4   6015772.6789286 2096311.6012512 37.7369581722856 -122.387927819023 (37.7369581722856, -122.387927819023)
23320 6751 3 55 1215 Fairfax Ave 5 1 1 2   12/29/1992 12:00:00 AM 7     6017537.38126 2096718.5380000002 37.738173145164104 -122.38185469014499 (37.7381731451641, -122.381854690145)
15662 6752 3 55 1215 Fairfax Ave 6 1 1 2     16 3x3   6017539.76894 2096719.1679599998 37.738175006759 -122.381846478456 (37.738175006759, -122.381846478456)
104152 6715 3 55 1200X Fairfax Ave 12 1 1 2     6 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191)
23365 5074 3 55 5593 Diamond Heights Blvd 1 1 1 2   06/04/1992 12:00:00 AM 3     6001579.88731 2097086.51396 37.73828941133 -122.43705400175699 (37.73828941133, -122.437054001757)
15398 6762 3 55 1275 Fairfax Ave 7 1 1 2   01/01/2009 12:00:00 AM 3 3x3   6017299.98506 2096895.81009 37.7386467866108 -122.38268782838999 (37.7386467866108, -122.38268782839)
78861 6767 3 55 1275 Fairfax Ave 12 1 1 2   12/29/1992 12:00:00 AM 12 3x3   6017284.4858800005 2096909.9197200001 37.738684672549205 -122.38274239930401 (37.7386846725492, -122.382742399304)
94044 9319 3 55 99X Gold Mine Dr 7 1 1 2     15 2x2   6001391.6487444 2098856.3848919 37.743138360608704 -122.437831565564 (37.7431383606087, -122.437831565564)
98684 9317 3 55 99X Gold Mine Dr 5 1 1 2   03/11/2006 12:00:00 AM 3 2X2   6001391.6487444 2098856.3848919 37.743138360608704 -122.437831565564 (37.7431383606087, -122.437831565564)
173687 247023 3 55 550x Valley St 1 3 1 2     7     6002381.071819999 2099185.81683 37.7440991162756 -122.43443395738599 (37.7440991162756, -122.434433957386)
17247 10229 3 55 1417 Guerrero St 1 1 1 2     18 3X3   6005889.94053 2100616.0721299998 37.748224824522296 -122.422402655257 (37.7482248245223, -122.422402655257)
17605 10230 3 55 1426 Guerrero St 1 1 1 2     40 2x3   6005817.36142 2100645.21865 37.7483007596771 -122.42265570290199 (37.7483007596771, -122.422655702902)
18162 10221 3 55 1370 Guerrero St 1 1 1 2     65 3X3   6005802.11698 2100976.8322900003 37.7492104347131 -122.42273198069599 (37.7492104347131, -122.422731980696)
22177 10214 3 55 1335 Guerrero St 1 1 1 2     18 4X3   6005859.10485 2101158.22325 37.7497117078336 -122.422547803155 (37.7497117078336, -122.422547803155)
20101 10202 3 55 1243 Guerrero St 1 1 1 2     12 3X3   6005829.09689 2101725.42508 37.7512674207747 -122.42269187452601 (37.7512674207747, -122.422691874526)
136150 191437 3 55 1300x De Haro St 31 3 1 2     15     6012282.34359 2102012.29375 37.7524170754114 -122.400395836501 (37.7524170754114, -122.400395836501)
22133 10187 3 55 1135 Guerrero St 1 1 1 2     18 3X3   6005790.8424 2102360.27695 37.7530084192058 -122.422869277503 (37.7530084192058, -122.422869277503)
19071 10185 3 55 1125 Guerrero St 1 1 1 2     12 3X3   6005788.9112599995 2102417.59249 37.7531656854677 -122.422880028901 (37.7531656854677, -122.422880028901)
123764 10183 3 55 1113 Guerrero St 1 1 1 2     18 3X2   6005790.6047359 2102492.1542693 37.7533705104285 -122.422879471267 (37.7533705104285, -122.422879471267)
98083 10181 3 55 1097X Guerrero St 3 1 1 2     24 3X3   6005777.346268901 2102574.3880576002 37.753595557271 -122.422931166019 (37.753595557271, -122.422931166019)
99786 10163 3 55 1013 Guerrero St 2 1 1 2     18 2x2   6005764.7450429 2102960.7456767 37.7546556947331 -122.423002202394 (37.7546556947331, -122.423002202394)
22091 10162 3 55 1013 Guerrero St 1 1 1 2     12 2x2   6005758.27618 2103002.2349099996 37.7547692495131 -122.42302752222099 (37.7547692495131, -122.423027522221)
286 10157 3 55 995 Guerrero St 1 1 1 2     12 3x3   6005745.7610599995 2103227.37374 37.755386722241504 -122.42308680461201 (37.7553867222415, -122.423086804612)
17896 10143 3 55 920 Guerrero St 1 1 1 2     12 3x3   6005657.84848 2103570.5399700003 37.7563240154596 -122.423415228047 (37.7563240154596, -122.423415228047)
20212 5507 3 55 800 Dolores St 1 1 1 2     20 2x2   6004984.13536 2103653.10654 37.756512676133 -122.42575103988999 (37.756512676133, -122.42575103989)
106702 10129 3 55 892 Guerrero St 3 1 1 2     40 3X3   6005646.9391641 2103763.6492254 37.7568536327232 -122.42346668441999 (37.7568536327232, -122.42346668442)
105257 26194 3 55 573 Castro St 1 1 1 2     12 4x4 Permit Number 772904 6002390.549968 2104882.2284699 37.7597406467411 -122.43480846230499 (37.7597406467411, -122.434808462305)
83389 422 3 55 685X Guerrero St 2 1 1 2     18 3X3   6005653.198434 2104994.6037312 37.7602338989595 -122.423532549649 (37.7602338989595, -122.423532549649)
20535 10072 3 55 573 Guerrero St 1 1 1 2     12 3x3   6005609.84736 2105668.09746 37.7620807071743 -122.423730368485 (37.7620807071743, -122.423730368485)
145902 15426 3 55 2101 Mission St 3 1 1 2     12 2X2   6006897.56767 2106023.27679 37.7631285540423 -122.419301827609 (37.7631285540423, -122.419301827609)
124076 15427 3 55 2109 Mission St 1 1 1 2     12 3X3   6006990.7827 2106030.4142400003 37.7631534012249 -122.418979933746 (37.7631534012249, -122.418979933746)
21805 10058 3 55 451 Guerrero St 1 1 1 2     18 3x5   6005573.3175800005 2106314.3851 37.763853198087 -122.4239026696 (37.763853198087, -122.4239026696)
18862 10055 3 55 432 Guerrero St 1 1 1 2     90 3X2   6005503.26278 2106415.24362 37.7641261764966 -122.424152141508 (37.7641261764966, -122.424152141508)
19488 10031 3 55 310 Guerrero St 1 1 1 2     100 2x3   6005459.49344 2107143.4221799998 37.7661231103266 -122.42435532265301 (37.7661231103266, -122.424355322653)
21820 10021 3 55 274 Guerrero St 1 1 1 2     17 3x4   6005443.44254 2107417.66285 37.7668752034469 -122.424430347706 (37.7668752034469, -122.424430347706)
19969 10013 3 55 215 Guerrero St 1 1 1 2     12 3x2   6005495.275 2107715.11687 37.7676948680391 -122.42427222529899 (37.7676948680391, -122.424272225299)
19433 10011 3 55 198 Guerrero St 1 1 1 2     25 2X3   6005417.15338 2107897.14895 37.76819027309789 -122.424555388522 (37.7681902730979, -122.424555388522)
20132 10004 3 55 150 Guerrero St 1 1 1 2     28 3X3   6005403.33839 2108127.1988 37.768821154693896 -122.424619539876 (37.7688211546939, -122.424619539876)
82679 9998 3 55 122 Guerrero St 1 1 1 2     18 2X2   6005390.2576582 2108319.0051408 37.7693470701553 -122.424678431625 (37.7693470701553, -122.424678431625)
97647 27658 3 55 1698X Mission St 4 1 1 2     12 3X3   6006725.5802 2108585.93757 37.7701553284346 -122.420078550817 (37.7701553284346, -122.420078550817)
19863 27655 3 55 1680 Mission St 9 1 1 2     6 3X3   6006765.6884 2108667.1143 37.770380480168704 -122.419945578015 (37.7703804801687, -122.419945578015)
17503 15320 3 55 1680 Mission St 8 1 1 2   02/27/2004 12:00:00 AM 3 3X3   6006776.8374 2108697.9883 37.770465880950496 -122.419909204722 (37.7704658809505, -122.419909204722)
103981 17345 3 55 175X Otis St 10 1 1 2     12 3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.42011195674299 (37.7705111956623, -122.420111956743)
17086 15318 3 55 1680 Mission St 6 1 1 2     12 3X3   6006784.5559 2108731.4352 37.7705581530288 -122.419884880101 (37.7705581530288, -122.419884880101)
20855 17135 3 55 2033 Oak St 1 1 1 2     12 3X3   5997261.7134 2109120.9259 37.771086505654104 -122.45285242516701 (37.7710865056541, -122.452852425167)
23288 15312 3 55 1665 Mission St 2 1 1 2   11/27/2001 12:00:00 AM 4 3X3   6006906.5597 2108955.7422 37.771180919322 -122.419478782903 (37.771180919322, -122.419478782903)
143245 17111 3 55 1837 Oak St 2 1 1 2     24 3X3   5998183.72781 2109230.9980599997 37.7714415276809 -122.44967109380501 (37.7714415276809, -122.449671093805)
17545 17038 3 55 1200X Oak St 2 1 1 2     24 3X3   6001065.34359 2109713.09337 37.772929678688506 -122.43973803201 (37.7729296786885, -122.43973803201)
Powered by Datasette · Query took 23.186ms · Data source: data.sfgov.org