sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
40 222540 2 20 1 Newburg St 3 1 1 1     6 Width 2ft   6002573.08856 2099992.67614 37.74632546084511 -122.433827665916 (37.7463254608451, -122.433827665916)
43 222539 2 20 1 Newburg St 2 1 1 1     6 Width 2ft   6002564.39948 2099984.1142599997 37.7463014588556 -122.433857099823 (37.7463014588556, -122.433857099823)
66 222538 2 20 1 Newburg St 1 1 1 1     6 Width 2ft   6002556.19825 2099973.42317 37.746271638232 -122.43388469462201 (37.746271638232, -122.433884694622)
358 251286 3 20 1299x Hudson Ave 7 1 1 2 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
375 251284 3 20 1299x Hudson Ave 5 1 1 2 3 06/21/1996 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
385 251282 3 20 1299x Hudson Ave 1 1 1 2 3 04/07/2016 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
392 251280 3 20 1275x Hudson Ave 1 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
398 251281 3 20 1275x Hudson Ave 4 1 1 2 3 03/23/2006 12:00:00 AM   3x3   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
402 251283 3 20 1299x Hudson Ave 9 1 1 2 3 06/06/1997 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
410 251287 3 20 1299x Hudson Ave 8 1 1 2 3 02/09/1998 12:00:00 AM   3x3   6017207.0 2095414.0 37.7345728945406 -122.38290623346 (37.7345728945406, -122.38290623346)
420 54426 1 20 770 Carolina St 1 1 1 1   07/02/1973 12:00:00 AM 15 3x3 Permit Number 12242 6012397.0815 2104349.75534 37.758841631549394 -122.400163199892 (37.7588416315494, -122.400163199892)
1380 251512 7 20 4116x 18th St 1 13 1 6       3x3   6002190.0 2105341.0 37.760988934022706 -122.43553488468001 (37.7609889340227, -122.43553488468)
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)
2997 246011 1 20 609 Ashbury St 1 1 1 1   08/09/1988 12:00:00 AM 8 Width 0ft Permit Number 25501 5998952.4081 2108635.9977 37.7698517546883 -122.446969376408 (37.7698517546883, -122.446969376408)
3320 56733 1 20 1583 McKinnon Ave 1 1 1 1     9   Permit Number 780681 6015469.0433 2095825.5988 37.7356068823061 -122.388943710821 (37.7356068823061, -122.388943710821)
3796 182316 1 20 2726 Kirkham St 3 1 1 1   04/12/2001 12:00:00 AM 3 Width 0ft Permit Number 43905 5986380.5744 2105064.6172 37.759319468361 -122.490191716108 (37.759319468361, -122.490191716108)
4156 213178 1 20 629 Grafton Ave 1 1 1 1   10/06/2017 08:23:00 AM 3 Width 3ft Permit Number 20774 5994856.22066 2090552.89382 37.7199652039099 -122.45982783161502 (37.7199652039099, -122.459827831615)
4201 252891 2 20 300x Howth St 1 1 1 1   10/10/2017 04:13:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4203 252894 2 20 300x Howth St 4 1 1 1   10/10/2017 04:10:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4212 204652 2 20 324 Howth St 1 1 1 1   10/10/2017 03:45:00 PM 3 Width 3ft   5997137.29551 2090290.56774 37.719375836806705 -122.45192406695601 (37.7193758368067, -122.451924066956)
4213 252892 2 20 300x Howth St 2 1 1 1   10/10/2017 04:08:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4246 252893 2 20 300x Howth St 3 1 1 1   10/10/2017 04:25:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
4291 252895 2 20 790x Mount Vernon Ave 1 1 1 1   10/10/2017 03:29:00 PM 3 3x3   5997282.0 2090432.0 37.719772464034904 -122.45143407539 (37.7197724640349, -122.45143407539)
4444 24256 1 20 203 Willow St 1 1 1 1   03/15/2014 12:00:00 AM 3 2x3   6006439.8092 2113362.67149 37.783254981274204 -122.421406308981 (37.7832549812742, -122.421406308981)
4793 12272 1 20 700X Laguna St 2 1 1 1   06/18/1997 12:00:00 AM 3 3X3   6004950.3992 2111308.9655 37.7775319231116 -122.426412801229 (37.7775319231116, -122.426412801229)
4849 253684 2 20 767 Burrows St 1 1 1 1       3x3   6009074.0 2092682.0 37.7266186845557 -122.410831962563 (37.7266186845557, -122.410831962563)
5163 12318 1 20 999 Laguna St 1 1 1 1   06/18/1997 12:00:00 AM 6 4X4   6004783.3056 2112237.6551 37.7800724294036 -122.427056996678 (37.7800724294036, -122.427056996678)
5538 27609 1 20 2695 Sacramento St 1 1 1 1   09/22/2000 12:00:00 AM 3 3x3   6001941.56922 2115683.47507 37.7893726707572 -122.437134613375 (37.7893726707572, -122.437134613375)
5700 107235 2 20 786 Sutter St 1 1 1 1     2 3x3   6008834.66692 2115296.44284 37.788699385205796 -122.413257820814 (37.7886993852058, -122.413257820814)
5851 9507 3 20 935 Golden Gate Ave 4 1 1 2     6 3X3   6005077.1287 2112297.1038 37.7802522713917 -122.42604476220501 (37.7802522713917, -122.426044762205)
5901 13142 1 20 1799 Lombard St 1 1 1 1   10/26/1993 12:00:00 AM 70 3X3   6003833.3629 2119660.0062 37.8003985594643 -122.43087313241999 (37.8003985594643, -122.43087313242)
7114 45767 1 20 99 Blake St 1 1 1 1 1 04/02/2002 12:00:00 AM 5 3x3 Permit Number 44690 5997811.6954 2113198.143 37.782312986330794 -122.45124412099399 (37.7823129863308, -122.451244120994)
7399 45765 1 20 99 Blake St 2 1 1 1   04/02/2002 12:00:00 AM 5 3x3 Permit Number 44690 5997815.0796 2113173.4382 37.782245347199996 -122.451230630986 (37.7822453472, -122.451230630986)
7463 52815 1 20 2760 Broderick St 1 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 773616 6000112.35725 2118047.78661 37.7957603016641 -122.44363337348999 (37.7957603016641, -122.44363337349)
7980 12325 1 20 1015 Laguna St 1 1 1 1   06/25/1997 12:00:00 AM 6 4X4   6004759.9403 2112401.4167 37.7805207570776 -122.427149495677 (37.7805207570776, -122.427149495677)
8678 26493 1 20 519 Laguna St 1 1 1 1     6 3X3   6004978.6865 2110816.0585 37.776180120030205 -122.42627984394699 (37.7761801200302, -122.426279843947)
9115 90912 1 20 545 Cabrillo St 1 1 1 1   02/20/2008 12:00:00 AM 3 3x3   5993886.17439 2110710.21085 37.775256248873895 -122.464643860229 (37.7752562488739, -122.464643860229)
9171 26893 1 20 1275X HUDSON AVE 6 1 1 1   03/09/1999 12:00:00 AM 6 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
9226 10863 1 20 1275X HUDSON AVE 2 1 1 1   04/28/2016 12:00:00 AM 6 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
9360 3447 1 20 26 Cameo Way 2 1 1 1     10 3X3   5999491.3304257 2099768.5267533 37.7455346409258 -122.44446787703998 (37.7455346409258, -122.44446787704)
9446 10864 1 20 1275X HUDSON AVE 3 1 1 1   02/19/1993 12:00:00 AM 6 3X4   6017281.0 2095243.0 37.734107450868 -122.38263849321599 (37.734107450868, -122.382638493216)
10007 99273 3 20 2825 Diamond St 1 1 1 2 2 02/01/2013 12:00:00 AM 3 3x3   6002499.0 2095479.8 37.733929944538204 -122.43376136145201 (37.7339299445382, -122.433761361452)
10112 5081 1 20 2562 Diamond St 1 1 1 1     14 3X3   6002249.017000001 2096934.71698 37.737910623162705 -122.434729631968 (37.7379106231627, -122.434729631968)
10145 173881 2 20 1245 Willard St 1 1 1 1       3x3   5996703.0 2107106.0 37.7655220059747 -122.45463943175601 (37.7655220059747, -122.454639431756)
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)
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)
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)
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)
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)
10673 121353 2 20 1221 37th Ave 1 1 1 1   09/27/2016 12:00:00 AM 3 3x3   5984567.3281 2106871.8527 37.76417557031971 -122.496596073864 (37.7641755703197, -122.496596073864)
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)
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)
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)
10826 27011 3 20 1468 Silver Ave 1 1 1 2   06/02/1999 12:00:00 AM 6 3X3   6010181.11487 2094586.49515 37.7319100425197 -122.407138874981 (37.7319100425197, -122.407138874981)
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)
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)
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)
10969 26989 3 20 1327 Silver Ave 1 1 1 2   06/22/1999 12:00:00 AM 6 3X3   6009306.59459 2094318.78355 37.7311259838562 -122.41014339480101 (37.7311259838562, -122.410143394801)
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)
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)
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)
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)
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)
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)
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)
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)
11500 66889 1 20 562 Vienna St 1 1 1 1   12/06/1991 12:00:00 AM 8 3x3 Permit Number 30203 6003132.96801 2090225.04515 37.7195375196183 -122.43119459394899 (37.7195375196183, -122.431194593949)
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)
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)
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)
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)
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)
11744 27020 1 20 1495 Silver Ave 1 1 1 1   06/16/1999 12:00:00 AM 6 3X3   6010228.2725 2094648.6070599998 37.7320832276456 -122.40698021658399 (37.7320832276456, -122.406980216584)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
12327 27038 1 20 1346 Silver Ave 2 1 1 1   03/21/2005 12:00:00 AM 3 3X3   6009450.86564 2094320.46878 37.7311386966779 -122.409644741423 (37.7311386966779, -122.409644741423)
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)
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)
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)
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)
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)
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)
12789 27012 1 20 1478 Silver Ave 1 1 1 1   07/13/1999 12:00:00 AM 6 3X3   6010237.54024 2094604.6047900002 37.731962925340206 -122.40694507558099 (37.7319629253402, -122.406945075581)
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)
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)
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)
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)
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)
13217 27037 1 20 1346 Silver Ave 1 1 1 1   05/27/1999 12:00:00 AM 6 3X3   6009433.39606 2094313.9953700001 37.731119943119296 -122.409704680324 (37.7311199431193, -122.409704680324)
13269 187626 2 20 298x Molimo Dr 1 5 1 1       3x3   5997428.0 2096652.0 37.7368594694916 -122.451377782024 (37.7368594694916, -122.451377782024)
13750 96932 3 20 901 Bay Shore Blvd 2 1 1 1     3 3x3   6011002.04218 2094782.5630700001 37.732494311353506 -122.404314536086 (37.7324943113535, -122.404314536086)
Powered by Datasette · Query took 1.977ms · Data source: data.sfgov.org