sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
127330 109501 5 119 1400X on Filbert Montgomery St 1 14 1 1         see 279 Filbert St. Same tree; shared responsibility 6011485.9 2120124.8 37.802105381717894 -122.404424889694 (37.8021053817179, -122.404424889694)
84402 109353 5 253 2505 Pacific Ave 6 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
104832 109350 5 253 2505 Pacific Ave 3 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
113379 109349 5 253 2505 Pacific Ave 2 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
122284 109352 5 253 2505 Pacific Ave 5 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
125736 109351 5 253 2505 Pacific Ave 4 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
139898 109348 5 253 2505 Pacific Ave 1 5 2 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
3835 253567 5 218 25 Raycliff Ter 1 13 1 1           6000333.0 2116919.0 37.792673532262505 -122.44278881704399 (37.7926735322625, -122.442788817044)
93974 121246 5 2 500 Pine St 2 1 1 1       3x3   6011462.5792 2116351.5538 37.791743655166 -122.40423986853001 (37.791743655166, -122.40423986853)
94513 121248 5 2 500 Pine St 4 1 1 1       3x3   6011462.5792 2116351.5538 37.791743655166 -122.40423986853001 (37.791743655166, -122.40423986853)
100736 121249 5 2 500 Pine St 5 1 1 1       3x3   6011462.5792 2116351.5538 37.791743655166 -122.40423986853001 (37.791743655166, -122.40423986853)
113673 121247 5 2 500 Pine St 3 1 1 1       3x3   6011462.5792 2116351.5538 37.791743655166 -122.40423986853001 (37.791743655166, -122.40423986853)
140147 121245 5 2 500 Pine St 1 1 1 1       3x3   6011462.5792 2116351.5538 37.791743655166 -122.40423986853001 (37.791743655166, -122.40423986853)
125580 109829 5 51 629 TAYLOR ST 1 1 1 1   12/01/2015 12:00:00 AM     Permit Number 775362 6009246.3 2115118.4 37.7882336239769 -122.41182103906 (37.7882336239769, -122.41182103906)
98596 115128 5 68 499X MAIN ST 6 1 1 1     7     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
104521 115129 5 68 499X MAIN ST 7 1 1 1     6     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
116115 104650 5 60 346 LAKE ST   1 1 1     28 10x8   5994385.6 2114927.2 37.7868637456835 -122.46322230514099 (37.7868637456835, -122.463222305141)
101604 108440 5 21 105 Lake St   1 1 1 1     3x3   5995179.45913 2114890.0759 37.786807513731105 -122.46047306430201 (37.7868075137311, -122.460473064302)
142217 108441 5 21 105 Lake St   8 1 1 1     3x3 Permit Number 773769 5995179.45913 2114890.0759 37.786807513731105 -122.46047306430201 (37.7868075137311, -122.460473064302)
103533 12529 5 88 105 Lake St 1 8 1 1 1 07/12/2004 12:00:00 AM 6 3x3 Permit Number 773769 5995136.95364 2114887.49287 37.78679797610221 -122.460619935074 (37.7867979761022, -122.460619935074)
142320 82180 5 88 105 Lake St 1 8 1 1 1     3x3 Permit Number 773769 5995179.68463591 2114884.08050195 37.78679106496129 -122.46047184952101 (37.7867910649613, -122.460471849521)
102017 85741 5 15 601X Howard St 3 1 1 1   04/30/2007 12:00:00 AM 3 5x5 Permit Number 770115 6013161.811798001 2114488.497614 37.78672294116279 -122.398229721423 (37.7867229411628, -122.398229721423)
117366 85739 5 15 601X Howard St 1 1 1 1   04/30/2007 12:00:00 AM 3 5x5 Permit Number 770115 6013161.811798001 2114488.497614 37.78672294116279 -122.398229721423 (37.7867229411628, -122.398229721423)
142254 85740 5 15 601X Howard St 2 1 1 1   04/30/2007 12:00:00 AM 3 5x5 Permit Number 770115 6013161.811798001 2114488.497614 37.78672294116279 -122.398229721423 (37.7867229411628, -122.398229721423)
15625 109064 5 21 401 Harrison St 3 1 1 1   02/02/2015 12:00:00 AM 3   Permit Number 774722 6014787.30736 2114269.34055 37.7862115942283 -122.39259051256799 (37.7862115942283, -122.392590512568)
14482 109063 5 21 401 Harrison St 2 1 1 1   02/02/2015 12:00:00 AM 3   Permit Number 774722 6014773.1420599995 2114255.79417 37.7861736122787 -122.39263857322901 (37.7861736122787, -122.392638573229)
981 191653 5 11 149 03rd St 2 1 1 1     9 Width 5ft   6012146.38303 2114300.35662 37.786149737060796 -122.40172965521799 (37.7861497370608, -122.401729655218)
16245 109062 5 21 401 Harrison St 1 1 1 1   02/02/2015 12:00:00 AM 3   Permit Number 774722 6014756.57852 2114238.14616 37.7861242349771 -122.392694644144 (37.7861242349771, -122.392694644144)
9555 105225 5 19 175 Spruce St 1 7 1 1     9     5997195.09596 2114417.64894 37.785626103218895 -122.453465347546 (37.7856261032189, -122.453465347546)
7821 99713 5 15 1415 Scott St 1 1 1 1     12 3x3   6001685.4406 2113539.6106 37.7834716060779 -122.43786717092199 (37.7834716060779, -122.437867170922)
7784 99714 5 15 1415 Scott St 2 1 1 1     12 3x3   6001688.147999999 2113522.0126 37.7834234404081 -122.43785654353 (37.7834234404081, -122.43785654353)
7284 99715 5 15 1415 Scott St 3 1 1 1     12 3x3   6001690.8553 2113503.3994 37.7833724872506 -122.43784584376199 (37.7833724872506, -122.437845843762)
1517 99716 5 81 1415 Scott St 4 1 1 1     12 3x3   6001693.2243 2113487.1552 37.7833280195253 -122.43783648412202 (37.7833280195253, -122.437836484122)
2892 99717 5 15 1415 Scott St 5 1 1 1     12 3x3   6001694.9164 2113468.8804 37.7832779377979 -122.437829320807 (37.7832779377979, -122.437829320807)
130745 82138 5 108 360 09th Ave 1 1 1 1 1 11/13/2004 12:00:00 AM 12     5993114.289030001 2113170.0137400003 37.781965672785795 -122.467492879752 (37.7819656727858, -122.467492879752)
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)
103226 104358 5 22 745X GOLDEN GATE AVE   1 1 1     10 3   6005986.0 2112447.0 37.7807151749226 -122.42291120983299 (37.7807151749226, -122.422911209833)
139890 9241 5 2 6442 Geary Blvd 1 1 1 1   10/01/1993 12:00:00 AM 6 3x3   5986987.758640001 2112604.7127900003 37.7800579063209 -122.488646014596 (37.7800579063209, -122.488646014596)
966 251417 5 103 418 19th Ave 1 1 1 6       3x3   5990003.0 2112517.0 37.779992561868504 -122.478208632121 (37.7799925618685, -122.478208632121)
85143 115005 5 16 1050 MCALLISTER ST 2 8 1 21 4     3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
106272 115004 5 80 1050 MCALLISTER ST 1 8 1 21 4 01/19/2016 09:19:00 AM 3 3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
13466 104640 5 5 112 07th St 1 1 1 1     10 2.5x2.5   6009509.89326 2111697.52669 37.778855505921605 -122.410667371323 (37.7788555059216, -122.410667371323)
99380 119616 5 54 400 Grove St 1 1 2 1   07/28/2016 12:00:00 AM 3     6005873.6969099995 2111410.5639299997 37.777863036884796 -122.42322602570499 (37.7778630368848, -122.423226025705)
22941 110324 5 17 580 Hayes St 2 1 1 1   04/06/2015 12:00:00 AM 3   Permit Number 773594 6005065.6 2110970.4 37.7766088164574 -122.42599017584601 (37.7766088164574, -122.425990175846)
50 138938 5 17 632 HAYES ST 1 2 1 1   03/21/2017 12:00:00 AM 3 Width 0ft Permit Number 779650 6004797.9634 2110922.1515 37.7764612085261 -122.426912572117 (37.7764612085261, -122.426912572117)
105247 25212 5 11 215X Fell St 3 1 1 1     6 3X3   6006420.227630001 2110742.05634 37.7760583047566 -122.421287897592 (37.7760583047566, -122.421287897592)
127560 108446 5 37 672 05th Ave   1 1 1 1     3x3 Permit Number 773773 5994431.81479 2110948.5397799998 37.7759420777365 -122.462773673163 (37.7759420777365, -122.462773673163)
102 98037 5 26 1384X Grove St 1 1 1 1   03/23/2017 12:00:00 AM 3   Permit Number 767782 6001197.2582 2110764.9293 37.775825263482105 -122.439357134105 (37.7758252634821, -122.439357134105)
78271 16888 5 37 300X Oak St 9 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
83519 16883 5 37 300X Oak St 4 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
85166 16887 5 37 300X Oak St 8 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
85178 16884 5 37 300X Oak St 5 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
102333 122643 5 37 300X Oak St 12 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
113580 16882 5 37 300X Oak St 3 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
115127 122644 5 37 300X Oak St 13 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
116204 16886 5 37 300X Oak St 7 1 1 1   11/10/2016 12:00:00 AM 3 3X4   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
140005 122641 5 37 300X Oak St 10 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
140429 122642 5 37 300X Oak St 11 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
142156 16885 5 37 300X Oak St 6 1 1 1   11/10/2016 12:00:00 AM 3 3X3   6005538.341599599 2110328.2060015 37.7748722137679 -122.42430913733 (37.7748722137679, -122.42430913733)
1491 110535 5 22 100X ASHBURY ST 3 1 1 12 3 04/21/2015 04:52:00 PM 3 3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
1496 110536 5 11 100X ASHBURY ST 4 1 1 12 3 05/29/2015 02:12:00 PM 3 3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
79432 106576 5 64 507 STEINER ST 1 7 2 1           6003113.3 2110111.6 37.7741402349502 -122.432682383122 (37.7741402349502, -122.432682383122)
90136 108459 5 88 771 11th Ave   1 1 1 1     3x3 Permit Number 773786 5992558.08669 2110211.94426 37.7738114893979 -122.469201704334 (37.7738114893979, -122.469201704334)
144924 114895 5 48 820 30th Ave 1 1 1 1   12/21/2015 12:00:00 AM     Permit Number 775427 5986664.4 2110325.3 37.7737804103986 -122.489596975753 (37.7737804103986, -122.489596975753)
57485 73751 5 61 794-798 19th Ave 2 1 1 1 1 03/09/1996 12:00:00 AM 10 3x3   5990095.37972 2109981.17843 37.7730352575459 -122.477703639701 (37.7730352575459, -122.477703639701)
145512 72375 5 90 4299X Fulton St 1 1 1 1 1 03/09/1996 12:00:00 AM   3x3 Permit Number 773790 5990099.63678033 2109979.56687008 37.773031079694 -122.47768879633699 (37.773031079694, -122.477688796337)
27 244214 5 17 342 Scott St 1 2 1 1   03/20/2017 12:00:00 AM 3 Width 0ft Permit Number 779666 6002262.2202 2109717.5413 37.7730099442883 -122.43559821674499 (37.7730099442883, -122.435598216745)
185734 73761 5 61 794-798 19th Ave 1 1 1 1 1 03/09/1996 12:00:00 AM 7 3x3   5990097.66816 2109968.1044799997 37.772999492868706 -122.47769476794599 (37.7729994928687, -122.477694767946)
109976 117353 5 108 101X China Basin St 2 1 1 1       3x3 Permit Number 772935 6015309.46376 2108739.72137 37.771057483634294 -122.39039747437401 (37.7710574836343, -122.390397474374)
126236 104626 5 15 49 BRODERICK ST 3 1 1 1     18 6X5   6001285.0 2108936.0 37.7708084746611 -122.438922516011 (37.7708084746611, -122.438922516011)
123092 104627 5 15 49 BRODERICK ST 4 1 1 1     17 5X5   6001306.0 2108720.0 37.7702165872443 -122.438834395611 (37.7702165872443, -122.438834395611)
83017 104401 5 46 727 Ashbury St   1 1 1     15 3x3   5999017.0 2108166.0 37.768564950056 -122.44671213341002 (37.768564950056, -122.44671213341)
139788 104400 5 22 755 Ashbury St   1 1 1     22 3x3   5999044.0 2107976.0 37.768044800389 -122.44660507122101 (37.768044800389, -122.446605071221)
13268 187627 5 47 88 States St 1 13 1 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
102645 110587 5 225 151 EDGEWOOD AVE 1 7 1 1           5996558.0 2106132.0 37.7628393335165 -122.45507056334999 (37.7628393335165, -122.45507056335)
100517 104502 5 3 30X SATURN ST 1 3 1 2     14     6000456.0 2106003.0 37.7627079858093 -122.44157952536999 (37.7627079858093, -122.44157952537)
92292 39627 5 15 199X Carmel St 1 1 1 1 1 12/29/1998 12:00:00 AM 6   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.45031878213301 (37.7607233191374, -122.450318782133)
103609 39626 5 15 1550 Shrader St 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.45031878213301 (37.7607233191374, -122.450318782133)
104147 39629 5 15 199X Carmel St 3 1 1 1 1 12/29/1998 12:00:00 AM 6   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.45031878213301 (37.7607233191374, -122.450318782133)
122002 39628 5 15 199X Carmel St 2 1 1 1 1 12/29/1998 12:00:00 AM 5   Permit Number 775173 5997915.23661319 2105333.02481713 37.7607233191374 -122.45031878213301 (37.7607233191374, -122.450318782133)
123904 106641 5 64 1323X CLAYTON ST 1 13 2 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
99533 100242 5 17 76 Linda St   10 2 1           6005815.0 2105046.0 37.76038415245 -122.422976606568 (37.76038415245, -122.422976606568)
103907 106639 5 64 1321X CLAYTON ST 1 13 2 1           5998910.0 2105100.0 37.7601403710114 -122.44686158716699 (37.7601403710114, -122.446861587167)
2502 253119 5 3 185 Belgrave Ave 1 13 1 1         Permit Number 780239 5997636.85301 2104869.74588 37.759435335978296 -122.45124816933 (37.7594353359783, -122.45124816933)
88121 71505 5 88 328 San Carlos St 1 1 1 1   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774557 6006691.32680411 2104197.11487977 37.758102721165706 -122.41988555479601 (37.7581027211657, -122.419885554796)
76816 104448 5 18 2490X Folsom St 3 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
88695 104451 5 5 2490X Folsom St 6 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
92561 104449 5 5 2490X Folsom St 4 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
100922 104446 5 18 2490X Folsom St 1 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
5091 253769 5 47 100 Raccoon Dr 2 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
145175 108885 5 118 707 NOE ST 5 13 1 1       3x3   6003152.4 2104071.5 37.757557804850705 -122.43211570496099 (37.7575578048507, -122.432115704961)
110956 118356 5 47 100 RACCOON DR 2 16 1 1     48     5998776.0 2103987.0 37.7570766935068 -122.44724492231701 (37.7570766935068, -122.447244922317)
101429 121090 5 3 1X Grand View Ave 3 1 1 1       3x3   6000227.0 2103854.0 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848)
141824 121089 5 103 1X Grand View Ave 2 1 1 1       3x3   6000227.0 2103854.0 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848)
97548 113801 5 46 806 SHOTWELL ST 3 7 1 1           6007931.0 2103220.0 37.755489548438 -122.41552904166201 (37.755489548438, -122.415529041662)
124928 104968 5 164 495 COLLINGWOOD ST 1 7 1 1     15   Permit Number 770776 6002186.6 2103026.0 37.7546323087418 -122.435381040855 (37.7546323087418, -122.435381040855)
93853 109126 5 138 890x CASTRO ST 2 1 1 1     4 3x3   6002411.0 2103002.0 37.754579151967796 -122.434603290485 (37.7545791519678, -122.434603290485)
141344 109125 5 138 890x CASTRO ST 1 1 1 1     12 3x3   6002411.0 2103002.0 37.754579151967796 -122.434603290485 (37.7545791519678, -122.434603290485)
102518 104768 5 46 912 CASTRO ST 1 1 1 1     17 3x3   6002431.1 2102873.8 37.7542282864134 -122.43452461352699 (37.7542282864134, -122.434524613527)
123259 73314 5 104 1142 Alabama St 1 1 1 1   12/09/2014 12:00:00 AM 3 3x3   6009184.98526399 2102501.75487234 37.7535878144828 -122.411141625253 (37.7535878144828, -122.411141625253)
97889 104310 5 329 3747 23RD ST 3 1 1 1     13 5x5   6004798.0 2102451.0 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314)
Powered by Datasette · Query took 4.409ms · Data source: data.sfgov.org