sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
613 20019 3 5 100 STAIRWAY48 3 1 1 2     6 10ST            
1109 20024 3 5 100 STAIRWAY48 8 1 1 2     12 10ST            
1647 20023 3 5 100 STAIRWAY48 7 1 1 2     12 10ST            
3571 39975 1 5 0 Steiner St 1 1 1 1         Permit Number 41235          
3819 19829 3 5 100 STAIRWAY25 13 1 1 2     6 60X            
6492 20389 3 5 262X Sunset Blvd 35 1 1 2     12 60            
6746 20018 3 5 100 STAIRWAY48 2 1 1 2     12 10ST            
7838 20021 3 5 100 STAIRWAY48 5 1 1 2     12 10ST            
8001 20026 3 5 100 STAIRWAY48 10 1 1 2     6 10ST            
8245 20020 3 5 100 STAIRWAY48 4 1 1 2     6 10ST            
8435 19808 3 5 100 STAIRWAY23 3 1 1 2     12 60ST            
8460 20385 3 5 262X Sunset Blvd 31 1 1 2     12 60            
11007 19809 3 5 100 STAIRWAY23 4 1 1 2     12 60ST            
11073 30310 1 5 228 Jordan Ave 2 1 1 1         Permit Number 8          
11209 20386 3 5 262X Sunset Blvd 32 1 1 2     12 60            
11240 19966 3 5 100 STAIRWAY41 4 1 1 2     6 25ST            
11825 20029 3 5 100 STAIRWAY50 1 1 1 2     12 40ST            
12211 20025 3 5 100 STAIRWAY48 9 1 1 2     12 10ST            
12986 19789 3 5 100 STAIRWAY19 11 1 1 2     18 50ST            
13382 39972 1 5 0 Steiner St 2 1 1 1         Permit Number 41235          
14068 30309 1 5 228 Jordan Ave 1 1 1 1         Permit Number 8          
15553 20453 3 5 495X Sunset Blvd 18 1 1 2     12 60            
16079 19828 3 5 100 STAIRWAY25 12 1 1 2     6 60X            
16094 20027 3 5 100 STAIRWAY48 11 1 1 2     6 10ST            
16111 102843 2 5 1101X Portola Dr 10 9 1 2                    
16846 20022 3 5 100 STAIRWAY48 6 1 1 2     12 10ST            
18151 124716 5 5 2195 Palou Ave 1 1 1 1                    
156682 175042 2 5 98 San Diego Ave 1 7 1 1     33     5992757.09235 2086323.81583 37.7082322293939 -122.466776470378 (37.7082322293939, -122.466776470378)
69667 175035 2 5 177 Desmond St 1 1 1 1     7 Width 3ft   6010415.17043 2086409.0149299998 37.70946946450071 -122.405753896527 (37.7094694645007, -122.405753896527)
121000 98352 2 5 201 Drake St 1 1 1 1       3x3   6001689.0 2086535.0 37.709323539126004 -122.435921964243 (37.709323539126, -122.435921964243)
2777 253179 2 5 201x Drake St 1 1 1 1       3x3   6001862.0 2086566.0 37.709418484595 -122.43532626528601 (37.709418484595, -122.435326265286)
150123 175036 2 5 141 Desmond St 1 1 1 1     12 Width 3ft   6010481.99907 2086582.34514 37.7099491314082 -122.405535123871 (37.7099491314082, -122.405535123871)
93717 25437 3 5 2555 Bay Shore Blvd 11 1 1 2   03/26/1998 12:00:00 AM 3 3x3   6010830.95304 2086585.06609 37.7099761086624 -122.40432925767401 (37.7099761086624, -122.404329257674)
29876 175037 2 5 137 Desmond St 1 1 1 1     13 Width 3ft   6010487.1621199995 2086599.0486700002 37.7099952846374 -122.40551845494 (37.7099952846374, -122.40551845494)
86741 87252 1 5 20 Burr Ave 1 1 1 1       3x3 Permit Number 50276 6007848.5 2086602.7 37.709857414252795 -122.414638464087 (37.7098574142528, -122.414638464087)
34165 175038 2 5 137 Desmond St 2 1 1 1     10 Width 3ft   6010492.95199 2086616.94014 37.7100447347569 -122.405499703176 (37.7100447347569, -122.405499703176)
60747 175041 2 5 2 Burr Ave 1 1 1 1     15 Width 2ft   6007781.09007 2086643.56012 37.7099658201356 -122.41487433598199 (37.7099658201356, -122.414874335982)
46969 175039 2 5 131 Desmond St 1 1 1 1     9 Width 3ft   6010504.44618 2086648.5226599998 37.7101320966946 -122.40546219962299 (37.7101320966946, -122.405462199623)
56725 175034 2 5 132 Desmond St 1 1 1 1     8 Width 3ft   6010467.70028 2086649.8713200002 37.7101337451556 -122.40558929631001 (37.7101337451556, -122.40558929631)
25522 175043 2 5 199 Shakespeare St 2 7 1 1     6 Width 8ft   5993498.29454 2086678.39145 37.709248559547504 -122.464240538697 (37.7092485595475, -122.464240538697)
64504 175040 2 5 143 Talbert St 1 1 1 1     13 Width 3ft   6010245.72954 2086682.4738 37.7102108503322 -122.406358770646 (37.7102108503322, -122.406358770646)
149496 175033 2 5 120 Desmond St 2 1 1 1     8 Width 3ft   6010491.77199 2086707.0107200001 37.710291984453704 -122.40551012090401 (37.7102919844537, -122.405510120904)
40791 175032 2 5 120 Desmond St 1 1 1 1     6 Width 3ft   6010498.816000001 2086727.27775 37.710348027504104 -122.405487201665 (37.7103480275041, -122.405487201665)
12225 24277 3 5 350X Winding Way 15 11 1 2     6 8   6000814.16949 2086790.4577099998 37.709975233345496 -122.43896380743999 (37.7099752333455, -122.43896380744)
10951 24278 3 5 350X Winding Way 16 11 1 2     6 8   6000808.42529 2086790.5767400002 37.709975233345 -122.438983668972 (37.709975233345, -122.438983668972)
101675 114218 2 5 119 TALBERT ST 1 1 1 1       3x3   6010311.0 2086793.0 37.710517984021294 -122.406140963349 (37.7105179840213, -122.406140963349)
76755 175031 2 5 100 Desmond St 1 1 1 1     12 Width 3ft   6010533.91342 2086822.6121900002 37.7106117590847 -122.40537260647498 (37.7106117590847, -122.405372606475)
75768 175018 2 5 345 Tocoloma Ave 2 1 1 1     13 Width 2ft   6012554.50627 2086829.44577 37.71074329033971 -122.398389424743 (37.7107432903397, -122.398389424743)
5181 253819 2 5 1100x Prague St   1 1 1       3x3   6001057.0 2086858.0 37.71017450293179 -122.43812937571998 (37.7101745029318, -122.43812937572)
24483 175030 2 5 54 Desmond St 2 1 1 1     10 Width 3ft   6010584.6901 2086918.2274599997 37.710877138233 -122.405203838782 (37.710877138233, -122.405203838782)
35933 188732 2 5 250 Executive Park Blvd 8 2 1 1     14 Width 3ft   6014643.15959 2086929.06971 37.7111329692742 -122.391177465365 (37.7111329692742, -122.391177465365)
90217 115147 2 5 101 EXECUTIVE PARK BLVD 8 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
96999 115142 2 5 101 EXECUTIVE PARK BLVD 3 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
104010 115146 2 5 101 EXECUTIVE PARK BLVD 7 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
108315 115143 2 5 101 EXECUTIVE PARK BLVD 4 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
118266 115144 2 5 101 EXECUTIVE PARK BLVD 5 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
128837 115141 2 5 101 EXECUTIVE PARK BLVD 2 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
138505 115140 2 5 101 EXECUTIVE PARK BLVD 1 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
139204 115145 2 5 101 EXECUTIVE PARK BLVD 6 1 1 1       3x3   6013586.0 2086931.0 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854)
52049 175029 2 5 54 Desmond St 1 1 1 1     9 Width 3ft   6010591.02139 2086933.10615 37.7109183460773 -122.405183003288 (37.7109183460773, -122.405183003288)
42001 188730 2 5 250 Executive Park Blvd 5 2 1 1     11 Width 3ft   6014544.34623 2086934.52337 37.7111424598152 -122.39151937233 (37.7111424598152, -122.39151937233)
68720 188729 2 5 250 Executive Park Blvd 4 2 1 1     20 Width 3ft   6014522.262519999 2086936.6978200001 37.7111472046498 -122.391595851594 (37.7111472046498, -122.391595851594)
68152 188728 2 5 250 Executive Park Blvd 3 2 1 1     15 Width 3ft   6014503.20591 2086938.3794099998 37.7111507641693 -122.39166183394501 (37.7111507641693, -122.391661833945)
165358 188727 2 5 250 Executive Park Blvd 2 2 1 1     13 Width 3ft   6014344.673219999 2086951.52191 37.7111780496084 -122.39221068478999 (37.7111780496084, -122.39221068479)
169015 175028 2 5 50 Desmond St 1 1 1 1     8 Width 3ft   6010596.823340001 2086951.5974299998 37.710969443768896 -122.40516425152599 (37.7109694437689, -122.405164251526)
57966 188747 3 5 250x Executive Park Blvd 15 3 1 2     15 Width 8ft   6014639.494109999 2086953.6057 37.7112001369439 -122.391191848221 (37.7112001369439, -122.391191848221)
71605 188746 3 5 250x Executive Park Blvd 14 3 1 2     19 Width 8ft   6014613.42303 2086955.91765 37.7112050382485 -122.391282118582 (37.7112050382485, -122.391282118582)
34628 188726 2 5 250 Executive Park Blvd 1 2 1 1     21 Width 3ft   6014282.88696 2086958.43171 37.7111935916762 -122.39242471805001 (37.7111935916762, -122.39242471805)
133838 188745 3 5 250x Executive Park Blvd 13 3 1 2     17 Width 8ft   6014589.916680001 2086958.4326 37.711210639227 -122.39136353872101 (37.711210639227, -122.391363538721)
37820 188744 3 5 250x Executive Park Blvd 12 3 1 2     20 Width 8ft   6014566.93251 2086961.4469700002 37.7112176404424 -122.391443188965 (37.7112176404424, -122.391443188965)
32164 188743 3 5 250x Executive Park Blvd 11 3 1 2     22 Width 8ft   6014538.0462 2086963.8159 37.711222541749 -122.391543193559 (37.711222541749, -122.391543193559)
63133 188742 3 5 250x Executive Park Blvd 10 3 1 2     16 Width 8ft   6014513.510980001 2086966.09658 37.7112274421761 -122.391628153428 (37.7112274421761, -122.391628153428)
168939 188741 3 5 250x Executive Park Blvd 9 3 1 2     19 Width 8ft   6014489.73327 2086967.85233 37.7112309432358 -122.39171045846399 (37.7112309432358, -122.391710458464)
178538 188740 3 5 250x Executive Park Blvd 8 3 1 2     14 Width 8ft   6014461.35341 2086969.95596 37.711235143968 -122.391808694124 (37.711235143968, -122.391808694124)
186731 188739 3 5 250x Executive Park Blvd 7 3 1 2     18 Width 8ft   6014439.36233 2086971.4204900002 37.7112379444543 -122.39188480373801 (37.7112379444543, -122.391884803738)
40250 188750 2 5 150 Executive Park Blvd 8 2 1 1     17 Width 3ft   6014131.496280001 2086972.33958 37.7112233718385 -122.39294893824801 (37.7112233718385, -122.392948938248)
149419 188738 3 5 250x Executive Park Blvd 6 3 1 2     17 Width 8ft   6014415.87146 2086974.70005 37.7112456453465 -122.39196622388799 (37.7112456453465, -122.391966223888)
71411 188737 3 5 250x Executive Park Blvd 5 3 1 2     17 Width 8ft   6014387.73209 2086976.03412 37.7112477461551 -122.39206357459899 (37.7112477461551, -122.392063574599)
65570 188736 3 5 250x Executive Park Blvd 4 3 1 2     17 Width 8ft   6014364.73249 2086978.28388 37.7112526465696 -122.39214322484 (37.7112526465696, -122.39214322484)
75165 188735 3 5 250x Executive Park Blvd 3 3 1 2     18 Width 8ft   6014342.21925 2086979.24909 37.711254046810495 -122.39222110431601 (37.7112540468105, -122.392221104316)
174612 188734 3 5 250x Executive Park Blvd 2 3 1 2     17 Width 8ft   6014314.36158 2086981.8522700001 37.71125964778079 -122.39231757011801 (37.7112596477808, -122.392317570118)
156272 188733 2 5 250 Executive Park Blvd 1 4 1 1     8 Width 8ft   6014289.08954 2086985.67825 37.7112687498269 -122.392405184751 (37.7112687498269, -122.392405184751)
124194 121022 2 5 200 Executive Park Blvd 1 1 1 1           6014230.0 2086988.0 37.711271843415105 -122.392609576957 (37.7112718434151, -122.392609576957)
127894 121023 2 5 200 Executive Park Blvd 2 1 1 1           6014230.0 2086988.0 37.711271843415105 -122.392609576957 (37.7112718434151, -122.392609576957)
138492 121024 2 5 200 Executive Park Blvd 3 1 1 1   09/01/2016 12:00:00 AM 3     6014230.0 2086988.0 37.711271843415105 -122.392609576957 (37.7112718434151, -122.392609576957)
38609 188748 2 5 150 Executive Park Blvd 5 2 1 1     18 Width 3ft   6013906.67984 2086991.4991 37.7112634896854 -122.39372730596399 (37.7112634896854, -122.393727305964)
56907 187701 3 5 150x Executive Park Blvd 10 3 1 2     24 Width 8ft   6014160.4254 2086993.65928 37.7112835184788 -122.392850441814 (37.7112835184788, -122.392850441814)
45422 187710 2 5 51 Executive Park Blvd 1 4 1 1     2 Width 8ft   6013683.2298 2086994.4586200002 37.7112591963142 -122.39449981823 (37.7112591963142, -122.39449981823)
153767 187700 3 5 150x Executive Park Blvd 9 3 1 2     18 Width 8ft   6014134.283869999 2086999.7269 37.7112987269389 -122.392941218475 (37.7112987269389, -122.392941218475)
30017 187699 3 5 150x Executive Park Blvd 8 3 1 2     24 Width 8ft   6014113.89856 2087000.13929 37.7112987269205 -122.393011704639 (37.7112987269205, -122.393011704639)
153046 187709 2 5 51 Executive Park Blvd 8 2 1 1     11 Width 4ft   6013649.01686 2087002.29435 37.7112788096526 -122.39461861596399 (37.7112788096526, -122.394618615964)
170303 188764 3 5 150x Executive Park Blvd 7 3 1 2     22 Width 8ft   6014090.1968 2087004.6185400002 37.711309709434 -122.393093937756 (37.711309709434, -122.393093937756)
137789 188763 3 5 150x Executive Park Blvd 6 3 1 2     22 Width 8ft   6014060.27429 2087007.0702 37.711314778934295 -122.39319752976601 (37.7113147789343, -122.393197529766)
173558 188762 3 5 150x Executive Park Blvd 5 3 1 2     28 Width 8ft   6014035.24999 2087007.2689599998 37.71131393444921 -122.39328403465299 (37.7113139344492, -122.393284034653)
147853 188761 3 5 150x Executive Park Blvd 4 3 1 2     23 Width 8ft   6013991.40971 2087009.0790099998 37.7113164687655 -122.39343568552 (37.7113164687655, -122.39343568552)
157079 187711 3 5 51x Executive Park Blvd 2 3 1 2     13 Width 8ft   6013709.84578 2087009.9917799998 37.711303326954706 -122.394408912955 (37.7113033269547, -122.394408912955)
92597 103410 2 5 201 Executive Park Blvd 3 1 1 1         Permit Number 56795 6014240.56167 2087011.24615 37.711336259389206 -122.392574697929 (37.7113362593892, -122.392574697929)
98508 103408 2 5 201 Executive Park Blvd 1 1 1 1         Permit Number 56795 6014240.56167 2087011.24615 37.711336259389206 -122.392574697929 (37.7113362593892, -122.392574697929)
141472 103409 2 5 201 Executive Park Blvd 2 1 1 1         Permit Number 56795 6014240.56167 2087011.24615 37.711336259389206 -122.392574697929 (37.7113362593892, -122.392574697929)
61209 187708 2 5 51 Executive Park Blvd 7 2 1 1     13 Width 4ft   6013663.58022 2087013.01188 37.7113090475516 -122.394569030961 (37.7113090475516, -122.394569030961)
166786 188760 3 5 150x Executive Park Blvd 2 3 1 2     20 Width 8ft   6013911.80932 2087014.9974599998 37.7113282966477 -122.393711220721 (37.7113282966477, -122.393711220721)
Powered by Datasette · Query took 41.433ms · Data source: data.sfgov.org