sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
240 251249 5 64 161 Lundys Ln 1 7 2 1       3x3   6006716.0 2098685.0 37.7429691002686 -122.41940918518 (37.7429691002686, -122.41940918518)
294 251266 5 12 10x Paloma Ave 1 1 1 1                    
682 251365 5 47 138x Gladeview Way 2 9 1 1                    
712 251366 5 47 138x Gladeview Way 3 9 1 1                    
713 251364 5 47 138x Gladeview Way 1 9 1 1                    
966 251417 5 103 418 19th Ave 1 1 1 6       3x3   5990003.0 2112517.0 37.779992561868504 -122.478208632121 (37.7799925618685, -122.478208632121)
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)
3419 252969 5 82 101 Whipple Ave 1 1 1 1           5998180.94106 2087280.50358 37.711170613109104 -122.448099970249 (37.7111706131091, -122.448099970249)
3835 253567 5 218 25 Raycliff Ter 1 13 1 1           6000333.0 2116919.0 37.792673532262505 -122.44278881704399 (37.7926735322625, -122.442788817044)
5091 253769 5 47 100 Raccoon Dr 2 13 1 1           5998692.0 2104165.0 37.7575606372552 -122.44754823773899 (37.7575606372552, -122.447548237739)
8592 121500 5 3 251X Pennsylvania Ave 1 13 1 2                    
10202 173900 5 55 601x Hearst Ave 1 1 1 1                    
13268 187627 5 47 88 States St 1 13 1 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
18151 124716 5 5 2195 Palou Ave 1 1 1 1                    
19281 114961 5 207 220 Evelyn Way 1 1 1 1   12/28/2015 12:00:00 AM     Permit Number 776128 5997838.7 2098850.9 37.7429206264442 -122.45011626136801 (37.7429206264442, -122.450116261368)
76816 104448 5 18 2490X Folsom St 3 1 1 3       3x3   6008214.39649 2104163.7525299997 37.7580968032353 -122.41461574816002 (37.7580968032353, -122.41461574816)
79103 120636 5 64 385 Nevada St 1 5 2 1       3x3   6008960.0 2096519.0 37.7371478708762 -122.411497024701 (37.7371478708762, -122.411497024701)
79432 106576 5 64 507 STEINER ST 1 7 2 1           6003113.3 2110111.6 37.7741402349502 -122.432682383122 (37.7741402349502, -122.432682383122)
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)
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)
85608 105439 5 17 790 LAKEVIEW AVE 1 7 1 1           5994224.8 2089960.8 37.718303123348605 -122.461967505828 (37.7183031233486, -122.461967505828)
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)
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)
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)
94513 121248 5 2 500 Pine St 4 1 1 1       3x3   6011462.5792 2116351.5538 37.791743655166 -122.40423986853001 (37.791743655166, -122.40423986853)
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)
97877 121418 5 226 521 Lakeview Ave 1 5 2 1       3x3   5996348.0 2089857.0 37.718140121256106 -122.45462104638399 (37.7181401212561, -122.454621046384)
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)
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)
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)
102645 110587 5 225 151 EDGEWOOD AVE 1 7 1 1           5996558.0 2106132.0 37.7628393335165 -122.45507056334999 (37.7628393335165, -122.45507056335)
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)
106936 105441 5 103 425 WAWONA ST   19 1 1           5991587.6 2097036.5 37.737579050883106 -122.471598439568 (37.7375790508831, -122.471598439568)
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)
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)
111683 114761 5 3 2155 10TH AVE 1 13 1 1       10x10   5993160.0 2101036.0 37.7486515109126 -122.466452556212 (37.7486515109126, -122.466452556212)
113673 121247 5 2 500 Pine St 3 1 1 1       3x3   6011462.5792 2116351.5538 37.791743655166 -122.40423986853001 (37.791743655166, -122.40423986853)
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)
119638 109607 5 98 775 Congo St 1 7 2 1           6000381.8 2095947.7 37.7350943222142 -122.44111470541901 (37.7350943222142, -122.441114705419)
120169 104564 5 64 18 FLOOD AVE 1 7 2 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
122672 102060 5 47 115 Kensington Way 1 13 1 1           5994908.3 2098325.8 37.741310707397396 -122.460210667073 (37.7413107073974, -122.460210667073)
123904 106641 5 64 1323X CLAYTON ST 1 13 2 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
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)
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)
138621 104565 5 64 18 FLOOD AVE 1 7 2 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
140147 121245 5 2 500 Pine St 1 1 1 1       3x3   6011462.5792 2116351.5538 37.791743655166 -122.40423986853001 (37.791743655166, -122.40423986853)
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)
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)
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)
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)
145175 108885 5 118 707 NOE ST 5 13 1 1       3x3   6003152.4 2104071.5 37.757557804850705 -122.43211570496099 (37.7575578048507, -122.432115704961)
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)
4983 83050 5 232 100X Cargo Way 2 1 1 9   02/04/2006 12:00:00 AM 1     6018877.26977 2097567.07885 37.7405769700435 -122.377280830842 (37.7405769700435, -122.377280830842)
23209 83033 5 41 100X Cargo Way 3 1 1 9   02/04/2006 12:00:00 AM 1     6018894.74802 2097554.01331 37.7405420574702 -122.377219490814 (37.7405420574702, -122.377219490814)
43784 83046 5 80 100X Cargo Way 6 1 1 9   02/04/2006 12:00:00 AM 1     6018811.25128 2097616.11187 37.740707968002 -122.37751250161399 (37.740707968002, -122.377512501614)
78203 26198 5 11 3830 03rd St 3 1 1 1     1 3x4   6015747.5106037995 2098323.3315623 37.742480578689 -122.388155190044 (37.742480578689, -122.388155190044)
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)
16217 22383 5 147 1799X Armstrong Ave 2 1 1 1   05/13/1997 12:00:00 AM 2 4x15   6013476.602999999 2093118.78047 37.7280638732384 -122.39564279807301 (37.7280638732384, -122.395642798073)
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)
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)
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)
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)
1079 3621 5 78 100X Cargo Way 57 1 1 9   05/01/2017 03:22:00 PM 3 3X3   6017849.66978 2098333.64293 37.7426251400454 -122.380887189608 (37.7426251400454, -122.380887189608)
1081 3617 5 2 100X Cargo Way 53 1 1 9   05/01/2017 03:16:00 PM 3 3X3   6017937.25359 2098269.56212 37.742454020638796 -122.380579893948 (37.7424540206388, -122.380579893948)
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)
2640 183247 5 2 2890 Rivera St 6 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984262.8939 2100232.1038 37.7459268239815 -122.49715885534201 (37.7459268239815, -122.497158855342)
2648 183237 5 2 2001 37th Ave 13 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984780.1717 2100543.2827 37.7468115375468 -122.495393151852 (37.7468115375468, -122.495393151852)
2656 183240 5 2 2001 37th Ave 16 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984790.3243 2100348.3517 37.7462769046122 -122.495343672098 (37.7462769046122, -122.495343672098)
2668 183245 5 2 2706 Rivera St 4 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984600.1313 2100244.4562 37.745980498085295 -122.495993663284 (37.7459804980853, -122.495993663284)
2672 183250 5 2 2107 39th Ave 1 1 1 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 780393 5984200.2859 2100804.8827 37.7474958486327 -122.497417620086 (37.7474958486327, -122.497417620086)
4012 252965 5 82 115X Whipple Ave 1 1 1 1   10/05/2017 02:04:00 PM 3              
4061 252970 5 82 101X Whipple Ave 2 2 1 1   10/05/2017 12:21:00 PM 3              
4066 252966 5 82 111 Whipple Ave 1 1 1 1   10/05/2017 12:19:00 PM 3     5998135.7809 2087327.97675 37.7112983819328 -122.448259470506 (37.7112983819328, -122.448259470506)
4074 252967 5 82 109 Whipple Ave 1 1 1 1   10/05/2017 01:55:00 PM 3     5998144.81293 2087318.48212 37.7112728281964 -122.448227570418 (37.7112728281964, -122.448227570418)
4630 25362 5 11 974 Geneva Ave 1 1 1 1   10/18/2017 12:00:00 AM 3 3X3 Permit Number 780532 6000558.35356 2088917.09573 37.7157999479938 -122.440000340863 (37.7157999479938, -122.440000340863)
4945 3600 5 78 100X Cargo Way 36 1 1 9   05/01/2017 03:14:00 PM 3 3X3   6018222.967130001 2098056.59418 37.7418850159701 -122.379577179554 (37.7418850159701, -122.379577179554)
4949 83043 5 41 100X Cargo Way 9 1 1 9   03/18/2017 02:49:00 PM 3     6018760.2720099995 2097656.0724299997 37.7408148829885 -122.377691543139 (37.7408148829885, -122.377691543139)
4950 3646 5 78 100X Cargo Way 82 1 1 9   04/10/2017 10:16:00 AM 3 3X3   6017441.11571 2098662.50366 37.7435055673357 -122.38232273959999 (37.7435055673357, -122.3823227396)
4973 3631 5 78 100X Cargo Way 67 1 1 9   05/01/2017 03:27:00 PM 3 3X3   6017682.09522 2098458.88711 37.7429597849556 -122.381475327351 (37.7429597849556, -122.381475327351)
4980 83034 5 78 100X Cargo Way 18 1 1 9   03/18/2017 02:59:00 PM 3     6018525.50747 2097831.43609 37.7412834585567 -122.37851545254298 (37.7412834585567, -122.378515452543)
4985 83041 5 11 100X Cargo Way 11 1 1 9   04/10/2017 09:47:00 AM 3     6018722.37051 2097684.4746 37.74089078129229 -122.377824564564 (37.7408907812923, -122.377824564564)
4989 83048 5 11 100X Cargo Way 4 1 1 9   04/10/2017 09:41:00 AM 3     6018843.8838 2097592.61577 37.7406452501696 -122.37739803950001 (37.7406452501696, -122.3773980395)
4994 3624 5 78 100X Cargo Way 60 1 1 9   05/01/2017 03:25:00 PM 3 3X3   6017797.96297 2098371.7943700003 37.742727042232396 -122.38106863050601 (37.7427270422324, -122.381068630506)
4998 83042 5 77 100X Cargo Way 10 1 1 9   03/18/2017 02:54:00 PM 3     6018742.83505 2097668.8048 37.740848882771 -122.37775271773 (37.740848882771, -122.37775271773)
5000 83036 5 97 100X Cargo Way 16 1 1 9   03/18/2017 02:55:00 PM 3     6018559.56213 2097806.04485 37.7412156164156 -122.378395939846 (37.7412156164156, -122.378395939846)
5014 3588 5 11 100X Cargo Way 24 1 1 9   04/10/2017 10:07:00 AM 3 3X3   6018423.14615 2097904.9005 37.7414795341434 -122.37887448618 (37.7414795341434, -122.37887448618)
Powered by Datasette · Query took 3.271ms · Data source: data.sfgov.org