sf-trees

Data source: data.sfgov.org

Custom SQL query returning 61 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2216 122752 3 94 693 Vermont St 6 1 1 4 2   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066)
2641 37818 3 9 450X Moscow St 6 1 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003946.32629 2090524.4735599998 37.720405743114 -122.428404441023 (37.720405743114, -122.428404441023)
4107 98607 3 26 2340 Jackson St 6 1 1 4 2   9 3x3   6002988.210519999 2116859.68166 37.792661671341705 -122.43359745208599 (37.7926616713417, -122.433597452086)
5823 98617 3 236 2501X Franklin St 6 1 1 4 2   5 3x3   6005326.63971 2118722.15466 37.7979079528477 -122.425639007743 (37.7979079528477, -122.425639007743)
7085 42636 3 32 1651 Union St 6 1 1 4 2 06/26/2000 12:00:00 AM 16 4x5 Permit Number 42688 6005181.30457 2118838.80185 37.7982200229931 -122.426150217479 (37.7982200229931, -122.426150217479)
8457 98627 3 32 3500X Fillmore St 6 1 1 4 2   6 6x6   6002279.94472 2120071.20683 37.801439470916 -122.43627801543998 (37.801439470916, -122.43627801544)
8576 97728 3 2 1150 Francisco St 6 1 1 4 2   5 3x3 Permit Number 50638 6005878.13407 2120716.4935 37.8034150458325 -122.423872565669 (37.8034150458325, -122.423872565669)
9776 99552 3 15 200X Henry St 6 1 1 4 2 12/28/2016 06:02:00 AM 3 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147)
10598 95755 3 180 260 Madrid St 6 1 1 4 2 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003450.901459999 2092257.0440599998 37.725134950402705 -122.43024050589399 (37.7251349504027, -122.430240505894)
10784 77645 3 55 1300X Silliman St 6 1 1 4 2 10/26/1984 12:00:00 AM 10 4x4   6006883.8507199995 2093162.97754 37.727816296176705 -122.41843733843201 (37.7278162961767, -122.418437338432)
10996 77652 3 2 299X Cambridge St 6 1 1 4 2 10/26/1984 12:00:00 AM 6 3x3   6006723.02825 2093252.77715 37.7280538116191 -122.41899967279 (37.7280538116191, -122.41899967279)
12293 75309 3 184 125 Excelsior Ave 6 1 1 4 2 05/08/1992 12:00:00 AM 5 3x3   6002784.56496 2092514.51527 37.7258041440316 -122.432562342276 (37.7258041440316, -122.432562342276)
12381 75048 3 108 148X Paris St 6 1 1 4 2 05/08/1992 12:00:00 AM 6 3x3   6003019.452409999 2092585.35122 37.7260119611657 -122.431755409402 (37.7260119611657, -122.431755409402)
12687 97250 3 12 301X Excelsior Ave 6 1 1 4 2 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003264.30376 2092207.6887700001 37.724988860924 -122.430882033691 (37.724988860924, -122.430882033691)
13403 96770 3 26 1300X Lane St 6 5 1 4 2 12/08/2012 12:00:00 AM 3 3x3   6015623.8599 2095148.9526 37.7337575287133 -122.388361234061 (37.7337575287133, -122.388361234061)
16461 51365 3 111 50 Pomona St 6 1 1 4 2 03/12/2005 12:00:00 AM 3 3x3 Permit Number 47704 6014154.93455 2094628.60419 37.7322472522973 -122.39340338185801 (37.7322472522973, -122.393403381858)
17300 30745 3 20 486X Page St 6 1 1 4 2 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004274.8073 2109806.6859 37.773368818647 -122.42864278458 (37.773368818647, -122.42864278458)
17867 98680 1 55 199X Park St 6 1 1 4 2         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
23245 76756 3 108 1501X 42nd Ave 6 1 1 4 2 05/14/1994 12:00:00 AM 2 3x12   5983095.0741 2104639.3384 37.757959352781 -122.501522927406 (37.757959352781, -122.501522927406)
24331 116062 2 32 2100x 19th St 6 1 1 4 2   22 3x3   6011361.02056 2105129.82914 37.7609257168785 -122.40380128939199 (37.7609257168785, -122.403801289392)
63647 95150 1 2 250 23rd Ave 6 1 1 4 2   12     5988721.361169999 2113591.74757 37.7828690364709 -122.482721124926 (37.7828690364709, -122.482721124926)
67897 110959 1 26 940 Filbert St 6 1 1 4 2   10 5x5   6008435.0253800005 2119688.1206900002 37.800735405160296 -122.414951484348 (37.8007354051603, -122.414951484348)
77873 99668 3 17 150X Alma St 6 1 1 4 2   8 3x3   5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
79583 73289 3 5 1600X GREEN ST 6 1 1 4 2 11/20/1999 12:00:00 AM 10 3x3   6005364.0 2118556.0 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433)
79881 97900 3 127 375X Precita Ave 6 1 1 4 2   16 3x4   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064)
80122 98749 2 26 540X Eureka St 6 1 1 4 2         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201)
80447 99695 3 26 1550X Washington St 6 1 1 4 2   10 3x3   6007274.7 2117123.2 37.7936275055362 -122.41878469564101 (37.7936275055362, -122.418784695641)
80823 98972 3 98 825 Shotwell St 6 1 1 4 2   0 5x5   6008234.2 2102998.9 37.754899496003105 -122.414464835105 (37.7548994960031, -122.414464835105)
83864 102190 2 55 3999X Folsom St 6 1 1 4 2   6 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
84763 99032 3 49 200X Bartlett St 6 1 1 4 2   5 3x3   6006692.0 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314)
87136 76065 3 11 2999X Polk St 6 1 1 4 2 11/16/1996 12:00:00 AM 6 4x4   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624)
88275 47199 3 2 450 30th Ave 6 1 1 4 2 05/08/2002 12:00:00 AM 8 4x4 Permit Number 45157 5986584.12235 2112732.41489 37.7803849777225 -122.49005175134701 (37.7803849777225, -122.490051751347)
88649 46953 3 2 1530 43rd Ave 6 1 1 4 2 05/01/2002 12:00:00 AM 6 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
91304 76222 3 2 3899X Kirkham St 6 1 1 4 2 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
92098 42366 3 28 250 Foerster St 6 1 1 4 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
92342 97065 3 11 1599X Newcomb Ave 6 1 1 4 2   10 3x3   6015231.1 2095663.5 37.7351486000155 -122.38975506041099 (37.7351486000155, -122.389755060411)
92468 73518 3 11 4235 19th St 6 1 1 4 2 06/23/2015 07:36:00 AM 3 4x4   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342)
94595 98794 3 21 950@Washington Clay St 6 1 1 4 2     3x3 Permit Number 768771 6010160.7 2117472.9 37.794749768385294 -122.40882353278799 (37.7947497683853, -122.408823532788)
98194 70472 2 46 450X Banks St 6 1 1 4 2 06/18/1994 12:00:00 AM 4 3x4   6008487.2849764 2096519.17342203 37.73712182063289 -122.413131433288 (37.7371218206329, -122.413131433288)
100398 95454 2 2 601X 30th Ave 6 1 1 4 2   6 3x3   5986556.01855 2112243.67907 37.7790414073553 -122.49011301465099 (37.7790414073553, -122.490113014651)
104670 74737 3 241 151X Palm Ave 6 1 1 4 2 05/31/1997 12:00:00 AM 6 3x3   5995889.08215 2113282.06845 37.7824331529909 -122.45790154321101 (37.7824331529909, -122.457901543211)
109074 42988 3 55 2X Yale St 6 1 1 4 2 09/16/2000 12:00:00 AM 10 4x5 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.41922408324301 (37.7290063985797, -122.419224083243)
109410 76771 3 41 200X Farallones St 6 1 1 4 2 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.45912868181601 (37.7143256328225, -122.459128681816)
109492 76051 3 21 380 Webster St 6 1 1 4 2 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
112310 95267 3 125 2245 Jones St 6 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
114467 99352 3 2 451X 29th Ave 6 1 1 4 2   10 3x3   5986835.92891 2113074.05562 37.781337726878206 -122.489205771916 (37.7813377268782, -122.489205771916)
116244 97072 3 17 1551 Newcomb Ave 6 1 1 4 2   18 4x4   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
119062 98568 3 26 301X Francisco St 6 1 1 4 2 03/23/2016 02:55:00 PM 3 3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
119088 95258 3 51 2290X 14th Ave 6 1 1 4 2         5992014.7 2099861.3 37.745359932747 -122.47032742053699 (37.745359932747, -122.470327420537)
121322 42347 3 28 380X Flood Ave 6 1 1 4 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
123342 98942 3 26 1400X San Bruno Ave 6 1 1 4 2   12 3x3   6011147.5 2101806.3 37.7517881116631 -122.40430583648501 (37.7517881116631, -122.404305836485)
126442 95363 3 5 775X Broadway 6 1 1 20 2   20 3x3   6009884.0 2118395.5 37.7972675002992 -122.40984611339898 (37.7972675002992, -122.409846113399)
126608 76687 3 11 163X London St 6 1 1 4 2 05/08/1992 12:00:00 AM 8 3x3   6002837.0 2092721.0 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389)
126948 99684 3 17 165 Grattan St 6 1 1 4 2 10/04/2013 12:00:00 AM 8 3x3 Permit Number 770537 5997880.8 2106478.8 37.7638673579207 -122.45052048585899 (37.7638673579207, -122.450520485859)
129440 99676 3 17 1250X Shrader St 6 1 1 4 2   14 3x3   5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
140274 99024 3 49 3351X 23rd St 6 1 1 4 2   10 3x3   6006571.0 2102346.4 37.753014305467794 -122.420170352411 (37.7530143054678, -122.420170352411)
140326 102026 2 37 165X Chattanooga St 6 1 1 4 2   3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
140503 116975 2 218 100x CARGO WAY 6 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
144482 98742 2 51 1150 Scott St 6 1 1 20 2 03/21/2012 12:00:00 AM 3 4X4   6002360.0 2112467.0 37.780564823652504 -122.43545670615299 (37.7805648236525, -122.435456706153)
163065 116050 2 12 650x Kansas St 6 1 1 4 2   3 4x4   6011499.79329 2105331.08163 37.76148606285779 -122.403335490949 (37.7614860628578, -122.403335490949)
183247 98791 3 44 950 Clay St 6 1 1 4 2   1 3x6 Permit Number 768771 6010164.1906 2117196.54488 37.7939911598214 -122.408791948484 (37.7939911598214, -122.408791948484)
Powered by Datasette · Query took 8.129ms · Data source: data.sfgov.org