sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
423 109554 2 15 300x Van Ness Ave 10 1 1 1     4 3x3   6006839.87541 2111919.81075 37.7793157843461 -122.41991981597201 (37.7793157843461, -122.419919815972)
476 174954 2 15 1400x Market St 1 1 1 1       4xt Permit Number 779898 6007316.0 2110809.0 37.776292577113104 -122.418193923043 (37.7762925771131, -122.418193923043)
537 195070 2 15 1532 Harrison St 2 1 1 1     8 Width 3ft   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
567 195068 2 15 1532 Harrison St 1 1 1 1     8 Width 3ft   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
761 195041 2 15 402 06th St 1 4 1 2     28 Width 3ft   6011480.36813 2111044.01847 37.777171403968296 -122.40380468436199 (37.7771714039683, -122.403804684362)
777 234744 2 15 2455 15th St 1 5 1 1     12 Width 3ft   6001486.4222099995 2107220.2274599997 37.766108846174795 -122.438102867577 (37.7661088461748, -122.438102867577)
861 109545 2 15 300x Van Ness Ave 1 1 1 1     4 3x3   6006870.4118800005 2111707.44564 37.778734401395205 -122.419799104459 (37.7787344013952, -122.419799104459)
1284 235428 2 15 2869 Cesar Chavez St 1 1 1 2   12/09/2016 12:00:00 AM 3 3x3   6010306.81938 2100635.6894799997 37.74852686004171 -122.40713053105101 (37.7485268600417, -122.407130531051)
1285 234575 2 15 2990 Cesar Chavez St 1 1 1 2   12/09/2016 12:00:00 AM 3 Width 3ft   6009677.1610900005 2100624.0529099996 37.7484596510092 -122.409307067568 (37.7484596510092, -122.409307067568)
1291 234571 2 15 2892 Cesar Chavez St 1 1 1 2   05/09/2017 12:00:00 AM 3 3x4   6010196.53099 2100680.54575 37.7486438528311 -122.407515070373 (37.7486438528311, -122.407515070373)
1318 100805 2 15 2429 Jackson St 2 1 1 1     18 3x3   6002563.2899400005 2116751.5140400003 37.79234055221529 -122.43505995207899 (37.7923405522153, -122.435059952079)
1429 102682 2 15 2100 Scott St 2 1 1 1     24 4x4   6001423.65551 2115717.83054 37.7894375487454 -122.438928994703 (37.7894375487454, -122.438928994703)
1733 200858 2 15 1133 Market St 1 1 1 1     8 Width 0ft   6008786.0 2112009.0 37.7796701249263 -122.413193644333 (37.7796701249263, -122.413193644333)
1740 200859 2 15 1133 Market St 2 1 1 1     13 Width 0ft   6008786.0 2112009.0 37.7796701249263 -122.413193644333 (37.7796701249263, -122.413193644333)
1753 134350 2 15 838 Market St 2 1 1 1     10 Width 4ft   6010747.0 2114018.0 37.7852962621335 -122.40655126994301 (37.7852962621335, -122.406551269943)
1888 100797 2 15 2471 Jackson St 1 1 1 1     12 3x3   6002362.24857 2116725.90576 37.7922588209311 -122.435753725979 (37.7922588209311, -122.435753725979)
1964 238618 2 15 4302 24th St 4 1 1 3     14 Width 4ft   6001078.53558 2101746.02342 37.751054810249 -122.439121284114 (37.751054810249, -122.439121284114)
1974 238616 2 15 4302 24th St 2 1 1 3     23 Width 4ft   6001186.94921 2101750.3744 37.7510729252903 -122.43874669133301 (37.7510729252903, -122.438746691333)
1975 238619 2 15 4302 24th St 5 1 1 3     23 Width 4ft   6001066.93276 2101745.60422 37.7510529990026 -122.43916137771099 (37.7510529990026, -122.439161377711)
2070 109552 2 15 300x Van Ness Ave 8 1 1 1     4 3x3   6006854.31545 2111807.2543900004 37.7790075453087 -122.419861872643 (37.7790075453087, -122.419861872643)
2096 200850 2 15 1411 Market St 3 1 1 1     5 Width 0ft   6007584.0 2110630.0 37.77581616716321 -122.417254147161 (37.7758161671632, -122.417254147161)
2108 98580 2 15 370 Drumm St 10 1 1 1   06/22/2017 12:00:00 AM 3 3x3   6013585.68076 2118314.1263900003 37.7972508218322 -122.397031561762 (37.7972508218322, -122.397031561762)
2299 253020 2 15 760 Hayes St 1 1 1 1       3x3   6004216.0 2110862.0 37.7762631241711 -122.42892145951299 (37.7762631241711, -122.428921459513)
2303 122440 2 15 599X Folsom St 1 1 1 1     6 3x3 Permit Number 778941 6013669.1059 2114077.4124 37.785622440131 -122.39644576664499 (37.785622440131, -122.396445766645)
2305 201174 2 15 599X Folsom St 4 1 1 1     7 Width 0ft Permit Number 778941 6013723.602999999 2114126.7683 37.785760992593296 -122.396260681537 (37.7857609925933, -122.396260681537)
2306 195019 2 15 300X 02nd St 2 1 1 1     5 Width 3ft   6013637.791730001 2113971.74755 37.785330566207705 -122.396546695873 (37.7853305662077, -122.396546695873)
2307 122432 2 15 598X Folsom St 2 1 1 1     12 4x4 Permit Number 778941 6013714.3488 2114207.9998 37.7859835205848 -122.396298394128 (37.7859835205848, -122.396298394128)
2309 122433 2 15 598X Folsom St 3 1 1 1     10 4x4 Permit Number 778941 6013698.925 2114193.6044 37.785943135879 -122.396350747311 (37.785943135879, -122.396350747311)
2313 201193 2 15 611 Folsom St 7 1 1 1     12 Width 0ft Permit Number 778941 6013579.6483 2113996.1808 37.7853944182999 -122.39674956946399 (37.7853944182999, -122.396749569464)
2315 195022 2 15 300X 02nd St 5 1 1 1     16 Width 3ft   6013709.75083 2113894.09551 37.785121356022394 -122.39629229296001 (37.7851213560224, -122.39629229296)
2319 201172 2 15 599X Folsom St 2 1 1 1     6 Width 0ft Permit Number 778941 6013687.6143 2114096.9491 37.785677113353294 -122.396383102325 (37.7856771133533, -122.396383102325)
2323 201173 2 15 599X Folsom St 3 1 1 1     6 Width 0ft Permit Number 778941 6013705.0945 2114111.3445 37.7857176125048 -122.39632363473801 (37.7857176125048, -122.396323634738)
2324 195018 2 15 300X 02nd St 1 1 1 1     9 Width 3ft Permit Number 778941 6013610.320719999 2113989.12597 37.7853767544813 -122.39664295660499 (37.7853767544813, -122.396642956605)
2331 122431 2 15 598X Folsom St 1 1 1 1     11 4x4 Permit Number 778941 6013729.7725 2114223.4236 37.786026729010295 -122.396246113338 (37.7860267290103, -122.396246113338)
2332 122438 2 15 598X Folsom St 8 1 1 1     15 4x4 Permit Number 778941 6013622.8347 2114119.5705 37.785735621476 -122.396608809095 (37.785735621476, -122.396608809095)
2334 122437 2 15 598X Folsom St 7 1 1 1     10 4x4 Permit Number 778941 6013638.2584 2114134.9942 37.7857788297664 -122.396556528653 (37.7857788297664, -122.396556528653)
2335 195021 2 15 300X 02nd St 4 1 1 1     20 Width 3ft   6013679.6407 2113928.34961 37.7852137343684 -122.396398867136 (37.7852137343684, -122.396398867136)
2336 195020 2 15 300X 02nd St 3 1 1 1     6 Width 3ft   6013662.142659999 2113947.50545 37.785265358143896 -122.39646074858601 (37.7852653581439, -122.396460748586)
2337 122436 2 15 598X Folsom St 6 1 1 1     3 4x4 Permit Number 778941 6013651.6256 2114147.3332 37.7858134537143 -122.39651114681001 (37.7858134537143, -122.39651114681)
2343 195028 2 15 300X 02nd St 11 1 1 1     14 Width 3ft   6013774.91802 2113824.49769 37.7849338824287 -122.396061954106 (37.7849338824287, -122.396061954106)
2344 122435 2 15 598X Folsom St 5 1 1 1     9 4x4 Permit Number 778941 6013667.0494 2114164.8134 37.785862308640105 -122.396459010111 (37.7858623086401, -122.396459010111)
2347 195023 2 15 300X 02nd St 6 1 1 1     13 Width 3ft   6013717.57682 2113887.99977 37.785105053996396 -122.396264789902 (37.7851050539964, -122.396264789902)
2350 122434 2 15 598X Folsom St 4 1 1 1     10 4x4 Permit Number 778941 6013681.4448 2114180.2371 37.7859054596404 -122.39641028715201 (37.7859054596404, -122.396410287152)
2351 201241 2 15 598 Folsom St 10 1 1 1     7 Width 0ft Permit Number 778941 6013597.1285 2114096.9491 37.78567207766061 -122.396696159476 (37.7856720776606, -122.396696159476)
2352 195026 2 15 300X 02nd St 9 1 1 1     11 Width 3ft   6013748.5801800005 2113848.78027 37.7849990913834 -122.39615477762301 (37.7849990913834, -122.396154777623)
2355 195025 2 15 300X 02nd St 8 1 1 1     10 Width 3ft   6013739.901380001 2113861.81988 37.7850344122501 -122.396185717917 (37.7850344122501, -122.396185717917)
2358 195024 2 15 300X 02nd St 7 1 1 1     12 Width 3ft   6013723.336209999 2113877.98804 37.785077884566604 -122.39624416214 (37.7850778845666, -122.39624416214)
2359 195027 2 15 300X 02nd St 10 1 1 1     13 Width 3ft   6013762.26581 2113837.6181400004 37.784969204212295 -122.396106646824 (37.7849692042123, -122.396106646824)
2360 122439 2 15 598X Folsom St 9 1 1 1     4 4x4 Permit Number 778941 6013610.4957 2114107.2315 37.7857010547146 -122.39665063354099 (37.7857010547146, -122.396650633541)
2622 238126 2 15 3388 17th St 3 1 1 1   07/24/2017 02:38:00 PM 3 Width 3ft   6006363.87344 2106134.73006 37.7634045065344 -122.421155613935 (37.7634045065344, -122.421155613935)
2686 234760 2 15 252 Waller St 2 1 1 1     19 Width 3ft   6004468.902369999 2109137.1444099997 37.77154140335671 -122.427923663451 (37.7715414033567, -122.427923663451)
2690 126183 2 15 1451 Bay St 5 1 1 1     12 Width 3ft   6003793.92894 2120715.46368 37.803294337014606 -122.431084963893 (37.8032943370146, -122.431084963893)
2733 253189 2 15 99x The Embarcadero 12 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2735 253188 2 15 99x The Embarcadero 11 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2737 253186 2 15 99x The Embarcadero 9 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2738 253184 2 15 99x The Embarcadero 7 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2739 253185 2 15 99x The Embarcadero 8 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2741 253190 2 15 99x The Embarcadero 13 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2744 253187 2 15 99x The Embarcadero 10 1 1 1       3x3   6014645.0 2117171.0 37.794170975650296 -122.393285986986 (37.7941709756503, -122.393285986986)
2767 252950 2 15 261x Winding Way 2 8 1 1       3x3 Permit Number 780594 6001774.0 2086449.0 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553)
2772 252949 2 15 261x Winding Way 1 8 1 1       3x3 Permit Number 780594 6001774.0 2086449.0 37.7090922302752 -122.435622042553 (37.7090922302752, -122.435622042553)
3632 122539 2 15 3443 Clay St 3 1 1 1     12 3x3 Permit Number 779060 5998247.97366 2115501.74936 37.788663053514 -122.44990087023001 (37.788663053514, -122.44990087023)
4013 253610 2 15 1075 Mission St 16 1 1 1       Width 4ft   6009725.02676 2112060.52163 37.7798642637711 -122.40994876804 (37.7798642637711, -122.40994876804)
4471 100799 2 15 2455 Jackson St 1 1 1 1     18 3x3   6002438.67863 2116735.02721 37.7922882071812 -122.435489929626 (37.7922882071812, -122.435489929626)
4567 109546 2 15 300x Van Ness Ave 2 1 1 1     4 3x3   6006868.4272 2111721.79621 37.778773692788 -122.419806988803 (37.778773692788, -122.419806988803)
4621 122573 2 15 2014 Buchanan St 1 1 1 1     12 4x4   6003898.8446 2115409.2515 37.7887307847056 -122.430343093484 (37.7887307847056, -122.430343093484)
4639 102681 2 15 2100 Scott St 1 1 1 1     24 4x4   6001426.627069999 2115693.54787 37.7893710438761 -122.43891697256399 (37.7893710438761, -122.438916972564)
4715 103364 2 15 1171X Sacramento St 3 1 1 1 7   3 3x3   6009173.30525 2116699.27717 37.79257023366971 -122.412185363057 (37.7925702336697, -122.412185363057)
4730 234655 2 15 437 Noe St 1 1 1 1     16 6x12   6002991.56268 2105705.90685 37.762036373292 -122.432788699846 (37.762036373292, -122.432788699846)
5139 235614 2 15 573 Valencia St 1 1 1 1     7 Width 3ft   6006249.0 2106283.0 37.7638051443341 -122.421563455709 (37.7638051443341, -122.421563455709)
5166 235615 2 15 573 Valencia St 2 1 1 1     6 Width 3ft   6006249.0 2106283.0 37.7638051443341 -122.421563455709 (37.7638051443341, -122.421563455709)
5330 103513 2 15 1859 Green St 2 1 1 1     8 3x3   6004155.22179 2118342.1254 37.7967982290065 -122.429665326519 (37.7967982290065, -122.429665326519)
5346 109550 2 15 300x Van Ness Ave 6 1 1 1     4 3x3   6006859.56746 2111778.81942 37.778929765630295 -122.41984168553999 (37.7789297656303, -122.41984168554)
5354 109556 2 15 300x Van Ness Ave 12 1 1 1     4 3x3   6006837.67499 2111950.4922 37.7793999042174 -122.41992960596501 (37.7793999042174, -122.419929605965)
5376 112253 2 15 3401 Washington St 1 1 1 1     12 3x3   5998472.27762 2115859.72352 37.789658787381796 -122.449150614422 (37.7896587873818, -122.449150614422)
5398 98494 2 15 2820 Baker St 1 1 1 1     14 3x3   5999556.928169999 2118555.98315 37.79712398054429 -122.44559181541099 (37.7971239805443, -122.445591815411)
5470 100796 2 15 2477 Jackson St 1 1 1 1     16 3x3   6002339.98716 2116721.3494700002 37.79224504601171 -122.43583042464199 (37.7922450460117, -122.435830424642)
5609 105280 2 15 3017 Webster St 1 1 1 1     20 3x3   6002863.14914 2118997.09169 37.7985233499191 -122.43418303843399 (37.7985233499191, -122.434183038434)
5610 109560 2 15 300x Van Ness Ave 16 1 1 1     4 3x3   6006827.8052900005 2112008.26753 37.7795579852454 -122.41996785053101 (37.7795579852454, -122.419967850531)
5640 79352 2 15 2909 Bush St 1 1 1 1 1 09/08/2001 12:00:00 AM 8 3x3   5999487.033 2114286.0485 37.785395874336 -122.445526470028 (37.785395874336, -122.445526470028)
5817 103362 2 15 1171X Sacramento St 1 1 1 1 7   12 3x3   6009111.87446 2116690.2667799997 37.7925420462198 -122.41239727931601 (37.7925420462198, -122.412397279316)
5857 99700 2 15 1412 Jackson St 1 1 1 1     30 4x4   6007375.87378 2117463.43004 37.794567388720296 -122.41845876116301 (37.7945673887203, -122.418458761163)
5882 109553 2 15 300x Van Ness Ave 9 1 1 1     4 3x3   6006853.14044 2111821.07903 37.7790454382325 -122.41986691873801 (37.7790454382325, -122.419866918738)
6038 103363 2 15 1171X Sacramento St 2 1 1 1 7   12 3x3   6009142.2805 2116694.47646 37.79255531122121 -122.412292370693 (37.7925553112212, -122.412292370693)
6077 100804 2 15 2429 Jackson St 1 1 1 1     18 3x3   6002544.40656 2116747.89129 37.7923295328255 -122.435125029709 (37.7923295328255, -122.435125029709)
6124 100807 2 15 2401 Jackson St 3 1 1 1     12 3x3   6002634.35526 2116761.0817299997 37.7923708575934 -122.4348147492 (37.7923708575934, -122.4348147492)
6227 113069 2 15 3108 Fillmore St 3 1 1 1     24 3x3   6002430.41421 2118968.02976 37.7984189836099 -122.43567835378 (37.7984189836099, -122.43567835378)
6245 100808 2 15 2401 Jackson St 4 1 1 1     12 3x3   6002651.17595 2116762.40631 37.7923754495237 -122.43475664402399 (37.7923754495237, -122.434756644024)
6438 113068 2 15 3108 Fillmore St 2 1 1 1     24 3x3   6002431.85216 2118952.17162 37.7983755229712 -122.43567224288799 (37.7983755229712, -122.435672242888)
6502 110596 2 15 624 Taylor St 5 1 1 1   05/12/2015 12:00:00 AM 3 2x2   6009279.98912 2115129.5633 37.7882661656083 -122.411705268989 (37.7882661656083, -122.411705268989)
6622 103365 2 15 1171X Sacramento St 4 1 1 1 7   12 3x3   6009208.54849 2116702.7837799997 37.7925818394263 -122.412063667702 (37.7925818394263, -122.412063667702)
6629 100806 2 15 2401 Jackson St 2 1 1 1     8 3x3   6002616.18496 2116759.45065 37.7923653474383 -122.434877502118 (37.7923653474383, -122.434877502118)
6677 121686 2 15 1653 Grant Ave 1 1 1 1     20 3x3   6010468.2399 2120204.652 37.8022677132519 -122.4079521316 (37.8022677132519, -122.4079521316)
6798 109547 2 15 300x Van Ness Ave 3 1 1 1     4 3x3   6006862.63225 2111739.40495 37.7788217156763 -122.419828285662 (37.7788217156763, -122.419828285662)
6831 101231 2 15 3575 Sacramento St 1 1 1 1     26 3x3 Permit Number 779254 5997777.0237 2115106.06857 37.7875496613457 -122.451501728247 (37.7875496613457, -122.451501728247)
6848 100798 2 15 2469 Jackson St 1 1 1 1     18 3x3   6002394.5470900005 2116728.58205 37.7922680039076 -122.435642164168 (37.7922680039076, -122.435642164168)
6916 102685 2 15 2138 Scott St 1 1 1 1     24 4x4   6001402.82307 2115865.31916 37.7898413290661 -122.43901164686399 (37.7898413290661, -122.439011646864)
7073 112426 2 15 2811 Jackson St 1 1 1 1     20 3x3   6000627.2120900005 2116484.87099 37.7914982957465 -122.441739663868 (37.7914982957465, -122.441739663868)
7147 102684 2 15 2100 Scott St 4 1 1 1     24 4x4   6001417.230930001 2115753.64679 37.78953552537921 -122.438953790804 (37.7895355253792, -122.438953790804)
7337 106720 2 15 1447 Lyon St 1 1 1 1     12 3x3   5999672.1743 2113882.1261 37.7842973761464 -122.44485689337401 (37.7842973761464, -122.444856893374)
7456 111007 2 15 600X Beach St 1 1 1 1   07/15/2015 12:00:00 AM 3   Permit Number 776001 6007258.06948 2121954.7995599997 37.8068929247227 -122.41918512469299 (37.8068929247227, -122.419185124693)
Powered by Datasette · Query took 6.649ms · Data source: data.sfgov.org