sf-trees

Data source: data.sfgov.org

Custom SQL query returning 33 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
511 251164 2 90 1215 Fairfax Ave 10 1 1 1   04/10/2017 01:46:00 PM 3 3x3   6017471.0 2096747.0 37.738247630240295 -122.382086185189 (37.7382476302403, -122.382086185189)
2200 252931 2 90 71 Edgar Ave 1 1 1 1       3x3   5997064.0 2091155.0 37.7217451669512 -122.45223976154499 (37.7217451669512, -122.452239761545)
2562 124910 2 90 3234 Pacific Ave 1 1 1 1   07/19/2017 12:00:00 AM 3 Width 4ft Permit Number 780160 5998760.117380001 2116596.00833 37.79169688945171 -122.4482077616 (37.7916968894517, -122.4482077616)
2563 124911 2 90 3234 Pacific Ave 2 1 1 1   07/19/2017 12:00:00 AM 3 Width 4ft Permit Number 780160 5998736.95045 2116593.12953 37.7916876606053 -122.448287711302 (37.7916876606053, -122.448287711302)
22880 230389 2 90 51 13th St 4 4 1 1     6 Width 3ft   6008142.81587 2108281.73826 37.7693998171644 -122.41515479496701 (37.7693998171644, -122.415154794967)
24021 177451 2 90 836 Brazil Ave 1 1 1 1     5 Width 2ft   6004096.8384300005 2090858.43848 37.7213312534072 -122.427907954105 (37.7213312534072, -122.427907954105)
32851 230380 2 90 1450 Hampshire St 1 1 1 1     5 Width 3ft   6010406.10881 2100942.79845 37.74937566986971 -122.40680882918501 (37.7493756698697, -122.406808829185)
41914 230386 2 90 51 13th St 1 4 1 1     9 Width 4ft   6008087.40778 2108285.62264 37.769407368778 -122.415346724678 (37.769407368778, -122.415346724678)
44789 230394 2 90 280 Fair Oaks St 1 1 1 1     1 Width 3ft   6005433.48505 2102088.4512099996 37.752241878473896 -122.42408575987 (37.7522418784739, -122.42408575987)
45445 230392 2 90 3416 22nd St 1 1 1 1     4 Width 3ft   6005586.33797 2103162.25218 37.7551989159029 -122.423633508794 (37.7551989159029, -122.423633508794)
49153 193408 2 90 480 Potrero Ave 5 1 1 1     1 Width 3ft   6010314.12402 2106048.6526900004 37.763390058038794 -122.40748684246401 (37.7633900580388, -122.407486842464)
49354 131010 2 90 3099 Steiner St 1 1 1 1     3 Width 3ft   6001935.38679 2118702.3343700003 37.797661323668606 -122.437372261923 (37.7976613236686, -122.437372261923)
51642 230377 2 90 11 Haight St 2 4 1 1     6 Width 4ft   6006012.138780001 2109648.33208 37.7730321861234 -122.42262184792101 (37.7730321861234, -122.422621847921)
53287 78624 2 90 1325 Kansas St 1 1 1 1 1 10/07/2000 12:00:00 AM 2     6011733.68356 2102177.51534 37.7528401263726 -122.402304820204 (37.7528401263726, -122.402304820204)
53871 230391 2 90 3425 22nd St 1 1 1 1     2 Width 3ft   6005521.318 2103117.66656 37.755072823769204 -122.423855197061 (37.7550728237692, -122.423855197061)
59682 230381 2 90 655 Dolores St 3 1 1 1     2 Width 6ft   6005021.944209999 2104476.3564299997 37.7587752633866 -122.425678875606 (37.7587752633866, -122.425678875606)
60367 131011 2 90 1771 North Point St 4 1 1 1     5 Width 3ft   6002300.20603 2120865.81933 37.8036224187107 -122.436264801676 (37.8036224187107, -122.436264801676)
62190 79630 2 90 1331 Kansas St 1 1 1 1 1 10/05/2002 12:00:00 AM 2     6011736.35903 2102141.72528 37.752742004040606 -122.402293051689 (37.7527420040406, -122.402293051689)
75813 230383 2 90 655 Dolores St 5 1 1 1     3 Width 6ft   6005020.28561 2104519.96917 37.7588949199761 -122.425687715924 (37.7588949199761, -122.425687715924)
129588 193407 2 90 541 Missouri St 1 4 1 1     3 Width 2ft   6013570.69062 2104547.33874 37.7594495210946 -122.396118132954 (37.7594495210946, -122.396118132954)
132375 230378 2 90 11 Haight St 3 4 1 1     5 Width 4ft   6006027.69558 2109650.1201 37.7730379732539 -122.422568162015 (37.7730379732539, -122.422568162015)
134507 230384 2 90 601 Dolores St 4 1 1 1     4 Width 4ft   6005003.814780001 2104818.83763 37.7597146115626 -122.42576595245501 (37.7597146115626, -122.425765952455)
136828 230393 2 90 3420 22nd St 1 1 1 1     9 Width 3ft   6005567.360669999 2103163.57677 37.7552014816894 -122.423699232135 (37.7552014816894, -122.423699232135)
152400 230382 2 90 655 Dolores St 4 1 1 1     1 Width 6ft   6005021.64655 2104500.02665 37.7588402394163 -122.42568158976002 (37.7588402394163, -122.42568158976)
156278 230376 2 90 126 Dolores St 1 4 1 1     4 Width 3ft   6004756.55794 2107626.00234 37.7674084411732 -122.426821010098 (37.7674084411732, -122.426821010098)
164713 230387 2 90 51 13th St 2 4 1 1     7 Width 4ft   6008108.07186 2108284.2511400003 37.7694047643365 -122.415275151222 (37.7694047643365, -122.415275151222)
172742 177452 2 90 404 Naples St 1 1 1 1     1 Width 4ft   6003440.2849 2091219.73942 37.7222861409715 -122.430203237092 (37.7222861409715, -122.430203237092)
173263 230390 2 90 3431 22nd St 1 1 1 1     4 Width 3ft   6005492.40988 2103117.15388 37.7550697840629 -122.423955133335 (37.7550697840629, -122.423955133335)
178042 230375 2 90 70 Pearl St 1 4 1 1     9 Width 4ft   6005616.00843 2108643.7620099997 37.770251521926 -122.423920665902 (37.770251521926, -122.423920665902)
178549 230385 2 90 581 Dolores St 2 1 1 1     2 Width 9ft   6004995.95318 2104998.86424 37.760208477866 -122.42580595608601 (37.760208477866, -122.425805956086)
179739 193406 2 90 746 Kansas St 1 1 1 1     1 Width 3ft   6011525.03424 2104899.87784 37.7603034831294 -122.40321785872601 (37.7603034831294, -122.403217858726)
180875 230388 2 90 51 13th St 3 4 1 1     8 Width 4ft   6008125.5999300005 2108283.70929 37.7694042616334 -122.41521448386001 (37.7694042616334, -122.41521448386)
182507 230379 2 90 636 Potrero Ave 2 1 1 1     4 Width 2ft   6010352.94216 2105328.73163 37.7614154903439 -122.407301828531 (37.7614154903439, -122.407301828531)
Powered by Datasette · Query took 59.913ms · Data source: data.sfgov.org