sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
81864 28226 3 100 399X King St 9 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
85028 18558 3 100 1700X Quesada Ave 13 11 1 2     12 19   6014793.6967997 2095004.1424748 37.7333138733401 -122.39122125893199 (37.7333138733401, -122.391221258932)
86395 18554 3 100 1700X Quesada Ave 9 11 1 2     12 19   6014793.6967997 2095004.1424748 37.7333138733401 -122.39122125893199 (37.7333138733401, -122.391221258932)
87635 28186 3 100 299X King St 4 1 1 2     12 6   6014324.7762427 2110655.2584450003 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457)
89467 28227 3 100 399X King St 10 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
92311 28184 3 100 299X King St 2 1 1 2     12 6   6014324.7762427 2110655.2584450003 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457)
93618 28237 3 100 399X King St 20 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
96175 28191 3 100 299X King St 9 1 1 2     12 6   6014324.7762427 2110655.2584450003 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457)
102777 28189 3 100 299X King St 7 1 1 2     12 6   6014324.7762427 2110655.2584450003 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457)
103796 28225 3 100 399X King St 8 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
104151 28188 3 100 299X King St 6 1 1 2     12 6   6014324.7762427 2110655.2584450003 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457)
107571 28235 3 100 399X King St 18 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
107778 28192 3 100 299X King St 10 1 1 2     12 6   6014324.7762427 2110655.2584450003 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457)
108524 28230 3 100 399X King St 13 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
109189 27850 1 100 100 The Embarcadero 5 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015895.51701 2112292.73501 37.7808457639334 -122.38861833648701 (37.7808457639334, -122.388618336487)
111408 28223 3 100 399X King St 6 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
111889 28228 3 100 399X King St 11 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
115023 28238 3 100 399X King St 21 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
116814 28222 3 100 399X King St 5 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
117445 27852 1 100 100 The Embarcadero 7 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015817.39201 2112182.05801 37.780537539741395 -122.388880882265 (37.7805375397414, -122.388880882265)
117955 28218 3 100 399X King St 1 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
119895 28234 3 100 399X King St 17 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
120266 27849 1 100 100 The Embarcadero 4 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015921.55801 2112354.58401 37.7810170305764 -122.388532565578 (37.7810170305764, -122.388532565578)
122472 28187 3 100 299X King St 5 1 1 2     12 6   6014324.7762427 2110655.2584450003 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457)
124299 28233 3 100 399X King St 16 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
124386 28193 3 100 299X King St 11 1 1 2     12 6   6014324.7762427 2110655.2584450003 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457)
124429 28219 3 100 399X King St 2 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
125243 28183 3 100 299X King St 1 1 1 2     12 6   6014324.7762427 2110655.2584450003 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457)
126124 25683 1 100 100 The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 12 3X3   6015960.62101 2112553.15201 37.781564418481004 -122.388411289639 (37.781564418481, -122.388411289639)
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)
139779 27853 1 100 100 The Embarcadero 8 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015772.90401 2112134.31501 37.780403982219205 -122.389031454309 (37.7804039822192, -122.389031454309)
139983 27851 1 100 100 The Embarcadero 6 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015857.5390099995 2112236.31101 37.7806887314792 -122.388745782008 (37.7806887314792, -122.388745782008)
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)
187874 194313 3 100 380x The Embarcadero 5 3 1 2     12 Width 7ft   6015116.8381 2116756.98357 37.793060384871 -122.391624402345 (37.793060384871, -122.391624402345)
130104 210913 2 100 1800 18th Ave 4 1 1 1     13 Width 4ft   5990641.4505900005 2103071.06132 37.754093605056795 -122.47531013997101 (37.7540936050568, -122.475310139971)
101242 27788 1 100 199X The Embarcadero 5 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
140643 27786 1 100 199X The Embarcadero 3 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
145407 27787 1 100 199X The Embarcadero 4 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
29021 234332 2 100 420 Dolores St 5 9 1 1     15 Width 3ft   6004849.34041 2105800.52772 37.7624013694379 -122.42637009990601 (37.7624013694379, -122.426370099906)
39479 234374 2 100 581 Dolores St 4 1 1 1     15 Width 9ft   6004996.87402 2105008.5457599997 37.760235113069896 -122.425803460464 (37.7602351130699, -122.425803460464)
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)
151716 194282 2 100 2 Tulare St 6 7 1 1     15     6016226.55416 2100307.94064 37.7479564371431 -122.386637143603 (37.7479564371431, -122.386637143603)
171516 194323 3 100 400x The Embarcadero 4 3 1 2     15 Width 7ft   6014746.37404 2117187.8708099998 37.7942229303951 -122.39293639989201 (37.7942229303951, -122.392936399892)
181931 247638 2 100 360 Bradford St 2 2 1 1     15     6009465.98098 2096572.55437 37.7373232876386 -122.40975139021499 (37.7373232876386, -122.409751390215)
724 25734 1 100 500X The Embarcadero 4 11 1 9   08/15/1996 12:00:00 AM 16 10   6013899.49111 2118360.1858599996 37.7973947538281 -122.395948920127 (37.7973947538281, -122.395948920127)
1312 25735 1 100 500X The Embarcadero 5 11 1 9   08/15/1996 12:00:00 AM 16 10   6013816.07307 2118422.78251 37.7975619881486 -122.396241959692 (37.7975619881486, -122.396241959692)
73625 178085 2 100 210 Tocoloma Ave 6 1 1 1     16 Width 3ft   6012726.322790001 2087488.8573099999 37.712563474091894 -122.397841808652 (37.7125634740919, -122.397841808652)
78576 25731 1 100 501X The Embarcadero 1 11 1 9   08/15/1996 12:00:00 AM 16 10   6013387.7643744005 2119020.8269614 37.799180234142106 -122.39776600258999 (37.7991802341421, -122.39776600259)
112637 25732 1 100 501X The Embarcadero 2 11 1 9   08/15/1996 12:00:00 AM 16 10   6013387.7643744005 2119020.8269614 37.799180234142106 -122.39776600258999 (37.7991802341421, -122.39776600259)
124202 25733 1 100 501X The Embarcadero 3 11 1 9   08/15/1996 12:00:00 AM 16 10   6013387.7643744005 2119020.8269614 37.799180234142106 -122.39776600258999 (37.7991802341421, -122.39776600259)
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)
30035 194392 3 100 860x Jamestown Ave 5 11 1 2     17 Width 5ft   6014755.052209999 2089115.5775900001 37.7171429037943 -122.39094345187799 (37.7171429037943, -122.390943451878)
47529 132102 3 100 1200x The Embarcadero 2 3 1 2     17 Width 10ft   6012409.883230001 2120572.1173400003 37.8033851982182 -122.401258897879 (37.8033851982182, -122.401258897879)
137882 132117 3 100 1000x The Embarcadero 10 3 1 2     17 Width 10ft   6013132.776319999 2119506.7755299998 37.800500329583 -122.398682475136 (37.800500329583, -122.398682475136)
9337 113319 1 100 100 VALENCIA ST 1 1 1 1     18 3x3   6005986.0 2109035.0 37.7713466487942 -122.42266867187 (37.7713466487942, -122.42266867187)
15304 19794 3 100 100 STAIRWAY19 16 1 1 2     18 50ST            
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)
32517 234386 2 100 800 Dolores St 2 1 1 1     18 Width 3ft   6004984.24145 2103652.12046 37.7565099745835 -122.42575060280899 (37.7565099745835, -122.425750602809)
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)
44784 132123 2 100 640 The Embarcadero 6 1 1 1     18 Width 5ft   6014232.87879 2117626.20085 37.795397945911205 -122.394743875326 (37.7953979459112, -122.394743875326)
48105 118707 2 100 4201 Balboa St 2 9 1 1     18 Width 2ft   5982546.62842 2110970.49419 37.775310661099795 -122.503888560039 (37.7753106610998, -122.503888560039)
54210 132125 2 100 640 The Embarcadero 8 1 1 1     18 Width 5ft   6014258.525909999 2117571.02815 37.79524788055 -122.39465126585199 (37.79524788055, -122.394651265852)
54710 132121 2 100 640 The Embarcadero 4 1 1 1     18 Width 5ft   6014209.141 2117675.2625 37.7955313378499 -122.39482945031999 (37.7955313378499, -122.39482945032)
56654 132101 3 100 1100x The Embarcadero 17 3 1 2     18 Width 10ft   6012520.61539 2120407.16114 37.802938445615 -122.40086410632 (37.802938445615, -122.40086410632)
68375 234369 3 100 1750x Dolores St 3 3 1 2     18     6005339.90624 2098058.76544 37.7411720001789 -122.42412281821899 (37.7411720001789, -122.424122818219)
77513 27958 1 100 307X The Embarcadero 2 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
79708 27959 1 100 307X The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
91142 28372 1 100 199X The Embarcadero 1 11 1 9     18     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
93856 27960 1 100 307X The Embarcadero 4 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
101121 27717 1 100 307X The Embarcadero 1 11 1 9   09/11/2000 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
118074 27961 1 100 307X The Embarcadero 5 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
120310 27785 1 100 199X The Embarcadero 2 11 1 9     18     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
138553 116529 3 100 745X SANCHEZ ST 6 3 1 2     18     6003713.0 2103768.0 37.7567562336472 -122.430155272915 (37.7567562336472, -122.430155272915)
140710 27962 1 100 307X The Embarcadero 6 11 1 9   02/05/2001 12:00:00 AM 18     6013768.7522982005 2118400.6344275 37.7974985415834 -122.396404150152 (37.7974985415834, -122.396404150152)
151174 194393 3 100 860x Jamestown Ave 9 11 1 2     18 Width 5ft   6014647.11529 2089218.63866 37.7174198994758 -122.391323741894 (37.7174198994758, -122.391323741894)
160623 234336 2 100 420 Dolores St 14 9 1 1     18 Width 3ft   6004864.2449199995 2105581.16954 37.7617999064621 -122.42630293226101 (37.7617999064621, -122.426302932261)
163388 233927 2 100 389 Webster St 3 4 1 1     18 Width 3ft   6004115.83529 2109995.53754 37.7738783609231 -122.429206159632 (37.7738783609231, -122.429206159632)
186247 118708 2 100 4201 Balboa St 5 9 1 1     18 Width 2ft   5982482.88801 2110969.6299 37.7753045397791 -122.504108985066 (37.7753045397791, -122.504108985066)
32439 194391 3 100 828x Jamestown Ave 4 11 1 2     19 Width 5ft   6014866.8225 2088973.5540099998 37.7167591360948 -122.39054719349899 (37.7167591360948, -122.390547193499)
41784 194394 3 100 920x Jamestown Ave 4 11 1 2     19 Width 5ft   6014490.42947 2089308.0420799998 37.717656686497506 -122.39187158462799 (37.7176566864975, -122.391871584628)
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)
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)
174052 194319 3 100 380x The Embarcadero 11 3 1 2     19 Width 7ft   6014937.91263 2116957.6212 37.793601355862705 -122.392257538577 (37.7936013558627, -122.392257538577)
177459 132104 3 100 1400x The Embarcadero 2 3 1 2     19 Width 10ft   6012041.8343 2121038.82925 37.8046461349625 -122.402565391602 (37.8046461349625, -122.402565391602)
17598 9369 1 100 276 Gold Mine Dr 1 1 1 1     20 2x2   6001136.50681 2098095.27018 37.7410340073111 -122.438659251142 (37.7410340073111, -122.438659251142)
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)
66065 132114 3 100 1000x The Embarcadero 4 3 1 2     20 Width 10ft   6013298.81612 2119255.09608 37.799818527453105 -122.39809024008001 (37.7998185274531, -122.39809024008)
69507 132112 3 100 1500x The Embarcadero 13 3 1 2     20 Width 10ft   6011208.1934400005 2121737.88602 37.8065189965151 -122.40549956557501 (37.8065189965151, -122.405499565575)
70221 132087 3 100 1500x The Embarcadero 2 3 1 2     20 Width 10ft   6011581.4658 2121414.5973099996 37.8056521894584 -122.40418501304501 (37.8056521894584, -122.404185013045)
111571 27784 1 100 399X The Embarcadero 7 11 1 9   12/01/2000 12:00:00 AM 20     6013580.156802201 2118681.7167588 37.7982598302065 -122.397076463892 (37.7982598302065, -122.397076463892)
121202 27482 3 100 990X Dolores St 2 11 1 2   10/20/1999 12:00:00 AM 20 20   6005038.29077 2102581.9809991 37.7535746757806 -122.425487524624 (37.7535746757806, -122.425487524624)
131771 132074 3 100 1000x The Embarcadero 9 3 1 2     20 Width 10ft   6013098.86351 2119482.52775 37.800431861502396 -122.39879812525601 (37.8004318615024, -122.398798125256)
133391 194310 3 100 380x The Embarcadero 2 3 1 2     20 Width 7ft   6015149.43028 2116672.0498900004 37.7928289857212 -122.39150569005301 (37.7928289857212, -122.391505690053)
135157 132081 3 100 1100x The Embarcadero 16 3 1 2     20 Width 10ft   6012501.69351 2120366.8481099997 37.802826700352995 -122.400926752172 (37.802826700353, -122.400926752172)
136050 132086 3 100 1400x The Embarcadero 3 3 1 2     20 Width 10ft   6011972.21269 2121045.33445 37.8046601095467 -122.402806783124 (37.8046601095467, -122.402806783124)
136668 194314 3 100 380x The Embarcadero 6 3 1 2     20 Width 7ft   6015030.092180001 2116803.1524 37.793182338337296 -122.39192778056601 (37.7931823383373, -122.391927780566)
152917 194273 3 100 1150x Tennessee St 16 3 1 2     20 Width 8ft   6015573.17514 2103426.7647700002 37.7564838780418 -122.38911425333 (37.7564838780418, -122.38911425333)
160227 194315 3 100 380x The Embarcadero 7 3 1 2     20 Width 7ft   6015053.743430001 2116822.79374 37.793237581902105 -122.391847319118 (37.7932375819021, -122.391847319118)
166867 132106 3 100 1500x The Embarcadero 1 3 1 2     20 Width 10ft   6011673.52168 2121373.1691 37.8055435810345 -122.40386352159099 (37.8055435810345, -122.403863521591)
Powered by Datasette · Query took 7.221ms · Data source: data.sfgov.org