sf-trees

Data source: data.sfgov.org

Custom SQL query returning 24 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
128753 29219 3 45 1902X 41st Ave 2 1 1 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
113357 18570 1 45 698X Randolph St 1 1 1 1   04/21/1997 12:00:00 AM 6 3X3   5992368.005846401 2088553.4079402 37.7143316913291 -122.46828327353701 (37.7143316913291, -122.468283273537)
17788 18608 1 45 550 Randolph St 1 1 1 1   01/03/1997 12:00:00 AM 6 3X3   5992502.2173 2088557.38 37.7143503484358 -122.467819678694 (37.7143503484358, -122.467819678694)
113563 18603 3 45 520 Randolph St 1 1 1 2   07/25/1996 12:00:00 AM 6 3X3   5992619.61154 2088559.40218 37.7143626789426 -122.467414068351 (37.7143626789426, -122.467414068351)
18385 25468 3 45 437 Randolph St 1 1 1 2   07/26/1996 12:00:00 AM 6 3X3   5992774.4094 2088493.0908 37.7141895393891 -122.466874212626 (37.7141895393891, -122.466874212626)
17486 18596 1 45 409 Randolph St 1 1 1 1   07/26/1996 12:00:00 AM 6 3X3   5992903.2652 2088492.7734 37.7141961040887 -122.46642881780501 (37.7141961040887, -122.466428817805)
105407 25463 1 45 308 Randolph St 2 1 1 1   02/10/1998 12:00:00 AM 3 3X3   5993157.11936 2088546.32287 37.714357782974204 -122.46555529463001 (37.7143577829742, -122.46555529463)
19205 17244 1 45 10X Randolph St 2 1 1 1   03/08/2005 12:00:00 AM 6 3X3   5993945.3779 2088542.9193 37.7143938707274 -122.462830535838 (37.7143938707274, -122.462830535838)
18943 26157 1 45 260 Orizaba Ave 1 1 1 1   06/27/1997 12:00:00 AM 3 3X3   5994051.6997 2088243.7899 37.713578655736 -122.462441364614 (37.713578655736, -122.462441364614)
111533 25183 3 45 3448X Market St 1 1 1 2   04/19/1996 12:00:00 AM 6 3X3   6000085.2661190005 2103906.7160847997 37.7569309776636 -122.442711229464 (37.7569309776636, -122.442711229464)
120958 25184 3 45 3448X Market St 2 1 1 2   04/19/1996 12:00:00 AM 25 3X3   6000085.2661190005 2103906.7160847997 37.7569309776636 -122.442711229464 (37.7569309776636, -122.442711229464)
79717 10670 1 45 1045 Hayes St 1 1 1 1     6 3X3   6002868.606349099 2110598.6567928 37.775463691965896 -122.43356363564301 (37.7754636919659, -122.433563635643)
83025 7243 3 45 1929X Post St 1 1 1 2     6 3X3   6002956.0424065 2114080.0912444 37.7850277993699 -122.43351002509701 (37.7850277993699, -122.433510025097)
18331 34 3 45 759 14th St 1 1 1 2     18 3X3   6003742.09963 2107707.8799900003 37.767575847275204 -122.430335723414 (37.7675758472752, -122.430335723414)
20666 33 3 45 755 14th St 1 1 1 2   02/17/1998 12:00:00 AM 3 3X3   6003762.7674 2107707.98129 37.7675772960935 -122.43026424352199 (37.7675772960935, -122.430264243522)
19634 31 3 45 753 14th St 1 1 1 2   06/08/2016 06:04:00 AM 3 3X3   6003785.60824 2107710.67637 37.7675859898405 -122.430185432325 (37.7675859898405, -122.430185432325)
97182 32 3 45 753 14th St 2 1 1 2   06/08/2016 06:10:00 AM 3 3X3   6003820.6216400005 2107707.01694 37.7675779249973 -122.43006406443999 (37.7675779249973, -122.43006406444)
21370 22 3 45 725 14th St 1 1 1 2   01/18/2017 08:22:00 AM 3 3X3   6003898.66598 2107719.95316 37.7676178644975 -122.429795042015 (37.7676178644975, -122.429795042015)
101774 8103 1 45 775 Fulton St 2 1 1 1   04/14/1998 12:00:00 AM 8 3X3   6004110.63243 2111457.69852 37.7778928009026 -122.42932844351601 (37.7778928009026, -122.429328443516)
93271 8100 1 45 765 Fulton St 3 1 1 1   04/14/1998 12:00:00 AM 6 3X3   6004193.95704 2111472.64562 37.7779385589247 -122.429041260431 (37.7779385589247, -122.429041260431)
146176 89014 1 45 2147 Mason St   1 1 1   09/30/2008 12:00:00 AM   3X3 Permit Number 51763 6008963.0 2120596.0 37.803257869178 -122.41318870136499 (37.803257869178, -122.413188701365)
124635 1772 3 45 2000X Bay Shore Blvd 12 1 1 2     12 3X3   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
98390 11347 3 45 1300X Ingalls St 5 1 1 2   06/06/1997 12:00:00 AM 18 3X3   6017347.6886145 2093992.5867035 37.730677746775605 -122.382320962891 (37.7306777467756, -122.382320962891)
105619 11343 1 45 1300X Ingalls St 1 1 1 1   02/08/1999 12:00:00 AM 16 3X3   6017347.6886145 2093992.5867035 37.730677746775605 -122.382320962891 (37.7306777467756, -122.382320962891)
Powered by Datasette · Query took 8.885ms · Data source: data.sfgov.org