sf-trees

Data source: data.sfgov.org

Custom SQL query returning 33 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
7925 22616 1 37 1001 Turk St 7 1 1 3     24 3x5   6005581.297 2112717.6262 37.7814354041528 -122.424330527926 (37.7814354041528, -122.424330527926)
11793 120892 2 37 201 Leland Ave 8 1 1 3     6 3x3   6009904.76 2087542.3079 37.7125527002168 -122.407597819442 (37.7125527002168, -122.407597819442)
21616 25457 1 37 100 Randolph St 2 1 1 3   12/10/1997 12:00:00 AM 6 3X3   5993681.7949 2088543.8714 37.7143812997511 -122.463741645146 (37.7143812997511, -122.463741645146)
21638 18577 1 37 100 Randolph St 1 1 1 3   10/12/1998 12:00:00 AM 6 3X3   5993712.2633 2088544.8235 37.7143856696584 -122.46363640417201 (37.7143856696584, -122.463636404172)
48375 17720 1 37 1300X Pierce St 1 1 1 3   01/28/2013 12:00:00 AM 35 3X3 Permit Number 768629 6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
77366 17721 1 37 1300X Pierce St 2 1 1 3   01/28/2013 12:00:00 AM 3 3X3 Permit Number 768629 6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
78609 26824 1 37 2000X San Jose Ave 17 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
79265 26306 1 37 2000X San Jose Ave 9 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
79960 26313 1 37 2000X San Jose Ave 16 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
80056 26299 1 37 2000X San Jose Ave 2 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
81506 26304 1 37 2000X San Jose Ave 7 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
85891 26298 1 37 2000X San Jose Ave 1 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
87516 111787 2 37 55X SHERMAN ST 4 1 1 3       3x3   6010857.0 2110997.0 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357)
91603 24685 1 37 6599X Geary Blvd 1 1 1 3   12/02/1998 12:00:00 AM 3 3X3   5986563.555448 2112507.5928897997 37.7797664796237 -122.490106359303 (37.7797664796237, -122.490106359303)
92206 26303 1 37 2000X San Jose Ave 6 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
95645 17724 1 37 1300X Pierce St 5 1 1 3   01/28/2013 12:00:00 AM 20 3X3 Permit Number 768629 6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
95883 26312 1 37 2000X San Jose Ave 15 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
96826 26300 1 37 2000X San Jose Ave 3 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
99814 26311 1 37 2000X San Jose Ave 14 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
101373 24687 1 37 6599X Geary Blvd 3 1 1 3   06/03/1997 12:00:00 AM 3 3X3   5986563.555448 2112507.5928897997 37.7797664796237 -122.490106359303 (37.7797664796237, -122.490106359303)
101761 101311 2 37 4244X 19th St 1 1 1 3     5 3x3   6001912.0 2104709.0 37.7592378221466 -122.43645112889901 (37.7592378221466, -122.436451128899)
105682 12051 1 37 1300X La Salle Ave 3 1 1 3   03/11/2006 12:00:00 AM 3 3X3   6016940.808513099 2094664.4394134998 37.7325000389111 -122.38377438405399 (37.7325000389111, -122.383774384054)
106413 26302 1 37 2000X San Jose Ave 5 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
107389 26297 1 37 2000X San Jose Ave 19 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
111375 26308 1 37 2000X San Jose Ave 11 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
114344 26310 1 37 2000X San Jose Ave 13 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
115282 12063 1 37 1330X La Salle Ave 8 1 1 3   03/11/2006 12:00:00 AM 3 3X3   6016860.8582794005 2094712.6673543 37.732628043472 -122.38405415096399 (37.732628043472, -122.384054150964)
115681 26309 1 37 2000X San Jose Ave 12 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
122107 26305 1 37 2000X San Jose Ave 8 1 1 3   06/25/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
139264 12049 1 37 1300X La Salle Ave 1 1 1 3   12/17/2007 12:00:00 AM 3 3x3   6016940.808513099 2094664.4394134998 37.7325000389111 -122.38377438405399 (37.7325000389111, -122.383774384054)
141627 26301 1 37 2000X San Jose Ave 4 1 1 3   06/24/1997 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
143937 17725 1 37 1300X Pierce St 6 1 1 3   01/28/2013 12:00:00 AM 60 3X3 Permit Number 768629 6002290.5602400005 2112983.34935 37.7819786446445 -122.435733884321 (37.7819786446445, -122.435733884321)
146124 26307 1 37 2000X San Jose Ave 10 1 1 3   07/06/1998 12:00:00 AM 3 3X3   5999917.070942 2092574.844182 37.7258067629719 -122.442479358973 (37.7258067629719, -122.442479358973)
Powered by Datasette · Query took 40.607ms · Data source: data.sfgov.org