sf-trees

Data source: data.sfgov.org

Custom SQL query returning 20 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2370 112542 2 45 438 Broadway 2 1 1 2   03/24/2016 12:00:00 AM 3 3x3   6011405.06525 2118709.9257400003 37.7982159634572 -122.40460495956002 (37.7982159634572, -122.40460495956)
6247 112539 2 45 426 Broadway 1 1 1 2   08/12/2016 11:10:00 AM 3 3x3   6011460.82325 2118719.23159 37.7982446311281 -122.404412674615 (37.7982446311281, -122.404412674615)
6998 112530 2 45 435 Broadway 1 1 1 2   03/24/2016 07:26:00 AM 3 3x3   6011409.86951 2118646.99301 37.7980434339179 -122.40458390283199 (37.7980434339179, -122.404583902832)
7100 106210 1 45 585X Bush St 6 1 1 1   11/06/2014 12:00:00 AM 3 3x3 Permit Number 774310 6010773.37918 2115862.1930299997 37.7903614528559 -122.406590009715 (37.7903614528559, -122.406590009715)
10245 43062 1 45 490 34th Ave 1 1 1 1   02/10/2017 12:00:00 AM 3 3x3 Permit Number 51464 5985348.18764 2112571.6735099996 37.779871377757296 -122.49431551232401 (37.7798713777573, -122.494315512324)
15769 30659 1 45 54 Lafayette St 1 1 1 1 1 04/13/2015 12:00:00 AM 3 3x3 Permit Number 34592 6007591.74325 2109572.72569 37.7729135790239 -122.41715242667 (37.7729135790239, -122.41715242667)
41315 95661 1 45 231 Brussels St 1 1 1 1 1 03/08/2011 12:00:00 AM 3 3x3 Permit Number 767423 6010393.1108800005 2093567.05478 37.7291227359169 -122.406334153496 (37.7291227359169, -122.406334153496)
47422 37962 1 45 150 Mississippi St 2 1 1 1   07/16/2009 12:00:00 AM 3 3x3 Permit Number 52636 6013967.394309999 2106347.66255 37.7644148813545 -122.39487221400299 (37.7644148813545, -122.394872214003)
48473 92109 1 45 654 46th Ave 1 1 1 1   07/02/2009 12:00:00 AM 3 3x3 Permit Number 52365 5981669.51861 2111284.19832 37.7761203861627 -122.506945906937 (37.7761203861627, -122.506945906937)
83275 94656 1 45 118 Baden St 1 1 1 1 1 10/22/2010 12:00:00 AM 3 3x3 Permit Number 53795 6000765.0 2094410.0 37.7308939745429 -122.439679643784 (37.7308939745429, -122.439679643784)
86432 117228 2 45 66 POTOMAC ST 1 1 1 1     3 3x3   6003144.0 2108708.0 37.7702880357607 -122.43247591327801 (37.7702880357607, -122.432475913278)
87056 102078 1 45 35 Highland Ave 1 1 1 1 1 12/18/2012 12:00:00 AM 3 3x3 Permit Number 769728 6005184.6 2096720.6 37.737488929995706 -122.42456464703699 (37.7374889299957, -122.424564647037)
91393 100238 2 45 701X 39th Ave 11 1 1 1     3 3x3   5983814.58777 2110777.43528 37.774855053302495 -122.499488194975 (37.7748550533025, -122.499488194975)
97280 94657 1 45 118 Baden St 2 1 1 1 1 10/22/2010 12:00:00 AM 3 3x3 Permit Number 53795 6000765.0 2094410.0 37.7308939745429 -122.439679643784 (37.7308939745429, -122.439679643784)
105918 94658 1 45 130 Baden St 1 1 1 1 1 10/22/2010 12:00:00 AM 3 3x3 Permit Number 53796 6000765.0 2094447.0 37.73099556799129 -122.43968229537701 (37.7309955679913, -122.439682295377)
106194 102595 1 45 133 Baden St 1 1 1 1 1 02/06/2013 12:00:00 AM 3 3x3 Permit Number 769795 6000714.8 2094523.9 37.7312038601891 -122.439861356334 (37.7312038601891, -122.439861356334)
126995 9330 3 45 159 Gold Mine Dr 1 1 1 2   06/11/2015 03:37:00 AM 3 3x3   6000991.502255901 2098643.2192577 37.7425302962209 -122.439199887043 (37.7425302962209, -122.439199887043)
129190 94659 1 45 130 Baden St 2 1 1 1 1 10/22/2010 12:00:00 AM 3 3x3 Permit Number 53796 6000765.0 2094447.0 37.73099556799129 -122.43968229537701 (37.7309955679913, -122.439682295377)
160691 81886 1 45 44 Toledo Way 1 1 1 1   06/13/2008 12:00:00 AM 3 3x3 Permit Number 50856 6001667.32434 2120063.59572 37.801383746212295 -122.43839740632299 (37.8013837462123, -122.438397406323)
173900 112532 2 45 435 Broadway 3 1 1 2     3 3x3   6011441.2715 2118651.0791599997 37.7980564084299 -122.404475530047 (37.7980564084299, -122.404475530047)
Powered by Datasette · Query took 6.921ms · Data source: data.sfgov.org