sf-trees

Data source: data.sfgov.org

Custom SQL query returning 10 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
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)
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)
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)
516 188685 3 90 1300 Evans Ave 14 4 1 2   04/10/2017 01:01:00 PM 3 Width 3ft   6017863.857919999 2096944.2017700002 37.738810795988606 -122.38074156686301 (37.7388107959886, -122.380741566863)
Powered by Datasette · Query took 30.045ms · Data source: data.sfgov.org