sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
131575 132122 2 100 640 The Embarcadero 5 1 1 1     19 Width 5ft   6014219.48603 2117650.76237 37.7954646414426 -122.39479193780599 (37.7954646414426, -122.394791937806)
131945 194301 2 100 550 The Embarcadero 4 1 1 1     25 Width 5ft   6014450.94814 2117319.50323 37.794567948092606 -122.393967833244 (37.7945679480926, -122.393967833244)
132845 234388 2 100 1069 Dolores St 2 1 1 1     30 Width 5ft   6005149.23502 2102137.71701 37.7523610979942 -122.425072246905 (37.7523610979942, -122.425072246905)
136703 178086 2 100 364 Capistrano Ave 1 1 1 1     43 Width 3ft   6001063.00753 2092653.5980599998 37.7260882551546 -122.438523588412 (37.7260882551546, -122.438523588412)
137503 234343 2 100 769 Dolores St 2 1 1 1     3 Width 7ft   6005056.066269999 2103868.0427200003 37.7571069049763 -122.42551757317601 (37.7571069049763, -122.425517573176)
138450 28224 3 100 399X King St 7 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
138478 24290 3 100 386 Winding Way 1 1 1 2     12 3X17   6000963.19469 2086697.3561200001 37.709728074949204 -122.43844208303699 (37.7097280749492, -122.438442083037)
139057 28221 3 100 399X King St 4 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
139986 1443 1 100 151X Arguello Blvd 1 1 1 1     36 3X5   5995492.27499 2115135.20138 37.7874985527143 -122.459408560713 (37.7874985527143, -122.459408560713)
142373 87850 1 100 94 Teresita Blvd 1 1 1 1       3x3 Permit Number 50753 5997405.9 2099153.7 37.7437272652603 -122.45163459365601 (37.7437272652603, -122.451634593656)
149136 234366 2 100 9 Duncan St 2 1 1 1     8 Width 3ft   6006381.599330001 2099941.08815 37.746399194477206 -122.420654601644 (37.7463991944772, -122.420654601644)
157078 120819 2 100 101 20th Ave 5 1 1 1     22 Width 5ft   5989573.42956 2114582.3778 37.7856385654779 -122.47984587101999 (37.7856385654779, -122.47984587102)
158189 234383 2 100 3483 22nd St 2 1 1 1     3 Width 3ft   6005156.87556 2103096.1087599997 37.7549930502992 -122.425114011399 (37.7549930502992, -122.425114011399)
159189 234375 2 100 581 Dolores St 5 1 1 1     12 Width 9ft   6004995.06327 2105009.72546 37.760238249920604 -122.425809806971 (37.7602382499206, -122.425809806971)
162909 194305 2 100 500 The Embarcadero 3 1 1 1     28 Width 5ft   6014543.5989 2117243.74376 37.7943650790379 -122.393641942341 (37.7943650790379, -122.393641942341)
163198 234393 2 100 1557 Sanchez St 2 1 1 1     7 Width 3ft   6003994.29589 2099192.81462 37.7442097715744 -122.42885628561001 (37.7442097715744, -122.42885628561)
163255 132126 2 100 640 The Embarcadero 9 1 1 1     16 Width 5ft   6014272.27117 2117547.1339 37.7951830367225 -122.394602030674 (37.7951830367225, -122.394602030674)
163649 132127 2 100 640 The Embarcadero 10 1 1 1     27 Width 5ft   6014286.02329 2117523.57721 37.79511912011571 -122.39455279549401 (37.7951191201157, -122.394552795494)
164059 178087 2 100 201 Chicago Way 1 1 1 1     28 Width 3ft   6003003.324659999 2086943.97699 37.7105210777575 -122.431408625424 (37.7105210777575, -122.431408625424)
170253 178084 2 100 210 Tocoloma Ave 1 1 1 1     19 Width 3ft   6012735.74773 2087515.03594 37.7126358803078 -122.39781106804199 (37.7126358803078, -122.397811068042)
170283 234385 2 100 384 Page St 2 1 1 1     10 Width 3ft   6004737.93375 2109866.7423400003 37.773559918201606 -122.427045042888 (37.7735599182016, -122.427045042888)
173668 194302 2 100 550 The Embarcadero 5 1 1 1     29 Width 5ft   6014474.29881 2117301.48742 37.7945197786065 -122.393885774627 (37.7945197786065, -122.393885774627)
174857 234391 2 100 1600 Dolores St 3 1 1 1     5 Width 6ft   6005241.74432 2098978.16752 37.743690926593295 -122.424527610268 (37.7436909265933, -122.424527610268)
175193 182680 2 100 2701 Moraga St 1 1 1 1     7 Width 0ft   5985854.1638 2103629.5919999997 37.7553485282392 -122.491906624733 (37.7553485282392, -122.491906624733)
177164 234402 2 100 667 Waller St 1 1 1 1     23 Width 3ft   6002514.48058 2108813.7305400004 37.7705426279609 -122.434660977745 (37.7705426279609, -122.434660977745)
179975 234373 2 100 581 Dolores St 3 1 1 1     3 Width 9ft   6004999.25531 2105001.6441599997 37.76021629747461 -122.42579473344401 (37.7602162974746, -122.425794733444)
181231 234403 2 100 175 Valencia St 5 1 1 1     23 Width 6ft   6006066.151819999 2108969.9418900004 37.771172536524794 -122.42238679931101 (37.7711725365248, -122.422386799311)
182278 210908 2 100 1351 06th Ave 1 1 1 1     1 Width 4ft   5994231.8356099995 2106400.1375599997 37.7634418445856 -122.463135347428 (37.7634418445856, -122.463135347428)
183774 132118 2 100 640 The Embarcadero 1 1 1 1     26 Width 5ft   6014172.89911 2117759.32578 37.795760140682894 -122.394960745056 (37.7957601406829, -122.394960745056)
185824 234392 2 100 1379 Dolores St 2 1 1 1     8 Width 7ft   6005257.78896 2100266.47383 37.7472292273428 -122.424563754022 (37.7472292273428, -122.424563754022)
188102 234372 2 100 3782 26th St 1 1 1 1     32 Width 3ft   6005314.45638 2100807.30331 37.74871742098671 -122.424406263843 (37.7487174209867, -122.424406263843)
608 233928 2 100 8 Octavia St Frontage East 1 2 1 1     29 Width 8ft   6005775.18179 2109348.30824 37.77219502161479 -122.423420179704 (37.7721950216148, -122.423420179704)
25380 124656 2 100 1 Presidio Ter 1 2 1 1     24 Width 7ft   5995441.43994 2115441.36584 37.7883362746058 -122.45960662195401 (37.7883362746058, -122.459606621954)
26482 210923 2 100 1540 Plymouth Ave 2 2 1 1     41 Width 3ft   5995839.221390001 2094293.33064 37.7302920326405 -122.456700326779 (37.7302920326405, -122.456700326779)
28217 210914 2 100 317 Dorantes Ave 1 2 1 1     25 Width 3ft   5993048.097569999 2099658.5212 37.744862847537206 -122.46673939310301 (37.7448628475372, -122.466739393103)
30590 118002 2 100 7 Shore View Ave 2 2 1 1     5 Width 8ft   5984637.38492 2112844.95185 37.780580098776795 -122.49679463074699 (37.7805800987768, -122.496794630747)
35628 210924 2 100 1540 Plymouth Ave 5 2 1 1     43 Width 3ft   5995827.117740001 2094309.51389 37.730335772973206 -122.45674334043699 (37.7303357729732, -122.456743340437)
35925 234399 2 100 319 Virginia Ave 5 2 1 1     39 Width 3ft   6006918.01461 2098154.19018 37.7415229912067 -122.418673038125 (37.7415229912067, -122.418673038125)
39528 194389 2 100 1031 Key Ave 4 2 1 1     36     6013123.75243 2089902.89375 37.7192140640518 -122.396637279208 (37.7192140640518, -122.396637279208)
42292 234344 2 100 751 Dolores St 1 2 1 1     5 Width 6ft   6005051.924 2103931.9938 37.757282265587 -122.42553644996299 (37.757282265587, -122.425536449963)
42834 194390 2 100 1031 Key Ave 5 2 1 1     29     6013152.66051 2089880.8718700001 37.719155205216104 -122.396535811395 (37.7191552052161, -122.396535811395)
43303 210921 2 100 380 Kingston St 2 2 1 1     37 Width 4ft   5994023.0507 2099217.557 37.7437082889086 -122.46333622000601 (37.7437082889086, -122.463336220006)
48345 194388 2 100 1031 Key Ave 3 2 1 1     40     6013107.94825 2089911.6587099999 37.7192372512804 -122.39669252276501 (37.7192372512804, -122.396692522765)
48989 233929 2 100 8 Octavia St 2 2 1 1     31     6005769.81739 2109368.12443 37.77224912933389 -122.42344014465901 (37.7722491293339, -122.423440144659)
57644 210918 2 100 380 Kingston St 6 2 1 1     37 Width 4ft   5994017.59782 2099245.20708 37.7437838949233 -122.463357080672 (37.7437838949233, -122.463357080672)
58910 234395 2 100 217 Ogden Ave 1 2 1 1     15 Width 4ft   6008499.5527 2096078.48845 37.735912484272205 -122.413057867339 (37.7359124842722, -122.413057867339)
63387 210922 2 100 380 Kingston St 1 2 1 1     39 Width 4ft   5994038.377230001 2099205.2198900003 37.7436752972852 -122.463282329909 (37.7436752972852, -122.463282329909)
66140 118759 2 100 544 45th Ave 1 2 1 1     43 Width 5ft   5981951.74748 2112030.16523 37.7781852088244 -122.50602493975501 (37.7781852088244, -122.506024939755)
70473 210915 2 100 587 Dewey Blvd 3 2 1 1     38 Width 4ft   5994038.34106 2099299.34237 37.743933731866605 -122.463289283487 (37.7439337318666, -122.463289283487)
72691 234342 2 100 500 Dolores St 27 2 1 1     35 Width 6ft   6004943.9168300005 2104413.64545 37.7585986644128 -122.425944266413 (37.7585986644128, -122.425944266413)
76588 247039 2 100 574 Valley St 1 2 1 1     33 Width 6ft   6002246.4280199995 2099186.76685 37.7440940809725 -122.43489959305 (37.7440940809725, -122.43489959305)
123442 210919 2 100 380 Kingston St 5 2 1 1     37 Width 4ft   5994015.85922 2099234.22929 37.7437536525071 -122.463362295833 (37.7437536525071, -122.463362295833)
149367 234380 2 100 1001 San Jose Ave 4 2 1 1     9 Width 3ft   6005142.82168 2096774.43039 37.7376343766353 -122.424712922782 (37.7376343766353, -122.424712922782)
151219 210920 2 100 380 Kingston St 4 2 1 1     37 Width 4ft   5994018.2668699995 2099229.1721099997 37.7437399054734 -122.463353603909 (37.7437399054734, -122.463353603909)
159196 210916 2 100 587 Dewey Blvd 2 2 1 1     38 Width 4ft   5994027.5569 2099288.55437 37.7439034894442 -122.46332578967 (37.7439034894442, -122.46332578967)
162443 194387 2 100 1031 Key Ave 2 2 1 1     31     6013093.20116 2089924.2998099998 37.7192711404238 -122.39674438396099 (37.7192711404238, -122.396744383961)
162688 210917 2 100 380 Kingston St 8 2 1 1     37 Width 4ft   5994023.9222099995 2099259.0924400003 37.7438223849926 -122.46333621999399 (37.7438223849926, -122.463336219994)
170613 194296 2 100 1799 Revere Ave 6 2 1 1     38     6014052.02799 2095141.7859200002 37.733650626363 -122.393795063609 (37.733650626363, -122.393795063609)
176009 234379 2 100 246 Bemis St 4 2 1 1     39     6003018.34772 2096316.7253 37.736257406663704 -122.432025563025 (37.7362574066637, -122.432025563025)
179136 124657 2 100 30 Presidio Ter 1 2 1 1     30 Width 7ft   5995444.46973 2115398.79213 37.7882195529326 -122.459593054716 (37.7882195529326, -122.459593054716)
181931 247638 2 100 360 Bradford St 2 2 1 1     15     6009465.98098 2096572.55437 37.7373232876386 -122.40975139021499 (37.7373232876386, -122.409751390215)
183295 194277 2 100 1301 Rhode Island St 1 2 1 1     48 Width 7ft   6012002.23785 2102241.02504 37.7530294975215 -122.401380567153 (37.7530294975215, -122.401380567153)
186407 194386 2 100 1031 Key Ave 1 2 1 1     32     6013080.03152 2089934.31035 37.7192978943535 -122.396790608192 (37.7192978943535, -122.396790608192)
188962 182197 2 100 1584 36th Ave 1 2 1 1     33 Width 0ft   5985008.2078 2104414.5267 37.7574542590905 -122.494890024235 (37.7574542590905, -122.494890024235)
22823 251110 9 100 1700X Quesada Ave 5 3 1 2                    
22825 251109 9 100 1700X Quesada Ave 3 3 1 2                    
22828 251115 9 100 1700X Quesada Ave 19 3 1 2                    
22831 251116 9 100 1700X Quesada Ave 20 3 1 2                    
22832 251108 9 100 1700X Quesada Ave 2 3 1 2                    
22833 251113 9 100 1700X Quesada Ave 15 3 1 2                    
22838 251111 9 100 1700X Quesada Ave 7 3 1 2                    
22839 251114 9 100 1700X Quesada Ave 16 3 1 2                    
23802 132129 3 100 500x The Embarcadero 9 3 1 2     24 Width 10ft   6013671.61354 2118630.60451 37.79812457884061 -122.39675640879999 (37.7981245788406, -122.3967564088)
24494 233935 3 100 150x Dolores St 9 3 1 2     30     6004826.52958 2107279.95522 37.766462234780604 -122.426554344032 (37.7664622347806, -122.426554344032)
25048 132103 3 100 1400x The Embarcadero 1 3 1 2     18 Width 10ft   6012095.78368 2120981.89347 37.8044928149639 -122.402374687645 (37.8044928149639, -122.402374687645)
25236 194362 3 100 380x The Embarcadero 9 3 1 2     29 Width 8ft   6016123.073030001 2114362.8388099996 37.786542411639 -122.38797559828899 (37.786542411639, -122.387975598289)
25390 132077 3 100 1100x The Embarcadero 7 3 1 2     23 Width 10ft   6012714.4120000005 2120058.1365799997 37.8019909162964 -122.400168938451 (37.8019909162964, -122.400168938451)
25996 194361 3 100 380x The Embarcadero 8 3 1 2     28 Width 8ft   6016114.70966 2114269.45463 37.786285536482296 -122.38799801482 (37.7862855364823, -122.38799801482)
26160 194311 3 100 380x The Embarcadero 3 3 1 2     21 Width 7ft   6015171.2298099995 2116694.38601 37.79289152546961 -122.39143182424401 (37.7928915254696, -122.391431824244)
27134 194292 3 100 1700x Quesada Ave 43 3 1 2     38     6014354.24031 2095291.86255 37.734079495961396 -122.392760714642 (37.7340794959614, -122.392760714642)
27286 132113 3 100 1000x The Embarcadero 2 3 1 2     21 Width 10ft   6013330.52243 2119204.92075 37.7996825238869 -122.39797700193701 (37.7996825238869, -122.397977001937)
27329 194334 3 100 88x King St 10 3 1 2     30 Width 8ft   6015942.04821 2112270.67914 37.7807877820727 -122.388455820993 (37.7807877820727, -122.388455820993)
27355 234354 3 100 650x Dolores St 1 3 1 2     23     6004979.813630001 2104508.3497200003 37.7588607286626 -122.425826859935 (37.7588607286626, -122.425826859935)
27594 194293 3 100 1700x Quesada Ave 46 3 1 2     28     6014318.796490001 2095319.19207 37.7341525685742 -122.392885167337 (37.7341525685742, -122.392885167337)
29064 194335 3 100 88x King St 11 3 1 2     30 Width 8ft   6015932.5598 2112347.87113 37.7809992081901 -122.38849403588999 (37.7809992081901, -122.38849403589)
29492 194379 3 100 300x The Embarcadero 2 3 1 2     30 Width 8ft   6015888.45756 2115624.95631 37.7899948982019 -122.388875463533 (37.7899948982019, -122.388875463533)
30823 132092 3 100 1500x The Embarcadero 12 3 1 2     20 Width 10ft   6011191.46105 2121714.3637599996 37.806453474602 -122.405555813649 (37.806453474602, -122.405555813649)
32862 132075 3 100 1100x The Embarcadero 3 3 1 2     23 Width 10ft   6012816.85763 2119903.53523 37.8015721299035 -122.399803563704 (37.8015721299035, -122.399803563704)
33156 234362 3 100 1150x Dolores St 4 3 1 2     25     6005144.45634 2101528.47617 37.7506879938715 -122.425045428228 (37.7506879938715, -122.425045428228)
33192 194377 3 100 310x The Embarcadero 14 3 1 2     28 Width 8ft   6016027.16358 2115370.7776 37.789304668530896 -122.388377800289 (37.7893046685309, -122.388377800289)
35273 233937 3 100 230x Dolores St 3 3 1 2     32     6004843.94175 2106947.59382 37.7655506342911 -122.42647045077801 (37.7655506342911, -122.426470450778)
35368 194364 3 100 310x The Embarcadero 1 3 1 2     30 Width 8ft   6016200.86003 2114659.13107 37.78736027221179 -122.387727152497 (37.7873602722118, -122.387727152497)
35608 194288 9 100 1700x Quesada Ave 37 3 1 2     34     6014411.93404 2095259.01392 37.733992504551296 -122.392558950849 (37.7339925045513, -122.392558950849)
35716 194337 3 100 88x King St 13 3 1 2     29 Width 8ft   6015953.29851 2112409.5704799998 37.781169770014294 -122.38842659752198 (37.7811697700143, -122.388426597522)
35928 194284 3 100 1700x Quesada Ave 20 3 1 2     31     6014504.15008 2095180.2076400002 37.733781239407 -122.392234619349 (37.733781239407, -122.392234619349)
37174 132080 3 100 1100x The Embarcadero 13 3 1 2     26 Width 10ft   6012562.54875 2120282.53748 37.802598598112 -122.40071023410101 (37.802598598112, -122.400710234101)
38595 234356 3 100 650x Dolores St 3 3 1 2     22     6004985.9304599995 2104422.99085 37.7586266989802 -122.42579962935301 (37.7586266989802, -122.425799629353)
39870 194287 9 100 1700x Quesada Ave 32 3 1 2     31     6014435.322380001 2095233.3766599998 37.733923408722795 -122.392476296866 (37.7339234087228, -122.392476296866)
41054 194324 3 100 400x The Embarcadero 5 3 1 2     18 Width 7ft   6014719.872819999 2117222.0655900002 37.7943153492131 -122.39303049145701 (37.7943153492131, -122.393030491457)
41120 233936 3 100 230x Dolores St 2 3 1 2     34     6004841.8872 2106976.70647 37.7656304545194 -122.42647963012699 (37.7656304545194, -122.426479630127)
41127 132091 3 100 1500x The Embarcadero 10 3 1 2     21 Width 10ft   6011272.98764 2121658.8993 37.806305741188204 -122.405269766312 (37.8063057411882, -122.405269766312)
Powered by Datasette · Query took 10.37ms · Data source: data.sfgov.org