sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
858 251395 2 118 2101 26th St   1 1 1       3x3   6012226.0 2101445.0 37.750856267744496 -122.400550836744 (37.7508562677445, -122.400550836744)
999 251422 2 47 480x De Long St   7 1 1       3x3   5992963.0 2086633.0 37.709093057147996 -122.466087289133 (37.709093057148, -122.466087289133)
1101 251439 3 67 49X Eddy St   1 1 2       3x3   6010285.0 2113564.0 37.78402382830029 -122.408117626865 (37.7840238283003, -122.408117626865)
1524 251544 2 27 863X Ocean Ave   17 1 1       3x3   5997430.0 2091537.0 37.722815009603295 -122.451002133856 (37.7228150096033, -122.451002133856)
1556 251583 2 12 75 Rice St   1 1 1       3x3   5995352.0 2086409.0 37.7086155444167 -122.45781440192499 (37.7086155444167, -122.457814401925)
1620 251543 2 3 0X Bay Shore Blvd Off Ramp   17 1 1                    
1635 251542 2 5 50 Vista Ln   1 1 1       3x3 Permit Number 780127 5999350.0 2102347.0 37.752606437592604 -122.445141915929 (37.7526064375926, -122.445141915929)
1683 251669 2 25 203 Addison St   1 1 1       3x3   6002642.0 2097220.0 37.7387162474086 -122.433391278876 (37.7387162474086, -122.433391278876)
1735 251679 2 132 5 Dwight St   1 1 1       3x3   6011495.0 2091622.0 37.7238435952898 -122.40238810251101 (37.7238435952898, -122.402388102511)
1769 251689 2 2 355 Silver Ave   1 1 1       3x3   6003702.0 2093526.0 37.728633439635104 -122.429462937782 (37.7286334396351, -122.429462937782)
1836 251749 2 48 601 Prague St   1 1 1       3x3   6002875.0 2087693.0 37.7125704580966 -122.43190559156 (37.7125704580966, -122.43190559156)
1848 251743 2 48 143 Cordova St   1 1 1       3x3   6001773.0 2087479.0 37.7119203272299 -122.43569914014999 (37.7119203272299, -122.43569914015)
1946 252821 2 162 47 Miramar Ave   1 1 1       3x3   5995289.0 2090229.0 37.719100747698704 -122.45830844121001 (37.7191007476987, -122.45830844121)
1985 252841 1 39 1763 Golden Gate Ave   1 1 1   10/07/1998 12:00:00 AM   3x3 Permit Number 40601 6001163.0 2111730.0 37.7784731541065 -122.43954484007 (37.7784731541065, -122.43954484007)
2126 252903 2 64 215 Capistrano Ave   7 1 1       3x3   6001180.0 2093207.0 37.727614424830705 -122.438158778943 (37.7276144248307, -122.438158778943)
2198 252932 2 41 66 Edgar Ave   1 1 1       3x3   5997141.0 2091179.0 37.7218154760893 -122.451975324711 (37.7218154760893, -122.451975324711)
2199 252934 2 41 78 Edgar Ave   1 1 1       3x3   5997141.0 2091229.0 37.7219527643602 -122.451978930217 (37.7219527643602, -122.451978930217)
2201 252933 2 41 72 Edgar Ave   1 1 1       3x3   5997141.0 2091205.0 37.7218868659906 -122.45197719957199 (37.7218868659906, -122.451977199572)
2575 253126 4 26 182 London St   1 1 1   07/19/2017 12:00:00 AM 3 3x3 Permit Number 779117 6002742.73008 2092646.2038099999 37.726163358663705 -122.432716365158 (37.7261633586637, -122.432716365158)
2650 253148 1 26 375 Naples St   1 1 1   07/13/2000 12:00:00 AM   3x3 Permit Number 43092 6003622.0 2091383.0 37.722744709081205 -122.42958672889 (37.7227447090812, -122.42958672889)
2749 253209 2 12 1129 Naples St   1 1 1       3x3   6001432.0 2087854.0 37.712930619101 -122.43690455890899 (37.712930619101, -122.436904558909)
2757 253210 2 129 567 Mississippi St   1 1 1       3x3   6014163.0 2104519.0 37.7594046471392 -122.394067636073 (37.7594046471392, -122.394067636073)
3318 253415 4 88 55 Stoneybrook Ave   8 1 1   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.4268599998 37.729984953042795 -122.421802746417 (37.7299849530428, -122.421802746417)
3851 252871 2 5 2557 Sutter St   7 1 1       3x3   5999847.0 2113975.0 37.7845623594454 -122.444258736096 (37.7845623594454, -122.444258736096)
4032 253155 2 37 546 Ellington Ave   1 1 1   10/05/2017 11:02:00 AM 3 3x3   5997941.0 2087090.0 37.710633814489604 -122.44891554828999 (37.7106338144896, -122.44891554829)
4222 253622 2 128 300x Naglee Ave   14 1 1                    
5008 253723 3 177 1X Glenview Dr   3 1 2       3x3   5998487.0 2100314.0 37.746975021233204 -122.447979947083 (37.7469750212332, -122.447979947083)
5181 253819 2 5 1100x Prague St   1 1 1       3x3   6001057.0 2086858.0 37.71017450293179 -122.43812937571998 (37.7101745029318, -122.43812937572)
8534 96176 1 251     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767809          
9563 108596 1 51 36 Bronte St   1 1 1 1   1 3x3 Permit Number 770949 6009339.44395 2097251.26276 37.7391797819084 -122.410236794344 (37.7391797819084, -122.410236794344)
9585 96180 1 251     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767812          
9710 173649 2 78 2645 Lake St   1 1 1       3x3   5987243.0 2114574.0 37.7854798983764 -122.48790776340401 (37.7854798983764, -122.487907763404)
9718 105047 4 37 278 Capitol Ave   1 1 1       3x3   5995102.4 2087946.7 37.7128233663074 -122.458788296392 (37.7128233663074, -122.458788296392)
9777 88104 1 16 1247 46th Ave   1 1 1   06/30/2008 12:00:00 AM   4x10 Permit Number 51108 5981754.7 2106590.8 37.763238693975296 -122.50630313344999 (37.7632386939753, -122.50630313345)
9790 104876 4 227 2478 43rd Ave   5 1 1   12/28/2016 12:00:00 AM 3   Permit Number 778928 5983068.6 2098273.8 37.740479796641296 -122.50114367627701 (37.7404797966413, -122.501143676277)
9962 173753 2 5 1140 Lawton St   1 1 1       3x3   5990653.0 2104548.0 37.7581495573033 -122.475378025252 (37.7581495573033, -122.475378025252)
10029 94465 1 62 4128 17th St   1 1 1     7 5x6 Permit Number 779215 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
10086 88538 2 109 1306 York St   5 1 1   06/26/2009 12:00:00 AM   3x12 Permit Number 52223 6010027.5 2101589.4 37.7511299031436 -122.40816367021999 (37.7511299031436, -122.40816367022)
10162 173888 2 5 2 Vasquez Ave   1 1 1       3x3   5995783.0 2100209.0 37.7465317821399 -122.457322486502 (37.7465317821399, -122.457322486502)
10220 173929 2 11 95 High St   1 1 1       3x3   5999870.0 2100717.0 37.7481605193068 -122.443226610241 (37.7481605193068, -122.443226610241)
10258 173932 2 1 1109x Alemany Blvd   1 1 1       3x3   6003491.0 2094313.0 37.7307824159859 -122.430248501015 (37.7307824159859, -122.430248501015)
11086 96178 1 268     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767810          
11627 88529 1 12     1 1 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51479          
12440 100166 7 218 2340 Twin Peaks Blvd   7 1 1         Permit Number 769026          
13297 173883 2 17 127 Holloway Ave   1 1 1   02/23/2017 12:00:00 AM 3 3x3 Permit Number 779596 5996444.0 2091166.0 37.721739833175 -122.454383721237 (37.721739833175, -122.454383721237)
13429 96174 1 281     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767807          
14101 96173 1 116     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767806          
15678 96177 1 293     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767810          
15720 96179 1 251     20 1 1       3x3 Permit Number 767811          
15790 87061 1 40     19 1 1       3x3 Permit Number 50003          
16457 93053 1 105     7 1 1   04/28/2010 12:00:00 AM 36   Permit Number 53387          
16511 96175 1 281     20 1 1   04/04/2011 12:00:00 AM   3x3 Permit Number 767808          
18196 108832 1 12 60 Ney St   1 1 1 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774659 6003833.887 2093995.50335 37.7299300570357 -122.429040457944 (37.7299300570357, -122.429040457944)
18642 106966 2 17 2391 47TH AVE   1 1 1           5981720.8 2098834.4 37.7419398125124 -122.505845312535 (37.7419398125124, -122.505845312535)
18677 88330 1 131 544 London St   1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51318 6001416.8 2090660.3 37.720635228492206 -122.437157897339 (37.7206352284922, -122.437157897339)
18679 86291 3 50 1339 25th Ave   1 1 2   12/05/2006 12:00:00 AM 3 3x3   5988318.888394 2106196.850699 37.7625412799726 -122.483571174333 (37.7625412799726, -122.483571174333)
18682 87286 1 12 1272 42nd Ave   9 1 1   03/18/2007 12:00:00 AM     Permit Number 50303 5983096.8 2106514.6 37.7631083916796 -122.501655692289 (37.7631083916796, -122.501655692289)
18733 88323 1 88 125 Lisbon St   1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51312 6003417.0 2092629.0 37.7261543381556 -122.430384225952 (37.7261543381556, -122.430384225952)
18879 94134 1 18 18 Nebraska St   1 1 1   06/11/2010 12:00:00 AM   3x3 Permit Number 53498 6009291.0 2097948.0 37.7410901551317 -122.41045347697501 (37.7410901551317, -122.410453476975)
18892 116488 2 5 2149 LYON ST   1 1 1       3x3   5999319.0 2116238.0 37.7907458271484 -122.446248274058 (37.7907458271484, -122.446248274058)
19027 97174 6 37 26 Gilbert St   5 1 1 1         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458)
19054 94934 6 311 2451X Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
19238 104509 2 2 80 DICHIERA CT   2 1 1     14     5998620.0 2088043.0 37.7132893442667 -122.446637305723 (37.7132893442667, -122.446637305723)
19350 95161 6 175 2721 Pacific Ave   7 1 1         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252)
19413 106117 1 44 405 Lisbon St   1 1 1   03/24/2014 12:00:00 AM   3x3 Permit Number 772749 6002458.5 2091056.7 37.721782813937395 -122.433585385445 (37.7217828139374, -122.433585385445)
19424 87790 1 313 635 Buena Vista West Ave   1 1 1   05/31/2008 12:00:00 AM     Permit Number 50531 5999771.0 2107673.0 37.7672543384354 -122.44406869049699 (37.7672543384354, -122.444068690497)
19560 103375 2 39 22 VANDEWATER ST   1 1 1       2.5x2.5 Permit Number 770057 6009069.0 2121391.0 37.8054466905223 -122.41287812458401 (37.8054466905223, -122.412878124584)
19599 106501 2 17 1266 09TH AVE   1 1 1       3x6   5993358.0 2106830.8 37.764573953722 -122.46618893715001 (37.764573953722, -122.46618893715)
19638 88554 1 12 579 16th Ave   1 1 1   07/24/2008 12:00:00 AM   3x3 Permit Number 51499 5990911.3 2111462.4 37.777149603591496 -122.474989443149 (37.7771496035915, -122.474989443149)
19648 88109 1 8 1305 48th Ave   1 1 1   07/01/2008 12:00:00 AM   3x3 Permit Number 51113 5981150.4 2106141.9 37.7619705488895 -122.50835984594299 (37.7619705488895, -122.508359845943)
19781 96412 6 175 185 Chilton Ave   7 1 1   05/18/2011 12:00:00 AM     Permit Number 767805 6001587.1 2095138.7 37.732941575251004 -122.436889661497 (37.732941575251, -122.436889661497)
19801 94573 1 52 3978 18th St   1 1 1 1 09/20/2010 12:00:00 AM   3x3 Permit Number 53752 6003116.0 2105363.0 37.761101890414 -122.432333828196 (37.761101890414, -122.432333828196)
20263 91677 3 131 599 South Van Ness Ave   1 1 2   03/01/2007 12:00:00 AM 3 3x3   6007489.042117 2106191.6259580003 37.763624095672895 -122.417268041752 (37.7636240956729, -122.417268041752)
20297 87411 3 11 898X Ellis St   1 1 2   04/22/2008 12:00:00 AM 3 3x3   6006570.640875 2113589.260791 37.783884515657896 -122.42096977598499 (37.7838845156579, -122.420969775985)
20384 104821 2 43 2173 15TH ST   1 1 1     20     6003063.7 2107068.1 37.7657807169148 -122.43263651234301 (37.7657807169148, -122.432636512343)
20472 89331 1 48 4658 18th St   1 1 1   12/31/2008 12:00:00 AM   3x3 Permit Number 51984 6000201.0 2105201.0 37.760491360371596 -122.4424038966 (37.7604913603716, -122.4424038966)
20985 87685 1 46 118 Virginia Ave   1 1 1   05/23/2008 12:00:00 AM   4x4 Permit Number 776560 6006594.8 2098480.6 37.7424010366351 -122.419813761733 (37.7424010366351, -122.419813761733)
21199 97237 7 41 125 Excelsior Ave   9 1 4 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
21236 92078 1 18 1151 Sutter St   1 1 1   06/22/2009 12:00:00 AM   3x3 Permit Number 52192 6007083.0 2115004.0 37.7877979108835 -122.41929759225799 (37.7877979108835, -122.419297592258)
28196 88382 1 88 355 17th Ave   1 1 1   07/10/2008 12:00:00 AM 2 3x3 Permit Number 51360 5990561.77007 2113010.94096 37.7813812065074 -122.476311706446 (37.7813812065074, -122.476311706446)
29641 89003 1 2 658 40th Ave   1 1 1   09/25/2008 12:00:00 AM 5 3x3 Permit Number 51755 5983531.7658 2111325.68873 37.7763438006114 -122.50050706598 (37.7763438006114, -122.50050706598)
30135 105475 2 17 671 Waller St   1 1 1   01/29/2014 12:00:00 AM   3x3   6002476.36422 2108834.33955 37.770597051265604 -122.434794296397 (37.7705970512656, -122.434794296397)
30542 86751 1 17 81 Parker Ave   1 1 1   10/03/2007 12:00:00 AM     Permit Number 49713 5996801.8 2114038.7 37.7845630578844 -122.454798641129 (37.7845630578844, -122.454798641129)
30941 88552 1 82 649 15th Ave   1 1 1   07/24/2008 12:00:00 AM 3 3x3 Permit Number 51497 5991271.5415199995 2111000.35442 37.7759018234336 -122.473709552083 (37.7759018234336, -122.473709552083)
32417 105247 2 25 1301X COLE ST   1 1 1     15 4x 5   5998246.0 2105821.0 37.7620821004846 -122.44920998148999 (37.7620821004846, -122.44920998149)
33525 88586 1 12 815 24th Ave   1 1 1   07/31/2008 12:00:00 AM 4 3x3 Permit Number 51529 5988483.68185 2110405.40991 37.7741064155227 -122.483309739734 (37.7741064155227, -122.483309739734)
34103 88390 1 12 258 22nd Ave   1 1 1   07/10/2008 12:00:00 AM 6 3x3 Permit Number 51368 5989033.92216 2113597.32101 37.7829025195026 -122.48164021539301 (37.7829025195026, -122.481640215393)
34436 88394 1 48 139 25th Ave   1 1 1   07/10/2008 12:00:00 AM 1 3x3 Permit Number 51373 5988000.05712 2115038.19323 37.78679857243979 -122.485322676521 (37.7867985724398, -122.485322676521)
35131 88579 1 37 767 19th Ave   1 1 1   07/31/2008 12:00:00 AM 4 3x3 Permit Number 51519 5990042.4275400005 2110151.2798 37.773499236106204 -122.477899243352 (37.7734992361062, -122.477899243352)
37397 91640 3 131 1427 South Van Ness Ave   1 1 2   03/01/2007 12:00:00 AM 8 3x3   6007757.588641 2101343.9238919998 37.7503285203588 -122.415995902486 (37.7503285203588, -122.415995902486)
37400 88728 1 49 68 Pontiac St   1 1 1   08/11/2008 12:00:00 AM   3x3 Permit Number 51663 6010467.8 2117974.1 37.7961431384766 -122.407796278381 (37.7961431384766, -122.407796278381)
40011 88560 1 84 2901 Pierce St   1 1 1   07/24/2008 12:00:00 AM   3x3 Permit Number 51505 6001501.0 2118350.0 37.7966692015857 -122.43885009322901 (37.7966692015857, -122.438850093229)
40857 124637 3 53 124 Arguello Blvd   1 1 2     31 Width 5ft   5995537.16304 2115311.02189 37.787983889154205 -122.459265995172 (37.7879838891542, -122.459265995172)
41693 91420 1 18 770 18th Ave   1 1 1   04/08/2009 12:00:00 AM 5 3x3 Permit Number 52101 5990400.3408699995 2110139.21584 37.7734868781795 -122.47666030039301 (37.7734868781795, -122.476660300393)
41811 108815 1 88 474 Munich St   1 1 1 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774652 6003779.44726 2089723.3814299998 37.7181966752665 -122.42892420414499 (37.7181966752665, -122.428924204145)
42748 89044 1 82 44 Surrey St   1 1 1       3x3 Permit Number 51783 6002618.0 2096049.0 37.735499589249294 -122.433390603486 (37.7354995892493, -122.433390603486)
42981 106868 2 17 1956 GREAT HWY   5 1 1           5981193.7 2101737.6 37.749880147789895 -122.507883225183 (37.7498801477899, -122.507883225183)
43173 112929 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
44829 94949 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
45347 108716 1 58 201 Randall St   1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773302 6004213.21698 2097517.4141599997 37.73962189424871 -122.427979939698 (37.7396218942487, -122.427979939698)
46076 88557 1 12 731 16th Ave   1 1 1   07/24/2008 12:00:00 AM 8 3x3 Permit Number 51502 5990963.88297 2110397.4755 37.7742286595499 -122.474729799279 (37.7742286595499, -122.474729799279)
Powered by Datasette · Query took 138.206ms · Data source: data.sfgov.org