sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
78 251199 6 3 900X 14th St 4 7 1 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
86 119601 6 34 4357x Mission St 3 7 1 1         Permit Number 774415          
93 251198 6 3 900X 14th St 3 7 1 1           6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
363 119608 6 34 299x Avalon Ave 4 7 1 1                    
595 119606 6 1 299x Avalon Ave 2 7 1 1                    
1310 251480 6 3 51 Peralta Ave 1 7 1 1       3x3   6010641.0 2100362.0 37.747794064611604 -122.40595565659201 (37.7477940646116, -122.405955656592)
1820 251716 6 47 3929 19th St 1 7 1 1           6003450.0 2104734.0 37.75939373993371 -122.431133769968 (37.7593937399337, -122.431133769968)
1930 252828 6 161 3852 17th St 7 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1932 252826 6 75 3852 17th St 5 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1933 252830 6 75 3852 17th St 9 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1936 252824 6 75 3852 17th St 3 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1938 252827 6 75 3852 17th St 6 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1939 252822 6 114 3852 17th St 1 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1947 252825 6 163 3852 17th St 4 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1950 252823 6 22 3852 17th St 2 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1957 252829 6 161 3852 17th St 8 7 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
2196 119600 6 34 4357x Mission St 2 7 1 1         Permit Number 774415          
2691 253165 6 180 1451 Bay St 3 7 1 1       3x3   6003691.0 2120547.0 37.802825946660796 -122.431429119577 (37.8028259466608, -122.431429119577)
2734 253182 6 143 5157 Diamond Heights Blvd 1 7 1 1           6000788.0 2100195.0 37.7467795353698 -122.44001478039101 (37.7467795353698, -122.440014780391)
2736 253183 6 143 5159 Diamond Heights Blvd 1 7 1 1           6000808.0 2099903.0 37.745978911495 -122.439924689335 (37.745978911495, -122.439924689335)
2848 253255 6 47 270 Castenada Ave 2 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2854 253253 6 5 99X Lopez Ave 4 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2859 253251 6 3 99X Lopez Ave 2 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2869 253250 6 3 99X Lopez Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2874 253252 6 3 99X Lopez Ave 3 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3059 126695 6 32 2829 Divisadero St 2 7 1 1     11 10x10 Permit Number 779774 6000551.43021 2118023.61416 37.7957189625051 -122.44211236900601 (37.7957189625051, -122.442112369006)
3138 253254 6 3 270 Castenada Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3256 253373 6 44 78 Peralta Ave 1 7 1 1       3x3   6010457.0 2100357.0 37.7477700431666 -122.406591570174 (37.7477700431666, -122.406591570174)
3283 253384 6 203 55 Cerritos Ave 1 7 1 1       10x10   5992588.0 2092941.0 37.7263916542788 -122.46784182223999 (37.7263916542788, -122.46784182224)
3534 253482 6 19 2179 41st Ave 1 7 1 1       3x5   5983532.0 2100331.0 37.74615550514321 -122.49969345420799 (37.7461555051432, -122.499693454208)
4553 253637 6 3 701 Noe St 2 7 1 1       Width 3ft   6003144.80454 2104133.37104 37.757727257313704 -122.43214639144101 (37.7577272573137, -122.432146391441)
4923 253718 6 47 227 Madison St 1 7 1 1       3x3   6005690.0 2092595.0 37.726189474375204 -122.422524168298 (37.7261894743752, -122.422524168298)
5055 253765 6 42 1366 Guerrero St 2 7 1 1       3X3   6005800.0848900005 2101007.6677599996 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761)
5478 121205 6 234 930 Chestnut St 1 7 1 1     20 3x3   6007386.5238 2120591.4348299997 37.8031567047665 -122.418643837145 (37.8031567047665, -122.418643837145)
7743 121449 6 2 1274 Filbert St 1 7 1 1     12 10x6   6006927.94593 2119481.89109 37.800084349978 -122.420151970562 (37.800084349978, -122.420151970562)
7809 119599 6 34 4357x Mission St 1 7 1 1         Permit Number 774415          
7810 119607 6 3 299x Avalon Ave 3 7 1 1                    
7834 119605 6 47 299x Avalon Ave 1 7 1 1                    
9641 114157 6 3 1200x JUNIPERO SERRA BLVD 18 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9643 114152 6 3 1200X JUNIPERO SERRA BLVD 11 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9644 114150 6 3 1200X JUNIPERO SERRA BLVD 9 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9647 114149 6 3 1200X JUNIPERO SERRA BLVD 8 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9651 114156 6 3 1200x JUNIPERO SERRA BLVD 17 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9655 114155 6 128 1200X JUNIPERO SERRA BLVD 16 7 1 1           5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9656 114151 6 3 1200X JUNIPERO SERRA BLVD 10 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9657 114153 6 3 1200x JUNIPERO SERRA BLVD 12 7 1 1     40     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9661 114148 6 3 1200X JUNIPERO SERRA BLVD 7 7 1 1     19     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9677 114154 6 5 1200x JUNIPERO SERRA BLVD 13 7 1 1     20     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9883 173726 6 3 1101 Connecticut St 1 7 1 1           6013424.0 2101939.0 37.752279425117294 -122.396442635345 (37.7522794251173, -122.396442635345)
9912 173731 6 1 484 Chenery St 1 7 1 1           6003566.0 2096120.0 37.7357482768139 -122.43011807363199 (37.7357482768139, -122.430118073632)
10174 173886 6 75 2931 20th St 1 7 1 1           6009454.0 2104482.0 37.759040204703496 -122.41035112011801 (37.7590402047035, -122.410351120118)
10190 173887 6 75 2931 20th St 2 7 1 1           6009454.0 2104482.0 37.759040204703496 -122.41035112011801 (37.7590402047035, -122.410351120118)
10256 173933 6 47 190 Beacon St 1 7 1 1           6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
13267 187629 6 183 4283 23rd St 1 7 1 1       3x3   6001353.0 2102279.0 37.7525338497288 -122.43821033719401 (37.7525338497288, -122.438210337194)
16097 104813 6 60 1601X Portola Dr 5 7 1 1                    
17858 121173 6 17 950 Duncan St 2 7 1 1       3x3   6000333.0 2099683.0 37.7453477932295 -122.44155138616101 (37.7453477932295, -122.441551386161)
19350 95161 6 175 2721 Pacific Ave   7 1 1         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252)
20477 104866 6 3 411 Holladay Ave 1 7 1 1           6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202)
20865 103256 6 22 4187 26th St 1 7 1 1     16 3x3   6002700.0 2100625.0 37.7480688746475 -122.433434000346 (37.7480688746475, -122.433434000346)
22304 248911 6 129 1633 Oakdale Ave 1 7 1 1           6014844.92913 2095599.8976 37.7349525388235 -122.39108575959101 (37.7349525388235, -122.391085759591)
23001 251172 6 3 363 Jersey St 2 7 1 1           6002784.74363 2101501.25508 37.750479672211 -122.433203561601 (37.750479672211, -122.433203561601)
23162 251173 6 75 367 Jersey St 2 7 1 1       Width 3ft   6002770.52649 2101500.0126900002 37.7504754543841 -122.43325263672399 (37.7504754543841, -122.433252636724)
26650 109414 6 113 4 GUY PL 1 7 1 1     14     6014378.1 2114502.6 37.786829336844605 -122.394022608955 (37.7868293368446, -122.394022608955)
46601 84938 6 40 145 Guerrero St 1 7 1 1         Permit Number 49347 6005480.0 2108218.0 37.769074802262395 -122.42436083172 (37.7690748022624, -122.42436083172)
58944 100194 6 191 361 Dellbrook Ave 2 7 1 1           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969)
59539 98244 6 241 901 Bay St 1 7 1 1     5     6006420.63185 2121080.7781 37.8044458892203 -122.422021121489 (37.8044458892203, -122.422021121489)
63120 105071 6 109 1808 Vallejo St 1 7 1 1     3   Permit Number 771033 6004794.05676 2118138.55822 37.796275437823894 -122.427440299436 (37.7962754378239, -122.427440299436)
67557 100121 6 1 690 Miramar Ave 1 7 1 1           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042)
69736 99191 6 15 1155@Sansome Battery St 2 7 1 1     9 Plaza Permit Number 768022 6012232.15659 2120086.23158 37.8020411569217 -122.401839756495 (37.8020411569217, -122.401839756495)
72156 104935 6 62 835 Gonzalez Dr 1 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
74055 100572 6 21 3020 Washington St 1 7 1 1     3   Permit Number 769157 6000180.60876 2116141.82829 37.790530933705 -122.44326025018299 (37.790530933705, -122.443260250183)
74816 100209 6 108 701 Rhode Island St 1 7 1 1     10   Permit Number 769013 6011855.86556 2105057.10212 37.7607536567646 -122.402084714731 (37.7607536567646, -122.402084714731)
75150 97534 6 143 203 Surrey St 1 7 1 1         Permit Number 768282 6002070.0 2096079.6 37.73555250464221 -122.435287431957 (37.7355525046422, -122.435287431957)
77671 107413 6 231 276 Yerba Buena Ave 1 7 1 1     28     5995080.66446 2095640.15746 37.733946507354396 -122.459420244296 (37.7339465073544, -122.459420244296)
77818 108026 6 116 862 Kansas St   7 1 1         Permit Number 774734 6011570.0 2104296.0 37.758647879927395 -122.403019866682 (37.7586478799274, -122.403019866682)
77934 105417 6 5 1450X McAllister St 3 7 1 1           6002220.7882900005 2111575.67932 37.7781095739995 -122.43587451144501 (37.7781095739995, -122.435874511445)
78391 108038 6 3 1 Twin Peaks Blvd   7 1 1           5998985.485719999 2105240.3128 37.760529947122706 -122.446610614338 (37.7605299471227, -122.446610614338)
78513 113727 6 26 1580 Valencia St 4 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
78531 104869 6 18 411 Holladay Ave 4 7 1 1         Permit Number 770735 6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202)
78769 116833 6 60 1750 Geneva Ave 1 7 1 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
78929 99659 6 5 1325 Portola Dr 3 7 1 1           5993615.2 2097760.6 37.7396843456359 -122.464640684629 (37.7396843456359, -122.464640684629)
79254 104682 6 26 33 08th St 4 7 1 1         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615)
79287 98950 6 108 401 Grove St 10 7 1 1           6005778.2 2111279.0 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313)
79360 112811 6 17 2023 43rd Ave 1 7 1 1           5982877.4 2101339.2 37.748885310102104 -122.502031530859 (37.7488853101021, -122.502031530859)
79490 113728 6 26 1580 Valencia St 5 7 1 1           6006496.0 2100402.0 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307)
79494 105555 6 22 410 Elizabeth St 2 7 1 1         Permit Number 772516 6003623.1 2102191.9 37.7524235434098 -122.430353733326 (37.7524235434098, -122.430353733326)
79771 105872 6 5 595X San Jose Ave 6 7 1 1           6006124.4715599995 2100100.1430599997 37.7468214281195 -122.421555015777 (37.7468214281195, -122.421555015777)
80060 113973 6 5 11 Hiliritas Ave 1 7 1 1         Permit Number 776381 6001589.6 2096875.9 37.7377116664791 -122.437005345865 (37.7377116664791, -122.437005345865)
80137 101978 6 25 25X Tiffany Ave 1 7 1 1     12     6006502.0 2099737.0 37.7458455996049 -122.420223786963 (37.7458455996049, -122.420223786963)
80152 104683 6 26 33 08th St 5 7 1 1         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615)
80662 110904 6 17 203 CORBETT AVE 1 7 1 1     20 3x3   6000094.0 2105620.0 37.7616357315689 -122.442804047122 (37.7616357315689, -122.442804047122)
80921 104904 6 26 417 Gonzalez Dr 1 7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
81071 78107 6 129 970 GUERRERO ST 1 7 1 1     15     6005649.9 2103318.5 37.755631523761394 -122.42342479955799 (37.7556315237614, -122.423424799558)
81326 99859 6 193 4443 19th St 1 7 1 1     12     6001193.1 2104609.9 37.7589248414166 -122.43893032447399 (37.7589248414166, -122.438930324474)
81710 104892 6 62 201 Gonzalez Dr   7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
81752 116834 6 60 1750 Geneva Ave 2 7 1 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
81776 114391 6 82 23x PINTO AVE 2 7 1 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
82109 105208 6 1 2694 47TH AVE   7 1 1           5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
82114 98455 6 189 2200 22nd St 1 7 1 1           6011565.2 2103754.7 37.7571613219705 -122.402998394603 (37.7571613219705, -122.402998394603)
82219 97945 6 116 2 Mendosa Ave 1 7 1 1         Permit Number 768165 5993624.4 2101138.5 37.748959736293294 -122.464854121346 (37.7489597362933, -122.464854121346)
82402 114388 6 16 361x ARBALLO DR 1 7 1 1     7     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
Powered by Datasette · Query took 11.135ms · Data source: data.sfgov.org