sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3 119263 3 3 495X Lakeshore Dr 1 3 1 2       10x30            
104 251210 3 39 1170 Ingalls St 2 1 1 2   11/02/1992 12:00:00 AM                
119 251215 3 43 175X Otis St 11 1 1 2       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.42011195674299 (37.7705111956623, -122.420111956743)
187 251248 3 60 829 Chenery St 1 1 1 2       3x3   6001839.0 2095802.0 37.7347771581377 -122.436066227259 (37.7347771581377, -122.436066227259)
196 251246 3 2 722X Mendell St 2 1 1 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
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)
222 251247 3 2 722X Mendell St 3 1 1 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
238 251251 3 63 321X Corbett Ave 2 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
239 251252 3 63 321X Corbett Ave 3 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
246 251253 3 21 1350 Howard St 3 1 1 2       3x3   6008544.9526 2110145.4696299997 37.774539777213995 -122.413895673958 (37.774539777214, -122.413895673958)
247 251250 3 63 321X Corbett Ave 1 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
344 251279 3 76 1200x Hudson Ave 8 1 1 2 3     3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
358 251286 3 20 1299x Hudson Ave 7 1 1 2 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
375 251284 3 20 1299x Hudson Ave 5 1 1 2 3 06/21/1996 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
385 251282 3 20 1299x Hudson Ave 1 1 1 2 3 04/07/2016 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
390 251276 3 37 1175X Hudson Ave 4 1 1 2 3 03/09/1998 12:00:00 AM   3x3   6017547.0 2094834.0 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626)
391 251275 3 37 1175x Hudson Ave 1 1 1 2 3 09/16/2011 12:00:00 AM   3x3   6017547.0 2094834.0 37.732999109091 -122.381690402626 (37.732999109091, -122.381690402626)
392 251280 3 20 1275x Hudson Ave 1 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
393 251277 3 76 1200x Hudson Ave 3 1 1 2 3 10/26/2011 12:00:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
398 251281 3 20 1275x Hudson Ave 4 1 1 2 3 03/23/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
402 251283 3 20 1299x Hudson Ave 9 1 1 2 3 06/06/1997 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
409 251278 3 76 1200x Hudson Ave 4 1 1 2 3 01/27/2016 09:31:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
410 251287 3 20 1299x Hudson Ave 8 1 1 2 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
445 251285 3 11 1299x Hudson Ave 2 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
626 251342 3 50 2275 Ocean Ave 2 1 1 2   11/14/1996 12:00:00 AM   3x3 Permit Number 37503 5992527.0 2093770.0 37.7286643609316 -122.46811297163299 (37.7286643609316, -122.468112971633)
628 251337 3 51 2230 Ocean Ave 1 1 1 2   04/26/1996 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
629 251338 3 51 2230 Ocean Ave 2 1 1 2   05/28/2012 12:00:00 AM   3x3   5992640.0 2093746.0 37.728604988221896 -122.46772058248399 (37.7286049882219, -122.467720582484)
674 251361 3 44 301 07th St 2 1 1 2       3x3   6010388.0 2110913.0 37.7767505721368 -122.40757431033701 (37.7767505721368, -122.407574310337)
709 251360 3 44 301 07th St 1 1 1 2   03/29/1991 12:00:00 AM   3x3   6010388.0 2110913.0 37.7767505721368 -122.40757431033701 (37.7767505721368, -122.407574310337)
731 251375 3 47 401 Portola Dr 3 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
746 251371 3 43 390 06th St 3 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
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)
750 251368 3 111 270 06th St 7 1 1 2 3     3x3   6010822.0 2111616.0 37.7787051302825 -122.40612250689199 (37.7787051302825, -122.406122506892)
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)
781 251370 3 44 390 06th St 2 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
785 251376 3 47 401 Portola Dr 4 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
786 251369 3 43 390 06th St 1 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
813 251390 3 60 800x Bosworth St 7 1 1 2       Width 3ft   6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
820 251223 3 12 80X Junipero Serra Blvd 22 1 1 2   01/18/2008 12:00:00 AM   Width 3ft   5991438.54417 2088636.90192 37.714507218415 -122.47150190860901 (37.714507218415, -122.471501908609)
821 251392 3 60 800x Bosworth St 9 5 1 2       Width 3ft   6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
844 251224 3 12 80X Junipero Serra Blvd 23 1 1 2   01/18/2008 12:00:00 AM   Width 3ft   5991438.54417 2088636.90192 37.714507218415 -122.47150190860901 (37.714507218415, -122.471501908609)
870 117001 3 54 1X Bernal Heights Blvd 1 7 1 2                    
881 251399 3 94 841 Columbus Ave 1 1 1 2       3x3   6008927.4869099995 2120274.72498 37.802373734427796 -122.413288863041 (37.8023737344278, -122.413288863041)
975 251421 3 15 300X King St 6 1 1 2 3 09/30/2014 01:37:00 PM   3x3   6014268.0 2110701.0 37.776384889187796 -122.394137287636 (37.7763848891878, -122.394137287636)
1048 251423 3 53 2162 Alemany Blvd 1 1 1 2       3x3   5999946.0 2089791.0 37.718164612456604 -122.44217960719999 (37.7181646124566, -122.4421796072)
1094 251442 3 37 2700x San Jose Ave 2 1 1 2   03/17/2006 12:00:00 AM   Width 3ft   5997075.0 2088509.0 37.7144804976148 -122.452010931306 (37.7144804976148, -122.452010931306)
1097 251443 3 37 2700x San Jose Ave 1 1 1 2   03/17/2006 12:00:00 AM   Width 3ft   5997075.0 2088509.0 37.7144804976148 -122.452010931306 (37.7144804976148, -122.452010931306)
1098 251438 3 47 2501X Santiago St 1 3 1 2                    
1101 251439 3 67 49X Eddy St   1 1 2       3x3   6010285.0 2113564.0 37.78402382830029 -122.408117626865 (37.7840238283003, -122.408117626865)
1141 251461 3 2 6400 Geary Blvd 1 1 1 2   10/01/1993 12:00:00 AM   3x3   5987191.0 2112582.0 37.7800074013317 -122.48794125088699 (37.7800074013317, -122.487941250887)
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)
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)
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)
Powered by Datasette · Query took 74.806ms · Data source: data.sfgov.org