sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
79432 106576 5 64 507 STEINER ST 1 7 2 1           6003113.3 2110111.6 37.7741402349502 -122.432682383122 (37.7741402349502, -122.432682383122)
79705 108816 5 3 348 Gold Mine Dr 1 13 1 1     30     6001084.0 2097744.0 37.740066514789 -122.43881563429301 (37.740066514789, -122.438815634293)
82462 114642 5 135 30 MacEdonia St 1 1 1 1   11/30/2015 12:00:00 AM     Permit Number 773527 6010319.9 2099707.2 37.745978163196995 -122.407019863158 (37.745978163197, -122.407019863158)
83017 104401 5 46 727 Ashbury St   1 1 1     15 3x3   5999017.0 2108166.0 37.768564950056 -122.44671213341002 (37.768564950056, -122.44671213341)
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)
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)
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)
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)
85608 105439 5 17 790 LAKEVIEW AVE 1 7 1 1           5994224.8 2089960.8 37.718303123348605 -122.461967505828 (37.7183031233486, -122.461967505828)
85994 104510 5 116 254 ALLISON ST 1 13 1 1     40     6000052.0 2087408.0 37.7116274717654 -122.441642291463 (37.7116274717654, -122.441642291463)
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)
88690 80520 5 291 2499X Mendell St 1 1 1 1   09/07/2002 12:00:00 AM 2     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
88695 104451 5 5 2490X Folsom St 6 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
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)
90169 104567 5 17 8 JOY ST 2 7 1 1     40     6010448.0 2098932.0 37.7438568002142 -122.40652229250799 (37.7438568002142, -122.406522292508)
90903 80593 5 204 1780 Bancroft Ave 5 1 1 1   09/07/2002 12:00:00 AM 7     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
91183 114258 5 3 70x CHUMASERO DR 1 7 1 1     40     5990913.0 2088468.0 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941)
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)
92561 104449 5 5 2490X Folsom St 4 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
93096 114666 5 13 382 Richland Ave 1 1 1 1   11/30/2015 12:00:00 AM     Permit Number 774512 6007233.6 2095963.6 37.7355258779344 -122.41742663990699 (37.7355258779344, -122.417426639907)
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)
93974 121246 5 2 500 Pine St 2 1 1 1       3x3   6011462.5792 2116351.5538 37.791743655166 -122.40423986853001 (37.791743655166, -122.40423986853)
94096 100243 5 17 1326-1332 Shotwell St   19 1 1           6008043.0 2100485.0 37.7479861507453 -122.41494814206699 (37.7479861507453, -122.414948142067)
94178 22382 5 291 2499X Mendell St 2 1 1 1   05/13/1997 12:00:00 AM 3 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041)
94513 121248 5 2 500 Pine St 4 1 1 1       3x3   6011462.5792 2116351.5538 37.791743655166 -122.40423986853001 (37.791743655166, -122.40423986853)
94668 80514 5 291 1769X Armstrong Ave 9 1 1 1   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
95325 111308 5 3 780x JAMESTOWN AVE 1 9 1 1       6x90   6015099.0 2088640.0 37.7158561393861 -122.389721379672 (37.7158561393861, -122.389721379672)
97007 117070 5 17 6 JOY ST 3 7 1 1           6010444.0 2098901.0 37.7437714571602 -122.406533939617 (37.7437714571602, -122.406533939617)
97106 102276 5 17 279 Topaz Way   13 2 1           6001205.6 2097796.6 37.7402178594385 -122.43839895973301 (37.7402178594385, -122.438398959733)
97548 113801 5 46 806 SHOTWELL ST 3 7 1 1           6007931.0 2103220.0 37.755489548438 -122.41552904166201 (37.755489548438, -122.415529041662)
97551 80517 5 291 1769X Armstrong Ave 5 1 1 1   09/07/2002 12:00:00 AM 3     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
97877 121418 5 226 521 Lakeview Ave 1 5 2 1       3x3   5996348.0 2089857.0 37.718140121256106 -122.45462104638399 (37.7181401212561, -122.454621046384)
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)
98596 115128 5 68 499X MAIN ST 6 1 1 1     7     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
98944 108170 5 44 1645 ALABAMA ST 1 1 1 1   02/03/2015 12:00:00 AM 3 3x3 Permit Number 774689 6009348.4 2099893.7 37.7464358384441 -122.410392359276 (37.7464358384441, -122.410392359276)
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)
99533 100242 5 17 76 Linda St   10 2 1           6005815.0 2105046.0 37.76038415245 -122.422976606568 (37.76038415245, -122.422976606568)
99668 104881 5 262 101 Gonzalez Dr 1 2 1 1         missing? 5990474.7 2090014.4 37.718233681711204 -122.47493379652201 (37.7182336817112, -122.474933796522)
100517 104502 5 3 30X SATURN ST 1 3 1 2     14     6000456.0 2106003.0 37.7627079858093 -122.44157952536999 (37.7627079858093, -122.44157952537)
100736 121249 5 2 500 Pine St 5 1 1 1       3x3   6011462.5792 2116351.5538 37.791743655166 -122.40423986853001 (37.791743655166, -122.40423986853)
100922 104446 5 18 2490X Folsom St 1 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
101345 104689 5 3 657 PALMETTO AVE 1 13 1 1     30     5991786.0 2087190.1 37.7105547448876 -122.470195680575 (37.7105547448876, -122.470195680575)
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)
101604 108440 5 21 105 Lake St   1 1 1 1     3x3   5995179.45913 2114890.0759 37.786807513731105 -122.46047306430201 (37.7868075137311, -122.460473064302)
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)
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)
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)
102645 110587 5 225 151 EDGEWOOD AVE 1 7 1 1           5996558.0 2106132.0 37.7628393335165 -122.45507056334999 (37.7628393335165, -122.45507056335)
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)
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)
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)
103907 106639 5 64 1321X CLAYTON ST 1 13 2 1           5998910.0 2105100.0 37.7601403710114 -122.44686158716699 (37.7601403710114, -122.446861587167)
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)
104521 115129 5 68 499X MAIN ST 7 1 1 1     6     6015842.0 2114626.0 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338)
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)
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)
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)
106936 105441 5 103 425 WAWONA ST   19 1 1           5991587.6 2097036.5 37.737579050883106 -122.471598439568 (37.7375790508831, -122.471598439568)
109183 105072 5 2 88X PROSPECT AVE 1 1 1 1     12 5x6   6007074.0 2099135.0 37.7442248567037 -122.41820321383699 (37.7442248567037, -122.418203213837)
109920 114977 5 26 183 Lee Ave 1 1 1 1   12/28/2015 12:00:00 AM     Permit Number 774982 5996484.3 2091092.2 37.7215395068839 -122.454239087603 (37.7215395068839, -122.454239087603)
109961 22155 5 58 1570X FAIRFAX AVE 7 1 1 1     1 3X3   6015579.0 2098247.0 37.74226164995721 -122.388732527256 (37.7422616499572, -122.388732527256)
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)
110181 104309 5 1 3747 23RD ST 2 1 1 1       5x5   6004798.0 2102451.0 37.7532014528284 -122.426309178314 (37.7532014528284, -122.426309178314)
110838 107348 5 64 260 LANSDALE AVE 1 13 2 1           5995019.0 2096651.7 37.7367204092857 -122.459706678853 (37.7367204092857, -122.459706678853)
110956 118356 5 47 100 RACCOON DR 2 16 1 1     48     5998776.0 2103987.0 37.7570766935068 -122.44724492231701 (37.7570766935068, -122.447244922317)
111683 114761 5 3 2155 10TH AVE 1 13 1 1       10x10   5993160.0 2101036.0 37.7486515109126 -122.466452556212 (37.7486515109126, -122.466452556212)
113265 80510 5 204 1740 Bancroft Ave 5 1 1 1   08/20/2007 12:00:00 AM 9   Permit Number 49651 6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
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)
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)
113673 121247 5 2 500 Pine St 3 1 1 1       3x3   6011462.5792 2116351.5538 37.791743655166 -122.40423986853001 (37.791743655166, -122.40423986853)
114609 80518 5 291 1769X Armstrong Ave 4 1 1 1   09/07/2002 12:00:00 AM 5     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
114700 80515 5 291 1769X Armstrong Ave 8 1 1 1   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
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)
116115 104650 5 60 346 LAKE ST   1 1 1     28 10x8   5994385.6 2114927.2 37.7868637456835 -122.46322230514099 (37.7868637456835, -122.463222305141)
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)
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)
118354 104317 5 9 13011305 SANCHEZ ST 2 5 1 1     12 3x3   6003956.0 2100665.0 37.748249883960796 -122.429093651106 (37.7482498839608, -122.429093651106)
118440 80512 5 204 1740 Bancroft Ave 3 1 1 1   09/07/2002 12:00:00 AM 9     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
118626 114647 5 49 331 Prentiss St 1 1 1 1   11/30/2015 12:00:00 AM     Permit Number 774946 6008851.6 2097283.6 37.7392412152063 -122.41192582952 (37.7392412152063, -122.41192582952)
119359 108314 5 60 2501X DIAMOND ST 4 1 1 1       3x3   6002141.0 2097265.0 37.7388113707969 -122.435126715418 (37.7388113707969, -122.435126715418)
119627 80516 5 291 1769X Armstrong Ave 7 1 1 1   09/07/2002 12:00:00 AM 4     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999)
119638 109607 5 98 775 Congo St 1 7 2 1           6000381.8 2095947.7 37.7350943222142 -122.44111470541901 (37.7350943222142, -122.441114705419)
119892 22381 5 204 1780 Bancroft Ave 4 1 1 1     10 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041)
120169 104564 5 64 18 FLOOD AVE 1 7 2 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
120714 104436 5 60 2 SAN FERNANDO WAY 1 7 1 1     13     5992040.0 2096369.0 37.7357724272627 -122.469985704629 (37.7357724272627, -122.469985704629)
120946 122898 5 13 198X San Jose Ave 1 1 1 1     6 3x3   6006160.0 2102149.0 37.752449123979794 -122.421577653162 (37.7524491239798, -122.421577653162)
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)
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)
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)
122672 102060 5 47 115 Kensington Way 1 13 1 1           5994908.3 2098325.8 37.741310707397396 -122.460210667073 (37.7413107073974, -122.460210667073)
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)
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)
123904 106641 5 64 1323X CLAYTON ST 1 13 2 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
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)
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)
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)
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)
127060 22386 5 291 1769X Armstrong Ave 6 1 1 1     3 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041)
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)
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)
Powered by Datasette · Query took 2.321ms · Data source: data.sfgov.org