sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
114 251216 6 1 399X Townsend St 1 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
118 251217 6 1 399X Townsend St 2 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
595 119606 6 1 299x Avalon Ave 2 7 1 1                    
883 251306 2 1 1 Cashmere St 5 13 1 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
885 251305 2 1 1 Cashmere St 4 13 1 1       3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
891 251304 2 1 1 Cashmere St 3 13 1 1 5     3x3   6017463.0 2095772.0 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696)
1262 251479 2 1 1214 29th Ave 3 1 1 1         Permit Number 779194 5987090.84961 2106996.2792700003 37.7646647351899 -122.48787719677 (37.7646647351899, -122.48787719677)
1333 187634 2 1 148 28th Ave 2 1 1 1       3x3 Permit Number 779931 5987142.0 2114987.0 37.786607985699604 -122.48828755026399 (37.7866079856996, -122.488287550264)
4468 253632 2 1 527 Oak St 1 5 1 1       3x3   6004455.0 2110106.0 37.7742008582336 -122.42804080634701 (37.7742008582336, -122.428040806347)
5081 253792 2 1 1698X 08th Ave 2 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5085 253795 2 1 1698X 08th Ave 5 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5092 253791 2 1 1698X 08th Ave 1 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5097 253793 2 1 1698X 08th Ave 3 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
5099 253794 2 1 1698X 08th Ave 4 14 1 2       3x3   5993765.0 2103990.0 37.7567973297208 -122.464574954098 (37.7567973297208, -122.464574954098)
9615 138532 2 1 1670 Scott St 3 1 1 1       Width 0ft   6001631.8101 2114208.4561 37.785305035186894 -122.438100638619 (37.7853050351869, -122.438100638619)
9684 173630 6 1 2699x OCEAN AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
9833 173705 2 1 181 Addison St 1 1 1 1       3x3   6002695.0 2097057.0 37.738271693727796 -122.433196386583 (37.7382716937278, -122.433196386583)
9868 173714 2 1 699x 29th St 3 8 1 1       3x3   6002089.0 2098776.0 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427)
9912 173731 6 1 484 Chenery St 1 7 1 1           6003566.0 2096120.0 37.7357482768139 -122.43011807363199 (37.7357482768139, -122.430118073632)
9946 173747 2 1 2799x 47th Ave 1 1 1 1       3x3   5981791.0 2096580.0 37.735753982711294 -122.50543552617201 (37.7357539827113, -122.505435526172)
10258 173932 2 1 1109x Alemany Blvd   1 1 1       3x3   6003491.0 2094313.0 37.7307824159859 -122.430248501015 (37.7307824159859, -122.430248501015)
11284 105132 2 1 1619 47th Ave 1 1 1 1   01/14/2016 12:00:00 AM   3x3 Permit Number 777355 5981562.16 2104041.1764 37.756226819608 -122.50677993398399 (37.756226819608, -122.506779933984)
11510 107860 2 1 3667 Wawona St 1 1 1 1       3x3 Permit Number 777933 5981683.9506 2096685.2741 37.7360367363779 -122.505813433386 (37.7360367363779, -122.505813433386)
11593 116739 1 1 1678 40th Ave 1 1 1 1       3x3 Permit Number 778366 5983788.3957 2103743.2164 37.755539548337204 -122.49905895584999 (37.7555395483372, -122.49905895585)
13254 115458 1 1 476 FAIR OAKS ST 3 1 1 1       3x3   6005502.0 2100939.0 37.7490896185955 -122.423767101444 (37.7490896185955, -122.423767101444)
13301 187651 6 1 175 Raccoon Dr 1 13 1 1           5998689.0 2104063.0 37.7572803991188 -122.447551270828 (37.7572803991188, -122.447551270828)
20976 108213 2 1 126 Clement St 2 1 1 1           5995164.0 2113575.0 37.783195780257 -122.46043122472 (37.783195780257, -122.46043122472)
21679 210472 2 1 624 Irving St 1 1 1 1       Width 4ft   5993801.69661 2106684.35823 37.764197452264106 -122.464643687651 (37.7641974522641, -122.464643687651)
42963 113115 2 1 1x TOMASO CT 3 9 1 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
42986 113272 1 1 505 Baker St 2 1 1 1           6000604.42582894 2110679.50515746 37.7755569556145 -122.44140175558 (37.7755569556145, -122.44140175558)
53606 121385 2 1 825 Lincoln Way 5 1 1 1       3x3   5993159.0 2107262.0 37.7657464318194 -122.466908568463 (37.7657464318194, -122.466908568463)
61688 57206 1 1 2202 Divisadero St 1 1 1 1   01/08/1975 12:00:00 AM     Permit Number 774014 6000908.32678769 2115906.78943665 37.7899270475037 -122.44072552972 (37.7899270475037, -122.44072552972)
63656 112446 2 1 254 CENTRAL AVE 2 1 1 1       3x3   5999892.0 2109423.0 37.772066299939205 -122.443775909671 (37.7720662999392, -122.443775909671)
65296 110379 2 1 2194 PALOU AVE 1 1 1 1       27x18   6011949.0 2097537.0 37.7401102866319 -122.401234145483 (37.7401102866319, -122.401234145483)
67557 100121 6 1 690 Miramar Ave 1 7 1 1           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042)
75161 41044 1 1 1444 Pacific Ave 1 1 1 1 1 01/29/2000 12:00:00 AM     Permit Number 41825 6007214.22869275 2117785.20726397 37.795441807697294 -122.41904090928001 (37.7954418076973, -122.41904090928)
76347 111157 2 1 201x EUGENIA AVE 4 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
77575 107856 2 1 2938 SLOAT BLVD   1 1 1       3x3   5981725.3 2096580.0 37.7357501162313 -122.50566267275299 (37.7357501162313, -122.505662672753)
77606 106897 2 1 2768 GREAT HWY 1 1 1 1           5981642.5 2096616.3 37.735844912626 -122.505951630112 (37.735844912626, -122.505951630112)
77652 31202 1 1 276 Granada Ave 1 1 1 1   07/02/1969 12:00:00 AM     Permit Number 34894 5995678.83964111 2091843.96330625 37.7235574477937 -122.45707767911101 (37.7235574477937, -122.457077679111)
77956 45719 1 1 227 Sargent St 1 1 1 1   12/18/1969 12:00:00 AM     Permit Number 44389 5993425.80357844 2089157.89359185 37.7160525030782 -122.464671006022 (37.7160525030782, -122.464671006022)
78090 113273 1 1 505 Baker St 3 1 1 1           6000604.42582894 2110679.50515746 37.7755569556145 -122.44140175558 (37.7755569556145, -122.44140175558)
78094 98145 1 1 2495 27th Ave 1 1 1 1       6x7 Permit Number 768497 5987947.1 2098339.7 37.7409460050834 -122.484280768936 (37.7409460050834, -122.484280768936)
78222 38067 1 1 1654X SCOTT ST 3 1 1 1 1 07/10/1998 12:00:00 AM   8x5 Permit Number 40258 6001625.0 2114095.0 37.7849931264589 -122.43811606926701 (37.7849931264589, -122.438116069267)
78233 40342 1 1 170 Westgate Dr 1 1 1 1   05/17/1999 12:00:00 AM     Permit Number 41473 5993510.486220299 2094049.6713278 37.7294890191855 -122.464733328734 (37.7294890191855, -122.464733328734)
78519 94912 1 1 1506 Masonic Ave 1 1 1 1           5999677.4 2107342.3 37.7663409791409 -122.44436866988998 (37.7663409791409, -122.44436866989)
78722 97496 2 1 677 02nd Ave 1 1 1 1           5995323.3 2110955.5 37.7760124935324 -122.459690319245 (37.7760124935324, -122.459690319245)
78781 121184 6 1 1000x Duncan St 5 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
79111 122609 2 1 1214 29th Ave 3 1 1 1       3x3   5987117.0 2106960.0 37.764566647704896 -122.48778408507201 (37.7645666477049, -122.487784085072)
79226 55388 1 1 1377 09th Ave 1 1 1 1   11/01/1972 12:00:00 AM   3x3 Permit Number 11325 5993310.46042535 2106120.10977525 37.762619842052494 -122.466301708727 (37.7626198420525, -122.466301708727)
79242 121190 6 1 1000x Duncan St 11 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
79255 57585 1 1 297 Missouri St 1 1 1 1   08/19/2015 12:00:00 AM   3x3 Permit Number 16453 6013500.41645948 2105713.4077908 37.762647381026504 -122.39644291208 (37.7626473810265, -122.39644291208)
79356 117521 2 1 1601 PAGE ST 3 1 1 1       3x3   5998904.0 2109014.0 37.7708868872166 -122.447164026359 (37.7708868872166, -122.447164026359)
79542 115664 2 1 601x PERU AVE 2 14 1 1       3x3   6005068.0 2092670.0 37.726360298316294 -122.42467972288401 (37.7263602983163, -122.424679722884)
79648 94502 1 1 60 Fernwood Dr 1 1 1 1         Permit Number 53693 5994613.0 2095460.0 37.733424938715 -122.461024038199 (37.733424938715, -122.461024038199)
79987 110384 2 1 2280 PALOU AVE 1 1 1 1       24x18   6011419.0 2097963.0 37.741250408777205 -122.40309663685801 (37.7412504087772, -122.403096636858)
80010 121602 2 1 247X Addison St 1 1 1 1       3x3   6002641.0 2097233.0 37.7387518856743 -122.433395665119 (37.7387518856743, -122.433395665119)
80352 121187 6 1 1000x Duncan St 8 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
80679 94196 1 1 355 Ocean Ave 4 1 1 1           5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662)
80788 107855 2 1 2938 SLOAT BLVD   1 1 1       3x3   5981725.3 2096580.0 37.7357501162313 -122.50566267275299 (37.7357501162313, -122.505662672753)
81459 25185 3 1 3638 Market St 1 1 1 2   04/19/1996 12:00:00 AM   3X3   6000425.6878797 2103367.625274 37.7554701662116 -122.441495243201 (37.7554701662116, -122.441495243201)
81630 112805 2 1 1590 NOE ST 1 1 1 1       3x3   6003316.0 2098976.0 37.743576033800004 -122.431186211773 (37.7435760338, -122.431186211773)
81845 113126 2 1 1x TOMASO CT 14 9 1 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
81854 64519 1 1 505 Baker St 1 1 1 1   07/21/1988 12:00:00 AM     Permit Number 25401 6000604.42582894 2110679.50515746 37.7755569556145 -122.44140175558 (37.7755569556145, -122.44140175558)
82038 122338 2 1 410X 04th Ave 2 1 1 1       3x3   5994775.0 2112759.0 37.780932878116396 -122.461717814262 (37.7809328781164, -122.461717814262)
82109 105208 6 1 2694 47TH AVE   7 1 1           5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
82321 101274 2 1 2350 Irving St 1 1 1 1       3x3   5988480.0 2106495.0 37.763369292926996 -122.483035808211 (37.763369292927, -122.483035808211)
82433 111159 2 1 201x EUGENIA AVE 6 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
82974 113119 2 1 1x TOMASO CT 7 9 1 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
82981 110866 2 1 800 INDIANA ST 2 9 1 1           6014913.4 2104437.2 37.7592217202179 -122.391466645187 (37.7592217202179, -122.391466645187)
83086 113959 2 1 549 Liberty St 1 1 1 1       3x3   6002757.9 2103817.6 37.7568382818529 -122.43346190022498 (37.7568382818529, -122.433461900225)
83109 66626 1 1 496 Alvarado St 1 1 1 1   01/14/2009 12:00:00 AM     Permit Number 52007 6003158.91614039 2102739.58919536 37.7539010640869 -122.43199806254499 (37.7539010640869, -122.431998062545)
83258 54511 1 1 624 Irving St 1 1 1 1   06/28/1972 12:00:00 AM   3x3 Permit Number 10305 5993855.83604665 2106680.47077674 37.7641898993307 -122.464456154065 (37.7641898993307, -122.464456154065)
83432 113936 2 1 800 EL CAMINO DEL MAR 5 1 1 1       3x3 Permit Number 776988 5985966.0 2115003.0 37.7865832348262 -122.49235734524099 (37.7865832348262, -122.492357345241)
83514 110421 2 1 39 DORMAN AVE 1 1 1 1       27x18   6011494.0 2097294.0 37.739417665451604 -122.402790273501 (37.7394176654516, -122.402790273501)
83776 112448 2 1 254 CENTRAL AVE 4 1 1 1       3x3   5999892.0 2109423.0 37.772066299939205 -122.443775909671 (37.7720662999392, -122.443775909671)
84788 103369 1 1 1528 Sanchez St 2 1 1 1       3x3 Permit Number 770212 6003912.8 2099364.9 37.744677665265606 -122.429150348387 (37.7446776652656, -122.429150348387)
84871 31201 1 1 257 Granada Ave 1 1 1 1   06/20/1969 12:00:00 AM     Permit Number 34892 5995623.87772067 2091687.20373025 37.723123866844894 -122.457256336737 (37.7231238668449, -122.457256336737)
85073 105050 1 1 2835 Steiner St 2 1 1 1       3x3 Permit Number 771766 6002056.0 2117852.0 37.7953333833033 -122.436894002104 (37.7953333833033, -122.436894002104)
85079 110426 2 1 90 DORMAN AVE 1 1 1 1       27x18   6011326.0 2097433.0 37.7397899480097 -122.403380922944 (37.7397899480097, -122.403380922944)
85308 121568 2 1 499X Laurel St 2 1 1 1       3x3   5998083.0 2114873.0 37.7869272334312 -122.450426308155 (37.7869272334312, -122.450426308155)
85450 121597 2 1 998X Elizabeth St 2 1 1 1       3x3   6000144.0 2102038.0 37.7518032865281 -122.44237395255101 (37.7518032865281, -122.442373952551)
86054 114065 2 1 898x ELIZABETH ST 4 1 1 1       3x3   6000938.0 2102006.0 37.751760645744206 -122.439625904919 (37.7517606457442, -122.439625904919)
86356 118325 2 1 200x TARAVAL ST 3 1 1 1       3x3   5992604.0 2099181.0 37.7435260562612 -122.4682402545 (37.7435260562612, -122.4682402545)
86623 107513 2 1 2760 GREENWICH ST   1 1 1           5999743.0 2118796.0 37.797793624169 -122.444965226189 (37.797793624169, -122.444965226189)
87073 118915 2 1 825 La Playa 1 1 1 1       Width 4ft   5980733.09837 2110116.47079 37.772858959689 -122.510098401613 (37.772858959689, -122.510098401613)
87082 110870 2 1 343X AUSTIN ST 2 1 1 1       3x3 Permit Number 775635 6005575.0 2115207.0 37.7882702532087 -122.424529439646 (37.7882702532087, -122.424529439646)
87112 108316 2 1 1795 Lincoln Way 1 5 1 1           5990313.88148 2107203.45347 37.765421057721795 -122.476744840008 (37.7654210577218, -122.476744840008)
87239 31218 1 1 2302 Steiner St 6 1 1 1         Permit Number 34907 6002345.06195587 2116106.2366551002 37.79055639288929 -122.43576883650199 (37.7905563928893, -122.435768836502)
87282 111156 2 1 201x EUGENIA AVE 3 14 1 1       3x3   6006591.0 2098138.0 37.7414601197382 -122.419802596536 (37.7414601197382, -122.419802596536)
87416 108318 2 1 1795 Lincoln Way 3 5 1 1           5990313.88148 2107203.45347 37.765421057721795 -122.476744840008 (37.7654210577218, -122.476744840008)
87538 97027 7 1 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
87992 101275 2 1 2350 Irving St 2 1 1 1       3x3   5988480.0 2106495.0 37.763369292926996 -122.483035808211 (37.763369292927, -122.483035808211)
88376 122391 2 1 163 Melrose Ave 1 1 1 1       3x3   5999026.0 2095466.0 37.733694368197 -122.445767544074 (37.733694368197, -122.445767544074)
88545 113118 2 1 1x TOMASO CT 6 9 1 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
88572 121382 2 1 825 Lincoln Way 2 1 1 1       3x3   5993159.0 2107262.0 37.7657464318194 -122.466908568463 (37.7657464318194, -122.466908568463)
88588 118899 2 1 7300 Fulton St 1 1 1 1       Width 4ft   5980716.90165 2109609.13106 37.771464998604 -122.510116727255 (37.771464998604, -122.510116727255)
88670 112445 2 1 254 CENTRAL AVE 1 1 1 1       3x3   5999892.0 2109423.0 37.772066299939205 -122.443775909671 (37.7720662999392, -122.443775909671)
89056 121188 6 1 1000x Duncan St 9 1 1 1       3x3 Permit Number 775289 5999834.0 2099740.0 37.7454758595085 -122.44328093408899 (37.7454758595085, -122.443280934089)
89162 122337 2 1 410X 04th Ave 1 1 1 1       3x3   5994775.0 2112759.0 37.780932878116396 -122.461717814262 (37.7809328781164, -122.461717814262)
89600 103266 2 1 2365 UNION ST 2 1 1 1       3x3   6001713.0 2118319.0 37.796596142729896 -122.43811430510799 (37.7965961427299, -122.438114305108)
Powered by Datasette · Query took 20.504ms · Data source: data.sfgov.org