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                    
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)
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              
3497 247942 4 58 29 Joy St 5 14 1 2     3   Permit Number 775404 6010292.72224 2098904.67919 37.7437730949632 -122.40705728398399 (37.7437730949632, -122.407057283984)
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)
3501 247943 4 22 29 Joy St 6 14 1 2     2   Permit Number 775404 6010304.2598 2098903.51059 37.7437705318851 -122.407017307297 (37.7437705318851, -122.407017307297)
3506 247939 4 180 29 Joy St 2 14 1 2     12   Permit Number 775404 6010258.299769999 2098917.5156900003 37.7438064148349 -122.40717721395 (37.7438064148349, -122.40717721395)
3510 247941 4 58 29 Joy St 4 14 1 2     5   Permit Number 775404 6010287.82636 2098909.7574 37.743786764646 -122.40707457072901 (37.743786764646, -122.407074570729)
3511 247940 4 58 29 Joy St 3 14 1 2     5   Permit Number 775404 6010280.31746 2098909.2881400003 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782)
3513 247938 4 16 29 Joy St 1 14 1 2     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056)
3537 102838 2 3 1101X Portola Dr 1 9 1 2                    
3586 253468 3 213 801X Alemany Blvd 1 17 1 2                    
3723 253167 3 12 1X Brotherhood Way 1 7 1 2                    
3794 29684 3 76 2000X Van Ness Ave 2 11 1 2     24     6006028.673359999 2117355.72849 37.7941957348865 -122.42311259358699 (37.7941957348865, -122.423112593587)
3898 212122 3 60 300x Miramar Ave 4 3 1 2     3     5995365.2918 2092257.6675200001 37.724675368963105 -122.45819147914699 (37.7246753689631, -122.458191479147)
Powered by Datasette · Query took 128.407ms · Data source: data.sfgov.org