sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
11230 27210 1 20 302 Silver Ave 17 1 1 1   11/28/2000 12:00:00 AM 3 3X3   6003698.299930001 2093465.5644 37.728467287514206 -122.42947142096901 (37.7284672875142, -122.429471420969)
71455 175779 2 20 302 Silver Ave 20 1 1 1     3 Width 3ft   6003783.14523 2093465.1437900001 37.728470936062706 -122.429178076504 (37.7284709360627, -122.429178076504)
10628 27211 1 20 302 Silver Ave 18 1 1 1   06/08/1999 12:00:00 AM 6 3X3   6003731.93996 2093466.46517 37.7284716654181 -122.429355189899 (37.7284716654181, -122.429355189899)
165500 175780 2 20 302 Silver Ave 21 1 1 1     1 Width 3ft   6003848.49776 2093464.0621200001 37.728471665422504 -122.4289520724 (37.7284716654225, -122.4289520724)
11548 27209 1 20 302 Silver Ave 16 1 1 1   06/08/1999 12:00:00 AM 6 3X3   6003678.0618199995 2093467.5761400003 37.728471665429396 -122.42954152854401 (37.7284716654294, -122.429541528544)
11894 27208 1 20 302 Silver Ave 15 1 1 1   06/08/1999 12:00:00 AM 6 3X3   6003655.1292 2093468.31467 37.7284723947828 -122.429620860416 (37.7284723947828, -122.429620860416)
10857 27206 3 20 302 Silver Ave 13 1 1 2   09/28/2012 12:00:00 AM 3 3X3   6003601.03384 2093471.82188 37.7284789616114 -122.429808120849 (37.7284789616114, -122.429808120849)
11918 27214 1 20 418 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 3X3   6004063.83311 2093462.31817 37.7284790632589 -122.428207522784 (37.7284790632589, -122.428207522784)
10380 27204 1 20 302 Silver Ave 11 1 1 1   02/23/2005 12:00:00 AM 3 3X3   6003546.09454 2093473.22062 37.728479690960796 -122.429998148515 (37.7284796909608, -122.429998148515)
10845 27213 1 20 408 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 3X3   6003994.27009 2093465.08607 37.728482727073995 -122.428448202938 (37.728482727074, -122.428448202938)
11852 27203 1 20 302 Silver Ave 10 1 1 1   05/04/2001 12:00:00 AM 6 3X3   6003520.15249 2093475.1012 37.7284833853765 -122.43008796558901 (37.7284833853765, -122.430087965589)
12768 27200 3 20 302 Silver Ave 7 1 1 2   02/23/2005 12:00:00 AM 3 3X3   6003430.014219999 2093478.3653900002 37.728487242572605 -122.430399810923 (37.7284872425726, -122.430399810923)
158669 175791 2 20 223 Holyoke St 1 1 1 1     7 Width 4ft   6009517.433730001 2093353.53583 37.7284874341444 -122.409346391343 (37.7284874341444, -122.409346391343)
11632 27199 1 20 302 Silver Ave 6 1 1 1   06/08/1999 12:00:00 AM 3 3X3   6003401.87305 2093484.5761900002 37.7285027019175 -122.43049753933998 (37.7285027019175, -122.43049753934)
11345 27198 1 20 302 Silver Ave 5 1 1 1   06/08/1999 12:00:00 AM 3 3X3   6003379.2285400005 2093490.3772 37.7285173473825 -122.43057623633001 (37.7285173473825, -122.43057623633)
11092 27197 1 20 302 Silver Ave 4 1 1 1   06/08/1999 12:00:00 AM 3 3X3   6003357.925480001 2093496.2985900003 37.72853239932861 -122.43065030447501 (37.7285323993286, -122.430650304475)
10875 27118 1 20 488 Silver Ave 1 1 1 1   06/09/1999 12:00:00 AM 6 3X3   6004485.4929 2093473.96445 37.7285348904523 -122.426750651627 (37.7285348904523, -122.426750651627)
80831 26977 3 20 526 Silver Ave 1 1 1 2   06/08/1999 12:00:00 AM 6 3X3   6004737.76851 2093468.91574 37.728535287917 -122.425878161452 (37.728535287917, -122.425878161452)
61855 175792 2 20 223 Holyoke St 2 1 1 1     7 Width 4ft   6009511.22188 2093372.0739 37.728537987719605 -122.409369173844 (37.7285379877196, -122.409369173844)
10985 27196 1 20 302 Silver Ave 3 1 1 1   05/04/2001 12:00:00 AM 3 3X3   6003338.54684 2093501.7358400002 37.7285462309168 -122.430717685294 (37.7285462309168, -122.430717685294)
12322 27195 1 20 302 Silver Ave 2 1 1 1   05/04/2001 12:00:00 AM 3 3X3   6003315.89626 2093507.2409400002 37.728560063388294 -122.430796382249 (37.7285600633883, -122.430796382249)
11624 27194 1 20 302 Silver Ave 1 1 1 1   05/04/2001 12:00:00 AM 6 3X3   6003295.095930001 2093512.42424 37.7285731170511 -122.430868659863 (37.7285731170511, -122.430868659863)
176001 175793 2 20 223 Holyoke St 3 1 1 1     8 Width 4ft   6009507.12766 2093386.74095 37.7285780309381 -122.409384362505 (37.7285780309381, -122.409384362505)
12696 27224 1 20 367 Silver Ave 1 1 1 1   06/26/1999 12:00:00 AM 3 3X3   6003787.64028 2093509.2466099998 37.728592287005604 -122.429165680266 (37.7285922870056, -122.429165680266)
13092 27221 1 20 385 Silver Ave 1 1 1 1   06/26/1999 12:00:00 AM 10 3x3   6003913.32371 2093508.9041799998 37.7285984608493 -122.428731161129 (37.7285984608493, -122.428731161129)
12660 27219 1 20 391 Silver Ave 1 1 1 1   08/10/1999 12:00:00 AM 6 3X3   6003983.54515 2093507.70675 37.728599147032 -122.428488316285 (37.728599147032, -122.428488316285)
12081 27218 3 20 393 Silver Ave 1 1 1 2   08/10/1999 12:00:00 AM 6 3x3   6004009.64112 2093507.9183200002 37.728601204683706 -122.42839811609699 (37.7286012046837, -122.428398116097)
159078 175794 2 20 223 Holyoke St 4 1 1 1     7 Width 4ft   6009502.30517 2093401.60497 37.7286185741876 -122.409402082759 (37.7286185741876, -122.409402082759)
50086 113271 1 20 1321 Revere Ave   1 1 1   09/16/2015 12:00:00 AM     Permit Number 774420 6016529.9 2093260.0 37.7286210040554 -122.38509718743299 (37.7286210040554, -122.385097187433)
10789 27116 1 20 431 Silver Ave 1 1 1 1   11/28/2000 12:00:00 AM 3 3X3   6004280.51311 2093512.4294900002 37.7286289154695 -122.42746201715599 (37.7286289154695, -122.427462017156)
11914 27040 1 20 590 Silver Ave 1 1 1 1   05/26/1999 12:00:00 AM 6 3X3   6005314.150169999 2093510.97607 37.728683332565396 -122.423888566416 (37.7286833325654, -122.423888566416)
12561 27049 1 20 910 Silver Ave 1 1 1 1   05/27/1999 12:00:00 AM 6 3x3   6007348.52678 2093482.2197099999 37.7287190140661 -122.41685354777701 (37.7287190140661, -122.416853547777)
173434 47219 1 20 102 Colby St 2 1 1 1 1 05/09/2002 12:00:00 AM 6   Permit Number 45167 6008176.9578 2093476.05572 37.7287486521041 -122.413989164793 (37.7287486521041, -122.413989164793)
72258 47216 1 20 102 Colby St 1 1 1 1 1 05/09/2002 12:00:00 AM 4   Permit Number 45167 6008173.05313 2093488.0369799999 37.728781330768896 -122.41400351077299 (37.7287813307689, -122.414003510773)
13190 27285 1 20 670 Silver Ave 1 1 1 1   05/26/1999 12:00:00 AM 3 3X3   6005819.54085 2093537.91486 37.728785819299105 -122.422143310586 (37.7287858192991, -122.422143310586)
133403 175786 2 20 913 Silliman St 1 1 1 1     4 Width 3ft   6008114.21781 2093492.5462599997 37.728790407640794 -122.41420722787599 (37.7287904076408, -122.414207227876)
135580 175787 2 20 913 Silliman St 2 1 1 1     5 Width 3ft   6008123.2351400005 2093495.1719799999 37.7287981238093 -122.414176239965 (37.7287981238093, -122.414176239965)
184588 175788 2 20 913 Silliman St 3 1 1 1     4 Width 3ft   6008132.91971 2093497.9491400002 37.7288062932694 -122.414142956056 (37.7288062932694, -122.414142956056)
12570 27105 1 20 595 Silver Ave 1 1 1 1   06/26/1999 12:00:00 AM 3 3X3   6005329.57476 2093556.08719 37.728808068530796 -122.42383844898701 (37.7288080685308, -122.423838448987)
10695 27041 1 20 708 Silver Ave 1 1 1 1   05/26/1999 12:00:00 AM 7     6006055.4905900005 2093548.93813 37.728829392352 -122.42132839800199 (37.728829392352, -122.421328398002)
98121 47220 1 20 102 Colby St 3 1 1 1 1 05/09/2002 12:00:00 AM     Permit Number 45167 6008165.27144692 2093507.30784615 37.7288338073717 -122.414031775389 (37.7288338073717, -122.414031775389)
115878 47217 1 20 102 Colby St 6 1 1 1 1 05/09/2002 12:00:00 AM     Permit Number 45167 6008165.27144692 2093507.30784615 37.7288338073717 -122.414031775389 (37.7288338073717, -122.414031775389)
120251 47218 1 20 102 Colby St 5 1 1 1 1 05/09/2002 12:00:00 AM     Permit Number 45167 6008165.27144692 2093507.30784615 37.7288338073717 -122.414031775389 (37.7288338073717, -122.414031775389)
124336 47221 1 20 102 Colby St 4 1 1 1 1 05/09/2002 12:00:00 AM     Permit Number 45167 6008165.27144692 2093507.30784615 37.7288338073717 -122.414031775389 (37.7288338073717, -122.414031775389)
11796 27192 1 20 284 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2X3   6003080.50306 2093615.49168 37.7288439559672 -122.431617874266 (37.7288439559672, -122.431617874266)
11427 27057 3 20 945 Silver Ave 1 1 1 2   06/25/1999 12:00:00 AM 7 2X3   6007415.89764 2093543.05958 37.72888985646029 -122.416624950003 (37.7288898564603, -122.416624950003)
12957 27096 1 20 707 Silver Ave 1 1 1 1   03/17/2006 12:00:00 AM 3 3X3   6006037.723730001 2093592.8940700002 37.7289490840269 -122.42139293964199 (37.7289490840269, -122.421392939642)
78376 36468 1 20 1469 Plymouth Ave 1 1 1 1 1 05/18/1998 12:00:00 AM     Permit Number 39366 5995883.06149021 2093810.4895036 37.728968784247705 -122.456513863949 (37.7289687842477, -122.456513863949)
89646 27087 1 20 743X Silver Ave 2 1 1 1   06/26/1999 12:00:00 AM 6 2X3   6006221.2435099995 2093597.03752 37.7289708064437 -122.420758791245 (37.7289708064437, -122.420758791245)
122819 27088 1 20 743X Silver Ave 3 1 1 1   06/26/1999 12:00:00 AM 6 2X3   6006210.7557 2093597.31773 37.728970984710294 -122.42079506833099 (37.7289709847103, -122.420795068331)
150799 175784 2 20 741 Silver Ave 2 1 1 1     8 Width 2ft   6006219.087180001 2093598.2968400002 37.7289741427237 -122.420766335217 (37.7289741427237, -122.420766335217)
176762 175785 2 20 741 Silver Ave 3 1 1 1     6 Width 2ft   6006201.21806 2093598.82119 37.7289745752989 -122.420828147413 (37.7289745752989, -122.420828147413)
124216 27086 1 20 743X Silver Ave 1 1 1 1   06/26/1999 12:00:00 AM 6 2X3   6006263.01382 2093613.9745099999 37.7290196659204 -122.42061558974702 (37.7290196659204, -122.420615589747)
10587 27191 1 20 270 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2X3   6002970.12798 2093687.91706 37.729036562883 -122.43200461784299 (37.729036562883, -122.432004617843)
25555 175783 2 20 771 Silver Ave 1 1 1 1     6 Width 3ft   6006465.53434 2093625.53998 37.729062833884605 -122.419916279827 (37.7290628338846, -122.419916279827)
12742 27190 3 20 266 Silver Ave 1 1 1 2   06/08/1999 12:00:00 AM 6 2X3   6002951.03979 2093700.24177 37.729069321573604 -122.432071486902 (37.7290693215736, -122.432071486902)
185696 175790 2 20 79 Colby St 2 9 1 1     11 Width 6ft   6008193.10922 2093597.69816 37.7290835632519 -122.413941929669 (37.7290835632519, -122.413941929669)
27115 175782 2 20 769 Silver Ave 1 1 1 1     10 Width 3ft   6006531.05237 2093633.80708 37.729089224484795 -122.419690364741 (37.7290892244848, -122.419690364741)
136571 175789 2 20 1038 Silver Ave 2 1 1 1     6 Width 3ft   6007776.24891 2093611.0245700001 37.7290967338157 -122.415383996168 (37.7290967338157, -122.415383996168)
10609 27189 1 20 262 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2X3   6002929.54622 2093714.9160799999 37.729108395319706 -122.432146839331 (37.7291083953197, -122.432146839331)
86882 27082 1 20 799X Silver Ave 4 1 1 1   12/08/2000 12:00:00 AM 6 2X3   6006577.59669 2093640.7294700001 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915)
100453 27079 3 20 799X Silver Ave 1 1 1 2   06/26/1999 12:00:00 AM 8 2X3   6006577.59669 2093640.7294700001 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915)
143415 27238 3 20 275 Silver Ave 1 1 1 2   06/26/1999 12:00:00 AM 6 3X3   6003040.40904 2093714.4077 37.729113284389 -122.43176354159401 (37.729113284389, -122.431763541594)
73669 204638 2 20 181 Staples Ave 7 1 1 1     10 Width 1ft   5998850.558130001 2093801.2422 37.729113316421106 -122.44625438283701 (37.7291133164211, -122.446254382837)
32358 204636 2 20 181 Staples Ave 2 1 1 1     11 Width 1ft   5998882.21711 2093801.6387 37.729116213139704 -122.446144964113 (37.7291162131397, -122.446144964113)
63144 204637 2 20 181 Staples Ave 6 1 1 1     9 Width 1ft   5998869.73196 2093802.12764 37.7291168426482 -122.446188161278 (37.7291168426482, -122.446188161278)
105413 101601 2 20 180X Staples Ave 1 1 1 1     5 2x2   5998894.7 2093810.1 37.7291401587489 -122.446102418286 (37.7291401587489, -122.446102418286)
113526 101605 2 20 180X Staples Ave 3 1 1 1     5 2x2   5998894.7 2093810.1 37.7291401587489 -122.446102418286 (37.7291401587489, -122.446102418286)
125961 101604 2 20 180X Staples Ave 2 1 1 1     5 2x2   5998894.7 2093810.1 37.7291401587489 -122.446102418286 (37.7291401587489, -122.446102418286)
12234 27239 1 20 267 Silver Ave 1 1 1 1   02/19/2004 12:00:00 AM 3 3X3   6002994.26296 2093731.2602 37.7291569416186 -122.431924275083 (37.7291569416186, -122.431924275083)
115613 27054 1 20 1048X Silver Ave 2 1 1 1   05/27/1999 12:00:00 AM 6 3X3   6007856.910540001 2093638.04837 37.7291754686195 -122.41510705369 (37.7291754686195, -122.41510705369)
10716 27187 1 20 250 Silver Ave 1 1 1 1   11/25/2002 12:00:00 AM 6 2X3   6002862.24087 2093754.97277 37.7292145657007 -122.43238237894501 (37.7292145657007, -122.432382378945)
13026 27186 1 20 246 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2x3   6002844.3159300005 2093767.7045599998 37.729248507888606 -122.432445255941 (37.7292485078886, -122.432445255941)
104783 96999 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
125835 97004 7 20 195A Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
12304 27185 1 20 238 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2X3   6002801.11945 2093793.8954 37.7293179724305 -122.43259645987101 (37.7293179724305, -122.432596459871)
12164 27184 1 20 234 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2x3   6002780.32065 2093807.2617400002 37.7293534938515 -122.432669317552 (37.7293534938515, -122.432669317552)
11022 27183 1 20 218 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2x3   6002694.31138 2093864.23527 37.729505052106795 -122.43297072801701 (37.7295050521068, -122.432970728017)
2817 253222 2 20 148 Felton St 3 1 1 1       Width 3ft   6010428.10303 2093767.62468 37.729675416078294 -122.406227307752 (37.7296754160783, -122.406227307752)
2839 253221 2 20 148 Felton St 2 1 1 1       Width 3ft   6010428.10303 2093767.62468 37.729675416078294 -122.406227307752 (37.7296754160783, -122.406227307752)
11557 27528 3 20 1136 Silver Ave 1 1 1 2   11/25/2002 12:00:00 AM 3     6008310.55132 2093825.05625 37.729714434952506 -122.413551995327 (37.7297144349525, -122.413551995327)
145192 33403 1 20 384 Santa Ana Ave 1 1 1 1 1 04/23/2003 12:00:00 AM     Permit Number 46425 5992447.80765363 2094243.66151518 37.729960344135996 -122.468421188533 (37.729960344136, -122.468421188533)
12154 26999 1 20 1200 Silver Ave 1 1 1 1   05/27/1999 12:00:00 AM 6 3X3   6008714.80501 2094009.36438 37.7302431967539 -122.41216746208401 (37.7302431967539, -122.412167462084)
10976 26998 3 20 1223 Silver Ave 1 1 1 2   06/25/1999 12:00:00 AM 6 3X3   6008728.29906 2094063.8664 37.7303936047791 -122.41212466153499 (37.7303936047791, -122.412124661535)
10667 26997 1 20 1231 Silver Ave 1 1 1 1   06/25/1999 12:00:00 AM 6 3X3   6008770.22229 2094084.7874099999 37.7304534015961 -122.41198120438801 (37.7304534015961, -122.411981204388)
11300 26996 1 20 1239 Silver Ave 1 1 1 1   12/14/2000 12:00:00 AM 3 3X3   6008815.333330001 2094106.20179 37.730514731765396 -122.41182676109399 (37.7305147317654, -122.411826761094)
177360 95997 1 20 56 Neptune St 1 1 1 1 1 08/16/2011 12:00:00 AM 4 3x3 Permit Number 767648 6013070.55126 2094035.71681 37.730558997287396 -122.39711080912501 (37.7305589972874, -122.397110809125)
42503 204633 2 20 451 Hearst Ave 13 1 1 1     4 Width 2ft   5998410.37704 2094369.2089900002 37.7306476704498 -122.447816990888 (37.7306476704498, -122.447816990888)
146446 204634 2 20 451 Hearst Ave 15 1 1 1     5 Width 2ft   5998426.7778900005 2094369.13977 37.7306484177936 -122.44776028591002 (37.7306484177936, -122.44776028591)
170117 204631 2 20 451 Hearst Ave 10 1 1 1     4 Width 2ft   5998374.865180001 2094370.4925900002 37.7306491651061 -122.447939852652 (37.7306491651061, -122.447939852652)
178908 204632 2 20 451 Hearst Ave 11 1 1 1     6 Width 2ft   5998393.17334 2094370.1114700001 37.7306491651244 -122.447876531394 (37.7306491651244, -122.447876531394)
151548 204635 2 20 458 Hearst Ave 1 9 1 1     5     5998373.34514 2094412.4750299999 37.73076435209 -122.447948129107 (37.73076435209, -122.447948129107)
72610 204630 2 20 304 Gennessee St 1 1 1 1     13 Width 2ft   5997471.23605 2094490.2943 37.7309264189197 -122.45107245665501 (37.7309264189197, -122.451072456655)
87714 27034 1 20 1300X Silver Ave 2 1 1 1   05/27/1999 12:00:00 AM 6 3X3   6009318.030669999 2094252.37415 37.7309442788115 -122.41009917146799 (37.7309442788115, -122.410099171468)
11657 27033 1 20 1300X Silver Ave 1 1 1 1   05/27/1999 12:00:00 AM 6 3X3   6009267.3963 2094255.34405 37.730949595331296 -122.410274433211 (37.7309495953313, -122.410274433211)
93655 97046 2 20 1590X SHAFTER AVE 1 1 1 1     12 3x3   6014988.0 2094146.0 37.7309683687499 -122.390489552503 (37.7309683687499, -122.390489552503)
92699 97048 2 20 1590X Shafter Ave 3 1 1 1     8 3x3   6014988.7 2094146.3 37.7309692313217 -122.39048715342 (37.7309692313217, -122.39048715342)
109764 97047 2 20 1590X Shafter Ave 2 1 1 1     8 3x3   6014988.7 2094146.3 37.7309692313217 -122.39048715342 (37.7309692313217, -122.39048715342)
148378 31102 1 20 215 Congo St 1 1 1 1 1 03/21/1995 12:00:00 AM 6   Permit Number 34832 6000072.59523 2094462.74015 37.7309993521219 -122.44207717762801 (37.7309993521219, -122.442077177628)
12971 26990 1 20 1305 Silver Ave 1 1 1 1   06/22/1999 12:00:00 AM 6 3X3   6009240.62739 2094292.02443 37.731048811250794 -122.41036956712601 (37.7310488112508, -122.410369567126)
120831 106009 2 20 1745 LANE ST 1 1 1 1     11 3x3   6014990.1 2094194.5 37.7311016564679 -122.390485679987 (37.7311016564679, -122.390485679987)
Powered by Datasette · Query took 12.54ms · Data source: data.sfgov.org