sf-trees

Data source: data.sfgov.org

Custom SQL query returning 72 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
186437 71320 2 82 326 Munich St 1 1 1 1 1 08/26/1995 12:00:00 AM 11     6004289.26563 2090538.0021799998 37.720462289783896 -122.42721997362601 (37.7204622897839, -122.427219973626)
185509 240181 2 82 3399 16th St 1 1 1 1     11 Width 3ft   6004284.27774 2106554.82474 37.7644405309357 -122.42837820690201 (37.7644405309357, -122.428378206902)
185244 179316 2 82 209 Sweeny St 1 1 1 1     11 Width 3ft   6009472.2037 2094777.58995 37.7323950495839 -122.40960322331199 (37.7323950495839, -122.409603223312)
178821 136242 2 82 1679 Washington St 4 1 1 1     11 Width 3ft   6006678.63942 2116999.88567 37.7932553363267 -122.420838360099 (37.7932553363267, -122.420838360099)
177551 213972 2 82 1061 Capitol Ave 5 1 1 1     11 Width 3ft   5995029.65711 2091072.52436 37.721401958108295 -122.459265935174 (37.7214019581083, -122.459265935174)
176770 239360 2 82 1301 Sanchez St 2 1 1 1     11 Width 2ft   6003913.69662 2100667.88359 37.7482554068595 -122.429240140544 (37.7482554068595, -122.429240140544)
173878 240175 2 82 449 Gates St 1 1 1 1     11 Width 3ft   6008238.06241 2096739.7432799998 37.7377134629997 -122.414008710659 (37.7377134629997, -122.414008710659)
168559 179317 2 82 213 Gaven St 1 1 1 1     11 Width 3ft   6009388.38978 2094971.87362 37.7329238140651 -122.40990669864999 (37.7329238140651, -122.40990669865)
167912 137712 2 82 1693 MCALLISTER ST 1 1 1 1     11 Width 0ft   6001117.7986 2111396.751 37.7775555640701 -122.43967731101101 (37.7775555640701, -122.439677311011)
167199 239258 2 82 455 Fair Oaks St 1 1 1 1     11 Width 3ft   6005532.11414 2101023.4503599997 37.749323199804394 -122.423668969944 (37.7493231998044, -122.423668969944)
166527 197112 2 82 2051 23rd St 3 1 1 1     11 Width 3ft   6012308.80023 2102801.3144400003 37.754585029698504 -122.400359759302 (37.7545850296985, -122.400359759302)
165461 240193 2 82 44 Whitney St 1 1 1 1     11 Width 4ft   6004261.16012 2097999.70879 37.740948877501204 -122.42784852959998 (37.7409488775012, -122.4278485296)
164273 136230 2 82 3100 Gough St 1 1 1 1     11 Width 3ft   6004683.10116 2120231.33167 37.8020153805639 -122.427973432847 (37.8020153805639, -122.427973432847)
161356 179312 2 82 407 Cambridge St 1 1 1 1     11 Width 2ft   6006926.51281 2092590.5645700002 37.726246975603 -122.41824928748001 (37.726246975603, -122.41824928748)
158844 136254 2 82 804 North Point St 1 1 1 1     11 Width 3ft   6006813.5477 2121550.30022 37.8057572293748 -122.420694750958 (37.8057572293748, -122.420694750958)
158757 72128 2 82 2012 23rd St 2 1 1 1 1 08/25/1984 12:00:00 AM 11     6012399.20292 2102851.6444 37.7547282656006 -122.400050655116 (37.7547282656006, -122.400050655116)
156029 62003 1 82 1446 Francisco St 1 1 1 1 1 04/18/1994 12:00:00 AM 11   Permit Number 33451 6004382.288930001 2120508.49846 37.8027593860996 -122.429034158913 (37.8027593860996, -122.429034158913)
154817 240133 2 82 0 Chattanooga St 5 1 1 1     11 Width 3ft   6004672.52486 2103529.70008 37.756156217245604 -122.426819912015 (37.7561562172456, -122.426819912015)
154312 239301 2 82 1277 Hampshire St 1 1 1 1     11 Width 3ft   6010336.55809 2101801.57143 37.7517297793105 -122.407109863745 (37.7517297793105, -122.407109863745)
153669 142216 2 82 401 CENTRAL AVE 2 1 1 1     11 Width 0ft   5999738.1536 2109958.1912 37.7735270230304 -122.444346542631 (37.7735270230304, -122.444346542631)
153317 179315 2 82 100 Hamilton St 3 1 1 1     11 Width 3ft   6009040.95061 2093717.83367 37.729461010514605 -122.411019345266 (37.7294610105146, -122.411019345266)
152159 239299 2 82 981 York St 1 1 1 1     11 Width 3ft   6009975.32476 2103526.84529 37.7564467747236 -122.408480748912 (37.7564467747236, -122.408480748912)
150643 67577 1 82 331 Connecticut St 1 1 1 1 1 10/05/1992 12:00:00 AM 11   Permit Number 31140 6013234.31664 2105505.14292 37.762060719736795 -122.397348656429 (37.7620607197368, -122.397348656429)
149171 42714 1 82 419 Thornton Ave 1 1 1 1 1 06/26/2000 12:00:00 AM 11   Permit Number 42727 6013037.066980001 2094313.85012 37.731320830081 -122.39724606626301 (37.731320830081, -122.397246066263)
148254 123265 2 82 460 07th Ave 6 1 1 1     11 Width 3ft   5993761.50417 2112485.6321900003 37.780123890844706 -122.465204105338 (37.7801238908447, -122.465204105338)
148251 55344 1 82 1518 Bacon St 1 1 1 1   10/25/1972 12:00:00 AM 11   Permit Number 11275 6007044.75091 2091766.9119900002 37.723992057772 -122.417782186794 (37.723992057772, -122.417782186794)
143665 179304 2 82 210 Edinburgh St 1 1 1 1     11 Width 3ft   6003900.76299 2092464.46075 37.7257299409794 -122.428700160583 (37.7257299409794, -122.428700160583)
137145 213941 2 82 173 Merced Ave 2 1 1 1     11 Width 4ft   5994356.4044699995 2099261.98747 37.743849483363206 -122.46218679288799 (37.7438494833632, -122.462186792888)
136254 239280 2 82 352 Lexington St 1 1 1 1     11 Width 3ft   6006524.26929 2104030.9306799998 37.7576370049615 -122.420451516722 (37.7576370049615, -122.420451516722)
134067 197110 2 82 600 De Haro St 3 9 1 1     11     6012050.80748 2105527.2247200003 37.7620553876595 -122.40144353408701 (37.7620553876595, -122.401443534087)
132440 137888 2 82 2034 FILLMORE ST 1 1 1 1     11 Width 0ft   6002938.4973 2115326.6052 37.788449414784104 -122.433659844142 (37.7884494147841, -122.433659844142)
131192 138423 2 82 1901 SUTTER ST 1 1 1 1     11 Width 0ft   6003270.9151 2114467.7439 37.7861100553795 -122.43244836372699 (37.7861100553795, -122.432448363727)
131145 213991 2 82 1 Merced Ave 2 2 1 1     11 Width 3ft   5995344.90173 2100199.2685 37.7464798897511 -122.458836668093 (37.7464798897511, -122.458836668093)
131135 58801 1 82 136 10th Ave 1 1 1 1   09/20/1979 12:00:00 AM 11   Permit Number 18050 5992752.10846 2114546.65003 37.7857246222932 -122.468846055179 (37.7857246222932, -122.468846055179)
129543 239328 2 82 3213 Harrison St 1 1 1 1     11 Width 3ft   6009023.80643 2099996.2581700003 37.74669923889321 -122.411522015935 (37.7466992388932, -122.411522015935)
124104 213976 2 82 1061 Capitol Ave 9 1 1 1     11 Width 3ft   5995023.46765 2090970.5982400002 37.7211217374705 -122.459279952923 (37.7211217374705, -122.459279952923)
90234 21723 1 82 1935 Sutter St 1 1 1 1   03/23/1990 12:00:00 AM 11 4X4   6003389.836 2114488.046 37.7861725425441 -122.432038379652 (37.7861725425441, -122.432038379652)
76559 239304 2 82 821 York St 1 1 1 1     11 Width 3ft   6009936.73456 2104250.32887 37.758431136907795 -122.40866524479901 (37.7584311369078, -122.408665244799)
72140 239356 2 82 111 Day St 1 1 1 1     11 Width 2ft   6005135.00311 2098711.3374 37.7429522432585 -122.42487771633101 (37.7429522432585, -122.424877716331)
70076 239335 2 82 3206 Harrison St 2 1 1 1     11 Width 3ft   6008987.26449 2099969.0979 37.7466226130369 -122.411646456035 (37.7466226130369, -122.411646456035)
69300 179323 2 82 100 Merrill St 1 1 1 1     11 Width 3ft   6009520.85663 2094768.8785700002 37.7323738561678 -122.409434403484 (37.7323738561678, -122.409434403484)
68853 239319 2 82 53 Norwich St 1 1 1 1     11 Width 3ft   6009012.44939 2099437.10451 37.745163289459995 -122.4115217893 (37.74516328946, -122.4115217893)
68615 240151 2 82 1526 Cole St 1 1 1 1     11 Width 2ft   5998354.70751 2105195.37647 37.760370512299 -122.448788941261 (37.760370512299, -122.448788941261)
66176 62995 1 82 828 Taylor St 1 1 1 1   09/17/1986 12:00:00 AM 11   Permit Number 23397 6009184.70363 2115820.64878 37.7901583733657 -122.412083801744 (37.7901583733657, -122.412083801744)
65359 213940 2 82 2526 14th Ave 2 1 1 1     11 Width 3ft   5992077.65136 2098235.486 37.7408995020175 -122.46999139020599 (37.7408995020175, -122.469991390206)
63717 240167 2 82 955 Clayton St 3 1 1 1     11 Width 4ft   5998784.85204 2106603.32437 37.764260973182395 -122.44740261924 (37.7642609731824, -122.44740261924)
63053 240137 2 82 466 27th St 1 1 1 1     11 Width 4ft   6003486.65901 2100127.7633700003 37.7467481782042 -122.43067828687201 (37.7467481782042, -122.430678286872)
62846 240171 2 82 457 Anderson St 1 1 1 1     11 Width 3ft   6007878.36492 2096720.03268 37.7376391331344 -122.415250966654 (37.7376391331344, -122.415250966654)
61299 240157 2 82 563 Belvedere St 1 1 1 1     11 Width 3ft   5998602.31996 2105951.33852 37.762460351486794 -122.44798699779601 (37.7624603514868, -122.447986997796)
59697 240149 2 82 1515 Cole St 1 1 1 1     11 Width 4ft   5998302.63561 2105242.38335 37.7604966035517 -122.448972419165 (37.7604966035517, -122.448972419165)
59382 213975 2 82 1061 Capitol Ave 8 1 1 1     11 Width 3ft   5995024.51997 2091003.2487299999 37.7212114484221 -122.45927867859501 (37.7212114484221, -122.459278678595)
58193 138286 2 82 2027 FILLMORE ST 2 1 1 1     11 Width 0ft   6002884.377 2115289.0168 37.788343135637795 -122.433844403927 (37.7883431356378, -122.433844403927)
57487 240150 2 82 1537 Cole St 1 1 1 1     11 Width 4ft   5998310.40334 2105182.48783 37.760332589688 -122.448941239673 (37.760332589688, -122.448941239673)
56253 138334 2 82 1971 FILLMORE ST 1 1 1 1     11 Width 0ft   6002917.5822 2115096.7114 37.7878169981836 -122.43371576970101 (37.7878169981836, -122.433715769701)
55899 239259 2 82 455 Fair Oaks St 2 1 1 1     11 Width 3ft   6005530.597 2101040.15381 37.749368977999 -122.423675403717 (37.749368977999, -122.423675403717)
55365 240183 2 82 3371 16th St 1 1 1 1     11 Width 3ft   6004376.30162 2106560.65422 37.764461744133 -122.428060337037 (37.764461744133, -122.428060337037)
54454 239342 2 82 249 Mullen Ave 2 1 1 1     11 Width 3ft   6010242.3381900005 2100031.5164900003 37.7468643247282 -122.40731092156 (37.7468643247282, -122.40731092156)
54021 248025 2 82 443 Franconia St 1 1 1 1     11 Width 2ft   6009980.9710099995 2098457.93236 37.7425289746384 -122.408103750406 (37.7425289746384, -122.408103750406)
51017 69367 1 82 3630 Webster St 1 1 1 1 1 04/18/1994 12:00:00 AM 11   Permit Number 33461 6002617.53648 2121095.37594 37.8042707453542 -122.435183094434 (37.8042707453542, -122.435183094434)
49521 240131 2 82 0 Chattanooga St 3 1 1 1     11 Width 3ft   6004671.7789900005 2103561.17999 37.7562426115098 -122.426824733295 (37.7562426115098, -122.426824733295)
46311 136201 2 82 20 Retiro Way 1 1 1 1     11 Width 3ft   6001803.6012 2121217.14439 37.8045588359743 -122.438008504412 (37.8045588359743, -122.438008504412)
39609 42172 1 82 525 05th St 5 1 1 1   06/21/2000 12:00:00 AM 11   Permit Number 42460 6012593.26461 2111204.07737 37.7776729981365 -122.399966040597 (37.7776729981365, -122.399966040597)
31500 69354 1 82 1342 Francisco St 1 1 1 1 1 04/18/1994 12:00:00 AM 11   Permit Number 33445 6004870.03416 2120576.9578 37.8029749544875 -122.427351191008 (37.8029749544875, -122.427351191008)
30857 239336 2 82 3206 Harrison St 1 1 1 1     11 Width 3ft   6008986.81884 2099989.0905299997 37.74667748337421 -122.41164940941201 (37.7466774833742, -122.411649409412)
30856 197169 2 82 2 Baldwin Ct 6 9 1 1     11 Width 4ft   6017690.0216 2093651.3665 37.7297597257339 -122.38111373781 (37.7297597257339, -122.38111373781)
29146 179293 2 82 180 Edinburgh St 2 1 1 1     11 Width 3ft   6004018.855 2092658.23186 37.7262686762461 -122.428305729646 (37.7262686762461, -122.428305729646)
28424 239318 2 82 2765 23rd St 1 1 1 1     11 Width 3ft   6010143.74039 2102787.8018900002 37.7544269567524 -122.407846193561 (37.7544269567524, -122.407846193561)
27611 239367 2 82 17 Chattanooga St 1 1 1 1     11 Width 2ft   6004711.71138 2103517.26847 37.756124298509896 -122.42668350644101 (37.7561242985099, -122.426683506441)
26447 213937 2 82 155 Wawona St 1 1 1 1     11 Width 3ft   5992856.26396 2098093.99646 37.740555986160494 -122.467288974202 (37.7405559861605, -122.467288974202)
26025 136191 2 82 2914 Fillmore St 3 1 1 1     11 Width 2ft   6002535.252730001 2118218.14981 37.7963659626655 -122.435261914602 (37.7963659626655, -122.435261914602)
24461 138424 2 82 1901 SUTTER ST 2 1 1 1     11 Width 0ft   6003330.8547 2114478.3784 37.786142653739 -122.432241748584 (37.786142653739, -122.432241748584)
23326 14782 3 82 1037 McAllister St 1 1 1 2     11 4X4   6004198.5372 2111824.0669 37.7789037342236 -122.429050478372 (37.7789037342236, -122.429050478372)
Powered by Datasette · Query took 9.028ms · Data source: data.sfgov.org