sf-trees

Data source: data.sfgov.org

Custom SQL query returning 11 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
176941 250886 2 8 187 29th Ave 2 2 1 1     4 Width 4ft   5986785.041569999 2114523.7412799997 37.7853151779048 -122.489488445745 (37.7853151779048, -122.489488445745)
23376 208522 2 8 1355 15th Ave 1 1 1 1     2 Width 4ft   5991431.92848 2106202.25399 37.762736820174396 -122.472804800527 (37.7627368201744, -122.472804800527)
181490 208525 2 8 1225 03rd Ave 1 1 1 1     7 Width 4ft   5995136.03986 2107208.3718 37.7657130923001 -122.46006657372101 (37.7657130923001, -122.460066573721)
24918 229203 2 8 4209 22nd St 1 1 1 1     10 Width 4ft   6001100.65171 2102872.95003 37.75415033787171 -122.43912556401699 (37.7541503378717, -122.439125564017)
46342 246446 2 8 453 Duncan St 1 4 1 1     7 Width 4ft   6003581.5934 2099789.36791 37.7458244008674 -122.43032587405399 (37.7458244008674, -122.430325874054)
182760 229195 2 8 2602 Folsom St 1 1 1 1     11 Width 4ft   6008231.941319999 2103239.86149 37.75556099464921 -122.41448969596 (37.7555609946492, -122.41448969596)
177493 247562 2 8 1050 Crescent Ave 4 4 1 1     15 Width 4ft   6008940.711209999 2095579.02322 37.7345658160544 -122.411497325053 (37.7345658160544, -122.411497325053)
177681 192744 2 8 994 Le Conte Ave 4 1 1 1     1 Width 4ft   6013200.48103 2089550.94534 37.718251954029796 -122.396347400705 (37.7182519540298, -122.396347400705)
64247 192743 2 8 994 Le Conte Ave 3 1 1 1     1 Width 4ft   6013217.10164 2089539.9347599999 37.718222646041205 -122.396289178611 (37.7182226460412, -122.396289178611)
154237 192747 2 8 1275 Fairfax Ave 5 1 1 1     1 Width 4ft   6017247.3717 2096937.7067 37.73875891949071 -122.382872657064 (37.7387589194907, -122.382872657064)
1173 190143 3 8 1200 Fairfax Ave 7 4 1 2   03/18/2017 10:47:00 AM 3 Width 4ft   6017523.521480001 2096815.65975 37.738439056714704 -122.381909364434 (37.7384390567147, -122.381909364434)
Powered by Datasette · Query took 6.415ms · Data source: data.sfgov.org