sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3199 253365 1 35 1745 Buchanan St 1 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3209 253364 1 35 1741 Buchanan St 2 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3238 253363 1 35 1741 Buchanan St 1 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3194 253362 1 35 1737 Buchanan St 2 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3221 253361 1 35 1737 Buchanan St 1 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3215 253360 1 35 1723 Buchanan St 2 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3234 253359 1 35 1723 Buchanan St 1 1 1 1       Width 0ft   6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3224 253358 1 35 1715 Buchanan St 1 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3195 253357 1 35 1705 Buchanan St 5 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3205 253356 1 35 1705 Buchanan St 4 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3207 253355 1 35 1705 Buchanan St 3 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3242 253354 1 35 1705 Buchanan St 2 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3229 253353 1 35 1705 Buchanan St 1 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3200 253352 1 35 1756 Buchanan St 4 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3225 253351 1 35 1756 Buchanan St 3 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3244 253350 1 35 1756 Buchanan St 2 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3236 253349 1 35 1756 Buchanan St 1 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3197 253348 1 35 1728 Buchanan St 1 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3217 253347 1 35 1700 Buchanan St 5 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3246 253346 1 35 1700 Buchanan St 4 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
3233 253345 1 35 1700 Buchanan St 3 1 1 1   11/26/2003 12:00:00 AM   Width 0ft Permit Number 47204 6004027.1917 2114282.142 37.7856432950328 -122.429818605296 (37.7856432950328, -122.429818605296)
53803 250309 2 35 12 Redfield Aly 1 17 1 1     5 Width 0ft   6008474.46022 2119519.71704 37.800275226579 -122.414803097987 (37.800275226579, -122.414803097987)
183681 250308 2 35 10 Redfield Aly 1 13 1 1     4 Width 0ft   6008483.77451 2119506.40025 37.8002391853351 -122.41476992380801 (37.8002391853351, -122.414769923808)
52553 249684 2 35 2400 Baker St 16 7 1 1     5     5999742.6330699995 2117264.679 37.793589001891796 -122.44485636243 (37.7935890018918, -122.44485636243)
54903 249683 2 35 2400 Baker St 15 7 1 1     5     5999743.16478 2117253.42108 37.7935581209611 -122.44485371304701 (37.7935581209611, -122.444853713047)
188711 249682 2 35 2400 Baker St 14 7 1 1     5     5999744.1267099995 2117244.44172 37.7935335209065 -122.444849738942 (37.7935335209065, -122.444849738942)
68892 248602 2 35 462 Frederick St 2 1 1 1     2 Width 0ft   5997486.7154 2107468.2888 37.7665616787282 -122.451954890142 (37.7665616787282, -122.451954890142)
170059 248511 2 35 77 Downey St 1 1 1 1     1 Width 0ft   5998828.2482 2107822.9016 37.7676121046283 -122.447340309872 (37.7676121046283, -122.447340309872)
38829 248392 2 35 707 Cole St 1 1 1 1     10 Width 0ft   5997906.1336 2108119.2199 37.7683729841331 -122.450551136272 (37.7683729841331, -122.450551136272)
41728 247994 2 35 270 Peralta Ave 1 9 1 1     13 Width 3ft   6009740.549319999 2099529.50478 37.7454578138309 -122.409010652834 (37.7454578138309, -122.409010652834)
47048 247783 2 35 274 30th St 2 4 1 1     2 Width 3ft   6004785.28168 2098443.27058 37.7421964332069 -122.42606787825198 (37.7421964332069, -122.426067878252)
43246 247776 2 35 228 30th St 1 4 1 1     1 Width 3ft   6005091.07435 2098463.74529 37.7422699303121 -122.425011997728 (37.7422699303121, -122.425011997728)
25957 247414 2 35 971 Page St 4 1 1 1     2 Width 0ft   6001933.8006 2109433.5045 37.772211390909 -122.436713922993 (37.772211390909, -122.436713922993)
172750 247372 2 35 475 Scott St 1 1 1 1     2 Width 0ft   6002162.1125 2110097.0889 37.7740464011597 -122.43597166463002 (37.7740464011597, -122.43597166463)
69173 247371 2 35 485 Scott St 1 1 1 1     2 Width 0ft   6002156.5991 2110137.258 37.774156382291295 -122.435993611299 (37.7741563822913, -122.435993611299)
136440 247321 2 35 216 Pierce St 3 1 1 1     3 Width 0ft   6002799.395 2109324.8498 37.771962206126794 -122.433711993285 (37.7719622061268, -122.433711993285)
176835 247315 2 35 303 Steiner St 2 1 1 1     3 Width 0ft   6003239.3513 2109346.5826 37.7720468334568 -122.432191704953 (37.7720468334568, -122.432191704953)
155917 247314 2 35 303 Steiner St 1 1 1 1     2 Width 0ft   6003237.761 2109364.6049 37.7720962280958 -122.432198493214 (37.7720962280958, -122.432198493214)
50827 247304 2 35 247 Pierce St 1 1 1 1     2 Width 0ft   6002738.4372 2109472.2087 37.772363358196394 -122.433933385595 (37.7723633581964, -122.433933385595)
118173 247294 2 35 836 Haight St 1 1 1 1     5 Width 0ft   6002133.2487 2109156.7194 37.771462740402995 -122.436004206745 (37.771462740403, -122.436004206745)
1012 246499 2 35 311 Duncan St 1 1 1 1   04/27/2017 12:00:00 AM 3 Width 3ft Permit Number 779776 6004393.833380001 2099835.13521 37.7459960419019 -122.427520522551 (37.7459960419019, -122.427520522551)
173334 246299 2 35 380 Noe St 1 1 1 1     2 Width 0ft   6002916.9058 2106020.4516 37.762895802660296 -122.433069383163 (37.7628958026603, -122.433069383163)
167652 246225 2 35 1387 Masonic Ave 1 1 1 1     3 Width 0ft   5999540.3508 2107874.8368 37.7677953711537 -122.44488098038401 (37.7677953711537, -122.444880980384)
52490 246224 2 35 1382 Masonic Ave 1 1 1 1     2 Width 0ft   5999585.4723 2107870.9 37.767787136682294 -122.444724628037 (37.7677871366823, -122.444724628037)
153885 246222 2 35 1381 Masonic Ave 1 1 1 1     2 Width 0ft   5999537.3225 2107899.6688 37.7678633807549 -122.444893240119 (37.7678633807549, -122.444893240119)
187927 246220 2 35 1375 Masonic Ave 1 1 1 1     6 Width 0ft   5999535.8083 2107910.8735 37.767894059626606 -122.444899283084 (37.7678940596266, -122.444899283084)
181756 245991 2 35 1250 Waller St 4 1 1 1     1 Width 0ft   5999788.9734 2108484.4317 37.769483351344 -122.44406483418899 (37.769483351344, -122.444064834189)
172060 245955 2 35 450 Frederick St 1 1 1 1     2 Width 0ft   5997557.5774 2107478.8878 37.7665948394439 -122.45171055688999 (37.7665948394439, -122.45171055689)
174739 245934 2 35 83 Downey St 1 1 1 1     2 Width 0ft   5998834.6076 2107782.3225 37.7675010480684 -122.447315392636 (37.7675010480684, -122.447315392636)
184820 245887 2 35 204 Broderick St 2 1 1 1     5 Width 0ft   6001309.3147 2109461.0534 37.772251523616 -122.438876043486 (37.772251523616, -122.438876043486)
155982 245875 2 35 230 Broderick St 3 1 1 1     5 Width 0ft   6001285.051 2109638.8769 37.772738401980604 -122.438972719673 (37.7727384019806, -122.438972719673)
68326 245221 2 35 341 Laguna St 1 1 1 1     13 Width 0ft   6005088.7556 2110037.9678 37.7740498933785 -122.425843687227 (37.7740498933785, -122.425843687227)
26914 245213 2 35 1155 Page St 1 1 1 1     5 Width 0ft   6001001.539 2109303.6237 37.7718017456892 -122.439929374343 (37.7718017456892, -122.439929374343)
183435 245195 2 35 48 Baker St 1 1 1 1     10 Width 0ft   6000874.4772 2109202.1258 37.7715158240845 -122.440361608185 (37.7715158240845, -122.440361608185)
32011 245193 2 35 48 Baker St 2 1 1 1     3 Width 0ft   6000872.1204 2109220.0374 37.77156487066021 -122.44037104524901 (37.7715648706602, -122.440371045249)
32986 245166 2 35 1356 Page St 1 1 1 1     5 Width 0ft   6000067.3756 2109215.4243 37.771506350919296 -122.443154362685 (37.7715063509193, -122.443154362685)
25034 245135 2 35 108 Lyon St 1 1 1 1     5 Width 0ft   6000350.1465 2109371.4561 37.7719508943795 -122.442187448391 (37.7719508943795, -122.442187448391)
147043 245121 2 35 1226 Page St 1 1 1 1     6 Width 0ft   6000650.5369 2109296.0266 37.7717608989394 -122.441142965804 (37.7717608989394, -122.441142965804)
50138 245099 2 35 1116 Page St 1 1 1 1     6 Width 0ft   6001200.4602 2109374.4683 37.7720075888162 -122.43924637279899 (37.7720075888162, -122.439246372799)
45910 245066 2 35 26 Lyon St 1 1 1 1     6 Width 0ft   6000396.341 2109035.0297 37.771029784663206 -122.44200350656999 (37.7710297846632, -122.44200350657)
51623 245057 2 35 38 Lyon St 1 1 1 1     13 Width 0ft   6000389.8085 2109086.3569 37.7711703439937 -122.44202978741501 (37.7711703439937, -122.442029787415)
154712 245028 2 35 1267 Page St 1 1 1 1     5 Width 0ft   6000516.7427 2109233.4639 37.7715814955912 -122.441601276959 (37.7715814955912, -122.441601276959)
146378 245027 2 35 1255 Page St 2 1 1 1     6 Width 0ft   6000554.2196 2109238.2078 37.771596656285894 -122.44147198305201 (37.7715966562859, -122.441471983052)
70065 245026 2 35 1255 Page St 1 1 1 1     4 Width 0ft   6000539.9879 2109236.7846 37.771591937743295 -122.441521109042 (37.7715919377433, -122.441521109042)
158425 245019 2 35 1231 Page St 1 1 1 1     2 Width 0ft   6000585.055 2109242.4773 37.7716101359109 -122.441365628321 (37.7716101359109, -122.441365628321)
154517 245006 2 35 1201 Page St 4 1 1 1     7 Width 0ft   6000755.8359 2109268.0945 37.771690201724205 -122.440776726653 (37.7716902017242, -122.440776726653)
3398 245004 2 35 1201 Page St 2 1 1 1     6 Width 0ft   6000727.3724 2109263.3505 37.7716755548589 -122.44087484303499 (37.7716755548589, -122.440874843035)
3043 244994 1 35 231 Lily St 1 1 1 1   05/02/2002 12:00:00 AM 4 Width 0ft Permit Number 45013 6005396.3109 2110099.8972 37.774237312156295 -122.4247842062 (37.7742373121563, -122.4247842062)
147675 244992 2 35 249 Rose St 1 1 1 1     2 Width 0ft   6005441.5895 2109754.3822 37.773291168852204 -122.42460299610501 (37.7732911688522, -122.424602996105)
46789 244991 2 35 213 Lily St 3 1 1 1     9 Width 0ft   6005531.8427 2110116.9147 37.7742916920696 -122.424316587333 (37.7742916920696, -122.424316587333)
53665 244990 2 35 215 Lily St 2 1 1 1     6 Width 0ft   6005497.2001 2110113.2681 37.7742797231705 -122.42443616312299 (37.7742797231705, -122.424436163123)
59484 244989 2 35 217 Lily St 1 1 1 1     7 Width 0ft   6005482.6137 2110109.6215 37.7742688867804 -122.42448636075899 (37.7742688867804, -122.424486360759)
166121 244988 2 35 260 Rose St 2 1 1 1     2 Width 0ft   6005214.8927 2109749.52 37.7732650130646 -122.42538682585301 (37.7732650130646, -122.425386825853)
39710 244987 2 35 260 Rose St 1 1 1 1     3 Width 0ft   6005231.3024 2109750.7356 37.7732692779132 -122.425330148953 (37.7732692779132, -122.425330148953)
60303 244983 2 35 299 Rose St 2 1 1 1     2 Width 0ft   6005200.9141 2109719.1317 37.7731807843789 -122.425433016756 (37.7731807843789, -122.425433016756)
37946 244981 2 35 200 Laguna St 1 1 1 1     1 Width 0ft   6005180.5539 2109687.8318 37.7730936920725 -122.425501217452 (37.7730936920725, -122.425501217452)
189068 244980 2 35 289 Rose St 1 1 1 1     2 Width 0ft   6005226.4402 2109722.7783 37.7731922392405 -122.425344978098 (37.7731922392405, -122.425344978098)
30963 244972 2 35 209 Rose St 4 1 1 1     3 Width 0ft   6005534.5777 2109768.9686 37.7733364706745 -122.424282374507 (37.7733364706745, -122.424282374507)
72594 244969 2 35 215 Rose St 1 1 1 1     4 Width 0ft   6005489.602999999 2109760.4598 37.7733105679298 -122.424437343055 (37.7733105679298, -122.424437343055)
29296 244956 2 35 298 Laguna St 1 1 1 1     1 Width 0ft   6005155.9394 2109820.0209 37.77345526051 -122.42559577205 (37.77345526051, -122.42559577205)
49526 244925 2 35 223 Lily St 2 1 1 1     2 Width 0ft   6005441.8933 2110105.3671 37.77425490559 -122.424626917474 (37.77425490559, -122.424626917474)
60283 244907 2 35 150 Central Ave 1 1 1 1     9 Width 0ft   5999911.6566 2109010.7372 37.7709354515424 -122.443678294205 (37.7709354515424, -122.443678294205)
42071 244906 2 35 31 Lyon St 2 1 1 1     6 Width 0ft   6000351.3383 2109052.958 37.7710764466514 -122.442160459028 (37.7710764466514, -122.442160459028)
169463 244904 2 35 151 Central Ave 1 1 1 1     1 Width 0ft   5999860.3433 2109070.0361 37.7710953445719 -122.44386004879101 (37.7710953445719, -122.443860048791)
37217 244897 2 35 39 Lyon St 1 1 1 1     7 Width 0ft   6000347.0687 2109078.5751 37.7711465414406 -122.442177066871 (37.7711465414406, -122.442177066871)
1472 244877 2 35 1349 Page St 1 1 1 1     15 Width 0ft   6000105.0 2109153.0 37.7713370947812 -122.443019734512 (37.7713370947812, -122.443019734512)
146715 244518 2 35 531 Page St 1 1 1 1     7 Width 0ft   6003993.7068 2109716.5376 37.77310538093779 -122.42960871992202 (37.7731053809378, -122.429608719922)
24195 244515 2 35 426 Fillmore St 1 1 1 1     4 Width 0ft   6003699.3803 2109847.5959 37.7734485650794 -122.430636186348 (37.7734485650794, -122.430636186348)
51288 244389 2 35 250 Octavia St 1 1 1 1     5 Width 0ft   6005653.9696 2110171.6272 37.774448814721104 -122.42389801886002 (37.7744488147211, -122.42389801886)
170836 244366 2 35 301 Octavia St 2 1 1 1     5 Width 0ft   6005514.1663 2110403.406 37.7750773296011 -122.424398114747 (37.7750773296011, -122.424398114747)
67122 244365 2 35 301 Octavia St 1 1 1 1     4 Width 0ft   6005511.8056 2110439.7613 37.775177019128606 -122.424408867351 (37.7751770191286, -122.424408867351)
57526 244352 2 35 300 Octavia St 7 1 1 1     5 Width 0ft   6005613.5532 2110456.5225 37.7752287864343 -122.42405809140699 (37.7752287864343, -122.424058091407)
853 244350 3 35 300 Octavia St 5 1 1 2   04/20/2017 07:22:00 AM 3 Width 0ft   6005619.219 2110418.7508 37.77512539438639 -122.424035805431 (37.7751253943864, -122.424035805431)
56529 244325 2 35 463 Fillmore St 1 1 1 1     2 Width 0ft   6003635.8441 2109959.3175 37.773751725465296 -122.430863941782 (37.7737517254653, -122.430863941782)
77132 244320 2 35 331 Octavia St 3 1 1 1     6 Width 0ft   6005500.9462 2110499.2518 37.775339752374 -122.424450664906 (37.775339752374, -122.424450664906)
343 244298 3 35 350 Octavia St 1 1 1 2     6 Width 0ft   6005605.7628 2110511.5277 37.7753793775331 -122.42408895277501 (37.7753793775331, -122.424088952775)
71170 244253 2 35 200 Octavia St 7 1 1 1     5 Width 0ft   6005660.0799 2110124.2725 37.7743191351223 -122.423873514167 (37.7743191351223, -122.423873514167)
70934 244250 2 35 200 Octavia St 4 1 1 1     6 Width 0ft   6005666.9539 2110073.8626 37.7741811097881 -122.423846150492 (37.7741811097881, -122.423846150492)
45819 244240 2 35 251 Octavia St 3 1 1 1     5 Width 0ft   6005550.0678 2110158.7025 37.774407460347796 -122.424256515939 (37.7744074603478, -122.424256515939)
187570 244239 2 35 253 Octavia St 2 1 1 1     5 Width 0ft   6005546.7389 2110177.0116 37.774457544735604 -122.424269333697 (37.7744575447356, -122.424269333697)
169464 244238 2 35 255 Octavia St 1 1 1 1     6 Width 0ft   6005544.2422 2110192.8239 37.7745008205043 -122.424279095113 (37.7745008205043, -122.424279095113)
Powered by Datasette · Query took 20.921ms · Data source: data.sfgov.org