sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
25738 95912 8 12 858 34th Ave 1 1 1 1   03/17/2011 12:00:00 AM 4   Permit Number 767389 5985440.58134 2110021.2041 37.772873924382296 -122.49380788423099 (37.7728739243823, -122.493807884231)
98030 118337 8 12 2 Page St 2 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
108721 118336 8 12 2 Page St 1 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
115517 118338 8 12 2 Page St 3 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
138904 118339 8 12 2 Page St 4 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
139876 31650 8 12 3632 Vicente St 1 1 1 1   08/07/2015 12:00:00 AM 3   Permit Number 35160 5981711.46236471 2097421.70961548 37.7380604052223 -122.505772893936 (37.7380604052223, -122.505772893936)
140107 110044 8 12 550 33rd Ave 1 1 1 1   03/19/2015 12:00:00 AM 3 3x3   5985672.92923 2112141.09949 37.7787081437008 -122.49316037495899 (37.7787081437008, -122.493160374959)
175584 96402 8 12 2160 36th Ave 1 1 1 1   05/12/2011 12:00:00 AM 1 2x3   5985141.5215 2100472.7854 37.746639122425606 -122.494138462065 (37.7466391224256, -122.494138462065)
81246 109097 7 12 601 29th St 1 1 1 1 1 01/27/2015 12:00:00 AM 3 3x3 Permit Number 774331 6002630.6 2098839.9 37.743163470374895 -122.43354642924999 (37.7431634703749, -122.43354642925)
107232 98405 7 12 84 Richland Ave   1 1 1   02/08/2012 12:00:00 AM     Permit Number 768549 6005038.1 2096133.0 37.735867237922 -122.425029371072 (37.735867237922, -122.425029371072)
122755 102079 7 12 76 Manchester St 1 1 1 1 1 12/18/2012 12:00:00 AM   3x3 Permit Number 769729 6008162.3 2099676.4 37.7457726186307 -122.414478397936 (37.7457726186307, -122.414478397936)
8728 121206 6 12 930 Chestnut St 2 1 1 1   11/22/2016 12:00:00 AM 3 3x3 Permit Number 778903 6007356.48577 2120579.5282099997 37.803122321012296 -122.418746939923 (37.8031223210123, -122.418746939923)
12363 92312 6 12 2711 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985822.132 2096946.3119 37.7369961745626 -122.49152548244 (37.7369961745626, -122.49152548244)
50494 110477 6 12 131X Washington St 1 13 1 1   04/16/2015 12:00:00 AM 3 10x10 Permit Number 774729 6013427.21844 2117958.83498 37.796266453658795 -122.397554954018 (37.7962664536588, -122.397554954018)
80235 96569 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
99207 96568 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
100392 96279 6 12 55@ Alemany Trumbull St 7 13 1 1           6004020.1 2094407.4 37.7310715719205 -122.428426044208 (37.7310715719205, -122.428426044208)
124197 96567 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
126031 110476 6 12 3700 Washington St 1 13 1 1   04/16/2015 12:00:00 AM 3 10x10 Permit Number 774729 5997015.1 2115715.0 37.7891779638687 -122.454181816252 (37.7891779638687, -122.454181816252)
294 251266 5 12 10x Paloma Ave 1 1 1 1                    
122211 36938 5 12 351 11th Ave 1 1 1 1   02/06/2015 12:00:00 AM 3 3x3 Permit Number 774744 5992449.52236815 2113091.8234389997 37.781712581861 -122.46978695177602 (37.781712581861, -122.469786951776)
948 251406 4 12 445 Amazon Ave 1 1 1 1   04/25/2017 12:00:00 AM 3 3x3   6001636.0 2088904.0 37.7158252789105 -122.43627456666799 (37.7158252789105, -122.436274566668)
976 160371 4 12 868 Edinburgh St 3 1 1 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001686.38396 2088939.3945099998 37.7159253269669 -122.43610294800199 (37.7159253269669, -122.436102948002)
991 160369 4 12 868 Edinburgh St 1 1 1 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001700.06015 2088961.7176 37.715987398188894 -122.436057273237 (37.7159873981889, -122.436057273237)
994 160370 4 12 868 Edinburgh St 2 1 1 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001693.73373 2088950.71414 37.715956825716 -122.436078353349 (37.715956825716, -122.436078353349)
2025 243143 4 12 98x Eugenia Ave 1 1 1 1   06/16/2017 12:00:00 AM 3 3x3   6006195.0 2098242.0 37.7417233638646 -122.42117921336501 (37.7417233638646, -122.421179213365)
2032 243144 4 12 98x Eugenia Ave 2 1 1 1   06/16/2017 12:00:00 AM 3 3x3   6006195.0 2098242.0 37.7417233638646 -122.42117921336501 (37.7417233638646, -122.421179213365)
2639 253101 4 12 3000x Irving St 1 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2642 253105 4 12 1295 31st Ave 1 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2663 253102 4 12 3000x Irving St 2 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2666 253103 4 12 3000x Irving St 3 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2669 253104 4 12 3000x Irving St 4 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
7909 115530 4 12 101 Polk St 3 1 1 1   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007332.44961 2111311.79762 37.7776740647351 -122.418172674243 (37.7776740647351, -122.418172674243)
9723 173650 4 12 80 Entrada Ct 2 9 1 1   12/21/2016 12:00:00 AM 3 4x10   5992424.456569999 2092194.59394 37.7243327619491 -122.46835290122299 (37.7243327619491, -122.468352901223)
9959 57959 4 12 336 Hanover St 1 1 1 1   01/13/2017 12:00:00 AM 3 3x3 Permit Number 774423 5999490.29697456 2086502.70799744 37.7091097236101 -122.443518692288 (37.7091097236101, -122.443518692288)
10564 116803 4 12 931 Silver Ave 1 1 1 1   04/27/2016 12:00:00 AM 3 3x3   6007342.71844 2093540.3953900002 37.728878425184796 -122.416877747635 (37.7288784251848, -122.416877747635)
11604 116262 4 12 35 La Grande Ave 1 1 1 1   03/22/2016 12:00:00 AM 3 3x4   6005278.18089 2092026.4994299999 37.724605255111896 -122.42390739821998 (37.7246052551119, -122.42390739822)
13329 60277 4 12 2690 Harrison St 7 1 1 1   07/03/2008 12:00:00 AM   3x3 Permit Number 51145 6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657)
22979 112863 4 12 2451 19TH AVE 1 1 1 1   08/25/2015 12:00:00 AM 3 3x3   5990427.0 2098705.0 37.7420931085193 -122.475732948104 (37.7420931085193, -122.475732948104)
46754 115098 4 12 537 Natoma St 4 1 1 1   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010148.06204 2111925.42664 37.7795170247346 -122.408475763058 (37.7795170247346, -122.408475763058)
81719 112974 4 12 4099x ULLOA ST 3 5 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
90957 112973 4 12 4099x ULLOA ST 2 5 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
105015 112975 4 12 4099x ULLOA ST 4 5 1 1   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
109588 113335 4 12 2X STANFORD ST 1 5 1 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
119781 113337 4 12 2X STANFORD ST 2 5 1 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
127734 113338 4 12 2X STANFORD ST 3 5 1 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
127737 112972 4 12 4099x ULLOA ST 1 5 1 1   10/20/2015 12:00:00 AM 1 3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
133773 101942 4 12 537 Natoma St 1 1 1 1   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010108.2937199995 2111885.47528 37.7794051005107 -122.408610520167 (37.7794051005107, -122.408610520167)
141647 122627 4 12 34 Country Club Dr 1 5 1 1   11/15/2016 12:00:00 AM 3 3x4 Permit Number 775279 5984731.0 2094410.0 37.729968312905505 -122.49511098534401 (37.7299683129055, -122.495110985344)
145677 108030 4 12 601 29th St 1 1 1 1   11/17/2014 12:00:00 AM 3 3x3   6002630.6 2098839.9 37.743163470374895 -122.43354642924999 (37.7431634703749, -122.43354642925)
149675 115096 4 12 537 Natoma St 2 1 1 1   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010119.08101 2111896.4319 37.7794357889593 -122.408573975335 (37.7794357889593, -122.408573975335)
151101 39246 4 12 3524 Jackson St 2 1 1 1   08/22/2002 12:00:00 AM 1   Permit Number 772836 5997390.1418 2116079.3582900004 37.7901998932662 -122.452910535096 (37.7901998932662, -122.452910535096)
179588 115097 4 12 537 Natoma St 3 1 1 1   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010133.894719999 2111910.59383 37.779475503918 -122.408523727481 (37.779475503918, -122.408523727481)
799 175049 3 12 80X Junipero Serra Blvd 17 1 1 2   01/18/2008 12:00:00 AM 1 Width 3ft   5991326.81361 2089039.5683900001 37.715606377909495 -122.47191742058 (37.7156063779095, -122.47191742058)
805 175380 3 12 80X Junipero Serra Blvd 13 1 1 2   01/18/2008 12:00:00 AM 2 Width 3ft   5991348.49258 2088973.03169 37.715424938774 -122.471837642593 (37.715424938774, -122.471837642593)
816 175372 3 12 80X Junipero Serra Blvd 4 1 1 2   03/09/2013 12:00:00 AM 2 Width 3ft   5991438.54417 2088636.90192 37.714507218415 -122.47150190860901 (37.714507218415, -122.471501908609)
820 251223 3 12 80X Junipero Serra Blvd 22 1 1 2   01/18/2008 12:00:00 AM   Width 3ft   5991438.54417 2088636.90192 37.714507218415 -122.47150190860901 (37.714507218415, -122.471501908609)
826 175048 3 12 80X Junipero Serra Blvd 16 1 1 2   01/18/2008 12:00:00 AM 25 Width 3ft   5991330.3562 2089025.12852 37.7155669345385 -122.47190412410299 (37.7155669345385, -122.471904124103)
835 175376 3 12 80X Junipero Serra Blvd 9 1 1 2   01/18/2008 12:00:00 AM 2 Width 3ft   5991381.99613 2088828.6732599998 37.715030504233 -122.471711326531 (37.715030504233, -122.471711326531)
839 216492 3 12 800x Bosworth St 5 1 1 2     0 Width 3ft   6001736.84783 2095515.7705400002 37.7339854340776 -122.43639892299299 (37.7339854340776, -122.436398922993)
842 175381 3 12 80X Junipero Serra Blvd 15 1 1 2   01/18/2008 12:00:00 AM 3 Width 3ft   5991335.841440001 2089011.6054200002 37.715530120800295 -122.47188417981 (37.7155301208003, -122.47188417981)
844 251224 3 12 80X Junipero Serra Blvd 23 1 1 2   01/18/2008 12:00:00 AM   Width 3ft   5991438.54417 2088636.90192 37.714507218415 -122.47150190860901 (37.714507218415, -122.471501908609)
845 175045 3 12 80x Junipero Serra Blvd 2 1 1 2   01/22/2008 12:00:00 AM 5 Width 3ft   5991569.1908599995 2087579.7101099999 37.711611983268 -122.47097337704399 (37.711611983268, -122.470973377044)
1043 81845 3 12 1421 Pine St 2 1 1 10 6 04/28/2017 08:33:00 AM 3 3x3 Permit Number 50020 6007103.87391 2115697.8037 37.789704100621705 -122.419274608151 (37.7897041006217, -122.419274608151)
2825 81846 3 12 1421 Pine St 1 1 1 10 6 12/20/2007 12:00:00 AM 3 3x3 Permit Number 50020 6007049.49584 2115692.06976 37.7896852939829 -122.419462344328 (37.7896852939829, -122.419462344328)
3723 253167 3 12 1X Brotherhood Way 1 7 1 2                    
4776 97245 3 12 301X Excelsior Ave 1 1 1 4 2 10/25/2017 04:18:00 PM 3 4x4 Permit Number 767495 6003351.72812 2092154.8424200001 37.724848709697106 -122.43057604836099 (37.7248487096971, -122.430576048361)
4799 97246 3 12 301X Excelsior Ave 2 1 1 4 2 10/25/2017 04:11:00 PM 3 4x4 Permit Number 767495 6003334.6314 2092165.82905 37.724877907973706 -122.430635933307 (37.7248779079737, -122.430635933307)
7013 18868 3 12 2245 Sacramento St 2 1 1 2   12/27/2014 12:05:00 PM 3 3X4   6004021.14791 2115967.48717 37.7902704855414 -122.42995977804199 (37.7902704855414, -122.429959778042)
8242 81844 3 12 1421 Pine St 3 1 1 2 6 09/11/2012 12:00:00 AM 3 3x3 Permit Number 50020 6007169.781140001 2115706.72596 37.789732310539705 -122.419047208268 (37.7897323105397, -122.419047208268)
9934 102961 3 12 1299X Junipero Serra Blvd 4 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9935 102960 3 12 1299X Junipero Serra Blvd 3 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9936 102965 3 12 1299X Junipero Serra Blvd 9 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9937 102966 3 12 1299X Junipero Serra Blvd 10 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9939 102963 3 12 1299X Junipero Serra Blvd 6 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9940 102969 3 12 1299X Junipero Serra Blvd 12 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9941 102968 3 12 1299X Junipero Serra Blvd 11 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9943 102967 3 12 1299X Junipero Serra Blvd 13 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9944 11821 3 12 1299X Junipero Serra Blvd 2 2 1 2   03/09/2013 12:00:00 AM 2 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
9945 102971 3 12 1299X Junipero Serra Blvd 18 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
10295 86058 3 12 1583 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987441.2276 2104514.7604 37.7578715963284 -122.486483137481 (37.7578715963284, -122.486483137481)
10301 86223 3 12 2490X 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988629.212 2098360.9697 37.7410440994961 -122.48192386283199 (37.7410440994961, -122.481923862832)
10327 86040 3 12 1307 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987380.4546 2106353.8076 37.762917573839104 -122.48682835991 (37.7629175738391, -122.48682835991)
10399 86345 3 12 2375 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988557.6358 2099173.0128 37.743269593853704 -122.482230823598 (37.7432695938537, -122.482230823598)
10405 86230 3 12 2434 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988618.0441 2098730.8647 37.742059084770105 -122.481989567109 (37.7420590847701, -122.481989567109)
10420 86166 3 12 1371 24th Ave 1 1 1 2   01/19/2007 12:00:00 AM 3 3x3   5988635.288 2105993.2776 37.7620007347072 -122.48246195923299 (37.7620007347072, -122.482461959233)
10423 86471 3 12 1814 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 8 3x3   5987856.6219 2102916.0794 37.7535062555598 -122.48492926433501 (37.7535062555598, -122.484929264335)
10428 86141 3 12 1454 24th Ave 1 1 1 2   01/22/2007 12:00:00 AM 3 3x3   5988697.0081 2105426.1429 37.7604471269304 -122.482206944127 (37.7604471269304, -122.482206944127)
10456 86365 3 12 2527 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988592.98 2098098.1742 37.7403204245752 -122.482029891514 (37.7403204245752, -122.482029891514)
10478 86216 3 12 2619 24th Ave 1 1 1 2   06/18/2015 03:11:00 PM 3 3x3   5988925.4466 2097480.2521 37.7386431021416 -122.48083513933202 (37.7386431021416, -122.480835139332)
10481 86342 3 12 2347 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988550.1905 2099342.5621 37.743734698566996 -122.482268986695 (37.743734698567, -122.482268986695)
10485 86147 3 12 1350 24th Ave 1 1 1 2   01/22/2007 12:00:00 AM 8 3x3   5988673.7063 2106118.8136 37.7623476572695 -122.482338285023 (37.7623476572695, -122.482338285023)
10499 86552 3 12 1807 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987803.5941 2102964.5337 37.7536362092428 -122.485116198466 (37.7536362092428, -122.485116198466)
10533 86042 3 12 1311 28th Ave 2 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987382.8738 2106304.4567 37.7627822108774 -122.48681636863701 (37.7627822108774, -122.486816368637)
10540 86470 3 12 1822 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 3 3x3   5987859.0288 2102867.5421 37.7533731253955 -122.484917380259 (37.7533731253955, -122.484917380259)
10561 86012 3 12 1642 28th Ave 1 1 1 2   01/04/2007 12:00:00 AM 3 3x3   5987499.1098 2104097.2319 37.7567285504541 -122.486252307696 (37.7567285504541, -122.486252307696)
10563 86468 3 12 1830 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 10 3x3   5987859.0288 2102813.3889 37.753224435288 -122.484913407703 (37.753224435288, -122.484913407703)
10588 29186 3 12 3109 Ortega St 7 1 1 2   03/18/2006 12:00:00 AM 3 3X3   5984375.9268 2102211.0253 37.751367022759105 -122.49691404116001 (37.7513670227591, -122.49691404116)
10600 86037 3 12 1215 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987357.4179 2106982.0087 37.76464109793461 -122.48695417155899 (37.7646410979346, -122.486954171559)
10602 86245 3 12 2306 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988589.4098 2099609.5524 37.744470064859 -122.48215293338001 (37.744470064859, -122.48215293338)
10646 86167 3 12 1379 24th Ave 1 1 1 2   01/19/2007 12:00:00 AM 3 3x3   5988635.288 2105938.085 37.761849190827796 -122.48245791496599 (37.7618491908278, -122.482457914966)
Powered by Datasette · Query took 18.225ms · Data source: data.sfgov.org