sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
99206 115258 1 54 2150 Jackson St   24 2 1   01/21/2016 12:00:00 AM   6x12   6003858.0 2116995.5 37.7930839063862 -122.430597643601 (37.7930839063862, -122.430597643601)
125788 104827 1 54 4366 26th St   24 1 1       3X3   6001535.3 2100615.2 37.7479758185871 -122.437460780102 (37.7479758185871, -122.437460780102)
28131 200245 2 54 1075 Ingerson Ave 1 19 1 1     0 Width 0ft   6013768.3263 2090118.3656 37.71984155975311 -122.394424294358 (37.7198415597531, -122.394424294358)
28513 200177 2 54 1041 Hollister Ave 1 19 1 1     0 Width 0ft   6014650.3204 2089811.8475 37.7190489123065 -122.39135410876001 (37.7190489123065, -122.39135410876)
29647 200249 2 54 1067 Ingerson Ave 1 19 1 1     0 Width 0ft   6013803.2037 2090093.549 37.7197753570889 -122.394301997885 (37.7197753570889, -122.394301997885)
29863 200176 2 54 1047 Hollister Ave 1 19 1 1     0 Width 0ft   6014610.748 2089844.7127 37.7191369573176 -122.391493192738 (37.7191369573176, -122.391493192738)
30792 200164 2 54 1027 Ingerson Ave 1 19 1 1     0 Width 0ft   6014014.4798 2089939.2839 37.7193635176037 -122.393560894555 (37.7193635176037, -122.393560894555)
37581 200170 2 54 1001 Ingerson Ave 1 19 1 1     0 Width 0ft   6014099.661 2089867.5171 37.71917119290661 -122.393261433304 (37.7191711929066, -122.393261433304)
39813 200248 2 54 1107 Hollister Ave 1 19 1 1     0 Width 0ft   6014274.7183 2090092.8783 37.719799714154504 -122.392672078819 (37.7197997141545, -122.392672078819)
40807 200183 2 54 1197 Hollister Ave 1 19 1 1     0 Width 0ft   6013828.6909 2090422.2008 37.7206791862384 -122.39423689451401 (37.7206791862384, -122.394236894514)
42125 200722 2 54 1476 Oakdale Ave 1 19 1 1     0 Width 0ft   6015747.1852 2094980.6714 37.7333022953684 -122.387923119588 (37.7333022953684, -122.387923119588)
43519 200180 2 54 1031 Hollister Ave 1 19 1 1     0 Width 0ft   6014690.5634 2089785.0188 37.7189774793874 -122.391213128817 (37.7189774793874, -122.391213128817)
44928 200155 2 54 1091 Hollister Ave 1 19 1 1     0 Width 0ft   6014363.9238 2090021.1115 37.719607610680704 -122.39235870744899 (37.7196076106807, -122.392358707449)
52467 200157 2 54 1091 Hollister Ave 1 19 1 1     0 Width 0ft   6014392.094 2090006.3557 37.7195686584119 -122.39226030100401 (37.7195686584119, -122.392260301004)
55366 200178 2 54 3201 Ingerson Ave 1 19 1 1     0 Width 0ft   6014218.378 2089782.3359 37.7189438969212 -122.39284511455 (37.7189438969212, -122.39284511455)
58301 200156 2 54 1047 Ingerson Ave 1 19 1 1     0 Width 0ft   6013914.5428 2090009.7093 37.7195513382693 -122.39391126933 (37.7195513382693, -122.39391126933)
61127 200498 2 54 1055 Ingerson Ave 1 19 1 1     0 Width 0ft   6013869.6047 2090039.2209 37.7196298737115 -122.394068670065 (37.7196298737115, -122.394068670065)
73420 200232 2 54 923 Ingerson Ave 1 19 1 1     0 Width 0ft   6014491.3602 2089577.767 37.7183973497527 -122.391887217647 (37.7183973497527, -122.391887217647)
74346 200162 2 54 1035 Ingerson Ave 1 19 1 1     0 Width 0ft   6013970.2124 2089969.4662 37.7194439323961 -122.393716023061 (37.7194439323961, -122.393716023061)
131768 200212 2 54 1101 Ingerson Ave 1 19 1 1     0 Width 0ft   6013545.647999999 2090276.655 37.720263809593604 -122.395205102903 (37.7202638095936, -122.395205102903)
133594 200166 2 54 1023 Ingerson Ave 1 19 1 1     0 Width 0ft   6014031.9185 2089919.1624 37.7193092369184 -122.393499207549 (37.7193092369184, -122.393499207549)
144780 200169 2 54 1061 Hollister Ave 1 19 1 1     0 Width 0ft   6014525.5668 2089911.1138 37.719314553356206 -122.391792274296 (37.7193145533562, -122.391792274296)
147039 200193 2 54 975 Ingerson Ave 1 19 1 1     0 Width 0ft   6014303.5592 2089724.6542 37.7187902452961 -122.392546641558 (37.7187902452961, -122.392546641558)
150420 200167 2 54 1019 Ingerson Ave 1 19 1 1     0 Width 0ft   6014049.3571 2089910.4430000002 37.7192862641022 -122.393438318502 (37.7192862641022, -122.393438318502)
156632 200165 2 54 1071 Hollister Ave 1 19 1 1     0 Width 0ft   6014485.3238 2089939.2839 37.7193896687982 -122.39193334918501 (37.7193896687982, -122.391933349185)
157610 200239 2 54 1131 Hollister Ave 1 19 1 1     0 Width 0ft   6014148.6234 2090188.791 37.7200560674381 -122.39311465541401 (37.7200560674381, -122.393114655414)
165416 200238 2 54 917 Ingerson Ave 1 19 1 1     0 Width 0ft   6014595.9922 2089500.6344 37.7181913669776 -122.391520156023 (37.7181913669776, -122.391520156023)
168399 200213 2 54 1101 Ingerson Ave 2 19 1 1     0 Width 0ft   6013590.5861 2090251.1677 37.7201963256026 -122.395047981349 (37.7201963256026, -122.395047981349)
168550 200246 2 54 1071 Ingerson Ave 1 19 1 1     0 Width 0ft   6013781.7407 2090110.9877 37.719822047209 -122.394377408818 (37.719822047209, -122.394377408818)
171950 200244 2 54 1123 Hollister Ave 1 19 1 1     0 Width 0ft   6014193.5615 2090152.5722 37.7199591140845 -122.39295678576201 (37.7199591140845, -122.392956785762)
173333 200730 2 54 1466 Oakdale Ave 1 19 1 1     0 Width 0ft   6015770.4184 2094966.2292 37.733263927070006 -122.387841787924 (37.73326392707, -122.387841787924)
176910 200204 2 54 2 Ingerson Ave 1 19 1 1     0 Width 0ft   6014372.6432 2089670.326 37.71864490712711 -122.392304046142 (37.7186449071271, -122.392304046142)
177358 200205 2 54 1003 Hollister Ave 1 19 1 1     0 Width 0ft   6014813.9755 2089679.7161 37.71869518696921 -122.39077918277701 (37.7186951869692, -122.390779182777)
177805 200235 2 54 923 Ingerson Ave 1 19 1 1     0 Width 0ft   6014534.9569 2089547.5847 37.7183168953073 -122.39173441165 (37.7183168953073, -122.39173441165)
177846 200172 2 54 1053 Hollister Ave 1 19 1 1     0 Width 0ft   6014576.5414 2089866.8464 37.7191958334242 -122.391612979464 (37.7191958334242, -122.391612979464)
179075 200190 2 54 1027 Hollister Ave 1 19 1 1     0 Width 0ft   6014706.6607 2089771.6044 37.7189415394071 -122.391156549139 (37.7189415394071, -122.391156549139)
179207 200191 2 54 981 Ingerson Ave 1 19 1 1     0 Width 0ft   6014255.2675 2089757.5194 37.7188778046353 -122.39271586587799 (37.7188778046353, -122.392715865878)
182449 200194 2 54 1011 Hollister Ave 1 19 1 1     0 Width 0ft   6014781.1104 2089713.2519999999 37.718785446443206 -122.390895127615 (37.7187854464432, -122.390895127615)
186420 200171 2 54 1059 Hollister Ave 1 19 1 1     0 Width 0ft   6014549.7127 2089886.9679 37.7192495938582 -122.391707122944 (37.7192495938582, -122.391707122944)
187469 200742 2 54 1454 Oakdale Ave 1 19 1 1     0 Width 0ft   6015834.4667 2094922.2745 37.733146784173606 -122.38761728786601 (37.7331467841736, -122.387617287866)
188973 200161 2 54 1083 Hollister Ave 1 19 1 1     0 Width 0ft   6014425.6299 2089982.8806 37.7195060625081 -122.392142737787 (37.7195060625081, -122.392142737787)
113035 118550 2 54 8140 Geary Blvd 3 17 1 1           5981686.0706 2112397.3766900003 37.7791778206923 -122.506971243035 (37.7791778206923, -122.506971243035)
631 251294 7 54 7126 Geary Blvd 1 16 1 1       3x3   5984860.0 2112552.0 37.779788778901796 -122.49600289252199 (37.7797887789018, -122.496002892522)
89637 121402 2 54 346X Duncan St 1 13 1 1       3x3   6004011.0 2099874.0 37.746081094705794 -122.428847079389 (37.7460810947058, -122.428847079389)
98644 106968 7 54 351 26th Ave   13 1 1           5987720.26121 2113604.44601 37.7828456076198 -122.48618540122601 (37.7828456076198, -122.486185401226)
110212 110320 7 54 9 Imperial Aly   13 2 1           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274)
141787 103673 7 54 64 Henry St   13 1 1           6003097.0 2107420.0 37.7667488371496 -122.432546472662 (37.7667488371496, -122.432546472662)
33065 185060 3 54 10x El Mirasol Pl 1 11 1 2     0 Width 0ft   5987413.8008 2096060.1353 37.7346558528299 -122.485957413668 (37.7346558528299, -122.485957413668)
36394 184614 3 54 3600x Noriega St 1 11 1 2     0 Width 0ft   5982812.7565 2102876.5318 37.7531025964328 -122.502368824356 (37.7531025964328, -122.502368824356)
40307 184619 3 54 3000x Noriega St 1 11 1 2     0 Width 0ft   5984675.7685 2102938.8014 37.7533828605842 -122.495930852185 (37.7533828605842, -122.495930852185)
40829 184609 3 54 3400x Noriega St 1 11 1 2     0 Width 0ft   5983436.8063 2102896.8371 37.7531949966988 -122.500212272852 (37.7531949966988, -122.500212272852)
44250 184634 3 54 4100x Noriega St 1 11 1 2     0 Width 0ft   5981271.0577 2102821.0876 37.7528596561113 -122.507696113948 (37.7528596561113, -122.507696113948)
47495 184900 3 54 3100x Noriega St 2 11 1 2     0 Width 0ft   5984148.1689 2102921.2035 37.7533036269678 -122.49775407488501 (37.7533036269678, -122.497754074885)
71149 142745 3 54 700x COLUMBUS AVE 8 11 1 2     0 Width 0ft   6009127.5357 2120116.4029 37.8019502507169 -122.412585395041 (37.8019502507169, -122.412585395041)
132958 184627 3 54 3300x Noriega St 1 11 1 2     0 Width 0ft   5983533.5949 2102898.8676 37.7532062522999 -122.499877713808 (37.7532062522999, -122.499877713808)
156043 184621 3 54 3100x Noriega St 1 11 1 2     0 Width 0ft   5984373.2194 2102928.6488 37.75333725996521 -122.49697636521401 (37.7533372599652, -122.496976365214)
162177 184618 3 54 3900x Noriega St 1 11 1 2     0 Width 0ft   5981674.4395 2102837.4254 37.7529282714167 -122.506302380507 (37.7529282714167, -122.506302380507)
174998 184611 3 54 3800x Noriega St 1 11 1 2     0 Width 0ft   5982199.0286 2102854.3652 37.753005653234204 -122.504489538097 (37.7530056532342, -122.504489538097)
188070 184620 3 54 3000x Noriega St 2 11 1 2     0 Width 0ft   5984460.1938 2102931.6946 37.753350719104795 -122.496675818993 (37.7533507191048, -122.496675818993)
22852 138173 2 54 1953 GOLDEN GATE AVE 1 10 1 1     0 Width 0ft   6000211.2401 2111613.6154 37.7780993776744 -122.44282896766 (37.7780993776744, -122.44282896766)
36634 247287 2 54 640 Stanyan St 1 10 1 1     0 Width 0ft   5997019.8905 2108844.4958 37.770313639572 -122.453668930321 (37.770313639572, -122.453668930321)
37254 140262 2 54 70 Cole St 1 10 1 1     0 Width 0ft   5997786.9682 2110316.587 37.7743995682404 -122.451121798449 (37.7743995682404, -122.451121798449)
50533 247288 2 54 638 Stanyan St 1 10 1 1     0 Width 0ft   5997017.3270000005 2108860.304 37.770356897849105 -122.453678939083 (37.7703568978491, -122.453678939083)
52776 247289 2 54 636 Stanyan St 1 10 1 1     0 Width 0ft   5997016.0452 2108877.8212 37.7704049220759 -122.45368463790199 (37.7704049220759, -122.453684637902)
89561 141330 2 54 1314 HAYES ST 2 10 1 1     0 Width 0ft   6001510.5734 2110463.2514 37.7750147569158 -122.438251682494 (37.7750147569158, -122.438251682494)
129766 246016 2 54 1605 Haight St 1 10 1 1     0 Width 0ft   5998345.69 2108581.6399 37.7696678206354 -122.449064074288 (37.7696678206354, -122.449064074288)
134533 181882 2 54 2339 32nd Ave 1 10 1 1     0 Width 0ft   5986377.6918 2099330.2097 37.7435741741127 -122.48977995723999 (37.7435741741127, -122.48977995724)
134641 184184 2 54 1642 Lower Great Hwy 1 10 1 1     0 Width 0ft   5980990.4302 2103889.7643 37.7557774014806 -122.508745894794 (37.7557774014806, -122.508745894794)
158331 184392 2 54 2040 Lower Great Hwy 1 10 1 1     0 Width 0ft   5981213.3751 2101162.7638 37.748302968665705 -122.50777253673 (37.7483029686657, -122.50777253673)
165689 140263 2 54 60 Cole St 2 10 1 1     0 Width 0ft   5997782.8203 2110340.7836 37.7744657683679 -122.451137892048 (37.7744657683679, -122.451137892048)
188216 182185 2 54 1638 25th Ave 1 10 1 1     0 Width 0ft   5988431.9652 2104143.1815 37.756909042216 -122.483029559375 (37.756909042216, -122.483029559375)
188653 246020 2 54 1629 Haight St 2 10 1 1     0 Width 0ft   5998306.6251 2108576.7946 37.7696522823625 -122.449198848796 (37.7696522823625, -122.449198848796)
42994 109343 1 54 3211 Baker St 2 9 2 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
51976 181517 2 54 1400 Sunset Blvd 77 9 1 1     4 Width 0ft   5984871.9567 2105586.7319 37.7606648313705 -122.49544767930401 (37.7606648313705, -122.495447679304)
70132 186781 2 54 1200 Sunset Blvd 49 9 1 1     4 Width 0ft   5984857.4742 2106824.7830000003 37.764063324835796 -122.49558908498399 (37.7640633248358, -122.495589084984)
97307 109345 1 54 3211 Baker St 4 9 2 1   02/11/2015 12:00:00 AM 3 8.75x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
99464 109344 1 54 3211 Baker St 3 9 2 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
99631 107208 2 54 3795 Market St 1 9 1 1           6000195.59748 2102713.68465 37.7536614933614 -122.442244022259 (37.7536614933614, -122.442244022259)
107878 124714 2 54 500X 28th St 1 9 1 1       3x3   6002346.0 2099447.0 37.7448142732195 -122.434573899432 (37.7448142732195, -122.434573899432)
109418 119124 2 54 601 46th Ave 3 9 1 1       Width 5ft   5981605.53063 2111566.74083 37.7768923962204 -122.50718822030198 (37.7768923962204, -122.507188220302)
125838 121591 2 54 162 Mangels Ave 1 9 1 1       3x3   6000339.0 2095263.0 37.7332118579221 -122.44121356967199 (37.7332118579221, -122.441213569672)
140543 109342 1 54 3211 Baker St 1 9 2 1   02/11/2015 12:00:00 AM 3 1x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
168416 186800 2 54 1200 Sunset Blvd 78 9 1 1     3 Width 0ft   5984846.2035 2106925.1049 37.7643381205783 -122.495635466651 (37.7643381205783, -122.495635466651)
169869 186771 2 54 1200 Sunset Blvd 39 9 1 1     4 Width 0ft   5984865.2362 2106774.8154 37.7639265823683 -122.495558553205 (37.7639265823683, -122.495558553205)
185802 200181 2 54 1175 Ingerson Ave 1 9 1 1     0 Width 0ft   6013299.4945 2090456.4074 37.7207436812319 -122.396068570714 (37.7207436812319, -122.396068570714)
870 117001 3 54 1X Bernal Heights Blvd 1 7 1 2                    
74538 199648 2 54 420 05th St 1 7 1 1     15 Width 3ft   6012151.63129 2111560.33 37.7786265538123 -122.401518854125 (37.7786265538123, -122.401518854125)
85374 114726 6 54 520 Townsend St 2 7 1 1           6012508.1 2109575.3 37.7731959986981 -122.40014623691201 (37.7731959986981, -122.400146236912)
85903 105084 6 54 344 Fulton St 4 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
86041 105089 6 54 344 Fulton St 9 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
94853 104637 1 54 217 Montcalm St   7 2 1       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375)
96655 105086 6 54 344 Fulton St 6 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
97038 105091 6 54 344 Fulton St 11 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
97519 114725 6 54 520 Townsend St 1 7 1 1           6012508.1 2109575.3 37.7731959986981 -122.40014623691201 (37.7731959986981, -122.400146236912)
100812 115070 6 54 401 DARIEN WAY 1 7 1 1     17     5992724.0 2094938.0 37.7318827746659 -122.467516839465 (37.7318827746659, -122.467516839465)
104314 105082 6 54 344 Fulton St 2 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
105651 105081 6 54 344 Fulton St 1 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
110291 105085 6 54 344 Fulton St 5 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
111744 104636 1 54 217 Montcalm St   7 2 1       16x16   6010036.0 2099691.0 37.7459177905176 -122.40800041337499 (37.7459177905176, -122.408000413375)
118218 104635 1 54 217 Montcalm St   7 2 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
118997 105083 6 54 344 Fulton St 3 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
Powered by Datasette · Query took 18.4ms · Data source: data.sfgov.org