sf-trees

Data source: data.sfgov.org

Custom SQL query returning 11 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
36138 249778 2 26 119 Pfeiffer St 4 13 1 1     10 Width 0ft   6010409.80858 2121137.7854400002 37.804826595643 -122.408220184708 (37.804826595643, -122.408220184708)
37767 211724 2 26 41 Ralston St 1 13 1 1     4     5992178.335940001 2088233.1934099998 37.71344150289679 -122.468915552827 (37.7134415028968, -122.468915552827)
41322 211727 2 26 41 Ralston St 10 13 1 1     6     5992176.51123 2088212.22362 37.7133838194885 -122.468920334526 (37.7133838194885, -122.468920334526)
57451 249779 2 26 119 Pfeiffer St 3 13 1 1     8 Width 0ft   6010421.07006 2121139.1053400002 37.804830850333204 -122.408181306135 (37.8048308503332, -122.408181306135)
170319 211723 2 26 47 Ralston St 7 13 1 1     4     5992174.6999 2088241.1909400001 37.7134632521081 -122.468928701793 (37.7134632521081, -122.468928701793)
171235 249889 2 26 230 Greenwich St 25 13 1 1     8 Width 0ft   6011472.47528 2120454.19881 37.8030090801563 -122.404494546207 (37.8030090801563, -122.404494546207)
174735 236183 2 26 1 Penny Ln 3 13 1 1     7 Width 2ft   6002335.35488 2096511.4177599999 37.7367532424671 -122.434400864109 (37.7367532424671, -122.434400864109)
175716 211722 2 26 47 Ralston St 6 13 1 1     8     5992176.846480001 2088244.58976 37.7134727084689 -122.468921529709 (37.7134727084689, -122.468921529709)
179054 249777 2 26 119 Pfeiffer St 5 13 1 1     7 Width 0ft   6010400.427069999 2121136.58311 37.8048227690275 -122.40825256571001 (37.8048227690275, -122.40825256571)
180672 211726 2 26 41 Ralston St 8 13 1 1     7     5992180.41529 2088216.9630599997 37.7133970584078 -122.46890718553699 (37.7133970584078, -122.468907185537)
188904 211725 2 26 41 Ralston St 7 13 1 1     5     5992180.34622 2088219.99909 37.7134053906231 -122.468907645067 (37.7134053906231, -122.468907645067)
Powered by Datasette · Query took 4.434ms · Data source: data.sfgov.org