sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
127 18052 3 46 2840 Pine St 2 1 1 2     18 3X3   6000317.799 2114808.7133 37.7868783690408 -122.442689819484 (37.7868783690408, -122.442689819484)
189 138807 3 46 2355 PINE ST 3 1 1 2     13 Width 0ft   6002661.6347 2115086.2451 37.7877737339769 -122.434600550462 (37.7877737339769, -122.434600550462)
194 138802 1 46 2375 PINE ST 3 1 1 1     12 Width 0ft   6002539.8455 2115065.9469 37.787711085766894 -122.435020465254 (37.7877110857669, -122.435020465254)
207 138805 3 46 2355 PINE ST 1 1 1 2     11 Width 0ft   6002622.3069 2115079.2676 37.787752342886 -122.434736117903 (37.787752342886, -122.434736117903)
219 138804 3 46 2375 PINE ST 5 1 1 2     1 Width 0ft   6002587.4194 2115073.5588 37.787734687268795 -122.43485641346001 (37.7877346872688, -122.43485641346)
225 138808 3 46 2355 PINE ST 4 1 1 2   06/06/2015 11:29:00 AM 5 Width 0ft   6002680.0299 2115089.4167 37.787783486631206 -122.434537133485 (37.7877834866312, -122.434537133485)
229 138803 1 46 2375 PINE ST 4 1 1 1     10 Width 0ft   6002563.9496 2115068.4842 37.787719421164496 -122.434937251329 (37.7877194211645, -122.434937251329)
333 242579 2 46 818 Douglass St 1 1 1 1   06/30/2016 12:00:00 AM 11 Width 3ft Permit Number 778239 6001257.943419999 2101462.97247 37.7502878270446 -122.438480597209 (37.7502878270446, -122.438480597209)
459 35612 1 46 2839 Pacific Ave 1 1 1 1   05/11/2012 12:00:00 AM 5 3x3 Permit Number 768882 6000549.03074 2116799.12347 37.792356695946005 -122.442032735847 (37.792356695946, -122.442032735847)
555 242524 3 46 1902 Folsom St 1 1 1 2   05/21/2007 12:00:00 AM 7 Width 2ft   6008008.060219999 2107332.79337 37.7667866624906 -122.415553715331 (37.7667866624906, -122.415553715331)
583 7548 1 46 2882 Folsom St 1 1 1 1     60 5x5   6008321.80095 2101666.80438 37.751246783135 -122.414067651319 (37.751246783135, -122.414067651319)
625 242532 3 46 2140 Folsom St 1 1 1 2   05/21/2007 12:00:00 AM 7 Width 3ft   6008084.96302 2105937.52751 37.7629599086871 -122.41518894402 (37.7629599086871, -122.41518894402)
849 93578 1 46 401X Francisco St 1 1 1 1   05/06/2010 12:00:00 AM 1 3x3 Permit Number 53401 6009309.6837 2121148.6264 37.8047947000965 -122.41202806393 (37.8047947000965, -122.41202806393)
865 142552 2 46 401 FRANCISCO ST 2 1 1 1     3 Width 0ft   6009334.5084 2121154.0569 37.804811003675105 -122.411942539139 (37.8048110036751, -122.411942539139)
977 242613 4 46 48 Winfield St 1 1 1 1     11 3x3 Permit Number 777782 6007306.44134 2099195.30791 37.744403529591395 -122.417403753004 (37.7444035295914, -122.417403753004)
1003 14837 3 46 1306 McAllister St 1 1 1 2   04/10/2011 12:00:00 AM 3 3x3   6002857.7118 2111688.5769 37.7784557229826 -122.43367923622401 (37.7784557229826, -122.433679236224)
1166 251466 2 46 129 Hyde St 2 1 1 1       3x3   6008072.0 2112894.0 37.782060012266896 -122.415726368353 (37.7820600122669, -122.415726368353)
1178 251465 2 46 129 Hyde St 1 1 1 1       3x3   6008072.0 2112894.0 37.782060012266896 -122.415726368353 (37.7820600122669, -122.415726368353)
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)
1241 242526 3 46 1922 Folsom St 1 1 1 2   05/21/2007 12:00:00 AM 7 Width 2ft   6008013.77103 2107241.1183 37.7665352651235 -122.415527471335 (37.7665352651235, -122.415527471335)
1243 242621 3 46 3274 Folsom St 2 1 1 2     20 Width 3ft   6008442.97152 2099602.35151 37.745585061615294 -122.413502636934 (37.7455850616153, -122.413502636934)
1266 242525 3 46 1916 Folsom St 1 1 1 2   05/21/2007 12:00:00 AM 7 Width 2ft   6008012.49588 2107266.03409 37.7666036064 -122.415533646066 (37.7666036064, -122.415533646066)
1270 18055 3 46 2872 Pine St 1 1 1 2     12 3X3   6000192.328 2114789.41 37.786818213822706 -122.443122531996 (37.7868182138227, -122.443122531996)
1395 251525 4 46 173 Sanchez St 8 1 1 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1525 251581 2 46 600 37th Ave 1 1 1 1       3x3   5984701.0 2111577.0 37.777102396300705 -122.496480968893 (37.7771023963007, -122.496480968893)
2076 14859 3 46 1368 McAllister St 1 1 1 2   04/10/2011 12:00:00 AM 3 3x3   6002639.2367 2111656.2394 37.7783545332764 -122.434432710417 (37.7783545332764, -122.434432710417)
2483 201850 2 46 911 Folsom St 1 1 1 1     5 Width 0ft   6011602.0 2112119.0 37.7801298483764 -122.403459565618 (37.7801298483764, -122.403459565618)
2504 55970 1 46 1246 Sacramento St 1 1 1 1   07/17/2017 12:00:00 AM 3   Permit Number 12041 6008815.91632 2116679.9939099997 37.7924972267216 -122.413420580993 (37.7924972267216, -122.413420580993)
2748 30802 1 46 109 Chilton Ave 1 1 1 1 1 02/06/1995 12:00:00 AM 10 4x6 Permit Number 34667 6001649.83524 2095450.8302099998 37.733802178321 -122.43669510478998 (37.733802178321, -122.43669510479)
2753 198672 2 46 193 Russ St 2 1 1 1   08/02/2017 12:00:00 AM 3 Width 4ft   6010593.523440001 2111314.08538 37.777863361242105 -122.406891615375 (37.7778633612421, -122.406891615375)
2806 18057 3 46 2882 Pine St 1 1 1 2     16 3X3   6000155.2064 2114785.6979 37.7868059046739 -122.443250696948 (37.7868059046739, -122.443250696948)
3289 253392 4 46 115 Steuart St 1 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3293 253393 4 46 115 Steuart St 2 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3316 253394 4 46 115 Steuart St 3 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3363 7526 1 46 2808 Folsom St 1 1 1 1   05/08/2004 12:00:00 AM 3 3x3   6008303.39209 2102027.1918 37.7522352918412 -122.414156805597 (37.7522352918412, -122.414156805597)
3378 242510 2 46 2808 Folsom St 2 1 1 1     14 Width 4ft   6008305.34942 2102000.42568 37.75216190805129 -122.41414814334 (37.7521619080513, -122.41414814334)
3384 242759 1 46 99 Ord St 2 1 1 1     15 Width 3ft   6000876.8584 2105865.2464 37.7623537170769 -122.440114051125 (37.7623537170769, -122.440114051125)
3612 18039 1 46 2813 Pine St 1 1 1 1     18 3X3   6000314.1463 2114749.1203 37.7867145338964 -122.442698176369 (37.7867145338964, -122.442698176369)
3831 30286 1 46 1355 Taylor St 2 1 1 1   07/06/1956 12:00:00 AM 10   Permit Number 132 6008896.76565 2117570.49119 37.794946853168604 -122.41320383718599 (37.7949468531686, -122.413203837186)
4036 242541 3 46 2430 Folsom St 1 1 1 2   05/22/2007 12:00:00 AM 5 Width 4ft   6008178.84704 2104258.05912 37.758353750252105 -122.41474536781901 (37.7583537502521, -122.414745367819)
4237 14843 3 46 1320 McAllister St 1 1 1 2   04/10/2011 12:00:00 AM 3 3x3   6002817.8815 2111683.4502 37.7784393862348 -122.433816657579 (37.7784393862348, -122.433816657579)
4598 18015 3 46 2712 Pine St 1 1 1 2     12 3X3   6000819.3499 2114877.5272 37.7870958927498 -122.44095951208901 (37.7870958927498, -122.440959512089)
4811 17931 3 46 2416 Pine St 1 1 1 2     18 5x6   6002234.6053 2115077.8001 37.7877262951282 -122.43607738468398 (37.7877262951282, -122.436077384684)
5079 137895 2 46 1944 BUCHANAN ST 1 1 1 1   11/06/2017 12:00:00 AM 3 Width 0ft   6003925.565 2115178.3301 37.788098246385395 -122.430234163647 (37.7880982463854, -122.430234163647)
5180 17545 1 46 543 Persia Ave 2 1 1 1     50 3X3   6003118.2023599995 2090743.3942599997 37.7209599548222 -122.431282614218 (37.7209599548222, -122.431282614218)
5186 180527 2 46 543 Persia Ave 1 1 1 1     16 Width 2ft   6003103.45709 2090752.9991099997 37.720985491961 -122.43133426946301 (37.720985491961, -122.431334269463)
5219 242740 1 46 4081 17th St 1 1 1 1   02/04/2005 12:00:00 AM 5 Width 2ft Permit Number 47860 6001797.68474 2105832.52045 37.7623162396305 -122.43692691855 (37.7623162396305, -122.43692691855)
5267 62038 1 46 2015 Divisadero St 1 1 1 1   01/14/2015 12:00:00 AM 3   Permit Number 773957 6000922.27992 2115385.7995599997 37.788497339028204 -122.440639868553 (37.7884973390282, -122.440639868553)
5698 17917 3 46 2370 Pine St 1 1 1 2     18 3X3   6002602.4145 2115123.2744 37.7878720449725 -122.43480808996 (37.7878720449725, -122.43480808996)
6048 14856 3 46 1360 McAllister St 1 1 1 2   04/10/2011 12:00:00 AM 3 3x3   6002668.0249 2111660.9717 37.7783691610679 -122.434333459849 (37.7783691610679, -122.434333459849)
6069 17933 3 46 2418 Pine St 2 1 1 2     18 3x3   6002186.7609 2115068.0006 37.7876966699691 -122.43624221533301 (37.7876966699691, -122.436242215333)
6092 46303 1 46   3 1 1 1   01/31/2002 12:00:00 AM     Permit Number 44564          
6216 18017 3 46 2713 Pine St 1 1 1 2     12 3X3   6000875.2767 2114835.3915 37.786983384155505 -122.440762994582 (37.7869833841555, -122.440762994582)
6355 12261 1 46 624 Laguna St 1 1 1 1   03/10/2000 12:00:00 AM 3 3X3   6004982.9117 2111116.4652 37.7770052022278 -122.426286620749 (37.7770052022278, -122.426286620749)
6566 2631 1 46 1884 Bush St 2 1 1 1     12 3X3   6004489.1648 2115039.2121 37.787748169652204 -122.428274287097 (37.7877481696522, -122.428274287097)
6867 18000 3 46 2670 Pine St 1 1 1 2     16 3X3   6001175.0601 2114930.6744 37.7872620743104 -122.43973264788299 (37.7872620743104, -122.439732647883)
6994 18053 1 46 2852 Pine St 1 1 1 1     18 3X3   6000250.2377 2114802.0314 37.7868561706627 -122.442923085267 (37.7868561706627, -122.442923085267)
7448 106350 2 46 1853 Scott St 1 1 1 1     14 3x3   6001488.8508 2114881.6293 37.7871452647326 -122.43864348553001 (37.7871452647326, -122.43864348553)
7478 46291 1 46   4 1 1 1   01/31/2002 12:00:00 AM     Permit Number 44564          
7539 18051 1 46 2840 Pine St 1 1 1 1   09/01/1999 12:00:00 AM 6 3X3PL   6000336.3598 2114811.683 37.786887581121704 -122.442625816895 (37.7868875811217, -122.442625816895)
7586 48883 1 46 1515 Baker St 1 1 1 1   11/21/2002 12:00:00 AM 4 5x4 Permit Number 46089 6000106.0163 2114246.8974 37.7853236932557 -122.44338216691901 (37.7853236932557, -122.443382166919)
7715 101523 2 46 2326 Filbert St 1 1 1 1     8 3x3   6001809.9749300005 2118762.85825 37.7978203759732 -122.43781055733801 (37.7978203759732, -122.437810557338)
7771 96366 1 46 1326 Green St 1 1 1 1     16 3x3   6006664.3237 2118739.81484 37.7980319387709 -122.421011488604 (37.7980319387709, -122.421011488604)
8034 17992 3 46 2619 Pine St 1 1 1 2   11/14/2012 12:00:00 AM 3 3X3   6001295.2434 2114888.6615 37.787153557687795 -122.439313827621 (37.7871535576878, -122.439313827621)
8226 18032 3 46 2801 Pine St 1 1 1 2     12 3X3   6000470.3136 2114777.4747 37.7868012889701 -122.44215991241501 (37.7868012889701, -122.442159912415)
8302 18045 1 46 2821 Pine St 1 1 1 1     18 3X3   6000216.4327 2114739.0872 37.786681414860894 -122.44303552029801 (37.7866814148609, -122.443035520298)
8354 14848 3 46 1341 McAllister St 1 1 1 2   04/10/2011 12:00:00 AM 3 3x3   6002736.8406 2111618.9725 37.778257747549894 -122.434092397831 (37.7782577475499, -122.434092397831)
8472 46875 1 46 1031 Pacific Ave 1 1 1 1 1 04/26/2002 12:00:00 AM 10 3x4 Permit Number 44938 6009178.55411 2118013.02984 37.7961777714378 -122.412260097639 (37.7961777714378, -122.412260097639)
8552 14851 3 46 1350 McAllister St 1 1 1 2   04/10/2011 12:00:00 AM 3 3x3   6002705.0947 2111666.0984 37.778385341741206 -122.434205588327 (37.7783853417412, -122.434205588327)
8639 18001 3 46 2673 Pine St 1 1 1 2     12 3X3   6001165.7528 2114873.8019 37.7871053873216 -122.439760770078 (37.7871053873216, -122.439760770078)
8667 6037 1 46 1822 Eddy St 2 1 1 1   10/31/2008 12:00:00 AM 3 3x3 Permit Number 51912 6001625.9468 2112554.8978 37.7807644518495 -122.43800243798 (37.7807644518495, -122.43800243798)
Powered by Datasette · Query took 2.485ms · Data source: data.sfgov.org