sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
74 188665 3 5 2175X Palou Ave 1 1 1 2     37     6011669.71313 2097723.45025 37.740606653987705 -122.402212916691 (37.7406066539877, -122.402212916691)
104 251210 3 39 1170 Ingalls St 2 1 1 2   11/02/1992 12:00:00 AM                
197 251245 3 60 701 Chenery St 1 1 1 2   06/04/1992 12:00:00 AM       6002463.96916 2095671.24377 37.73445361741221 -122.433896153002 (37.7344536174122, -122.433896153002)
479 85531 3 49 101X 12th St 3 1 1 2   05/29/2007 12:00:00 AM 6     6007317.968280001 2109362.68703 37.7723214572932 -122.418084555959 (37.7723214572932, -122.418084555959)
487 85532 3 9 101X 12th St 4 1 1 2   05/29/2007 12:00:00 AM 6     6007270.64018 2109417.23244 37.7724685621036 -122.418252136526 (37.7724685621036, -122.418252136526)
497 14419 3 2 2X Masonic Ave 7 11 1 2     35     5998835.1676 2113089.5942 37.7820734871416 -122.447695558807 (37.7820734871416, -122.447695558807)
501 251171 3 11 201X Cargo Way 37 1 1 2   04/10/2017 11:21:00 AM 3              
731 251375 3 47 401 Portola Dr 3 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
747 251378 3 47 401 Portola Dr 6 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
749 251374 3 47 401 Portola Dr 2 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
757 251377 3 47 401 Portola Dr 5 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
763 251373 3 47 401 Portola Dr 1 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
764 251379 3 47 401 Portola Dr 7 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
785 251376 3 47 401 Portola Dr 4 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
794 212187 3 60 720 Bosworth St 1 9 1 2     16     6002096.28779 2095466.30888 37.733870041163 -122.435152693763 (37.733870041163, -122.435152693763)
796 212189 3 60 720 Bosworth St 3 9 1 2     16     6002068.0773599995 2095471.6867 37.7338832054473 -122.435250610137 (37.7338832054473, -122.435250610137)
797 212191 3 60 720 Bosworth St 5 9 1 2     16     6002043.865019999 2095478.6742 37.7339010165159 -122.435334819059 (37.7339010165159, -122.435334819059)
801 212193 3 60 720 Bosworth St 7 9 1 2     14     6002021.19403 2095482.3719 37.7339098820273 -122.43541346386002 (37.7339098820273, -122.43541346386)
870 117001 3 54 1X Bernal Heights Blvd 1 7 1 2                    
1023 24311 3 15 2639 Hyde St 2 1 1 2     20     6006902.669840001 2121389.92308 37.8053218972443 -122.420374939461 (37.8053218972443, -122.420374939461)
1098 251438 3 47 2501X Santiago St 1 3 1 2                    
1177 251471 3 137 2423 Market St 1 7 1 2                    
1183 119797 3 46 201x Octavia St 5 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1185 119832 3 46 301x Octavia St 5 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1187 119794 3 46 201x Octavia St 2 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1189 119798 3 46 201x Octavia St 6 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1191 119838 3 46 301x Octavia St 11 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1192 119753 3 46 101x Octavia St 8 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1194 119795 3 46 201x Octavia St 3 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1196 119750 3 46 101x Octavia St 5 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1199 119799 3 46 201x Octavia St 7 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1201 119839 3 46 301x Octavia St 12 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1202 119754 3 46 101x Octavia St 9 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1203 119796 3 46 201x Octavia St 4 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1204 119749 3 46 101x Octavia St 4 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1206 119801 3 46 201x Octavia St 9 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1207 119793 3 46 201x Octavia St 1 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1208 119803 3 46 201x Octavia St 11 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1209 119800 3 46 201x Octavia St 8 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1211 119836 3 46 301x Octavia St 9 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1212 119828 3 46 301x Octavia St 1 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1213 119747 3 46 101x Octavia St 2 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1219 119829 3 46 301x Octavia St 2 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1222 119837 3 46 301x Octavia St 10 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1223 119752 3 46 101x Octavia St 7 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1226 119830 3 46 301x Octavia St 3 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1227 119736 3 46 101x Octavia St 1 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1228 119831 3 46 301x Octavia St 4 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1230 119834 3 46 301x Octavia St 7 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1231 119833 3 46 301x Octavia St 6 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1233 119757 3 46 101x Octavia St 12 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1234 119748 3 46 101x Octavia St 3 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1235 119756 3 46 101x Octavia St 11 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1272 251489 3 3 900 Bosworth St 31 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1277 212203 3 60 920 Bosworth St 2 9 1 2     16     6001598.82808 2095593.8833700002 37.7341920703926 -122.436881688932 (37.7341920703926, -122.436881688932)
1282 251482 3 3 900 Bosworth St 1 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1283 251493 3 3 900 Bosworth St 35 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1286 251492 3 3 900 Bosworth St 34 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1288 251487 3 3 900 Bosworth St 29 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1290 251486 3 3 900 Bosworth St 28 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1295 251491 3 3 900 Bosworth St 33 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1298 251490 3 3 900 Bosworth St 32 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1299 251494 3 3 900 Bosworth St 36 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1307 212207 3 60 920 Bosworth St 8 9 1 2     11     6001467.5944 2095628.72955 37.7342802902926 -122.43733789885 (37.7342802902926, -122.43733789885)
1316 251488 3 3 900 Bosworth St 30 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1320 251503 3 143 800X Bosworth St 15 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1322 251483 3 3 900 Bosworth St 8 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1324 251501 3 143 800X Bosworth St 13 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1326 251502 3 143 800X Bosworth St 14 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1332 251484 3 3 900 Bosworth St 7 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1335 251499 3 143 800X Bosworth St 11 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1338 251485 3 3 900 Bosworth St 6 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1341 251498 3 143 800X Bosworth St 10 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1348 251500 3 143 800X Bosworth St 12 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1355 29680 3 11 1900X Van Ness Ave 3 11 1 2     3     6006072.343230001 2117086.04016 37.7934577026643 -122.422942314134 (37.7934577026643, -122.422942314134)
1392 29683 3 11 1900X Van Ness Ave 6 11 1 2   02/11/2012 12:00:00 AM 5     6006051.34304 2117188.93929 37.793739052873704 -122.423022293545 (37.7937390528737, -122.423022293545)
1529 251578 3 62 1000X Columbus Ave 6 11 1 2                    
1582 45051 3 37 2243 26th Ave 1 1 1 1 1 05/08/2001 12:00:00 AM 3   Permit Number 43936 5988218.295 2100043.5647 37.7456401553342 -122.483467967859 (37.7456401553342, -122.483467967859)
1703 29682 3 11 1900X Van Ness Ave 5 11 1 2     3     6006057.50051 2117137.8264200003 37.7935990572132 -122.422997353566 (37.7935990572132, -122.422997353566)
1796 29783 3 11 2000X Van Ness Ave 4 11 1 2   04/18/2008 12:00:00 AM 3     6006016.33701 2117432.70817 37.794406405577 -122.423160753176 (37.794406405577, -122.423160753176)
1822 251717 3 47 1000X San Jose Ave 1 7 1 2           6004710.0 2096486.0 37.736817957153605 -122.426188866367 (37.7368179571536, -122.426188866367)
1982 118349 3 109 100X Guerrero St 4 11 1 2   07/15/2016 06:43:00 AM 3              
2168 118346 3 109 100X Guerrero St 1 11 1 2   07/15/2016 05:47:00 AM 3              
2179 252925 3 71 700 Sanchez St 2 7 1 2           6003672.0 2104202.0 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181)
2186 252924 3 47 700 Sanchez St 1 7 1 2           6003672.0 2104202.0 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181)
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)
2219 122754 3 55 693 Vermont St 4 1 1 4 2   16     6011277.363419999 2105334.1858 37.761482160689894 -122.404105006665 (37.7614821606899, -122.404105006665)
2223 43305 3 94 693 Vermont St 10 1 1 4 2 07/12/2000 12:00:00 AM 6   Permit Number 43072 6011285.67007 2105193.27319 37.7610957103087 -122.4040663601 (37.7610957103087, -122.4040663601)
2229 43306 3 133 693 Vermont St 12 1 1 4 2 07/12/2000 12:00:00 AM 22   Permit Number 43072 6011289.47877 2105149.93268 37.7609769197604 -122.404050137204 (37.7609769197604, -122.404050137204)
2231 122750 3 94 693 Vermont St 8 1 1 4 2   9     6011285.1392 2105241.4016400003 37.761227830607204 -122.40407158333299 (37.7612278306072, -122.404071583333)
2232 122753 3 13 693 Vermont St 5 1 1 4 2   15     6011277.810190001 2105311.62173 37.7614202297665 -122.404101873421 (37.7614202297665, -122.404101873421)
2233 122749 3 94 693 Vermont St 9 1 1 4 2   5     6011285.506709999 2105214.92948 37.761155164510605 -122.404068449214 (37.7611551645106, -122.404068449214)
2240 122755 3 55 693 Vermont St 3 1 1 4 2   14     6011274.22678 2105356.76628 37.7615439863765 -122.40411744427601 (37.7615439863765, -122.404117444276)
2333 253025 3 51 1754 09th Ave 1 1 1 2   07/11/2017 12:00:00 AM 3     5993444.58369 2103545.63859 37.7555587516047 -122.465650780273 (37.7555587516047, -122.465650780273)
2581 107490 3 84 1306x Montgomery St 19 11 1 2     12     6011447.18476 2119974.7633599997 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963)
2766 118353 3 109 100X Guerrero St 8 11 1 2   07/15/2016 05:58:00 AM 3              
3111 118355 3 109 100X Guerrero St 10 11 1 2   07/15/2016 06:48:00 AM 3              
3394 118348 3 109 100X Guerrero St 3 11 1 2   07/15/2016 06:19:00 AM 3              
3436 100973 3 26 450X Chestnut St 5 1 1 4 4   0   Permit Number 37341 6009614.0 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823)
3500 13943 3 15 1101 Market St 2 1 1 2     12   Permit Number 780155 6008953.3362 2112197.3558 37.780196698058894 -122.412628072717 (37.7801966980589, -122.412628072717)
3586 253468 3 213 801X Alemany Blvd 1 17 1 2                    
Powered by Datasette · Query took 68.691ms · Data source: data.sfgov.org